DW_CMR_RCPT_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 Receipt

Details

Module: Purchasing

Key Columns

CMR_ACCR_RECONC_HEADER_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CMR_ACCR_RECONC_HEADER_ID NUMBER 38 0 True Receipt accounting accrual reconciliation header identifier.    
SOURCE_RECORD_ID VARCHAR2 64     This column is for Oracle Internal use only. System    
CMR_PO_DISTRIBUTION_ID NUMBER 38 0   Identifies an entity in Receipt accounting PO Distributions    
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
PO_EVENT_DATE DATE       Latest event date of purchase order distribution #2 DW_DAY_D CALENDAR_DATE
INVENTORY_ITEM_ID NUMBER 38 0   Inventory Item Identifier on the purchase order line #1 DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID
INVENTORY_ORGANIZATION_ID NUMBER 38 0   Inventory organization identifier. DW_INTERNAL_ORG_D ORGANIZATION_ID
ITEM_DESCRIPTION VARCHAR2 256     Item description.    
BILL_TO_BUSINESS_UNIT_ID NUMBER 38 0   Bill to business unit identifier where invoice is created. DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
PRIMARY_LEDGER_ID NUMBER 38 0   Ledger identifier associated with Deliver 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
DELIVER_TO_BUSINESS_UNIT_ID NUMBER 38 0   Business unit of the deliver to organization 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       Net posted Accrual Amount by CMR to SLA.    
LEDGER_INVOICE_AMOUNT NUMBER       Net posted Accrual Amount by Account Payables to SLA.    
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       Net received quantity as reported by receipt accounting.    
PO_TXN_INVOICED_QTY NUMBER       Invoice quantity as reported by accounts payable.    
PUOM_CODE VARCHAR2 32     1. Primary UOM code for regular items 2. Base UOM code for description based items 3. Not Available for Service Based/Amount Based items 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    

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 PO_EVENT_DATE column

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