PV_DELV_ADDR_VW

(SQL View)
 Index Back

ePro Delivery details view


SELECT D.BUSINESS_UNIT , D.RECEIVER_ID , D.RECV_LN_NBR , D.RECV_SHIP_SEQ_NBR , D.DISTRIB_LINE_NUM , D.LOCATION , L.DESCR , %subrec(ADDRESS_SBR,L) , %subrec(BUS_PHONE_SBR,L) , L.BUILDING , L.FLOOR , L.SECTOR , L.JURISDICTION FROM PS_RECV_LN_DISTRIB D , PS_LOCATION_TBL L WHERE D.LOCATION = L.LOCATION AND L.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_LOCATION_TBL B WHERE B.SETID = L.SETID AND B.LOCATION = L.LOCATION AND B.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
2 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
3 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
4 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
5 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
6 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_VW

7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
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 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
13 CITY Character(30) VARCHAR2(30) NOT NULL City
14 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
15 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
16 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer
17 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
18 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
19 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
20 COUNTY Character(30) VARCHAR2(30) NOT NULL County
21 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: %EDIT_STATE

22 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
23 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
24 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

25 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix
26 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
27 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension
28 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
29 BUILDING Character(10) VARCHAR2(10) NOT NULL Building #
30 FLOOR Character(10) VARCHAR2(10) NOT NULL Floor #
31 SECTOR Character(10) VARCHAR2(10) NOT NULL Sector
32 JURISDICTION Character(5) VARCHAR2(5) NOT NULL Jurisdiction