ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN B054531DF5620463E0530100007F09D5Y select rx.organization_name ledger, haouv.name operating_unit, rx.rec_postable_flag postable, rx.rec_balance "&bal_segment_p", rx.rec_balance_desc "&bal_segment_d", rx.trx_currency currency, arpt_sql_func_util.get_lookup_meaning('INV/CM',trx_types.type) class, rx.trx_number invoice_number, rx.doc_sequence_value document_number, trx_types.name "Type", substrb(bill_to_party.party_name,1,50) customer_name, bill_to.account_number customer_number, bill_to_site.location customer_site, rx.trx_date invoice_date, rx.receivables_gl_date gl_date, rx.trx_amount entered_amount, rx.trx_acctd_amount functional_amount, rx.trx_amount-arpt_sql_func_util.get_sum_of_trx_lines(rx.customer_trx_id,'TAX') total_line_amount, arpt_sql_func_util.get_sum_of_trx_lines(rx.customer_trx_id,'TAX') total_tax_amount, &il_tax_columns rx.rec_natacct receivables_account, rx.rec_natacct_desc receivables_account_desc, rx.rec_account receivables_account_full, rx.rec_account_desc receivables_account_full_desc, rx.functional_currency_code functional_currency, rx.exchange_type exchange_rate_type, rx.exchange_date exchange_rate_date, rx.exchange_rate exchange_rate, terms.name payment_terms, rx.trx_due_date invoice_due_date, methods.name payment_method, arpt_sql_func_util.get_lookup_meaning('YES/NO', nvl(bill_to_site.tax_header_level_flag, nvl(bill_to.tax_header_level_flag, rx.tax_header_level_flag))) tax_calculation_level, bas.name batch_source, ba.name batch_name, rx.cons_bill_number consolidated_bill_number, doc_seq.name document_sequence_name, substrb(ship_to_party.party_name,1,50) ship_to_customer_name, ship_to.account_number ship_to_customer_number, ship_to_site.location ship_to_customer_site &il_reg_columns from ar_transactions_rep_itf rx, ra_terms terms, fnd_document_sequences doc_seq, hz_cust_accounts ship_to, hz_parties ship_to_party, hz_cust_accounts bill_to, hz_parties bill_to_party, hz_cust_site_uses_all ship_to_site, hz_cust_site_uses_all bill_to_site, ra_cust_trx_types_all trx_types, ar_receipt_methods methods, ra_batches_all ba, ra_batch_sources_all bas, hr_all_organization_units_vl haouv &il_from where 1=1 and rx.ship_to_customer_id = ship_to.cust_account_id(+) and ship_to.party_id = ship_to_party.party_id(+) and rx.ship_to_site_use_id = ship_to_site.site_use_id(+) and rx.bill_to_customer_id = bill_to.cust_account_id and bill_to.party_id = bill_to_party.party_id and rx.bill_to_site_use_id = bill_to_site.site_use_id and rx.cust_trx_type_id = trx_types.cust_trx_type_id and rx.term_id = terms.term_id(+) and rx.doc_sequence_id = doc_seq.doc_sequence_id(+) and rx.receipt_method_id = methods.receipt_method_id(+) and nvl(rx.org_id, -99) = nvl(trx_types.org_id, -99) and rx.batch_id = ba.batch_id(+) and rx.batch_source_id = bas.batch_source_id(+) and nvl(rx.org_id, -99) = nvl(bas.org_id, -99) and rx.request_id = fnd_global.conc_request_id and rx.org_id = haouv.organization_id (+) &il_where order by rx.organization_name, rx.rec_balance, rx.rec_postable_flag, rx.trx_currency, arpt_sql_func_util.get_lookup_meaning('INV/CM',trx_types.type), rx.trx_number, rx.doc_sequence_value Added India GST columns reporting in transaction currency, displayed only when India Localization is installed. XXEN_AR AR AR Transaction Register Application: المقبوضات Source: مسجل الحركة Short Name: ARRXINVR D AR Transaction Register Application: Debitoren Source: Transaktionen - Liste Short Name: ARRXINVR E AR Transaction Register Aplicación: Cuentas por cobrar Fuente: Registro de transacciones Nombre corto: ARRXINVR F AR Transaction Register Application: Receivables Source: Registre des mouvements Short Name: ARRXINVR I AR Transaction Register Application: Receivables Source: Registro transazioni Short Name: ARRXINVR JA AR Transaction Register 申請書を提出する。売掛債権 ソースは以下の通りです。トランザクションレジスタ ショートネームです。ARRXINVR KO AR Transaction Register 신청 : AR 출처 : 거래 등록 짧은 이름 : ARRXINVR PTB AR Transaction Register Aplicação: Contas a receber Fonte: Registro de Transações Nome curto: ARRXINVR RU AR Transaction Register Приложение: Дебиторская задолженность Источник: Реестр транзакций Короткое имя: ARRXINVR S AR Transaction Register Ansökan: Fordringar Källa: Transaktionsregister Kort namn: ARRXINVR TR AR Transaction Register Uygulama: Alacaklar Kaynak: İşlem Kaydı Kısa isim: ARRXINVR US AR Transaction Register Application: Receivables Source: Transaction Register Short Name: ARRXINVR The report has now been enhanced to allow multiple accessible Ledgers or Operating Units to be selected in the Reporting Context parameter. Additionally, the Reporting Context parameter has been made optional. Leaving it null will allow the report to be run across all accessible Ledgers or Operating Units. When India Localization is installed, the following GST columns are also included: IGST Amount, IGST Recoverable, IGST Non-Recoverable, CGST Amount, CGST Recoverable, CGST Non-Recoverable, SGST Amount, SGST Recoverable, SGST Non-Recoverable, CESS Amount, CESS Rate, Custom Amount, Unclassified Tax Amount, Unclassified Tax Rate Codes, Taxable Value, HSN SAC Code, HSN Length Warning, GST State Tax Mismatch, GST Registration No, GST PAN No, Reverse Charge Flag, Place of Supply, Ship From State. ZHS AR Transaction Register Application: 应收帐款 Source: 事务处理登记 Short Name: ARRXINVR Enginatics &bal_segment_d &bal_segment_p &il_from &il_reg_columns &il_tax_columns &il_where 1=1 :p_adjustment_type_high :p_adjustment_type_low :p_application_name :p_attribute_set :p_bal_seg_high :p_bal_seg_low :p_batch_source_name :p_coa_id :p_concurrent_program_name :p_document_sequence_name :p_document_sequence_num_high :p_document_sequence_num_low :p_entered_currency_high :p_entered_currency_low :p_gl_account_flex_high :p_gl_account_flex_low :p_gl_date_from :p_gl_date_to :p_ledger_id :p_out_of_balance_only :p_output_format :p_period_name :p_report_code :p_report_id :p_reporting_entity_id :p_reporting_entity_name :p_reporting_level :p_request_type :p_summary_account :p_transaction_class :p_transaction_date_high :p_transaction_date_low :p_transaction_due_date_high :p_transaction_due_date_low :p_transaction_type_high :p_transaction_type_low 1 -110 1=1 :India_Localization=:India_Localization Char Y xxen_util.jai_installed US India Localization 2 &il_from ,(select jtlv.trx_id, sum(decode(jrav.reporting_code,'CGST',jtlv.rounded_tax_amt_trx_curr)) cgst_amount, sum(decode(jrav.reporting_code,'SGST',jtlv.rounded_tax_amt_trx_curr)) sgst_amount, sum(decode(jrav.reporting_code,'IGST',jtlv.rounded_tax_amt_trx_curr)) igst_amount, sum(decode(jrav.reporting_code,'CESS',jtlv.rounded_tax_amt_trx_curr)) cess_amount, sum(decode(jrav.reporting_code,'CUSTOM',jtlv.rounded_tax_amt_trx_curr)) custom_amount, sum(decode(jrav.reporting_code,null,jtlv.rounded_tax_amt_trx_curr)) unclassified_amount, max(decode(jrav.reporting_code,'CGST',jtlv.tax_rate_code)) cgst_tax_rate, max(decode(jrav.reporting_code,'SGST',jtlv.tax_rate_code)) sgst_tax_rate, max(decode(jrav.reporting_code,'IGST',jtlv.tax_rate_code)) igst_tax_rate, max(decode(jrav.reporting_code,'CESS',jtlv.tax_rate_code)) cess_tax_rate, sum(decode(jrav.reporting_code,'CGST',jtlv.rec_tax_amt_trx_curr)) cgst_rec_amount, sum(decode(jrav.reporting_code,'CGST',jtlv.nrec_tax_amt_trx_curr)) cgst_nrec_amount, sum(decode(jrav.reporting_code,'SGST',jtlv.rec_tax_amt_trx_curr)) sgst_rec_amount, sum(decode(jrav.reporting_code,'SGST',jtlv.nrec_tax_amt_trx_curr)) sgst_nrec_amount, sum(decode(jrav.reporting_code,'IGST',jtlv.rec_tax_amt_trx_curr)) igst_rec_amount, sum(decode(jrav.reporting_code,'IGST',jtlv.nrec_tax_amt_trx_curr)) igst_nrec_amount, max(jtlv.self_assessed_flag) reverse_charge_flag, sum(decode(jrav.reporting_code,'CGST',jtlv.rounded_taxable_amt_trx_curr,'IGST',jtlv.rounded_taxable_amt_trx_curr)) taxable_value, max(jrc.reporting_code) hsn_sac_code, max(case when length(jrc.reporting_code)<6 then 'Below 6 digits' end) hsn_length_warning, max(case when jtdf.ship_from_state<>jtdf.ship_to_state and jrav.reporting_code in ('CGST','SGST') and jtlv.rounded_tax_amt_trx_curr<>0 then 'CGST/SGST on interstate' when jtdf.ship_from_state=jtdf.ship_to_state and jrav.reporting_code='IGST' and jtlv.rounded_tax_amt_trx_curr<>0 then 'IGST on intrastate' end) state_tax_mismatch from jai_tax_lines_v jtlv, jai_reporting_associations_v jrav, jai_tax_det_factors jtdf, jai_reporting_codes jrc where jtlv.tax_type_id=jrav.entity_id(+) and jrav.entity_code(+)='TAX_TYPE' and jrav.reporting_type_code(+)='TAX_TYPES_CLASSIFICATION' and jtlv.det_factor_id=jtdf.det_factor_id(+) and jtdf.application_id(+)=222 and nvl(jtdf.hsn_code_id,jtdf.sac_code_id)=jrc.reporting_code_id(+) and jtlv.application_id=222 group by jtlv.trx_id ) il_tax Y US India Localization 3 &il_reg_columns ,nvl(coalesce( ( select nvl(jprl.registration_number,jprl.secondary_registration_number) from ra_customer_trx_all rcta0, hz_cust_site_uses_all hcsua, jai_party_regs_v jpr, jai_party_reg_lines_v jprl where rx.customer_trx_id=rcta0.customer_trx_id and rcta0.bill_to_site_use_id=hcsua.site_use_id and hcsua.cust_acct_site_id=jpr.party_site_id and jpr.party_type_code='THIRD_PARTY_SITE' and jpr.customer_flag='Y' and jpr.party_reg_id=jprl.party_reg_id and jprl.registration_type_code in ('GST','GSTIN') and jprl.regime_id in (select jr.regime_id from jai_regimes jr where jr.regime_type='T') and jprl.effective_from<=rcta0.trx_date and (jprl.effective_to is null or jprl.effective_to>=rcta0.trx_date) and rownum=1 ), ( select nvl(jprl.registration_number,jprl.secondary_registration_number) from ra_customer_trx_all rcta0, hz_cust_site_uses_all hcsua, jai_party_regs_v jpr, jai_party_reg_lines_v jprl where rx.customer_trx_id=rcta0.customer_trx_id and rcta0.bill_to_site_use_id=hcsua.site_use_id and hcsua.cust_acct_site_id=jpr.party_site_id and jpr.party_type_code='THIRD_PARTY_SITE' and jpr.customer_flag='Y' and jpr.party_reg_id=jprl.party_reg_id and regexp_like(nvl(jprl.registration_number,jprl.secondary_registration_number),'^[0-9]{2}[A-Z]{5}[0-9]{4}[A-Z][0-9A-Z]Z[0-9A-Z]$') and jprl.regime_id in (select jr.regime_id from jai_regimes jr where jr.regime_type='T') and jprl.effective_from<=rcta0.trx_date and (jprl.effective_to is null or jprl.effective_to>=rcta0.trx_date) and rownum=1 )),coalesce( ( select nvl(jprl.registration_number,jprl.secondary_registration_number) from ra_customer_trx_all rcta0, jai_party_regs_v jpr, jai_party_reg_lines_v jprl where rx.customer_trx_id=rcta0.customer_trx_id and rcta0.bill_to_customer_id=jpr.party_id and jpr.party_type_code='THIRD_PARTY' and jpr.customer_flag='Y' and jpr.party_reg_id=jprl.party_reg_id and jprl.registration_type_code in ('GST','GSTIN') and jprl.regime_id in (select jr.regime_id from jai_regimes jr where jr.regime_type='T') and jprl.effective_from<=rcta0.trx_date and (jprl.effective_to is null or jprl.effective_to>=rcta0.trx_date) and rownum=1 ), ( select nvl(jprl.registration_number,jprl.secondary_registration_number) from ra_customer_trx_all rcta0, jai_party_regs_v jpr, jai_party_reg_lines_v jprl where rx.customer_trx_id=rcta0.customer_trx_id and rcta0.bill_to_customer_id=jpr.party_id and jpr.party_type_code='THIRD_PARTY' and jpr.customer_flag='Y' and jpr.party_reg_id=jprl.party_reg_id and regexp_like(nvl(jprl.registration_number,jprl.secondary_registration_number),'^[0-9]{2}[A-Z]{5}[0-9]{4}[A-Z][0-9A-Z]Z[0-9A-Z]$') and jprl.regime_id in (select jr.regime_id from jai_regimes jr where jr.regime_type='T') and jprl.effective_from<=rcta0.trx_date and (jprl.effective_to is null or jprl.effective_to>=rcta0.trx_date) and rownum=1 ))) "GST Registration No", ( select nvl(jprl.registration_number,jprl.secondary_registration_number) from ra_customer_trx_all rcta0, jai_party_regs_v jpr, jai_party_reg_lines_v jprl where rx.customer_trx_id=rcta0.customer_trx_id and rcta0.bill_to_customer_id=jpr.party_id and jpr.party_type_code='THIRD_PARTY' and jpr.customer_flag='Y' and jpr.party_reg_id=jprl.party_reg_id and jprl.registration_type_code='PAN' and jprl.effective_from<=rcta0.trx_date and (jprl.effective_to is null or jprl.effective_to>=rcta0.trx_date) and rownum=1 ) "GST PAN No", xxen_util.meaning(il_tax.reverse_charge_flag,'YES_NO',0) "Reverse Charge Flag", (select max(jtdf.ship_to_state) from jai_tax_det_factors jtdf where jtdf.trx_id=rx.customer_trx_id and jtdf.application_id=222) "Place of Supply", (select max(jtdf.ship_from_state) from jai_tax_det_factors jtdf where jtdf.trx_id=rx.customer_trx_id and jtdf.application_id=222) "Ship From State" Y US India Localization 4 &il_tax_columns il_tax.igst_amount "IGST Amount", il_tax.igst_rec_amount "IGST Recoverable", il_tax.igst_nrec_amount "IGST Non-Recoverable", il_tax.cgst_amount "CGST Amount", il_tax.cgst_rec_amount "CGST Recoverable", il_tax.cgst_nrec_amount "CGST Non-Recoverable", il_tax.sgst_amount "SGST Amount", il_tax.sgst_rec_amount "SGST Recoverable", il_tax.sgst_nrec_amount "SGST Non-Recoverable", il_tax.cess_amount "CESS Amount", il_tax.cess_tax_rate "CESS Rate", il_tax.custom_amount "Custom Amount", il_tax.unclassified_amount "Unclassified Tax Amount", ( select listagg(ut.tax_rate_code,', ') within group (order by ut.tax_rate_code) from ( select distinct jtlv.trx_id, jtlv.tax_rate_code from jai_tax_lines_v jtlv, jai_reporting_associations_v jrav where jtlv.tax_type_id=jrav.entity_id(+) and jrav.entity_code(+)='TAX_TYPE' and jrav.reporting_type_code(+)='TAX_TYPES_CLASSIFICATION' and jrav.reporting_code is null and jtlv.application_id=222 ) ut where ut.trx_id=rx.customer_trx_id ) "Unclassified Tax Rate Codes", il_tax.taxable_value "Taxable Value", il_tax.hsn_sac_code "HSN SAC Code", il_tax.hsn_length_warning "HSN Length Warning", il_tax.state_tax_mismatch "GST State Tax Mismatch", Y US India Localization 5 &il_where and rx.customer_trx_id=il_tax.trx_id(+) Y US India Localization 6 -80 :p_request_type Char SUBMIT US Request Type 7 -70 :p_application_name Char AR US FARX_APP_NAME 8 -60 :p_concurrent_program_name Char RXARINVR US FARX_CONC_NAME 9 -50 :p_report_id Number select distinct report_id from fa_rx_reports r, fnd_concurrent_programs c, fnd_application a where r.application_id = a.application_id and r.application_id = c.application_id and r.concurrent_program_id = c.concurrent_program_id and a.application_short_name = :$FLEX$.FARX_APP_NAME and c.concurrent_program_name = :$FLEX$.FARX_CONC_NAME US FARX_REPORT_ID 10 -40 :p_output_format Char TEXT Y US Output Format 11 -30 :p_coa_id Number select gsob.chart_of_accounts_id from gl_sets_of_books gsob, ar_system_parameters asp, hr_all_organization_units haou where gsob.set_of_books_id=asp.set_of_books_id and asp.org_id=haou.organization_id and ( :$flex$.reporting_context is null or :$flex$.reporting_level='1000' and xxen_util.contains(:$flex$.reporting_context,gsob.name)='Y' or :$flex$.reporting_level='3000' and xxen_util.contains(:$flex$.reporting_context,haou.name)='Y' ) and rownum=1 US Chart of Accounts Id 12 &bal_segment_d select fifsv.form_left_prompt || ' Desc' from fnd_segment_attribute_values fsav , fnd_id_flex_segments_vl fifsv where fsav.application_id = 101 and fsav.id_flex_code = 'GL#' and fsav.segment_attribute_type = 'GL_BALANCING' and fsav.id_flex_num = :p_coa_id and fsav.attribute_value = 'Y' and fifsv.application_id = fsav.application_id and fifsv.id_flex_code = fsav.id_flex_code and fifsv.id_flex_num = fsav.id_flex_num and fifsv.application_column_name = fsav.application_column_name US Chart of Accounts Id 13 &bal_segment_p select fifsv.form_left_prompt from fnd_segment_attribute_values fsav , fnd_id_flex_segments_vl fifsv where fsav.application_id = 101 and fsav.id_flex_code = 'GL#' and fsav.segment_attribute_type = 'GL_BALANCING' and fsav.id_flex_num = :p_coa_id and fsav.attribute_value = 'Y' and fifsv.application_id = fsav.application_id and fifsv.id_flex_code = fsav.id_flex_code and fifsv.id_flex_num = fsav.id_flex_num and fifsv.application_column_name = fsav.application_column_name US Chart of Accounts Id 14 -20 :p_attribute_set LOV Oracle FARX_ATTRIBUTE_SET Y select attr.attribute_set id, attr.attribute_set value, attr.user_attribute_set description from fa_rx_attrsets_vl attr where attr.report_id=:$flex$.farx_report_id and (attr.public_flag='Y' or fnd_global.resp_id in (select sec.responsibility_id from fa_rx_security sec where sec.report_id=attr.report_id and sec.attribute_set=attr.attribute_set)) order by decode(attr.attribute_set,'DEFAULT',0,1), attr.user_attribute_set, attr.attribute_set DEFAULT Y US FARX_ATTRIBUTE_SET 15 -10 :p_report_code Char ARRXINVR Y US Report Code 16 10 :p_reporting_level LOV Oracle FND_MO_REPORTING_LEVEL Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='FND_MO_REPORTING_LEVEL' and lookup_code in (1000,3000) order by value,description 1000 Y US Reporting Level 17 20 1=1 decode(:p_reporting_level,'1000',rx.organization_name,'3000',haouv.name,null) = :p_reporting_entity_name LOV custom Y select entity_name value, null description from fnd_mo_reporting_entities_v where reporting_level=:$flex$.fnd_mo_reporting_level and ( :$flex$.fnd_mo_reporting_level='1000' and ledger_category_code='PRIMARY' or :$flex$.fnd_mo_reporting_level='3000' ) order by value,description select fmrev.entity_name from fnd_mo_reporting_entities_v fmrev where fmrev.reporting_level=:$flex$.fnd_mo_reporting_level and rownum=1 US Reporting Context 18 30 :p_bal_seg_low LOV GL Balancing F26C78167A214EFBE0530100007F336B Y select distinct substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value, substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description from ( select fifs.id_flex_num, fifs.application_column_name from fnd_id_flex_segments fifs where fifs.application_id=101 and fifs.id_flex_code='GL#' and fifs.enabled_flag='Y' and (fifs.application_id, fifs.id_flex_code, fifs.id_flex_num, fifs.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_BALANCING' and fsav.attribute_value='Y') and (:$flex$.chart_of_accounts_id is not null or :$flex$.chart_of_accounts is not null or :$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null or :$flex$.book is not null) and fifs.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( fifsv.id_flex_num=:$flex$.chart_of_accounts_id or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or (:$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null) and fifsv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (:$flex$.operating_unit is null or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) or fifsv.id_flex_num in (select fbc.accounting_flex_structure from fa_book_controls fbc where xxen_util.contains(:$flex$.book,fbc.book_type_code)='Y') ) ) ) s, table(xxen_util.kff_segment_lov( p_application_id=>101, p_id_flex_code=>'GL#', p_id_flex_num=>s.id_flex_num, p_application_column_name=>s.application_column_name, p_enabled_only=>'N' )) l order by 1 US Company Segment Low 19 40 :p_bal_seg_high LOV GL Balancing F26C78167A214EFBE0530100007F336B Y select distinct substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value, substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description from ( select fifs.id_flex_num, fifs.application_column_name from fnd_id_flex_segments fifs where fifs.application_id=101 and fifs.id_flex_code='GL#' and fifs.enabled_flag='Y' and (fifs.application_id, fifs.id_flex_code, fifs.id_flex_num, fifs.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_BALANCING' and fsav.attribute_value='Y') and (:$flex$.chart_of_accounts_id is not null or :$flex$.chart_of_accounts is not null or :$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null or :$flex$.book is not null) and fifs.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( fifsv.id_flex_num=:$flex$.chart_of_accounts_id or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or (:$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null) and fifsv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (:$flex$.operating_unit is null or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) or fifsv.id_flex_num in (select fbc.accounting_flex_structure from fa_book_controls fbc where xxen_util.contains(:$flex$.book,fbc.book_type_code)='Y') ) ) ) s, table(xxen_util.kff_segment_lov( p_application_id=>101, p_id_flex_code=>'GL#', p_id_flex_num=>s.id_flex_num, p_application_column_name=>s.application_column_name, p_enabled_only=>'N' )) l order by 1 :$flex$.company_segment_low US Company Segment High 20 50 :p_gl_date_from Date trunc(sysdate,'MON') Y US GL Date From 21 60 :p_gl_date_to Date last_day(:$flex$.gl_date_From) Y US GL Date To 22 70 :p_gl_account_flex_low LOV custom Y select gcck.concatenated_segments value ,null description from gl_code_combinations_kfv gcck where gcck.chart_of_accounts_id = :$flex$.chart_of_accounts_id and gcck.enabled_flag = 'Y' and gcck.detail_posting_allowed = 'Y' and gcck.summary_flag = 'N' order by gcck.concatenated_segments US Receivables Account Low 23 80 :p_gl_account_flex_high LOV custom Y select gcck.concatenated_segments value ,null description from gl_code_combinations_kfv gcck where gcck.chart_of_accounts_id = :$flex$.chart_of_accounts_id and gcck.enabled_flag = 'Y' and gcck.detail_posting_allowed = 'Y' and gcck.summary_flag = 'N' order by gcck.concatenated_segments :$flex$.Receivables_Account_low US Receivables Account High 24 90 :p_entered_currency_low LOV Oracle AR_SRS_CURRENCY Y select currency_code id, currency_code value, name description from fnd_currencies_vl where currency_flag='Y' and enabled_flag in ('Y','N') order by currency_code US Entered Currency Low 25 100 :p_entered_currency_high LOV Oracle AR_SRS_CURRENCY Y select currency_code id, currency_code value, name description from fnd_currencies_vl where currency_flag='Y' and enabled_flag in ('Y','N') order by currency_code :$flex$.entered_currency_low US Entered Currency High 26 110 :p_transaction_date_low Date US Transaction Date Low 27 120 :p_transaction_date_high Date :$flex$.transaction_date_low US Transaction Date High 28 130 :p_batch_source_name LOV custom Y select name id, name value, null description from ra_batch_sources_all where nvl(org_id,-99) in (select -99 from dual union select hou.organization_id from hr_operating_units hou, gl_sets_of_books gsob where :$flex$.reporting_level = '1000' and to_number(hou.set_of_books_id) = gsob.set_of_books_id and xxen_util.contains(:$flex$.reporting_context,gsob.name) = 'Y' union select haouv.organization_id from hr_all_organization_units_vl haouv where :$flex$.reporting_level = '3000' and xxen_util.contains(:$flex$.reporting_context,haouv.name) = 'Y' ) order by value,description US Batch Source Name 29 140 :p_transaction_type_low LOV custom Y select name id, name value, null description from ra_cust_trx_types_all where nvl(org_id,-99) in (select -99 from dual union select hou.organization_id from hr_operating_units hou, gl_sets_of_books gsob where :$flex$.reporting_level = '1000' and to_number(hou.set_of_books_id) = gsob.set_of_books_id and xxen_util.contains(:$flex$.reporting_context,gsob.name) = 'Y' union select haouv.organization_id from hr_all_organization_units_vl haouv where :$flex$.reporting_level = '3000' and xxen_util.contains(:$flex$.reporting_context,haouv.name) = 'Y' ) order by value, description US Transaction Type Low 30 150 :p_transaction_type_high LOV custom Y select name id, name value, null description from ra_cust_trx_types_all where nvl(org_id,-99) in (select -99 from dual union select hou.organization_id from hr_operating_units hou, gl_sets_of_books gsob where :$flex$.reporting_level = '1000' and to_number(hou.set_of_books_id) = gsob.set_of_books_id and xxen_util.contains(:$flex$.reporting_context,gsob.name) = 'Y' union select haouv.organization_id from hr_all_organization_units_vl haouv where :$flex$.reporting_level = '3000' and xxen_util.contains(:$flex$.reporting_context,haouv.name) = 'Y' ) order by value, description :$flex$.transaction_type_low US Transaction Type High 31 160 :p_transaction_class LOV Oracle AR_INVOICE_CLASS Y select lookup_code id, meaning value, null description from ar_lookups where lookup_code in ('INV','DEP','CM','GUAR','DM','CB') and lookup_type='INV/CM' order by meaning,lookup_code US Transaction Class 32 170 :p_document_sequence_name LOV custom Y select doc_sequence_id id, name value, null description from fnd_document_sequences where doc_sequence_id in (select distinct doc_sequence_id from fnd_doc_sequence_assignments where application_id=222 and set_of_books_id in (select gsob.set_of_books_id from gl_sets_of_books gsob where :$flex$.reporting_level = '1000' and xxen_util.contains(:$flex$.reporting_context,gsob.name) = 'Y' union select aspa.set_of_books_id from hr_all_organization_units_vl haouv, ar_system_parameters_all aspa where :$flex$.reporting_level = '3000' and aspa.org_id = haouv.organization_id and xxen_util.contains(:$flex$.reporting_context,haouv.name) = 'Y' ) ) order by value US Document Sequence Name 33 180 :p_document_sequence_num_low LOV custom Y select doc_sequence_value id, doc_sequence_value value, null description from ar_doc_sequence_audit where doc_sequence_id=:$flex$.Document_Sequence_Name and :$flex$.Document_Sequence_Name is not null order by value,description US Document Sequence Number From 34 190 :p_document_sequence_num_high LOV custom Y select doc_sequence_value id, doc_sequence_value value, null description from ar_doc_sequence_audit where doc_sequence_id=:$flex$.Document_Sequence_Name and :$flex$.Document_Sequence_Name is not null order by value,description :$flex$.document_sequence_number_from US Document Sequence Number To E64C100B42B0CC94144AB109ECC6BB1D Default Y SYSADMIN 33 BATCH_NAME 32 BATCH_SOURCE 53 CESS Amount 54 CESS Rate 47 CGST Amount 49 CGST Non-Recoverable 48 CGST Recoverable 7 CLASS 34 CONSOLIDATED_BILL_NUMBER 6 CURRENCY 11 CUSTOMER_NAME 12 CUSTOMER_NUMBER 13 CUSTOMER_SITE 4 Company 5 Company Desc 55 Custom Amount 9 DOCUMENT_NUMBER 35 DOCUMENT_SEQUENCE_NAME 16 ENTERED_AMOUNT 27 EXCHANGE_RATE 26 EXCHANGE_RATE_DATE 25 EXCHANGE_RATE_TYPE 17 FUNCTIONAL_AMOUNT 24 FUNCTIONAL_CURRENCY 15 GL_DATE 40 GST PAN No 39 GST Registration No 61 GST State Tax Mismatch 59 HSN Length Warning 58 HSN SAC Code 44 IGST Amount 46 IGST Non-Recoverable 45 IGST Recoverable 14 INVOICE_DATE 29 INVOICE_DUE_DATE 8 INVOICE_NUMBER 1 LEDGER 2 OPERATING_UNIT 30 PAYMENT_METHOD 28 PAYMENT_TERMS 3 POSTABLE 42 Place of Supply 18 RECEIVABLES_ACCOUNT 20 RECEIVABLES_ACCOUNT_DESC 22 RECEIVABLES_ACCOUNT_FULL 23 RECEIVABLES_ACCOUNT_FULL_DESC 41 Reverse Charge Flag 50 SGST Amount 52 SGST Non-Recoverable 51 SGST Recoverable 36 SHIP_TO_CUSTOMER_NAME 37 SHIP_TO_CUSTOMER_NUMBER 38 SHIP_TO_CUSTOMER_SITE 43 Ship From State 31 TAX_CALCULATION_LEVEL 19 TOTAL_LINE_AMOUNT 21 TOTAL_TAX_AMOUNT 57 Taxable Value 10 Type 56 Unclassified Tax Amount 60 Unclassified Tax Rate Codes AR Transaction Register - Default Template.xlsx US UEsDBBQAAAAIABgzOF2Q7xzWmgEAAG0HAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbM2V30/CMBDH3038H5a+mq2AiTGGwQPqoxLFP6CsB2vY2qZXEP57bx34g0yQgNGXtVt79/20d7vr9pdlES3AoTI6Ze2kxSLQmZFKT1P2MrqPr1mEXmgpCqMhZStA1u+dn3VHKwsYkbXGlOXe2xvOMcuhFJgYC5pWJsaVwtOrm3IrspmYAu+0Wlc8M9qD9rGvfLBe9xYmYl746G5Jn2sSBwWyaFBvrLRSJqwtVCY8rfOFllsq8VohIcuwB3Nl8YIwGG9UqFa+F1jbPdLVOCUhGgrnH0RJGHxZ8FfjZmNjZsluJw2UZjJRGUiTzUs6WILWgZCYA/iySMKYlELpDfcO/bAZeRjaJwapzhccH8jR+Sccl3/EYdXC+IGg34B/TCm7lVZVSp46TE0aeyLWSPgEmXESfw9vLbCHzVP1AB6ex6MEN3sE0a8KwBPnSu10n3IuHMhn76jOnhzgs++fpMNIjIm4ztgwP/72v9a1D8+7cKgoDp2xSO3BweFB2dT/yjq25AicV7sD8a5IreVwwa1SDlXzkiAbtHlolr03UEsDBBQAAAAIABgzOF21VTAj7gAAAEwCAAALAAAAX3JlbHMvLnJlbHONks9OwzAMxu9IvEPk++puSAihpbtMSLshVB7AJO4ftY2jJED39oQDgkpj29H2588/W97u5mlUHxxiL07DuihBsTNie9dqeK2fVg+gYiJnaRTHGo4cYVfd3mxfeKSUm2LX+6iyi4saupT8I2I0HU8UC/HscqWRMFHKYWjRkxmoZdyU5T2Gvx5QLTzVwWoIB3sHqj76PPmytzRNb3gv5n1il06MQJ4TO8t25UNmC6nP26iaQstJgxXznNMRyfsiYwOeJtpcT/T/tjhxIkuJ0Ejg8zzfinNA6+uBLp9oqfi9zjzip4ThTWT4YcHFD1RfUEsDBBQAAAAIABgzOF2tp6Z7oAEAAG4DAAAQAAAAZG9jUHJvcHMvYXBwLnhtbJ2TTW/bMAyG7wP2HwzdG7vNUAyBrKJoO/SwYUHjdmdWpmOhsmSIjJHs10+2Ecdpe9qNH69fPxQlebNvbNJhIONdLi4XmUjQaV8at83Fc/Hj4rtIiMGVYL3DXByQxI36+kWug28xsEFKooWjXNTM7SpNSdfYAC1i28VO5UMDHNOwTX1VGY33Xu8adJxeZdl1intGV2J50U6GYnRcdfy/pqXXPR+9FIc2AitZeAZbmAZVJtNTIm/b1hoNHKdXv4wOnnzFycNeo5XpvCkj9Qb1Lhg+9B7zVG40WLyLP1QVWEKZngryEaE/zDWYQEp2vOpQsw8Jmb/xOK9E8gqEPWYuOggGHEfcXjYmQ2xb4qD++PBGNSKTTKfiEM6189h8U8tBEINz4fDVABIb54iFYYv0u1pD4E+Il3PiAWzkHRlvn5IigCPQ/ZEmT7g1xBjmwJN2LtzsmgbC4VNdBIEGo8vHuY8TvGP+adwbPbeFvwfG407Oi3JTQ8AyrnHa2VSQj3EdwfYmdzW4LZZHzcdGf4NexuejLq8X2TKLl2NWk+npoah/UEsDBBQAAAAIABgzOF0adRtDNwEAAFECAAARAAAAZG9jUHJvcHMvY29yZS54bWyNklFLwzAUhd8F/0PJe5u0m9OFtgOVPTkQnCi+heSuCzZpSKLd/r1pu3Ub7MHHe8+5X869JF/sVB39gnWy0QVKE4Ii0LwRUlcFel8v4wcUOc+0YHWjoUB7cGhR3t7k3FDeWHi1jQHrJbgokLSj3BRo672hGDu+BcVcEhw6iJvGKuZDaStsGP9mFeCMkBlW4JlgnuEOGJuRiA5IwUek+bF1DxAcQw0KtHc4TVJ88nqwyl0d6JUzp5J+b8JOh7jnbMEHcXTvnByNbdsm7aSPEfKn+HP18tavGkvd3YoDKnPBKbfAfGPLPKQ9FeFwNXN+FW68kSAe90G/0hO8jzvMgYhCADrEPSofk6fn9RKVGcmmMZnH6XxN7uj0nqazr+7Ji/ku0NBQh4f/SZxRktHpOfEIGHJffoLyD1BLAwQUAAAACAAYMzhdTUHW0hoBAAB7BAAAGgAAAHhsL19yZWxzL3dvcmtib29rLnhtbC5yZWxzvZTBSsQwEIbvgu8Q5m7TdnUV2XQPLsJedX2A0E7bsG0SMnG1b2+s0FpY6h6Kl8DMJP//Mcxks/1sG3ZCR8poAUkUA0Odm0LpSsDb4fnmARh5qQvZGI0COiTYZtdXmxdspA+PqFaWWFDRJKD23j5yTnmNraTIWNShUhrXSh9CV3Er86OskKdxvObutwZkE022LwS4fbECduhscP5b25SlynFn8vcWtT9jwT+MO1KN6IOodBV6AUOKeF9ZRYEY+HmY+yVhqJYOi1fvQq9pBJqk52DSJWEu6Ew6B5P8M0wyB7NeEoZ814ShHwbmJ56zv1vS3odVwtG9D3l/zrbgdkkGq07GP8mw1TsslVbfez8ijVV+7uKAySdfRvYFUEsDBBQAAAAIABgzOF3iK397uwAAADMBAAAyAAAAeGwvcGl2b3RDYWNoZS9fcmVscy9waXZvdENhY2hlRGVmaW5pdGlvbjEueG1sLnJlbHOFj8FqwzAQRO+F/oPYey07h1CK5RwSArkG5wMWaW2L2FqhVUL899ExoYUeh2HezLS7xzKrOyXxHAw0VQ2KgmXnw2jg0h+/vkFJxuBw5kAGVhLYdZ8f7ZlmzCUkk4+iCiWIgSnn+KO12IkWlIojheIMnBbMRaZRR7RXHElv6nqr0ysDujemOjkD6eQaUP0aS/P/bB4Gb+nA9rZQyH9U6OjvnPdY5p3JcnJS4JhGygZ+WU1VpoPuWv12tXsCUEsDBBQAAAAIABgzOF0wowXuPgQAAKcVAAAnAAAAeGwvcGl2b3RDYWNoZS9waXZvdENhY2hlRGVmaW5pdGlvbjEueG1s3Vhbb+I4FH5faf+DlfdAAoESBIwIlxVSpzMq7Uj76CYGrMY2azssaDX/fY8TkqZLtyGlo9G0QoXYznfun+0z+LRnMdoRqajgQ8ttOBYiPBQR5euhdX83t3sWUhrzCMeCk6F1IMr6NPr9t8GW7oSe4HBDpmRFOdUAgACMq6G10XrbbzYVTDKsGmJLOMyshGRYw6NcN9VWEhypDSGaxc2W43SbDFNuZQh9eQ6GWK1oSKYiTBjhOgORJMZGE7WhW5WjsfAcOIblY7K1Q8G2APFAY6oPKaiFWNhfrLmQ+CEGF+xlDrw/1ZPRUAolVroBQM1MxRNrXQ8U3VHjcwvJPo2GllxELvwmK0nU5gu/FhgGn0ZIFByG1jjRGwHSj8tINMUaFPI6nY7XuOq43aue4/itbhtUpkpBDBeaMHVNGdVDC0Ibgtc1ib7l8YbgFljlQUb5baaKMbmYAVxJQiGjiUg4IIJ+e9lPjP7/TCbOPPD9wJ522zPbmwdXtj8eB3an2+kGQdBtd3ud79ZoEJqUWYpEhgTpwxbU/1vIxzQTYLb4fVzBMYMV2QMYi63maNAsQRzx5pTEkUJhpla7m8tJx1EGck2iNQHn8YTNmV6Azg4sAwsliVI35a+7ZhjthtbNOBVXWpILT3HLso8yvmyJhOTha3QPFfFjZX0VUJcQnTpS/oTqrWnSxNQDP9SR4rhvFIKmRIV1JNWP0CSREgiulj33y2ltg2KsgH/Oz7UF3wmgirpyjq+hm4Q9VCU318CwakkY/Uz3JLqD4gOuNqwgjlNaprRfGspw00rPVy24JlBI6RjwxDccJ1Bd5gHvi4eiTP+vUnLarqH5jeAZ372uchBj/mgUqtTBeOCVGFW+P0mUFoxIdAME8z5Av1oYCxcsqb7IBXkimwiXXel2Tki6Mo9fSpQsc0ppvHxKdsjibBp2e8d2XPjcOU4//aRp/Z/Z1tNsZY78EaOPZtIMCAD2TDRmZrstB8s73VErg1WKQ84wJdJ5Ihi/3Wo7jZY5jRU8U4xVhmGe8NCcC3H8gto/UGu33XWcdqPlF3/PePJ0ttKSWxISujMbv0LjMD3xvL7PXBiBCtqHinlmkXl+iw1VW/+bMOdJHF/Cyy/4GhnMi5UtpeMZB5JK22f7cIP5mqBboDF06bb2HO3DsVfZVz+zcmoemL7ig7nmojsi2Wsny8pkKXbahHy4rSl30mcCF+XonOi+/6ES79EEx2GSNSLQNdmRi0gowDrcoOwKfAmZZTgVR9XilP/ufplAU0bENDL9BxRQINHz7yzvrkxx+1iSvxK4DpKf55cldKrQnUDvdpk4BfzVLhUnFtS8XGQNoqwnNBqQvb5WOv1GiaTQqrpqdcaz1nhm+57v2l7vgdhBK/Bsbxb4V9580nZ63veix+d6J93Ds5p8jt/0s6bmaLB3vf5LDVND1qBX9j/VsvnSstG/UEsDBBQAAAAIABgzOF3HgJcMfQEAAKgDAAAkAAAAeGwvcGl2b3RDYWNoZS9waXZvdENhY2hlUmVjb3JkczEueG1spZNRa8IwEMffB/sOIe82qW4yxSqiDHyYD9v8ADGNGtbkShKLfvtdWmwHsimsJCWXu/v17p90MjuZglTKeQ02o2nCKVFWQq7tPqObz9feCyU+CJuLAqzK6Fl5Ops+PkxKXUFYCHlQ70qCyz1BkvUZPYRQjhnz6DHCJ1Aqi54dOCMCmm7PfOmUyP1BqWAK1ud8yIzQljaEsbuHAbudlmoJ8miUDQ3EqUIE7MMfdOkvNCPvwRnhvo5lT4IpEbHVhQ7nGkqJkePV3oIT2wL7P7kL+HRdp9HSgYddSBDEmhKvuk2fsNBKR8EpkXC0AXWn04mbTk6kyiin7H8rGylppBicPlorWwHWEvdqez2Pyy7wx2Ye/dg57/EUxyfn43rEhL98NWw06A940h929MGQ80HSH7VP58JvtAXNZa2EJ3iZlK6i1q0vltLM7nVX4uZj2cYtwJV4hqHG3uyjVq8RRQWSPt9KaoVeQ5v5JuxRFJdjiBFd1O/yM7wG7Orfmn4DUEsDBBQAAAAIABgzOF0KQQzqvQAAAEcBAAApAAAAeGwvcGl2b3RUYWJsZXMvX3JlbHMvcGl2b3RUYWJsZTEueG1sLnJlbHOFj8EKwjAMhu+C71Byt908iMg6D4rgVfQBQpdtxS0tbRV9e+ttA8FjyJ/vz1ftX+MgnhSidayhlAUIYuMay52G2/W02oKICbnBwTFpeFOEfb1cVBcaMOWj2FsfRaZw1NCn5HdKRdPTiFE6T5w3rQsjpjyGTnk0d+xIrYtio8KUAfWMKc6NhnBuShDXt8/N/9muba2hozOPkTj9qFDePl06YH7vSK1l+xXIfAwdJQ1STgI/s6XMOqDqSs306w9QSwMEFAAAAAgAGDM4XWgu4htXBQAAQi4AAB4AAAB4bC9waXZvdFRhYmxlcy9waXZvdFRhYmxlMS54bWztml9vozgQwN9Puu+AeKcECuSPkqxICNpKvbtq29t7dsAk1oKNjGkTre6739gkBEh6yp20D9vw0BTGZjwejyfO8Jt+2mWp9op5QRid6dbdQNcwjVhM6Gam//kSGiNdKwSiMUoZxTN9jwv90/zXX6Y5eWXiBa1THOCEUCJAgQbKaDHTt0LkE9Msoi3OUHHHckyhJWE8QwJu+cYsco5RXGwxFllq2oOBZ2aIUL3SMMmia5RkiH8rcyNiWY4EWZOUiL3SpWtZNHnYUMalfTN9x4+Kd/xMcUYizgqWiDtQZLIkIRE+s89yTI5fifQSqOKTksQz/bt37w6tsb0wlpa/NBxvMTIW9mhlDN0gcFfDob3w7L91jaIMjHiqHWbpWoTANw+gY+jqGsrzdP97ma0xDysfzXRYByVeMB5fEIeMirO+T0gIzOmZ3E/Jhmb4whN/kVhsP2Oy2Z60gXUxEmiJcrmkM/0rSktYdK3MQYzjr8dYgcDICP2CE46LrfRz3XIPIbNlbwEnaapmUhbYLwWrDBMqtGAUInD2xAkVL0SkGOYs/QJh0RmE0BhMV3rUSket6wBMVW1ZmQqSpzgkOI1DkoInlBvn05RFEB4QnRwnM913J6EFIyWEF+IzBCHmX9ibUqFEUqESHPtIwZLBRBxd4+ztCW3wkpXSIphnxNKGwNLNebUxlBUFNFcdPTDjJNfQjoBt8lM+3J4XK0VK5E4Dg6QX/cqH86l0V63RPgi0nWyEUWWrBkPFOEHgCSky1RPzKd6Jx0Ko/1rJCcStPXa8VTDyDN8auoZzbyNj5C8tw3NWg6XreMEwWEHcVntxZzn/b88Mxua42tXzKSiZNByQQGQE7I0+ojVO1cpLe8HA6lOZa576987rnXf4LrkqW//wyIMEcdWu1QgtMBeLFNFvh6TSb+RDdmxkwavdechuz+VaMIEuJUarmxg/fBa82nl9LF7zpXKtO/t9fNzHzVPZu6eXD3YI6ef8zim1X+ef/oDdx/btxTYtszATsiBhQUHiFrP4bXpAVnpUraKqvjTqKyd/OFCJuJWIeN8ft+KBPvvfXvbvY7tRZ+1PsP0J9icsi/d5u8/b9buiD5zDbvOc3u/ufnffwu7uT6L9SfQjwQp93u7z9ofK2w0qB9Ai4KHapJMDr98TWU+UYNK9pHrqO6d157buPMX/1NqU4ocm7yQBKgIYEXRr/pkgI03sSQO+T7JRslPduJb4BcBbF5qOuNTFJzrCDQcMsqFb2quMnE8BA2v7QWII9cwNW02v7qT6t6ancK7mcPATXKrYaa9HOAqapYbDgDlwYx3GTCJmR6mWyIou1G23BMO0jQpMa7dCvfdfWu12q3kacD6ti6QtHK2WHnhHbUWBwcOx5meSggO8TlWZ4fXCGhWV8Qqhk3dyVsrexuneUyFypjUsaSRpPpR2FAP1+V8Um6dZwFJV2OWR11Orp0RavEvkWxG5QIpH8wFQVHzkHzTdK5ObRxa15E+sUDRshe0BdAheoBFuaa+lAB0qR4BbDrAgqDzDXCo+7qTqCDJIa+C6srW+gIA80bnPYp/iB5qwJoaqhL/hmJTZuMIMAXuoYMiKw5QigB67Iuj1LDjJJa154BOhV1f0iAoB4jKTRLG0/Pzn6NizV6EbWIa79G3Dicb3xmgVOkawCN3lwHXux4EkZ38EgdhlltssIsDMkp9UTtiSGFf06xEIPdgDsdpBnC9iaXgX4SbcXDOOJxJz6Ax9z/Icwxq5vuEMgiWQmL5rhAPLtWzXGgSuc/JDHgPydM3IXbza8qq8fQisFO0hamV+AY0VWtjxCjzwDpDZ6Tj/B1BLAwQUAAAACAAYMzhdnPPzq8UDAABbDAAADQAAAHhsL3N0eWxlcy54bWzlV12P4jYUfa/U/2B5XhvyQcISSlgtMJFW2q6qzlSqVKrKJA5Ya8eRY2ZDq/73XjsBwnwyo+5TXwb72j73XN97bjzT943g6I6qmskywf7Aw4iWmcxZuUnwr7epM8ao1qTMCZclTfCe1vj97PvvprXec3qzpVQjgCjrBG+1riauW2dbKkg9kBUtYaWQShANU7Vx60pRktfmkOBu4HkjVxBW4hZhIrJLQARRX3aVk0lREc3WjDO9t1gYiWzycVNKRdYcqDZ+SDLU+CMVoEYdnFjrAz+CZUrWstADwHVlUbCMPqQbu7FLshMSIL8NyY9cLziLvVFvRApdRe+YSR+eTcudSIWuUSZ3pU5wcDShduVjDjkehRi1WVnIHO4pXzlCiJWz36/QdjsRYlLX2D2AnZ2Mzk9e/XB15Q0870/04++/0PyPlXOwrJBBcDs+s2khyz4tyApkYfKllF/L1CwBLeBqds2m9V/ojnCweAYjk1wqpKGmgKpveRFB2x0LwtlaMWMsiGB835oDY7Bl2O0TDIrCEmo9tH/XZtc392Vd1uCTcX5MTGiCBcNsCjWsqSpTmKBufLuvINQS5NZStvte2L1RZO8H0eUHaslZblhsFvaC1Wad4DS9/nCdphZm3S2wMqcNhbqBsjF0eoQvJXffV5dMKEPNTJl6g3dxHI/90Xg8jsOhH4Y2g69hYG8JbnktVQ7N7CAAU1StaTbltNCAqthma361rIwPqTUIfjbNGdnIknAT4uFENwDYjHJ+Yxreb8UZdlP05AGt0+TaaMwMgVA3bPHaicHvo7XYPdgYKL8eFjXFEf+p0/6JVIBRn9TxNCJVxfdGkUZr3QwC6ZR3huzbZvBSvPegP+/EmqrUdp9HQdvm9B+jhhel5pVUX4lZsTup5zsoN/OdNXVwfpujb3Gdj3McPp/9p/L9BMPn0e4n/EFNWTVA/fdEdiaxo1iQ6fsJ/mxqh8M3uCt4tN4xDn3kEXkBZt6cBDsEZcH8xV56aFeH/nNhu3q0M7rW4f/Jq4kYLl6bN5htmcdsQjHmtCA7rm+Piwk+jX+iOdsJaE3drp+NYixEgk/jdldsBEQb/amGDzn8op1iCf77ev4uXl6ngTP25mMnHNLIiaP50onCxXy5TGMv8Bb/9F6Cb3tzeeYdaB+uIGI/nNQcXouqC7Yjf3OyJbg3+WQ+P1b+LtDuc4+Dkfch8j0nHXq+E47I2BmPhpGTRn6wHIXz6yiNetyjt3H3Pdf3T+SjiWaCclYecnXIUN8KSYLpM0GYUGwm3NN/BbN/AVBLAwQUAAAACAAYMzhdwofb8lEGAADXGwAAEwAAAHhsL3RoZW1lL3RoZW1lMS54bWztWU9v2zYUvw/YdyB0b2MnthMHdYrYsZutTRskboceaZmW2FCiQNJJfRva44ABw7phlwG77TBsK9ACu3SfJluHrQP6FfZISrYYM43Tpti/5hCL1I/v/3t8pK5cvZ8wdEiEpDxtBdXLlQCRNORDmkat4Ha/d2ktQFLhdIgZT0krmBAZXN14/70reF3FJCEI1qdyHbeCWKlsfWlJhjCN5WWekRTejbhIsIKhiJaGAh8B3YQtLVcqjaUE0zRAKU6A7K3RiIYE9Q1JeLuKLsFPtRJsFIy6DF6lSuqJkIl9zYa4q0+uGx5UNVpOZIcJdIhZKwD+Q37UJ/dVgBiWCl60gor5C5Y2rizh9XwRU6esLa3rmb98Xb5geLBseIpoMGVa7dWaq1tT+gbA1Dyu2+12utUpPQPAYQhaW1nKNGu9tWq7oFkC2cd52p1KvVJz8SX6K3P0m+12u97MZbFEDcg+1ubwa5VGbXPZwRuQxdfn5W9vdjoNB29AFt+Yw/dWm42aizegmNH0YA6t/Tn1zBQy4mzbC18D+FoRADMURMM00jSLEU/VInGX4Htc9ABsHI0VTZGaZGSEQ4j0Dk4GgmKtOV4nuPTGToVybkrzRTIUNFOt4MMMQ9bM6L189v3LZ0/Qy2ePjx88PX7w0/HDh8cPfrS0nIXbOI3KC198+9mfX3+M/njyzYtHX/jxsoz/9YdPfvn5cz8Qsmkm0fMvH//29PHzrz79/btHHvimwIMyvE8TItFNcoT2eAK6eSQnA3G+Ff0YU2cFjoG2h3RXxQ7w5gQzH65NXOPdEVBIfMBr43uOrPuxGCvq4Xw9ThzgDueszYXXANc1r5KF++M08jMX4zJuD+NDH+8OTh3XdscZVNMiKJ2o6cTEEXOX4VThiKREIf2OHxDi0e4upY5dd2gouOQjhe5S1MbUa5I+HTiBNFu0TRPwy8SnM7jasc3OHdTmzKf1Fjl0kZAQmHmE7xPmmPEaHiuc+Ej2ccLKBr+BVewTcn8iwjKuKxV4OiKMo+6QSOlbc0uAviWnX8dQu7xu32GTxEUKRQ98NG9gzsvILX7QiXGSeWWmaVzGfiAPIEQx2uXKB9/hboboMfgBp6e6+w4ljrvPLgS3aeSINAsQ/WYsPL68RribjxM2wsRUGSjvTqVOaPqqss0o1O13ZbvYxzZhE/Mlz/aJYn0a7l9YorfwON0lkBXzW9S7Cv2uQgf/+Qp9Wi5ffF2elWKo0rO+2zS1yUJN+Igytq8mjNyQpg+XsBkNezBpBub0OD2gZTE85luCg4sENmuQ4OojquL9GGfQw1fNsTSSOelIooxLOEeaaS9tc4yl0MabU2i9OG8CGqsdPrTTK+Vz6JSM2agic+4tGK1oAosyW1nND7evyaxqpVpQtaoRzRRIR7WpyqDMvGpGw9ya0OUg6I3Ayg040GtqcPbBjAy13e22XbjF2OQiXSRjPCS5j7Te84pUjZOKWCnCyOMjfaY8w2olbk1N9g24LeKkMrvaKewK772JlwrrzLykc/hEOrK0nJwsRUetoFlfrgcoxFkrGMGxGR6TDLwudWOJWQT3U6ESNhDPTGaDmnmz6Q/LKtyKnOJNh0UmpNrCMrahYV4V1zSpOeQb+ZfrYNaLUsBG+mtIsbIGwfC3SQEyu64loxEJVdnZpRlzB2IAefLzsSJiPx4eoQEbiz0M7tehCvoMqYTbD1MR9ACu7bS1zcgtznnSlS/LDM7OY5bFOC+3OkWLTLZwY/OpDGZUEm86MtrMZD8xXFQVk/IXpEo5jP9nquj9BK4jVobm9gxukwVGOl9bARcq5lCFspiGPQGXaCYCIFrg6hdeg/HhTtv8CnKof23OWRomreFUqfZohASF/UjFgpBdKEsm+s4gVs33LkuyIGRzeiauzKzYA3JIWF/XkIbe2wMUF9UkLwMGdzL+3HEedoNINyz/1M7HJvN524NZ52PXL9iL1EpFv7QVNN9MhHNutbZizWm8XF94q83gUgnpf7D/UREyYvTXG2qf70HpRNOOEkFUX7KNB9IF0j4NoHGykzaYNKm320bNOt0p37fYfJa2+Wlz5rJzcvHV3ef5jJ1b2LF1udP1mBoccDJFdXtUHGqMY8yXtfIHLz64B47egk8IY6ak/XRwH64QYcuyHyQg+a1zzdKNvwBQSwMEFAAAAAgAGDM4Xaftr3MaAwAANQcAAA8AAAB4bC93b3JrYm9vay54bWylVW1v2jAQ/j5p/yGzkLpKg8TmtRFQ0UI0pq5FhbYfkUkMWE3iyHEgqOp/3zkQCO1WoS5Agl/uueeeO1/al2ngGysmYy7CDsIVCxksdIXHw0UHPUyccgsZsaKhR30Rsg7asBhddr9+aa+FfJ4J8WwAQBh30FKpyDbN2F2ygMYVEbEQVuZCBlTBUC7MOJKMevGSMRX4JrGshhlQHqItgi1PwRDzOXdZX7hJwEK1BZHMpwrox0sexTla4J4CF1D5nERlVwQRQMy4z9UmA0VG4NrDRSgknfkQdorrRirh24AftuBGck+w9M5VwF0pYjFXFYA2t6TfxY8tE+MjCdL3GpyGVAMRVlzncM9KNj7JSgu6xQIVtqnRIf83GobSyuHIJ9Hqe24Eddtz7rPHbekaNIpuaaAz5SPDp7EaeFwxr4OaMBRrdpioIUMm0VXCfVglzQvSQmZ3X84jaQCsYnIk+Yq6GzgTyFhyj434SiiHM9+74bHKpj02p4mvJlDxOQ+YJzVCGhoylXau5EhJA/4P+zfAbExXwBPU8HZlPAQiuDoNXWnj6YtVv2o4TVIvN/HAKtcGfafc69Xr5cFFtWlVG9Ve3bl+BSllw3YFTdRyJ4GG7qAaxPtu6TdN8xVs2Qn3DjRerN1V1s83t3ztVYejD/sjZ+v4IJYeGukTDz2x7qBqi7Qgqk0+LmMCw3W2+sQ9tdRbGrX93E/GF0ugTEAymKSu4is2obNMWzhgmmgHHRHsbwk6cGW3I4JmgWHWZYBp9jTCrDJ698ZE0jDWjqBi7tkCEskk9De9KUsClIatncqhh3XMRfOi7TgJoHVsCqbVgil5azqiEhiAL2hPe2fQQPbOqtrCzElDXfGQebqeIYTCaBfINPXDoDJ1sjrtU0VnNGa6zF3qj/NYQFEoW4/pro66Z/8I/uxbqVfCdqn3q4TbZsHV3/yORSKh+YJD1L1znPFg8v1j3B8WfK7vHm4nvQ93gv/zE/YBT3x+/oZmkTSoBRK4cIb1I8soIQRnqYz0+b2m8HqCXYcB7IQpvbVZLySkliXkyMbM33jdP1BLAwQUAAAACAAYMzhdyKG4+rgAAAA0AQAAIwAAAHhsL3dvcmtzaGVldHMvX3JlbHMvc2hlZXQyLnhtbC5yZWxzhY/BCsIwEETvgv8Q9m7SehCRpr2I4FXqB6zptg22SchG0b83xwqCt9kd9s1O1bzmSTwpsvVOQykLEOSM76wbNFzb02YPghO6DifvSMObGJp6vaouNGHKRzzawCJTHGsYUwoHpdiMNCNLH8hlp/dxxpTHOKiA5o4DqW1R7FRcMqD+YopzpyGeuxJE+w45+T/b9701dPTmMZNLPyJUsE+fWrxNlKkYB0oapFyseaFLmX8HVVfqq2v9AVBLAwQUAAAACAAYMzhd0MA4SPkDAADUDgAAGAAAAHhsL3dvcmtzaGVldHMvc2hlZXQxLnhtbJ1XXW+jOBR9X2n+A+Jh3wrYhHxtklHVKppZ7Uijdnb22QGTWAXM2E6/VvPf99pwgaqzEqRK8QXj4+N7j68vm4/PZeE9cqWFrLY+CSLf41UqM1Edt/7f3/ZXS9/ThlUZK2TFt/4L1/7H3YffNk9SPegT58YDhEpv/ZMx9ToMdXriJdOBrHkFPblUJTNwq46hrhVnmRtUFiGNonlYMlH5DcJajcGQeS5SfivTc8kr04AoXjAD/PVJ1BrRynQMXMnUw7m+SmVZA8RBFMK8OFDfK9P152MlFTsUsO5nMmOp96zgR+E/xmnc83czlSJVUsvcBIAcNpzfL38VrkKWdkjv1z8KhszAAY/CBrCHopdRIkmHRXuw+EIwG5mGmHWXWp9FtvX/jdq/K2iJvUT9Bft++rtNJiDCdrCneL71r8n6+k/qh7uNE9B3wZ/0wPasHg9SPtiOzzBPBBA1q7j3cl9DVEHbvmdk/RfPzQ0vCgCEFbLUiEf+FV7b+gdpjCxtv1O8gUe5kq+8cnPygsO7QMZivn25AelB9Y+GsCMbdmyHNjLfu93xVXkZz9m5MDey+Edk5gRsSTCjyWJJaOJj7518+sTF8WQXQ4MFdDj1rbOXW65T2A6w6sDNmsoCpoCrVwq7rUHN7Nm1Ty38KlgmyWy+tCgHrs2+dVF61uAFJNFiNSjgL4cCLaKMHwwKcIOhbQdfwGDWgkCLDKKBm0auA0g7KtAiymy6N2yGsCjQ9lzILJrbgI1ksmgxoEUMEtBlQpIpKJChHRNou7hMX8+qRYEWUZbTfUvg/GikBgbiLIJkEcVOySMdQzrF9pKl4KWxw1GqZKDVxXSfEFStNfqdMzHKBGVrDUSJg6koKFvS63Y13bEoWzLQ7Xy65ghK1xq9XiZrl6B4rdF7uE99YyOO8iW9fmk8PeIU9WuNlg+lF+CggGkv4HkULEi0iqek3C7nDoS8vIAOCpkOJAieGuldu3Ob1P8mZ05eDYqPDsSXTNawTQQNm4H25hc4BbVHe+3ZsI91CkqODlLm9B0Zo+KsgYobHv4j6cSoOGv0OJN3ZIySswbixJODFHcHfp866QXHbIzJ0xpIZ/xJEKNyrYHDZ1Nzb4zCtQaijN7NYVONuULwlhmGhWBjs7ORe1EYrgZ1LoTwl/Xy6n/rZSj6anbkX5g6ikp7BZSxthoET6mmYnQ2FMDOsiexK3fx7gQfZhw+QKIAwpVLCXSamxb3nptzDbVvzdW9eIUCGDQvlYCa0315bf0CPhF1Cv2+d4KOVwk9xW0tbCFuvy+NSLt7wGzm27uJdhuZZZ/cg93vrKz/uLm+874pVmlbWUPJfcePQsOLm7B/cRO+hQi779Hdf1BLAwQUAAAACAAYMzhdy+zihnIDAACyCwAAGAAAAHhsL3dvcmtzaGVldHMvc2hlZXQyLnhtbJ1W227jNhB9L9B/EPhuSZQl+QLbC8e20H0oUPT6TMu0TUQSVZJ2EhT7752hYt2c1soGSSiRR+dwZg4viy+veeZcudJCFktCXZ84vEjlQRSnJfnj92Q0JY42rDiwTBZ8Sd64Jl9WP/6weJHqWZ85Nw4wFHpJzsaUc8/T6ZnnTLuy5AWMHKXKmYFXdfJ0qTg72I/yzAt8P/ZyJgpSMczVEA55PIqUb2V6yXlhKhLFM2Zg/vosSn1jy9MhdDlTz5dylMq8BIq9yIR5s6TEydP511MhFdtnEPcrDVnqvCr4DeBvfJOx/XdKuUiV1PJoXGD2qjnfhz/zZh5La6b7+AfR0BAScBVYwIYq+L4p0ajmChqy8XeSYWWqiWG61PwiDkvyTxLEk2ibbEabONqMwmANHnva+aNotok3IX2Kn6a7b2S1OAioMH7sKH5ckjWdJ5QSb7WwBvpT8BfdenYM2//GM54aDiKUOOjPvZTPCPwKXT5QagtASgbNlW94lgEzFFv/XYnEKODVCu3nm1piHf2Lcg78yC6Z+VW+/MTF6WxANnAnEYSKnpgf3rZcp2BS0HYD5E1lBiTw38kFLjbwGHutJisO5rwkge+GQTSZ0gBY9lybRCArcdKLNjL/q0LZJNQsUCfLAm3DEkwjGsWfYIECWRZobyyBS0P/MxzhOwe07xyxO6H+bIw5GRgNIO08oH3noOGnSXDxIsmkIYkHJ9arqmQtsGWGrRZKvjiwNqEMumS409E5KHxYZKgLQteItUFA+TQY77ryF94V3JS+I54AUY/ReswDrVoQKjpYELFdwaAnCIhHglD8wYKI7QqOe4KAeCQICRosiNiuYNgTvEdEXcTmHhF3Edt7xKSL2LWLOu2OJe2x2cdFxb1mqIsA22Swb6DOYOMg679NZ7DnhG1nsFe1Hc5vSWLr2dk4GMPW1ctR0obQcez7YzeY1T8fhw1LcXDYgP3vsDuD/bBRxS775vueSbY3CG6hmKpd1TH9v4DbkKEB47VpYJ13iMWc3+aUtDo6O8JsOOkasE0Wegthh0QPqtyGDA2awu1xcNQW3Am73dOJG879wbxrBDeR98y7s1QPQu9gHsZe3Raqo6JkJ/4zUydRaCfjR3v0g3tUdT2wz0aW9gnPRGngVL+9neFuzMGRvgs751FKc3vBG0l92179C1BLAQIUABQAAAAIABgzOF2Q7xzWmgEAAG0HAAATAAAAAAAAAAAAIAC2gQAAAABbQ29udGVudF9UeXBlc10ueG1sUEsBAhQAFAAAAAgAGDM4XbVVMCPuAAAATAIAAAsAAAAAAAAAAAAgALaBywEAAF9yZWxzLy5yZWxzUEsBAhQAFAAAAAgAGDM4Xa2npnugAQAAbgMAABAAAAAAAAAAAAAgALaB4gIAAGRvY1Byb3BzL2FwcC54bWxQSwECFAAUAAAACAAYMzhdGnUbQzcBAABRAgAAEQAAAAAAAAAAACAAtoGwBAAAZG9jUHJvcHMvY29yZS54bWxQSwECFAAUAAAACAAYMzhdTUHW0hoBAAB7BAAAGgAAAAAAAAAAACAAtoEWBgAAeGwvX3JlbHMvd29ya2Jvb2sueG1sLnJlbHNQSwECFAAUAAAACAAYMzhd4it/e7sAAAAzAQAAMgAAAAAAAAAAACAAtoFoBwAAeGwvcGl2b3RDYWNoZS9fcmVscy9waXZvdENhY2hlRGVmaW5pdGlvbjEueG1sLnJlbHNQSwECFAAUAAAACAAYMzhdMKMF7j4EAACnFQAAJwAAAAAAAAAAACAAtoFzCAAAeGwvcGl2b3RDYWNoZS9waXZvdENhY2hlRGVmaW5pdGlvbjEueG1sUEsBAhQAFAAAAAgAGDM4XceAlwx9AQAAqAMAACQAAAAAAAAAAAAgALaB9gwAAHhsL3Bpdm90Q2FjaGUvcGl2b3RDYWNoZVJlY29yZHMxLnhtbFBLAQIUABQAAAAIABgzOF0KQQzqvQAAAEcBAAApAAAAAAAAAAAAIAC2gbUOAAB4bC9waXZvdFRhYmxlcy9fcmVscy9waXZvdFRhYmxlMS54bWwucmVsc1BLAQIUABQAAAAIABgzOF1oLuIbVwUAAEIuAAAeAAAAAAAAAAAAIAC2gbkPAAB4bC9waXZvdFRhYmxlcy9waXZvdFRhYmxlMS54bWxQSwECFAAUAAAACAAYMzhdnPPzq8UDAABbDAAADQAAAAAAAAAAACAAtoFMFQAAeGwvc3R5bGVzLnhtbFBLAQIUABQAAAAIABgzOF3Ch9vyUQYAANcbAAATAAAAAAAAAAAAIAC2gTwZAAB4bC90aGVtZS90aGVtZTEueG1sUEsBAhQAFAAAAAgAGDM4Xaftr3MaAwAANQcAAA8AAAAAAAAAAAAgALaBvh8AAHhsL3dvcmtib29rLnhtbFBLAQIUABQAAAAIABgzOF3Iobj6uAAAADQBAAAjAAAAAAAAAAAAIAC2gQUjAAB4bC93b3Jrc2hlZXRzL19yZWxzL3NoZWV0Mi54bWwucmVsc1BLAQIUABQAAAAIABgzOF3QwDhI+QMAANQOAAAYAAAAAAAAAAAAIAC2gf4jAAB4bC93b3Jrc2hlZXRzL3NoZWV0MS54bWxQSwECFAAUAAAACAAYMzhdy+zihnIDAACyCwAAGAAAAAAAAAAAACAAtoEtKAAAeGwvd29ya3NoZWV0cy9zaGVldDIueG1sUEsFBgAAAAAQABAAfwQAANUrAAAAAA== xl/worksheets/sheet1.xml xl/worksheets/sheet3.xml 1 0 Ledger 1 (All) 2 Operating Unit 3 Postable 4 Company 5 Company Desc 6 Currency 7 Class 8 Entered Amount 9 Functional Amount 10 01 11 NA 12 USD 13 Invoice 14 USD Total 15 01 Total 16 Grand Total data A1 1 data AA 2 data AA1 1 data AB1 1 data AC1 1 data AD1 1 data AE1 1 data AF1 1 data AG1 1 data AH1 1 data AI1 1 data AJ1 1 data B1 1 data C1 1 data D1 1 data E1 1 data F1 1 data G1 1 data H1 1 data I1 1 data J1 1 data K1 1 data L1 1 data M1 1 data N 2 data N1 1 data O 2 data O1 1 data P 4 data P1 1 data Q1 1 data R1 1 data S1 1 data T1 1 data U1 1 data V1 1 data W1 1 data X 2 data X1 1 data Y1 1 data Z1 1 parameter A1 1 parameter A10 1 parameter A11 1 parameter A12 1 parameter A2 1 parameter A3 1 parameter A4 1 parameter A5 1 parameter A6 1 parameter A7 1 parameter A9 1 parameter B3 3 S Site E64C100B42B0CC94144AB109ECC6BB1D