DOO_LINES_ALL

This table would contain the line level information for a DOO Order

Details

  • Schema: FUSION

  • Object owner: DOO

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Details of the primary key for the table.
Name Columns
DOO_LINES_ALL_PK LINE_ID

Columns

Columns that are associated with the table.
Name Database Length Precision Not Null Comments Flexfield Mapping
HEADER_ID NUMBER 18 Yes Reference to the unique identifier for the orchestration order
LINE_ID NUMBER 18 Yes Unique identifier of the orchestration order line
LINE_NUMBER NUMBER 9 Yes Representation of a sales order line used in communication with fulfillment systems.
STATUS_CODE VARCHAR2 30 Yes Status of the orchestration order line.
OWNER_ID NUMBER 18 DOO user who is responsible for the orchestration order line
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
SOURCE_LINE_ID VARCHAR2 50 Yes Reference to the unique identifier for the original source order line
SOURCE_LINE_NUMBER VARCHAR2 50 Yes Any line asset line that originates from other feeders systems.
SOURCE_ORDER_ID VARCHAR2 50 Yes Reference to the unique identifier for the source order in order capture
SOURCE_ORDER_NUMBER VARCHAR2 50 Yes Order Capture order number that is the origin of the contract line.
SOURCE_ORDER_SYSTEM VARCHAR2 30 Yes Reference to the order capture system that the source order came from.
SOURCE_SCHEDULE_ID VARCHAR2 50 Yes Reference to the unique identifier for the schedule line from the source order.
SOURCE_SCHEDULE_NUMBER VARCHAR2 50 Yes Reference to the originating sales order schedule number.
SOURCE_REVISION_NUMBER NUMBER 18 Yes Reference to the revision number of the source order from order capture.
ITEM_TYPE_CODE VARCHAR2 30 Yes Indicates a grouping of all items of a particular type that share the same set of item attributes
ORDERED_QTY NUMBER Yes The quantity of a good or service ordered
CANCELED_QTY NUMBER Canceled quantity.
ORDERED_UOM VARCHAR2 3 Yes Unit of Measure for the quantity ordered- A predetermined amount or quantity or quality, such as of length, time, heat, value that is adopted as a standard of measurement.
SOURCE_ORG_ID NUMBER 18 Reference to the unique identifier for the organization of the source order.
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row.
ACTUAL_SHIP_DATE DATE The date the shipment was actually sent.
SCHEDULE_SHIP_DATE DATE The date when a shipment of goods is expected to be shipped.
RMA_DELIVERED_QTY NUMBER The quantity delivered against the receipt line.
EXTENDED_AMOUNT NUMBER Monetary amount for the order line quantity.
FULFILLED_QTY NUMBER Quantity used to fulfill the order line.
FULFILLMENT_DATE DATE Date when the order line is fulfilled (Goods shipped, hardware installed etc.).
LINE_TYPE_CODE VARCHAR2 30 Defines the system behavior for the order line transaction, in terms of values required, defaulted, and displayed.
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.
OPEN_FLAG VARCHAR2 1 Yes Indicates that the status of an order line that is not closed or canceled.
CANCELED_FLAG VARCHAR2 1 Indicates that the order line is canceled.
INVENTORY_ITEM_ID NUMBER 18 Yes Reference to the unique identifier for the inventory item
COMP_SEQ_PATH VARCHAR2 4000 Defines the hierarchical relation of a model. Derived from BOM table
PARENT_LINE_ID NUMBER 18 Used in orchestration order line hierarchies (models) to identify the immediate parent orchestration order line.
ORIG_SYS_DOCUMENT_REF VARCHAR2 50 Original document reference for the orchestration order in external system
ORIG_SYS_DOCUMENT_LINE_REF VARCHAR2 50 Original document reference for the order line in external system
ROOT_PARENT_LINE_ID NUMBER 18 Used in orchestration order line hierarchies (models) to identify the highest orchestration order line in the hierarchy.
SHIPPED_QTY NUMBER Quantity of product on an order line that is shipped.
UNIT_LIST_PRICE NUMBER Yes The base selling price before applying discounts. It typically defaults from the item definition.
UNIT_SELLING_PRICE NUMBER Yes The price per unit that a buyer paid for an item.
DELTA_TYPE NUMBER 18 Internal column used by change processing framework for tracking type of change like update, cancel..etc
REFERENCE_LINE_ID NUMBER 18 Used by change processing framework for storing the previous line.
ON_HOLD VARCHAR2 1 Indicates an order line is not accepting further processing.
INVENTORY_ORGANIZATION_ID NUMBER 18 Yes Reference to the unique identifier for the inventory organization
CATEGORY_CODE VARCHAR2 30 Yes A code used to group and process journal entries with similar characteristics such as adjustments, accruals, or reclassifications.
TRANSFORM_FROM_LINE_ID NUMBER 18 Reference to the unique identifier for the orchestration order line ...Denotes the line id received from OC from which this particular lineid is derived
ITEM_SUB_TYPE_CODE VARCHAR2 30 More specific sub group for ITEM_TYPE_CODE. Model/Service/One-Time Item characteristic detail (like ATO, PTOSMC, PTONONSMC).

Foreign Keys

Foreign keys that are associated with the table.
Table Foreign Table Foreign Key Column
DOO_LINES_ALL DOO_HEADERS_ALL HEADER_ID
DOO_FULFILL_LINES_ALL DOO_LINES_ALL LINE_ID
DOO_HOLD_INSTANCES DOO_LINES_ALL DOO_LINE_ID
DOO_STEP_INSTANCE_DETAILS DOO_LINES_ALL LINE_ID
DOO_LINES_EFF_B DOO_LINES_ALL LINE_ID
DOO_ORCHESTRATION_GROUPS DOO_LINES_ALL LINE_ID
DOO_UI_RECENT_OBJECTS DOO_LINES_ALL LINE_ID

Indexes

Indexes that are associated with the table.
Index Uniqueness Tablespace Column
DOO_LINES_ALL_FK1 Non Unique Default HEADER_ID
DOO_LINES_ALL_FK2 Non Unique Default INVENTORY_ITEM_ID, OPEN_FLAG
DOO_LINES_ALL_FK3 Non Unique Default PARENT_LINE_ID
DOO_LINES_ALL_FK4 Non Unique Default ROOT_PARENT_LINE_ID
DOO_LINES_ALL_FK5 Non Unique Default REFERENCE_LINE_ID
DOO_LINES_ALL_N1 Non Unique Default SOURCE_SCHEDULE_ID, SOURCE_LINE_ID, SOURCE_ORDER_ID, SOURCE_ORDER_SYSTEM
DOO_LINES_ALL_PK Unique Default LINE_ID