KITCMPRC_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	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
5	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value.
7	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
8	PROD_COMPONENT_ID	Character(18)	VARCHAR2(18) NOT NULL	Field is used to store components of a product
9	DATE_IN_EFFECT	Date(10)	DATE	01/27/2000 RML Added "As of date" label
10	PRODKIT_COMP_PRICE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Product Kit Component Price
11	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
12	DATE_OBSOLETE	Date(10)	DATE	Obsolete Date
13	DATETIME_ADDED	DateTime(26)	TIMESTAMP	DateTime Added
14	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.
15	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	This field determines the last user or operator that last changed this item.