[Home] [Help] [Dependency Information]
Object Name: | FII_GL_SNAP_SUM_F |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.FII_GL_SNAP_SUM_F |
Subobject Name: | |
Status: | VALID |
This table stores aggregated snapshot data of sysdate from FII_GL_SNAP_F via Financial Category, Company, Cost Center, User Defined 1 dimensions
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FII_GL_SNAP_SUM_F_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PARENT_COMPANY_DIM_ID
COMPANY_DIM_ID PARENT_COST_CENTER_DIM_ID COST_CENTER_DIM_ID PARENT_FIN_CATEGORY_ID FIN_CATEGORY_ID PARENT_USER_DIM1_ID USER_DIM1_ID USER_DIM2_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COST_CENTER_DIM_ID | NUMBER | (15) | Cost center dimension identifier | |
PARENT_COST_CENTER_DIM_ID | NUMBER | (15) | Parent cost center dimension identifier | |
COMPANY_DIM_ID | NUMBER | (15) | Company dimension identifier | |
PARENT_COMPANY_DIM_ID | NUMBER | (15) | Parent company dimension identifier | |
FIN_CATEGORY_ID | NUMBER | (15) | Financial Category Identifier | |
PARENT_FIN_CATEGORY_ID | NUMBER | (15) | Parent financial category identifier | |
USER_DIM1_ID | NUMBER | (15) | User dimension1 identifier | |
PARENT_USER_DIM1_ID | NUMBER | (15) | Parent user 1 dimension identifier | |
USER_DIM2_ID | NUMBER | (15) | User dimension 2 identifier | |
LEDGER_ID | NUMBER | (15) | Ledger identifier | |
ACTUAL_B_CUR_MTD | NUMBER | Current month to date actual amount in base currency | ||
ACTUAL_B_CUR_QTD | NUMBER | Current quarter to date actual amount in base currency | ||
ACTUAL_B_CUR_YTD | NUMBER | Current year to date actual amount in base currency | ||
ACTUAL_B_PRIOR_MTD | NUMBER | Prior month to date actual amount in base currency | ||
ACTUAL_B_PRIOR_QTD | NUMBER | Prior quarter to date actual amount in base currency | ||
ACTUAL_B_PRIOR_YTD | NUMBER | Prior year to date actual amount in base currency | ||
ACTUAL_B_LAST_YEAR_MTD | NUMBER | Last year month to date actual amount in base currency | ||
ACTUAL_B_LAST_YEAR_QTD | NUMBER | Last year quarter to date actual amount in base currency | ||
ACTUAL_PG_CUR_MTD | NUMBER | Current month to date actual amount in primary currency | ||
ACTUAL_PG_CUR_QTD | NUMBER | Current quarter to date actual amount in primary currency | ||
ACTUAL_PG_CUR_YTD | NUMBER | Current year to date actual amount in primary currency | ||
ACTUAL_PG_PRIOR_MTD | NUMBER | Prior month to date actual amount in primary currency | ||
ACTUAL_PG_PRIOR_QTD | NUMBER | Prior quarter to date actual amount in primary currency | ||
ACTUAL_PG_PRIOR_YTD | NUMBER | Prior year to date actual amount in primary currency | ||
ACTUAL_PG_LAST_YEAR_MTD | NUMBER | Last year month to date actual amount in primary currency | ||
ACTUAL_PG_LAST_YEAR_QTD | NUMBER | Last year quarter to date actual amount in primary currency | ||
ACTUAL_SG_CUR_MTD | NUMBER | Current month to date actual amount in secondary currency | ||
ACTUAL_SG_CUR_QTD | NUMBER | Current quarter to date actual amount in secondary currency | ||
ACTUAL_SG_CUR_YTD | NUMBER | Current year to date actual amount in secondary currency | ||
ACTUAL_SG_PRIOR_MTD | NUMBER | Prior month to date actual amount in secondary currency | ||
ACTUAL_SG_PRIOR_QTD | NUMBER | Prior quarter to date actual amount in secondary currency | ||
ACTUAL_SG_PRIOR_YTD | NUMBER | Prior year to date actual amount in secondary currency | ||
ACTUAL_SG_LAST_YEAR_MTD | NUMBER | Last year month to date actual amount in secondary currency | ||
ACTUAL_SG_LAST_YEAR_QTD | NUMBER | Last year quarter to date actual amount in secondary currency | ||
BUDGET_PG_CUR_MTD | NUMBER | Current month to date budget amount in primary currency | ||
BUDGET_PG_CUR_QTD | NUMBER | Current quarter to date budget amount in primary currency | ||
BUDGET_PG_CUR_YTD | NUMBER | Current year to date budget amount in primary currency | ||
BUDGET_PG_PRIOR_MTD | NUMBER | Prior month to date budget amount in primary currency | ||
BUDGET_PG_PRIOR_QTD | NUMBER | Prior quarter to date budget amount in primary currency | ||
BUDGET_PG_PRIOR_YTD | NUMBER | Prior year to date budget amount in primary currency | ||
BUDGET_PG_LAST_YEAR_MTD | NUMBER | Last year month to date budget amount in primary currency | ||
BUDGET_PG_LAST_YEAR_QTD | NUMBER | Last year qurater to date budget amount in primary currency | ||
BUDGET_SG_CUR_MTD | NUMBER | Current month to date budget amount in secondary currency | ||
BUDGET_SG_CUR_QTD | NUMBER | Current quarter to date budget amount in secondary currency | ||
BUDGET_SG_CUR_YTD | NUMBER | Current year to date budget amount in secondary currency | ||
BUDGET_SG_PRIOR_MTD | NUMBER | Prior month to date budget amount in secondary currency | ||
BUDGET_SG_PRIOR_QTD | NUMBER | Prior quarter to date budget amount in secondary currency | ||
BUDGET_SG_PRIOR_YTD | NUMBER | Prior year to date budget amount in secondary currency | ||
BUDGET_SG_LAST_YEAR_MTD | NUMBER | Last year month to date budget amount in secondary currency | ||
BUDGET_SG_LAST_YEAR_QTD | NUMBER | Last year quarter to date budget amount in secondary currency | ||
FORECAST_PG_CUR_MTD | NUMBER | Current month to date forecast amount in primary currency | ||
FORECAST_PG_CUR_QTD | NUMBER | Current quarter to date forecast amount in primary currency | ||
FORECAST_PG_CUR_YTD | NUMBER | Current year to date forecast amount in primary currency | ||
FORECAST_PG_PRIOR_MTD | NUMBER | Prior month to date forecast amount in primary currency | ||
FORECAST_PG_PRIOR_QTD | NUMBER | Prior quarter to date forecast amount in primary currency | ||
FORECAST_PG_PRIOR_YTD | NUMBER | Prior year to date forecast amount in primary currency | ||
FORECAST_PG_LAST_YEAR_MTD | NUMBER | Last year month to date forecast amount in primary currency | ||
FORECAST_PG_LAST_YEAR_QTD | NUMBER | Last year quarter to date forecast amount in primary currency | ||
FORECAST_SG_CUR_MTD | NUMBER | Current month to date forecast amount in secondary currency | ||
FORECAST_SG_CUR_QTD | NUMBER | Current quarter to date forecast amount in secondary currency | ||
FORECAST_SG_CUR_YTD | NUMBER | Current year to date forecast amount in secondary currency | ||
FORECAST_SG_PRIOR_MTD | NUMBER | Prior month to date forecast amount in secondary currency | ||
FORECAST_SG_PRIOR_QTD | NUMBER | Prior quarter to date forecast amount in secondary currency | ||
FORECAST_SG_PRIOR_YTD | NUMBER | Prior year to date forecast amount in secondary currency | ||
FORECAST_SG_LAST_YEAR_MTD | NUMBER | Last year month to date forecast amount in secondary currency | ||
FORECAST_SG_LAST_YEAR_QTD | NUMBER | Last year quarter to date forecast amount in secondary currency | ||
LAST_UPDATE_DATE | DATE | Yes | Standard who columns | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who columns |
CREATION_DATE | DATE | Yes | Standard who columns | |
CREATED_BY | NUMBER | (15) | Yes | Standard who columns |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who columns | |
COMMITTED_AMT_PG_CUR_MTD | NUMBER | Current month to date committed amount in primary currency | ||
COMMITTED_AMT_PG_CUR_QTD | NUMBER | Current quarter to date committed amount in primary currency | ||
COMMITTED_AMT_PG_CUR_YTD | NUMBER | Current year to date committed amount in primary currency | ||
COMMITTED_AMT_PG_PRIOR_MTD | NUMBER | Prior month to date committed amount in primary currency | ||
COMMITTED_AMT_PG_PRIOR_QTD | NUMBER | Prior quarter to date committed amount in primary currency | ||
COMMITTED_AMT_PG_PRIOR_YTD | NUMBER | Prior year to date committed amount in primary currency | ||
COMMITTED_AMT_PG_LAST_YEAR_MTD | NUMBER | Last year month to date committed amount in primary currency | ||
COMMITTED_AMT_PG_LAST_YEAR_QTD | NUMBER | Last year quarter to date committed amount in primary currency | ||
OBLIGATED_AMT_PG_CUR_MTD | NUMBER | Current month to date obligated amount in primary currency | ||
OBLIGATED_AMT_PG_CUR_QTD | NUMBER | Current quarter to date obligated amount in primary currency | ||
OBLIGATED_AMT_PG_CUR_YTD | NUMBER | Current year to date obligated amount in primary currency | ||
OBLIGATED_AMT_PG_PRIOR_MTD | NUMBER | Prior month to date obligated amount in primary currency | ||
OBLIGATED_AMT_PG_PRIOR_QTD | NUMBER | Prior quarter to date obligated amount in primary currency | ||
OBLIGATED_AMT_PG_PRIOR_YTD | NUMBER | Prior year to date obligated amount in primary currency | ||
OBLIGATED_AMT_PG_LAST_YEAR_MTD | NUMBER | Last year month to date obligated amount in primary currency | ||
OBLIGATED_AMT_PG_LAST_YEAR_QTD | NUMBER | Last year quarter to date obligated amount in primary currency | ||
OTHER_AMT_PG_CUR_MTD | NUMBER | Current month to date other amount in primary currency | ||
OTHER_AMT_PG_CUR_QTD | NUMBER | Current quarter to date other amount in primary currency | ||
OTHER_AMT_PG_CUR_YTD | NUMBER | Current year to date other amount in primary currency | ||
OTHER_AMT_PG_PRIOR_MTD | NUMBER | Prior month to date other amount in primary currency | ||
OTHER_AMT_PG_PRIOR_QTD | NUMBER | Prior quarter to date other amount in primary currency | ||
OTHER_AMT_PG_PRIOR_YTD | NUMBER | Prior year to date other amount in primary currency | ||
OTHER_AMT_PG_LAST_YEAR_MTD | NUMBER | Last year month to date other amount in primary currency | ||
OTHER_AMT_PG_LAST_YEAR_QTD | NUMBER | Last year quarter to date other amount in primary currency | ||
BASELINE_AMT_PG_CUR_MTD | NUMBER | Current month to date baseline amount in primary currency | ||
BASELINE_AMT_PG_CUR_QTD | NUMBER | Current quarter to date baseline amount in primary currency | ||
BASELINE_AMT_PG_CUR_YTD | NUMBER | Current year to date baseline amount in primary currency | ||
BASELINE_AMT_PG_PRIOR_MTD | NUMBER | Prior month to date baseline amount in primary currency | ||
BASELINE_AMT_PG_PRIOR_QTD | NUMBER | Current quarter to date baseline amount in primary currency | ||
BASELINE_AMT_PG_PRIOR_YTD | NUMBER | Current year to date baseline amount in primary currency | ||
BASELINE_AMT_PG_LAST_YEAR_MTD | NUMBER | Last year month to date baseline amount in primary currency | ||
BASELINE_AMT_PG_LAST_YEAR_QTD | NUMBER | Last year quarter to date baseline amount in primary currency | ||
POSTED_DATE | DATE | Posted date |
Cut, paste (and edit) the following text to query this object:
SELECT COST_CENTER_DIM_ID
, PARENT_COST_CENTER_DIM_ID
, COMPANY_DIM_ID
, PARENT_COMPANY_DIM_ID
, FIN_CATEGORY_ID
, PARENT_FIN_CATEGORY_ID
, USER_DIM1_ID
, PARENT_USER_DIM1_ID
, USER_DIM2_ID
, LEDGER_ID
, ACTUAL_B_CUR_MTD
, ACTUAL_B_CUR_QTD
, ACTUAL_B_CUR_YTD
, ACTUAL_B_PRIOR_MTD
, ACTUAL_B_PRIOR_QTD
, ACTUAL_B_PRIOR_YTD
, ACTUAL_B_LAST_YEAR_MTD
, ACTUAL_B_LAST_YEAR_QTD
, ACTUAL_PG_CUR_MTD
, ACTUAL_PG_CUR_QTD
, ACTUAL_PG_CUR_YTD
, ACTUAL_PG_PRIOR_MTD
, ACTUAL_PG_PRIOR_QTD
, ACTUAL_PG_PRIOR_YTD
, ACTUAL_PG_LAST_YEAR_MTD
, ACTUAL_PG_LAST_YEAR_QTD
, ACTUAL_SG_CUR_MTD
, ACTUAL_SG_CUR_QTD
, ACTUAL_SG_CUR_YTD
, ACTUAL_SG_PRIOR_MTD
, ACTUAL_SG_PRIOR_QTD
, ACTUAL_SG_PRIOR_YTD
, ACTUAL_SG_LAST_YEAR_MTD
, ACTUAL_SG_LAST_YEAR_QTD
, BUDGET_PG_CUR_MTD
, BUDGET_PG_CUR_QTD
, BUDGET_PG_CUR_YTD
, BUDGET_PG_PRIOR_MTD
, BUDGET_PG_PRIOR_QTD
, BUDGET_PG_PRIOR_YTD
, BUDGET_PG_LAST_YEAR_MTD
, BUDGET_PG_LAST_YEAR_QTD
, BUDGET_SG_CUR_MTD
, BUDGET_SG_CUR_QTD
, BUDGET_SG_CUR_YTD
, BUDGET_SG_PRIOR_MTD
, BUDGET_SG_PRIOR_QTD
, BUDGET_SG_PRIOR_YTD
, BUDGET_SG_LAST_YEAR_MTD
, BUDGET_SG_LAST_YEAR_QTD
, FORECAST_PG_CUR_MTD
, FORECAST_PG_CUR_QTD
, FORECAST_PG_CUR_YTD
, FORECAST_PG_PRIOR_MTD
, FORECAST_PG_PRIOR_QTD
, FORECAST_PG_PRIOR_YTD
, FORECAST_PG_LAST_YEAR_MTD
, FORECAST_PG_LAST_YEAR_QTD
, FORECAST_SG_CUR_MTD
, FORECAST_SG_CUR_QTD
, FORECAST_SG_CUR_YTD
, FORECAST_SG_PRIOR_MTD
, FORECAST_SG_PRIOR_QTD
, FORECAST_SG_PRIOR_YTD
, FORECAST_SG_LAST_YEAR_MTD
, FORECAST_SG_LAST_YEAR_QTD
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, COMMITTED_AMT_PG_CUR_MTD
, COMMITTED_AMT_PG_CUR_QTD
, COMMITTED_AMT_PG_CUR_YTD
, COMMITTED_AMT_PG_PRIOR_MTD
, COMMITTED_AMT_PG_PRIOR_QTD
, COMMITTED_AMT_PG_PRIOR_YTD
, COMMITTED_AMT_PG_LAST_YEAR_MTD
, COMMITTED_AMT_PG_LAST_YEAR_QTD
, OBLIGATED_AMT_PG_CUR_MTD
, OBLIGATED_AMT_PG_CUR_QTD
, OBLIGATED_AMT_PG_CUR_YTD
, OBLIGATED_AMT_PG_PRIOR_MTD
, OBLIGATED_AMT_PG_PRIOR_QTD
, OBLIGATED_AMT_PG_PRIOR_YTD
, OBLIGATED_AMT_PG_LAST_YEAR_MTD
, OBLIGATED_AMT_PG_LAST_YEAR_QTD
, OTHER_AMT_PG_CUR_MTD
, OTHER_AMT_PG_CUR_QTD
, OTHER_AMT_PG_CUR_YTD
, OTHER_AMT_PG_PRIOR_MTD
, OTHER_AMT_PG_PRIOR_QTD
, OTHER_AMT_PG_PRIOR_YTD
, OTHER_AMT_PG_LAST_YEAR_MTD
, OTHER_AMT_PG_LAST_YEAR_QTD
, BASELINE_AMT_PG_CUR_MTD
, BASELINE_AMT_PG_CUR_QTD
, BASELINE_AMT_PG_CUR_YTD
, BASELINE_AMT_PG_PRIOR_MTD
, BASELINE_AMT_PG_PRIOR_QTD
, BASELINE_AMT_PG_PRIOR_YTD
, BASELINE_AMT_PG_LAST_YEAR_MTD
, BASELINE_AMT_PG_LAST_YEAR_QTD
, POSTED_DATE
FROM FII.FII_GL_SNAP_SUM_F;
FII.FII_GL_SNAP_SUM_F does not reference any database object
FII.FII_GL_SNAP_SUM_F is referenced by following:
|
|
|