BILLING PLAN Table
View exposing billing plan detail including billing amounts, status, block indicators, billing and performance dates, currency, and billing-completion flags used for financial billing reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BILLED_BY_SYSTEM |
Billed by system as provided by the source. |
VARCHAR2 |
1 |
BILLED_HISTORICAL |
Billed historical as provided by the source. |
VARCHAR2 |
1 |
BILLED_MANUALLY |
Billed manually as provided by the source. |
VARCHAR2 |
1 |
BILLING_AMOUNT |
Billing amount as provided by the source. |
NUMBER |
15,2 |
BILLING_BLOCK |
Billing block as provided by the source. |
VARCHAR2 |
20 |
BILLING_BLOCK_CODE |
Code identifying billing block. |
VARCHAR2 |
2 |
BILLING_DATE |
Date associated with billing. |
DATE |
|
BILLING_END_DATE_RULE |
Billing end date rule as provided by the source. |
VARCHAR2 |
2 |
BILLING_PLAN_ITEM_NUMBER |
Billing plan item number as provided by the source. |
NUMBER |
6 |
BILLING_PLAN_KEY |
Surrogate key identifying the billing plan. |
VARCHAR2 |
10 |
BILLING_PLAN_NUMBER |
Billing plan number as provided by the source. |
VARCHAR2 |
10 |
BILLING_START_DATE_RULE |
Billing start date rule as provided by the source. |
VARCHAR2 |
2 |
BILLING_STATUS |
Billing status as provided by the source. |
VARCHAR2 |
30 |
BILLING_STATUS_CODE |
Code identifying billing status. |
VARCHAR2 |
1 |
CURRENCY_KEY |
Surrogate key identifying the currency. |
VARCHAR2 |
5 |
DATE_DESCRIPTION |
Description of date. |
VARCHAR2 |
4 |
INVOICE_FROM_DATE |
Date associated with invoice from. |
DATE |
|
INVOICE_THRU_DATE |
Date associated with invoice thru. |
DATE |
|
IS_BILLING_DONE |
Indicator identifying whether billing done (Y/N). |
VARCHAR2 |
1 |
IS_CANCELLED |
Indicator identifying whether cancelled (Y/N). |
VARCHAR2 |
1 |
IS_TO_BE_BILLED |
Indicator identifying whether to be billed (Y/N). |
VARCHAR2 |
1 |
PERFORMANCE_END_DATE |
Date associated with performance end. |
DATE |
|
PERFORMANCE_START_DATE |
Date associated with performance start. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |