LEAD_IDRSFM_LESLS_VW(SQL View) |
Index Back |
|---|---|
Mobile Sales Rep ViewThis view is used as a work record to have the Assign tab on mobile sales. |
| SELECT O.LEAD_ID , O.PERSON_ID , O.INDUSTRY_ID , O.REGION_ID , O.TERRITORY_ID , O.TREE_NAME , ' ' , O.ASSIGN_GROUP , O.SYNCID , O.SYNCDTTM FROM PS_RSF_LEAD O |
| # | 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 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 3 | INDUSTRY_ID | Character(30) | VARCHAR2(30) NOT NULL | Industry ID. |
| 4 | REGION_ID | Character(15) | VARCHAR2(15) NOT NULL | This field stores the region id value. |
| 5 | TERRITORY_ID | Character(20) | VARCHAR2(20) NOT NULL | Territory ID |
| 6 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 7 | SIC_CODE | Character(10) | VARCHAR2(10) NOT NULL | Standard Industry Code |
| 8 | ASSIGN_GROUP | Character(30) | VARCHAR2(30) NOT NULL | This field is used to specify assignment group name for Territory assignment. |
| 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 |