ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US DC0CEF12A1781779E053CB0418AC7871 select u.ledger_name, u.currency_code, &lp_pivot_segment_name pivot_segment, &pivot_and_account_segment u.concatenated_segments account, &parent_acct_desc u.begin_balance_dr, u.begin_balance_cr, u.begin_balance, u.period_dr, u.period_cr, u.period_net, u.end_balance_dr, u.end_balance_cr, u.end_balance, &segment_columns2 &dff_cols2 xxen_util.meaning(u.gl_account_type,'ACCOUNT_TYPE',0) account_type from ( select max(glr.target_ledger_name) ledger_name, gb.currency_code, max(gcck.gl_account_type) gl_account_type, &parent_acct_display max(gcck.concatenated_segments) concatenated_segments, &segment_columns decode(:p_type,'PTD', sum(decode(:p_currency_type,'T', nvl(begin_balance_dr,0),'S', nvl(begin_balance_dr,0),'E',decode(gb.translated_flag,'R', nvl(begin_balance_dr,0), nvl(begin_balance_dr_beq,0)),'C', nvl(begin_balance_dr_beq,0))),'PJTD', decode(:p_currency_type,'T', 0,'S', 0,'E', 0,'C',0),'YTD', decode(:p_currency_type,'T', sum(decode(gb.period_name,:p_first_period_name,(nvl(begin_balance_dr,0)),0)),'S', sum(decode(gb.period_name,:p_first_period_name,(nvl(begin_balance_dr,0)),0)),'E', sum(decode(gb.translated_flag,'R', decode(gb.period_name,:p_first_period_name, nvl(begin_balance_dr,0),0), decode(gb.period_name,:p_first_period_name, nvl(begin_balance_dr_beq,0),0))),'C', sum(decode(gb.period_name,:p_first_period_name,nvl(begin_balance_dr_beq,0),0)))) begin_balance_dr, decode(:p_type,'PTD', sum(decode(:p_currency_type,'T', nvl(begin_balance_cr,0),'S', nvl(begin_balance_cr,0),'E',decode(gb.translated_flag,'R', nvl(begin_balance_cr,0), nvl(begin_balance_cr_beq,0)),'C', nvl(begin_balance_cr_beq,0))),'PJTD', decode(:p_currency_type,'T', 0,'S', 0,'E', 0,'C',0),'YTD', decode(:p_currency_type,'T', sum(decode(gb.period_name,:p_first_period_name,(nvl(begin_balance_cr,0)),0)),'S', sum(decode(gb.period_name,:p_first_period_name,(nvl(begin_balance_cr,0)),0)),'E', sum(decode(gb.translated_flag,'R', decode(gb.period_name,:p_first_period_name, nvl(begin_balance_cr,0),0), decode(gb.period_name,:p_first_period_name, nvl(begin_balance_cr_beq,0),0))),'C', sum(decode(gb.period_name,:p_first_period_name,nvl(begin_balance_cr_beq,0),0)))) begin_balance_cr, decode(:p_type,'PTD', sum(decode(:p_currency_type,'T', nvl(begin_balance_dr,0)-nvl(begin_balance_cr,0),'S',nvl(begin_balance_dr,0)-nvl(begin_balance_cr,0),'E',decode(gb.translated_flag,'R', nvl(begin_balance_dr,0)-nvl(begin_balance_cr,0), nvl(begin_balance_dr_beq,0)- nvl(begin_balance_cr_beq,0)),'C', nvl(begin_balance_dr_beq,0)- nvl(begin_balance_cr_beq,0))),'PJTD', decode(:p_currency_type,'T', 0,'S', 0,'E', 0,'C',0),'YTD', decode(:p_currency_type,'T',sum(decode(gb.period_name, :p_first_period_name,(nvl(begin_balance_dr,0) - nvl(begin_balance_cr,0)),0)),'S', sum(decode(gb.period_name, :p_first_period_name,(nvl(begin_balance_dr,0) - nvl(begin_balance_cr,0)),0)),'E', sum(decode(gb.translated_flag,'R', decode(gb.period_name, :p_first_period_name, nvl(begin_balance_dr,0) - nvl(begin_balance_cr,0),0), decode(gb.period_name, :p_first_period_name, nvl(begin_balance_dr_beq,0)- nvl(begin_balance_cr_beq,0),0))),'C', sum(decode(gb.period_name,:p_first_period_name,(nvl(begin_balance_dr_beq,0)- nvl(begin_balance_cr_beq,0)),0)))) begin_balance, decode(:p_type,'PTD', sum(decode(:p_currency_type,'T', nvl(period_net_dr,0),'S', nvl(period_net_dr,0),'E', decode(gb.translated_flag,'R', nvl(period_net_dr,0),nvl(period_net_dr_beq,0)),'C', nvl(period_net_dr_beq,0))),'PJTD', sum(decode(:p_currency_type,'T', nvl(project_to_date_dr,0) + nvl(period_net_dr,0),'S', nvl(project_to_date_dr,0) + nvl(period_net_dr,0),'E', decode(gb.translated_flag,'R', nvl(project_to_date_dr,0) + nvl(period_net_dr,0), nvl(project_to_date_dr_beq,0) + nvl(period_net_dr_beq,0)),'C', nvl(project_to_date_dr_beq,0) + nvl(period_net_dr_beq,0))),'YTD', decode(:p_currency_type,'T',sum(decode(gb.period_name, :p_period_name, nvl(period_net_dr,0) + nvl(begin_balance_dr,0),0) - decode(gb.period_name, :p_first_period_name, nvl(begin_balance_dr,0),0)),'S', sum(decode(gb.period_name, :p_period_name, nvl(period_net_dr,0) + nvl(begin_balance_dr,0),0) -decode(gb.period_name, :p_first_period_name, nvl(begin_balance_dr,0),0)),'E', sum(decode(gb.translated_flag,'R', decode(gb.period_name, :p_period_name, nvl(period_net_dr,0)+ nvl(begin_balance_dr,0),0) -decode(gb.period_name, :p_first_period_name, nvl(begin_balance_dr,0),0), decode(gb.period_name, :p_period_name, nvl(period_net_dr_beq,0)+nvl(begin_balance_dr_beq,0),0) - decode(gb.period_name, :p_first_period_name,nvl(begin_balance_dr_beq,0),0))),'C', sum(decode(gb.period_name, :p_period_name, nvl(period_net_dr_beq,0) + nvl(begin_balance_dr_beq,0),0) - decode(gb.period_name, :p_first_period_name, nvl(begin_balance_dr_beq,0),0)))) period_dr, decode(:p_type,'PTD', sum(decode(:p_currency_type,'T', nvl(period_net_cr,0),'S', nvl(period_net_cr,0),'E', decode(gb.translated_flag,'R', nvl(period_net_cr,0),nvl(period_net_cr_beq,0)),'C', nvl(period_net_cr_beq,0))),'PJTD', sum(decode(:p_currency_type,'T', nvl(project_to_date_cr,0) + nvl(period_net_cr,0),'S', nvl(project_to_date_cr,0) + nvl(period_net_cr,0),'E', decode(gb.translated_flag,'R', nvl(project_to_date_cr,0) + nvl(period_net_cr,0), nvl(project_to_date_cr_beq,0) + nvl(period_net_cr_beq,0)),'C', nvl(project_to_date_cr_beq,0) + nvl(period_net_cr_beq,0))),'YTD', decode(:p_currency_type,'T',sum(decode(gb.period_name, :p_period_name, nvl(period_net_cr,0) + nvl(begin_balance_cr,0),0) - decode(gb.period_name, :p_first_period_name, nvl(begin_balance_cr,0),0)),'S', sum(decode(gb.period_name, :p_period_name, nvl(period_net_cr,0) + nvl(begin_balance_cr,0),0) -decode(gb.period_name, :p_first_period_name, nvl(begin_balance_cr,0),0)),'E', sum(decode(gb.translated_flag,'R', decode(gb.period_name, :p_period_name, nvl(period_net_cr,0)+ nvl(begin_balance_cr,0),0) -decode(gb.period_name, :p_first_period_name, nvl(begin_balance_cr,0),0), decode(gb.period_name, :p_period_name, nvl(period_net_cr_beq,0)+nvl(begin_balance_cr_beq,0),0) - decode(gb.period_name, :p_first_period_name,nvl(begin_balance_cr_beq,0),0))),'C', sum(decode(gb.period_name, :p_period_name, nvl(period_net_cr_beq,0) + nvl(begin_balance_cr_beq,0),0) - decode(gb.period_name, :p_first_period_name, nvl(begin_balance_cr_beq,0),0)))) period_cr, decode(:p_type,'PTD', sum(decode(:p_currency_type,'T', nvl(period_net_dr,0)-nvl(period_net_cr,0),'S', nvl(period_net_dr,0)- nvl(period_net_cr,0),'E', decode(gb.translated_flag,'R', nvl(period_net_dr,0)- nvl(period_net_cr,0), nvl(period_net_dr_beq,0)- nvl(period_net_cr_beq,0)),'C', nvl(period_net_dr_beq,0)- nvl(period_net_cr_beq,0))),'PJTD', sum(decode(:p_currency_type,'T', nvl(project_to_date_dr,0)+ nvl(period_net_dr,0) - nvl(project_to_date_cr,0)- nvl(period_net_cr,0),'S', nvl(project_to_date_dr,0)+ nvl(period_net_dr,0) - nvl(project_to_date_cr,0)- nvl(period_net_cr,0),'E', decode(gb.translated_flag,'R', nvl(project_to_date_dr,0)+ nvl(period_net_dr,0) - nvl(project_to_date_cr,0)- nvl(period_net_cr,0), nvl(project_to_date_dr_beq,0)+ nvl(period_net_dr_beq,0) - nvl(project_to_date_cr_beq,0)- nvl(period_net_cr_beq,0)),'C', nvl(project_to_date_dr_beq,0)+ nvl(period_net_dr_beq,0)- nvl(project_to_date_cr_beq,0) - nvl(period_net_cr_beq,0))),'YTD', decode(:p_currency_type,'T', sum( decode(gb.period_name,:p_period_name, nvl(period_net_dr,0)- nvl(period_net_cr,0)+ nvl(begin_balance_dr,0)- nvl(begin_balance_cr,0),0) - decode(gb.period_name,:p_first_period_name, nvl(begin_balance_dr,0)- nvl(begin_balance_cr,0),0)),'S', sum(decode(gb.period_name,:p_period_name, nvl(period_net_dr,0)-nvl(period_net_cr,0)+nvl(begin_balance_dr,0)-nvl(begin_balance_cr,0),0) - decode(gb.period_name,:p_first_period_name, nvl(begin_balance_dr,0)- nvl(begin_balance_cr,0),0)),'E', sum(decode(gb.translated_flag,'R', decode(gb.period_name,:p_period_name, nvl(period_net_dr,0) - nvl(period_net_cr,0)+ nvl(begin_balance_dr,0)- nvl(begin_balance_cr,0),0) - decode(gb.period_name,:p_first_period_name, nvl(begin_balance_dr,0)- nvl(begin_balance_cr,0),0), decode(gb.period_name,:p_period_name, nvl(period_net_dr_beq,0)- nvl(period_net_cr_beq,0) + nvl(begin_balance_dr_beq,0) - nvl(begin_balance_cr_beq,0),0) - decode(gb.period_name,:p_first_period_name, nvl(begin_balance_dr_beq,0)- nvl(begin_balance_cr_beq,0 ),0))),'C', sum( decode(gb.period_name,:p_period_name, nvl(period_net_dr_beq,0)- nvl(period_net_cr_beq,0)+ nvl(begin_balance_dr_beq,0) - nvl(begin_balance_cr_beq,0),0)- decode(gb.period_name,:p_first_period_name, nvl(begin_balance_dr_beq,0)-nvl(begin_balance_cr_beq,0),0)))) period_net, decode(:p_type,'PTD', sum(decode(:p_currency_type,'T', nvl(begin_balance_dr,0)+ nvl(period_net_dr,0),'S', nvl(begin_balance_dr,0) + nvl(period_net_dr,0),'E',decode(gb.translated_flag,'R', nvl(begin_balance_dr,0)+ nvl(period_net_dr,0),nvl(begin_balance_dr_beq,0) + nvl(period_net_dr_beq,0)),'C', nvl(begin_balance_dr_beq,0) + nvl(period_net_dr_beq,0))),'PJTD', sum(decode(:p_currency_type,'T', nvl(project_to_date_dr,0) + nvl(period_net_dr,0),'S', nvl(project_to_date_dr,0) + nvl(period_net_dr,0),'E', decode(gb.translated_flag,'R', nvl(project_to_date_dr,0)+ nvl(period_net_dr,0) ,nvl(project_to_date_dr_beq,0) + nvl(period_net_dr_beq,0)),'C', nvl(project_to_date_dr_beq,0) + nvl(period_net_dr_beq,0))),'YTD', decode(:p_currency_type,'T',sum(decode(gb.period_name, :p_period_name, nvl(period_net_dr,0)+nvl(begin_balance_dr,0),0)),'S', sum(decode(gb.period_name, :p_period_name, nvl(period_net_dr,0)+ nvl(begin_balance_dr,0),0)),'E', sum(decode(gb.translated_flag,'R', decode(gb.period_name, :p_period_name, nvl(period_net_dr,0)+ nvl(begin_balance_dr,0),0),decode(gb.period_name, :p_period_name, nvl(period_net_dr_beq,0)+ nvl(begin_balance_dr_beq,0),0))),'C', sum(decode(gb.period_name, :p_period_name, nvl(period_net_dr_beq,0) + nvl(begin_balance_dr_beq,0),0)))) end_balance_dr, decode(:p_type,'PTD', sum(decode(:p_currency_type,'T', nvl(begin_balance_cr,0)+ nvl(period_net_cr,0),'S', nvl(begin_balance_cr,0) + nvl(period_net_cr,0),'E',decode(gb.translated_flag,'R', nvl(begin_balance_cr,0)+ nvl(period_net_cr,0),nvl(begin_balance_cr_beq,0) + nvl(period_net_cr_beq,0)),'C', nvl(begin_balance_cr_beq,0) + nvl(period_net_cr_beq,0))),'PJTD', sum(decode(:p_currency_type,'T', nvl(project_to_date_cr,0) + nvl(period_net_cr,0),'S', nvl(project_to_date_cr,0) + nvl(period_net_cr,0),'E', decode(gb.translated_flag,'R', nvl(project_to_date_cr,0)+ nvl(period_net_cr,0) ,nvl(project_to_date_cr_beq,0) + nvl(period_net_cr_beq,0)),'C', nvl(project_to_date_cr_beq,0) + nvl(period_net_cr_beq,0))),'YTD', decode(:p_currency_type,'T',sum(decode(gb.period_name, :p_period_name, nvl(period_net_cr,0)+nvl(begin_balance_cr,0),0)),'S', sum(decode(gb.period_name, :p_period_name, nvl(period_net_cr,0)+ nvl(begin_balance_cr,0),0)),'E', sum(decode(gb.translated_flag,'R', decode(gb.period_name, :p_period_name, nvl(period_net_cr,0)+ nvl(begin_balance_cr,0),0),decode(gb.period_name, :p_period_name, nvl(period_net_cr_beq,0)+ nvl(begin_balance_cr_beq,0),0))),'C', sum(decode(gb.period_name, :p_period_name, nvl(period_net_cr_beq,0) + nvl(begin_balance_cr_beq,0),0)))) end_balance_cr, decode(:p_type,'PTD', sum(decode(:p_currency_type,'T', nvl(begin_balance_dr,0)+ nvl(period_net_dr,0)- nvl(begin_balance_cr,0) - nvl(period_net_cr,0),'S', nvl(begin_balance_dr,0)+ nvl(period_net_dr,0) - nvl(begin_balance_cr,0) - nvl(period_net_cr,0),'E', decode(gb.translated_flag,'R', nvl(begin_balance_dr,0) + nvl(period_net_dr,0)- nvl(begin_balance_cr,0) - nvl(period_net_cr,0),nvl(begin_balance_dr_beq,0) + nvl(period_net_dr_beq,0)- nvl(begin_balance_cr_beq,0) - nvl(period_net_cr_beq,0) ),'C', nvl(begin_balance_dr_beq,0)+ nvl(period_net_dr_beq,0)- nvl(begin_balance_cr_beq,0) - nvl(period_net_cr_beq,0))),'PJTD', sum(decode(:p_currency_type,'T', nvl(project_to_date_dr,0)+ nvl(period_net_dr,0) - nvl(project_to_date_cr,0) - nvl(period_net_cr,0),'S', nvl(project_to_date_dr,0) + nvl(period_net_dr,0) - nvl(project_to_date_cr,0) - nvl(period_net_cr,0),'E', decode(gb.translated_flag,'R', nvl(project_to_date_dr,0) + nvl(period_net_dr,0)- nvl(project_to_date_cr,0) - nvl(period_net_cr,0), nvl(project_to_date_dr_beq,0) + nvl(period_net_dr_beq,0) - nvl(project_to_date_cr_beq,0) - nvl(period_net_cr_beq,0) ),'C', nvl(project_to_date_dr_beq,0) + nvl(period_net_dr_beq,0) - nvl(project_to_date_cr_beq,0) - nvl(period_net_cr_beq,0)) ),'YTD', decode(:p_currency_type,'T', sum(decode(gb.period_name, :p_period_name, nvl(period_net_dr,0 ) - nvl(period_net_cr,0) + nvl(begin_balance_dr,0) - nvl(begin_balance_cr,0),0)),'S', sum(decode(gb.period_name, :p_period_name, nvl(period_net_dr,0)- nvl(period_net_cr,0) + nvl(begin_balance_dr,0)- nvl(begin_balance_cr,0),0)),'E', sum(decode(gb.translated_flag,'R', decode(gb.period_name, :p_period_name, nvl(period_net_dr,0)- nvl(period_net_cr,0)+ nvl(begin_balance_dr,0) - nvl(begin_balance_cr, 0 ), 0 ), decode(gb.period_name, :p_period_name, nvl(period_net_dr_beq, 0 ) - nvl(period_net_cr_beq,0)+ nvl(begin_balance_dr_beq,0)- nvl(begin_balance_cr_beq,0),0) ) ),'C', sum(decode(gb.period_name,:p_period_name, nvl(period_net_dr_beq,0) - nvl(period_net_cr_beq,0) + nvl(begin_balance_dr_beq,0) - nvl(begin_balance_cr_beq,0),0)))) end_balance, &dff_cols max(gcck.chart_of_accounts_id) chart_of_accounts_id, &parent_id_col gcck.code_combination_id from gl_ledgers gl, gl_ledger_set_assignments glsa, gl_ledger_relationships glr, gl_balances gb, gl_code_combinations_kfv gcck &parent_hierarchy_from where 1=1 and gl.ledger_id=:p_ledger_id and gl.ledger_id=glsa.ledger_set_id(+) and glr.target_currency_code=:p_ledger_currency and gl.ledger_id=glr.source_ledger_id and glr.source_ledger_id=glr.target_ledger_id and nvl(glsa.ledger_id,gl.ledger_id)=gb.ledger_id and gb.code_combination_id=gcck.code_combination_id and nvl(:p_entered_currency,'?')=nvl(:p_entered_currency,'?') and gb.period_name in (:p_period_name, decode(:p_type,'PTD', :p_period_name,'PJTD', :p_period_name,'YTD', :p_first_period_name)) and gb.actual_flag='A' and gcck.chart_of_accounts_id=:p_chart_of_accounts_id and gcck.summary_flag='N' and gcck.template_id is null &parent_hierarchy_where group by gb.ledger_id, gb.currency_code, &dff_cols_group &parent_pivot_group &parent_group_by gcck.code_combination_id ) u where nvl(u.begin_balance,0)!=0 or nvl(u.period_net,0)!=0 or nvl(u.end_balance,0)!=0 order by u.ledger_name, u.currency_code, pivot_segment_value, account_segment, &segment_columns3 u.concatenated_segments Add Show Parents parameter to roll up child account balances to parent account level using GL account hierarchy Y (:Currency_Type = 'E' or :Entered_Currency is not null) US GL Trial Balance - Detail Imported from Concurrent Program Description: Detail Trial Balance (XML) Application: General Ledger Source: Trial Balance - Detail (XML) Short Name: GLTRBALD DB package: Please enter the Entered Currency for Total or Statistical Currency Type Enginatics R12 only &dff_cols &dff_cols2 &dff_cols_group &lp_pivot_segment_name &parent_acct_desc &parent_acct_display &parent_group_by &parent_hierarchy_from &parent_hierarchy_where &parent_id_col &parent_pivot_group &pivot_and_account_segment &segment_columns &segment_columns2 &segment_columns3 1=1 :p_chart_of_accounts_id :p_currency_type :p_entered_currency :p_first_period_name :p_ledger_currency :p_ledger_id :p_period_name :p_type 1 -40 :p_first_period_name Char with first_ledger as ( select nvl( ( select target_ledger_id from gl_ledger_set_assignments asg, gl_ledger_relationships lr where asg.ledger_set_id = :$flex$.GL_SRS_LEDGER_ID_UNVALIDATED and lr.target_ledger_id = asg.ledger_id and lr.source_ledger_id = asg.ledger_id and lr.target_currency_code = :$flex$.Ledger_Currency and rownum=1 ),:$flex$.GL_SRS_LEDGER_ID_UNVALIDATED) ledger_id from dual ) select a.period_name from first_ledger l, gl_period_statuses a, gl_period_statuses b where a.application_id = 101 and b.application_id = 101 and a.ledger_id = l.ledger_id and b.ledger_id = l.ledger_id and a.period_type = b.period_type and a.period_year = b.period_year and b.period_name = :$flex$.Period and a.period_num = (select min(c.period_num) from gl_period_statuses c where c.application_id = 101 and c.ledger_id = l.ledger_id and c.period_year = a.period_year and c.period_type = a.period_type group by c.period_year ) US First Period 2 -29 :p_access_set_id Number fnd_profile.value('GL_ACCESS_SET_ID') Y US Access Set Id Access set Id 3 1=1 select gl_access_set_security_pkg.get_security_clause(:p_access_set_id,'R','LEDGER_COLUMN','ledger_id','gb','SEG_COLUMN',null,'GCCK',null) from dual US Access Set Id 4 -20 :p_ledger_id Number select gl_ledger_utils_pkg.get_ledger_id_of_short_name(:$flex$.ledger_ledger_set) from dual Y US GL_SRS_LEDGER_ID_UNVALIDATED Ledger Id 5 -10 :p_chart_of_accounts_id Number select gas.chart_of_accounts_id from gl_access_sets gas where gas.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') Y US GL_SRS_COA_UNVALIDATED Chart of Accounts Id 6 10 :p_ledger_name LOV Oracle GL_SRS_LEDGER_WITH_SETS_AND_ALCS_STORE_SHORT_NAME Y select nvl(rel.target_ledger_short_name,led.short_name) id, nvl(rel.target_ledger_name,led.name) value, led.description description from gl_access_set_ledgers ac,gl_ledgers led,gl_ledger_relationships rel where ac.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and led.ledger_id=ac.ledger_id and rel.source_ledger_id(+)=ac.ledger_id and rel.target_ledger_id(+)=ac.ledger_id and rel.application_id(+)=101 order by nvl(rel.target_ledger_name,led.name) select name from gl_ledgers where ledger_id = gl_access_set_security_pkg.get_default_ledger_id(fnd_profile.value('GL_ACCESS_SET_ID'), 'R') Y US Ledger/Ledger Set Ledger Name 7 20 :p_ledger_currency LOV Oracle GL_SRS_LEDGER_CURRENCIES Y select curr.currency_code id, curr.currency_code value, null description from fnd_currencies curr where curr.currency_code in (select rel.target_currency_code from gl_ledger_relationships rel where rel.target_ledger_short_name=:$flex$.gl_srs_ledger_with_sets_and_alcs_store_short_name union select rel.target_currency_code from gl_ledger_set_assignments ls,gl_ledger_relationships rel where ls.ledger_set_id=:$flex$.gl_srs_ledger_id_unvalidated and rel.source_ledger_id=ls.ledger_id and rel.target_ledger_id=ls.ledger_id) order by value,description select gl_ledger_utils_pkg.get_default_ledger_currency(:$flex$.ledger_ledger_set) from dual Y US Ledger Currency Ledger Currency 8 30 :p_currency_type LOV Oracle GL_SRS_CURRENCY_TYPE Y select lookup_code id, meaning value, description description from gl_lookups where lookup_type='GL_CURRENCY_TYPE' and lookup_code in ('T','S','E') order by meaning T Y US Currency Type Currency Type 9 1=1 select case when :p_currency_type in ('E','C') then nvl2(:p_entered_currency,'nvl(gb.translated_flag,''R'')=''R'' and gb.currency_code='||''''||:p_entered_currency||'''', 'nvl(gb.translated_flag,''R'')=''R''') when :p_currency_type='T' then 'nvl(gb.translated_flag,''x'')!=''R'' and gb.currency_code='||''''||:p_ledger_currency||'''' when :p_currency_type='S' then 'gb.translated_flag is null and gb.currency_code='||''''||:p_entered_currency||'''' end from dual US Currency Type 10 40 :p_entered_currency LOV Oracle GL_SRS_ENTERED_CURRENCIES Y select currency_code id, currency_code value, null description from gl_entered_currencies_v where currency_type=:$flex$.gl_srs_currency_type order by value,description select gecv.currency_code from gl_entered_currencies_v gecv where gecv.currency_type=decode(:$flex$.currency_type,'S','S','T','T') US Entered Currency Entered Currency 11 50 &lp_pivot_segment_name select ''''||fifsv.form_left_prompt||'''' from fnd_id_flex_segments_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num=:p_chart_of_accounts_id and fifsv.segment_num=:p_pagebreak_seg_num LOV Oracle GL_SRS_PAGEBREAK_SEGS Y select segment_num id, segment_name value, s.description description from fnd_id_flex_segments_vl s,fnd_segment_attribute_values v where s.id_flex_code='GL#' and v.id_flex_code='GL#' and s.id_flex_num=:$flex$.gl_srs_coa_unvalidated and v.id_flex_num=:$flex$.gl_srs_coa_unvalidated and s.enabled_flag='Y' and s.application_column_name=v.application_column_name and s.application_id=101 and v.application_id=101 and v.segment_attribute_type='GL_ACCOUNT' and v.attribute_value='N' order by segment_num 1 Y US Pivot Segment Pagebreak Segment 12 &pivot_and_account_segment select 'u.'||lower(fifsv.application_column_name)||' '||decode(fifsv.segment_num,:p_pagebreak_seg_num,'pivot_segment_value','account_segment')||','||chr(10)|| 'xxen_util.segment_description(u.'||lower(fifsv.application_column_name)||', '''||fifsv.application_column_name||''', u.chart_of_accounts_id'|| ( select ', u.'||lower(fifs.application_column_name) from fnd_id_flex_segments fifs where fifsv.application_id=fifs.application_id and fifsv.id_flex_code=fifs.id_flex_code and fifsv.id_flex_num=fifs.id_flex_num and fifsv.enabled_flag=fifs.enabled_flag and fifs.flex_value_set_id=(select ffvs.parent_flex_value_set_id from fnd_flex_value_sets ffvs where fifsv.flex_value_set_id=ffvs.flex_value_set_id) )||')'||' '||decode(fifsv.segment_num,:p_pagebreak_seg_num,'pivot_segment_desc','account_segment_desc')||',' text from (select xxen_util.init_cap(fifsv.form_left_prompt) form_left_prompt_, fifsv.* from fnd_id_flex_segments_vl fifsv) fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num=:p_chart_of_accounts_id and fifsv.enabled_flag='Y' and ( fifsv.segment_num=:p_pagebreak_seg_num or (fifsv.application_id, fifsv.id_flex_code, fifsv.id_flex_num, fifsv.application_column_name) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type='GL_ACCOUNT' and fsav.attribute_value='Y') ) order by fifsv.segment_num US Pivot Segment 13 &segment_columns select 'max(gcck.'||lower(fifsv.application_column_name)||') '||lower(fifsv.application_column_name)||',' text from (select xxen_util.init_cap(fifsv.form_left_prompt) form_left_prompt_, fifsv.* from fnd_id_flex_segments_vl fifsv) fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num=:p_chart_of_accounts_id and fifsv.enabled_flag='Y' order by fifsv.segment_num US Pivot Segment 14 &segment_columns2 select 'u.'||lower(fifsv.application_column_name)||' "'||substrb(fifsv.form_left_prompt_,1,xxen_report.max_column_length)||'",'||chr(10)|| 'xxen_util.segment_description(u.'||lower(fifsv.application_column_name)||', '''||fifsv.application_column_name||''', u.chart_of_accounts_id'|| ( select ', u.'||lower(fifs.application_column_name) from fnd_id_flex_segments fifs where fifsv.application_id=fifs.application_id and fifsv.id_flex_code=fifs.id_flex_code and fifsv.id_flex_num=fifs.id_flex_num and fifsv.enabled_flag=fifs.enabled_flag and fifs.flex_value_set_id=(select ffvs.parent_flex_value_set_id from fnd_flex_value_sets ffvs where fifsv.flex_value_set_id=ffvs.flex_value_set_id) )||')'||' "'||substrb(fifsv.form_left_prompt,1,xxen_report.max_column_length-5)||' desc",' text from (select xxen_util.init_cap(fifsv.form_left_prompt) form_left_prompt_, fifsv.* from fnd_id_flex_segments_vl fifsv) fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num=:p_chart_of_accounts_id and fifsv.enabled_flag='Y' and fifsv.segment_num<>:p_pagebreak_seg_num and (fifsv.application_id, fifsv.id_flex_code, fifsv.id_flex_num, fifsv.application_column_name) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type='GL_ACCOUNT' and fsav.attribute_value='N') order by fifsv.segment_num US Pivot Segment 15 &segment_columns3 select 'u.'||lower(fifsv.application_column_name)||',' text from (select xxen_util.init_cap(fifsv.form_left_prompt) form_left_prompt_, fifsv.* from fnd_id_flex_segments_vl fifsv) fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num=:p_chart_of_accounts_id and fifsv.enabled_flag='Y' and fifsv.segment_num<>:p_pagebreak_seg_num and (fifsv.application_id, fifsv.id_flex_code, fifsv.id_flex_num, fifsv.application_column_name) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type='GL_ACCOUNT' and fsav.attribute_value='N') order by fifsv.segment_num US Pivot Segment 16 60 1=1 select 'gcck.'||fifsv.application_column_name||'>= '''||:p_low_pb_seg||'''' from fnd_id_flex_segments_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num=:p_chart_of_accounts_id and fifsv.segment_num=:p_pagebreak_seg_num and fifsv.enabled_flag='Y' LOV custom Y select ffvv.flex_value value, ffvv.description from fnd_id_flex_segments_vl fifsv, fnd_flex_values_vl ffvv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num=:$flex$.gl_srs_coa_unvalidated and fifsv.segment_num=:$flex$.Pivot_Segment and fifsv.enabled_flag='Y' and ffvv.flex_value_set_id = fifsv.flex_value_set_id order by ffvv.flex_value US Pivot Segment Low Pagebreak Segment Low 17 70 1=1 select 'gcck.'||fifsv.application_column_name||'<= '''||:p_high_pb_seg||'''' from fnd_id_flex_segments_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num=:p_chart_of_accounts_id and fifsv.segment_num=:p_pagebreak_seg_num and fifsv.enabled_flag='Y' LOV custom Y select ffvv.flex_value value, ffvv.description from fnd_id_flex_segments_vl fifsv, fnd_flex_values_vl ffvv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num=:$flex$.gl_srs_coa_unvalidated and fifsv.segment_num=:$flex$.Pivot_Segment and fifsv.enabled_flag='Y' and ffvv.flex_value_set_id = fifsv.flex_value_set_id order by ffvv.flex_value :$flex$.Pagebreak_Segment_Low US Pivot Segment High Pagebreak Segment High 18 80 :p_period_name LOV Oracle GL_SRS_PERIOD_NAME_FOR_LEDGER_SET Y select per.period_name id, per.period_name value, null description from gl_ledgers led,gl_periods per where led.ledger_id=:$flex$.gl_srs_ledger_id_unvalidated and per.period_set_name=led.period_set_name and per.period_type=led.accounted_period_type and exists ( select 'has data' from gl_ledgers led2, gl_ledger_set_assignments ls, gl_ledger_relationships rel, gl_period_statuses ps where led2.ledger_id=led.ledger_id and ls.ledger_set_id (+)=led2.ledger_id and rel.source_ledger_id=nvl(ls.ledger_id,led.ledger_id) and rel.target_ledger_id=nvl(ls.ledger_id,led.ledger_id) and rel.target_currency_code=:$flex$.gl_srs_ledger_currencies and ps.application_id=101 and ps.ledger_id=rel.source_ledger_id and ps.closing_status in ('O','C','P') and ps.period_name=per.period_name) order by per.period_year,per.period_num Y US Period Period Name 19 90 :p_type LOV Oracle GL_SRS_PERIOD_TYPES Y select lookup_code id, meaning value, description description from gl_lookups where lookup_type='PTD_YTD' and lookup_code!='QTD' order by upper(meaning) Y US Amount Type Amount Type 20 95 1=1 gcck.enabled_flag='Y' and not exists ( select null from fnd_id_flex_segments fifs, fnd_flex_values ffv where fifs.id_flex_code='GL#' and fifs.application_id=101 and fifs.id_flex_num=gcck.chart_of_accounts_id and fifs.flex_value_set_id=ffv.flex_value_set_id and decode(fifs.application_column_name,'SEGMENT1',gcck.segment1,'SEGMENT2',gcck.segment2,'SEGMENT3',gcck.segment3,'SEGMENT4',gcck.segment4,'SEGMENT5',gcck.segment5,'SEGMENT6',gcck.segment6,'SEGMENT7',gcck.segment7,'SEGMENT8',gcck.segment8,'SEGMENT9',gcck.segment9,'SEGMENT10',gcck.segment10,'SEGMENT11',gcck.segment11,'SEGMENT12',gcck.segment12,'SEGMENT13',gcck.segment13,'SEGMENT14',gcck.segment14,'SEGMENT15',gcck.segment15)=ffv.flex_value and (ffv.enabled_flag='N' or ffv.start_date_active>sysdate or ffv.end_date_active<trunc(sysdate)) ) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Active Accounts Only 21 96 &parent_acct_display select 'nvl(pmap.parent_flex_value,''(No Parent)'') concatenated_segments,--' from dual LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Show Parents When enabled, rolls up child account balances to their parent account level using the GL account hierarchy 22 &parent_acct_desc select 'xxen_util.segment_description(u.concatenated_segments,'''||fsav.application_column_name||''',u.chart_of_accounts_id) parent_account_description,' from fnd_segment_attribute_values fsav where fsav.application_id=101 and fsav.id_flex_code='GL#' and fsav.id_flex_num=:p_chart_of_accounts_id and fsav.segment_attribute_type='GL_ACCOUNT' and fsav.attribute_value='Y' Y US Show Parents 23 &parent_group_by select 'nvl(pmap.parent_flex_value,''(No Parent)'') --' from dual Y US Show Parents 24 &parent_hierarchy_from select ',fnd_flex_value_norm_hierarchy pmap' from fnd_id_flex_segments fifs, fnd_segment_attribute_values fsav where fifs.application_id=101 and fifs.id_flex_code='GL#' and fifs.id_flex_num=:p_chart_of_accounts_id and fsav.application_id=fifs.application_id and fsav.id_flex_code=fifs.id_flex_code and fsav.id_flex_num=fifs.id_flex_num and fsav.application_column_name=fifs.application_column_name and fsav.segment_attribute_type='GL_ACCOUNT' and fsav.attribute_value='Y' Y US Show Parents 25 &parent_hierarchy_where select 'and pmap.flex_value_set_id(+)='||fifs.flex_value_set_id||' and pmap.range_attribute(+)=''C'' and gcck.'||lower(fsav.application_column_name)||' between pmap.child_flex_value_low(+) and pmap.child_flex_value_high(+) and (pmap.parent_flex_value is null or not exists (select null from fnd_flex_value_norm_hierarchy ffvnh2 where ffvnh2.flex_value_set_id=pmap.flex_value_set_id and ffvnh2.range_attribute=''C'' and gcck.'||lower(fsav.application_column_name)||' between ffvnh2.child_flex_value_low and ffvnh2.child_flex_value_high and ffvnh2.child_flex_value_low>=pmap.child_flex_value_low and ffvnh2.child_flex_value_high<=pmap.child_flex_value_high and (ffvnh2.child_flex_value_low>pmap.child_flex_value_low or ffvnh2.child_flex_value_high<pmap.child_flex_value_high)))' from fnd_id_flex_segments fifs, fnd_segment_attribute_values fsav where fifs.application_id=101 and fifs.id_flex_code='GL#' and fifs.id_flex_num=:p_chart_of_accounts_id and fsav.application_id=fifs.application_id and fsav.id_flex_code=fifs.id_flex_code and fsav.id_flex_num=fifs.id_flex_num and fsav.application_column_name=fifs.application_column_name and fsav.segment_attribute_type='GL_ACCOUNT' and fsav.attribute_value='Y' Y US Show Parents 26 &parent_id_col select 'null --' from dual Y US Show Parents 27 &parent_pivot_group select 'gcck.'||lower(fifsv.application_column_name)||',' from fnd_id_flex_segments_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num=:p_chart_of_accounts_id and fifsv.segment_num=:p_pagebreak_seg_num and fifsv.enabled_flag='Y' Y US Show Parents 28 100 &dff_cols select xxen_util.dff_columns(p_table_name=>'gl_code_combinations',p_table_alias=>'gcck',p_display_mode=>:dff_display) from dual LOV custom Y select 'V' id, 'Value' value, 'Value only' description from dual union all select 'C' id, 'Value: Description' value, 'Concatenated value and description' description from dual union all select 'S' id, 'Value, Description' value, 'Value and description in separate columns' description from dual fnd_profile.value('XXEN_REPORT_DFF_DISPLAY') US DFF Display 29 &dff_cols2 select xxen_util.dff_columns(p_table_name=>'gl_code_combinations',p_prefix=>'u.',p_display_mode=>:dff_display) from dual US DFF Display 30 &dff_cols_group select xxen_util.dff_columns(p_table_name=>'gl_code_combinations',p_table_alias=>'gcck',p_hide_column_name=>'Y',p_display_mode=>:dff_display) from dual US DFF Display :$flex$.GL_SRS_LEDGER_ID_UNVALIDATED GL_SRS_LEDGER_ID_UNVALIDATED First Period :$flex$.Ledger_Currency Ledger Currency First Period :$flex$.Period Period First Period :$flex$.Pivot_Segment Pivot Segment Pivot Segment High :$flex$.Pivot_Segment Pivot Segment Pivot Segment Low :$flex$.currency_type Currency Type Entered Currency :$flex$.gl_srs_coa_unvalidated GL_SRS_COA_UNVALIDATED Pivot Segment :$flex$.gl_srs_coa_unvalidated GL_SRS_COA_UNVALIDATED Pivot Segment High :$flex$.gl_srs_coa_unvalidated GL_SRS_COA_UNVALIDATED Pivot Segment Low :$flex$.gl_srs_currency_type Currency Type Entered Currency :$flex$.gl_srs_ledger_currencies Ledger Currency Period :$flex$.gl_srs_ledger_id_unvalidated GL_SRS_LEDGER_ID_UNVALIDATED Ledger Currency :$flex$.gl_srs_ledger_id_unvalidated GL_SRS_LEDGER_ID_UNVALIDATED Period :$flex$.gl_srs_ledger_with_sets_and_alcs_store_short_name Ledger/Ledger Set Ledger Currency :$flex$.ledger_ledger_set Ledger/Ledger Set GL_SRS_LEDGER_ID_UNVALIDATED :$flex$.ledger_ledger_set Ledger/Ledger Set Ledger Currency 3F06581380C069C199B0437381BE9487 Trial Balance Pivot Y SYSADMIN 8 ACCOUNT 6 ACCOUNT_SEGMENT 7 ACCOUNT_SEGMENT_DESC 11 BEGIN_BALANCE 10 BEGIN_BALANCE_CR 9 BEGIN_BALANCE_DR 2 CURRENCY_CODE 17 END_BALANCE 16 END_BALANCE_CR 15 END_BALANCE_DR 1 LEDGER_NAME 13 PERIOD_CR 12 PERIOD_DR 14 PERIOD_NET 3 PIVOT_SEGMENT 5 PIVOT_SEGMENT_DESC 4 PIVOT_SEGMENT_VALUE ACCOUNT ROW 8 ACCOUNT_SEGMENT ROW 6 ACCOUNT_SEGMENT_DESC ROW 7 BEGIN_BALANCE VALUE 1 SUM CURRENCY_CODE ROW 2 END_BALANCE VALUE 3 SUM LEDGER_NAME ROW 1 PERIOD_NET VALUE 2 SUM PIVOT_SEGMENT ROW 3 PIVOT_SEGMENT_DESC ROW 5 PIVOT_SEGMENT_VALUE ROW 4 GL Trial Balance Detail - Trial Balance Pivot Template.xlsx US UEsDBBQAAAAIAIFGvVyQ7xzWmgEAAG0HAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbM2V30/CMBDH3038H5a+mq2AiTGGwQPqoxLFP6CsB2vY2qZXEP57bx34g0yQgNGXtVt79/20d7vr9pdlES3AoTI6Ze2kxSLQmZFKT1P2MrqPr1mEXmgpCqMhZStA1u+dn3VHKwsYkbXGlOXe2xvOMcuhFJgYC5pWJsaVwtOrm3IrspmYAu+0Wlc8M9qD9rGvfLBe9xYmYl746G5Jn2sSBwWyaFBvrLRSJqwtVCY8rfOFllsq8VohIcuwB3Nl8YIwGG9UqFa+F1jbPdLVOCUhGgrnH0RJGHxZ8FfjZmNjZsluJw2UZjJRGUiTzUs6WILWgZCYA/iySMKYlELpDfcO/bAZeRjaJwapzhccH8jR+Sccl3/EYdXC+IGg34B/TCm7lVZVSp46TE0aeyLWSPgEmXESfw9vLbCHzVP1AB6ex6MEN3sE0a8KwBPnSu10n3IuHMhn76jOnhzgs++fpMNIjIm4ztgwP/72v9a1D8+7cKgoDp2xSO3BweFB2dT/yjq25AicV7sD8a5IreVwwa1SDlXzkiAbtHlolr03UEsDBBQAAAAIAIFGvVy1VTAj7gAAAEwCAAALAAAAX3JlbHMvLnJlbHONks9OwzAMxu9IvEPk++puSAihpbtMSLshVB7AJO4ftY2jJED39oQDgkpj29H2588/W97u5mlUHxxiL07DuihBsTNie9dqeK2fVg+gYiJnaRTHGo4cYVfd3mxfeKSUm2LX+6iyi4saupT8I2I0HU8UC/HscqWRMFHKYWjRkxmoZdyU5T2Gvx5QLTzVwWoIB3sHqj76PPmytzRNb3gv5n1il06MQJ4TO8t25UNmC6nP26iaQstJgxXznNMRyfsiYwOeJtpcT/T/tjhxIkuJ0Ejg8zzfinNA6+uBLp9oqfi9zjzip4ThTWT4YcHFD1RfUEsDBBQAAAAIAIFGvVyclN/2pQEAAHYDAAAQAAAAZG9jUHJvcHMvYXBwLnhtbJ2TTW/bMAyG7wP2HwTdE7nNUAyBrGJrtvXQYQHidmdOpmOhsmRIrJHs10+2Ecdpe9qNX3r1kJTk7aGxrMMQjXc5v1pmnKHTvjRun/PH4vviM2eRwJVgvcOcHzHyW/Xxg9wG32Igg5ElCRdzXhO1ayGirrGBuExplzKVDw1QcsNe+KoyGjdevzToSFxn2Y3AA6ErsVy0kyAfFdcd/a9o6XXPF5+KY5uAlSw8gS1MgyqT4uzIL21rjQZK3aufRgcffUXs20GjlWKelIl6h/olGDr2GnNX7jRYvEsXqgpsRCnOAXmP0A9zCyZEJTtad6jJBxbN3zTOa87+QMQeM+cdBAOOEm5fNjqDbdtIQf324TnWiBSlmIKDOa+d2+aTWg0FybgsHE4NIClxiVgYshh/VVsI9A7xak48gI28I+OPB1Ykbsu+ggWnkS3YBglMmuYZebK2pvO0uDwwxN6vhgANUnqrb/o/dfKK/cG45/jYFn4DhKfdXAblroaAZVrntLspIO/TWoLtRe5qcHssTzVvE/1Lehq/kbq6WWarLD2SWUyK84dR/wBQSwMEFAAAAAgAgUa9XPxmAyo8AQAAUQIAABEAAABkb2NQcm9wcy9jb3JlLnhtbH2SUUvDMBSF3wX/Q8l7mzSVMUPbgcqeHAhWHL6F5G4rNmlIot3+vWm7dRsMH+89534595J8sVdN9AvW1a0uUJoQFIEWraz1tkAf1TKeo8h5riVvWg0FOoBDi/L+LheGidbCm20NWF+DiwJJOyZMgXbeG4axEztQ3CXBoYO4aa3iPpR2iw0X33wLmBIywwo8l9xz3ANjMxHRESnFhDQ/thkAUmBoQIH2DqdJis9eD1a5mwODcuFUtT+YsNMx7iVbilGc3HtXT8au65IuG2KE/Cler17fh1XjWve3EoDKXAomLHDf2jIPac9FOFzDnV+FG29qkE+HoN/oSTHEHedARiEAG+OelM/s+aVaopISSmPyGJNZRQmjlGUPX/2TV/N9oLGhjg//T8xiMo/TWUUIyzJG5xfEE2DMff0Jyj9QSwMEFAAAAAgAgUa9XE1B1tIaAQAAewQAABoAAAB4bC9fcmVscy93b3JrYm9vay54bWwucmVsc72UwUrEMBCG74LvEOZu03Z1Fdl0Dy7CXnV9gNBO27BtEjJxtW9vrNBaWOoeipfAzCT//zHMZLP9bBt2QkfKaAFJFANDnZtC6UrA2+H55gEYeakL2RiNAjok2GbXV5sXbKQPj6hWllhQ0SSg9t4+ck55ja2kyFjUoVIa10ofQldxK/OjrJCncbzm7rcGZBNNti8EuH2xAnbobHD+W9uUpcpxZ/L3FrU/Y8E/jDtSjeiDqHQVegFDinhfWUWBGPh5mPslYaiWDotX70KvaQSapOdg0iVhLuhMOgeT/DNMMgezXhKGfNeEoR8G5iees79b0t6HVcLRvQ95f8624HZJBqtOxj/JsNU7LJVW33s/Io1Vfu7igMknX0b2BVBLAwQUAAAACACBRr1c4it/e7sAAAAzAQAAMgAAAHhsL3Bpdm90Q2FjaGUvX3JlbHMvcGl2b3RDYWNoZURlZmluaXRpb24xLnhtbC5yZWxzhY/BasMwEETvhf6D2HstO4dQiuUcEgK5BucDFmlti9haoVVC/PfRMaGFHodh3sy0u8cyqzsl8RwMNFUNioJl58No4NIfv75BScbgcOZABlYS2HWfH+2ZZswlJJOPogoliIEp5/ijtdiJFpSKI4XiDJwWzEWmUUe0VxxJb+p6q9MrA7o3pjo5A+nkGlD9Gkvz/2weBm/pwPa2UMh/VOjo75z3WOadyXJyUuCYRsoGfllNVaaD7lr9drV7AlBLAwQUAAAACACBRr1cwY7qFPQDAADjEAAAJwAAAHhsL3Bpdm90Q2FjaGUvcGl2b3RDYWNoZURlZmluaXRpb24xLnhtbM1YXW/iOBR9X2n/g+Wn3Yc0H4SBIGDE5wip2+mUtu9uYsBqYke2w4BW89/3OgksIYxoO+2yeQjg3Jx7fK7v9TXdz5skRmsqFRO8h90rByPKQxExvuzhh/up1cZIacIjEgtOe3hLFf7c//23bsrWQo9IuKJjumCcaQBAAMZVD6+0Tju2reBhQtSVSCmHJwshE6Lhp1zaKpWURGpFqU5i23OcT3ZCGMcFQke+BEMsFiykYxFmCeW6AJE0JoaJWrFU7dCS8CVwCZHPWWqFIkkB4onFTG9zUIySsDNbciHJUwwSbOQOeFPnmbBQCiUW+gqA7IJibbauD0TXzGiOkeywqIflLHLhO11ICqpEw20PDzK9EuCrHPzKrwUBy0OzMdFAyPfbrnvVaDrNwGt7vtNqYRSCvppGj7vIwiz24PtBiG3C+F3h1Exu/6RhzEMho5HIuAan4HUjO5mh+rdTXhZ8DszNsaZw5bdPoJi5fuB+NzSrYy4yGVKktykw/S7kcx50eLr/XloAPZiz2/nW8n1Yc8aqh79co3vJSIyGJCYccCw0ppqwGNv9rn3goPQ2ZTSOFApL1q0di3wccZIAiWsaLalEN/ADI54l00TPYFoO2IIKkkYzTRODwcERVzeCFzJDauzGhkDmOQ9F6cmDlxOgpNC6hx/zyKKvKZXFYkR/PMwHf2KUmVcM8QM/u2nkDA9nUbIdZVJCRm7RSEQfxPfL8PZt3G5NDUBzujQJ+DFajmlKpC7w3yJfhSJ6JHH2QSLCmn8PhmOqwo9R8kZA6vyamIMwX+7vHnG3kj6u6x5ImWeU26gPuY1jK6/+ohcENaumV4P3avCNEx79mpXXrJOoYL0m04/UhWi941KoSjzPFOzJClJhl1O5zCUDhe5oSNna7AhHFjOuKWwW+ucWc9izNLqnMkEzvgZTk7uwFVccjYhaHQ3dmbLOaYQmRHLoPo5f2Xu+JdsTxMpRpAVsFfwZ9omicB6UjeoUT8MYylwLuUV/Qc3Pd56yZlT4zzU8RXMSU4WgN0IPiqJ7skFvrKOl7u+W99VgO67Zoy2TVsVmXSlVuSp7k8ZZE1je51Agdc6ZQCqdMTHJfM7kPBeToOdQoEScMTHF4BwKVBUL+ARVdV+T/0O6ZHzf6Iyh8/u3OfFf053Mtczb91MNy75t+lm/UWUx+j+wuIwQt5D+IkKXikPp/lIBKN3fQKt+kWU4gaq66/kvFYJDDpeKwwGH/yQQxZmqOEb1u3Sjr5XOP1EmGZz9Wl5zMPEGEyvwA9fy20/UGnpD3/Inw6DlT0cNp+3/2J+PXb928n7RAdkJ7KD4Q6Df3bh+59SfDaaSAa/inrO0T5n1/wFQSwMEFAAAAAgAgUa9XC0Lt1sWAQAA6AYAACQAAAB4bC9waXZvdENhY2hlL3Bpdm90Q2FjaGVSZWNvcmRzMS54bWztlcFKxDAQhu+C7xDmvk0rIrK03YMieBV9gGw6bYNJJiRp6b69qWVPRXbBPfYQSPjhm/l/Zkh5mIxmI/qgyFZQZDkwtJIaZbsKvj7fds/AQhS2EZosVnDCAIf6/q50aqT4ImSPHyjJN4Elkg0V9DG6PechKUaEjBzapLTkjYjp6TsenEfRhB4xGs0f8vyJG6EsLIS9v4ZBbaskvpIcDNq4QDxqEZOP0CsXzjQjr8EZ4b8Ht5NkXEIclVbx9AsFZuT+vbPkxVEn/5M/g6d1n0ZJT4HamCUQX1pcuS0eU6OjmgMHJmmwMeVeQF36upzYWEEO/FY3k0iXDk91t9I3iv5S2LO+Bb5N+D83fBuzvxKYl4uv/qb6B1BLAwQUAAAACACBRr1cCkEM6r0AAABHAQAAKQAAAHhsL3Bpdm90VGFibGVzL19yZWxzL3Bpdm90VGFibGUxLnhtbC5yZWxzhY/BCsIwDIbvgu9QcrfdPIjIOg+K4FX0AUKXbcUtLW0VfXvrbQPBY8if789X7V/jIJ4UonWsoZQFCGLjGsudhtv1tNqCiAm5wcExaXhThH29XFQXGjDlo9hbH0WmcNTQp+R3SkXT04hROk+cN60LI6Y8hk55NHfsSK2LYqPClAH1jCnOjYZwbkoQ17fPzf/Zrm2toaMzj5E4/ahQ3j5dOmB+70itZfsVyHwMHSUNUk4CP7OlzDqg6krN9OsPUEsDBBQAAAAIAIFGvVxb7SdhrwQAADQTAAAeAAAAeGwvcGl2b3RUYWJsZXMvcGl2b3RUYWJsZTEueG1s7Vhbb9s2FH4fsP8g6F2VaMtXRC6cOF6Ddl3QeN0zI1E2MYoUKCqxUey/75BSaMUiWjdD1w2oH2TxiPr4nRt1Di9e7wvmPRBZUcETH72KfI/wVGSUbxP/9806mPpepTDPMBOcJP6BVP7rxc8/XZT0QagNvmdkRXLKqQIAD8B4lfg7pcp5GFbpjhS4eiVKwuFJLmSBFQzlNqxKSXBW7QhRBQsHUTQOC0y53yDMi/QckALLP+sySEVRYkXvKaPqYLB8r0jnN1supOaX+Hv5BLyXPeCCplJUIlevACgUeU5T0uOH4lCSB6qtBFByXtMs8T9F7S+A/4m+REGE9KXz+8v3OC6AxK01GPK9FINtbgBjOPQ9XJbs8L4u7olcNzZKfPCDEV8KmTnEa8FVb+4tVopI3pMvGd3ygjje+INmaveG0O3uiAbsMqzwFS61SxP/I2Y1ON2rSxCT7ONTrEBgFJR/ILkk1U7b2T4BleqKLGslGirKBBPgSvH4i4RY2giFWaNkKtipiCpS3ErK1YYqRmCatheES3dxcDHlGajUgkAEpM/uV6CCeVbUTNGSkTUlLFtTBhYyKy8umEghbCBqJckTf4nmb2Pfy6ms1BuITSI/iEeDYEQazwiAjBVcCZb4Uz9cNNlglqhApVrzQhNY4yj38J7CwvoKOFrxI2dRK0Z1dsFq1U48Lhng6nsh1eZQwgNcpYTrpATnkByDTnf1vdJmbHTRNrMrD1qBVxi6e30FjnqOHkR6EJo34P/I8FuwPWE2PIOZoQn2a/X8F8n+MK2J4G8RB/8v057BFn0uyWzeDW3eWdGkLxr0RbO+KO6L0DGvLf7YMc1kvMkrO23UF5mN7HtsEi8zt8NEDkM69HR4wOEn5DDa0UKfM/eZjvpue/LLzO0INYe5HYZ0mMPhFEfYOvzkCniHUxyh0XHnuZ/Ac77Qjo/xs2rgrM/8F0F0PWa25qYWOqNy+CLkfwfkh3LPaj635zplGhRtUEc/rzWnUFflOkBsfWdHJm/tyKSsHZlstSOTqHZkctSOTHrakcnM0LIwhG66Faip8xYXe++hrT2/7s5wbl45vQ0BlnbLQw86Or3ccQXnFNSbovkb0osLaEJOaveuPQNjtNBOMvOd6pq6WvOjWu0+JxDrssFQbUBhtgZuedhUsKW81sxK20bSuyRbyr1LzDBPCbQjZl+AduEeV02bk/iTZqRxjRE9XhfrQumOE42Na3uot0RSkXnviXqChD7un0Fe8+yUJjRuX4UZHm3S1qXmzOFOHRi54bnoNtdG+CvJaF3MmkYKOq2ml2u6SC2Cnu1UBLPulKSl7jXbDgxmnYre4UqBuC70OYm2INmrd5Uy/14twbefZuPB9Xq0QsHoajkI4nQ2DKbX6zhYXa5HV9EoHs5WAzgPaM449ih+2VlENAtnzWkJhBKK586TmB3NSNO5P3Wt7aoQDyfHM84DELJPSfdgRgcrKNrVdhJPlmM0jgM0HS2DOFpdBdPlchSsIzRCgxGKVqP4qG2ZQat6zsqnR0No3Gx+7cbI8AHaZa06IDp1R2PvmusgyZ565AqOqHTPbNxrhb/xjSg7T6yKWlHj2Wbhk0Ouxd9QSwMEFAAAAAgAgUa9XJzNpYJvAwAAbAkAAA0AAAB4bC9zdHlsZXMueG1stVbbjts2EH0v0H8guK/V6rKWa7uWg/giIEASFN0tUKAuCkqibCK8CBS1lRr03zukZFtO0mZ3i75Y5JBz5gzncOjlq1Zw9Eh1zZRMcHgbYERlrgomDwn++SH1ZhjVhsiCcCVpgjta41erb79Z1qbj9P5IqUEAIesEH42pFr5f50cqSH2rKiphpVRaEANTffDrSlNS1NZJcD8KgqkvCJO4R1iI/CkggugPTeXlSlTEsIxxZjqHhZHIF28OUmmScaDahhOSozac6gi1+hTEWT+LI1iuVa1Kcwu4vipLltPP6c79uU/yCxIgvwwpjP0gusq91S9EmviaPjJbPrxaykakwtQoV400CY7OJtSvvCmgxtMJRn1VNqqAcyr2nhBi73XdHh2PCyEWdY39E9iVZ3ztefPdzU1wGwS/ox9+/YkWv+29k2WPLII/8FktSyXHtKAqUIXFB6n+kKldAlrA1e5aLes/0SPhYAksRq640siApoBq6HgRQfsdG8JZppk1lkQw3vXmyBqcDId9goEoHKE+Qv+b2V3/eywXsoaYjPNzYe5ssmBYLUHDhmqZwgQN44euglQlXLeestv3ld0HTbowip/uUCvOCsvisHEHrA9ZgtN093qXpg4mGxaYLGhLQTcgG0tnRPhMznGEHDOlC2glJ/nZkvam1ZLT0oC7Zoej/RpV2RjKGLhuq2XByEFJwm2Ak8cwANiccn5v280v5RV2W47ECY3LnrRVuB0CoWHY4/UTiz9G67FHsFOg/HxY1JZn/H/yDi+kIozGpM7eiFQV7+x9sEofZpDIoPsr5OEWfy3hT7DfNyKjOnWX/0uokyed4jNBn4lZsUdl1g0owz5ItmSfJO6a0H9P3AkBSj/S15W6zjpBtuEk+L09NQ7Nf6g1yhrGDZNfUBZgFu1Fq053xj5KTsXnKHAwBS1Jw83DeTHBl/E7WrBGgFqGXT/ak3EQCb6M+11zG4O25m0NnQ2+qNEswR936+/n210aebNgPfMmdzT25vF668WTzXq7TedBFGz+Gj2NL3uEAvswupccihVOFjWH51MPyQ7k7y+2BI8mb21HcGX2gfaY+zyaBq/jMPDSuyD0JlMy82bTu9hL4zDaTifrXZzGI+7xy7iHgR+GF/LxwjBBOZOnWp0qNLZCkWD6L0nYVFwl/MvfpNXfUEsDBBQAAAAIAIFGvVzCh9vyUQYAANcbAAATAAAAeGwvdGhlbWUvdGhlbWUxLnhtbO1ZT2/bNhS/D9h3IHRvYye2Ewd1itixm61NGyRuhx5pmZbYUKJA0kl9G9rjgAHDumGXAbvtMGwr0AK7dJ8mW4etA/oV9khKthgzjdOm2L/mEIvUj+//e3ykrly9nzB0SISkPG0F1cuVAJE05EOaRq3gdr93aS1AUuF0iBlPSSuYEBlc3Xj/vSt4XcUkIQjWp3Idt4JYqWx9aUmGMI3lZZ6RFN6NuEiwgqGIloYCHwHdhC0tVyqNpQTTNEApToDsrdGIhgT1DUl4u4ouwU+1EmwUjLoMXqVK6omQiX3NhrirT64bHlQ1Wk5khwl0iFkrAP5DftQn91WAGJYKXrSCivkLljauLOH1fBFTp6wtreuZv3xdvmB4sGx4imgwZVrt1ZqrW1P6BsDUPK7b7Xa61Sk9A8BhCFpbWco0a721arugWQLZx3nanUq9UnPxJforc/Sb7Xa73sxlsUQNyD7W5vBrlUZtc9nBG5DF1+flb292Og0Hb0AW35jD91abjZqLN6CY0fRgDq39OfXMFDLibNsLXwP4WhEAMxREwzTSNIsRT9UicZfge1z0AGwcjRVNkZpkZIRDiPQOTgaCYq05Xie49MZOhXJuSvNFMhQ0U63gwwxD1szovXz2/ctnT9DLZ4+PHzw9fvDT8cOHxw9+tLSchds4jcoLX3z72Z9ff4z+ePLNi0df+PGyjP/1h09++flzPxCyaSbR8y8f//b08fOvPv39u0ce+KbAgzK8TxMi0U1yhPZ4Arp5JCcDcb4V/RhTZwWOgbaHdFfFDvDmBDMfrk1c490RUEh8wGvje46s+7EYK+rhfD1OHOAO56zNhdcA1zWvkoX74zTyMxfjMm4P40Mf7w5OHdd2xxlU0yIonajpxMQRc5fhVOGIpEQh/Y4fEOLR7i6ljl13aCi45COF7lLUxtRrkj4dOIE0W7RNE/DLxKczuNqxzc4d1ObMp/UWOXSRkBCYeYTvE+aY8RoeK5z4SPZxwsoGv4FV7BNyfyLCMq4rFXg6Ioyj7pBI6VtzS4C+Jadfx1C7vG7fYZPERQpFD3w0b2DOy8gtftCJcZJ5ZaZpXMZ+IA8gRDHa5coH3+Fuhugx+AGnp7r7DiWOu88uBLdp5Ig0CxD9Ziw8vrxGuJuPEzbCxFQZKO9OpU5o+qqyzSjU7Xdlu9jHNmET8yXP9olifRruX1iit/A43SWQFfNb1LsK/a5CB//5Cn1aLl98XZ6VYqjSs77bNLXJQk34iDK2ryaM3JCmD5ewGQ17MGkG5vQ4PaBlMTzmW4KDiwQ2a5Dg6iOq4v0YZ9DDV82xNJI56UiijEs4R5ppL21zjKXQxptTaL04bwIaqx0+tNMr5XPolIzZqCJz7i0YrWgCizJbWc0Pt6/JrGqlWlC1qhHNFEhHtanKoMy8akbD3JrQ5SDojcDKDTjQa2pw9sGMDLXd7bZduMXY5CJdJGM8JLmPtN7zilSNk4pYKcLI4yN9pjzDaiVuTU32Dbgt4qQyu9op7ArvvYmXCuvMvKRz+EQ6srScnCxFR62gWV+uByjEWSsYwbEZHpMMvC51Y4lZBPdToRI2EM9MZoOaebPpD8sq3Iqc4k2HRSak2sIytqFhXhXXNKk55Bv5l+tg1otSwEb6a0ixsgbB8LdJATK7riWjEQlV2dmlGXMHYgB58vOxImI/Hh6hARuLPQzu16EK+gyphNsPUxH0AK7ttLXNyC3OedKVL8sMzs5jlsU4L7c6RYtMtnBj86kMZlQSbzoy2sxkPzFcVBWT8hekSjmM/2eq6P0EriNWhub2DG6TBUY6X1sBFyrmUIWymIY9AZdoJgIgWuDqF16D8eFO2/wKcqh/bc5ZGiat4VSp9miEBIX9SMWCkF0oSyb6ziBWzfcuS7IgZHN6Jq7MrNgDckhYX9eQht7bAxQX1SQvAwZ3Mv7ccR52g0g3LP/Uzscm83nbg1nnY9cv2IvUSkW/tBU030yEc261tmLNabxcX3irzeBSCel/sP9RETJi9Ncbap/vQelE044SQVRfso0H0gXSPg2gcbKTNpg0qbfbRs063Snft9h8lrb5aXPmsnNy8dXd5/mMnVvYsXW50/WYGhxwMkV1e1QcaoxjzJe18gcvPrgHjt6CTwhjpqT9dHAfrhBhy7IfJCD5rXPN0o2/AFBLAwQUAAAACACBRr1casVk3eMCAACWBgAADwAAAHhsL3dvcmtib29rLnhtbKVV0W7aMBR9n7R/8CykPYVgk6YQEaq2KRtSNzGVtY/IJIZYTeLIMRBU9d93nRBKhiZVXQQ2vtc5Pvf42IyuyjRBW64KITMfk24PI56FMhLZ2se/5xNrgFGhWRaxRGbcx3te4Kvx50+jnVTPSymfEQBkhY9jrXPPtosw5ikrujLnGWRWUqVMw1Ct7SJXnEVFzLlOE5v2eq6dMpHhGsFT78GQq5UIeSDDTcozXYMonjAN9ItY5EWDlobvgUuZet7kVijTHCCWIhF6X4FilIbedJ1JxZYJlF2SC1Qq+LjwJT1oaLMSpM6WSkWoZCFXugvQdk36rH7SswlpSVCea/A+JAdE2Aqzh0dWyv0gKyNojQUq1FtjSv5vNALWauDoB9EujtwoHo9WIuGPtXURy/OfLDU7lWCUsELfRULzyMeXMJQ73gqoTX6zEQlkqetSF9vjo51nCgGs5mqmxJaFezgTGMUi4jOxlXoieBLdi0JX4Yiv2CbRc3B8wwPi1KE1ZKm8RsmZVgh+T4N7YPbAtsAT1IgONp4CEdJfZKHyyOLlmvZvbt3gziLD4cRy7uildT0ZDqyhcxGQiUOdwV3wClIq1wsl2+j4IIGB9rED9Z6lfrCyyZCetxHRG42X3uGxTP9X0+ReTTnmsD8KvivexDJDVD6JLJI7H1uEQlH79nBXJZ9EpGMf9weuA1Pq2Hcu1jEwpqAYBFmoxZbP2bKSFs6X4enjFr+g5jeBp2pa/OwTgtUlA0SrHmWVMb7do7kSLEE3LGFZyJGFAq6ZAL9U06pdwEh5Zlk1jYgp+hSgcoDVxqhiJwBwKxwB6BkAU8AEvAW31HHJ/skbffOG3ZAHe4mMR8bWUMrJ6FDQokyytLuYVHYNmGZLVnDj9pAlD01FoCy4N+Lmcsfjr/8U4euXznWHeJ1fHTKyT9YCPm0eAB7CITFdpRillFRS5UaKWwb3P7B9G8BMCJmp/dNSnarU1jt285cy/gNQSwMEFAAAAAgAgUa9XMihuPq4AAAANAEAACMAAAB4bC93b3Jrc2hlZXRzL19yZWxzL3NoZWV0Mi54bWwucmVsc4WPwQrCMBBE74L/EPZu0noQkaa9iOBV6ges6bYNtknIRtG/N8cKgrfZHfbNTtW85kk8KbL1TkMpCxDkjO+sGzRc29NmD4ITug4n70jDmxiaer2qLjRhykc82sAiUxxrGFMKB6XYjDQjSx/IZaf3ccaUxziogOaOA6ltUexUXDKg/mKKc6chnrsSRPsOOfk/2/e9NXT05jGTSz8iVLBPn1q8TZSpGAdKGqRcrHmhS5l/B1VX6qtr/QFQSwMEFAAAAAgAgUa9XF6lvfg+AwAAkwkAABgAAAB4bC93b3Jrc2hlZXRzL3NoZWV0MS54bWydlt9v2jAQx98n7X+w/LA3kjj8ZkC1FbFW6qRu7bZn4zhg1Ykz2xTotP99ZychVFU1UgTxxU4+/vp8d3h6sc8keuTaCJXPMAkijHjOVCLy9Qz/uF92RhgZS/OESpXzGT5wgy/m799Nd0o/mA3nFgEhNzO8sbaYhKFhG55RE6iC5zCSKp1RC7d6HZpCc5r4lzIZxlE0CDMqclwSJvochkpTwfhCsW3Gc1tCNJfUgn6zEYWpaRk7B5dR/bAtOkxlBSBWQgp78FCMMja5XudK05WEde9JjzK01/CN4detp/H9L2bKBNPKqNQGQA5LzS+XPw7HIWVH0sv1n4UhPXDAo3Ab2KDit0ki/SMrbmDdN8LczpTCnLv0ZCuSGf4TVZ8OtMRdouZSj/3F82kiYIfdy0jzdIY/kck3EuNwPvUB9FPwnTmxkYvHlVIPbuAa5okAUdCco8NdAbsKsY2RVcUNT+0llxKAsELKrHjkt/DYDK+UtSpz4z7iLXSlWj3x3M/JJYdnQYxjPn+4hDRQ87sU7MWGR7Wndq186bPjVqOEp3Qr7aWSv0RiN6AWErHq/K52V1ysN24NcTDsgy9d0E2Sw4IbBlkAiw38ZExJIMMVZcJlMwQx3ft2V1HHwajf7w1GjrLixi4rz7CtgcXXc1eskgJu8hTYw5rSC4YkGndbQHoVBNpGSlsIaPZKoD1Czl6Gy2j3MrT1y8OA9KJBfL4rhhUD2ooRk6AX94cj0oICFdUrgbbxRWvKuKJAW1MGrbfFRVkZImA0mNZiyDHUTmKtF8SjPum3cTAkeKUHjFpPFPSHUbeNhwnEarmsk6CN2u8UqcPWGbUc0l5OHbjkJHLPjzpSh64zmhRsncikDl9nHDn/S6CwLCq+jC2opXUZK226tWoppOX6pEq/UuzHrxZ7KF0FXfOvVK9FbpCEGuxqGsjUZd3zNlRvbznP+Vpd323gVMHh3zMKYLtTpUBNeVNx77jdFlC4C67vxBNUb8gZpQVUTn9smGEJ5xvDYByjDQw8KRiRi0K4fxF3OLKCHe+BWc639BPNpypJrnzH/APNio+XX27QvRZUos8UuIyjDlpwS4Wchs2j0/A5JDwep+b/AFBLAwQUAAAACACBRr1cDcMON3YDAAD8CgAAGAAAAHhsL3dvcmtzaGVldHMvc2hlZXQyLnhtbJ1WXY/aOBR9X2n/Q+T3SeJA+BJQdYbSodOVqu1+PJvgQDRJnLUNM9PV/vceOwkkZIXSIogd3+Pjc6/vtZm/e81S58SlSkS+INT1icPzSOySfL8gf/6xvpsQR2mW71gqcr4gb1yRd8tff5m/CPmsDpxrBwy5WpCD1sXM81R04BlTrih4DkssZMY0XuXeU4XkbGcnZakX+P7Iy1iSk5JhJvtwiDhOIr4S0THjuS5JJE+Zhn51SApVs2VRH7qMyedjcReJrADFNkkT/WZJiZNFs80+F5JtU/j9Socscl4lvgF+g3oZO95ZKUsiKZSItQtmr9TcdX/qTT0WnZm6/veioUME4JSYDbxQBT8niYZnruBCNvhJMrMzpTATLjk7JrsF+devPndoqXn4dz41j8bnP7Kc7xLssJnsSB4vyHs6exoSbzm3+fNXwl9Uo+9otv3KUx5pjjUocUx6boV4NsANhnwwFiznztvXAptsMVoUn3msH3iagh8Os0gnJ/4FsAXZCq1FZuy2ADSGYim+8dxqsEsZbYazDS5JLqTqn1J/YCZ6Z/XNfu3J2hbLF+nseMyOqX4Q6d/JTh+glrrDIBxPaBCS2vq7eHnkyf5gnAncMQw2GWe7txVXEaoDXrt21UikWAJPJ0tMlSO52WsZppJ+MHInYTgcTQzLliu9rkIUHRWiUIuouEoWxMuyoK1Y6MSlQ39kJPbkQF5YDrQ1R9hwtCfLsGJBW7OM3HDsD2y0epIAaaWgvbjzoyTjigRtRRLAtZ4KcNJaBWiryVM3mIQ0/JGITisStLUb2KCeCihO/zIz0Kmno9t3+jmxLplF/b474ZVZagtkxTRbzqV4cXAogkyhzHDF0BnFy/9mOdLbYN8b8IIgE5D9CjV/Wvpz74RiiyrEfRdB24iHLiJoI1ZdxKCN+NBFDNuIdRcRthEfu4hRG/HYRYzbiI055upITNq2T03btG17atroJYQe9uS8MUis/hsD8FkIvYr4/S3jwy3j6pbxwy3j+pbx4y3j4y3jxgTFnCLm2DUZ+el64Kkx0AonTore4VwBfAnnVXpuDFNLw/XAU2OgpQGF01vDfbPK6LUGw9TScD2A2/yMKDWUl2NZ+wXb89+Y3Ce5clJcwuYuw6kqy/vO9nF925454+1lXb8d8C+TI/S+CzdjIXT9Yi7g8//W5XdQSwECFAAUAAAACACBRr1ckO8c1poBAABtBwAAEwAAAAAAAAAAACAAtoEAAAAAW0NvbnRlbnRfVHlwZXNdLnhtbFBLAQIUABQAAAAIAIFGvVy1VTAj7gAAAEwCAAALAAAAAAAAAAAAIAC2gcsBAABfcmVscy8ucmVsc1BLAQIUABQAAAAIAIFGvVyclN/2pQEAAHYDAAAQAAAAAAAAAAAAIAC2geICAABkb2NQcm9wcy9hcHAueG1sUEsBAhQAFAAAAAgAgUa9XPxmAyo8AQAAUQIAABEAAAAAAAAAAAAgALaBtQQAAGRvY1Byb3BzL2NvcmUueG1sUEsBAhQAFAAAAAgAgUa9XE1B1tIaAQAAewQAABoAAAAAAAAAAAAgALaBIAYAAHhsL19yZWxzL3dvcmtib29rLnhtbC5yZWxzUEsBAhQAFAAAAAgAgUa9XOIrf3u7AAAAMwEAADIAAAAAAAAAAAAgALaBcgcAAHhsL3Bpdm90Q2FjaGUvX3JlbHMvcGl2b3RDYWNoZURlZmluaXRpb24xLnhtbC5yZWxzUEsBAhQAFAAAAAgAgUa9XMGO6hT0AwAA4xAAACcAAAAAAAAAAAAgALaBfQgAAHhsL3Bpdm90Q2FjaGUvcGl2b3RDYWNoZURlZmluaXRpb24xLnhtbFBLAQIUABQAAAAIAIFGvVwtC7dbFgEAAOgGAAAkAAAAAAAAAAAAIAC2gbYMAAB4bC9waXZvdENhY2hlL3Bpdm90Q2FjaGVSZWNvcmRzMS54bWxQSwECFAAUAAAACACBRr1cCkEM6r0AAABHAQAAKQAAAAAAAAAAACAAtoEODgAAeGwvcGl2b3RUYWJsZXMvX3JlbHMvcGl2b3RUYWJsZTEueG1sLnJlbHNQSwECFAAUAAAACACBRr1cW+0nYa8EAAA0EwAAHgAAAAAAAAAAACAAtoESDwAAeGwvcGl2b3RUYWJsZXMvcGl2b3RUYWJsZTEueG1sUEsBAhQAFAAAAAgAgUa9XJzNpYJvAwAAbAkAAA0AAAAAAAAAAAAgALaB/RMAAHhsL3N0eWxlcy54bWxQSwECFAAUAAAACACBRr1cwofb8lEGAADXGwAAEwAAAAAAAAAAACAAtoGXFwAAeGwvdGhlbWUvdGhlbWUxLnhtbFBLAQIUABQAAAAIAIFGvVxqxWTd4wIAAJYGAAAPAAAAAAAAAAAAIAC2gRkeAAB4bC93b3JrYm9vay54bWxQSwECFAAUAAAACACBRr1cyKG4+rgAAAA0AQAAIwAAAAAAAAAAACAAtoEpIQAAeGwvd29ya3NoZWV0cy9fcmVscy9zaGVldDIueG1sLnJlbHNQSwECFAAUAAAACACBRr1cXqW9+D4DAACTCQAAGAAAAAAAAAAAACAAtoEiIgAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1sUEsBAhQAFAAAAAgAgUa9XA3DDjd2AwAA/AoAABgAAAAAAAAAAAAgALaBliUAAHhsL3dvcmtzaGVldHMvc2hlZXQyLnhtbFBLBQYAAAAAEAAQAH8EAABCKQAAAAA= xl/worksheets/sheet1.xml xl/worksheets/sheet3.xml 1 0 Ledger Name 1 Currency Code 2 Pivot Segment 3 Pivot Segment Value 4 Pivot Segment Desc 5 Account Segment 6 Account Segment Desc 7 Account 8 Begin Balance 9 Period Net 10 End Balance 11 (blank) 12 (blank) Total data A1 1 data B1 1 data C1 1 data D1 1 data E1 1 data F1 1 data G1 1 data H1 1 data I 3 data I1 1 data J 3 data J1 1 data K 3 data K1 1 data L 3 data L1 1 data M 3 data M1 1 data N 3 data N1 1 data O 3 data O1 1 data P 3 data P1 1 data Q 3 data Q1 1 parameter A1 1 parameter A10 1 parameter A11 1 parameter A12 1 parameter A13 1 parameter A14 1 parameter A15 1 parameter A16 1 parameter A17 1 parameter A18 1 parameter A19 1 parameter A2 1 parameter A20 1 parameter A21 1 parameter A22 1 parameter A3 1 parameter A4 1 parameter A5 1 parameter A6 1 parameter A7 1 parameter A8 1 parameter B3 2 S Site 9C6497FD592A86028AECDD9E1EDBA784 Trial Balance Pivot_KLAM Y KLAM 8 ACCOUNT 6 ACCOUNT_SEGMENT 7 ACCOUNT_SEGMENT_DESC 9 BEGIN_BALANCE BEGIN_BALANCE_CR BEGIN_BALANCE_DR 2 CURRENCY_CODE 11 END_BALANCE END_BALANCE_CR END_BALANCE_DR 1 LEDGER_NAME PERIOD_CR PERIOD_DR 10 PERIOD_NET 3 PIVOT_SEGMENT 5 PIVOT_SEGMENT_DESC 4 PIVOT_SEGMENT_VALUE ACCOUNT ROW 8 ACCOUNT_SEGMENT ROW 6 ACCOUNT_SEGMENT_DESC ROW 7 BEGIN_BALANCE VALUE 1 SUM CURRENCY_CODE ROW 2 END_BALANCE VALUE 3 SUM LEDGER_NAME ROW 1 PERIOD_NET VALUE 2 SUM PIVOT_SEGMENT ROW 3 PIVOT_SEGMENT_DESC ROW 5 PIVOT_SEGMENT_VALUE ROW 4 S Site KLAM 9C6497FD592A86028AECDD9E1EDBA784 3F06581380C069C199B0437381BE9487