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

Source

View Text - Preformatted


select HEADER_ID HEADER_ID, ACTION_INDICATOR ACTION_INDICATOR, VENDOR_TYPE_LOOKUP_CODE VENDOR_TYPE_LOOKUP_CODE, VENDOR_ID VENDOR_ID, VENDOR_NAME VENDOR_NAME, VENDOR_SITE_ID VENDOR_SITE_ID, VENDOR_SITE_CODE VENDOR_SITE_CODE, FIRST_NAME FIRST_NAME, SECOND_NAME SECOND_NAME, LAST_NAME LAST_NAME, SALUTATION SALUTATION, TRADING_NAME TRADING_NAME, UNIQUE_TAX_REFERENCE_NUM UNIQUE_TAX_REFERENCE_NUM, WORK_REFERENCE WORK_REFERENCE, COMPANY_REGISTRATION_NUMBER COMPANY_REGISTRATION_NUMBER, NATIONAL_INSURANCE_NUMBER NATIONAL_INSURANCE_NUMBER, PARTNERSHIP_UTR PARTNERSHIP_UTR, PARTNERSHIP_NAME PARTNERSHIP_NAME, VERIFICATION_NUMBER VERIFICATION_NUMBER, CIS_VERIFICATION_DATE CIS_VERIFICATION_DATE, ADDRESS_LINE1 ADDRESS_LINE1, ADDRESS_LINE2 ADDRESS_LINE2, ADDRESS_LINE3 ADDRESS_LINE3, ADDRESS_LINE4 ADDRESS_LINE4, MATCH_STATUS MATCH_STATUS, POST_CODE POST_CODE, COUNTRY COUNTRY, CONTACT_NUMBER CONTACT_NUMBER, TAX_TREATMENT_STATUS TAX_TREATMENT_STATUS, 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 from "IGI"."IGI_CIS_VERIFY_LINES_T"

View Text - HTML Formatted

SELECT HEADER_ID HEADER_ID
, ACTION_INDICATOR ACTION_INDICATOR
, VENDOR_TYPE_LOOKUP_CODE VENDOR_TYPE_LOOKUP_CODE
, VENDOR_ID VENDOR_ID
, VENDOR_NAME VENDOR_NAME
, VENDOR_SITE_ID VENDOR_SITE_ID
, VENDOR_SITE_CODE VENDOR_SITE_CODE
, FIRST_NAME FIRST_NAME
, SECOND_NAME SECOND_NAME
, LAST_NAME LAST_NAME
, SALUTATION SALUTATION
, TRADING_NAME TRADING_NAME
, UNIQUE_TAX_REFERENCE_NUM UNIQUE_TAX_REFERENCE_NUM
, WORK_REFERENCE WORK_REFERENCE
, COMPANY_REGISTRATION_NUMBER COMPANY_REGISTRATION_NUMBER
, NATIONAL_INSURANCE_NUMBER NATIONAL_INSURANCE_NUMBER
, PARTNERSHIP_UTR PARTNERSHIP_UTR
, PARTNERSHIP_NAME PARTNERSHIP_NAME
, VERIFICATION_NUMBER VERIFICATION_NUMBER
, CIS_VERIFICATION_DATE CIS_VERIFICATION_DATE
, ADDRESS_LINE1 ADDRESS_LINE1
, ADDRESS_LINE2 ADDRESS_LINE2
, ADDRESS_LINE3 ADDRESS_LINE3
, ADDRESS_LINE4 ADDRESS_LINE4
, MATCH_STATUS MATCH_STATUS
, POST_CODE POST_CODE
, COUNTRY COUNTRY
, CONTACT_NUMBER CONTACT_NUMBER
, TAX_TREATMENT_STATUS TAX_TREATMENT_STATUS
, 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
FROM "IGI"."IGI_CIS_VERIFY_LINES_T"