PRD_PRCE_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	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
9	LIST_PRICE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	List Price
10	UNIT_COST	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Unit Cost
11	SERVICE_COST	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Service Cost
12	REPAIR_COST	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Repair Cost
13	MFG_SUG_RTL_PRC	Number(16,4)	DECIMAL(15,4) NOT NULL	Manufactures's Suggested Retai
14	PRICING_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Pricing Flag C=Cost L=List Price
15	DATETIME_ADDED	DateTime(26)	TIMESTAMP	DateTime Added
16	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.
17	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	This field determines the last user or operator that last changed this item.