eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: JG.JG_ZZ_VAT_TRX_DETAILS#

Source

View Text - Preformatted


select VAT_TRANSACTION_ID VAT_TRANSACTION_ID, REPORTING_STATUS_ID REPORTING_STATUS_ID, SELECTION_PROCESS_ID SELECTION_PROCESS_ID, FINAL_REPORTING_ID FINAL_REPORTING_ID, REP_ENTITY_ID REP_ENTITY_ID, REP_CONTEXT_ENTITY_NAME REP_CONTEXT_ENTITY_NAME, REP_CONTEXT_ENTITY_LOCATION_ID REP_CONTEXT_ENTITY_LOCATION_ID, TAXPAYER_ID TAXPAYER_ID, ORG_INFORMATION2 ORG_INFORMATION2, LEGAL_AUTHORITY_NAME LEGAL_AUTHORITY_NAME, LEGAL_AUTH_ADDRESS_LINE2 LEGAL_AUTH_ADDRESS_LINE2, LEGAL_AUTH_ADDRESS_LINE3 LEGAL_AUTH_ADDRESS_LINE3, LEGAL_AUTH_CITY LEGAL_AUTH_CITY, LEGAL_CONTACT_PARTY_NAME LEGAL_CONTACT_PARTY_NAME, ACTIVITY_CODE ACTIVITY_CODE, LEDGER_ID LEDGER_ID, LEDGER_NAME LEDGER_NAME, CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID, EXTRACT_SOURCE_LEDGER EXTRACT_SOURCE_LEDGER, ESTABLISHMENT_ID ESTABLISHMENT_ID, INTERNAL_ORGANIZATION_ID INTERNAL_ORGANIZATION_ID, APPLICATION_ID APPLICATION_ID, ENTITY_CODE ENTITY_CODE, EVENT_CLASS_CODE EVENT_CLASS_CODE, TRX_ID TRX_ID, TRX_NUMBER TRX_NUMBER, TRX_DESCRIPTION TRX_DESCRIPTION, TRX_CURRENCY_CODE TRX_CURRENCY_CODE, TRX_TYPE_ID TRX_TYPE_ID, TRX_TYPE_MNG TRX_TYPE_MNG, TRX_LINE_ID TRX_LINE_ID, TRX_LINE_NUMBER TRX_LINE_NUMBER, TRX_LINE_DESCRIPTION TRX_LINE_DESCRIPTION, TRX_LEVEL_TYPE TRX_LEVEL_TYPE, TRX_LINE_TYPE TRX_LINE_TYPE, TRX_LINE_CLASS TRX_LINE_CLASS, TRX_CLASS_MNG TRX_CLASS_MNG, TRX_DATE TRX_DATE, TRX_DUE_DATE TRX_DUE_DATE, TRX_COMMUNICATED_DATE TRX_COMMUNICATED_DATE, PRODUCT_ID PRODUCT_ID, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, TERRITORY_SHORT_NAME TERRITORY_SHORT_NAME, DOC_SEQ_ID DOC_SEQ_ID, DOC_SEQ_NAME DOC_SEQ_NAME, DOC_SEQ_VALUE DOC_SEQ_VALUE, TRX_LINE_AMT TRX_LINE_AMT, RECEIPT_CLASS_ID RECEIPT_CLASS_ID, APPLIED_FROM_APPLICATION_ID APPLIED_FROM_APPLICATION_ID, APPLIED_FROM_ENTITY_CODE APPLIED_FROM_ENTITY_CODE, APPLIED_FROM_EVENT_CLASS_CODE APPLIED_FROM_EVENT_CLASS_CODE, APPLIED_FROM_TRX_ID APPLIED_FROM_TRX_ID, APPLIED_FROM_LINE_ID APPLIED_FROM_LINE_ID, APPLIED_FROM_TRX_NUMBER APPLIED_FROM_TRX_NUMBER, APPLIED_TO_APPLICATION_ID APPLIED_TO_APPLICATION_ID, APPLIED_TO_ENTITY_CODE APPLIED_TO_ENTITY_CODE, APPLIED_TO_EVENT_CLASS_CODE APPLIED_TO_EVENT_CLASS_CODE, APPLIED_TO_TRX_ID APPLIED_TO_TRX_ID, APPLIED_TO_TRX_LINE_ID APPLIED_TO_TRX_LINE_ID, APPLIED_TO_TRX_NUMBER APPLIED_TO_TRX_NUMBER, ADJUSTED_DOC_APPLICATION_ID ADJUSTED_DOC_APPLICATION_ID, ADJUSTED_DOC_ENTITY_CODE ADJUSTED_DOC_ENTITY_CODE, ADJUSTED_DOC_EVENT_CLASS_CODE ADJUSTED_DOC_EVENT_CLASS_CODE, ADJUSTED_DOC_TRX_ID ADJUSTED_DOC_TRX_ID, ADJUSTED_DOC_NUMBER ADJUSTED_DOC_NUMBER, ADJUSTED_DOC_DATE ADJUSTED_DOC_DATE, REF_DOC_APPLICATION_ID REF_DOC_APPLICATION_ID, REF_DOC_ENTITY_CODE REF_DOC_ENTITY_CODE, REF_DOC_EVENT_CLASS_CODE REF_DOC_EVENT_CLASS_CODE, REF_DOC_TRX_ID REF_DOC_TRX_ID, REF_DOC_LINE_ID REF_DOC_LINE_ID, MERCHANT_PARTY_DOCUMENT_NUMBER MERCHANT_PARTY_DOCUMENT_NUMBER, MERCHANT_PARTY_NAME MERCHANT_PARTY_NAME, MERCHANT_PARTY_REFERENCE MERCHANT_PARTY_REFERENCE, MERCHANT_PARTY_TAX_REG_NUMBER MERCHANT_PARTY_TAX_REG_NUMBER, MERCHANT_PARTY_TAXPAYER_ID MERCHANT_PARTY_TAXPAYER_ID, START_EXPENSE_DATE START_EXPENSE_DATE, TAXABLE_LINE_SOURCE_TABLE TAXABLE_LINE_SOURCE_TABLE, TAX_LINE_ID TAX_LINE_ID, TAX_LINE_NUMBER TAX_LINE_NUMBER, TAX_INVOICE_DATE TAX_INVOICE_DATE, TAXABLE_AMT TAXABLE_AMT, TAXABLE_AMT_FUNCL_CURR TAXABLE_AMT_FUNCL_CURR, TAX_AMT TAX_AMT, TAX_AMT_FUNCL_CURR TAX_AMT_FUNCL_CURR, REC_TAX_AMT_TAX_CURR REC_TAX_AMT_TAX_CURR, NREC_TAX_AMT_TAX_CURR NREC_TAX_AMT_TAX_CURR, TAXABLE_DISC_AMT TAXABLE_DISC_AMT, TAXABLE_DISC_AMT_FUNCL_CURR TAXABLE_DISC_AMT_FUNCL_CURR, TAX_DISC_AMT TAX_DISC_AMT, TAX_DISC_AMT_FUNCL_CURR TAX_DISC_AMT_FUNCL_CURR, TAX_RATE_ID TAX_RATE_ID, TAX_RATE_CODE TAX_RATE_CODE, TAX_RATE TAX_RATE, TAX_RATE_CODE_NAME TAX_RATE_CODE_NAME, TAX_RATE_CODE_DESCRIPTION TAX_RATE_CODE_DESCRIPTION, TAX_RATE_VAT_TRX_TYPE_CODE TAX_RATE_VAT_TRX_TYPE_CODE, TAX_RATE_VAT_TRX_TYPE_DESC TAX_RATE_VAT_TRX_TYPE_DESC, TAX_RATE_CODE_VAT_TRX_TYPE_MNG TAX_RATE_CODE_VAT_TRX_TYPE_MNG, TAX_RATE_REGISTER_TYPE_CODE TAX_RATE_REGISTER_TYPE_CODE, TAX_TYPE_CODE TAX_TYPE_CODE, TAX_TYPE_MNG TAX_TYPE_MNG, TAX_RECOVERY_RATE TAX_RECOVERY_RATE, TAX_REGIME_CODE TAX_REGIME_CODE, TAX TAX, TAX_JURISDICTION_CODE TAX_JURISDICTION_CODE, TAX_STATUS_ID TAX_STATUS_ID, TAX_STATUS_CODE TAX_STATUS_CODE, TAX_CURRENCY_CODE TAX_CURRENCY_CODE, OFFSET_TAX_RATE_CODE OFFSET_TAX_RATE_CODE, BILLING_TP_NAME BILLING_TP_NAME, BILLING_TP_NUMBER BILLING_TP_NUMBER, BILLING_TP_TAX_REG_NUM BILLING_TP_TAX_REG_NUM, BILLING_TP_TAXPAYER_ID BILLING_TP_TAXPAYER_ID, BILLING_TP_PARTY_NUMBER BILLING_TP_PARTY_NUMBER, BILLING_TRADING_PARTNER_ID BILLING_TRADING_PARTNER_ID, BILLING_TP_TAX_REPORTING_FLAG BILLING_TP_TAX_REPORTING_FLAG, BILLING_TP_SITE_ID BILLING_TP_SITE_ID, BILLING_TP_ADDRESS_ID BILLING_TP_ADDRESS_ID, BILLING_TP_SITE_NAME BILLING_TP_SITE_NAME, BILLING_TP_SITE_TAX_REG_NUM BILLING_TP_SITE_TAX_REG_NUM, SHIPPING_TP_NAME SHIPPING_TP_NAME, SHIPPING_TP_NUMBER SHIPPING_TP_NUMBER, SHIPPING_TP_TAX_REG_NUM SHIPPING_TP_TAX_REG_NUM, SHIPPING_TP_TAXPAYER_ID SHIPPING_TP_TAXPAYER_ID, SHIPPING_TRADING_PARTNER_ID SHIPPING_TRADING_PARTNER_ID, SHIPPING_TP_SITE_ID SHIPPING_TP_SITE_ID, SHIPPING_TP_ADDRESS_ID SHIPPING_TP_ADDRESS_ID, SHIPPING_TP_SITE_NAME SHIPPING_TP_SITE_NAME, SHIPPING_TP_SITE_TAX_REG_NUM SHIPPING_TP_SITE_TAX_REG_NUM, BILL_FROM_PARTY_ID BILL_FROM_PARTY_ID, BILL_FROM_PARTY_SITE_ID BILL_FROM_PARTY_SITE_ID, BANKING_TP_NAME BANKING_TP_NAME, BANKING_TP_TAXPAYER_ID BANKING_TP_TAXPAYER_ID, BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME, BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM, BANK_ACCOUNT_ID BANK_ACCOUNT_ID, BANK_BRANCH_ID BANK_BRANCH_ID, LEGAL_ENTITY_TAX_REG_NUMBER LEGAL_ENTITY_TAX_REG_NUMBER, HQ_ESTB_REG_NUMBER HQ_ESTB_REG_NUMBER, TAX_LINE_REGISTRATION_NUMBER TAX_LINE_REGISTRATION_NUMBER, CANCELLED_DATE CANCELLED_DATE, CANCEL_FLAG CANCEL_FLAG, OFFSET_FLAG OFFSET_FLAG, POSTED_FLAG POSTED_FLAG, MRC_TAX_LINE_FLAG MRC_TAX_LINE_FLAG, RECONCILIATION_FLAG RECONCILIATION_FLAG, TAX_RECOVERABLE_FLAG TAX_RECOVERABLE_FLAG, REVERSE_FLAG REVERSE_FLAG, CORRECTION_FLAG CORRECTION_FLAG, AR_CASH_RECEIPT_REVERSE_STATUS AR_CASH_RECEIPT_REVERSE_STATUS, AR_CASH_RECEIPT_REVERSE_DATE AR_CASH_RECEIPT_REVERSE_DATE, PAYABLES_INVOICE_SOURCE PAYABLES_INVOICE_SOURCE, ACCTD_AMOUNT_DR ACCTD_AMOUNT_DR, ACCTD_AMOUNT_CR ACCTD_AMOUNT_CR, REC_APPLICATION_STATUS REC_APPLICATION_STATUS, VAT_COUNTRY_CODE VAT_COUNTRY_CODE, INVOICE_IDENTIFIER INVOICE_IDENTIFIER, ACCOUNT_CLASS ACCOUNT_CLASS, LATEST_REC_FLAG LATEST_REC_FLAG, JGZZ_FISCAL_CODE JGZZ_FISCAL_CODE, TAX_REFERENCE TAX_REFERENCE, PT_LOCATION PT_LOCATION, INVOICE_REPORT_TYPE INVOICE_REPORT_TYPE, ES_CORRECTION_YEAR ES_CORRECTION_YEAR, ES_CORRECTION_PERIOD ES_CORRECTION_PERIOD, TRIANGULATION TRIANGULATION, DOCUMENT_SUB_TYPE DOCUMENT_SUB_TYPE, ASSESSABLE_VALUE ASSESSABLE_VALUE, PROPERTY_LOCATION PROPERTY_LOCATION, CHK_VAT_AMOUNT_PAID CHK_VAT_AMOUNT_PAID, IMPORT_DOCUMENT_NUMBER IMPORT_DOCUMENT_NUMBER, IMPORT_DOCUMENT_DATE IMPORT_DOCUMENT_DATE, PRL_NO PRL_NO, PROPERTY_RENTAL PROPERTY_RENTAL, RATES_REFERENCE RATES_REFERENCE, STAIR_NUM STAIR_NUM, FLOOR_NUM FLOOR_NUM, DOOR_NUM DOOR_NUM, AMOUNT_APPLIED AMOUNT_APPLIED, ACTG_EVENT_TYPE_CODE ACTG_EVENT_TYPE_CODE, ACTG_EVENT_TYPE_MNG ACTG_EVENT_TYPE_MNG, ACTG_EVENT_NUMBER ACTG_EVENT_NUMBER, ACTG_EVENT_STATUS_FLAG ACTG_EVENT_STATUS_FLAG, ACTG_EVENT_STATUS_MNG ACTG_EVENT_STATUS_MNG, ACTG_CATEGORY_CODE ACTG_CATEGORY_CODE, ACTG_CATEGORY_MNG ACTG_CATEGORY_MNG, ACCOUNTING_DATE ACCOUNTING_DATE, GL_TRANSFER_FLAG GL_TRANSFER_FLAG, ACTG_LINE_NUM ACTG_LINE_NUM, ACTG_LINE_TYPE_CODE ACTG_LINE_TYPE_CODE, ACTG_LINE_TYPE_MNG ACTG_LINE_TYPE_MNG, ACTG_LINE_DESCRIPTION ACTG_LINE_DESCRIPTION, ACTG_STAT_AMT ACTG_STAT_AMT, ACTG_PARTY_ID ACTG_PARTY_ID, ACTG_PARTY_SITE_ID ACTG_PARTY_SITE_ID, ACTG_PARTY_TYPE ACTG_PARTY_TYPE, ACTG_EVENT_ID ACTG_EVENT_ID, ACTG_HEADER_ID ACTG_HEADER_ID, ACTG_LINE_ID ACTG_LINE_ID, ACTG_SOURCE_ID ACTG_SOURCE_ID, ACTG_SOURCE_TABLE ACTG_SOURCE_TABLE, ACTG_LINE_CCID ACTG_LINE_CCID, ACCOUNT_FLEXFIELD ACCOUNT_FLEXFIELD, ACCOUNT_DESCRIPTION ACCOUNT_DESCRIPTION, PERIOD_NAME PERIOD_NAME, TRX_ARAP_BALANCING_SEGMENT TRX_ARAP_BALANCING_SEGMENT, TRX_ARAP_NATURAL_ACCOUNT TRX_ARAP_NATURAL_ACCOUNT, TRX_TAXABLE_BALANCING_SEGMENT TRX_TAXABLE_BALANCING_SEGMENT, TRX_TAXABLE_NATURAL_ACCOUNT TRX_TAXABLE_NATURAL_ACCOUNT, TRX_TAX_BALANCING_SEGMENT TRX_TAX_BALANCING_SEGMENT, TRX_TAX_NATURAL_ACCOUNT TRX_TAX_NATURAL_ACCOUNT, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, GL_DATE GL_DATE, TRX_CONTROL_ACCOUNT_FLEXFIELD TRX_CONTROL_ACCOUNT_FLEXFIELD, TAX_ORIGIN TAX_ORIGIN, REPORTING_CODE REPORTING_CODE, DEF_REC_SETTLEMENT_OPTION_CODE DEF_REC_SETTLEMENT_OPTION_CODE, IL_VAT_REP_STATUS_ID IL_VAT_REP_STATUS_ID, TAXABLE_ITEM_SOURCE_ID TAXABLE_ITEM_SOURCE_ID, INTRA_EU_TRX_TYPE_CODE INTRA_EU_TRX_TYPE_CODE from "JG"."JG_ZZ_VAT_TRX_DETAILS"

