VENDOR_CNT_VW(SQL View) |
Index Back |
|---|---|
Supplier Contact Detail View |
| SELECT c.setid , c.cntct_seq_num , c.vendor_id , c.address_seq_num , c.eff_status , c.contact_name , c.contact_type , c.contact_title , c.url , c.emailid FROM PS_VENDOR_CNTCT c WHERE c.eff_status = 'A' AND c.effdt = ( SELECT MAX(b.effdt) FROM PS_VENDOR_CNTCT b WHERE b.setid = c.setid AND b.vendor_id = c.vendor_id AND b.cntct_seq_num = c.cntct_seq_num AND b.effdt <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CNTCT_SEQ_NUM |
Number(5,0) | INTEGER NOT NULL | Contact Sequence Number |
| 3 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 4 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL |
Address Sequence Number
Prompt Table: VENDOR_ADDR_VW2 |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 6 | CONTACT_NAME | Character(50) | VARCHAR2(50) NOT NULL | The individual contact name associated with a given bank/counterparty. |
| 7 | 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 |
| 8 | CONTACT_TITLE | Character(35) | VARCHAR2(35) NOT NULL | The professional title for a given bank/counterparty contact person. |
| 9 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |
| 10 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |