LEAD_IDCONTACT_NAMERSF_LE_CONT_VW(SQL View) |
Index Back |
|---|---|
SFA - Lead ContactsSFA - Lead Contacts |
| SELECT LEAD_ID , CONTACT_NAME , FIRST_NAME , LAST_NAME , CONTACT_ID , BO_ID_CONTACT , COUNTRY_CODE , WORK_PHONE , EMAILID , PRIMARY_FLAG FROM PS_RSF_LE_CONTACTS WHERE CONTACT_NAME <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LEAD_ID |
Character(15) | VARCHAR2(15) NOT NULL | Used by Sales Force Automation, this field uniquely identifies a Sales Lead. |
| 2 | CONTACT_NAME |
Character(50) | VARCHAR2(50) NOT NULL | The individual contact name associated with a given bank/counterparty. |
| 3 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 4 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 5 | CONTACT_ID | Character(15) | VARCHAR2(15) NOT NULL | Contact Identifier for Treasury Contacts |
| 6 | BO_ID_CONTACT | Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
| 7 | COUNTRY_CODE | Character(3) | VARCHAR2(3) NOT NULL | This field stores the Country Code values. |
| 8 | WORK_PHONE | Character(24) | VARCHAR2(24) NOT NULL | Work Phone |
| 9 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 10 | PRIMARY_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Primary |