JE Belgian VAT Annual Audit

➜ Back to Library
Description
Categories: BI Publisher
Columns: Ar Doc Seq Value, Ar Customer Name, Ar Address1, Ar Customer Number, Ar Postal Code, Ar City, Ar Class, Ar Doc Number, Ar Invoice Type, Ar Tax Reference ...
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 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
Calling Report 
 
Download
Related Blitz Reports
JG EMEA VAT: Turnover AR Non TRL Extract JE Belgian VAT Purchases Journal JG EMEA VAT: Journal AP Extract JE Portuguese Suppliers Recapitulative JE Italian Purchase VAT Register JG EMEA VAT: Summary AP Extract JE EMEA VAT: Spanish Modelo Extract JE Spanish Annual Modelo Magnetic Format JE Czech Export Tax
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: