# 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

Copyright © 2019, 2026, Oracle and/or its affiliates.