W3EB_VCNTCT_VW(SQL View) |
Index Back |
|---|---|
Vendor Contact Telephone Nbrs |
| SELECT vp.SETID , vp.VENDOR_ID , vp.CNTCT_SEQ_NUM , vp.EFFDT , vp.PHONE_TYPE , vp.COUNTRY_CODE , vp.PHONE , vp.EXTENSION , vc.CONTACT_NAME , vc.CONTACT_TYPE , vc.CONTACT_TITLE , vc.PREFERRED_LANGUAGE FROM PS_VNDR_CNTCT_PHN vp , PS_VENDOR_CNTCT vc WHERE vp.SETID = vc.SETID AND vp.VENDOR_ID = vc.VENDOR_ID AND vp.CNTCT_SEQ_NUM = vc.CNTCT_SEQ_NUM AND vp.EFFDT = vc.EFFDT AND vc.CONTACT_TYPE = 'U' AND vp.PHONE_TYPE = 'MAIN' AND vp.EFFDT = ( SELECT MAX(vp1.EFFDT) FROM PS_VENDOR_CNTCT vp1 WHERE vp1.SETID = vp.SETID AND vp1.VENDOR_ID = vp.VENDOR_ID AND vp1.CNTCT_SEQ_NUM = vp.CNTCT_SEQ_NUM) AND vp.CNTCT_SEQ_NUM = ( SELECT MAX(vp2.CNTCT_SEQ_NUM) FROM PS_VENDOR_CNTCT vp2 WHERE vp2.SETID = vp.SETID AND vp2.VENDOR_ID = vp.VENDOR_ID) |
| # | 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 | CNTCT_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Contact Sequence Number |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | PHONE_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Phone Type
BUSN=Business CAMP=Campus CELL=Mobile DORM=Dormitory FAX=FAX HOME=Home MAIN=Main OTR=Other PGR1=Pager 1 PGR2=Pager 2 TELX=Telex WORK=Work |
| 6 | COUNTRY_CODE | Character(3) | VARCHAR2(3) NOT NULL | Prefix |
| 7 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 8 | EXTENSION | Character(6) | VARCHAR2(6) NOT NULL | Phone number extension |
| 9 | CONTACT_NAME | Character(50) | VARCHAR2(50) NOT NULL | Contact Name |
| 10 | CONTACT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Contact Type
B=Billing Contact C=Claims E=EDI Contact G=General I=Internal Corporate Contact M=Executive Management O=Policy P=Accounts Payable R=Broker S=Sales Contact U=Customer Service V=Service Contact W=Warehousing/Shipping Contact |
| 11 | CONTACT_TITLE | Character(35) | VARCHAR2(35) NOT NULL | Contact Title |
| 12 | PREFERRED_LANGUAGE | Character(3) | VARCHAR2(3) NOT NULL |
Preferred Language
E=English F=French |