AUC_VR_CT_US_VW(SQL View) |
Index Back |
|---|---|
Valid Supplier ContactsValid Supplier Contacts with User Profiles 08/20/18 MANINSRI Modified as part of the Supplier User access to multiple Suppliers/Bidders Bidding Opportunities |
| SELECT VC.SETID , VC.VENDOR_ID , VC.CNTCT_SEQ_NUM , VC.EFFDT , VC.ADDRESS_SEQ_NUM , VC.EFF_STATUS , VC.CONTACT_NAME , VC.CONTACT_TYPE , VU.OPRID FROM PS_VENDOR_CNTCT VC , PS_VENDOR_USER VU WHERE VC.SETID = VU.SETID AND VC.VENDOR_ID = VU.VENDOR_ID AND VC.EFFDT = ( SELECT MAX(J4.EFFDT) FROM PS_VENDOR_CNTCT J4 WHERE J4.SETID = VC.SETID AND J4.VENDOR_ID = VC.VENDOR_ID AND J4.CNTCT_SEQ_NUM = VC.CNTCT_SEQ_NUM AND J4.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 | CNTCT_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Contact Sequence Number |
| 4 |  EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
| 6 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 7 | CONTACT_NAME | Character(50) | VARCHAR2(50) NOT NULL | The individual contact name associated with a given bank/counterparty. |
| 8 | 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 |
| 9 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |