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 |