DW_OM_DRAFT_FULFILLMENT_CHARGE_COMPONENTS_CF (Preview)

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

Details

Module: Order Management

Key Columns

ORDER_CHARGE_COMPONENT_ID, 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
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

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