INV_CUST_ADR_VW

(SQL View)
 Index Back

Ship-To Cust Address - IN

Defines the customer addresses used to identify a particular route stop number on the Route Stop Assignment Panel.

select b.setid, b.cust_id, b.address_seq_num, effdt, eff_status, b.address1, b.address2, b.address3, b.address4, b.city, b.state, b.postal, b.county, b.country from ps_cust_addr_seq a, PS_CUST_ADDRESS b where a.setid=b.setid and a.cust_id=b.cust_id and a.address_seq_num=b.address_seq_num and a.ship_to_addr='Y' 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 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
3 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
4 EFFDT Date(10) DATE Effective Date
5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
6 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
7 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
8 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
9 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
10 CITY Character(30) VARCHAR2(30) NOT NULL City
11 STATE Character(6) VARCHAR2(6) NOT NULL State
12 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
13 COUNTY Character(30) VARCHAR2(30) NOT NULL County
14 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country