OPPORTUNITY_IDBO_ID_CONTACTRSFM_OPPCONT_VW(SQL View) |
Index Back |
|---|---|
Opportunity Contacts (Mobile)Opportunity Contacts (Mobile). Used by Mobile Sales. |
| SELECT OPPORTUNITY_ID , BO_ID_CONTACT , CONTACT_NAME , FIRST_NAME , LAST_NAME , CONTACT_ID , WORK_PHONE , EXTENSION , SYNCID , SYNCDTTM FROM PS_RSF_OPP_CONTACT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPPORTUNITY_ID |
Character(15) | VARCHAR2(15) NOT NULL | Opportunity ID |
| 2 | BO_ID_CONTACT |
Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
| 3 | CONTACT_NAME | Character(50) | VARCHAR2(50) NOT NULL | The individual contact name associated with a given bank/counterparty. |
| 4 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 5 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 6 | CONTACT_ID | Character(15) | VARCHAR2(15) NOT NULL | Contact Identifier for Treasury Contacts |
| 7 | WORK_PHONE | Character(24) | VARCHAR2(24) NOT NULL | Work Phone |
| 8 | EXTENSION | Character(6) | VARCHAR2(6) NOT NULL | This field stores the Phone extension. |
| 9 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 10 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |