VIEW: FA.FA_CATEGORY_BOOK_DEFAULTS#

Source

View Text - Preformatted

select CATEGORY_ID CATEGORY_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, START_DPIS START_DPIS, END_DPIS END_DPIS, LIFE_IN_MONTHS LIFE_IN_MONTHS, DEPRN_METHOD DEPRN_METHOD, PRORATE_CONVENTION_CODE PRORATE_CONVENTION_CODE, ITC_ELIGIBLE_FLAG ITC_ELIGIBLE_FLAG, USE_ITC_CEILINGS_FLAG USE_ITC_CEILINGS_FLAG, CEILING_NAME CEILING_NAME, BASIC_RATE BASIC_RATE, ADJUSTED_RATE ADJUSTED_RATE, BONUS_RULE BONUS_RULE, DEPRECIATE_FLAG DEPRECIATE_FLAG, RETIREMENT_PRORATE_CONVENTION RETIREMENT_PRORATE_CONVENTION, PRICE_INDEX_NAME PRICE_INDEX_NAME, USE_STL_RETIREMENTS_FLAG USE_STL_RETIREMENTS_FLAG, STL_METHOD_CODE STL_METHOD_CODE, STL_LIFE_IN_MONTHS STL_LIFE_IN_MONTHS, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SUBCOMPONENT_LIFE_RULE SUBCOMPONENT_LIFE_RULE, MINIMUM_LIFE_IN_MONTHS MINIMUM_LIFE_IN_MONTHS, PRODUCTION_CAPACITY PRODUCTION_CAPACITY, UNIT_OF_MEASURE UNIT_OF_MEASURE, CAPITAL_GAIN_THRESHOLD CAPITAL_GAIN_THRESHOLD, 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, USE_DEPRN_LIMITS_FLAG USE_DEPRN_LIMITS_FLAG, ALLOWED_DEPRN_LIMIT ALLOWED_DEPRN_LIMIT, SPECIAL_DEPRN_LIMIT_AMOUNT SPECIAL_DEPRN_LIMIT_AMOUNT, PERCENT_SALVAGE_VALUE PERCENT_SALVAGE_VALUE, CUA_LIFE_END_DATE CUA_LIFE_END_DATE, CUA_RULE_SET_ID CUA_RULE_SET_ID, GROUP_ASSET_ID GROUP_ASSET_ID, MASS_PROPERTY_FLAG MASS_PROPERTY_FLAG, RECOGNIZE_GAIN_LOSS RECOGNIZE_GAIN_LOSS, RECAPTURE_RESERVE_FLAG RECAPTURE_RESERVE_FLAG, LIMIT_PROCEEDS_FLAG LIMIT_PROCEEDS_FLAG, TERMINAL_GAIN_LOSS TERMINAL_GAIN_LOSS, TRACKING_METHOD TRACKING_METHOD, EXCLUDE_FULLY_RSV_FLAG EXCLUDE_FULLY_RSV_FLAG, EXCESS_ALLOCATION_OPTION EXCESS_ALLOCATION_OPTION, DEPRECIATION_OPTION DEPRECIATION_OPTION, MEMBER_ROLLUP_FLAG MEMBER_ROLLUP_FLAG, ALLOCATE_TO_FULLY_RSV_FLAG ALLOCATE_TO_FULLY_RSV_FLAG, ALLOCATE_TO_FULLY_RET_FLAG ALLOCATE_TO_FULLY_RET_FLAG from "FA"."FA_CATEGORY_BOOK_DEFAULTS"

View Text - HTML Formatted

SELECT CATEGORY_ID CATEGORY_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, START_DPIS START_DPIS
, END_DPIS END_DPIS
, LIFE_IN_MONTHS LIFE_IN_MONTHS
, DEPRN_METHOD DEPRN_METHOD
, PRORATE_CONVENTION_CODE PRORATE_CONVENTION_CODE
, ITC_ELIGIBLE_FLAG ITC_ELIGIBLE_FLAG
, USE_ITC_CEILINGS_FLAG USE_ITC_CEILINGS_FLAG
, CEILING_NAME CEILING_NAME
, BASIC_RATE BASIC_RATE
, ADJUSTED_RATE ADJUSTED_RATE
, BONUS_RULE BONUS_RULE
, DEPRECIATE_FLAG DEPRECIATE_FLAG
, RETIREMENT_PRORATE_CONVENTION RETIREMENT_PRORATE_CONVENTION
, PRICE_INDEX_NAME PRICE_INDEX_NAME
, USE_STL_RETIREMENTS_FLAG USE_STL_RETIREMENTS_FLAG
, STL_METHOD_CODE STL_METHOD_CODE
, STL_LIFE_IN_MONTHS STL_LIFE_IN_MONTHS
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SUBCOMPONENT_LIFE_RULE SUBCOMPONENT_LIFE_RULE
, MINIMUM_LIFE_IN_MONTHS MINIMUM_LIFE_IN_MONTHS
, PRODUCTION_CAPACITY PRODUCTION_CAPACITY
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, CAPITAL_GAIN_THRESHOLD CAPITAL_GAIN_THRESHOLD
, 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
, USE_DEPRN_LIMITS_FLAG USE_DEPRN_LIMITS_FLAG
, ALLOWED_DEPRN_LIMIT ALLOWED_DEPRN_LIMIT
, SPECIAL_DEPRN_LIMIT_AMOUNT SPECIAL_DEPRN_LIMIT_AMOUNT
, PERCENT_SALVAGE_VALUE PERCENT_SALVAGE_VALUE
, CUA_LIFE_END_DATE CUA_LIFE_END_DATE
, CUA_RULE_SET_ID CUA_RULE_SET_ID
, GROUP_ASSET_ID GROUP_ASSET_ID
, MASS_PROPERTY_FLAG MASS_PROPERTY_FLAG
, RECOGNIZE_GAIN_LOSS RECOGNIZE_GAIN_LOSS
, RECAPTURE_RESERVE_FLAG RECAPTURE_RESERVE_FLAG
, LIMIT_PROCEEDS_FLAG LIMIT_PROCEEDS_FLAG
, TERMINAL_GAIN_LOSS TERMINAL_GAIN_LOSS
, TRACKING_METHOD TRACKING_METHOD
, EXCLUDE_FULLY_RSV_FLAG EXCLUDE_FULLY_RSV_FLAG
, EXCESS_ALLOCATION_OPTION EXCESS_ALLOCATION_OPTION
, DEPRECIATION_OPTION DEPRECIATION_OPTION
, MEMBER_ROLLUP_FLAG MEMBER_ROLLUP_FLAG
, ALLOCATE_TO_FULLY_RSV_FLAG ALLOCATE_TO_FULLY_RSV_FLAG
, ALLOCATE_TO_FULLY_RET_FLAG ALLOCATE_TO_FULLY_RET_FLAG
FROM "FA"."FA_CATEGORY_BOOK_DEFAULTS"