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