VIEW: FV.FV_GTAS_REPORT_T2#

Source

View Text - Preformatted

select ACCOUNT_TYPE ACCOUNT_TYPE, EXCH_NON_EXCH EXCH_NON_EXCH, FUND_VALUE FUND_VALUE, G_NG_INDICATOR G_NG_INDICATOR, RECIPIENT_NAME RECIPIENT_NAME, RECORD_CATEGORY RECORD_CATEGORY, REPORTED_STATUS REPORTED_STATUS, USSGL_ACCOUNT USSGL_ACCOUNT, ACCOUNT_NUMBER ACCOUNT_NUMBER, AMOUNT AMOUNT, BEGINNING_BALANCE BEGINNING_BALANCE, BUDGET_SUBFUNCTION BUDGET_SUBFUNCTION, BUREAU_ID BUREAU_ID, BUSINESS_LINE BUSINESS_LINE, CCID CCID, CR_AMOUNT CR_AMOUNT, DEPT_ID DEPT_ID, DR_AMOUNT DR_AMOUNT, D_C_INDICATOR D_C_INDICATOR, FACTS_ATTRIBUTE FACTS_ATTRIBUTE, FISCAL_YEAR FISCAL_YEAR, FUND_GROUP FUND_GROUP, GOVT_NON_GOVT GOVT_NON_GOVT, JE_CATEGORY JE_CATEGORY, JE_SOURCE JE_SOURCE, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, CUST_NON_CUST CUST_NON_CUST, ELIMINATIONS_DEPT ELIMINATIONS_DEPT, REFERENCE_1 REFERENCE_1, REFERENCE_2 REFERENCE_2, REFERENCE_3 REFERENCE_3, REFERENCE_4 REFERENCE_4, REFERENCE_5 REFERENCE_5, SEGMENT1 SEGMENT1, SEGMENT2 SEGMENT2, SEGMENT3 SEGMENT3, SEGMENT4 SEGMENT4, SEGMENT5 SEGMENT5, SEGMENT6 SEGMENT6, SEGMENT7 SEGMENT7, SEGMENT8 SEGMENT8, SEGMENT9 SEGMENT9, SEGMENT10 SEGMENT10, SEGMENT11 SEGMENT11, SEGMENT12 SEGMENT12, SEGMENT13 SEGMENT13, SEGMENT14 SEGMENT14, SEGMENT15 SEGMENT15, SEGMENT16 SEGMENT16, SEGMENT17 SEGMENT17, SEGMENT18 SEGMENT18, SEGMENT19 SEGMENT19, SEGMENT20 SEGMENT20, SEGMENT21 SEGMENT21, SEGMENT22 SEGMENT22, SEGMENT23 SEGMENT23, SEGMENT24 SEGMENT24, SEGMENT25 SEGMENT25, SEGMENT26 SEGMENT26, SEGMENT27 SEGMENT27, SEGMENT28 SEGMENT28, SEGMENT29 SEGMENT29, SEGMENT30 SEGMENT30 from "FV"."FV_GTAS_REPORT_T2"

View Text - HTML Formatted

SELECT ACCOUNT_TYPE ACCOUNT_TYPE
, EXCH_NON_EXCH EXCH_NON_EXCH
, FUND_VALUE FUND_VALUE
, G_NG_INDICATOR G_NG_INDICATOR
, RECIPIENT_NAME RECIPIENT_NAME
, RECORD_CATEGORY RECORD_CATEGORY
, REPORTED_STATUS REPORTED_STATUS
, USSGL_ACCOUNT USSGL_ACCOUNT
, ACCOUNT_NUMBER ACCOUNT_NUMBER
, AMOUNT AMOUNT
, BEGINNING_BALANCE BEGINNING_BALANCE
, BUDGET_SUBFUNCTION BUDGET_SUBFUNCTION
, BUREAU_ID BUREAU_ID
, BUSINESS_LINE BUSINESS_LINE
, CCID CCID
, CR_AMOUNT CR_AMOUNT
, DEPT_ID DEPT_ID
, DR_AMOUNT DR_AMOUNT
, D_C_INDICATOR D_C_INDICATOR
, FACTS_ATTRIBUTE FACTS_ATTRIBUTE
, FISCAL_YEAR FISCAL_YEAR
, FUND_GROUP FUND_GROUP
, GOVT_NON_GOVT GOVT_NON_GOVT
, JE_CATEGORY JE_CATEGORY
, JE_SOURCE JE_SOURCE
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, CUST_NON_CUST CUST_NON_CUST
, ELIMINATIONS_DEPT ELIMINATIONS_DEPT
, REFERENCE_1 REFERENCE_1
, REFERENCE_2 REFERENCE_2
, REFERENCE_3 REFERENCE_3
, REFERENCE_4 REFERENCE_4
, REFERENCE_5 REFERENCE_5
, SEGMENT1 SEGMENT1
, SEGMENT2 SEGMENT2
, SEGMENT3 SEGMENT3
, SEGMENT4 SEGMENT4
, SEGMENT5 SEGMENT5
, SEGMENT6 SEGMENT6
, SEGMENT7 SEGMENT7
, SEGMENT8 SEGMENT8
, SEGMENT9 SEGMENT9
, SEGMENT10 SEGMENT10
, SEGMENT11 SEGMENT11
, SEGMENT12 SEGMENT12
, SEGMENT13 SEGMENT13
, SEGMENT14 SEGMENT14
, SEGMENT15 SEGMENT15
, SEGMENT16 SEGMENT16
, SEGMENT17 SEGMENT17
, SEGMENT18 SEGMENT18
, SEGMENT19 SEGMENT19
, SEGMENT20 SEGMENT20
, SEGMENT21 SEGMENT21
, SEGMENT22 SEGMENT22
, SEGMENT23 SEGMENT23
, SEGMENT24 SEGMENT24
, SEGMENT25 SEGMENT25
, SEGMENT26 SEGMENT26
, SEGMENT27 SEGMENT27
, SEGMENT28 SEGMENT28
, SEGMENT29 SEGMENT29
, SEGMENT30 SEGMENT30
FROM "FV"."FV_GTAS_REPORT_T2"