DW_OM_SALES_ORDER_CF

Sales Order Header Fact

Details

Module: Order Management

Key Columns

ORDER_HEADER_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ORDER_HEADER_ID NUMBER 38 0 True Unique identifier of the orchestration order    
SOURCE_RECORD_ID VARCHAR2 128     This column is for Oracle Internal use only. System Identifier    
ORDER_NUMBER VARCHAR2 64     Representation of a sales order used in communication with fulfillment systems    
BUSINESS_UNIT_ID NUMBER 38 0   Business Unit ID 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
SOURCE_ORDER_SYSTEM VARCHAR2 64     Reference to the order capture system that the source order came from    
SOURCE_DOCUMENT_TYPE_CODE VARCHAR2 64     Indicates the Original Document document type on the order    
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
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
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. #1 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. #1 DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
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    
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 #1 DW_DAY_D CALENDAR_DATE
ORDERED_TIMESTAMP TIMESTAMP       Date with timestamp when the items where ordered    
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
SUBMITTED_BY VARCHAR2 64     Order submitted by DW_USER_D USERNAME
CREATION_DATE DATE       order creation date DW_DAY_D CALENDAR_DATE
CREATION_TIMESTAMP TIMESTAMP       order creation date with timestamp    
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    
ORDER_CUSTOMER_PO_NUMBER VARCHAR2 64     Header level customer PO number    

Notes

#1 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, 2024, Oracle and/or its affiliates.