PO_VENLOCEDI_VW (SQL View)	Index Back
Supplier SETID Loc View SELECT DISTINCT A.SETID , A.SUPPLIER_ID , A.SUPP_LOC , A.PRICE_LOC , A.CURRENCY_CD , A.CUR_RT_TYPE , A.PRICE_SETID , A.PRICE_SUPPLIER , A.DISP_METHOD , A.PYMNT_TERMS_CD , A.FREIGHT_TERMS FROM PS_SUPPLIER_LOC A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_SUPPLIER_LOC B WHERE A.SETID = B.SETID AND A.SUPPLIER_ID = B.SUPPLIER_ID AND A.SUPP_LOC = B.SUPP_LOC AND B.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

PO_VENLOCEDI_VW

(SQL View)

Supplier SETID Loc View

SELECT DISTINCT A.SETID , A.SUPPLIER_ID , A.SUPP_LOC , A.PRICE_LOC , A.CURRENCY_CD , A.CUR_RT_TYPE , A.PRICE_SETID , A.PRICE_SUPPLIER , A.DISP_METHOD , A.PYMNT_TERMS_CD , A.FREIGHT_TERMS FROM PS_SUPPLIER_LOC A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_SUPPLIER_LOC B WHERE A.SETID = B.SETID AND A.SUPPLIER_ID = B.SUPPLIER_ID AND A.SUPP_LOC = B.SUPP_LOC AND B.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

SELECT DISTINCT A.SETID , A.VENDOR_ID , A.VNDR_LOC , A.PRICE_LOC , A.CURRENCY_CD , A.CUR_RT_TYPE , A.PRICE_SETID , A.PRICE_VENDOR , A.DISP_METHOD , A.PYMNT_TERMS_CD , A.FREIGHT_TERMS FROM PS_VENDOR_LOC A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_VENDOR_LOC B WHERE A.SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.VNDR_LOC = B.VNDR_LOC AND B.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

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

3 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

4 PRICE_LOC Character(10) VARCHAR2(10) NOT NULL Price from Location

5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

6 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type

7 PRICE_SETID Character(5) VARCHAR2(5) NOT NULL Price From Vendor SetID

8 PRICE_VENDOR Character(10) VARCHAR2(10) NOT NULL Price Vendor ID

9 DISP_METHOD Character(3) VARCHAR2(3) NOT NULL Dispatch Method
EDX=Electronic Document Exchange
EML=Email Dispatch
FAX=Fax Transmission
PHN=Phone Dispatch
PRN=Print

10 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.

11 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
3	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
4	PRICE_LOC	Character(10)	VARCHAR2(10) NOT NULL	Price from Location
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
6	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
7	PRICE_SETID	Character(5)	VARCHAR2(5) NOT NULL	Price From Vendor SetID
8	PRICE_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Price Vendor ID
9	DISP_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Dispatch Method EDX=Electronic Document Exchange EML=Email Dispatch FAX=Fax Transmission PHN=Phone Dispatch PRN=Print
10	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
11	FREIGHT_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Freight Terms Code