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 This column is for Oracle Internal use only. 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