[Home] [Help] [Dependency Information]
Object Name: | GL_ELIM_BAL_OPTIONS |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_ELIM_BAL_OPTIONS |
Subobject Name: | |
Status: | VALID |
GL_ELIM_BAL_OPTIONS stores information for balancing options defined for an elimination set. This table corresponds to the Balancing Options window of the Define Elimination Set form. For the balancing options in an elimination set, there exists a row in this table. If the value of the BALANCING_OPTION_CODE is 'A', which corresponds to 'Use net difference accounts', then the NET_DR_DIFFERENCE_CCID and the NET_CR_DIFFERENCE_CCID columns will also be populated. If the value of the BALANCING_OPTION_CODE is 'R', which corresponds to 'Use threshold rules', then the THRESHOLD_RULE and other corresponding threshold columns will be populated. If the value of the BALANCING_OPTION_CODE column is 'U', which corresponds to 'Create unbalanced journal', then the net difference account and the threshold columns will not contain any values.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_ELIM_BAL_OPTIONS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ELIMINATION_SET_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ELIMINATION_SET_ID | NUMBER | (15) | Yes | Intercompany elimination set defining column |
BALANCING_OPTION_CODE | VARCHAR2 | (1) | Yes | Balancing option code |
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 |
NET_DR_DIFFERENCE_CCID | NUMBER | (15) | Net debit difference account | |
NET_CR_DIFFERENCE_CCID | NUMBER | (15) | Net credit difference account | |
THRESHOLD_RULE | VARCHAR2 | (1) | Threshold rule | |
THRESHOLD_AMOUNT | NUMBER | (15) | Constant threshold amount | |
THRESHOLD_JOURNAL_PERCENT | NUMBER | Threshold journal percentage | ||
THRESHOLD_ACCOUNT_PERCENT | NUMBER | Threshold account percentage | ||
THRESHOLD_CCID | NUMBER | (15) | Threshold account | |
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
, BALANCING_OPTION_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, NET_DR_DIFFERENCE_CCID
, NET_CR_DIFFERENCE_CCID
, THRESHOLD_RULE
, THRESHOLD_AMOUNT
, THRESHOLD_JOURNAL_PERCENT
, THRESHOLD_ACCOUNT_PERCENT
, THRESHOLD_CCID
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM GL.GL_ELIM_BAL_OPTIONS;
GL.GL_ELIM_BAL_OPTIONS does not reference any database object
GL.GL_ELIM_BAL_OPTIONS is referenced by following:
|
|
|