PL_FORECAST_TMP

(SQL Table)
Index Back

Forecasts for Items/Products

SCC 03/10/97 CN# PL601-5.8: New temporary record that holds forecasts for products (forecast_prod) and forecasts for items (forecast_inv). Used in datalink.

# 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_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

Prompt Table: SP_BUIN_NONVW

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_OM_NONVW

4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
5 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: PROD_ITEM_VW

6 FORECAST_DATE Date(10) DATE Forecast Date
7 QTY_FORECAST Number(16,4) DECIMAL(15,4) NOT NULL 11/01/01 PCL (CN#PL900-1): Added
8 NET_CHANGE_FLG Character(1) VARCHAR2(1) NOT NULL Production Planning Net Change

Y/N Table Edit

Default Value: N

9 NET_CHANGE_EP Character(1) VARCHAR2(1) NOT NULL Enterprise Planning Net Change

Y/N Table Edit

Default Value: N