VENDOR_ADDR_VW

(SQL View)
 Index Back

Vendor Address

Vendor Address.

SELECT A.SETID , A.VENDOR_ID , A.ADDRESS_SEQ_NUM , A.DESCR FROM PS_VNDR_ADDR_SCROL A , PS_VENDOR_ADDR B WHERE A.SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.ADDRESS_SEQ_NUM = B.ADDRESS_SEQ_NUM AND B.EFF_STATUS = 'A'

# 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