PL_FCST_TMP

(SQL Table)
Index Back

PL Opt Load: Temp Tbl for FCST

11/01/01 PCL (CN#PL900-1): Added

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
4 PLAN_END_DTTM DateTime(26) TIMESTAMP 08/29/01 EGS (CN#PL900-1): Added.
5 PL_SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL PL_SYSTEM_SOURCE
6 PLAN_START_DTTM DateTime(26) TIMESTAMP 08/29/01 EGS (CN#PL900-1): Added.
7 QTY_FORECAST Number(16,4) DECIMAL(15,4) NOT NULL 11/01/01 PCL (CN#PL900-1): Added
8 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference