DW_GL_BALANCE_CA

This table contains information about aggregated metrics for GL.

Details

Module: General Ledger

Key Columns

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

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
FISCAL_PERIOD_NAME VARCHAR2 64   True Accounting period name. DW_FISCAL_PERIOD_D FISCAL_PERIOD_NAME
FISCAL_PERIOD_SET_NAME VARCHAR2 16   True Accounting calendar name. DW_FISCAL_PERIOD_D FISCAL_PERIOD_SET_NAME
LEDGER_ID NUMBER 38 0 True Ledger identifier. DW_LEDGER_D LEDGER_ID
LEGAL_ENTITY_ID NUMBER 38 0 True Legal entity identifier. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
GL_BALANCING_SEGMENT VARCHAR2 32   True Balancing segment for the ledger. 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
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
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
TRANSACTION_CURRENCY_CODE VARCHAR2 64   True Transaction currency code.    
TRANSLATED_FLAG VARCHAR2 16   True Indicates currency translation.    
CURRENCY_TYPE VARCHAR2 64   True Currency type.    
SOURCE_RECORD_ID VARCHAR2 999     Source record identifier.    
LEDGER_CURRENCY_CODE VARCHAR2 16     Ledger currency code.    
GBL_CURRENCY_CODE VARCHAR2 16     Global currency code.    
TRXN_CRNC_PRD_NET_ACTIVITY BIGDECIMAL   10   Accounting period net balance.    
TRXN_CRNC_PRD_NET_ACTIVITY_CR BIGDECIMAL   10   Accounting period net credit.    
TRXN_CRNC_PRD_NET_ACTIVITY_DR BIGDECIMAL   10   Accounting period net debit.    
TRXN_CRNC_PRD_END_BALANCE BIGDECIMAL   10   Accounting period end balance.    
TRXN_CRNC_PRD_END_BALANCE_CR BIGDECIMAL   10   Accounting period end credit.    
TRXN_CRNC_PRD_END_BALANCE_DR BIGDECIMAL   10   Accounting period end debit.    
LDGR_CRNC_PRD_NET_ACTIVITY BIGDECIMAL   10   Accounting period net balance in ledger currency.    
LDGR_CRNC_PRD_NET_ACTIVITY_CR BIGDECIMAL   10   Accounting period net credit in ledger currency.    
LDGR_CRNC_PRD_NET_ACTIVITY_DR BIGDECIMAL   10   Accounting period net debit in ledger currency.    
LDGR_CRNC_PRD_END_BALANCE BIGDECIMAL   10   Accounting period end balance in ledger currency.    
LDGR_CRNC_PRD_END_BALANCE_CR BIGDECIMAL   10   Accounting period end credit in ledger currency.    
LDGR_CRNC_PRD_END_BALANCE_DR BIGDECIMAL   10   Accounting period end debit in ledger currency.    
GBL_CRNC_PRD_NET_ACTIVITY BIGDECIMAL   10   Accounting period net balance 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.    
GBL_CRNC_PRD_END_BALANCE_CR BIGDECIMAL   10   Accounting period end credit in global currency.    
GBL_CRNC_PRD_END_BALANCE_DR BIGDECIMAL   10   Accounting period end debit in global currency.    

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