OPRIDPrompt Table: OPERATOR_VW
RUN_CNTL_IDPrompt Table: RSF_FCAST_AF1_V
Prompt Table: RSF_FCAST_AF_VW
R=Revenue Forecast
S=Shadow Forecast
A=All Sales Reps
M=My Sales Reps
N=No
Y=Yes
RSF_FCAST_RUN(SQL Table) |
Index Back |
|---|---|
RSF_AUTOFORECAST Run ControlRun Control record for Sales Auto Forecasts |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPERATOR_VW |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | FORECAST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Forecast Name
Prompt Table: RSF_FCAST_AF1_V |
| 4 | TIMEFRAME_PERIOD | Character(32) | VARCHAR2(32) NOT NULL |
Time Frame
Prompt Table: RSF_FCAST_AF_VW |
| 5 | FORECAST_CATEGORY | Character(1) | VARCHAR2(1) NOT NULL |
Forecast Category
R=Revenue Forecast S=Shadow Forecast |
| 6 | PERSON_ID_MANAGER | Character(15) | VARCHAR2(15) NOT NULL | Contact Identifier for Treasury Contacts |
| 7 | AUTOFORECAST_SCOPE | Character(1) | VARCHAR2(1) NOT NULL |
Auto Forecast Scope
A=All Sales Reps M=My Sales Reps |
| 8 | FORECAST_SUBMITTED | Character(1) | VARCHAR2(1) NOT NULL |
Submit status for forecast.
N=No Y=Yes |