Groups
SESSION_DETAIL_LINE
| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | Primary key | |
| 2 | SESSION_ID | VARCHAR2 | 100 | N | ||
| 3 | REQUEST_TYPE | VARCHAR2 | 4 | N | ||
| 4 | BILLING_RECORD_ID | NUMBER | 22 | N | ||
| 5 | ACCOUNT_ID | NUMBER | 22 | N | ||
| 6 | SERVICE_ID | NUMBER | 22 | N | ||
| 7 | CHARGE_ITEM_ID | NUMBER | 22 | N | ||
| 8 | SUM_QUANTITY | NUMBER | 22 | N | ||
| 9 | SUM_TIME | NUMBER | 22 | N | ||
| 10 | TOTAL_EXCL_VAT | NUMBER | 22 | N | ||
| 11 | TOTAL_VAT | NUMBER | 22 | N | ||
| 12 | DESCRIPTION | VARCHAR2 | 400 | Y | ||
| 13 | CHARGE_DATE | DATE | 7 | Y | ||
| 14 | LEVEL1 | VARCHAR2 | 400 | Y | ||
| 15 | LEVEL2 | VARCHAR2 | 400 | Y | ||
| 16 | LEVEL3 | VARCHAR2 | 400 | Y | ||
| 17 | LEVEL4 | VARCHAR2 | 400 | Y | ||
| 18 | LEVEL5 | VARCHAR2 | 400 | Y | ||
| 19 | SUBSCRIPTION_ID | NUMBER | 22 | Y | ||
| 20 | BILLING_GROUP_ID | NUMBER | 22 | Y | ||
| 21 | CALLER | VARCHAR2 | 80 | Y | ||
| 22 | VAT_METHOD_NAME | VARCHAR2 | 320 | Y | ||
| 23 | CURRENCY_CODE | VARCHAR2 | 12 | Y | ||
| 24 | CHARGED_UNITS | NUMBER | 22 | Y | ||
| 25 | CHARGED_UNIT_TYPE | VARCHAR2 | 60 | Y | ||
| 26 | INVOICE_LINE_ID | NUMBER | 22 | Y | ||
| 27 | FINANCE_CODE_BILL_GROUP | NUMBER | 22 | Y | ||
| 28 | FINANCE_CODE_PRODUCT | NUMBER | 22 | Y | ||
| 29 | FINANCE_CODE_PRICEPLAN | NUMBER | 22 | Y | ||
| 30 | FINANCE_CODE_ACCOUNT | NUMBER | 22 | Y | ||
| 31 | FINANCE_CODE_NUMBERPLAN | NUMBER | 22 | Y | ||
| 32 | FINANCE_CODE_PLAN_ELEMENT | NUMBER | 22 | Y | ||
| 33 | FINANCE_CODE_CHARGE_ITEM | NUMBER | 22 | Y | ||
| 34 | FINANCE_CODE_DAY_CHARGE | NUMBER | 22 | Y | ||
| 35 | FINANCE_CODE_TIME_CHARGE | NUMBER | 22 | Y | ||
| 36 | FINANCE_CODE_BILLING_RECORD | NUMBER | 22 | Y |