VIEW: FA.FA_BOOKS#

Source

View Text - Preformatted

select BOOK_TYPE_CODE BOOK_TYPE_CODE, ASSET_ID ASSET_ID, DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE, DATE_EFFECTIVE DATE_EFFECTIVE, DEPRN_START_DATE DEPRN_START_DATE, DEPRN_METHOD_CODE DEPRN_METHOD_CODE, LIFE_IN_MONTHS LIFE_IN_MONTHS, RATE_ADJUSTMENT_FACTOR RATE_ADJUSTMENT_FACTOR, ADJUSTED_COST ADJUSTED_COST, COST COST, ORIGINAL_COST ORIGINAL_COST, SALVAGE_VALUE SALVAGE_VALUE, PRORATE_CONVENTION_CODE PRORATE_CONVENTION_CODE, PRORATE_DATE PRORATE_DATE, COST_CHANGE_FLAG COST_CHANGE_FLAG, ADJUSTMENT_REQUIRED_STATUS ADJUSTMENT_REQUIRED_STATUS, CAPITALIZE_FLAG CAPITALIZE_FLAG, RETIREMENT_PENDING_FLAG RETIREMENT_PENDING_FLAG, DEPRECIATE_FLAG DEPRECIATE_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, DATE_INEFFECTIVE DATE_INEFFECTIVE, TRANSACTION_HEADER_ID_IN TRANSACTION_HEADER_ID_IN, TRANSACTION_HEADER_ID_OUT TRANSACTION_HEADER_ID_OUT, ITC_AMOUNT_ID ITC_AMOUNT_ID, ITC_AMOUNT ITC_AMOUNT, RETIREMENT_ID RETIREMENT_ID, TAX_REQUEST_ID TAX_REQUEST_ID, ITC_BASIS ITC_BASIS, BASIC_RATE BASIC_RATE, ADJUSTED_RATE ADJUSTED_RATE, BONUS_RULE BONUS_RULE, CEILING_NAME CEILING_NAME, RECOVERABLE_COST RECOVERABLE_COST, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ADJUSTED_CAPACITY ADJUSTED_CAPACITY, FULLY_RSVD_REVALS_COUNTER FULLY_RSVD_REVALS_COUNTER, IDLED_FLAG IDLED_FLAG, PERIOD_COUNTER_CAPITALIZED PERIOD_COUNTER_CAPITALIZED, PERIOD_COUNTER_FULLY_RESERVED PERIOD_COUNTER_FULLY_RESERVED, PERIOD_COUNTER_FULLY_RETIRED PERIOD_COUNTER_FULLY_RETIRED, PRODUCTION_CAPACITY PRODUCTION_CAPACITY, REVAL_AMORTIZATION_BASIS REVAL_AMORTIZATION_BASIS, REVAL_CEILING REVAL_CEILING, UNIT_OF_MEASURE UNIT_OF_MEASURE, UNREVALUED_COST UNREVALUED_COST, ANNUAL_DEPRN_ROUNDING_FLAG ANNUAL_DEPRN_ROUNDING_FLAG, PERCENT_SALVAGE_VALUE PERCENT_SALVAGE_VALUE, ALLOWED_DEPRN_LIMIT ALLOWED_DEPRN_LIMIT, ALLOWED_DEPRN_LIMIT_AMOUNT ALLOWED_DEPRN_LIMIT_AMOUNT, PERIOD_COUNTER_LIFE_COMPLETE PERIOD_COUNTER_LIFE_COMPLETE, ADJUSTED_RECOVERABLE_COST ADJUSTED_RECOVERABLE_COST, ANNUAL_ROUNDING_FLAG ANNUAL_ROUNDING_FLAG, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, EOFY_ADJ_COST EOFY_ADJ_COST, EOFY_FORMULA_FACTOR EOFY_FORMULA_FACTOR, SHORT_FISCAL_YEAR_FLAG SHORT_FISCAL_YEAR_FLAG, CONVERSION_DATE CONVERSION_DATE, ORIGINAL_DEPRN_START_DATE ORIGINAL_DEPRN_START_DATE, REMAINING_LIFE1 REMAINING_LIFE1, REMAINING_LIFE2 REMAINING_LIFE2, OLD_ADJUSTED_COST OLD_ADJUSTED_COST, FORMULA_FACTOR FORMULA_FACTOR, GROUP_ASSET_ID GROUP_ASSET_ID, SALVAGE_TYPE SALVAGE_TYPE, DEPRN_LIMIT_TYPE DEPRN_LIMIT_TYPE, REDUCTION_RATE REDUCTION_RATE, REDUCE_ADDITION_FLAG REDUCE_ADDITION_FLAG, REDUCE_ADJUSTMENT_FLAG REDUCE_ADJUSTMENT_FLAG, REDUCE_RETIREMENT_FLAG REDUCE_RETIREMENT_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, TERMINAL_GAIN_LOSS_AMOUNT TERMINAL_GAIN_LOSS_AMOUNT, CIP_COST CIP_COST, YTD_PROCEEDS YTD_PROCEEDS, LTD_PROCEEDS LTD_PROCEEDS, LTD_COST_OF_REMOVAL LTD_COST_OF_REMOVAL, EOFY_RESERVE EOFY_RESERVE, PRIOR_EOFY_RESERVE PRIOR_EOFY_RESERVE, EOP_ADJ_COST EOP_ADJ_COST, EOP_FORMULA_FACTOR EOP_FORMULA_FACTOR, EXCLUDE_PROCEEDS_FROM_BASIS EXCLUDE_PROCEEDS_FROM_BASIS, RETIREMENT_DEPRN_OPTION RETIREMENT_DEPRN_OPTION, TERMINAL_GAIN_LOSS_FLAG TERMINAL_GAIN_LOSS_FLAG, SUPER_GROUP_ID SUPER_GROUP_ID, OVER_DEPRECIATE_OPTION OVER_DEPRECIATE_OPTION, DISABLED_FLAG DISABLED_FLAG, OLD_ADJUSTED_CAPACITY OLD_ADJUSTED_CAPACITY, DRY_HOLE_FLAG DRY_HOLE_FLAG, CASH_GENERATING_UNIT_ID CASH_GENERATING_UNIT_ID, CONTRACT_ID CONTRACT_ID, EXTENDED_DEPRN_FLAG EXTENDED_DEPRN_FLAG, EXTENDED_DEPRECIATION_PERIOD EXTENDED_DEPRECIATION_PERIOD, PERIOD_COUNTER_FULLY_EXTENDED PERIOD_COUNTER_FULLY_EXTENDED, RATE_IN_USE RATE_IN_USE, NBV_AT_SWITCH NBV_AT_SWITCH, PRIOR_DEPRN_LIMIT_TYPE PRIOR_DEPRN_LIMIT_TYPE, PRIOR_DEPRN_LIMIT_AMOUNT PRIOR_DEPRN_LIMIT_AMOUNT, PRIOR_DEPRN_LIMIT PRIOR_DEPRN_LIMIT, PRIOR_DEPRN_METHOD PRIOR_DEPRN_METHOD, PRIOR_LIFE_IN_MONTHS PRIOR_LIFE_IN_MONTHS, PRIOR_BASIC_RATE PRIOR_BASIC_RATE, PRIOR_ADJUSTED_RATE PRIOR_ADJUSTED_RATE from "FA"."FA_BOOKS"

