# DW_OM_BACK_TO_BACK_SUPPLY_DETAILS_CF

Back to Back and Supply Details Fact - Stores Supply Details for Back to Back Sales Orders.

## Details

Module: Order Management

## Key Columns

FULFILL_LINE_ID, SUPPLY_LINE_ID, SUPPLY_TRACKING_LINE_DOCS_ID, SUPPLY_TRACKING_LINE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
FULFILL_LINE_ID | NUMBER | 38 | 0 | True | Unique Identifier for a fulfillment line |  |
SUPPLY_LINE_ID | NUMBER | 38 | 0 | True | Unique Identifier of DOS_SUPPLY_LINES |  |
SUPPLY_TRACKING_LINE_ID | NUMBER | 38 | 0 | True | Unique Identifier of DOS_SUPPLY_TRACKING_LINES |  |
SUPPLY_TRACKING_LINE_DOCS_ID | NUMBER | 38 | 0 | True | Unique Identifier of DOS_SUPPLY_TRACKING_LINE_DOCS |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. System Identifier |  |
ORDER_HEADER_ID | NUMBER | 38 | 0 |  | Unique identifier of the orchestration order |  |
SUPPLY_HEADER_ID | NUMBER | 38 | 0 |  | Unique identifier of the supply header |  |
ORDER_NUMBER | VARCHAR2 | 64 |  |  | Representation of a sales order used in communication with fulfillment systems |  |
LINE_ID | NUMBER | 38 | 0 |  | Unique identifier of the sales order line |  |
ORDER_LINE_NUMBER | NUMBER | 38 | 0 |  | Representation of a sales order line used in communication with fulfillment systems |  |
FULFILL_LINE_NUMBER | NUMBER | 38 | 0 |  | Numerical value associated to fulfillment line. It is defaulted to 1 and increments in integers as fulfillment lines split |  |
LINE_DISPLAY_LINE_NUMBER | VARCHAR2 | 128 |  |  | Line number for display purposes. Corresponds to the line number on UI |  |
FULFILL_DISPLAY_LINE_NUMBER | VARCHAR2 | 256 |  |  | Fulfill Line number for display purposes. Corresponds to the Fulfill line number on UI |  |
ORGANIZATION_ID | NUMBER | 38 | 0 |  | Indicates the identifier of the inventory organization | DW_INTERNAL_ORG_D | ORGANIZATION_ID
FULFILL_ORG_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for the fulfillment organization | DW_INTERNAL_ORG_D | ORGANIZATION_ID
BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Business Unit ID | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
PROFIT_CENTER_BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Reference to Unique Identifier of Profit Center Business Unit | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
ORGANIZATION_BU_ID | NUMBER | 38 | 0 |  | Inventory Business Unit ID | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
INVENTORY_ORG_PROFIT_CENTER_BU_ID | NUMBER | 38 | 0 |  | Profit Center Business Unit Id of the Inventory Organization. | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Legal entity identifier | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID
ORDER_TYPE_CODE | VARCHAR2 | 32 |  |  | Name of the type of order that was placed. Stores codes for values of order types. | DW_ORDER_TYPE_LKP_TL | ORDER_TYPE_CODE
ORDER_STATUS_CODE | VARCHAR2 | 32 |  |  | Status of the order. | DW_OM_STATUS_D | STATUS_CODE
LINE_TYPE_CODE | VARCHAR2 | 32 |  |  | Defines the system behavior for the order line transaction, in terms of values required, defaulted, and displayed. Use DW_ORDER_LINE_TYPE_LKP_TL to resolve the lookup codes for order lines, and DW_ORDER_RETURN_TYPE_LKP_TL for return lines | DW_ORDER_LINE_TYPE_LKP_TL | LINE_TYPE_CODE
FULFILL_LINE_STATUS_CODE | VARCHAR2 | 32 |  |  | Current fulfillment status of the fulfillment line. | DW_OM_STATUS_D | STATUS_CODE
SOURCE_ORDER_NUMBER | VARCHAR2 | 64 |  |  | Reference to the number of the originating sales order |  |
SOURCE_ORDER_SYSTEM | VARCHAR2 | 64 |  |  | Reference to the order capture system that the source order came from |  |
SOURCE_ORDER_LINE_NUMBER | VARCHAR2 | 128 |  |  | Reference to the number of the originating sales order line |  |
SOURCE_DOCUMENT_TYPE_CODE | VARCHAR2 | 64 |  |  | Indicates the Original Document document type on the order |  |
INVENTORY_ITEM_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for the inventory item #1 | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID
ITEM_TYPE_CODE | VARCHAR2 | 32 |  |  | Indicates a grouping of all items of a particular type that share the same set of item attributes. Stores codes for values like - Model, Option Class, Standard, etc | DW_ORDER_ITEM_TYPE_LKP_TL | ORDER_ITEM_TYPE_CODE
ITEM_SUBTYPE_CODE | VARCHAR2 | 32 |  |  | More specific sub group for ITEM_TYPE_CODE. Model/Service/One-Time Item characteristic detail (like ATO, PTOSMC, PTONONSMC). Stores codes for values like - Standard, Pick to order model, Kit, etc | DW_ORDER_ITEM_SUBTYPE_LKP_TL | ORDER_ITEM_SUBTYPE_CODE
TRX_UOM | VARCHAR2 | 16 |  |  | Unit of measure of the Item used for the transaction | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
ORDER_BILL_TO_CUST_ACCT_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for the bill-to customer(Order Header level) | DW_CUSTOMER_ACCOUNT_D | CUSTOMER_ACCOUNT_ID
ORDER_BILL_TO_PARTY_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for bill-to Party(Order Header Level) | DW_PARTY_D | PARTY_ID
ORDER_BILL_TO_CONTACT_PARTY_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for bill-to contact Party(Order Header Level) | DW_PARTY_D | PARTY_ID
ORDER_BILL_TO_LOCATION_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for the bill-to customer location(Order Header Level) | DW_CUSTOMER_LOCATION_D | CUSTOMER_LOCATION_ID
BILL_TO_CUSTOMER_ACCOUNT_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for the bill-to customer(Fulfillment Line Level) | DW_CUSTOMER_ACCOUNT_D | CUSTOMER_ACCOUNT_ID
BILL_TO_PARTY_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for bill-to Party(Fulfillment Line Level) | DW_PARTY_D | PARTY_ID
BILL_TO_CONTACT_PARTY_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for bill-to contact Party(Fulfillment Line Level) | DW_PARTY_D | PARTY_ID
BILL_TO_LOCATION_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for the bill-to customer location(Fulfillment Line Level) | DW_CUSTOMER_LOCATION_D | CUSTOMER_LOCATION_ID
SOLD_TO_PARTY_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for the sold-to Party. | DW_PARTY_D | PARTY_ID
SOLD_TO_CONTACT_PARTY_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for the sold-to contact Party. | DW_PARTY_D | PARTY_ID
ORDER_SHIP_TO_PARTY_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for ship-to Party(Order Header Level) | DW_PARTY_D | PARTY_ID
ORDER_SHIP_TO_CONTACT_PARTY_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for ship-to contact Party(Order Header Level) | DW_PARTY_D | PARTY_ID
ORDER_SHIP_TO_LOCATION_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for the ship-to party location(Order Header Level) | DW_CUSTOMER_LOCATION_D | CUSTOMER_LOCATION_ID
SHIP_TO_PARTY_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for ship-to Party(Fulfillment Line Level) | DW_PARTY_D | PARTY_ID
SHIP_TO_CONTACT_PARTY_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for ship-to contact Party(Fulfillment Line Level) | DW_PARTY_D | PARTY_ID
SHIP_TO_LOCATION_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for the ship-to party location(Fulfillment Line Level) | DW_CUSTOMER_LOCATION_D | CUSTOMER_LOCATION_ID
SHIP_TO_PARTY_SITE_NAME | VARCHAR2 | 256 |  |  | Fulfillment line ship to party site name |  |
LEDGER_ID | NUMBER | 38 | 0 |  | Primary ledger id. Derived from the Business Unit. | DW_LEDGER_D | LEDGER_ID
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | Period type. Derived from the ledger associated with the Business Unit. #2 | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | Period Set Name.Derived from the ledger associated with the Business Unit. #2 | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
ORDER_SUBMIT_DATE | DATE |  |  |  | The date and time of the submission of the order | DW_DAY_D | CALENDAR_DATE
ORDER_SUBMIT_TIMESTAMP | TIMESTAMP |  |  |  | The date and time of the submission of the order |  |
ORDERED_DATE | DATE |  |  |  | Date when the items where ordered | DW_DAY_D | CALENDAR_DATE
ORDERED_TIMESTAMP | TIMESTAMP |  |  |  | Date when the items where ordered |  |
ORDER_OPEN_FLAG | VARCHAR2 | 16 |  |  | Indicates that the status of an order that is not closed or canceled |  |
ORDER_ON_HOLD_FLAG | VARCHAR2 | 16 |  |  | Indicates an order is not accepting further processing |  |
FULFILL_LINE_OPEN_FLAG | VARCHAR2 | 16 |  |  | Indicates that the status of a fulfillment line that is not closed or canceled |  |
FULFILL_LINE_ON_HOLD_FLAG | VARCHAR2 | 16 |  |  | Indicates fulfillment lines are not accepting further processing |  |
ORDER_CANCELLED_FLAG | VARCHAR2 | 16 |  |  | Indicates if the entire order has been cancelled or not |  |
ORDER_CANCELLED_REASON_CODE | VARCHAR2 | 32 |  |  | Reason for cancelation of order | DW_RETURN_REASON_LKP_TL | RETURN_REASON_CODE
FULFILL_LINE_CANCEL_FLAG | VARCHAR2 | 16 |  |  | Indicates if the order fulfill line has been cancelled or not |  |
PUOM_CONVERSION_FACTOR | NUMBER |  |  |  | Primary UOM conversion factor |  |
PUOM_CODE | VARCHAR2 | 16 |  |  | Primary Unit of measure of the Item used for the transaction | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
SUPPLY_ORDER_NUMBER | VARCHAR2 | 256 |  |  | Supply Order Number for the Supply Request |  |
SUPPLY_ORDER_STATUS_CODE | VARCHAR2 | 32 |  |  | Header Status OPEN,CLOSED,INPROC | DW_ORA_DOS_SUPPLY_ORDER_STATUS_LKP_TL | ORA_DOS_SUPPLY_ORDER_STATUS_CODE
SUPPLY_ORDER_REQUEST_DATE | DATE |  |  |  | Date on which the supply was requested | DW_DAY_D | CALENDAR_DATE
SUPPLY_ORDER_REQUEST_TIMESTAMP | TIMESTAMP |  |  |  | Date with timestamp on which the supply was requested |  |
SUPPLY_LINE_NUMBER | NUMBER | 38 | 0 |  | Supply Line Number. Unique number for a particular Supply Order |  |
SUPPLY_LINE_QUANTITY | NUMBER |  |  |  | Supply Quantity being requested for this order |  |
SUPPLY_LINE_PUOM_QUANTITY | NUMBER |  |  |  | Supply Quantity in Primary UOM being requested for this order |  |
SUPPLY_LINE_STATUS_CODE | VARCHAR2 | 32 |  |  | Status code of the Supply Line derived from lookups | DW_ORA_DOS_SUPPLY_ORDER_STATUS_LKP_TL | ORA_DOS_SUPPLY_ORDER_STATUS_CODE
SUPPLY_LINE_TYPE_CODE | VARCHAR2 | 32 |  |  | Type of supply being created like MAKE OR BUY | DW_ORA_DOS_SUPPLY_ORDER_TYPE_LKP_TL | ORA_DOS_SUPPLY_ORDER_TYPE_CODE
SUPPLY_TRACKING_LINE_NUMBER | NUMBER | 38 | 0 |  | Supply Tracking Line Number, automatically generated by system |  |
SUPPLY_TRACKING_LINE_STATUS_CODE | VARCHAR2 | 32 |  |  | Status of the supply tracking line The status code that is eligible to be used on a tracking line. | DW_DOS_STATUS_D | STATUS_CODE
SUPPLY_TRACKING_LINE_REQUESTED_QUANTITY | NUMBER |  |  |  | Supply quantity associated with the supply tracking line |  |
SUPPLY_TRACKING_LINE_PUOM_REQUESTED_QUANTITY | NUMBER |  |  |  | Supply quantity in Primary UOM associated with the supply tracking line |  |
SUPPLY_TRACKING_LINE_FULFILLED_QUANTITY | NUMBER |  |  |  | Quantity which has been completed at the fulfillment completion step of the process instance associated to the tracking line. |  |
SUPPLY_TRACKING_LINE_PUOM_FULFILLED_QUANTITY | NUMBER |  |  |  | Quantity in Primary UOM which has been completed at the fulfillment completion step of the process instance associated to the tracking line. |  |
SUPPLY_TRACKING_LINE_AVAILABLE_TO_SHIP_DATE | DATE |  |  |  | Date the Supply needs to be available | DW_DAY_D | CALENDAR_DATE
SUPPLY_TRACKING_LINE_AVAILABLE_TO_SHIP_TIMESTAMP | TIMESTAMP |  |  |  | Timestamp the Supply needs to be available |  |
SUPPLY_TRACKING_LINE_DOCUMENT_HEADER_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for the supply order |  |
SUPPLY_TRACKING_LINE_DOCUMENT_LINE_ID | NUMBER | 38 | 0 |  | Reference to the unique identifier for the supply order line |  |
SUPPLY_TRACKING_LINE_DOCUMENT_NUMBER | VARCHAR2 | 128 |  |  | Document Number of the supply document created for the supply request |  |
SUPPLY_TRACKING_LINE_DOCUMENT_TYPE_CODE | VARCHAR2 | 32 |  |  | Type of supply document created for the supply request | DW_ORA_DOS_DOCUMENT_TYPE_LKP_TL | ORA_DOS_DOCUMENT_TYPE_CODE
SUPPLY_TRACKING_LINE_DOCUMENT_LINE_NUMBER | VARCHAR2 | 32 |  |  | Document Line created for the supply request |  |
SUPPLY_TRACKING_LINE_DOCUMENT_QUANTITY | NUMBER |  |  |  | Supply quantity associated with the document line |  |
SUPPLY_TRACKING_LINE_DOCUMENT_PUOM_QUANTITY | NUMBER |  |  |  | Supply quantity in Primary UOM associated with the document line |  |
SUPPLY_TRACKING_LINE_DOCUMENT_UOM_CODE | VARCHAR2 | 16 |  |  | Unit of measure for the document line quantity | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
SUPPLY_TRACKING_LINE_DOCUMENT_PUOM_CONVERSION_FACTOR | NUMBER |  |  |  | Primary UOM conversion factor |  |
SUPPLY_TRACKING_LINE_DOCUMENT_STATUS_CODE | VARCHAR2 | 32 |  |  | Status of the Document created in the execution system | DW_DOS_STATUS_D | STATUS_CODE
SUPPLY_TRACKING_LINE_DOCUMENT_CREATION_DATE | DATE |  |  |  | indicates the date of the creation of the Document table row. | DW_DAY_D | CALENDAR_DATE
SUPPLY_TRACKING_LINE_DOCUMENT_CREATION_TIMESTAMP | TIMESTAMP |  |  |  | indicates the date and time of the creation of the Document table row. |  |
SUPPLY_TRACKING_LINE_DOCUMENT_ACTIVE_FLAG | NUMBER | 38 | 0 |  | Flag to identify latest status of a document line. Either 1 or 0. document type, document id and document line id combination will have only one record with value 1. |  |
SUPPLY_STATUS_CODE | VARCHAR2 | 32 |  |  | Status of the supply for the fulfillment line. | DW_ORA_DOO_SUPPLY_STATUS_CODE_LKP_TL | ORA_DOO_SUPPLY_STATUS_CODE_CODE
SHIP_STATUS | VARCHAR2 | 32 |  |  | Status of a fulfillment line where the detail level task type is shipment. | DW_OM_STATUS_D | STATUS_CODE
ORDER_PRICING_SEGMENT_CODE | VARCHAR2 | 32 |  |  | Stores either the pricing segment code passed in from the caller or the pricing segment code derived by the pricing engine | DW_ORA_QP_CUST_PRICING_SEGMENTS_LKP_TL | ORA_QP_CUST_PRICING_SEGMENTS_CODE
ORDER_PRICING_SEGMENT_EXPLANATION | VARCHAR2 | 999 |  |  | Message explaining why the Pricing Segment was applied |  |
ORDER_PRICING_STRATEGY_EXPLANATION | VARCHAR2 | 999 |  |  | Message explaining why the Pricing Strategy was applied |  |
SHIPPING_INSTRUCTIONS | VARCHAR2 | 999 |  |  | A message on a document that provides details about cargo and any requirements for its physical movement. |  |
PACKING_INSTRUCTIONS | VARCHAR2 | 999 |  |  | A document that contains information concerning the packing of an item. |  |
SALESPERSON_ID | NUMBER | 38 | 0 |  | Primary Sales person identifier. | DW_PARTY_D | PARTY_ID
PJC_PROJECT_ID | NUMBER | 38 | 0 |  | Identifier of the project used to build the transaction descriptive flexfield for project-related transaction distributions. | DW_PROJECT_D | PROJECT_ID
PJC_TASK_ID | NUMBER | 38 | 0 |  | Identifier of the task used to build the transaction descriptive flexfield for project-related transaction distributions. | DW_PROJECT_ELEMENT_D | PROJ_ELEMENT_ID
PJC_EXPENDITURE_TYPE_ID | NUMBER | 38 | 0 |  | Expenditure type used to build the transaction descriptive flexfield for project-related transaction distributions. | DW_PROJECT_EXPENDITURE_TYPE_D | EXPENDITURE_TYPE_ID
PJC_EXPENDITURE_ITEM_DATE | DATE |  |  |  | Date on which a project-related transaction is incurred | DW_DAY_D | CALENDAR_DATE
PJC_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Identifier for expenditure organization used to build the transaction descriptive flexfield for project-related transaction distributions. | DW_INTERNAL_ORG_D | ORGANIZATION_ID

## Notes

#1 In these cases in addition to the item columns ORGANIZATION_ID column should also be used for join with DW_INVENTORY_ITEM_D #2 In these cases to join with DW_FISCAL_DAY_D apart from FISCAL_PERIOD_TYPE and FISCAL_PERIOD_SET_NAME the relationship should be based on ORDERED_DATE column

Copyright © 2019, 2025, Oracle and/or its affiliates.