| View Name: | related_contacts_v |
| View Number: | 5789 |
| Group: | Morder |
| Description: | Gets contacts assigned to site part. Used in site_part_contacts.jsp page |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| objid | con_sp_role | objid | Contact - site_part role internal record number | 3 (UNIQUE) |
| site_part_objid | site_part | objid | Site parte internal record number | |
| role | con_sp_role | role_name | Role name contacts and site parts play for each other | |
| con_objid | contact | objid | Contact internal record number | |
| last_name | contact | last_name | Contact's last name | |
| first_name | contact | first_name | Contact's first name | |
| phone | contact | phone | Contact phone number |
| Join From | Join To |
|---|---|
| (con_sp_role).con_sp_role2contact | (contact).contact2con_sp_role |
| (con_sp_role).con_sp_role2site_part | (site_part).site_part2con_sp_role |
| related_contacts_v | |||