Fulfillment Lines Fact - Stores all Fulfillment line information at Fulfillment line level with metrics in transactional, Ledger, and global currency values
Module: Order Management
FULFILL_LINE_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 | ||
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 | |
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 | 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 #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 | ||
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_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 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 | ||
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 | ||
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