APS_SUPPLIER_VW

(SQL View)
 Index Back

APS Integration Supplier View


SELECT V.SETID , V.VENDOR_ID , VL.VNDR_LOC , VL.EFFDT , VL.EFF_STATUS , VA.EFFDT , V.NAME1 , VA.CITY , VA.STATE , VA.COUNTRY , VA.POSTAL FROM PS_VENDOR_LOC VL , PS_VENDOR_ADDR VA , PS_VENDOR V WHERE V.VENDOR_STATUS = 'A' AND VA.SETID = V.SETID AND VA.VENDOR_ID = V.VENDOR_ID AND VL.SETID = V.SETID AND VL.VENDOR_ID = V.VENDOR_ID AND VL.EFF_STATUS = 'A' AND VA.ADDRESS_SEQ_NUM = VL.ADDR_SEQ_NUM_SHFR AND VA.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 EFFDT Date(10) DATE Effective Date
5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
6 EFFDT_VENDOR Date(10) DATE Effective Date Supplier
7 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
8 CITY Character(30) VARCHAR2(30) NOT NULL City
9 STATE Character(6) VARCHAR2(6) NOT NULL State
10 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
11 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal