DW_PROJECTED_GROSS_MARGIN_DETAILS_CF (Preview)

This table requires activation of Projected COGS and Gross Margin functional area. This fact table contains the projected cost of goods sold and gross margin details.

Details

Module: Cost 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 Sales Order Fulfillment Line
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. System generated
ORDER_HEADER_ID NUMBER 38 0 Unique Identifier for a Sales Order Header
ORDER_NUMBER VARCHAR2 64 Sales Order Number
ORDER_TYPE_CODE VARCHAR2 64 Order Type Code DW_ORDER_TYPE_LKP_TL ORDER_TYPE_CODE
LINE_NUMBER NUMBER 38 0 Sales Order Line number
LINE_ID NUMBER 38 0 Unique Identifier for a Sales Order Line
FULFILL_DISPLAY_LINE_NUMBER VARCHAR2 256 Fulfill Line number for display purposes. Corresponds to the Fulfill line number on UI.
SUBMITTED_DATE DATE Sales Order Submit date #2 DW_DAY_D CALENDAR_DATE
CREATION_DATE DATE Fulfill line creation date DW_DAY_D CALENDAR_DATE
CREATION_TIMESTAMP TIMESTAMP Fulfill line creation date with timestamp
LAST_UPDATE_DATE DATE Fulfill line Last Update Date DW_DAY_D CALENDAR_DATE
LAST_UPDATE_TIMESTAMP TIMESTAMP Fulfill line Last Update Date with timestamp
PROFIT_CENTER_BUSINESS_UNIT_ID NUMBER 38 0 Fulfill Line Profit Center Business Unit Identifier DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
INVENTORY_ORG_ID NUMBER 38 0 Fulfill Org - Used for association with "Inv Org Item Cost Fact" - Organisation DW_INTERNAL_ORG_D ORGANIZATION_ID
INVENTORY_ORG_BUSINESS_UNIT_ID NUMBER 38 0 Fulfill Org business unit identifier DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
INVENTORY_ITEM_ID NUMBER 38 0 Reference to the unique identifier for the inventory item #1 DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID
BILL_TO_CUSTOMER_ACCOUNT_ID NUMBER 38 0 Reference to the unique identifier for the bill-to customer on fulfillment line level DW_CUSTOMER_ACCOUNT_D CUSTOMER_ACCOUNT_ID
BILL_TO_PARTY_ID NUMBER 38 0 References to the unique identifier for bill to party on fulfillment line level DW_PARTY_D PARTY_ID
SHIP_TO_PARTY_ID NUMBER 38 0 Reference to the unique identifier for ship-to Party on fulfillment line level DW_PARTY_D PARTY_ID
COST_ORG_ID NUMBER 38 0 Cost Org identifier DW_CST_COST_ORG_BOOKS_D COST_ORG_ID
COST_BOOK_ID NUMBER 38 0 Primary Cost Book identifier DW_CST_COST_ORG_BOOKS_D COST_BOOK_ID
COST_ORG_LEGAL_ENTITY_ID NUMBER 38 0 Reference to Legal Entity ID associated to the Cost Org DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
COST_ORG_LEDGER_ID NUMBER 38 0 Referenced to Ledger identifier associated to the Cost Book DW_LEDGER_D LEDGER_ID
FISCAL_PERIOD_TYPE VARCHAR2 16 Accounting period type based on Primary Cost Book Ledger.#2 DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
FISCAL_PERIOD_SET_NAME VARCHAR2 16 Accounting calendar name based on Primary Cost Book Ledger.#2 DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
TRX_UOM_CODE VARCHAR2 16 SO Header Transaction UOM DW_UNIT_OF_MEASURE_D_TL UOM_CODE
ORDERED_QTY NUMBER Sales Order Fulfill Line ordered quantity in Transaction UOM
TRX_CURRENCY_CODE VARCHAR2 32 Transaction Currency DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
UNIT_SELLING_PRICE NUMBER Unit selling price in sales order transaction currency for transaction UOM - Aggregated from Charge Components where Price Element is of type NETPAY
PRIMARY_UOM_CODE VARCHAR2 16 Primary UOM DW_UNIT_OF_MEASURE_D_TL UOM_CODE
PUOM_ORDERED_QTY NUMBER Sales Order Fulfill Line ordered quantity in Primary UOM
LEDGER_CURRENCY_CODE VARCHAR2 32 Cost Book Ledger Currency code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
TRX_CURRENCY_TO_GLOBAL_CURRENCY_EXCH_RATE NUMBER Sales Order Transaction Currency to Global/Analytical Currency Exchange Rate
LEDGER_TO_GLOBAL_CURRENCY_EXCH_RATE NUMBER Currency Exchange rate from Ledger to Analytical currency
TRX_CURRENCY_TO_LEDGER_CURRENCY_EXCH_RATE NUMBER Sales Order Transaction Currency to Ledger Currency Exchange Rate
TRX_UOM_TO_PUOM_CONVERSION_FACTOR NUMBER Sales Order Transaction UOM to Primary UOM Conversion Factor
LEDGER_PUOM_UNIT_SELLING_PRICE NUMBER Unit selling price in Cost Book Ledger Currency for Primary UOM
COSTING_UOM_CODE VARCHAR2 16 Costing UOM DW_UNIT_OF_MEASURE_D_TL UOM_CODE
COSTING_UOM_TO_PUOM_CONVERSION_FACTOR NUMBER Costing UOM to Primary UOM Conversion Factor
UNIT_COST NUMBER Indicates the unit cost in Primary cost book ledger currency in costing UOM at item and inventory org level
LEDGER_PUOM_UNIT_COST NUMBER Unit cost in Ledger currency for primary UOM at item and inventory org level
GLOBAL_CURRENCY_CODE VARCHAR2 32 Global/analytics currency code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
GLOBAL_PUOM_UNIT_SELLING_PRICE NUMBER Global Currency unit selling price for primary UOM
GLOBAL_PUOM_UNIT_COST NUMBER Unit cost in global/analytical currency for primary UOM at item and inventory org level
PROJECTED_COGS_AMOUNT NUMBER Projected cogs amount in ledger currency for primary UOM
PROJECTED_REVENUE NUMBER Projected revenue amount in ledger currency for primary UOM
PROJECTED_GROSS_MARGIN NUMBER Projected gross margin in ledger currency for primary UOM
GLOBAL_PROJECTED_COGS_AMOUNT NUMBER Projected cogs amount in global currency for primary UOM
GLOBAL_PROJECTED_REVENUE NUMBER Projected revenue in global currency for primary UOM
GLOBAL_PROJECTED_GROSS_MARGIN NUMBER Projected gross margin in global currency for primary UOM

Notes

#1 In these cases in addition to the item columns INVENTORY_ORG_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 SUBMITTED_DATE column