[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FA_BOOK_CONTROLS_HISTORY |
|---|---|
| Object Type: | TABLE |
| Owner: | FA |
| FND Design Data: |  OFA.FA_BOOK_CONTROLS_HISTORY
|
| Subobject Name: | |
| Status: | VALID |
FA_BOOK_CONTROLS_HISTORY stores information about modifications made to book setup information in the Book Controls form. The table creates an audit history for these changes.
Oracle Assets inserts rows in this table each time you update book level information in the Book Controls form. The existing record for that book is terminated, so that the DATE_INACTIVE of the old record and the DATE_ACTIVE for the new record are the same. This means that you can easily identify rows that are affected by the same update.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| FA_BOOK_CONTROLS_HISTORY_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 BOOK_TYPE_CODE
DATE_ACTIVE
|
| BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | Book name |
| DATE_ACTIVE | DATE | Yes | Date row was entered | |
| DATE_INACTIVE | DATE | Date that book setup information is no longer active | ||
| BOOK_TYPE_NAME | VARCHAR2 | (30) | Yes | Description of the book |
| SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Set of books identification number for GL set of books |
| AMORTIZE_FLAG | VARCHAR2 | (3) | Yes | Indicates whether or not to allow amortized changes |
| GL_POSTING_ALLOWED_FLAG | VARCHAR2 | (3) | Yes | Indicates whether or not to allow posting to GL |
| ALLOW_MASS_CHANGES | VARCHAR2 | (3) | Yes | Indicates whether or not to allow mass changes |
| ALLOW_DEPRN_ADJUSTMENTS | VARCHAR2 | (3) | Yes | Indicates whether or not to allow depreciation reserve adjustments in tax books |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| DATE_INEFFECTIVE | DATE | Date that the book is no longer active | ||
| JE_RETIREMENT_CATEGORY | VARCHAR2 | (30) | Journal category for retirements | |
| JE_DEPRECIATION_CATEGORY | VARCHAR2 | (30) | Journal category for depreciation | |
| JE_RECLASS_CATEGORY | VARCHAR2 | (30) | Journal category for reclassifications | |
| GL_JE_SOURCE | VARCHAR2 | (30) | General Ledger journal entry source | |
| JE_ADDITION_CATEGORY | VARCHAR2 | (30) | Journal category for additions | |
| JE_ADJUSTMENT_CATEGORY | VARCHAR2 | (30) | Journal category for adjustments | |
| JE_TRANSFER_CATEGORY | VARCHAR2 | (30) | Journal category for transfers | |
| COPY_RETIREMENTS_FLAG | VARCHAR2 | (3) | Yes | Indicates whether or not to copy retirements in a mass copy |
| COPY_ADJUSTMENTS_FLAG | VARCHAR2 | (3) | Yes | Indicates whether or not to copy adjustments in a mass copy |
| ALLOW_COST_CEILING | VARCHAR2 | (3) | Yes | Indicates whether or not to allow cost ceilings |
| ALLOW_DEPRN_EXP_CEILING | VARCHAR2 | (3) | Yes | Indicates whether or not to allow depreciation expense ceilings |
| JE_DEFERRED_DEPRN_CATEGORY | VARCHAR2 | (30) | Journal category for deferred depreciation | |
| ITC_ALLOWED_FLAG | VARCHAR2 | (3) | Yes | Indicates whether or not to allow ITC |
| CREATED_BY | NUMBER | (15) | Standard Who column | |
| CREATION_DATE | DATE | Standard Who column | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| ALLOW_MASS_COPY | VARCHAR2 | (3) | Yes | Indicates whether or not to allow mass copy |
| ALLOW_PURGE_FLAG | VARCHAR2 | (3) | Indicates whether or not to allow purge | |
| ALLOW_REVAL_FLAG | VARCHAR2 | (3) | Yes | Indicates whether or not to allow revaluation |
| AMORTIZE_REVAL_RESERVE_FLAG | VARCHAR2 | (3) | Indicates whether or not to amortize revaluation reserve | |
| AP_INTERCOMPANY_ACCT | VARCHAR2 | (25) | Intercompany payables account segment | |
| AR_INTERCOMPANY_ACCT | VARCHAR2 | (25) | Intercompany receivables account segment | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE_CATEGORY_CODE | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
| CAPITAL_GAIN_THRESHOLD | NUMBER | Minimum time to hold an asset for Oracle Assets to report it as a capital gain on the form 4797 reports when you retire it | ||
| COPY_SALVAGE_VALUE_FLAG | VARCHAR2 | (3) | Yes | Indicates whether or not to mass copy salvage value |
| COST_OF_REMOVAL_CLEARING_ACCT | VARCHAR2 | (25) | Yes | Clearing account segment for cost of removal upon retirement |
| COST_OF_REMOVAL_GAIN_ACCT | VARCHAR2 | (25) | Account segment for cost of removal upon retirement that results in a gain | |
| COST_OF_REMOVAL_LOSS_ACCT | VARCHAR2 | (25) | Account segment for cost of removal upon 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 | (15) | Default maximum number of times an asset can be revalued as fully reserved | |
| DEFAULT_REVAL_FULLY_RSVD_FLAG | VARCHAR2 | (3) | Indicates whether or not to revalue fully reserved assets in this book by default | |
| DEFERRED_DEPRN_EXPENSE_ACCT | VARCHAR2 | (25) | Expense account segment for deferred depreciation | |
| DEFERRED_DEPRN_RESERVE_ACCT | VARCHAR2 | (25) | Reserve account segment for deferred depreciation | |
| DEPRN_ALLOCATION_CODE | VARCHAR2 | (1) | Yes | Determines whether to allocate annual depreciation expense to each period evenly (E) or by the number of days in that period (D) |
| JE_CIP_ADJUSTMENT_CATEGORY | VARCHAR2 | (30) | Journal category for CIP adjustments | |
| JE_CIP_ADDITION_CATEGORY | VARCHAR2 | (30) | Journal category for CIP additions | |
| JE_CIP_RECLASS_CATEGORY | VARCHAR2 | (30) | Journal category for CIP reclassifications | |
| JE_CIP_RETIREMENT_CATEGORY | VARCHAR2 | (30) | Journal category for CIP retirements | |
| JE_CIP_REVAL_CATEGORY | VARCHAR2 | (30) | Journal category for CIP revaluations | |
| JE_CIP_TRANSFER_CATEGORY | VARCHAR2 | (30) | Journal category for CIP transfers | |
| JE_REVAL_CATEGORY | VARCHAR2 | (30) | Journal category for revaluations | |
| NBV_AMOUNT_THRESHOLD | NUMBER | Rounding information for depreciation based on currency and precision | ||
| NBV_FRACTION_THRESHOLD | NUMBER | Rounding information for depreciation based on currency and precision | ||
| NBV_RETIRED_GAIN_ACCT | VARCHAR2 | (25) | NBV retired account segment to use if retirement results in a gain | |
| NBV_RETIRED_LOSS_ACCT | VARCHAR2 | (25) | NBV retired account segment to use if retirement results in a loss | |
| PROCEEDS_OF_SALE_CLEARING_ACCT | VARCHAR2 | (25) | Proceeds of sale clearing account segment | |
| PROCEEDS_OF_SALE_GAIN_ACCT | VARCHAR2 | (25) | Proceeds of sale account segment to use if retirement results in a gain | |
| PROCEEDS_OF_SALE_LOSS_ACCT | VARCHAR2 | (25) | Proceeds of sale account segment to use if retirement results in a loss | |
| REVALUE_ON_RETIREMENT_FLAG | VARCHAR2 | (3) | Indicates whether or not to revalue upon retirement | |
| REVAL_DEPRN_RESERVE_FLAG | VARCHAR2 | (3) | Indicates whether or not to revalue depreciation reserve | |
| REVAL_RSV_RETIRED_GAIN_ACCT | VARCHAR2 | (25) | Revaluation reserve retired account segment to use if retirement results in a gain | |
| REVAL_RSV_RETIRED_LOSS_ACCT | VARCHAR2 | (25) | Revaluation reserve retired account segment to use if retirement results in a loss | |
| DEPRN_ADJUSTMENT_ACCT | VARCHAR2 | (25) | Account segment for reserve adjustments in tax books | |
| IMMEDIATE_COPY_FLAG | VARCHAR2 | (3) | Reserved for future use | |
| JE_DEPRN_ADJUSTMENT_CATEGORY | VARCHAR2 | (30) | Journal category for tax depreciation adjustments | |
| DEPR_FIRST_YEAR_RET_FLAG | VARCHAR2 | (3) | Yes | Indicates whether or not to depreciate assets retired in the first year of life |
| FLEXBUILDER_DEFAULTS_CCID | NUMBER | (15) | Code combination ID of segment default values for the Account Generator | |
| RETIRE_REVAL_RESERVE_FLAG | VARCHAR2 | (3) | Indicates whether or not to retire revaluation reserve | |
| COPY_ADDITIONS_FLAG | VARCHAR2 | (3) | Yes | Indicates whether or not to copy additions in a mass copy |
| USE_PERCENT_SALVAGE_VALUE_FLAG | VARCHAR2 | (3) | Reserved for future use | |
| REVAL_POSTING_FLAG | VARCHAR2 | (3) | Reserved for future use | |
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Reserved for country-specific functionality | |
| MC_SOURCE_FLAG | VARCHAR2 | (1) | Indicates whether the book is an MRC-enabled book | |
| REVAL_YTD_DEPRN_FLAG | VARCHAR2 | (3) | Reserved for future use | |
| ALLOW_CIP_ASSETS_FLAG | VARCHAR2 | (3) | Indicates whether or not to allow copying CIP assets from corporate book to tax book | |
| ORG_ID | NUMBER | (15) | Organization ID | |
| ALLOW_GROUP_DEPRN_FLAG | VARCHAR2 | (1) | Indicates whether or not to allow group assets and group depreciation | |
| ALLOW_CIP_DEP_GROUP_FLAG | VARCHAR2 | (1) | Indicates whether or not to allow portions of a cip asset's cost to depreciate as part of a group asset | |
| ALLOW_INTERCO_GROUP_FLAG | VARCHAR2 | (1) | Indicates whether or not intercompany transactions are allowed on group or group member assets | |
| COPY_GROUP_ASSIGNMENT_FLAG | VARCHAR2 | (1) | Indicates whether or not to mass copy the group asset association of an asset | |
| COPY_GROUP_ADDITION_FLAG | VARCHAR2 | (1) | Indicates whether or not to mass copy group asset additions | |
| ALLOW_CIP_MEMBER_FLAG | VARCHAR2 | (1) | Indicates whether group assets will be automatically defaulted for CIP additions | |
| ALLOW_MEMBER_TRACKING_FLAG | VARCHAR2 | (1) | Indicates whether member asset tracking is allowed for a particular book | |
| INTERCOMPANY_POSTING_FLAG | VARCHAR2 | (1) | Indicates whether intercompany transfer posting to journals is allowed or not. | |
| ALLOW_BACKDATED_TRANSFERS_FLAG | VARCHAR2 | (1) | Indicates whether to allow backdated transfers in tax books. | |
| ALLOW_COST_SIGN_CHANGE_FLAG | VARCHAR2 | (1) | Indicates whether to allow adjustments that change the cost on an asset from positive to negative or vice versa. | |
| ALLOW_IMPAIRMENT_FLAG | VARCHAR2 | (1) | Indicates whether to allow asset impairments | |
| SORP_ENABLED_FLAG | VARCHAR2 | (1) | Indicates whether to allow UK Local Authority specific accounting for the book | |
| COPY_AMORT_ADAJ_EXP_FLAG | VARCHAR2 | (1) | Indicates whether to expense member adjustments during mass copy | |
| COPY_GROUP_CHANGE_FLAG | VARCHAR2 | (1) | Indicates whether to copy Group change during mass copy | |
| PREVENT_PRIOR_PERIOD_TXNS_FLAG | VARCHAR2 | (1) | Indicates whether amortized transactions backdated to previous periods should be prevented | |
| ALLOW_UNALLOCATED_LINES_FLAG | VARCHAR2 | (1) | Decides whether to allow unallocated line types from Payables during mass addition | |
| DEFAULT_PERIOD_END_REVAL_FLAG | VARCHAR2 | (1) | Used to default value of Include Current Period Depreciation in Revaluation UI | |
| IMPORT_ALLOC_INV_LINES_AS_NEW | VARCHAR2 | (1) | Decides whether to disable automatic merge of payables source lines | |
| Name | Datatype | Length | Mandatory | Comments |
|---|
Cut, paste (and edit) the following text to query this object:
SELECT BOOK_TYPE_CODE
, DATE_ACTIVE
, DATE_INACTIVE
, BOOK_TYPE_NAME
, SET_OF_BOOKS_ID
, AMORTIZE_FLAG
, GL_POSTING_ALLOWED_FLAG
, ALLOW_MASS_CHANGES
, ALLOW_DEPRN_ADJUSTMENTS
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, DATE_INEFFECTIVE
, JE_RETIREMENT_CATEGORY
, JE_DEPRECIATION_CATEGORY
, JE_RECLASS_CATEGORY
, GL_JE_SOURCE
, JE_ADDITION_CATEGORY
, JE_ADJUSTMENT_CATEGORY
, JE_TRANSFER_CATEGORY
, COPY_RETIREMENTS_FLAG
, COPY_ADJUSTMENTS_FLAG
, ALLOW_COST_CEILING
, ALLOW_DEPRN_EXP_CEILING
, JE_DEFERRED_DEPRN_CATEGORY
, ITC_ALLOWED_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, ALLOW_MASS_COPY
, ALLOW_PURGE_FLAG
, ALLOW_REVAL_FLAG
, AMORTIZE_REVAL_RESERVE_FLAG
, AP_INTERCOMPANY_ACCT
, AR_INTERCOMPANY_ACCT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY_CODE
, CAPITAL_GAIN_THRESHOLD
, COPY_SALVAGE_VALUE_FLAG
, COST_OF_REMOVAL_CLEARING_ACCT
, COST_OF_REMOVAL_GAIN_ACCT
, COST_OF_REMOVAL_LOSS_ACCT
, DEFAULT_LIFE_EXTENSION_CEILING
, DEFAULT_LIFE_EXTENSION_FACTOR
, DEFAULT_MAX_FULLY_RSVD_REVALS
, DEFAULT_REVAL_FULLY_RSVD_FLAG
, DEFERRED_DEPRN_EXPENSE_ACCT
, DEFERRED_DEPRN_RESERVE_ACCT
, DEPRN_ALLOCATION_CODE
, JE_CIP_ADJUSTMENT_CATEGORY
, JE_CIP_ADDITION_CATEGORY
, JE_CIP_RECLASS_CATEGORY
, JE_CIP_RETIREMENT_CATEGORY
, JE_CIP_REVAL_CATEGORY
, JE_CIP_TRANSFER_CATEGORY
, JE_REVAL_CATEGORY
, NBV_AMOUNT_THRESHOLD
, NBV_FRACTION_THRESHOLD
, NBV_RETIRED_GAIN_ACCT
, NBV_RETIRED_LOSS_ACCT
, PROCEEDS_OF_SALE_CLEARING_ACCT
, PROCEEDS_OF_SALE_GAIN_ACCT
, PROCEEDS_OF_SALE_LOSS_ACCT
, REVALUE_ON_RETIREMENT_FLAG
, REVAL_DEPRN_RESERVE_FLAG
, REVAL_RSV_RETIRED_GAIN_ACCT
, REVAL_RSV_RETIRED_LOSS_ACCT
, DEPRN_ADJUSTMENT_ACCT
, IMMEDIATE_COPY_FLAG
, JE_DEPRN_ADJUSTMENT_CATEGORY
, DEPR_FIRST_YEAR_RET_FLAG
, FLEXBUILDER_DEFAULTS_CCID
, RETIRE_REVAL_RESERVE_FLAG
, COPY_ADDITIONS_FLAG
, USE_PERCENT_SALVAGE_VALUE_FLAG
, REVAL_POSTING_FLAG
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY
, MC_SOURCE_FLAG
, REVAL_YTD_DEPRN_FLAG
, ALLOW_CIP_ASSETS_FLAG
, ORG_ID
, ALLOW_GROUP_DEPRN_FLAG
, ALLOW_CIP_DEP_GROUP_FLAG
, ALLOW_INTERCO_GROUP_FLAG
, COPY_GROUP_ASSIGNMENT_FLAG
, COPY_GROUP_ADDITION_FLAG
, ALLOW_CIP_MEMBER_FLAG
, ALLOW_MEMBER_TRACKING_FLAG
, INTERCOMPANY_POSTING_FLAG
, ALLOW_BACKDATED_TRANSFERS_FLAG
, ALLOW_COST_SIGN_CHANGE_FLAG
, ALLOW_IMPAIRMENT_FLAG
, SORP_ENABLED_FLAG
, COPY_AMORT_ADAJ_EXP_FLAG
, COPY_GROUP_CHANGE_FLAG
, PREVENT_PRIOR_PERIOD_TXNS_FLAG
, ALLOW_UNALLOCATED_LINES_FLAG
, DEFAULT_PERIOD_END_REVAL_FLAG
, IMPORT_ALLOC_INV_LINES_AS_NEW
FROM FA.FA_BOOK_CONTROLS_HISTORY;
FA.FA_BOOK_CONTROLS_HISTORY does not reference any database object
FA.FA_BOOK_CONTROLS_HISTORY is referenced by following:
FA
FA_BOOK_CONTROLS_HISTORY#
|
|
|
|