[Home] [Help] [Dependency Information]
Object Name: | GL_AUTOREVERSE_OPTIONS |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_AUTOREVERSE_OPTIONS |
Subobject Name: | |
Status: | VALID |
GL_AUTOREVERSE_OPTIONS stores the automatic reversal options you define using the Reversal Criteria form. Each row includes the journal category and its reversal criteria. One row is inserted into this table for each ledger when a new journal category is created through the Journal Categories form. The REVERSAL_DATE_CODE column is only used in ADB Non-Consolidation ledgers. Its value should be null for other ledgers.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_AUTOREVERSE_OPTIONS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CRITERIA_SET_ID
JE_CATEGORY_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CRITERIA_SET_ID | NUMBER | (15) | Yes | Autoreversal criteria set defining column |
JE_CATEGORY_NAME | VARCHAR2 | (25) | Yes | Journal entry category name |
METHOD_CODE | VARCHAR2 | (1) | Yes | Reversal method |
REVERSAL_PERIOD_CODE | VARCHAR2 | (30) | Yes | Rule used to default the reversal period |
AUTOREVERSE_FLAG | VARCHAR2 | (1) | Yes | Indicates if automatic reversal is enabled |
AUTOPOST_REVERSAL_FLAG | VARCHAR2 | (1) | Yes | Indicates if reversals are to be automatically posted |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who column |
REVERSAL_DATE_CODE | VARCHAR2 | (30) | Rule used to default the reversal date | |
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 | |
CONTEXT | VARCHAR2 | (150) | Descriptive flexfield context column |
Cut, paste (and edit) the following text to query this object:
SELECT CRITERIA_SET_ID
, JE_CATEGORY_NAME
, METHOD_CODE
, REVERSAL_PERIOD_CODE
, AUTOREVERSE_FLAG
, AUTOPOST_REVERSAL_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REVERSAL_DATE_CODE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CONTEXT
FROM GL.GL_AUTOREVERSE_OPTIONS;
GL.GL_AUTOREVERSE_OPTIONS does not reference any database object
GL.GL_AUTOREVERSE_OPTIONS is referenced by following:
|
|
|