Book Summaries

The Book Summaries view object contains periodical financial information on group assets. It stores all group financial information changes, such as group additions, adjustments, member asset additions, member asset adjustments, member asset retirements, group reclassifications, and unplanned depreciation.

Data Store Key : FscmTopModelAM.FinExtractAM.FaBiccExtractAM.BookSummaryExtractPVO

Primary Keys : BookSummaryAssetId, BookSummaryPeriodCounter, BookSummaryBookTypeCode

Initial Extract Date : BookSummaryCreationDate

Incremental Extract Date : BookSummaryLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
BookSummaryAccDeprnAdjustmentAmount	Accelerated Depreciation Reserve
BookSummaryAcceleratedAdjustedCost	Accelerated Adjusted Cost
BookSummaryAcceleratedDeprnAmount	Accelerated Depreciation Amount
BookSummaryAcceleratedDeprnReserve	Accelerated Depreciation Reserve
BookSummaryAcceleratedYtdDeprn	YTD Accelerated Depreciation
BookSummaryAdjustedCapacity
BookSummaryAdjustedCost	The adjusted cost of an asset.
BookSummaryAdjustedRecoverableCost	The adjusted portion of the current cost that can be depreciated.
BookSummaryAllowedDeprnLimit	Depreciation limit percentage that is applied automatically when assets are added with this asset category.
BookSummaryAllowedDeprnLimitAmount	Depreciation limit amount that is applied automatically when assets are added with this asset category.
BookSummaryAmortizeFlag	Allow Amortized Changes Indicator
BookSummaryAssetId	Identifier of the asset number.
BookSummaryAssetType	Asset Type
BookSummaryBonusAdjustedCost	Base amount on which the bonus depreciation is calculated.
BookSummaryBonusDeprnAmount	The bonus depreciation amount of the transaction.
BookSummaryBonusDeprnReserve	Bonus Depreciation Reserve
BookSummaryBonusExpenseAdjAmount	The bonus depreciation expense adjustment amount for the period.
BookSummaryBonusRate	Rate for calculating bonus depreciation amounts.
BookSummaryBonusReserveAdjAmount	The bonus depreciation reserve adjustment amount for the asset.
BookSummaryBonusReserveRetAdjAmount	The bonus depreciation reserve retired adjustment amount for the period.
BookSummaryBonusRuleId	Identifier for the depreciation bonus rule.
BookSummaryBookSummaryBonusYtdDeprn	Bonus YTD Depreciation
BookSummaryBookTypeCode	The unique identifier for the asset book name.
BookSummaryCalendarPeriodCloseDate	Period Close Date
BookSummaryCalendarPeriodOpenDate	The period start date.
BookSummaryCapitalAdjustment	Capital Adjustment Amount
BookSummaryCapitalizedFlag	Indicates whether the asset is a capitalized asset.
BookSummaryCeilingTypeId	Identifier of the depreciation ceiling.
BookSummaryChangeInAdditionsCost
BookSummaryChangeInAdjustmentsCost
BookSummaryChangeInCipCost	The change in the construction-in-process cost of the asset.
BookSummaryChangeInCost	Change in Cost
BookSummaryChangeInEofyReserve	The change in depreciation reserve at the end of the previous fiscal year.
BookSummaryChangeInGroupRecCost
BookSummaryChangeInRetirementsCost
BookSummaryCipCost	Account used to reflect the cost of a construction-in-process asset.
BookSummaryCost	Total recorded cost of the asset.
BookSummaryCreatedBy	The user who created the asset book.
BookSummaryCreationDate	The date the asset book was created.
BookSummaryDatePlacedInService	Date on which the asset was placed in service.
BookSummaryDepreciateFlag	Indicates whether the asset is depreciating.
BookSummaryDeprnAdjustmentAmount	Adjustment to the depreciation amount for retroactive asset transactions.
BookSummaryDeprnAdjustmentFactor	The internal adjustment factor used to calculate the depreciation.
BookSummaryDeprnAmount	Asset depreciation expense amount.
BookSummaryDeprnLimitType	Depreciation limit type assigned to the asset. It can be either the amount, percentage, sum of member assets, or none.
BookSummaryDeprnOverrideFlag	Indicates whether a depreciation override amount is allowed for assets in the book.
BookSummaryDeprnReserve	Total depreciation expense including the bonus depreciation recognized for the asset.
BookSummaryDisabledFlag	Indicates whether the lookup required to use the Group Asset feature is enabled.
BookSummaryEofyAdjCost	Adjusted cost at the end of the previous fiscal year.
BookSummaryEofyFormulaFactor	Formula factor at the end of the previous fiscal year.
BookSummaryEofyReserve	Depreciation reserve at the end of the previous fiscal year.
BookSummaryEopAdjCost	Adjusted cost at the end of the previous period.
BookSummaryEopFormulaFactor	Formula factor at the end of the previous period.
BookSummaryExpenseAdjustmentAmount	The depreciation expense adjustment amount for the period.
BookSummaryExtendedDeprnFlag	Indicates whether to extend depreciation beyond the useful life of the asset.
BookSummaryFiscalYear	The name of the accounting fiscal year.
BookSummaryFlatRateId	Identifies the rates for flat rate depreciation methods.
BookSummaryFormulaFactor	Factor used to adjust the depreciation rate for formula-NBV method assets.
BookSummaryFullyReserveOnAddFlag	Indicates whether to fully depreciate an asset when the asset is added.
BookSummaryFullyReservedFlag	Fully reserved
BookSummaryFullyRetiredFlag	Indicates whether the asset is fully retired.
BookSummaryFullyRsvdRevalsCounter	Number of times the asset has been revalued as fully reserved.
BookSummaryGeneralFund	General Fund
BookSummaryGroupAssetId	Identifier of the group asset.
BookSummaryImpReserveRetAdjAmount	The impairment reserve retired adjustment amount for the period.
BookSummaryImpairLossBalance	Impairment Loss Balance
BookSummaryImpairmentAmount	Impairment loss balance of the asset immediately after the impairment.
BookSummaryImpairmentReserve	The impairment reserve amount.
BookSummaryImpairmentReserveAdjAmount	The impairment reserve adjustment amount for the period.
BookSummaryLastUpdateDate	The date the asset was updated.
BookSummaryLastUpdateLogin	The session login associated with the user who last updated the asset.
BookSummaryLastUpdatedBy	The user who last updated the asset.
BookSummaryLeaseAdjustmentFactor	The internal factor used to amortize the lease basis over the remaining lease term of the asset.
BookSummaryLeaseExpenseBasis	The basis amount used for calculating the periodic lease expense amount for assets attached to operating leases.
BookSummaryLeaseId	Unique lease identification number.
BookSummaryLeaseScheduleId	Unique lease payment schedule identification number.
BookSummaryLifeCompleteFlag	Life Completed Period
BookSummaryLtdCostOfRemoval	Indicates whether the net of the cost of removal that can be added to the accumulated depreciation is limited to the recoverable cost of the retiring member asset.
BookSummaryLtdProceedsOfSale	The life-to-date proceeds of sale amount for the asset.
BookSummaryLtdProduction
BookSummaryMemberDeprnLimitAmount	The depreciation limit amount for the sum of the member assets.
BookSummaryMemberSalvageValue	The salvage value for the sum of the member assets.
BookSummaryMethodId	Identifier of the depreciation method.
BookSummaryObjectVersionNumber	The number of times the Book row has been updated.
BookSummaryOverDepreciateOption	Indicates whether a group asset should stop depreciating beyond its depreciation limit.
BookSummaryPercentSalvageValue	Value an asset will realize upon its sale at the end of its useful life.
BookSummaryPeriodCounter	Identifier of the depreciation period.
BookSummaryPeriodNum	Period Number
BookSummaryPolishAdjRecCost	The adjusted recoverable cost used for assets with a Polish depreciation basis rule.
BookSummaryPolishDeprnBasis	The rates used in the depreciation methods to calculate depreciation for assets using Polish Tax Depreciation.
BookSummaryProduction
BookSummaryProductionCapacity
BookSummaryRateAdjustmentFactor	Internal factor used to adjust depreciation rates to depreciate the net book value over the remaining life.
BookSummaryRecoverableCost	The cost of an asset minus the salvage value.
BookSummaryRemainingLife1	The asset remaining life first variable used for defining formula-based depreciation methods.
BookSummaryRemainingLife2	The asset remaining life second variable used for defining formula-based depreciation methods.
BookSummaryReserveAdjustmentAmount	Depreciation Reserve Adjustment Amount
BookSummaryReserveRetAdjAmount	The depreciation reserve retired adjustment amount for the period.
BookSummaryResetAdjustedCostFlag	An option that indicates whether there is an adjustment that requires you to recalculate the adjusted cost of the asset.
BookSummaryRevalAmortBalance	Revaluation Amortization Balance
BookSummaryRevalAmortization
BookSummaryRevalAmortizationBasis
BookSummaryRevalCeiling
BookSummaryRevalDeprnExpense
BookSummaryRevalLossBalance	Revaluation Loss Balance
BookSummaryRevalReserve
BookSummaryRevalReserveAdjAmount	Revaluation Reserve Amortization Adjustment Amount
BookSummaryRevalReserveRetAdjAmount	The revaluation reserve retired adjustment amount for the period.
BookSummarySalvageType	Salvage type assigned to the asset. It can be either the amount, percentage, or sum of member assets.
BookSummarySalvageValue	Value an asset will realize upon its sale at the end of its useful life.
BookSummaryShortFiscalYearFlag	Option indicating whether the asset is added in a short tax year.
BookSummarySwitchCode	The current depreciation code for a Polish depreciation basis that's in use for the asset.
BookSummarySystemBonusDeprnAmount	Bonus depreciation expense for the depreciation period.
BookSummarySystemDeprnAmount	Asset depreciation expense amount for the asset.
BookSummaryTerminalGainLossAmount	Accumulated depreciation remaining for the group asset after the last member asset of the group asset is retired.
BookSummaryTerminalGainLossFlag	Option indicating whether the terminal gain or loss amount must be processed by the Calculate Gains and Losses process when it is running for the last period of the fiscal year.
BookSummaryTransactionHeaderIdIn	Identifier of the transaction that created the row in the FA_BOOKS table.
BookSummaryTransactionHeaderIdOut	Identifier of the transaction that terminated the row in the FA_BOOKS table.
BookSummaryUnitOfMeasure
BookSummaryUnplannedAmount
BookSummaryUnrevaluedCost
BookSummaryYtdCostOfRemoval	Year-to-date amount of the cost of removal of the asset.
BookSummaryYtdDeprn	Year-to-date depreciation expense.
BookSummaryYtdImpairment	Year-to-date impairment amount.
BookSummaryYtdProceedsOfSale	The year-to-date proceeds of sale for an asset.
BookSummaryYtdProduction
BookSummaryYtdRevalDeprnExpense