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_AP_WHT_ITF#

Source

View Text - Preformatted


select HRL_GLOBAL_ATTRIBUTE3 HRL_GLOBAL_ATTRIBUTE3, HRL_GLOBAL_ATTRIBUTE4 HRL_GLOBAL_ATTRIBUTE4, HRL_GLOBAL_ATTRIBUTE5 HRL_GLOBAL_ATTRIBUTE5, HRL_GLOBAL_ATTRIBUTE6 HRL_GLOBAL_ATTRIBUTE6, HRL_GLOBAL_ATTRIBUTE7 HRL_GLOBAL_ATTRIBUTE7, HRL_GLOBAL_ATTRIBUTE8 HRL_GLOBAL_ATTRIBUTE8, HRL_GLOBAL_ATTRIBUTE9 HRL_GLOBAL_ATTRIBUTE9, HRL_GLOBAL_ATTRIBUTE10 HRL_GLOBAL_ATTRIBUTE10, HRL_GLOBAL_ATTRIBUTE11 HRL_GLOBAL_ATTRIBUTE11, HRL_GLOBAL_ATTRIBUTE12 HRL_GLOBAL_ATTRIBUTE12, HRL_GLOBAL_ATTRIBUTE13 HRL_GLOBAL_ATTRIBUTE13, HRL_GLOBAL_ATTRIBUTE14 HRL_GLOBAL_ATTRIBUTE14, HRL_GLOBAL_ATTRIBUTE15 HRL_GLOBAL_ATTRIBUTE15, HRL_GLOBAL_ATTRIBUTE16 HRL_GLOBAL_ATTRIBUTE16, HRL_GLOBAL_ATTRIBUTE17 HRL_GLOBAL_ATTRIBUTE17, HRL_GLOBAL_ATTRIBUTE18 HRL_GLOBAL_ATTRIBUTE18, HRL_GLOBAL_ATTRIBUTE19 HRL_GLOBAL_ATTRIBUTE19, HRL_GLOBAL_ATTRIBUTE20 HRL_GLOBAL_ATTRIBUTE20, HRL_GA_CATEGORY HRL_GA_CATEGORY, LOCATION_NAME LOCATION_NAME, LOCATION_ADDRESS1 LOCATION_ADDRESS1, LOCATION_ADDRESS2 LOCATION_ADDRESS2, LOCATION_ADDRESS3 LOCATION_ADDRESS3, LOCATION_COUNTRY LOCATION_COUNTRY, LOCATION_ZIPCODE LOCATION_ZIPCODE, LOCATION_PHONE LOCATION_PHONE, LOCATION_FAX LOCATION_FAX, LEGAL_ENTITY_NAME LEGAL_ENTITY_NAME, LEGAL_ENTITY_CITY LEGAL_ENTITY_CITY, LEGAL_ENTITY_ADDRESS1 LEGAL_ENTITY_ADDRESS1, LEGAL_ENTITY_ADDRESS2 LEGAL_ENTITY_ADDRESS2, LEGAL_ENTITY_ADDRESS3 LEGAL_ENTITY_ADDRESS3, LEGAL_ENTITY_COUNTRY LEGAL_ENTITY_COUNTRY, LEGAL_ENTITY_ZIPCODE LEGAL_ENTITY_ZIPCODE, LEGAL_ENTITY_PHONE LEGAL_ENTITY_PHONE, HRL_GLOBAL_ATTRIBUTE1 HRL_GLOBAL_ATTRIBUTE1, HRL_GLOBAL_ATTRIBUTE2 HRL_GLOBAL_ATTRIBUTE2, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, SUPPLIER_NAME SUPPLIER_NAME, SUPPLIER_SITE_NAME SUPPLIER_SITE_NAME, PV_ATTRIBUTE1 PV_ATTRIBUTE1, PV_ATTRIBUTE2 PV_ATTRIBUTE2, PV_ATTRIBUTE3 PV_ATTRIBUTE3, PV_ATTRIBUTE4 PV_ATTRIBUTE4, PV_ATTRIBUTE5 PV_ATTRIBUTE5, PV_ATTRIBUTE6 PV_ATTRIBUTE6, PV_ATTRIBUTE7 PV_ATTRIBUTE7, PV_ATTRIBUTE8 PV_ATTRIBUTE8, PV_ATTRIBUTE9 PV_ATTRIBUTE9, PV_ATTRIBUTE10 PV_ATTRIBUTE10, PV_ATTRIBUTE11 PV_ATTRIBUTE11, PV_ATTRIBUTE12 PV_ATTRIBUTE12, PV_ATTRIBUTE13 PV_ATTRIBUTE13, PV_ATTRIBUTE14 PV_ATTRIBUTE14, PV_ATTRIBUTE15 PV_ATTRIBUTE15, PV_ATTRIBUTE_CATEGORY PV_ATTRIBUTE_CATEGORY, PV_GA_CATEGORY PV_GA_CATEGORY, PV_GLOBAL_ATTRIBUTE1 PV_GLOBAL_ATTRIBUTE1, PV_GLOBAL_ATTRIBUTE2 PV_GLOBAL_ATTRIBUTE2, PV_GLOBAL_ATTRIBUTE3 PV_GLOBAL_ATTRIBUTE3, PV_GLOBAL_ATTRIBUTE4 PV_GLOBAL_ATTRIBUTE4, PV_GLOBAL_ATTRIBUTE5 PV_GLOBAL_ATTRIBUTE5, PV_GLOBAL_ATTRIBUTE6 PV_GLOBAL_ATTRIBUTE6, PV_GLOBAL_ATTRIBUTE7 PV_GLOBAL_ATTRIBUTE7, PV_GLOBAL_ATTRIBUTE8 PV_GLOBAL_ATTRIBUTE8, PV_GLOBAL_ATTRIBUTE9 PV_GLOBAL_ATTRIBUTE9, PV_GLOBAL_ATTRIBUTE10 PV_GLOBAL_ATTRIBUTE10, PV_GLOBAL_ATTRIBUTE11 PV_GLOBAL_ATTRIBUTE11, PV_GLOBAL_ATTRIBUTE12 PV_GLOBAL_ATTRIBUTE12, PV_GLOBAL_ATTRIBUTE13 PV_GLOBAL_ATTRIBUTE13, PV_GLOBAL_ATTRIBUTE14 PV_GLOBAL_ATTRIBUTE14, PV_GLOBAL_ATTRIBUTE15 PV_GLOBAL_ATTRIBUTE15, PV_GLOBAL_ATTRIBUTE16 PV_GLOBAL_ATTRIBUTE16, PV_GLOBAL_ATTRIBUTE17 PV_GLOBAL_ATTRIBUTE17, PV_GLOBAL_ATTRIBUTE18 PV_GLOBAL_ATTRIBUTE18, PV_GLOBAL_ATTRIBUTE19 PV_GLOBAL_ATTRIBUTE19, PV_GLOBAL_ATTRIBUTE20 PV_GLOBAL_ATTRIBUTE20, PVS_ATTRIBUTE1 PVS_ATTRIBUTE1, PVS_ATTRIBUTE2 PVS_ATTRIBUTE2, PVS_ATTRIBUTE3 PVS_ATTRIBUTE3, PVS_ATTRIBUTE4 PVS_ATTRIBUTE4, PVS_ATTRIBUTE5 PVS_ATTRIBUTE5, PVS_ATTRIBUTE6 PVS_ATTRIBUTE6, PVS_ATTRIBUTE7 PVS_ATTRIBUTE7, PVS_ATTRIBUTE8 PVS_ATTRIBUTE8, PVS_ATTRIBUTE9 PVS_ATTRIBUTE9, PVS_ATTRIBUTE10 PVS_ATTRIBUTE10, PVS_ATTRIBUTE11 PVS_ATTRIBUTE11, PVS_ATTRIBUTE12 PVS_ATTRIBUTE12, PVS_ATTRIBUTE13 PVS_ATTRIBUTE13, PVS_ATTRIBUTE14 PVS_ATTRIBUTE14, PVS_ATTRIBUTE15 PVS_ATTRIBUTE15, PVS_GLOBAL_ATTRIBUTE3 PVS_GLOBAL_ATTRIBUTE3, PVS_GLOBAL_ATTRIBUTE4 PVS_GLOBAL_ATTRIBUTE4, PVS_GLOBAL_ATTRIBUTE5 PVS_GLOBAL_ATTRIBUTE5, PVS_GLOBAL_ATTRIBUTE6 PVS_GLOBAL_ATTRIBUTE6, PVS_GLOBAL_ATTRIBUTE7 PVS_GLOBAL_ATTRIBUTE7, PVS_GLOBAL_ATTRIBUTE8 PVS_GLOBAL_ATTRIBUTE8, PVS_GLOBAL_ATTRIBUTE9 PVS_GLOBAL_ATTRIBUTE9, PVS_GLOBAL_ATTRIBUTE10 PVS_GLOBAL_ATTRIBUTE10, PVS_GLOBAL_ATTRIBUTE11 PVS_GLOBAL_ATTRIBUTE11, PVS_GLOBAL_ATTRIBUTE12 PVS_GLOBAL_ATTRIBUTE12, PVS_GLOBAL_ATTRIBUTE13 PVS_GLOBAL_ATTRIBUTE13, PVS_GLOBAL_ATTRIBUTE14 PVS_GLOBAL_ATTRIBUTE14, PVS_GLOBAL_ATTRIBUTE15 PVS_GLOBAL_ATTRIBUTE15, PVS_GLOBAL_ATTRIBUTE16 PVS_GLOBAL_ATTRIBUTE16, PVS_GLOBAL_ATTRIBUTE17 PVS_GLOBAL_ATTRIBUTE17, PVS_GLOBAL_ATTRIBUTE18 PVS_GLOBAL_ATTRIBUTE18, PVS_GLOBAL_ATTRIBUTE19 PVS_GLOBAL_ATTRIBUTE19, PVS_GLOBAL_ATTRIBUTE20 PVS_GLOBAL_ATTRIBUTE20, PVS_ATTRIBUTE_CATEGORY PVS_ATTRIBUTE_CATEGORY, PVS_GA_CATEGORY PVS_GA_CATEGORY, INV_ATTRIBUTE1 INV_ATTRIBUTE1, INV_ATTRIBUTE2 INV_ATTRIBUTE2, INV_ATTRIBUTE3 INV_ATTRIBUTE3, INV_ATTRIBUTE4 INV_ATTRIBUTE4, INV_ATTRIBUTE5 INV_ATTRIBUTE5, INV_ATTRIBUTE6 INV_ATTRIBUTE6, INV_ATTRIBUTE7 INV_ATTRIBUTE7, INV_ATTRIBUTE8 INV_ATTRIBUTE8, INV_ATTRIBUTE9 INV_ATTRIBUTE9, INV_ATTRIBUTE10 INV_ATTRIBUTE10, INV_ATTRIBUTE11 INV_ATTRIBUTE11, INV_ATTRIBUTE12 INV_ATTRIBUTE12, INV_ATTRIBUTE13 INV_ATTRIBUTE13, INV_ATTRIBUTE14 INV_ATTRIBUTE14, INV_ATTRIBUTE15 INV_ATTRIBUTE15, INV_GLOBAL_ATTRIBUTE1 INV_GLOBAL_ATTRIBUTE1, INV_GLOBAL_ATTRIBUTE2 INV_GLOBAL_ATTRIBUTE2, INV_GLOBAL_ATTRIBUTE3 INV_GLOBAL_ATTRIBUTE3, INV_GLOBAL_ATTRIBUTE4 INV_GLOBAL_ATTRIBUTE4, INV_GLOBAL_ATTRIBUTE5 INV_GLOBAL_ATTRIBUTE5, INV_GLOBAL_ATTRIBUTE6 INV_GLOBAL_ATTRIBUTE6, INV_GLOBAL_ATTRIBUTE7 INV_GLOBAL_ATTRIBUTE7, INV_GLOBAL_ATTRIBUTE8 INV_GLOBAL_ATTRIBUTE8, INV_GLOBAL_ATTRIBUTE9 INV_GLOBAL_ATTRIBUTE9, INV_GLOBAL_ATTRIBUTE10 INV_GLOBAL_ATTRIBUTE10, INV_GLOBAL_ATTRIBUTE11 INV_GLOBAL_ATTRIBUTE11, INV_GLOBAL_ATTRIBUTE12 INV_GLOBAL_ATTRIBUTE12, INV_GLOBAL_ATTRIBUTE13 INV_GLOBAL_ATTRIBUTE13, INV_GLOBAL_ATTRIBUTE14 INV_GLOBAL_ATTRIBUTE14, INV_GLOBAL_ATTRIBUTE15 INV_GLOBAL_ATTRIBUTE15, INV_GLOBAL_ATTRIBUTE16 INV_GLOBAL_ATTRIBUTE16, INV_GLOBAL_ATTRIBUTE17 INV_GLOBAL_ATTRIBUTE17, INV_GLOBAL_ATTRIBUTE18 INV_GLOBAL_ATTRIBUTE18, INV_GLOBAL_ATTRIBUTE19 INV_GLOBAL_ATTRIBUTE19, INV_GLOBAL_ATTRIBUTE20 INV_GLOBAL_ATTRIBUTE20, INV_ATTRIBUTE_CATEGORY INV_ATTRIBUTE_CATEGORY, INV_GA_CATEGORY INV_GA_CATEGORY, IND_GLOBAL_ATTRIBUTE1 IND_GLOBAL_ATTRIBUTE1, IND_GLOBAL_ATTRIBUTE2 IND_GLOBAL_ATTRIBUTE2, IND_GLOBAL_ATTRIBUTE3 IND_GLOBAL_ATTRIBUTE3, IND_GLOBAL_ATTRIBUTE4 IND_GLOBAL_ATTRIBUTE4, IND_GLOBAL_ATTRIBUTE5 IND_GLOBAL_ATTRIBUTE5, IND_GLOBAL_ATTRIBUTE6 IND_GLOBAL_ATTRIBUTE6, IND_GLOBAL_ATTRIBUTE7 IND_GLOBAL_ATTRIBUTE7, IND_GLOBAL_ATTRIBUTE8 IND_GLOBAL_ATTRIBUTE8, IND_GLOBAL_ATTRIBUTE9 IND_GLOBAL_ATTRIBUTE9, IND_GLOBAL_ATTRIBUTE10 IND_GLOBAL_ATTRIBUTE10, IND_GLOBAL_ATTRIBUTE11 IND_GLOBAL_ATTRIBUTE11, IND_GLOBAL_ATTRIBUTE12 IND_GLOBAL_ATTRIBUTE12, IND_GLOBAL_ATTRIBUTE13 IND_GLOBAL_ATTRIBUTE13, IND_GLOBAL_ATTRIBUTE14 IND_GLOBAL_ATTRIBUTE14, IND_GLOBAL_ATTRIBUTE15 IND_GLOBAL_ATTRIBUTE15, IND_GLOBAL_ATTRIBUTE16 IND_GLOBAL_ATTRIBUTE16, IND_GLOBAL_ATTRIBUTE17 IND_GLOBAL_ATTRIBUTE17, IND_GLOBAL_ATTRIBUTE18 IND_GLOBAL_ATTRIBUTE18, IND_GLOBAL_ATTRIBUTE19 IND_GLOBAL_ATTRIBUTE19, IND_GLOBAL_ATTRIBUTE20 IND_GLOBAL_ATTRIBUTE20, IND_GA_CATEGORY IND_GA_CATEGORY, SUPPLIER_COUNTRY SUPPLIER_COUNTRY, SUPPLIER_ADDRESS_LINE1 SUPPLIER_ADDRESS_LINE1, SUPPLIER_ADDRESS_LINE2 SUPPLIER_ADDRESS_LINE2, SUPPLIER_ADDRESS_LINE3 SUPPLIER_ADDRESS_LINE3, SUPPLIER_CITY SUPPLIER_CITY, SUPPLIER_POSTAL_CODE SUPPLIER_POSTAL_CODE, SUPPLIER_PROVINCE SUPPLIER_PROVINCE, SUPPLIER_COUNTY SUPPLIER_COUNTY, SUPP_CONCATENATED_ADDRESS SUPP_CONCATENATED_ADDRESS, PVS_GLOBAL_ATTRIBUTE1 PVS_GLOBAL_ATTRIBUTE1, SUPPLIER_TAX_REGISTRATION_NUM SUPPLIER_TAX_REGISTRATION_NUM, SUPPLIER_TAXPAYER_ID SUPPLIER_TAXPAYER_ID, PVS_GLOBAL_ATTRIBUTE2 PVS_GLOBAL_ATTRIBUTE2, BIZ_INC_SUB_CATEG_MEANING BIZ_INC_SUB_CATEG_MEANING, DIST_CODE_COMBINATION_ID DIST_CODE_COMBINATION_ID, ACCOUNTING_FLEXFIELD ACCOUNTING_FLEXFIELD, TRANSACTION_NUMBER TRANSACTION_NUMBER, ACCOUNTING_DATE ACCOUNTING_DATE, DOCUMENT_NUMBER DOCUMENT_NUMBER, ORGANIZATION_TYPE ORGANIZATION_TYPE, ORG_TYPE_MEANING ORG_TYPE_MEANING, TAX_ID TAX_ID, TAX_CODE TAX_CODE, AWT_DESCRIPTION AWT_DESCRIPTION, TAX_TYPE TAX_TYPE, TAX_RATE_ID TAX_RATE_ID, TAX_RATE TAX_RATE, ATC_GLOBAL_ATTRIBUTE6 ATC_GLOBAL_ATTRIBUTE6, ATC_GLOBAL_ATTRIBUTE7 ATC_GLOBAL_ATTRIBUTE7, ATC_GLOBAL_ATTRIBUTE1 ATC_GLOBAL_ATTRIBUTE1, ATC_GLOBAL_ATTRIBUTE2 ATC_GLOBAL_ATTRIBUTE2, ATC_GLOBAL_ATTRIBUTE3 ATC_GLOBAL_ATTRIBUTE3, ATC_GLOBAL_ATTRIBUTE8 ATC_GLOBAL_ATTRIBUTE8, ATC_GLOBAL_ATTRIBUTE9 ATC_GLOBAL_ATTRIBUTE9, ATC_GLOBAL_ATTRIBUTE10 ATC_GLOBAL_ATTRIBUTE10, ATC_GLOBAL_ATTRIBUTE11 ATC_GLOBAL_ATTRIBUTE11, ATC_GLOBAL_ATTRIBUTE12 ATC_GLOBAL_ATTRIBUTE12, ATC_GLOBAL_ATTRIBUTE13 ATC_GLOBAL_ATTRIBUTE13, ATC_GLOBAL_ATTRIBUTE14 ATC_GLOBAL_ATTRIBUTE14, ATC_GLOBAL_ATTRIBUTE15 ATC_GLOBAL_ATTRIBUTE15, ATC_GLOBAL_ATTRIBUTE16 ATC_GLOBAL_ATTRIBUTE16, ATC_GLOBAL_ATTRIBUTE17 ATC_GLOBAL_ATTRIBUTE17, ATC_GLOBAL_ATTRIBUTE18 ATC_GLOBAL_ATTRIBUTE18, ATC_GLOBAL_ATTRIBUTE19 ATC_GLOBAL_ATTRIBUTE19, ATC_GLOBAL_ATTRIBUTE20 ATC_GLOBAL_ATTRIBUTE20, ATC_GA_CATEGORY ATC_GA_CATEGORY, WH_TAX_TYPE_MEANING WH_TAX_TYPE_MEANING, ATC_GLOBAL_ATTRIBUTE4 ATC_GLOBAL_ATTRIBUTE4, RES_INC_CATEG_MEANING RES_INC_CATEG_MEANING, ATC_GLOBAL_ATTRIBUTE5 ATC_GLOBAL_ATTRIBUTE5, FOR_INC_CATEG_MEANING FOR_INC_CATEG_MEANING, TAX_AUTHORITY_NAME TAX_AUTHORITY_NAME, STATUS STATUS, INCOME_TAX INCOME_TAX, RESIDENT_TAX RESIDENT_TAX, TOTAL_WHT_AMOUNT TOTAL_WHT_AMOUNT, PAYMENT_CURRENCY PAYMENT_CURRENCY, INVOICE_PAYMENT_ID INVOICE_PAYMENT_ID, PAYMENT_AMOUNT PAYMENT_AMOUNT, PAYMENT_DATE PAYMENT_DATE, PAYMENT_NUMBER PAYMENT_NUMBER, CHECK_ID CHECK_ID, CHECK_NUMBER CHECK_NUMBER, CHECK_AMOUNT CHECK_AMOUNT, INVOICE_ID INVOICE_ID, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID, INVOICE_AMOUNT INVOICE_AMOUNT, INVOICE_DATE INVOICE_DATE, CURRENCY_CODE CURRENCY_CODE, FUNC_CURRENCY_CODE FUNC_CURRENCY_CODE, AMT_SUBJECT_TO_WH AMT_SUBJECT_TO_WH, RECOGNIZED_EXPENSE_AMT RECOGNIZED_EXPENSE_AMT, INC_WH_TAX_BASE_AMT INC_WH_TAX_BASE_AMT, RES_WH_TAX_BASE_AMT RES_WH_TAX_BASE_AMT, TOTAL_TAX_BASE_AMT TOTAL_TAX_BASE_AMT, NET_AMOUNT NET_AMOUNT, LINE_NUMBER LINE_NUMBER, TYPE_1099 TYPE_1099, ITEM_DESCRIPTION ITEM_DESCRIPTION, ORGANIZATION_NAME ORGANIZATION_NAME, REPORTING_ENTITY_NAME REPORTING_ENTITY_NAME, REPORTING_SOB_NAME REPORTING_SOB_NAME, SOB_ID SOB_ID, REQUEST_ID REQUEST_ID, NOMINAL_OR_REG_TAX_RATE NOMINAL_OR_REG_TAX_RATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, INVOICE_LINE_NUM INVOICE_LINE_NUM from "JG"."JG_ZZ_AP_WHT_ITF"

