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

TABLE: FA.FA_ACE_BOOKS

Object Details
Object Name: FA_ACE_BOOKS
Object Type: TABLE
Owner: FA
FND Design Data: TableOFA.FA_ACE_BOOKS
Subobject Name:
Status: VALID


FA_ACE_BOOKS is temporary table Oracle Assets uses to store
financial information for your Adjusted Current Earnings ("ACE")
depreciation book.
.
When you run FAACCR, the ACE program populates this table.
Oracle Assets deletes any data in this table before running the
program. Oracle Assets 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 Assets uses the information in the table to update these
assets in your ACE tax book when you run FAACUP.
.
MLC_UPDATE_FLAG is set to 'YES' by the FAACCR program if Oracle
Assets must update the depreciation method(M), life(L), and prorate
convention(C) of an asset in the ACE tax book to the values for the
asset in the federal tax book. In this case Oracle Assets also
provides the method, life, and convention.
.
For more information on the RATE_ADJUSTMENT_FACTOR , please
refer to the FA_BOOKS table description in this manual.
.
For more information on loading this table, read the Integrating
Oracle Assets Using the ACE Interface essay in the Oracle Financials
and Oracle Government Financials Implementation Manual.
Scope: public
Lifecycle: active
Display Name: FA ACE Books
Product: FA
Category: BUSINESS_ENTITY FA_ASSET


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ASSET_ID NUMBER (15) Yes Asset identification number
MLC_UPDATE_FLAG VARCHAR2 (3) Yes YES if update ACE book program needs to update the depreciation method, life, prorate convention, and rate adjustment factor with the values in this table
COST NUMBER
Yes Current asset cost
ADJUSTED_COST NUMBER
Yes Depreciable basis of the asset, calculated as recoverable cost for cost-based depreciation methods, less the accumulated depreciation for NBV-based methods
DEPRN_METHOD_CODE VARCHAR2 (12)
Depreciation method for the asset
LIFE_IN_MONTHS NUMBER (4)
Whole life of the assets in months
PRORATE_CONVENTION_CODE VARCHAR2 (10)
Prorate convention for the asset
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

Starting depreciation reserve for the asset
PRODUCTION_CAPACITY NUMBER

Production capacity for assets that use a units of production method
ADJUSTED_CAPACITY NUMBER

Remaining capacity to use for depreciation for assets that use a units of production method
LTD_PRODUCTION NUMBER

Life-to-date production for assets that use a units of production method
ADJUSTED_RATE NUMBER

Not currently used
BASIC_RATE NUMBER

Not currently used
Query Text

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


SELECT ASSET_ID
,      MLC_UPDATE_FLAG
,      COST
,      ADJUSTED_COST
,      DEPRN_METHOD_CODE
,      LIFE_IN_MONTHS
,      PRORATE_CONVENTION_CODE
,      RATE_ADJUSTMENT_FACTOR
,      YTD_DEPRN
,      DEPRN_RESERVE
,      PRODUCTION_CAPACITY
,      ADJUSTED_CAPACITY
,      LTD_PRODUCTION
,      ADJUSTED_RATE
,      BASIC_RATE
FROM FA.FA_ACE_BOOKS;

Dependencies

[top of page]

FA.FA_ACE_BOOKS does not reference any database object

FA.FA_ACE_BOOKS is referenced by following:

SchemaFA
ViewFA_ACE_BOOKS#