View Text - HTML Formatted

SELECT VAT_TRANSACTION_ID VAT_TRANSACTION_ID
, REPORTING_STATUS_ID REPORTING_STATUS_ID
, SELECTION_PROCESS_ID SELECTION_PROCESS_ID
, FINAL_REPORTING_ID FINAL_REPORTING_ID
, REP_ENTITY_ID REP_ENTITY_ID
, REP_CONTEXT_ENTITY_NAME REP_CONTEXT_ENTITY_NAME
, REP_CONTEXT_ENTITY_LOCATION_ID REP_CONTEXT_ENTITY_LOCATION_ID
, TAXPAYER_ID TAXPAYER_ID
, ORG_INFORMATION2 ORG_INFORMATION2
, LEGAL_AUTHORITY_NAME LEGAL_AUTHORITY_NAME
, LEGAL_AUTH_ADDRESS_LINE2 LEGAL_AUTH_ADDRESS_LINE2
, LEGAL_AUTH_ADDRESS_LINE3 LEGAL_AUTH_ADDRESS_LINE3
, LEGAL_AUTH_CITY LEGAL_AUTH_CITY
, LEGAL_CONTACT_PARTY_NAME LEGAL_CONTACT_PARTY_NAME
, ACTIVITY_CODE ACTIVITY_CODE
, LEDGER_ID LEDGER_ID
, LEDGER_NAME LEDGER_NAME
, CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, EXTRACT_SOURCE_LEDGER EXTRACT_SOURCE_LEDGER
, ESTABLISHMENT_ID ESTABLISHMENT_ID
, INTERNAL_ORGANIZATION_ID INTERNAL_ORGANIZATION_ID
, APPLICATION_ID APPLICATION_ID
, ENTITY_CODE ENTITY_CODE
, EVENT_CLASS_CODE EVENT_CLASS_CODE
, TRX_ID TRX_ID
, TRX_NUMBER TRX_NUMBER
, TRX_DESCRIPTION TRX_DESCRIPTION
, TRX_CURRENCY_CODE TRX_CURRENCY_CODE
, TRX_TYPE_ID TRX_TYPE_ID
, TRX_TYPE_MNG TRX_TYPE_MNG
, TRX_LINE_ID TRX_LINE_ID
, TRX_LINE_NUMBER TRX_LINE_NUMBER
, TRX_LINE_DESCRIPTION TRX_LINE_DESCRIPTION
, TRX_LEVEL_TYPE TRX_LEVEL_TYPE
, TRX_LINE_TYPE TRX_LINE_TYPE
, TRX_LINE_CLASS TRX_LINE_CLASS
, TRX_CLASS_MNG TRX_CLASS_MNG
, TRX_DATE TRX_DATE
, TRX_DUE_DATE TRX_DUE_DATE
, TRX_COMMUNICATED_DATE TRX_COMMUNICATED_DATE
, PRODUCT_ID PRODUCT_ID
, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, TERRITORY_SHORT_NAME TERRITORY_SHORT_NAME
, DOC_SEQ_ID DOC_SEQ_ID
, DOC_SEQ_NAME DOC_SEQ_NAME
, DOC_SEQ_VALUE DOC_SEQ_VALUE
, TRX_LINE_AMT TRX_LINE_AMT
, RECEIPT_CLASS_ID RECEIPT_CLASS_ID
, APPLIED_FROM_APPLICATION_ID APPLIED_FROM_APPLICATION_ID
, APPLIED_FROM_ENTITY_CODE APPLIED_FROM_ENTITY_CODE
, APPLIED_FROM_EVENT_CLASS_CODE APPLIED_FROM_EVENT_CLASS_CODE
, APPLIED_FROM_TRX_ID APPLIED_FROM_TRX_ID
, APPLIED_FROM_LINE_ID APPLIED_FROM_LINE_ID
, APPLIED_FROM_TRX_NUMBER APPLIED_FROM_TRX_NUMBER
, APPLIED_TO_APPLICATION_ID APPLIED_TO_APPLICATION_ID
, APPLIED_TO_ENTITY_CODE APPLIED_TO_ENTITY_CODE
, APPLIED_TO_EVENT_CLASS_CODE APPLIED_TO_EVENT_CLASS_CODE
, APPLIED_TO_TRX_ID APPLIED_TO_TRX_ID
, APPLIED_TO_TRX_LINE_ID APPLIED_TO_TRX_LINE_ID
, APPLIED_TO_TRX_NUMBER APPLIED_TO_TRX_NUMBER
, ADJUSTED_DOC_APPLICATION_ID ADJUSTED_DOC_APPLICATION_ID
, ADJUSTED_DOC_ENTITY_CODE ADJUSTED_DOC_ENTITY_CODE
, ADJUSTED_DOC_EVENT_CLASS_CODE ADJUSTED_DOC_EVENT_CLASS_CODE
, ADJUSTED_DOC_TRX_ID ADJUSTED_DOC_TRX_ID
, ADJUSTED_DOC_NUMBER ADJUSTED_DOC_NUMBER
, ADJUSTED_DOC_DATE ADJUSTED_DOC_DATE
, REF_DOC_APPLICATION_ID REF_DOC_APPLICATION_ID
, REF_DOC_ENTITY_CODE REF_DOC_ENTITY_CODE
, REF_DOC_EVENT_CLASS_CODE REF_DOC_EVENT_CLASS_CODE
, REF_DOC_TRX_ID REF_DOC_TRX_ID
, REF_DOC_LINE_ID REF_DOC_LINE_ID
, MERCHANT_PARTY_DOCUMENT_NUMBER MERCHANT_PARTY_DOCUMENT_NUMBER
, MERCHANT_PARTY_NAME MERCHANT_PARTY_NAME
, MERCHANT_PARTY_REFERENCE MERCHANT_PARTY_REFERENCE
, MERCHANT_PARTY_TAX_REG_NUMBER MERCHANT_PARTY_TAX_REG_NUMBER
, MERCHANT_PARTY_TAXPAYER_ID MERCHANT_PARTY_TAXPAYER_ID
, START_EXPENSE_DATE START_EXPENSE_DATE
, TAXABLE_LINE_SOURCE_TABLE TAXABLE_LINE_SOURCE_TABLE
, TAX_LINE_ID TAX_LINE_ID
, TAX_LINE_NUMBER TAX_LINE_NUMBER
, TAX_INVOICE_DATE TAX_INVOICE_DATE
, TAXABLE_AMT TAXABLE_AMT
, TAXABLE_AMT_FUNCL_CURR TAXABLE_AMT_FUNCL_CURR
, TAX_AMT TAX_AMT
, TAX_AMT_FUNCL_CURR TAX_AMT_FUNCL_CURR
, REC_TAX_AMT_TAX_CURR REC_TAX_AMT_TAX_CURR
, NREC_TAX_AMT_TAX_CURR NREC_TAX_AMT_TAX_CURR
, TAXABLE_DISC_AMT TAXABLE_DISC_AMT
, TAXABLE_DISC_AMT_FUNCL_CURR TAXABLE_DISC_AMT_FUNCL_CURR
, TAX_DISC_AMT TAX_DISC_AMT
, TAX_DISC_AMT_FUNCL_CURR TAX_DISC_AMT_FUNCL_CURR
, TAX_RATE_ID TAX_RATE_ID
, TAX_RATE_CODE TAX_RATE_CODE
, TAX_RATE TAX_RATE
, TAX_RATE_CODE_NAME TAX_RATE_CODE_NAME
, TAX_RATE_CODE_DESCRIPTION TAX_RATE_CODE_DESCRIPTION
, TAX_RATE_VAT_TRX_TYPE_CODE TAX_RATE_VAT_TRX_TYPE_CODE
, TAX_RATE_VAT_TRX_TYPE_DESC TAX_RATE_VAT_TRX_TYPE_DESC
, TAX_RATE_CODE_VAT_TRX_TYPE_MNG TAX_RATE_CODE_VAT_TRX_TYPE_MNG
, TAX_RATE_REGISTER_TYPE_CODE TAX_RATE_REGISTER_TYPE_CODE
, TAX_TYPE_CODE TAX_TYPE_CODE
, TAX_TYPE_MNG TAX_TYPE_MNG
, TAX_RECOVERY_RATE TAX_RECOVERY_RATE
, TAX_REGIME_CODE TAX_REGIME_CODE
, TAX TAX
, TAX_JURISDICTION_CODE TAX_JURISDICTION_CODE
, TAX_STATUS_ID TAX_STATUS_ID
, TAX_STATUS_CODE TAX_STATUS_CODE
, TAX_CURRENCY_CODE TAX_CURRENCY_CODE
, OFFSET_TAX_RATE_CODE OFFSET_TAX_RATE_CODE
, BILLING_TP_NAME BILLING_TP_NAME
, BILLING_TP_NUMBER BILLING_TP_NUMBER
, BILLING_TP_TAX_REG_NUM BILLING_TP_TAX_REG_NUM
, BILLING_TP_TAXPAYER_ID BILLING_TP_TAXPAYER_ID
, BILLING_TP_PARTY_NUMBER BILLING_TP_PARTY_NUMBER
, BILLING_TRADING_PARTNER_ID BILLING_TRADING_PARTNER_ID
, BILLING_TP_TAX_REPORTING_FLAG BILLING_TP_TAX_REPORTING_FLAG
, BILLING_TP_SITE_ID BILLING_TP_SITE_ID
, BILLING_TP_ADDRESS_ID BILLING_TP_ADDRESS_ID
, BILLING_TP_SITE_NAME BILLING_TP_SITE_NAME
, BILLING_TP_SITE_TAX_REG_NUM BILLING_TP_SITE_TAX_REG_NUM
, SHIPPING_TP_NAME SHIPPING_TP_NAME
, SHIPPING_TP_NUMBER SHIPPING_TP_NUMBER
, SHIPPING_TP_TAX_REG_NUM SHIPPING_TP_TAX_REG_NUM
, SHIPPING_TP_TAXPAYER_ID SHIPPING_TP_TAXPAYER_ID
, SHIPPING_TRADING_PARTNER_ID SHIPPING_TRADING_PARTNER_ID
, SHIPPING_TP_SITE_ID SHIPPING_TP_SITE_ID
, SHIPPING_TP_ADDRESS_ID SHIPPING_TP_ADDRESS_ID
, SHIPPING_TP_SITE_NAME SHIPPING_TP_SITE_NAME
, SHIPPING_TP_SITE_TAX_REG_NUM SHIPPING_TP_SITE_TAX_REG_NUM
, BILL_FROM_PARTY_ID BILL_FROM_PARTY_ID
, BILL_FROM_PARTY_SITE_ID BILL_FROM_PARTY_SITE_ID
, BANKING_TP_NAME BANKING_TP_NAME
, BANKING_TP_TAXPAYER_ID BANKING_TP_TAXPAYER_ID
, BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM
, BANK_ACCOUNT_ID BANK_ACCOUNT_ID
, BANK_BRANCH_ID BANK_BRANCH_ID
, LEGAL_ENTITY_TAX_REG_NUMBER LEGAL_ENTITY_TAX_REG_NUMBER
, HQ_ESTB_REG_NUMBER HQ_ESTB_REG_NUMBER
, TAX_LINE_REGISTRATION_NUMBER TAX_LINE_REGISTRATION_NUMBER
, CANCELLED_DATE CANCELLED_DATE
, CANCEL_FLAG CANCEL_FLAG
, OFFSET_FLAG OFFSET_FLAG
, POSTED_FLAG POSTED_FLAG
, MRC_TAX_LINE_FLAG MRC_TAX_LINE_FLAG
, RECONCILIATION_FLAG RECONCILIATION_FLAG
, TAX_RECOVERABLE_FLAG TAX_RECOVERABLE_FLAG
, REVERSE_FLAG REVERSE_FLAG
, CORRECTION_FLAG CORRECTION_FLAG
, AR_CASH_RECEIPT_REVERSE_STATUS AR_CASH_RECEIPT_REVERSE_STATUS
, AR_CASH_RECEIPT_REVERSE_DATE AR_CASH_RECEIPT_REVERSE_DATE
, PAYABLES_INVOICE_SOURCE PAYABLES_INVOICE_SOURCE
, ACCTD_AMOUNT_DR ACCTD_AMOUNT_DR
, ACCTD_AMOUNT_CR ACCTD_AMOUNT_CR
, REC_APPLICATION_STATUS REC_APPLICATION_STATUS
, VAT_COUNTRY_CODE VAT_COUNTRY_CODE
, INVOICE_IDENTIFIER INVOICE_IDENTIFIER
, ACCOUNT_CLASS ACCOUNT_CLASS
, LATEST_REC_FLAG LATEST_REC_FLAG
, JGZZ_FISCAL_CODE JGZZ_FISCAL_CODE
, TAX_REFERENCE TAX_REFERENCE
, PT_LOCATION PT_LOCATION
, INVOICE_REPORT_TYPE INVOICE_REPORT_TYPE
, ES_CORRECTION_YEAR ES_CORRECTION_YEAR
, ES_CORRECTION_PERIOD ES_CORRECTION_PERIOD
, TRIANGULATION TRIANGULATION
, DOCUMENT_SUB_TYPE DOCUMENT_SUB_TYPE
, ASSESSABLE_VALUE ASSESSABLE_VALUE
, PROPERTY_LOCATION PROPERTY_LOCATION
, CHK_VAT_AMOUNT_PAID CHK_VAT_AMOUNT_PAID
, IMPORT_DOCUMENT_NUMBER IMPORT_DOCUMENT_NUMBER
, IMPORT_DOCUMENT_DATE IMPORT_DOCUMENT_DATE
, PRL_NO PRL_NO
, PROPERTY_RENTAL PROPERTY_RENTAL
, RATES_REFERENCE RATES_REFERENCE
, STAIR_NUM STAIR_NUM
, FLOOR_NUM FLOOR_NUM
, DOOR_NUM DOOR_NUM
, AMOUNT_APPLIED AMOUNT_APPLIED
, ACTG_EVENT_TYPE_CODE ACTG_EVENT_TYPE_CODE
, ACTG_EVENT_TYPE_MNG ACTG_EVENT_TYPE_MNG
, ACTG_EVENT_NUMBER ACTG_EVENT_NUMBER
, ACTG_EVENT_STATUS_FLAG ACTG_EVENT_STATUS_FLAG
, ACTG_EVENT_STATUS_MNG ACTG_EVENT_STATUS_MNG
, ACTG_CATEGORY_CODE ACTG_CATEGORY_CODE
, ACTG_CATEGORY_MNG ACTG_CATEGORY_MNG
, ACCOUNTING_DATE ACCOUNTING_DATE
, GL_TRANSFER_FLAG GL_TRANSFER_FLAG
, ACTG_LINE_NUM ACTG_LINE_NUM
, ACTG_LINE_TYPE_CODE ACTG_LINE_TYPE_CODE
, ACTG_LINE_TYPE_MNG ACTG_LINE_TYPE_MNG
, ACTG_LINE_DESCRIPTION ACTG_LINE_DESCRIPTION
, ACTG_STAT_AMT ACTG_STAT_AMT
, ACTG_PARTY_ID ACTG_PARTY_ID
, ACTG_PARTY_SITE_ID ACTG_PARTY_SITE_ID
, ACTG_PARTY_TYPE ACTG_PARTY_TYPE
, ACTG_EVENT_ID ACTG_EVENT_ID
, ACTG_HEADER_ID ACTG_HEADER_ID
, ACTG_LINE_ID ACTG_LINE_ID
, ACTG_SOURCE_ID ACTG_SOURCE_ID
, ACTG_SOURCE_TABLE ACTG_SOURCE_TABLE
, ACTG_LINE_CCID ACTG_LINE_CCID
, ACCOUNT_FLEXFIELD ACCOUNT_FLEXFIELD
, ACCOUNT_DESCRIPTION ACCOUNT_DESCRIPTION
, PERIOD_NAME PERIOD_NAME
, TRX_ARAP_BALANCING_SEGMENT TRX_ARAP_BALANCING_SEGMENT
, TRX_ARAP_NATURAL_ACCOUNT TRX_ARAP_NATURAL_ACCOUNT
, TRX_TAXABLE_BALANCING_SEGMENT TRX_TAXABLE_BALANCING_SEGMENT
, TRX_TAXABLE_NATURAL_ACCOUNT TRX_TAXABLE_NATURAL_ACCOUNT
, TRX_TAX_BALANCING_SEGMENT TRX_TAX_BALANCING_SEGMENT
, TRX_TAX_NATURAL_ACCOUNT TRX_TAX_NATURAL_ACCOUNT
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, GL_DATE GL_DATE
, TRX_CONTROL_ACCOUNT_FLEXFIELD TRX_CONTROL_ACCOUNT_FLEXFIELD
, TAX_ORIGIN TAX_ORIGIN
, REPORTING_CODE REPORTING_CODE
, DEF_REC_SETTLEMENT_OPTION_CODE DEF_REC_SETTLEMENT_OPTION_CODE
, IL_VAT_REP_STATUS_ID IL_VAT_REP_STATUS_ID
, TAXABLE_ITEM_SOURCE_ID TAXABLE_ITEM_SOURCE_ID
, INTRA_EU_TRX_TYPE_CODE INTRA_EU_TRX_TYPE_CODE
FROM "JG"."JG_ZZ_VAT_TRX_DETAILS"