JE Belgian VAT Annual Audit

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: European Localizations
Source: Belgian VAT Annual Audit Report
Short Name: JEBEVA17_XMLP
DB package: jg_zz_audit_ar_pkg
   SELECT jg_info_v1                           AR_DOC_SEQ_VALUE
         ,jg_info_v2                           AR_CUSTOMER_NAME
         ,jg_info_v3                           AR_ADDRESS1
         ,jg_info_v4                           AR_CUSTOMER_NUMBER
         ,jg_info_v5                           AR_POSTAL_CODE
         ,jg_info_v6                           AR_CITY
         ,jg_info_v7                           AR_CLASS
         ,jg_info_v8                           AR_DOC_NUMBER
         ,jg_info_v9                           AR_INVOICE_TYPE
         ,jg_info_v10                          AR_TAX_REFERENCE
         ,jg_info_v11                          AR_FUNCTIONAL_CURRENCY_CODE
         ,jg_info_v12                          AR_VAT_BOX
         ,jg_info_v13                          AR_VAT_BOX_DESC
         ,jg_info_v14                          AR_TRANSACTION_DESC
         ,jg_info_d1                           AR_DOCUMENT_DATE
         ,jg_info_d2                           AR_GL_DATE
         ,jg_info_d3                           AR_TAX_DATE
         ,jg_info_n1                           AR_TOTAL_AMOUNT
         ,jg_info_n2                           AR_TAXABLE_AMOUNT
         ,jg_info_n3                           AR_TAX_AMOUNT
   FROM jg_zz_vat_trx_gt
   WHERE (:p_report_name = 'AUDIT-AR' OR :p_report_name IS NULL)
   AND    NVL(jg_info_v30,'X') <> 'H'
Parameter NameSQL textValidation
Reporting Identifier
 
LOV Oracle
Tax Calendar Year
 
LOV Oracle
Minimum Declared Amount
 
Number
Customer Name From
 
LOV Oracle
Customer Name To
 
LOV Oracle
Report Format
 
LOV Oracle
Download
Related Blitz Reports
JE Portuguese Customers Recapitulative JG EMEA VAT: Turnover AR Non TRL Extract JE Italian Annual Customer Listing JG ECE Payables VAT Register JE Israeli VAT AP Detail Register JG EMEA VAT: Journal AP Extract JE Italian Annual Supplier Listing JE Spanish Inter-EU Invoices Journal JG EMEA VAT: Summary AP Extract JE Croatian Supplier Invoice Tax
Blitz Report™