DW_CMR_PERIOD_END_ACCRUAL_BALANCES_CF (Preview)

This table requires activation of Receipt Accounting functional area. This fact table stores Accrual balances for all purchase order distributions with Acrrual at period end

Details

Module: Purchasing

Key Columns

PERIOD_START_DATE, CMR_PO_DISTRIBUTION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CMR_PO_DISTRIBUTION_ID NUMBER 38 0 True Internal identifier of the purchase order distribution.    
PERIOD_START_DATE DATE     True Date when the accounting period begins. #2 DW_DAY_D CALENDAR_DATE
SOURCE_RECORD_ID VARCHAR2 64     This column is for Oracle Internal use only. System    
PERIOD_END_DATE DATE       Date when the accounting period ends. DW_DAY_D CALENDAR_DATE
PERIOD_NAME VARCHAR2 16     Fiscal period name    
PO_HEADER_ID NUMBER 38 0   Purchase order header identifier of source PO    
PO_NUMBER VARCHAR2 64     Purchase order number    
PO_LINE_ID NUMBER 38 0   Purchase order line identifier    
PO_LINE_NUMBER VARCHAR2 64     Purchase order line number    
PO_LINE_LOCATION_ID NUMBER 38 0   Purchase order schedule identifier    
PO_SCHEDULE_NUMBER VARCHAR2 64     Purchase order schedule number    
PO_DISTRIBUTION_ID NUMBER 38 0   Purchase order distribution identifier    
PO_DISTRIBUTION_NUMBER VARCHAR2 64     Purchase order distribution number    
SUPPLIER_ID NUMBER 38 0   Identifies the Supplier DW_PARTY_D SUPPLIER_ID
SUPPLIER_SITE_ID NUMBER 38 0   Identifies the Supplier site DW_SUPPLIER_SITE_D SUPPLIER_SITE_ID
INVENTORY_ORGANIZATION_ID NUMBER 38 0   Inventory organization id where the item is stored DW_INTERNAL_ORG_D ORGANIZATION_ID
INVENTORY_ITEM_ID NUMBER 38 0   Inventory item identifier, it will be null for description based item #1 DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID
ITEM_DESCRIPTION VARCHAR2 256     Item description.    
BILL_TO_BUSINESS_UNIT_ID NUMBER 38 0   Business unit that will create the invoice for the purchase. DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
PRIMARY_LEDGER_ID NUMBER 38 0   Ledger identifier associated with Bill to business unit DW_LEDGER_D LEDGER_ID
FISCAL_PERIOD_SET_NAME VARCHAR2 16     Name of the accounting calendar. #2 DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE VARCHAR2 16     Accounting period type. Examples are Weekly, Monthly, Quarterly. #2 DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
PROFIT_CENTER_BUSINESS_UNIT_ID NUMBER 38 0   Profit Center Business Unit identifier DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
LEDGER_CURRENCY_CODE VARCHAR2 16     Ledger currency code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
LEDGER_ACCRUED_AMOUNT NUMBER       Accrued amount in ledger currency    
LEDGER_INVOICE_AMOUNT NUMBER       Invoice amount in ledger currency    
GLOBAL_CURRENCY_CODE VARCHAR2 16     Global currency code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
GLOBAL_EXCHANGE_RATE NUMBER       Ledger to Global currency conversion rate    
GLOBAL_ACCRUED_AMOUNT NUMBER       Accrued amount in global currency    
GLOBAL_INVOICE_AMOUNT NUMBER       Invoice amount in global currency    
PO_TXN_UOM_CODE VARCHAR2 32     Unit of Measure code of Purchase order DW_UNIT_OF_MEASURE_D_TL UOM_CODE
PO_TXN_RECEIVED_QTY NUMBER       Accrued quantity in purchase order unit of measure    
PO_TXN_INVOICED_QTY NUMBER       Invoiced quantity in purchase order unit of measure    
PUOM_CODE VARCHAR2 32     Primary UOM code DW_UNIT_OF_MEASURE_D_TL UOM_CODE
PUOM_CONVERSION_FACTOR NUMBER       Purchase order UOM to Primary UOM conversion factor    
PUOM_RECEIVED_QTY NUMBER       Accrued quantity in primary unit of measure    
PUOM_INVOICED_QTY NUMBER       Invoiced quantity in primary unit of measure    
LEDGER_OPEN_ACCRUAL_BALANCE_AMOUNT NUMBER       Open Accrual Balance in ledger currency    
GLOBAL_OPEN_ACCRUAL_BALANCE_AMOUNT NUMBER       Open Accrual Balance in global currency    
PO_TXN_UNINVOICED_QTY NUMBER       Un-invoiced Quantity in purchase order unit of measure    
PUOM_UNINVOICED_QTY NUMBER       Un-invoiced Quantity in primary unit of measure    

Notes

#1 For join with Item Dimension along with INVENTORY_ITEM_ID also join on column INVENTORY_ORGANIZATION_ID. #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 PERIOD_START_DATE column

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