PV_SHIPTOTBL_VW (SQL View)	Index Back
Effective dated ship to table.

PV_SHIPTOTBL_VW

(SQL View)

Effective dated ship to table.

SELECT A.SETID , A.SHIPTO_ID , A.SETID_REGION , A.REGION_CD FROM PS_SHIPTO_TBL A WHERE A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_SHIPTO_TBL B WHERE A.SETID = B.SETID AND A.SHIPTO_ID = B.SHIPTO_ID AND B.EFFDT <= %CurrentDateIn )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

3 SETID_REGION Character(5) VARCHAR2(5) NOT NULL Region SetID

4 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location
3	SETID_REGION	Character(5)	VARCHAR2(5) NOT NULL	Region SetID
4	REGION_CD	Character(10)	VARCHAR2(10) NOT NULL	Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.