DW_OM_HOLDS_CF

This table contains details of Holds Facts

Details

Module: Order Management

Key Columns

HOLD_INSTANCE_ID, FULFILL_LINE_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
ACTIVE_FLAG VARCHAR2 16 Identifies whether a hold is active on a transaction.
APPLY_TIMESTAMP TIMESTAMP Date hold was placed.
APPLY_DATE DATE Date hold was placed. 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_CREATION_DATE DATE Who column: indicates the date of the creation of the row. DW_DAY_D CALENDAR_DATE
HOLD_CREATION_TIMESTAMP TIMESTAMP Who column: indicates the date and time of the creation of the row.
HOLD_LAST_UPDATE_DATE DATE Who column: indicates the date and time of the last update of the row. DW_DAY_D CALENDAR_DATE
HOLD_LAST_UPDATE_TIMESTAMP TIMESTAMP Who column: indicates the date and time of the last update of the row.
HOLD_CREATED_BY VARCHAR2 128 Who column: indicates the user who created the row. DW_USER_D USERNAME
HOLD_LAST_UPDATED_BY VARCHAR2 128 Who column: indicates the user who last updated the row. DW_USER_D USERNAME
HOLD_RELEASE_COMMENTS VARCHAR2 256 Comments added by user while releasing a hold.
HOLD_RELEASE_REASON_CODE VARCHAR2 32 Reason for releasing the hold. DW_HOLD_RELEASE_REASON_LKP_TL HOLD_RELEASE_REASON_CODE
TRANSACTION_ENTITY_NAME1 VARCHAR2 32 Entity name corresponding to Transaction Entity Id1.
HOLD_LEVEL VARCHAR2 32 Reference to the level at which the hold is applied DW_MSG_ENTITY_TYPE_LKP_TL HOLD_LEVEL_CODE
RELEASE_TIMESTAMP TIMESTAMP The date when the hold is released.
RELEASE_DATE DATE The date when the hold is released. DW_DAY_D CALENDAR_DATE
RELEASED_BY VARCHAR2 128 The user name that requested to release this hold instance. DW_USER_D USERNAME
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.
ORDER_HEADER_ID NUMBER 38 0 Unique identifier of the orchestration order
ORDER_NUMBER VARCHAR2 64 Representation of a sales order used in communication with fulfillment systems
LINE_ID NUMBER 38 0 Unique identifier of the sales order line
ORDER_LINE_NUMBER NUMBER 38 0 Representation of a sales order line used in communication with fulfillment systems
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
LINE_DISPLAY_LINE_NUMBER VARCHAR2 128 Line number for display purposes. Corresponds to the line number on UI
FULFILL_DISPLAY_LINE_NUMBER VARCHAR2 256 Fulfill Line number for display purposes. Corresponds to the Fulfill line number on UI
ORGANIZATION_ID NUMBER 38 0 Indicates the identifier of the inventory organization DW_INTERNAL_ORG_D ORGANIZATION_ID
FULFILL_ORG_ID NUMBER 38 0 Reference to the unique identifier for the fulfillment organization DW_INTERNAL_ORG_D ORGANIZATION_ID
BUSINESS_UNIT_ID NUMBER 38 0 Business Unit ID DW_BUSINESS_UNIT_D BUSINESS_UNIT_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
ORGANIZATION_BU_ID NUMBER 38 0 Inventory Business Unit ID DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
INVENTORY_ORG_PROFIT_CENTER_BU_ID NUMBER 38 0 Profit Center Business Unit Id of the Inventory Organization. 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 DW_ORDER_TYPE_LKP_TL ORDER_TYPE_CODE
ORDER_STATUS_CODE VARCHAR2 32 Status of the order DW_OM_STATUS_D STATUS_CODE
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_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
FULFILL_LINE_STATUS_CODE VARCHAR2 32 Current fulfillment status of the fulfillment line DW_OM_STATUS_D STATUS_CODE
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
SOURCE_ORDER_LINE_NUMBER VARCHAR2 128 Reference to the number of the originating sales order line
SOURCE_DOCUMENT_TYPE_CODE VARCHAR2 64 Indicates the Original Document document type on the order
PARENT_FULFILL_LINE_ID NUMBER 38 0 Used in fulfillment line hierarchies (models) to identify the immediate parent fulfillment line
ROOT_PARENT_FULFILL_LINE_ID NUMBER 38 0 Used in fulfillment line hierarchies (models) to identify the highest fulfillment line in the hierarchy
PARENT_LINE_ID NUMBER 38 0 Parent Line Identifier
ROOT_PARENT_LINE_ID NUMBER 38 0 Root Parent Line Identifier
COMP_SEQ_PATH VARCHAR2 999 Defines the hierarchical relation of a model. Derived from BOM table
INVENTORY_ITEM_ID NUMBER 38 0 Reference to the unique identifier for the inventory item DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID
ITEM_TYPE_CODE VARCHAR2 32 Indicates a grouping of all items of a particular type that share the same set of item attributes DW_ORDER_ITEM_TYPE_LKP_TL ORDER_ITEM_TYPE_CODE
ITEM_SUBTYPE_CODE VARCHAR2 32 More specific sub group for ITEM_TYPE_CODE. Model/Service/One-Time Item characteristic detail (like ATO, PTOSMC, PTONONSMC) DW_ORDER_ITEM_SUBTYPE_LKP_TL ORDER_ITEM_SUBTYPE_CODE
SALES_PRODUCT_TYPE_CODE VARCHAR2 32 Identifies sales product type of product on the fulfillment line DW_SALES_PRODUCT_TYPE_LKP_TL SALES_PRODUCT_TYPE_CODE
PAYMENT_TERM_ID NUMBER 38 0 Identifies the AR payment term associated with the Payment terms DW_AR_PAYMENT_TERMS_D PAYMENT_TERM_ID
PARENT_LINE_DISPLAY_LINE_NUM VARCHAR2 128 Display line number of parent line
PARENT_FLINE_DISPLAY_LINE_NUM VARCHAR2 128 Display line number of parent fulfill line
RP_LINE_DISPLAY_LINE_NUM VARCHAR2 128 Display line number of root parent line
RP_FLINE_DISPLAY_LINE_NUM VARCHAR2 128 Display line number of root parent fulfill line
CONFIGURED_ITEM_ID NUMBER 38 0 Inventory item of shippable ATO configuration DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID
ORIGINAL_INVENTORY_ITEM_ID NUMBER 38 0 Reference to the unique identifier for the original inventory item that was populated on the fulfillment line from decomposition DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID
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
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_PARTY_ID NUMBER 38 0 Reference to the unique identifier for bill-to Party(Fulfillment Line Level) DW_PARTY_D PARTY_ID
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_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
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
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_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_SITE_NAME VARCHAR2 256 Fulfillment line ship to party site name
LEDGER_ID NUMBER 38 0 Primary ledger id DW_LEDGER_D LEDGER_ID
FISCAL_PERIOD_TYPE VARCHAR2 16 Period type DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
FISCAL_PERIOD_SET_NAME VARCHAR2 16 Period Set Name 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
FULFILL_LINE_OPEN_FLAG VARCHAR2 16 Indicates that the status of a fulfillment line that is not closed or canceled
FULFILL_LINE_ON_HOLD_FLAG VARCHAR2 16 Indicates fulfillment lines are not accepting further processing
SALES_AGREEMENT_FLAG VARCHAR2 16 Indicated application of a Sales Agreement
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 DW_DAY_D CALENDAR_DATE
ORDERED_TIMESTAMP TIMESTAMP Date when the items where ordered
SCHEDULE_SHIP_DATE DATE The current date the shipment is planned to ship on DW_DAY_D CALENDAR_DATE
SCHEDULE_SHIP_TIMESTAMP TIMESTAMP The current date the shipment is planned to ship on
PROMISE_SHIP_DATE DATE The date that was promised to the customer that the item would ship DW_DAY_D CALENDAR_DATE
PROMISE_SHIP_TIMESTAMP TIMESTAMP The date that was promised to the customer that the item would ship
REQUEST_SHIP_DATE DATE The original date the customer requested the item ship on DW_DAY_D CALENDAR_DATE
REQUEST_SHIP_TIMESTAMP TIMESTAMP The original date the customer requested the item ship on
ACTUAL_SHIP_DATE DATE The date the shipment was actually sent DW_DAY_D CALENDAR_DATE
ACTUAL_SHIP_TIMESTAMP TIMESTAMP The date the shipment was actually sent
SCHEDULE_ARRIVAL_DATE DATE The current date the shipment is planned to arrive on DW_DAY_D CALENDAR_DATE
SCHEDULE_ARRIVAL_TIMESTAMP TIMESTAMP The current date the shipment is planned to arrive on
PROMISE_ARRIVAL_DATE DATE The date that was promised to the customer that the item would arrive DW_DAY_D CALENDAR_DATE
PROMISE_ARRIVAL_TIMESTAMP TIMESTAMP The date that was promised to the customer that the item would arrive
REQUEST_ARRIVAL_DATE DATE The original date the customer requested the item arrive on DW_DAY_D CALENDAR_DATE
REQUEST_ARRIVAL_TIMESTAMP TIMESTAMP The original date the customer requested the item arrive on
FULFILLED_DATE DATE Date when the order line is fulfilled (Goods shipped, hardware installed etc.) DW_DAY_D CALENDAR_DATE
FULFILLED_TIMESTAMP TIMESTAMP Date when the order line is fulfilled (Goods shipped, hardware installed etc.)
FULFILL_LINE_CANCEL_DATE DATE Date on which customer requested cancellation on the fulfill line DW_DAY_D CALENDAR_DATE
FULFILL_LINE_CANCEL_TIMESTAMP TIMESTAMP Date on which customer requested cancellation on the fulfill line
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
FULFILL_LINE_CANCEL_FLAG VARCHAR2 16 Indicates if the order fulfill line has been cancelled or not
RMA_RECEIPT_DATE DATE Actual Receipt Date of items for a return order, populated here by the receiving fulfillment system DW_DAY_D CALENDAR_DATE
RMA_RECEIPT_TIMESTAMP TIMESTAMP Actual Receipt Date of items for a return order, populated here by the receiving fulfillment system
ORIGINAL_ORDER_NUMBER VARCHAR2 64 Corresponds to the original order number for which return is generated
SUBMITTED_BY VARCHAR2 64 Order submitted by DW_USER_D USERNAME
CREATION_DATE DATE fulfill line creation date DW_DAY_D CALENDAR_DATE
CREATION_TIMESTAMP TIMESTAMP fulfill line creation date
ORDER_CREATION_DATE DATE order creation date DW_DAY_D CALENDAR_DATE
ORDER_CREATION_TIMESTAMP TIMESTAMP order creation date
CREATED_BY VARCHAR2 64 Fulfill line created by DW_USER_D USERNAME
LAST_UPDATE_DATE DATE Fulfill line last update date DW_DAY_D CALENDAR_DATE
LAST_UPDATE_TIMESTAMP TIMESTAMP Fulfill line last update date
LAST_UPDATED_BY VARCHAR2 64 Fulfill line last updated by DW_USER_D USERNAME
CUSTOMER_PO_NUMBER VARCHAR2 64 Customer PO Number
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_SCHEDULE_NUMBER VARCHAR2 64 Contains Customers Purchase Order Shipment Schedule number , if specified while submitting an order.
DROP_SHIPMENT_PO_HEADER_ID NUMBER 38 0 Header ID for Drop ship PO
DROP_SHIPMENT_PO_NUMBER VARCHAR2 256 Header Number for Drop ship PO
DROP_SHIPMENT_PO_LINE_ID NUMBER 38 0 Line ID for Drop ship PO
DROP_SHIPMENT_PO_LINE_NUMBER VARCHAR2 256 Line Number for Drop ship PO
DROP_SHIPMENT_PO_SCHEDULE_ID NUMBER 38 0 Schedule ID for Drop ship PO
DROP_SHIPMENT_PO_SCHEDULE_NUMBER VARCHAR2 256 Schedule Number for Drop ship PO
DROP_SHIPMENT_REQUISITION_HEADER_ID NUMBER 38 0 Requisition Header ID for Drop ship PO
DROP_SHIPMENT_REQUISITION_NUMBER VARCHAR2 256 Requisition Header Number for Drop ship PO
DROP_SHIPMENT_REQUISITION_LINE_ID NUMBER 38 0 Requisition Line ID for Drop ship PO
DROP_SHIPMENT_REQUISITION_LINE_NUMBER VARCHAR2 256 Requisition Line Number for Drop ship PO
DROP_SHIPMENT_REQUISITION_BU_ID NUMBER 38 0 Maps to BU Id as per Fusion Enterprise structure. DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
DROP_SHIPMENT_REQUISITION_INVENTORY_ORG_ID NUMBER 38 0 Maps to Organization Id as per Fusion Enterprise structure. DW_INTERNAL_ORG_D ORGANIZATION_ID
DROP_SHIPMENT_PO_BUYER_ID NUMBER 38 0 Holds Buyer information for a schedule, this is a reference column and it is referenced to BUYER PUBLIC VIEW that is published by purchase Order product. DW_PERSON_NAME_CURRENT_D PERSON_ID
SHIP_STATUS VARCHAR2 32 Status of a fulfillment line where the detail level task type is shipment. DW_OM_STATUS_D STATUS_CODE
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
SHIPPING_INSTRUCTIONS VARCHAR2 999 A message on a document that provides details about cargo and any requirements for its physical movement.
PACKING_INSTRUCTIONS VARCHAR2 999 A document that contains information concerning the packing of an item.
SALESPERSON_ID NUMBER 38 0 Primary Sales person identifier. DW_PARTY_D PARTY_ID
ORDER_CUSTOMER_PO_NUMBER VARCHAR2 64 Header level customer PO number
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
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_EXPENDITURE_ITEM_DATE DATE Date on which a project-related transaction is incurred DW_DAY_D CALENDAR_DATE
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