Back to Back and Supply details Fact - Stores all Fulfillment line, charge components information at Fulfillment line and components level with metrics in transactional, Ledger, and global currency values
Module: Order Management
SUPPLY_LINE_ID, SUPPLY_TRACKING_LINE_ID, FULFILL_LINE_ID, SUPPLY_TRACKING_LINE_DOCS_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
FULFILL_LINE_ID | NUMBER | 38 | 0 | True | Unique Identifier for a fulfillment line | ||
SUPPLY_LINE_ID | NUMBER | 38 | 0 | True | Unique Identifier of DOS_SUPPLY_LINES | ||
SUPPLY_TRACKING_LINE_ID | NUMBER | 38 | 0 | True | Unique Identifier of DOS_SUPPLY_TRACKING_LINES | ||
SUPPLY_TRACKING_LINE_DOCS_ID | NUMBER | 38 | 0 | True | Unique Identifier of DOS_SUPPLY_TRACKING_LINE_DOCS | ||
SOURCE_RECORD_ID | VARCHAR2 | 128 | System Identifier | ||||
ORDER_HEADER_ID | NUMBER | 38 | 0 | Unique identifier of the orchestration order | |||
SUPPLY_HEADER_ID | NUMBER | 38 | 0 | Unique identifier of the supply header | |||
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. 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 | ||
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 | ||||
INVENTORY_ITEM_ID | NUMBER | 38 | 0 | Reference to the unique identifier for the inventory item #1 | 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. Stores codes for values like - Model, Option Class, Standard, etc | 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). Stores codes for values like - Standard, Pick to order model, Kit, etc | DW_ORDER_ITEM_SUBTYPE_LKP_TL | ORDER_ITEM_SUBTYPE_CODE | ||
TRX_UOM | VARCHAR2 | 16 | Unit of measure of the Item used for the transaction | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE | ||
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. 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. #2 | 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. #2 | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME | ||
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 | |||||
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 | ||||
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 | ||||
PUOM_CONVERSION_FACTOR | NUMBER | Primary UOM conversion factor | |||||
PUOM_CODE | VARCHAR2 | 16 | Primary Unit of measure of the Item used for the transaction | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE | ||
SUPPLY_ORDER_NUMBER | VARCHAR2 | 256 | Supply Order Number for the Supply Request | ||||
SUPPLY_ORDER_STATUS_CODE | VARCHAR2 | 32 | Header Status OPEN,CLOSED,INPROC | DW_ORA_DOS_SUPPLY_ORDER_STATUS_LKP_TL | ORA_DOS_SUPPLY_ORDER_STATUS_CODE | ||
SUPPLY_ORDER_REQUEST_DATE | DATE | Date on which the supply was requested | DW_DAY_D | CALENDAR_DATE | |||
SUPPLY_ORDER_REQUEST_TIMESTAMP | TIMESTAMP | Date with timestamp on which the supply was requested | |||||
SUPPLY_LINE_NUMBER | NUMBER | 38 | 0 | Supply Line Number. Unique number for a particular Supply Order | |||
SUPPLY_LINE_QUANTITY | NUMBER | Supply Quantity being requested for this order | |||||
SUPPLY_LINE_PUOM_QUANTITY | NUMBER | Supply Quantity in Primary UOM being requested for this order | |||||
SUPPLY_LINE_STATUS_CODE | VARCHAR2 | 32 | Status code of the Supply Line derived from lookups | DW_ORA_DOS_SUPPLY_ORDER_STATUS_LKP_TL | ORA_DOS_SUPPLY_ORDER_STATUS_CODE | ||
SUPPLY_LINE_TYPE_CODE | VARCHAR2 | 32 | Type of supply being created like MAKE OR BUY | DW_ORA_DOS_SUPPLY_ORDER_TYPE_LKP_TL | ORA_DOS_SUPPLY_ORDER_TYPE_CODE | ||
SUPPLY_TRACKING_LINE_NUMBER | NUMBER | 38 | 0 | Supply Tracking Line Number, automatically generated by system | |||
SUPPLY_TRACKING_LINE_STATUS_CODE | VARCHAR2 | 32 | Status of the supply tracking line The status code that is eligible to be used on a tracking line. | DW_DOS_STATUS_D | STATUS_CODE | ||
SUPPLY_TRACKING_LINE_REQUESTED_QUANTITY | NUMBER | Supply quantity associated with the supply tracking line | |||||
SUPPLY_TRACKING_LINE_PUOM_REQUESTED_QUANTITY | NUMBER | Supply quantity in Primary UOM associated with the supply tracking line | |||||
SUPPLY_TRACKING_LINE_FULFILLED_QUANTITY | NUMBER | Quantity which has been completed at the fulfillment completion step of the process instance associated to the tracking line. | |||||
SUPPLY_TRACKING_LINE_PUOM_FULFILLED_QUANTITY | NUMBER | Quantity in Primary UOM which has been completed at the fulfillment completion step of the process instance associated to the tracking line. | |||||
SUPPLY_TRACKING_LINE_AVAILABLE_TO_SHIP_DATE | DATE | Date the Supply needs to be available | DW_DAY_D | CALENDAR_DATE | |||
SUPPLY_TRACKING_LINE_AVAILABLE_TO_SHIP_TIMESTAMP | TIMESTAMP | Timestamp the Supply needs to be available | |||||
SUPPLY_TRACKING_LINE_SUPPLIER_ID | NUMBER | 38 | 0 | Purchase Req - Suggested Vendor Id | DW_PARTY_D | SUPPLIER_ID | |
SUPPLY_TRACKING_LINE_SUPPLIER_SITE_ID | NUMBER | 38 | 0 | Purchase Req - Suggested Vendor Site Id | DW_SUPPLIER_SITE_D | SUPPLIER_SITE_ID | |
SUPPLY_TRACKING_LINE_DOCUMENT_HEADER_ID | NUMBER | 38 | 0 | Reference to the unique identifier for the supply order | |||
SUPPLY_TRACKING_LINE_DOCUMENT_LINE_ID | NUMBER | 38 | 0 | Reference to the unique identifier for the supply order line | |||
SUPPLY_TRACKING_LINE_DOCUMENT_NUMBER | VARCHAR2 | 128 | Document Number of the supply document created for the supply request | ||||
SUPPLY_TRACKING_LINE_DOCUMENT_TYPE_CODE | VARCHAR2 | 32 | Type of supply document created for the supply request | DW_ORA_DOS_DOCUMENT_TYPE_LKP_TL | ORA_DOS_DOCUMENT_TYPE_CODE | ||
SUPPLY_TRACKING_LINE_DOCUMENT_LINE_NUMBER | VARCHAR2 | 32 | Document Line created for the supply request | ||||
SUPPLY_TRACKING_LINE_DOCUMENT_QUANTITY | NUMBER | Supply quantity associated with the document line | |||||
SUPPLY_TRACKING_LINE_DOCUMENT_PUOM_QUANTITY | NUMBER | Supply quantity in Primary UOM associated with the document line | |||||
SUPPLY_TRACKING_LINE_DOCUMENT_UOM_CODE | VARCHAR2 | 16 | Unit of measure for the document line quantity | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE | ||
SUPPLY_TRACKING_LINE_DOCUMENT_PUOM_CONVERSION_FACTOR | NUMBER | Primary UOM conversion factor | |||||
SUPPLY_TRACKING_LINE_DOCUMENT_STATUS_CODE | VARCHAR2 | 32 | Status of the Document created in the execution system | DW_DOS_STATUS_D | STATUS_CODE | ||
SUPPLY_TRACKING_LINE_DOCUMENT_CREATION_DATE | DATE | indicates the date of the creation of the Document table row. | DW_DAY_D | CALENDAR_DATE | |||
SUPPLY_TRACKING_LINE_DOCUMENT_CREATION_TIMESTAMP | TIMESTAMP | indicates the date and time of the creation of the Document table row. | |||||
SUPPLY_TRACKING_LINE_DOCUMENT_ACTIVE_FLAG | NUMBER | 38 | 0 | Flag to identify latest status of a document line. Either 1 or 0. document type, document id and document line id combination will have only one record with value 1. | |||
SUPPLY_STATUS_CODE | VARCHAR2 | 32 | Status of the supply for the fulfillment line. | DW_ORA_DOO_SUPPLY_STATUS_CODE_LKP_TL | ORA_DOO_SUPPLY_STATUS_CODE_CODE | ||
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 |
#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