SHIPTO_ADDR_VW3

(SQL View)
 Index Back

Shipping Address View

Ship to address view for online voucher

SELECT A.setid , A.shipto_id , A.effdt , A.eff_status , A.descrshort , B.descr , B.address1 , B.address2 , B.address3 , B.address4 , B.city , B.state , B.postal , B.country FROM PS_SHIPTO_TBL A , PS_LOCATION_TBL B , PS_SET_CNTRL_REC C WHERE A.SETID = C.SETCNTRLVALUE AND C.RECNAME = 'LOCATION_TBL' AND C.SETID = B.SETID AND A.SHIPTO_ID = B.LOCATION AND A.EFF_STATUS = 'A' AND B.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_SHIPTO_TBL C WHERE C.SETID = A.SETID AND C.SHIPTO_ID = A.SHIPTO_ID AND C.EFFDT <= %CurrentDateIn) AND B.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_LOCATION_TBL D WHERE D.SETID = B.SETID AND D.LOCATION = B.LOCATION AND D.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SETID_TBL

2 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
3 SHIP_TO_EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
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 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

13 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
14 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Default Value: USA

Prompt Table: COUNTRY_TBL