[Home] [Help]
select ASSET_ID ASSET_ID, MLC_UPDATE_FLAG MLC_UPDATE_FLAG, COST COST, ADJUSTED_COST ADJUSTED_COST, DEPRN_METHOD_CODE DEPRN_METHOD_CODE, LIFE_IN_MONTHS LIFE_IN_MONTHS, PRORATE_CONVENTION_CODE PRORATE_CONVENTION_CODE, RATE_ADJUSTMENT_FACTOR RATE_ADJUSTMENT_FACTOR, YTD_DEPRN YTD_DEPRN, DEPRN_RESERVE DEPRN_RESERVE, PRODUCTION_CAPACITY PRODUCTION_CAPACITY, ADJUSTED_CAPACITY ADJUSTED_CAPACITY, LTD_PRODUCTION LTD_PRODUCTION, ADJUSTED_RATE ADJUSTED_RATE, BASIC_RATE BASIC_RATE from "FA"."FA_ACE_BOOKS"
SELECT ASSET_ID ASSET_ID
, MLC_UPDATE_FLAG MLC_UPDATE_FLAG
, COST COST
, ADJUSTED_COST ADJUSTED_COST
, DEPRN_METHOD_CODE DEPRN_METHOD_CODE
, LIFE_IN_MONTHS LIFE_IN_MONTHS
, PRORATE_CONVENTION_CODE PRORATE_CONVENTION_CODE
, RATE_ADJUSTMENT_FACTOR RATE_ADJUSTMENT_FACTOR
, YTD_DEPRN YTD_DEPRN
, DEPRN_RESERVE DEPRN_RESERVE
, PRODUCTION_CAPACITY PRODUCTION_CAPACITY
, ADJUSTED_CAPACITY ADJUSTED_CAPACITY
, LTD_PRODUCTION LTD_PRODUCTION
, ADJUSTED_RATE ADJUSTED_RATE
, BASIC_RATE BASIC_RATE
FROM "FA"."FA_ACE_BOOKS"
|
|
|
|