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

TABLE: FA.FA_MC_BOOKS_SUMMARY

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


FA_MC_BOOKS_SUMMARY is an MRC sub-table of FA_BOOKS_SUMMARY. FA_MC_BOOKS_SUMMARY stores currency and financial information about asset depreciation in each reporting book.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FA_MC_BOOKS_SUMMARY_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSET_OF_BOOKS_ID
ColumnASSET_ID
ColumnBOOK_TYPE_CODE
ColumnPERIOD_COUNTER
ColumnTRANSACTION_HEADER_ID_OUT
FA_MC_BOOKS_SUMMARY_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBOOK_TYPE_CODE
ColumnPERIOD_COUNTER
ColumnTRANSACTION_HEADER_ID_OUT
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Yes Reporting set of books identification number for GL sets of books
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 assets 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

Life-to-date Capital Adjustment
GENERAL_FUND NUMBER

Life-to-date General Fund
REVAL_LOSS_BALANCE NUMBER

Revaluation Loss Balance
Query Text

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


SELECT SET_OF_BOOKS_ID
,      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_MC_BOOKS_SUMMARY;

Dependencies

[top of page]

FA.FA_MC_BOOKS_SUMMARY does not reference any database object

FA.FA_MC_BOOKS_SUMMARY is referenced by following:

SchemaFA
ViewFA_MC_BOOKS_SUMMARY#