PV_ATTR_LOAD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
2	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
3	ATTRNAME	Character(30)	VARCHAR2(30) NOT NULL	Pub/Sub Attribute Name
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	PV_CP_SPN	Character(50)	VARCHAR2(50) NOT NULL	Supplier Part Number
6	PV_CP_PART_EXT	Character(50)	VARCHAR2(50) NOT NULL	CUP Part Extension
7	MFG_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer ID
8	MFG_ITM_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer's Item ID Prompt Table: ITEM_MFG_ID_VW
9	CATEGORY_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Category Type PSF=User Def UNS=UN/SPSC
10	CATEGORY_CD	Character(18)	VARCHAR2(18) NOT NULL	Category Code
11	CATEGORY_ID	Character(5)	VARCHAR2(5) NOT NULL	Category ID
12	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
13	ATTRVALUE	Character(30)	VARCHAR2(30) NOT NULL	Pub/Sub Attribute Value
14	PV_ATTRVALUE	Signed Number(14,2)	DECIMAL(12,2) NOT NULL	This is price per unit for calculating the service charge.
15	UOM_ATTR	Character(3)	VARCHAR2(3) NOT NULL	Attribute Unit of Measure Prompt Table: UNITS_TBL
16	FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag N=No Y=Yes Y/N Table Edit
17	PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Processed Flag
18	ERROR_MESSAGE	Character(254)	VARCHAR2(254) NOT NULL	For Standard Journal (SJE)
19	ERROR_VALUE	Character(1)	VARCHAR2(1) NOT NULL	Error Status value