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: FV.FV_GTAS_ENDING_BALANCES#

Source

View Text - Preformatted


select ACCOUNT_TYPE ACCOUNT_TYPE, AMOUNT AMOUNT, AUTHORITY_TYPE_CODE AUTHORITY_TYPE_CODE, BEGINNING_BALANCE BEGINNING_BALANCE, BUDGET_IMPACT_IND BUDGET_IMPACT_IND, CCID CCID, CUST_NON_CUST CUST_NON_CUST, D_C_INDICATOR D_C_INDICATOR, END_BAL_IND END_BAL_IND, EXCH_NON_EXCH EXCH_NON_EXCH, FED_NON_FED FED_NON_FED, FISCAL_YEAR FISCAL_YEAR, FUND_VALUE FUND_VALUE, RECIPIENT_NAME RECIPIENT_NAME, RECORD_CATEGORY RECORD_CATEGORY, REPORTED_STATUS REPORTED_STATUS, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, TRADING_PARTNER_AGENCY_ID TRADING_PARTNER_AGENCY_ID, TRADING_PARTNER_MAIN_ACCOUNT TRADING_PARTNER_MAIN_ACCOUNT, USSGL_ACCOUNT USSGL_ACCOUNT, ACCOUNT_NUMBER ACCOUNT_NUMBER, DOLLAR_AMOUNT DOLLAR_AMOUNT from "FV"."FV_GTAS_ENDING_BALANCES"

View Text - HTML Formatted

SELECT ACCOUNT_TYPE ACCOUNT_TYPE
, AMOUNT AMOUNT
, AUTHORITY_TYPE_CODE AUTHORITY_TYPE_CODE
, BEGINNING_BALANCE BEGINNING_BALANCE
, BUDGET_IMPACT_IND BUDGET_IMPACT_IND
, CCID CCID
, CUST_NON_CUST CUST_NON_CUST
, D_C_INDICATOR D_C_INDICATOR
, END_BAL_IND END_BAL_IND
, EXCH_NON_EXCH EXCH_NON_EXCH
, FED_NON_FED FED_NON_FED
, FISCAL_YEAR FISCAL_YEAR
, FUND_VALUE FUND_VALUE
, RECIPIENT_NAME RECIPIENT_NAME
, RECORD_CATEGORY RECORD_CATEGORY
, REPORTED_STATUS REPORTED_STATUS
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, TRADING_PARTNER_AGENCY_ID TRADING_PARTNER_AGENCY_ID
, TRADING_PARTNER_MAIN_ACCOUNT TRADING_PARTNER_MAIN_ACCOUNT
, USSGL_ACCOUNT USSGL_ACCOUNT
, ACCOUNT_NUMBER ACCOUNT_NUMBER
, DOLLAR_AMOUNT DOLLAR_AMOUNT
FROM "FV"."FV_GTAS_ENDING_BALANCES"