RS_FCAST_VW

(SQL View)
 Index Back

Sales Forecast View

Input view for Sales Forecast ACE report.

SELECT J.PROBINST , A.FORECAST_ID , A.TIMEFRAME_PERIOD , A.FORECAST_CATEGORY , B.SALES_USER_NAME , B.FORECAST_DT , C.FORECAST_TYPE , G.TO_CUR , C.BUSINESS_UNIT , C.SALES_MODEL %Concat ' - ' %Concat C.SALES_STAGE , C.REGIONDESCR , C.TERRITORYDESCR , C.INDUSTRYDESCR , C.PRODGROUPDESCR , C.SYNCID , %Round(%DecMult(C.FROM_REVENUE, G.RATE_MULT),1) FROM PS_RSF_FCAST A , PS_RSF_FCAST_USER B , PS_RSF_FCAST_DTL C , PS_RSF_ACC_MGR_VW D , PS_RT_DFLT_VW G , PS_INSTALLATION H , PS_RSF_OPR_DEF_VW E , PS_RS_FCAST_INST J WHERE E.OPRID = J.OPRID AND G.EFFDT = ( SELECT MAX(G_ED.EFFDT) FROM PS_RT_DFLT_VW G_ED WHERE G.FROM_CUR = G_ED.FROM_CUR AND G.TO_CUR = G_ED.TO_CUR AND G.RT_TYPE = G_ED.RT_TYPE AND G_ED.EFFDT <= %CurrentDateIn) AND A.FORECAST_ID = B.FORECAST_ID AND A.TIMEFRAME_PERIOD = B.TIMEFRAME_PERIOD AND A.FORECAST_CATEGORY = B.FORECAST_CATEGORY AND B.FORECAST_ID = C.FORECAST_ID AND B.TIMEFRAME_PERIOD = C.TIMEFRAME_PERIOD AND B.FORECAST_CATEGORY = C.FORECAST_CATEGORY AND B.PERSON_ID = C.PERSON_ID AND C.PERSON_ID_ADJUSTBY = D.PERSON_ID AND H.DEF_CUR_RT_TYPE = G.RT_TYPE AND G.FROM_CUR = C.FROM_CUR AND G.TO_CUR = J.TO_CUR AND D.PERSON_ID_MANAGER = E.PERSON_ID AND A.TIMEFRAME_PERIOD = J.TIMEFRAME_PERIOD AND A.FORECAST_ID = J.FORECAST_ID AND A.FORECAST_CATEGORY = J.FORECAST_CATEGORY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
2 FORECAST_ID Character(15) VARCHAR2(15) NOT NULL Forecast Name

Prompt Table: RSF_FCAST_ID

3 TIMEFRAME_PERIOD Character(32) VARCHAR2(32) NOT NULL Time Frame

Prompt Table: %EDITTABLE

4 FORECAST_CATEGORY Character(1) VARCHAR2(1) NOT NULL Forecast Category
R=Revenue Forecast
S=Shadow Forecast
5 SALES_USER_NAME Character(50) VARCHAR2(50) NOT NULL Sales User Name field
6 FORECAST_DT Date(10) DATE Date when forecast. The date the entire forecast was begun does not change, but the date per user does change with updates.
7 FORECAST_TYPE Character(10) VARCHAR2(10) NOT NULL Type of forecast, eg 'Open' or 'closed'
8 TO_CUR Character(3) VARCHAR2(3) NOT NULL To Currency Code
9 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
10 CR_MODEL_NAME Character(254) VARCHAR2(254) NOT NULL BAM Installation: Fully qualified file path for template model (mdl).
11 REGIONDESCR Character(30) VARCHAR2(30) NOT NULL Description
12 TERRITORYDESCR Character(30) VARCHAR2(30) NOT NULL Description
13 INDUSTRYDESCR Character(50) VARCHAR2(50) NOT NULL Description
14 PRODGROUPDESCR Character(30) VARCHAR2(30) NOT NULL Description
15 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
16 FCAST_TOTAL Number(27,2) DECIMAL(26,2) NOT NULL Total