1. Tables and Views for Financials
  2. FA_CATEGORY_BOOKS

FA_CATEGORY_BOOKS

FA_CATEGORY_BOOKS contains cost and reserve accounts for a book and category combination. A row inserted into this table for each book to which the asset category is assigned. For example, if you define a category for three depreciation books, Oracle Fusion Assets inserts three rows into this table.

Details

  • Schema: FUSION

  • Object owner: FA

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

FA_CATEGORY_BOOKS_PK

CATEGORY_BOOK_ID

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping
LEASE_RATE_GAIN_LOSS_ACCT_CCID NUMBER 18 Identifier of the account code combination for the default currency exchange rate gain or loss on lease liability.
BOOK_TYPE_CODE VARCHAR2 30 Yes Unique book identification name.
ASSET_COST_ACCOUNT_CCID NUMBER 18 Yes Identifier of the account code combination for the default cost account.
ASSET_CLEARING_ACCOUNT_CCID NUMBER 18 Identifier of the account code combination for the default cost clearing account.
WIP_COST_ACCOUNT_CCID NUMBER 18 Identifier of the account code combination for the default CIP cost account.
WIP_CLEARING_ACCOUNT_CCID NUMBER 18 Identifier of the account code combination for the default CIP clearing account.
DEPRN_EXPENSE_ACCOUNT_CCID NUMBER 18 Identifier of the account code combination for the default depreciation expense account.
RESERVE_ACCOUNT_CCID NUMBER 18 Yes Identifier of the account code combination for the default depreciation reserve account.
BONUS_EXPENSE_ACCOUNT_CCID NUMBER 18 Identifier of the account code combination for the default bonus expense account.
BONUS_RESERVE_ACCT_CCID NUMBER Identifier of the account code combination for the default bonus reserve account.
REVAL_AMORT_ACCOUNT_CCID NUMBER 18 Identifier of the account code combination for the default revaluation reserve account.
REVAL_RESERVE_ACCOUNT_CCID NUMBER 18 Identifier of the account code combination for the default revaluation reserve account.
UNPLAN_EXPENSE_ACCOUNT_CCID NUMBER 18 Identifier of the account code combination for the default unplanned depreciation expense account.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Category Books (FA_CATEGORY_BOOKS)
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Category Books (FA_CATEGORY_BOOKS)
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Category Books (FA_CATEGORY_BOOKS)
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Category Books (FA_CATEGORY_BOOKS)
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Category Books (FA_CATEGORY_BOOKS)
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Category Books (FA_CATEGORY_BOOKS)
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Category Books (FA_CATEGORY_BOOKS)
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Category Books (FA_CATEGORY_BOOKS)
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Category Books (FA_CATEGORY_BOOKS)
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Category Books (FA_CATEGORY_BOOKS)
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Category Books (FA_CATEGORY_BOOKS)
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Category Books (FA_CATEGORY_BOOKS)
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Category Books (FA_CATEGORY_BOOKS)
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Category Books (FA_CATEGORY_BOOKS)
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Category Books (FA_CATEGORY_BOOKS)
ATTRIBUTE_CATEGORY_CODE VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Category Books (FA_CATEGORY_BOOKS)
ALT_COST_ACCOUNT_CCID NUMBER 18 Identifier of the account code combination for the default alternate cost account.
WRITE_OFF_ACCOUNT_CCID NUMBER 18 Identifier of the account code combination for the default write-off account.
IMPAIR_EXPENSE_ACCOUNT_CCID NUMBER 18 Identifier of the account code combination for the default impairment expense account.
IMPAIR_RESERVE_ACCOUNT_CCID NUMBER 18 Identifier of the account code combination for the default impairment reserve account.
CAPITAL_ADJ_ACCOUNT_CCID NUMBER 18 Identifier of the account code combination for the default capital adjustment account.
GENERAL_FUND_ACCOUNT_CCID NUMBER 18 Identifier of the account code combination for the default general fund account.
CATEGORY_BOOK_ID NUMBER 18 Yes Identifier of the default accounts for the category in the book.
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE16 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE17 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE18 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE19 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE20 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 30 Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER1 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER2 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER3 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER4 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER5 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE1 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE2 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE3 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE4 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE5 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
DEFAULT_EXPENSE_CCID_FLAG VARCHAR2 1 Option indicating whether to use the expense account combination or the natural account segment for defaulting purposes during asset additions.
REVAL_LOSS_ACCOUNT_CCID NUMBER 18 Stores the revaluation loss account combination.
COST_WRITE_OFF_ACCOUNT_CCID NUMBER 18 The account code combination identifier used to account the asset cost that was not capitalized.
LEASE_LIABILITY_ACCOUNT_CCID NUMBER 18 Identifier of the account code combination for the default lease liability.
LEASE_INT_EXPENSE_ACCOUNT_CCID NUMBER 18 Identifier of the account code combination for the default lease interest expense account.
LEASE_EXPENSE_ACCOUNT_CCID NUMBER 18 Identifier of the account code combination for the default lease expense account.
LEASE_GAIN_LOSS_ACCOUNT_CCID NUMBER 18 Identifier of the account code combination for the default gain or loss on leased asset account.
LEASE_CLEARING_ACCOUNT_CCID NUMBER 18 Identifier of the account code combination for the default lease clearing account.
REVALUED_COST_ACCOUNT_CCID NUMBER 18 Default account used to record the revalued asset cost.
BACKLOG_DEPRN_RSV_ACCT_CCID NUMBER 18 Default account used to record the revaluation of the prior year accumulated depreciation.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
CATEGORY_ID NUMBER 18 Yes Identifier of the asset category.
ANNUITY_INT_EXP_ACCOUNT_CCID NUMBER 18 Account code combination identifier for the default annuity interest expense account.
ANNUITY_INT_REV_ACCOUNT_CCID NUMBER 18 Account code combination identifier for the default annuity interest revenue account.
SUPPRESS_MASSADD_AUTOPOST_FLAG VARCHAR2 1 Indicates whether to suppress the automatic setting of lines to the Post queue for this specific category when enabled for the associated book.

Foreign Keys

Table Foreign Table Foreign Key Column
FA_CATEGORY_BOOKS fa_categories_b CATEGORY_ID
FA_CATEGORY_BOOKS gl_code_combinations UNPLAN_EXPENSE_ACCOUNT_CCID
FA_CATEGORY_BOOKS gl_code_combinations DEPRN_EXPENSE_ACCOUNT_CCID
FA_CATEGORY_BOOKS gl_code_combinations BONUS_EXPENSE_ACCOUNT_CCID
FA_CATEGORY_BOOKS gl_code_combinations BONUS_RESERVE_ACCT_CCID
FA_CATEGORY_BOOKS gl_code_combinations REVAL_LOSS_ACCOUNT_CCID
FA_CATEGORY_BOOKS fa_book_controls BOOK_TYPE_CODE
FA_CATEGORY_BOOKS gl_code_combinations ASSET_COST_ACCOUNT_CCID
FA_CATEGORY_BOOKS gl_code_combinations ASSET_CLEARING_ACCOUNT_CCID
FA_CATEGORY_BOOKS gl_code_combinations RESERVE_ACCOUNT_CCID
FA_CATEGORY_BOOKS gl_code_combinations REVAL_RESERVE_ACCOUNT_CCID
FA_CATEGORY_BOOKS gl_code_combinations REVAL_AMORT_ACCOUNT_CCID
FA_CATEGORY_BOOKS gl_code_combinations WIP_CLEARING_ACCOUNT_CCID
FA_CATEGORY_BOOKS gl_code_combinations WIP_COST_ACCOUNT_CCID
fa_category_book_defaults fa_category_books CATEGORY_ID, BOOK_TYPE_CODE
fa_mass_retirements fa_category_books CATEGORY_ID, BOOK_TYPE_CODE
fa_itf_impairments fa_category_books CATEGORY_ID, BOOK_TYPE_CODE
fa_adjustments_t fa_category_books CATEGORY_ID, BOOK_TYPE_CODE
fa_mass_changes fa_category_books CATEGORY_ID, BOOK_TYPE_CODE
fa_mass_additions fa_category_books ASSET_CATEGORY_ID, BOOK_TYPE_CODE
fa_mass_transfers fa_category_books CATEGORY_ID, BOOK_TYPE_CODE
fa_mass_reclass fa_category_books FROM_CATEGORY_ID, BOOK_TYPE_CODE
fa_mass_reclass fa_category_books TO_CATEGORY_ID, BOOK_TYPE_CODE

Indexes

Index Uniqueness Tablespace Columns
FA_CATEGORY_BOOKS_U1 Unique Default CATEGORY_BOOK_ID
FA_CATEGORY_BOOKS_U2 Unique Default CATEGORY_ID, BOOK_TYPE_CODE