SPF_SUGST_VNDOR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	SP_REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Service Request ID
3	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
4	VENDOR_NAME1	Character(40)	VARCHAR2(40) NOT NULL	Vendor Name1
5	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	The individual contact name associated with a given bank/counterparty.
6	SRV_PRV_NAME	Character(40)	VARCHAR2(40) NOT NULL	Service provider name
7	SP_CONTRACT	Character(1)	VARCHAR2(1) NOT NULL	Contract Y/N Table Edit Default Value: N
8	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
9	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
10	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
11	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
12	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
13	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
14	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
15	PHONE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Phone Type BUSN=Business Phone CAMP=Campus Phone CELL=Cellular Phone DORM=Dormitory Phone FAX=FAX HOME=Home Phone MAIN=Main OTR=Other PGR1=Pager 1 PGR2=Pager 2 TELX=Telex
16	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Int'l Prefix
17	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
18	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	Phone Extension
19	SP_NOTIFY	Character(1)	VARCHAR2(1) NOT NULL	Field to indicate notification status N=No Y=Yes Y/N Table Edit Default Value: N
20	SP_NOTIFY_DATE	DateTime(26)	TIMESTAMP	Notification Date Default Value: %datetime
21	COMMENTS	Long Character	CLOB	Comment