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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: FA.FA_BOOKS

Object Details

Object Name:	FA_BOOKS
Object Type:	TABLE
Owner:	FA
FND Design Data:	OFA.FA_BOOKS
Subobject Name:
Status:	VALID

FA_BOOKS contains the information needed for calculating depreciation.
.
When you initially add an asset, Oracle Assets inserts one row into the
table. This becomes the "active" row for the asset. Whenever you use the
Depreciation Books form to change the asset's depreciation information, or if
you retire or reinstate it, Oracle Assets inserts another row into the table,
which then becomes the new "active" row, and marks the previous row as
obsolete.
At any point in time, there is only one "active" row in the table for an asset
in any given depreciation book. Generally, Oracle Assets uses the active row,
but if you run a report for a prior accounting period, Oracle Assets selects
the row that was active during that period. You can
identify the active row for an asset in a book because it is the only one
whose DATE_INEFFECTIVE and TRANSACTION_HEADER_ID_OUT are NULL.
.
When Oracle Assets terminates a row, the DATE_INEFFECTIVE and
TRANSACTION_HEADER_OUT are set to the DATE_EFFECTIVE and
TRANSACTION_HEADER_IN of the new row, respectively. You can easily identify
rows affected by the same transaction because they have the same
DATE_EFFECTIVE / DATE_INEFFECTIVE and TRANSACTION_HEADER_ID_IN /
TRANSACTION_HEADER_ID_OUT pairs. When Oracle Assets creates the new row, the
value used for the TRANSACTION_HEADER_ID_IN column is the same as the
TRANSACTION_HEADER_ID in the row inserted into
FA_TRANSACTION_HEADERS, and the DATE_EFFECTIVE is the system date.
.
When you retire an asset, Oracle Assets inserts a new row to reduce the COST
by the amount retired. When you reinstate an asset, Oracle Assets inserts a
new row to
increase the COST by the COST_RETIRED in the corresponding row in
FA_RETIREMENTS.
.
NOTE: Altering the Adjusted Cost and Rate Adjustment Factor values damages
data integrity.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_BOOKS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_HEADER_ID_IN
FA_BOOKS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSET_ID BOOK_TYPE_CODE
FA_BOOKS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_HEADER_ID_OUT
FA_BOOKS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RETIREMENT_ID
FA_BOOKS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GROUP_ASSET_ID
FA_BOOKS_U2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BOOK_TYPE_CODE TRANSACTION_HEADER_ID_OUT ASSET_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes	Book name
ASSET_ID	NUMBER	(15)	Yes	Asset identification number
DATE_PLACED_IN_SERVICE	DATE		Yes	Date the asset was placed in service
DATE_EFFECTIVE	DATE		Yes	Date the row was entered
DEPRN_START_DATE	DATE		Yes	Date the asset started to depreciate
DEPRN_METHOD_CODE	VARCHAR2	(12)	Yes	Name of the depreciation method for the asset
LIFE_IN_MONTHS	NUMBER	(4)		Life of the asset in total months
RATE_ADJUSTMENT_FACTOR	NUMBER		Yes	Percent of remaining depreciation after a revaluation or an amortized change, or 1
ADJUSTED_COST	NUMBER		Yes	Recoverable cost less depreciation reserve. Reset when you perform an amortized adjustment or revaluation
COST	NUMBER		Yes	Current cost of the asset
ORIGINAL_COST	NUMBER		Yes	Original cost of the asset
SALVAGE_VALUE	NUMBER		Yes	Asset salvage value
PRORATE_CONVENTION_CODE	VARCHAR2	(10)	Yes	Depreciation prorate convention
PRORATE_DATE	DATE		Yes	Date used to prorate depreciation
COST_CHANGE_FLAG	VARCHAR2	(3)	Yes	Indicates whether there is an adjustment pending for the asset. The depreciation program recalculates depreciation reserve from the beginning of the asset's life if this flag is set to YES
ADJUSTMENT_REQUIRED_STATUS	VARCHAR2	(4)	Yes	Indicates asset requires an adjustment to depreciation expense for a retroactive transaction
CAPITALIZE_FLAG	VARCHAR2	(3)	Yes	Indicates whether the asset is a capitalized asset
RETIREMENT_PENDING_FLAG	VARCHAR2	(3)	Yes	Indicates whether the asset has a retirement pending
DEPRECIATE_FLAG	VARCHAR2	(3)	Yes	Indicates whether the asset is depreciating
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
DATE_INEFFECTIVE	DATE			Date which the row became ineffective
TRANSACTION_HEADER_ID_IN	NUMBER	(15)	Yes	Identifies the transaction that made this row effective
TRANSACTION_HEADER_ID_OUT	NUMBER	(15)		Identifies the transaction that made this row ineffective
ITC_AMOUNT_ID	NUMBER	(15)		Identifies the ITC rate
ITC_AMOUNT	NUMBER			Amount of ITC
RETIREMENT_ID	NUMBER	(15)		Identifies the retirement transaction if the asset has been retired
TAX_REQUEST_ID	NUMBER	(15)		Concurrent request number for mass copy program
ITC_BASIS	NUMBER			Cost basis for calculating ITC
BASIC_RATE	NUMBER			Base rate used to calculate depreciation amount for flat-rate methods
ADJUSTED_RATE	NUMBER			Actual rate used to calculate depreciation for flat-rate methods
BONUS_RULE	VARCHAR2	(30)		Identifies the bonus rule to use in calculating depreciation for the flat-rate methods
CEILING_NAME	VARCHAR2	(30)		Identifies a depreciation ceiling to use in calculating depreciation
RECOVERABLE_COST	NUMBER		Yes	Cost minus salvage value, or depreciation ceiling, whichever is lower
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
ADJUSTED_CAPACITY	NUMBER			Capacity of a units of production asset. Reset to the remaining capacity when you perform an amortized capacity adjustment
FULLY_RSVD_REVALS_COUNTER	NUMBER	(5)		Number of times the asset has been revalued as fully reserved
IDLED_FLAG	VARCHAR2	(3)		Reserved for future use
PERIOD_COUNTER_CAPITALIZED	NUMBER	(15)		Period that the asset was capitalized
PERIOD_COUNTER_FULLY_RESERVED	NUMBER	(15)		Period that the asset became fully reserved
PERIOD_COUNTER_FULLY_RETIRED	NUMBER	(15)		Period in which the asset was fully retired
PRODUCTION_CAPACITY	NUMBER			Capacity of a units of production asset
REVAL_AMORTIZATION_BASIS	NUMBER			Revaluation reserve used in calculating amortization of revaluation reserve. Updated only when the asset is revalued or has an amortized adjustment
REVAL_CEILING	NUMBER			Upper limit for revaluing asset cost
UNIT_OF_MEASURE	VARCHAR2	(25)		Unit of measure of a units of production asset
UNREVALUED_COST	NUMBER		Yes	Cost without regard to any revaluations
ANNUAL_DEPRN_ROUNDING_FLAG	VARCHAR2	(5)		Indicates whether Oracle Assets should subtract year-to-date depreciation from the annual depreciation amount to get the depreciation amount for the last period of the fiscal year
PERCENT_SALVAGE_VALUE	NUMBER			Salvage value percentage amount
ALLOWED_DEPRN_LIMIT	NUMBER			The default depreciation limit as a percentage of cost.
ALLOWED_DEPRN_LIMIT_AMOUNT	NUMBER			Cost without regard to any revaluations
PERIOD_COUNTER_LIFE_COMPLETE	NUMBER	(15)		The period the asset's useful life is fully reserved
ADJUSTED_RECOVERABLE_COST	NUMBER			Adjusted recoverable cost with special depreciation limits taken into account
ANNUAL_ROUNDING_FLAG	VARCHAR2	(5)		Reserved for future use
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Reserved for country-specific functionality
EOFY_ADJ_COST	NUMBER			Adjusted cost at the end of fiscal year
EOFY_FORMULA_FACTOR	NUMBER			Formula factor at the end of the fiscal year
SHORT_FISCAL_YEAR_FLAG	VARCHAR2	(3)		Indicates if asset is added in a short fiscal year
CONVERSION_DATE	DATE			Date short tax year asset added to the acquiring company
ORIGINAL_DEPRN_START_DATE	DATE			Date short tax year asset began depreciating in the acquired company's books
REMAINING_LIFE1	NUMBER	(4)		Remaining life of the asset as of the conversion date, prorate date or fiscal year start date
REMAINING_LIFE2	NUMBER	(4)		Remaining life of the asset as of the fiscal year start date
OLD_ADJUSTED_COST	NUMBER			The old cost of a formula-based NBV-based asset before an adjustment
FORMULA_FACTOR	NUMBER			Factor used to adjust the depreciation rate for formula-based NBV-based assets
GROUP_ASSET_ID	NUMBER	(15)		Reserved for system use. Do not use.
SALVAGE_TYPE	VARCHAR2	(30)	Yes	Indicates whether the salvage type is the amount, percentage, or sum of member assets
DEPRN_LIMIT_TYPE	VARCHAR2	(30)	Yes	Indicates whether the depreciation limit type is the amount, percentage, sum of member assets, or no depreciation limit type(NONE)
REDUCTION_RATE	NUMBER			If the record is for a group asset, the reduction rate will be a default value for member assets. If the record is for a member asset, the reduction rate is the reduction rate used for transactions.
REDUCE_ADDITION_FLAG	VARCHAR2	(1)		Indicates whether or not the reduction rate should be used for addition transactions
REDUCE_ADJUSTMENT_FLAG	VARCHAR2	(1)		Indicates whether or not the reduction rate should be used for adjustment transactions
REDUCE_RETIREMENT_FLAG	VARCHAR2	(1)		Indicates whether or not the reduction rate should be used for retirement transactions
RECOGNIZE_GAIN_LOSS	VARCHAR2	(30)		Indicates whether or not the system recognizes gain or loss immediately
RECAPTURE_RESERVE_FLAG	VARCHAR2	(1)		Indicates whether or not the reserve for a group asset can exceed its recoverable cost
LIMIT_PROCEEDS_FLAG	VARCHAR2	(1)		Indicates whether or not the reserve for a group asset can exceed its recoverable cost
TERMINAL_GAIN_LOSS	VARCHAR2	(30)		Indicates whether or not to take terminal gain or loss immediately, or at the end of the fiscal year, when there is accumulated depreciation remaining for the group asset after the last member asset is retired from the group asset
TRACKING_METHOD	VARCHAR2	(30)		Indicates whether member assets should be tracked, tracked using the allocate method or the calculate method
EXCLUDE_FULLY_RSV_FLAG	VARCHAR2	(1)		Indicates whether or not fully reserved assets' depreciable basis should be excluded from the group's depreciable basis
EXCESS_ALLOCATION_OPTION	VARCHAR2	(30)		Indicates whether the excess amount incurred during allocation should also be distributed to the member asset, or reduced from the group asset depreciation expense
DEPRECIATION_OPTION	VARCHAR2	(30)		Indicates whether a member assets depreciation expenses should be calculated using its group asset depreciation rules or the member asset depreciation rules
MEMBER_ROLLUP_FLAG	VARCHAR2	(1)		Indicates whether or not the sum of member asset depreciation expense should be the group asset depreciation amount
ALLOCATE_TO_FULLY_RSV_FLAG	VARCHAR2	(1)		Indicates whether or not group depreciation expense should be allocated to fully reserved assets
ALLOCATE_TO_FULLY_RET_FLAG	VARCHAR2	(1)		Indicates whether or not group depreciation expense should be allocated to fully retired assets
TERMINAL_GAIN_LOSS_AMOUNT	NUMBER			Accumulated depreciation remaining for the group asset after the last member asset is retired from the group asset
CIP_COST	NUMBER			Sum of the non-depreciable source line cost if the asset type is CIP
YTD_PROCEEDS	NUMBER			Year-to-date proceeds of sale
LTD_PROCEEDS	NUMBER			Life-to-date proceeds of sale
LTD_COST_OF_REMOVAL	NUMBER			Life-to-date cost of removal
EOFY_RESERVE	NUMBER			Accumulated depreciation at the end of the previous fiscal year
PRIOR_EOFY_RESERVE	NUMBER			Previous accumulated depreciation at the end of the previous fiscal year
EOP_ADJ_COST	NUMBER			Adjusted cost at the end of the previous period
EOP_FORMULA_FACTOR	NUMBER			Formula factor at the end of the previous period
EXCLUDE_PROCEEDS_FROM_BASIS	VARCHAR2	(1)		Indicates whether or not the proceeds of sale should be included when calculating the depreciable basis.
RETIREMENT_DEPRN_OPTION	VARCHAR2	(30)		Indicates whether depreciation should continue depreciating until the last member asset is retired or until the end of the fiscal year
TERMINAL_GAIN_LOSS_FLAG	VARCHAR2	(1)		Indicates whether or not the terminal gain/loss amount needs to be processed during the Calculate Gains and Losses program, if it is running in the last period of the fiscal year
SUPER_GROUP_ID	NUMBER	(15)		Identifies the super group that the asset in this book uses
OVER_DEPRECIATE_OPTION	VARCHAR2	(30)		Indicates whether the over depreciate is Do Not Allow, Allow, or Allow and Depreciate.
DISABLED_FLAG	VARCHAR2	(1)		Indicates whether a group asset is disabled or enabled. Possible values are: Y- (Yes) N- (No), NULL
OLD_ADJUSTED_CAPACITY	NUMBER			Old net remaining capacity before the last depreciation run
DRY_HOLE_FLAG	VARCHAR2	(1)		Indicates whether the asset is of a dry-hole type.
CASH_GENERATING_UNIT_ID	NUMBER	(15)		Unique identification number of a cash generating unit
CONTRACT_ID	NUMBER			Contract associated with asset
EXTENDED_DEPRN_FLAG	VARCHAR2	(1)		Indicates whether the asset is in extended depreciation
EXTENDED_DEPRECIATION_PERIOD	NUMBER	(15)		Indicates the period counter from which the asset entered extended depreciation.
PERIOD_COUNTER_FULLY_EXTENDED	NUMBER	(15)		Indicates the period counter on which the asset completed extended depreciation.
RATE_IN_USE	NUMBER			Indicates present rate in use
NBV_AT_SWITCH	NUMBER			The net book value of an asset at the date the original rate was switched to the revised rate.
PRIOR_DEPRN_LIMIT_TYPE	VARCHAR2	(30)		The depreciation limit type for the asset immediately before it began extended depreciation.
PRIOR_DEPRN_LIMIT_AMOUNT	NUMBER			The depreciation limit amount for the asset immediately before it began extended depreciation.
PRIOR_DEPRN_LIMIT	NUMBER			The depreciation limit as a percentage of cost for the asset immediately before it began extended depreciation.
PRIOR_DEPRN_METHOD	VARCHAR2	(12)		The depreciation method for the asset immediately before it began extended depreciation.
PRIOR_LIFE_IN_MONTHS	NUMBER	(6)		The life in months for the asset immediately before it began extended depreciation.
PRIOR_BASIC_RATE	NUMBER			The basic rate of the asset immediately before it began extended depreciation.
PRIOR_ADJUSTED_RATE	NUMBER			The adjusted rate of the asset immediately before it began extended depreciation.

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

FA.FA_BOOKS does not reference any database object

FA.FA_BOOKS is referenced by following:

FA: FA_BOOKS#