RS_FCAST_VW(SQL View) |
Index Back |
---|---|
Sales Forecast ViewInput 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 |