VIEW: IGI.IGI_CIS_MTH_RET_LINES_T_ALL#

Source

View Text - Preformatted

select HEADER_ID HEADER_ID, VENDOR_ID VENDOR_ID, ORG_ID ORG_ID, VENDOR_NAME VENDOR_NAME, VENDOR_TYPE_LOOKUP_CODE VENDOR_TYPE_LOOKUP_CODE, FIRST_NAME FIRST_NAME, SECOND_NAME SECOND_NAME, LAST_NAME LAST_NAME, SALUTATION SALUTATION, TRADING_NAME TRADING_NAME, UNMATCHED_TAX_FLAG UNMATCHED_TAX_FLAG, UNIQUE_TAX_REFERENCE_NUM UNIQUE_TAX_REFERENCE_NUM, COMPANY_REGISTRATION_NUMBER COMPANY_REGISTRATION_NUMBER, NATIONAL_INSURANCE_NUMBER NATIONAL_INSURANCE_NUMBER, VERIFICATION_NUMBER VERIFICATION_NUMBER, TOTAL_PAYMENTS TOTAL_PAYMENTS, MATERIAL_COST MATERIAL_COST, TOTAL_DEDUCTIONS TOTAL_DEDUCTIONS, LABOUR_COST LABOUR_COST, DISCOUNT_AMOUNT DISCOUNT_AMOUNT, 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, CIS_TAX CIS_TAX from "IGI"."IGI_CIS_MTH_RET_LINES_T_ALL"

View Text - HTML Formatted

SELECT HEADER_ID HEADER_ID
, VENDOR_ID VENDOR_ID
, ORG_ID ORG_ID
, VENDOR_NAME VENDOR_NAME
, VENDOR_TYPE_LOOKUP_CODE VENDOR_TYPE_LOOKUP_CODE
, FIRST_NAME FIRST_NAME
, SECOND_NAME SECOND_NAME
, LAST_NAME LAST_NAME
, SALUTATION SALUTATION
, TRADING_NAME TRADING_NAME
, UNMATCHED_TAX_FLAG UNMATCHED_TAX_FLAG
, UNIQUE_TAX_REFERENCE_NUM UNIQUE_TAX_REFERENCE_NUM
, COMPANY_REGISTRATION_NUMBER COMPANY_REGISTRATION_NUMBER
, NATIONAL_INSURANCE_NUMBER NATIONAL_INSURANCE_NUMBER
, VERIFICATION_NUMBER VERIFICATION_NUMBER
, TOTAL_PAYMENTS TOTAL_PAYMENTS
, MATERIAL_COST MATERIAL_COST
, TOTAL_DEDUCTIONS TOTAL_DEDUCTIONS
, LABOUR_COST LABOUR_COST
, DISCOUNT_AMOUNT DISCOUNT_AMOUNT
, 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
, CIS_TAX CIS_TAX
FROM "IGI"."IGI_CIS_MTH_RET_LINES_T_ALL"