[Home] [Help] [Dependency Information]
Object Name: | JL_ZZ_FA_RETIREMNT_JES |
---|---|
Object Type: | TABLE |
Owner: | JL |
FND Design Data: | JL.JL_ZZ_FA_RETIREMNT_JES |
Subobject Name: | |
Status: | VALID |
JL_ZZ_FA_RETIREMNT_JES stores inflation adjustment journal entries at code combination level for the depreciation expense of retired assets.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JL_ZZ_FA_RETIREMNT_JES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | JE_LINE_ID |
JL_ZZ_FA_RETIREMNT_JES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
BOOK_TYPE_CODE
PERIOD_COUNTER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
JE_LINE_ID | NUMBER | (15) | Yes | Journal entry record identifier |
BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | Depreciation Book Identifier |
PERIOD_COUNTER | NUMBER | (15) | Yes | Depreciation period identifier |
CODE_COMBINATION_ID | NUMBER | (15) | Yes | Depreciation expense account identifier |
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Set of books identification number for GL set of books |
REQUEST_ID | NUMBER | (15) | Concurrent request ID that created the row | |
CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
ADJUSTMENT_AMOUNT | NUMBER | Depreciation being adjusted in the period | ||
DEBIT_CREDIT_FLAG | VARCHAR2 | (2) | Indicates whether to debit (DR) or credit (CR) the account | |
POSTING_FLAG | VARCHAR2 | (1) | Posted record indicator | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
CREATION_DATE | DATE | Standard WHO Column | ||
CREATED_BY | NUMBER | (15) | Standard WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column |
Cut, paste (and edit) the following text to query this object:
SELECT JE_LINE_ID
, BOOK_TYPE_CODE
, PERIOD_COUNTER
, CODE_COMBINATION_ID
, SET_OF_BOOKS_ID
, REQUEST_ID
, CURRENCY_CODE
, ADJUSTMENT_AMOUNT
, DEBIT_CREDIT_FLAG
, POSTING_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM JL.JL_ZZ_FA_RETIREMNT_JES;
JL.JL_ZZ_FA_RETIREMNT_JES does not reference any database object
JL.JL_ZZ_FA_RETIREMNT_JES is referenced by following:
|
|
|