VIEW: FA.FA_RETIREMENTS#

Source

View Text - Preformatted

select RETIREMENT_ID RETIREMENT_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, ASSET_ID ASSET_ID, TRANSACTION_HEADER_ID_IN TRANSACTION_HEADER_ID_IN, DATE_RETIRED DATE_RETIRED, DATE_EFFECTIVE DATE_EFFECTIVE, COST_RETIRED COST_RETIRED, STATUS STATUS, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, RETIREMENT_PRORATE_CONVENTION RETIREMENT_PRORATE_CONVENTION, TRANSACTION_HEADER_ID_OUT TRANSACTION_HEADER_ID_OUT, UNITS UNITS, COST_OF_REMOVAL COST_OF_REMOVAL, NBV_RETIRED NBV_RETIRED, GAIN_LOSS_AMOUNT GAIN_LOSS_AMOUNT, PROCEEDS_OF_SALE PROCEEDS_OF_SALE, GAIN_LOSS_TYPE_CODE GAIN_LOSS_TYPE_CODE, RETIREMENT_TYPE_CODE RETIREMENT_TYPE_CODE, ITC_RECAPTURED ITC_RECAPTURED, 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, STL_DEPRN_AMOUNT STL_DEPRN_AMOUNT, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, 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_CODE ATTRIBUTE_CATEGORY_CODE, REVAL_RESERVE_RETIRED REVAL_RESERVE_RETIRED, UNREVALUED_COST_RETIRED UNREVALUED_COST_RETIRED, BONUS_RESERVE_RETIRED BONUS_RESERVE_RETIRED, 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_RETIREMENTS"

View Text - HTML Formatted

SELECT RETIREMENT_ID RETIREMENT_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, ASSET_ID ASSET_ID
, TRANSACTION_HEADER_ID_IN TRANSACTION_HEADER_ID_IN
, DATE_RETIRED DATE_RETIRED
, DATE_EFFECTIVE DATE_EFFECTIVE
, COST_RETIRED COST_RETIRED
, STATUS STATUS
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, RETIREMENT_PRORATE_CONVENTION RETIREMENT_PRORATE_CONVENTION
, TRANSACTION_HEADER_ID_OUT TRANSACTION_HEADER_ID_OUT
, UNITS UNITS
, COST_OF_REMOVAL COST_OF_REMOVAL
, NBV_RETIRED NBV_RETIRED
, GAIN_LOSS_AMOUNT GAIN_LOSS_AMOUNT
, PROCEEDS_OF_SALE PROCEEDS_OF_SALE
, GAIN_LOSS_TYPE_CODE GAIN_LOSS_TYPE_CODE
, RETIREMENT_TYPE_CODE RETIREMENT_TYPE_CODE
, ITC_RECAPTURED ITC_RECAPTURED
, 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
, STL_DEPRN_AMOUNT STL_DEPRN_AMOUNT
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, 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_CODE ATTRIBUTE_CATEGORY_CODE
, REVAL_RESERVE_RETIRED REVAL_RESERVE_RETIRED
, UNREVALUED_COST_RETIRED UNREVALUED_COST_RETIRED
, BONUS_RESERVE_RETIRED BONUS_RESERVE_RETIRED
, 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_RETIREMENTS"