[Home] [Help] [Dependency Information]
Object Name: | GL_ELIMINATION_JOURNALS |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_ELIMINATION_JOURNALS |
Subobject Name: | |
Status: | VALID |
GL_ELIMINATION_JOURNALS stores information about your journals for an elimination set. This table corresponds to the journal definition section of the Define Elimination Mappings window of the Define Elimination Set form. For each journal in an elimination set, there exists a row in this table. That row indicates the journal name, category, currency, amount_type, and other information.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_ELIM_JOURNALS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ELIMINATION_SET_ID
JOURNAL_ID |
GL_ELIM_JOURNALS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ELIMINATION_SET_ID
JOURNAL_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ELIMINATION_SET_ID | NUMBER | (15) | Yes | Intercompany elimination set defining column |
JOURNAL_ID | NUMBER | (15) | Yes | Elimination journal defining column |
JOURNAL_NAME | VARCHAR2 | (100) | Yes | Elimination journal name |
JE_CATEGORY | VARCHAR2 | (25) | Yes | Journal entry category |
CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency |
AMOUNT_TYPE | VARCHAR2 | (4) | Yes | Amount type (YTD, QTD, PTD, etc...) |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who column |
CONTEXT | VARCHAR2 | (150) | Descriptive flexfield context | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT ELIMINATION_SET_ID
, JOURNAL_ID
, JOURNAL_NAME
, JE_CATEGORY
, CURRENCY_CODE
, AMOUNT_TYPE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM GL.GL_ELIMINATION_JOURNALS;
GL.GL_ELIMINATION_JOURNALS does not reference any database object
GL.GL_ELIMINATION_JOURNALS is referenced by following:
|
|
|