ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE7F79D2E0530100007F1FF2 AR Account Number Y Y select hca.account_number value, hp.party_name||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name US 8E2FF36EDE8679D2E0530100007F1FF2 AR Customer Name Y select hp.party_name value, hca.account_number||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name US 8E2FF36EDEA579D2E0530100007F1FF2 AR Receipt Method Y select arm.name value, ifpct.payment_channel_name description from ar_receipt_methods arm, iby_fndcpt_pmt_chnnls_tl ifpct where arm.payment_channel_code=ifpct.payment_channel_code(+) and ifpct.language(+)=userenv('lang') order by arm.name US F26C78167A214EFBE0530100007F336B GL Balancing Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and (fifsgv.application_id, fifsgv.id_flex_code, fifsgv.id_flex_num, fifsgv.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 fifsgv.flex_value_set_id=ffvv.flex_value_set_id 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 fifsgv.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 fifsgv.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 fifsgv.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') ) ) order by ffvv.flex_value US EAC5823706A70343E05362FB0905E27D select x.ledger, x.ledger_currency, x.operating_unit, x.customer_name, x.customer_number, x.customer_name_alt, x.customer_location, x.customer_address, x.customer_country, x.customer_tax_number, x.collector, x.collector_account, x.collector_site, -- Receipt Main Details x.batch_name, x.batch_source, x.receipt_number, x.receipt_date, x.gl_date, x.receipt_type, x.receipt_method, x.receipt_status, x.receipt_history_status, x.receipt_currency, -- entered amounts x.receipt_amount, x.factor_discount_amount, x.applied_amount, x.on_account_amount, x.unidentified_amount, x.unapplied_amount, x.miscellaneous_amount, x.cash_claims_amount, x.writeoff_amount, x.refund_amount, x.chargeback_amount, x.short_term_debt_amount, x.earned_discount_taken, x.unearned_discount_taken, -- acctd amounts x.acctd_receipt_amount, x.acctd_factor_discount_amount, x.acctd_applied_amount, x.acctd_on_account_amount, x.acctd_unidentified_amount, x.acctd_unapplied_amount, x.acctd_miscellaneous_amount, x.acctd_cash_claims_amount, x.acctd_writeoff_amount, x.acctd_refund_amount, x.acctd_chargeback_amount, x.acctd_short_term_debt_amount, x.acctd_earned_discount_taken, x.acctd_unearned_discount_taken, x.acctd_gain_loss, -- Revaluation Columns &lp_reval_columns -- x.first_apply_date, x.last_apply_date, x.first_applied_in_full_date, x.first_apply_gl_date, x.last_apply_gl_date, x.first_applied_in_full_gl_date, -- Additional Receipt Info x.doc_sequence_name, x.doc_sequence_value, x.receipt_creation_date, x.receipt_created_by, x.receipt_last_updated_date, x.receipt_last_updated_by, x.issue_date, x.deposit_date, x.anticipated_clearing_date, x.misc_payment_source, x.reference_type, x.reference_number, x.customer_receipt_reference, x.tax_code, x.exchange_rate, x.exchange_date, x.exchange_rate_type, x.receipt_comments, x.application_notes, x.reversal_date, x.reversal_category, x.reversal_reason, x.reversal_comments, -- x.bank_name, x.bank_name_alt, x.bank_number, x.bank_branch_name, x.bank_branch_name_alt, x.branch_number, x.bank_branch_country, x.bank_account_name, x.bank_account_name_alt, x.bank_account_number, x.bank_account_currency, x.bank_account_description, -- Debit GL Account Info x.debit_account, x.debit_account_desc, x.balancing_segment, x.balancing_segment_desc, x.account_segment, x.account_segment_desc, x.debit_account_pivot_label, x.bal_seg_pivot_label, x.account_pivot_label, x.cust_name_pivot_label, x.cust_number_pivot_label, x.reporting_entity, x.cash_receipt_id from ( select /*+ push_pred(araa, araa2) */ gl.name ledger, gl.currency_code ledger_currency, haou.name operating_unit, substrb(hp.party_name,1,240) customer_name, hca.account_number customer_number, decode(hp.party_type,'ORGANIZATION',hp.organization_name_phonetic, null) customer_name_alt, hcsua.location customer_location, hz_format_pub.format_address(hps.location_id,null,null,' , ') customer_address, ftv2.territory_short_name customer_country, hp.jgzz_fiscal_code customer_tax_number, nvl(ac2.name,ac.name) collector, ac.name collector_account, ac2.name collector_site, -- Receipt Main Details decode(acrha.status, 'REVERSED', aba.name, aba.name) batch_name, absa.name batch_source, acra.receipt_number, acra.receipt_date, acrha.gl_date, xxen_util.meaning(acra.type,'PAYMENT_CATEGORY_TYPE',222) receipt_type, arm.name receipt_method, case when acra.status in ('REV', 'NSF', 'STOP') and acrha.status <> 'REVERSED' then case :p_mrc_flag when 'R' then (select case when sum(decode(araa2.status,'UNID',araa2.amount_applied,0)) != 0 then xxen_util.meaning('UNID','CHECK_STATUS',222) when sum(decode(araa2.status,'UNAPP',araa2.amount_applied,0)) != 0 then xxen_util.meaning('UNAPP','CHECK_STATUS',222) else xxen_util.meaning('APP','CHECK_STATUS',222) end from ar_receivable_apps_all_mrc_v araa2 where araa2.cash_receipt_id = acra.cash_receipt_id ) else (select case when sum(decode(araa2.status,'UNID',araa2.amount_applied,0)) != 0 then xxen_util.meaning('UNID','CHECK_STATUS',222) when sum(decode(araa2.status,'UNAPP',araa2.amount_applied,0)) != 0 then xxen_util.meaning('UNAPP','CHECK_STATUS',222) else xxen_util.meaning('APP','CHECK_STATUS',222) end from ar_receivable_applications_all araa2 where araa2.cash_receipt_id = acra.cash_receipt_id ) end else xxen_util.meaning(acra.status,'CHECK_STATUS',222) end receipt_status, xxen_util.meaning(acrha.status,'RECEIPT_CREATION_STATUS',222) receipt_history_status, acra.currency_code receipt_currency, decode(acrha.status, 'REVERSED',decode(acrha3.cash_receipt_history_id , acrha.cash_receipt_history_id, 0 , (nvl(acrha3.amount,0))* -1), decode(acrha3.cash_receipt_history_id, acrha.cash_receipt_history_id, (acrha.amount), (acrha.amount -(nvl(acrha3.amount,0)))) ) + decode(acrha.status, 'REVERSED',decode(acrha3.cash_receipt_history_id , acrha.cash_receipt_history_id, 0, (nvl(acrha3.factor_discount_amount,0))* -1), decode(acrha3.cash_receipt_history_id ,acrha.cash_receipt_history_id, nvl(acrha.factor_discount_amount,0), (nvl(acrha.factor_discount_amount,0) -(nvl(acrha3.factor_discount_amount,0)))) ) receipt_amount, decode(acrha.status, 'REVERSED',decode(acrha3.cash_receipt_history_id , acrha.cash_receipt_history_id, 0, (nvl(acrha3.factor_discount_amount,0))* -1), decode(acrha3.cash_receipt_history_id ,acrha.cash_receipt_history_id, nvl(acrha.factor_discount_amount,0), (nvl(acrha.factor_discount_amount,0) -(nvl(acrha3.factor_discount_amount,0)))) ) factor_discount_amount, araa.applied_amount, araa.on_account_amount, araa.unidentified_amount, decode(araa.unapplied_amt,0,to_number(null),araa.unapplied_amt) unapplied_amount, case when acra.type = 'MISC' then decode(acrha.status, 'REVERSED',decode(acrha3.cash_receipt_history_id , acrha.cash_receipt_history_id, 0 , (nvl(acrha3.amount,0))* -1), decode(acrha3.cash_receipt_history_id, acrha.cash_receipt_history_id, (acrha.amount), (acrha.amount -(nvl(acrha3.amount,0)))) ) + decode(acrha.status, 'REVERSED',decode(acrha3.cash_receipt_history_id , acrha.cash_receipt_history_id, 0, (nvl(acrha3.factor_discount_amount,0))* -1), decode(acrha3.cash_receipt_history_id ,acrha.cash_receipt_history_id, nvl(acrha.factor_discount_amount,0), (nvl(acrha.factor_discount_amount,0) -(nvl(acrha3.factor_discount_amount,0)))) ) end miscellaneous_amount, araa.cash_claims_amount, araa.writeoff_amount, araa.refund_amount, araa.chargeback_amount, araa.short_term_debt_amount, araa.earned_discount_taken, araa.unearned_discount_taken, -- acctd decode(acrha.status, 'REVERSED',decode(acrha3.cash_receipt_history_id , acrha.cash_receipt_history_id, 0, (nvl(acrha3.acctd_amount,0))* -1), decode(acrha3.cash_receipt_history_id, acrha.cash_receipt_history_id, (acrha.acctd_amount) , (acrha.acctd_amount -(nvl(acrha3.acctd_amount,0)))) ) + decode(acrha.status, 'REVERSED',decode(acrha3.cash_receipt_history_id , acrha.cash_receipt_history_id,0, (nvl(acrha3.acctd_factor_discount_amount,0))* -1), decode(acrha3.cash_receipt_history_id ,acrha.cash_receipt_history_id, nvl(acrha.acctd_factor_discount_amount,0), (nvl(acrha.acctd_factor_discount_amount,0) -(nvl(acrha3.acctd_factor_discount_amount,0)))) ) acctd_receipt_amount, decode(acrha.status, 'REVERSED',decode(acrha3.cash_receipt_history_id , acrha.cash_receipt_history_id,0, (nvl(acrha3.acctd_factor_discount_amount,0))* -1), decode(acrha3.cash_receipt_history_id ,acrha.cash_receipt_history_id, nvl(acrha.acctd_factor_discount_amount,0), (nvl(acrha.acctd_factor_discount_amount,0) -(nvl(acrha3.acctd_factor_discount_amount,0)))) ) acctd_factor_discount_amount, araa.acctd_applied_amount, araa.acctd_on_account_amount, araa.acctd_unidentified_amt acctd_unidentified_amount, decode(araa.acctd_unapplied_amt,0,to_number(null),araa.acctd_unapplied_amt) acctd_unapplied_amount, case when acra.type = 'MISC' then decode(acrha.status, 'REVERSED',decode(acrha3.cash_receipt_history_id , acrha.cash_receipt_history_id, 0, (nvl(acrha3.acctd_amount,0))* -1), decode(acrha3.cash_receipt_history_id, acrha.cash_receipt_history_id, (acrha.acctd_amount) , (acrha.acctd_amount -(nvl(acrha3.acctd_amount,0)))) ) + decode(acrha.status, 'REVERSED',decode(acrha3.cash_receipt_history_id , acrha.cash_receipt_history_id,0, (nvl(acrha3.acctd_factor_discount_amount,0))* -1), decode(acrha3.cash_receipt_history_id ,acrha.cash_receipt_history_id, nvl(acrha.acctd_factor_discount_amount,0), (nvl(acrha.acctd_factor_discount_amount,0) -(nvl(acrha3.acctd_factor_discount_amount,0)))) ) end acctd_miscellaneous_amount, araa.acctd_cash_claims_amount, araa.acctd_writeoff_amount, araa.acctd_refund_amount, araa.acctd_chargeback_amount, araa.acctd_short_term_debt_amount, araa.acctd_earned_discount_taken, araa.acctd_unearned_discount_taken, araa.acctd_gain_loss, -- (select min(trunc(araa.apply_date)) from ar_receivable_applications_all araa where araa.org_id = acra.org_id and araa.cash_receipt_id = acra.cash_receipt_id and nvl(araa.confirmed_flag,'Y')='Y' and araa.status = 'APP' ) first_apply_date, (select max(trunc(araa.apply_date)) from ar_receivable_applications_all araa, ar_payment_schedules_all apsa where araa.org_id = acra.org_id and araa.cash_receipt_id = acra.cash_receipt_id and araa.applied_payment_schedule_id = apsa.payment_schedule_id and nvl(araa.confirmed_flag,'Y')='Y' and araa.status = 'APP' and decode(sign(araa.amount_applied),-1,-1,1) = decode(sign(apsa.amount_due_original),-1,-1,1) ) last_apply_date, araa2.first_applied_in_full_date, (select min(trunc(araa.gl_date)) from ar_receivable_applications_all araa where araa.org_id = acra.org_id and araa.cash_receipt_id = acra.cash_receipt_id and nvl(araa.confirmed_flag,'Y')='Y' and araa.status = 'APP' ) first_apply_gl_date, (select max(trunc(araa.gl_date)) from ar_receivable_applications_all araa, ar_payment_schedules_all apsa where araa.org_id = acra.org_id and araa.cash_receipt_id = acra.cash_receipt_id and araa.applied_payment_schedule_id = apsa.payment_schedule_id and nvl(araa.confirmed_flag,'Y')='Y' and araa.status = 'APP' and decode(sign(araa.amount_applied),-1,-1,1) = decode(sign(apsa.amount_due_original),-1,-1,1) ) last_apply_gl_date, araa2.first_applied_in_full_gl_date, -- Additional Receipt Info acra.reversal_date, xxen_util.meaning(acra.reversal_category,'REVERSAL_CATEGORY_TYPE',222) reversal_category, xxen_util.meaning(acra.reversal_reason_code,'CKAJST_REASON',222) reversal_reason, acra.reversal_comments, fds.name doc_sequence_name, acra.doc_sequence_value doc_sequence_value, acra.creation_date receipt_creation_date, xxen_util.user_name(acra.created_by) receipt_created_by, acra.last_update_date receipt_last_updated_date, xxen_util.user_name(acra.last_updated_by) receipt_last_updated_by, acra.issue_date, acra.deposit_date, acra.anticipated_clearing_date, acra.misc_payment_source, xxen_util.meaning(acra.reference_type,'CB_REFERENCE_TYPE',222) reference_type, case when acra.reference_type='REMITTANCE' then (select ab.name from ar_batches_all ab where acra.reference_id=ab.batch_id) when acra.reference_type='RECEIPT' then (select acra.receipt_number from ar_cash_receipts_all acra0 where acra.reference_id=acra0.cash_receipt_id) when acra.reference_type='PAYMENT_BATCH' then (select aisca.checkrun_name from ap_inv_selection_criteria_all aisca where acra.reference_id=aisca.checkrun_id) when acra.reference_type='PAYMENT' then (select to_char(aca.check_number) from ap_checks_all aca where acra.reference_id=aca.check_id) when acra.reference_type='CREDIT_MEMO' then (select rcta.trx_number from ra_customer_trx_all rcta where acra.reference_id=rcta.customer_trx_id) end reference_number, acra.customer_receipt_reference customer_receipt_reference, avta.tax_code, acra.exchange_rate, acra.exchange_date, acra.exchange_rate_type, acra.comments receipt_comments, acra.application_notes, cbbv.bank_name, cbbv.bank_name_alt, cbbv.bank_number, cbbv.bank_branch_name, cbbv.bank_branch_name_alt, cbbv.branch_number, ftv.territory_short_name bank_branch_country, cba.bank_account_name, cba.bank_account_name_alt, cba.masked_account_num bank_account_number, cba.currency_code bank_account_currency, cba.description bank_account_description, -- Debit GL Account Info nvl2(gcc.code_combination_id,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'ALL', 'Y', 'VALUE'),null) debit_account, nvl2(gcc.code_combination_id,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'ALL', 'Y', 'DESCRIPTION'),null) debit_account_desc, nvl2(gcc.code_combination_id,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE'),null) balancing_segment, nvl2(gcc.code_combination_id,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'GL_BALANCING', 'Y', 'DESCRIPTION'),null) balancing_segment_desc, nvl2(gcc.code_combination_id,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'GL_ACCOUNT', 'Y', 'VALUE'),null) account_segment, nvl2(gcc.code_combination_id,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'GL_ACCOUNT', 'Y', 'DESCRIPTION'),null) account_segment_desc, nvl2(gcc.code_combination_id,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'ALL', 'Y', 'VALUE') || ' - ' || fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'ALL', 'Y', 'DESCRIPTION'),null) debit_account_pivot_label, nvl2(gcc.code_combination_id,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE') || ' - ' || fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'GL_BALANCING', 'Y', 'DESCRIPTION'),null) bal_seg_pivot_label, nvl2(gcc.code_combination_id,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'GL_ACCOUNT', 'Y', 'VALUE') || ' - ' || fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'GL_ACCOUNT', 'Y', 'DESCRIPTION'),null) account_pivot_label, hp.party_name || ' - ' || hca.account_number cust_name_pivot_label, hca.account_number || ' - ' || hp.party_name cust_number_pivot_label, decode(:reporting_level,1000,gl.name,3000,haou.name,null) reporting_entity, acra.cash_receipt_id, decode(gl.currency_code,:p_reval_currency,1,(select gdr.conversion_rate from gl_daily_conversion_types gdct, gl_daily_rates gdr where gl.currency_code=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 (select araa.org_id, araa.cash_receipt_id, -- sum(case araa.status when 'APP' then nvl(araa.amount_applied_from,araa.amount_applied) when 'ACTIVITY' then decode(araa.receivables_trx_id,-16,araa.amount_applied,null) else null end ) applied_amount, sum(case araa.status when 'APP' then araa.earned_discount_taken when 'ACTIVITY' then decode(araa.receivables_trx_id,-16,araa.earned_discount_taken,null) else null end ) earned_discount_taken, sum(case araa.status when 'APP' then araa.unearned_discount_taken when 'ACTIVITY' then decode(araa.receivables_trx_id,-16,araa.unearned_discount_taken,null) else null end ) unearned_discount_taken, sum(case araa.status when 'ACC' then araa.amount_applied when 'OTHER ACC' then decode(araa.applied_payment_schedule_id,-7,araa.amount_applied,null) else null end ) on_account_amount, sum(case araa.status when 'UNID' then araa.amount_applied else null end ) unidentified_amount, sum(case araa.status when 'UNAPP' then araa.amount_applied else null end ) unapplied_amt, sum(case araa.status when 'OTHER ACC' then decode(araa.applied_payment_schedule_id,-4,araa.amount_applied,null) else null end ) cash_claims_amount, sum(case araa.status when 'ACTIVITY' then decode(araa.applied_payment_schedule_id,-3,araa.amount_applied,null) else null end ) writeoff_amount, sum(case araa.status when 'ACTIVITY' then decode(araa.applied_payment_schedule_id,-8,araa.amount_applied,null) else null end ) refund_amount, sum(case araa.status when 'ACTIVITY' then decode(araa.applied_payment_schedule_id,-5,araa.amount_applied,null) else null end ) chargeback_amount, sum(case araa.status when 'ACTIVITY' then decode(araa.applied_payment_schedule_id,-2,araa.amount_applied,null) else null end ) short_term_debt_amount, -- acctd sum(case araa.status when 'APP' then araa.acctd_amount_applied_from when 'ACTIVITY' then decode(araa.receivables_trx_id,-16,araa.acctd_amount_applied_from,null) else null end ) acctd_applied_amount, sum(case araa.status when 'APP' then araa.acctd_earned_discount_taken when 'ACTIVITY' then decode(araa.receivables_trx_id,-16,araa.acctd_earned_discount_taken,null) else null end ) acctd_earned_discount_taken, sum(case araa.status when 'APP' then araa.acctd_unearned_discount_taken when 'ACTIVITY' then decode(araa.receivables_trx_id,-16,araa.acctd_unearned_discount_taken,null) else null end ) acctd_unearned_discount_taken, sum(case araa.status when 'ACC' then araa.acctd_amount_applied_from when 'OTHER ACC' then decode(araa.applied_payment_schedule_id,-7,araa.acctd_amount_applied_from,null) else null end ) acctd_on_account_amount, sum(case araa.status when 'UNID' then araa.acctd_amount_applied_from else null end ) acctd_unidentified_amt, sum(case araa.status when 'UNAPP' then araa.acctd_amount_applied_from else null end ) acctd_unapplied_amt, sum(case araa.status when 'OTHER ACC' then decode(araa.applied_payment_schedule_id,-4,araa.acctd_amount_applied_from,null) else null end ) acctd_cash_claims_amount, sum(case araa.status when 'ACTIVITY' then decode(araa.applied_payment_schedule_id,-3,araa.acctd_amount_applied_from,null) else null end ) acctd_writeoff_amount, sum(case araa.status when 'ACTIVITY' then decode(araa.applied_payment_schedule_id,-8,araa.acctd_amount_applied_from,null) else null end ) acctd_refund_amount, sum(case araa.status when 'ACTIVITY' then decode(araa.applied_payment_schedule_id,-5,araa.acctd_amount_applied_from,null) else null end ) acctd_chargeback_amount, sum(case araa.status when 'ACTIVITY' then decode(araa.applied_payment_schedule_id,-2,araa.acctd_amount_applied_from,null) else null end ) acctd_short_term_debt_amount, sum(case araa.status when 'APP' then nvl(araa.acctd_amount_applied_from - araa.acctd_amount_applied_to,0) when 'ACTIVITY' then decode(araa.receivables_trx_id,-16,nvl(araa.acctd_amount_applied_from - araa.acctd_amount_applied_to,0),null) else null end ) acctd_gain_loss from ar_receivable_applications_all araa where nvl(araa.confirmed_flag,'Y')='Y' and 3=3 group by araa.org_id, araa.cash_receipt_id ) araa, (select araa.org_id, araa.cash_receipt_id, min(araa.apply_date) first_applied_in_full_date, min(araa.gl_date) first_applied_in_full_gl_date from (select araa.org_id, araa.cash_receipt_id, trunc(araa.apply_date) apply_date, trunc(araa.gl_date) gl_date, case when sum(araa.amount_applied) over (partition by araa.org_id,araa.cash_receipt_id order by araa.apply_date,araa.receivable_application_id) >= acrha.amount then 'Y' else null end applied_in_full from ar_receivable_applications_all araa, ar_cash_receipt_history_all acrha where araa.org_id = acrha.org_id and araa.cash_receipt_id = acrha.cash_receipt_id and nvl(araa.confirmed_flag,'Y')='Y' and (araa.status = 'APP' or (araa.status = 'ACTIVITY' and araa.receivables_trx_id = -16)) and acrha.first_posted_record_flag = 'Y' ) araa where araa.applied_in_full = 'Y' group by araa.org_id, araa.cash_receipt_id ) araa2, &lp_table_list where acra.org_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) and acra.org_id = araa.org_id (+) and acra.cash_receipt_id = araa.cash_receipt_id (+) and acra.org_id = araa2.org_id (+) and acra.cash_receipt_id = araa2.cash_receipt_id (+) and acra.org_id = haou.organization_id and acra.set_of_books_id = gl.ledger_id and acra.cash_receipt_id = acrha2.cash_receipt_id and acrha2.first_posted_record_flag = 'Y' and acrha2.org_id = aba.org_id(+) and acrha2.batch_id = aba.batch_id(+) and nvl(aba.org_id,-1) = absa.org_id(+) and nvl(aba.batch_source_id,-1) = absa.batch_source_id(+) and acra.doc_sequence_id = fds.doc_sequence_id(+) and acra.vat_tax_id = avta.vat_tax_id(+) and acra.remit_bank_acct_use_id = cbaua.bank_acct_use_id and cba.bank_branch_id = cbbv.branch_party_id and cbbv.country=ftv.territory_code(+) and cbaua.bank_account_id = cba.bank_account_id and acra.receipt_method_id = arm.receipt_method_id and acra.cash_receipt_id = acrha.cash_receipt_id and gcc.code_combination_id (+) = acrha.account_code_combination_id and acra.pay_from_customer = hca.cust_account_id(+) and hca.party_id = hp.party_id(+) and acra.customer_site_use_id=hcsua.site_use_id(+) and hcsua.cust_acct_site_id=hcasa.cust_acct_site_id(+) and hcasa.party_site_id=hps.party_site_id(+) and hps.location_id=hl.location_id(+) and hl.country=ftv2.territory_code(+) and acra.pay_from_customer=hcp.cust_account_id(+) and nvl(hcp.site_use_id(+),-999)=-999 and hcp.collector_id=ac.collector_id(+) and acra.pay_from_customer=hcp2.cust_account_id(+) and acra.customer_site_use_id=hcp2.site_use_id(+) and hcp2.collector_id=ac2.collector_id(+) and acrha.cash_receipt_id = acrha3.cash_receipt_id and (decode(acrha3.cash_receipt_history_id , acrha.cash_receipt_history_id, acrha.acctd_amount +1 , acrha3.acctd_amount) <> acrha.acctd_amount or decode(acrha3.cash_receipt_history_id , acrha.cash_receipt_history_id, nvl( acrha.acctd_factor_discount_amount,0) + 1 ,nvl(acrha3.acctd_factor_discount_amount,0)) <> nvl( acrha.acctd_factor_discount_amount,0) or acrha.status='REVERSED' ) and nvl(acra.confirmed_flag,'Y') = 'Y' and -- :reporting_level in (1000,3000) and nvl(:p_coa,-1) = nvl(:p_coa,-1) and :p_mrc_flag = :p_mrc_flag and nvl(:p_gl_date_low_h,sysdate) = nvl(:p_gl_date_low_h,sysdate) and nvl(:p_gl_date_high_h,sysdate) = nvl(:p_gl_date_high_h,sysdate) and 1=1 ) x where 2=2 order by x.ledger, x.balancing_segment, x.operating_unit, x.receipt_currency, x.receipt_number Removed incorrect not exists clause for 11i operating unit security Y #,##0.00;[Red]-#,##0.00 US AR Receipt Register Application: Receivables Description: Receivables Receipt Register Provided Templates: Default: Detail - Detail Listing with no Pivot Summarization Pivot: Summary by Receipt Date - Summary by Balancing Segment, Receipt Currency, Receipt Date Pivot: Summary by Receipt Status - Summary by Balancing Segment, Receipt Status Pivot: Summary by Batch - Summary by Balancing Segment, Receipt Currency, Batch Pivot: Summary by Customer Name - Summary by Balancing Segment, Receipt Currency, Customer Pivot: Summary by Debit Account - Summary by Balancing Segment, Account Segment, Debit Account, Receipt Currency Pivot: Summary by GL Date - Summary by Balancing Segment, Receipt Currency, GL Date Source: Receipt Register Short Name: ARRXRCRG/RXARRCRG Enginatics R12 only &lp_reval_columns &lp_table_list 1=1 2=2 3=3 :p_coa :p_gl_date_high_h :p_gl_date_low_h :p_mrc_flag :p_reval_conv_date :p_reval_conv_type :p_reval_currency :reporting_level 1 -40 :p_coa Number select gl.chart_of_accounts_id from gl_ledgers gl where ( (:$flex$.reporting_level = 1000 and gl.name = :$flex$.reporting_context) or (:$flex$.reporting_level = 3000 and gl.ledger_id = (select hou.set_of_books_id from hr_operating_units hou where hou.name = :$flex$.reporting_context)) or (not exists (select null from gl_ledgers gl2 where ((:$flex$.reporting_level = 1000 and gl2.name = :$flex$.reporting_context) or (:$flex$.reporting_level = 3000 and gl2.ledger_id = (select hou2.set_of_books_id from hr_operating_units hou2 where hou2.name = :$flex$.reporting_context)) ) ) and gl.ledger_id = nvl(fnd_profile.value('GL_SET_OF_BKS_ID'),(select asp.set_of_books_id from ar_system_parameters asp where rownum <=1)) ) ) F Plan de comptes Id US Chart of Accounts Id 2 -30 :p_mrc_flag Char select case when (x.ci_rsob_id = x.pf_rsob_id) or (x.ci_rsob_id = -99) then 'P' else 'R' end from (select to_number(nvl(replace(substr(userenv('CLIENT_INFO'),45,10),' '),-99)) ci_rsob_id, to_number(nvl(fnd_profile.value('MRC_REPORTING_SOB_ID'),-1)) pf_rsob_id from dual ) x F Drapeau MRC US MRC Flag 3 &lp_table_list hr_all_organization_units haou, gl_ledgers gl, ar_cash_receipts_all acra, fnd_document_sequences fds, ar_vat_tax_all avta, ce_bank_accounts cba, ce_bank_acct_uses_all cbaua, ce_bank_branches_v cbbv, fnd_territories_vl ftv, ar_receipt_methods arm, ar_cash_receipt_history_all acrha, gl_code_combinations gcc, hz_cust_accounts hca, hz_parties hp, hz_cust_site_uses_all hcsua, hz_cust_acct_sites_all hcasa, hz_party_sites hps, hz_locations hl, fnd_territories_vl ftv2, hz_customer_profiles hcp, ar_collectors ac, hz_customer_profiles hcp2, ar_collectors ac2, ar_batches_all aba, ar_batch_sources_all absa, ar_cash_receipt_history_all acrha2, ar_cash_receipt_history_all acrha3 P F Drapeau MRC US MRC Flag 4 &lp_table_list hr_all_organization_units haou, gl_ledgers gl, ar_cash_receipts_all_mrc_v acra, fnd_document_sequences fds, ar_vat_tax_all avta, ce_bank_accounts cba, ce_bank_acct_uses_all cbaua, ce_bank_branches_v cbbv, fnd_territories_vl ftv, ar_receipt_methods arm, ar_cash_receipt_hist_all_mrc_v acrha, gl_code_combinations gcc, hz_cust_accounts hca, hz_parties hp, hz_cust_site_uses_all hcsua, hz_cust_acct_sites_all hcasa, hz_party_sites hps, hz_locations hl, fnd_territories_vl ftv2, hz_customer_profiles hcp, ar_collectors ac, hz_customer_profiles hcp2, ar_collectors ac2, ar_batches_all_mrc_v aba, ar_batch_sources_all absa, ar_cash_receipt_hist_all_mrc_v acrha2, ar_cash_receipt_hist_all_mrc_v acrha3 R F Drapeau MRC US MRC Flag 5 1=1 acrha.cash_receipt_history_id in (select nvl(max(crhnew.cash_receipt_history_id ), max(decode(incrh.created_from,'RATE ADJUSTMENT TRIGGER', decode(incrh.current_record_flag,'N', decode(incrh.reversal_created_from,null,-100,incrh.cash_receipt_history_id), incrh.cash_receipt_history_id) ,incrh.cash_receipt_history_id ))) from ar_cash_receipt_history_all incrh, ar_cash_receipt_history_all crhnew where incrh.cash_receipt_id = acrha.cash_receipt_id and crhnew.cash_receipt_id(+) = incrh.cash_receipt_id and crhnew.current_record_flag(+) = 'Y' and incrh.gl_date between nvl(:p_gl_date_low_h,to_date('1800/01/01','YYYY/MM/DD')) and nvl(:p_gl_date_high_h,to_date('2147/12/31','YYYY/MM/DD')) and crhnew.gl_date(+) between nvl(:p_gl_date_low_h,to_date('1800/01/01','YYYY/MM/DD')) and nvl(:p_gl_date_high_h,to_date('2147/12/31','YYYY/MM/DD')) ) and acrha3.cash_receipt_history_id = (select nvl(max(incrh2.cash_receipt_history_id),acrha.cash_receipt_history_id) from ar_cash_receipt_history_all incrh2 where incrh2.cash_receipt_id = acrha.cash_receipt_id and incrh2.gl_date < nvl(:p_gl_date_low_h,to_date('1800/01/01','YYYY/MM/DD')) ) P US MRC Flag 6 1=1 acrha.cash_receipt_history_id in (select max(incrh.cash_receipt_history_id) from ar_cash_receipt_hist_all_mrc_v incrh where incrh.cash_receipt_id = acrha.cash_receipt_id and incrh.gl_date between nvl(:p_gl_date_low_h,to_date('1800/01/01','YYYY/MM/DD')) and nvl(:p_gl_date_high_h,to_date('2147/12/31','YYYY/MM/DD')) ) and acrha3.cash_receipt_history_id = (select nvl(max(incrh2.cash_receipt_history_id),acrha.cash_receipt_history_id) from ar_cash_receipt_hist_all_mrc_v incrh2 where incrh2.cash_receipt_id = acrha.cash_receipt_id and incrh2.gl_date < nvl(:p_gl_date_low_h,to_date('1800/01/01','YYYY/MM/DD')) ) R US MRC Flag 7 -20 :p_gl_date_low_h Date select nvl(:$flex$.gl_date_from, ( select gps.start_date from gl_period_statuses gps where gps.period_name=:$flex$.Accounting_Period and gps.set_of_books_id= (select gl.ledger_id from gl_ledgers gl where (:$flex$.reporting_level = 1000 and gl.name = :$flex$.reporting_context) or (:$flex$.reporting_level = 3000 and gl.ledger_id = (select hou.set_of_books_id from hr_operating_units hou where hou.name = :$flex$.reporting_context)) ) and gps.application_id=222 ) ) from dual US GL Date Low Hidden 8 -10 :p_gl_date_high_h Date select nvl(:$flex$.gl_date_to, ( select gps.end_date from gl_period_statuses gps where gps.period_name=:$flex$.Accounting_Period and gps.set_of_books_id= (select gl.ledger_id from gl_ledgers gl where (:$flex$.reporting_level = 1000 and gl.name = :$flex$.reporting_context) or (:$flex$.reporting_level = 3000 and gl.ledger_id = (select hou.set_of_books_id from hr_operating_units hou where hou.name = :$flex$.reporting_context)) ) and gps.application_id=222 ) ) from dual US GL Date High Hidden 9 10 :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 AR مستوى إعداد التقرير مستوى إعداد التقرير D Auswertungsebene Auswertungsebene E Nivel de Informe Nivel de Informe F Niveau de rapport Niveau de reporting I Livello dichiarazione Livello di creazione rapporti JA レポート・レベル レポート・レベル KO 보고 레벨 보고 레벨 PTB Nível do Relatório Nível do Relatório RU Уровень отчетности Уровень отчетности S Rapporteringsnivå Rapporteringsnivå TR Raporlama Düzeyi Raporlama Düzeyi US Reporting Level Reporting Level ZHS 报告层 报告层 10 20 2=2 x.reporting_entity = :reporting_context LOV custom Y select entity_name value, null description from fnd_mo_reporting_entities_v where reporting_level=:$flex$.fnd_mo_reporting_level order by value,description SELECT entity_name FROM FND_MO_REPORTING_ENTITIES_V WHERE reporting_level = :$flex$.fnd_mo_reporting_level and rownum=1 AR سياق إعداد التقرير سياق إعداد التقرير D Auswertungskontext Auswertungskontext E Contexto del Informe Contexto del Informe F Contexte du rapport Contexte de reporting I Contesto dichiarazione Contesto creazione rapporti JA レポート・コンテキスト レポート・コンテキスト KO 보고 컨텍스트 보고 컨텍스트 PTB Contexto do Relatório Contexto do Relatório RU Контекст отчетности Контекст отчетности S Rapporteringssammanhang Rapporteringssammanhang TR Raporlama İçeriği Raporlama İçeriği US Reporting Context Reporting Context ZHS 报告上下文 报告上下文 11 30 1=1 :p_bal_segment_low=:p_bal_segment_low and fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', :p_coa, NULL, gcc.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE') >= :p_bal_segment_low LOV GL Balancing F26C78167A214EFBE0530100007F336B Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and (fifsgv.application_id, fifsgv.id_flex_code, fifsgv.id_flex_num, fifsgv.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 fifsgv.flex_value_set_id=ffvv.flex_value_set_id 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 fifsgv.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 fifsgv.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 fifsgv.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') ) ) order by ffvv.flex_value AR مقطع الشركة من مقطع الشركة من D Von Firmensegment Von Firmensegment E De Segmento de Compañía De Segmento de Compañía F Segment d'équilibrage Bas Segment de société - De I Segmento società - minimo Segmento società - minimo JA 会社セグメント:自 会社セグメント:自 KO 회사 세그먼트 하한 회사 세그먼트 하한 PTB Segmento Empresa (Inferior) Segmento Empresa (Inferior) RU Сегмент компании с Сегмент компании с S Från bolagssegment Från bolagssegment TR Şirket Segmenti Alt Değeri Şirket Segmenti Alt Değeri US Balancing Segment Low Balancing Segment Low ZHS 公司段下限 公司段下限 12 40 1=1 :p_bal_segment_high=:p_bal_segment_high and fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_seg', 'SQLGL', 'GL#', :p_coa, NULL, gcc.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE') <= :p_bal_segment_high LOV GL Balancing F26C78167A214EFBE0530100007F336B Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and (fifsgv.application_id, fifsgv.id_flex_code, fifsgv.id_flex_num, fifsgv.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 fifsgv.flex_value_set_id=ffvv.flex_value_set_id 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 fifsgv.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 fifsgv.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 fifsgv.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') ) ) order by ffvv.flex_value :$flex$.Balancing_Segment_Low AR مقطع الشركة إلى مقطع الشركة إلى D Bis Firmensegment Bis Firmensegment E A Segmento de Compañía A Segmento de Compañía F Segment d'équilibrage Haut Segment de société - A I Segmento società (max) Segmento società (max) JA 会社セグメント:至 会社セグメント:至 KO 회사 세그먼트 상한 회사 세그먼트 상한 PTB Segmento Empresa (Superior) Segmento Empresa (Superior) RU Сегмент компании по Сегмент компании по S Till bolagssegment Till bolagssegment TR Şirket Segmenti Üst Değeri Şirket Segmenti Üst Değeri US Balancing Segment High Balancing Segment High ZHS 公司段上限 公司段上限 13 50 1=1 select ' acrha.gl_date>=to_date(''' || to_char(gps.start_date,'YYYY/MM/DD') || ''',''YYYY/MM/DD'') and acrha.gl_date < to_date(''' || to_char(gps.end_date+1,'YYYY/MM/DD') || ''',''YYYY/MM/DD'')' from gl_period_statuses gps where gps.period_name=:p_period_name and gps.set_of_books_id= (select gl.ledger_id from gl_ledgers gl where (:reporting_level = 1000 and gl.name = :reporting_context) or (:reporting_level = 3000 and gl.ledger_id = (select hou.set_of_books_id from hr_operating_units hou where hou.name = :reporting_context)) ) and gps.application_id=222 LOV custom Y select gps.period_name value, xxen_util.meaning(gps.closing_status,'CLOSING_STATUS',222)||': '||gps.start_date||' - '||gps.end_date description from gl_period_statuses gps where gps.ledger_id= (select gl.ledger_id from gl_ledgers gl where (:$flex$.reporting_level = 1000 and gl.name = :$flex$.reporting_context) or (:$flex$.reporting_level = 3000 and gl.ledger_id = (select hou.set_of_books_id from hr_operating_units hou where hou.name = :$flex$.reporting_context)) ) and gps.start_date<=sysdate and gps.application_id=222 order by gps.start_date desc F Période comptable US Accounting Period 14 3=3 select ' araa.gl_date>=to_date(''' || to_char(gps.start_date,'YYYY/MM/DD') || ''',''YYYY/MM/DD'') and araa.gl_date < to_date(''' || to_char(gps.end_date+1,'YYYY/MM/DD') || ''',''YYYY/MM/DD'')' from gl_period_statuses gps where gps.period_name=:p_period_name and gps.set_of_books_id= (select gl.ledger_id from gl_ledgers gl where (:reporting_level = 1000 and gl.name = :reporting_context) or (:reporting_level = 3000 and gl.ledger_id = (select hou.set_of_books_id from hr_operating_units hou where hou.name = :reporting_context)) ) and gps.application_id=222 US Accounting Period 15 60 1=1 acrha.gl_date>=:p_gl_date_from Date AR تاريخ أ/ع من تاريخ أ/ع من D Von Buchungsdatum Von Buchungsdatum E De Fecha Contable De Fecha Contable F GL appliqué Date du Date GL - Du I Data GL - Da Data GL - Da JA GL記帳日:自 GL記帳日:自 KO GL 일자-부터 GL 일자-부터 PTB Data GL - De Data GL - De RU Дата ГК с Дата ГК с S Från bokf.datum Från bokf.datum TR GL Başlangıç Tarihi GL Başlangıç Tarihi US GL Date From GL Date From ZHS GL 日期自 GL 日期自 16 3=3 araa.gl_date>=:p_gl_date_from US GL Date From 17 70 1=1 acrha.gl_date<:p_gl_date_to+1 Date last_day(:$flex$.Gl_Date_From) AR تاريخ أ/ع إلى تاريخ أ/ع إلى D Bis Buchungsdatum Bis Buchungsdatum E A Fecha Contable A Fecha Contable F Date GL appliquée à Date GL - Au I Data GL - A Data GL - A JA GL記帳日:至 GL記帳日:至 KO GL 일자-까지 GL 일자-까지 PTB Data GL - Até Data GL - Até RU Дата ГК по Дата ГК по S Till bokf.datum Till bokf.datum TR GL Bitiş Tarihi GL Bitiş Tarihi US GL Date To GL Date To ZHS GL 日期至 GL 日期至 18 3=3 araa.gl_date<:p_gl_date_to+1 US GL Date To 19 80 1=1 acra.currency_code=:p_currency_code 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 AR العملة المدخلة العملة المدخلة D Eingabewährung Eingabewährung E Divisa Introducida Divisa Introducida F Devise saisie Devise de saisie I Divisa inserita Divisa inserita JA 入力通貨 入力通貨 KO 입력 통화 입력 통화 PTB Moeda Informada Moeda Informada RU Введенная валюта Введенная валюта S Registrerad valuta Registrerad valuta TR Girilen Para Birimi Girilen Para Birimi US Entered Currency Entered Currency ZHS 输入币种 输入币种 20 90 1=1 upper(hp.party_name) like upper(:p_customer_name) LOV AR Customer Name 8E2FF36EDE8679D2E0530100007F1FF2 Y select hp.party_name value, hca.account_number||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name F Nom du client US Customer Name 21 100 1=1 hp.party_name>=:p_customer_name_low LOV AR Customer Name 8E2FF36EDE8679D2E0530100007F1FF2 Y select hp.party_name value, hca.account_number||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name F Nom du client Low US Customer Name Low 22 110 1=1 hp.party_name<=:p_customer_name_high LOV AR Customer Name 8E2FF36EDE8679D2E0530100007F1FF2 Y select hp.party_name value, hca.account_number||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name :$flex$.Customer_Name_Low F Nom du client High US Customer Name High 23 120 1=1 hca.account_number=:p_account_number LOV AR Account Number 8E2FF36EDE7F79D2E0530100007F1FF2 Y Y select hca.account_number value, hp.party_name||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name F Numéro de compte du client US Customer Account Number 24 130 1=1 hca.account_number>=:p_account_number_low LOV AR Account Number 8E2FF36EDE7F79D2E0530100007F1FF2 Y Y select hca.account_number value, hp.party_name||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name F Numéro de compte client faible US Customer Account Num Low 25 140 1=1 hca.account_number<=:p_account_number_high LOV AR Account Number 8E2FF36EDE7F79D2E0530100007F1FF2 Y Y select hca.account_number value, hp.party_name||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name :$flex$.Customer_Account_Num_Low F Numéro de compte client élevé US Customer Account Num High 26 150 1=1 arm.name=:p_receipt_method LOV AR Receipt Method 8E2FF36EDEA579D2E0530100007F1FF2 Y select arm.name value, ifpct.payment_channel_name description from ar_receipt_methods arm, iby_fndcpt_pmt_chnnls_tl ifpct where arm.payment_channel_code=ifpct.payment_channel_code(+) and ifpct.language(+)=userenv('lang') order by arm.name F Méthode de réception US Receipt Method 27 160 1=1 acra.status=xxen_util.lookup_code(:p_receipt_status,'CHECK_STATUS',222) LOV custom Y select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='CHECK_STATUS' and flvv.view_application_id=222 and flvv.security_group_id=0 order by flvv.meaning F Statut de réception US Receipt Status 28 170 1=1 aba1.name>=:p_batch_name_low LOV Oracle AR_BATCH_NAME Y select b1.name id, b1.name value, null description from ar_batches b1 where b1.batch_id=(select max(b2.batch_id) from ar_batches b2 where b2.name=b1.name) order by b1.name AR اسم مجموعة من اسم مجموعة من D Von Stapel Von Stapel E De Nombre del Lote De Nombre del Lote F Nom du lot Bas Nom de lot - De I Nome batch - minimo Nome batch - minimo JA バッチ名:自 バッチ名:自 KO 뱃치명 하한 뱃치명 하한 PTB Nome do Lote - Inferior Nome do Lote - Inferior RU Имя пакета с Имя пакета с S Från buntnamn Från buntnamn TR İşlem Grubu Adı Alt Değeri İşlem Grubu Adı Alt Değeri US Batch Name Low Batch Name Low ZHS 批名下限 批名下限 29 180 1=1 aba1.name<=:p_batch_name_high LOV Oracle AR_BATCH_NAME Y select b1.name id, b1.name value, null description from ar_batches b1 where b1.batch_id=(select max(b2.batch_id) from ar_batches b2 where b2.name=b1.name) order by b1.name :$flex$.Batch_Name_Low AR اسم مجموعة إلى اسم مجموعة إلى D Bis Stapel Bis Stapel E A Nombre del Lote A Nombre del Lote F Nom du lot Haut Nom de lot - A I Nome batch - massimo Nome batch - massimo JA バッチ名:至 バッチ名:至 KO 뱃치명 상한 뱃치명 상한 PTB Nome do Lote - Superior Nome do Lote - Superior RU Имя пакета по Имя пакета по S Till buntnamn Till buntnamn TR İşlem Grubu Adı Üst Değeri İşlem Grubu Adı Üst Değeri US Batch Name High Batch Name High ZHS 批名上限 批名上限 30 190 1=1 acra.receipt_date>=:p_receipt_date_from Date F Date de réception du US Receipt Date From 31 200 1=1 acra.receipt_date<:p_receipt_date_to+1 Date last_day(:$flex$.Receipt_Date_From) F Date de réception au US Receipt Date To 32 210 1=1 acra.deposit_date>=:p_deposit_date_from Date AR تاريخ الإيداع من تاريخ الإيداع من D Von Anzahlungsdatum Von Anzahlungsdatum E A Fecha de Depósito A Fecha de Depósito F Date de dépôt du Date de remise - Du I Data versamento - Da Data versamento - Da JA 預入日:自 預入日:自 KO 예금 일자 From 예금 일자 From PTB Data do Depósito - De Data do Depósito - De RU Дата депонирования с Дата депонирования с S Från insättningsdatum Från insättningsdatum TR Kaparo Başlangıç Tarihi Kaparo Başlangıç Tarihi US Deposit Date From Deposit Date From ZHS 存款起始日期 存款起始日期 33 220 1=1 acra.deposit_date<:p_deposit_date_to+1 Date last_day(:$flex$.Deposit_Date_From) AR تاريخ الإيداع إلى تاريخ الإيداع إلى D Bis Anzahlungsdatum Bis Anzahlungsdatum E A Fecha de Depósito 2 A Fecha de Depósito F Date du dépôt au Date de remise - Du I Data versamento - A Data versamento - A JA 預入日:至 預入日:至 KO 예금 일자 To 예금 일자 To PTB Data do Depósito - Até Data do Depósito - Até RU Дата депонирования по Дата депонирования по S Till insättningsdatum Till insättningsdatum TR Kaparo Bitiş Tarihi Kaparo Bitiş Tarihi US Deposit Date To Deposit Date To ZHS 存款终止日期 存款终止日期 34 230 1=1 acra.last_update_date>=:p_lud_from Date F Reçu Dernière mise à jour de US Receipt Last Updated From 35 240 1=1 acra.last_update_date<:p_lud_to+1 Date F Reçu Dernière mise à jour au US Receipt Last Updated To 36 250 1=1 acra.receipt_number>=:p_receipt_num_from LOV Oracle AR_RECEIPT_NUMBER Y Y select cr.receipt_number id, cr.receipt_number value, null description from ar_cash_receipts cr where cr.cash_receipt_id in (select max(cr2.cash_receipt_id) from ar_cash_receipts cr2 where cr.receipt_number=cr2.receipt_number) and not exists ( select 'X' from okl_trx_csh_receipt_b oklrct where oklrct.cash_receipt_id=cr.cash_receipt_id and nvl(oklrct.receipt_type,'REG')='FUT' ) order by cr.receipt_number,cr.cash_receipt_id AR رقم إيصال من رقم إيصال من D Von Zahlungs-Nr. Von Zahlungs-Nr. E De Número de Cobro De Número de Cobro F Numéro du récépissé Bas Numéro de règlement - De I Numero incasso - Minimo Numero incasso - Minimo JA 入金番号:自 入金番号:自 KO 수금 번호 하한 수금 번호 하한 PTB Número do Recebimento - Inferior Número do Recebimento - Inferior RU Номер поступления с Номер поступления с S Från betalningsnummer Från betalningsnummer TR Alınan Ödeme Numarası Alt Değeri Alınan Ödeme Numarası Alt Değeri US Receipt Number Low Receipt Number Low ZHS 收款编号下限 收款编号下限 37 260 1=1 acra.receipt_number<=:p_receipt_num_to LOV Oracle AR_RECEIPT_NUMBER Y Y select cr.receipt_number id, cr.receipt_number value, null description from ar_cash_receipts cr where cr.cash_receipt_id in (select max(cr2.cash_receipt_id) from ar_cash_receipts cr2 where cr.receipt_number=cr2.receipt_number) and not exists ( select 'X' from okl_trx_csh_receipt_b oklrct where oklrct.cash_receipt_id=cr.cash_receipt_id and nvl(oklrct.receipt_type,'REG')='FUT' ) order by cr.receipt_number,cr.cash_receipt_id :$flex$.Receipt_Number_Low AR رقم إيصال إلى رقم إيصال إلى D Bis Zahlungs-Nr. Bis Zahlungs-Nr. E A Número de Cobro A Número de Cobro F Numéro de reçu élevé Numéro de règlement - A I Numero incasso - Massimo Numero incasso - Massimo JA 入金番号:至 入金番号:至 KO 수금 번호 상한 수금 번호 상한 PTB Número do Recebimento - Superior Número do Recebimento - Superior RU Номер поступления по Номер поступления по S Till betalningsnummer Till betalningsnummer TR Alınan Ödeme Numrası Üst Değeri Alınan Ödeme Numrası Üst Değeri US Receipt Number High Receipt Number High ZHS 接收编号上限 接收编号上限 38 270 1=1 acra.doc_sequence_id=(select fds.doc_sequence_id from fnd_document_sequences fds where fds.name = :p_doc_seq_name) LOV custom Y select fds.name value, null description from fnd_document_sequences fds, fnd_doc_sequence_assignments fdsa where fdsa.doc_sequence_id = fds.doc_sequence_id and fdsa.set_of_books_id in ( select gl.ledger_id from gl_ledgers gl where (:$flex$.reporting_level = 1000 and gl.name = :$flex$.reporting_context) or (:$flex$.reporting_level = 3000 and gl.ledger_id = (select hou.set_of_books_id from hr_operating_units hou where hou.name = :$flex$.reporting_context)) ) order by fds.name F Nom de la séquence du document US Document Sequence Name 39 280 1=1 acra.doc_sequence_value>=:p_doc_num_low LOV custom select to_char(doc_sequence_value) value, null description from ar_doc_sequence_audit where doc_sequence_id= (select doc_sequence_id from fnd_document_sequences where name = :$flex$.document_sequence_name) order by value,description F Numéro du document Faible US Document Number Low 40 290 1=1 acra.doc_sequence_value<=:p_doc_num_high LOV custom select to_char(doc_sequence_value) value, null description from ar_doc_sequence_audit where doc_sequence_id= (select doc_sequence_id from fnd_document_sequences where name = :$flex$.document_sequence_name) order by value,description :$flex$.Document_Number_Low F Numéro du document Haut US Document Number High 41 300 :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 gsob.currency_code from gl_sets_of_books gsob where ((:$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 gsob.set_of_books_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.reporting_context,hou.name) = 'Y')) ) ) and gdr.conversion_date>=sysdate-20 order by 1 US Revaluation Currency 42 &lp_reval_columns select ' :p_reval_currency revaluation_currency, :p_reval_conv_type revaluation_rate_type, x.reval_conv_rate revaluation_rate, x.acctd_receipt_amount * x.reval_conv_rate "Receipt Amount ' || :p_reval_currency || '", x.acctd_factor_discount_amount * x.reval_conv_rate "Factor Discount Amount ' || :p_reval_currency || '", x.acctd_applied_amount * x.reval_conv_rate "Applied Amount ' || :p_reval_currency || '", x.acctd_on_account_amount * x.reval_conv_rate "On Account Amount ' || :p_reval_currency || '", x.acctd_unidentified_amount * x.reval_conv_rate "Unidentified Amount ' || :p_reval_currency || '", x.acctd_unapplied_amount * x.reval_conv_rate "Unapplied Amount ' || :p_reval_currency || '", x.acctd_miscellaneous_amount * x.reval_conv_rate "Miscellaneous Amount ' || :p_reval_currency || '", x.acctd_cash_claims_amount * x.reval_conv_rate "Cash Claims Amount ' || :p_reval_currency || '", x.acctd_writeoff_amount * x.reval_conv_rate "Writeoff Amount ' || :p_reval_currency || '", x.acctd_refund_amount * x.reval_conv_rate "Refund Amount ' || :p_reval_currency || '", x.acctd_chargeback_amount * x.reval_conv_rate "Chargeback Amount ' || :p_reval_currency || '", x.acctd_short_term_debt_amount * x.reval_conv_rate "Short Term Debt Amount ' || :p_reval_currency || '", x.acctd_earned_discount_taken * x.reval_conv_rate "Earned Discount Taken ' || :p_reval_currency || '", x.acctd_unearned_discount_taken * x.reval_conv_rate "Unearned Discount Taken ' || :p_reval_currency || '", x.acctd_gain_loss * x.reval_conv_rate "Gain Loss ' || :p_reval_currency || '",' from dual US Revaluation Currency 43 310 :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 gsob.currency_code from gl_sets_of_books gsob where ((:$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 gsob.set_of_books_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.reporting_context,hou.name) = 'Y')) ) ) and gdr.to_currency=:$flex$.revaluation_currency and gdr.conversion_date>=sysdate-20 and gdct.conversion_type=gdr.conversion_type order by 1 US Revaluation Rate Type 44 320 :p_reval_conv_date Date sysdate US Revaluation Date :$flex$.Accounting_Period Accounting Period GL Date High Hidden :$flex$.Accounting_Period Accounting Period GL Date Low Hidden :$flex$.Balancing_Segment_Low Balancing Segment Low Balancing Segment High :$flex$.Batch_Name_Low Batch Name Low Batch Name High :$flex$.Customer_Account_Num_Low Customer Account Num Low Customer Account Num High :$flex$.Customer_Name_Low Customer Name Low Customer Name High :$flex$.Deposit_Date_From Deposit Date From Y Deposit Date To :$flex$.Document_Number_Low Document Number Low Document Number High :$flex$.Gl_Date_From GL Date From Y GL Date To :$flex$.Receipt_Date_From Receipt Date From Y Receipt Date To :$flex$.Receipt_Number_Low Receipt Number Low Receipt Number High :$flex$.chart_of_accounts_id Chart of Accounts Id Balancing Segment High :$flex$.chart_of_accounts_id Chart of Accounts Id Balancing Segment Low :$flex$.document_sequence_name Document Sequence Name Document Number High :$flex$.document_sequence_name Document Sequence Name Document Number Low :$flex$.fnd_mo_reporting_level Reporting Level Reporting Context :$flex$.gl_date_from GL Date From Y GL Date Low Hidden :$flex$.gl_date_to GL Date To Y GL Date High Hidden :$flex$.reporting_context Reporting Context Accounting Period :$flex$.reporting_context Reporting Context Chart of Accounts Id :$flex$.reporting_context Reporting Context Document Sequence Name :$flex$.reporting_context Reporting Context GL Date High Hidden :$flex$.reporting_context Reporting Context GL Date Low Hidden :$flex$.reporting_context Reporting Context Revaluation Currency :$flex$.reporting_context Reporting Context Revaluation Rate Type :$flex$.reporting_level Reporting Level Accounting Period :$flex$.reporting_level Reporting Level Chart of Accounts Id :$flex$.reporting_level Reporting Level Document Sequence Name :$flex$.reporting_level Reporting Level GL Date High Hidden :$flex$.reporting_level Reporting Level GL Date Low Hidden :$flex$.reporting_level Reporting Level Revaluation Currency :$flex$.reporting_level Reporting Level Revaluation Rate Type :$flex$.revaluation_currency Revaluation Currency Revaluation Rate Type Default: Detail Y Default Detail Template SYSADMIN 102 ACCOUNT_PIVOT_LABEL 98 ACCOUNT_SEGMENT 99 ACCOUNT_SEGMENT_DESC 42 ACCTD_APPLIED_AMOUNT 47 ACCTD_CASH_CLAIMS_AMOUNT 50 ACCTD_CHARGEBACK_AMOUNT 52 ACCTD_EARNED_DISCOUNT_TAKEN 41 ACCTD_FACTOR_DISCOUNT_AMOUNT 54 ACCTD_GAIN_LOSS 46 ACCTD_MISCELLANEOUS_AMOUNT 43 ACCTD_ON_ACCOUNT_AMOUNT 40 ACCTD_RECEIPT_AMOUNT 49 ACCTD_REFUND_AMOUNT 51 ACCTD_SHORT_TERM_DEBT_AMOUNT 45 ACCTD_UNAPPLIED_AMOUNT -43.0045 ACCTD_UNAPPLIED_AMT 53 ACCTD_UNEARNED_DISCOUNT_TAKEN 44 ACCTD_UNIDENTIFIED_AMOUNT -43.0044 ACCTD_UNIDENTIFIED_AMT 48 ACCTD_WRITEOFF_AMOUNT 70 ANTICIPATED_CLEARING_DATE 80 APPLICATION_NOTES 28 APPLIED_AMOUNT 3 BALANCING_SEGMENT 2 4 BALANCING_SEGMENT_DESC 101 BAL_SEG_PIVOT_LABEL 95 BANK_ACCOUNT_CURRENCY 96 BANK_ACCOUNT_DESCRIPTION 94 BANK_ACCOUNT_NAME 93 BANK_ACCOUNT_NAME_ALT 92 BANK_ACCOUNT_NUMBER 89 BANK_BRANCH_COUNTRY 90 BANK_BRANCH_NAME 91 BANK_BRANCH_NAME_ALT 86 BANK_NAME 87 BANK_NAME_ALT 85 BANK_NUMBER 16 BATCH_NAME 17 BATCH_SOURCE 88 BRANCH_NUMBER 33 CASH_CLAIMS_AMOUNT 106 CASH_RECEIPT_ID 36 CHARGEBACK_AMOUNT 13 COLLECTOR 14 COLLECTOR_ACCOUNT 15 COLLECTOR_SITE 10 CUSTOMER_ADDRESS 11 CUSTOMER_COUNTRY 9 CUSTOMER_LOCATION 6 CUSTOMER_NAME 8 CUSTOMER_NAME_ALT 7 CUSTOMER_NUMBER 74 CUSTOMER_RECEIPT_REFERENCE 12 CUSTOMER_TAX_NUMBER 103 CUST_NAME_PIVOT_LABEL 104 CUST_NUMBER_PIVOT_LABEL 61 DEBIT_ACCOUNT 97 DEBIT_ACCOUNT_DESC 100 DEBIT_ACCOUNT_PIVOT_LABEL 69 DEPOSIT_DATE 62 DOC_SEQUENCE_NAME 63 DOC_SEQUENCE_VALUE 38 EARNED_DISCOUNT_TAKEN 77 EXCHANGE_DATE 76 EXCHANGE_RATE 78 EXCHANGE_RATE_TYPE 27 FACTOR_DISCOUNT_AMOUNT 57 FIRST_APPLIED_IN_FULL_DATE 60 FIRST_APPLIED_IN_FULL_GL_DATE 55 FIRST_APPLY_DATE 58 FIRST_APPLY_GL_DATE 20 GL_DATE 68 ISSUE_DATE 56 LAST_APPLY_DATE 59 LAST_APPLY_GL_DATE 1 LEDGER 1 2 LEDGER_CURRENCY 32 MISCELLANEOUS_AMOUNT 71 MISC_PAYMENT_SOURCE 29 ON_ACCOUNT_AMOUNT 5 OPERATING_UNIT 3 26 RECEIPT_AMOUNT 79 RECEIPT_COMMENTS 65 RECEIPT_CREATED_BY 64 RECEIPT_CREATION_DATE 25 RECEIPT_CURRENCY 19 RECEIPT_DATE 4 24 RECEIPT_HISTORY_STATUS 67 RECEIPT_LAST_UPDATED_BY 66 RECEIPT_LAST_UPDATED_DATE 22 RECEIPT_METHOD 18 RECEIPT_NUMBER 5 23 RECEIPT_STATUS 21 RECEIPT_TYPE 73 REFERENCE_NUMBER 72 REFERENCE_TYPE 35 REFUND_AMOUNT 105 REPORTING_ENTITY 82 REVERSAL_CATEGORY 84 REVERSAL_COMMENTS 81 REVERSAL_DATE 83 REVERSAL_REASON 37 SHORT_TERM_DEBT_AMOUNT 75 TAX_CODE 31 UNAPPLIED_AMOUNT -30.0031 UNAPPLIED_AMT 39 UNEARNED_DISCOUNT_TAKEN 30 UNIDENTIFIED_AMOUNT 34 WRITEOFF_AMOUNT S Site Pivot: Summary by Batch Y Pivot: Summary by Balancing Segment, Receipt Currency, Batch with drilldown to details SYSADMIN 102 ACCOUNT_PIVOT_LABEL 98 ACCOUNT_SEGMENT 99 ACCOUNT_SEGMENT_DESC -26.0031 ACCTD_AMT_APPLIED_FROM_RECEIPT -26.0032 ACCTD_AMT_APPLIED_TO_TRX 38 ACCTD_APPLIED_AMOUNT 43 ACCTD_CASH_CLAIMS_AMOUNT 46 ACCTD_CHARGEBACK_AMOUNT 48 ACCTD_EARNED_DISCOUNT_TAKEN 37 ACCTD_FACTOR_DISCOUNT_AMOUNT 50 ACCTD_GAIN_LOSS 42 ACCTD_MISCELLANEOUS_AMOUNT 39 ACCTD_ON_ACCOUNT_AMOUNT 36 ACCTD_RECEIPT_AMOUNT 45 ACCTD_REFUND_AMOUNT 47 ACCTD_SHORT_TERM_DEBT_AMOUNT -17.0022 ACCTD_TRX_AMOUNT 41 ACCTD_UNAPPLIED_AMOUNT -35.0037 ACCTD_UNAPPLIED_AMT 49 ACCTD_UNEARNED_DISCOUNT_TAKEN 40 ACCTD_UNIDENTIFIED_AMOUNT -35.0036 ACCTD_UNIDENTIFIED_AMT 44 ACCTD_WRITEOFF_AMOUNT -26.0027 AMOUNT_APPLIED_FROM_RECEIPT -26.0028 AMOUNT_APPLIED_TO_TRX 71 ANTICIPATED_CLEARING_DATE 64 APPLICATION_NOTES 24 APPLIED_AMOUNT -17.0018 APPLIED_TO_TRX_NUMBER 7 -17.0024 APPLY_DATE 5 -17.0025 APPLY_GL_DATE 3 BALANCING_SEGMENT 2 4 BALANCING_SEGMENT_DESC 101 BAL_SEG_PIVOT_LABEL 95 BANK_ACCOUNT_CURRENCY 96 BANK_ACCOUNT_DESCRIPTION 92 BANK_ACCOUNT_NAME 93 BANK_ACCOUNT_NAME_ALT 94 BANK_ACCOUNT_NUMBER 91 BANK_BRANCH_COUNTRY 88 BANK_BRANCH_NAME 89 BANK_BRANCH_NAME_ALT 85 BANK_NAME 86 BANK_NAME_ALT 87 BANK_NUMBER 17 BATCH_NAME 4 10 BATCH_SOURCE 90 BRANCH_NUMBER 29 CASH_CLAIMS_AMOUNT 106 CASH_RECEIPT_ID 32 CHARGEBACK_AMOUNT 14 COLLECTOR 15 COLLECTOR_ACCOUNT 16 COLLECTOR_SITE 11 CUSTOMER_ADDRESS 12 CUSTOMER_COUNTRY 9 CUSTOMER_LOCATION 6 CUSTOMER_NAME 8 CUSTOMER_NAME_ALT 7 CUSTOMER_NUMBER 75 CUSTOMER_RECEIPT_REFERENCE 13 CUSTOMER_TAX_NUMBER 103 CUST_NAME_PIVOT_LABEL 104 CUST_NUMBER_PIVOT_LABEL 57 DEBIT_ACCOUNT 97 DEBIT_ACCOUNT_DESC 100 DEBIT_ACCOUNT_PIVOT_LABEL 70 DEPOSIT_DATE 58 DOC_SEQUENCE_NAME 59 DOC_SEQUENCE_VALUE 34 EARNED_DISCOUNT_TAKEN 78 EXCHANGE_DATE 77 EXCHANGE_RATE 79 EXCHANGE_RATE_TYPE 23 FACTOR_DISCOUNT_AMOUNT 53 FIRST_APPLIED_IN_FULL_DATE 56 FIRST_APPLIED_IN_FULL_GL_DATE 51 FIRST_APPLY_DATE 54 FIRST_APPLY_GL_DATE 20 GL_DATE 69 ISSUE_DATE 52 LAST_APPLY_DATE 55 LAST_APPLY_GL_DATE 1 LEDGER 1 2 LEDGER_CURRENCY 28 MISCELLANEOUS_AMOUNT 72 MISC_PAYMENT_SOURCE 25 ON_ACCOUNT_AMOUNT 5 OPERATING_UNIT 22 RECEIPT_AMOUNT 80 RECEIPT_COMMENTS 61 RECEIPT_CREATED_BY 60 RECEIPT_CREATION_DATE 21 RECEIPT_CURRENCY 3 19 RECEIPT_DATE -26.0033 RECEIPT_GAIN_LOSS 66 RECEIPT_HISTORY_STATUS 68 RECEIPT_LAST_UPDATED_BY 67 RECEIPT_LAST_UPDATED_DATE 63 RECEIPT_METHOD 18 RECEIPT_NUMBER 6 65 RECEIPT_STATUS 62 RECEIPT_TYPE 74 REFERENCE_NUMBER 73 REFERENCE_TYPE 31 REFUND_AMOUNT -17.0023 RELATED_CUSTOMER_NUMBER 105 REPORTING_ENTITY 82 REVERSAL_CATEGORY 84 REVERSAL_COMMENTS 81 REVERSAL_DATE 83 REVERSAL_REASON 33 SHORT_TERM_DEBT_AMOUNT 76 TAX_CODE -17.0021 TRX_AMOUNT -17.002 TRX_CURRENCY -17.0019 TRX_DATE 27 UNAPPLIED_AMOUNT -26.0027 UNAPPLIED_AMT 35 UNEARNED_DISCOUNT_TAKEN 26 UNIDENTIFIED_AMOUNT 30 WRITEOFF_AMOUNT ACCOUNT_SEGMENT FILTER 3 ACCTD_AMT_APPLIED_FROM_RECEIPT VALUE 5 SUM ACCTD_AMT_APPLIED_TO_TRX VALUE 6 SUM ACCTD_APPLIED_AMOUNT VALUE 17 SUM ACCTD_CASH_CLAIMS_AMOUNT VALUE 22 SUM ACCTD_CHARGEBACK_AMOUNT VALUE 25 SUM ACCTD_EARNED_DISCOUNT_TAKEN VALUE 27 SUM ACCTD_FACTOR_DISCOUNT_AMOUNT VALUE 16 SUM ACCTD_GAIN_LOSS VALUE 29 SUM ACCTD_MISCELLANEOUS_AMOUNT VALUE 21 SUM ACCTD_ON_ACCOUNT_AMOUNT VALUE 18 SUM ACCTD_RECEIPT_AMOUNT VALUE 15 SUM ACCTD_REFUND_AMOUNT VALUE 24 SUM ACCTD_SHORT_TERM_DEBT_AMOUNT VALUE 26 SUM ACCTD_UNAPPLIED_AMOUNT VALUE 20 SUM ACCTD_UNAPPLIED_AMT VALUE 18 SUM ACCTD_UNEARNED_DISCOUNT_TAKEN VALUE 28 SUM ACCTD_UNIDENTIFIED_AMOUNT VALUE 19 SUM ACCTD_UNIDENTIFIED_AMT VALUE 17 SUM ACCTD_WRITEOFF_AMOUNT VALUE 23 SUM AMOUNT_APPLIED_FROM_RECEIPT VALUE 1 SUM AMOUNT_APPLIED_TO_TRX VALUE 2 SUM APPLIED_AMOUNT VALUE 3 SUM BALANCING_SEGMENT FILTER 2 BAL_SEG_PIVOT_LABEL ROW 1 BATCH_NAME ROW 3 BATCH_SOURCE FILTER 7 CASH_CLAIMS_AMOUNT VALUE 8 SUM CHARGEBACK_AMOUNT VALUE 11 SUM CUSTOMER_NAME FILTER 5 CUSTOMER_NUMBER FILTER 6 EARNED_DISCOUNT_TAKEN VALUE 13 SUM FACTOR_DISCOUNT_AMOUNT VALUE 2 SUM LEDGER FILTER 1 MISCELLANEOUS_AMOUNT VALUE 7 SUM ON_ACCOUNT_AMOUNT VALUE 4 SUM OPERATING_UNIT FILTER 4 RECEIPT_AMOUNT VALUE 1 SUM RECEIPT_CURRENCY ROW 2 RECEIPT_GAIN_LOSS VALUE 7 SUM REFUND_AMOUNT VALUE 10 SUM SHORT_TERM_DEBT_AMOUNT VALUE 12 SUM UNAPPLIED_AMOUNT VALUE 6 SUM UNAPPLIED_AMT VALUE 6 SUM UNEARNED_DISCOUNT_TAKEN VALUE 14 SUM UNIDENTIFIED_AMOUNT VALUE 5 SUM WRITEOFF_AMOUNT VALUE 9 SUM S Site Pivot: Summary by Batch - Accounted Currency Y Pivot: Summary by Balancing Segment, Receipt Currency, Batch with drilldown to details SYSADMIN 102 ACCOUNT_PIVOT_LABEL 98 ACCOUNT_SEGMENT 99 ACCOUNT_SEGMENT_DESC -26.0031 ACCTD_AMT_APPLIED_FROM_RECEIPT -26.0032 ACCTD_AMT_APPLIED_TO_TRX 38 ACCTD_APPLIED_AMOUNT 43 ACCTD_CASH_CLAIMS_AMOUNT 46 ACCTD_CHARGEBACK_AMOUNT 48 ACCTD_EARNED_DISCOUNT_TAKEN 37 ACCTD_FACTOR_DISCOUNT_AMOUNT 50 ACCTD_GAIN_LOSS 42 ACCTD_MISCELLANEOUS_AMOUNT 39 ACCTD_ON_ACCOUNT_AMOUNT 36 ACCTD_RECEIPT_AMOUNT 45 ACCTD_REFUND_AMOUNT 47 ACCTD_SHORT_TERM_DEBT_AMOUNT -17.0022 ACCTD_TRX_AMOUNT 41 ACCTD_UNAPPLIED_AMOUNT -39.0041 ACCTD_UNAPPLIED_AMT 49 ACCTD_UNEARNED_DISCOUNT_TAKEN 40 ACCTD_UNIDENTIFIED_AMOUNT -39.004 ACCTD_UNIDENTIFIED_AMT 44 ACCTD_WRITEOFF_AMOUNT -26.0027 AMOUNT_APPLIED_FROM_RECEIPT -26.0028 AMOUNT_APPLIED_TO_TRX 75 ANTICIPATED_CLEARING_DATE 64 APPLICATION_NOTES 24 APPLIED_AMOUNT -17.0018 APPLIED_TO_TRX_NUMBER 7 -17.0024 APPLY_DATE 5 -17.0025 APPLY_GL_DATE 3 BALANCING_SEGMENT 2 4 BALANCING_SEGMENT_DESC 101 BAL_SEG_PIVOT_LABEL 95 BANK_ACCOUNT_CURRENCY 96 BANK_ACCOUNT_DESCRIPTION 92 BANK_ACCOUNT_NAME 93 BANK_ACCOUNT_NAME_ALT 94 BANK_ACCOUNT_NUMBER 91 BANK_BRANCH_COUNTRY 88 BANK_BRANCH_NAME 89 BANK_BRANCH_NAME_ALT 85 BANK_NAME 86 BANK_NAME_ALT 87 BANK_NUMBER 17 BATCH_NAME 4 10 BATCH_SOURCE 90 BRANCH_NUMBER 29 CASH_CLAIMS_AMOUNT 106 CASH_RECEIPT_ID 32 CHARGEBACK_AMOUNT 14 COLLECTOR 15 COLLECTOR_ACCOUNT 16 COLLECTOR_SITE 11 CUSTOMER_ADDRESS 12 CUSTOMER_COUNTRY 9 CUSTOMER_LOCATION 6 CUSTOMER_NAME 8 CUSTOMER_NAME_ALT 7 CUSTOMER_NUMBER 79 CUSTOMER_RECEIPT_REFERENCE 13 CUSTOMER_TAX_NUMBER 103 CUST_NAME_PIVOT_LABEL 104 CUST_NUMBER_PIVOT_LABEL 57 DEBIT_ACCOUNT 97 DEBIT_ACCOUNT_DESC 100 DEBIT_ACCOUNT_PIVOT_LABEL 74 DEPOSIT_DATE 58 DOC_SEQUENCE_NAME 59 DOC_SEQUENCE_VALUE 34 EARNED_DISCOUNT_TAKEN 82 EXCHANGE_DATE 81 EXCHANGE_RATE 83 EXCHANGE_RATE_TYPE 23 FACTOR_DISCOUNT_AMOUNT 53 FIRST_APPLIED_IN_FULL_DATE 56 FIRST_APPLIED_IN_FULL_GL_DATE 51 FIRST_APPLY_DATE 54 FIRST_APPLY_GL_DATE 20 GL_DATE 73 ISSUE_DATE 52 LAST_APPLY_DATE 55 LAST_APPLY_GL_DATE 1 LEDGER 1 2 LEDGER_CURRENCY 28 MISCELLANEOUS_AMOUNT 76 MISC_PAYMENT_SOURCE 25 ON_ACCOUNT_AMOUNT 5 OPERATING_UNIT 22 RECEIPT_AMOUNT 84 RECEIPT_COMMENTS 61 RECEIPT_CREATED_BY 60 RECEIPT_CREATION_DATE 21 RECEIPT_CURRENCY 3 19 RECEIPT_DATE -26.0033 RECEIPT_GAIN_LOSS 70 RECEIPT_HISTORY_STATUS 72 RECEIPT_LAST_UPDATED_BY 71 RECEIPT_LAST_UPDATED_DATE 63 RECEIPT_METHOD 18 RECEIPT_NUMBER 6 69 RECEIPT_STATUS 62 RECEIPT_TYPE 78 REFERENCE_NUMBER 77 REFERENCE_TYPE 31 REFUND_AMOUNT -17.0023 RELATED_CUSTOMER_NUMBER 105 REPORTING_ENTITY 66 REVERSAL_CATEGORY 68 REVERSAL_COMMENTS 65 REVERSAL_DATE 67 REVERSAL_REASON 33 SHORT_TERM_DEBT_AMOUNT 80 TAX_CODE -17.0021 TRX_AMOUNT -17.002 TRX_CURRENCY -17.0019 TRX_DATE 27 UNAPPLIED_AMOUNT -26.0027 UNAPPLIED_AMT 35 UNEARNED_DISCOUNT_TAKEN 26 UNIDENTIFIED_AMOUNT 30 WRITEOFF_AMOUNT ACCOUNT_SEGMENT FILTER 3 ACCTD_AMT_APPLIED_FROM_RECEIPT VALUE 5 SUM ACCTD_AMT_APPLIED_TO_TRX VALUE 6 SUM ACCTD_APPLIED_AMOUNT VALUE 3 SUM ACCTD_CASH_CLAIMS_AMOUNT VALUE 8 SUM ACCTD_CHARGEBACK_AMOUNT VALUE 11 SUM ACCTD_EARNED_DISCOUNT_TAKEN VALUE 13 SUM ACCTD_FACTOR_DISCOUNT_AMOUNT VALUE 2 SUM ACCTD_GAIN_LOSS VALUE 15 SUM ACCTD_MISCELLANEOUS_AMOUNT VALUE 7 SUM ACCTD_ON_ACCOUNT_AMOUNT VALUE 4 SUM ACCTD_RECEIPT_AMOUNT VALUE 1 SUM ACCTD_REFUND_AMOUNT VALUE 10 SUM ACCTD_SHORT_TERM_DEBT_AMOUNT VALUE 12 SUM ACCTD_UNAPPLIED_AMOUNT VALUE 6 SUM ACCTD_UNAPPLIED_AMT VALUE 6 SUM ACCTD_UNEARNED_DISCOUNT_TAKEN VALUE 14 SUM ACCTD_UNIDENTIFIED_AMOUNT VALUE 5 SUM ACCTD_UNIDENTIFIED_AMT VALUE 5 SUM ACCTD_WRITEOFF_AMOUNT VALUE 9 SUM AMOUNT_APPLIED_FROM_RECEIPT VALUE 1 SUM AMOUNT_APPLIED_TO_TRX VALUE 2 SUM BALANCING_SEGMENT FILTER 2 BAL_SEG_PIVOT_LABEL ROW 1 BATCH_NAME ROW 3 BATCH_SOURCE FILTER 7 CUSTOMER_NAME FILTER 5 CUSTOMER_NUMBER FILTER 6 LEDGER FILTER 1 OPERATING_UNIT FILTER 4 RECEIPT_CURRENCY ROW 2 RECEIPT_GAIN_LOSS VALUE 7 SUM S Site Pivot: Summary by Customer Name Y Pivot: Summary by Balancing Segment, Receipt Currency, Customer with drilldown to details SYSADMIN 102 ACCOUNT_PIVOT_LABEL 98 ACCOUNT_SEGMENT 99 ACCOUNT_SEGMENT_DESC -26.0031 ACCTD_AMT_APPLIED_FROM_RECEIPT -26.0032 ACCTD_AMT_APPLIED_TO_TRX 38 ACCTD_APPLIED_AMOUNT 43 ACCTD_CASH_CLAIMS_AMOUNT 46 ACCTD_CHARGEBACK_AMOUNT 48 ACCTD_EARNED_DISCOUNT_TAKEN 37 ACCTD_FACTOR_DISCOUNT_AMOUNT 50 ACCTD_GAIN_LOSS 42 ACCTD_MISCELLANEOUS_AMOUNT 39 ACCTD_ON_ACCOUNT_AMOUNT 36 ACCTD_RECEIPT_AMOUNT 45 ACCTD_REFUND_AMOUNT 47 ACCTD_SHORT_TERM_DEBT_AMOUNT -17.0022 ACCTD_TRX_AMOUNT 41 ACCTD_UNAPPLIED_AMOUNT -35.0037 ACCTD_UNAPPLIED_AMT 49 ACCTD_UNEARNED_DISCOUNT_TAKEN 40 ACCTD_UNIDENTIFIED_AMOUNT -35.0036 ACCTD_UNIDENTIFIED_AMT 44 ACCTD_WRITEOFF_AMOUNT -26.0027 AMOUNT_APPLIED_FROM_RECEIPT -26.0028 AMOUNT_APPLIED_TO_TRX 71 ANTICIPATED_CLEARING_DATE 64 APPLICATION_NOTES 24 APPLIED_AMOUNT -17.0018 APPLIED_TO_TRX_NUMBER 7 -17.0024 APPLY_DATE 5 -17.0025 APPLY_GL_DATE 3 BALANCING_SEGMENT 2 4 BALANCING_SEGMENT_DESC 101 BAL_SEG_PIVOT_LABEL 95 BANK_ACCOUNT_CURRENCY 96 BANK_ACCOUNT_DESCRIPTION 92 BANK_ACCOUNT_NAME 93 BANK_ACCOUNT_NAME_ALT 94 BANK_ACCOUNT_NUMBER 91 BANK_BRANCH_COUNTRY 88 BANK_BRANCH_NAME 89 BANK_BRANCH_NAME_ALT 85 BANK_NAME 86 BANK_NAME_ALT 87 BANK_NUMBER 17 BATCH_NAME 10 BATCH_SOURCE 90 BRANCH_NUMBER 29 CASH_CLAIMS_AMOUNT 106 CASH_RECEIPT_ID 32 CHARGEBACK_AMOUNT 14 COLLECTOR 15 COLLECTOR_ACCOUNT 16 COLLECTOR_SITE 11 CUSTOMER_ADDRESS 12 CUSTOMER_COUNTRY 9 CUSTOMER_LOCATION 6 CUSTOMER_NAME 4 8 CUSTOMER_NAME_ALT 7 CUSTOMER_NUMBER 75 CUSTOMER_RECEIPT_REFERENCE 13 CUSTOMER_TAX_NUMBER 103 CUST_NAME_PIVOT_LABEL 104 CUST_NUMBER_PIVOT_LABEL 57 DEBIT_ACCOUNT 97 DEBIT_ACCOUNT_DESC 100 DEBIT_ACCOUNT_PIVOT_LABEL 70 DEPOSIT_DATE 58 DOC_SEQUENCE_NAME 59 DOC_SEQUENCE_VALUE 34 EARNED_DISCOUNT_TAKEN 78 EXCHANGE_DATE 77 EXCHANGE_RATE 79 EXCHANGE_RATE_TYPE 23 FACTOR_DISCOUNT_AMOUNT 53 FIRST_APPLIED_IN_FULL_DATE 56 FIRST_APPLIED_IN_FULL_GL_DATE 51 FIRST_APPLY_DATE 54 FIRST_APPLY_GL_DATE 20 GL_DATE 69 ISSUE_DATE 52 LAST_APPLY_DATE 55 LAST_APPLY_GL_DATE 1 LEDGER 1 2 LEDGER_CURRENCY 28 MISCELLANEOUS_AMOUNT 72 MISC_PAYMENT_SOURCE 25 ON_ACCOUNT_AMOUNT 5 OPERATING_UNIT 22 RECEIPT_AMOUNT 80 RECEIPT_COMMENTS 66 RECEIPT_CREATED_BY 65 RECEIPT_CREATION_DATE 21 RECEIPT_CURRENCY 3 19 RECEIPT_DATE -26.0033 RECEIPT_GAIN_LOSS 63 RECEIPT_HISTORY_STATUS 68 RECEIPT_LAST_UPDATED_BY 67 RECEIPT_LAST_UPDATED_DATE 61 RECEIPT_METHOD 18 RECEIPT_NUMBER 6 62 RECEIPT_STATUS 60 RECEIPT_TYPE 74 REFERENCE_NUMBER 73 REFERENCE_TYPE 31 REFUND_AMOUNT -17.0023 RELATED_CUSTOMER_NUMBER 105 REPORTING_ENTITY 82 REVERSAL_CATEGORY 84 REVERSAL_COMMENTS 81 REVERSAL_DATE 83 REVERSAL_REASON 33 SHORT_TERM_DEBT_AMOUNT 76 TAX_CODE -17.0021 TRX_AMOUNT -17.002 TRX_CURRENCY -17.0019 TRX_DATE 27 UNAPPLIED_AMOUNT -26.0027 UNAPPLIED_AMT 35 UNEARNED_DISCOUNT_TAKEN 26 UNIDENTIFIED_AMOUNT 30 WRITEOFF_AMOUNT ACCOUNT_SEGMENT FILTER 3 ACCTD_AMT_APPLIED_FROM_RECEIPT VALUE 5 SUM ACCTD_AMT_APPLIED_TO_TRX VALUE 6 SUM ACCTD_APPLIED_AMOUNT VALUE 17 SUM ACCTD_CASH_CLAIMS_AMOUNT VALUE 22 SUM ACCTD_CHARGEBACK_AMOUNT VALUE 25 SUM ACCTD_EARNED_DISCOUNT_TAKEN VALUE 27 SUM ACCTD_FACTOR_DISCOUNT_AMOUNT VALUE 16 SUM ACCTD_GAIN_LOSS VALUE 29 SUM ACCTD_MISCELLANEOUS_AMOUNT VALUE 21 SUM ACCTD_ON_ACCOUNT_AMOUNT VALUE 18 SUM ACCTD_RECEIPT_AMOUNT VALUE 15 SUM ACCTD_REFUND_AMOUNT VALUE 24 SUM ACCTD_SHORT_TERM_DEBT_AMOUNT VALUE 26 SUM ACCTD_UNAPPLIED_AMOUNT VALUE 20 SUM ACCTD_UNAPPLIED_AMT VALUE 18 SUM ACCTD_UNEARNED_DISCOUNT_TAKEN VALUE 28 SUM ACCTD_UNIDENTIFIED_AMOUNT VALUE 19 SUM ACCTD_UNIDENTIFIED_AMT VALUE 17 SUM ACCTD_WRITEOFF_AMOUNT VALUE 23 SUM AMOUNT_APPLIED_FROM_RECEIPT VALUE 1 SUM AMOUNT_APPLIED_TO_TRX VALUE 2 SUM APPLIED_AMOUNT VALUE 3 SUM BALANCING_SEGMENT FILTER 2 BAL_SEG_PIVOT_LABEL ROW 1 BATCH_SOURCE FILTER 7 CASH_CLAIMS_AMOUNT VALUE 8 SUM CHARGEBACK_AMOUNT VALUE 11 SUM CUSTOMER_NAME FILTER 5 CUSTOMER_NUMBER FILTER 6 CUST_NAME_PIVOT_LABEL ROW 3 EARNED_DISCOUNT_TAKEN VALUE 13 SUM FACTOR_DISCOUNT_AMOUNT VALUE 2 SUM LEDGER FILTER 1 MISCELLANEOUS_AMOUNT VALUE 7 SUM ON_ACCOUNT_AMOUNT VALUE 4 SUM OPERATING_UNIT FILTER 4 RECEIPT_AMOUNT VALUE 1 SUM RECEIPT_CURRENCY ROW 2 RECEIPT_GAIN_LOSS VALUE 7 SUM REFUND_AMOUNT VALUE 10 SUM SHORT_TERM_DEBT_AMOUNT VALUE 12 SUM UNAPPLIED_AMOUNT VALUE 6 SUM UNAPPLIED_AMT VALUE 6 SUM UNEARNED_DISCOUNT_TAKEN VALUE 14 SUM UNIDENTIFIED_AMOUNT VALUE 5 SUM WRITEOFF_AMOUNT VALUE 9 SUM S Site Pivot: Summary by Customer Name - Accounted Currency Y Pivot: Summary by Balancing Segment, Receipt Currency, Customer with drilldown to details SYSADMIN 102 ACCOUNT_PIVOT_LABEL 98 ACCOUNT_SEGMENT 99 ACCOUNT_SEGMENT_DESC -26.0031 ACCTD_AMT_APPLIED_FROM_RECEIPT -26.0032 ACCTD_AMT_APPLIED_TO_TRX 38 ACCTD_APPLIED_AMOUNT 43 ACCTD_CASH_CLAIMS_AMOUNT 46 ACCTD_CHARGEBACK_AMOUNT 48 ACCTD_EARNED_DISCOUNT_TAKEN 37 ACCTD_FACTOR_DISCOUNT_AMOUNT 50 ACCTD_GAIN_LOSS 42 ACCTD_MISCELLANEOUS_AMOUNT 39 ACCTD_ON_ACCOUNT_AMOUNT 36 ACCTD_RECEIPT_AMOUNT 45 ACCTD_REFUND_AMOUNT 47 ACCTD_SHORT_TERM_DEBT_AMOUNT -17.0022 ACCTD_TRX_AMOUNT 41 ACCTD_UNAPPLIED_AMOUNT -39.0041 ACCTD_UNAPPLIED_AMT 49 ACCTD_UNEARNED_DISCOUNT_TAKEN 40 ACCTD_UNIDENTIFIED_AMOUNT -39.004 ACCTD_UNIDENTIFIED_AMT 44 ACCTD_WRITEOFF_AMOUNT -26.0027 AMOUNT_APPLIED_FROM_RECEIPT -26.0028 AMOUNT_APPLIED_TO_TRX 75 ANTICIPATED_CLEARING_DATE 64 APPLICATION_NOTES 24 APPLIED_AMOUNT -17.0018 APPLIED_TO_TRX_NUMBER 7 -17.0024 APPLY_DATE 5 -17.0025 APPLY_GL_DATE 3 BALANCING_SEGMENT 2 4 BALANCING_SEGMENT_DESC 101 BAL_SEG_PIVOT_LABEL 95 BANK_ACCOUNT_CURRENCY 96 BANK_ACCOUNT_DESCRIPTION 92 BANK_ACCOUNT_NAME 93 BANK_ACCOUNT_NAME_ALT 94 BANK_ACCOUNT_NUMBER 91 BANK_BRANCH_COUNTRY 88 BANK_BRANCH_NAME 89 BANK_BRANCH_NAME_ALT 85 BANK_NAME 86 BANK_NAME_ALT 87 BANK_NUMBER 17 BATCH_NAME 10 BATCH_SOURCE 90 BRANCH_NUMBER 29 CASH_CLAIMS_AMOUNT 106 CASH_RECEIPT_ID 32 CHARGEBACK_AMOUNT 14 COLLECTOR 15 COLLECTOR_ACCOUNT 16 COLLECTOR_SITE 11 CUSTOMER_ADDRESS 12 CUSTOMER_COUNTRY 9 CUSTOMER_LOCATION 6 CUSTOMER_NAME 4 8 CUSTOMER_NAME_ALT 7 CUSTOMER_NUMBER 79 CUSTOMER_RECEIPT_REFERENCE 13 CUSTOMER_TAX_NUMBER 103 CUST_NAME_PIVOT_LABEL 104 CUST_NUMBER_PIVOT_LABEL 57 DEBIT_ACCOUNT 97 DEBIT_ACCOUNT_DESC 100 DEBIT_ACCOUNT_PIVOT_LABEL 74 DEPOSIT_DATE 58 DOC_SEQUENCE_NAME 59 DOC_SEQUENCE_VALUE 34 EARNED_DISCOUNT_TAKEN 82 EXCHANGE_DATE 81 EXCHANGE_RATE 83 EXCHANGE_RATE_TYPE 23 FACTOR_DISCOUNT_AMOUNT 53 FIRST_APPLIED_IN_FULL_DATE 56 FIRST_APPLIED_IN_FULL_GL_DATE 51 FIRST_APPLY_DATE 54 FIRST_APPLY_GL_DATE 20 GL_DATE 73 ISSUE_DATE 52 LAST_APPLY_DATE 55 LAST_APPLY_GL_DATE 1 LEDGER 1 2 LEDGER_CURRENCY 28 MISCELLANEOUS_AMOUNT 76 MISC_PAYMENT_SOURCE 25 ON_ACCOUNT_AMOUNT 5 OPERATING_UNIT 22 RECEIPT_AMOUNT 84 RECEIPT_COMMENTS 70 RECEIPT_CREATED_BY 69 RECEIPT_CREATION_DATE 21 RECEIPT_CURRENCY 3 19 RECEIPT_DATE -26.0033 RECEIPT_GAIN_LOSS 63 RECEIPT_HISTORY_STATUS 72 RECEIPT_LAST_UPDATED_BY 71 RECEIPT_LAST_UPDATED_DATE 61 RECEIPT_METHOD 18 RECEIPT_NUMBER 6 62 RECEIPT_STATUS 60 RECEIPT_TYPE 78 REFERENCE_NUMBER 77 REFERENCE_TYPE 31 REFUND_AMOUNT -17.0023 RELATED_CUSTOMER_NUMBER 105 REPORTING_ENTITY 66 REVERSAL_CATEGORY 68 REVERSAL_COMMENTS 65 REVERSAL_DATE 67 REVERSAL_REASON 33 SHORT_TERM_DEBT_AMOUNT 80 TAX_CODE -17.0021 TRX_AMOUNT -17.002 TRX_CURRENCY -17.0019 TRX_DATE 27 UNAPPLIED_AMOUNT -26.0027 UNAPPLIED_AMT 35 UNEARNED_DISCOUNT_TAKEN 26 UNIDENTIFIED_AMOUNT 30 WRITEOFF_AMOUNT ACCOUNT_SEGMENT FILTER 3 ACCTD_AMT_APPLIED_FROM_RECEIPT VALUE 5 SUM ACCTD_AMT_APPLIED_TO_TRX VALUE 6 SUM ACCTD_APPLIED_AMOUNT VALUE 3 SUM ACCTD_CASH_CLAIMS_AMOUNT VALUE 8 SUM ACCTD_CHARGEBACK_AMOUNT VALUE 11 SUM ACCTD_EARNED_DISCOUNT_TAKEN VALUE 13 SUM ACCTD_FACTOR_DISCOUNT_AMOUNT VALUE 2 SUM ACCTD_GAIN_LOSS VALUE 15 SUM ACCTD_MISCELLANEOUS_AMOUNT VALUE 7 SUM ACCTD_ON_ACCOUNT_AMOUNT VALUE 4 SUM ACCTD_RECEIPT_AMOUNT VALUE 1 SUM ACCTD_REFUND_AMOUNT VALUE 10 SUM ACCTD_SHORT_TERM_DEBT_AMOUNT VALUE 12 SUM ACCTD_UNAPPLIED_AMOUNT VALUE 6 SUM ACCTD_UNAPPLIED_AMT VALUE 6 SUM ACCTD_UNEARNED_DISCOUNT_TAKEN VALUE 14 SUM ACCTD_UNIDENTIFIED_AMOUNT VALUE 5 SUM ACCTD_UNIDENTIFIED_AMT VALUE 5 SUM ACCTD_WRITEOFF_AMOUNT VALUE 9 SUM AMOUNT_APPLIED_FROM_RECEIPT VALUE 1 SUM AMOUNT_APPLIED_TO_TRX VALUE 2 SUM BALANCING_SEGMENT FILTER 2 BAL_SEG_PIVOT_LABEL ROW 1 BATCH_SOURCE FILTER 7 CUSTOMER_NAME FILTER 5 CUSTOMER_NUMBER FILTER 6 CUST_NAME_PIVOT_LABEL ROW 3 LEDGER FILTER 1 OPERATING_UNIT FILTER 4 RECEIPT_CURRENCY ROW 2 RECEIPT_GAIN_LOSS VALUE 7 SUM S Site Pivot: Summary by Debit Account Y Pivot: Summary by Balancing Segment, Account Segment, Debit Account, Receipt Currency with drilldown to details SYSADMIN 101 ACCOUNT_PIVOT_LABEL 98 ACCOUNT_SEGMENT 99 ACCOUNT_SEGMENT_DESC -26.0031 ACCTD_AMT_APPLIED_FROM_RECEIPT -26.0032 ACCTD_AMT_APPLIED_TO_TRX 38 ACCTD_APPLIED_AMOUNT 43 ACCTD_CASH_CLAIMS_AMOUNT 46 ACCTD_CHARGEBACK_AMOUNT 48 ACCTD_EARNED_DISCOUNT_TAKEN 37 ACCTD_FACTOR_DISCOUNT_AMOUNT 50 ACCTD_GAIN_LOSS 42 ACCTD_MISCELLANEOUS_AMOUNT 39 ACCTD_ON_ACCOUNT_AMOUNT 36 ACCTD_RECEIPT_AMOUNT 45 ACCTD_REFUND_AMOUNT 47 ACCTD_SHORT_TERM_DEBT_AMOUNT -17.0022 ACCTD_TRX_AMOUNT 41 ACCTD_UNAPPLIED_AMOUNT -35.0037 ACCTD_UNAPPLIED_AMT 49 ACCTD_UNEARNED_DISCOUNT_TAKEN 40 ACCTD_UNIDENTIFIED_AMOUNT -35.0036 ACCTD_UNIDENTIFIED_AMT 44 ACCTD_WRITEOFF_AMOUNT -26.0027 AMOUNT_APPLIED_FROM_RECEIPT -26.0028 AMOUNT_APPLIED_TO_TRX 71 ANTICIPATED_CLEARING_DATE 64 APPLICATION_NOTES 24 APPLIED_AMOUNT -17.0018 APPLIED_TO_TRX_NUMBER 7 -17.0024 APPLY_DATE 4 -17.0025 APPLY_GL_DATE 3 BALANCING_SEGMENT 2 4 BALANCING_SEGMENT_DESC 100 BAL_SEG_PIVOT_LABEL 95 BANK_ACCOUNT_CURRENCY 96 BANK_ACCOUNT_DESCRIPTION 92 BANK_ACCOUNT_NAME 93 BANK_ACCOUNT_NAME_ALT 94 BANK_ACCOUNT_NUMBER 91 BANK_BRANCH_COUNTRY 88 BANK_BRANCH_NAME 89 BANK_BRANCH_NAME_ALT 85 BANK_NAME 86 BANK_NAME_ALT 87 BANK_NUMBER 17 BATCH_NAME 10 BATCH_SOURCE 90 BRANCH_NUMBER 29 CASH_CLAIMS_AMOUNT 105 CASH_RECEIPT_ID 32 CHARGEBACK_AMOUNT 14 COLLECTOR 15 COLLECTOR_ACCOUNT 16 COLLECTOR_SITE 11 CUSTOMER_ADDRESS 12 CUSTOMER_COUNTRY 9 CUSTOMER_LOCATION 6 CUSTOMER_NAME 5 8 CUSTOMER_NAME_ALT 7 CUSTOMER_NUMBER 75 CUSTOMER_RECEIPT_REFERENCE 13 CUSTOMER_TAX_NUMBER 102 CUST_NAME_PIVOT_LABEL 103 CUST_NUMBER_PIVOT_LABEL 57 DEBIT_ACCOUNT 97 DEBIT_ACCOUNT_DESC 106 DEBIT_ACCOUNT_PIVOT_LABEL 70 DEPOSIT_DATE 58 DOC_SEQUENCE_NAME 59 DOC_SEQUENCE_VALUE 34 EARNED_DISCOUNT_TAKEN 78 EXCHANGE_DATE 77 EXCHANGE_RATE 79 EXCHANGE_RATE_TYPE 23 FACTOR_DISCOUNT_AMOUNT 53 FIRST_APPLIED_IN_FULL_DATE 56 FIRST_APPLIED_IN_FULL_GL_DATE 51 FIRST_APPLY_DATE 54 FIRST_APPLY_GL_DATE 20 GL_DATE 69 ISSUE_DATE 52 LAST_APPLY_DATE 55 LAST_APPLY_GL_DATE 1 LEDGER 1 2 LEDGER_CURRENCY 28 MISCELLANEOUS_AMOUNT 72 MISC_PAYMENT_SOURCE 25 ON_ACCOUNT_AMOUNT 5 OPERATING_UNIT 22 RECEIPT_AMOUNT 80 RECEIPT_COMMENTS 66 RECEIPT_CREATED_BY 65 RECEIPT_CREATION_DATE 21 RECEIPT_CURRENCY 3 19 RECEIPT_DATE -26.0033 RECEIPT_GAIN_LOSS 63 RECEIPT_HISTORY_STATUS 68 RECEIPT_LAST_UPDATED_BY 67 RECEIPT_LAST_UPDATED_DATE 61 RECEIPT_METHOD 18 RECEIPT_NUMBER 6 62 RECEIPT_STATUS 60 RECEIPT_TYPE 74 REFERENCE_NUMBER 73 REFERENCE_TYPE 31 REFUND_AMOUNT -17.0023 RELATED_CUSTOMER_NUMBER 104 REPORTING_ENTITY 82 REVERSAL_CATEGORY 84 REVERSAL_COMMENTS 81 REVERSAL_DATE 83 REVERSAL_REASON 33 SHORT_TERM_DEBT_AMOUNT 76 TAX_CODE -17.0021 TRX_AMOUNT -17.002 TRX_CURRENCY -17.0019 TRX_DATE 27 UNAPPLIED_AMOUNT -26.0027 UNAPPLIED_AMT 35 UNEARNED_DISCOUNT_TAKEN 26 UNIDENTIFIED_AMOUNT 30 WRITEOFF_AMOUNT ACCOUNT_PIVOT_LABEL ROW 2 ACCOUNT_SEGMENT FILTER 3 ACCTD_AMT_APPLIED_FROM_RECEIPT VALUE 5 SUM ACCTD_AMT_APPLIED_TO_TRX VALUE 6 SUM ACCTD_APPLIED_AMOUNT VALUE 17 SUM ACCTD_CASH_CLAIMS_AMOUNT VALUE 22 SUM ACCTD_CHARGEBACK_AMOUNT VALUE 25 SUM ACCTD_EARNED_DISCOUNT_TAKEN VALUE 27 SUM ACCTD_FACTOR_DISCOUNT_AMOUNT VALUE 16 SUM ACCTD_GAIN_LOSS VALUE 29 SUM ACCTD_MISCELLANEOUS_AMOUNT VALUE 21 SUM ACCTD_ON_ACCOUNT_AMOUNT VALUE 18 SUM ACCTD_RECEIPT_AMOUNT VALUE 15 SUM ACCTD_REFUND_AMOUNT VALUE 24 SUM ACCTD_SHORT_TERM_DEBT_AMOUNT VALUE 26 SUM ACCTD_UNAPPLIED_AMOUNT VALUE 20 SUM ACCTD_UNAPPLIED_AMT VALUE 18 SUM ACCTD_UNEARNED_DISCOUNT_TAKEN VALUE 28 SUM ACCTD_UNIDENTIFIED_AMOUNT VALUE 19 SUM ACCTD_UNIDENTIFIED_AMT VALUE 17 SUM ACCTD_WRITEOFF_AMOUNT VALUE 23 SUM AMOUNT_APPLIED_FROM_RECEIPT VALUE 1 SUM AMOUNT_APPLIED_TO_TRX VALUE 2 SUM APPLIED_AMOUNT VALUE 3 SUM BALANCING_SEGMENT FILTER 2 BAL_SEG_PIVOT_LABEL ROW 1 BATCH_SOURCE FILTER 7 CASH_CLAIMS_AMOUNT VALUE 8 SUM CHARGEBACK_AMOUNT VALUE 11 SUM CUSTOMER_NAME FILTER 5 CUSTOMER_NUMBER FILTER 6 DEBIT_ACCOUNT_PIVOT_LABEL ROW 3 EARNED_DISCOUNT_TAKEN VALUE 13 SUM FACTOR_DISCOUNT_AMOUNT VALUE 2 SUM LEDGER FILTER 1 MISCELLANEOUS_AMOUNT VALUE 7 SUM ON_ACCOUNT_AMOUNT VALUE 4 SUM OPERATING_UNIT FILTER 4 RECEIPT_AMOUNT VALUE 1 SUM RECEIPT_CURRENCY ROW 4 RECEIPT_GAIN_LOSS VALUE 7 SUM REFUND_AMOUNT VALUE 10 SUM SHORT_TERM_DEBT_AMOUNT VALUE 12 SUM UNAPPLIED_AMOUNT VALUE 6 SUM UNAPPLIED_AMT VALUE 6 SUM UNEARNED_DISCOUNT_TAKEN VALUE 14 SUM UNIDENTIFIED_AMOUNT VALUE 5 SUM WRITEOFF_AMOUNT VALUE 9 SUM S Site Pivot: Summary by Debit Account - Accounted Currency Y Pivot: Summary by Balancing Segment, Account Segment, Debit Account, Receipt Currency with drilldown to details SYSADMIN 101 ACCOUNT_PIVOT_LABEL 98 ACCOUNT_SEGMENT 99 ACCOUNT_SEGMENT_DESC -26.0031 ACCTD_AMT_APPLIED_FROM_RECEIPT -26.0032 ACCTD_AMT_APPLIED_TO_TRX 38 ACCTD_APPLIED_AMOUNT 43 ACCTD_CASH_CLAIMS_AMOUNT 46 ACCTD_CHARGEBACK_AMOUNT 48 ACCTD_EARNED_DISCOUNT_TAKEN 37 ACCTD_FACTOR_DISCOUNT_AMOUNT 50 ACCTD_GAIN_LOSS 42 ACCTD_MISCELLANEOUS_AMOUNT 39 ACCTD_ON_ACCOUNT_AMOUNT 36 ACCTD_RECEIPT_AMOUNT 45 ACCTD_REFUND_AMOUNT 47 ACCTD_SHORT_TERM_DEBT_AMOUNT -17.0022 ACCTD_TRX_AMOUNT 41 ACCTD_UNAPPLIED_AMOUNT -39.0041 ACCTD_UNAPPLIED_AMT 49 ACCTD_UNEARNED_DISCOUNT_TAKEN 40 ACCTD_UNIDENTIFIED_AMOUNT -39.004 ACCTD_UNIDENTIFIED_AMT 44 ACCTD_WRITEOFF_AMOUNT -26.0027 AMOUNT_APPLIED_FROM_RECEIPT -26.0028 AMOUNT_APPLIED_TO_TRX 75 ANTICIPATED_CLEARING_DATE 64 APPLICATION_NOTES 24 APPLIED_AMOUNT -17.0018 APPLIED_TO_TRX_NUMBER 7 -17.0024 APPLY_DATE 4 -17.0025 APPLY_GL_DATE 3 BALANCING_SEGMENT 2 4 BALANCING_SEGMENT_DESC 100 BAL_SEG_PIVOT_LABEL 95 BANK_ACCOUNT_CURRENCY 96 BANK_ACCOUNT_DESCRIPTION 92 BANK_ACCOUNT_NAME 93 BANK_ACCOUNT_NAME_ALT 94 BANK_ACCOUNT_NUMBER 91 BANK_BRANCH_COUNTRY 88 BANK_BRANCH_NAME 89 BANK_BRANCH_NAME_ALT 85 BANK_NAME 86 BANK_NAME_ALT 87 BANK_NUMBER 17 BATCH_NAME 10 BATCH_SOURCE 90 BRANCH_NUMBER 29 CASH_CLAIMS_AMOUNT 105 CASH_RECEIPT_ID 32 CHARGEBACK_AMOUNT 14 COLLECTOR 15 COLLECTOR_ACCOUNT 16 COLLECTOR_SITE 11 CUSTOMER_ADDRESS 12 CUSTOMER_COUNTRY 9 CUSTOMER_LOCATION 6 CUSTOMER_NAME 5 8 CUSTOMER_NAME_ALT 7 CUSTOMER_NUMBER 79 CUSTOMER_RECEIPT_REFERENCE 13 CUSTOMER_TAX_NUMBER 102 CUST_NAME_PIVOT_LABEL 103 CUST_NUMBER_PIVOT_LABEL 57 DEBIT_ACCOUNT 97 DEBIT_ACCOUNT_DESC 106 DEBIT_ACCOUNT_PIVOT_LABEL 74 DEPOSIT_DATE 58 DOC_SEQUENCE_NAME 59 DOC_SEQUENCE_VALUE 34 EARNED_DISCOUNT_TAKEN 82 EXCHANGE_DATE 81 EXCHANGE_RATE 83 EXCHANGE_RATE_TYPE 23 FACTOR_DISCOUNT_AMOUNT 53 FIRST_APPLIED_IN_FULL_DATE 56 FIRST_APPLIED_IN_FULL_GL_DATE 51 FIRST_APPLY_DATE 54 FIRST_APPLY_GL_DATE 20 GL_DATE 73 ISSUE_DATE 52 LAST_APPLY_DATE 55 LAST_APPLY_GL_DATE 1 LEDGER 1 2 LEDGER_CURRENCY 28 MISCELLANEOUS_AMOUNT 76 MISC_PAYMENT_SOURCE 25 ON_ACCOUNT_AMOUNT 5 OPERATING_UNIT 22 RECEIPT_AMOUNT 84 RECEIPT_COMMENTS 70 RECEIPT_CREATED_BY 69 RECEIPT_CREATION_DATE 21 RECEIPT_CURRENCY 3 19 RECEIPT_DATE -26.0033 RECEIPT_GAIN_LOSS 63 RECEIPT_HISTORY_STATUS 72 RECEIPT_LAST_UPDATED_BY 71 RECEIPT_LAST_UPDATED_DATE 61 RECEIPT_METHOD 18 RECEIPT_NUMBER 6 62 RECEIPT_STATUS 60 RECEIPT_TYPE 78 REFERENCE_NUMBER 77 REFERENCE_TYPE 31 REFUND_AMOUNT -17.0023 RELATED_CUSTOMER_NUMBER 104 REPORTING_ENTITY 66 REVERSAL_CATEGORY 68 REVERSAL_COMMENTS 65 REVERSAL_DATE 67 REVERSAL_REASON 33 SHORT_TERM_DEBT_AMOUNT 80 TAX_CODE -17.0021 TRX_AMOUNT -17.002 TRX_CURRENCY -17.0019 TRX_DATE 27 UNAPPLIED_AMOUNT -26.0027 UNAPPLIED_AMT 35 UNEARNED_DISCOUNT_TAKEN 26 UNIDENTIFIED_AMOUNT 30 WRITEOFF_AMOUNT ACCOUNT_PIVOT_LABEL ROW 2 ACCOUNT_SEGMENT FILTER 3 ACCTD_AMT_APPLIED_FROM_RECEIPT VALUE 5 SUM ACCTD_AMT_APPLIED_TO_TRX VALUE 6 SUM ACCTD_APPLIED_AMOUNT VALUE 3 SUM ACCTD_CASH_CLAIMS_AMOUNT VALUE 8 SUM ACCTD_CHARGEBACK_AMOUNT VALUE 11 SUM ACCTD_EARNED_DISCOUNT_TAKEN VALUE 13 SUM ACCTD_FACTOR_DISCOUNT_AMOUNT VALUE 2 SUM ACCTD_MISCELLANEOUS_AMOUNT VALUE 7 SUM ACCTD_ON_ACCOUNT_AMOUNT VALUE 4 SUM ACCTD_RECEIPT_AMOUNT VALUE 1 SUM ACCTD_REFUND_AMOUNT VALUE 10 SUM ACCTD_SHORT_TERM_DEBT_AMOUNT VALUE 12 SUM ACCTD_UNAPPLIED_AMOUNT VALUE 6 SUM ACCTD_UNAPPLIED_AMT VALUE 6 SUM ACCTD_UNEARNED_DISCOUNT_TAKEN VALUE 14 SUM ACCTD_UNIDENTIFIED_AMOUNT VALUE 5 SUM ACCTD_UNIDENTIFIED_AMT VALUE 5 SUM ACCTD_WRITEOFF_AMOUNT VALUE 9 SUM AMOUNT_APPLIED_FROM_RECEIPT VALUE 1 SUM AMOUNT_APPLIED_TO_TRX VALUE 2 SUM BALANCING_SEGMENT FILTER 2 BAL_SEG_PIVOT_LABEL ROW 1 BATCH_SOURCE FILTER 7 CUSTOMER_NAME FILTER 5 CUSTOMER_NUMBER FILTER 6 DEBIT_ACCOUNT_PIVOT_LABEL ROW 3 LEDGER FILTER 1 OPERATING_UNIT FILTER 4 RECEIPT_CURRENCY ROW 4 RECEIPT_GAIN_LOSS VALUE 7 SUM S Site Pivot: Summary by GL Date Y Pivot: Summary by Balancing Segment, Receipt Currency, GL Date with drilldown to details SYSADMIN 102 ACCOUNT_PIVOT_LABEL 98 ACCOUNT_SEGMENT 99 ACCOUNT_SEGMENT_DESC 38 ACCTD_APPLIED_AMOUNT 43 ACCTD_CASH_CLAIMS_AMOUNT 46 ACCTD_CHARGEBACK_AMOUNT 48 ACCTD_EARNED_DISCOUNT_TAKEN 37 ACCTD_FACTOR_DISCOUNT_AMOUNT 50 ACCTD_GAIN_LOSS 42 ACCTD_MISCELLANEOUS_AMOUNT 39 ACCTD_ON_ACCOUNT_AMOUNT 36 ACCTD_RECEIPT_AMOUNT 45 ACCTD_REFUND_AMOUNT 47 ACCTD_SHORT_TERM_DEBT_AMOUNT 41 ACCTD_UNAPPLIED_AMOUNT -35.0037 ACCTD_UNAPPLIED_AMT 49 ACCTD_UNEARNED_DISCOUNT_TAKEN 40 ACCTD_UNIDENTIFIED_AMOUNT -35.0036 ACCTD_UNIDENTIFIED_AMT 44 ACCTD_WRITEOFF_AMOUNT 70 ANTICIPATED_CLEARING_DATE 80 APPLICATION_NOTES 24 APPLIED_AMOUNT 3 BALANCING_SEGMENT 2 4 BALANCING_SEGMENT_DESC 101 BAL_SEG_PIVOT_LABEL 95 BANK_ACCOUNT_CURRENCY 96 BANK_ACCOUNT_DESCRIPTION 92 BANK_ACCOUNT_NAME 93 BANK_ACCOUNT_NAME_ALT 94 BANK_ACCOUNT_NUMBER 91 BANK_BRANCH_COUNTRY 88 BANK_BRANCH_NAME 89 BANK_BRANCH_NAME_ALT 85 BANK_NAME 86 BANK_NAME_ALT 87 BANK_NUMBER 16 BATCH_NAME 17 BATCH_SOURCE 90 BRANCH_NUMBER 29 CASH_CLAIMS_AMOUNT 106 CASH_RECEIPT_ID 32 CHARGEBACK_AMOUNT 13 COLLECTOR 14 COLLECTOR_ACCOUNT 15 COLLECTOR_SITE 10 CUSTOMER_ADDRESS 11 CUSTOMER_COUNTRY 9 CUSTOMER_LOCATION 6 CUSTOMER_NAME 5 8 CUSTOMER_NAME_ALT 7 CUSTOMER_NUMBER 74 CUSTOMER_RECEIPT_REFERENCE 12 CUSTOMER_TAX_NUMBER 103 CUST_NAME_PIVOT_LABEL 104 CUST_NUMBER_PIVOT_LABEL 57 DEBIT_ACCOUNT 97 DEBIT_ACCOUNT_DESC 100 DEBIT_ACCOUNT_PIVOT_LABEL 69 DEPOSIT_DATE 58 DOC_SEQUENCE_NAME 59 DOC_SEQUENCE_VALUE 34 EARNED_DISCOUNT_TAKEN 77 EXCHANGE_DATE 76 EXCHANGE_RATE 78 EXCHANGE_RATE_TYPE 23 FACTOR_DISCOUNT_AMOUNT 53 FIRST_APPLIED_IN_FULL_DATE 56 FIRST_APPLIED_IN_FULL_GL_DATE 51 FIRST_APPLY_DATE 54 FIRST_APPLY_GL_DATE 20 GL_DATE 68 ISSUE_DATE 52 LAST_APPLY_DATE 55 LAST_APPLY_GL_DATE 1 LEDGER 1 2 LEDGER_CURRENCY 28 MISCELLANEOUS_AMOUNT 71 MISC_PAYMENT_SOURCE 25 ON_ACCOUNT_AMOUNT 5 OPERATING_UNIT 22 RECEIPT_AMOUNT 79 RECEIPT_COMMENTS 65 RECEIPT_CREATED_BY 64 RECEIPT_CREATION_DATE 21 RECEIPT_CURRENCY 3 19 RECEIPT_DATE 63 RECEIPT_HISTORY_STATUS 67 RECEIPT_LAST_UPDATED_BY 66 RECEIPT_LAST_UPDATED_DATE 61 RECEIPT_METHOD 18 RECEIPT_NUMBER 6 62 RECEIPT_STATUS 60 RECEIPT_TYPE 73 REFERENCE_NUMBER 72 REFERENCE_TYPE 31 REFUND_AMOUNT 105 REPORTING_ENTITY 82 REVERSAL_CATEGORY 84 REVERSAL_COMMENTS 81 REVERSAL_DATE 83 REVERSAL_REASON 33 SHORT_TERM_DEBT_AMOUNT 75 TAX_CODE 27 UNAPPLIED_AMOUNT -26.0027 UNAPPLIED_AMT 35 UNEARNED_DISCOUNT_TAKEN 26 UNIDENTIFIED_AMOUNT 30 WRITEOFF_AMOUNT ACCOUNT_SEGMENT FILTER 3 ACCTD_AMT_APPLIED_FROM_RECEIPT VALUE 5 SUM ACCTD_AMT_APPLIED_TO_TRX VALUE 6 SUM ACCTD_APPLIED_AMOUNT VALUE 17 SUM ACCTD_CASH_CLAIMS_AMOUNT VALUE 22 SUM ACCTD_CHARGEBACK_AMOUNT VALUE 25 SUM ACCTD_EARNED_DISCOUNT_TAKEN VALUE 27 SUM ACCTD_FACTOR_DISCOUNT_AMOUNT VALUE 16 SUM ACCTD_GAIN_LOSS VALUE 29 SUM ACCTD_MISCELLANEOUS_AMOUNT VALUE 21 SUM ACCTD_ON_ACCOUNT_AMOUNT VALUE 18 SUM ACCTD_RECEIPT_AMOUNT VALUE 15 SUM ACCTD_REFUND_AMOUNT VALUE 24 SUM ACCTD_SHORT_TERM_DEBT_AMOUNT VALUE 26 SUM ACCTD_UNAPPLIED_AMOUNT VALUE 20 SUM ACCTD_UNAPPLIED_AMT VALUE 18 SUM ACCTD_UNEARNED_DISCOUNT_TAKEN VALUE 28 SUM ACCTD_UNIDENTIFIED_AMOUNT VALUE 19 SUM ACCTD_UNIDENTIFIED_AMT VALUE 17 SUM ACCTD_WRITEOFF_AMOUNT VALUE 23 SUM AMOUNT_APPLIED_FROM_RECEIPT VALUE 1 SUM AMOUNT_APPLIED_TO_TRX VALUE 2 SUM APPLIED_AMOUNT VALUE 3 SUM APPLY_GL_DATE ROW 3 BALANCING_SEGMENT FILTER 2 BAL_SEG_PIVOT_LABEL ROW 1 BATCH_SOURCE FILTER 7 CASH_CLAIMS_AMOUNT VALUE 8 SUM CHARGEBACK_AMOUNT VALUE 11 SUM CUSTOMER_NAME FILTER 5 CUSTOMER_NUMBER FILTER 6 EARNED_DISCOUNT_TAKEN VALUE 13 SUM FACTOR_DISCOUNT_AMOUNT VALUE 2 SUM GL_DATE ROW 2 LEDGER FILTER 1 MISCELLANEOUS_AMOUNT VALUE 7 SUM ON_ACCOUNT_AMOUNT VALUE 4 SUM OPERATING_UNIT FILTER 4 RECEIPT_AMOUNT VALUE 1 SUM RECEIPT_CURRENCY ROW 3 RECEIPT_GAIN_LOSS VALUE 7 SUM REFUND_AMOUNT VALUE 10 SUM SHORT_TERM_DEBT_AMOUNT VALUE 12 SUM UNAPPLIED_AMOUNT VALUE 6 SUM UNAPPLIED_AMT VALUE 6 SUM UNEARNED_DISCOUNT_TAKEN VALUE 14 SUM UNIDENTIFIED_AMOUNT VALUE 5 SUM WRITEOFF_AMOUNT VALUE 9 SUM S Site Pivot: Summary by GL Date - Accounted Currency Y Pivot: Summary by Balancing Segment, Receipt Currency, GL Date with drilldown to details SYSADMIN 102 ACCOUNT_PIVOT_LABEL 98 ACCOUNT_SEGMENT 99 ACCOUNT_SEGMENT_DESC 38 ACCTD_APPLIED_AMOUNT 43 ACCTD_CASH_CLAIMS_AMOUNT 46 ACCTD_CHARGEBACK_AMOUNT 48 ACCTD_EARNED_DISCOUNT_TAKEN 37 ACCTD_FACTOR_DISCOUNT_AMOUNT 50 ACCTD_GAIN_LOSS 42 ACCTD_MISCELLANEOUS_AMOUNT 39 ACCTD_ON_ACCOUNT_AMOUNT 36 ACCTD_RECEIPT_AMOUNT 45 ACCTD_REFUND_AMOUNT 47 ACCTD_SHORT_TERM_DEBT_AMOUNT 41 ACCTD_UNAPPLIED_AMOUNT -39.0041 ACCTD_UNAPPLIED_AMT 49 ACCTD_UNEARNED_DISCOUNT_TAKEN 40 ACCTD_UNIDENTIFIED_AMOUNT -39.004 ACCTD_UNIDENTIFIED_AMT 44 ACCTD_WRITEOFF_AMOUNT 70 ANTICIPATED_CLEARING_DATE 80 APPLICATION_NOTES 24 APPLIED_AMOUNT 3 BALANCING_SEGMENT 2 4 BALANCING_SEGMENT_DESC 101 BAL_SEG_PIVOT_LABEL 95 BANK_ACCOUNT_CURRENCY 96 BANK_ACCOUNT_DESCRIPTION 92 BANK_ACCOUNT_NAME 93 BANK_ACCOUNT_NAME_ALT 94 BANK_ACCOUNT_NUMBER 91 BANK_BRANCH_COUNTRY 88 BANK_BRANCH_NAME 89 BANK_BRANCH_NAME_ALT 85 BANK_NAME 86 BANK_NAME_ALT 87 BANK_NUMBER 16 BATCH_NAME 17 BATCH_SOURCE 90 BRANCH_NUMBER 29 CASH_CLAIMS_AMOUNT 106 CASH_RECEIPT_ID 32 CHARGEBACK_AMOUNT 13 COLLECTOR 14 COLLECTOR_ACCOUNT 15 COLLECTOR_SITE 10 CUSTOMER_ADDRESS 11 CUSTOMER_COUNTRY 9 CUSTOMER_LOCATION 6 CUSTOMER_NAME 5 8 CUSTOMER_NAME_ALT 7 CUSTOMER_NUMBER 74 CUSTOMER_RECEIPT_REFERENCE 12 CUSTOMER_TAX_NUMBER 103 CUST_NAME_PIVOT_LABEL 104 CUST_NUMBER_PIVOT_LABEL 57 DEBIT_ACCOUNT 97 DEBIT_ACCOUNT_DESC 100 DEBIT_ACCOUNT_PIVOT_LABEL 69 DEPOSIT_DATE 58 DOC_SEQUENCE_NAME 59 DOC_SEQUENCE_VALUE 34 EARNED_DISCOUNT_TAKEN 77 EXCHANGE_DATE 76 EXCHANGE_RATE 78 EXCHANGE_RATE_TYPE 23 FACTOR_DISCOUNT_AMOUNT 53 FIRST_APPLIED_IN_FULL_DATE 56 FIRST_APPLIED_IN_FULL_GL_DATE 51 FIRST_APPLY_DATE 54 FIRST_APPLY_GL_DATE 20 GL_DATE 68 ISSUE_DATE 52 LAST_APPLY_DATE 55 LAST_APPLY_GL_DATE 1 LEDGER 1 2 LEDGER_CURRENCY 28 MISCELLANEOUS_AMOUNT 71 MISC_PAYMENT_SOURCE 25 ON_ACCOUNT_AMOUNT 5 OPERATING_UNIT 22 RECEIPT_AMOUNT 79 RECEIPT_COMMENTS 65 RECEIPT_CREATED_BY 64 RECEIPT_CREATION_DATE 21 RECEIPT_CURRENCY 3 19 RECEIPT_DATE 63 RECEIPT_HISTORY_STATUS 67 RECEIPT_LAST_UPDATED_BY 66 RECEIPT_LAST_UPDATED_DATE 61 RECEIPT_METHOD 18 RECEIPT_NUMBER 6 62 RECEIPT_STATUS 60 RECEIPT_TYPE 73 REFERENCE_NUMBER 72 REFERENCE_TYPE 31 REFUND_AMOUNT 105 REPORTING_ENTITY 82 REVERSAL_CATEGORY 84 REVERSAL_COMMENTS 81 REVERSAL_DATE 83 REVERSAL_REASON 33 SHORT_TERM_DEBT_AMOUNT 75 TAX_CODE 27 UNAPPLIED_AMOUNT -26.0027 UNAPPLIED_AMT 35 UNEARNED_DISCOUNT_TAKEN 26 UNIDENTIFIED_AMOUNT 30 WRITEOFF_AMOUNT ACCOUNT_SEGMENT FILTER 3 ACCTD_AMT_APPLIED_FROM_RECEIPT VALUE 5 SUM ACCTD_AMT_APPLIED_TO_TRX VALUE 6 SUM ACCTD_APPLIED_AMOUNT VALUE 3 SUM ACCTD_CASH_CLAIMS_AMOUNT VALUE 8 SUM ACCTD_CHARGEBACK_AMOUNT VALUE 11 SUM ACCTD_EARNED_DISCOUNT_TAKEN VALUE 13 SUM ACCTD_FACTOR_DISCOUNT_AMOUNT VALUE 2 SUM ACCTD_GAIN_LOSS VALUE 15 SUM ACCTD_MISCELLANEOUS_AMOUNT VALUE 7 SUM ACCTD_ON_ACCOUNT_AMOUNT VALUE 4 SUM ACCTD_RECEIPT_AMOUNT VALUE 1 SUM ACCTD_REFUND_AMOUNT VALUE 10 SUM ACCTD_SHORT_TERM_DEBT_AMOUNT VALUE 12 SUM ACCTD_UNAPPLIED_AMOUNT VALUE 6 SUM ACCTD_UNAPPLIED_AMT VALUE 6 SUM ACCTD_UNEARNED_DISCOUNT_TAKEN VALUE 14 SUM ACCTD_UNIDENTIFIED_AMOUNT VALUE 5 SUM ACCTD_UNIDENTIFIED_AMT VALUE 5 SUM ACCTD_WRITEOFF_AMOUNT VALUE 9 SUM AMOUNT_APPLIED_FROM_RECEIPT VALUE 1 SUM AMOUNT_APPLIED_TO_TRX VALUE 2 SUM APPLY_GL_DATE ROW 3 BALANCING_SEGMENT FILTER 2 BAL_SEG_PIVOT_LABEL ROW 1 BATCH_SOURCE FILTER 7 CUSTOMER_NAME FILTER 5 CUSTOMER_NUMBER FILTER 6 GL_DATE ROW 2 LEDGER FILTER 1 OPERATING_UNIT FILTER 4 RECEIPT_CURRENCY ROW 3 RECEIPT_GAIN_LOSS VALUE 7 SUM S Site Pivot: Summary by Receipt Date Y Pivot: Summary by Balancing Segment, Receipt Currency, Receipt Date with drilldown to details SYSADMIN 102 ACCOUNT_PIVOT_LABEL 98 ACCOUNT_SEGMENT 99 ACCOUNT_SEGMENT_DESC 38 ACCTD_APPLIED_AMOUNT 43 ACCTD_CASH_CLAIMS_AMOUNT 46 ACCTD_CHARGEBACK_AMOUNT 48 ACCTD_EARNED_DISCOUNT_TAKEN 37 ACCTD_FACTOR_DISCOUNT_AMOUNT 50 ACCTD_GAIN_LOSS 42 ACCTD_MISCELLANEOUS_AMOUNT 39 ACCTD_ON_ACCOUNT_AMOUNT 36 ACCTD_RECEIPT_AMOUNT 45 ACCTD_REFUND_AMOUNT 47 ACCTD_SHORT_TERM_DEBT_AMOUNT 41 ACCTD_UNAPPLIED_AMOUNT -35.0037 ACCTD_UNAPPLIED_AMT 49 ACCTD_UNEARNED_DISCOUNT_TAKEN 40 ACCTD_UNIDENTIFIED_AMOUNT -35.0036 ACCTD_UNIDENTIFIED_AMT 44 ACCTD_WRITEOFF_AMOUNT 70 ANTICIPATED_CLEARING_DATE 80 APPLICATION_NOTES 24 APPLIED_AMOUNT 3 BALANCING_SEGMENT 2 4 BALANCING_SEGMENT_DESC 101 BAL_SEG_PIVOT_LABEL 95 BANK_ACCOUNT_CURRENCY 96 BANK_ACCOUNT_DESCRIPTION 92 BANK_ACCOUNT_NAME 93 BANK_ACCOUNT_NAME_ALT 94 BANK_ACCOUNT_NUMBER 91 BANK_BRANCH_COUNTRY 88 BANK_BRANCH_NAME 89 BANK_BRANCH_NAME_ALT 85 BANK_NAME 86 BANK_NAME_ALT 87 BANK_NUMBER 16 BATCH_NAME 17 BATCH_SOURCE 90 BRANCH_NUMBER 29 CASH_CLAIMS_AMOUNT 106 CASH_RECEIPT_ID 32 CHARGEBACK_AMOUNT 13 COLLECTOR 14 COLLECTOR_ACCOUNT 15 COLLECTOR_SITE 10 CUSTOMER_ADDRESS 11 CUSTOMER_COUNTRY 9 CUSTOMER_LOCATION 6 CUSTOMER_NAME 5 8 CUSTOMER_NAME_ALT 7 CUSTOMER_NUMBER 74 CUSTOMER_RECEIPT_REFERENCE 12 CUSTOMER_TAX_NUMBER 103 CUST_NAME_PIVOT_LABEL 104 CUST_NUMBER_PIVOT_LABEL 57 DEBIT_ACCOUNT 97 DEBIT_ACCOUNT_DESC 100 DEBIT_ACCOUNT_PIVOT_LABEL 69 DEPOSIT_DATE 58 DOC_SEQUENCE_NAME 59 DOC_SEQUENCE_VALUE 34 EARNED_DISCOUNT_TAKEN 77 EXCHANGE_DATE 76 EXCHANGE_RATE 78 EXCHANGE_RATE_TYPE 23 FACTOR_DISCOUNT_AMOUNT 53 FIRST_APPLIED_IN_FULL_DATE 56 FIRST_APPLIED_IN_FULL_GL_DATE 51 FIRST_APPLY_DATE 54 FIRST_APPLY_GL_DATE 20 GL_DATE 68 ISSUE_DATE 52 LAST_APPLY_DATE 55 LAST_APPLY_GL_DATE 1 LEDGER 1 2 LEDGER_CURRENCY 28 MISCELLANEOUS_AMOUNT 71 MISC_PAYMENT_SOURCE 25 ON_ACCOUNT_AMOUNT 5 OPERATING_UNIT 22 RECEIPT_AMOUNT 79 RECEIPT_COMMENTS 65 RECEIPT_CREATED_BY 64 RECEIPT_CREATION_DATE 21 RECEIPT_CURRENCY 3 19 RECEIPT_DATE 4 63 RECEIPT_HISTORY_STATUS 67 RECEIPT_LAST_UPDATED_BY 66 RECEIPT_LAST_UPDATED_DATE 61 RECEIPT_METHOD 18 RECEIPT_NUMBER 6 62 RECEIPT_STATUS 60 RECEIPT_TYPE 73 REFERENCE_NUMBER 72 REFERENCE_TYPE 31 REFUND_AMOUNT 105 REPORTING_ENTITY 82 REVERSAL_CATEGORY 84 REVERSAL_COMMENTS 81 REVERSAL_DATE 83 REVERSAL_REASON 33 SHORT_TERM_DEBT_AMOUNT 75 TAX_CODE 27 UNAPPLIED_AMOUNT -26.0027 UNAPPLIED_AMT 35 UNEARNED_DISCOUNT_TAKEN 26 UNIDENTIFIED_AMOUNT 30 WRITEOFF_AMOUNT ACCOUNT_SEGMENT FILTER 3 ACCTD_AMT_APPLIED_FROM_RECEIPT VALUE 5 SUM ACCTD_AMT_APPLIED_TO_TRX VALUE 6 SUM ACCTD_APPLIED_AMOUNT VALUE 17 SUM ACCTD_CASH_CLAIMS_AMOUNT VALUE 22 SUM ACCTD_CHARGEBACK_AMOUNT VALUE 25 SUM ACCTD_EARNED_DISCOUNT_TAKEN VALUE 27 SUM ACCTD_FACTOR_DISCOUNT_AMOUNT VALUE 16 SUM ACCTD_GAIN_LOSS VALUE 29 SUM ACCTD_MISCELLANEOUS_AMOUNT VALUE 21 SUM ACCTD_ON_ACCOUNT_AMOUNT VALUE 18 SUM ACCTD_RECEIPT_AMOUNT VALUE 15 SUM ACCTD_REFUND_AMOUNT VALUE 24 SUM ACCTD_SHORT_TERM_DEBT_AMOUNT VALUE 26 SUM ACCTD_UNAPPLIED_AMOUNT VALUE 20 SUM ACCTD_UNAPPLIED_AMT VALUE 18 SUM ACCTD_UNEARNED_DISCOUNT_TAKEN VALUE 28 SUM ACCTD_UNIDENTIFIED_AMOUNT VALUE 19 SUM ACCTD_UNIDENTIFIED_AMT VALUE 17 SUM ACCTD_WRITEOFF_AMOUNT VALUE 23 SUM AMOUNT_APPLIED_FROM_RECEIPT VALUE 1 SUM AMOUNT_APPLIED_TO_TRX VALUE 2 SUM APPLIED_AMOUNT VALUE 3 SUM APPLY_DATE ROW 3 BALANCING_SEGMENT FILTER 2 BAL_SEG_PIVOT_LABEL ROW 1 BATCH_SOURCE FILTER 7 CASH_CLAIMS_AMOUNT VALUE 8 SUM CHARGEBACK_AMOUNT VALUE 11 SUM CUSTOMER_NAME FILTER 5 CUSTOMER_NUMBER FILTER 6 EARNED_DISCOUNT_TAKEN VALUE 13 SUM FACTOR_DISCOUNT_AMOUNT VALUE 2 SUM LEDGER FILTER 1 MISCELLANEOUS_AMOUNT VALUE 7 SUM ON_ACCOUNT_AMOUNT VALUE 4 SUM OPERATING_UNIT FILTER 4 RECEIPT_AMOUNT VALUE 1 SUM RECEIPT_CURRENCY ROW 2 RECEIPT_GAIN_LOSS VALUE 7 SUM REFUND_AMOUNT VALUE 10 SUM SHORT_TERM_DEBT_AMOUNT VALUE 12 SUM UNAPPLIED_AMOUNT VALUE 6 SUM UNAPPLIED_AMT VALUE 6 SUM UNEARNED_DISCOUNT_TAKEN VALUE 14 SUM UNIDENTIFIED_AMOUNT VALUE 5 SUM WRITEOFF_AMOUNT VALUE 9 SUM S Site Pivot: Summary by Receipt Date - Accounted Currency Y Pivot: Summary by Balancing Segment, Receipt Currency, Receipt Date with drilldown to details SYSADMIN 102 ACCOUNT_PIVOT_LABEL 98 ACCOUNT_SEGMENT 99 ACCOUNT_SEGMENT_DESC 38 ACCTD_APPLIED_AMOUNT 43 ACCTD_CASH_CLAIMS_AMOUNT 46 ACCTD_CHARGEBACK_AMOUNT 48 ACCTD_EARNED_DISCOUNT_TAKEN 37 ACCTD_FACTOR_DISCOUNT_AMOUNT 50 ACCTD_GAIN_LOSS 42 ACCTD_MISCELLANEOUS_AMOUNT 39 ACCTD_ON_ACCOUNT_AMOUNT 36 ACCTD_RECEIPT_AMOUNT 45 ACCTD_REFUND_AMOUNT 47 ACCTD_SHORT_TERM_DEBT_AMOUNT 41 ACCTD_UNAPPLIED_AMOUNT -39.0041 ACCTD_UNAPPLIED_AMT 49 ACCTD_UNEARNED_DISCOUNT_TAKEN 40 ACCTD_UNIDENTIFIED_AMOUNT -39.004 ACCTD_UNIDENTIFIED_AMT 44 ACCTD_WRITEOFF_AMOUNT 70 ANTICIPATED_CLEARING_DATE 80 APPLICATION_NOTES 24 APPLIED_AMOUNT 3 BALANCING_SEGMENT 2 4 BALANCING_SEGMENT_DESC 101 BAL_SEG_PIVOT_LABEL 95 BANK_ACCOUNT_CURRENCY 96 BANK_ACCOUNT_DESCRIPTION 92 BANK_ACCOUNT_NAME 93 BANK_ACCOUNT_NAME_ALT 94 BANK_ACCOUNT_NUMBER 91 BANK_BRANCH_COUNTRY 88 BANK_BRANCH_NAME 89 BANK_BRANCH_NAME_ALT 85 BANK_NAME 86 BANK_NAME_ALT 87 BANK_NUMBER 16 BATCH_NAME 17 BATCH_SOURCE 90 BRANCH_NUMBER 29 CASH_CLAIMS_AMOUNT 106 CASH_RECEIPT_ID 32 CHARGEBACK_AMOUNT 13 COLLECTOR 14 COLLECTOR_ACCOUNT 15 COLLECTOR_SITE 10 CUSTOMER_ADDRESS 11 CUSTOMER_COUNTRY 9 CUSTOMER_LOCATION 6 CUSTOMER_NAME 5 8 CUSTOMER_NAME_ALT 7 CUSTOMER_NUMBER 74 CUSTOMER_RECEIPT_REFERENCE 12 CUSTOMER_TAX_NUMBER 103 CUST_NAME_PIVOT_LABEL 104 CUST_NUMBER_PIVOT_LABEL 57 DEBIT_ACCOUNT 97 DEBIT_ACCOUNT_DESC 100 DEBIT_ACCOUNT_PIVOT_LABEL 69 DEPOSIT_DATE 58 DOC_SEQUENCE_NAME 59 DOC_SEQUENCE_VALUE 34 EARNED_DISCOUNT_TAKEN 77 EXCHANGE_DATE 76 EXCHANGE_RATE 78 EXCHANGE_RATE_TYPE 23 FACTOR_DISCOUNT_AMOUNT 53 FIRST_APPLIED_IN_FULL_DATE 56 FIRST_APPLIED_IN_FULL_GL_DATE 51 FIRST_APPLY_DATE 54 FIRST_APPLY_GL_DATE 20 GL_DATE 68 ISSUE_DATE 52 LAST_APPLY_DATE 55 LAST_APPLY_GL_DATE 1 LEDGER 1 2 LEDGER_CURRENCY 28 MISCELLANEOUS_AMOUNT 71 MISC_PAYMENT_SOURCE 25 ON_ACCOUNT_AMOUNT 5 OPERATING_UNIT 22 RECEIPT_AMOUNT 79 RECEIPT_COMMENTS 65 RECEIPT_CREATED_BY 64 RECEIPT_CREATION_DATE 21 RECEIPT_CURRENCY 3 19 RECEIPT_DATE 4 63 RECEIPT_HISTORY_STATUS 67 RECEIPT_LAST_UPDATED_BY 66 RECEIPT_LAST_UPDATED_DATE 61 RECEIPT_METHOD 18 RECEIPT_NUMBER 6 62 RECEIPT_STATUS 60 RECEIPT_TYPE 73 REFERENCE_NUMBER 72 REFERENCE_TYPE 31 REFUND_AMOUNT 105 REPORTING_ENTITY 82 REVERSAL_CATEGORY 84 REVERSAL_COMMENTS 81 REVERSAL_DATE 83 REVERSAL_REASON 33 SHORT_TERM_DEBT_AMOUNT 75 TAX_CODE 27 UNAPPLIED_AMOUNT -26.0027 UNAPPLIED_AMT 35 UNEARNED_DISCOUNT_TAKEN 26 UNIDENTIFIED_AMOUNT 30 WRITEOFF_AMOUNT ACCOUNT_SEGMENT FILTER 3 ACCTD_AMT_APPLIED_FROM_RECEIPT VALUE 5 SUM ACCTD_AMT_APPLIED_TO_TRX VALUE 6 SUM ACCTD_APPLIED_AMOUNT VALUE 3 SUM ACCTD_CASH_CLAIMS_AMOUNT VALUE 8 SUM ACCTD_CHARGEBACK_AMOUNT VALUE 11 SUM ACCTD_EARNED_DISCOUNT_TAKEN VALUE 13 SUM ACCTD_FACTOR_DISCOUNT_AMOUNT VALUE 2 SUM ACCTD_GAIN_LOSS VALUE 15 SUM ACCTD_MISCELLANEOUS_AMOUNT VALUE 7 SUM ACCTD_ON_ACCOUNT_AMOUNT VALUE 4 SUM ACCTD_RECEIPT_AMOUNT VALUE 1 SUM ACCTD_REFUND_AMOUNT VALUE 10 SUM ACCTD_SHORT_TERM_DEBT_AMOUNT VALUE 12 SUM ACCTD_UNAPPLIED_AMOUNT VALUE 6 SUM ACCTD_UNAPPLIED_AMT VALUE 6 SUM ACCTD_UNEARNED_DISCOUNT_TAKEN VALUE 14 SUM ACCTD_UNIDENTIFIED_AMOUNT VALUE 5 SUM ACCTD_UNIDENTIFIED_AMT VALUE 5 SUM ACCTD_WRITEOFF_AMOUNT VALUE 9 SUM AMOUNT_APPLIED_FROM_RECEIPT VALUE 1 SUM AMOUNT_APPLIED_TO_TRX VALUE 2 SUM APPLY_DATE ROW 3 BALANCING_SEGMENT FILTER 2 BAL_SEG_PIVOT_LABEL ROW 1 BATCH_SOURCE FILTER 7 CUSTOMER_NAME FILTER 5 CUSTOMER_NUMBER FILTER 6 LEDGER FILTER 1 OPERATING_UNIT FILTER 4 RECEIPT_CURRENCY ROW 2 RECEIPT_GAIN_LOSS VALUE 7 SUM S Site Pivot: Summary by Receipt Status Y Pivot: Summary by Balancing Segment, Receipt Status with drilldown to details SYSADMIN 102 ACCOUNT_PIVOT_LABEL 98 ACCOUNT_SEGMENT 99 ACCOUNT_SEGMENT_DESC 38 ACCTD_APPLIED_AMOUNT 43 ACCTD_CASH_CLAIMS_AMOUNT 46 ACCTD_CHARGEBACK_AMOUNT 48 ACCTD_EARNED_DISCOUNT_TAKEN 37 ACCTD_FACTOR_DISCOUNT_AMOUNT 50 ACCTD_GAIN_LOSS 42 ACCTD_MISCELLANEOUS_AMOUNT 39 ACCTD_ON_ACCOUNT_AMOUNT 36 ACCTD_RECEIPT_AMOUNT 45 ACCTD_REFUND_AMOUNT 47 ACCTD_SHORT_TERM_DEBT_AMOUNT 41 ACCTD_UNAPPLIED_AMOUNT -35.0037 ACCTD_UNAPPLIED_AMT 49 ACCTD_UNEARNED_DISCOUNT_TAKEN 40 ACCTD_UNIDENTIFIED_AMOUNT -35.0036 ACCTD_UNIDENTIFIED_AMT 44 ACCTD_WRITEOFF_AMOUNT 70 ANTICIPATED_CLEARING_DATE 80 APPLICATION_NOTES 24 APPLIED_AMOUNT 3 BALANCING_SEGMENT 2 4 BALANCING_SEGMENT_DESC 101 BAL_SEG_PIVOT_LABEL 95 BANK_ACCOUNT_CURRENCY 96 BANK_ACCOUNT_DESCRIPTION 92 BANK_ACCOUNT_NAME 93 BANK_ACCOUNT_NAME_ALT 94 BANK_ACCOUNT_NUMBER 91 BANK_BRANCH_COUNTRY 88 BANK_BRANCH_NAME 89 BANK_BRANCH_NAME_ALT 85 BANK_NAME 86 BANK_NAME_ALT 87 BANK_NUMBER 16 BATCH_NAME 17 BATCH_SOURCE 90 BRANCH_NUMBER 29 CASH_CLAIMS_AMOUNT 106 CASH_RECEIPT_ID 32 CHARGEBACK_AMOUNT 13 COLLECTOR 14 COLLECTOR_ACCOUNT 15 COLLECTOR_SITE 10 CUSTOMER_ADDRESS 11 CUSTOMER_COUNTRY 9 CUSTOMER_LOCATION 6 CUSTOMER_NAME 5 8 CUSTOMER_NAME_ALT 7 CUSTOMER_NUMBER 74 CUSTOMER_RECEIPT_REFERENCE 12 CUSTOMER_TAX_NUMBER 103 CUST_NAME_PIVOT_LABEL 104 CUST_NUMBER_PIVOT_LABEL 57 DEBIT_ACCOUNT 97 DEBIT_ACCOUNT_DESC 100 DEBIT_ACCOUNT_PIVOT_LABEL 69 DEPOSIT_DATE 58 DOC_SEQUENCE_NAME 59 DOC_SEQUENCE_VALUE 34 EARNED_DISCOUNT_TAKEN 77 EXCHANGE_DATE 76 EXCHANGE_RATE 78 EXCHANGE_RATE_TYPE 23 FACTOR_DISCOUNT_AMOUNT 53 FIRST_APPLIED_IN_FULL_DATE 56 FIRST_APPLIED_IN_FULL_GL_DATE 51 FIRST_APPLY_DATE 54 FIRST_APPLY_GL_DATE 20 GL_DATE 68 ISSUE_DATE 52 LAST_APPLY_DATE 55 LAST_APPLY_GL_DATE 1 LEDGER 1 2 LEDGER_CURRENCY 28 MISCELLANEOUS_AMOUNT 71 MISC_PAYMENT_SOURCE 25 ON_ACCOUNT_AMOUNT 5 OPERATING_UNIT 22 RECEIPT_AMOUNT 79 RECEIPT_COMMENTS 65 RECEIPT_CREATED_BY 64 RECEIPT_CREATION_DATE 21 RECEIPT_CURRENCY 3 19 RECEIPT_DATE 63 RECEIPT_HISTORY_STATUS 67 RECEIPT_LAST_UPDATED_BY 66 RECEIPT_LAST_UPDATED_DATE 61 RECEIPT_METHOD 18 RECEIPT_NUMBER 6 62 RECEIPT_STATUS 60 RECEIPT_TYPE 73 REFERENCE_NUMBER 72 REFERENCE_TYPE 31 REFUND_AMOUNT 105 REPORTING_ENTITY 82 REVERSAL_CATEGORY 84 REVERSAL_COMMENTS 81 REVERSAL_DATE 83 REVERSAL_REASON 33 SHORT_TERM_DEBT_AMOUNT 75 TAX_CODE 27 UNAPPLIED_AMOUNT -26.0027 UNAPPLIED_AMT 35 UNEARNED_DISCOUNT_TAKEN 26 UNIDENTIFIED_AMOUNT 30 WRITEOFF_AMOUNT ACCOUNT_SEGMENT FILTER 3 ACCTD_AMT_APPLIED_FROM_RECEIPT VALUE 5 SUM ACCTD_AMT_APPLIED_TO_TRX VALUE 6 SUM ACCTD_APPLIED_AMOUNT VALUE 17 SUM ACCTD_CASH_CLAIMS_AMOUNT VALUE 22 SUM ACCTD_CHARGEBACK_AMOUNT VALUE 25 SUM ACCTD_EARNED_DISCOUNT_TAKEN VALUE 27 SUM ACCTD_FACTOR_DISCOUNT_AMOUNT VALUE 16 SUM ACCTD_GAIN_LOSS VALUE 29 SUM ACCTD_MISCELLANEOUS_AMOUNT VALUE 21 SUM ACCTD_ON_ACCOUNT_AMOUNT VALUE 18 SUM ACCTD_RECEIPT_AMOUNT VALUE 15 SUM ACCTD_REFUND_AMOUNT VALUE 24 SUM ACCTD_SHORT_TERM_DEBT_AMOUNT VALUE 26 SUM ACCTD_UNAPPLIED_AMOUNT VALUE 20 SUM ACCTD_UNAPPLIED_AMT VALUE 18 SUM ACCTD_UNEARNED_DISCOUNT_TAKEN VALUE 28 SUM ACCTD_UNIDENTIFIED_AMOUNT VALUE 19 SUM ACCTD_UNIDENTIFIED_AMT VALUE 17 SUM ACCTD_WRITEOFF_AMOUNT VALUE 23 SUM AMOUNT_APPLIED_FROM_RECEIPT VALUE 1 SUM AMOUNT_APPLIED_TO_TRX VALUE 2 SUM APPLIED_AMOUNT VALUE 3 SUM APPLY_GL_DATE ROW 3 BALANCING_SEGMENT FILTER 2 BAL_SEG_PIVOT_LABEL ROW 1 BATCH_SOURCE FILTER 7 CASH_CLAIMS_AMOUNT VALUE 8 SUM CHARGEBACK_AMOUNT VALUE 11 SUM CUSTOMER_NAME FILTER 5 CUSTOMER_NUMBER FILTER 6 EARNED_DISCOUNT_TAKEN VALUE 13 SUM FACTOR_DISCOUNT_AMOUNT VALUE 2 SUM LEDGER FILTER 1 MISCELLANEOUS_AMOUNT VALUE 7 SUM ON_ACCOUNT_AMOUNT VALUE 4 SUM OPERATING_UNIT FILTER 4 RECEIPT_AMOUNT VALUE 1 SUM RECEIPT_GAIN_LOSS VALUE 7 SUM RECEIPT_STATUS ROW 2 REFUND_AMOUNT VALUE 10 SUM SHORT_TERM_DEBT_AMOUNT VALUE 12 SUM UNAPPLIED_AMOUNT VALUE 6 SUM UNAPPLIED_AMT VALUE 6 SUM UNEARNED_DISCOUNT_TAKEN VALUE 14 SUM UNIDENTIFIED_AMOUNT VALUE 5 SUM WRITEOFF_AMOUNT VALUE 9 SUM S Site Pivot: Summary by Receipt Status - Accounted Currency Y Pivot: Summary by Balancing Segment, Receipt Status with drilldown to details SYSADMIN 102 ACCOUNT_PIVOT_LABEL 98 ACCOUNT_SEGMENT 99 ACCOUNT_SEGMENT_DESC 38 ACCTD_APPLIED_AMOUNT 43 ACCTD_CASH_CLAIMS_AMOUNT 46 ACCTD_CHARGEBACK_AMOUNT 48 ACCTD_EARNED_DISCOUNT_TAKEN 37 ACCTD_FACTOR_DISCOUNT_AMOUNT 50 ACCTD_GAIN_LOSS 42 ACCTD_MISCELLANEOUS_AMOUNT 39 ACCTD_ON_ACCOUNT_AMOUNT 36 ACCTD_RECEIPT_AMOUNT 45 ACCTD_REFUND_AMOUNT 47 ACCTD_SHORT_TERM_DEBT_AMOUNT 41 ACCTD_UNAPPLIED_AMOUNT -39.0041 ACCTD_UNAPPLIED_AMT 49 ACCTD_UNEARNED_DISCOUNT_TAKEN 40 ACCTD_UNIDENTIFIED_AMOUNT -39.004 ACCTD_UNIDENTIFIED_AMT 44 ACCTD_WRITEOFF_AMOUNT 70 ANTICIPATED_CLEARING_DATE 80 APPLICATION_NOTES 24 APPLIED_AMOUNT 3 BALANCING_SEGMENT 2 4 BALANCING_SEGMENT_DESC 101 BAL_SEG_PIVOT_LABEL 95 BANK_ACCOUNT_CURRENCY 96 BANK_ACCOUNT_DESCRIPTION 92 BANK_ACCOUNT_NAME 93 BANK_ACCOUNT_NAME_ALT 94 BANK_ACCOUNT_NUMBER 91 BANK_BRANCH_COUNTRY 88 BANK_BRANCH_NAME 89 BANK_BRANCH_NAME_ALT 85 BANK_NAME 86 BANK_NAME_ALT 87 BANK_NUMBER 16 BATCH_NAME 17 BATCH_SOURCE 90 BRANCH_NUMBER 29 CASH_CLAIMS_AMOUNT 106 CASH_RECEIPT_ID 32 CHARGEBACK_AMOUNT 13 COLLECTOR 14 COLLECTOR_ACCOUNT 15 COLLECTOR_SITE 10 CUSTOMER_ADDRESS 11 CUSTOMER_COUNTRY 9 CUSTOMER_LOCATION 6 CUSTOMER_NAME 5 8 CUSTOMER_NAME_ALT 7 CUSTOMER_NUMBER 74 CUSTOMER_RECEIPT_REFERENCE 12 CUSTOMER_TAX_NUMBER 103 CUST_NAME_PIVOT_LABEL 104 CUST_NUMBER_PIVOT_LABEL 57 DEBIT_ACCOUNT 97 DEBIT_ACCOUNT_DESC 100 DEBIT_ACCOUNT_PIVOT_LABEL 69 DEPOSIT_DATE 58 DOC_SEQUENCE_NAME 59 DOC_SEQUENCE_VALUE 34 EARNED_DISCOUNT_TAKEN 77 EXCHANGE_DATE 76 EXCHANGE_RATE 78 EXCHANGE_RATE_TYPE 23 FACTOR_DISCOUNT_AMOUNT 53 FIRST_APPLIED_IN_FULL_DATE 56 FIRST_APPLIED_IN_FULL_GL_DATE 51 FIRST_APPLY_DATE 54 FIRST_APPLY_GL_DATE 20 GL_DATE 68 ISSUE_DATE 52 LAST_APPLY_DATE 55 LAST_APPLY_GL_DATE 1 LEDGER 1 2 LEDGER_CURRENCY 28 MISCELLANEOUS_AMOUNT 71 MISC_PAYMENT_SOURCE 25 ON_ACCOUNT_AMOUNT 5 OPERATING_UNIT 22 RECEIPT_AMOUNT 79 RECEIPT_COMMENTS 65 RECEIPT_CREATED_BY 64 RECEIPT_CREATION_DATE 21 RECEIPT_CURRENCY 3 19 RECEIPT_DATE 63 RECEIPT_HISTORY_STATUS 67 RECEIPT_LAST_UPDATED_BY 66 RECEIPT_LAST_UPDATED_DATE 61 RECEIPT_METHOD 18 RECEIPT_NUMBER 6 62 RECEIPT_STATUS 60 RECEIPT_TYPE 73 REFERENCE_NUMBER 72 REFERENCE_TYPE 31 REFUND_AMOUNT 105 REPORTING_ENTITY 82 REVERSAL_CATEGORY 84 REVERSAL_COMMENTS 81 REVERSAL_DATE 83 REVERSAL_REASON 33 SHORT_TERM_DEBT_AMOUNT 75 TAX_CODE 27 UNAPPLIED_AMOUNT -26.0027 UNAPPLIED_AMT 35 UNEARNED_DISCOUNT_TAKEN 26 UNIDENTIFIED_AMOUNT 30 WRITEOFF_AMOUNT ACCOUNT_SEGMENT FILTER 3 ACCTD_AMT_APPLIED_FROM_RECEIPT VALUE 5 SUM ACCTD_AMT_APPLIED_TO_TRX VALUE 6 SUM ACCTD_APPLIED_AMOUNT VALUE 3 SUM ACCTD_CASH_CLAIMS_AMOUNT VALUE 8 SUM ACCTD_CHARGEBACK_AMOUNT VALUE 11 SUM ACCTD_EARNED_DISCOUNT_TAKEN VALUE 13 SUM ACCTD_FACTOR_DISCOUNT_AMOUNT VALUE 2 SUM ACCTD_GAIN_LOSS VALUE 15 SUM ACCTD_MISCELLANEOUS_AMOUNT VALUE 7 SUM ACCTD_ON_ACCOUNT_AMOUNT VALUE 4 SUM ACCTD_RECEIPT_AMOUNT VALUE 1 SUM ACCTD_REFUND_AMOUNT VALUE 10 SUM ACCTD_SHORT_TERM_DEBT_AMOUNT VALUE 12 SUM ACCTD_UNAPPLIED_AMOUNT VALUE 6 SUM ACCTD_UNAPPLIED_AMT VALUE 6 SUM ACCTD_UNEARNED_DISCOUNT_TAKEN VALUE 14 SUM ACCTD_UNIDENTIFIED_AMOUNT VALUE 5 SUM ACCTD_UNIDENTIFIED_AMT VALUE 5 SUM ACCTD_WRITEOFF_AMOUNT VALUE 9 SUM AMOUNT_APPLIED_FROM_RECEIPT VALUE 1 SUM AMOUNT_APPLIED_TO_TRX VALUE 2 SUM APPLY_GL_DATE ROW 3 BALANCING_SEGMENT FILTER 2 BAL_SEG_PIVOT_LABEL ROW 1 BATCH_SOURCE FILTER 7 CUSTOMER_NAME FILTER 5 CUSTOMER_NUMBER FILTER 6 LEDGER FILTER 1 OPERATING_UNIT FILTER 4 RECEIPT_GAIN_LOSS VALUE 7 SUM RECEIPT_STATUS ROW 2 S Site SYSADMIN Pivot: Summary by Receipt Status - Accounted Currency DEVELOPER Pivot: Summary by Customer Name - Accounted Currency ANDY.HAACK Pivot: Summary by Customer Name Default: Detail