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

TABLE: FA.FA_BOOKS_SUMMARY

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


This table stores group assets' periodical financial information. All group financial information changes, such as group additions, adjustments, member asset addition, member asset adjustments, member asset retirements, group reclassifications, and unplanned depreciations, will result in maintaining this table. This table stores the latest group asset information for each period. This means that any retroactive adjustment will result in updating multiple records for that group asset to reflect the latest changes to old periods.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FA_BOOKS_SUMMARY_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSET_ID
ColumnBOOK_TYPE_CODE
ColumnPERIOD_COUNTER
ColumnTRANSACTION_HEADER_ID_OUT
FA_BOOKS_SUMMARY_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBOOK_TYPE_CODE
ColumnPERIOD_COUNTER
ColumnTRANSACTION_HEADER_ID_OUT
Columns
Name Datatype Length Mandatory Comments
ASSET_ID NUMBER (15) Yes Asset identification number
BOOK_TYPE_CODE VARCHAR2 (15) Yes Book name
PERIOD_COUNTER NUMBER (15) Yes Depreciation period
FISCAL_YEAR NUMBER (15)
Fiscal year
PERIOD_NUM NUMBER (15)
Period number within a fiscal year
CALENDAR_PERIOD_OPEN_DATE DATE

Start date in corresponding FA_CALENDAR_PERIODS row
CALENDAR_PERIOD_CLOSE_DATE DATE

End date in corresponding FA_CALENDAR_PERIODS row
RESET_ADJUSTED_COST_FLAG VARCHAR2 (1)
Indicates whether there is an adjustment that requires you to reset the adjusted cost
CHANGE_IN_COST NUMBER

Change in cost in this period
CHANGE_IN_ADDITIONS_COST NUMBER

Reserved for future use
CHANGE_IN_ADJUSTMENTS_COST NUMBER

Reserved for future use
CHANGE_IN_RETIREMENTS_COST NUMBER

Reserved for future use
CHANGE_IN_GROUP_REC_COST NUMBER

Reserved for future use
CHANGE_IN_CIP_COST NUMBER

Change in CIP cost in this period
COST NUMBER

Cost of the asset
CIP_COST NUMBER

CIP cost of the asset
SALVAGE_TYPE VARCHAR2 (30)
Indicates whether the salvage type is the amount, percentage, or sum of member assets
PERCENT_SALVAGE_VALUE NUMBER

Salvage value percentage amount
SALVAGE_VALUE NUMBER

Asset salvage value
MEMBER_SALVAGE_VALUE NUMBER

Sum of member asset salvage value
RECOVERABLE_COST NUMBER

Cost minus salvage value, or depreciation ceiling, whichever is lower
DEPRN_LIMIT_TYPE VARCHAR2 (30)
Indicates whether the depreciation limit type is the amount, percentage, or sum of member assets
ALLOWED_DEPRN_LIMIT NUMBER

Depreciation limit as a percentage of cost
ALLOWED_DEPRN_LIMIT_AMOUNT NUMBER

Depreciation limit as a flat amount, subtracted from cost
MEMBER_DEPRN_LIMIT_AMOUNT NUMBER

Sum of depreciation limit as a flat amount, subtracted from cost
ADJUSTED_RECOVERABLE_COST NUMBER

Adjusted recoverable cost with special depreciation limits taken into account
ADJUSTED_COST NUMBER

Recoverable cost less depreciation reserve. Reset when you perform an amortized adjustment or revaluation
DEPRECIATE_FLAG VARCHAR2 (3)
Indicates whether the asset is depreciating
DISABLED_FLAG VARCHAR2 (1)
Indicates whether the asset is disabled
DATE_PLACED_IN_SERVICE DATE

Date the asset was placed in service
DEPRN_METHOD_CODE VARCHAR2 (12)
Name of the depreciation method for the asset
LIFE_IN_MONTHS NUMBER (4)
Life of the asset in total months
RATE_ADJUSTMENT_FACTOR NUMBER

Percent of remaining depreciation after a revaluation or an amortized change, or 1
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
ADJUSTED_CAPACITY NUMBER

Reserved for future use
PRODUCTION_CAPACITY NUMBER

Reserved for future use
UNIT_OF_MEASURE VARCHAR2 (25)
Reserved for future use
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
FORMULA_FACTOR NUMBER

Factor used to adjust the depreciation rate for formula-based NBV-based assets
UNREVALUED_COST NUMBER

Reserved for future use
REVAL_AMORTIZATION_BASIS NUMBER

Reserved for future use
REVAL_CEILING NUMBER

Reserved for future use
CEILING_NAME VARCHAR2 (30)
Identifies a depreciation ceiling to use in calculating depreciation
EOFY_ADJ_COST NUMBER

Adjusted cost at the end of previous fiscal year
EOFY_FORMULA_FACTOR NUMBER

