[Home] [Help] [Dependency Information]
Object Name: | GMS_272_HISTORY# |
---|---|
Object Type: | VIEW |
Owner: | GMS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AWARD_ID | NUMBER | (15) | Yes | |
VERSION | NUMBER | (15) | Yes | |
STATUS_CODE | VARCHAR2 | (1) | Yes | |
CREATION_DATE | DATE | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
DOCUMENT_NUMBER | VARCHAR2 | (30) | ||
RUN_DATE | DATE | |||
REPORT_START_DATE | DATE | |||
REPORT_END_DATE | DATE | |||
LETTER_OF_CREDIT | VARCHAR2 | (15) | ||
LAST_PAYMENT_VOUCHER_NUMBER | NUMBER | |||
PAYMENT_VOUCHER_CREDIT | NUMBER | (15) | ||
TREASURY_CHECK | NUMBER | |||
CASH_IN_HAND_BEGIN | NUMBER | (22) | ||
LETTER_OF_CREDIT_WITHDRAWLS | NUMBER | (22) | ||
TREASURY_CHECK_PAYMENTS | NUMBER | (15) | ||
TOTAL_RECEIPTS | NUMBER | (22) | ||
TOTAL_CASH_AVAIABLE | NUMBER | (22) | ||
GROSS_DISBURSEMENTS | NUMBER | (22) | ||
FEDERAL_SHARE_INCOME | NUMBER | (22) | ||
NET_DISBURSEMENTS | NUMBER | (22) | ||
ADJUSTMENTS_PRIOR_PERIODS | NUMBER | (22) | ||
CASH_IN_HAND_END | NUMBER | (22) | ||
DAYS | NUMBER | |||
INTEREST_INCOME | NUMBER | (22) | ||
ADV_TO_SUBGRANTEES | NUMBER | (22) | ||
REMARKS | VARCHAR2 | (2000) | ||
CREATED_BY | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT AWARD_ID
, VERSION
, STATUS_CODE
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, DOCUMENT_NUMBER
, RUN_DATE
, REPORT_START_DATE
, REPORT_END_DATE
, LETTER_OF_CREDIT
, LAST_PAYMENT_VOUCHER_NUMBER
, PAYMENT_VOUCHER_CREDIT
, TREASURY_CHECK
, CASH_IN_HAND_BEGIN
, LETTER_OF_CREDIT_WITHDRAWLS
, TREASURY_CHECK_PAYMENTS
, TOTAL_RECEIPTS
, TOTAL_CASH_AVAIABLE
, GROSS_DISBURSEMENTS
, FEDERAL_SHARE_INCOME
, NET_DISBURSEMENTS
, ADJUSTMENTS_PRIOR_PERIODS
, CASH_IN_HAND_END
, DAYS
, INTEREST_INCOME
, ADV_TO_SUBGRANTEES
, REMARKS
, CREATED_BY
FROM GMS.GMS_272_HISTORY#;
|
|
|