SF_VNDR_ADR_SCR (SQL Table)	Index Back
Vendor Address Scroll This is a new table that mirrors the AP Vendor Address Scroll table. It is used to control scroll level 1 on the Vendor Address panel since a table can only have one associated scroll bar. It acts as the parent to the Vendor Address record.

SF_VNDR_ADR_SCR

(SQL Table)

Vendor Address Scroll

This is a new table that mirrors the AP Vendor Address Scroll table. It is used to control scroll level 1 on the Vendor Address panel since a table can only have one associated scroll bar. It acts as the parent to the Vendor Address record.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

3 ADDRESS_SEQ_NUM Number(3,0) SMALLINT NOT NULL Address Sequence Number
Default Value: 1

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 VNDR_ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type
BUSN=Business
CLMS=Claims
CSRV=Customer Service
MAIL=Mailing
OTHR=Other
PREM=Premium Payment
RMIT=Remittance
Default Value: BUSN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
3	ADDRESS_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Address Sequence Number Default Value: 1
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	VNDR_ADDRESS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Address Type BUSN=Business CLMS=Claims CSRV=Customer Service MAIL=Mailing OTHR=Other PREM=Premium Payment RMIT=Remittance Default Value: BUSN