Sales Order Header Fact
Module: Order Management
ORDER_HEADER_ID
| 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 |
#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.