[Home] [Help] [Dependency Information]
Object Name: | FA_DEPRN_OVERRIDE |
---|---|
Object Type: | TABLE |
Owner: | FA |
FND Design Data: | OFA.FA_DEPRN_OVERRIDE |
Subobject Name: | |
Status: | VALID |
This table stores depreciation information that users entered. This information overrides system calculated depreciation amounts.
Scope: public
Product: FA
Lifecycle: active
Display Name: FA Depreciation Override
Category: BUSINESS_ENTITY FA_ASSET
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FA_DEPRN_OVERRIDE_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | DEPRN_OVERRIDE_ID |
FA_DEPRN_OVERRIDE_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
BOOK_TYPE_CODE
ASSET_ID PERIOD_NAME USED_BY STATUS |
FA_DEPRN_OVERRIDE_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
USED_BY
STATUS TRANSACTION_HEADER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DEPRN_OVERRIDE_ID | NUMBER | (15) | Yes | Unique Identification Number for depreciation override records |
BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | BOOK_NAME |
ASSET_ID | NUMBER | (15) | Yes | System generated asset identification number |
PERIOD_NAME | VARCHAR2 | (15) | Yes | Depreciation period name |
DEPRN_AMOUNT | NUMBER | Depreciation Amount to be overridden | ||
BONUS_DEPRN_AMOUNT | NUMBER | Bonus Depreciation Amount to be overridden | ||
SUBTRACTION_FLAG | VARCHAR2 | (1) | 'Y'- DEPRN_AMOUNT refers to year-to-date balance. NULL - DEPRN_AMOUNT refers to periodic depreciation amount. Default value is NULL | |
USED_BY | VARCHAR2 | (15) | Yes | 'ADJUSTMENT' -- override amount will be used by adjustment transaction. 'DEPRECIATION' -- override amount will be used by depreciation process. |
STATUS | VARCHAR2 | (15) | Override status ('NEW', 'POSTED') | |
TRANSACTION_HEADER_ID | NUMBER | (15) | Shows the transaction that used the override amounts | |
REQUEST_ID | NUMBER | (15) | Concurrent Request Number | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Additional Who Column | |
PROGRAM_UPDATE_DATE | DATE | Additional Who Column | ||
PROGRAM_ID | NUMBER | (15) | Additional Who Column | |
CREATED_BY | NUMBER | (15) | Standard Who Column | |
CREATION_DATE | DATE | Standard Who Column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who Column | |
LAST_UPDATE_DATE | DATE | LAST_UPDATE_DATE | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
SUBTRACT_YTD_FLAG | VARCHAR2 | (1) | DEPRN_AMOUNT refers to year-to-date balance. 'N', NULL - DEPRN_AMOUNT refers to periodic depreciation amount. Default value is NULL. |
Cut, paste (and edit) the following text to query this object:
SELECT DEPRN_OVERRIDE_ID
, BOOK_TYPE_CODE
, ASSET_ID
, PERIOD_NAME
, DEPRN_AMOUNT
, BONUS_DEPRN_AMOUNT
, SUBTRACTION_FLAG
, USED_BY
, STATUS
, TRANSACTION_HEADER_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, PROGRAM_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SUBTRACT_YTD_FLAG
FROM FA.FA_DEPRN_OVERRIDE;
FA.FA_DEPRN_OVERRIDE does not reference any database object
FA.FA_DEPRN_OVERRIDE is referenced by following:
|
|
|