AUC_VNDR_CNTC_S(SQL View) |
Index Back |
|---|---|
Supplier contact search |
| SELECT a.setid , a.contact_name , a.vendor_id , a.contact_type FROM PS_VENDOR_CNTCT a WHERE a.effdt = ( SELECT MAX(b.effdt) FROM PS_VENDOR_CNTCT b WHERE b.setid = a.setid AND b.vendor_id = a.vendor_id AND b.cntct_seq_num = a.cntct_seq_num AND b.effdt <= %CurrentDateIn) AND a.contact_name <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CONTACT_NAME |
Character(50) | VARCHAR2(50) NOT NULL | The individual contact name associated with a given bank/counterparty. |
| 3 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 4 | 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 |