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