FA_BOOK_CONTROLS_
FA_BOOK_CONTROLS contains all information about the asset depreciation book.
Details
-
Schema: FUSION
-
Object owner: FA
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
FA_BOOK_CONTROLS_PK_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, BOOK_TYPE_CODE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LEASE_CURR_RATE_GAIN_LOSS_FLAG | VARCHAR2 | 1 | Indicates whether to calculate gain or loss on lease liability for currency exchange rate changes. | ||
| BOOK_TYPE_CODE | VARCHAR2 | 30 | Yes | Unique book identification name. | |
| BOOK_TYPE_NAME | VARCHAR2 | 30 | General description for the asset book. | ||
| SET_OF_BOOKS_ID | NUMBER | 18 | Identifier of the accounting ledger. | ||
| INITIAL_DATE | DATE | Starting date of the asset book. | |||
| LAST_DEPRN_RUN_DATE | DATE | Date the last time depreciation was run for this book on the previous asset system. | |||
| AMORTIZE_FLAG | VARCHAR2 | 3 | Option indicating whether amortized transactions are allowed for the book. | ||
| FULLY_RESERVED_FLAG | VARCHAR2 | 3 | Not currently used. | ||
| DEPRN_CALENDAR | VARCHAR2 | 15 | Name of the depreciation calendar. | ||
| BOOK_CLASS | VARCHAR2 | 15 | Type of the asset book. Possible values can be Corporate or Tax. | ||
| GL_POSTING_ALLOWED_FLAG | VARCHAR2 | 3 | Option indicating whether the accounting entries can be posted to Oracle Fusion General Ledger. | ||
| FISCAL_YEAR_NAME | VARCHAR2 | 30 | Fiscal year in which the current period of the book falls. | ||
| CURRENT_FISCAL_YEAR | NUMBER | 4 | Current fiscal year for the book. | ||
| ALLOW_MASS_CHANGES | VARCHAR2 | 3 | Option indicating whether mass depreciation changes are allowed for the book. | ||
| ACCOUNTING_FLEX_STRUCTURE | NUMBER | 18 | Identifier of the accounting flexfield structure. | ||
| 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. | |
| PRORATE_CALENDAR | VARCHAR2 | 15 | Name of the prorate convention calendar. | ||
| DATE_INEFFECTIVE | DATE | Date when the row became inactive. | |||
| DISTRIBUTION_SOURCE_BOOK | VARCHAR2 | 30 | Identifier of the asset book which contains the asset distribution information. | ||
| COPY_RETIREMENTS_FLAG | VARCHAR2 | 3 | Option indicating whether retirement transactions to be copied from the corporate book. | ||
| COPY_ADJUSTMENTS_FLAG | VARCHAR2 | 3 | Option indicating whether adjustment transactions to be copied from the corporate book. | ||
| DEPRN_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the Depreciation job that last updated the row. | ||
| ALLOW_COST_CEILING | VARCHAR2 | 3 | Option indicating whether cost ceilings are allowed for the book. | ||
| ALLOW_DEPRN_EXP_CEILING | VARCHAR2 | 3 | Option indicating whether expense ceilings are allowed for the book. | ||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ALLOW_MASS_COPY | VARCHAR2 | 3 | Option indicating whether mass copy for the tax book is allowed. | ||
| ALLOW_PURGE_FLAG | VARCHAR2 | 3 | Option indicating whether purge is allowed. | ||
| ALLOW_REVAL_FLAG | VARCHAR2 | 3 | Option indicating whether revaluation is allowed. | ||
| AMORTIZE_REVAL_RESERVE_FLAG | VARCHAR2 | 3 | Option indicating whether revaluation reserve amortization is allowed. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CATEGORY_CODE | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| CAPITAL_GAIN_THRESHOLD | NUMBER | Minimum time to hold an asset for Oracle Fusion Assets to report it as a capital gain on the form 4797 reports when you retire it. | |||
| COPY_SALVAGE_VALUE_FLAG | VARCHAR2 | 3 | Option indicating whether salvage value can be copied by mass copy process. | ||
| COST_OF_REMOVAL_CLEARING_ACCT | VARCHAR2 | 25 | Cost of removal clearing account for retirement transactions. | ||
| COST_OF_REMOVAL_GAIN_ACCT | VARCHAR2 | 25 | Cost of removal account for retirement that results in a gain. | ||
| COST_OF_REMOVAL_LOSS_ACCT | VARCHAR2 | 25 | Cost of removal account for retirement that results in a loss. | ||
| DEFAULT_LIFE_EXTENSION_CEILING | NUMBER | Default maximum factor by which the life can be multiplied when backing out depreciation during revaluation. Does not affect the actual asset life. | |||
| DEFAULT_LIFE_EXTENSION_FACTOR | NUMBER | Default factor by which to extend the life when revaluing a fully reserved asset. | |||
| DEFAULT_MAX_FULLY_RSVD_REVALS | NUMBER | 18 | Default maximum number of times an asset can be revalued as fully reserved. | ||
| DEFAULT_REVAL_FULLY_RSVD_FLAG | VARCHAR2 | 3 | Option indicating whether fully reserved assets in this book are revalued or not. This value will be defaulted to the revaluation transactions performed in this book. | ||
| DEFERRED_DEPRN_EXPENSE_ACCT | VARCHAR2 | 25 | Deferred depreciation expense account. | ||
| DEFERRED_DEPRN_RESERVE_ACCT | VARCHAR2 | 25 | Deferred depreciation reserve account. | ||
| DEPRN_ALLOCATION_CODE | VARCHAR2 | 1 | Method of allocating annual depreciation expense to each period evenly (E) or by the number of days in that period (D). | ||
| DEPRN_STATUS | VARCHAR2 | 1 | Depreciation program status. Possible values are C for completed, E for error, R for running, and S for submitted. | ||
| INITIAL_PERIOD_COUNTER | NUMBER | 18 | Identifier of the calendar period before the period book is created. | ||
| LAST_MASS_COPY_PERIOD_COUNTER | NUMBER | 18 | Identifier of the last corporate period for which mass copy is run for this tax book. | ||
| LAST_PERIOD_COUNTER | NUMBER | 18 | Identifier of the last period for which depreciation process is run. | ||
| LAST_PURGE_PERIOD_COUNTER | NUMBER | 18 | Identifier of the last period for which purge process is run. | ||
| MASS_COPY_SOURCE_BOOK | VARCHAR2 | 30 | Associated corporate book from which transactions are to be copied. | ||
| MASS_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the mass transaction job that is running for the row. | ||
| NBV_AMOUNT_THRESHOLD | NUMBER | Depreciation rounding threshold amount based on currency and precision. | |||
| NBV_FRACTION_THRESHOLD | NUMBER | Depreciation rounding threshold fraction based on currency and precision. | |||
| NBV_RETIRED_GAIN_ACCT | VARCHAR2 | 25 | Net book value retired account for retirement that results in a gain. | ||
| NBV_RETIRED_LOSS_ACCT | VARCHAR2 | 25 | Net book value retired account for retirement that results in a loss. | ||
| PROCEEDS_OF_SALE_CLEARING_ACCT | VARCHAR2 | 25 | Proceeds of sale clearing account for retirement transactions. | ||
| PROCEEDS_OF_SALE_GAIN_ACCT | VARCHAR2 | 25 | Proceeds of sale account for retirement that results in a gain. | ||
| PROCEEDS_OF_SALE_LOSS_ACCT | VARCHAR2 | 25 | Proceeds of sale account for retirement that results in a loss. | ||
| REVAL_DEPRN_RESERVE_FLAG | VARCHAR2 | 3 | Option indicating whether depreciation reserve can be revalued. | ||
| REVAL_RSV_RETIRED_GAIN_ACCT | VARCHAR2 | 25 | Revaluation reserve retired account for retirement that results in a gain. | ||
| REVAL_RSV_RETIRED_LOSS_ACCT | VARCHAR2 | 25 | Revaluation reserve retired account for retirement that results in a loss. | ||
| IMMEDIATE_COPY_FLAG | VARCHAR2 | 3 | Not currently used. | ||
| DEPR_FIRST_YEAR_RET_FLAG | VARCHAR2 | 3 | Option indicating whether to depreciate assets retired in the first year of life. | ||
| FLEXBUILDER_DEFAULTS_CCID | NUMBER | 18 | Identifier of the account code combination used as default value for the accounting segments. | ||
| RETIRE_REVAL_RESERVE_FLAG | VARCHAR2 | 3 | Option indicating whether revaluation reserve can be retired. | ||
| COPY_ADDITIONS_FLAG | VARCHAR2 | 3 | Option indicating whether the mass copy process can copy the asset additions to tax book or not. | ||
| USE_PERCENT_SALVAGE_VALUE_FLAG | VARCHAR2 | 3 | Not currently used. | ||
| MC_SOURCE_FLAG | VARCHAR2 | 1 | Option indicating whether the book has reporting currency. | ||
| REVAL_YTD_DEPRN_FLAG | VARCHAR2 | 3 | Not currently used. | ||
| ALLOW_CIP_ASSETS_FLAG | VARCHAR2 | 3 | Option indicating whether copying construction-in-process assets from corporate book to tax book is allowed. | ||
| ALLOW_GROUP_DEPRN_FLAG | VARCHAR2 | 1 | Option indicating whether group assets depreciation is allowed. | ||
| ALLOW_CIP_DEP_GROUP_FLAG | VARCHAR2 | 1 | Option indicating whether construction-in-process assets cost can depreciate as part of a group asset. | ||
| ALLOW_INTERCO_GROUP_FLAG | VARCHAR2 | 1 | Option indicating whether intercompany transactions are allowed on group or member assets. | ||
| COPY_GROUP_ASSIGNMENT_FLAG | VARCHAR2 | 1 | Option indicating whether mass copy process can copy the group asset association of an asset. | ||
| COPY_GROUP_ADDITION_FLAG | VARCHAR2 | 1 | Option indicating whether mass copy process can copy group asset additions. | ||
| ALLOW_CIP_MEMBER_FLAG | VARCHAR2 | 1 | Option indicating whether group assets will be automatically defaulted for construction-in-process additions. | ||
| ALLOW_MEMBER_TRACKING_FLAG | VARCHAR2 | 1 | Option indicating whether member asset tracking is allowed. | ||
| ALLOW_BACKDATED_TRANSFERS_FLAG | VARCHAR2 | 1 | Option indicating whether backdated transfers are allowed in tax book. | ||
| ALLOW_COST_SIGN_CHANGE_FLAG | VARCHAR2 | 1 | Option indicating whether adjustments that change the cost of an asset from positive to negative or negative to positive is allowed. | ||
| CREATE_ACCOUNTING_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the Create Accounting job that is running for the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | 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. | ||
| ALLOW_BONUS_DEPRN_FLAG | VARCHAR2 | 1 | Option indicating whether bonus depreciation is allowed. | ||
| ALLOW_IMPAIRMENT_FLAG | VARCHAR2 | 1 | Option indicating whether asset impairment is allowed. | ||
| ITC_ALLOWED_FLAG | VARCHAR2 | 3 | Flag indicates whether investment tax credit is allowed or not. | ||
| SORP_ENABLED_FLAG | VARCHAR2 | 1 | Option indicating whether statement of recommended accounting practice feature is enabled. | ||
| ALLOW_DEPRN_ADJUSTMENTS | VARCHAR2 | 3 | Option indicating whether depreciation adjustments are allowed for the book. | ||
| DEPRN_ADJUSTMENT_ACCT | VARCHAR2 | 25 | Depreciation adjustment account used to account depreciation adjustment transaction. | ||
| ROUND_ANNUAL_DEPRECIATION | VARCHAR2 | 30 | Annual depreciation rounding option. | ||
| COPY_ALL_COST_ADJUSTMENTS_FLAG | VARCHAR2 | 1 | Option indicating whether mass copy process can copy all adjustments. | ||
| DEFAULT_DPIS_TO_INV_DATE_FLAG | VARCHAR2 | 1 | Option indicating whether Payables invoice date can be defaulted to data placed in service or not. | ||
| USE_NBV_THRESHOLD_FLAG | VARCHAR2 | 1 | Option indicating whether net book value threshold is enabled. | ||
| COPY_AMORT_ADAJ_EXP_FLAG | VARCHAR2 | 1 | Option indicating whether mass copy process can copy amortized adjustment as expensed adjustment. | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | ||
| 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_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. | |||
| LAST_CREATE_MASS_ADDITIONS_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the Create Mass Additions job that last updated the row. | ||
| LAST_POST_MASS_ADDITIONS_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the Post Mass Additions job that last updated the row. | ||
| COPY_GROUP_CHANGE_FLAG | VARCHAR2 | 1 | Option indicating whether mass copy process can copy group asset assignment changes. | ||
| PREVENT_PRIOR_PERIOD_TXNS_FLAG | VARCHAR2 | 1 | Option indicating whether amortized transactions backdated to previous periods should be prevented. | ||
| ALLOW_DEPRN_OVERRIDE_FLAG | VARCHAR2 | 1 | Option indicating whether depreciation override is allowed. | ||
| ALLOW_FUND_ACCOUNTING_FLAG | VARCHAR2 | 1 | Enables fund accounting in the book. | ||
| ALLOW_COST_BASED_REVAL_FLAG | VARCHAR2 | 1 | Allows cost-based revaluation on an asset in the book. | ||
| ALLOW_NBV_BASED_REVAL_FLAG | VARCHAR2 | 1 | Allows NBV-based revaluation on an asset in the book. | ||
| DEFAULT_PERIOD_END_REVAL_FLAG | VARCHAR2 | 1 | Includes current period depreciation in revaluation calculations. | ||
| ALLOW_UNALLOCATED_LINES_FLAG | VARCHAR2 | 1 | Indicates whether unallocated line types from Payables will be imported during the Create Mass Additions process. | ||
| SUPPRESS_INV_AUTO_MERGE_FLAG | VARCHAR2 | 1 | Indicates whether to suppress the default behavior of automatically merging Payables source lines. | ||
| ALLOW_DIRECT_TAX_ADDITION_FLAG | VARCHAR2 | 1 | Indicates whether direct asset addition is allowed for the tax book. | ||
| ALLOW_TAX_DISTRIBUTIONS_FLAG | VARCHAR2 | 1 | Indicates whether the tax book has its own asset distribution or uses the distribution of the associated corporate book. | ||
| BOOK_TYPE_MIGRATION_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| COPY_TRANSFERS_FLAG | VARCHAR2 | 1 | Indicates whether the Mass Copy process can copy the asset transfers to the tax book. | ||
| REQUIRE_LOCATION_FLAG | VARCHAR2 | 1 | Indicates whether location tracking is mandatory for the assets in the book. | ||
| TRACK_SOURCE_LINES_IN_TAX_FLAG | VARCHAR2 | 1 | Indicates whether source lines are allowed for the assets in the tax book. | ||
| CAP_THRESHOLD_TYPE | VARCHAR2 | 30 | Capitalization threshold type for the asset book. It can be either Cost, Unit, or none. | ||
| CAP_THRESHOLD_AMOUNT | NUMBER | The threshold amount used to determine whether to capitalize or expense an asset source line. | |||
| LOW_VALUE_THRESHOLD_AMOUNT | NUMBER | The threshold amount used to determine whether the asset needs to added as a low value capitalized asset. | |||
| ALLOW_TRANS_CONVENTION_FLAG | VARCHAR2 | 1 | Indicates whether the prorate convention is allowed for adjustment and transfer transactions. | ||
| ADVANCED_OPTIONS_ENABLED_FLAG | VARCHAR2 | 1 | Indicates whether advanced features are allowed for this book. | ||
| ALLOW_PHYSICAL_INVENTORY_FLAG | VARCHAR2 | 1 | Indicates whether physical inventory is allowed for the book. | ||
| ALLOW_LEASES_FLAG | VARCHAR2 | 1 | Indicates whether leased assets are allowed for the asset book. | ||
| LEASE_EXPENSE_RUN_FLAG | VARCHAR2 | 1 | Indicates whether periodic lease interest and expense have been generated for the current open period. | ||
| COPY_LEASE_ASSETS_FLAG | VARCHAR2 | 1 | Indicates whether mass copy process can copy lease assets to the tax book. | ||
| COPY_LEASE_SCHEDULES_FLAG | VARCHAR2 | 1 | Indicates whether mass copy process can copy lease schedules while copying lease assets to the tax book. | ||
| LAST_LEASE_EXPENSE_RUN_DATE | DATE | Date the last time calculate periodic lease expense program was run for this book. | |||
| LEASE_MIGRATION_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| CREATE_ACCOUNTING_RUN_DATE | TIMESTAMP | Last run date of create accounting for the book. | |||
| LAST_DEPRECIATION_RUN_DATE | TIMESTAMP | Last run date of depreciation for the book. | |||
| NON_SALE_GAIN_ACCT | VARCHAR2 | 25 | Natural account used to account the accumulated bonus depreciation reversal during asset retirement. | ||
| USE_FIRST_DATE_AS_TRX_DATE | VARCHAR2 | 1 | Option indicating that the Mass Copy process uses the first date of the current open period as the transaction date. | ||
| ALLOW_UK_GOVERNMENT_REVAL_FLAG | VARCHAR2 | 1 | Specifies whether UK government revaluation is enabled for the book. | ||
| INDEX_REVAL_PERIOD_NUM | NUMBER | 3 | Specifies the period number in which index revaluation will be performed for the book. | ||
| 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. | |||
| ADDITIONS_APPROVAL_FLAG | VARCHAR2 | 1 | Indicates whether approval for an addition transaction is allowed for the asset book. | ||
| ADJUSTMENTS_APPROVAL_FLAG | VARCHAR2 | 1 | Indicates whether approval for an adjustment transaction is allowed for the asset book. | ||
| TRANSFERS_APPROVAL_FLAG | VARCHAR2 | 1 | Indicates whether approval for a transfer transaction is allowed for the asset book. | ||
| RETIREMENTS_APPROVAL_FLAG | VARCHAR2 | 1 | Indicates whether approval for a retirement transaction is allowed for the asset book. | ||
| AP_CLEARING_BSV_CHECK_FLAG | VARCHAR2 | 1 | Indicates whether balancing segment of Payables cost clearing account determines the asset book for invoices. | ||
| AP_CLEARING_CC_CHECK_FLAG | VARCHAR2 | 1 | Indicates whether cost center segment of Payables cost clearing account determines the asset book for invoices. | ||
| AP_CLEARING_NA_CHECK_FLAG | VARCHAR2 | 1 | Indicates whether natural account segment of Payables cost clearing account determines the asset book for invoices. | ||
| ALLOW_BOOK_TRANSFER_FLAG | VARCHAR2 | 1 | Indicates whether the book allows asset transfer to another book. | ||
| AP_INTERCOMPANY_ACCT | VARCHAR2 | 25 | Intercompany Payables account segment. | ||
| AR_INTERCOMPANY_ACCT | VARCHAR2 | 25 | Intercompany Receivables account segment. | ||
| CAP_THRESHOLD_CURRENCY_CODE | VARCHAR2 | 15 | Currency in which the capitalization threshold is maintained, which may be different than the functional currency of the ledger. | ||
| CAP_THRESHOLD_RATE_TYPE | VARCHAR2 | 30 | Rate type used to convert the capitalization threshold to the functional currency of the associated ledger. | ||
| BOOK_CONTROL_ID | NUMBER | 18 | Identifier of the asset book associated to the row. | ||
| ALLOW_ANNUITY_DEPRN_FLAG | VARCHAR2 | 1 | Indicates whether the book allows annuity depreciation calculation. | ||
| AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
| AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | ||
| AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Original Impersonator User. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FA_BOOK_CONTROLS_N1_ | Non Unique | Default | BOOK_TYPE_CODE |
| FA_BOOK_CONTROLS_U1_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, BOOK_TYPE_CODE |