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.

[Home] [Help]

VIEW: GMS.GMS_272_HISTORY#

Source

View Text - Preformatted


select AWARD_ID AWARD_ID, VERSION VERSION, STATUS_CODE STATUS_CODE, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, DOCUMENT_NUMBER DOCUMENT_NUMBER, RUN_DATE RUN_DATE, REPORT_START_DATE REPORT_START_DATE, REPORT_END_DATE REPORT_END_DATE, LETTER_OF_CREDIT LETTER_OF_CREDIT, LAST_PAYMENT_VOUCHER_NUMBER LAST_PAYMENT_VOUCHER_NUMBER, PAYMENT_VOUCHER_CREDIT PAYMENT_VOUCHER_CREDIT, TREASURY_CHECK TREASURY_CHECK, CASH_IN_HAND_BEGIN CASH_IN_HAND_BEGIN, LETTER_OF_CREDIT_WITHDRAWLS LETTER_OF_CREDIT_WITHDRAWLS, TREASURY_CHECK_PAYMENTS TREASURY_CHECK_PAYMENTS, TOTAL_RECEIPTS TOTAL_RECEIPTS, TOTAL_CASH_AVAIABLE TOTAL_CASH_AVAIABLE, GROSS_DISBURSEMENTS GROSS_DISBURSEMENTS, FEDERAL_SHARE_INCOME FEDERAL_SHARE_INCOME, NET_DISBURSEMENTS NET_DISBURSEMENTS, ADJUSTMENTS_PRIOR_PERIODS ADJUSTMENTS_PRIOR_PERIODS, CASH_IN_HAND_END CASH_IN_HAND_END, DAYS DAYS, INTEREST_INCOME INTEREST_INCOME, ADV_TO_SUBGRANTEES ADV_TO_SUBGRANTEES, REMARKS REMARKS, CREATED_BY CREATED_BY from "GMS"."GMS_272_HISTORY"

View Text - HTML Formatted

SELECT AWARD_ID AWARD_ID
, VERSION VERSION
, STATUS_CODE STATUS_CODE
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DOCUMENT_NUMBER DOCUMENT_NUMBER
, RUN_DATE RUN_DATE
, REPORT_START_DATE REPORT_START_DATE
, REPORT_END_DATE REPORT_END_DATE
, LETTER_OF_CREDIT LETTER_OF_CREDIT
, LAST_PAYMENT_VOUCHER_NUMBER LAST_PAYMENT_VOUCHER_NUMBER
, PAYMENT_VOUCHER_CREDIT PAYMENT_VOUCHER_CREDIT
, TREASURY_CHECK TREASURY_CHECK
, CASH_IN_HAND_BEGIN CASH_IN_HAND_BEGIN
, LETTER_OF_CREDIT_WITHDRAWLS LETTER_OF_CREDIT_WITHDRAWLS
, TREASURY_CHECK_PAYMENTS TREASURY_CHECK_PAYMENTS
, TOTAL_RECEIPTS TOTAL_RECEIPTS
, TOTAL_CASH_AVAIABLE TOTAL_CASH_AVAIABLE
, GROSS_DISBURSEMENTS GROSS_DISBURSEMENTS
, FEDERAL_SHARE_INCOME FEDERAL_SHARE_INCOME
, NET_DISBURSEMENTS NET_DISBURSEMENTS
, ADJUSTMENTS_PRIOR_PERIODS ADJUSTMENTS_PRIOR_PERIODS
, CASH_IN_HAND_END CASH_IN_HAND_END
, DAYS DAYS
, INTEREST_INCOME INTEREST_INCOME
, ADV_TO_SUBGRANTEES ADV_TO_SUBGRANTEES
, REMARKS REMARKS
, CREATED_BY CREATED_BY
FROM "GMS"."GMS_272_HISTORY"