SESSION_DETAIL_LINE
- Søren Duusgaard (Deactivated)
Groups
SESSION_DETAIL_LINE
| Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|
ID | NUMBER | 22 | N | Primary key | |
SESSION_ID | VARCHAR2 | 100 | N | ||
REQUEST_TYPE | VARCHAR2 | 4 | N | ||
BILLING_RECORD_ID | NUMBER | 22 | N | ||
ACCOUNT_ID | NUMBER | 22 | N | ||
SERVICE_ID | NUMBER | 22 | N | ||
CHARGE_ITEM_ID | NUMBER | 22 | N | ||
SUM_QUANTITY | NUMBER | 22 | N | ||
SUM_TIME | NUMBER | 22 | N | ||
TOTAL_EXCL_VAT | NUMBER | 22 | N | ||
TOTAL_VAT | NUMBER | 22 | N | ||
DESCRIPTION | VARCHAR2 | 400 | Y | ||
CHARGE_DATE | DATE | 7 | Y | ||
LEVEL1 | VARCHAR2 | 400 | Y | ||
LEVEL2 | VARCHAR2 | 400 | Y | ||
LEVEL3 | VARCHAR2 | 400 | Y | ||
LEVEL4 | VARCHAR2 | 400 | Y | ||
LEVEL5 | VARCHAR2 | 400 | Y | ||
SUBSCRIPTION_ID | NUMBER | 22 | Y | ||
BILLING_GROUP_ID | NUMBER | 22 | Y | ||
CALLER | VARCHAR2 | 80 | Y | ||
VAT_METHOD_NAME | VARCHAR2 | 320 | Y | ||
CURRENCY_CODE | VARCHAR2 | 12 | Y | ||
CHARGED_UNITS | NUMBER | 22 | Y | ||
CHARGED_UNIT_TYPE | VARCHAR2 | 60 | Y | ||
INVOICE_LINE_ID | NUMBER | 22 | Y | ||
FINANCE_CODE_BILL_GROUP | NUMBER | 22 | Y | ||
FINANCE_CODE_PRODUCT | NUMBER | 22 | Y | ||
FINANCE_CODE_PRICEPLAN | NUMBER | 22 | Y | ||
FINANCE_CODE_ACCOUNT | NUMBER | 22 | Y | ||
FINANCE_CODE_NUMBERPLAN | NUMBER | 22 | Y | ||
FINANCE_CODE_PLAN_ELEMENT | NUMBER | 22 | Y | ||
FINANCE_CODE_CHARGE_ITEM | NUMBER | 22 | Y | ||
FINANCE_CODE_DAY_CHARGE | NUMBER | 22 | Y | ||
FINANCE_CODE_TIME_CHARGE | NUMBER | 22 | Y | ||
FINANCE_CODE_BILLING_RECORD | NUMBER | 22 | Y |