DW_GL_VARIANCES_CA

This view contains Aggregated information about both the Budget balance data as well as the GL balance Actual data.

Details

Module: General Ledger

Key Columns

TRANSACTION_CURRENCY_CODE, NTRL_ACNT_SGMNT_VALUESET_CODE, COST_CENTER_VALUESET_CODE, GL_BLNC_SGMNT_VALUESET_CODE, NATURAL_ACCOUNT_SEGMENT, FISCAL_PERIOD_NAME, ACCOUNTING_SCENARIO_CODE, LEDGER_ID, CURRENCY_TYPE, GL_BALANCING_SEGMENT, COST_CENTER_SEGMENT, LEGAL_ENTITY_ID, FISCAL_PERIOD_SET_NAME

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ACCOUNTING_SCENARIO_CODE VARCHAR2 128   True Name of the accounting budget.    
LEDGER_ID NUMBER 38 0 True Ledger identifier of Oracle Fusion General Ledger. DW_LEDGER_D LEDGER_ID
FISCAL_PERIOD_NAME VARCHAR2 64   True Accounting period name of Oracle Fusion General Ledger. DW_FISCAL_DAY_D FISCAL_PERIOD_NAME
FISCAL_PERIOD_SET_NAME VARCHAR2 16   True Set of accounting periods defined by a party to quantify the fiscal position of the business. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
CURRENCY_TYPE VARCHAR2 64   True Currency type.    
TRANSACTION_CURRENCY_CODE VARCHAR2 16   True Functional currency code of the transaction.    
COST_CENTER_SEGMENT VARCHAR2 32   True Cost center segment. DW_COST_CENTER_D COST_CENTER_SEGMENT
COST_CENTER_VALUESET_CODE VARCHAR2 64   True Cost center value set code. DW_COST_CENTER_D COST_CENTER_VALUESET_CODE
GL_BALANCING_SEGMENT VARCHAR2 32   True Balancing segment. DW_BALANCING_SEGMENT_D GL_BALANCING_SEGMENT
GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64   True Balancing segment value set code. DW_BALANCING_SEGMENT_D GL_BLNC_SGMNT_VALUESET_CODE
LEGAL_ENTITY_ID NUMBER 38 0 True Legal entity identifier. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
NATURAL_ACCOUNT_SEGMENT VARCHAR2 32   True Natural account segment. DW_NATURAL_ACCOUNT_D NATURAL_ACCOUNT_SEGMENT
NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64   True Natural account value set code. DW_NATURAL_ACCOUNT_D NTRL_ACNT_SGMNT_VALUESET_CODE
SOURCE_RECORD_ID VARCHAR2 999          
GBL_CURRENCY_CODE VARCHAR2 16     Global currency code of the General Ledger.    
TRXN_CRNC_PRD_NET_ACTIVITY BIGDECIMAL   10   Accounting period net amount in trxn currency.    
TRXN_CRNC_PRD_NET_ACTIVITY_CR BIGDECIMAL   10   Accounting period net credit in trxn currency.    
TRXN_CRNC_PRD_NET_ACTIVITY_DR BIGDECIMAL   10   Accounting period net debit in trxn currency.    
TRXN_CRNC_PRD_END_BALANCE BIGDECIMAL   10   Accounting period end balance.    
GBL_CRNC_PRD_NET_ACTIVITY BIGDECIMAL   10   Accounting period net amount in global currency.    
GBL_CRNC_PRD_NET_ACTIVITY_CR BIGDECIMAL   10   Accounting period net credit in global currency.    
GBL_CRNC_PRD_NET_ACTIVITY_DR BIGDECIMAL   10   Accounting period net debit in global currency.    
GBL_CRNC_PRD_END_BALANCE BIGDECIMAL   10   Accounting period end balance in global currency.    

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