FA_ACE_BOOKS

FA_ACE_BOOKS contains financial information for your Adjusted Current Earnings (ACE) depreciation book. It is a temporary table in Oracle Fusion Assets. The Populate ACE interface process populates the data in this table. Oracle Fusion Assets first deletes any data in this table before running the process and then inserts into this table the financial information of assets you placed in service before 1981, MACRS assets placed in service before 1990, and ACRS assets. The program ignores assets that do not fit into one of these groups. Oracle Fusion Assets uses the information in the table to update these assets in your ACE tax book when you run the Update ACE tax book process.

Details

• Schema: FUSION

• Object owner: FA

• Object type: TABLE

• Tablespace: INTERFACE

Primary Key

Name	Columns
FA_ACE_BOOKS_PK	ASSET_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
ASSET_ID	NUMBER		18	Yes	Identifier of the asset number.
MLC_UPDATE_FLAG	VARCHAR2	3		Yes	Option indicating whether or not the Adjusted Current Earnings (ACE) process needs to update the depreciation method, life, prorate convention, and rate adjustment factor with the values in this table.
COST	NUMBER			Yes	Total recorded cost of the asset.
ADJUSTED_COST	NUMBER			Yes	Depreciable basis of the asset, calculated as recoverable cost for cost basis depreciation methods, and recoverable cost less the accumulated depreciation for NBV basis methods.
METHOD_ID	NUMBER		18		Identifier of the depreciation method.
FLAT_RATE_ID	NUMBER		18		Identifier of the rates for the flat rate depreciation method.
CONVENTION_TYPE_ID	NUMBER		18		Identifier of the prorate convention.
RATE_ADJUSTMENT_FACTOR	NUMBER				Internal factor used to adjust depreciation rates to depreciate the net book value over the remaining life.
YTD_DEPRN	NUMBER				Not currently used.
DEPRN_RESERVE	NUMBER				Total depreciation expense including the bonus depreciation recognized for the asset.
PRODUCTION_CAPACITY	NUMBER				Production capacity for assets that use units of production method.
ADJUSTED_CAPACITY	NUMBER				Remaining production capacity used to depreciate assets that use units of production method.
LTD_PRODUCTION	NUMBER				Life-to-date production for a units of production asset.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Foreign Keys

Table	Foreign Table	Foreign Key Column
FA_ACE_BOOKS	fa_additions_b	ASSET_ID
FA_ACE_BOOKS	fa_methods	METHOD_ID
FA_ACE_BOOKS	fa_convention_types	CONVENTION_TYPE_ID
FA_ACE_BOOKS	fa_flat_rates	METHOD_ID, FLAT_RATE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
FA_ACE_BOOKS_U1	Unique	Default	ASSET_ID