VND_DFHI_OPTVW2

(SQL View)
 Index Back

Vndr-Lvl Dflt Hier Opt View


SELECT A.SETID , A.VENDOR_ID , B.VNDR_LOC , B.VNDR_SBI_FLG , B.RECV_ONLY_MTCH_FLG , A.VNDR_AFFILIATE FROM PS_VENDOR A , PS_VENDOR_LOC B WHERE B.SETID = A.SETID AND B.VENDOR_ID = A.VENDOR_ID AND B.EFFDT = ( SELECT MAX(I.EFFDT) FROM PS_VENDOR_LOC I WHERE I.SETID = B.SETID AND I.VENDOR_ID = B.VENDOR_ID AND I.VNDR_LOC = B.VNDR_LOC AND I.EFFDT <= %CurrentDateIn AND I.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 SBI_FLG Character(1) VARCHAR2(1) NOT NULL Selfbillingflag
5 RECV_ONLY_MTCH_FLG Character(1) VARCHAR2(1) NOT NULL Receipt Only Match
6 VNDR_AFFILIATE Character(5) VARCHAR2(5) NOT NULL Vendor Affiliate