View Text - HTML Formatted

SELECT BOOK_TYPE_CODE BOOK_TYPE_CODE
, ASSET_ID ASSET_ID
, DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE
, DATE_EFFECTIVE DATE_EFFECTIVE
, DEPRN_START_DATE DEPRN_START_DATE
, DEPRN_METHOD_CODE DEPRN_METHOD_CODE
, LIFE_IN_MONTHS LIFE_IN_MONTHS
, RATE_ADJUSTMENT_FACTOR RATE_ADJUSTMENT_FACTOR
, ADJUSTED_COST ADJUSTED_COST
, COST COST
, ORIGINAL_COST ORIGINAL_COST
, SALVAGE_VALUE SALVAGE_VALUE
, PRORATE_CONVENTION_CODE PRORATE_CONVENTION_CODE
, PRORATE_DATE PRORATE_DATE
, COST_CHANGE_FLAG COST_CHANGE_FLAG
, ADJUSTMENT_REQUIRED_STATUS ADJUSTMENT_REQUIRED_STATUS
, CAPITALIZE_FLAG CAPITALIZE_FLAG
, RETIREMENT_PENDING_FLAG RETIREMENT_PENDING_FLAG
, DEPRECIATE_FLAG DEPRECIATE_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, DATE_INEFFECTIVE DATE_INEFFECTIVE
, TRANSACTION_HEADER_ID_IN TRANSACTION_HEADER_ID_IN
, TRANSACTION_HEADER_ID_OUT TRANSACTION_HEADER_ID_OUT
, ITC_AMOUNT_ID ITC_AMOUNT_ID
, ITC_AMOUNT ITC_AMOUNT
, RETIREMENT_ID RETIREMENT_ID
, TAX_REQUEST_ID TAX_REQUEST_ID
, ITC_BASIS ITC_BASIS
, BASIC_RATE BASIC_RATE
, ADJUSTED_RATE ADJUSTED_RATE
, BONUS_RULE BONUS_RULE
, CEILING_NAME CEILING_NAME
, RECOVERABLE_COST RECOVERABLE_COST
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ADJUSTED_CAPACITY ADJUSTED_CAPACITY
, FULLY_RSVD_REVALS_COUNTER FULLY_RSVD_REVALS_COUNTER
, IDLED_FLAG IDLED_FLAG
, PERIOD_COUNTER_CAPITALIZED PERIOD_COUNTER_CAPITALIZED
, PERIOD_COUNTER_FULLY_RESERVED PERIOD_COUNTER_FULLY_RESERVED
, PERIOD_COUNTER_FULLY_RETIRED PERIOD_COUNTER_FULLY_RETIRED
, PRODUCTION_CAPACITY PRODUCTION_CAPACITY
, REVAL_AMORTIZATION_BASIS REVAL_AMORTIZATION_BASIS
, REVAL_CEILING REVAL_CEILING
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, UNREVALUED_COST UNREVALUED_COST
, ANNUAL_DEPRN_ROUNDING_FLAG ANNUAL_DEPRN_ROUNDING_FLAG
, PERCENT_SALVAGE_VALUE PERCENT_SALVAGE_VALUE
, ALLOWED_DEPRN_LIMIT ALLOWED_DEPRN_LIMIT
, ALLOWED_DEPRN_LIMIT_AMOUNT ALLOWED_DEPRN_LIMIT_AMOUNT
, PERIOD_COUNTER_LIFE_COMPLETE PERIOD_COUNTER_LIFE_COMPLETE
, ADJUSTED_RECOVERABLE_COST ADJUSTED_RECOVERABLE_COST
, ANNUAL_ROUNDING_FLAG ANNUAL_ROUNDING_FLAG
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, EOFY_ADJ_COST EOFY_ADJ_COST
, EOFY_FORMULA_FACTOR EOFY_FORMULA_FACTOR
, SHORT_FISCAL_YEAR_FLAG SHORT_FISCAL_YEAR_FLAG
, CONVERSION_DATE CONVERSION_DATE
, ORIGINAL_DEPRN_START_DATE ORIGINAL_DEPRN_START_DATE
, REMAINING_LIFE1 REMAINING_LIFE1
, REMAINING_LIFE2 REMAINING_LIFE2
, OLD_ADJUSTED_COST OLD_ADJUSTED_COST
, FORMULA_FACTOR FORMULA_FACTOR
, GROUP_ASSET_ID GROUP_ASSET_ID
, SALVAGE_TYPE SALVAGE_TYPE
, DEPRN_LIMIT_TYPE DEPRN_LIMIT_TYPE
, REDUCTION_RATE REDUCTION_RATE
, REDUCE_ADDITION_FLAG REDUCE_ADDITION_FLAG
, REDUCE_ADJUSTMENT_FLAG REDUCE_ADJUSTMENT_FLAG
, REDUCE_RETIREMENT_FLAG REDUCE_RETIREMENT_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
, TERMINAL_GAIN_LOSS_AMOUNT TERMINAL_GAIN_LOSS_AMOUNT
, CIP_COST CIP_COST
, YTD_PROCEEDS YTD_PROCEEDS
, LTD_PROCEEDS LTD_PROCEEDS
, LTD_COST_OF_REMOVAL LTD_COST_OF_REMOVAL
, EOFY_RESERVE EOFY_RESERVE
, PRIOR_EOFY_RESERVE PRIOR_EOFY_RESERVE
, EOP_ADJ_COST EOP_ADJ_COST
, EOP_FORMULA_FACTOR EOP_FORMULA_FACTOR
, EXCLUDE_PROCEEDS_FROM_BASIS EXCLUDE_PROCEEDS_FROM_BASIS
, RETIREMENT_DEPRN_OPTION RETIREMENT_DEPRN_OPTION
, TERMINAL_GAIN_LOSS_FLAG TERMINAL_GAIN_LOSS_FLAG
, SUPER_GROUP_ID SUPER_GROUP_ID
, OVER_DEPRECIATE_OPTION OVER_DEPRECIATE_OPTION
, DISABLED_FLAG DISABLED_FLAG
, OLD_ADJUSTED_CAPACITY OLD_ADJUSTED_CAPACITY
, DRY_HOLE_FLAG DRY_HOLE_FLAG
, CASH_GENERATING_UNIT_ID CASH_GENERATING_UNIT_ID
, CONTRACT_ID CONTRACT_ID
, EXTENDED_DEPRN_FLAG EXTENDED_DEPRN_FLAG
, EXTENDED_DEPRECIATION_PERIOD EXTENDED_DEPRECIATION_PERIOD
, PERIOD_COUNTER_FULLY_EXTENDED PERIOD_COUNTER_FULLY_EXTENDED
, RATE_IN_USE RATE_IN_USE
, NBV_AT_SWITCH NBV_AT_SWITCH
, PRIOR_DEPRN_LIMIT_TYPE PRIOR_DEPRN_LIMIT_TYPE
, PRIOR_DEPRN_LIMIT_AMOUNT PRIOR_DEPRN_LIMIT_AMOUNT
, PRIOR_DEPRN_LIMIT PRIOR_DEPRN_LIMIT
, PRIOR_DEPRN_METHOD PRIOR_DEPRN_METHOD
, PRIOR_LIFE_IN_MONTHS PRIOR_LIFE_IN_MONTHS
, PRIOR_BASIC_RATE PRIOR_BASIC_RATE
, PRIOR_ADJUSTED_RATE PRIOR_ADJUSTED_RATE
FROM "FA"."FA_BOOKS"