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	SetID
3	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
4	PROD_COMPONENT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product Component ID
5	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
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. 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	% of Kit Value for VAT
15	TEXT254	Character(254)	VARCHAR2(254) NOT NULL	Text
16	COMP_PRC_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Contract Price %
17	MAX_QTY_PER	Number(10,4)	DECIMAL(9,4) NOT NULL	Maximum allowable quantity for a kit component
18	MIN_QTY_PER	Number(10,4)	DECIMAL(9,4) NOT NULL	Minimum allowable quantity for a kit component
19	DATETIME_ADDED	DateTime(26)	TIMESTAMP	DateTime Added
20	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.
21	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID