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

Source

View Text - Preformatted


select CCID CCID, PERIOD_NUM PERIOD_NUM, PERIOD_NAME PERIOD_NAME, PERIOD_YEAR PERIOD_YEAR, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, FUND_GROUP FUND_GROUP, ACCOUNT_NUMBER ACCOUNT_NUMBER, FUND_VALUE FUND_VALUE, DEPT_ID DEPT_ID, BUREAU_ID BUREAU_ID, ELIMINATIONS_DEPT ELIMINATIONS_DEPT, G_NG_INDICATOR G_NG_INDICATOR, END_BAL_IND END_BAL_IND, REPORTED_GROUP REPORTED_GROUP, USSGL_ACCOUNT USSGL_ACCOUNT, EXCH_NON_EXCH EXCH_NON_EXCH, CUST_NON_CUST CUST_NON_CUST, BUDGET_SUBFUNCTION BUDGET_SUBFUNCTION, ACCOUNT_TYPE ACCOUNT_TYPE, NEW_REC_FLAG NEW_REC_FLAG, BALANCE_AMOUNT BALANCE_AMOUNT, BEGIN_BALANCE BEGIN_BALANCE, PERIOD_CY_DR_BAL PERIOD_CY_DR_BAL, PERIOD_CY_CR_BAL PERIOD_CY_CR_BAL, PERIOD_BEGIN_BAL PERIOD_BEGIN_BAL from "FV"."FV_FACTS1_PERIOD_ATTRIBUTES"

View Text - HTML Formatted

SELECT CCID CCID
, PERIOD_NUM PERIOD_NUM
, PERIOD_NAME PERIOD_NAME
, PERIOD_YEAR PERIOD_YEAR
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, FUND_GROUP FUND_GROUP
, ACCOUNT_NUMBER ACCOUNT_NUMBER
, FUND_VALUE FUND_VALUE
, DEPT_ID DEPT_ID
, BUREAU_ID BUREAU_ID
, ELIMINATIONS_DEPT ELIMINATIONS_DEPT
, G_NG_INDICATOR G_NG_INDICATOR
, END_BAL_IND END_BAL_IND
, REPORTED_GROUP REPORTED_GROUP
, USSGL_ACCOUNT USSGL_ACCOUNT
, EXCH_NON_EXCH EXCH_NON_EXCH
, CUST_NON_CUST CUST_NON_CUST
, BUDGET_SUBFUNCTION BUDGET_SUBFUNCTION
, ACCOUNT_TYPE ACCOUNT_TYPE
, NEW_REC_FLAG NEW_REC_FLAG
, BALANCE_AMOUNT BALANCE_AMOUNT
, BEGIN_BALANCE BEGIN_BALANCE
, PERIOD_CY_DR_BAL PERIOD_CY_DR_BAL
, PERIOD_CY_CR_BAL PERIOD_CY_CR_BAL
, PERIOD_BEGIN_BAL PERIOD_BEGIN_BAL
FROM "FV"."FV_FACTS1_PERIOD_ATTRIBUTES"