1. Tables and Views for SCM
  2. CJM_DOCUMENT_LINES_ALL

CJM_DOCUMENT_LINES_ALL

This table contains the details for each document line. Each row includes the item number, supplier item information, and quantity received for the line.

Details

  • Schema: FUSION

  • Object owner: CJM

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

CJM_DOCUMENT_LINES_ALL_PK

DOCUMENT_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
DOCUMENT_LINE_ID NUMBER 18 Yes Unique identifier for a channel document line.
DOCUMENT_HEADER_ID NUMBER 18 Yes Unique identifier for the document created in the system.
DOCUMENT_BATCH_ID NUMBER 18 Indicates the identifier of the batch.
STATUS_CODE VARCHAR2 30 Indicates the status code of the line. Values are from the lookup ORA_CJM_BATCH_LINE_STATUS.
ITEM_ID NUMBER 18 Unique identifier of the inventory item.
ITEM_DESCRIPTION VARCHAR2 240 Indicates the description of the item.
ITEM_REVISION VARCHAR2 18 Revision number of the inventory item.
VENDOR_ITEM_NUM VARCHAR2 300 Supplier item number in the document line. Obsolete
QUANTITY NUMBER Indicates the item quantity on the line.
UOM_CODE VARCHAR2 3 Unit of measure for the item quantity.
TRANSACTION_QTY_IN_PO_UOM NUMBER Indicates the transaction quantity in the purchase order UOM.
UNIT_PRICE NUMBER Unit price of the line in the document currency.
INVENTORY_ORGANIZATION_ID NUMBER 18 Unique identifier for the item validation inventory organization.
RECEIVING_INVENTORY_ORG_ID NUMBER 18 Unique identifier for the receiving inventory organization.
BU_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row.
REQUESTED_DELIVERY_DATE DATE Indicates the delivery date requested by the buying company for the ordered item or service.
REQUESTED_SHIP_DATE DATE Indicates the date on which the buying company has requested the ordered item to be made ready to be shipped.
PO_HEADER_ID NUMBER 18 Indicates the identifier of the purchase order associated with the document line.
PO_NUMBER VARCHAR2 30 Indicates the purchase order number associated with the document line.
PO_DATE DATE Indicates the purchase order date.
PO_LINE_ID NUMBER 18 Indicates the purchase order line identifier of the object.
PO_LINE_NUMBER NUMBER Indicates the purchase order line number of the object.
PROGRAM_APPLIED_FLAG VARCHAR2 1 Indicates if any program lines are applied for the given document line.
PO_LINE_LOCATION_ID NUMBER 18 Unique identifier of the document shipment schedule.
MATCH_OPTION VARCHAR2 25 Indicates whether the shipment invoice should match the purchase order or the receipt.
EXPECTED_RECEIPT_DATE DATE Expected arrival date of the shipment.
ORIG_TRANSACTION_ID NUMBER 18 Unique identifier for the original transaction associated with the receiving line.
TRANSACTION_ID NUMBER 18 Unique identifier for the transaction associated with the receiving line.
TRANSACTION_NUMBER VARCHAR2 30 Indicates the receiving transaction number.
ORIG_TRANSACTION_NUMBER VARCHAR2 30 Indicates the original receiving transaction number.
TRANSACTION_TYPE VARCHAR2 25 Indicates the original transaction type.
TRANSACTION_DATE DATE Original transaction date for the transactions.
TRANSACTION_QUANTITY NUMBER Transaction quantity of the original transaction.
TRANSACTION_UOM_CODE VARCHAR2 3 Unit of measure code for the original transaction.
TRANSACTION_CURR_CODE VARCHAR2 15 Currency code for the original transaction.
TRANSACTION_UNIT_PRICE NUMBER Transaction unit price for the original transaction.
BILL_TO_LOCATION_ID NUMBER 18 Unique identifier for the bill-to location. (References HR_LOCATIONS_ALL.location_id)
BILL_TO_LOCATION_NAME VARCHAR2 240 Indicates the bill-to location name. Obsolete
BILLTO_LOC_ADDRESS_LINE_1 VARCHAR2 240 First line of the bill-to location address. Obsolete
BILLTO_LOC_ADDRESS_LINE_2 VARCHAR2 240 Second line of the bill-to location address. Obsolete
BILLTO_LOC_ADDRESS_LINE_3 VARCHAR2 240 Third line of the bill-to location address. Obsolete
BILLTO_LOC_ADDRESS_LINE_4 VARCHAR2 240 Fourth line of the bill-to location address. Obsolete
BILLTO_LOC_TOWN_OR_CITY VARCHAR2 30 Name of the town or city for the bill-to location address. Obsolete
BILLTO_LOC_COUNTRY VARCHAR2 60 Country of the bill-to location address. Obsolete
BILLTO_LOC_COUNTY VARCHAR2 120 County of the bill-to location address. Obsolete
BILLTO_LOC_POSTAL_CODE VARCHAR2 30 Postal code of the bill-to location address. Obsolete
BILLTO_LOC_PROVINCE VARCHAR2 120 Province of the bill-to location address. Obsolete
BILLTO_LOC_STATE VARCHAR2 120 State of the bill-to location address. Obsolete
SHIP_TO_LOCATION_ID NUMBER 18 Unique identifier of the ship-to location. (References HR_LOCATIONS_ALL.location_id)
SHIP_TO_LOCATION_NAME VARCHAR2 240 Indicates the ship-to location name. Obsolete
SHIPTO_LOC_ADDRESS_LINE_1 VARCHAR2 240 First line of the ship-to location address. Obsolete
SHIPTO_LOC_ADDRESS_LINE_2 VARCHAR2 240 Second line of the ship-to location address. Obsolete
SHIPTO_LOC_ADDRESS_LINE_3 VARCHAR2 240 Third line of the ship-to location address. Obsolete
SHIPTO_LOC_ADDRESS_LINE_4 VARCHAR2 240 Fourth line of the ship-to location address. Obsolete
SHIPTO_LOC_TOWN_OR_CITY VARCHAR2 30 Name of the town or city for ship-to location address. Obsolete
SHIPTO_LOC_COUNTRY VARCHAR2 60 Country of the ship-to location address. Obsolete
SHIPTO_LOC_COUNTY VARCHAR2 120 County of the ship-to location address. Obsolete
SHIPTO_LOC_POSTAL_CODE VARCHAR2 30 Postal code of the ship-to location address. Obsolete
SHIPTO_LOC_PROVINCE VARCHAR2 120 Province of the ship-to location address. Obsolete
SHIPTO_LOC_STATE VARCHAR2 120 State of the ship-to location address. Obsolete
RECEIVING_LOCATION_ID NUMBER 18 Unique identifier of the receiving location. (References HR_LOCATIONS_ALL.location_id)
RECEIVING_LOCATION_NAME VARCHAR2 240 Indicates the receiving location name. Obsolete
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.
REASON_ID NUMBER 18 Unique identifier of the inventory transaction reason.
REASON_NAME VARCHAR2 30 Indicates the name of the transaction reason.
REASON_DESCRIPTION VARCHAR2 240 Indicates the description of the transaction reason.
DOCUMENT_LINE_NUMBER NUMBER 18 Document line number for the document.
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. Obsolete
RECEIPT_SHIPPED_DATE DATE Supplier invoice date or receiving transaction date when the receipt shipment was created. Obsolete
RECEIPT_WAYBILL_NUMBER VARCHAR2 20 Waybill or airbill receipt number. Obsolete
RECEIPT_BILL_OF_LADING VARCHAR2 25 Bill of lading number from the receipt. Obsolete
DOCUMENT_LINE_REASON VARCHAR2 240 Indicates the reason for the document line.
ORIG_DOCUMENT_NUMBER VARCHAR2 50 Indicates the number of the original document.
ORIG_DOCUMENT_LINE_NUMBER NUMBER 18 Indicates the line number of the original document.
ORIG_DOCUMENT_LINE_ID NUMBER 18 Indicates the line identifier of the original line.
TP_ITEM_ID NUMBER 18 Unique identifier used for the trading partner item.
TP_ITEM_NUM VARCHAR2 300 Indicates the trading partner item number.
SHIPMENT_NUMBER VARCHAR2 30 Shipment number assigned by the shipment's source.
SHIPPED_DATE DATE Indicates the date when the shipment was created.
WAYBILL_NUMBER VARCHAR2 30 Indicates the waybill or airbill number.
BILL_OF_LADING VARCHAR2 120 Indicates the bill of lading number.
REQUESTED_ARRIVAL_DATE DATE Original date the customer requested the item arrive on.
DOO_LINE_ID NUMBER 18 Value that uniquely identifies the Distributed Order Orchestration line.
DOO_FULFILL_LINE_ID NUMBER 18 Value that uniquely identifies the Distributed Order Orchestration fulfillment line.
SALES_INVOICE_ID NUMBER 18 Unique identifier of the customer invoice.
SALES_INVOICE_DATE DATE Date that appears on the customer invoice.
SALES_INVOICE_NUMBER VARCHAR2 50 Invoice number for the customer invoice.
SALES_INVOICE_TYPE_CODE VARCHAR2 20 Indicates the invoice type for the invoice.
SALES_INVOICE_LINE_ID NUMBER 18 Unique identifier of the customer invoice line.
SALES_INVOICE_LINE_NUMBER NUMBER 18 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_LINE_TYPE_CODE VARCHAR2 30 System behavior for the order line transaction.
ORIG_SALES_INVOICE_ID NUMBER 18 Unique identifier of the original customer invoice.
ORIG_SALES_INVOICE_LINE_ID NUMBER 18 Unique identifier of the original customer invoice line.
SALESPERSON_ID NUMBER 18 Unique identifier for the salesperson.
SHIPPED_QUANTITY NUMBER Quantity of goods or services shipped by the supplier.
SHIPPED_UOM VARCHAR2 3 Unit of measure for the shipped quantity.
SHIP_TO_CUSTOMER_ID NUMBER 18 Unique identifier for the ship-to customer.
SHIP_TO_PARTY_SITE_ID NUMBER 18 Unique identifier for the party site of the ship-to-party site address.
SHIP_TO_SITE_USE_ID NUMBER 18 Unique identifier for the ship-to site use for the selected customer site.
UNIT_LIST_PRICE NUMBER Base selling price before applying discounts.
UNIT_SELLING_PRICE NUMBER Price per unit that the buyer paid for the item.
UNIT_PURCHASE_PRICE NUMBER The price per unit paid by the distributor for an item.
CATEGORY_ID NUMBER 18 Reference to the unique identifier of the item category the item belongs to.
WAREHOUSE_ID NUMBER Unique identifier for the warehouse that is used to ship items from or receive items into.
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE_CHAR1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
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 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.

Foreign Keys

Table Foreign Table Foreign Key Column
CJM_DOCUMENT_LINES_ALL cjm_document_headers_all DOCUMENT_HEADER_ID

Indexes

Index Uniqueness Tablespace Columns
CJM_DOCUMENT_LINES_ALL_N1 Non Unique Default DOCUMENT_HEADER_ID
CJM_DOCUMENT_LINES_ALL_N2 Non Unique Default DOCUMENT_BATCH_ID
CJM_DOCUMENT_LINES_ALL_N3 Non Unique Default TRANSACTION_TYPE
CJM_DOCUMENT_LINES_ALL_N4 Non Unique Default REASON_NAME
CJM_DOCUMENT_LINES_ALL_N5 Non Unique Default TRANSACTION_ID
CJM_DOCUMENT_LINES_ALL_N6 Non Unique Default STATUS_CODE
CJM_DOCUMENT_LINES_ALL_N7 Non Unique Default CREATION_DATE
CJM_DOCUMENT_LINES_ALL_U1 Unique Default DOCUMENT_LINE_ID