[Home] [Help] [Dependency Information]
Object Name: | JL_ZZ_FA_RETIREMNT_ADJS |
---|---|
Object Type: | TABLE |
Owner: | JL |
FND Design Data: | JL.JL_ZZ_FA_RETIREMNT_ADJS |
Subobject Name: | |
Status: | VALID |
JL_ZZ_FA_RETIREMNT_ADJS stores information about assets that have been retired. This information is required to calculate inflation adjustment for depreciation expense amounts of retired assets.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JL_ZZ_FA_RETIREMNT_ADJS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
RETIREMENT_ID
PERIOD_COUNTER DISTRIBUTION_ID |
JL_ZZ_FA_RETIREMNT_ADJS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
BOOK_TYPE_CODE
PERIOD_COUNTER |
JL_ZZ_FA_RETIREMNT_ADJS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
BOOK_TYPE_CODE
ASSET_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RETIREMENT_ID | NUMBER | (15) | Yes | Retirement Identifier |
PERIOD_COUNTER | NUMBER | (15) | Yes | Depreciation Period Identifier |
DISTRIBUTION_ID | NUMBER | (15) | Yes | Distribution Identifier |
ASSET_ID | NUMBER | (15) | Yes | Asset Identification Number |
TRANSACTION_HEADER_ID | NUMBER | (15) | Yes | Transaction Header Identifier |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | Depreciation Book Identifier |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
JE_LINE_ID | NUMBER | (15) | Record identifier referencing on JE table | |
ORIGINAL_YTD_DEPRECIATION | NUMBER | Year-to-date depreciation expense at the time of retiring the asset | ||
TOTAL_ADJUSTMENT_AMOUNT | NUMBER | Sum of all the inflation adjustments (including the inflation adjustment for the period) | ||
CREATED_BY | NUMBER | (15) | Standard WHO Column | |
PERIOD_ADJUSTMENT_AMOUNT | NUMBER | Inflation adjustment amount for the period | ||
STATUS | VARCHAR2 | (3) | Indicator if the record was transferred to the journal entries table. It is either 'Y' or 'N'. | |
RETIRE_REINST_FLAG | VARCHAR2 | (3) | Source of the record. It could be either REI (Reinstated), RET (Retired), INF (Inflation Adjusted). | |
CREATION_DATE | DATE | Standard WHO Column | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column |
Cut, paste (and edit) the following text to query this object:
SELECT RETIREMENT_ID
, PERIOD_COUNTER
, DISTRIBUTION_ID
, ASSET_ID
, TRANSACTION_HEADER_ID
, LAST_UPDATED_BY
, BOOK_TYPE_CODE
, LAST_UPDATE_DATE
, JE_LINE_ID
, ORIGINAL_YTD_DEPRECIATION
, TOTAL_ADJUSTMENT_AMOUNT
, CREATED_BY
, PERIOD_ADJUSTMENT_AMOUNT
, STATUS
, RETIRE_REINST_FLAG
, CREATION_DATE
, LAST_UPDATE_LOGIN
FROM JL.JL_ZZ_FA_RETIREMNT_ADJS;
JL.JL_ZZ_FA_RETIREMNT_ADJS does not reference any database object
JL.JL_ZZ_FA_RETIREMNT_ADJS is referenced by following:
|
|
|