DW_OM_FULFILLMENT_CF

Fulfillment Lines Fact - Stores all Fulfillment line information at Fulfillment line level with metrics in transactional, Ledger, and global currency values

Details

Module: Order Management

Key Columns

FULFILL_LINE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
FULFILL_LINE_ID NUMBER 38 0 True Unique Identifier for a fulfillment line    
SOURCE_RECORD_ID VARCHAR2 128     System Identifier    
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. 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
FULFILLMENT_MODE VARCHAR2 32     It captures the fulfillment mode codes. The lookup can have the below 3 values for Regular Order Fulfill Lines (Not applicable for Return Fulfill lines) - Regular, DropShip, Back to Back DW_ORDER_FULFILL_MODE_LKP_TL FULFILLMENT_MODE_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    
SPLIT_FROM_FLINE_ID NUMBER 38 0   Reference to the original fulfillment line in the event that splits occur    
SPLIT_FLINE_FLAG VARCHAR2 16     Indicates if the fulfill line is split and if it is original or a result of splitting from another line. The values - 'O' stands for the original line in an order from which there are split lines, 'C' indicates the split lines or the child lines, 'N' referes to the lines which have no association with split    
PARENT_SPLIT_LINE_FLAG VARCHAR2 16     Indicates if the fulfill line is split into atleast one further line    
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 #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
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
PAYMENT_TERM_ID NUMBER 38 0   Identifies the AR payment term associated with the Payment terms DW_AR_PAYMENT_TERMS_D PAYMENT_TERM_ID
COVERED_FULFILL_LINE_ID NUMBER 38 0   Fulfill line ID of the item for which coverage is required within the order    
COVERED_INVENTORY_ITEM_ID NUMBER 38 0   Inventory Item id of the item that is covered #1 DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID
COVERED_ORDER_NUMBER VARCHAR2 64     Order number of the item that is covered    
COVERED_LINE_DISPLAY_LINE_NUM VARCHAR2 128     Line Display line number of the item line that is covered    
COVERED_FLINE_DISPLAY_LINE_NUM VARCHAR2 128     Fulfill line Display line number of the item line that is covered    
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 #1 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 #1 DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID
TRX_UOM VARCHAR2 16     Unit of measure of the Item used for the transaction DW_UNIT_OF_MEASURE_D_TL UOM_CODE
DEMAND_CLASS_CODE VARCHAR2 32     Demand Class used by the promise engine to consume target allocation amounts. This helps identify different market and customer segments. DW_DEMAND_CLASS_LKP_TL DEMAND_CLASS_CODE
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. 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_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    
INVOICEABLE_ITEM_FLAG VARCHAR2 16     This fulfillment line has an item that is enabled for billing or invoicing    
INVOICE_ENABLED_FLAG VARCHAR2 16     Indicator implying the line / item qualifies for billing    
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    
DOCUMENT_CURRENCY_CODE VARCHAR2 32     Currency code captured at the order header level    
GLOBAL_CURRENCY_CODE VARCHAR2 32     Analytics currency code    
GLOBAL_CURRENCY_EXCH_RATE NUMBER       Transaction to Global currency exchange rate    
ORDERED_QTY NUMBER       The quantity of a good or service ordered    
PUOM_ORDERED_QTY NUMBER       The quantity in Primary Unit of Measure of a good or service ordered    
RESERVED_QTY NUMBER       Quantity of an item that was set aside in a warehouse specifically to fulfill the demand from a given fulfillment line    
PUOM_RESERVED_QTY NUMBER       Quantity in Primary Unit of Measure of an item that was set aside in a warehouse specifically to fulfill the demand from a given fulfillment line    
TRX_UNIT_SELLING_PRICE NUMBER       The price per unit that a buyer paid for an item in transaction uom    
TRX_UNIT_LIST_PRICE NUMBER       The base selling price before applying discounts. It typically defaults from the item definition    
TRX_FLINE_AMT NUMBER       Total amount to be paid by a customer for every fulfill line. (Unit selling price x ordered quantity) whether return or general orders    
TRX_ORDER_AMT NUMBER       Total amount to be paid by a customer for every fulfill line. (Unit selling price x ordered quantity) for general orders    
GLOBAL_UNIT_SELLING_PRICE NUMBER       In Global Currency - The price per unit that a buyer paid for an item in transaction uom    
GLOBAL_UNIT_LIST_PRICE NUMBER       In Global Currency - The base selling price before applying discounts. It typically defaults from the item definition    
GLOBAL_FLINE_AMT NUMBER       In Global Currency - Total amount to be paid by a customer for every fulfill line. (Unit selling price x ordered quantity) whether return or general orders    
GLOBAL_ORDER_AMT NUMBER       In Global Currency - Total amount to be paid by a customer for every fulfill line. (Unit selling price x ordered quantity) for general orders    
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    
SHIPPABLE_FLAG VARCHAR2 16     Indicates whether a fulfillment line can be shipped to a customer    
SHIPPED_FLAG VARCHAR2 16     Indicates whether a fulfillment line is shipped or not. Applies to Line_Category Order, based on. the Actual Ship Date being populated or not.    
SHIPPED_FROM_INVENTORY_FLAG VARCHAR2 16     Indicates if the item that is shipped is shipped from inventory. For example, the Main ATO item will be shipped from inventory and not it's options    
ON_TIME_SHIPMENT_SCH_DATE_FLAG VARCHAR2 16     Indicates if the shipment is done before the schedule ship date    
ON_TIME_SHIPMENT_REQ_DATE_FLAG VARCHAR2 16     Indicates if the shipment is done before the request ship date    
SHIPPED_IN_FULL_FLAG VARCHAR2 16     Indicates if the shipment is done as per the original order without splitting the lines    
PERFECT_ORDER_FLAG VARCHAR2 16     This is a column derived using OPEN_ORDER_FLAG and PERFECT_ORDER_LINES_FLAG. This can be used for directly aggregating at Order Grain to determine if an order is perfect or not. Logic for aggregating it would be : MIN(PERFECT_ORDER_FLAG) by ORDER_HEADER_ID    
ORDER_SHIPPED_IN_FULL_FLAG VARCHAR2 16     This is a column derived using OPEN_ORDER_FLAG and SHIPPED_IN_FULL_FLAG. This can be used for directly aggregating at Order Grain to determine if an order is Shipped in Full or Not. Logic for aggregating it would be : MIN(ORDER_SHIPPED_IN_FULL_FLAG) by ORDER_HEADER_ID    
PERFECT_ORDER_LINES_FLAG VARCHAR2 16     Indicates if the order fulfillment line was a perfect order line or not    
CARRIER_NAME VARCHAR2 512     Trading Partner Carrier Name    
MODE_OF_TRANSPORT VARCHAR2 32     Type of transportation used to ship the product, such as - Truck, Air, Boat, etc DW_WSH_TRANSPORT_MODE_LKP_TL TRANSPORT_MODE_CODE
SERVICE_LEVEL VARCHAR2 32     Priority of transportation that affects how quickly goods are transported DW_WSH_SERVICE_LEVEL_LKP_TL SERVICE_LEVEL_CODE
SHIP_SET_NAME VARCHAR2 64     Group of order lines within an order that need to ship together from their common origin to a common destination and which have the same scheduled ship date    
SHIPMENT_PRIORITY_CODE VARCHAR2 32     Indicates the priority of the fulfillment lines to be shipped. For Ex - High, low, medium DW_SHIPMENT_PRIORITY_LKP_TL SHIPMENT_PRIORITY_CODE
FOB_POINT_CODE VARCHAR2 32     Code that indicates freight on board. This indicates who owns the goods while they are in transit.For Ex - Destination, Origin, etc DW_FOB_POINT_LKP_TL FOB_POINT_CODE
FREIGHT_TERMS_CODE VARCHAR2 32     Freight Terms, specifying the responsibility for Freight charges. For Ex - Add Freight, Prepaid Frieght, etc DW_FREIGHT_CHARGE_TERMS_LKP_TL FREIGHT_CHARGE_TERMS_CODE
SHIPPED_QTY NUMBER       Quantity of product on a fulfillment line that is shipped    
PUOM_SHIPPED_QTY NUMBER       Quantity in Primary Unit of Measure of product on a fulfillment line that is shipped    
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.)    
FULFILLED_FLAG VARCHAR2 16     Indicated if the order line if fulfilled    
FULFILLED_QTY NUMBER       Quantity used to fulfill the order line    
PUOM_FULFILLED_QTY NUMBER       Quantity in Primary Unit of Measure used to fulfill the order line    
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    
CANCELLED_QTY NUMBER       Canceled Quantity    
PUOM_CANCELLED_QTY NUMBER       Canceled Quantity in Primary Unit of Measure    
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    
RETURN_LINE_FLAG VARCHAR2 16     Indicates if the fulfill line is a return line    
RETURNED_LINE_FLAG VARCHAR2 16     Indicates if the return fulfill line is closed or not    
UNREFERENCED_RETURN_FLAG VARCHAR2 16     Identify return that does not include a reference order.    
ORIGINAL_ORDER_NUMBER VARCHAR2 64     Corresponds to the original order number for which return is generated    
RETURN_ASSOCIATED_FLAG VARCHAR2 16     Indicates if the original fulfill line has a return associated with it in future    
RETURN_REASON_CODE VARCHAR2 32     Justification for a return of a specific product. Many companies have standard reasons that are assigned to returns to be used to analyze the quantity and types of returns DW_RETURN_REASON_LKP_TL RETURN_REASON_CODE
RMA_DELIVERED_QTY NUMBER       The quantity delivered against the receipt fulfill line    
PUOM_RMA_DELIVERED_QTY NUMBER       The quantity in Primary Unit of Measure delivered against the receipt fulfill line    
TRX_BILLED_AMT NUMBER       Transaction currency billed amount for a order fulfill line    
GLOBAL_BILLED_ORDER_AMT NUMBER       Global currency billed amount for a order fulfill line    
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 timestamp    
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
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
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
PURCHASING_ENABLED_FLAG VARCHAR2 16     Indicates whether the item on the fulfillment line may be included on a Purchase Order for fulfilling the underlying source order line    
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
SHIP_STATUS VARCHAR2 32     Status of a fulfillment line where the detail level task type is shipment. DW_OM_STATUS_D STATUS_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
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    

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, 2023, Oracle and/or its affiliates.