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.

VIEW: IGI.IGI_CIS_CI36_PAYMENTS#

Source

View Text - Preformatted


select INVOICE_ID INVOICE_ID, INVOICE_NUM INVOICE_NUM, INVOICE_PAYMENT_ID INVOICE_PAYMENT_ID, PAYMENT_NUM PAYMENT_NUM, AMOUNT AMOUNT, PMT_VCH_NUMBER PMT_VCH_NUMBER, PMT_VCH_AMOUNT PMT_VCH_AMOUNT, PMT_VCH_DESCRIPTION PMT_VCH_DESCRIPTION, CHECK_NUMBER CHECK_NUMBER, CHECK_DATE CHECK_DATE, VENDOR_ID VENDOR_ID, VENDOR_NAME VENDOR_NAME, VENDOR_SITE_ID VENDOR_SITE_ID, VENDOR_SITE_CODE VENDOR_SITE_CODE, GROUP_ID GROUP_ID, CERTIFICATE_TYPE CERTIFICATE_TYPE, CERTIFICATE_NUMBER CERTIFICATE_NUMBER, CERTIFICATE_DESCRIPTION CERTIFICATE_DESCRIPTION, NI_NUMBER NI_NUMBER, SEGMENT1 SEGMENT1, PMT_VCH_RECEIVED_DATE PMT_VCH_RECEIVED_DATE, ADDRESS_LINE1 ADDRESS_LINE1, ADDRESS_LINE2 ADDRESS_LINE2, ADDRESS_LINE3 ADDRESS_LINE3, ZIP ZIP from "IGI"."IGI_CIS_CI36_PAYMENTS"

View Text - HTML Formatted

SELECT INVOICE_ID INVOICE_ID
, INVOICE_NUM INVOICE_NUM
, INVOICE_PAYMENT_ID INVOICE_PAYMENT_ID
, PAYMENT_NUM PAYMENT_NUM
, AMOUNT AMOUNT
, PMT_VCH_NUMBER PMT_VCH_NUMBER
, PMT_VCH_AMOUNT PMT_VCH_AMOUNT
, PMT_VCH_DESCRIPTION PMT_VCH_DESCRIPTION
, CHECK_NUMBER CHECK_NUMBER
, CHECK_DATE CHECK_DATE
, VENDOR_ID VENDOR_ID
, VENDOR_NAME VENDOR_NAME
, VENDOR_SITE_ID VENDOR_SITE_ID
, VENDOR_SITE_CODE VENDOR_SITE_CODE
, GROUP_ID GROUP_ID
, CERTIFICATE_TYPE CERTIFICATE_TYPE
, CERTIFICATE_NUMBER CERTIFICATE_NUMBER
, CERTIFICATE_DESCRIPTION CERTIFICATE_DESCRIPTION
, NI_NUMBER NI_NUMBER
, SEGMENT1 SEGMENT1
, PMT_VCH_RECEIVED_DATE PMT_VCH_RECEIVED_DATE
, ADDRESS_LINE1 ADDRESS_LINE1
, ADDRESS_LINE2 ADDRESS_LINE2
, ADDRESS_LINE3 ADDRESS_LINE3
, ZIP ZIP
FROM "IGI"."IGI_CIS_CI36_PAYMENTS"