DW_OM_BACK_TO_BACK_SUPPLY_DETAILS_CF

Back to Back and Supply details Fact - Stores all Fulfillment line, charge components information at Fulfillment line and components level with metrics in transactional, Ledger, and global currency values

Details

Module: Order Management

Key Columns

FULFILL_LINE_ID, SUPPLY_TRACKING_LINE_ID, SUPPLY_TRACKING_LINE_DOCS_ID, SUPPLY_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     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

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