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

Source

View Text - Preformatted


select FUND_GROUP FUND_GROUP, ACCOUNT_NUMBER ACCOUNT_NUMBER, DEPT_ID DEPT_ID, BUREAU_ID BUREAU_ID, D_C_INDICATOR D_C_INDICATOR, AMOUNT AMOUNT, BUSINESS_LINE BUSINESS_LINE, ELIMINATIONS_DEPT ELIMINATIONS_DEPT, G_NG_INDICATOR G_NG_INDICATOR, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, RECORD_CATEGORY RECORD_CATEGORY, FISCAL_YEAR FISCAL_YEAR, REPORTED_STATUS REPORTED_STATUS, USSGL_ACCOUNT USSGL_ACCOUNT, EXCH_NON_EXCH EXCH_NON_EXCH, CUST_NON_CUST CUST_NON_CUST, BUDGET_SUBFUNCTION BUDGET_SUBFUNCTION, FUND_VALUE FUND_VALUE, CCID CCID, BEGINNING_BALANCE BEGINNING_BALANCE, ACCOUNT_TYPE ACCOUNT_TYPE, RECIPIENT_NAME RECIPIENT_NAME from "FV"."FV_FACTS_ENDING_BALANCES"

View Text - HTML Formatted

SELECT FUND_GROUP FUND_GROUP
, ACCOUNT_NUMBER ACCOUNT_NUMBER
, DEPT_ID DEPT_ID
, BUREAU_ID BUREAU_ID
, D_C_INDICATOR D_C_INDICATOR
, AMOUNT AMOUNT
, BUSINESS_LINE BUSINESS_LINE
, ELIMINATIONS_DEPT ELIMINATIONS_DEPT
, G_NG_INDICATOR G_NG_INDICATOR
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, RECORD_CATEGORY RECORD_CATEGORY
, FISCAL_YEAR FISCAL_YEAR
, REPORTED_STATUS REPORTED_STATUS
, USSGL_ACCOUNT USSGL_ACCOUNT
, EXCH_NON_EXCH EXCH_NON_EXCH
, CUST_NON_CUST CUST_NON_CUST
, BUDGET_SUBFUNCTION BUDGET_SUBFUNCTION
, FUND_VALUE FUND_VALUE
, CCID CCID
, BEGINNING_BALANCE BEGINNING_BALANCE
, ACCOUNT_TYPE ACCOUNT_TYPE
, RECIPIENT_NAME RECIPIENT_NAME
FROM "FV"."FV_FACTS_ENDING_BALANCES"