VIEW: JE.JE_GR_AR_AP_TRNOVR_ITF#

Source

View Text - Preformatted

select REQUEST_ID REQUEST_ID, INV_TRX_ID INV_TRX_ID, CUST_SUP_TYPE_CODE CUST_SUP_TYPE_CODE, CUST_SUP_NAME CUST_SUP_NAME, CUST_SUP_NUMBER CUST_SUP_NUMBER, TAX_PAYER_ID TAX_PAYER_ID, VAT_REGISTRATION_NUMBER VAT_REGISTRATION_NUMBER, SUPPLIER_SITE_CODE SUPPLIER_SITE_CODE, PROFESSION PROFESSION, ADDRESS_LINE1 ADDRESS_LINE1, ADDRESS_LINE2 ADDRESS_LINE2, ADDRESS_LINE3 ADDRESS_LINE3, CITY CITY, STATE STATE, ZIP ZIP, PROVINCE PROVINCE, COUNTRY COUNTRY, INV_TRX_NUMBER INV_TRX_NUMBER, INV_TRX_DATE INV_TRX_DATE, INV_TRX_CURRENCY_CODE INV_TRX_CURRENCY_CODE, INV_TRX_AMOUNT INV_TRX_AMOUNT, INV_TRX_TYPE INV_TRX_TYPE, ACCTD_INV_TRX_AMOUNT ACCTD_INV_TRX_AMOUNT, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "JE"."JE_GR_AR_AP_TRNOVR_ITF"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, INV_TRX_ID INV_TRX_ID
, CUST_SUP_TYPE_CODE CUST_SUP_TYPE_CODE
, CUST_SUP_NAME CUST_SUP_NAME
, CUST_SUP_NUMBER CUST_SUP_NUMBER
, TAX_PAYER_ID TAX_PAYER_ID
, VAT_REGISTRATION_NUMBER VAT_REGISTRATION_NUMBER
, SUPPLIER_SITE_CODE SUPPLIER_SITE_CODE
, PROFESSION PROFESSION
, ADDRESS_LINE1 ADDRESS_LINE1
, ADDRESS_LINE2 ADDRESS_LINE2
, ADDRESS_LINE3 ADDRESS_LINE3
, CITY CITY
, STATE STATE
, ZIP ZIP
, PROVINCE PROVINCE
, COUNTRY COUNTRY
, INV_TRX_NUMBER INV_TRX_NUMBER
, INV_TRX_DATE INV_TRX_DATE
, INV_TRX_CURRENCY_CODE INV_TRX_CURRENCY_CODE
, INV_TRX_AMOUNT INV_TRX_AMOUNT
, INV_TRX_TYPE INV_TRX_TYPE
, ACCTD_INV_TRX_AMOUNT ACCTD_INV_TRX_AMOUNT
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "JE"."JE_GR_AR_AP_TRNOVR_ITF"