Oracle Fusion · Data dictionary
FA_BOOK_CONTROLS
Fixed AssetsUsed in 13 subject areas29 reporting columns
Fixed Assets (FA).
Primary key: BOOK_TYPE_CODE
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ALLOW_CIP_ASSETS_FLAG | ● | Indicator (Y/N) for the allow cip assets. | |
| ALLOW_MASS_CHANGES | ● | Allow mass changes. | |
| AMORTIZE_FLAG | ● | Indicator (Y/N) for the amortize. | |
| BOOK_CLASS | ● | Book class. | |
| BOOK_TYPE_CODE | PK | ● | Code identifying the book type. |
| BOOK_TYPE_NAME | ● | Name of the book type. | |
| COST_OF_REMOVAL_CLEARING_ACCT | ● | Cost of removal clearing account. | |
| COST_OF_REMOVAL_GAIN_ACCT | ● | Cost of removal gain account. | |
| COST_OF_REMOVAL_LOSS_ACCT | ● | Cost of removal loss account. | |
| CURRENT_FISCAL_YEAR | ● | Current fiscal year. | |
| DATE_INEFFECTIVE | ● | Date ineffective. | |
| DEFERRED_DEPRN_EXPENSE_ACCT | ● | Deferred deprn expense account. | |
| DEFERRED_DEPRN_RESERVE_ACCT | ● | Deferred deprn reserve account. | |
| DEPRN_ADJUSTMENT_ACCT | ● | Deprn adjustment account. | |
| DEPRN_ALLOCATION_CODE | ● | Code identifying the deprn allocation. | |
| DEPRN_CALENDAR | ● | Deprn calendar. | |
| DEPRN_STATUS | ● | Status of the deprn. | |
| DISTRIBUTION_SOURCE_BOOK | ● | Distribution source book. | |
| FISCAL_YEAR_NAME | ● | Name of the fiscal year. | |
| GL_POSTING_ALLOWED_FLAG | ● | Indicator (Y/N) for the general ledger posting allowed. | |
| LAST_DEPRN_RUN_DATE | ● | Last deprn run date. | |
| LAST_PERIOD_COUNTER | ● | Last period counter. | |
| NBV_AMOUNT_THRESHOLD | ● | Nbv amount threshold. | |
| NBV_FRACTION_THRESHOLD | ● | Nbv fraction threshold. | |
| NBV_RETIRED_GAIN_ACCT | ● | Nbv retired gain account. | |
| NBV_RETIRED_LOSS_ACCT | ● | Nbv retired loss account. | |
| PROCEEDS_OF_SALE_CLEARING_ACCT | ● | Proceeds of sale clearing account. | |
| PROCEEDS_OF_SALE_GAIN_ACCT | ● | Proceeds of sale gain account. | |
| PROCEEDS_OF_SALE_LOSS_ACCT | ● | Proceeds of sale loss account. |
6 reports read from this table
Change a column here and these are the reports that move with it, the blast radius for any change to FA_BOOK_CONTROLS.
- Asset Book Controls Report
- Asset Accounting and Location Report
- Asset Addition and Cost Adjustment Report
- Asset Audit History Detail Report
- Asset Category Exceptions Report
- FA to GL Reconciliation Report
Where this surfaces in OTBI
The OTBI subject areas that expose this table. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.
- Costing - Fiscal Document Capture Transactions Real Time
- Fixed Assets - Asset Assignments Real Time
- Fixed Assets - Asset Balances Real Time
- Fixed Assets - Asset Depreciation Real Time
- Fixed Assets - Asset Financial Information Real Time
- Fixed Assets - Asset Retirements and Reinstatements Real Time
- Fixed Assets - Asset Transactions Real Time
- Fixed Assets - Asset Transfer Real Time
- Payables Invoices - Holds Real Time
- Payables Invoices - Prepayment Applications Real Time
- Payables Invoices - Transactions Real Time
- Procurement - Spend Real Time
- Subledger Accounting - Journals Real Time
Need the extract + dbt staging for FA_BOOK_CONTROLS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table