SETIDCUST_IDPrompt Table: CUST_ALL_CNT_VW
E=External Contact
I=Internal Contact
WC_CONTACT_VW(SQL View) |
Index Back |
|---|---|
View used for Contact PGLTView used for Contact PGLT, pulls in Contacts for OPERID. |
| SELECT A.CUSTOMER_SETID , A.CUST_ID , C.NAME1 , A.CONTACT_ID , B.CONTACT_FLAG , B.NAME1 , B.EMAILID , D.CONTACT_CODE ,E.DESCR FROM PS_CONTACT_CUST A , PS_CONTACT B , PS_CUSTOMER C , PS_CONTACT_TYPE D , PS_CUST_CNTCT_CODE E WHERE A.CONTACT_ID = B.CONTACT_ID AND A.CONTACT_ID = D.CONTACT_ID AND D.CONTACT_CODE = E.CONTACT_CODE AND A.CUST_ID = C.CUST_ID AND C.CUST_STATUS IN ('A','I') AND B.CONTACT_FLAG = 'I' AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_CONTACT_CUST A1 WHERE A1.CONTACT_ID = A.CONTACT_ID AND A1.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table: CUST_ALL_CNT_VW |
| 3 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 4 | CONTACT_ID | Character(15) | VARCHAR2(15) NOT NULL | Contact Identifier for Treasury Contacts |
| 5 | CONTACT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
An attribute that describes the specific purpose of a given bank/counterparty contact person.
E=External Contact I=Internal Contact |
| 6 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 7 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 8 | CONTACT_CODE | Character(6) | VARCHAR2(6) NOT NULL | Contact Type Code |
| 9 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |