[Home] [Help]
View: FVFV_FEDERAL_ACCOUNT_SYMBOLS
Product: | FV - Federal Financials |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT FFA.FEDERAL_ACCT_SYMBOL_ID
, FFA.TREASURY_DEPT_CODE
, FFA.TREASURY_ACCT_CODE
, FFA.FEDERAL_ACCT_SYMBOL_NAME
, '_LA:FINANCING_ACCOUNT:FV_LOOKUP_CODES:FINANCING_ACCOUNT:DESCRIPTION'
, FFA.COHORT_SEGMENT_NAME
, FFA.START_DATE
, FFA.END_DATE
, GSB.NAME
, FFA.SET_OF_BOOKS_ID
, '_DF:FV:FV_FACTS_FA_DESC:FFA'
, FFA.CREATION_DATE
, FFA.CREATED_BY
, FFA.LAST_UPDATE_DATE
, FFA.LAST_UPDATED_BY
, FFA.LAST_UPDATE_LOGIN
FROM FV_FACTS_FEDERAL_ACCOUNTS FFA
, GL_SETS_OF_BOOKS GSB
WHERE GSB.SET_OF_BOOKS_ID = FFA.SET_OF_BOOKS_ID WITH READ ONLY
Columns
Name |
FEDERAL_ACCT_SYMBOL_ID |
TREASURY_DEPT_CODE |
TREASURY_ACCT_CODE |
FEDERAL_ACCT_SYMBOL_NAME |
"_LA:FINANCING_ACCOUNT" |
COHORT_SEGMENT_NAME |
START_DATE |
END_DATE |
SET_OF_BOOKS_NAME |
SET_OF_BOOKS_ID |
"_DF" |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |