Book Controls

The Book Controls view object contains all information about the asset depreciation book. It contains depreciation rules, accounts, and calendars. Asset books are set up before adding assets to the book.

Data Store Key : FscmTopModelAM.FinExtractAM.FaBiccExtractAM.BookControlExtractPVO

Primary Keys : BookControlBookTypeCode

Initial Extract Date : BookControlCreationDate

Incremental Extract Date : BookControlLastUpdateDate

Attributes

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

Name Description
BookControlAccountingFlexStructure Identifier of the accounting flexfield structure.
BookControlAdvancedOptionsEnabledFlag Indicates whether advanced features are allowed for this book.
BookControlAllowBackdatedTransfersFlag Indicates whether backdated transfers are allowed in the tax book.
BookControlAllowBonusDeprnFlag Indicates whether bonus depreciation is allowed.
BookControlAllowCipAssetsFlag Indicates if an asset book can permit tracking of construction-in-process assets.
BookControlAllowCipDepGroupFlag Indicates if an asset book can calculate depreciation for construction-in-process assets.
BookControlAllowCipMemberFlag Indicates if an asset book can permit construction-in-process members for group assets.
BookControlAllowCostBasedRevalFlag The revaluation method that revalues both the gross and net carrying cost of the asset.
BookControlAllowCostCeiling Indicates whether an asset book can consider cost ceilings for depreciation calculation.
BookControlAllowCostSignChangeFlag Indicates whether an asset book can handle changes to the cost of an asset that result in the value changing from positive to negative, or vice versa.
BookControlAllowDeprnAdjustments Indicates whether depreciation adjustments are allowed for the book.
BookControlAllowDeprnExpCeiling Indicates whether an asset book can consider expense ceilings for depreciation calculation.
BookControlAllowDeprnOverrideFlag Allows you to enter a depreciation override amount for assets in the book.
BookControlAllowDirectTaxAdditionFlag Indicates whether direct asset additions are allowed for the tax book.
BookControlAllowFundAccountingFlag Allows capital fund accounting for the asset book.
BookControlAllowGroupDeprnFlag Indicates whether an asset book can handle group asset depreciation.
BookControlAllowImpairmentFlag Indicates whether impairment transactions are allowed for the asset book.
BookControlAllowIntercoGroupFlag Indicates if an asset book can permit asset members from different companies within a group.
BookControlAllowLeasesFlag Indicates whether leased assets are allowed for the asset book.
BookControlAllowMassChanges Indicates if an asset book can accept mass change transactions.
BookControlAllowMassCopy Indicates if an asset book can accept mass copy transactions.
BookControlAllowMemberTrackingFlag Indicates that the depreciation balance is maintained at the group member level.
BookControlAllowNbvBasedRevalFlag The revaluation method that revalues only the net carrying cost of the asset.
BookControlAllowPhysicalInventoryFlag Indicates whether physical inventory is allowed for the asset book.
BookControlAllowPurgeFlag Indicates whether purging is allowed.
BookControlAllowRevalFlag Indicates whether revaluation of an asset is allowed.
BookControlAllowTaxDistributionsFlag Indicates whether the tax book has its own asset distribution or uses the distribution of the associated corporate book.
BookControlAllowTransConventionFlag Indicates whether prorate conventions are allowed for asset adjustment and transfer transactions.
BookControlAllowUkGovernmentRevalFlag Indicates whether UK government revaluation is enabled for the book.
BookControlAllowUnallocatedLinesFlag Allows you to transfer unallocated Payables invoice lines.
BookControlAmortizeFlag Indicates whether amortized transactions are allowed for the book.
BookControlAmortizeRevalReserveFlag Allows you to amortize the revaluation reserve of the assets.
BookControlAttribute1 A segment for the Book descriptive flexfield.
BookControlAttribute10 A segment for the Book descriptive flexfield.
BookControlAttribute11 A segment for the Book descriptive flexfield.
BookControlAttribute12 A segment for the Book descriptive flexfield.
BookControlAttribute13 A segment for the Book descriptive flexfield.
BookControlAttribute14 A segment for the Book descriptive flexfield.
BookControlAttribute15 A segment for the Book descriptive flexfield.
BookControlAttribute2 A segment for the Book descriptive flexfield.
BookControlAttribute3 A segment for the Book descriptive flexfield.
BookControlAttribute4 A segment for the Book descriptive flexfield.
BookControlAttribute5 A segment for the Book descriptive flexfield.
BookControlAttribute6 A segment for the Book descriptive flexfield.
BookControlAttribute7 A segment for the Book descriptive flexfield.
BookControlAttribute8 A segment for the Book descriptive flexfield.
BookControlAttribute9 A segment for the Book descriptive flexfield.
BookControlAttributeCategoryCode The context name for the Book descriptive flexfield.
BookControlAttributeDate1 A date segment for the Book descriptive flexfield.
BookControlAttributeDate2 A date segment for the Book descriptive flexfield.
BookControlAttributeDate3 A date segment for the Book descriptive flexfield.
BookControlAttributeDate4 A date segment for the Book descriptive flexfield.
BookControlAttributeDate5 A date segment for the Book descriptive flexfield.
BookControlAttributeNumber1 A number segment for the Book descriptive flexfield.
BookControlAttributeNumber2 A number segment for the Book descriptive flexfield.
BookControlAttributeNumber3 A number segment for the Book descriptive flexfield.
BookControlAttributeNumber4 A number segment for the Book descriptive flexfield.
BookControlAttributeNumber5 A number segment for the Book descriptive flexfield.
BookControlBookClass Indicates the class of the asset book. For example, corporate or tax book.
BookControlBookControlId Identifier for the asset book.
BookControlBookTypeCode The unique identifier for the asset book name.
BookControlBookTypeName Asset book description.
BookControlCapThresholdAmount The threshold amount used to determine whether to capitalize or expense an asset source line.
BookControlCapThresholdType Capitalization threshold type for the asset book. It can be either Cost, Unit, or none.
BookControlCapitalGainThreshold Minimum time to hold an asset for Oracle Fusion Assets to report it as a capital gain on form 4797 reports when you retire it.
BookControlCopyAdditionsFlag Indicates if asset additions can be copied to other books.
BookControlCopyAdjustmentsFlag Indicates if asset adjustments can be copied to other books.
BookControlCopyAllCostAdjustmentsFlag Indicates whether to copy transactions from the corporate book even though the tax books are not synchronized.
BookControlCopyAmortAdajExpFlag This option copies amortized addition and adjusted cost in the corporate book as expensed in the tax book.
BookControlCopyGroupAdditionFlag Indicates whether group asset additions can be copied to other books.
BookControlCopyGroupAssignmentFlag Indicates whether asset adjustments can be copied to other books.
BookControlCopyGroupChangeFlag Indicates whether group asset changes can be copied to tax books.
BookControlCopyRetirementsFlag Indicates whether asset retirements can be copied to tax books.
BookControlCopySalvageValueFlag Indicates whether the asset salvage value can be copied to tax books.
BookControlCopyTransfersFlag Indicates whether the Mass Copy process can copy asset transfers to tax books.
BookControlCostOfRemovalClearingAcct Cost of removal clearing account for retirement transactions.
BookControlCostOfRemovalGainAcct Cost of removal account for retirement transactions that result in a gain.
BookControlCostOfRemovalLossAcct Cost of removal account for retirement transactions that result in a loss.
BookControlCreateAccountingRequestId Indicates the request ID of the last run of the Create Accounting process.
BookControlCreateAccountingRunDate Date on which the Create Accounting process was run.
BookControlCreatedBy The user who created the asset book.
BookControlCreationDate The date the asset book was created.
BookControlCurrentFiscalYear Current accounting fiscal year.
BookControlDateIneffective Date the referenced asset book was inactivated.
BookControlDefaultDpisToInvDateFlag Indicates whether to use the Payables invoice date as the asset placed in service date.
BookControlDefaultLifeExtensionCeiling The default life extension ceiling of the book.
BookControlDefaultLifeExtensionFactor The default life extension factor of the book.
BookControlDefaultMaxFullyRsvdRevals The default maximum revaluations allowed for the book.
BookControlDefaultPeriodEndRevalFlag Allows you to include the current period depreciation amount in revaluation calculations.
BookControlDefaultRevalFullyRsvdFlag Allows you to revalue fully reserved assets in the book.
BookControlDeferredDeprnExpenseAcct Account that reflects the temporary difference in depreciation expense between the corporate book and the tax book.
BookControlDeferredDeprnReserveAcct Account that reflects the temporary difference in depreciation reserve between the corporate book and the tax book.
BookControlDeprFirstYearRetFlag Indicates whether to depreciate assets retired in the first year of life.
BookControlDeprnAdjustmentAcct Account that reflects depreciation adjustments.
BookControlDeprnAllocationCode Spreads annual depreciation over the depreciation periods of the fiscal year.
BookControlDeprnCalendar Name of the depreciation calendar.
BookControlDeprnRequestId Indicates the request ID of the last run of the Calculate Depreciation process.
BookControlDeprnStatus Last condition of the Calculate Depreciation process.
BookControlDistributionSourceBook Indicates the asset book that contains the asset distribution information.
BookControlFiscalYearName The name of the accounting fiscal year.
BookControlFlexbuilderDefaultsCcid Indicates the account code combination used as the default value for accounting segments.
BookControlGlPostingAllowedFlag Indicates whether accounting entries can be posted to Oracle Fusion General Ledger.
BookControlGlobalAttribute1 A segment for the Book Regional Information global descriptive flexfield.
BookControlGlobalAttribute10 A segment for the Book Regional Information global descriptive flexfield.
BookControlGlobalAttribute11 A segment for the Book Regional Information global descriptive flexfield.
BookControlGlobalAttribute12 A segment for the Book Regional Information global descriptive flexfield.
BookControlGlobalAttribute13 A segment for the Book Regional Information global descriptive flexfield.
BookControlGlobalAttribute14 A segment for the Book Regional Information global descriptive flexfield.
BookControlGlobalAttribute15 A segment for the Book Regional Information global descriptive flexfield.
BookControlGlobalAttribute16 A segment for the Book Regional Information global descriptive flexfield.
BookControlGlobalAttribute17 A segment for the Book Regional Information global descriptive flexfield.
BookControlGlobalAttribute18 A segment for the Book Regional Information global descriptive flexfield.
BookControlGlobalAttribute19 A segment for the Book Regional Information global descriptive flexfield.
BookControlGlobalAttribute2 A segment for the Book Regional Information global descriptive flexfield.
BookControlGlobalAttribute20 A segment for the Book Regional Information global descriptive flexfield.
BookControlGlobalAttribute3 A segment for the Book Regional Information global descriptive flexfield.
BookControlGlobalAttribute4 A segment for the Book Regional Information global descriptive flexfield.
BookControlGlobalAttribute5 A segment for the Book Regional Information global descriptive flexfield.
BookControlGlobalAttribute6 A segment for the Book Regional Information global descriptive flexfield.
BookControlGlobalAttribute7 A segment for the Book Regional Information global descriptive flexfield.
BookControlGlobalAttribute8 A segment for the Book Regional Information global descriptive flexfield.
BookControlGlobalAttribute9 A segment for the Book Regional Information global descriptive flexfield.
BookControlGlobalAttributeCategory The context name for the Book Regional Information global descriptive flexfield.
BookControlGlobalAttributeDate1 A date segment for the Book Regional Information global descriptive flexfield.
BookControlGlobalAttributeDate2 A date segment for the Book Regional Information global descriptive flexfield.
BookControlGlobalAttributeDate3 A date segment for the Book Regional Information global descriptive flexfield.
BookControlGlobalAttributeDate4 A date segment for the Book Regional Information global descriptive flexfield.
BookControlGlobalAttributeDate5 A date segment for the Book Regional Information global descriptive flexfield.
BookControlGlobalAttributeNumber1 A number segment for the Book Regional Information global descriptive flexfield.
BookControlGlobalAttributeNumber2 A number segment for the Book Regional Information global descriptive flexfield.
BookControlGlobalAttributeNumber3 A number segment for the Book Regional Information global descriptive flexfield.
BookControlGlobalAttributeNumber4 A number segment for the Book Regional Information global descriptive flexfield.
BookControlGlobalAttributeNumber5 A number segment for the Book Regional Information global descriptive flexfield.
BookControlInitialDate Starting date of the asset book.
BookControlInitialPeriodCounter The calendar period before the period book is created.
BookControlItcAllowedFlag Indicates whether the investment tax credit is allowed.
BookControlLastCreateMassAdditionsId The request ID of the last run of the Create Mass Additions process.
BookControlLastDepreciationRunDate Date on which the Calculate Depreciation process was run last time for the book.
BookControlLastDeprnRunDate Date on which the Calculate Depreciation process was run last time for the book.
BookControlLastMassCopyPeriodCounter Identifier of the last corporate period for which the Mass Copy process is run for this tax book.
BookControlLastPeriodCounter Identifier of the last period for which the Calculate Depreciation process was run.
BookControlLastPostMassAdditionsId The request ID of the last run of the Post Mass Additions process.
BookControlLastPurgePeriodCounter Identifier of the last period for which the Purge process was run.
BookControlLastUpdateDate The date of the most recent change.
BookControlLastUpdateLogin The session login associated with the user who edited the asset book.
BookControlLastUpdatedBy The user name of the person who last edited the asset book.
BookControlLowValueThresholdAmount The threshold amount used to determine whether the asset needs to be added as a low value capitalized asset.
BookControlMassCopySourceBook The associated corporate book from which transactions are to be copied to the tax book.
BookControlMassRequestId Indicates the request ID of the last run of the Mass Transaction process.
BookControlMcSourceFlag Indicates whether the asset book has reporting currency.
BookControlNbvAmountThreshold The net book value threshold amount for a book.
BookControlNbvFractionThreshold The net book value threshold fraction for a book.
BookControlNbvRetiredGainAcct Account used to track the cost minus the accumulated depreciation when you retire an asset that results in a gain.
BookControlNbvRetiredLossAcct Account used to track the cost minus the accumulated depreciation when you retire an asset that results in a loss.
BookControlObjectVersionNumber The number of times an asset book was edited.
BookControlPreventPriorPeriodTxnsFlag Indicates if an asset book can permit amortized adjustments in the prior period.
BookControlProceedsOfSaleClearingAcct Proceeds of sale clearing account for retirement transactions.
BookControlProceedsOfSaleGainAcct Proceeds of sale account for a retirement that results in a gain.
BookControlProceedsOfSaleLossAcct Proceeds of sale account for a retirement that results in a loss.
BookControlProrateCalendar Determines what rate the application uses to calculate annual depreciation by mapping each date to a prorate period.
BookControlRequireLocationFlag Indicates whether location tracking is required for the assets in the book.
BookControlRetireRevalReserveFlag The option that lets you retire the revaluation reserve of assets.
BookControlRevalDeprnReserveFlag The option that lets you revalue the depreciation reserve of assets.
BookControlRevalRsvRetiredGainAcct Revaluation reserve retired account for a retirement that results in a gain.
BookControlRevalRsvRetiredLossAcct Revaluation reserve retired account for a retirement that results in a loss.
BookControlRevalYtdDeprnFlag Indicates whether to revalue the YTD depreciation of the assets.
BookControlRoundAnnualDepreciation Annual depreciation rounding option that can be selected from the predefined options.
BookControlSetOfBooksId Indicates the accounting ledger of the book.
BookControlSorpEnabledFlag Option indicating whether the statement of recommended accounting practice feature is enabled.
BookControlSuppressInvAutoMergeFlag The option that lets you suspend an automatic merge of Payables invoice lines.
BookControlTrackSourceLinesInTaxFlag Indicates whether source lines are allowed for the assets in the tax book.
BookControlUseNbvThresholdFlag Indicates whether to use the net book value threshold for asset depreciation.