This table contains details of Holds Facts
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 | 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 and time 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 | |
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 | 4000 | 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 | |
BILL_TO_CUSTOMER_ACCOUNT_ID | NUMBER | 38 | 0 | Reference to the unique identifier for the bill-to customer | DW_CUSTOMER_ACCOUNT_D | CUSTOMER_ACCOUNT_ID | |
BILL_TO_PARTY_ID | NUMBER | 38 | 0 | Reference to the unique identifier for bill-to 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 | |
SHIP_TO_PARTY_ID | NUMBER | 38 | 0 | Reference to the unique identifier for ship-to Party | DW_PARTY_D | PARTY_ID | |
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 |