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	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	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. CS=Case EA=Each 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	This field is used for the percentage of kit value for VAT.
16	TEXT254	Character(254)	VARCHAR2(254) NOT NULL	Text
17	DATETIME_ADDED	DateTime(26)	TIMESTAMP	DateTime Added
18	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.
19	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	This field determines the last user or operator that last changed this item.