ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 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）限制的操作单元。 82288223F4703869E053B46B63588994Y with xtb as (select xtbg.* from ( &P_TEMPLATE_SQL_STATEMENT &P_SQL_STATEMENT ) xtbg ), aptb_trx as (select 'Transaction' record_type, xtb.ledger_id, xtb.ledger_name, xtb.ledger_short_name, xtb.ledger_currency_code currency, xtb.source_trx_curr trx_entered_currency, xtb.account, xtb.code_combination_id, to_number(null) gl_balance, to_number(null) other_sources_amount, to_number(null) subledger_manuals_amount, to_number(null) difference, xtb.third_party_name, xtb.third_party_number, xtb.source_entity_id transaction_id, xtb.source_trx_type transaction_type, xtb.source_trx_number transaction_number, aia.description invoice_description, aia.exchange_rate invoice_exchange_rate, aia.exchange_rate_type invoice_exchange_rate_type, aia.exchange_date invoice_exchange_date, to_date(xtb.source_trx_gl_date,'YYYY-MM-DD') gl_date, xtb.user_trx_identifier_value_7 payment_status, xtb.user_trx_identifier_value_9 cancelled_date, xtb.src_acctd_rounded_orig_amt transaction_original_amount, xtb.src_acctd_rounded_rem_amt transaction_remaining_amount, xtb.src_entered_rounded_orig_amt entered_currency_original_amt, xtb.src_entered_rounded_rem_amt entered_currency_remaining_amt from xtb, ap_invoices_all aia, xla_transaction_entities xte where xte.application_id=200 and xte.entity_code='AP_INVOICES' and xte.source_id_int_1=aia.invoice_id and xte.entity_id=xtb.source_entity_id ), aptb_acc as (select 'GL Account' record_type, xtb.ledger_id, xtb.ledger_name, xtb.ledger_short_name, xtb.ledger_currency_code currency, null trx_entered_currency, xtb.account, xtb.code_combination_id, xtb.gl_balance, xtb.non_ap_amount other_sources_amount, xtb.manual_sla_amount subledger_manuals_amount, nvl(xtb.gl_balance,0) - ( nvl(xtb.non_ap_amount,0) + nvl(xtb.manual_sla_amount,0) + nvl(sum(xtb.src_acctd_rounded_rem_amt),0) ) difference, null third_party_name, null third_party_number, null transaction_id, null transaction_type, null transaction_number, null invoice_description, null invoice_exchange_rate, null invoice_exchange_rate_type, null invoice_exchange_date, to_date(null) gl_date, null payment_status, null cancelled_date, to_number(null) transaction_original_amount, to_number(null) transaction_remaining_amount, to_number(null) entered_currency_original_amt, to_number(null) entered_currency_remaining_amt from xtb group by xtb.ledger_id, xtb.ledger_name, xtb.ledger_short_name, xtb.ledger_currency_code, xtb.account, xtb.gl_balance, xtb.non_ap_amount, xtb.manual_sla_amount, xtb.code_combination_id ) -- -- Main Query Starts Here -- select aptb.record_type, aptb.ledger_name, aptb.account account_combination, aptb.third_party_name, aptb.third_party_number, aptb.gl_balance, aptb.other_sources_amount, aptb.subledger_manuals_amount, aptb.transaction_remaining_amount, aptb.entered_currency_remaining_amt, aptb.difference, aptb.transaction_original_amount, aptb.entered_currency_original_amt, &reval_columns aptb.transaction_type, aptb.transaction_number, aptb.invoice_description, aptb.invoice_exchange_rate, aptb.invoice_exchange_rate_type, aptb.invoice_exchange_date, aptb.gl_date, aptb.payment_status, aptb.cancelled_date, &gcc_segment_columns xxen_util.meaning(gcck.gl_account_type,'ACCOUNT_TYPE',0) account_type &lp_init_sql from (select aptb_trx.*, decode(aptb_trx.currency,:p_reval_currency,1,(select gdr.conversion_rate from gl_daily_conversion_types gdct, gl_daily_rates gdr where aptb_trx.currency=gdr.from_currency and gdr.to_currency=:p_reval_currency and :p_reval_conv_date=gdr.conversion_date and gdct.user_conversion_type=:p_reval_conv_type and gdct.conversion_type=gdr.conversion_type)) reval_conv_rate from aptb_trx union all select aptb_acc.*, decode(aptb_acc.currency,:p_reval_currency,1,(select gdr.conversion_rate from gl_daily_conversion_types gdct, gl_daily_rates gdr where aptb_acc.currency=gdr.from_currency and gdr.to_currency=:p_reval_currency and :p_reval_conv_date=gdr.conversion_date and gdct.user_conversion_type=:p_reval_conv_type and gdct.conversion_type=gdr.conversion_type)) reval_conv_rate from aptb_acc ) aptb, gl_code_combinations_kfv gcck where 1=1 and nvl(:p_report_code,'?') = nvl(:p_report_code,'?') and nvl(:p_operating_unit,'?') = nvl(:p_operating_unit,'?') and nvl(:p_relative_period,'?') = nvl(:p_relative_period,'?') and gcck.code_combination_id (+) = aptb.code_combination_id order by aptb.ledger_name, aptb.account nulls last, decode(aptb.record_type,'GL Account',1,2), aptb.third_party_name nulls last, aptb.third_party_number nulls last, aptb.transaction_id nulls last, aptb.gl_date nulls last Added the following columns: entered_currency_remaining_amt trx_entered_currency invoice_description invoice_exchange_rate invoice_exchange_rate_type invoice_exchange_date SQLAP APTBRPT #,##0.00 (:As_of_Date is not null and :As_of_Relative_Period_Close is null ) or (:As_of_Date is null and :As_of_Relative_Period_Close is not null ) AR AP ميزان مراجعة حساب المدفوعات Application: المدفوعات Source: ميزان مراجعة حساب المدفوعات Short Name: APTBRPT DB package: XLA_TB_AP_REPORT_PVT D AP Kreditoren Summen-/Saldenliste Application: Kreditoren Source: Kreditoren Summen-/Saldenliste Short Name: APTBRPT DB package: XLA_TB_AP_REPORT_PVT F AP Balance des fournisseurs Application: Payables Source: Balance des fournisseurs Short Name: APTBRPT DB package: XLA_TB_AP_REPORT_PVT US AP Trial Balance Application: Payables Source: Accounts Payable Trial Balance Short Name: APTBRPT DB package: XLA_TB_AP_REPORT_PVT For scheduling the report to run periodically, use the 'as of relative period close' offset parameter. This is the relative period offset to the current period, so when the current period changes, the period close as of date will also be automatically updated when the report is re-run. Requires custom package XXEN_XLA package to be installed to initialize the hidden parameters removed from the report to simplify scheduling of the report. Please specify a value for either the 'As of Date' or 'As of Relative Period Close' parameters ZHS AP 应付帐款试算表 Application: 应付帐款 Source: 应付帐款试算表 Short Name: APTBRPT DB package: XLA_TB_AP_REPORT_PVT Enginatics R12 only &gcc_segment_columns &lp_init_sql &p_sql_statement &p_template_sql_statement &reval_columns 1=1 :p_account_from :p_account_to :p_acct_balance :p_acct_balance_dsp :p_app_sql_statement :p_as_of_date :p_coa_id :p_custom_param_1 :p_custom_param_2 :p_custom_param_3 :p_definition_code :p_inc_sla_manuals_unposted :p_incl_write_off_dsp :p_incl_write_off_flag :p_include_sla_manuals_unposted :p_journal_source :p_journal_source_dsp :p_operating_unit :p_relative_period :p_report :p_report_code :p_report_definition_dsp :p_report_mode_dsp :p_report_style :p_reval_conv_date :p_reval_conv_type :p_reval_currency :p_security_flag :p_security_id_char_1 :p_security_id_int_1 :p_show_trx_detail_dsp :p_show_trx_detail_flag :p_sql_statement :p_start_date :p_summary_sql_statement :p_third_party_id :p_third_party_name :p_valuation_method 1 -100 :p_report_code Char APTBRPT F Code du rapport US Report Code 2 -90 &p_template_sql_statement select 'select null account, 0 gl_balance, 0 code_combination_id, null balancing_segment_value, null natural_account_segment_value, null cost_center_segment_value, null management_segment_value, null intercompany_segment_value, 0 ledger_id, null ledger_name, null ledger_short_name, null ledger_currency_code, null third_party_name, null third_party_number, null third_party_type_code, null third_party_type, null third_party_site_name, 0 source_trx_application_id, 0 source_entity_id, null source_trx_application_name, null source_trx_type, null source_trx_number, null source_trx_gl_date, null source_trx_curr, 0 src_entered_unrounded_orig_amt, 0 src_entered_unrounded_rem_amt, 0 src_entered_rounded_orig_amt, 0 src_entered_rounded_rem_amt, 0 src_acctd_unrounded_orig_amt, 0 src_acctd_unrounded_rem_amt, 0 src_acctd_rounded_orig_amt, 0 src_acctd_rounded_rem_amt, null user_trx_identifier_name_1, null user_trx_identifier_name_2, null user_trx_identifier_name_3, null user_trx_identifier_name_4, null user_trx_identifier_name_5, null user_trx_identifier_name_6, null user_trx_identifier_name_7, null user_trx_identifier_name_8, null user_trx_identifier_name_9, null user_trx_identifier_name_10, null user_trx_identifier_value_1, null user_trx_identifier_value_2, null user_trx_identifier_value_3, null user_trx_identifier_value_4, null user_trx_identifier_value_5, null user_trx_identifier_value_6, null user_trx_identifier_value_7, null user_trx_identifier_value_8, null user_trx_identifier_value_9, null user_trx_identifier_value_10, 0 non_ap_amount, 0 manual_sla_amount, null balancing_segment_desc, null natural_account_desc, null cost_center_desc, null management_segment_desc, null intercompany_segment_desc from dual' from dual where :run_id is null Char Y F Modèle US Template 3 -80 &lp_init_sql select xxen_xla.xla_tb_ap_report_pvt_init (:p_dummy ,:p_report_code ,:p_operating_unit ,:p_report_definition_dsp ,:p_je_source_name ,:p_as_of_date ,:p_relative_period ,:p_account_from ,:p_account_to ,:p_include_sla_manuals_unposted ) from dual Char Y US Init SQL 4 -70 &reval_columns select case :p_do_reval when 'Y' then 'aptb.currency currency, aptb.trx_entered_currency, :p_reval_currency revaluation_currency, :p_reval_conv_type revaluation_rate_type, nvl2(:p_reval_currency,:p_reval_conv_date,null) revaluation_date, aptb.reval_conv_rate revaluation_rate, aptb.gl_balance * aptb.reval_conv_rate "GL Balance ' || :p_reval_currency || '", aptb.other_sources_amount * aptb.reval_conv_rate "Other Sources Amount ' || :p_reval_currency || '", aptb.subledger_manuals_amount * aptb.reval_conv_rate "Subledger Manuals Amount ' || :p_reval_currency || '", aptb.transaction_remaining_amount * aptb.reval_conv_rate "Trx Remaining Amount ' || :p_reval_currency || '", aptb.difference * aptb.reval_conv_rate "Difference ' || :p_reval_currency || '", aptb.transaction_original_amount * aptb.reval_conv_rate "Trx Original Amount ' || :p_reval_currency || '",' else 'aptb.currency currency, aptb.trx_entered_currency,' end from dual Char select nvl2(:$flex$.Revaluation_Currency,'Y','N') from dual F Colonnes de réévaluation US Revaluation Columns 5 -60 :p_third_party_id LOV Oracle XLA_SRS_TB_THIRD_PARTY Y select tp.pt_id || '#$' || tp.pt_cd id, tp.pt_nm value, lk.meaning description from ((select vendor_id pt_id,vendor_name pt_nm,'S' pt_cd from ap_suppliers) union all (select hca.cust_account_id pt_id,hp.party_name pt_nm,'C' pt_cd from hz_cust_accounts hca,hz_parties hp where hca.party_id=hp.party_id)) tp,xla_lookups lk where tp.pt_cd=lk.lookup_code and lk.lookup_type='XLA_PARTY_TYPE' order by tp.pt_nm select x.id from ( select tp.pt_id || '#$' || tp.pt_cd id, count(*) over () cnt from ( (select vendor_id pt_id,vendor_name pt_nm,'S' pt_cd from ap_suppliers) union all (select hca.cust_account_id pt_id,hp.party_name pt_nm,'C' pt_cd from hz_cust_accounts hca,hz_parties hp where hca.party_id=hp.party_id) ) tp where pt_nm=:$flex$.Third_Party_Name ) x where x.cnt = 1 AR اسم الطرف الآخر D Geschäftspartnername F Nom du tiers US Third Party Id ZHS 第三方名称 6 10 :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)) AR وحدة التشغيل D Betriebseinheit F Unité d'exploitation US Operating Unit ZHS 业务实体 7 20 :p_report_definition_dsp LOV custom Y select xtdv.name value, xtdv.description from xla_tb_definitions_vl xtdv where xtdv.enabled_flag='Y' and ( xtdv.definition_code in ( select xtdjs.definition_code from xla_subledgers xs, xla_tb_defn_je_sources xtdjs where xs.application_id=nvl(fnd_profile.value('XLA_APPL_ID'),fnd_global.resp_appl_id) and xs.je_source_name=xtdjs.je_source_name ) or decode(nvl(fnd_profile.value('XLA_APPL_ID'),fnd_global.resp_appl_id),101,'GL','OTHERS')='GL' ) and ( nvl(fnd_profile.value('XLA_USE_LEDGER_SECURITY'),'N')='N' or ( fnd_profile.value('XLA_USE_LEDGER_SECURITY')='Y' and xtdv.ledger_id in ( select gasa.ledger_id from gl_access_set_assignments gasa where gasa.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') or gasa.access_set_id=fnd_profile.value('XLA_GL_SECONDARY_ACCESS_SET_ID') ) ) ) order by value, description Y AR تعريف التقرير D Auswertungsdefinition F Définition du rapport US Report Definition ZHS 报表定义 8 &gcc_segment_columns select distinct 'gcck.'||lower(fifsv.application_column_name)||' "'||substrb(fifsv.form_left_prompt_,1,xxen_report.max_column_length)||'",'||chr(10)|| 'xxen_util.segment_description(gcck.'||lower(fifsv.application_column_name)||', '''||fifsv.application_column_name||''', gcck.chart_of_accounts_id'|| ( select ', gcck.'||lower(fifs.application_column_name) from fnd_id_flex_segments fifs where fifsv.application_id=fifs.application_id and fifsv.id_flex_code=fifs.id_flex_code and fifsv.id_flex_num=fifs.id_flex_num and fifsv.enabled_flag=fifs.enabled_flag and fifs.flex_value_set_id=(select ffvs.parent_flex_value_set_id from fnd_flex_value_sets ffvs where fifsv.flex_value_set_id=ffvs.flex_value_set_id) )||') "'||substrb(fifsv.form_left_prompt_,1,xxen_report.max_column_length-5)||' desc",' text, min(fifsv.id_flex_num) over (partition by fifsv.application_column_name, fifsv.form_left_prompt) min_id_flex_num, min(fifsv.segment_num) over (partition by fifsv.application_column_name, fifsv.form_left_prompt) min_segment_num from (select xxen_util.init_cap(fifsv.form_left_prompt) form_left_prompt_, fifsv.* from fnd_id_flex_segments_vl fifsv) fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num in (select gl.chart_of_accounts_id from xla_tb_definitions_vl xtdv, gl_ledgers gl where xtdv.name=:p_report_definition_dsp and xtdv.ledger_id=gl.ledger_id) order by min_id_flex_num, min_segment_num F Définition du rapport US Report Definition 9 30 :p_journal_source_dsp LOV custom Y select user_je_source_name value, null description from gl_je_sources a where exists (select 1 from xla_tb_definitions_vl xtdv ,xla_tb_defn_je_sources djs ,xla_subledgers xls where djs.definition_code=xtdv.definition_code and djs.je_source_name=xls.je_source_name and djs.je_source_name=a.je_source_name and xtdv.name=:$flex$.report_definition and xls.application_id=decode(nvl(fnd_profile.value('XLA_JE_SOURCE_ALLOW_OVERRIDE'),'N'),'Y',xls.application_id,nvl(fnd_profile.value('XLA_APPL_ID'),fnd_global.resp_appl_id)) ) order by user_je_source_name SELECT gjs.user_je_source_name FROM gl_je_sources gjs WHERE gjs.je_source_name IN (SELECT xls.je_source_name FROM xla_tb_definitions_vl xtdv, xla_tb_defn_je_sources xjs, xla_subledgers xls WHERE xtdv.definition_code = xjs.definition_code AND xjs.je_source_name = xls.je_source_name AND xtdv.name = :$FLEX$.Report_Definition AND xls.application_id = nvl(fnd_profile.value('XLA_APPL_ID'),fnd_global.RESP_APPL_ID)) AR مصدر اليومية D Belegherkunft F Source du journal US Journal Source ZHS 凭证来源系统 10 40 :p_as_of_date Date select sysdate from dual AR اعتبارًا من تاريخ D Vom F En date du US As of Date ZHS 截止日期 11 50 1=1 aptb.third_party_name=:p_third_party_name LOV custom Y select distinct tp.pt_nm value, lk.meaning description from ((select vendor_id pt_id,vendor_name pt_nm,'S' pt_cd from ap_suppliers) union all (select hca.cust_account_id pt_id,hp.party_name pt_nm,'C' pt_cd from hz_cust_accounts hca,hz_parties hp where hca.party_id=hp.party_id) ) tp, xla_lookups lk where tp.pt_cd=lk.lookup_code and lk.lookup_type='XLA_PARTY_TYPE' order by tp.pt_nm US Third Party Name 12 60 :p_incl_write_off_flag LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description N Y AR تضمين المحذوفات D Mit aufgelösten Rückstellungen F Inclure les radiations US Include Write Offs ZHS 包括注销 13 70 :p_account_from LOV custom Y Y select gcck.concatenated_segments value, xxen_util.segments_description(gcck.code_combination_id) description from gl_code_combinations_kfv gcck where gcck.chart_of_accounts_id = (select gl.chart_of_accounts_id from xla_tb_definitions_vl xtdv, gl_ledgers gl where xtdv.name = :$flex$.report_definition and gl.ledger_id = xtdv.ledger_id ) and gcck.gl_account_type = 'L' and gcck.detail_posting_allowed = 'Y' and gcck.enabled_flag = 'Y' and gcck.summary_flag = 'N' order by gcck.concatenated_segments AR حساب من D Von Konto F Compte de créditeurs De US Payables Account From ZHS 帐户自 14 80 :p_account_to LOV custom Y Y select gcck.concatenated_segments value, xxen_util.segments_description(gcck.code_combination_id) description from gl_code_combinations_kfv gcck where gcck.chart_of_accounts_id = (select gl.chart_of_accounts_id from xla_tb_definitions_vl xtdv, gl_ledgers gl where xtdv.name = :$flex$.report_definition and gl.ledger_id = xtdv.ledger_id ) and gcck.gl_account_type = 'L' and gcck.detail_posting_allowed = 'Y' and gcck.enabled_flag = 'Y' and gcck.summary_flag = 'N' order by gcck.concatenated_segments :$flex$.Payables_Account_From AR حساب إلى D Bis Konto F Compte de dettes à US Payables Account To ZHS 帐户至 15 90 :p_include_sla_manuals_unposted LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y Y F Inclure les manuels d'ALS/autres sources US Include SLA Manuals/Other Sources 16 100 :p_reval_currency LOV custom Y select distinct fcv.currency_code value, fcv.description from fnd_currencies_vl fcv, gl_daily_rates gdr where fcv.currency_code=gdr.to_currency and fcv.enabled_flag='Y' and gdr.from_currency in ( select gl.currency_code from gl_ledgers gl where gl.ledger_id in (select xtdv.ledger_id from xla_tb_definitions_vl xtdv where xtdv.name=:$flex$.Report_Definition) ) and gdr.conversion_date>=sysdate-365 order by 1 F Monnaie de réévaluation US Revaluation Currency 17 110 :p_reval_conv_type LOV custom Y select distinct gdct.user_conversion_type value, gdct.description||' ('||count(*) over (partition by gdr.conversion_type)||')' description from gl_daily_conversion_types gdct, gl_daily_rates gdr where gdr.from_currency in ( select gl.currency_code from gl_ledgers gl where gl.ledger_id in (select xtdv.ledger_id from xla_tb_definitions_vl xtdv where xtdv.name=:$flex$.Report_Definition) ) and gdr.to_currency=:$flex$.revaluation_currency and gdr.conversion_date>=sysdate-365 and gdct.conversion_type=gdr.conversion_type order by 1 F Taux de réévaluation Type US Revaluation Rate Type 18 120 :p_reval_conv_date Date sysdate F Date de réévaluation US Revaluation Date 19 130 :p_relative_period LOV custom Y select distinct to_char(x.relative_period) value, 'Current Period' || decode(x.relative_period,0,null,' ' || to_char(x.relative_period) || ' ' || x.period_type) || ' (' || x.period_name || ')' description from ( select 1-rank() over (partition by gl.name order by ((glp.period_year * 100000) + glp.period_num) desc) relative_period, glp.period_name, glp.period_type from gl_ledgers gl ,gl_periods glp ,gl_periods glpc where gl.ledger_id = (select xtdv.ledger_id from xla_tb_definitions_vl xtdv where xtdv.name = :$flex$.report_definition) and gl.period_set_name=glp.period_set_name and gl.accounted_period_type=glp.period_type and glp.adjustment_period_flag='N' and gl.period_set_name=glpc.period_set_name and gl.accounted_period_type=glpc.period_type and glpc.adjustment_period_flag='N' and trunc(sysdate-1) between glpc.start_date and glpc.end_date and glp.start_date <= glpc.start_date ) x order by x.relative_period desc F A partir de la clôture de la période relative As of Period Close based on the Period Offset relative to the current period. Useful when scheduling the request to be run periodically, the as of date will update automatically relative to the current period. US As of Relative Period Close As of Period Close based on the Period Offset relative to the current period. Useful when scheduling the request to be run periodically, the as of date will update automatically relative to the current period. :$FLEX$.Report_Definition Report Definition Journal Source :$flex$.Payables_Account_From Payables Account From Payables Account To :$flex$.Report_Definition Report Definition Revaluation Currency :$flex$.Report_Definition Report Definition Revaluation Rate Type :$flex$.Revaluation_Currency Revaluation Currency Revaluation Columns :$flex$.Third_Party_Name Third Party Name Third Party Id :$flex$.report_definition Report Definition As of Relative Period Close :$flex$.report_definition Report Definition Journal Source :$flex$.report_definition Report Definition Payables Account From :$flex$.report_definition Report Definition Payables Account To :$flex$.revaluation_currency Revaluation Currency Revaluation Rate Type 88749F5FF522DD7C75264B8C19F97BA8 Pivot: Default Template Y Summary by Ledger, Account, Third Party with Drilldown to Transaction Details SYSADMIN -2.0003 ACCOUNT 3 ACCOUNT_COMBINATION 28 ACCOUNT_TYPE 22 Account 23 Account desc 17 CANCELLED_DATE 6 CURRENCY 18 Company 19 Company desc 11 DIFFERENCE 20 Department 21 Department desc 7 GL_BALANCE 15 GL_DATE 2 LEDGER_NAME 8 OTHER_SOURCES_AMOUNT 16 PAYMENT_STATUS 26 Product 27 Product desc 1 RECORD_TYPE 9 SUBLEDGER_MANUALS_AMOUNT 24 Sub-Account 25 Sub-Account desc 4 THIRD_PARTY_NAME 5 THIRD_PARTY_NUMBER 13 TRANSACTION_NUMBER 14 TRANSACTION_ORIGINAL_AMOUNT 10 TRANSACTION_REMAINING_AMOUNT 12 TRANSACTION_TYPE ACCOUNT ROW 2 ACCOUNT_COMBINATION ROW 2 DIFFERENCE VALUE 5 SUM GL_BALANCE VALUE 1 SUM LEDGER_NAME ROW 1 OTHER_SOURCES_AMOUNT VALUE 2 SUM SUBLEDGER_MANUALS_AMOUNT VALUE 3 SUM THIRD_PARTY_NAME ROW 3 TRANSACTION_REMAINING_AMOUNT VALUE 4 SUM S Site 88749F5FF522DD7C75264B8C19F97BA8