DW_CMR_PERIOD_END_ACCRUAL_BALANCES_CF (Preview)

This table requires activation of Procurement Receipt Accounting functional area. This fact table stores Accrual Balances for all Purchase Order Distributions with Accrual 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
DEFAULT_ACCRUAL_ACCOUNT_ID NUMBER 38 0 Code Combination Identifier of the Default Accrual Account DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
DEFAULT_ACCRUAL_ACCOUNT_GL_BALANCING_SEGMENT VARCHAR2 32 Balancing segment. DW_BALANCING_SEGMENT_D GL_BALANCING_SEGMENT
DEFAULT_ACCRUAL_ACCOUNT_GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64 Balancing segment value set code. DW_BALANCING_SEGMENT_D GL_BLNC_SGMNT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_COST_CENTER_SEGMENT VARCHAR2 32 Cost center segment. DW_COST_CENTER_D COST_CENTER_SEGMENT
DEFAULT_ACCRUAL_ACCOUNT_COST_CENTER_VALUESET_CODE VARCHAR2 64 Cost center value set code. DW_COST_CENTER_D COST_CENTER_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_NATURAL_ACCOUNT_SEGMENT VARCHAR2 32 Natural account segment. DW_NATURAL_ACCOUNT_D NATURAL_ACCOUNT_SEGMENT
DEFAULT_ACCRUAL_ACCOUNT_NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64 Natural account value set code. DW_NATURAL_ACCOUNT_D NTRL_ACNT_SGMNT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT1 VARCHAR2 32 Accounting segment 1. DW_GL_SEGMENT1_D GL_SEGMENT_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT1_VALUESET_CODE VARCHAR2 64 Accounting segment 1 value set code. DW_GL_SEGMENT1_D GL_SEGMENT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT2 VARCHAR2 32 Accounting segment 2. DW_GL_SEGMENT2_D GL_SEGMENT_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT2_VALUESET_CODE VARCHAR2 64 Accounting segment 2 value set code. DW_GL_SEGMENT2_D GL_SEGMENT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT3 VARCHAR2 32 Accounting segment 3. DW_GL_SEGMENT3_D GL_SEGMENT_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT3_VALUESET_CODE VARCHAR2 64 Accounting segment 3 value set code. DW_GL_SEGMENT3_D GL_SEGMENT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT4 VARCHAR2 32 Accounting segment 4. DW_GL_SEGMENT4_D GL_SEGMENT_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT4_VALUESET_CODE VARCHAR2 64 Accounting segment 4 value set code. DW_GL_SEGMENT4_D GL_SEGMENT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT5 VARCHAR2 32 Accounting segment 5. DW_GL_SEGMENT5_D GL_SEGMENT_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT5_VALUESET_CODE VARCHAR2 64 Accounting segment 5 value set code. DW_GL_SEGMENT5_D GL_SEGMENT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT6 VARCHAR2 32 Accounting segment 6. DW_GL_SEGMENT6_D GL_SEGMENT_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT6_VALUESET_CODE VARCHAR2 64 Accounting segment 6 value set code. DW_GL_SEGMENT6_D GL_SEGMENT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT7 VARCHAR2 32 Accounting segment 7. DW_GL_SEGMENT7_D GL_SEGMENT_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT7_VALUESET_CODE VARCHAR2 64 Accounting segment 7 value set code. DW_GL_SEGMENT7_D GL_SEGMENT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT8 VARCHAR2 32 Accounting segment 8. DW_GL_SEGMENT8_D GL_SEGMENT_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT8_VALUESET_CODE VARCHAR2 64 Accounting segment 8 value set code. DW_GL_SEGMENT8_D GL_SEGMENT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT9 VARCHAR2 32 Accounting segment 9. DW_GL_SEGMENT9_D GL_SEGMENT_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT9_VALUESET_CODE VARCHAR2 64 Accounting segment 9 value set code. DW_GL_SEGMENT9_D GL_SEGMENT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT10 VARCHAR2 32 Accounting segment 10. DW_GL_SEGMENT10_D GL_SEGMENT_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT10_VALUESET_CODE VARCHAR2 64 Accounting segment 10 value set code. DW_GL_SEGMENT10_D GL_SEGMENT_VALUESET_CODE

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