VIEW: FV.FV_GTAS_ATTRIBUTES#

Source

View Text - Preformatted

select SET_OF_BOOKS_ID SET_OF_BOOKS_ID, SGL_ATTRIBUTES_ID SGL_ATTRIBUTES_ID, GTAS_ACCT_NUMBER GTAS_ACCT_NUMBER, USSGL_ACCT_NUMBER USSGL_ACCT_NUMBER, BALANCE_TYPE BALANCE_TYPE, FED_NON_FED1 FED_NON_FED1, FED_NON_FED2 FED_NON_FED2, FED_NON_FED3 FED_NON_FED3, EXCH_NON_EXCH1 EXCH_NON_EXCH1, EXCH_NON_EXCH2 EXCH_NON_EXCH2, EXCH_NON_EXCH3 EXCH_NON_EXCH3, CUST_NON_CUST1 CUST_NON_CUST1, CUST_NON_CUST2 CUST_NON_CUST2, AUTHORITY_TYPE1 AUTHORITY_TYPE1, AUTHORITY_TYPE2 AUTHORITY_TYPE2, AUTHORITY_TYPE3 AUTHORITY_TYPE3, AUTHORITY_TYPE4 AUTHORITY_TYPE4, AUTHORITY_TYPE5 AUTHORITY_TYPE5, AUTHORITY_TYPE6 AUTHORITY_TYPE6, APPORTIONMENT_CATEGORY1 APPORTIONMENT_CATEGORY1, APPORTIONMENT_CATEGORY2 APPORTIONMENT_CATEGORY2, APPORTIONMENT_CATEGORY3 APPORTIONMENT_CATEGORY3, NEW_BAL_CODE1 NEW_BAL_CODE1, NEW_BAL_CODE2 NEW_BAL_CODE2, CUR_SUB_CODE1 CUR_SUB_CODE1, CUR_SUB_CODE2 CUR_SUB_CODE2, BEA_CATEGORY1 BEA_CATEGORY1, BEA_CATEGORY2 BEA_CATEGORY2, BEA_CATEGORY_ACCT_TYPE BEA_CATEGORY_ACCT_TYPE, BORROWING_SOURCE1 BORROWING_SOURCE1, BORROWING_SOURCE2 BORROWING_SOURCE2, BORROWING_SOURCE3 BORROWING_SOURCE3, PYA_CODE1 PYA_CODE1, PYA_CODE2 PYA_CODE2, PYA_CODE3 PYA_CODE3, DIR_REIMB_CODE1 DIR_REIMB_CODE1, DIR_REIMB_CODE2 DIR_REIMB_CODE2, BUD_IMPACT_IND1 BUD_IMPACT_IND1, BUD_IMPACT_IND2 BUD_IMPACT_IND2, PROG_COST_IND1 PROG_COST_IND1, PROG_COST_IND2 PROG_COST_IND2, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, DIRECT_OR_REIMB_FLAG DIRECT_OR_REIMB_FLAG, APPOR_CAT_B_PROG_FLAG APPOR_CAT_B_PROG_FLAG, PROG_REP_CAT_FLAG PROG_REP_CAT_FLAG, BEA_CATEGORY_FLAG BEA_CATEGORY_FLAG, BORROWING_SOURCE_FLAG BORROWING_SOURCE_FLAG, PROGRAM_COST_IND_FLAG PROGRAM_COST_IND_FLAG, NEW_OR_BAL_FLAG NEW_OR_BAL_FLAG, TRADING_PARTNER_FLAG TRADING_PARTNER_FLAG from "FV"."FV_GTAS_ATTRIBUTES"

View Text - HTML Formatted

SELECT SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, SGL_ATTRIBUTES_ID SGL_ATTRIBUTES_ID
, GTAS_ACCT_NUMBER GTAS_ACCT_NUMBER
, USSGL_ACCT_NUMBER USSGL_ACCT_NUMBER
, BALANCE_TYPE BALANCE_TYPE
, FED_NON_FED1 FED_NON_FED1
, FED_NON_FED2 FED_NON_FED2
, FED_NON_FED3 FED_NON_FED3
, EXCH_NON_EXCH1 EXCH_NON_EXCH1
, EXCH_NON_EXCH2 EXCH_NON_EXCH2
, EXCH_NON_EXCH3 EXCH_NON_EXCH3
, CUST_NON_CUST1 CUST_NON_CUST1
, CUST_NON_CUST2 CUST_NON_CUST2
, AUTHORITY_TYPE1 AUTHORITY_TYPE1
, AUTHORITY_TYPE2 AUTHORITY_TYPE2
, AUTHORITY_TYPE3 AUTHORITY_TYPE3
, AUTHORITY_TYPE4 AUTHORITY_TYPE4
, AUTHORITY_TYPE5 AUTHORITY_TYPE5
, AUTHORITY_TYPE6 AUTHORITY_TYPE6
, APPORTIONMENT_CATEGORY1 APPORTIONMENT_CATEGORY1
, APPORTIONMENT_CATEGORY2 APPORTIONMENT_CATEGORY2
, APPORTIONMENT_CATEGORY3 APPORTIONMENT_CATEGORY3
, NEW_BAL_CODE1 NEW_BAL_CODE1
, NEW_BAL_CODE2 NEW_BAL_CODE2
, CUR_SUB_CODE1 CUR_SUB_CODE1
, CUR_SUB_CODE2 CUR_SUB_CODE2
, BEA_CATEGORY1 BEA_CATEGORY1
, BEA_CATEGORY2 BEA_CATEGORY2
, BEA_CATEGORY_ACCT_TYPE BEA_CATEGORY_ACCT_TYPE
, BORROWING_SOURCE1 BORROWING_SOURCE1
, BORROWING_SOURCE2 BORROWING_SOURCE2
, BORROWING_SOURCE3 BORROWING_SOURCE3
, PYA_CODE1 PYA_CODE1
, PYA_CODE2 PYA_CODE2
, PYA_CODE3 PYA_CODE3
, DIR_REIMB_CODE1 DIR_REIMB_CODE1
, DIR_REIMB_CODE2 DIR_REIMB_CODE2
, BUD_IMPACT_IND1 BUD_IMPACT_IND1
, BUD_IMPACT_IND2 BUD_IMPACT_IND2
, PROG_COST_IND1 PROG_COST_IND1
, PROG_COST_IND2 PROG_COST_IND2
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, DIRECT_OR_REIMB_FLAG DIRECT_OR_REIMB_FLAG
, APPOR_CAT_B_PROG_FLAG APPOR_CAT_B_PROG_FLAG
, PROG_REP_CAT_FLAG PROG_REP_CAT_FLAG
, BEA_CATEGORY_FLAG BEA_CATEGORY_FLAG
, BORROWING_SOURCE_FLAG BORROWING_SOURCE_FLAG
, PROGRAM_COST_IND_FLAG PROGRAM_COST_IND_FLAG
, NEW_OR_BAL_FLAG NEW_OR_BAL_FLAG
, TRADING_PARTNER_FLAG TRADING_PARTNER_FLAG
FROM "FV"."FV_GTAS_ATTRIBUTES"