JE French Deductible VAT Declaration

➜ Back to Library
Description
Categories: BI Publisher
Columns: Ven Name, Ven No, Inv Type, Tax Amt, Rec Per, Company, Acc No, Tax Rate, Tax Id, Offset Tax Rate Code ...
Application: European Localizations
Source: French Deductible VAT Declaration Report
Short Name: JEFRTXDC_XMLP
DB package: JE_ZZ_AUDIT_AP_PKG 
    SELECT     jg_info_v1                     ven_name
              ,jg_info_v2                     ven_no
              ,jg_info_v3                     inv_type
              ,jg_info_n1                     tax_amt
              ,jg_info_n2                     rec_per
              ,jg_info_v4                     company
              ,jg_info_v5                     acc_no
              ,jg_info_n3                     tax_rate
              ,jg_info_v6                     tax_id
              ,jg_info_v7                     offset_tax_rate_code
              ,jg_info_v8                     tax_type
              ,jg_info_v9                     inv_no
              ,TO_CHAR(jg_info_d1,'DD-MON-RRRR')                     acc_date
              ,jg_info_n4                     invoice_id
              ,TO_CHAR(jg_info_d2,'DD-MON-RRRR')                     cancelled_date
              ,jg_info_n5                     item_line_cnt
              ,jg_info_n6                     charge_dist_id
              ,TO_CHAR(jg_info_d3,'DD-MON-RRRR')                      check_void_date
              ,jg_info_n7                     pay_amt
              ,jg_info_v10                    line_type_lookup_code
              ,jg_info_v11                    line_type_lookup_code_item
              ,jg_info_v12                    line_type_lookup_code_prepay
              ,jg_info_v13                    reversal_flag_item
              ,jg_info_v14                    reversal_flag_pay
              ,jg_info_v15                    reversal_flag_prepay
              ,jg_info_n8                     parent_reversal_id
              ,jg_info_n9                     base_amount
              ,jg_info_n10                    invoice_amount
              ,TO_CHAR(jg_info_d4,'DD-MON-RRRR')                     void_date
              ,TO_CHAR(jg_info_d5,'DD-MON-RRRR')                     future_pay_due_date
              ,TO_CHAR(jg_info_d6,'DD-MON-RRRR')                     check_date
              ,jg_info_v16                    payment_status_flag
              ,TO_CHAR(jg_info_d7,'DD-MON-RRRR')                     accounting_date
              ,jg_info_n11                    reversal_inv_pmt_id
              ,jg_info_v17                    c_company
    FROM JG_ZZ_VAT_TRX_GT JVGT
    WHERE (jg_info_v30 is null or jg_info_v30 <> 'H')
  --AND    DECODE('''' || :P_COMPANY || '''', NULL, ' 1 ', jg_info_v10 ) = DECODE('''' || :P_COMPANY || '''', --NULL, ' 1 ', '''' || :P_COMPANY || '''')
    ORDER BY   company
              ,tax_type
              ,tax_rate
              ,acc_no
              ,rec_per
              ,tax_amt
Parameter Name SQL text Validation
Report By VAT Entity? 
 
 LOV Oracle
Reporting Identifier 
 
 LOV Oracle
Declaration Period 
 
 LOV Oracle
Legal Entity 
 
 LOV Oracle
Ledger 
 
 LOV Oracle
Balancing Segment 
 
Declaration Date 
 
 Date
FND_NUMBER_1 
 
 Number
FND_NUMBER_2 
 
 Number
Chart of Accounts ID 
 
 LOV Oracle
Calling Report 
 
Download
Related Blitz Reports
JE Belgian VAT Annual Audit 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: