PL_PROD_OPTEDEL

(SQL Table)
Index Back

PL Prod Opt Effective Delete

10/29/01 EGS (CN#PL900-1): Added, delete table for PL_PROD_OPT_EFF.

# 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 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
5 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code
6 PRODUCTION_TYPE Character(2) VARCHAR2(2) NOT NULL JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production
RW=Rework
SV=Service
TD=Teardown
7 DATE_IN_EFFECT Date(10) DATE 01/27/2000 RML Added "As of date" label 03/23/2004 SFC Added PRICE_LIST_DATE label 06/04/2004 SFC Added PRODUCT_PRICE_DAT label
8 DATE_OBSOLETE Date(10) DATE Obsolete Date
9 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference