1. Tables and Views for SCM
  2. CJM_DOCUMENT_LINES_INT

CJM_DOCUMENT_LINES_INT

CJM_DOCUMENT_LINES_INT is an interface table for bulk import of document lines. Data in this table will be purged according to the setup in the import framework.

Details

  • Schema: FUSION

  • Object owner: CJM

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

CJM_DOCUMENT_LINES_INT_PK

BATCH_ID, INTERFACE_ROW_ID

Columns

Name Datatype Length Precision Not-null Comments Status
BATCH_ID NUMBER 18 Yes Batch identifier populated by the import framework for each job execution.
INTERFACE_ROW_ID NUMBER 18 Yes Unique identifier for the record within a batch. Combination of BATCH_ID and INTERFACE_ROW_ID is unique in this interface table.
IMPORT_JOB_NUMBER VARCHAR2 130 Indicates the job number of the import batch.
FILE_RECORD_NUM NUMBER 18 Used by the import wizard to relate a record in the interface table to the file row.
FILE_NAME_SYSTASK_ID NUMBER 18 Recommended optional column for multi-csv uptake, that saves the individual sys task id for each input csv file, corresponding to the value in the MKT_CM_SYSTASK table. This is populated by the import framework.
IMPORT_STATUS_CODE VARCHAR2 1 Indicates the status of a row in the interface table. File import wizard status: I - In Progress, O ? Obsolete (status of all the interface table records that were run previously), E - Error, S - Successful (internal use only).
ERROR_MESSAGE VARCHAR2 3000 Optional column, used if consumers want any error message as the first error.
ACTION_CODE VARCHAR2 30 Specifies the operations for a row. Possible values are NULL, INSERT, UPDATE, and DELETE.
INTERNAL_ACTION_CODE VARCHAR2 30 Oracle internal use only. Populated and used by bulk import logic.
BATCH_TRANSACTION_TYPE_CODE VARCHAR2 30 Indicates the batch transaction type code. 
DATA_SOURCE_CODE VARCHAR2 30 Indicates the code of the data source from which interface line data is received. Obsolete
BU_ID NUMBER 18 Identifier of the business unit associated to with the row.
BU_NAME VARCHAR2 240 Name of business unit associated to with the row.
VENDOR_ID NUMBER 18 Unique identifier for the supplier associated with the document.
VENDOR_NAME VARCHAR2 100 Indicates the name of the supplier.
VENDOR_NUMBER VARCHAR2 30 Unique number to identify the supplier.
VENDOR_SITE_ID NUMBER 18 Unique identifier for the supplier site associated with the document.
VENDOR_SITE_CODE VARCHAR2 240 Indicates the code for the supplier site.
HEADER_COMMENTS VARCHAR2 4000 Free-form text that can be used to capture any high-level information about the document.
ITEM_ID NUMBER 18 Unique identifier of the inventory item.
ITEM_NUMBER VARCHAR2 300 Item number of the inventory item.
ITEM_DESCRIPTION VARCHAR2 240 Indicates the description of the item.
ITEM_REVISION VARCHAR2 18 This column indicates the revision number of the inventory item. Obsolete
VENDOR_ITEM_NUM VARCHAR2 300 This column stores the supplier item number. Obsolete
QUANTITY NUMBER Indicates the item quantity on the line. Obsolete
UOM_CODE VARCHAR2 3 Unit of measure for the item quantity. Obsolete
UNIT_PRICE NUMBER Unit price of the line in document currency. Obsolete
INVENTORY_ORGANIZATION_ID NUMBER 18 Unique identifier for the item validation inventory organization.
INVENTORY_ORG_NAME VARCHAR2 240 Name of the inventory organization.
INVENTORY_ORGANIZATION_CODE VARCHAR2 18 Code of the inventory organization that the product belongs to.
RECEIVING_INVENTORY_ORG_ID NUMBER 18 Unique identifier for the receiving inventory organization.
RECEIVING_INVENTORY_ORG_CODE VARCHAR2 18 Code of the receiving inventory organization.
PRC_BU_ID NUMBER 18 Procurement business unit unique identifier.
PRC_BU_NAME VARCHAR2 240 Procurement business unit name.
PO_NUMBER VARCHAR2 30 Purchase order number associated with the document line.
PO_DATE DATE Indicates the purchase order date.
PO_LINE_NUMBER NUMBER Indicates the purchase order line number of the object.
RECEVING_LOCATION_ID NUMBER 18 Unique identifier for the location in Oracle Fusion Receiving. Obsolete
RECEIVING_LOCATION_ID NUMBER 18 Unique identifier for the location in Oracle Fusion Receiving.
RECEIVING_LOCATION_CODE VARCHAR2 18 Indicates the receiving location code.
RECEIVING_LOCATION_NAME VARCHAR2 240 Indicates the receiving location name.
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.
CURRENCY_CODE VARCHAR2 15 Indicates the currency code of the channel batch transaction object.
PO_LINE_REQ_DELIVERY_DATE DATE Indicates the request delivery date on the purchase order line.
PO_LINE_REQ_SHIP_DATE DATE Indicates the request ship date on the purchase order line.
RECEIVING_TRANSACTION_QTY NUMBER Indicates the item quantity on the receiving transaction.
RECEIVING_TRANSACTION_UOM VARCHAR2 3 Unit of measure for the item quantity on the receiving transaction.
RECEIVING_TRX_UNIT_PRICE NUMBER Unit price of the item on the receiving transaction.
SUPPLIER_INVOICE_LINE_QTY NUMBER Indicates the item quantity on the supplier invoice line.
SUPPLIER_INVOICE_LINE_UOM VARCHAR2 3 Unit of measure for the item quantity on supplier invoice line.
SUPPLIER_INV_LINE_UNIT_PRICE NUMBER Unit price of the supplier invoice line.
PO_BILLTO_LOCATION_ID NUMBER 18 Identifier of the purchase order bill-to location.
PO_BILLTO_LOCATION_CODE VARCHAR2 30 Code of the purchase order bill-to location.
PO_SHIPTO_LOCATION_ID NUMBER 18 Identifier of the purchase order ship-to location.
PO_SHIPTO_LOCATION_CODE VARCHAR2 30 Code of the purchase order ship-to location.
RECEIPT_NUMBER VARCHAR2 50 Indicates the receipt number for the receiving transaction or supplier invoice.
RECEIPT_SHIPMENT_NUMBER VARCHAR2 30 Receipt shipment number assigned by the shipment's source.
RECEIPT_SHIPPED_DATE DATE Date when the receipt shipment was created.
RECEIPT_WAYBILL_NUMBER VARCHAR2 30 Waybill or airbill receipt number.
RECEIPT_BILL_OF_LADING VARCHAR2 25 Bill of lading number from the receipt.
RECEIVING_TRANSACTION_DATE DATE Indicates the date of the receiving transaction.
RECEIVING_TRANSACTION_TYPE VARCHAR2 25 Indicates the original transaction type.
RECEIVING_TRANSACTION_NUM VARCHAR2 30 Indicates the receiving transaction number.
ORIG_RECEIVING_TRX_NUM VARCHAR2 30 Indicates the original receiving transaction number.
RECEIVING_REASON_ID NUMBER 18 Indicates the identifier of receiving reason.
RECEIVING_REASON_NAME VARCHAR2 30 Name of the receiving transaction reason.
RECEIVING_REASON_DESCRIPTION VARCHAR2 240 Description of the receiving transaction reason. Obsolete
SUPPLIER_INVOICE_NUMBER VARCHAR2 50 Indicates the invoice number of the supplier.
SUPPLIER_INVOICE_DATE DATE Indicates the date of the supplier invoice.
SUPPLIER_INVOICE_TYPE_CODE VARCHAR2 30 Indicates the invoice type code of the supplier invoice.
SUPPLIER_INVOICE_LINE_NUM NUMBER 18 Indicates the line number of the supplier invoice.
TP_ITEM_ID NUMBER 18 Unique identifier used for the trading partner item.
TP_ITEM_NUM VARCHAR2 300 Indicates the trading partner item number.
ORIG_SUPPLIER_INVOICE_NUMBER VARCHAR2 50 Indicates the original invoice number of the supplier.
SUPPLIER_INVOICE_LINE_REASON VARCHAR2 240 Indicates the supplier invoice line reason for the invoice correction.
ORIG_SUPPLIER_INV_LINE_NUM NUMBER 18 Indicates the line number of the original supplier invoice.
BILL_TO_ACCOUNT_NUMBER VARCHAR2 30 The account number of the bill-to customer.
BILL_TO_ACCOUNT_ID NUMBER 18 The unique identifier for the bill-to account.
BILL_TO_ACCOUNT_SITE VARCHAR2 240 Code for the customer bill-to site.
BILL_TO_ACCOUNT_SITE_ID NUMBER 18 Unique address identifier of the customer bill-to site.
BILL_TO_CUSTOMER_NAME VARCHAR2 360 The name of the bill-to customer.
BILL_TO_CUSTOMER_ID NUMBER 18 The unique identifier for the bill-to customer.
BILL_TO_CUSTOMER_REGISTRY_ID VARCHAR2 30 Unique identification number of the bill-to party.
BILL_TO_SITE_USE_ID NUMBER 18 Unique identifier for the bill-to site use for the selected customer account site.
ORIG_SALES_ORDER_NUMBER VARCHAR2 50 Sales order number for the original sales order.
ORIG_SALES_ORDER_LINE_NUMBER NUMBER 9 Line number for the original sales order line.
REQUESTED_ARRIVAL_DATE DATE The original arrival date for an item requested by the customer.
REQUESTED_SHIP_DATE DATE The original ship date for an item requested by the customer.
SALES_INVOICE_NUMBER VARCHAR2 50 The invoice number for the customer invoice.
SALES_INVOICE_TYPE_CODE VARCHAR2 20 The invoice type for the invoice.
SALES_INVOICE_DATE DATE The date that appears on a customer invoice.
SALES_INVOICE_LINE_NUMBER NUMBER 18 The unique identifier for the invoice line.
SALES_INVOICE_LINE_TYPE_CODE VARCHAR2 20 Indicates whether the invoice line corresponds to an item, tax, freight, or miscellaneous.
SALES_ORDER_NUMBER VARCHAR2 50 The identifier for the sales order.
SALES_ORDER_TYPE_CODE VARCHAR2 30 The name of the order type placed.
SALES_ORDER_DATE DATE The ordered date on the sales order.
SALES_ORDER_LINE_NUMBER NUMBER 9 The unique identifier for the sales order line.
SALES_ORDER_LINE_TYPE_CODE VARCHAR2 30 Defines how the order line transaction is processed.
SALESPERSON_ID NUMBER 18 The unique identifier for the salesperson.
SALESPERSON_NUMBER VARCHAR2 30 The unique number that is associated with the salesperson.
SALESPERSON_NAME VARCHAR2 360 The person who is engaged in the sale of goods and services.
SHIPPED_DATE DATE The date the shipment was actually sent.
SHIPPED_QUANTITY NUMBER The quantity of goods or services that was shipped by supplier.
SHIPPED_UOM VARCHAR2 3 The unit of measure for the shipped quantity. UOM stands for Unit of Measure.
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 18 The unique identifier for the ship-to customer.
SHIP_TO_CUSTOMER_REGISTRY_ID VARCHAR2 30 Unique identification number of the ship-to party.
SHIP_TO_CUSTOMER_SITE VARCHAR2 240 Code for the customer ship-to site.
SHIP_TO_CUSTOMER_SITE_ID NUMBER 18 The unique address identifier for the ship-to customer.
SHIP_TO_SITE_USE_ID NUMBER 18 Unique identifier for the ship-to site use for the selected customer site.
SOLD_TO_CUSTOMER_NAME VARCHAR2 360 The name of the sold-to customer.
SOLD_TO_CUSTOMER_ID NUMBER 18 The unique identifier for the sold-to customer.
SOLD_TO_CUSTOMER_REGISTRY_ID VARCHAR2 30 Unique identification number of the sold-to party.
SOLD_TO_CUSTOMER_SITE VARCHAR2 240 Code for the customer sold-to site.
SOLD_TO_CUSTOMER_SITE_ID NUMBER 18 The unique address identifier for the sold-to customer.
SOLD_TO_SITE_USE_ID NUMBER 18 Identifier for the sold-to site use.
UNIT_LIST_PRICE NUMBER The base selling price before applying discounts.
UNIT_SELLING_PRICE NUMBER The price per unit that a buyer paid for an item.
CATEGORY_ID NUMBER 18 Reference to the unique identifier of the item category the item belongs to.
SALES_BILL_OF_LADING_NUMBER VARCHAR2 120 Carrier's contract and receipt for the goods that the carrier agrees to transport from a specific origin address to a specific destination address.
SALES_SHIPMENT_NUMBER VARCHAR2 30 Unique identifier for a shipment.
SALES_WAYBILL_NUMBER VARCHAR2 30 Non-negotiable document describing the contract for transporting cargo.
WAREHOUSE_ID NUMBER 18 Unique identifier for the warehouse that is used to ship items from or receive items into.
WAREHOUSE_CODE VARCHAR2 18 Unique alphanumeric identifier for the inventory organization.
BATCH_START_DATE DATE Indicates the start date of the batch. Applicable for Special Pricing Agreement batches. Obsolete
BATCH_END_DATE DATE Indicates the end date of the batch. Applicable for Special Pricing Agreement batches. Obsolete
DISTRIBUTOR_NAME VARCHAR2 360 Indicates the name of the distributor of the special price agreement.
DISTRI_BILL_TO_ACCT_NUMBER VARCHAR2 30 Indicates the name of the bill-to-account number of the distributor for the special price agreement.
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.
AGREEMENT_NAME VARCHAR2 240 The name of the special price agreement.
AGREEMENT_NUMBER VARCHAR2 30 The unique number that identifies the special price agreement.
UNIT_PURCHASE_PRICE NUMBER The price per unit paid by the distributor for an item.
UNIT_CLAIMED_AMOUNT NUMBER The amount per unit claimed by the distributor.
HEADER_ATTRIBUTE_CATEGORY VARCHAR2 30 User-defined descriptive flexfield context sensitive segments configured to capture additional information on 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 on 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.
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.
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP 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_INT_N1 Non Unique Default BATCH_ID, SUPPLIER_INVOICE_NUMBER
CJM_DOCUMENT_LINES_INT_N2 Non Unique Default BATCH_ID, SALES_ORDER_NUMBER
CJM_DOCUMENT_LINES_INT_U1 Unique Default BATCH_ID, INTERFACE_ROW_ID