FORECAST_SETPrompt Table: FORECAST_SET
BUSINESS_UNITPrompt Table: SP_BUIN_NONVW
INV_ITEM_IDPrompt Table: PL_FCST_ITM_VW
FORECAST_DATEFORECAST_TIMEAPS_FORECAST_VW(SQL View) |
Index Back |
|---|---|
APS Integ Forecast View |
| SELECT F.FORECAST_SET , F.BUSINESS_UNIT , F.INV_ITEM_ID , F.FORECAST_DATE , F.FORECAST_TIME , F.QTY_FORECAST , I.ITM_SETID FROM PS_FORECAST_INV F , PS_APS_ITEM_BU_VW I WHERE I.BUSINESS_UNIT = F.BUSINESS_UNIT AND I.INV_ITEM_ID = F.INV_ITEM_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FORECAST_SET |
Character(20) | VARCHAR2(20) NOT NULL |
Forecast Set
Prompt Table: FORECAST_SET |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUIN_NONVW |
| 3 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: PL_FCST_ITM_VW |
| 4 | FORECAST_DATE |
Date(10) | DATE NOT NULL | Forecast Date |
| 5 | FORECAST_TIME |
Time(15) | TIMESTAMP | Forecast Time |
| 6 | QTY_FORECAST | Number(16,4) | DECIMAL(15,4) NOT NULL | 11/01/01 PCL (CN#PL900-1): Added |
| 7 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |