PRDKTCMP_UP_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
3	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
4	PROD_COMPONENT_ID	Character(18)	VARCHAR2(18) NOT NULL	Field is used to store components of a product
5	DATE_IN_EFFECT	Date(10)	DATE	01/27/2000 RML Added "As of date" label
6	DATE_OBSOLETE	Date(10)	DATE	Obsolete Date
7	DTTM_IN_EFFECT	DateTime(26)	TIMESTAMP	Effective Date-Time
8	DTTM_OBSOLETE	DateTime(26)	TIMESTAMP	Obsolete Date-Time
9	QTY_PER	Number(10,4)	DECIMAL(9,4) NOT NULL	Quantity
10	QTY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Per ASY=Assembly ORD=Order Default Value: ASY
11	OPTIONAL_SHIP	Character(1)	VARCHAR2(1) NOT NULL	OK to Ship Without Default Value: N
12	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. CS=Case EA=Each MHR=Muti Hourly PER=Percentage SQF=Square Footage
13	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Default Value: 1
14	VAT_KIT_PCT	Number(3,0)	SMALLINT NOT NULL	This field is used for the percentage of kit value for VAT.
15	MIN_QTY	Number(10,4)	DECIMAL(9,4) NOT NULL	Minimum Quantity
16	MAX_QTY	Number(10,4)	DECIMAL(9,4) NOT NULL	Maximum Quantity
17	TEXT254	Character(254)	VARCHAR2(254) NOT NULL	Text
18	DATETIME_ADDED	DateTime(26)	TIMESTAMP	DateTime Added
19	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
20	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	This field determines the last user or operator that last changed this item.