VRM_BILLING_LINE_DETAILS_GT
Oracle internal use only. This global temporary table is used in import billing data job during internal processing.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
BILLING_LINE_DETAIL_ID | NUMBER | 18 | Yes | Billing line detail internal identifier. | |
BILL_DATE | DATE | Transaction date of the billing document in the billing system. | |||
BILL_ACCOUNTING_DATE | DATE | Accounting date on which billed amount is posted in contract revenue clearing account in billing system. | |||
BILL_ID | NUMBER | 18 | Transaction internal identifier in billing system. | ||
BILL_NUMBER | VARCHAR2 | 60 | Transaction number in billing system. | ||
BILL_LINE_ID | NUMBER | 18 | Transaction line internal identifier in billing system. | ||
BILL_SUB_LINE_ID | NUMBER | 18 | Transaction subline internal identifier in billing system. | ||
BILL_LINE_NUMBER | VARCHAR2 | 30 | Transaction line number in billing system. | ||
BILL_QUANTITY | NUMBER | Quantity of the transaction line in billing system. | |||
BILL_AMOUNT | NUMBER | 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. | |||
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. | ||
DOCUMENT_TYPE_ID | NUMBER | 18 | Source document type internal identifier. | ||
DOCUMENT_TYPE_CODE | VARCHAR2 | 30 | Code of the source document type. | ||
BILLING_APPLICATION | VARCHAR2 | 960 | Source system that generated the bill. | ||
SOURCE_SYSTEM | VARCHAR2 | 120 | The source system sending the billing line data. | ||
DOCUMENT_LINE_ID | NUMBER | 18 | Source document line unique identifier. | ||
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. | ||
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. | |||
BILLING_DATA_PROCESSED_STATUS | VARCHAR2 | 30 | Processing status for billing data line. | ||
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. |