ZX Financial Tax Register
Description
Categories: Enginatics, R12 only
Repository: Github
Repository: Github
Imported from Concurrent Program
Description: Rx-only: Financial Tax Register
Application: E-Business Tax
Source: RX-only: Financial Tax Register Report
Short Name: RXZXPTEX
Description: Rx-only: Financial Tax Register
Application: E-Business Tax
Source: RX-only: Financial Tax Register Report
Short Name: RXZXPTEX
select zrev.gdf_ra_addresses_ship_att9 gdf_ra_addresses_ship_att9, zrev.country_of_supply country_of_supply, zrev.start_expense_date start_expense_date, zrev.tax_exemption_id tax_exemption_id, zrev.tax_exception_id tax_exception_id, zrev.exempt_certificate_number exempt_certificate_number, zrev.exempt_reason_code exempt_reason_code, zrev.tax_exempt_reason_mng tax_exempt_reason_mng, zrev.tax_exception_reason_code tax_exception_reason_code, zrev.tax_exception_reason_mng tax_exception_reason_mng, zrev.tax_line_user_category tax_line_user_category, zrev.tax_line_user_attribute1 tax_line_user_attribute1, zrev.tax_line_user_attribute2 tax_line_user_attribute2, zrev.tax_line_user_attribute3 tax_line_user_attribute3, zrev.tax_line_user_attribute4 tax_line_user_attribute4, zrev.tax_line_user_attribute5 tax_line_user_attribute5, zrev.tax_line_user_attribute6 tax_line_user_attribute6, zrev.tax_line_user_attribute7 tax_line_user_attribute7, zrev.tax_line_user_attribute8 tax_line_user_attribute8, zrev.tax_line_user_attribute9 tax_line_user_attribute9, zrev.tax_line_user_attribute10 tax_line_user_attribute10, zrev.tax_line_user_attribute11 tax_line_user_attribute11, zrev.tax_line_user_attribute12 tax_line_user_attribute12, zrev.tax_line_user_attribute13 tax_line_user_attribute13, zrev.tax_line_user_attribute14 tax_line_user_attribute14, zrev.tax_line_user_attribute15 tax_line_user_attribute15, zrev.tax_amt tax_amount, zrev.tax_amt_funcl_curr tax_accounted_amount, zrev.tax_line_number tax_line_number, zrev.taxable_amt taxable_amount, zrev.taxable_amt_funcl_curr taxable_accounted_amount, zrev.total_entered_amount total_entered_amount, zrev.total_accounted_amount total_accounted_amount, zrev.taxable_disc_amt taxable_discount_amount, zrev.taxable_disc_amt_funcl_curr taxable_discount_accounted_amount, zrev.tax_disc_amt tax_discount_amount, zrev.tax_disc_amt_funcl_curr tax_discount_accounted_amount, zrev.trx_line_number trx_line_number, zrev.taxable_line_source_table taxable_line_source_table, zrev.trx_line_description trx_line_description, zrev.product_id product_id, zrev.taxable_line_item_flexfield taxable_line_item_flexfield, zrev.product_description product_description, zrev.trx_line_quantity trx_line_quantity, zrev.uom_code uom_code, zrev.trx_quantity_uom_mng trx_quantity_uom_mng, zrev.trx_line_type trx_line_type, zrev.actg_event_id actg_event_id, zrev.actg_event_type_code actg_event_type_code, zrev.actg_event_type_mng actg_event_type_mng, zrev.actg_event_number actg_event_number, zrev.actg_event_status_flag actg_event_status_flag, zrev.actg_event_status_mng actg_event_status_mng, zrev.actg_source_table actg_source_table, zrev.actg_source_id actg_source_id, zrev.actg_header_id actg_header_id, zrev.actg_category_code actg_category_code, zrev.actg_category_mng actg_category_mng, zrev.period_name period_name, zrev.gl_transfer_flag gl_transfer_flag, zrev.gl_transfer_run_id gl_transfer_run_id, zrev.actg_header_description actg_header_description, zrev.actg_line_num actg_line_num, zrev.actg_line_type_code actg_line_type_code, zrev.actg_line_type_mng actg_line_type_mng, zrev.actg_line_ccid actg_line_ccid, zrev.account_flexfield account_flexfield, zrev.account_description account_description, zrev.actg_line_description actg_line_description, zrev.actg_stat_amt actg_stat_amount, zrev.actg_error_code actg_error_code, zrev.gl_transfer_code gl_transfer_code, zrev.actg_doc_sequence_id actg_doc_sequence_id, zrev.actg_doc_sequence_name actg_doc_sequence_name, zrev.actg_doc_sequence_value actg_doc_sequence_value, zrev.actg_party_id actg_party_id, zrev.actg_party_site_id actg_party_site_id, zrev.trx_arap_balancing_segment trx_arap_balancing_segment, zrev.trx_arap_natural_account trx_arap_natural_account, zrev.trx_taxable_balancing_segment trx_taxable_balancing_segment, zrev.trx_taxable_natural_account trx_taxable_natural_account, zrev.trx_tax_balancing_segment trx_tax_balancing_segment, zrev.trx_tax_natural_account trx_tax_natural_account, zrev.trx_taxable_account trx_taxable_account, zrev.trx_taxable_account_desc trx_taxable_account_desc, zrev.trx_taxable_balseg_desc trx_taxable_balseg_desc, zrev.trx_taxable_natacct_seg_desc trx_taxable_natacct_seg_desc, zrev.numeric1 numeric1, zrev.numeric2 numeric2, zrev.numeric3 numeric3, zrev.numeric4 numeric4, zrev.numeric5 numeric5, zrev.numeric6 numeric6, zrev.numeric7 numeric7, zrev.numeric8 numeric8, zrev.numeric9 numeric9, zrev.numeric10 numeric10, zrev.numeric11 numeric11, zrev.numeric12 numeric12, zrev.numeric13 numeric13, zrev.numeric14 numeric14, zrev.numeric15 numeric15, zrev.numeric16 numeric16, zrev.attribute1 attribute1, zrev.attribute2 attribute2, zrev.attribute3 attribute3, zrev.attribute4 attribute4, zrev.attribute5 attribute5, zrev.attribute6 attribute6, zrev.attribute7 attribute7, zrev.attribute8 attribute8, zrev.attribute9 attribute9, zrev.attribute10 attribute10, zrev.attribute11 attribute11, zrev.attribute12 attribute12, zrev.attribute13 attribute13, zrev.attribute14 attribute14, zrev.attribute15 attribute15, zrev.attribute16 attribute16, zrev.attribute17 attribute17, zrev.attribute18 attribute18, zrev.business_loc_address business_loc_address, zrev.document_sub_type_mng document_sub_type_mng, zrev.tax_status_mng tax_status_mng, zrev.trx_business_category_mng trx_business_category_mng, zrev.gdf_ap_invoices_att2 gdf_ap_invoices_att2, zrev.gdf_ap_invoices_att3 gdf_ap_invoices_att3, zrev.gdf_ap_invoices_att4 gdf_ap_invoices_att4, zrev.gdf_ap_invoices_att11 gdf_ap_invoices_att11, zrev.gdf_ap_invoices_att12 gdf_ap_invoices_att12, zrev.gdf_ap_invoices_att13 gdf_ap_invoices_att13, zrev.gdf_ap_invoice_dist_att1 gdf_ap_invoice_dist_att1, zrev.gdf_po_vendor_sites_att17 gdf_po_vendor_sites_att17, zrev.gdf_ra_cust_bill_att10 gdf_ra_cust_bill_att10, zrev.gdf_ra_cust_bill_att12 gdf_ra_cust_bill_att12, zrev.gdf_party_sites_bill_att8 gdf_party_sites_bill_att8, zrev.gdf_party_sites_bill_att9 gdf_party_sites_bill_att9, zrev.gdf_ra_cust_trx_att3 gdf_ra_cust_trx_att3, zrev.gdf_ra_cust_trx_att4 gdf_ra_cust_trx_att4, zrev.gdf_ra_cust_trx_att5 gdf_ra_cust_trx_att5, zrev.gdf_ra_cust_trx_att6 gdf_ra_cust_trx_att6, zrev.gdf_ra_cust_trx_att7 gdf_ra_cust_trx_att7, zrev.gdf_ra_cust_trx_att8 gdf_ra_cust_trx_att8, zrev.gdf_ra_cust_trx_att9 gdf_ra_cust_trx_att9, zrev.gdf_ra_cust_trx_att19 gdf_ra_cust_trx_att19, zrev.gdf_ra_cust_trx_lines_att1 gdf_ra_cust_trx_lines_att1, zrev.gdf_ra_cust_trx_lines_att2 gdf_ra_cust_trx_lines_att2, zrev.gdf_ra_cust_trx_types_att5 gdf_ra_cust_trx_types_att5, zrev.gdf_ra_cust_trx_types_att6 gdf_ra_cust_trx_types_att6, zrev.gdf_ra_cust_trx_types_att7 gdf_ra_cust_trx_types_att7, zrev.gdf_ra_batch_sources_att1 gdf_ra_batch_sources_att1, zrev.gdf_ra_batch_sources_att2 gdf_ra_batch_sources_att2, zrev.gdf_ra_batch_sources_att3 gdf_ra_batch_sources_att3, zrev.gdf_ra_batch_sources_att4 gdf_ra_batch_sources_att4, zrev.ledger_id ledger_id, zrev.chart_of_accounts_id chart_of_accounts_id, zrev.detail_tax_line_id detail_tax_line_id, zrev.extract_source_ledger extract_source_ledger, zrev.extract_report_line_number extract_report_line_number, zrev.rep_entity_id rep_entity_id, zrev.legal_entity_tax_reg_number legal_entity_tax_reg_number, zrev.org_information2 org_information2, zrev.rep_context_lvl_code rep_context_lvl_code, zrev.rep_context_lvl_mng rep_context_lvl_mng, zrev.taxpayer_id taxpayer_id, zrev.rep_context_entity_name rep_context_entity_name, zrev.rep_context_entity_location_id rep_context_entity_location_id, zrev.rep_context_entity_city rep_context_entity_city, zrev.rep_context_entity_county rep_context_entity_county, zrev.rep_context_entity_state rep_context_entity_state, zrev.rep_context_entity_province rep_context_entity_province, zrev.rep_context_entity_address1 rep_context_entity_address1, zrev.rep_context_entity_address2 rep_context_entity_address2, zrev.rep_context_entity_address3 rep_context_entity_address3, zrev.rep_context_entity_country rep_context_entity_country, zrev.rep_context_entity_postal_code rep_context_entity_postal_code, zrev.rep_context_entity_tel_number rep_context_entity_tel_number, zrev.ledger_name ledger_name, zrev.functional_currency_code functional_currency, zrev.trx_id trx_id, zrev.trx_number trx_number, zrev.trx_description trx_description, zrev.doc_seq_id doc_seq_id, zrev.doc_seq_name doc_seq_name, zrev.doc_seq_value doc_seq_value, zrev.trx_date trx_date, zrev.trx_line_class tax_class, zrev.trx_line_class trx_line_class, zrev.trx_class_mng trx_class, zrev.trx_type_id trx_type_id, zrev.trx_type_mng trx_type, zrev.applied_from_entity_code applied_from_entity_code, zrev.applied_from_trx_id applied_from_trx_id, zrev.applied_from_event_class_code applied_from_event_class_code, zrev.trx_applied_from_class_mng trx_applied_from_class_mng, zrev.applied_from_trx_number applied_from_trx_number, zrev.adjusted_doc_entity_code adjusted_doc_entity_code, zrev.adjusted_doc_trx_id adjusted_doc_trx_id, zrev.adjusted_doc_event_class_code adjusted_doc_event_class_code, zrev.adjusted_doc_number adjusted_doc_number, zrev.adjusted_doc_date adjusted_doc_date, zrev.trx_applied_to_class_mng related_transaction_class, zrev.applied_to_trx_number related_transaction, zrev.trx_type_description trx_type_description, zrev.trx_due_date trx_due_date, zrev.trx_shipping_date trx_shipping_date, zrev.trx_communicated_date trx_communicated_date, zrev.trx_currency_code trx_currency_code, zrev.currency_conversion_type currency_conversion_type, zrev.currency_conversion_date currency_conversion_date, zrev.currency_conversion_rate currency_conversion_rate, zrev.reconciliation_flag reconciliation_flag, zrev.trx_tax_balancing_segment balancing_segment_value, zrev.trx_tax_balancing_segment company, zrev.trx_control_account_flexfield trx_control_account_flexfield, zrev.billing_trading_partner_id billing_trading_partner_id, zrev.billing_tp_site_id billing_tp_site_id, zrev.billing_tp_number billing_tp_number, zrev.billing_tp_tax_reg_num billing_tp_tax_reg_num, zrev.billing_tp_taxpayer_id billing_tp_taxpayer_id, zrev.billing_tp_site_name billing_tp_site_name, zrev.billing_tp_site_name_alt billing_tp_site_name_alt, zrev.billing_tp_site_tax_reg_num billing_tp_site_tax_reg_num, zrev.billing_tp_tax_reporting_flag billing_tp_tax_reporting_flag, zrev.billing_tp_name billing_tp_name, zrev.billing_tp_name_alt billing_tp_name_alt, zrev.billing_tp_sic_code billing_tp_sic_code, zrev.billing_tp_address_id billing_tp_address_id, zrev.billing_tp_city billing_tp_city, zrev.billing_tp_county billing_tp_county, zrev.billing_tp_state billing_tp_state, zrev.billing_tp_province billing_tp_province, zrev.billing_tp_address1 billing_tp_address1, zrev.billing_tp_address2 billing_tp_address2, zrev.billing_tp_address3 billing_tp_address3, zrev.billing_tp_address_lines_alt billing_tp_address_lines_alt, zrev.billing_tp_country billing_tp_country, zrev.billing_tp_postal_code billing_tp_postal_code, zrev.shipping_trading_partner_id shipping_trading_partner_id, zrev.shipping_tp_site_id shipping_tp_site_id, zrev.shipping_tp_number shipping_tp_number, zrev.shipping_tp_tax_reg_num shipping_tp_tax_reg_num, zrev.shipping_tp_taxpayer_id shipping_tp_taxpayer_id, zrev.shipping_tp_site_name shipping_tp_site_name, zrev.shipping_tp_site_tax_reg_num shipping_tp_site_tax_reg_num, zrev.shipping_tp_name shipping_tp_name, zrev.shipping_tp_name_alt shipping_tp_name_alt, zrev.shipping_tp_sic_code shipping_tp_sic_code, zrev.shipping_tp_address_id shipping_tp_address_id, zrev.shipping_tp_city shipping_tp_city, zrev.shipping_tp_county shipping_tp_county, zrev.shipping_tp_state shipping_tp_state, zrev.shipping_tp_province shipping_tp_province, zrev.shipping_tp_address1 shipping_tp_address1, zrev.gdf_ra_batch_sources_att7 gdf_ra_batch_sources_att7, zrev.gdf_ra_addresses_bill_att9 gdf_ra_addresses_bill_att9, zrev.shipping_tp_address2 shipping_tp_address2, zrev.shipping_tp_address3 shipping_tp_address3, zrev.shipping_tp_address_lines_alt shipping_tp_address_lines_alt, zrev.shipping_tp_country shipping_tp_country, zrev.shipping_tp_postal_code shipping_tp_postal_code, zrev.banking_tp_name banking_tp_name, zrev.banking_tp_taxpayer_id banking_tp_taxpayer_id, zrev.trx_batch_source_name trx_batch_source_name, zrev.trx_sic_code trx_sic_code, zrev.fob_point fob_point, zrev.trx_waybill_number trx_waybill_number, zrev.posted_flag posted_flag, zrev.tax_rate_id tax_rate_id, zrev.tax_rate_code tax_rate_code, zrev.tax_rate tax_rate, zrev.tax_rate_vat_trx_type_code tax_rate_vat_trx_type_code, zrev.tax_rate_code_vat_trx_type_mng tax_rate_code_vat_trx_type_mng, zrev.tax_rate_vat_trx_type_desc tax_rate_vat_trx_type_desc, zrev.tax_rate_register_type_code tax_rate_register_type_code, zrev.tax_rate_code_reg_type_meaning tax_rate_code_reg_type_meaning, zrev.tax tax, zrev.tax_regime_code tax_regime_code, zrev.tax_status_code tax_status_code, zrev.tax_type_code tax_type_code, zrev.tax_type_mng tax_type_mng, zrev.tax_rate_code_name tax_rate_code_name, zrev.tax_rate_code_description tax_rate_code_description, zrev.tax_recoverable_flag tax_recoverable_flag, zrev.tax_recovery_rate tax_recovery_rate, zrev.merchant_party_document_number merchant_party_document_number, zrev.merchant_party_name merchant_party_name, zrev.merchant_party_reference merchant_party_reference, zrev.merchant_party_tax_reg_number merchant_party_tax_reg_number, zrev.merchant_party_taxpayer_id merchant_party_taxpayer_id, zrev.gl_date gl_date, -- to_number(to_char(zrev.trx_date,'YYYY')) trx_date_year, to_number(to_char(zrev.trx_date,'MM')) trx_date_month, to_number(to_char(zrev.gl_date,'YYYY')) gl_date_year, to_number(to_char(zrev.gl_date,'MM')) gl_date_month from zx_rep_extract_v zrev where request_id=fnd_global.conc_request_id order by zrev.tax_disc_amt_funcl_curr |
| Parameter Name | SQL text | Validation | |
|---|---|---|---|
| Reporting Level | LOV Oracle | ||
| Reporting Context | LOV Oracle | ||
| Company Name | LOV Oracle | ||
| Set of Books Currency | LOV Oracle | ||
| Register Type | LOV Oracle | ||
| Summary Level | LOV Oracle | ||
| Product | LOV Oracle | ||
| GL Date Low | Date | ||
| GL Date High | Date | ||
| Transaction Date Low | Date | ||
| Transaction Date High | Date | ||
| VAT Tax Transaction Type | LOV Oracle | ||
| Tax Type Low | LOV Oracle | ||
| Tax Type High | LOV Oracle | ||
| Tax Regime Code | LOV Oracle | ||
| Tax | LOV Oracle | ||
| Tax Jurisdiction | LOV Oracle | ||
| Tax Status Code | LOV Oracle | ||
| Tax Code Low | LOV Oracle | ||
| Tax Code High | LOV Oracle | ||
| Currency Code Low | LOV Oracle | ||
| Currency Code High | LOV Oracle | ||
| Transfer to GL | LOV Oracle | ||
| Accounting Status | LOV Oracle | ||
| AR Exemption Status | LOV Oracle | ||
| Transaction Number | Char | ||
| Include Standard Invoices | LOV | ||
| Include Debit Memos | LOV | ||
| Include Credit Memos | LOV | ||
| Include Prepayments | LOV | ||
| Include Mixed Invoices | LOV | ||
| Include Expense Reports | LOV | ||
| Include Invoices | LOV | ||
| Include Applications | LOV | ||
| Include Adjustments | LOV | ||
| Include Miscellaneous receipts | LOV | ||
| Include Bills Receivables | LOV | ||
| Include Accounting Segments | LOV | ||
| Include Discounts | LOV | ||
| Include Referenced Source | LOV |