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.