FORECAST_CH_INV(SQL Table) |
Index Back |
|---|---|
Forecasts for Deleted ItemsDI-USER-1 ========= Done by Patrick Lerambert - 09/22/1997 Added new field NET_CHANGE_EP. ________________________________________________________ |
| # | 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: MST_ITM_PRPT_VW |
| 4 | FORECAST_DATE |
Date(10) | DATE | 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
Default Value: Y |