[Home] [Help]
View: FII_GL_SNAP_F_S_V
Product: | FII - Financial Intelligence (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT COST_CENTER_DIM_ID
, COMPANY_DIM_ID
, FIN_CATEGORY_ID
, 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_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_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_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
, POSTED_DATE
FROM FII_GL_SNAP_F
Columns
Name |
COST_CENTER_ID |
COMPANY_ID |
FIN_CATEGORY_ID |
FUD1_ID |
FUD2_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_CUR_MTD |
ACTUAL_CUR_QTD |
ACTUAL_CUR_YTD |
ACTUAL_PRIOR_MTD |
ACTUAL_PRIOR_QTD |
ACTUAL_PRIOR_YTD |
ACTUAL_LAST_YEAR_MTD |
ACTUAL_LAST_YEAR_QTD |
BUDGET_CUR_MTD |
BUDGET_CUR_QTD |
BUDGET_CUR_YTD |
BUDGET_PRIOR_MTD |
BUDGET_PRIOR_QTD |
BUDGET_PRIOR_YTD |
BUDGET_LAST_YEAR_MTD |
BUDGET_LAST_YEAR_QTD |
FORECAST_CUR_MTD |
FORECAST_CUR_QTD |
FORECAST_CUR_YTD |
FORECAST_PRIOR_MTD |
FORECAST_PRIOR_QTD |
FORECAST_PRIOR_YTD |
FORECAST_LAST_YEAR_MTD |
FORECAST_LAST_YEAR_QTD |
POSTED_DATE |