VRM_AR_OKS_SUB_LINE_GT
This table contains contract lines information during billing data extraction.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| CM_BILL_ACCTD_DATE | DATE | Accounting date of the transaction. | ||
| CM_BILL_DATE | DATE | Transaction date. | ||
| CM_CURRENCY_CODE | VARCHAR2 | 15 | Currency code of the credit memo transaction. | |
| CM_CUSTOMER_TRX_ID | NUMBER | 18 | Transaction identifier. | |
| CM_DOCUMENT_TYPE_ID | NUMBER | 18 | Unique identifier of a source document type. | |
| CM_DOC_LINE_ID_CHAR_1 | VARCHAR2 | 30 | Unique identifier of the credit memo transaction. | |
| CM_DOC_LINE_ID_CHAR_2 | VARCHAR2 | 30 | Unique identifier of the credit memo transaction. | |
| CM_DOC_LINE_ID_CHAR_3 | VARCHAR2 | 30 | Unique identifier of the credit memo transaction. | |
| CM_DOC_LINE_ID_CHAR_4 | VARCHAR2 | 30 | Unique identifier of the credit memo transaction. | |
| CM_DOC_LINE_ID_CHAR_5 | VARCHAR2 | 30 | Unique identifier of the credit memo transaction. | |
| CM_DOC_LINE_ID_INT_1 | NUMBER | Credit memo transaction unique identifier. | ||
| CM_DOC_LINE_ID_INT_2 | NUMBER | Credit memo transaction unique identifier. | ||
| CM_DOC_LINE_ID_INT_3 | NUMBER | Credit memo transaction unique identifier. | ||
| CM_DOC_LINE_ID_INT_4 | NUMBER | Credit memo transaction unique identifier. | ||
| CM_DOC_LINE_ID_INT_5 | NUMBER | Credit memo transaction unique identifier. | ||
| CM_LINE_AMOUNT | NUMBER | Transaction line amount. | ||
| CM_LINE_ID | NUMBER | 18 | Transaction line identifier. | |
| CM_LINE_NUMBER | NUMBER | Transaction line number. | ||
| CM_QUANTITY_CREDITED | NUMBER | Quantity credited to the transaction. | ||
| CM_TRX_NUMBER | VARCHAR2 | 20 | Transaction number. | |
| DOCUMENT_LINE_ID | NUMBER | 18 | Unique identifier of a source document line. | |
| INV_LINE_AMOUNT | NUMBER | Transaction line amount | ||
| INV_LINE_ID | NUMBER | 18 | Transaction line identifier. | |
| OKS_BILLING_ID | NUMBER | 18 | Contract billing line identifier | |
| OKS_BILL_INSTANCE_NUMBER | VARCHAR2 | 30 | Contract billing instance number. | |
| OKS_SUB_LINE_AMOUNT | NUMBER | Contract subline amount. | ||
| OKS_SUB_LINE_ID | NUMBER | 18 | Unique identifier of contract subline. | |
| ALLOCATED_AMOUNT | NUMBER | Amount allocated after proration. | ||
| ALLOCATED_ACCTD_AMOUNT | NUMBER | Amount allocated after proration in ledger currency. | ||
| SOURCE_SYSTEM | VARCHAR2 | 120 | The source system sending the data. |