PV_SUPP_TPO_MK1

(SQL View)
 Index Back

Active supplier list


SELECT A.SETID , A.VENDOR_ID , A.ADDRESS_seq_num , A.CNTCT_seq_num , A.CONTACT_NAME , A.CONTACT_TYPE , A.contact_title , A.url , A.DESCR , A.EMAILID , B.PHONE_TYPE , B.COUNTRY_CODE , B.PHONE , B.EXTENSION FROM PS_VENDOR_CNTCT A LEFT OUTER JOIN PS_VNDR_CNTCT_PHN B ON A.SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.CNTCT_seq_num = B.CNTCT_seq_num WHERE A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_VENDOR_CNTCT A1 WHERE A1.setid = A.setid AND A1.vendor_id = A.vendor_id AND A1.address_seq_num = A.address_seq_num AND A1.eff_status = 'A' AND A1.EFFDT <= %CurrentDateIn)

# 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 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
4 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
5 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL The individual contact name associated with a given bank/counterparty.
6 CONTACT_TYPE Character(1) VARCHAR2(1) NOT NULL An attribute that describes the specific purpose of a given bank/counterparty contact person.
B=Billing Contact
C=Contract Collaborator
D=Commercial Paper Contact
E=External Contact
F=Cash Forecast
G=General
I=Internal Corporate Contact
L=Line of Credit Contact
M=Executive Management
O=Investment Pool Contact
P=Accounts Payable
R=Broker
S=Sales Contact
V=Service Contact
W=Warehousing/Shipping Contact
7 CONTACT_TITLE Character(35) VARCHAR2(35) NOT NULL The professional title for a given bank/counterparty contact person.
8 CONTACTURL Character(254) VARCHAR2(254) NOT NULL Integration Server Business Entity Internet URL (Universal Resource Locator)
9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
10 CONTACTEMAIL Character(70) VARCHAR2(70) NOT NULL Integration Server Business Entity Contact Email
11 PHONE_TYPE Character(4) VARCHAR2(4) NOT NULL Phone Type
BUSN=Business Phone
CAMP=Campus Phone
CELL=Cellular Phone
DORM=Dormitory Phone
FAX=FAX
HOME=Home Phone
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
12 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix
13 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
14 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension