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
| Name | Columns |
|---|---|
|
DOO_LINES_ALL_PK |
LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| 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 | 100 | 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 | The base selling price before applying discounts. It typically defaults from the item definition. | |||
| UNIT_SELLING_PRICE | NUMBER | 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). | ||
| QUANTITY_PER_MODEL | NUMBER | Component quantity for a single model | |||
| MODIFIED_FLAG | VARCHAR2 | 1 | Indicates that the row has been modified in the version currently submitted | ||
| DISPLAY_LINE_NUMBER | VARCHAR2 | 100 | Line number for display purposes | ||
| CREATED_IN_RELEASE | VARCHAR2 | 15 | Stores the release version when line was created. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| DOO_LINES_ALL | doo_headers_all | HEADER_ID |
| doo_orchestration_groups | doo_lines_all | LINE_ID |
| doo_hold_instances | doo_lines_all | DOO_LINE_ID |
| doo_lines_eff_b | doo_lines_all | LINE_ID |
| doo_step_instance_details | doo_lines_all | LINE_ID |
| doo_ui_recent_objects | doo_lines_all | LINE_ID |
| doo_fulfill_lines_all | doo_lines_all | LINE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| 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_LINE_ID, SOURCE_ORDER_ID, SOURCE_ORDER_SYSTEM, SOURCE_SCHEDULE_ID |
| DOO_LINES_ALL_PK | Unique | Default | LINE_ID |