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
Run JE Belgian VAT Annual Audit and other Oracle EBS reports with Blitz Report™ on our demo environment
   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 Name SQL text Validation
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
JG EMEA VAT: Audit AR Extract JE Spanish Input VAT Journal JE Spanish Periodic Modelo JE EMEA VAT: Spanish Modelo Extract JE Spanish Annual Modelo Magnetic Format JE Czech Export Tax JE Belgian VAT Purchases Journal JG EMEA VAT: Summary AP Extract JG EMEA VAT: Journal AP Extract
Blitz Report™

Blitz Report™ provides multiple benefits:

Blitz Report™