[Home] [Help] [Dependency Information]
Object Name: | JL_ZZ_GL_AXI_TMP |
---|---|
Object Type: | TABLE |
Owner: | JL |
FND Design Data: | JL.JL_ZZ_GL_AXI_TMP |
Subobject Name: | |
Status: | VALID |
JL_ZZ_GL_AXI_TMP stores information used to issue the inflation adjustment report. The Inflation Adjustment process inserts data into this table.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JL_ZZ_GL_AXI_TMP_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE |
PERIOD_FROM
CODE_COMBINATION_ID AXI_RUN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CODE_COMBINATION_ID | NUMBER | (15) | Yes | Accounting flexfield combination defining column |
AXI_RUN_ID | NUMBER | (15) | Yes | Adjustment process execution identifier |
GROUP_ID | NUMBER | (15) | Journal import group identifier | |
PERIOD_FROM | VARCHAR2 | (15) | Inflation adjusted from period | |
PERIOD_TO | VARCHAR2 | (15) | Inflation adjusted to period | |
YTD_BALANCE | NUMBER | Year to date balance | ||
PTD_BALANCE | NUMBER | Period to date balance | ||
ADJUSTMENT_AMOUNT | NUMBER | Adjustment resulting from the Inflation Adjustment process | ||
FV_FLAG | VARCHAR2 | (1) | Flags is 'Y' if the adjustment process found an Inflation adjustment date (Fecha Valor), else it stores 'N' |
Cut, paste (and edit) the following text to query this object:
SELECT CODE_COMBINATION_ID
, AXI_RUN_ID
, GROUP_ID
, PERIOD_FROM
, PERIOD_TO
, YTD_BALANCE
, PTD_BALANCE
, ADJUSTMENT_AMOUNT
, FV_FLAG
FROM JL.JL_ZZ_GL_AXI_TMP;
JL.JL_ZZ_GL_AXI_TMP does not reference any database object
JL.JL_ZZ_GL_AXI_TMP is referenced by following:
|
|
|