Formula factor at the end of previous fiscal year
EOFY_RESERVE NUMBER

Depreciation reserve at the end of previous fiscal year
EOP_ADJ_COST NUMBER

Adjusted cost at the end of previous period
EOP_FORMULA_FACTOR NUMBER

Formula factor at the end of previous period
SHORT_FISCAL_YEAR_FLAG VARCHAR2 (3)
Indicates if asset is added in a short fiscal year
GROUP_ASSET_ID NUMBER (15)
Reserved for future use
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 option is Do Not Allow, Allow, or Allow and Depreciate
FULLY_RSVD_REVALS_COUNTER NUMBER (5)
Reserved for future use
CAPITALIZED_FLAG VARCHAR2 (1)
Indicates whether the asset is capitalized
FULLY_RESERVED_FLAG VARCHAR2 (1)
Indicates whether the asset is fully reserved
FULLY_RETIRED_FLAG VARCHAR2 (1)
Indicates whether the asset is fully retired
LIFE_COMPLETE_FLAG VARCHAR2 (1)
Indicates whether the asset life is completed
TERMINAL_GAIN_LOSS_AMOUNT NUMBER

Accumulated depreciation remaining for the group asset after the last member asset is retired from the group asset
TERMINAL_GAIN_LOSS_FLAG VARCHAR2 (1)
Indicates whether or not the terminal gain/loss amount needs to be processed
DEPRN_AMOUNT NUMBER

Depreciation expense for this depreciation period
YTD_DEPRN NUMBER

Year-to-date depreciation expense
DEPRN_RESERVE NUMBER

Total depreciation taken since beginning of asset life
BONUS_DEPRN_AMOUNT NUMBER

Bonus depreciation expense for this depreciation period
BONUS_YTD_DEPRN NUMBER

Bonus year-to-date depreciation expense
BONUS_DEPRN_RESERVE NUMBER

Bonus total depreciation taken since beginning of asset life
BONUS_RATE NUMBER

Bonus rate used to calculate depreciation
LTD_PRODUCTION NUMBER

Reserved for future use
YTD_PRODUCTION NUMBER

Reserved for future use
PRODUCTION NUMBER

Reserved for future use
REVAL_AMORTIZATION NUMBER

Reserved for future use
REVAL_DEPRN_EXPENSE NUMBER

Reserved for future use
REVAL_RESERVE NUMBER

Reserved for future use
YTD_REVAL_DEPRN_EXPENSE NUMBER

Reserved for future use
DEPRN_OVERRIDE_FLAG VARCHAR2 (1)
Override status ('D' - stands for depreciation amount was overridden, 'B' stands for bonus amount was overridden, 'A' stands for depreciation and bonus amounts were overridden)
SYSTEM_DEPRN_AMOUNT NUMBER

System calculated depreciation amount (this is stored only when the tracking member method is specified)
SYSTEM_BONUS_DEPRN_AMOUNT NUMBER

System calculated bonus depreciation amount (this is stored only when the tracking member method is specified)
YTD_PROCEEDS_OF_SALE NUMBER

Year-to-date proceeds of sale
LTD_PROCEEDS_OF_SALE NUMBER

Life-to-date proceeds of sale
YTD_COST_OF_REMOVAL NUMBER

Year-to-date cost of removal
LTD_COST_OF_REMOVAL NUMBER

Life-to-date cost of removal
DEPRN_ADJUSTMENT_AMOUNT NUMBER

Store current period expense adjustments amount. This column will not be maintained. Use to get current period catch-up amount
EXPENSE_ADJUSTMENT_AMOUNT NUMBER

Sum of expense adjustment amounts for a period
UNPLANNED_AMOUNT NUMBER

Reserved for future use
RESERVE_ADJUSTMENT_AMOUNT NUMBER

Sum of reserve adjustment amounts for a period
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
CHANGE_IN_EOFY_RESERVE NUMBER

The change in depreciation reserve at the end of the previous fiscal year
SWITCH_CODE VARCHAR2 (2)
Current depreciation code for a Polish depreciation basis that is in use for an asset.
TRANSACTION_HEADER_ID_IN NUMBER (15)
Identifies the transaction that made this row effective
TRANSACTION_HEADER_ID_OUT NUMBER (15)
Identifies the transaction that made this row ineffective
POLISH_DEPRN_BASIS NUMBER

The depreciation basis amount used for assets with a Polish depreciation basis rule
POLISH_ADJ_REC_COST NUMBER

The adjusted recoverable cost used for assets with a Polish depreciation basis rule
IMPAIRMENT_AMOUNT NUMBER

Periodic Impairment amount
YTD_IMPAIRMENT NUMBER

Year-to-date Impairment amount
IMPAIRMENT_RESERVE NUMBER

Life-to-date Impairment amount
CAPITAL_ADJUSTMENT NUMBER

