CJM_DOCUMENT_LINES_STG
This table is used as a staging table to store validated document line data from CJM_DOCUMENT_LINES_INT before it's transferred to CJM_DOCUMENT_LINES_ALL. This table is used as a temporary holding area during the data validation process.
Details
-
Schema: FUSION
-
Object owner: CJM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CJM_DOCUMENT_LINES_STG_PK |
DOCUMENT_LINES_STG_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| DOCUMENT_LINES_STG_ID | NUMBER | 18 | Yes | Unique identifier of the document lines stage record. | ||
| DOCUMENT_BATCH_ID | NUMBER | 18 | Indicates the identifier of the document batch. | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| STATUS_CODE | VARCHAR2 | 30 | Indicates the status code of the line. Values are from the lookup ORA_CJM_BATCH_LINE_STATUS. | |||
| BATCH_ID | NUMBER | 18 | Import batch identifier which was populated by Import Framework during data upload. | |||
| INTERFACE_ROW_ID | NUMBER | 18 | Unique identifier for the record within a batch. The combination of BATCH_ID and INTERFACE_ROW_ID is a unique alternate key for the record. | |||
| BATCH_NUMBER | VARCHAR2 | 18 | Unique alternate key for the batch. Import Framework populates this value. | |||
| BATCH_NAME | VARCHAR2 | 266 | Indicates the batch name. Import Framework populates this value. | |||
| BATCH_TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | Indicates the batch transaction type code. | |||
| BATCH_START_DATE | DATE | Indicates the start date of the batch. | Obsolete | |||
| BATCH_END_DATE | DATE | Indicates the end date of the batch. | Obsolete | |||
| BU_ID | NUMBER | 18 | Identifier of the business unit associated with the row. | |||
| BU_NAME | VARCHAR2 | 240 | Name of business unit associated with the row. | |||
| CURRENCY_CODE | VARCHAR2 | 15 | Indicates the currency code of the channel batch transaction object. | |||
| DISTRI_BILL_TO_CUST_ACCT_ID | NUMBER | 18 | Indicates the unique identifier of the distributor bill-to customer account. | |||
| DISTRIBUTOR_NAME | VARCHAR2 | 360 | Indicates the name of the distributor. | |||
| DISTRI_BILL_TO_ACCT_NUMBER | VARCHAR2 | 30 | Indicates the bill-to customer account number of the distributor. | |||
| DISTRIBUTOR_REGISTRY_ID | VARCHAR2 | 30 | Indicates the unique identification number of the distributor. | |||
| DISTRIBUTOR_CLAIM_NUMBER | VARCHAR2 | 30 | Indicates the claim number recorded in the distributor's system. | |||
| HEADER_COMMENTS | VARCHAR2 | 4000 | Free-form text that can be used to capture any high-level information about the document. | |||
| AGREEMENT_NUMBER | VARCHAR2 | 30 | The unique number that identifies the special price agreement. | |||
| AGREEMENT_NAME | VARCHAR2 | 240 | The name of the special price agreement. | |||
| AGREEMENT_ID | NUMBER | 18 | Unique identifier of the agreement number. | |||
| AGREEMENT_TYPE_CODE | VARCHAR2 | 30 | Indicates the agreement type. Values are from the lookup code . | |||
| ITEM_ID | NUMBER | Unique identifier of the inventory item. | ||||
| ITEM_NUMBER | VARCHAR2 | 300 | Number associated with the inventory item. | |||
| ITEM_DESCRIPTION | VARCHAR2 | 240 | Indicates the description of the item. | |||
| LINE_COMMENTS | VARCHAR2 | 4000 | Free-form text that can be used to capture any high-level information about the document lines. | |||
| ORIG_SYSTEM_SOURCE | VARCHAR2 | 240 | Source information of the originating system. | |||
| ORIG_SYSTEM_REFERENCE | VARCHAR2 | 240 | Reference of the originating system. | |||
| ORIG_SYSTEM_LINE_REFERENCE | VARCHAR2 | 240 | Line reference of the originating system. | |||
| BILL_TO_ACCOUNT_NUMBER | VARCHAR2 | 30 | The account number of the bill-to customer. | Obsolete | ||
| BILL_TO_ACCOUNT_ID | NUMBER | The unique identifier for the bill-to account. | Obsolete | |||
| BILL_TO_CUSTOMER_REGISTRY_ID | VARCHAR2 | 30 | Unique identification number of the bill-to party. | |||
| BILL_TO_CUSTOMER_NAME | VARCHAR2 | 360 | Indicates the name of the bill-to customer . | |||
| BILL_TO_CUSTOMER_ID | NUMBER | 18 | Unique identifier of the bill to customer identifier. It is the PARTY_ID from HZ_PARTIES. | |||
| WAYBILL_NUMBER | VARCHAR2 | 30 | Indicates the non-negotiable document number that describes the contract for transporting cargo. | |||
| REQUESTED_SHIP_DATE | DATE | Indicates the date on which the customer has requested the ordered item to be shipped. | ||||
| SALES_ORDER_NUMBER | VARCHAR2 | 50 | The identifier for the sales order. | |||
| SALES_ORDER_DATE | DATE | Date when the items where ordered. | ||||
| SALES_ORDER_LINE_NUMBER | NUMBER | The unique identifier of the sales order line. | ||||
| SHIPPED_DATE | DATE | The date the shipment was actually sent. | ||||
| SHIPPED_QUANTITY | NUMBER | The quantity of goods or services shipped by the supplier. | ||||
| SHIPPED_UOM | VARCHAR2 | 3 | The unit of measure for the shipped quantity. | |||
| CLAIMED_QUANTITY | NUMBER | Indicates the quantity claimed by the distributor for a special pricing agreement. | ||||
| SHIP_TO_CUSTOMER_NAME | VARCHAR2 | 360 | The name of the ship-to customer. | |||
| SHIP_TO_CUSTOMER_ID | NUMBER | The unique identifier of the ship-to customer. | ||||
| SHIP_TO_CUSTOMER_REGISTRY_ID | VARCHAR2 | 30 | Unique identification number of the ship-to party. | |||
| UNIT_PURCHASE_PRICE | NUMBER | The price per unit that a distributor paid for an item. | ||||
| UNIT_SELLING_PRICE | NUMBER | The price per unit that a buyer paid for an item. | ||||
| UNIT_CLAIMED_AMOUNT | NUMBER | The amount per unit that is claimed by the distributor. | ||||
| UNIT_DISCOUNT_AMOUNT | NUMBER | Indicates the discount amount per unit calculated by the system. | ||||
| CALCULATED_AMOUNT | NUMBER | Indicates the total calculated amount of the line that can be claimed. | ||||
| TOTAL_CALCULATED_AMOUNT | NUMBER | Indicates the total calculated amount of the line which can be claimed. | Obsolete | |||
| ALLOWED_QUANTITY | NUMBER | Indicates the allowed quantity for the batch line. | ||||
| ALLOWED_AMOUNT | NUMBER | Indicates the allowed amount of the line per unit. | Obsolete | |||
| TOTAL_ALLOWED_AMOUNT | NUMBER | Indicates the total allowed amount of the line which can be claimed. | Obsolete | |||
| ACCEPTED_AMOUNT | NUMBER | Indicates the total accepted amount of the line that can be claimed. | ||||
| TOTAL_ACCEPTED_AMOUNT | NUMBER | Indicates the total accepted amount of the line which can be claimed. | Obsolete | |||
| ACCEPTANCE_MODE_CODE | VARCHAR2 | 30 | A code indicating how the amount for the document line in the stage record is accepted. It distinguishes between automatically accepted amounts and manually accepted amounts. In automatically accepted amounts, the distributor's claimed amount matches the calculated amount, whereas, in manually accepted amounts, a user explicitly accepts the calculated amount.s | |||
| DUP_DOCUMENT_LINES_STG_ID | NUMBER | 18 | Unique identifier for the duplicate document lines stage record. It is populated during the duplicate check of the lines within the same batch or across batches. | |||
| PROCESS_ERROR_CODE | VARCHAR2 | 300 | Indicates the error code for the document lines while processing the data in the staging table. This is an internal column used for validation. | |||
| REJECT_REASON_CODE | VARCHAR2 | 30 | Indicates the reason for rejecting the batch line. Values are from the lookup ORA_BATCH_LINE_REJECT_REASON. | |||
| AGRMNT_STATUS_CODE | VARCHAR2 | 30 | Indicates the status code of the agreement associated with the line. | |||
| AGRMNT_ACCRUE_POS_FLAG | VARCHAR2 | 1 | Indicates whether the agreement accrual is based on the receipt of the point of sale data. | |||
| AGRMNT_DIS_BILL_TO_ACCT_ID | NUMBER | 18 | Indicates the identifier of the distributor's bill to customer associated with the agreement. | |||
| AGRMNT_BU_ID | NUMBER | 18 | Indicates the identifier of the business unit for the agreement. | |||
| AGRMNT_CURRENCY_CODE | VARCHAR2 | 15 | Indicates the currency code for the agreement. | |||
| AGRMNT_SPA_REQ_TYPE_CODE | VARCHAR2 | 30 | Indicates the request type code for the agreement. | |||
| AGRMNT_END_CUST_PARTY_ID | NUMBER | 18 | Indicates the identifier of the end customer party associated with the agreement. | |||
| AGRMNT_PRI_DATE_TYPE_CODE | VARCHAR2 | 30 | Indicates the date type code associated with the agreement. | |||
| AGRMNT_PRI_DATE_FROM | DATE | Indicates the from date of the agreement based on the agreement's pricing date type code. | ||||
| AGRMNT_PRI_DATE_TO | DATE | Indicates the to date of the agreement based on the agreement's pricing date type code. | ||||
| AGRMNT_LN_UOM_CODE | VARCHAR2 | 30 | Indicates the unit of measure of the item. | |||
| AGRMNT_LN_PROGRAM_LINE_ID | NUMBER | 18 | Indicates the identifier of the program line associated with the agreement. | |||
| AGRMNT_LN_DIS_TYPE_CODE | VARCHAR2 | 30 | Indicates the discount type code associated with the agreement line. | |||
| AGRMNT_LN_DIS_AMOUNT | NUMBER | Indicates the discount amount for the agreement line. | ||||
| AGRMNT_LN_MAX_ALLOWED_QTY | NUMBER | Indicates the maximum allowed quantity in the agreement line. | ||||
| AGRMNT_LN_UNIT_DIS_AMOUNT | NUMBER | Indicates the discount amount per unit for the item in the agreement. | ||||
| AGRMNT_LN_ALREADY_ACCRUED_QTY | NUMBER | Indicates the quantity already accrued for the item in the agreement. | ||||
| HEADER_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | User-defined descriptive flexfield context sensitive segments configured to capture additional information for the transaction header. | |||
| HEADER_ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | |||
| HEADER_ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | |||
| HEADER_ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | |||
| HEADER_ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | |||
| HEADER_ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | |||
| HEADER_ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | |||
| HEADER_ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | |||
| HEADER_ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | |||
| HEADER_ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | |||
| HEADER_ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | |||
| HEADER_ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | |||
| HEADER_ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | |||
| HEADER_ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | |||
| HEADER_ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | |||
| HEADER_ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | |||
| HEADER_ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | |||
| HEADER_ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | |||
| HEADER_ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | |||
| HEADER_ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | |||
| HEADER_ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | |||
| HEADER_ATTRIBUTE_NUMBER1 | NUMBER | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | ||||
| HEADER_ATTRIBUTE_NUMBER2 | NUMBER | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | ||||
| HEADER_ATTRIBUTE_NUMBER3 | NUMBER | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | ||||
| HEADER_ATTRIBUTE_NUMBER4 | NUMBER | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | ||||
| HEADER_ATTRIBUTE_NUMBER5 | NUMBER | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | ||||
| HEADER_ATTRIBUTE_NUMBER6 | NUMBER | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | ||||
| HEADER_ATTRIBUTE_NUMBER7 | NUMBER | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | ||||
| HEADER_ATTRIBUTE_NUMBER8 | NUMBER | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | ||||
| HEADER_ATTRIBUTE_NUMBER9 | NUMBER | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | ||||
| HEADER_ATTRIBUTE_NUMBER10 | NUMBER | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | ||||
| HEADER_ATTRIBUTE_DATE1 | DATE | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | ||||
| HEADER_ATTRIBUTE_DATE2 | DATE | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | ||||
| HEADER_ATTRIBUTE_DATE3 | DATE | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | ||||
| HEADER_ATTRIBUTE_DATE4 | DATE | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | ||||
| HEADER_ATTRIBUTE_DATE5 | DATE | Segment of the descriptive flexfield used to hold user-defined information on the transaction header. | ||||
| LINE_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | User-defined descriptive flexfield context sensitive segments configured to capture additional information for the transaction line. | |||
| LINE_ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | |||
| LINE_ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | |||
| LINE_ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | |||
| LINE_ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | |||
| LINE_ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | |||
| LINE_ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | |||
| LINE_ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | |||
| LINE_ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | |||
| LINE_ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | |||
| LINE_ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | |||
| LINE_ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | |||
| LINE_ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | |||
| LINE_ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | |||
| LINE_ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | |||
| LINE_ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | |||
| LINE_ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | |||
| LINE_ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | |||
| LINE_ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | |||
| LINE_ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | |||
| LINE_ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | |||
| LINE_ATTRIBUTE_NUMBER1 | NUMBER | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | ||||
| LINE_ATTRIBUTE_NUMBER2 | NUMBER | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | ||||
| LINE_ATTRIBUTE_NUMBER3 | NUMBER | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | ||||
| LINE_ATTRIBUTE_NUMBER4 | NUMBER | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | ||||
| LINE_ATTRIBUTE_NUMBER5 | NUMBER | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | ||||
| LINE_ATTRIBUTE_NUMBER6 | NUMBER | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | ||||
| LINE_ATTRIBUTE_NUMBER7 | NUMBER | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | ||||
| LINE_ATTRIBUTE_NUMBER8 | NUMBER | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | ||||
| LINE_ATTRIBUTE_NUMBER9 | NUMBER | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | ||||
| LINE_ATTRIBUTE_NUMBER10 | NUMBER | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | ||||
| LINE_ATTRIBUTE_DATE1 | DATE | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | ||||
| LINE_ATTRIBUTE_DATE2 | DATE | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | ||||
| LINE_ATTRIBUTE_DATE3 | DATE | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | ||||
| LINE_ATTRIBUTE_DATE4 | DATE | Segment of the descriptive flexfield used to hold user-defined information on the transaction line. | ||||
| LINE_ATTRIBUTE_DATE5 | DATE | Segment of the descriptive flexfield used to hold user-defined information on the transaction 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. | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | |||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CJM_DOCUMENT_LINES_STG_N1 | Non Unique | cjm_document_lines_stg_N1 | DOCUMENT_BATCH_ID, STATUS_CODE, AGREEMENT_ID, ITEM_ID |
| CJM_DOCUMENT_LINES_STG_U1 | Unique | Default | DOCUMENT_LINES_STG_ID |