JG EMEA VAT: Journal AR Extract

Description
Categories: BI Publisher
Columns: Legal Entity Name, Le Location Id, Address1, Address2, Address3, Stadt, Postal Code, Telephone, Le Tax Registration Number, Contact Name ...
Application: Regional Localizations
Source: EMEA VAT: Journal AR Extract
Short Name: JGZZJOURNALAR_XMLP
DB package: jg_zz_journal_ar_pkg
     SELECT
         JZVTD.rep_context_entity_name        LEGAL_ENTITY_NAME
        ,JZVTD.rep_context_entity_location_id LE_LOCATION_ID
        ,HLA.address_line_1                   ADDRESS1
        ,HLA.address_line_2                   ADDRESS2
        ,HLA.address_line_3                   ADDRESS3
        ,HLA.town_or_city                     CITY
        ,HLA.postal_code                      POSTAL_CODE
        ,HLA.telephone_number_1               TELEPHONE
        ,JZVRS.tax_registration_number        LE_TAX_REGISTRATION_NUMBER
        ,JZVTD.legal_contact_party_name       CONTACT_NAME
        ,JZVRS.tax_calendar_year              TAX_PERIOD_YEAR
        ,JZVRS.tax_calendar_period            TAX_PERIOD_NAME
        ,to_char(JZVRS.period_start_date,'DD-Mon-RRRR')             PERIOD_START_DATE
        ,to_char(JZVRS.period_end_date,'DD-Mon-RRRR')               PERIOD_END_DATE
        ,JZVTD.extract_source_ledger          EXTRACT_SOURCE_LEDGER
        ,JZVTD.event_class_code               EVENT_CLASS_CODE
        ,JZVTD.period_name                    GL_PERIOD_NAME
        ,JZVTD.doc_seq_name                   DOC_SEQUENCE_NAME
        ,JZVTD.doc_seq_value                  DOC_SEQUENCE_NUMBER
        ,to_char(JZVTD.trx_date,'DD-Mon-RRRR')                        INVOICE_DATE
        ,JZVTD.billing_tp_party_number        CUSTOMER_NUMBER
        ,JZVTD.billing_tp_taxpayer_id         CUSTOMER_TAX_PAYER_ID
        ,JZVTD.billing_tp_site_name           CUSTOMER_SITE_NAME
        ,JZVTD.billing_tp_name                CUSTOMER_NAME
        ,JZVTD.billing_tp_tax_reg_num         CUST_BILL_TAX_REG_NUM
        ,JZVTD.shipping_tp_tax_reg_num        CUST_SHIP_AX_REG_NUM
        ,JZVTD.billing_tp_site_tax_reg_num    CUST_SITE_BILL_TAX_REG_NUM
        ,JZVTD.shipping_tp_site_tax_reg_num   CUST_SITE_SHIP_TAX_REG_NUM
        ,JZVTD.trx_number                     INVOICE_NUMBER
        ,NVL(JZVTD.taxable_amt,0)             TAXABLE_AMT
        ,NVL(JZVTD.tax_amt,0)                 TAX_AMOUNT
        ,NVL(JZVTD.taxable_amt_funcl_curr,0)  TAXABLE_AMT_FUNCL_CURR
        ,NVL(JZVTD.tax_amt_funcl_curr,0)      TAX_AMOUNT_FUNCL_CURR
        ,JZVTD.trx_id                         TRX_ID
        ,to_char(JZVTD.cancelled_date,'DD-Mon-RRRR'