Reports2017-11-18T12:27:27+00:00

JE Invoice Electronic Listing File for Italy

Description
Categories: BI Publisher
Application: European Localizations
Source: Invoice Electronic Listing File for Italy
Short Name: JEITIELF_XMLP
DB package: JE_IT_ELE_INV_REPORT_PKG
SELECT decode(length(jeiteitl.vat_registration_num),13,substr(jeiteitl.vat_registration_num,3,11),
                                                                          jeiteitl.vat_registration_num)         PARTY_VAT_REG_NUM
                          ,substr(jeiteitl.vat_registration_num,0,2)         PARTY_COUNTRY_CODE   
                          ,jeiteitl.tax_payer_id                             TAX_PAYER_ID  
                          ,jeiteitl.party_type                               PARTY_TYPE                        
                          ,jeiteitl.party_name                               PARTY_NAME
                          ,jeiteitl.indv_party_first_name                    INDV_PARTY_FIRST_NAME
                          ,jeiteitl.indv_party_last_name                     INDV_PARTY_LAST_NAME
                          ,jeiteitl.party_address                            PARTY_ADDRESS
                          ,jeiteitl.party_zip                                PARTY_ZIP
                          ,jeiteitl.party_city                               PARTY_CITY
                          ,jeiteitl.party_province                           PARTY_PROVINCE
                          ,jeiteitl.party_country                            PARTY_COUNTRY
                          ,jeiteitl.party_pe_address                         PARTY_PE_ADDRESS
                          ,jeiteitl.party_pe_zip                             PARTY_PE_ZIP 
                          ,jeiteitl.party_pe_city                            PARTY_PE_CITY
                          ,jeiteitl.party_pe_province                        PARTY_PE_PROVINCE
                          ,jeiteitl.party_pe_country                         PARTY_PE_COUNTRY
                          ,jeiteitl.inv_document_type                        INV_DOCUMENT_TYPE
                          ,to_char(jeiteitl.trx_date,'RRRR-MM-DD')           TRX_DATE
                          ,to_char(jeiteitl.gl_date,'RRRR-MM-DD')            GL_DATE
                          ,jeiteitl.trx_num                                  TRX_NUM
                          ,jeiteitl.vat_not_exposed_flag                     VAT_NOT_EXPOSED
                          ,trim(to_char(jeiteitl.taxable_amt,'99999999990.99'))    TAXABLE_AMT
                          ,trim(to_char(jeiteitl.tax_amt,'99999999990.99'))        TAX_AMT
                          ,trim(to_char(jeiteitl.taxable_amt+jeiteitl.tax_amt,'99999999990.99'))    TOTAL_AMT  
                          ,trim(to_char(jeiteitl.tax_rate,'990.99'))               TAX_RATE
                          ,jeiteitl.nature_of_vat                            NATURE_OF_VAT
                          ,jeiteitl.offset_flag                              OFFSET_FLAG  
                     FROM je_it_ele_inv_trx_lines jeiteitl
                    WHERE jeiteitl.request_id   = :P_REQUEST_ID
                      AND jeiteitl.rec_type  = 'R'
                      AND jeiteitl.eft_num = :P_EFT_NUM
                 ORDER BY party_name,party_address,trx_date,trx_num
By continuing to use the site, you agree to the use of cookies. Accept