eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: FA.FA_GROUP_ASSET_RULES#

Source

View Text - Preformatted


select GROUP_ASSET_ID GROUP_ASSET_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, DATE_EFFECTIVE DATE_EFFECTIVE, REVAL_AMORTIZATION_BASIS REVAL_AMORTIZATION_BASIS, LIFE_IN_MONTHS LIFE_IN_MONTHS, DEPRN_METHOD_CODE DEPRN_METHOD_CODE, PRORATE_DATE PRORATE_DATE, DEPRN_START_DATE DEPRN_START_DATE, UNIT_OF_MEASURE UNIT_OF_MEASURE, ADJUST_ACCOUNT_BASE_FLAG ADJUST_ACCOUNT_BASE_FLAG, ADJUSTED_RATE ADJUSTED_RATE, BASE_CALCULATION_TYPE BASE_CALCULATION_TYPE, BASIC_RATE BASIC_RATE, CAPITAL_GAIN_THRESHOLD CAPITAL_GAIN_THRESHOLD, USE_DEPRECIATION_LIMITS_FLAG USE_DEPRECIATION_LIMITS_FLAG, ALLOWED_DEPRN_LIMIT_FLAG ALLOWED_DEPRN_LIMIT_FLAG, SPECIAL_DEPRN_LIMIT_AMOUNT SPECIAL_DEPRN_LIMIT_AMOUNT, PERCENT_SALVAGE_VALUE PERCENT_SALVAGE_VALUE, REDUCE_SALVAGE_VALUE_FLAG REDUCE_SALVAGE_VALUE_FLAG, STL_LIFE_IN_MONTHS STL_LIFE_IN_MONTHS, CREATION_DATE CREATION_DATE, CEILING_NAME CEILING_NAME, BONUS_RULE BONUS_RULE, DEPRECIABLE_BASIS_FLAG DEPRECIABLE_BASIS_FLAG, PRODUCTION_CAPACITY PRODUCTION_CAPACITY, ADJUSTED_CAPACITY ADJUSTED_CAPACITY, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, DATE_INEFFECTIVE DATE_INEFFECTIVE, PRORATE_CONVENTION_CODE PRORATE_CONVENTION_CODE, ITC_ELIGIBLE_FLAG ITC_ELIGIBLE_FLAG, USE_ITC_CEILINGS_FLAG USE_ITC_CEILINGS_FLAG, DEPRECIATE_FLAG DEPRECIATE_FLAG, STL_METHOD_CODE STL_METHOD_CODE from "FA"."FA_GROUP_ASSET_RULES"

View Text - HTML Formatted

SELECT GROUP_ASSET_ID GROUP_ASSET_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, DATE_EFFECTIVE DATE_EFFECTIVE
, REVAL_AMORTIZATION_BASIS REVAL_AMORTIZATION_BASIS
, LIFE_IN_MONTHS LIFE_IN_MONTHS
, DEPRN_METHOD_CODE DEPRN_METHOD_CODE
, PRORATE_DATE PRORATE_DATE
, DEPRN_START_DATE DEPRN_START_DATE
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, ADJUST_ACCOUNT_BASE_FLAG ADJUST_ACCOUNT_BASE_FLAG
, ADJUSTED_RATE ADJUSTED_RATE
, BASE_CALCULATION_TYPE BASE_CALCULATION_TYPE
, BASIC_RATE BASIC_RATE
, CAPITAL_GAIN_THRESHOLD CAPITAL_GAIN_THRESHOLD
, USE_DEPRECIATION_LIMITS_FLAG USE_DEPRECIATION_LIMITS_FLAG
, ALLOWED_DEPRN_LIMIT_FLAG ALLOWED_DEPRN_LIMIT_FLAG
, SPECIAL_DEPRN_LIMIT_AMOUNT SPECIAL_DEPRN_LIMIT_AMOUNT
, PERCENT_SALVAGE_VALUE PERCENT_SALVAGE_VALUE
, REDUCE_SALVAGE_VALUE_FLAG REDUCE_SALVAGE_VALUE_FLAG
, STL_LIFE_IN_MONTHS STL_LIFE_IN_MONTHS
, CREATION_DATE CREATION_DATE
, CEILING_NAME CEILING_NAME
, BONUS_RULE BONUS_RULE
, DEPRECIABLE_BASIS_FLAG DEPRECIABLE_BASIS_FLAG
, PRODUCTION_CAPACITY PRODUCTION_CAPACITY
, ADJUSTED_CAPACITY ADJUSTED_CAPACITY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DATE_INEFFECTIVE DATE_INEFFECTIVE
, PRORATE_CONVENTION_CODE PRORATE_CONVENTION_CODE
, ITC_ELIGIBLE_FLAG ITC_ELIGIBLE_FLAG
, USE_ITC_CEILINGS_FLAG USE_ITC_CEILINGS_FLAG
, DEPRECIATE_FLAG DEPRECIATE_FLAG
, STL_METHOD_CODE STL_METHOD_CODE
FROM "FA"."FA_GROUP_ASSET_RULES"