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 |
BOOK_TYPE_CODE |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
---|---|---|---|---|---|---|
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 | Yes | General description for the asset book. | ||
SET_OF_BOOKS_ID | NUMBER | 18 | Yes | Identifier of the accounting ledger. | ||
INITIAL_DATE | DATE | Yes | Starting date of the asset book. | |||
LAST_DEPRN_RUN_DATE | DATE | Yes | Date the last time depreciation was run for this book on the previous asset system. | |||
AMORTIZE_FLAG | VARCHAR2 | 3 | Yes | Option indicating whether amortized transactions are allowed for the book. | ||
FULLY_RESERVED_FLAG | VARCHAR2 | 3 | Yes | Not currently used. | ||
DEPRN_CALENDAR | VARCHAR2 | 15 | Yes | Name of the depreciation calendar. | ||
BOOK_CLASS | VARCHAR2 | 15 | Yes | Type of the asset book. Possible values can be Corporate or Tax. | ||
GL_POSTING_ALLOWED_FLAG | VARCHAR2 | 3 | Yes | 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 | Yes | Current fiscal year for the book. | ||
ALLOW_MASS_CHANGES | VARCHAR2 | 3 | Yes | Option indicating whether mass depreciation changes are allowed for the book. | ||
ACCOUNTING_FLEX_STRUCTURE | NUMBER | 18 | Yes | 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 | Yes | 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 | Yes | Option indicating whether retirement transactions to be copied from the corporate book. | ||
COPY_ADJUSTMENTS_FLAG | VARCHAR2 | 3 | Yes | 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 | Yes | Option indicating whether cost ceilings are allowed for the book. | ||
ALLOW_DEPRN_EXP_CEILING | VARCHAR2 | 3 | Yes | Option indicating whether expense ceilings are allowed for the book. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
CREATION_DATE | TIMESTAMP | Yes | 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 | Yes | 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 | Yes | 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. | Book Controls (FA_BOOK_CONTROLS) | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Book Controls (FA_BOOK_CONTROLS) | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Book Controls (FA_BOOK_CONTROLS) | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Book Controls (FA_BOOK_CONTROLS) | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Book Controls (FA_BOOK_CONTROLS) | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Book Controls (FA_BOOK_CONTROLS) | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Book Controls (FA_BOOK_CONTROLS) | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Book Controls (FA_BOOK_CONTROLS) | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Book Controls (FA_BOOK_CONTROLS) | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Book Controls (FA_BOOK_CONTROLS) | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Book Controls (FA_BOOK_CONTROLS) | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Book Controls (FA_BOOK_CONTROLS) | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Book Controls (FA_BOOK_CONTROLS) | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Book Controls (FA_BOOK_CONTROLS) | ||
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Book Controls (FA_BOOK_CONTROLS) | ||
ATTRIBUTE_CATEGORY_CODE | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Book Controls (FA_BOOK_CONTROLS) | ||
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 | Yes | Option indicating whether salvage value can be copied by mass copy process. | ||
COST_OF_REMOVAL_CLEARING_ACCT | VARCHAR2 | 25 | Yes | Cost of removal clearing account for retirement transactions. | ||
COST_OF_REMOVAL_GAIN_ACCT | VARCHAR2 | 25 | Yes | Cost of removal account for retirement that results in a gain. | ||
COST_OF_REMOVAL_LOSS_ACCT | VARCHAR2 | 25 | Yes | 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 | Yes | Deferred depreciation expense account. | ||
DEFERRED_DEPRN_RESERVE_ACCT | VARCHAR2 | 25 | Yes | Deferred depreciation reserve account. | ||
DEPRN_ALLOCATION_CODE | VARCHAR2 | 1 | Yes | 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 | Yes | 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 | Yes | 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 | Yes | Net book value retired account for retirement that results in a gain. | ||
NBV_RETIRED_LOSS_ACCT | VARCHAR2 | 25 | Yes | Net book value retired account for retirement that results in a loss. | ||
PROCEEDS_OF_SALE_CLEARING_ACCT | VARCHAR2 | 25 | Yes | Proceeds of sale clearing account for retirement transactions. | ||
PROCEEDS_OF_SALE_GAIN_ACCT | VARCHAR2 | 25 | Yes | Proceeds of sale account for retirement that results in a gain. | ||
PROCEEDS_OF_SALE_LOSS_ACCT | VARCHAR2 | 25 | Yes | 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 | Yes | Option indicating whether to depreciate assets retired in the first year of life. | ||
FLEXBUILDER_DEFAULTS_CCID | NUMBER | 18 | Yes | 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 | Yes | 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 | 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. | ||
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 | Yes | Indicates whether balancing segment of Payables cost clearing account determines the asset book for invoices. | ||
AP_CLEARING_CC_CHECK_FLAG | VARCHAR2 | 1 | Yes | Indicates whether cost center segment of Payables cost clearing account determines the asset book for invoices. | ||
AP_CLEARING_NA_CHECK_FLAG | VARCHAR2 | 1 | Yes | 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. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
FA_BOOK_CONTROLS | fa_calendar_types | DEPRN_CALENDAR |
FA_BOOK_CONTROLS | fa_book_controls | MASS_COPY_SOURCE_BOOK |
FA_BOOK_CONTROLS | fa_fiscal_year_types_b | FISCAL_YEAR_NAME |
FA_BOOK_CONTROLS | fa_book_controls | DISTRIBUTION_SOURCE_BOOK |
FA_BOOK_CONTROLS | fa_deprn_periods | BOOK_TYPE_CODE, LAST_PURGE_PERIOD_COUNTER |
FA_BOOK_CONTROLS | fa_deprn_periods | BOOK_TYPE_CODE, INITIAL_PERIOD_COUNTER |
FA_BOOK_CONTROLS | fa_deprn_periods | BOOK_TYPE_CODE, LAST_PERIOD_COUNTER |
FA_BOOK_CONTROLS | fa_deprn_periods | BOOK_TYPE_CODE, LAST_MASS_COPY_PERIOD_COUNTER |
FA_BOOK_CONTROLS | fa_calendar_types | PRORATE_CALENDAR |
FA_BOOK_CONTROLS | gl_code_combinations | FLEXBUILDER_DEFAULTS_CCID |
FA_BOOK_CONTROLS | fa_fiscal_year | FISCAL_YEAR_NAME, CURRENT_FISCAL_YEAR |
fa_transaction_headers | fa_book_controls | BOOK_TYPE_CODE |
fa_category_book_defaults | fa_book_controls | BOOK_TYPE_CODE |
fa_mc_deferred_deprn | fa_book_controls | CORP_BOOK_TYPE_CODE |
fa_mc_deferred_deprn | fa_book_controls | TAX_BOOK_TYPE_CODE |
fa_invoice_transactions | fa_book_controls | BOOK_TYPE_CODE |
fa_deprn_override | fa_book_controls | BOOK_TYPE_CODE |
fa_mass_retirements | fa_book_controls | BOOK_TYPE_CODE |
fa_distribution_history | fa_book_controls | BOOK_TYPE_CODE |
fa_cash_gen_units | fa_book_controls | BOOK_TYPE_CODE |
fa_deprn_detail_h | fa_book_controls | BOOK_TYPE_CODE |
fa_distribution_sets | fa_book_controls | BOOK_TYPE_CODE |
fa_mc_books | fa_book_controls | BOOK_TYPE_CODE |
fa_transfers_t | fa_book_controls | BOOK_TYPE_CODE |
fa_mc_book_controls | fa_book_controls | BOOK_TYPE_CODE |
fa_books | fa_book_controls | BOOK_TYPE_CODE |
fa_itf_impairments | fa_book_controls | BOOK_TYPE_CODE |
fa_mc_deprn_periods | fa_book_controls | BOOK_TYPE_CODE |
fa_deprn_summary_h | fa_book_controls | BOOK_TYPE_CODE |
fa_books_summary | fa_book_controls | BOOK_TYPE_CODE |
fa_deleted_mass_additions | fa_book_controls | BOOK_TYPE_CODE |
fa_book_controls | fa_book_controls | MASS_COPY_SOURCE_BOOK |
fa_book_controls | fa_book_controls | DISTRIBUTION_SOURCE_BOOK |
fa_mc_lease_schedules | fa_book_controls | BOOK_TYPE_CODE |
fa_mc_revaluations | fa_book_controls | BOOK_TYPE_CODE |
fa_adjustments | fa_book_controls | BOOK_TYPE_CODE |
fa_periodic_production | fa_book_controls | BOOK_TYPE_CODE |
fa_mc_retirements | fa_book_controls | BOOK_TYPE_CODE |
fa_trx_references | fa_book_controls | BOOK_TYPE_CODE |
fa_book_controls_history | fa_book_controls | BOOK_TYPE_CODE |
fa_deprn_summary | fa_book_controls | BOOK_TYPE_CODE |
fa_mc_books_rates | fa_book_controls | BOOK_TYPE_CODE |
fa_retirements | fa_book_controls | BOOK_TYPE_CODE |
fa_deprn_events | fa_book_controls | BOOK_TYPE_CODE |
fa_deferred_deprn_events | fa_book_controls | CORP_BOOK_TYPE_CODE |
fa_deferred_deprn_events | fa_book_controls | TAX_BOOK_TYPE_CODE |
fa_retirements_t | fa_book_controls | BOOK_TYPE_CODE |
fa_adjustments_t | fa_book_controls | BOOK_TYPE_CODE |
fa_lease_schedules | fa_book_controls | BOOK_TYPE_CODE |
fa_mc_deprn_detail | fa_book_controls | BOOK_TYPE_CODE |
fa_mc_deprn_summary_h | fa_book_controls | BOOK_TYPE_CODE |
fa_deprn_periods | fa_book_controls | BOOK_TYPE_CODE |
fa_deprn_detail | fa_book_controls | BOOK_TYPE_CODE |
fa_mass_changes | fa_book_controls | BOOK_TYPE_CODE |
fa_mc_deprn_detail_h | fa_book_controls | BOOK_TYPE_CODE |
pjc_standard_unit_costs | fa_book_controls | BOOK_TYPE_CODE |
fa_mass_additions | fa_book_controls | BOOK_TYPE_CODE |
fa_mc_adjustments | fa_book_controls | BOOK_TYPE_CODE |
fa_category_books | fa_book_controls | BOOK_TYPE_CODE |
fa_mc_conversion_rates | fa_book_controls | BOOK_TYPE_CODE |
fa_mc_conversion_history | fa_book_controls | BOOK_TYPE_CODE |
fa_impairments | fa_book_controls | BOOK_TYPE_CODE |
fa_mc_books_summary | fa_book_controls | BOOK_TYPE_CODE |
fa_deferred_deprn | fa_book_controls | CORP_BOOK_TYPE_CODE |
fa_deferred_deprn | fa_book_controls | TAX_BOOK_TYPE_CODE |
fa_mc_deprn_summary | fa_book_controls | BOOK_TYPE_CODE |
pjf_bu_impl_all | fa_book_controls | BOOK_TYPE_CODE |
fa_mass_transfers | fa_book_controls | BOOK_TYPE_CODE |
fa_mass_reclass | fa_book_controls | BOOK_TYPE_CODE |
fa_revaluations | fa_book_controls | BOOK_TYPE_CODE |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
FA_BOOK_CONTROLS_N1 | Non Unique | Default | LAST_UPDATE_DATE |
FA_BOOK_CONTROLS_U1 | Unique | Default | BOOK_TYPE_CODE |