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_MC_BOOKS

Object Details

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

FA_MC_BOOKS is an MRC sub-table of FA_BOOKS. This table stores currency and financial information about assets in each reporting book associated with the parent record in FA_BOOKS.
This table stores one active row for each asset per reporting book identified by a null TRANSACTION_HEADER_ID_OUT. Oracle Assets updates this table when ever a financial adjustment is performed on the asset by setting the TRANSACTION_HEADER_ID_OUT of the current row to the TRANSACTION_HEADER_ID_IN of the new row.
RATE_ADJUSTMENT_FACTOR is stored in the parent record in FA_BOOKS.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_MC_BOOKS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID TRANSACTION_HEADER_ID_IN
FA_MC_BOOKS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID ASSET_ID BOOK_TYPE_CODE TRANSACTION_HEADER_ID_OUT
FA_MC_BOOKS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID TRANSACTION_HEADER_ID_OUT
FA_MC_BOOKS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID RETIREMENT_ID
FA_MC_BOOKS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GROUP_ASSET_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Reporting set of books identification number for General Ledger sets of books
ASSET_ID	NUMBER	(15)	Yes	Asset identification number
BOOK_TYPE_CODE	VARCHAR2	(30)	Yes	Book name
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
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
SOURCE_COST	NUMBER			Current cost of the asset in the primary functional currency
ORIGINAL_COST	NUMBER		Yes	Original cost of the asset
SOURCE_ORIGINAL_COST	NUMBER			Original cost of the asset in the primary functional currency
SALVAGE_VALUE	NUMBER		Yes	Asset salvage value
ADJUSTMENT_REQUIRED_STATUS	VARCHAR2	(4)	Yes	Indicates asset requires an adjustment to depreciation expense for a retroactive transaction
RETIREMENT_PENDING_FLAG	VARCHAR2	(3)	Yes	Identifies whether the asset has a retirement pending
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
ITC_AMOUNT	NUMBER			Amount of ITC
ITC_BASIS	NUMBER			Cost basis for calculating ITC
RECOVERABLE_COST	NUMBER		Yes	Cost minus salvage value, or depreciation ceiling, which ever is lower
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
REVAL_CEILING	NUMBER			Upper limit for revaluing asset cost
PERIOD_COUNTER_FULLY_RESERVED	NUMBER	(15)		Period that the asset became fully reserved
UNREVALUED_COST	NUMBER		Yes	Cost without regard to any revaluations
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
CONVERTED_FLAG	VARCHAR2	(1)		Indicates whether amounts for this row have been converted to the reporting currency
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
EOFY_ADJ_COST	NUMBER			Adjusted cost at the end of the previous fiscal year
OLD_ADJUSTED_COST	NUMBER			Adjusted cost at the time of the prior adjustment
EOFY_FORMULA_FACTOR	NUMBER			The formula factor at the end of the fiscal year
FORMULA_FACTOR	NUMBER			The formula factor
REMAINING_LIFE1	NUMBER	(4)		Remaining useful life as of the conversion date or the beginning of the fiscal year
REMAINING_LIFE2	NUMBER	(4)		Remaining useful life as of the beginning of the fiscal year
SHORT_FISCAL_YEAR_FLAG	VARCHAR2	(3)		Indicates if asset is added in a short fiscal year
GROUP_ASSET_ID	NUMBER	(15)		Reserved for system use. Do not use.
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.
ITC_AMOUNT_ID	NUMBER	(15)		Identifies the ITC rate
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
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
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			Number of times the asset has been revalued as fully reserved
IDLED_FLAG	VARCHAR2	(3)		Reserved for future use
PERIOD_COUNTER_CAPITALIZED	NUMBER			Period that the asset was capitalized
PERIOD_COUNTER_FULLY_RETIRED	NUMBER			Period that the asset became fully retired
PRODUCTION_CAPACITY	NUMBER			Capacity of a units of production asset
UNIT_OF_MEASURE	VARCHAR2	(25)		Unit of measure of a units of production asset
PERCENT_SALVAGE_VALUE	NUMBER			Salvage value percentage amount
ALLOWED_DEPRN_LIMIT	NUMBER			The default depreciation limit as a percentage of cost.
ANNUAL_ROUNDING_FLAG	VARCHAR2	(3)		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
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			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
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
CAPITALIZE_FLAG	VARCHAR2	(3)	Yes	Indicates whether the asset is a capitalized asset
DEPRECIATE_FLAG	VARCHAR2	(3)	Yes	Indicates whether the asset is depreciating
DATE_INEFFECTIVE	DATE			Date which the row became ineffective
CONVERSION_DATE	DATE			Date short tax asset added to the acquiring company
ORIGINAL_DEPRN_START_DATE	DATE			Original depreciation start date
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
RATE_IN_USE	NUMBER			Indicates present rate in use

