[Home] [Help] [Dependency Information]
Object Name: | GL_ELIMINATION_SETS |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_ELIMINATION_SETS |
Subobject Name: | |
Status: | VALID |
GL_ELIMINATION_SETS stores information about your elimination set definitions. Each row includes an elimination set id, name, description and other information. This table corresponds to the first window of the Define Elimination Set Form. The LAST_EXECUTED_PERIOD column indicates the last period for which the elimination set was submitted for generation. The ELIMINATION_COMPANY column will contain a balancing segment value associated with your ledger's chart of accounts.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_ELIMINATION_SETS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ELIMINATION_SET_ID |
GL_ELIMINATION_SETS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
LEDGER_ID
NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ELIMINATION_SET_ID | NUMBER | (15) | Yes | Intercompany elimination set defining column |
NAME | VARCHAR2 | (40) | Yes | Elimination set name |
LEDGER_ID | NUMBER | (15) | Yes | Ledger defining column |
TRACK_ELIMINATION_STATUS_FLAG | VARCHAR2 | (1) | Yes | Indicates whether this elimination set should be considered in determining the elimination status |
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 |
START_DATE_ACTIVE | DATE | Date before which the elimination set is not active | ||
END_DATE_ACTIVE | DATE | Date after which the elimination set is not active | ||
ELIMINATION_COMPANY | VARCHAR2 | (25) | Elimination company | |
LAST_EXECUTED_PERIOD | VARCHAR2 | (15) | Last executed period for the elimination set | |
DESCRIPTION | VARCHAR2 | (240) | Elimination set description | |
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 | |
SECURITY_FLAG | VARCHAR2 | (1) | Yes | Enable definition access set security flag |
Cut, paste (and edit) the following text to query this object:
SELECT ELIMINATION_SET_ID
, NAME
, LEDGER_ID
, TRACK_ELIMINATION_STATUS_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, ELIMINATION_COMPANY
, LAST_EXECUTED_PERIOD
, DESCRIPTION
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_FLAG
FROM GL.GL_ELIMINATION_SETS;
GL.GL_ELIMINATION_SETS does not reference any database object
GL.GL_ELIMINATION_SETS is referenced by following:
|
|
|