FORECAST_INV(SQL Table) |
Index Back |
|---|---|
Forecasts for Items10/20/97 SCC CN# PL750-DI-GPENN-66: Added Cycle_ID, Modifier, Time_Period_ID, Qty_Error (deviation). Also, make forecast_set, business_unit, inv_item_id not required and remove search key. Key fields will be set from selection criteria at save time. Made forecast_date and qty_forecast required. Moved inv_item_id fed peoplecode to forecast_wrk.inv_item_id fed. Removed business_unit SrI and SrS peoplecode since it's obsolete. 10/19/97 JNW CN# PL750-DI-GPENN-52: Added net_change_ep. 04/06/99 EGS CN# DI-SCHEW-143: Remove fields CYCLE_ID, MODIFIER, QTY_ERROR and TIME_PERIOD_ID 10/18/99 MACN CD#EN800-12.0 - Added pcode FEdit to QTY_FORECAST for qty precision check. |
| # | 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
Default Value: OPR_DEF_TBL_FS.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
Default Value: 8:00 AM |
| 6 | QTY_FORECAST | Number(16,4) | DECIMAL(15,4) NOT NULL | 11/01/01 PCL (CN#PL900-1): Added |
| 7 | NET_CHANGE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Production Planning Net Change
Y/N Table Edit Default Value: Y |
| 8 | NET_CHANGE_EP | Character(1) | VARCHAR2(1) NOT NULL |
Enterprise Planning Net Change
Y/N Table Edit Default Value: Y |
| 9 | DP_PUBLISHNAME | Character(20) | VARCHAR2(20) NOT NULL | Publish Name |
| 10 | DP_PUBLISH_DATE | Date(10) | DATE | DP_PUBLISH_DATE |