Books
The Books view object contains information needed for calculating depreciation. Oracle Fusion Assets inserts a row in this table when you add, adjust, retire, and reinstate an asset.
Data Store Key : FscmTopModelAM.FinExtractAM.FaBiccExtractAM.BookExtractPVO
Primary Keys : BookTransactionHeaderIdIn
Initial Extract Date : BookCreationDate
Incremental Extract Date : BookLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| BookAdjustedCapacity | Remaining production capacity used to depreciate assets that use units of production methods. |
| BookAdjustedCost | The adjusted cost of an asset. |
| BookAdjustedRecoverableCost | The adjusted portion of the current cost that can be depreciated. |
| BookAllocateToFullyRetFlag | Indicates whether the group asset depreciation amount is allocated to all of the member assets, including fully retired member assets. |
| BookAllocateToFullyRsvFlag | Indicates whether the group asset depreciation amount is allocated to all of the member assets, including fully reserved member assets. |
| BookAllowedDeprnLimit | Depreciation limit percentage that is applied automatically when assets are added with this asset category. |
| BookAllowedDeprnLimitAmount | Depreciation limit amount that is applied automatically when assets are added with this asset category. |
| BookAnnualDeprnRoundingFlag | Option indicating whether Oracle Fusion Assets should subtract year-to-date depreciation from the annual depreciation amount to get the depreciation amount for the last period of the fiscal year. |
| BookAssetId | Identifier of the asset number. |
| BookBonusRuleId | Identifier for the depreciation bonus rule. |
| BookBookTypeCode | Unique book identification name. |
| BookCapitalizeFlag | Indicates whether the asset is a capitalized asset. |
| BookCashGeneratingUnitId | Identifier of the cash generating unit. |
| BookCeilingTypeId | Identifier of the depreciation ceiling. |
| BookCipCost | Account used to reflect the cost of a construction-in-process asset. |
| BookContractId | Unique identifier of the lease contract. |
| BookConventionTypeId | Identifier of the prorate convention. |
| BookConversionDate | The date on which a conversion rate is used to convert an amount into another currency. |
| BookCost | Total recorded cost of the asset. |
| BookCreatedBy | The user who created the row. |
| BookCreationDate | The date and time of the creation of the row. |
| BookDateEffective | Date when the row became effective. |
| BookDateIneffective | Date when the row became inactive. |
| BookDatePlacedInService | Date on which the asset was placed in service. |
| BookDepreciateFlag | Indicates whether the asset is depreciating. |
| BookDepreciationOption | Indicates whether the depreciation expense of a member asset is calculated using its group asset depreciation rules or the member asset depreciation rules. |
| BookDeprnAdjustmentFactor | The internal adjustment factor used to calculate the depreciation. |
| BookDeprnLimitType | Depreciation limit type assigned to the asset. It can be either the amount, percentage, sum of member assets, or none. |
| BookDeprnStartDate | The original depreciation start date. |
| BookDisabledFlag | Indicates whether the lookup required to use the Group Asset feature is enabled. |
| BookDryHoleFlag | Option indicating whether an energy asset is classified as a dry hole. |
| BookEofyAdjCost | Adjusted cost at the end of the previous fiscal year. |
| BookEofyFormulaFactor | Formula factor at the end of the previous fiscal year. |
| BookEofyReserve | Depreciation reserve at the end of the previous fiscal year. |
| BookEofyRevalReserve | Revaluation reserve at the end of the previous fiscal year. |
| BookEopAdjCost | Adjusted cost at the end of the previous period. |
| BookEopFormulaFactor | Formula factor at the end of the previous period. |
| BookExcessAllocationOption | Indicates whether excess depreciation of the group asset is allocated to its member assets or reduced from the group asset depreciation. |
| BookExcludeFullyRsvFlag | Indicates whether the depreciable basis of fully reserved assets should be excluded from the depreciable basis of group assets. |
| BookExcludeProceedsFromBasis | The group asset retirement rule that indicates whether proceeds of sale should be excluded when calculating the depreciable basis for group assets. |
| BookExtendedDepreciationPeriod | Oracle internal use only. Identifier of the depreciation period in which the asset was fully extended. |
| BookExtendedDeprnFlag | Indicates whether to extend depreciation beyond the useful life of the asset. |
| BookFairMarketValue | Fair market value of the asset. |
| BookFlatRateId | Identifies the rates for flat rate depreciation methods. |
| BookFormulaFactor | Factor used to adjust the depreciation rate for formula-NBV method assets. |
| BookFullyReserveOnAddFlag | Indicates whether to fully depreciate an asset when the asset is added. |
| BookFullyRsvdRevalsCounter | Number of times the asset has been revalued as fully reserved. |
| BookGlobalAttribute1 | A segment for the Books Regional Information global descriptive flexfield. |
| BookGlobalAttribute10 | A segment for the Books Regional Information global descriptive flexfield. |
| BookGlobalAttribute11 | A segment for the Books Regional Information global descriptive flexfield. |
| BookGlobalAttribute12 | A segment for the Books Regional Information global descriptive flexfield. |
| BookGlobalAttribute13 | A segment for the Books Regional Information global descriptive flexfield. |
| BookGlobalAttribute14 | A segment for the Books Regional Information global descriptive flexfield. |
| BookGlobalAttribute15 | A segment for the Books Regional Information global descriptive flexfield. |
| BookGlobalAttribute16 | A segment for the Books Regional Information global descriptive flexfield. |
| BookGlobalAttribute17 | A segment for the Books Regional Information global descriptive flexfield. |
| BookGlobalAttribute18 | A segment for the Books Regional Information global descriptive flexfield. |
| BookGlobalAttribute19 | A segment for the Books Regional Information global descriptive flexfield. |
| BookGlobalAttribute2 | A segment for the Books Regional Information global descriptive flexfield. |
| BookGlobalAttribute20 | A segment for the Books Regional Information global descriptive flexfield. |
| BookGlobalAttribute3 | A segment for the Books Regional Information global descriptive flexfield. |
| BookGlobalAttribute4 | A segment for the Books Regional Information global descriptive flexfield. |
| BookGlobalAttribute5 | A segment for the Books Regional Information global descriptive flexfield. |
| BookGlobalAttribute6 | A segment for the Books Regional Information global descriptive flexfield. |
| BookGlobalAttribute7 | A segment for the Books Regional Information global descriptive flexfield. |
| BookGlobalAttribute8 | A segment for the Books Regional Information global descriptive flexfield. |
| BookGlobalAttribute9 | A segment for the Books Regional Information global descriptive flexfield. |
| BookGlobalAttributeCategory | The context name for the Books Regional Information global descriptive flexfield. |
| BookGlobalAttributeDate1 | A date segment for the Books Regional Information global descriptive flexfield. |
| BookGlobalAttributeDate2 | A date segment for the Books Regional Information global descriptive flexfield. |
| BookGlobalAttributeDate3 | A date segment for the Books Regional Information global descriptive flexfield. |
| BookGlobalAttributeDate4 | A date segment for the Books Regional Information global descriptive flexfield. |
| BookGlobalAttributeDate5 | A date segment for the Books Regional Information global descriptive flexfield. |
| BookGlobalAttributeNumber1 | A number segment for the Books Regional Information global descriptive flexfield. |
| BookGlobalAttributeNumber2 | A number segment for the Books Regional Information global descriptive flexfield. |
| BookGlobalAttributeNumber3 | A number segment for the Books Regional Information global descriptive flexfield. |
| BookGlobalAttributeNumber4 | A number segment for the Books Regional Information global descriptive flexfield. |
| BookGlobalAttributeNumber5 | A number segment for the Books Regional Information global descriptive flexfield. |
| BookGroupAssetId | Identifier of the group asset. |
| BookItcAmount | Investment tax credit amount of the asset. |
| BookItcAmountId | Identifier of the investment tax credit. |
| BookItcBasis | The investment tax credit calculation basis. |
| BookLastPriceIndexValue | Stores the value of the price index used during index-based revaluation for future revaluations. |
| BookLastUpdateDate | The date the asset was updated. |
| BookLastUpdateLogin | The session login associated with the user who last updated the asset. |
| BookLastUpdatedBy | The user who last updated the asset. |
| BookLeaseId | Unique lease identification number. |
| BookLimitProceedsFlag | Indicates whether the proceeds of sale of the member asset is limited to its recoverable cost. |
| BookLowValueAssetFlag | Indicates whether the asset is a low value asset. |
| BookLtdCostOfRemoval | 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. |
| BookLtdProceeds | Indicates whether the net of proceeds that can be added to accumulated depreciation is limited to the recoverable cost of the retiring member asset. |
| BookMemberRollupFlag | Option indicating whether group asset depreciation is the sum of member asset depreciation or calculated separately. |
| BookMethodId | Identifier of the depreciation method. |
| BookNbvAtSwitch | The net book value of the asset at the time you switch the depreciation method from declining balance to straight line. |
| BookObjectVersionNumber | The number of times the Book row has been updated. |
| BookOldAdjustedCapacity | Production capacity used to calculate the periodic depreciation amount. |
| BookOldAdjustedCost | The historical cost of an adjusted asset. |
| BookOriginalCost | The original cost of the asset. |
| BookOriginalDeprnStartDate | The original depreciation start date of the asset. |
| BookOverDepreciateOption | Indicates whether a group asset should stop depreciating beyond its depreciation limit. |
| BookPercentSalvageValue | Value an asset will realize upon its sale at the end of its useful life. |
| BookPeriodCounterCapitalized | Identifier of the depreciation period in which the asset is capitalized. |
| BookPeriodCounterExtended | The period in which extended depreciation starts for the asset. |
| BookPeriodCounterFullyExtended | Identifier of the depreciation period in which the asset life was extended. |
| BookPeriodCounterFullyReserved | Identifier of the depreciation period in which the asset was fully reserved. |
| BookPeriodCounterFullyRetired | Identifier of the depreciation period in which the asset was fully retired. |
| BookPeriodCounterLifeComplete | Identifier of the asset book period in which the life of the asset was completed. |
| BookPriorDeprnLimit | The depreciation limit percentage of the asset before its depreciation is extended. |
| BookPriorDeprnLimitAmount | The depreciation limit amount of the asset before its depreciation is extended. |
| BookPriorDeprnLimitType | The depreciation limit type used for the asset before its depreciation is extended. |
| BookPriorEofyReserve | Previous accumulated depreciation at the end of the previous fiscal year. |
| BookPriorFlatRateId | Identifier of the flat rate for the depreciation method of the asset immediately before it began extended depreciation. |
| BookPriorMethodId | Identifier of the depreciation method for the asset immediately before it began extended depreciation. |
| BookProductionCapacity | Production capacity that is selected automatically when assets are added with this asset category. |
| BookProrateDate | Date used to calculate the annual depreciation for assets. |
| BookRateAdjustmentFactor | Internal factor used to adjust depreciation rates to depreciate the net book value over the remaining life. |
| BookRateInUse | Depreciation rates used to depreciate the net book value over the remaining life. |
| BookRecaptureReserveFlag | Indicates whether the accumulated depreciation of a group asset can exceed its recoverable cost without triggering the recognition of a gain. |
| BookRecognizeGainLoss | Indicates whether to recognize gain or loss immediately for member assets. |
| BookRecoverableCost | The cost of an asset minus the salvage value. |
| BookReduceAdditionFlag | Indicates whether the reduction rate should be applied for member asset additions. |
| BookReduceAdjustmentFlag | Indicates whether the reduction rate should be applied for member asset adjustments. |
| BookReduceRetirementFlag | Indicates whether the reduction rate should be applied for member asset retirements. |
| BookReductionRate | Rate used by a group asset to calculate reduced depreciation for its member assets based on the depreciable basis rule. |
| BookRemainingLife1 | The asset remaining life first variable used for defining formula-based depreciation methods. |
| BookRemainingLife2 | The asset remaining life second variable used for defining formula-based depreciation methods. |
| BookRetirementDeprnOption | Unique identifier for an in-progress asset retirement transaction. |
| BookRetirementId | Identifier of the asset retirement transaction. |
| BookRevalAmortizationBasis | Revaluation reserve amount used to calculate amortization of revaluation reserve. This amount changes only when the asset is revalued or an amortized adjustment is performed. |
| BookRevalCeiling | Upper limit for revaluing asset cost. |
| BookRevaluedCost | Increase or decrease in cost due to revaluation of an asset. Can be a positive or negative amount. |
| BookSalvageType | Salvage type assigned to the asset. It can be either the amount, percentage, or sum of member assets. |
| BookSalvageValue | Value an asset will realize upon its sale at the end of its useful life. |
| BookShortFiscalYearFlag | Option indicating whether the asset is added in a short tax year. |
| BookTerminalGainLoss | Indicates how terminal gain or loss is recognized for member asset retirements. |
| BookTerminalGainLossAmount | Accumulated depreciation remaining for the group asset after the last member asset of the group asset is retired. |
| BookTerminalGainLossFlag | 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. |
| BookTrackingMethod | The group asset tracking method that is used to calculate group depreciation and member asset depreciation. |
| BookTransactionHeaderIdIn | Identifier of the transaction that created the row in the FA_BOOKS table. |
| BookTransactionHeaderIdOut | Identifier of the transaction that terminated the row in the FA_BOOKS table. |
| BookUnitOfMeasure | Unit of measure used to select candidate assets depreciating under a units of production depreciation method. |
| BookUnrevaluedCost | Cost without regard to any revaluations. |
| BookUseBooksSummaryFlag | Indicates whether the FA_BOOKS_SUMMARY table for the asset was populated. |
| BookYtdProceeds | The year-to-date proceeds of sale for an asset. |