BILLING PLAN Table
Billing plan data
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BILLED_BY_SYSTEM |
XXX |
VARCHAR2 |
1 |
BILLED_HISTORICAL |
XXX |
VARCHAR2 |
1 |
BILLED_MANUALLY |
XXX |
VARCHAR2 |
1 |
BILLING_AMOUNT |
XXX |
NUMBER |
22 |
BILLING_BLOCK |
XXX |
VARCHAR2 |
20 |
BILLING_BLOCK_CODE |
XXX |
VARCHAR2 |
2 |
BILLING_DATE |
Date telephone charges are billed to a cost collector. |
DATE |
8 |
BILLING_END_DATE_RULE |
XXX |
VARCHAR2 |
2 |
BILLING_PLAN_ITEM_NUMBER |
XXX |
NUMBER |
22 |
BILLING_PLAN_KEY |
Key field used to join to the BILLING_PLAN table. This field should only be used for joining data, NOT for reporting |
VARCHAR2 |
10 |
BILLING_PLAN_NUMBER |
XXX |
VARCHAR2 |
10 |
BILLING_START_DATE_RULE |
XXX |
VARCHAR2 |
2 |
BILLING_STATUS |
XXX |
VARCHAR2 |
30 |
BILLING_STATUS_CODE |
XXX |
VARCHAR2 |
1 |
CURRENCY_KEY |
Key used to join to the LIBRARY_CURRENCY table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
3 |
DATE_DESCRIPTION |
XXX |
VARCHAR2 |
4 |
INVOICE_FROM_DATE |
XXX |
DATE |
8 |
INVOICE_THRU_DATE |
XXX |
DATE |
8 |
IS_BILLING_DONE |
XXX |
VARCHAR2 |
1 |
IS_CANCELLED |
XXX |
VARCHAR2 |
1 |
IS_TO_BE_BILLED |
XXX |
VARCHAR2 |
1 |
PERFORMANCE_END_DATE |
XXX |
DATE |
7 |
PERFORMANCE_START_DATE |
XXX |
DATE |
7 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |