PY_GARN_ADD_VW (SQL View)	Index Back
Garnishment Vndr Remit Address This view returns all remit address sequences for the remit vendor of the selected vendor location.

PY_GARN_ADD_VW

(SQL View)

Garnishment Vndr Remit Address

This view returns all remit address sequences for the remit vendor of the selected vendor location.

SELECT A.SETID , A.VENDOR_ID , A.VNDR_LOC , B.ADDRESS_SEQ_NUM , B.DESCR FROM PS_PY_GARN_LOC_VW A , PS_VNDR_ADDR_SCROL B WHERE A.SETID = B.SETID AND A.REMIT_VENDOR = B.VENDOR_ID

# 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 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

4 REMIT_ADDR_SEQ_NUM Number(3,0) SMALLINT NOT NULL Remitting Location

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

#	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	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
4	REMIT_ADDR_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Remitting Location
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description