[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FA_BOOK_CONTROLS |
|---|---|
| Object Type: | TABLE |
| Owner: | FA |
| FND Design Data: |  OFA.FA_BOOK_CONTROLS
|
| Subobject Name: | |
| Status: | VALID |
FA_BOOK_CONTROLS contains control information that affects all
assets in a depreciation book.
.
LAST_PERIOD_COUNTER is the last period for which you ran the
depreciation program on a book. Oracle Assets uses it to prevent
you from running the depreciation program multiple times for a
period and to ensure that you run it for consecutive periods.
.
INITIAL_PERIOD_COUNTER is the period prior to the one in which you
created this book.
.
INITIAL_DATE is the last date on which you ran depreciation for this
book on your previous system before you started using Oracle Assets.
.
ACCOUNTING_FLEX_STRUCTURE determines which Accounting Flexfield
structure the depreciation book uses. It matches a
CHART_OF_ACCOUNTS_ID in GL_CODE_COMBINATIONS. Oracle Assets uses
it to configure Accounting Flexfield pop-up windows and to run
reports that use the account number.
.
DEPRN_REQUEST_ID is the concurrent request number for the last time
you ran the depreciation program on a book. Oracle Assets updates
this column as soon as the depreciation program begins running.
.
DEPRN_STATUS specifies whether depreciation is locking the book.
Oracle Assets uses DEPRN_STATUS to prevent you from entering
transactions while depreciation is running. It can be:
.
{{FB}} C {{F0}}
{{TAB}}Completed
.
{{FB}} E {{F0}}
{{TAB}}Error
.
{{FB}} R {{F0}}
{{TAB}}Running
.
{{FB}} S {{F0}}
{{TAB}}Submitted
.
.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| FA_BOOK_CONTROLS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 BOOK_TYPE_CODE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | Book name |
| 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 |
| INITIAL_DATE | DATE | Yes | Date the last time depreciation was run for this book on the previous asset system | |
| LAST_DEPRN_RUN_DATE | DATE | Yes | Date of the last depreciation | |
| AMORTIZE_FLAG | VARCHAR2 | (3) | Yes | Indicates whether or not to allow amortized changes |
| FULLY_RESERVED_FLAG | VARCHAR2 | (3) | Yes | No longer used |
| DEPRN_CALENDAR | VARCHAR2 | (15) | Yes | Name of depreciation calendar |
| BOOK_CLASS | VARCHAR2 | (15) | Yes | Indicates whether the book is a corporate, tax, or budget book |
| GL_POSTING_ALLOWED_FLAG | VARCHAR2 | (3) | Yes | Indicates whether or not to allow posting to GL |
| CURRENT_FISCAL_YEAR | NUMBER | (4) | Yes | Current fiscal year for the book |
| 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 |
| ACCOUNTING_FLEX_STRUCTURE | NUMBER | (15) | Yes | Accounting flexfield structure |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| PRORATE_CALENDAR | VARCHAR2 | (15) | Yes | Name of prorate calendar |
| 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 | |
| DISTRIBUTION_SOURCE_BOOK | VARCHAR2 | (15) | Associated corporate book used for tracking distributions | |
| 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 |
| DEPRN_REQUEST_ID | NUMBER | (15) | Concurrent request identification number for the last depreciation run | |
| 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 |
| CALCULATE_NBV | VARCHAR2 | (3) | Yes | No longer used |
| RUN_YEAR_END_PROGRAM | VARCHAR2 | (3) | Yes | Indicates that the year end program is running |
| JE_DEFERRED_DEPRN_CATEGORY | VARCHAR2 | (30) | Journal category for deferred depreciation | |
| ALLOW_CIP_ASSETS_FLAG | VARCHAR2 | (3) | Indicates whether or not to allow copying CIP assets from corporate book to tax book | |
| 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) | Yes | Intercompany payables account segment |
| AR_INTERCOMPANY_ACCT | VARCHAR2 | (25) | Yes | 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) | Yes | Account segment for cost of removal upon retirement that results in a gain |
| COST_OF_REMOVAL_LOSS_ACCT | VARCHAR2 | (25) | Yes | 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) | Yes | Expense account segment for deferred depreciation |
| DEFERRED_DEPRN_RESERVE_ACCT | VARCHAR2 | (25) | Yes | 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) |
| DEPRN_STATUS | VARCHAR2 | (1) | Specifies whether the depreciation program is locking the book. Either C (completed), E (error), R (running), or S (submitted) | |
| FISCAL_YEAR_NAME | VARCHAR2 | (30) | Name of fiscal year for which the book is defined | |
| INITIAL_PERIOD_COUNTER | NUMBER | (15) | Yes | Period before the period you created this book |
| 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) | Reserved for future use | |
| JE_CIP_TRANSFER_CATEGORY | VARCHAR2 | (30) | Journal category for CIP transfers | |
| JE_REVAL_CATEGORY | VARCHAR2 | (30) | Journal category for revaluations | |
| LAST_MASS_COPY_PERIOD_COUNTER | NUMBER | (15) | Last corporate period mass copied into this tax book | |
| LAST_PERIOD_COUNTER | NUMBER | (15) | Yes | Last period depreciated in this book |
| LAST_PURGE_PERIOD_COUNTER | NUMBER | (15) | Last period purged for this book | |
| MASS_COPY_SOURCE_BOOK | VARCHAR2 | (15) | Associated corporate book to Mass Copy from | |
| MASS_REQUEST_ID | NUMBER | (15) | Concurrent request ID of a mass transaction locking any assets in this book | |
| 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) | Yes | NBV retired account segment to use if retirement results in a gain |
| NBV_RETIRED_LOSS_ACCT | VARCHAR2 | (25) | Yes | NBV retired account segment to use if retirement results in a loss |
| PROCEEDS_OF_SALE_CLEARING_ACCT | VARCHAR2 | (25) | Yes | Proceeds of sale clearing account segment |
| PROCEEDS_OF_SALE_GAIN_ACCT | VARCHAR2 | (25) | Yes | Proceeds of sale account segment to use if retirement results in a gain |
| PROCEEDS_OF_SALE_LOSS_ACCT | VARCHAR2 | (25) | Yes | 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_POSTING_FLAG | VARCHAR2 | (3) | Reserved for future use | |
| REVAL_RSV_RETIRED_GAIN_ACCT | VARCHAR2 | (25) | Yes | Revaluation reserve retired account segment to use if retirement results in a gain |
| REVAL_RSV_RETIRED_LOSS_ACCT | VARCHAR2 | (25) | Yes | Revaluation reserve retired account segment to use if retirement results in a loss |
| DEPRN_ADJUSTMENT_ACCT | VARCHAR2 | (25) | Yes | 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) | Yes | 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 | |
| USE_CURRENT_NBV_FOR_DEPRN | VARCHAR2 | (3) | Yes | Reserved for future use |
| 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 | |
| MC_SOURCE_FLAG | VARCHAR2 | (1) | Indicates whether the book is an MRC-enabled book | |
| REVAL_YTD_DEPRN_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 | |
| 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 wether 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. | |
| CREATE_ACCOUNTING_REQUEST_ID | NUMBER | (15) | Concurrent request ID of a Create Accounting program currently locking this book | |
| ALLOW_IMPAIRMENT_FLAG | VARCHAR2 | (1) | Indicates whether to allow asset impairments | |
| ALLOW_BONUS_DEPRN_FLAG | VARCHAR2 | (1) | Indicates whether to allow bonus depreciation | |
| 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 |
Cut, paste (and edit) the following text to query this object:
SELECT BOOK_TYPE_CODE
, BOOK_TYPE_NAME
, SET_OF_BOOKS_ID
, INITIAL_DATE
, LAST_DEPRN_RUN_DATE
, AMORTIZE_FLAG
, FULLY_RESERVED_FLAG
, DEPRN_CALENDAR
, BOOK_CLASS
, GL_POSTING_ALLOWED_FLAG
, CURRENT_FISCAL_YEAR
, ALLOW_MASS_CHANGES
, ALLOW_DEPRN_ADJUSTMENTS
, ACCOUNTING_FLEX_STRUCTURE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, PRORATE_CALENDAR
, DATE_INEFFECTIVE
, JE_RETIREMENT_CATEGORY
, JE_DEPRECIATION_CATEGORY
, JE_RECLASS_CATEGORY
, GL_JE_SOURCE
, JE_ADDITION_CATEGORY
, JE_ADJUSTMENT_CATEGORY
, DISTRIBUTION_SOURCE_BOOK
, JE_TRANSFER_CATEGORY
, COPY_RETIREMENTS_FLAG
, COPY_ADJUSTMENTS_FLAG
, DEPRN_REQUEST_ID
, ALLOW_COST_CEILING
, ALLOW_DEPRN_EXP_CEILING
, CALCULATE_NBV
, RUN_YEAR_END_PROGRAM
, JE_DEFERRED_DEPRN_CATEGORY
, ALLOW_CIP_ASSETS_FLAG
, 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
, DEPRN_STATUS
, FISCAL_YEAR_NAME
, INITIAL_PERIOD_COUNTER
, 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
, LAST_MASS_COPY_PERIOD_COUNTER
, LAST_PERIOD_COUNTER
, LAST_PURGE_PERIOD_COUNTER
, MASS_COPY_SOURCE_BOOK
, MASS_REQUEST_ID
, 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_POSTING_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
, USE_CURRENT_NBV_FOR_DEPRN
, COPY_ADDITIONS_FLAG
, USE_PERCENT_SALVAGE_VALUE_FLAG
, MC_SOURCE_FLAG
, REVAL_YTD_DEPRN_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
, 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
, CREATE_ACCOUNTING_REQUEST_ID
, ALLOW_IMPAIRMENT_FLAG
, ALLOW_BONUS_DEPRN_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;
FA.FA_BOOK_CONTROLS does not reference any database object
FA.FA_BOOK_CONTROLS is referenced by following:
FA
FA_BOOK_CONTROLS#
|
|
|
|