PRDKTCMP_UP_TAO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EIP_CTL_ID	Character(25)	VARCHAR2(25) NOT NULL	Enterprise Components EIP (enterprise integration point) control field
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	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
7	DATE_OBSOLETE	Date(10)	DATE	Obsolete Date
8	DTTM_IN_EFFECT	DateTime(26)	TIMESTAMP	Effective Date-Time
9	DTTM_OBSOLETE	DateTime(26)	TIMESTAMP	Obsolete Date-Time
10	QTY_PER	Number(10,4)	DECIMAL(9,4) NOT NULL	Quantity
11	QTY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Per ASY=Assembly ORD=Order Default Value: ASY
12	OPTIONAL_SHIP	Character(1)	VARCHAR2(1) NOT NULL	OK to Ship Without Y/N Table Edit Default Value: N
13	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
14	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Default Value: 1
15	VAT_KIT_PCT	Number(3,0)	SMALLINT NOT NULL	% of Kit Value for VAT
16	TEXT254	Character(254)	VARCHAR2(254) NOT NULL	Text
17	COMP_PRC_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Contract Price %
18	MAX_QTY_PER	Number(10,4)	DECIMAL(9,4) NOT NULL	Maximum allowable quantity for a kit component
19	MIN_QTY_PER	Number(10,4)	DECIMAL(9,4) NOT NULL	Minimum allowable quantity for a kit component
20	DATETIME_ADDED	DateTime(26)	TIMESTAMP	DateTime Added
21	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.
22	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID