JA_CN_ACCOUNT_BALANCES_V

Details

• Schema: FUSION

• Object owner: JA

• Object type: VIEW

Columns

Name

LEDGER_ID LEGAL_ENTITY_ID BALANCING_SEGMENT PERIOD_NAME CURRENCY_CODE COST_CENTER_SEGMENT THIRD_PARTY_TYPE THIRD_PARTY_ID THIRD_PARTY_NUMBER PROJECT_ID PROJECT_NUMBER PROJECT_SOURCE NATURAL_ACCOUNT_SEGMENT PERSONNEL_ID PERSONNEL_NUMBER BEGIN_BALANCE_DR_BEQ BEGIN_BALANCE_CR_BEQ BEGIN_BALANCE_DR BEGIN_BALANCE_CR PERIOD_NET_DR_BEQ PERIOD_NET_CR_BEQ PERIOD_NET_DR PERIOD_NET_CR PERIOD_MONTH ACCOUNT_TYPE SEGMENT1 SEGMENT2 SEGMENT3 SEGMENT4 SEGMENT5 SEGMENT6 SEGMENT7 SEGMENT8 SEGMENT9 SEGMENT10 SEGMENT11 SEGMENT12 SEGMENT13 SEGMENT14 SEGMENT15 SEGMENT16 SEGMENT17 SEGMENT18 SEGMENT19 SEGMENT20 SEGMENT21 SEGMENT22 SEGMENT23 SEGMENT24 SEGMENT25 SEGMENT26 SEGMENT27 SEGMENT28 SEGMENT29 SEGMENT30 FUNC_BEGIN_BALANCE BEGIN_BALANCE FUNC_END_BALANCE_DR FUNC_END_BALANCE_CR END_BALANCE_DR END_BALANCE_CR FUNC_END_BALANCE END_BALANCE

Query

SQL_Statement

SELECT LEDGER_ID , LEGAL_ENTITY_ID , BALANCING_SEGMENT , PERIOD_NAME , CURRENCY_CODE , COST_CENTER_SEGMENT , THIRD_PARTY_TYPE , THIRD_PARTY_ID , THIRD_PARTY_NUMBER , PROJECT_ID , PROJECT_NUMBER , PROJECT_SOURCE , NATURAL_ACCOUNT_SEGMENT , PERSONNEL_ID , PERSONNEL_NUMBER , BEGIN_BALANCE_DR_BEQ , BEGIN_BALANCE_CR_BEQ , BEGIN_BALANCE_DR , BEGIN_BALANCE_CR , PERIOD_NET_DR_BEQ , PERIOD_NET_CR_BEQ , PERIOD_NET_DR , PERIOD_NET_CR , PERIOD_MONTH , account_type , SEGMENT1 , SEGMENT2 , SEGMENT3 , SEGMENT4 , SEGMENT5 , SEGMENT6 , SEGMENT7 , SEGMENT8 , SEGMENT9 , SEGMENT10 , SEGMENT11 , SEGMENT12 , SEGMENT13 , SEGMENT14 , SEGMENT15 , SEGMENT16 , SEGMENT17 , SEGMENT18 , SEGMENT19 , SEGMENT20 , SEGMENT21 , SEGMENT22 , SEGMENT23 , SEGMENT24 , SEGMENT25 , SEGMENT26 , SEGMENT27 , SEGMENT28 , SEGMENT29 , SEGMENT30 , decode(account_type,'A',nvl(BEGIN_BALANCE_DR_BEQ,0)-nvl(BEGIN_BALANCE_CR_BEQ,0) ,'E',nvl(BEGIN_BALANCE_DR_BEQ,0)-nvl(BEGIN_BALANCE_CR_BEQ,0) ,nvl(BEGIN_BALANCE_CR_BEQ,0)-nvl(BEGIN_BALANCE_DR_BEQ,0) ) func_begin_balance , decode(account_type,'A',nvl(BEGIN_BALANCE_DR,0)-nvl(BEGIN_BALANCE_cR,0) ,'E',nvl(BEGIN_BALANCE_DR,0)-nvl(BEGIN_BALANCE_cR,0) ,nvl(BEGIN_BALANCE_CR,0)-nvl(BEGIN_BALANCE_DR,0) ) begin_balance , nvl(BEGIN_BALANCE_DR_BEQ,0) + nvl(PERIOD_NET_DR_BEQ,0) func_end_balance_dr , nvl(BEGIN_BALANCE_CR_BEQ,0) + nvl(PERIOD_NET_CR_BEQ,0) func_end_balance_cr , nvl(BEGIN_BALANCE_DR,0) + nvl(PERIOD_NET_DR,0) end_balance_dr , nvl(BEGIN_BALANCE_cR,0) + nvl(PERIOD_NET_cR,0) end_balance_cr , decode(account_type,'A',nvl(BEGIN_BALANCE_DR_BEQ,0) + nvl(PERIOD_NET_DR_BEQ,0) - (nvl(BEGIN_BALANCE_CR_BEQ,0) + nvl(PERIOD_NET_CR_BEQ,0)) ,'E',nvl(BEGIN_BALANCE_DR_BEQ,0) + nvl(PERIOD_NET_DR_BEQ,0) - (nvl(BEGIN_BALANCE_CR_BEQ,0) + nvl(PERIOD_NET_CR_BEQ,0)) ,nvl(BEGIN_BALANCE_CR_BEQ,0) + nvl(PERIOD_NET_CR_BEQ,0) - (nvl(BEGIN_BALANCE_DR_BEQ,0) + nvl(PERIOD_NET_DR_BEQ,0)) ) func_end_balance , decode(account_type,'A',nvl(BEGIN_BALANCE_DR,0) + nvl(PERIOD_NET_DR,0) - (nvl(BEGIN_BALANCE_cR,0) + nvl(PERIOD_NET_cR,0)) ,'E',nvl(BEGIN_BALANCE_DR,0) + nvl(PERIOD_NET_DR,0) - (nvl(BEGIN_BALANCE_cR,0) + nvl(PERIOD_NET_cR,0)) ,nvl(BEGIN_BALANCE_cR,0) + nvl(PERIOD_NET_cR,0) - (nvl(BEGIN_BALANCE_DR,0) + nvl(PERIOD_NET_DR,0)) ) end_balance FROM ja_cn_account_balances