VIEW: FA.FA_MC_RETIREMENTS#

Source

View Text - Preformatted

select SET_OF_BOOKS_ID SET_OF_BOOKS_ID, RETIREMENT_ID RETIREMENT_ID, COST_RETIRED COST_RETIRED, STATUS STATUS, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, COST_OF_REMOVAL COST_OF_REMOVAL, NBV_RETIRED NBV_RETIRED, GAIN_LOSS_AMOUNT GAIN_LOSS_AMOUNT, PROCEEDS_OF_SALE PROCEEDS_OF_SALE, ITC_RECAPTURED ITC_RECAPTURED, STL_DEPRN_AMOUNT STL_DEPRN_AMOUNT, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REVAL_RESERVE_RETIRED REVAL_RESERVE_RETIRED, UNREVALUED_COST_RETIRED UNREVALUED_COST_RETIRED, CONVERTED_FLAG CONVERTED_FLAG, BONUS_RESERVE_RETIRED BONUS_RESERVE_RETIRED, BOOK_TYPE_CODE BOOK_TYPE_CODE, ASSET_ID ASSET_ID, TRANSACTION_HEADER_ID_IN TRANSACTION_HEADER_ID_IN, TRANSACTION_HEADER_ID_OUT TRANSACTION_HEADER_ID_OUT, DATE_RETIRED DATE_RETIRED, DATE_EFFECTIVE DATE_EFFECTIVE, RETIREMENT_PRORATE_CONVENTION RETIREMENT_PRORATE_CONVENTION, UNITS UNITS, GAIN_LOSS_TYPE_CODE GAIN_LOSS_TYPE_CODE, RETIREMENT_TYPE_CODE RETIREMENT_TYPE_CODE, ITC_RECAPTURE_ID ITC_RECAPTURE_ID, REFERENCE_NUM REFERENCE_NUM, SOLD_TO SOLD_TO, TRADE_IN_ASSET_ID TRADE_IN_ASSET_ID, STL_METHOD_CODE STL_METHOD_CODE, STL_LIFE_IN_MONTHS STL_LIFE_IN_MONTHS, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, 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_CODE ATTRIBUTE_CATEGORY_CODE, RECOGNIZE_GAIN_LOSS RECOGNIZE_GAIN_LOSS, REDUCTION_RATE REDUCTION_RATE, RECAPTURE_RESERVE_FLAG RECAPTURE_RESERVE_FLAG, LIMIT_PROCEEDS_FLAG LIMIT_PROCEEDS_FLAG, TERMINAL_GAIN_LOSS TERMINAL_GAIN_LOSS, RESERVE_RETIRED RESERVE_RETIRED, RECAPTURE_AMOUNT RECAPTURE_AMOUNT, EOFY_RESERVE EOFY_RESERVE, IMPAIR_RESERVE_RETIRED IMPAIR_RESERVE_RETIRED from "FA"."FA_MC_RETIREMENTS"

View Text - HTML Formatted

SELECT SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, RETIREMENT_ID RETIREMENT_ID
, COST_RETIRED COST_RETIRED
, STATUS STATUS
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, COST_OF_REMOVAL COST_OF_REMOVAL
, NBV_RETIRED NBV_RETIRED
, GAIN_LOSS_AMOUNT GAIN_LOSS_AMOUNT
, PROCEEDS_OF_SALE PROCEEDS_OF_SALE
, ITC_RECAPTURED ITC_RECAPTURED
, STL_DEPRN_AMOUNT STL_DEPRN_AMOUNT
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REVAL_RESERVE_RETIRED REVAL_RESERVE_RETIRED
, UNREVALUED_COST_RETIRED UNREVALUED_COST_RETIRED
, CONVERTED_FLAG CONVERTED_FLAG
, BONUS_RESERVE_RETIRED BONUS_RESERVE_RETIRED
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, ASSET_ID ASSET_ID
, TRANSACTION_HEADER_ID_IN TRANSACTION_HEADER_ID_IN
, TRANSACTION_HEADER_ID_OUT TRANSACTION_HEADER_ID_OUT
, DATE_RETIRED DATE_RETIRED
, DATE_EFFECTIVE DATE_EFFECTIVE
, RETIREMENT_PRORATE_CONVENTION RETIREMENT_PRORATE_CONVENTION
, UNITS UNITS
, GAIN_LOSS_TYPE_CODE GAIN_LOSS_TYPE_CODE
, RETIREMENT_TYPE_CODE RETIREMENT_TYPE_CODE
, ITC_RECAPTURE_ID ITC_RECAPTURE_ID
, REFERENCE_NUM REFERENCE_NUM
, SOLD_TO SOLD_TO
, TRADE_IN_ASSET_ID TRADE_IN_ASSET_ID
, STL_METHOD_CODE STL_METHOD_CODE
, STL_LIFE_IN_MONTHS STL_LIFE_IN_MONTHS
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, 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_CODE ATTRIBUTE_CATEGORY_CODE
, RECOGNIZE_GAIN_LOSS RECOGNIZE_GAIN_LOSS
, REDUCTION_RATE REDUCTION_RATE
, RECAPTURE_RESERVE_FLAG RECAPTURE_RESERVE_FLAG
, LIMIT_PROCEEDS_FLAG LIMIT_PROCEEDS_FLAG
, TERMINAL_GAIN_LOSS TERMINAL_GAIN_LOSS
, RESERVE_RETIRED RESERVE_RETIRED
, RECAPTURE_AMOUNT RECAPTURE_AMOUNT
, EOFY_RESERVE EOFY_RESERVE
, IMPAIR_RESERVE_RETIRED IMPAIR_RESERVE_RETIRED
FROM "FA"."FA_MC_RETIREMENTS"