FORECAST_SETPrompt Table: FORECAST_SET
BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_OM_NONVW
PRODUCT_IDPrompt Table: PROD_ITEM_VW
FORECAST_DATEFCST_PROD_DEL(SQL Table) |
Index Back |
|---|---|
Deleted OM Forecast |
| # | 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_BU_OM_NONVW |
| 3 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Product ID
Prompt Table: PROD_ITEM_VW |
| 4 | FORECAST_DATE |
Date(10) | DATE | 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 |