View Text - HTML Formatted

SELECT HRL_GLOBAL_ATTRIBUTE3 HRL_GLOBAL_ATTRIBUTE3
, HRL_GLOBAL_ATTRIBUTE4 HRL_GLOBAL_ATTRIBUTE4
, HRL_GLOBAL_ATTRIBUTE5 HRL_GLOBAL_ATTRIBUTE5
, HRL_GLOBAL_ATTRIBUTE6 HRL_GLOBAL_ATTRIBUTE6
, HRL_GLOBAL_ATTRIBUTE7 HRL_GLOBAL_ATTRIBUTE7
, HRL_GLOBAL_ATTRIBUTE8 HRL_GLOBAL_ATTRIBUTE8
, HRL_GLOBAL_ATTRIBUTE9 HRL_GLOBAL_ATTRIBUTE9
, HRL_GLOBAL_ATTRIBUTE10 HRL_GLOBAL_ATTRIBUTE10
, HRL_GLOBAL_ATTRIBUTE11 HRL_GLOBAL_ATTRIBUTE11
, HRL_GLOBAL_ATTRIBUTE12 HRL_GLOBAL_ATTRIBUTE12
, HRL_GLOBAL_ATTRIBUTE13 HRL_GLOBAL_ATTRIBUTE13
, HRL_GLOBAL_ATTRIBUTE14 HRL_GLOBAL_ATTRIBUTE14
, HRL_GLOBAL_ATTRIBUTE15 HRL_GLOBAL_ATTRIBUTE15
, HRL_GLOBAL_ATTRIBUTE16 HRL_GLOBAL_ATTRIBUTE16
, HRL_GLOBAL_ATTRIBUTE17 HRL_GLOBAL_ATTRIBUTE17
, HRL_GLOBAL_ATTRIBUTE18 HRL_GLOBAL_ATTRIBUTE18
, HRL_GLOBAL_ATTRIBUTE19 HRL_GLOBAL_ATTRIBUTE19
, HRL_GLOBAL_ATTRIBUTE20 HRL_GLOBAL_ATTRIBUTE20
, HRL_GA_CATEGORY HRL_GA_CATEGORY
, LOCATION_NAME LOCATION_NAME
, LOCATION_ADDRESS1 LOCATION_ADDRESS1
, LOCATION_ADDRESS2 LOCATION_ADDRESS2
, LOCATION_ADDRESS3 LOCATION_ADDRESS3
, LOCATION_COUNTRY LOCATION_COUNTRY
, LOCATION_ZIPCODE LOCATION_ZIPCODE
, LOCATION_PHONE LOCATION_PHONE
, LOCATION_FAX LOCATION_FAX
, LEGAL_ENTITY_NAME LEGAL_ENTITY_NAME
, LEGAL_ENTITY_CITY LEGAL_ENTITY_CITY
, LEGAL_ENTITY_ADDRESS1 LEGAL_ENTITY_ADDRESS1
, LEGAL_ENTITY_ADDRESS2 LEGAL_ENTITY_ADDRESS2
, LEGAL_ENTITY_ADDRESS3 LEGAL_ENTITY_ADDRESS3
, LEGAL_ENTITY_COUNTRY LEGAL_ENTITY_COUNTRY
, LEGAL_ENTITY_ZIPCODE LEGAL_ENTITY_ZIPCODE
, LEGAL_ENTITY_PHONE LEGAL_ENTITY_PHONE
, HRL_GLOBAL_ATTRIBUTE1 HRL_GLOBAL_ATTRIBUTE1
, HRL_GLOBAL_ATTRIBUTE2 HRL_GLOBAL_ATTRIBUTE2
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, SUPPLIER_NAME SUPPLIER_NAME
, SUPPLIER_SITE_NAME SUPPLIER_SITE_NAME
, PV_ATTRIBUTE1 PV_ATTRIBUTE1
, PV_ATTRIBUTE2 PV_ATTRIBUTE2
, PV_ATTRIBUTE3 PV_ATTRIBUTE3
, PV_ATTRIBUTE4 PV_ATTRIBUTE4
, PV_ATTRIBUTE5 PV_ATTRIBUTE5
, PV_ATTRIBUTE6 PV_ATTRIBUTE6
, PV_ATTRIBUTE7 PV_ATTRIBUTE7
, PV_ATTRIBUTE8 PV_ATTRIBUTE8
, PV_ATTRIBUTE9 PV_ATTRIBUTE9
, PV_ATTRIBUTE10 PV_ATTRIBUTE10
, PV_ATTRIBUTE11 PV_ATTRIBUTE11
, PV_ATTRIBUTE12 PV_ATTRIBUTE12
, PV_ATTRIBUTE13 PV_ATTRIBUTE13
, PV_ATTRIBUTE14 PV_ATTRIBUTE14
, PV_ATTRIBUTE15 PV_ATTRIBUTE15
, PV_ATTRIBUTE_CATEGORY PV_ATTRIBUTE_CATEGORY
, PV_GA_CATEGORY PV_GA_CATEGORY
, PV_GLOBAL_ATTRIBUTE1 PV_GLOBAL_ATTRIBUTE1
, PV_GLOBAL_ATTRIBUTE2 PV_GLOBAL_ATTRIBUTE2
, PV_GLOBAL_ATTRIBUTE3 PV_GLOBAL_ATTRIBUTE3
, PV_GLOBAL_ATTRIBUTE4 PV_GLOBAL_ATTRIBUTE4
, PV_GLOBAL_ATTRIBUTE5 PV_GLOBAL_ATTRIBUTE5
, PV_GLOBAL_ATTRIBUTE6 PV_GLOBAL_ATTRIBUTE6
, PV_GLOBAL_ATTRIBUTE7 PV_GLOBAL_ATTRIBUTE7
, PV_GLOBAL_ATTRIBUTE8 PV_GLOBAL_ATTRIBUTE8
, PV_GLOBAL_ATTRIBUTE9 PV_GLOBAL_ATTRIBUTE9
, PV_GLOBAL_ATTRIBUTE10 PV_GLOBAL_ATTRIBUTE10
, PV_GLOBAL_ATTRIBUTE11 PV_GLOBAL_ATTRIBUTE11
, PV_GLOBAL_ATTRIBUTE12 PV_GLOBAL_ATTRIBUTE12
, PV_GLOBAL_ATTRIBUTE13 PV_GLOBAL_ATTRIBUTE13
, PV_GLOBAL_ATTRIBUTE14 PV_GLOBAL_ATTRIBUTE14
, PV_GLOBAL_ATTRIBUTE15 PV_GLOBAL_ATTRIBUTE15
, PV_GLOBAL_ATTRIBUTE16 PV_GLOBAL_ATTRIBUTE16
, PV_GLOBAL_ATTRIBUTE17 PV_GLOBAL_ATTRIBUTE17
, PV_GLOBAL_ATTRIBUTE18 PV_GLOBAL_ATTRIBUTE18
, PV_GLOBAL_ATTRIBUTE19 PV_GLOBAL_ATTRIBUTE19
, PV_GLOBAL_ATTRIBUTE20 PV_GLOBAL_ATTRIBUTE20
, PVS_ATTRIBUTE1 PVS_ATTRIBUTE1
, PVS_ATTRIBUTE2 PVS_ATTRIBUTE2
, PVS_ATTRIBUTE3 PVS_ATTRIBUTE3
, PVS_ATTRIBUTE4 PVS_ATTRIBUTE4
, PVS_ATTRIBUTE5 PVS_ATTRIBUTE5
, PVS_ATTRIBUTE6 PVS_ATTRIBUTE6
, PVS_ATTRIBUTE7 PVS_ATTRIBUTE7
, PVS_ATTRIBUTE8 PVS_ATTRIBUTE8
, PVS_ATTRIBUTE9 PVS_ATTRIBUTE9
, PVS_ATTRIBUTE10 PVS_ATTRIBUTE10
, PVS_ATTRIBUTE11 PVS_ATTRIBUTE11
, PVS_ATTRIBUTE12 PVS_ATTRIBUTE12
, PVS_ATTRIBUTE13 PVS_ATTRIBUTE13
, PVS_ATTRIBUTE14 PVS_ATTRIBUTE14
, PVS_ATTRIBUTE15 PVS_ATTRIBUTE15
, PVS_GLOBAL_ATTRIBUTE3 PVS_GLOBAL_ATTRIBUTE3
, PVS_GLOBAL_ATTRIBUTE4 PVS_GLOBAL_ATTRIBUTE4
, PVS_GLOBAL_ATTRIBUTE5 PVS_GLOBAL_ATTRIBUTE5
, PVS_GLOBAL_ATTRIBUTE6 PVS_GLOBAL_ATTRIBUTE6
, PVS_GLOBAL_ATTRIBUTE7 PVS_GLOBAL_ATTRIBUTE7
, PVS_GLOBAL_ATTRIBUTE8 PVS_GLOBAL_ATTRIBUTE8
, PVS_GLOBAL_ATTRIBUTE9 PVS_GLOBAL_ATTRIBUTE9
, PVS_GLOBAL_ATTRIBUTE10 PVS_GLOBAL_ATTRIBUTE10
, PVS_GLOBAL_ATTRIBUTE11 PVS_GLOBAL_ATTRIBUTE11
, PVS_GLOBAL_ATTRIBUTE12 PVS_GLOBAL_ATTRIBUTE12
, PVS_GLOBAL_ATTRIBUTE13 PVS_GLOBAL_ATTRIBUTE13
, PVS_GLOBAL_ATTRIBUTE14 PVS_GLOBAL_ATTRIBUTE14
, PVS_GLOBAL_ATTRIBUTE15 PVS_GLOBAL_ATTRIBUTE15
, PVS_GLOBAL_ATTRIBUTE16 PVS_GLOBAL_ATTRIBUTE16
, PVS_GLOBAL_ATTRIBUTE17 PVS_GLOBAL_ATTRIBUTE17
, PVS_GLOBAL_ATTRIBUTE18 PVS_GLOBAL_ATTRIBUTE18
, PVS_GLOBAL_ATTRIBUTE19 PVS_GLOBAL_ATTRIBUTE19
, PVS_GLOBAL_ATTRIBUTE20 PVS_GLOBAL_ATTRIBUTE20
, PVS_ATTRIBUTE_CATEGORY PVS_ATTRIBUTE_CATEGORY
, PVS_GA_CATEGORY PVS_GA_CATEGORY
, INV_ATTRIBUTE1 INV_ATTRIBUTE1
, INV_ATTRIBUTE2 INV_ATTRIBUTE2
, INV_ATTRIBUTE3 INV_ATTRIBUTE3
, INV_ATTRIBUTE4 INV_ATTRIBUTE4
, INV_ATTRIBUTE5 INV_ATTRIBUTE5
, INV_ATTRIBUTE6 INV_ATTRIBUTE6
, INV_ATTRIBUTE7 INV_ATTRIBUTE7
, INV_ATTRIBUTE8 INV_ATTRIBUTE8
, INV_ATTRIBUTE9 INV_ATTRIBUTE9
, INV_ATTRIBUTE10 INV_ATTRIBUTE10
, INV_ATTRIBUTE11 INV_ATTRIBUTE11
, INV_ATTRIBUTE12 INV_ATTRIBUTE12
, INV_ATTRIBUTE13 INV_ATTRIBUTE13
, INV_ATTRIBUTE14 INV_ATTRIBUTE14
, INV_ATTRIBUTE15 INV_ATTRIBUTE15
, INV_GLOBAL_ATTRIBUTE1 INV_GLOBAL_ATTRIBUTE1
, INV_GLOBAL_ATTRIBUTE2 INV_GLOBAL_ATTRIBUTE2
, INV_GLOBAL_ATTRIBUTE3 INV_GLOBAL_ATTRIBUTE3
, INV_GLOBAL_ATTRIBUTE4 INV_GLOBAL_ATTRIBUTE4
, INV_GLOBAL_ATTRIBUTE5 INV_GLOBAL_ATTRIBUTE5
, INV_GLOBAL_ATTRIBUTE6 INV_GLOBAL_ATTRIBUTE6
, INV_GLOBAL_ATTRIBUTE7 INV_GLOBAL_ATTRIBUTE7
, INV_GLOBAL_ATTRIBUTE8 INV_GLOBAL_ATTRIBUTE8
, INV_GLOBAL_ATTRIBUTE9 INV_GLOBAL_ATTRIBUTE9
, INV_GLOBAL_ATTRIBUTE10 INV_GLOBAL_ATTRIBUTE10
, INV_GLOBAL_ATTRIBUTE11 INV_GLOBAL_ATTRIBUTE11
, INV_GLOBAL_ATTRIBUTE12 INV_GLOBAL_ATTRIBUTE12
, INV_GLOBAL_ATTRIBUTE13 INV_GLOBAL_ATTRIBUTE13
, INV_GLOBAL_ATTRIBUTE14 INV_GLOBAL_ATTRIBUTE14
, INV_GLOBAL_ATTRIBUTE15 INV_GLOBAL_ATTRIBUTE15
, INV_GLOBAL_ATTRIBUTE16 INV_GLOBAL_ATTRIBUTE16
, INV_GLOBAL_ATTRIBUTE17 INV_GLOBAL_ATTRIBUTE17
, INV_GLOBAL_ATTRIBUTE18 INV_GLOBAL_ATTRIBUTE18
, INV_GLOBAL_ATTRIBUTE19 INV_GLOBAL_ATTRIBUTE19
, INV_GLOBAL_ATTRIBUTE20 INV_GLOBAL_ATTRIBUTE20
, INV_ATTRIBUTE_CATEGORY INV_ATTRIBUTE_CATEGORY
, INV_GA_CATEGORY INV_GA_CATEGORY
, IND_GLOBAL_ATTRIBUTE1 IND_GLOBAL_ATTRIBUTE1
, IND_GLOBAL_ATTRIBUTE2 IND_GLOBAL_ATTRIBUTE2
, IND_GLOBAL_ATTRIBUTE3 IND_GLOBAL_ATTRIBUTE3
, IND_GLOBAL_ATTRIBUTE4 IND_GLOBAL_ATTRIBUTE4
, IND_GLOBAL_ATTRIBUTE5 IND_GLOBAL_ATTRIBUTE5
, IND_GLOBAL_ATTRIBUTE6 IND_GLOBAL_ATTRIBUTE6
, IND_GLOBAL_ATTRIBUTE7 IND_GLOBAL_ATTRIBUTE7
, IND_GLOBAL_ATTRIBUTE8 IND_GLOBAL_ATTRIBUTE8
, IND_GLOBAL_ATTRIBUTE9 IND_GLOBAL_ATTRIBUTE9
, IND_GLOBAL_ATTRIBUTE10 IND_GLOBAL_ATTRIBUTE10
, IND_GLOBAL_ATTRIBUTE11 IND_GLOBAL_ATTRIBUTE11
, IND_GLOBAL_ATTRIBUTE12 IND_GLOBAL_ATTRIBUTE12
, IND_GLOBAL_ATTRIBUTE13 IND_GLOBAL_ATTRIBUTE13
, IND_GLOBAL_ATTRIBUTE14 IND_GLOBAL_ATTRIBUTE14
, IND_GLOBAL_ATTRIBUTE15 IND_GLOBAL_ATTRIBUTE15
, IND_GLOBAL_ATTRIBUTE16 IND_GLOBAL_ATTRIBUTE16
, IND_GLOBAL_ATTRIBUTE17 IND_GLOBAL_ATTRIBUTE17
, IND_GLOBAL_ATTRIBUTE18 IND_GLOBAL_ATTRIBUTE18
, IND_GLOBAL_ATTRIBUTE19 IND_GLOBAL_ATTRIBUTE19
, IND_GLOBAL_ATTRIBUTE20 IND_GLOBAL_ATTRIBUTE20
, IND_GA_CATEGORY IND_GA_CATEGORY
, SUPPLIER_COUNTRY SUPPLIER_COUNTRY
, SUPPLIER_ADDRESS_LINE1 SUPPLIER_ADDRESS_LINE1
, SUPPLIER_ADDRESS_LINE2 SUPPLIER_ADDRESS_LINE2
, SUPPLIER_ADDRESS_LINE3 SUPPLIER_ADDRESS_LINE3
, SUPPLIER_CITY SUPPLIER_CITY
, SUPPLIER_POSTAL_CODE SUPPLIER_POSTAL_CODE
, SUPPLIER_PROVINCE SUPPLIER_PROVINCE
, SUPPLIER_COUNTY SUPPLIER_COUNTY
, SUPP_CONCATENATED_ADDRESS SUPP_CONCATENATED_ADDRESS
, PVS_GLOBAL_ATTRIBUTE1 PVS_GLOBAL_ATTRIBUTE1
, SUPPLIER_TAX_REGISTRATION_NUM SUPPLIER_TAX_REGISTRATION_NUM
, SUPPLIER_TAXPAYER_ID SUPPLIER_TAXPAYER_ID
, PVS_GLOBAL_ATTRIBUTE2 PVS_GLOBAL_ATTRIBUTE2
, BIZ_INC_SUB_CATEG_MEANING BIZ_INC_SUB_CATEG_MEANING
, DIST_CODE_COMBINATION_ID DIST_CODE_COMBINATION_ID
, ACCOUNTING_FLEXFIELD ACCOUNTING_FLEXFIELD
, TRANSACTION_NUMBER TRANSACTION_NUMBER
, ACCOUNTING_DATE ACCOUNTING_DATE
, DOCUMENT_NUMBER DOCUMENT_NUMBER
, ORGANIZATION_TYPE ORGANIZATION_TYPE
, ORG_TYPE_MEANING ORG_TYPE_MEANING
, TAX_ID TAX_ID
, TAX_CODE TAX_CODE
, AWT_DESCRIPTION AWT_DESCRIPTION
, TAX_TYPE TAX_TYPE
, TAX_RATE_ID TAX_RATE_ID
, TAX_RATE TAX_RATE
, ATC_GLOBAL_ATTRIBUTE6 ATC_GLOBAL_ATTRIBUTE6
, ATC_GLOBAL_ATTRIBUTE7 ATC_GLOBAL_ATTRIBUTE7
, ATC_GLOBAL_ATTRIBUTE1 ATC_GLOBAL_ATTRIBUTE1
, ATC_GLOBAL_ATTRIBUTE2 ATC_GLOBAL_ATTRIBUTE2
, ATC_GLOBAL_ATTRIBUTE3 ATC_GLOBAL_ATTRIBUTE3
, ATC_GLOBAL_ATTRIBUTE8 ATC_GLOBAL_ATTRIBUTE8
, ATC_GLOBAL_ATTRIBUTE9 ATC_GLOBAL_ATTRIBUTE9
, ATC_GLOBAL_ATTRIBUTE10 ATC_GLOBAL_ATTRIBUTE10
, ATC_GLOBAL_ATTRIBUTE11 ATC_GLOBAL_ATTRIBUTE11
, ATC_GLOBAL_ATTRIBUTE12 ATC_GLOBAL_ATTRIBUTE12
, ATC_GLOBAL_ATTRIBUTE13 ATC_GLOBAL_ATTRIBUTE13
, ATC_GLOBAL_ATTRIBUTE14 ATC_GLOBAL_ATTRIBUTE14
, ATC_GLOBAL_ATTRIBUTE15 ATC_GLOBAL_ATTRIBUTE15
, ATC_GLOBAL_ATTRIBUTE16 ATC_GLOBAL_ATTRIBUTE16
, ATC_GLOBAL_ATTRIBUTE17 ATC_GLOBAL_ATTRIBUTE17
, ATC_GLOBAL_ATTRIBUTE18 ATC_GLOBAL_ATTRIBUTE18
, ATC_GLOBAL_ATTRIBUTE19 ATC_GLOBAL_ATTRIBUTE19
, ATC_GLOBAL_ATTRIBUTE20 ATC_GLOBAL_ATTRIBUTE20
, ATC_GA_CATEGORY ATC_GA_CATEGORY
, WH_TAX_TYPE_MEANING WH_TAX_TYPE_MEANING
, ATC_GLOBAL_ATTRIBUTE4 ATC_GLOBAL_ATTRIBUTE4
, RES_INC_CATEG_MEANING RES_INC_CATEG_MEANING
, ATC_GLOBAL_ATTRIBUTE5 ATC_GLOBAL_ATTRIBUTE5
, FOR_INC_CATEG_MEANING FOR_INC_CATEG_MEANING
, TAX_AUTHORITY_NAME TAX_AUTHORITY_NAME
, STATUS STATUS
, INCOME_TAX INCOME_TAX
, RESIDENT_TAX RESIDENT_TAX
, TOTAL_WHT_AMOUNT TOTAL_WHT_AMOUNT
, PAYMENT_CURRENCY PAYMENT_CURRENCY
, INVOICE_PAYMENT_ID INVOICE_PAYMENT_ID
, PAYMENT_AMOUNT PAYMENT_AMOUNT
, PAYMENT_DATE PAYMENT_DATE
, PAYMENT_NUMBER PAYMENT_NUMBER
, CHECK_ID CHECK_ID
, CHECK_NUMBER CHECK_NUMBER
, CHECK_AMOUNT CHECK_AMOUNT
, INVOICE_ID INVOICE_ID
, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID
, INVOICE_AMOUNT INVOICE_AMOUNT
, INVOICE_DATE INVOICE_DATE
, CURRENCY_CODE CURRENCY_CODE
, FUNC_CURRENCY_CODE FUNC_CURRENCY_CODE
, AMT_SUBJECT_TO_WH AMT_SUBJECT_TO_WH
, RECOGNIZED_EXPENSE_AMT RECOGNIZED_EXPENSE_AMT
, INC_WH_TAX_BASE_AMT INC_WH_TAX_BASE_AMT
, RES_WH_TAX_BASE_AMT RES_WH_TAX_BASE_AMT
, TOTAL_TAX_BASE_AMT TOTAL_TAX_BASE_AMT
, NET_AMOUNT NET_AMOUNT
, LINE_NUMBER LINE_NUMBER
, TYPE_1099 TYPE_1099
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, ORGANIZATION_NAME ORGANIZATION_NAME
, REPORTING_ENTITY_NAME REPORTING_ENTITY_NAME
, REPORTING_SOB_NAME REPORTING_SOB_NAME
, SOB_ID SOB_ID
, REQUEST_ID REQUEST_ID
, NOMINAL_OR_REG_TAX_RATE NOMINAL_OR_REG_TAX_RATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, INVOICE_LINE_NUM INVOICE_LINE_NUM
FROM "JG"."JG_ZZ_AP_WHT_ITF"