DBA Data[Home] [Help]

VIEW: FA.FA_SORP_UPG_CAGF#

Source

View Text - Preformatted

select BOOK_TYPE_CODE BOOK_TYPE_CODE, ASSET_ID ASSET_ID, ASSET_NUMBER ASSET_NUMBER, ASSET_DESCRIPTION ASSET_DESCRIPTION, DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE, CATEGORY_NAME CATEGORY_NAME, CURRENT_COST CURRENT_COST, DEPRICIATION_RESERVE DEPRICIATION_RESERVE, REVALUATION_RESERVE REVALUATION_RESERVE, IMPAIRMENT_RESERVE IMPAIRMENT_RESERVE, CAPITAL_ADJUSTMENT_ACCT_AMOUNT CAPITAL_ADJUSTMENT_ACCT_AMOUNT, GENERAL_FUND_ACCT_AMOUNT GENERAL_FUND_ACCT_AMOUNT from "FA"."FA_SORP_UPG_CAGF"
View Text - HTML Formatted

SELECT BOOK_TYPE_CODE BOOK_TYPE_CODE
, ASSET_ID ASSET_ID
, ASSET_NUMBER ASSET_NUMBER
, ASSET_DESCRIPTION ASSET_DESCRIPTION
, DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE
, CATEGORY_NAME CATEGORY_NAME
, CURRENT_COST CURRENT_COST
, DEPRICIATION_RESERVE DEPRICIATION_RESERVE
, REVALUATION_RESERVE REVALUATION_RESERVE
, IMPAIRMENT_RESERVE IMPAIRMENT_RESERVE
, CAPITAL_ADJUSTMENT_ACCT_AMOUNT CAPITAL_ADJUSTMENT_ACCT_AMOUNT
, GENERAL_FUND_ACCT_AMOUNT GENERAL_FUND_ACCT_AMOUNT
FROM "FA"."FA_SORP_UPG_CAGF"