DW_OM_DRAFT_HOLDS_CF (Preview)

This table requires activation of Draft Order Management functional area. This table contains details of Draft Holds Fact

Details

Module: Order Management

Key Columns

FULFILL_LINE_ID, HOLD_INSTANCE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
HOLD_INSTANCE_ID NUMBER 38 0 True Unique identifier of the hold instance    
FULFILL_LINE_ID NUMBER 38 0 True Unique Identifier for a fulfillment line    
SOURCE_RECORD_ID VARCHAR2 128     This column is for Oracle Internal use only. System Identifier    
APPLY_TIMESTAMP TIMESTAMP       Date hold was placed with timestamp.    
APPLY_DATE DATE       Date hold was placed without timestamp. DW_DAY_D CALENDAR_DATE
APPLIED_BY VARCHAR2 128     The user name that requested to apply this hold instance. This is only applicable when the apply system is DOO workbench. DW_USER_D USERNAME
HOLD_CODE_ID NUMBER 38 0   Reference to the unique identifier for hold codes DW_OM_HOLD_CODES_D HOLD_CODE_ID
HOLD_COMMENTS VARCHAR2 256     Comments the user who is initiating the hold adds to the hold.    
HOLD_LAST_UPDATED_BY VARCHAR2 128     Who column: indicates the user who last updated the row. DW_USER_D USERNAME
TRANSACTION_ENTITY_NAME1 VARCHAR2 32     Entity name corresponding to Transaction Entity Id1.    
HOLD_SOURCE_ORDER_SYSTEM VARCHAR2 64     Reference to the order capture system that the source order came from.    
APPLY_SYSTEM VARCHAR2 32     The system that requested to apply this hold instance.    
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_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_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
BILL_TO_PARTY_ID NUMBER 38 0   Reference to the unique identifier for bill-to Party(Fulfillment Line Level) DW_PARTY_D PARTY_ID
BUSINESS_UNIT_ID NUMBER 38 0   Business Unit ID DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
COMP_SEQ_PATH VARCHAR2 999     Defines the hierarchical relation of a model. Derived from BOM table    
CUSTOMER_PO_LINE_NUMBER VARCHAR2 64     An identifier of the line record on a transaction. The purchase order line describes an item or service, with a price and quantity ordered.    
CUSTOMER_PO_NUMBER VARCHAR2 64     Customer PO Number    
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
FISCAL_PERIOD_TYPE VARCHAR2 16     Period type. Derived from the ledger associated with the Business Unit. #2 DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
FULFILL_DISPLAY_LINE_NUMBER VARCHAR2 256     Fulfill Line number for display purposes. Corresponds to the Fulfill line number on UI    
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    
FULFILL_ORG_ID NUMBER 38 0   Reference to the unique identifier for the fulfillment organization DW_INTERNAL_ORG_D ORGANIZATION_ID
INVENTORY_ITEM_ID NUMBER 38 0   Reference to the unique identifier for the inventory item #1 DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID
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
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
LEDGER_ID NUMBER 38 0   Primary ledger id. Derived from the Business Unit. DW_LEDGER_D LEDGER_ID
LEGAL_ENTITY_ID NUMBER 38 0   Legal entity identifier DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
LINE_CATEGORY_CODE VARCHAR2 32     Represents whether a sales order line belongs to a regular order or a return order DW_ORDER_LINE_CATEGORY_LKP_TL LINE_CATEGORY_CODE
LINE_DISPLAY_LINE_NUMBER VARCHAR2 128     Line number for display purposes. Corresponds to the line number on UI    
LINE_ID NUMBER 38 0   Unique identifier of the sales order line    
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
ORDER_CREATION_DATE DATE       order creation date DW_DAY_D CALENDAR_DATE
ORDER_CREATION_TIMESTAMP TIMESTAMP       order creation date with timestamp    
ORDER_CUSTOMER_PO_NUMBER VARCHAR2 64     Header level customer PO number    
ORDER_HEADER_ID NUMBER 38 0   Unique identifier of the orchestration order    
ORDER_LINE_NUMBER NUMBER 38 0   Representation of a sales order line used in communication with fulfillment systems    
ORDER_NUMBER VARCHAR2 64     Representation of a sales order used in communication with fulfillment systems    
ORDER_STATUS_CODE VARCHAR2 32     Status of the order. DW_OM_STATUS_D STATUS_CODE
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
ORDERED_DATE DATE       Date when the items where ordered DW_DAY_D CALENDAR_DATE
ORDERED_TIMESTAMP TIMESTAMP       Date when the items where ordered    
ORGANIZATION_ID NUMBER 38 0   Indicates the identifier of the inventory organization DW_INTERNAL_ORG_D ORGANIZATION_ID
PACKING_INSTRUCTIONS VARCHAR2 999     A document that contains information concerning the packing of an item.    
PARENT_FULFILL_LINE_ID NUMBER 38 0   Used in fulfillment line hierarchies (models) to identify the immediate parent fulfillment line    
PARENT_LINE_ID NUMBER 38 0   Parent Line Identifier    
PAYMENT_TERM_ID NUMBER 38 0   Identifies the AR payment term associated with the Payment terms DW_AR_PAYMENT_TERMS_D PAYMENT_TERM_ID
PJC_EXPENDITURE_ITEM_DATE DATE       Date on which a project-related transaction is incurred DW_DAY_D CALENDAR_DATE
PJC_EXPENDITURE_TYPE_ID NUMBER 38 0   Expenditure type used to build the transaction descriptive flexfield for project-related transaction distributions. DW_PROJECT_EXPENDITURE_TYPE_D EXPENDITURE_TYPE_ID
PJC_ORGANIZATION_ID NUMBER 38 0   Identifier for expenditure organization used to build the transaction descriptive flexfield for project-related transaction distributions. DW_INTERNAL_ORG_D ORGANIZATION_ID
PJC_PROJECT_ID NUMBER 38 0   Identifier of the project used to build the transaction descriptive flexfield for project-related transaction distributions. DW_PROJECT_D PROJECT_ID
PJC_TASK_ID NUMBER 38 0   Identifier of the task used to build the transaction descriptive flexfield for project-related transaction distributions. DW_PROJECT_ELEMENT_D PROJ_ELEMENT_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
ROOT_PARENT_FULFILL_LINE_ID NUMBER 38 0   Used in fulfillment line hierarchies (models) to identify the highest fulfillment line in the hierarchy    
ROOT_PARENT_LINE_ID NUMBER 38 0   Root Parent Line Identifier    
SALES_PRODUCT_TYPE_CODE VARCHAR2 32     Identifies sales product type of product on the fulfillment line. Stores codes for values like:- Goods, Subscription, extended warranty, etc DW_SALES_PRODUCT_TYPE_LKP_TL SALES_PRODUCT_TYPE_CODE
SALESPERSON_ID NUMBER 38 0   Primary Sales person identifier. 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_ID NUMBER 38 0   Reference to the unique identifier for ship-to Party(Fulfillment Line Level) DW_PARTY_D PARTY_ID
SHIP_TO_PARTY_SITE_NAME VARCHAR2 256     Fulfillment line ship to party site name    
SHIPPING_INSTRUCTIONS VARCHAR2 999     A message on a document that provides details about cargo and any requirements for its physical movement.    
SOLD_TO_CONTACT_PARTY_ID NUMBER 38 0   Reference to the unique identifier for the sold-to contact Party. DW_PARTY_D PARTY_ID
SOLD_TO_PARTY_ID NUMBER 38 0   Reference to the unique identifier for the sold-to Party. DW_PARTY_D PARTY_ID
SOURCE_DOCUMENT_TYPE_CODE VARCHAR2 64     Indicates the Original Document document type on the order    
SOURCE_ORDER_LINE_NUMBER VARCHAR2 128     Reference to the number of the originating sales order line    
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    

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

Copyright © 2019, 2024, Oracle and/or its affiliates.