SPF_REMIT_SUP_V

(SQL View)
 Index Back

Supplier Remit Loc & Address

Supplier Remitting Location and Address information

SELECT L.SETID , L.VENDOR_ID , L.VNDR_LOC , L.REMIT_VENDOR , V.NAME1 FROM PS_VENDOR V , PS_VENDOR_LOC L WHERE L.SETID = V.SETID AND L.VENDOR_ID = V.VENDOR_ID AND L.EFFDT = ( SELECT MAX(L1.EFFDT) FROM PS_VENDOR_LOC L1 WHERE L1.SETID = L.SETID AND L1.VENDOR_ID = L.VENDOR_ID AND L1.VNDR_LOC = L.VNDR_LOC AND L1.EFFDT <= %CurrentDateIn AND L1.EFF_STATUS = 'A') AND L.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
4 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1