DW_GL_JOURNAL_CA

This table contains information about journal entries aggregated on few attributes.

Details

Module: General Ledger

Key Columns

LEDGER_ID, GL_BALANCING_SEGMENT, JOURNAL_LINE_STATUS, FISCAL_PERIOD_NAME, NATURAL_ACCOUNT_SEGMENT, COST_CENTER_SEGMENT, COST_CENTER_VALUESET_CODE, TRANSACTION_CURRENCY_CODE, GL_BLNC_SGMNT_VALUESET_CODE, NTRL_ACNT_SGMNT_VALUESET_CODE, FISCAL_PERIOD_SET_NAME, LEGAL_ENTITY_ID, DEBIT_CREDIT_IND

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
FISCAL_PERIOD_SET_NAME VARCHAR2 16   True Accounting calendar name. DW_FISCAL_PERIOD_D FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_NAME VARCHAR2 16   True Accounting period name. DW_FISCAL_PERIOD_D FISCAL_PERIOD_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. 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
JOURNAL_LINE_STATUS VARCHAR2 16   True Journal entry line status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=GL_JOURNAL_STATUS. Possible values are U or P. DW_CODE_VALUES_LKP_TL CODE
TRANSACTION_CURRENCY_CODE VARCHAR2 16   True Transaction currency code.    
DEBIT_CREDIT_IND VARCHAR2 32   True Indicates debit or credit.    
SOURCE_RECORD_ID VARCHAR2 999     Source record identifier.    
LEDGER_CURRENCY_CODE VARCHAR2 16     Ledger currency code.    
GLOBAL_CURRENCY_CODE VARCHAR2 16     Global currency code.    
TRANSACTION_CURRENCY_AMOUNT NUMBER       Amount in transaction currency.    
LEDGER_CURRENCY_AMOUNT NUMBER       Amount in ledger currency.    
GLOBAL_CURRENCY_AMOUNT NUMBER       Amount in global currency.    
JOURNAL_LINE_ENTERED_DR NUMBER       Journal entry line debit amount in entered currency.    
JOURNAL_LINE_ENTERED_CR NUMBER       Journal entry line credit amount in entered currency.    
JOURNAL_LINE_ACCOUNTED_DR NUMBER       Journal entry line debit amount in base currency.    
JOURNAL_LINE_ACCOUNTED_CR NUMBER       Journal entry line credit amount in base currency.    
JOURNAL_LINE_GLOBAL_DR NUMBER       Journal entry line debit amount in global currency.    
JOURNAL_LINE_GLOBAL_CR NUMBER       Journal entry line credit amount in global currency.