VIEW: FV.FV_FACTS_REPORT_T2#

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, 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, DR_AMOUNT DR_AMOUNT, CR_AMOUNT CR_AMOUNT, JE_SOURCE JE_SOURCE, JE_CATEGORY JE_CATEGORY, GOVT_NON_GOVT GOVT_NON_GOVT, FACTS_ATTRIBUTE FACTS_ATTRIBUTE, REFERENCE_1 REFERENCE_1, REFERENCE_2 REFERENCE_2, REFERENCE_3 REFERENCE_3, REFERENCE_5 REFERENCE_5, REFERENCE_7 REFERENCE_7 from "FV"."FV_FACTS_REPORT_T2"

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
, 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
, DR_AMOUNT DR_AMOUNT
, CR_AMOUNT CR_AMOUNT
, JE_SOURCE JE_SOURCE
, JE_CATEGORY JE_CATEGORY
, GOVT_NON_GOVT GOVT_NON_GOVT
, FACTS_ATTRIBUTE FACTS_ATTRIBUTE
, REFERENCE_1 REFERENCE_1
, REFERENCE_2 REFERENCE_2
, REFERENCE_3 REFERENCE_3
, REFERENCE_5 REFERENCE_5
, REFERENCE_7 REFERENCE_7
FROM "FV"."FV_FACTS_REPORT_T2"