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

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