VRM_BILLING_LINE_DETAILS
This table contains the billing information for performance obligation lines.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
VRM_BILLING_LINE_DETAILS_PK |
BILLING_LINE_DETAIL_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BILLING_LINE_DETAIL_ID | NUMBER | 18 | Yes | Billing line detail internal identifier. | |
| DOCUMENT_LINE_ID | NUMBER | 18 | Source document line unique identifier. | ||
| BILL_DATE | DATE | Yes | Transaction date of the billing document in the billing system. | ||
| BILL_ACCOUNTING_DATE | DATE | Yes | Accounting date on which billed amount is posted in contract revenue clearing account in billing system. | ||
| BILL_QUANTITY | NUMBER | Quantity of the transaction line in billing system. | |||
| BILL_AMOUNT | NUMBER | Yes | Line amount of the transaction line in the billing system. | ||
| BILL_ACCTD_AMOUNT | NUMBER | Line amount of the transaction line in ledger currency. Tax amount is excluded. | |||
| BILL_ID | NUMBER | 18 | Yes | Transaction internal identifier in billing system. | |
| BILL_NUMBER | VARCHAR2 | 60 | Yes | Transaction number in billing system. | |
| BILL_LINE_ID | NUMBER | 18 | Yes | Transaction line internal identifier in billing system. | |
| BILL_LINE_NUMBER | VARCHAR2 | 30 | Yes | Transaction line number in billing system. | |
| BILL_SUB_LINE_ID | NUMBER | 18 | Yes | Transaction subline internal identifier in billing system. | |
| SOURCE_DOCUMENT_NUMBER | VARCHAR2 | 30 | Document number of the source transaction. | ||
| SOURCE_DOCUMENT_DATE | DATE | Document date of the source document. | |||
| SOURCE_DOCUMENT_LINE_NUMBER | VARCHAR2 | 30 | Sequence number of a source document line. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| SOURCE_SYSTEM | VARCHAR2 | 120 | The source system sending the billing line data. | ||
| DOCUMENT_TYPE_ID | NUMBER | 18 | Source document type internal identifier. | ||
| DOC_LINE_ID_INT_1 | NUMBER | Source document line unique identifier attribute in the source system. | |||
| DOC_LINE_ID_INT_2 | NUMBER | Source document line unique identifier attribute in the source system. | |||
| DOC_LINE_ID_INT_3 | NUMBER | Source document line unique identifier attribute in the source system. | |||
| DOC_LINE_ID_INT_4 | NUMBER | Source document line unique identifier attribute in the source system. | |||
| DOC_LINE_ID_INT_5 | NUMBER | Source document line unique identifier attribute in the source system. | |||
| DOC_LINE_ID_CHAR_1 | VARCHAR2 | 30 | Source document line unique identifier attribute in the source system. | ||
| DOC_LINE_ID_CHAR_2 | VARCHAR2 | 30 | Source document line unique identifier attribute in the source system. | ||
| DOC_LINE_ID_CHAR_3 | VARCHAR2 | 30 | Source document line unique identifier attribute in the source system. | ||
| DOC_LINE_ID_CHAR_4 | VARCHAR2 | 30 | Source document line unique identifier attribute in the source system. | ||
| DOC_LINE_ID_CHAR_5 | VARCHAR2 | 30 | Source document line unique identifier attribute in the source system. | ||
| EXCHANGE_RATE | NUMBER | Conversion rate used for converting the billed amount from the entered currency to the ledger currency. | |||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Conversion rate type used for converting the billed amount from the entered currency to the ledger currency. | ||
| EXCHANGE_RATE_DATE | DATE | Conversion rate date used for converting the billed amount from the entered currency to the ledger currency. | |||
| LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row. | ||
| BILLING_APPLICATION | VARCHAR2 | 960 | Yes | Source system that generated the bill. | |
| BILLING_DATA_PROCESSED_STATUS | VARCHAR2 | 30 | Processing status for billing data line. | ||
| DOCUMENT_TYPE_CODE | VARCHAR2 | 30 | Code of the source document type. | ||
| RECURRING_FLAG | VARCHAR2 | 1 | Indicates whether the line will recur on the line's satisfaction plan end date. Valid values are from the lookup type VRM_YES/NO. | ||
| UNAPPLIED_BILL_ENTERED_AMT | NUMBER | Bill line amount remaining to be applied in entered currency. | |||
| UNAPPLIED_BILL_ACCTD_AMT | NUMBER | Bill line amount remaining to be applied in ledger currency. | |||
| BILL_AMOUNT_CURRENCY_CODE | VARCHAR2 | 15 | This column is reserved for future use. | ||
| BILL_TO_SDL_EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | This column is reserved for future use. | ||
| BILL_TO_SDL_EXCHANGE_RATE_DATE | DATE | This column is reserved for future use. | |||
| BILL_TO_SDL_EXCHANGE_RATE | NUMBER | This column is reserved for future use. | |||
| BILL_ENTERED_AMOUNT | NUMBER | This column is reserved for future use. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| VRM_BILLING_LINE_DETAILS | vrm_pricing_lines | DOCUMENT_LINE_ID |
| VRM_BILLING_LINE_DETAILS | gl_daily_conversion_types | EXCHANGE_RATE_TYPE |
| vrm_pol_billing_events | vrm_billing_line_details | BILLING_LINE_DETAIL_ID |
| vrm_billing_line_applications | vrm_billing_line_details | BILLING_LINE_DETAIL_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| VRM_BILLING_LINE_DETAILS_N1 | Non Unique | Default | BILL_LINE_ID, NVL("DOC_LINE_ID_INT_1",(-1)), NVL("DOC_LINE_ID_INT_2",(-1)), NVL("DOC_LINE_ID_INT_3",(-1)), NVL("DOC_LINE_ID_INT_4",(-1)), NVL("DOC_LINE_ID_INT_5",(-1)), NVL("DOC_LINE_ID_CHAR_1",'X'), NVL("DOC_LINE_ID_CHAR_2",'X'), NVL("DOC_LINE_ID_CHAR_3",'X'), NVL("DOC_LINE_ID_CHAR_4",'X'), NVL("DOC_LINE_ID_CHAR_5",'X'), DOCUMENT_TYPE_ID, SOURCE_SYSTEM |
| VRM_BILLING_LINE_DETAILS_N2 | Non Unique | Default | DOCUMENT_LINE_ID |
| VRM_BILLING_LINE_DETAILS_N3 | Non Unique | Default | BILLING_DATA_PROCESSED_STATUS |
| VRM_BILLING_LINE_DETAILS_U1 | Unique | Default | BILLING_LINE_DETAIL_ID |