[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FA_CATEGORY_BOOK_DEFAULTS |
|---|---|
| Object Type: | TABLE |
| Owner: | FA |
| FND Design Data: |  OFA.FA_CATEGORY_BOOK_DEFAULTS
|
| Subobject Name: | |
| Status: | VALID |
FA_CATEGORY_BOOK_DEFAULTS provides defaults for the
depreciation rules when you add an asset.
.
The Asset Categories form inserts a row into this table
for each asset category, depreciation book, and date
placed in service range for which you set up the category.
.
.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| FA_CATEGORY_BOOK_DEFAULTS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 CATEGORY_ID
BOOK_TYPE_CODE
START_DPIS
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CATEGORY_ID | NUMBER | (15) | Yes | Asset category |
| BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | Book name |
| START_DPIS | DATE | Yes | First date placed in service to which this set of default depreciation rules applies | |
| END_DPIS | DATE | Last date placed in service to which this set of default depreciation rules applies | ||
| LIFE_IN_MONTHS | NUMBER | (4) | Life of an asset in this asset category and book | |
| DEPRN_METHOD | VARCHAR2 | (12) | Yes | Depreciation method used by this asset category and book |
| PRORATE_CONVENTION_CODE | VARCHAR2 | (10) | Yes | Depreciation prorate convention used by assets in this category and book |
| ITC_ELIGIBLE_FLAG | VARCHAR2 | (3) | Yes | Indicates whether assets in this category and book are eligible for ITC |
| USE_ITC_CEILINGS_FLAG | VARCHAR2 | (3) | Yes | Indicates whether ITC ceilings are used by assets in this category and book |
| CEILING_NAME | VARCHAR2 | (30) | Name of the depreciation ceiling used | |
| BASIC_RATE | NUMBER | Basic depreciation rate used for flat-rate methods | ||
| ADJUSTED_RATE | NUMBER | Adjusted depreciation rate used for flat-rate methods | ||
| BONUS_RULE | VARCHAR2 | (30) | Bonus depreciation rule for flat-rate methods | |
| DEPRECIATE_FLAG | VARCHAR2 | (3) | Yes | Indicates whether assets in this category are depreciating or non-depreciating assets |
| RETIREMENT_PRORATE_CONVENTION | VARCHAR2 | (10) | Yes | Retirement prorate convention used by assets in this category and book |
| PRICE_INDEX_NAME | VARCHAR2 | (40) | Name of the price index | |
| USE_STL_RETIREMENTS_FLAG | VARCHAR2 | (3) | Yes | Indicates whether a straight line retirement convention is used |
| STL_METHOD_CODE | VARCHAR2 | (12) | Straight line method code used for special tax retirements | |
| STL_LIFE_IN_MONTHS | NUMBER | (4) | Life of an asset for use with straight line depreciation for special tax retirements | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| CREATED_BY | NUMBER | (15) | Standard Who column | |
| CREATION_DATE | DATE | Standard Who column | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| SUBCOMPONENT_LIFE_RULE | VARCHAR2 | (13) | Rule by which to default the life of subcomponents in this category | |
| MINIMUM_LIFE_IN_MONTHS | NUMBER | (4) | Minimum life for subcomponents | |
| PRODUCTION_CAPACITY | NUMBER | Capacity for a units of production asset | ||
| UNIT_OF_MEASURE | VARCHAR2 | (25) | Unit of measure for a units of production asset | |
| 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 | ||
| 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 | |
| USE_DEPRN_LIMITS_FLAG | VARCHAR2 | (3) | Indicates whether to use a depreciation limit for the book. | |
| ALLOWED_DEPRN_LIMIT | NUMBER | Default depreciation limit as a percent of cost. | ||
| SPECIAL_DEPRN_LIMIT_AMOUNT | NUMBER | Default depreciation limit as a flat amount, subtracted from cost. | ||
| PERCENT_SALVAGE_VALUE | NUMBER | Default salvage value percentage. | ||
| CUA_LIFE_END_DATE | DATE | Reserved for system use. Do not use. | ||
| CUA_RULE_SET_ID | NUMBER | Reserved for system use. Do not use. | ||
| GROUP_ASSET_ID | NUMBER | (15) | Identifies the associated group asset for group member assets | |
| MASS_PROPERTY_FLAG | VARCHAR2 | (1) | Indicates whether Mass Property is eligible or not for assets added to this category. | |
| RECOGNIZE_GAIN_LOSS | VARCHAR2 | (30) | Indicates whether or not the system recognizes gain or loss immediately | |
| RECAPTURE_RESERVE_FLAG | VARCHAR2 | (1) | Indicates whether or not the reserve for a group asset can exceed its recoverable cost | |
| LIMIT_PROCEEDS_FLAG | VARCHAR2 | (1) | Indicates whether or not the proceeds amount for a member asset is limited to the retiring member recoverable cost | |
| TERMINAL_GAIN_LOSS | VARCHAR2 | (30) | Indicates whether or not to take terminal gain or loss immediately or at the end of the fiscal year, when accumulated depreciation remains for the group asset after the last member asset is retired from the group asset | |
| TRACKING_METHOD | VARCHAR2 | (30) | Indicates whether member assets should be tracked using the allocate method or the calculate method | |
| EXCLUDE_FULLY_RSV_FLAG | VARCHAR2 | (1) | Indicates whether or not fully reserved assets' depreciable basis should be excluded from the group's depreciable basis | |
| EXCESS_ALLOCATION_OPTION | VARCHAR2 | (30) | Indicates whether the excess amount incurred during allocation should also be distributed to the member asset, or reduced from the group asset depreciation expense | |
| DEPRECIATION_OPTION | VARCHAR2 | (30) | Indicates whether a member asset's depreciation expenses should be calculated using its group asset depreciation rules or the member asset depreciation rules | |
| MEMBER_ROLLUP_FLAG | VARCHAR2 | (1) | Indicates whether or not the sum of member asset depreciation expense should be the group asset depreciation amount | |
| ALLOCATE_TO_FULLY_RSV_FLAG | VARCHAR2 | (1) | Indicates whether or not group depreciation expense should be allocated to fully reserved assets | |
| ALLOCATE_TO_FULLY_RET_FLAG | VARCHAR2 | (1) | Indicates whether or not group depreciation expense should be allocated to fully retired assets |
Cut, paste (and edit) the following text to query this object:
SELECT CATEGORY_ID
, BOOK_TYPE_CODE
, START_DPIS
, END_DPIS
, LIFE_IN_MONTHS
, DEPRN_METHOD
, PRORATE_CONVENTION_CODE
, ITC_ELIGIBLE_FLAG
, USE_ITC_CEILINGS_FLAG
, CEILING_NAME
, BASIC_RATE
, ADJUSTED_RATE
, BONUS_RULE
, DEPRECIATE_FLAG
, RETIREMENT_PRORATE_CONVENTION
, PRICE_INDEX_NAME
, USE_STL_RETIREMENTS_FLAG
, STL_METHOD_CODE
, STL_LIFE_IN_MONTHS
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, SUBCOMPONENT_LIFE_RULE
, MINIMUM_LIFE_IN_MONTHS
, PRODUCTION_CAPACITY
, UNIT_OF_MEASURE
, CAPITAL_GAIN_THRESHOLD
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY_CODE
, USE_DEPRN_LIMITS_FLAG
, ALLOWED_DEPRN_LIMIT
, SPECIAL_DEPRN_LIMIT_AMOUNT
, PERCENT_SALVAGE_VALUE
, CUA_LIFE_END_DATE
, CUA_RULE_SET_ID
, GROUP_ASSET_ID
, MASS_PROPERTY_FLAG
, RECOGNIZE_GAIN_LOSS
, RECAPTURE_RESERVE_FLAG
, LIMIT_PROCEEDS_FLAG
, TERMINAL_GAIN_LOSS
, TRACKING_METHOD
, EXCLUDE_FULLY_RSV_FLAG
, EXCESS_ALLOCATION_OPTION
, DEPRECIATION_OPTION
, MEMBER_ROLLUP_FLAG
, ALLOCATE_TO_FULLY_RSV_FLAG
, ALLOCATE_TO_FULLY_RET_FLAG
FROM FA.FA_CATEGORY_BOOK_DEFAULTS;
FA.FA_CATEGORY_BOOK_DEFAULTS does not reference any database object
FA.FA_CATEGORY_BOOK_DEFAULTS is referenced by following:
FA
FA_CATEGORY_BOOK_DEFAULTS#
|
|
|
|