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

Source

View Text - Preformatted


select CERTIFICATE_TYPE CERTIFICATE_TYPE, VENDOR_NAME VENDOR_NAME, VENDOR_SITE_CODE VENDOR_SITE_CODE, CERTIFICATE_NUMBER CERTIFICATE_NUMBER, CERTIFICATE_DESCRIPTION CERTIFICATE_DESCRIPTION, NI_NUMBER NI_NUMBER, PMT_VCH_NUMBER PMT_VCH_NUMBER, PMT_VCH_DESCRIPTION PMT_VCH_DESCRIPTION, MATERIAL_AMOUNT MATERIAL_AMOUNT, LABOR_AMOUNT LABOR_AMOUNT, CIS_AMOUNT CIS_AMOUNT, NET_AMOUNT NET_AMOUNT, SEGMENT1 SEGMENT1, INVOICE_NUM INVOICE_NUM, CHECK_NUMBER CHECK_NUMBER, CHECK_DATE CHECK_DATE, AMOUNT AMOUNT, 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_EXTRACT"

View Text - HTML Formatted

SELECT CERTIFICATE_TYPE CERTIFICATE_TYPE
, VENDOR_NAME VENDOR_NAME
, VENDOR_SITE_CODE VENDOR_SITE_CODE
, CERTIFICATE_NUMBER CERTIFICATE_NUMBER
, CERTIFICATE_DESCRIPTION CERTIFICATE_DESCRIPTION
, NI_NUMBER NI_NUMBER
, PMT_VCH_NUMBER PMT_VCH_NUMBER
, PMT_VCH_DESCRIPTION PMT_VCH_DESCRIPTION
, MATERIAL_AMOUNT MATERIAL_AMOUNT
, LABOR_AMOUNT LABOR_AMOUNT
, CIS_AMOUNT CIS_AMOUNT
, NET_AMOUNT NET_AMOUNT
, SEGMENT1 SEGMENT1
, INVOICE_NUM INVOICE_NUM
, CHECK_NUMBER CHECK_NUMBER
, CHECK_DATE CHECK_DATE
, AMOUNT AMOUNT
, 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_EXTRACT"