AssetBook
A book represents the grouping in which fixed assets of the entity are recorded, tracked, depreciated, reported, and accounted for in the primary ledger.
Business Views
** Available for extracting data- assetBooksExtract**
This view contains information about descriptive details of the book, the book class, ledger, and currency details of the assets.
Label
Asset Books
Data Source
Read-optimized data store
Fields
- advancedOptionsEnabledFlag (boolean)
Indicates whether advanced features are allowed for this book.
Label
Allow Advanced Options
Properties
- searchable
- sortable
- allowAdditionsApprovalFlag (boolean)
Indicates whether approval for asset additions is enabled for the book
Label
Allow Additions Approval
Properties
- searchable
- sortable
- allowAdjustmentsApprovalFlag (boolean)
Indicates whether approval for asset adjustment transactions is enabled for the book.
Label
Allow Adjustments Approval
Properties
- searchable
- sortable
- allowAmortizedChangesFlag (boolean)
Indicates whether amortized transactions are allowed for the book.
Label
Allow amortized changes
Properties
- searchable
- sortable
- not nullable
- allowBackdatedTransfersFlag (boolean)
Indicates whether backdated transfers are allowed in the tax book.
Label
Allow Backdated Transfers
Properties
- searchable
- sortable
- allowBonusDepreciationFlag (boolean)
Indicates whether bonus depreciation is allowed.
Label
Allow Bonus Depreciation
Properties
- searchable
- sortable
- allowCapitalFundAccountingFlag (boolean)
Allows capital fund accounting for the asset book.
Label
Allow capital fund accounting
Properties
- searchable
- sortable
- allowCipAssetsFlag (boolean)
Indicates if an asset book can permit tracking of construction-in-process assets.
Label
Allow CIP assets
Properties
- searchable
- sortable
- allowCipDepreciationInGroupAssetFlag (boolean)
Indicates if an asset book can calculate depreciation for construction-in-process assets.
Label
Allow Construction-in-Progress Depreciation in Group Asset
Properties
- searchable
- sortable
- allowCipMembersFlag (boolean)
Indicates if an asset book can permit construction-in-process members for group assets.
Label
Allow CIP members
Properties
- searchable
- sortable
- allowConventionForAdjustmentAndTransferFlag (boolean)
Indicates whether prorate conventions are allowed for asset adjustment and transfer transactions.
Label
Allow convention for adjustment and transfer
Properties
- searchable
- sortable
- allowCostBasedRevaluationFlag (boolean)
The revaluation method that revalues both the gross and net carrying cost of the asset.
Label
Allow cost revaluation
Properties
- searchable
- sortable
- allowCostCeilingsFlag (boolean)
Indicates whether an asset book can consider cost ceilings for depreciation calculation.
Label
Allow cost ceilings
Properties
- searchable
- sortable
- not nullable
- allowCostSignChangeFlag (boolean)
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.
Label
Allow Cost Sign Change Indicator
Properties
- searchable
- sortable
- allowDepreciationAdjustmentsFlag (boolean)
Indicates whether depreciation adjustments are allowed for the book.
Label
Allow Depreciation Adjustments
Properties
- searchable
- sortable
- allowDepreciationExpenseCeilingFlag (boolean)
Indicates whether an asset book can consider expense ceilings for depreciation calculation.
Label
Allow Depreciation Expense Ceiling
Properties
- searchable
- sortable
- not nullable
- allowDepreciationOverrideFlag (boolean)
Allows you to enter a depreciation override amount for assets in the book.
Label
Allow depreciation override
Properties
- searchable
- sortable
- allowDirectTaxAssetAdditionsFlag (boolean)
Indicates whether direct asset additions are allowed for the tax book.
Label
Allow direct asset additions
Properties
- searchable
- sortable
- allowGeneralLedgerPostingFlag (boolean)
Indicates whether the accounting entries can be posted to General Ledger.
Label
Allow ledger posting
Properties
- searchable
- sortable
- not nullable
- allowGroupDepreciationFlag (boolean)
Indicates whether an asset book can handle group asset depreciation.
Label
Allow group depreciation
Properties
- searchable
- sortable
- allowImpairmentFlag (boolean)
Indicates whether impairment transactions are allowed for the asset book.
Label
Allow Impairment Indicator
Properties
- searchable
- sortable
- allowIntercompanyMemberFlag (boolean)
Indicates if an asset book can permit asset members from different companies within a group.
Label
Allow intercompany member
Properties
- searchable
- sortable
- allowLeasesFlag (boolean)
Indicates whether leased assets are allowed for the asset book.
Label
Allow Lease Assets
Properties
- searchable
- sortable
- allowLocationTrackingFlag (boolean)
Indicates whether location tracking is required for the assets in the book.
Label
Allow location tracking
Properties
- searchable
- sortable
- allowMassChangesFlag (boolean)
Indicates if an asset book can accept mass change transactions.
Label
Allow mass changes
Properties
- searchable
- sortable
- not nullable
- allowMassCopyFlag (boolean)
Indicates if an asset book can accept mass copy transactions.
Label
Allow mass copy
Properties
- searchable
- sortable
- not nullable
- allowMemberTrackingFlag (boolean)
Indicates that the depreciation balance is maintained at the group member level.
Label
Allow member tracking
Properties
- searchable
- sortable
- allowNetBookValueBasedRevaluationFlag (boolean)
The revaluation method that revalues only the net carrying cost of the asset.
Label
Allow net book value revaluation
Properties
- searchable
- sortable
- allowPhysicalInventoryFlag (boolean)
Indicates whether physical inventory is allowed for the asset book.
Label
Allow physical inventory
Properties
- searchable
- sortable
- allowPurgeFlag (boolean)
Indicates whether purging is allowed.
Label
Allow Purge
Properties
- searchable
- sortable
- allowRetirementsApprovalFlag (boolean)
Indicates whether approval for asset retirement transactions is enabled for the book.
Label
Allow Retirements Approval
Properties
- searchable
- sortable
- allowRevaluationFlag (boolean)
Indicates whether revaluation of an asset is allowed.
Label
Allow Revaluation Indicator
Properties
- searchable
- sortable
- not nullable
- allowSourceLinesInTaxFlag (boolean)
Indicates whether source lines are allowed for the assets in the tax book.
Label
Allow source lines in tax book
Properties
- searchable
- sortable
- allowTaxAssignmentsFlag (boolean)
Indicates whether the tax book has its own asset distribution or uses the distribution of the associated corporate book.
Label
Allow assignments in tax book
Properties
- searchable
- sortable
- allowTransferApprovalFlag (boolean)
Indicates whether approval for asset transfer transactions enabled for the book.
Label
Allow Transfer Approval
Properties
- searchable
- sortable
- allowTransferToAnotherBookFlag (boolean)
Indicates whether the book allows asset transfer to another book.
Label
Allow transfer to another book
Properties
- searchable
- sortable
- allowUkGovernmentRevaluationFlag (boolean)
Indicates whether UK government revaluation is enabled for the book.
Label
Allow UK Government Revaluation
Properties
- searchable
- sortable
- allowUnallocatedPayablesInvoiceLinesFlag (boolean)
Allows you to transfer unallocated Payables invoice lines.
Label
Allow unallocated Payables invoice lines
Properties
- searchable
- sortable
- amortizeRevaluationReserveFlag (boolean)
Allows you to amortize the revaluation reserve of the assets.
Label
Amortize revaluation reserve
Properties
- searchable
- sortable
- annualDepreciationRounding (enumeration: AnnualDepreciationRounding)
Annual depreciation rounding option that can be selected from the predefined options.
Label
Annual Depreciation Rounding
Type
-
Module: oraErpCoreFixedAssetsSetup
-
Enumeration Type: AnnualDepreciationRounding
Properties
- searchable
- sortable
Valid Values
- ALWAYS
- ROUNDUP_WHOLE_NUMBER
- WITH_RESTRICTIONS
-
- bookClassCode (enumeration: BookClass)
Indicates the class of the asset book. For example, corporate or tax book.
Label
Book Class Code
Type
-
Module: oraErpCoreFixedAssetsSetup
-
Enumeration Type: BookClass
Properties
- searchable
- sortable
- not nullable
Valid Values
- CORPORATE
- TAX
-
- bookControlId (int64)
The name of the asset book.
Label
Book ID
Properties
- searchable
- sortable
- capitalGainThreshold (big-decimal)
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.
Label
Capital Gain Threshold
Properties
- searchable
- sortable
- capitalizationThresholdAmount (big-decimal)
Threshold amount used to decide whether to add the invoice lines in the asset category as low value assets.
Label
Capitalization Threshold Amount
Properties
- searchable
- sortable
- capitalizationThresholdType (string)
Capitalization threshold type for the asset book. It can be either Cost, Unit, or none.
Label
Capitalization Threshold Type
Properties
- searchable
- sortable
- copyAdditionsFlag (boolean)
Indicates if asset additions can be copied to other books.
Label
Copy additions
Properties
- searchable
- sortable
- not nullable
- copyAdjustmentsFlag (boolean)
Indicates if asset adjustments can be copied to other books.
Label
Copy adjustments
Properties
- searchable
- sortable
- not nullable
- copyAmortizedAdjustmentsAsExpensedFlag (boolean)
This option copies amortized addition and adjusted cost in the corporate book as expensed in the tax book.
Label
Copy amortized adjustments as expensed
Properties
- searchable
- sortable
- copyChangesWhenCostIsntSynchronizedFlag (boolean)
Indicates whether to copy transactions from the corporate book even though the tax books aren't synchronized.
Label
Copy changes when cost isn't synchronized
Properties
- searchable
- sortable
- copyGroupAdditionFlag (boolean)
Indicates whether group asset additions can be copied to other books.
Label
Copy group asset additions
Properties
- searchable
- sortable
- copyGroupAssetChangesFlag (boolean)
Indicates whether group asset changes can be copied to tax books.
Label
Copy group asset changes
Properties
- searchable
- sortable
- copyLeaseAssetsFlag (boolean)
Indicates whether mass copy process can copy lease assets to the tax book.
Label
Allow Lease Assets Copy
Properties
- searchable
- sortable
- copyLeaseSchedulesFlag (boolean)
Indicates whether mass copy process can copy lease schedules while copying lease assets to the tax book.
Label
Allow Lease Schedules Copy
Properties
- searchable
- sortable
- copyMemberAssetAssignmentsFlag (boolean)
Indicates whether asset adjustments can be copied to other books.
Label
Copy member asset assignments
Properties
- searchable
- sortable
- copyRetirementsFlag (boolean)
Indicates whether asset retirements can be copied to tax books.
Label
Copy retirements
Properties
- searchable
- sortable
- not nullable
- copySalvageValueFlag (boolean)
Indicates whether the asset salvage value can be copied to tax books.
Label
Copy salvage value
Properties
- searchable
- sortable
- not nullable
- copyTransfersFlag (boolean)
Indicates whether the Mass Copy process can copy asset transfers to tax books.
Label
Copy transfers
Properties
- searchable
- sortable
- costCenterSegmentDeterminesAssetBookFlag (boolean)
Indicates whether cost center segment of Payables cost clearing account determines the asset book for invoices.
Label
Cost Center Segment Determines Asset Book
Properties
- searchable
- sortable
- not nullable
- costOfRemovalClearing (string)
Cost of removal clearing account for retirement transactions.
Label
Cost of Removal Clearing
Properties
- searchable
- sortable
- not nullable
- costOfRemovalGain (string)
Cost of removal account for retirement transactions that result in a gain.
Label
Cost of Removal Gain
Properties
- searchable
- sortable
- not nullable
- costOfRemovalLoss (string)
Cost of removal account for retirement transactions that result in a loss.
Label
Cost of Removal Loss
Properties
- searchable
- sortable
- not nullable
- createAccountingRequestId (int64)
Indicates the request ID of the last run of the Create Accounting process.
Label
Create Accounting Request ID
Properties
- searchable
- sortable
- createdBy (string)
The user who created the record.
Label
Created By
Properties
- searchable
- sortable
- not nullable
- currentFiscalYear (int32)
Current accounting fiscal year.
Label
Current Fiscal Year
Properties
- searchable
- sortable
- not nullable
- deferredDepreciationExpense (string)
Account that reflects the temporary difference in depreciation expense between the corporate book and the tax book.
Label
Deferred Depreciation Expense
Properties
- searchable
- sortable
- not nullable
- deferredDepreciationReserve (string)
Account that reflects the temporary difference in depreciation reserve between the corporate book and the tax book.
Label
Deferred Depreciation Reserve
Properties
- searchable
- sortable
- not nullable
- depreciateIfRetiredInTheFirstYearFlag (boolean)
Indicates whether to depreciate assets retired in the first year of life.
Label
Depreciate if retired in the first year
Properties
- searchable
- sortable
- not nullable
- depreciationAdjustmentAccount (string)
Adjustment to the depreciation amount for retroactive asset transactions.
Label
Depreciation Adjustment Account
Properties
- searchable
- sortable
- depreciationCalendar (string)
Name of the depreciation calendar.
Label
Depreciation Calendar
Properties
- searchable
- sortable
- not nullable
- depreciationRequestId (int64)
Indicates if asset adjustments can be copied to other books.
Label
Depreciation Request ID
Properties
- searchable
- sortable
- description (string)
Asset book description.
Label
Description
Properties
- searchable
- sortable
- not nullable
- divideDepreciation (enumeration: DepreciationAllocationCode)
Spreads annual depreciation over the depreciation periods of the fiscal year.
Label
Divide Depreciation
Type
-
Module: oraErpCoreFixedAssetsSetup
-
Enumeration Type: DepreciationAllocationCode
Properties
- searchable
- sortable
- not nullable
Valid Values
- D
- E
-
- fiscalYearName (string)
Name of the accounting fiscal year.
Label
Fiscal Year Name
Properties
- searchable
- sortable
- includeCurrentPeriodDepreciationFlag (boolean)
Allows you to include the current period depreciation amount in revaluation calculations.
Label
Include current period depreciation
Properties
- searchable
- sortable
- ineffectiveDate (date)
Date the referenced asset book was inactivated.
Label
Ineffective Date
Properties
- searchable
- sortable
- initialDate (date)
Starting date of the asset book.
Label
Initial Date
Properties
- searchable
- sortable
- not nullable
- lastAccountingRunDate (date-time)
Date on which the Create Accounting process was run.
Label
Last Accounting Run Date
Properties
- searchable
- sortable
- lastCreateMassAdditionsId (int64)
The request ID of the last run of the Create Mass Additions process.
Label
Last Create Mass Additions Request ID
Properties
- searchable
- sortable
- lastDepreciationRunDate (date-time)
Date on which depreciation was last run for the book.
Label
Last Depreciation Run Date
Properties
- searchable
- sortable
- lastDepreciationRunStatus (enumeration: DepreciationRunStatus)
Last condition of the Calculate Depreciation process.
Label
Last Depreciation Run Status
Type
-
Module: oraErpCoreFixedAssetsSetup
-
Enumeration Type: DepreciationRunStatus
Properties
- searchable
- sortable
Valid Values
- C
- E
- R
- S
-
- lastLeaseExpenseCalculationDate (date)
Date when the calculate periodic lease expense program was last run for this book.
Label
Last Lease Expense Calculation Date
Properties
- searchable
- sortable
- lastPeriodCopied (int64)
Identifier of the last corporate period for which the Mass Copy process is run for this tax book.
Label
Last Period Copied
Properties
- searchable
- sortable
- lastPostMassAdditionsRequestId (int64)
The request ID of the last run of the Post Mass Additions process.
Label
Last Post Mass Additions Request ID
Properties
- searchable
- sortable
- lifeExtensionCeiling (big-decimal)
The default life extension ceiling of the book.
Label
Life Extension Ceiling
Properties
- searchable
- sortable
- lifeExtensionFactor (big-decimal)
The default life extension factor of the book.
Label
Life Extension Factor
Properties
- searchable
- sortable
- lowValueThresholdAmount (big-decimal)
The threshold amount used to determine whether the asset needs to be added as a low value capitalized asset.
Label
Low Value Threshold Amount
Properties
- searchable
- sortable
- massRequestId (int64)
Enterprise Service Scheduler Request ID of the process for the invoice transferred to Oracle Payables.
Label
Mass Request ID
Properties
- searchable
- sortable
- maximumRevaluations (int64)
The default maximum revaluations allowed for the book.
Label
Maximum Revaluations
Properties
- searchable
- sortable
- name (string)
The name of the asset book.
Label
Book
Properties
- searchable
- sortable
- not nullable
- naturalAccountSegmentDeterminesAssetBookFlag (boolean)
Indicates whether natural account segment of Payables cost clearing account determines the asset book for invoices.
Label
Natural Account Segment Determines Asset Book
Properties
- searchable
- sortable
- not nullable
- nbvAmountThreshold (big-decimal)
The net book value threshold amount for a book.
Label
NBV Amount Threshold
Properties
- searchable
- sortable
- nbvFractionThreshold (big-decimal)
The net book value threshold fraction for a book.
Label
NBV Fraction Threshold
Properties
- searchable
- sortable
- netBookValueRetiredGain (string)
Account used to track the cost minus the accumulated depreciation when you retire an asset that results in a gain.
Label
Net Book Value Retired Gain
Properties
- searchable
- sortable
- not nullable
- netBookValueRetiredLoss (string)
Account used to track the cost minus the accumulated depreciation when you retire an asset that results in a loss.
Label
Net Book Value Retired Loss
Properties
- searchable
- sortable
- not nullable
- nonsaleGainAccount (string)
Natural account used to account the accumulated bonus depreciation reversal during asset retirement.
Label
Nonsale Gain Account
Properties
- searchable
- sortable
- payablesIntercompanyAccount (string)
Intercompany Payables account segment.
Label
Payables Intercompany Account
Properties
- searchable
- sortable
- preventPriorPeriodAmortizedAdjustmentsFlag (boolean)
Indicates if an asset book can permit amortized adjustments in the prior period.
Label
Prevent prior period amortized adjustments
Properties
- searchable
- sortable
- priceIndexValueId (int32)
Indicates the period number in which index revaluation will be performed for the book.
Label
Price Index Value ID
Properties
- searchable
- sortable
- primaryBalancingSegmentDeterminesAssetBookFlag (boolean)
Indicates whether balancing segment of Payables cost clearing account determines the asset book for invoices.
Label
Primary Balancing Segment Determines Asset Book
Properties
- searchable
- sortable
- not nullable
- proceedsOfSaleAccountForRetirementThatResultsInAGain (string)
Proceeds of sale account for a retirement that results in a gain.
Label
Proceeds of sale account for retirement that results in a gain.
Properties
- searchable
- sortable
- not nullable
- proceedsOfSaleAccountForRetirementThatResultsInALoss (string)
Proceeds of sale account for a retirement that results in a loss.
Label
Proceeds of sale account for retirement that results in a loss.
Properties
- searchable
- sortable
- not nullable
- proceedsOfSaleClearingAccountForRetirementTransactions (string)
Proceeds of sale clearing account for retirement transactions.
Label
Proceeds of sale clearing account for retirement transactions.
Properties
- searchable
- sortable
- not nullable
- receivablesIntercompanyAccount (string)
Intercompany Receivables account segment.
Label
Receivables Intercompany Account
Properties
- searchable
- sortable
- recognizeLeaseExchangeRateGainOrLossFlag (boolean)
Indicates whether gain or loss amount on lease liability for the currency exchange rate changes.
Label
Recognize lease exchange rate gain or loss
Properties
- searchable
- sortable
- retireRevaluationReserveFlag (boolean)
The option that lets you retire the revaluation reserve of assets.
Label
Retire revaluation reserve
Properties
- searchable
- sortable
- revaluationReserveRetiredGainAccount (string)
Revaluation reserve retired account for a retirement that results in a gain.
Label
Revaluation Reserve Retired Gain Account
Properties
- searchable
- sortable
- revaluationReserveRetiredLossAccount (string)
Revaluation reserve retired account for a retirement that results in a loss.
Label
Revaluation Reserve Retired Loss Account
Properties
- searchable
- sortable
- revalueDepreciationReserveFlag (boolean)
The option that lets you revalue the depreciation reserve of assets.
Label
Revalue depreciation reserve
Properties
- searchable
- sortable
- revalueFullyReservedAssetsFlag (boolean)
Allows you to revalue fully reserved assets in the book.
Label
Revalue fully reserved assets
Properties
- searchable
- sortable
- sorpEnabledFlag (boolean)
Option indicating whether the statement of recommended accounting practice feature is enabled.
Label
Statement of Recommended Accounting Practice Enabled
Properties
- searchable
- sortable
- suspendAutomaticMergeOfPayablesInvoiceLinesFlag (boolean)
The option that lets you suspend an automatic merge of Payables invoice lines.
Label
Suspend automatic merge of Payables invoice lines
Properties
- searchable
- sortable
- timeCreated (date-time)
The date and time when the record was created.
Label
Creation Date
Properties
- searchable
- sortable
- not nullable
- timeUpdated (date-time)
The date and time when the record was last updated.
Label
Last Updated Date
Properties
- searchable
- sortable
- not nullable
- updatedBy (string)
The user who last updated the record.
Label
Last Updated By
Properties
- searchable
- sortable
- not nullable
- useFirstDateAsTransactionDateFlag (boolean)
Indicates whether the Mass Copy process uses the first date of the current open period as the transaction date.
Label
Use First Date as Transaction Date
Properties
- searchable
- sortable
- useNbvThresholdForDepreciationFlag (boolean)
Indicates whether to use the net book value threshold for asset depreciation.
Label
Use NBV threshold for depreciation
Properties
- searchable
- sortable
- usePayablesInvoiceDateAsDatePlacedInServiceFlag (boolean)
Indicates whether to use the Payables invoice date as the asset placed in service date.
Label
Use Payables invoice date as date placed in service
Properties
- searchable
- sortable
- useReportingCurrencyFlag (boolean)
Indicates whether the asset book has reporting currency.
Label
Use Reporting Currency for Asset Book
Properties
- searchable
- sortable
- advancedOptionsEnabledFlag (boolean)