selectgb.period_year会计年度,
gb.period_name会计期间,
gcck.concatenated_segments科目代码,
gl_flexfields_pkg.get_description_sql(gcck.chart_of_accounts_id,1,
gcck.segment1)公司,
gl_flexfields_pkg.get_description_sql(gcck.chart_of_accounts_id,2,
gcck.segment2)成本中心,
gl_flexfields_pkg.get_description_sql(gcck.chart_of_accounts_id,3,
gcck.segment3)会计科目,
gl_flexfields_pkg.get_description_sql(gcck.chart_of_accounts_id,4,
gcck.segment4)子科目,
gl_flexfields_pkg.get_description_sql(gcck.chart_of_accounts_id,5,
gcck.segment5)产品段,
gl_flexfields_pkg.get_description_sql(gcck.chart_of_accounts_id,6,
gcck.segment6)片区,
gl_flexfields_pkg.get_description_sql(gcck.chart_of_accounts_id,7,
gcck.segment7)备用
,
gb.begin_balance_dr-gb.begin_balance_cr期初余额,
gb.period_net_dr本期借方发生,
gb.period_net_cr本期贷方发生,
nvl(gb.period_net_dr,0)-nvl(gb.period_net_cr,0)本期净额,
nvl(gb.begin_balance_dr,0)+nvl(gb.period_net_dr,0)-nvl(gb.begin_balance_cr,0)-nvl(gb.period_net_cr,0)期末余额fromgl.gl_balancesgb,
gl_code_combinations_kfvgcckwheregb.code_combination_id=gcck.code_combination_idandgb.currency_code='CNY'andgcck.summary_flag='N'andgb.actual_flag='A'