Category Books
The Category Books view object contains cost and reserve accounts for a book and category combination. A row is inserted into this table for each book the asset category is assigned to.
Data Store Key : FscmTopModelAM.FinExtractAM.FaBiccExtractAM.CategoryBookExtractPVO
Primary Keys : CategoryBookCategoryBookId
Initial Extract Date : CategoryBookCreationDate
Incremental Extract Date : CategoryBookLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| CategoryBookAltCostAccountCcid | The account code combination identifier for the default alternate cost account. |
| CategoryBookAssetClearingAccountCcid | The account code combination identifier for the asset clearing account. |
| CategoryBookAssetCostAccountCcid | The account code combination for the default cost account. |
| CategoryBookAttribute1 | A segment for the Category Books descriptive flexfield. |
| CategoryBookAttribute10 | A segment for the Category Books descriptive flexfield. |
| CategoryBookAttribute11 | A segment for the Category Books descriptive flexfield. |
| CategoryBookAttribute12 | A segment for the Category Books descriptive flexfield. |
| CategoryBookAttribute13 | A segment for the Category Books descriptive flexfield. |
| CategoryBookAttribute14 | A segment for the Category Books descriptive flexfield. |
| CategoryBookAttribute15 | A segment for the Category Books descriptive flexfield. |
| CategoryBookAttribute2 | A segment for the Category Books descriptive flexfield. |
| CategoryBookAttribute3 | A segment for the Category Books descriptive flexfield. |
| CategoryBookAttribute4 | A segment for the Category Books descriptive flexfield. |
| CategoryBookAttribute5 | A segment for the Category Books descriptive flexfield. |
| CategoryBookAttribute6 | A segment for the Category Books descriptive flexfield. |
| CategoryBookAttribute7 | A segment for the Category Books descriptive flexfield. |
| CategoryBookAttribute8 | A segment for the Category Books descriptive flexfield. |
| CategoryBookAttribute9 | A segment for the Category Books descriptive flexfield. |
| CategoryBookAttributeCategoryCode | The context name for the Category Books descriptive flexfield. |
| CategoryBookBonusExpenseAccountCcid | The account code combination identifier for the default bonus expense account. |
| CategoryBookBonusReserveAcctCcid | The account code combination identifier for the default bonus reserve account. |
| CategoryBookBookTypeCode | Unique book identification name. |
| CategoryBookCapitalAdjAccountCcid | The account code combination identifier for the default capital adjustment account. |
| CategoryBookCategoryBookId | The identifier of the default accounts for the category in the book. |
| CategoryBookCategoryId | The identifier of the asset category. |
| CategoryBookCostWriteOffAccountCcid | The account code combination identifier used to account for the asset cost that was not capitalized. |
| CategoryBookCreatedBy | The user who created the row in the FA_CATEGORY_BOOKS table. |
| CategoryBookCreationDate | The date the row was created in the FA_CATEGORY_BOOKS table. |
| CategoryBookDefaultExpenseCcidFlag | Indicates whether to use the expense account combination or the natural account segment as the default when adding assets. |
| CategoryBookDeprnExpenseAccountCcid | The account that is debited by a depreciation entry to expense the portion of the asset that was depreciated in the current time period. |
| CategoryBookGeneralFundAccountCcid | Identifier of the account code combination for the default general fund account. |
| CategoryBookGlobalAttribute1 | A segment for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookGlobalAttribute10 | A segment for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookGlobalAttribute11 | A segment for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookGlobalAttribute12 | A segment for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookGlobalAttribute13 | A segment for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookGlobalAttribute14 | A segment for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookGlobalAttribute15 | A segment for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookGlobalAttribute16 | A segment for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookGlobalAttribute17 | A segment for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookGlobalAttribute18 | A segment for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookGlobalAttribute19 | A segment for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookGlobalAttribute2 | A segment for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookGlobalAttribute20 | A segment for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookGlobalAttribute3 | A segment for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookGlobalAttribute4 | A segment for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookGlobalAttribute5 | A segment for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookGlobalAttribute6 | A segment for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookGlobalAttribute7 | A segment for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookGlobalAttribute8 | A segment for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookGlobalAttribute9 | A segment for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookGlobalAttributeCategory | The context name for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookGlobalAttributeDate1 | A date segment for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookGlobalAttributeDate2 | A date segment for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookGlobalAttributeDate3 | A date segment for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookGlobalAttributeDate4 | A date segment for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookGlobalAttributeDate5 | A date segment for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookGlobalAttributeNumber1 | A number segment for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookGlobalAttributeNumber2 | A number segment for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookGlobalAttributeNumber3 | A number segment for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookGlobalAttributeNumber4 | A number segment for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookGlobalAttributeNumber5 | A number segment for the Category Books Regional Information global descriptive flexfield. |
| CategoryBookImpairExpenseAccountCcid | Identifier of the account code combination for the default impairment expense account. |
| CategoryBookImpairReserveAccountCcid | Identifier of the account code combination for the default impairment reserve account. |
| CategoryBookLastUpdateDate | The date and time of the last update of the row in the FA_CATEGORY_BOOKS table.. |
| CategoryBookLastUpdateLogin | The session login associated with the user who last updated the row in the FA_CATEGORY_BOOKS table. |
| CategoryBookLastUpdatedBy | The user who last updated the row in the FA_CATEGORY_BOOKS table. |
| CategoryBookLeaseClearingAccountCcid | Account used to book the lease clearing account. |
| CategoryBookLeaseExpenseAccountCcid | Account used to book the asset lease expense account. |
| CategoryBookLeaseGainLossAccountCcid | The account code combination identifier for the default gain or loss on the leased asset account. |
| CategoryBookLeaseIntExpenseAccountCcid | The account code combination identifier used to account for the lease interest expense. |
| CategoryBookLeaseLiabilityAccountCcid | The account code combination identifier used to account for the conversion rate gain or loss on lease liability. |
| CategoryBookObjectVersionNumber | The number of times the Category Books row has been updated. |
| CategoryBookReserveAccountCcid | Account code combination identifier used to book the depreciation reserve account. |
| CategoryBookRevalAmortAccountCcid | Account code combination identifier used to book the periodic amortization of the revaluation reserve. |
| CategoryBookRevalLossAccountCcid | Account code combination identifier used to book the asset revaluation loss. |
| CategoryBookRevalReserveAccountCcid | Account code combination identifier used to book the asset revaluation reserve. |
| CategoryBookUnplanExpenseAccountCcid | The account that is debited by an unplanned depreciation entry to expense the portion of the asset that was depreciated in the current time period. |
| CategoryBookWipClearingAccountCcid | Clearing account used in transactions that include construction-in-process assets. |
| CategoryBookWipCostAccountCcid | Account code combination identifier used to reflect the cost of a construction-in-process asset. |
| CategoryBookWriteOffAccountCcid | Account code combination identifier used to book the write-off account. |