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. |