FORECAST_ID_SUPPROJ_ROLERS_SNR_ROLE_REG(SQL View) |
Index Back |
|---|
| SELECT FORECAST_ID_SUP , PROJ_ROLE , SETID_REGION , REGION_CD , DATE_ENTERED , CAPACITY FROM PS_RS_FR_SUP_CACH |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FORECAST_ID_SUP |
Character(15) | VARCHAR2(15) NOT NULL | Supply Forecast ID |
| 2 | PROJ_ROLE |
Character(15) | VARCHAR2(15) NOT NULL | Project Role |
| 3 | SETID_REGION | Character(5) | VARCHAR2(5) NOT NULL | Region SetID |
| 4 | REGION_CD | Character(10) | VARCHAR2(10) NOT NULL | Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to. |
| 5 | DATE_ENTERED | Date(10) | DATE | Date |
| 6 | CAPACITY | Signed Number(14,2) | DECIMAL(12,2) NOT NULL | SCP- Forecasted Supply stored as capacity. |