This table requires activation of Draft Order Management functional area. This table contains details of Draft Holds Fact
Module: Order Management
FULFILL_LINE_ID, HOLD_INSTANCE_ID
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 |
#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.