VIEW: FV.FV_GTAS_ACTIVITY_BALANCES#

Source

View Text - Preformatted

select CCID CCID, PERIOD_NUM PERIOD_NUM, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, PERIOD_YEAR PERIOD_YEAR, JE_SOURCE JE_SOURCE, JE_CATEGORY JE_CATEGORY, FUND_VALUE FUND_VALUE, ACCOUNT_NUMBER ACCOUNT_NUMBER, AUTHORITY_TYPE_CODE AUTHORITY_TYPE_CODE, FED_NON_FED FED_NON_FED, TRADING_PARTNER_TYPE TRADING_PARTNER_TYPE, TRADING_PARTNER_NAME TRADING_PARTNER_NAME, TRADING_PARTNER_AGENCY_ID#1 TRADING_PARTNER_AGENCY_ID, TRADING_PARTNER_MAIN_ACCOUNT TRADING_PARTNER_MAIN_ACCOUNT, BUDGET_IMPACT_IND BUDGET_IMPACT_IND, D_C_INDICATOR D_C_INDICATOR, AMOUNT AMOUNT, JE_HEADER_ID JE_HEADER_ID, JE_LINE_NUM JE_LINE_NUM, RECORD_CATEGORY RECORD_CATEGORY, CREATION_DATE CREATION_DATE, GL_PERIOD GL_PERIOD, BALANCE_TYPE BALANCE_TYPE, TRADING_PARTNER_ID TRADING_PARTNER_ID, PERIOD_NAME PERIOD_NAME, EXCEPTION_CATEGORY EXCEPTION_CATEGORY, DOLLAR_AMOUNT DOLLAR_AMOUNT from "FV"."FV_GTAS_ACTIVITY_BALANCES"

View Text - HTML Formatted

SELECT CCID CCID
, PERIOD_NUM PERIOD_NUM
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, PERIOD_YEAR PERIOD_YEAR
, JE_SOURCE JE_SOURCE
, JE_CATEGORY JE_CATEGORY
, FUND_VALUE FUND_VALUE
, ACCOUNT_NUMBER ACCOUNT_NUMBER
, AUTHORITY_TYPE_CODE AUTHORITY_TYPE_CODE
, FED_NON_FED FED_NON_FED
, TRADING_PARTNER_TYPE TRADING_PARTNER_TYPE
, TRADING_PARTNER_NAME TRADING_PARTNER_NAME
, TRADING_PARTNER_AGENCY_ID#1 TRADING_PARTNER_AGENCY_ID
, TRADING_PARTNER_MAIN_ACCOUNT TRADING_PARTNER_MAIN_ACCOUNT
, BUDGET_IMPACT_IND BUDGET_IMPACT_IND
, D_C_INDICATOR D_C_INDICATOR
, AMOUNT AMOUNT
, JE_HEADER_ID JE_HEADER_ID
, JE_LINE_NUM JE_LINE_NUM
, RECORD_CATEGORY RECORD_CATEGORY
, CREATION_DATE CREATION_DATE
, GL_PERIOD GL_PERIOD
, BALANCE_TYPE BALANCE_TYPE
, TRADING_PARTNER_ID TRADING_PARTNER_ID
, PERIOD_NAME PERIOD_NAME
, EXCEPTION_CATEGORY EXCEPTION_CATEGORY
, DOLLAR_AMOUNT DOLLAR_AMOUNT
FROM "FV"."FV_GTAS_ACTIVITY_BALANCES"