[Home] [Help] [Dependency Information]
Object Name: | FAFV_BOOKS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OFA.FAFV_BOOKS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This shows control information that affects all assets in a depreciation book.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | Book name |
BOOK_TYPE_NAME | VARCHAR2 | (30) | Yes | Description of the book |
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 |
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 |
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 |
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 |
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 |
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 | ||
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 |
FISCAL_YEAR_NAME | VARCHAR2 | (30) | Name of fiscal year for which the book is defined | |
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 | |
MASS_COPY_SOURCE_BOOK | VARCHAR2 | (15) | Associated corporate book to Mass Copy from | |
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_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 |
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 |
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 |
MC_SOURCE_FLAG | VARCHAR2 | (1) | Indicates whether the book is an MRC-enabled book | |
LEDGER_ID | NUMBER | (15) | Yes | Set of books identification number for GL set of books |
LEDGER_NAME | VARCHAR2 | (30) | Yes | |
LAST_PERIOD_COUNTER | NUMBER | (15) | Yes | |
LAST_PERIOD_NAME | VARCHAR2 | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT BOOK_TYPE_CODE
, BOOK_TYPE_NAME
, INITIAL_DATE
, LAST_DEPRN_RUN_DATE
, AMORTIZE_FLAG
, DEPRN_CALENDAR
, BOOK_CLASS
, GL_POSTING_ALLOWED_FLAG
, CURRENT_FISCAL_YEAR
, ALLOW_MASS_CHANGES
, ALLOW_DEPRN_ADJUSTMENTS
, 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
, ALLOW_COST_CEILING
, ALLOW_DEPRN_EXP_CEILING
, JE_DEFERRED_DEPRN_CATEGORY
, ITC_ALLOWED_FLAG
, ALLOW_MASS_COPY
, ALLOW_PURGE_FLAG
, ALLOW_REVAL_FLAG
, AMORTIZE_REVAL_RESERVE_FLAG
, AP_INTERCOMPANY_ACCT
, AR_INTERCOMPANY_ACCT
, 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
, DEFERRED_DEPRN_EXPENSE_ACCT
, DEFERRED_DEPRN_RESERVE_ACCT
, FISCAL_YEAR_NAME
, 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
, MASS_COPY_SOURCE_BOOK
, 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
, JE_DEPRN_ADJUSTMENT_CATEGORY
, DEPR_FIRST_YEAR_RET_FLAG
, RETIRE_REVAL_RESERVE_FLAG
, COPY_ADDITIONS_FLAG
, MC_SOURCE_FLAG
, LEDGER_ID
, LEDGER_NAME
, LAST_PERIOD_COUNTER
, LAST_PERIOD_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
FROM APPS.FAFV_BOOKS;
APPS.FAFV_BOOKS is not referenced by any database object
|
|
|