Reporting Books
The Reporting Books view object contains currency and financial information about assets in each reporting book associated with the parent record in the FA_BOOKS table. This table stores transactions in reporting currencies, and also stores transactions from tax books that use a secondary ledger with different currencies.
Data Store Key : FscmTopModelAM.FinExtractAM.FaBiccExtractAM.ReportingBookExtractPVO
Primary Keys : ReportingBookSetOfBooksId, ReportingBookTransactionHeaderIdIn
Initial Extract Date : ReportingBookCreationDate
Incremental Extract Date : ReportingBookLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| ReportingBookAcceleratedAdjustedCost | The base amount on which the accelerated depreciation is calculated. |
| ReportingBookAcceleratedBonusRuleId | Bonus rule used to take a higher depreciation amount than the amount calculated by the depreciation method. |
| ReportingBookAdjustedCapacity | Remaining production capacity used to depreciate assets that use units of production methods. |
| ReportingBookAdjustedCost | The adjusted cost of an asset. |
| ReportingBookAdjustedRecoverableCost | The adjusted portion of the current cost that can be depreciated. |
| ReportingBookAllocateToFullyRetFlag | Indicates whether the group asset depreciation amount is allocated to all of the member assets, including fully retired member assets. |
| ReportingBookAllocateToFullyRsvFlag | Indicates whether the group asset depreciation amount is allocated to all of the member assets, including fully reserved member assets. |
| ReportingBookAllowedDeprnLimit | Depreciation limit percentage that is applied automatically when assets are added with this asset category. |
| ReportingBookAllowedDeprnLimitAmount | Depreciation limit amount that is applied automatically when assets are added with this asset category. |
| ReportingBookAnnualDeprnRoundingFlag | The rounding depreciation options. |
| ReportingBookAssetId | Identifier of the asset number. |
| ReportingBookBonusAdjustedCost | The base amount on which the bonus depreciation is calculated. |
| ReportingBookBonusRuleId | Identifier for the depreciation bonus rule. |
| ReportingBookBookTypeCode | Unique book identification name. |
| ReportingBookCapitalizeFlag | Indicates whether the asset is a capitalized asset. |
| ReportingBookCashGeneratingUnitId | Identifier of the cash generating unit. |
| ReportingBookCeilingTypeId | Identifier of the depreciation ceiling. |
| ReportingBookCipCost | Account used to reflect the cost of a construction-in-process asset. |
| ReportingBookContractId | Unique identifier of the lease contract. |
| ReportingBookConventionTypeId | Identifier of the prorate convention. |
| ReportingBookConversionDate | The date on which a conversion rate is used to convert an amount into another currency. |
| ReportingBookConvertedFlag | Status indicating whether the transaction amounts have been converted to the reporting currency. |
| ReportingBookCost | Total recorded cost of the asset. |
| ReportingBookCreatedBy | The user who created the books in the reporting currencies. |
| ReportingBookCreationDate | The date the reporting currency books were created. |
| ReportingBookDateEffective | Date when the row became effective. |
| ReportingBookDateIneffective | Date when the row became inactive. |
| ReportingBookDatePlacedInService | Date on which the asset was placed in service. |
| ReportingBookDepreciateFlag | Indicates whether the asset is depreciating. |
| ReportingBookDepreciationOption | Indicates whether the depreciation expense of a member asset is calculated using its group asset depreciation rules or the member asset depreciation rules. |
| ReportingBookDeprnAdjustmentFactor | The internal adjustment factor used to calculate the depreciation. |
| ReportingBookDeprnLimitType | Depreciation limit type assigned to the asset. It can be either the amount, percentage, sum of member assets, or none. |
| ReportingBookDeprnStartDate | The original depreciation start date. |
| ReportingBookDisabledFlag | Indicates whether the lookup required to use the Group Asset feature is enabled. |
| ReportingBookDryHoleFlag | Option indicating whether an energy asset is classified as a dry hole. |
| ReportingBookEofyAdjCost | Adjusted cost at the end of the previous fiscal year. |
| ReportingBookEofyFormulaFactor | Formula factor at the end of the previous fiscal year. |
| ReportingBookEofyReserve | Depreciation reserve at the end of the previous fiscal year. |
| ReportingBookEofyRevalReserve | Revaluation reserve at the end of the previous fiscal year. |
| ReportingBookEopAdjCost | Adjusted cost at the end of the previous period. |
| ReportingBookEopFormulaFactor | Formula factor at the end of the previous period. |
| ReportingBookExcessAllocationOption | Indicates whether excess depreciation of the group asset is allocated to its member assets or reduced from the group asset depreciation. |
| ReportingBookExcludeFullyRsvFlag | Indicates whether the depreciable basis of fully reserved assets should be excluded from the depreciable basis of group assets. |
| ReportingBookExcludeProceedsFromBasis | The group asset retirement rule that indicates whether proceeds of sale should be excluded when calculating the depreciable basis for group assets. |
| ReportingBookExtendedDepreciationPeriod | Oracle internal use only. Identifier of the depreciation period in which the asset was fully extended. |
| ReportingBookExtendedDeprnFlag | Indicates whether to extend depreciation beyond the useful life of the asset. |
| ReportingBookFairMarketValue | Fair market value of the asset. |
| ReportingBookFlatRateId | Identifies the rates for flat rate depreciation methods. |
| ReportingBookFormulaFactor | Factor used to adjust the depreciation rate for formula-NBV method assets. |
| ReportingBookFullyReserveOnAddFlag | Indicates whether to fully depreciate an asset when the asset is added. |
| ReportingBookFullyRsvdRevalsCounter | Number of times the asset has been revalued as fully reserved. |
| ReportingBookGlobalAttribute1 | A segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttribute10 | A segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttribute11 | A segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttribute12 | A segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttribute13 | A segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttribute14 | A segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttribute15 | A segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttribute16 | A segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttribute17 | A segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttribute18 | A segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttribute19 | A segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttribute2 | A segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttribute20 | A segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttribute3 | A segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttribute4 | A segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttribute5 | A segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttribute6 | A segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttribute7 | A segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttribute8 | A segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttribute9 | A segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttributeCategory | The context name for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttributeDate1 | A date segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttributeDate2 | A date segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttributeDate3 | A date segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttributeDate4 | A date segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttributeDate5 | A date segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttributeNumber1 | A number segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttributeNumber10 | A number segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttributeNumber2 | A number segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttributeNumber3 | A number segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttributeNumber4 | A number segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttributeNumber5 | A number segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttributeNumber6 | A number segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttributeNumber7 | A number segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttributeNumber8 | A number segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGlobalAttributeNumber9 | A number segment for the Reporting Books Regional Information global descriptive flexfield. |
| ReportingBookGroupAssetId | Identifier of the group asset. |
| ReportingBookItcAmount | Investment tax credit amount of the asset. |
| ReportingBookItcAmountId | Identifier of the investment tax credit. |
| ReportingBookItcBasis | The investment tax credit calculation basis. |
| ReportingBookLastPriceIndexValue | Stores the value of the price index used during index-based revaluation for future revaluations. |
| ReportingBookLastUpdateDate | The date the asset was updated. |
| ReportingBookLastUpdateLogin | The session login associated with the user who last updated the asset. |
| ReportingBookLastUpdatedBy | The user who last updated the asset. |
| ReportingBookLeaseAdjustmentFactor | Internal factor used to amortize the lease basis over the remaining lease term of the asset. |
| ReportingBookLeaseExpenseBasis | Basis used for calculating the periodic lease expense of the asset. |
| ReportingBookLeaseId | Unique lease identification number. |
| ReportingBookLeaseScheduleId | Unique lease payment schedule identification number. |
| ReportingBookLimitProceedsFlag | Indicates whether the proceeds of sale of the member asset is limited to its recoverable cost. |
| ReportingBookLowValueAssetFlag | Indicates whether the asset is a low value asset. |
| ReportingBookLtdCostOfRemoval | 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. |
| ReportingBookLtdProceeds | Indicates whether the net of proceeds that can be added to accumulated depreciation is limited to the recoverable cost of the retiring member asset. |
| ReportingBookMemberRollupFlag | Option indicating whether group asset depreciation is the sum of member asset depreciation or calculated separately. |
| ReportingBookMethodId | Identifier of the depreciation method. |
| ReportingBookNbvAtSwitch | The net book value of the asset at the time you switch the depreciation method from declining balance to straight line. |
| ReportingBookObjectVersionNumber | The number of times the Reporting Book row has been updated. |
| ReportingBookOldAdjustedCapacity | Production capacity used to calculate the periodic depreciation amount. |
| ReportingBookOldAdjustedCost | The historical cost of an adjusted asset. |
| ReportingBookOriginalCost | The original cost of the asset. |
| ReportingBookOriginalDeprnStartDate | Date when the short tax year asset begins depreciating in the books of the acquired company. |
| ReportingBookOverDepreciateOption | Indicates whether a group asset should stop depreciating beyond its depreciation limit. |
| ReportingBookPercentSalvageValue | Value an asset will realize upon its sale at the end of its useful life. |
| ReportingBookPeriodCounterCapitalized | Identifier of the depreciation period in which the asset is capitalized. |
| ReportingBookPeriodCounterExtended | The period in which extended depreciation starts for the asset. |
| ReportingBookPeriodCounterFullyExtended | Identifier of the depreciation period in which the asset life was extended. |
| ReportingBookPeriodCounterFullyReserved | Identifier of the depreciation period in which the asset was fully reserved. |
| ReportingBookPeriodCounterFullyRetired | Identifier of the depreciation period in which the asset was fully retired. |
| ReportingBookPeriodCounterLifeComplete | Identifier of the asset book period in which the life of the asset was completed. |
| ReportingBookPriorDeprnLimit | The depreciation limit percentage of the asset before its depreciation is extended. |
| ReportingBookPriorDeprnLimitAmount | The depreciation limit amount of the asset before its depreciation is extended. |
| ReportingBookPriorDeprnLimitType | The depreciation limit type used for the asset before its depreciation is extended. |
| ReportingBookPriorEofyReserve | Previous accumulated depreciation at the end of the previous fiscal year. |
| ReportingBookPriorEofyRevalReserve | The value of the revaluation reserve at the end of the fiscal year before the transaction. This value is used to roll back the depreciation for the last period of the fiscal year. |
| ReportingBookPriorFlatRateId | Identifier of the flat rate for the depreciation method of the asset immediately before it began extended depreciation. |
| ReportingBookPriorMethodId | Identifier of the depreciation method for the asset immediately before it began extended depreciation. |
| ReportingBookProductionCapacity | Production capacity that is selected automatically when assets are added with this asset category. |
| ReportingBookProrateDate | Date used to calculate the annual depreciation for assets. |
| ReportingBookRateAdjustmentFactor | Internal factor used to adjust depreciation rates to depreciate the net book value over the remaining life. |
| ReportingBookRateInUse | Depreciation rates used to depreciate the net book value over the remaining life. |
| ReportingBookRecaptureReserveFlag | Indicates whether the reserve for the group asset can exceed its recoverable cost. |
| ReportingBookRecognizeGainLoss | Indicates whether gain or loss should be recognized for member asset retirements. |
| ReportingBookRecoverableCost | The cost of an asset minus the salvage value. |
| ReportingBookReduceAdditionFlag | Indicates whether the reduction rate should be applied for member asset additions. |
| ReportingBookReduceAdjustmentFlag | Indicates whether the reduction rate should be applied for member asset adjustments. |
| ReportingBookReduceRetirementFlag | Indicates whether the reduction rate should be applied for member asset retirements. |
| ReportingBookReductionRate | Depreciation reduction percentage for the group and its member assets. |
| ReportingBookRemainingLife1 | Remaining life of the asset calculated as of the conversion date, prorate date, or fiscal year start date. |
| ReportingBookRemainingLife2 | Remaining life of the asset calculated as of the fiscal year start date. |
| ReportingBookRetirementDeprnOption | Indicates whether a group asset should depreciate until the last member asset is retired or at the end of the fiscal year. |
| ReportingBookRetirementId | Identifier of the asset retirement transaction. |
| ReportingBookRevalAmortizationBasis | 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. |
| ReportingBookRevalCeiling | Upper limit for revaluing asset cost. |
| ReportingBookRevaluedCost | Increase or decrease in cost due to revaluation of an asset. Can be a positive or negative amount. |
| ReportingBookSalvageType | Salvage type assigned to the asset. It can be either the amount, percentage, or sum of member assets. |
| ReportingBookSalvageValue | Salvage value amount for the asset. |
| ReportingBookSetOfBooksId | Identifier of the accounting ledger. |
| ReportingBookShortFiscalYearFlag | Indicates whether the asset is added in a short tax year. |
| ReportingBookSourceCost | Current cost of the asset in the primary functional currency. |
| ReportingBookSourceOriginalCost | Original cost of the asset in the primary functional currency. |
| ReportingBookTerminalGainLoss | Indicates how terminal gain or loss is recognized for member asset retirements. |
| ReportingBookTerminalGainLossAmount | Accumulated depreciation remaining for the group asset after the last member asset of the group asset is retired. |
| ReportingBookTerminalGainLossFlag | 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. |
| ReportingBookTrackingMethod | The group asset tracking method that is used to calculate group depreciation and member asset depreciation. |
| ReportingBookTransactionHeaderIdIn | Identifier of the transaction that created the row in the FA_MC_BOOKS table. |
| ReportingBookTransactionHeaderIdOut | Identifier of the transaction that terminated the row in the FA_MC_BOOKS table. |
| ReportingBookUnitOfMeasure | Unit of measure used to select candidate assets depreciating under a units of production depreciation method. |
| ReportingBookUnrevaluedCost | Cost without regard to any revaluations. |
| ReportingBookUseBooksSummaryFlag | Indicates whether the FA_MC_BOOKS_SUMMARY table for the asset was populated. |
| ReportingBookYtdProceeds | The year-to-date proceeds of sale for an asset. |