ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE9079D2E0530100007F1FF2 FND Currency Y select fcv.currency_code value, fcv.description from fnd_currencies_vl fcv where fcv.enabled_flag='Y' order by fcv.currency_code US B581C79E6D7AE63DE0530100007FE14A GL Ledger (restricted by AR System Parameters) Y select gl.name value, fifsv.id_flex_structure_name||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where gl.ledger_id in (select asp.set_of_books_id from ar_system_parameters asp) and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, gl.name AR دفاتر الأستاذ مقيدة بمعلمات النظام ar D Ledger eingeschränkt durch ar-Systemparameter E Libros mayores restringidos por los parámetros del sistema ar F Les grands livres sont limités par les paramètres du système ar I Libri mastri limitati da parametri di sistema JA ARシステムパラメータで制限された帳票 KO AR 시스템 매개 변수에 의해 제한되는 원장 PTB Ledgers restringidos por parâmetros do sistema ar RU Леджеры ограничены параметрами системы ar S Ledgers begränsade av ar-systemparametrar TR Ar sistem parametreleri ile kısıtlanmış defterler US Ledgers restricted by ar system parameters ZHS 受人工智能系统参数限制的分类账 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 B290EE2D95595523E0530100007FD7DBY select trx.ledger "Ledger" , trx.ou_name "Operating Unit" , trx.c_balancing "Balancing Segment" , trx.c_account "Account Segment" , trx.c_flexdata "Accounting Flexfield" , trx.c_flexdata_desc "Accounting Flexfield Desc." , trx.currency_code "Currency" , trx.customer_name "Trading Partner" , trx.account_number "Customer Number" , trx.invoice_number "Invoice/Receipt Number" , trx.transaction_type "Transaction Type" , trx.internal_invoice_no "Internal Invoice Number" , trx.invoice_date "Invoice/Receipt Date" , trx.invoice_amt_entered "Invoice/Receipt Amount" , trx.inv_amt_due "Amount Due" , trx.orig_invoice_rate "Exchange Rate" , trx.inv_amt_due_er "Open Functional Amount" , :p_user_exchange_rate_type "Revaluation Rate Type" , to_number(trx.exchange_rate) "Revaluation Rate" , trx.inv_amt_due_reval "Open Revalued Amount" , nvl(trx.inv_amt_due_reval,0) - nvl(trx.inv_amt_due_er,0) "Profit/Loss" , nvl2(trx.exchange_rate,null,'Yes') "Missing Revaluation Rates" from ( select gl.name ledger , hou.name ou_name , fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_select_all', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE') c_balancing , fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_select_all', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'GL_ACCOUNT', 'Y', 'VALUE') c_account , fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_select_all', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'ALL', 'Y', 'VALUE') c_flexdata , fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_select_all', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'ALL', 'Y', 'DESCRIPTION') c_flexdata_desc , rcta.invoice_currency_code currency_code , nvl(rcta.exchange_rate,1) orig_invoice_rate , hp.party_name customer_name , hca.account_number account_number , rcta.trx_number invoice_number , '' lookup_code , rcta.trx_date invoice_date , rcta.doc_sequence_value internal_invoice_no , rctt.type transaction_type , rcta.customer_trx_id cust_trx_id , case '&lp_exchange_rate_type' when 'User' then :p_exchange_rate else case when gl_currency_api.get_rate_sql(rcta.invoice_currency_code,gl.currency_code,:p_as_of_date,'&lp_exchange_rate_type') in (-1,-2) then to_number(null) else gl_currency_api.get_rate_sql(rcta.invoice_currency_code,gl.currency_code,:p_as_of_date,'&lp_exchange_rate_type') end end exchange_rate , sum(aps.amount_due_original) invoice_amt_entered , 0 invoice_amt_accounted , sum(aps.amount_due_original) - nvl( ( select sum(ara.amount_applied) from ar_receivable_applications ara where ara.status = 'APP' and ara.applied_customer_trx_id = rcta.customer_trx_id and ara.gl_date <= :p_as_of_date ) , 0) - nvl( ( select sum(nvl( earned_discount_taken,0)+nvl( unearned_discount_taken, 0 )) from ar_receivable_applications ara where ara.status = 'APP' and ara.application_type= 'CASH' and nvl( ara.confirmed_flag, 'Y' ) = 'Y' and ara.applied_customer_trx_id = rcta.customer_trx_id and ara.gl_date <= :p_as_of_date ) , 0) + nvl( ( select sum(ara.amount_applied) from ar_receivable_applications ara where ara.status = 'APP' and ara.application_type != 'CASH' and rctt.type = 'CM' and ara.customer_trx_id = rcta.customer_trx_id and ara.gl_date <= :p_as_of_date ) , 0) + nvl( ( select sum(ara.amount) from ar_adjustments ara where ara.customer_trx_id = rcta.customer_trx_id and ara.gl_date <= :p_as_of_date ) , 0) inv_amt_due , nvl(aps.exchange_rate,1) * ( sum(aps.amount_due_original) - nvl( ( select sum(ara.amount_applied) from ar_receivable_applications ara where ara.status = 'APP' and ara.applied_customer_trx_id = rcta.customer_trx_id and ara.gl_date <= :p_as_of_date ) , 0) - nvl( ( select sum(nvl( earned_discount_taken,0)+nvl( unearned_discount_taken, 0 )) from ar_receivable_applications ara where ara.status = 'APP' and ara.application_type= 'CASH' and nvl( ara.confirmed_flag, 'Y' ) = 'Y' and ara.applied_customer_trx_id = rcta.customer_trx_id and ara.gl_date <= :p_as_of_date ) , 0) + nvl( ( select sum(ara.amount_applied) from ar_receivable_applications ara where ara.status = 'APP' and ara.application_type != 'CASH' and rctt.type = 'CM' and ara.customer_trx_id = rcta.customer_trx_id and ara.gl_date <= :p_as_of_date ) , 0) + nvl( ( select sum(ara.amount) from ar_adjustments ara where ara.customer_trx_id = rcta.customer_trx_id and ara.gl_date <= :p_as_of_date ) , 0) ) inv_amt_due_er , ( sum(aps.amount_due_original) - nvl( ( select sum(ara.amount_applied) from ar_receivable_applications ara where ara.status = 'APP' and ara.applied_customer_trx_id = rcta.customer_trx_id and ara.gl_date <= :p_as_of_date ) , 0) - nvl( ( select sum(nvl( earned_discount_taken,0)+nvl( unearned_discount_taken, 0 )) from ar_receivable_applications ara where ara.status = 'APP' and ara.application_type= 'CASH' and nvl( ara.confirmed_flag, 'Y' ) = 'Y' and ara.applied_customer_trx_id = rcta.customer_trx_id and ara.gl_date <= :p_as_of_date ) , 0) + nvl( ( select sum(ara.amount_applied) from ar_receivable_applications ara where ara.status = 'APP' and ara.application_type != 'CASH' and rctt.type = 'CM' and ara.customer_trx_id = rcta.customer_trx_id and ara.gl_date <= :p_as_of_date ) , 0) + nvl( ( select sum(ara.amount) from ar_adjustments ara where ara.customer_trx_id = rcta.customer_trx_id and ara.gl_date <= :p_as_of_date) , 0) ) * case '&lp_exchange_rate_type' when 'User' then :p_exchange_rate else case when gl_currency_api.get_rate_sql(rcta.invoice_currency_code,gl.currency_code,:p_as_of_date,'&lp_exchange_rate_type') in (-1,-2) then to_number(null) else gl_currency_api.get_rate_sql(rcta.invoice_currency_code,gl.currency_code,:p_as_of_date,'&lp_exchange_rate_type') end end inv_amt_due_reval from hr_operating_units hou , gl_ledgers gl , ra_customer_trx rcta , ar_payment_schedules aps , ra_cust_trx_types rctt , ra_cust_trx_line_gl_dist rctlgd , gl_code_combinations gcc , xla_distribution_links xdl , xla_ae_lines xal , hz_cust_accounts hca , hz_parties hp , ar_system_parameters sp where hou.organization_id = sp.org_id and hou.set_of_books_id = sp.set_of_books_id and gl.ledger_id = sp.set_of_books_id and rcta.customer_trx_id = aps.customer_trx_id and rcta.org_id = hou.organization_id and aps.org_id = rcta.org_id and rcta.cust_trx_type_id = rctt.cust_trx_type_id and rcta.org_id = rctt.org_id and rctlgd.org_id = rctt.org_id and aps.customer_trx_id = rctlgd.customer_trx_id and aps.gl_date <= :p_as_of_date and rctlgd.account_class = 'REC' and rctlgd.latest_rec_flag = 'Y' and xdl.source_distribution_id_num_1 = rctlgd.cust_trx_line_gl_dist_id and xdl.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL' and xdl.application_id = 222 and xal.ae_header_id = xdl.ae_header_id and xal.ae_line_num = xdl.ae_line_num and xal.application_id = 222 and xal.accounting_class_code = 'RECEIVABLE' and gcc.code_combination_id = xal.code_combination_id and exists( select null from gl_import_references gir, gl_je_headers gjh where gir.gl_sl_link_id=xal.gl_sl_link_id and gir.gl_sl_link_table=xal.gl_sl_link_table and gjh.je_header_id=gir.je_header_id and gjh.status='P' and gjh.ledger_id=sp.set_of_books_id ) and rcta.bill_to_customer_id = hca.cust_account_id and hp.party_id = hca.party_id and rcta.trx_date <= :p_as_of_date and 1=1 group by gl.name , gl.currency_code , hou.name , gcc.chart_of_accounts_id , gcc.code_combination_id , rcta.invoice_currency_code , nvl(rcta.exchange_rate,1) , hp.party_name , hca.account_number , rcta.trx_number , rcta.trx_date , rcta.doc_sequence_value , rcta.invoice_currency_code , rctt.type , hca.cust_account_id , rcta.customer_trx_id , nvl(APS.exchange_rate,1) having ( sum(aps.amount_due_original) - nvl( ( select sum(ara.amount_applied) from ar_receivable_applications ara where ara.status = 'APP' and ara.applied_customer_trx_id = rcta.customer_trx_id and ara.gl_date <= :p_as_of_date ) , 0) - nvl( ( select sum(nvl( earned_discount_taken,0)+nvl( unearned_discount_taken, 0 )) from ar_receivable_applications ara where ara.status = 'APP' and ara.application_type= 'CASH' and nvl( ara.confirmed_flag, 'Y' ) = 'Y' and ara.applied_customer_trx_id = rcta.customer_trx_id and ara.gl_date <= :p_as_of_date ) , 0) + nvl( ( select sum(ara.amount_applied) from ar_receivable_applications ara where ara.status = 'APP' and ara.application_type != 'CASH' and rctt.type = 'CM' and ara.customer_trx_id = rcta.customer_trx_id and ara.gl_date <= :p_as_of_date ) , 0) + nvl( ( select sum(ara.amount) from ar_adjustments ara where ara.customer_trx_id = rcta.customer_trx_id and ara.gl_date <= :p_as_of_date) , 0) ) != 0 union select abc.ledger ledger , abc.op_name ou_name , abc.c_balancing c_balancing , abc.c_account c_account , abc.c_flexdata c_flexdata , abc.c_flexdata_desc c_flexdata_desc , abc.currency_code currency_code , abc.orig_invoice_rate orig_invoice_rate , hp.party_name customer_name , hca.account_number account_number , abc.invoice_number invoice_number , abc.lookup_code lookup_code , abc.receipt_date invoice_date , abc.int_invoice_number internal_invoice_no , abc.trans_type transaction_type , abc.custid cust_trx_id , abc.exchange_rate exchange_rate , abc.orig_amt invoice_amt_entered , 0 invoice_amt_accounted , 0-abc.original_amount inv_amt_due , 0-abc.historic_amount inv_amt_due_er , 0-abc.closing_amount inv_amt_due_reval from ( select gl.name ledger , hou.name op_name , fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_select_all', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE') c_balancing , fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_select_all', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'GL_ACCOUNT', 'Y', 'VALUE') c_account , fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_select_all', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'ALL', 'Y', 'VALUE') c_flexdata , fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_select_all', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'ALL', 'Y', 'DESCRIPTION') c_flexdata_desc , hca.cust_account_id custid , decode(ara.status,'ACC','*' || al.meaning) trans_type , acr.receipt_number invoice_number , acr.doc_sequence_value int_invoice_number , acr.receipt_date , al.lookup_code , acr.amount orig_amt , nvl(acr.exchange_rate,1) orig_invoice_rate , substr(acr.currency_code,1,3) currency_code , sum(nvl(ara.amount_applied,0)) original_amount , sum(nvl(acr.exchange_rate,1) * nvl(ara.amount_applied,0)) historic_amount , sum(nvl(ara.amount_applied,0)) * case '&lp_exchange_rate_type' when 'User' then :p_exchange_rate else case when gl_currency_api.get_rate_sql(acr.currency_code,gl.currency_code,:p_as_of_date,'&lp_exchange_rate_type') in (-1,-2) then to_number(null) else gl_currency_api.get_rate_sql(acr.currency_code,gl.currency_code,:p_as_of_date,'&lp_exchange_rate_type') end end closing_amount , case '&lp_exchange_rate_type' when 'User' then :p_exchange_rate else case when gl_currency_api.get_rate_sql(acr.currency_code,gl.currency_code,:p_as_of_date,'&lp_exchange_rate_type') in (-1,-2) then to_number(null) else gl_currency_api.get_rate_sql(acr.currency_code,gl.currency_code,:p_as_of_date,'&lp_exchange_rate_type') end end exchange_rate from hr_operating_units hou , gl_ledgers gl , ar_receivable_applications ara , ar_lookups al , ar_cash_receipts acr , ar_cash_receipt_history acrh , hz_cust_accounts hca , gl_code_combinations gcc , ar_distributions ads , xla_distribution_links xdl , xla_ae_lines xal , ar_system_parameters sp where hou.organization_id = sp.org_id and hou.set_of_books_id = sp.set_of_books_id and gl.ledger_id = sp.set_of_books_id and acr.org_id = hou.organization_id and acr.org_id = ara.org_id and hca.cust_account_id = acr.pay_from_customer and acr.cash_receipt_id = ara.cash_receipt_id and acrh.cash_receipt_id = ara.cash_receipt_id and ara.cash_receipt_history_id = acrh.cash_receipt_history_id and al.lookup_type = 'PAYMENT_TYPE' and ara.status = al.lookup_code and ara.status = 'ACC' and not exists ( select 'X' from ar_cash_receipt_history crhin where crhin.cash_receipt_id = acr.cash_receipt_id and crhin.status = 'REVERSED' ) and nvl(ara.confirmed_flag,'Y') = 'Y' and nvl(acr.confirmed_flag,'Y') = 'Y' and ads.source_id = acrh.cash_receipt_history_id and xdl.source_distribution_id_num_1 = ads.line_id and xdl.application_id = 222 and xal.ae_header_id = xdl.ae_header_id and xal.ae_line_num = xdl.ae_line_num and xal.application_id = 222 and xal.accounting_class_code = 'ACC' and gcc.code_combination_id = xal.code_combination_id and exists( select null from gl_import_references gir, gl_je_headers gjh where gir.gl_sl_link_id=xal.gl_sl_link_id and gir.gl_sl_link_table=xal.gl_sl_link_table and gjh.je_header_id=gir.je_header_id and gjh.status='P' and gjh.ledger_id=sp.set_of_books_id ) and ara.gl_date <= :p_as_of_date and 2=2 group by gl.name , gl.currency_code , hou.name , gcc.chart_of_accounts_id , gcc.code_combination_id , hca.cust_account_id , decode(ara.status,'ACC','*' || al.meaning) , acr.receipt_number , acr.doc_sequence_value , acr.receipt_date , al.lookup_code , acr.amount , nvl(acr.exchange_rate,1) , substr(acr.currency_code,1,3) , acr.currency_code having sum(ara.amount_applied) <> 0 union select gl.name ledger , hou.name op_name , fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_select_all', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE') c_balancing , fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_select_all', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'GL_ACCOUNT', 'Y', 'VALUE') c_account , fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_select_all', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'ALL', 'Y', 'VALUE') c_flexdata , fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_select_all', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'ALL', 'Y', 'DESCRIPTION') c_flexdata_desc , hca.cust_account_id custid , decode(ara.status,'UNAPP','*' || al.meaning) trans_type , acr.receipt_number invoice_number , acr.doc_sequence_value int_invoice_number , acr.receipt_date , al.lookup_code , acr.amount orig_amt , nvl(acr.exchange_rate,1) orig_invoice_rate , substr(acr.currency_code,1,3) currency_code , sum(ara.amount_applied) original_amount , sum(nvl(acr.exchange_rate,1) * nvl(ara.amount_applied,0)) historic_amount , sum(ara.amount_applied) * case '&lp_exchange_rate_type' when 'User' then :p_exchange_rate else case when gl_currency_api.get_rate_sql(acr.currency_code,gl.currency_code,:p_as_of_date,'&lp_exchange_rate_type') in (-1,-2) then to_number(null) else gl_currency_api.get_rate_sql(acr.currency_code,gl.currency_code,:p_as_of_date,'&lp_exchange_rate_type') end end closing_amount , case '&lp_exchange_rate_type' when 'User' then :p_exchange_rate else case when gl_currency_api.get_rate_sql(acr.currency_code,gl.currency_code,:p_as_of_date,'&lp_exchange_rate_type') in (-1,-2) then to_number(null) else gl_currency_api.get_rate_sql(acr.currency_code,gl.currency_code,:p_as_of_date,'&lp_exchange_rate_type') end end exchange_rate from hr_operating_units hou , gl_ledgers gl , ar_receivable_applications ara , ar_lookups al , ar_cash_receipts acr , ar_cash_receipt_history acrh , hz_cust_accounts hca , gl_code_combinations gcc , ar_distributions ads , xla_distribution_links xdl , xla_ae_lines xal , ar_system_parameters sp where hou.organization_id = sp.org_id and hou.set_of_books_id = sp.set_of_books_id and gl.ledger_id = sp.set_of_books_id and acr.org_id = hou.organization_id and acr.org_id = ara.org_id and hca.cust_account_id = acr.pay_from_customer and acr.cash_receipt_id = ara.cash_receipt_id and acrh.cash_receipt_id = ara.cash_receipt_id and ara.cash_receipt_history_id = acrh.cash_receipt_history_id and al.lookup_type = 'PAYMENT_TYPE' and ara.status = al.lookup_code and ara.status = 'UNAPP' and nvl(ara.confirmed_flag,'Y') = 'Y' and nvl(acr.confirmed_flag,'Y') = 'Y' and ads.source_id = acrh.cash_receipt_history_id and xdl.source_distribution_id_num_1 = ads.line_id and xdl.application_id = 222 and xal.ae_header_id = xdl.ae_header_id and xal.ae_line_num = xdl.ae_line_num and xal.application_id = 222 and xal.accounting_class_code = 'UNAPP' and ads.source_type <> 'BANK_CHARGES' and ads.source_table = 'CRH' and xdl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL' and gcc.code_combination_id = xal.code_combination_id and exists( select null from gl_import_references gir, gl_je_headers gjh where gir.gl_sl_link_id=xal.gl_sl_link_id and gir.gl_sl_link_table=xal.gl_sl_link_table and gjh.je_header_id=gir.je_header_id and gjh.status='P' and gjh.ledger_id=sp.set_of_books_id ) and not exists ( select 'X' from ar_cash_receipt_history crhin where crhin.cash_receipt_id = acr.cash_receipt_id and crhin.status = 'REVERSED' ) and ara.gl_date<=:p_as_of_date and 2=2 group by gl.name , gl.currency_code , hou.name , gcc.chart_of_accounts_id , gcc.code_combination_id , hca.cust_account_id , decode(ara.status,'UNAPP','*' || al.meaning) , acr.receipt_number , acr.doc_sequence_value , acr.receipt_date , al.lookup_code , acr.amount , nvl(acr.exchange_rate,1) , substr(acr.currency_code,1,3) , acr.currency_code having sum(ara.amount_applied) <> 0 ) abc , hz_cust_accounts hca , hz_parties hp where hca.party_id = hp.party_id and hca.cust_account_id = abc.custid and 3=3 ) trx order by trx.ledger , trx.c_balancing , trx.c_account , trx.c_flexdata , trx.currency_code , trx.customer_name , trx.invoice_number AR AROBRR #,##0.00;[Red]-#,##0.00 AR AR Open Balances Revaluation Imported from BI Publisher Application: المقبوضات Source: تقرير إعادة تقييم الأرصدة المفتوحة في المقبوضات Short Name: AROBRR DB package: ar_obalrev_pkg D AR Open Balances Revaluation Imported from BI Publisher Description: Auswertung "KR Neubewertung Offene Salden" Application: Debitoren Source: KR Neubewertung Offene Salden Short Name: AROBRR DB package: ar_obalrev_pkg E AR Open Balances Revaluation Importado de BI Publisher Aplicación: Cuentas por cobrar Fuente: Informe de revalorización de saldos pendientes AR Nombre corto: AROBRR Paquete DB: ar_obalrev_pkg F AR Open Balances Revaluation Imported from BI Publisher Application: Receivables Source: Etat de réévaluation des soldes AP Short Name: AROBRR DB package: ar_obalrev_pkg I AR Open Balances Revaluation Imported from BI Publisher Application: Receivables Source: Rapporto Rivalutazione saldi aperti AR Short Name: AROBRR DB package: ar_obalrev_pkg JA AR Open Balances Revaluation BI Publisherからのインポート 申請書を提出する。売掛債権 出典は、以下の通りです。ARオープンバランス再評価報告書 略称です。AROBRR DB パッケージ: ar_obalrev_pkg KO AR Open Balances Revaluation BI Publisher에서 가져옴 신청 : AR 출처 : AR 미결 잔액 재평가 보고서 짧은 이름 : AROBRR DB 패키지 : ar_obalrev_pkg PTB AR Open Balances Revaluation Importado da editora BI Aplicação: Contas a receber Fonte: AR Relatório de Reavaliação de Saldos Abertos Nome curto: AROBRR Pacote DB: ar_obalrev_pkg RU AR Open Balances Revaluation Импортировано из Издательства БИ Приложение: Дебиторская задолженность Источник: АР Отчет о переоценке открытого сальдо Короткое имя: AROBRR Пакет БД: ar_obalrev_pkg S AR Open Balances Revaluation Importerad från BI Publisher Ansökan: Fordringar Källa: AR Omvärderingsrapport för öppna saldon Kort namn: AROBRR DB-paket: ar_obalrev_pkg TR AR Open Balances Revaluation BI Publisher'dan içe aktarıldı Uygulama: Alacaklar Kaynak: AR Açık Bakiyeler Yeniden Değerleme Raporu Kısa isim: AROBRR DB paketi: ar_obalrev_pkg US AR Open Balances Revaluation Report: AR Open Balances Revaluation Report Application: Receivables Source: AR Open Balances Revaluation Report Short Name: AROBRR ZHS AR Open Balances Revaluation Imported from BI Publisher Application: 应收帐款 Source: AR 未结余额重估报表 Short Name: AROBRR DB package: ar_obalrev_pkg Enginatics R12 only &lp_exchange_rate_type 1=1 2=2 3=3 :gc_currency_where :gc_currency_where1 :gc_customer_name :gc_customer_where :gc_customer_where1 :gc_exchange_rate_type :gc_func_currency :gc_incl_domestic_inv_where :gc_incl_domestic_inv_where1 :gc_ledger_id :gc_ou_name :gc_ou_where :gc_ou_where1 :gc_trx_date_where :gc_trx_date_where1 :gd_date_to :gd_date_to1 :p_as_of_date :p_currency :p_customer :p_dummy :p_exchange_rate :p_exchange_rate_type :p_incl_domestic_inv :p_org_id :p_user_exchange_rate_type :var2 1 10 1=1 gl.name = :p_ledger LOV GL Ledger (restricted by AR System Parameters) B581C79E6D7AE63DE0530100007FE14A Y select gl.name value, fifsv.id_flex_structure_name||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where gl.ledger_id in (select asp.set_of_books_id from ar_system_parameters asp) and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, gl.name coalesce(xxen_util.default_ledger,xxen_util.previous_parameter_value(:parameter_id)) US Ledger Ledger 2 2=2 gl.name = :p_ledger US Ledger 3 20 1=1 hou.name = :p_operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) US Operating Unit Operating Unit 4 2=2 hou.name = :p_operating_unit US Operating Unit 5 30 :p_as_of_date Date trunc(sysdate) Y US As of Date As of Date 6 40 :p_user_exchange_rate_type LOV custom Y select gdct.user_conversion_type value, null description from gl_daily_conversion_types gdct where user_conversion_type = 'User' or exists (select null from ar_payment_schedules_all apsa where apsa.org_id in (select hou.organization_id from hr_operating_units hou, gl_ledgers gl where gl.ledger_id = hou.set_of_books_id and mo_global.check_access(hou.organization_id) = 'Y' and ( (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,hou.name)='Y') and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') ) ) and apsa.status = 'OP' and apsa.exchange_rate_type = gdct.conversion_type ) order by gdct.user_conversion_type select gdct.user_conversion_type from ar_payment_schedules_all apsa, gl_daily_conversion_types gdct where gdct.conversion_type = apsa.exchange_rate_type and apsa.org_id in (select hou.organization_id from hr_operating_units hou, gl_ledgers gl where gl.ledger_id = hou.set_of_books_id and mo_global.check_access(hou.organization_id) = 'Y' and ( (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,hou.name)='Y') and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') ) ) and apsa.status = 'OP' and apsa.exchange_rate_type is not null and rownum=1 Y US Exchange Rate Type Exchange Rate Type 7 &lp_exchange_rate_type select gdct.conversion_type from gl_daily_conversion_types gdct where gdct.user_conversion_type = :p_user_exchange_rate_type US Exchange Rate Type 8 50 1=1 rcta.invoice_currency_code = :p_currency LOV FND Currency 8E2FF36EDE9079D2E0530100007F1FF2 Y select fcv.currency_code value, fcv.description from fnd_currencies_vl fcv where fcv.enabled_flag='Y' order by fcv.currency_code US Currency Currency - Must be specified for User Exchange Rate Type 9 2=2 acr.currency_code = :p_currency US Currency 10 60 :p_exchange_rate Number US User Rate Type Exchange Rate Exchange Rate - only applies to User Exchange Rate Type 11 70 1=1 rcta.invoice_currency_code <> gl.currency_code LOV Oracle AP_SRS_YES_NO_MAND Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description N Y Y US Include Domestic Invoices Include Domestic Invoices 12 2=2 acr.currency_code <> gl.currency_code N US Include Domestic Invoices 13 80 1=1 hca.account_number = :p_customer LOV Oracle AR_CUST_NAME Y select cust.account_number id, party.party_name value, null description from hz_cust_accounts cust,hz_parties party where cust.party_id=party.party_id order by cust.account_number US Customer Customer 14 2=2 hca.account_number = :p_customer US Customer :$flex$.ledger Ledger Exchange Rate Type :$flex$.ledger Ledger Operating Unit :$flex$.operating_unit Operating Unit Exchange Rate Type E83C7EA52609B92F56ED3A8AF8D14795 Default Y SYSADMIN 4 Account Segment 5 Accounting Flexfield 6 Accounting Flexfield Desc. 15 Amount Due 3 Balancing Segment 7 Currency 9 Customer Number 16 Exchange Rate 12 Internal Invoice Number 14 Invoice/Receipt Amount 13 Invoice/Receipt Date 10 Invoice/Receipt Number 1 Ledger 22 Missing Revaluation Rates 17 Open Functional Amount 20 Open Revalued Amount 2 Operating Unit 21 Profit/Loss 19 Revaluation Rate 18 Revaluation Rate Type 8 Trading Partner 11 Transaction Type AR Open Balances Revaluation - Default Template.xlsx US UEsDBBQAAAAIAIiO5ly+0BxCqwEAAOEHAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbM1VyU7DMBC9I/EPka+ocSkSQqhpDyxHQFA+wI2njdXEtjzT0v49E7csqroQtQguiRN73nuzeKbbn1dlMoOAxtlMnKdtkYDNnTZ2nInXwX3rSiRIympVOguZWACKfu/0pDtYeMCErS1moiDy11JiXkClMHUeLO+MXKgU8WcYS6/yiRqD7LTblzJ3lsBSi2oM0evewkhNS0ru5vx7qWRorEhuludqqkwo70uTK+JtObN6jaTlRiOTg3b5tGKTFH0ApbEAoKpMfTCMFF6AiB1DITdyBiixGenKq5QtozAsjMczdn0LQ72z3auV3SOnIxgNyZMK9KAq9l3OS/nmwmTo3CTdDdI0NDFEaaWM/dC9gz8eRhlf50cWUvsXgRvq6PwTHRd/pMObmaMbxVdPfi35Rhlr6pI8dpo2cezJ2EaFz5C7oPH35K0I9mgj7lgg4/NwKRFmDyHSogQ8cq0sQfcxFyqAfiHuheOjC/iO/ZNyGKghK15WbFwfHv21lv+JvEsOz4un4DzySArQPCkf/b+2bnkGgkBmdyI+GXmeNSdcm3JQD0wNegO3jAO69w5QSwMEFAAAAAgAiI7mXLVVMCPuAAAATAIAAAsAAABfcmVscy8ucmVsc42Sz07DMAzG70i8Q+T76m5ICKGlu0xIuyFUHsAk7h+1jaMkQPf2hAOCSmPb0fbnzz9b3u7maVQfHGIvTsO6KEGxM2J712p4rZ9WD6BiImdpFMcajhxhV93ebF94pJSbYtf7qLKLixq6lPwjYjQdTxQL8exypZEwUcphaNGTGahl3JTlPYa/HlAtPNXBaggHeweqPvo8+bK3NE1veC/mfWKXToxAnhM7y3blQ2YLqc/bqJpCy0mDFfOc0xHJ+yJjA54m2lxP9P+2OHEiS4nQSODzPN+Kc0Dr64Eun2ip+L3OPOKnhOFNZPhhwcUPVF9QSwMEFAAAAAgAiI7mXLVV1HKhAQAAZQMAABAAAABkb2NQcm9wcy9hcHAueG1snZPBbtswDIbvA/YOgu6N3GYohkBW0bUbetjQoHG7MyfTsVBZMiTGSPb0k23EcdqediP5U9QnkpI3+8ayDkM03uX8cpFxhk770rhtzp+LHxdfOYsErgTrHeb8gJHfqM+f5Dr4FgMZjCyVcDHnNVG7EiLqGhuIiyS7pFQ+NEDJDVvhq8povPd616AjcZVl1wL3hK7E8qKdCvKx4qqj/y1aet3zxZfi0CZgJQtPYAvToMqkODnytm2t0UDp9eqX0cFHXxH7vtdopZiLMlFvUO+CoUNfY+7KjQaLd+lCVYGNKMUpIB8Q+mauwYSoZEerDjX5wKL5m9p5xdkfiNhj5ryDYMBRwu3TRmewbRspqN8+vMYakaIUU3Aw57lz23xRyyEhGeeJw6kBJAnniIUhi/GxWkOgD4iXc+IBbOQdGW+f2GOaO/sGFpxOu/GEHdjd0OA59XRgbTpPHysQoEFKq/nuuUfwN6g/jXuNz23h74HwOIrzoNzUELBM05tGNQXkQ5pCsH2RuxrcFstjznuhX5yX8deoy+tFtszSTsxiUpz+h/oHUEsDBBQAAAAIAIiO5lwefdbONgEAAFECAAARAAAAZG9jUHJvcHMvY29yZS54bWyNklFLwzAUhd8F/0PJe5tkneJC24HKnhwIThTfQnK3BZs0JNFu/9603boN9uDjvefcL+deUsx3uk5+wXnVmBLRjKAEjGikMpsSva8W6QNKfOBG8roxUKI9eDSvbm8KYZloHLy6xoILCnwSScYzYUu0DcEyjL3YguY+iw4TxXXjNA+xdBtsufjmG8ATQu6xhsAlDxx3wNSORHRASjEi7Y+re4AUGGrQYILHNKP45A3gtL860CtnTq3C3sadDnHP2VIM4ujeeTUa27bN2ryPEfNT/Ll8eetXTZXpbiUAVYUUTDjgoXFVEdOeini4mvuwjDdeK5CP+6hf6UnRxx3mQCYxABviHpWP/Ol5tUDVhEzylJKU0hXJ2d2UTclX9+TFfBdoaOjDw/8kRtyM5bMz4hEw5L78BNUfUEsDBBQAAAAIAIiO5lxNQdbSGgEAAHsEAAAaAAAAeGwvX3JlbHMvd29ya2Jvb2sueG1sLnJlbHO9lMFKxDAQhu+C7xDmbtN2dRXZdA8uwl51fYDQTtuwbRIycbVvb6zQWljqHoqXwMwk//8xzGSz/WwbdkJHymgBSRQDQ52bQulKwNvh+eYBGHmpC9kYjQI6JNhm11ebF2ykD4+oVpZYUNEkoPbePnJOeY2tpMhY1KFSGtdKH0JXcSvzo6yQp3G85u63BmQTTbYvBLh9sQJ26Gxw/lvblKXKcWfy9xa1P2PBP4w7Uo3og6h0FXoBQ4p4X1lFgRj4eZj7JWGolg6LV+9Cr2kEmqTnYNIlYS7oTDoHk/wzTDIHs14ShnzXhKEfBuYnnrO/W9Leh1XC0b0PeX/OtuB2SQarTsY/ybDVOyyVVt97PyKNVX7u4oDJJ19G9gVQSwMEFAAAAAgAiI7mXOIrf3u7AAAAMwEAADIAAAB4bC9waXZvdENhY2hlL19yZWxzL3Bpdm90Q2FjaGVEZWZpbml0aW9uMS54bWwucmVsc4WPwWrDMBBE74X+g9h7LTuHUIrlHBICuQbnAxZpbYvYWqFVQvz30TGhhR6HYd7MtLvHMqs7JfEcDDRVDYqCZefDaODSH7++QUnG4HDmQAZWEth1nx/tmWbMJSSTj6IKJYiBKef4o7XYiRaUiiOF4gycFsxFplFHtFccSW/qeqvTKwO6N6Y6OQPp5BpQ/RpL8/9sHgZv6cD2tlDIf1To6O+c91jmnclyclLgmEbKBn5ZTVWmg+5a/Xa1ewJQSwMEFAAAAAgAiI7mXDI8/C/JAwAAtRAAACcAAAB4bC9waXZvdENhY2hlL3Bpdm90Q2FjaGVEZWZpbml0aW9uMS54bWzVWFtv4jgUfl9p/4OV95BLw1XAiHCRkJjOqO3Mu5sYsBrbke2wqVbz3/c4BhouOy0jwe5IqCW2+53vXPydnPY/lSxDGyIVFXzgBA3fQYQnIqV8NXC+Pc3cjoOUxjzFmeBk4LwS5Xwa/vlHP6cbocc4WZMJWVJONQAgAONq4Ky1znuep2CTYdUQOeGwsxSSYQ2PcuWpXBKcqjUhmmVe6Pstj2HKHYvQkx/BEMslTchEJAUjXFsQSTJsmKg1zdUOjSUfgWNYvhS5mwiWA8Qzzah+rUAdxJLefMWFxM8ZhKCUO+DylCejiRRKLHUDgDxL8cTbIAKiG2pi7iDZo+nAkfM0gO9kKYlaf+ELgWHxbYWk8evAGRV6LcD69hhJJ1gDoagZBn6jHYVhyw86zaDTBspUKcjhXBOmFpRRPXAgtQlEXZP0+y7fkNw9Vn2RUf5gqRiX9zt35ngiZDoWBQdE4FfKXmH4/x377XYrbI3d9jQeu1HcbLqjVjBzp5N2HIw70/Zds/nDGfYTUzKPopAJQfo1B/p/CflSVQLs7r9vT3DM4IR9AGex4w37Xg1iizejJEsVSiytMNzZqdaRBVmQdEUgeLxgM6bnwNmHY+ChJGkVpt2fB2YZbQbO/agyVzuyM17h1m1vbXzJiYTi4Sv0DW7EdW3FOMM8MbYeycrcgOuaGyVVdG9qzDg3y0i5NOG+iXsHFtGEqKTxE7v7Yvy3ehgXUoKcvl6X+5PERq/RVyw1v3aJjwulBSMS3Rfs+drG5nwjjIA+kITQXN/EJkSTK5xU/ewJBOq6uZtzTSTHGdq6+iEXuYZeqe4Ft/pvhF3YtUctq85dW4pBJl6MVr9brcfRNuh174PmiWBurRJGP9OSpCZe0P9r1s+RtKyheZxhDZ3Hbod+6Lt+AJ8n3+9VH+hquDzaDWu7W/k3+p0a/T4HcaGgH4dkxIwIHgSl9QtROZMme50OwmJqA1pWtQZx+Y6zwmYbwvD2UPOaG6/9S5uW9QlNisNk//Z+TctkjfmKoIfjOr61ayZ/+5RVdb99fRr2q5TZu3nZewZHs4JXKgXi8f8ry3fF5oFsoJ6rl/UqQRdr7VjIHF7JQaIuDN6x5f/0Nl+nNKyLJP0dC+OrFEuqvYVQMMC9vawHt760Rzr7bkF/thMXOi6vAy9OR45f6+V1CWE/r387LtkJadgnpV4oXf1GhaQwuLXD5mgajqZuN+oGbtR5Jm4cxpEbTeNuO5qN7/xO9GM/8QbRySz9oZHX73pdO+IP+2UQ9c79+8D4Abzsz4qld+7Y8B9QSwMEFAAAAAgAiI7mXKWNdG8KAQAAfAIAACQAAAB4bC9waXZvdENhY2hlL3Bpdm90Q2FjaGVSZWNvcmRzMS54bWyVksFKxDAQhu+C7xDmvk1XRKS0XUQRvHgQfYBsOm2DTSZk0tJ9e7OWZQ8V2b3N8Ge++f8h5W62g5gwsCFXwTbLQaDT1BjXVfD1+bp5BMFRuUYN5LCCAzLs6tub0puJ4rPSPX6gptCwSCTHFfQx+kJKTopVnJFHl5SWglUxtaGT7AOqhnvEaAd5l+cP0irjYCEU4RIGta3R+EJ6tOjiAgk4qJhycG88n2hWX4KzKnyPfqPJ+oTYm8HEwy8UhNXFW+coqP2Q8s/hBJ7XPq3RgZjamCWQXCyu0m7vk9HJHA8OQtPoYro71GWoy1lMFeQgL6/4OPH+dM3IeYm9YpH719pZ/eudTNHk6r/UP1BLAwQUAAAACACIjuZcCkEM6r0AAABHAQAAKQAAAHhsL3Bpdm90VGFibGVzL19yZWxzL3Bpdm90VGFibGUxLnhtbC5yZWxzhY/BCsIwDIbvgu9QcrfdPIjIOg+K4FX0AUKXbcUtLW0VfXvrbQPBY8if789X7V/jIJ4UonWsoZQFCGLjGsudhtv1tNqCiAm5wcExaXhThH29XFQXGjDlo9hbH0WmcNTQp+R3SkXT04hROk+cN60LI6Y8hk55NHfsSK2LYqPClAH1jCnOjYZwbkoQ17fPzf/Zrm2toaMzj5E4/ahQ3j5dOmB+70itZfsVyHwMHSUNUk4CP7OlzDqg6krN9OsPUEsDBBQAAAAIAIiO5lxH0d+FAgYAABkrAAAeAAAAeGwvcGl2b3RUYWJsZXMvcGl2b3RUYWJsZTEueG1s7Vpdb6M4FH1faf8D4p0hECBJlWREQ9BU6u5U0+7sswMmsQYwMqZNNdr/vteGECDNbJppHqbLQz98gcvhcG1jnzP9uE1i5RGznNB0phofBqqC04CGJF3P1L8efG2sKjlHaYhimuKZ+oxz9eP899+mGXmk/AGtYuzhiKSEQwIFkqX5TN1wnl3peh5scILyDzTDKRyJKEsQhyZb63nGMArzDcY8iXVzMHD0BJFULTNcJcEpSRLEvhWZFtAkQ5ysSEz4s8ylKklwdbNOKRP4ZuqW7RJv2UHihASM5jTiHyCRTqOIBPgAn2HpDD8SwRKkYlcFCWfqd3vpDcaWda0ZvjHSrLFvaNcLe6QNrw3XswzbdozJP6qSogRA3NWEGaoSIODmBnIYNrRQlsXPfxbJCjO/JGmmwouQ4WvKwhfCPk35wbl3iHPM0oO4G5N1muAXrvibhHzzCZP1Zp8NAIWIowXKxDudqV9RXMBbV4oMwjj8uisWqIyEpF9wxHC+EUTXR4ZQMxv65DESx/JJihy7BaclMC5rC+5COE7uGEn5A+ExhmcWxEBddG5C0hCgyzzyVQet/z2AKo8lRcxJFmOf4Dj0SQxMSBrn05gGUB9QngxHM9V1ru4NS1UiwnL+CaoQsy/0SaaQIZFQBgBNHVhQeBADCovRpzu0xgtaCEgCMI1bAX1edg0JI4fD8kTTBBz7uIK2BMCJ33Cr9nPRgsdEdDUAJFh0Kw5JmmPGr2OUfqvgzaeCwf094BYioGzFtYBDNuDmIY4QkCNCurxiPsVbfptz+VcpGIFaNieWs/TGjuYaI1uzhibSxu7C0BxrOVjYluONvCXUctk/t4Z1Xj8aTPRJ2dPnU0hy1aAkgmLx6FN6i1Y4lsUg8ALA8reEq+/PP0KneBen8Vmxcl+sOOVI1mmHUKNL6Ltn78fFWDH1QLO+OM8qznPp7Tt6NZ6eM272/XxHXnP2bM0yP+jYL7L3bmePkyfjvqjO75H9aHY+d0pfeD155doCFidv8cHcD3mvXm0cnUcbq7X/+byZFomf8HKDQ1WOLWn7weyEwaxBpQMbED2Xp28GHIxtPZdnb6z8kMu+j5+wSSU2VeXMXe0b7rcym2X5Wir7tVg/i5wwi/TTxn9NG8e756u4e2f9sR+0ThjZT1VzXrvP1pJ33rUa0RB2QJ0Cka0tn4HyNp9GctW7E7fqlim24uvWsNWyWq1RqzVutSatliH1szqp0b6H0b4JiInNk532pXa72cZgtEGYpeZVP75k4qap8Y2FJAXSGZz2Mz865CBNaVABXdwSmpzUCF84KPTLowdFabYOroRKCWKp+NI5ct2LV3SCawbGg0YCwYykYz4F2bVTIs0K0eQL0+uT5PktIod7IsvnBQ1UYlUed9LjLiwfXYTLpBAWiSscGeiNh0DqqBJVn3sbgoENrXzB+4vm03qArXVcAa2OVuYBRfkMJgrFL9JAKNkoVtxEKMsgUcsbwMJwhfISCTRBmhdNgVF+bLbXPQDhIL9M/wU/Cq0/7CSf/GzyO0YjwvVbmoONQAI2Qdx+FWB9zxN0zNIksRPXRacoQ0q4japNh0ofdsFPIO0Mn9P4WcqWzdlc9vA7mkv3SqkAg0cAM7DA4Dq9KIs6CrtukuKREJmltA8pD75Aq35cp9op1wIN/F+CPQAtOqAUuH8l0KJaLwoarBpvznTtxrgU05cALerwokyDbefNmRZd6lcDPbk0ZvPtiRZj4EV5fhPM1cgH8/fePnjPn2N8k0a06ZOTwT9wSIoEZh9hg4L9p9KsVfrERAhMWd0QnHXPGcmEm6zyT8FZ3dAtyjmEi0RYHsWMfLhomzjm0rc9Q7MXrqlZwWSojZe+pXnXvr0Y2NZw4pkXskN1TZVtnQfclsLMJUnYkBCX7rydYa2yZ8Gs3/FgvuhyxNsAN92XteFqbwsbWSPXMRxLM8a2q1kDbwG2MNfW/AE4F03bGHi2techC8FHdcqdu/5PwylXANVMGqNnmKbFdxdkLE1iHVYMR1mmwnQY7gxcec0MvPg6+DkFu1LjyDFPWSf9/F9QSwMEFAAAAAgAiI7mXCFmNxQxAAAA3AAAACcAAAB4bC9wcmludGVyU2V0dGluZ3MvcHJpbnRlclNldHRpbmdzMS5iaW5jYKAMMLIwMN8BGsE/u4GdkYGTYRa3CUcKAyMDE2MEExOQjmBiAJK0ASBzgcbjNB8AUEsDBBQAAAAIAIiO5lyQ6juvJwQAANUQAAANAAAAeGwvc3R5bGVzLnhtbNVY227jNhB9L9B/IJSXFqisiyWv5bW8iC8CFtguiiYFCtRFQUuUTSwpChSdyi367x1Ssi1nc3GCtEHykJBD8vAMZ+ZQzPhDzRm6IbKioogtr+daiBSpyGixjq1frhN7aKFK4SLDTBQktnaksj5Mvv1mXKkdI1cbQhQCiKKKrY1S5chxqnRDOK56oiQFjORCcqygK9dOVUqCs0ov4szxXXfgcEwLq0EY8fQcEI7ll21pp4KXWNEVZVTtDJaFeDr6uC6ExCsGVGsvwCmqvYH0US33mxjrV/twmkpRiVz1ANcReU5T8jXdyIkcnB6RAPl5SF7ouP6J77V8JlLgSHJDdfisybjY8oSrCqViW6jY6h9MqBn5mEGMB4GFmqjMRAbnlC1tzvnS3u2WaLMZcT6qKsvZg52sDE9XXvxwceH2XPf98rt9c/n9PUshPN1N9/P/QO9/+5lkvy/tAwLSCE7rymSci6LrEQQUAjj6Uog/i0QPgUfgpp41GVd/oRvMwOJqjFQwIZGCdAQvPcMLc9LMmGFGV5JqY445ZbvG7GuDyeB2HqeQT4ZQs0Pze6VnvfJecr2KrSRxzc/LOGd8rMBJytghiQJ9umCYjKHeFJFFAh3Utq93JZxtAdLQnJGZ98jstcQ7zw/PX1AJRjPNYj0zEW09X1wuksTArNoBWmSkJpDjkOKaTofwueRu79VmD5SMorqk3N67KIqG3mA4HEZB3wsCkzJPYWBOCU55JWQGwrsvVp3FjWkyZiRXgCrpeqP/KlHqPYRSIE6TcUbxWhSYaRf3K9oGwKaEsSstzr/mJ9h13illkHkda60HugmE2maD13Q0fhetwe7CusD56biozg8b3LfaO7LyLdRldViNcFmyndYAXd1tDzxpa/0E2TPK9ZjDt6A/b/mKyMRI5Z2gjZK+OOp/wfWsgB/9L+mNUNMtJJz+KtCZcHqcAyPnL+x5h2Mn/P2XCH+X79nYt+P/lITr+AL5e0+BPZjKl4yuC06a7J6M4b5quvprTdFU31YpdElzO9V5W6xQnh0NOFGAQy0jfQ/G1med2Qw+Z9pyRKstZSBzd1Q/YGZ1R08GwAgMj2r9Xk73+nimnN6p3I7ZsNn1cAu313J37OG76jUYvS22r3N+r7Pr24rM22L7f0dUawDolNKvP/MBdBA/EOOM5HjL1PVhMLaO7R9JRrccdLqd9ZO+/QxEbB3bzaxIyy2p1acK3gHwF20lja2/F9N30XyR+PbQnQ7toE9COwqnczsMZtP5PIlc353903mDPu+15+oXqHkyw4XsBaOKwTtVts625K+OttjqdD7pj0lzlTtAu8s98gfuZei5dtJ3PTsY4KE9HPRDOwk9fz4IposwCTvcw+dx91zH847kw5GinDBa7GO1j1DXCkGC7gNOaFdMJJzj/yMm/wJQSwMEFAAAAAgAiI7mXMKH2/JRBgAA1xsAABMAAAB4bC90aGVtZS90aGVtZTEueG1s7VlPb9s2FL8P2HcgdG9jJ7YTB3WK2LGbrU0bJG6HHmmZlthQokDSSX0b2uOAAcO6YZcBu+0wbCvQArt0nyZbh60D+hX2SEq2GDON06bYv+YQi9SP7/97fKSuXL2fMHRIhKQ8bQXVy5UAkTTkQ5pGreB2v3dpLUBS4XSIGU9JK5gQGVzdeP+9K3hdxSQhCNanch23glipbH1pSYYwjeVlnpEU3o24SLCCoYiWhgIfAd2ELS1XKo2lBNM0QClOgOyt0YiGBPUNSXi7ii7BT7USbBSMugxepUrqiZCJfc2GuKtPrhseVDVaTmSHCXSIWSsA/kN+1Cf3VYAYlgpetIKK+QuWNq4s4fV8EVOnrC2t65m/fF2+YHiwbHiKaDBlWu3VmqtbU/oGwNQ8rtvtdrrVKT0DwGEIWltZyjRrvbVqu6BZAtnHedqdSr1Sc/El+itz9JvtdrvezGWxRA3IPtbm8GuVRm1z2cEbkMXX5+Vvb3Y6DQdvQBbfmMP3VpuNmos3oJjR9GAOrf059cwUMuJs2wtfA/haEQAzFETDNNI0ixFP1SJxl+B7XPQAbByNFU2RmmRkhEOI9A5OBoJirTleJ7j0xk6Fcm5K80UyFDRTreDDDEPWzOi9fPb9y2dP0Mtnj48fPD1+8NPxw4fHD360tJyF2ziNygtffPvZn19/jP548s2LR1/48bKM//WHT375+XM/ELJpJtHzLx//9vTx868+/f27Rx74psCDMrxPEyLRTXKE9ngCunkkJwNxvhX9GFNnBY6Btod0V8UO8OYEMx+uTVzj3RFQSHzAa+N7jqz7sRgr6uF8PU4c4A7nrM2F1wDXNa+ShfvjNPIzF+Mybg/jQx/vDk4d13bHGVTTIiidqOnExBFzl+FU4YikRCH9jh8Q4tHuLqWOXXdoKLjkI4XuUtTG1GuSPh04gTRbtE0T8MvEpzO42rHNzh3U5syn9RY5dJGQEJh5hO8T5pjxGh4rnPhI9nHCyga/gVXsE3J/IsIyrisVeDoijKPukEjpW3NLgL4lp1/HULu8bt9hk8RFCkUPfDRvYM7LyC1+0Ilxknllpmlcxn4gDyBEMdrlygff4W6G6DH4AaenuvsOJY67zy4Et2nkiDQLEP1mLDy+vEa4m48TNsLEVBko706lTmj6qrLNKNTtd2W72Mc2YRPzJc/2iWJ9Gu5fWKK38DjdJZAV81vUuwr9rkIH//kKfVouX3xdnpViqNKzvts0tclCTfiIMravJozckKYPl7AZDXswaQbm9Dg9oGUxPOZbgoOLBDZrkODqI6ri/Rhn0MNXzbE0kjnpSKKMSzhHmmkvbXOMpdDGm1NovThvAhqrHT600yvlc+iUjNmoInPuLRitaAKLMltZzQ+3r8msaqVaULWqEc0USEe1qcqgzLxqRsPcmtDlIOiNwMoNONBranD2wYwMtd3ttl24xdjkIl0kYzwkuY+03vOKVI2TilgpwsjjI32mPMNqJW5NTfYNuC3ipDK72insCu+9iZcK68y8pHP4RDqytJycLEVHraBZX64HKMRZKxjBsRkekwy8LnVjiVkE91OhEjYQz0xmg5p5s+kPyyrcipziTYdFJqTawjK2oWFeFdc0qTnkG/mX62DWi1LARvprSLGyBsHwt0kBMruuJaMRCVXZ2aUZcwdiAHny87EiYj8eHqEBG4s9DO7XoQr6DKmE2w9TEfQAru20tc3ILc550pUvywzOzmOWxTgvtzpFi0y2cGPzqQxmVBJvOjLazGQ/MVxUFZPyF6RKOYz/Z6ro/QSuI1aG5vYMbpMFRjpfWwEXKuZQhbKYhj0Bl2gmAiBa4OoXXoPx4U7b/ApyqH9tzlkaJq3hVKn2aIQEhf1IxYKQXShLJvrOIFbN9y5LsiBkc3omrsys2ANySFhf15CG3tsDFBfVJC8DBncy/txxHnaDSDcs/9TOxybzeduDWedj1y/Yi9RKRb+0FTTfTIRzbrW2Ys1pvFxfeKvN4FIJ6X+w/1ERMmL01xtqn+9B6UTTjhJBVF+yjQfSBdI+DaBxspM2mDSpt9tGzTrdKd+32HyWtvlpc+ayc3Lx1d3n+YydW9ixdbnT9ZgaHHAyRXV7VBxqjGPMl7XyBy8+uAeO3oJPCGOmpP10cB+uEGHLsh8kIPmtc83Sjb8AUEsDBBQAAAAIAIiO5lw/NEKoFwMAAEAHAAAPAAAAeGwvd29ya2Jvb2sueG1spVVrb9owFP0+af/Bs5C6SoMkJqQQARWURkPqWlRo+xGZxIDVJI4ch4eq/vddB8KjTBvqAiTYvjk+99yTm+b1KgrRgsmUi7iFrYqJEYt9EfB41sJPI69cxyhVNA5oKGLWwmuW4uv21y/NpZCvEyFeEQDEaQvPlUpcw0j9OYtoWhEJi2FlKmREFQzlzEgTyWiQzhlTUWgQ03SMiPIYbxBceQ6GmE65z3rCzyIWqw2IZCFVQD+d8yQt0CL/HLiIytcsKfsiSgBiwkOu1jkoRpHv9mexkHQSQtorq4ZWEr4O/CwTTqTYCZZOtoq4L0UqpqoC0MaG9En+lmlY1pEEq1MNzkOyQYQF1zXcsZLOJ1lpQTdYoMKmNDrl/0azwFoFHPkkWm3HjeB2c8pD9ryxLqJJck8jXakQo5Cm6jbgigUtfAVDsWT7CRsjmSXdjIewSpw6ucJGe2fngUQAq5gcSL6g/hqeCYzmPGADvhDK4ywM7niq8umATWkWqhE4vuAB88QmxNGQK+kWSg6URPC/37sDZkO6AJ6gRrC1cR+IWNVx7EvXGr81TPvWu3G8cs9u2GXbblTL9UbNKdvVepXUup7ZrZN3kFI6ri9opuZbCTR0C9uQ78nSL7oqVizTzXiwp/Fmbo+yvn44FWvvOh39sD9ztkz3YukhWr3wOBDLFq7WSR2yWhfjskVguMxXX3ig5jrEsXdzPxmfzYEyAclgkvqKL9iITnJt4QHTRFv4iGBvQ9CDIz8dETQOGOZdBpjmVxTnzug8ogfoSqhLQxr7LEWPbEHDLO8d0OR0ZF4J8Ierd5b9wNKJH2LkLjgIrh4Ek5NgKmFj8BJ0pR089I0dfFXfYRRcwU48ZoG2MTA/GG35j1dhHFXGXm7PHlV0QlOm3e3TcFiwByHBrQHTzRy3L/6W88W3UqdkuaXnktU0Drb7095DkUnou7Apbj943vB29P0M7B8mfG4enu5HnX+Hu6XO5bnBwNq6vPzA+jAHEBBU8eFp1pe8rIQQK69nomt4Q+FFBVH7AUTCVB5aO/SAnRfp6CajePm1fwNQSwMEFAAAAAgAiI7mXDeLW4nYAAAA2QEAACMAAAB4bC93b3Jrc2hlZXRzL19yZWxzL3NoZWV0Mi54bWwucmVsc62RwWrDMAyG74O+g9G9dtLDGKNOL2PQ65o9gOsoiWkiG0sr7dvPu5SlFHbZTdKPPv2StrvLPKkzZg6RLNS6AoXkYxdosPDZvq9fQLE46twUCS1ckWHXrJ62Hzg5KU08hsSqUIgtjCLp1Rj2I86OdUxIReljnp2UNA8mOX9yA5pNVT2b/JsBzYKp9p2FvO82oNprKpP/Zse+Dx7fov+akeTBCJNyIMF8QJGyIBe0ywOKBa3vtfu81sdAYB6brP/VZDhHad1xwqW/W5lNusW1Lgf+sWUWD2m+AVBLAwQUAAAACACIjuZcVqvBU3wDAAAuCwAAGAAAAHhsL3dvcmtzaGVldHMvc2hlZXQxLnhtbKVWXW/bIBR9n7T/gHjYW23jfGdJpq5V1EmbVrX7eCYYJ6jYeEDatNP++y7YxJm6TfZWpb7XvnDuAQ5cFm8OhUT3XBuhyiUmUYIRL5nKRLld4s+f1mdTjIylZUalKvkSP3KD36xevlg8KH1ndpxbBAilWeKdtdU8jg3b8YKaSFW8hEiudEEtvOptbCrNaeY7FTJOk2QcF1SUuEaY6y4YKs8F45eK7Qte2hpEc0kt8Dc7UZmAVrAucAXVd/vqjKmiAoiNkMI+elCMCjZ/ty2VphsJ4z6QIWXooOGXwv8gpPHfn2UqBNPKqNxGgBzXnJ8PfxbPYsqOSM/H3wmGDGEC7oVbwBYq/TdKZHTESluwwT+CuZWpibnp0vO9yJb4e9L8nYEl7pG0jxD7gVeLTMAKu85I83yJz8n8S4rj1cLr54vgD+bER06OG6XuXOAdpEkAoaIlR4+3FSwqSBsjq6r3PLcXXErAgwFSZsU9v4ZmS7xR1qrCxb3gLXzKtXripc/JJYe2wMVh/tq4BmlBzbearycbH9me+oH52m+Oa40yntO9tBdKfhWZ3QFbEg3T0WRK0hEO0Rv1cMXFducGk0YTCHjxzbPHS24Y7AYYdeSzMiUhBTxRIdyuBjHTg7cPDfwgSqcjMho7+A03dt1MEdsbmIVAosGqUWC+PArYgNK9MwjAdwYbOk+iCUlmAzeOjgyGDQjYEwZ/oQzQPivYpkMKx1nHbO4IcJ3Bhs6Dk0XpiDJpUMAGzklEhkmfmQfOngnYwGTSF2PWYIBtF2A6Gg3H0x4rQKA81FICJ3BJo/44R0meaHIcjSbJwCu+4+SSoEnntHT66ooEdTonwMAAu7IIuiStMFPYoD3VTYJanfMf+5QE4Ton4Az70wnKJa1000Ff2ZGgXeeEqSW9UYJ6yYl8x72HlAb1OqeVS/+TMKg3PVEv6U/neKKeHKmzrpsgrg95X18uqaWhvtQ+3Vu1FtJy3VZPIPvbIjz7YxGGUlLRLf9A9VaUBkkojq7GgCB0XYe8D2XVe27f+iIa3nZw2+Nwq0ki2Fe5UsCmfmlwb7ndV1BRK65vxROUVVhdpQVUMn+dW2IJ907DII7RDgJPCiLyshKuvLtLqxXs+A6Ydb61T7RaqCy78h9Wr2hRvb44v0Ef4U6K3lKAZdygG35P5d6nWsRt60X8K058vOmufgJQSwMEFAAAAAgAiI7mXMiEcnzRBQAANRgAABgAAAB4bC93b3Jrc2hlZXRzL3NoZWV0Mi54bWydWVtzqkgQft+q/Q8U7xEH8VqaU0ZjYhITlb08ExwjFWBYmFy39r9v9+CIDEhhqs45jF93f93T3TMDc4a/PgNfe6dx4rFwpJNGU9do6LKNF76M9D//mF30dC3hTrhxfBbSkf5FE/3X5e+/DT9Y/JrsKOUaMITJSN9xHg0MI3F3NHCSBotoCJItiwOHw8/4xUiimDobYRT4htlsdozA8UI9ZRjEdTjYduu5dMrct4CGPCWJqe9wiD/ZeVEi2QK3Dl3gxK9v0YXLgggonj3f41+CVNcCdzB/CVnsPPsw709iOa72GcMfE/62pBuBFzwFnhuzhG15A5iNNObi9PtG33DcA1Nx/rVoiAUJePewgBmV+bOQSPvAZWZkrR+SYWXSwDBd8eDN24z0f/vj1pj0W52Lca/TurBm/d5FfzydXUyn48mkNetcz656/+mXw40HFUZjLabbkT4mA5tYunE5FA30l0c/kqOxxp1nm/rU5RScEF3D/nxm7BUV5wA1gTJyQqp92hFUeaTDBL/2Q6g2Z9ED3fIJ9f2RPunqmuNy750uwWKkPzPOWbD2XnZcrAYO2DZm3zQU8Qi3GCjyj3Sg2qumHHtOiCn5R0xlQsrMUicYhHSeGo6tgyEMS/zlosu5hGlIl120NA6pOx7LNM7EUl3G2oZunTefr9nHLcU5Qz7NRrcNNcRmH2y+pjRxYfVBUhsm8rrMBxL4Vws83EVg8TifaRW8Dd/BqNfokma/hSTuWwLz/Hsv2JunhlASYQhPadjNDJ9pwmdYOeCtIIFeEyTwlCSdRq/dtjo9dF+TBZIuWOC5ZzGPQqlwDy6EITylodUwe23S7pjVs8c9By3hmc3+7MCh5oIFntK/2bDMdrdH0H/N6cOuL1jgmSWRWE0xh5oc/T0HPCVHv9HuNlvnBELgQEqbCQbZhLKE1gyGHJryqCutxplTIrJDcZAl5vxoZJOSoy49PxrZpLAvHnLTPD/FsmVJ1rOkc9SzdVMsG5hkHWy2zu89IlsYB7Lk5PwlTGQT40DyNH8Qj2xkctTJ0I0102LKDsaB7Jl23SoZ6d4qNu6pw53LYcw+NHhVwOMEzht48SIDDKx0b4ZNGXXHqDzSQQt2zwQOwvfL5tB4h0PAhb9AeGCFtq7Pisp5VlLOiidY7VhRWWyfh1jNA6uYzRVoHGStco/QgfU9onLeo6V4LGq08xqTokYnrzEtanTzGtdFjV5eY1bU6Oc1booaJCu1SN9tiUpWN6EyL1FRinBXopLVQrDcl6goiX0oUVEyuyhRUVL7WKKi5PapREVJ7rJERcnuCl8U5Qoylbyuc0Ilo3ZOmOUyt/jwda32MgHlLBQl81dVQny5PWk5rRJeVwlnVcKbKuFtlXCOScE3Qty0rFavpST2LpV3lE0tbcAK2UOV00VqaAlSxeFjzlDp56dumckyZ6L096oiyHWFzC6X5RoKv91rNxQon26oKuGkSjitEl5jgOJVNfOsrO2ZVMHPDCzqjQrcqsBcBe5U4F4FHlRgoQKPKvCkAksVWKVAr6w11xUyu1yWqywc5fUre3zum+pWUSWcoJvq+kyliqzPtQrMVOBGBW5VYK4CdypwrwIPKrBQgUcVeFKBpQqsUqC8ghUyu1yWqyB+z9QvIWqfXp2Cq7pOk4OOLNS0gFwXkFkBuSkgtwVkXkDuCsh9AXkoIIsC8lhAngrIsoCs9kh5HauE9glhvpLnvIqv8ENUHFiyDusCYh8jeVdnvZ/jR+rJjXWF0lMn57pKaJ8Q5iOFD9va7b3Cz2AlKSpiH+vkXZ31eYHfyllSlNfEFUpPJ6VCiHeTZZZppOnFW/r9FjkvdOHEL16YaD7c9uEtGpyAcXrTJsZwgyhGeNcibgXlrx3cn1M4BJsNSM+WMS5/QDMhr035WwTXkBGNbe8b7iJhI2KxB3d14oJ8pEcs5rHjwRXjDvBvBgJ/Gnl4PYr/C8A9N/sdD/C+Np5vxB2fcbjwv/wfUEsBAhQAFAAAAAgAiI7mXL7QHEKrAQAA4QcAABMAAAAAAAAAAAAgALaBAAAAAFtDb250ZW50X1R5cGVzXS54bWxQSwECFAAUAAAACACIjuZctVUwI+4AAABMAgAACwAAAAAAAAAAACAAtoHcAQAAX3JlbHMvLnJlbHNQSwECFAAUAAAACACIjuZctVXUcqEBAABlAwAAEAAAAAAAAAAAACAAtoHzAgAAZG9jUHJvcHMvYXBwLnhtbFBLAQIUABQAAAAIAIiO5lwefdbONgEAAFECAAARAAAAAAAAAAAAIAC2gcIEAABkb2NQcm9wcy9jb3JlLnhtbFBLAQIUABQAAAAIAIiO5lxNQdbSGgEAAHsEAAAaAAAAAAAAAAAAIAC2gScGAAB4bC9fcmVscy93b3JrYm9vay54bWwucmVsc1BLAQIUABQAAAAIAIiO5lziK397uwAAADMBAAAyAAAAAAAAAAAAIAC2gXkHAAB4bC9waXZvdENhY2hlL19yZWxzL3Bpdm90Q2FjaGVEZWZpbml0aW9uMS54bWwucmVsc1BLAQIUABQAAAAIAIiO5lwyPPwvyQMAALUQAAAnAAAAAAAAAAAAIAC2gYQIAAB4bC9waXZvdENhY2hlL3Bpdm90Q2FjaGVEZWZpbml0aW9uMS54bWxQSwECFAAUAAAACACIjuZcpY10bwoBAAB8AgAAJAAAAAAAAAAAACAAtoGSDAAAeGwvcGl2b3RDYWNoZS9waXZvdENhY2hlUmVjb3JkczEueG1sUEsBAhQAFAAAAAgAiI7mXApBDOq9AAAARwEAACkAAAAAAAAAAAAgALaB3g0AAHhsL3Bpdm90VGFibGVzL19yZWxzL3Bpdm90VGFibGUxLnhtbC5yZWxzUEsBAhQAFAAAAAgAiI7mXEfR34UCBgAAGSsAAB4AAAAAAAAAAAAgALaB4g4AAHhsL3Bpdm90VGFibGVzL3Bpdm90VGFibGUxLnhtbFBLAQIUABQAAAAIAIiO5lwhZjcUMQAAANwAAAAnAAAAAAAAAAAAIAC2gSAVAAB4bC9wcmludGVyU2V0dGluZ3MvcHJpbnRlclNldHRpbmdzMS5iaW5QSwECFAAUAAAACACIjuZckOo7rycEAADVEAAADQAAAAAAAAAAACAAtoGWFQAAeGwvc3R5bGVzLnhtbFBLAQIUABQAAAAIAIiO5lzCh9vyUQYAANcbAAATAAAAAAAAAAAAIAC2gegZAAB4bC90aGVtZS90aGVtZTEueG1sUEsBAhQAFAAAAAgAiI7mXD80QqgXAwAAQAcAAA8AAAAAAAAAAAAgALaBaiAAAHhsL3dvcmtib29rLnhtbFBLAQIUABQAAAAIAIiO5lw3i1uJ2AAAANkBAAAjAAAAAAAAAAAAIAC2ga4jAAB4bC93b3Jrc2hlZXRzL19yZWxzL3NoZWV0Mi54bWwucmVsc1BLAQIUABQAAAAIAIiO5lxWq8FTfAMAAC4LAAAYAAAAAAAAAAAAIAC2gcckAAB4bC93b3Jrc2hlZXRzL3NoZWV0MS54bWxQSwECFAAUAAAACACIjuZcyIRyfNEFAAA1GAAAGAAAAAAAAAAAACAAtoF5KAAAeGwvd29ya3NoZWV0cy9zaGVldDIueG1sUEsFBgAAAAARABEA1AQAAIAuAAAAAA== xl/worksheets/sheet1.xml xl/worksheets/sheet3.xml 1 0 WARNING: This report does not display transactions for which accounting has not yet been generated 1 WARNING: The totals and differences will not be correct in cases where the revaluation rate is missing. 2 Operating Unit 3 (All) 4 Ledger 5 Balancing Segment 6 Account Segment 7 Accounting Flexfield 8 Trading Partner 9 Customer Number 10 Invoice/Receipt Number 11 Transaction Type 12 Invoice/Receipt Date 13 Invoice/Receipt Amount 14 Amount Due 15 Currency 16 Exchange Rate 17 Revaluation Rate Type 18 Revaluation Rate 19 Missing Revaluation Rates 20 Open Functional Amount 21 Open Revalued Amount 22 Profit/Loss 23 NA 24 Corporate 25 (blank) 26 NA Total 27 Grand 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 I1 1 data J1 1 data K1 1 data L1 1 data M 2 data M1 1 data N 4 data N1 1 data O 4 data O1 1 data P 4 data P1 1 data Q 4 data Q1 1 data R1 1 data S 4 data S1 1 data T 4 data T1 1 data U 4 data U1 1 data V1 1 parameter A1 1 parameter A10 1 parameter A11 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 D9FFCA67AF9CE51A57DC0B693EDA640E EC: Customer Summary Y SYSADMIN 3 Accounting Flexfield 12 Amount Due 4 Currency 6 Customer Number 13 Exchange Rate 9 Internal Invoice Number 11 Invoice/Receipt Amount 10 Invoice/Receipt Date 7 Invoice/Receipt Number 1 Ledger 19 No Revaluation Rate 14 Open Functional Amount 17 Open Revalued Amount 2 Operating Unit 18 Profit/Loss 16 Revaluation Rate 15 Revaluation Rate Type 5 Trading Partner 8 Transaction Type AR Open Balances Revaluation 25-May-2022 205354.xlsx US UEsDBBQAAAAIAIiO5lwg+fFodwEAAKMFAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbK2UTW7CMBCF9z2F5W2VGFhUVZXAgrbLFqn0AK49EAvHtmxD4fadmB9RRElR2MRKnHnv82ReitG61mQFPihrStrPe5SAEVYqMy/p5/Q1e6QkRG4k19ZASTcQ6GhI7kgx3TgIBMtNKGkVo3tiLIgKah5y68Dgzsz6mke89XPmuFjwObBBr/fAhDURTMxio0GHpHiGGV/qSF7W+HzL4kEHSsbbNxuzknLntBI84j5bGXlik+0scqxM74RKuXCPHJSdt2i2/nbYF75je7ySQCbcxzdeIwhba/Zt/eLL2kV+WeUMp53NlABpxbLGo+XBeeAyVACx1nla85orcyD/AyBir4Gla78zRJJpcwxxoyF09jo5cBJtta64B/kRPQ7mzQmOtdtABNdiXOHnuXEbDroXAXBoJt66gAnycD3BPiFNdeZQCHxULc0/WGL6rnc8mXVo8i1B/td8l7MUisDS0n3Wf89fk+MkvGt8cSHvxxyDzs1o4WDpDzv8AVBLAwQUAAAACACIjuZcsIxkoe4AAABSAgAACwAAAF9yZWxzLy5yZWxzjZJNT8MwDIbv/IrI99XdkBBCS3dBSLtNqPwAk7gfahtHSQbdvydcgErs42j79evHlre7eRrVB4fYi9OwLkpQ7IzY3rUa3uqX1SOomMhZGsWxhhNH2FXqTm1feaSUu2LX+6iyjYsaupT8E2I0HU8UC/HscqWRMFHKYWjRkxmoZdyU5QOGvx5QLU3V3moIe3sPqj75PPu6uTRNb/hZzHFil/6ZgTwndpbtyocMF1Kf91E1hZaTBivmkNMRyfsicwOeQdrcjnR+X5w4kaVEaCTwZaBvxUWi9e1E14+0VPzeZx7xU8LwLjL8wODiDyr1BVBLAwQUAAAACACIjuZcLZF5F6EBAABlAwAAEAAAAGRvY1Byb3BzL2FwcC54bWydk01v2zAMhu/7FYLujdzsA0Mgu+jaDTtsaNC63ZmT6VioLBkSYyT79aPt1vnoYcBufkmaevSS0le71okeY7LB5/JykUmB3oTK+k0uH8tvF5+lSAS+Ahc85nKPSV4V4p3Q6xg6jGQxCe7hUy4bom6lVDINtpAWnPacqUNsgVjGjQp1bQ3eBrNt0ZNaZtknhTtCX2F10c0N5dRx1dP/Nq2CGfjSU7nvmLgQugwErrQtFplWByH0ddc5a4DYgOKnNTGkUJP4ujPotDpOCs3gD2i20dJ+6HIshX4w4PCGDy1qcAm1OgSE/o4wWLoGGxPD9LTq0VCIItk/7OpSit+QcIDNZQ/RgqcBeqib1CRclygWv0J8Tg0iJa3moBi/T6pPhP1QLMcS/jivHf8ceYbUGWtpyWG6q9cQ6Z/sI+AL+QR7fS/ueBHEF3DgDS/LPfbgtqPfR/iH2/E50CLxSr693cx4DvXD+uf02JXhFghfB3Aa5Ak1ELHiqc0TmgM8IfY+uqHNTQN+g9Vr0dvEuDNP05spLj8usvcZb8NRjE08vI5C/AVQSwMEFAAAAAgAiI7mXAa5pCYqAQAAOQIAABEAAABkb2NQcm9wcy9jb3JlLnhtbJ2RzU7DMBCE7zyF5XtiJ20RspJUAtQTlZAIAnGz7G1rEf/INqR9e9ykDUVw4rje2W9nx9Vyrzv0CT4oa2pc5BQjMMJKZbY1fm5X2Q1GIXIjeWcN1PgAAS8bdIUq4ZiwHh69deCjgoASygQmXI13MTpGSBA70DzkSWFSc2O95jGVfkscF+98C6Sk9JpoiFzyyMkRmLmJiE9IKSak+/DdAJCCQAcaTAykyAvyrY3gdfhzYOhcKLWKB5eOOtm9ZEsxNif1PqhJ2Pd93s8GG8l/QV7XD0/DqZkyx7AE4AZVUjDhgUfrSapSXB0PcZ2i3SiQt4fjoxSDpVEHEqUlbLR07rzM7u7bFW5KWpYZXWTloi0pW8wZnb9VKYQf8xdEfdrzb+QZkJjk11c36AtQSwMEFAAAAAgAiI7mXIUMy0X4AAAASQMAABoAAAB4bC9fcmVscy93b3JrYm9vay54bWwucmVsc72Tz07DMAzGXyXynaYtAyG0bJcJaVcYDxAl7h+tTarYA/r2RIWVVqrgUnGJZFv+/NNnZ7v/aBvxhoFq7xRkSQoCnfG2dqWC19PTzQMIYu2sbrxDBT0S7HfbZ2w0xxaq6o5E1HCkoGLuHqUkU2GrKfEdulgpfGg1xzCUstPmrEuUeZreyzDVgLmmOFoF4WgzEKe+i3P/1vZFURs8eHNp0fHCCPnuw5kqRI6iOpTICsYUyaGSJZEY5DJM/s8w+TeMmNl9teZ2TRqOK8MfW4ZQDu/VkWWIzZoQxH0Tz2tczlf8qwl3q86vdED7wiEe/xRjmh5p5OwL7D4BUEsDBBQAAAAIAIiO5lxoX1y+1gMAAJsLAAANAAAAeGwvc3R5bGVzLnhtbL1WS2/jNhC+91cQyqUFKusRy2u7URbxQ+gCabFoUrSHXmiJkonwYVB01m7R/94hKVlSNtl4m6InDYecme+bGY549f7AGXokqqZSpF40Cj1ERC4LKqrU+/U+86ceqjUWBWZSkNQ7ktp7f42+QVe1PjJytyVEI/Ah6tTbar2bB0GdbwnH9UjuiICdUiqONSxVFdQ7RXBRGyPOgjgMJwHHVHjOw5zn5zjhWD3sd34u+Q5ruqGM6qP15SGezz9UQiq8YYD1EI1x3vq2i8/cc5orWctSj8BdIMuS5uRzlLNgFoCna3Ql9jzjuka53AudepedDrmtDwVkcTL2kKO9lAUAKYoR56Pj0QtOLgbHk+eP/4G22znn87oGwyZ0324WD+0uvr+4CEdh+MO3rfSdjRg0qEEspeijRzYr8wchP4nMbAF4Q8kcg0/9J3rEDHSh9ZNLJhXSUF3gFFlMmBN3ZIkZ3ShqlCXmlB2dOjYK2xDNOU6hPA5VE6T5bIzu/wy4fzWgYf2fULRUa5NXytiweYwGNqCTNVEigxVq5PvjDtIs4NY16XInXzOoFD5GcfJVNrVktLB1r5a2xqrapF6WrW/WWeZcbZodKgpyINDk0OO2ij3ktqgOpf0axhupCpgu7YWJTRSnA4GRUhsnilZbK2i5s8Gk1nAdQSoorqTAzIY62Q0coF/Y9nbxW+rpLUyS66ZLhzivAhOqjXSehQXlMJ1nAAdP2M+zcDxfpNkQNmnMCWN3ZuD+Xg5zeSh7EwGGt+k0M4OMCCVoRJcwtzCpfGrV3+/btd5g0ODdjh0/KqlJru2/AiJY3Q2jleDEjMNWtbDhurVp6271855viMrsfGwBBX2CDd8e1Xembb6eKjqUL3NuuUVdpoDmIBOtuSNqBqSbey9jMRP5+bQ3WCDal501P4/Xqnii5twNc/oMxmhifzJvdjusQuR+QW/2em5xXepsNz1N5POVs3PD9BY0U/8aDS/RqfmQ+aGl3p198KgC3g5NA6HNnjJNRddOT21+hHGtGBUPrREA7BlN3bQ8WRk0xaG7zO5eavNwsff8BBDuVEFKvGf6/rSZep38EynonkMZmlMf6aPU1kXqdbI7NbNByEHf1maygYD2iqbeX+vFu9lqncX+NFxM/fElSfxZslj5yXi5WK2yWRiHy797L6k3vKPse8/coGg8rxk8t1TDt8F/1+mgEN3i1oxj19gBAB/An8WT8CaJQj+7DCN/PMFTfzq5TPwsieLVZLxYJ1nSg5/8O/hRGESRe69a/MlcU06g5G3F2jr1tVAqWH6Rh6HjChJ0b+pr9A9QSwMEFAAAAAgAiI7mXNbN2FVwBgAA/hwAABMAAAB4bC90aGVtZS90aGVtZTEueG1s7VlLbxtFHL/zKUZ7b20ndhpHdavYsRto00aJW9TjeD3enXp2ZzUzTuobao9ISIiCuCBx44CASq3EpXyaQBEUqV+B/+zsa+wxSfoQoDaV6n3834/f/Gf28tX7EUNHREjK447XuFj3EIl9PqZx0PFuDwcXNj0kFY7HmPGYdLw5kd7VK+gDdBlvqZBEBIGAWG7hjhcqlWzVatKHx1he5AmJ4d2EiwgruBVBbSzwMQiOWG2tXt+oRZjGHopxBHJvTSbUJ2ioRXpXCul9BvexkukTn4lDLZxYPIZ6PG2kv3Iue0ygI8w6Huga8+Mhua88xLBU8KLj1dM/rwbUtZKNqVXsFdZB+pez5izj6ZrRLIJRoboxaLYv7ZRaDAlTDtJ+v9/rN0qphgT7PvidGVWV3BxsNrqF5CqZuXZo6NVb9eYCS1XL+rL97W6322rnRhnJhsxcN5dZNusbze01m8WQGZbWMkuzu93rbdgshsywbCyzDC61N5oLLIYsZDSeLjPobJdJK4kmnO26OTaBY7OokAod1EtRgqmiCY/VyoqM8D0uBkBhUo8VjZGaJ2SCfaj3Ho5GgmIPJTjmEh7U1+qD+jr8r/8106tmGhm8RXCFMXvmy+Vn2hwkfUET1fE+AsFeheblsx9ePnuCXj57fPLg6cmDn08ePjx58FMmzeLcxXFQ5Xzx3ed/ffMJ+vPJty8efbmCQVYZfvvx019/+WIFJfRiGYXnXz3+/enj519/9sf3j1z02wKPqvRDGhGJbpJjdMAj8M/Ex7aejMQ5WYYhphYLDkG6S3hfhRblzTlmTsIusWN4RwAWOSmvze5Z9h6GYqaoS/n1MLIo9zhnXS7cYbiu1VUiPZzFwQr9YlYlPMD4yKm+h2Mry/1ZAlgMJexIQi8klqn7DMcKByQmCul3fEqIi+8upVZ896gvuOQThe5S1MXUHZghHVlVVXLt0ggSNHfaCFm3IrR3B3U5c7q+Q45sUugQzFwODAmzonkNzxSOnEKHOGLVwN/AKnQaejgXfpWwLxUkPSCMo/6YSOlkuiXA60r+r2MAO3cF7LF5ZJMKRadOqTcw51XSHT7thThK3HbTOKwSfyinULEY7XPlpN/jds/oe0gIjldn/g4lVubPgA+3aWBZVRaLfjMTrqxeI9zu0TmbYGLgBxYFG+kjGv8j7jMKwL+A+633uG+B+CLub8NS6ey33QW0X0n4P8X4HTyL9wn0kQNk30O8XhjeQ3w+Ur4bEL+yw98GsFegHHC+HPfN2BmtHv4nlLFDNWfkhjTzv4SVbDyAp+Yu3cYWu8UkhMt8NbEpA4FTNiS4+piq8DDECewWGmbXG8hcfiBRwiVsI8wLpwKzraawSUi3x61iIwz0WO3xsXm+bu2QC0lmrQvMVjxXt66FnF3l+qV87/3qKhvGvDO72UhNNPhpuVn6D3653EzdzQMM4xOCqQtCvwGHF1okbLUwI2OdjGwQyJNlQvSmMydDPCZZ6nQQHD410twVlZRXmTN1ept7ahgrOtta9mvqPFvuqkqbq5QWWX3N5BXRqiRP9/piA7PY6mcWo+OO126ttTzk46TjTWCHD5dRAgUh9SCLWQAnar4SWameDgCmRMsst1dUbgPOc1Zm2YaPREi1g2VoyiZ9V5w0xeZgInVkrQWBfnOeZP3warasb0KZ/Mu2QAUsJJxMJsRXVg1UHplzmpQkBww+U0QchuNjNGIzcYChLnQxg2djKuGAJkURfQOHkjr66Z2N8nl7Vs//UsLsBWZJiDPQ1u1cNL5hMG1f2GFuq0YWt6lbFR8W78/sU4oRb8wnq8zfYZ/08gRnJ+vjNEU+HJgLjHRrdzwuVMgBupKQ+gMBB4AGbaCO4Mgb3kM24OA+/RXkSP9mvWmkGAiAja86oAESFNY3FQpC9gHL0so8TV4jWwwzqbkoU2tVq2WSmT8iR4QNNehs6OnBQ2EOPzlqGMql4rQf5CU5CvR49F+ftUznv8oQUs5aRsaZ555mdfWoLCrt17fk3Mu4wbpl99da51rGEzgigwNzBRXjU+Gz7EuRXquH/ACwFxVjLYLav2BGHKQB1lyNYFgzD7Na08Ky6Sgb197O7FZO3aX6tz0CVyaJciy0ldrNe+oMfM74Z0G3wm8N3c7oQ5sv9bQeyPLdlklX+u3R+jrIR/egAnbg+8qMKZl9ObkPR6WwEpqPNAAZWdpT7ivob1BLAwQUAAAACACIjuZc/fXAM/IBAAC8AwAADwAAAHhsL3dvcmtib29rLnhtbI2T207jMBCG7/cpvFYlrmjiqIuqqikCAaI3uxWwcIlce9JY9SGynR7efscJge4irbiKx4dv/n9mMr88GE124INytqRsnFMCVjip7Kakv5/uzqeUhMit5NpZKOkRAr1ckG9kvnd+u3ZuS5BgQ0nrGJtZlgVRg+Fh7BqweFI5b3jE0G+y0HjgMtQA0eisyPOLzHBlaU+Y+a8wXFUpATdOtAZs7CEeNI+oP9SqCQPNiK/gDPfbtjkXzjSIWCut4rGDUmLEbLmxzvO1Rt8H9mMg4/IT2ijhXXBVHCMq60V+8svyjLHe8oLMK6XhuS884U3zk5uURlOieYi3UkWQJUUd2u3hY2NCiW+b61ZpPGWTSZHTDGFDM1aeIDeCX3m14+KIdyiRUPFWxydszJAR94tJUVx0j1MXnxXswwkoxeTwoqx0+5IWE5yL4xCxHGux745elIx1EjL92LsHtaljSac568Vlpwm69qdM3YLYzvbVA/mF80KuueZWQCAPsOO67bqK85duLpNfND9TuPBLyRD9F2PFPbLQOo7A+4vi5EXRi3kXgGVRFmQqfNJzEr6pej1oa8avd11Bb3jkax4gNURw/ThowsLUSkpIfw9dnP3Pydn30dWIzUaPIzbPTtIlVf+IwQwCe5k+nfGiKFhyjDeHVi/+AFBLAwQUAAAACACIjuZc3kPKnksDAAB3CQAAGAAAAHhsL3dvcmtzaGVldHMvc2hlZXQxLnhtbJVWTZPbKBC976+gdNhbkJA9tuW1nUrG5UqqNpXUeJOcsYRtaiShAjxfvz4PZCxPzWGZUzei9fo1PBoWH5+amjwIbaRqlwmjWUJEW6pKtodl8vO/zYdZQozlbcVr1Ypl8ixM8nFF/iKLR6XvzVEISwDRmmVytLabp6kpj6LhhqpOtJjZK91wi6E+pKbTglf+p6ZO8yybpA2XbdIjzHUMhtrvZSnWqjw1orU9iBY1tyjAHGVnAtpTFYVXaf6IYgOfK4rrfuaCx8Zv+DWy1MqovaWlatKe2tsqi7R4VWdTxhTacH1/6j4AuENxO1lL++zLTUhTzr8eWqX5rsaWPLExL69Y8rfw8TyBtCKLSmJxnSSIFvtl8onNt4yNxkmKOb99v6R4NKvBJ5bvtqIWpRUVZJQQp46dUvcu8Cs+Zclq0fFWkOdth0p8jFXdv2Jvb0VdI0eeEF5a+SB+IGyZ7JS1qnHzXoAWn/ZavYi2J+FzOYIO9FU0pskivbBE8DAwgf/Gq/KHJjtuxK2qf8vKHkEK8q/Enp9qe6cevwh5ODqqOZ3eYIHdOs+r57UwJaSHmmjuyZSqdsAwpJHuFGGH+FO/DGfcgs7GKHAnjN2cqy9PBgWGxAAaABDpAWADwJgWN8CLBBidAWAHBuPo3xHp88OG3zPKxvH5sVoeAPYMkE9pVoBOZAFO5A4ANjCY0tmsiAaYngFgAwPsYoFuFskAkZ4BbGAwoTc5KooEAFcPADswmBSoKBLAibHXEZwAkdFsGr8P7CLFQYt5TiczLEssiyBGdqXGEc3z+M1kQY7OGQQ9Kd7BIkiSDZrMR5SN4g8VC6J0TlhOXHjFOyCCLNmVLid0OonXJQvCdM6gi1EefzpZkKZzwnIyOhm/Q1pBnGxQJyvoTfa/O5L6Ztc3/jW3fHXurr3PT1ZtZG2Fvro4fI/s+EF84/ogW0NqNHXXPZFM9x3W+7gOvOeOmG/+YXTEo0HgMs8o9LNXCvD9IABvhT11uAk6obfyBdcBqlJaokn7Z8EyqfGAMSXmE3LExIvCTL3upLuX3OvHyvIyRiPuE258ptVCVdUX/2H1N2+6f24/3ZHveNuQzxywpTDkTjzw+uRTLdIhepG+xkkvL6bVH1BLAQIUABQAAAAIAIiO5lwg+fFodwEAAKMFAAATAAAAAAAAAAAAIAC2gQAAAABbQ29udGVudF9UeXBlc10ueG1sUEsBAhQAFAAAAAgAiI7mXLCMZKHuAAAAUgIAAAsAAAAAAAAAAAAgALaBqAEAAF9yZWxzLy5yZWxzUEsBAhQAFAAAAAgAiI7mXC2ReRehAQAAZQMAABAAAAAAAAAAAAAgALaBvwIAAGRvY1Byb3BzL2FwcC54bWxQSwECFAAUAAAACACIjuZcBrmkJioBAAA5AgAAEQAAAAAAAAAAACAAtoGOBAAAZG9jUHJvcHMvY29yZS54bWxQSwECFAAUAAAACACIjuZchQzLRfgAAABJAwAAGgAAAAAAAAAAACAAtoHnBQAAeGwvX3JlbHMvd29ya2Jvb2sueG1sLnJlbHNQSwECFAAUAAAACACIjuZcaF9cvtYDAACbCwAADQAAAAAAAAAAACAAtoEXBwAAeGwvc3R5bGVzLnhtbFBLAQIUABQAAAAIAIiO5lzWzdhVcAYAAP4cAAATAAAAAAAAAAAAIAC2gRgLAAB4bC90aGVtZS90aGVtZTEueG1sUEsBAhQAFAAAAAgAiI7mXP31wDPyAQAAvAMAAA8AAAAAAAAAAAAgALaBuREAAHhsL3dvcmtib29rLnhtbFBLAQIUABQAAAAIAIiO5lzeQ8qeSwMAAHcJAAAYAAAAAAAAAAAAIAC2gdgTAAB4bC93b3Jrc2hlZXRzL3NoZWV0MS54bWxQSwUGAAAAAAkACQA+AgAAWRcAAAAA xl/worksheets/sheet1.xml xl/worksheets/sheet2.xml 1 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 I1 1 data J 3 data J1 1 data K 5 data K1 1 data L 5 data L1 1 data M 5 data M1 1 data N 5 data N1 1 data O1 1 data P 5 data P1 1 data Q 5 data Q1 1 data R 5 data R1 1 data S1 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 B1 6 parameter B10 6 parameter B11 6 parameter B12 6 parameter B2 6 parameter B3 4 parameter B4 6 parameter B5 6 parameter B6 6 parameter B7 6 parameter B9 6 S Site SYSADMIN E83C7EA52609B92F56ED3A8AF8D14795