APX2020_TMP

#	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	SetID
3	WTHD_ENTITY	Character(5)	VARCHAR2(5) NOT NULL	Withholding Entity
4	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
5	VENDOR_NAME_SHORT	Character(14)	VARCHAR2(14) NOT NULL	Short Vendor Name
6	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
7	VENDOR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Vendor Status A=Approved D=Denied E=Unapproved I=Inactive X=To Be Archived
8	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
9	WTHD_JUR_CD	Character(5)	VARCHAR2(5) NOT NULL	Withholding Jurisdiction
10	WTHD_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Withholding Type
11	DEFAULT_CLASS	Character(5)	VARCHAR2(5) NOT NULL	Default Withholding Class
12	VENDOR_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Vendor Category
13	WTHD_TYPE_G	Character(5)	VARCHAR2(5) NOT NULL	Withholding Type
14	WTHD_CLASS	Character(5)	VARCHAR2(5) NOT NULL	Withholding Class
15	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
16	SORT_SUPP	Character(4)	VARCHAR2(4) NOT NULL	Sort Ascending or Descending. ID=Supplier ID NA=Supplier Name