DP_PUBLISHNAMEBUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
PRODUCT_IDFORECAST_DATEY/N Table Edit
Default Value: Y
Y/N Table Edit
Default Value: Y
DP_FORECAST_PRD(SQL Table) |
Index Back |
|---|---|
Forecasts for Products10/20/97 SCC CN# PL750-DI-GPENN-66: Added Cycle_ID, Modifier, Time_Period_ID, Qty_Error (deviation). Also, make forecast_set, business_unit, product_id not required and remove search keys. Key fields will be set from selection criteria at save time. Made forecast_date and qty_forecast required. Moved product_id fed peoplecode to forecast_wrk.product_id fed. Removed business_unit SrI 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: Deleted CYCLE_ID, MODIFIER, QTY_ERROR and TIME_PERIOD_ID. 10/18/99 MACN CN#EN800-12.0 - Added pcode Fedit on QTY_FORECAST for qty precision check. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DP_PUBLISHNAME |
Character(20) | VARCHAR2(20) NOT NULL | Publish Name |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT |
| 3 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 4 | FORECAST_DATE |
Date(10) | DATE NOT NULL | Forecast Date |
| 5 | QTY_FORECAST | Number(16,4) | DECIMAL(15,4) NOT NULL | 11/01/01 PCL (CN#PL900-1): Added |
| 6 | NET_CHANGE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Production Planning Net Change
Y/N Table Edit Default Value: Y |
| 7 | NET_CHANGE_EP | Character(1) | VARCHAR2(1) NOT NULL |
Enterprise Planning Net Change
Y/N Table Edit Default Value: Y |
| 8 | DP_PUBLISH_DATE | Date(10) | DATE | DP_PUBLISH_DATE |