VNDR_HADDR_LVW (SQL View)	Index Back
Active Supplier Addresses View of supplier addresses that are active - used for prompting

VNDR_HADDR_LVW

(SQL View)

Active Supplier Addresses

View of supplier addresses that are active - used for prompting

SELECT A.SETID , A.ADDRESS_SEQ_NUM , A.VENDOR_ID , C.LANGUAGE_CD , A.EMAILID , %subrec(ADDRESS_SBR, C) FROM PS_VENDOR_ADDR A , PS_VENDOR_ADDR_LNG C WHERE A.SETID = C.SETID AND A.ADDRESS_SEQ_NUM = C.ADDRESS_SEQ_NUM AND A.VENDOR_ID = C.VENDOR_ID AND A.EFFDT = C.EFFDT AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_VENDOR_ADDR B WHERE B.SETID = A.SETID AND B.VENDOR_ID = A.VENDOR_ID AND B.ADDRESS_SEQ_NUM = A.ADDRESS_SEQ_NUM AND B.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

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

4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

5 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address

6 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

7 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

8 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2

9 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3

10 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4

11 CITY Character(30) VARCHAR2(30) NOT NULL City

12 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1

13 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2

14 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer

15 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1

16 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2

17 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3

18 COUNTY Character(30) VARCHAR2(30) NOT NULL County

19 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: %EDIT_STATE

20 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

21 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code

22 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
Y/N Table Edit

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
3	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
6	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
7	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
8	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
9	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
10	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
11	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
12	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
13	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
14	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat WW=Trailer
15	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
16	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
17	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
18	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
19	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: %EDIT_STATE
20	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
21	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
22	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit