[Home] [Help] [Dependency Information]
Object Name: | GL_XFR_LED_MAP_PERIODS |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_XFR_LED_MAP_PERIODS |
Subobject Name: | |
Status: | VALID |
This table contains the transfer information for each period that has been transferred for a ledger mapping.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_XFR_LED_MAP_PERIODS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
LEDGER_MAPPING_ID
FROM_PERIOD_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEDGER_MAPPING_ID | NUMBER | (15) | Yes | Ledger mapping that this transfer information is for |
FROM_PERIOD_NAME | VARCHAR2 | (15) | Yes | Name of period that this transfer information is for |
FROM_EFF_PER_NUM | NUMBER | (15) | Yes | Effective period number of period that this transfer information is for |
FULL_TRANSFER_DONE_FLAG | VARCHAR2 | (1) | Yes | Has this period already been transferred in full (Y/N) |
MAX_DELTA_RUN_ID | NUMBER | (15) | The maximum delta run id at the last time this period was run in full mode. Recorded so that only incremental information created after this period was last processed in full mode is processed. | |
TEMP_DATE | DATE | Interim column used by the balance transfer program | ||
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) | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT LEDGER_MAPPING_ID
, FROM_PERIOD_NAME
, FROM_EFF_PER_NUM
, FULL_TRANSFER_DONE_FLAG
, MAX_DELTA_RUN_ID
, TEMP_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM GL.GL_XFR_LED_MAP_PERIODS;
GL.GL_XFR_LED_MAP_PERIODS does not reference any database object
GL.GL_XFR_LED_MAP_PERIODS is referenced by following:
|
|
|