JE Belgian VAT Annual Audit
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 ...
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
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 | |
|---|---|---|---|
| Calling Report |
|
||
| Report Format |
|
LOV Oracle | |
| Customer Name To |
|
LOV Oracle | |
| Customer Name From |
|
LOV Oracle | |
| Minimum Declared Amount |
|
Number | |
| Tax Calendar Year |
|
LOV Oracle | |
| Reporting Identifier |