Capital Adjustment Amount
GENERAL_FUND NUMBER

General Fund Amount
REVAL_LOSS_BALANCE NUMBER

Reval Loss Balance Amount
Query Text

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


SELECT ASSET_ID
,      BOOK_TYPE_CODE
,      PERIOD_COUNTER
,      FISCAL_YEAR
,      PERIOD_NUM
,      CALENDAR_PERIOD_OPEN_DATE
,      CALENDAR_PERIOD_CLOSE_DATE
,      RESET_ADJUSTED_COST_FLAG
,      CHANGE_IN_COST
,      CHANGE_IN_ADDITIONS_COST
,      CHANGE_IN_ADJUSTMENTS_COST
,      CHANGE_IN_RETIREMENTS_COST
,      CHANGE_IN_GROUP_REC_COST
,      CHANGE_IN_CIP_COST
,      COST
,      CIP_COST
,      SALVAGE_TYPE
,      PERCENT_SALVAGE_VALUE
,      SALVAGE_VALUE
,      MEMBER_SALVAGE_VALUE
,      RECOVERABLE_COST
,      DEPRN_LIMIT_TYPE
,      ALLOWED_DEPRN_LIMIT
,      ALLOWED_DEPRN_LIMIT_AMOUNT
,      MEMBER_DEPRN_LIMIT_AMOUNT
,      ADJUSTED_RECOVERABLE_COST
,      ADJUSTED_COST
,      DEPRECIATE_FLAG
,      DISABLED_FLAG
,      DATE_PLACED_IN_SERVICE
,      DEPRN_METHOD_CODE
,      LIFE_IN_MONTHS
,      RATE_ADJUSTMENT_FACTOR
,      ADJUSTED_RATE
,      BONUS_RULE
,      ADJUSTED_CAPACITY
,      PRODUCTION_CAPACITY
,      UNIT_OF_MEASURE
,      REMAINING_LIFE1
,      REMAINING_LIFE2
,      FORMULA_FACTOR
,      UNREVALUED_COST
,      REVAL_AMORTIZATION_BASIS
,      REVAL_CEILING
,      CEILING_NAME
,      EOFY_ADJ_COST
,      EOFY_FORMULA_FACTOR
,      EOFY_RESERVE
,      EOP_ADJ_COST
,      EOP_FORMULA_FACTOR
,      SHORT_FISCAL_YEAR_FLAG
,      GROUP_ASSET_ID
,      SUPER_GROUP_ID
,      OVER_DEPRECIATE_OPTION
,      FULLY_RSVD_REVALS_COUNTER
,      CAPITALIZED_FLAG
,      FULLY_RESERVED_FLAG
,      FULLY_RETIRED_FLAG
,      LIFE_COMPLETE_FLAG
,      TERMINAL_GAIN_LOSS_AMOUNT
,      TERMINAL_GAIN_LOSS_FLAG
,      DEPRN_AMOUNT
,      YTD_DEPRN
,      DEPRN_RESERVE
,      BONUS_DEPRN_AMOUNT
,      BONUS_YTD_DEPRN
,      BONUS_DEPRN_RESERVE
,      BONUS_RATE
,      LTD_PRODUCTION
,      YTD_PRODUCTION
,      PRODUCTION
,      REVAL_AMORTIZATION
,      REVAL_DEPRN_EXPENSE
,      REVAL_RESERVE
,      YTD_REVAL_DEPRN_EXPENSE
,      DEPRN_OVERRIDE_FLAG
,      SYSTEM_DEPRN_AMOUNT
,      SYSTEM_BONUS_DEPRN_AMOUNT
,      YTD_PROCEEDS_OF_SALE
,      LTD_PROCEEDS_OF_SALE
,      YTD_COST_OF_REMOVAL
,      LTD_COST_OF_REMOVAL
,      DEPRN_ADJUSTMENT_AMOUNT
,      EXPENSE_ADJUSTMENT_AMOUNT
,      UNPLANNED_AMOUNT
,      RESERVE_ADJUSTMENT_AMOUNT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CHANGE_IN_EOFY_RESERVE
,      SWITCH_CODE
,      TRANSACTION_HEADER_ID_IN
,      TRANSACTION_HEADER_ID_OUT
,      POLISH_DEPRN_BASIS
,      POLISH_ADJ_REC_COST
,      IMPAIRMENT_AMOUNT
,      YTD_IMPAIRMENT
,      IMPAIRMENT_RESERVE
,      CAPITAL_ADJUSTMENT
,      GENERAL_FUND
,      REVAL_LOSS_BALANCE
FROM FA.FA_BOOKS_SUMMARY;

Dependencies

[top of page]

FA.FA_BOOKS_SUMMARY does not reference any database object

FA.FA_BOOKS_SUMMARY is referenced by following:

SchemaFA
ViewFA_BOOKS_SUMMARY#