Query Text

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


SELECT SET_OF_BOOKS_ID
,      ASSET_ID
,      BOOK_TYPE_CODE
,      TRANSACTION_HEADER_ID_IN
,      TRANSACTION_HEADER_ID_OUT
,      ADJUSTED_COST
,      COST
,      SOURCE_COST
,      ORIGINAL_COST
,      SOURCE_ORIGINAL_COST
,      SALVAGE_VALUE
,      ADJUSTMENT_REQUIRED_STATUS
,      RETIREMENT_PENDING_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      ITC_AMOUNT
,      ITC_BASIS
,      RECOVERABLE_COST
,      LAST_UPDATE_LOGIN
,      REVAL_CEILING
,      PERIOD_COUNTER_FULLY_RESERVED
,      UNREVALUED_COST
,      ALLOWED_DEPRN_LIMIT_AMOUNT
,      PERIOD_COUNTER_LIFE_COMPLETE
,      ADJUSTED_RECOVERABLE_COST
,      CONVERTED_FLAG
,      ANNUAL_DEPRN_ROUNDING_FLAG
,      EOFY_ADJ_COST
,      OLD_ADJUSTED_COST
,      EOFY_FORMULA_FACTOR
,      FORMULA_FACTOR
,      REMAINING_LIFE1
,      REMAINING_LIFE2
,      SHORT_FISCAL_YEAR_FLAG
,      GROUP_ASSET_ID
,      REVAL_AMORTIZATION_BASIS
,      ITC_AMOUNT_ID
,      RETIREMENT_ID
,      TAX_REQUEST_ID
,      BASIC_RATE
,      ADJUSTED_RATE
,      BONUS_RULE
,      CEILING_NAME
,      ADJUSTED_CAPACITY
,      FULLY_RSVD_REVALS_COUNTER
,      IDLED_FLAG
,      PERIOD_COUNTER_CAPITALIZED
,      PERIOD_COUNTER_FULLY_RETIRED
,      PRODUCTION_CAPACITY
,      UNIT_OF_MEASURE
,      PERCENT_SALVAGE_VALUE
,      ALLOWED_DEPRN_LIMIT
,      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
,      DATE_PLACED_IN_SERVICE
,      DATE_EFFECTIVE
,      DEPRN_START_DATE
,      DEPRN_METHOD_CODE
,      LIFE_IN_MONTHS
,      RATE_ADJUSTMENT_FACTOR
,      PRORATE_CONVENTION_CODE
,      PRORATE_DATE
,      COST_CHANGE_FLAG
,      CAPITALIZE_FLAG
,      DEPRECIATE_FLAG
,      DATE_INEFFECTIVE
,      CONVERSION_DATE
,      ORIGINAL_DEPRN_START_DATE
,      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
,      RATE_IN_USE
FROM FA.FA_MC_BOOKS;

Dependencies

[top of page]

FA.FA_MC_BOOKS does not reference any database object

FA.FA_MC_BOOKS is referenced by following:

FA: FA_MC_BOOKS#