VIEW: AP.AP_WHT_ITF#

Source

View Text - Preformatted

select REQUEST_ID REQUEST_ID, ORGANIZATION_NAME ORGANIZATION_NAME, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, 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, ADDRESS_LINE1 ADDRESS_LINE1, ADDRESS_LINE2 ADDRESS_LINE2, ADDRESS_LINE3 ADDRESS_LINE3, CITY CITY, ZIP ZIP, PROVINCE PROVINCE, STATE STATE, COUNTRY COUNTRY, TAX_AUTHORITY TAX_AUTHORITY, SUPPLIER_TYPE SUPPLIER_TYPE, SUPPLIER_NAME SUPPLIER_NAME, TAXPAYER_ID TAXPAYER_ID, SUPPLIER_NUMBER SUPPLIER_NUMBER, SUPPLIER_SITE_CODE SUPPLIER_SITE_CODE, VAT_REGISTRATION_NUMBER VAT_REGISTRATION_NUMBER, SUPPLIER_ADDRESS_LINE1 SUPPLIER_ADDRESS_LINE1, SUPPLIER_ADDRESS_LINE2 SUPPLIER_ADDRESS_LINE2, SUPPLIER_ADDRESS_LINE3 SUPPLIER_ADDRESS_LINE3, SUPPLIER_CITY SUPPLIER_CITY, SUPPLIER_STATE SUPPLIER_STATE, SUPPLIER_ZIP SUPPLIER_ZIP, SUPPLIER_PROVINCE SUPPLIER_PROVINCE, SUPPLIER_COUNTRY SUPPLIER_COUNTRY, INVOICE_NUM INVOICE_NUM, INVOICE_AMOUNT INVOICE_AMOUNT, INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE, INVOICE_DATE INVOICE_DATE, 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, 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, AWT_CODE AWT_CODE, AWT_RATE AWT_RATE, AWT_AMOUNT AWT_AMOUNT, AWT_BASE_AMOUNT AWT_BASE_AMOUNT, AWT_GROUP_NAME AWT_GROUP_NAME, AWT_GL_DATE AWT_GL_DATE, AWT_GROSS_AMOUNT AWT_GROSS_AMOUNT from "AP"."AP_WHT_ITF"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, ORGANIZATION_NAME ORGANIZATION_NAME
, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, 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
, ADDRESS_LINE1 ADDRESS_LINE1
, ADDRESS_LINE2 ADDRESS_LINE2
, ADDRESS_LINE3 ADDRESS_LINE3
, CITY CITY
, ZIP ZIP
, PROVINCE PROVINCE
, STATE STATE
, COUNTRY COUNTRY
, TAX_AUTHORITY TAX_AUTHORITY
, SUPPLIER_TYPE SUPPLIER_TYPE
, SUPPLIER_NAME SUPPLIER_NAME
, TAXPAYER_ID TAXPAYER_ID
, SUPPLIER_NUMBER SUPPLIER_NUMBER
, SUPPLIER_SITE_CODE SUPPLIER_SITE_CODE
, VAT_REGISTRATION_NUMBER VAT_REGISTRATION_NUMBER
, SUPPLIER_ADDRESS_LINE1 SUPPLIER_ADDRESS_LINE1
, SUPPLIER_ADDRESS_LINE2 SUPPLIER_ADDRESS_LINE2
, SUPPLIER_ADDRESS_LINE3 SUPPLIER_ADDRESS_LINE3
, SUPPLIER_CITY SUPPLIER_CITY
, SUPPLIER_STATE SUPPLIER_STATE
, SUPPLIER_ZIP SUPPLIER_ZIP
, SUPPLIER_PROVINCE SUPPLIER_PROVINCE
, SUPPLIER_COUNTRY SUPPLIER_COUNTRY
, INVOICE_NUM INVOICE_NUM
, INVOICE_AMOUNT INVOICE_AMOUNT
, INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, INVOICE_DATE INVOICE_DATE
, 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
, 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
, AWT_CODE AWT_CODE
, AWT_RATE AWT_RATE
, AWT_AMOUNT AWT_AMOUNT
, AWT_BASE_AMOUNT AWT_BASE_AMOUNT
, AWT_GROUP_NAME AWT_GROUP_NAME
, AWT_GL_DATE AWT_GL_DATE
, AWT_GROSS_AMOUNT AWT_GROSS_AMOUNT
FROM "AP"."AP_WHT_ITF"