VIEW: FV.FV_GTAS_DETAIL_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 TRADING_PARTNER_AGENCY_ID, TRADING_PARTNER_MAIN_ACCOUNT TRADING_PARTNER_MAIN_ACCOUNT, BUDGET_IMPACT_IND BUDGET_IMPACT_IND, D_C_INDICATOR D_C_INDICATOR, DOLLAR_AMOUNT DOLLAR_AMOUNT, JE_HEADER_ID JE_HEADER_ID, JE_LINE_NUM JE_LINE_NUM, RECORD_CATEGORY RECORD_CATEGORY, CREATION_DATE CREATION_DATE, PARTY_ID PARTY_ID, PARTY_TYPE PARTY_TYPE, PARTY_CLASSIFICATION PARTY_CLASSIFICATION, AMOUNT AMOUNT from "FV"."FV_GTAS_DETAIL_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 TRADING_PARTNER_AGENCY_ID
, TRADING_PARTNER_MAIN_ACCOUNT TRADING_PARTNER_MAIN_ACCOUNT
, BUDGET_IMPACT_IND BUDGET_IMPACT_IND
, D_C_INDICATOR D_C_INDICATOR
, DOLLAR_AMOUNT DOLLAR_AMOUNT
, JE_HEADER_ID JE_HEADER_ID
, JE_LINE_NUM JE_LINE_NUM
, RECORD_CATEGORY RECORD_CATEGORY
, CREATION_DATE CREATION_DATE
, PARTY_ID PARTY_ID
, PARTY_TYPE PARTY_TYPE
, PARTY_CLASSIFICATION PARTY_CLASSIFICATION
, AMOUNT AMOUNT
FROM "FV"."FV_GTAS_DETAIL_BALANCES"