[Home] [Help] [Dependency Information]
Object Name: | GL_AUTOMATIC_POSTING_OPTIONS |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_AUTOMATIC_POSTING_OPTIONS |
Subobject Name: | |
Status: | VALID |
GL_AUTOMATIC_POSTING_OPTIONS stores the criteria used by the AutoPost program to select journal entries for posting. Each row stores the priority of this AutoPost criteria and contains the balance type, period, source, and category criteria used to select journal entries. There is a one-to-many relationship between AutoPost Criteria Sets in GL_AUTOMATIC_POSTING_SETS and AutoPost criteria in this table.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_AUTOMATIC_POSTING_OP_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
AUTOPOST_SET_ID
LEDGER_ID JE_SOURCE_NAME JE_CATEGORY_NAME PERIOD_NAME ACTUAL_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AUTOPOST_SET_ID | NUMBER | (15) | Yes | Autopost set id |
ACTUAL_FLAG | VARCHAR2 | (1) | Yes | Autopost criterion: balance type; can be 'A', ' B', or 'E' |
PERIOD_NAME | VARCHAR2 | (15) | Yes | Autopost criterion: journal batch posting period |
JE_SOURCE_NAME | VARCHAR2 | (25) | Yes | Autopost criterion: journal source name |
JE_CATEGORY_NAME | VARCHAR2 | (25) | Yes | Autopost criterion: journal category name |
POSTING_PRIORITY | NUMBER | (2) | Yes | Posting priority |
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 |
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 | |
LEDGER_ID | NUMBER | (15) | Yes | Ledger defining column |
Cut, paste (and edit) the following text to query this object:
SELECT AUTOPOST_SET_ID
, ACTUAL_FLAG
, PERIOD_NAME
, JE_SOURCE_NAME
, JE_CATEGORY_NAME
, POSTING_PRIORITY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CONTEXT
, LEDGER_ID
FROM GL.GL_AUTOMATIC_POSTING_OPTIONS;
GL.GL_AUTOMATIC_POSTING_OPTIONS does not reference any database object
GL.GL_AUTOMATIC_POSTING_OPTIONS is referenced by following:
|
|
|