This table requires activation of Draft Order Management functional area. Draft Fulfillment Lines and charge components Fact - Stores all draft Fulfillment line and charge components information at Fulfillment line and components level
Module: Order Management
FULFILL_LINE_ID, ORDER_CHARGE_COMPONENT_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 | ||
ORDER_CHARGE_COMPONENT_ID | NUMBER | 38 | 0 | True | Unique Identifier of Charge Components | ||
SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. System Identifier | ||||
ORDER_CHARGE_ID | NUMBER | 38 | 0 | Unique Identifier of Charges | |||
CHARGE_DEFINITION_ID | NUMBER | 38 | 0 | Indicates the primary key for the pricing charge definition | DW_QP_CHARGE_DEFINITIONS_TL | CHARGE_DEFINITION_ID | |
CHARGE_DEFINITION_CODE | VARCHAR2 | 32 | A charge definition is a combination of Price Type, Charge Type, Charge Sub Type. Combination of these three attributes is represented as a single code | ||||
CHARGE_TYPE_CODE | VARCHAR2 | 32 | Type of a given charge. Charge Types could include Goods Sale, Service Sale, Financing vs. Lease, Shipping-related Charges, Restocking Penalties, Special Charges) | DW_ORA_QP_CHARGE_TYPES_LKP_TL | ORA_QP_CHARGE_TYPES_CODE | ||
CHARGE_SUBTYPE_CODE | VARCHAR2 | 32 | Subtype of a given charge type. Examples could include, within Shipping Related Charges: Freight Charge, Shipping Insurance, within Special Charges: Suspend Charge, Resumption Charge) | DW_ORA_QP_CHARGE_SUBTYPES_LKP_TL | ORA_QP_CHARGE_SUBTYPES_CODE | ||
CHARGE_PRICE_TYPE_CODE | VARCHAR2 | 32 | Price type of a given charge. One-time, Recurring, Usage,Recurring usage. | DW_ORA_QP_PRICE_TYPES_LKP_TL | ORA_QP_PRICE_TYPES_CODE | ||
CHARGE_APPLIES_TO | VARCHAR2 | 32 | Indicates whether a charge is applied to Product, Shipping or Return | DW_ORA_QP_CHARGE_DEF_TYPES_LKP_TL | ORA_QP_CHARGE_DEF_TYPES_CODE | ||
CHARGE_ROLLUP_FLAG | VARCHAR2 | 16 | Marks a charge as a rollup/aggregate charge | DW_DOO_COMMON_YES_NO_NA_LKP_TL | DOO_COMMON_YES_NO_NA_CODE | ||
CHARGE_SEQUENCE_NUMBER | NUMBER | 38 | 0 | Sequence number of the charge | |||
CHARGE_COMPONENT_PRICE_ELEMENT_ID | NUMBER | 38 | 0 | Indicates the Id of the price element | DW_QP_PRICE_ELEMENTS_TL | PRICE_ELEMENT_ID | |
CHARGE_COMPONENT_PRICE_ELEMENT_CODE | VARCHAR2 | 32 | Element reference to the Price Elements setup e.g.. LISTPRICE, NETPRICE etc. | ||||
CHARGE_COMPONENT_PRICE_ELEMENT_USAGE_CODE | VARCHAR2 | 32 | Indicate how the charge component will be used. Values will come from a QP lookup. OOTB, the values will include "List Price" and "Invoice Price". | DW_ORA_QP_ELEMENT_USAGES_LKP_TL | ORA_QP_ELEMENT_USAGES_CODE | ||
CHARGE_COMPONENT_EXPLANATION | VARCHAR2 | 999 | Message for display in a price breakdown or price waterfall UI. | ||||
CHARGE_COMPONENT_SEQUENCE_NUMBER | NUMBER | 38 | 0 | Sequence number of the charge component | |||
CURRENCY_CODE | VARCHAR2 | 32 | Currency code captured at the order header level | ||||
CHARGE_COMPONENT_UNIT_PRICE | NUMBER | Indicates the price or adjustment per unit in the header currency for the line UOM | |||||
CHARGE_COMPONENT_EXTENDED_AMOUNT | NUMBER | Indicates the extended amount in header currency | |||||
GLOBAL_CURRENCY_CODE | VARCHAR2 | 32 | Analytics currency code | ||||
GLOBAL_CURRENCY_EXCH_RATE | NUMBER | Transaction to Global currency exchange rate | |||||
GLOBAL_CHARGE_COMPONENT_UNIT_PRICE | NUMBER | Indicates the price or adjustment per unit in the header currency for the line UOM in global currency | |||||
GLOBAL_CHARGE_COMPONENT_EXTENDED_AMOUNT | NUMBER | Indicates the extended global amount in header currency | |||||
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 | |
LEGAL_ENTITY_ID | NUMBER | 38 | 0 | Legal entity identifier | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID | |
ORDER_TYPE_CODE | VARCHAR2 | 32 | Name of the type of order that was placed. Stores codes for values of order types. | DW_ORDER_TYPE_LKP_TL | ORDER_TYPE_CODE | ||
ORDER_STATUS_CODE | VARCHAR2 | 32 | Status of the order. | DW_OM_STATUS_D | STATUS_CODE | ||
LINE_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 | ||
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 | ||||
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 | |||
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(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 | |
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 | ||
ORDERED_DATE | DATE | Date when the items where ordered | DW_DAY_D | CALENDAR_DATE | |||
ORDERED_TIMESTAMP | TIMESTAMP | Date when the items where ordered | |||||
SHIPPABLE_FLAG | VARCHAR2 | 16 | Indicates whether a fulfillment line can be shipped to a customer | ||||
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 | ||
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 | ||
UNREFERENCED_RETURN_FLAG | VARCHAR2 | 16 | Identify return that does not include a reference order. | ||||
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 | ||
ORDER_CREATION_DATE | DATE | order creation date | DW_DAY_D | CALENDAR_DATE | |||
ORDER_CREATION_TIMESTAMP | TIMESTAMP | order creation date with timestamp | |||||
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. | ||||
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 | |
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 | ||||
PUOM_CODE | VARCHAR2 | 16 | Primary Unit of measure of the Item used for the transaction | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE | ||
PUOM_CONVERSION_FACTOR | NUMBER | Primary UOM conversion factor | |||||
TRX_UOM | VARCHAR2 | 16 | Unit of measure of the Item used for the transaction | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE | ||
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 |
#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, 2024, Oracle and/or its affiliates.