| View Name: | agr_con_v |
| View Number: | 5785 |
| Group: | Morder |
| Description: | Uses for retrieve data of additional agreement contacts for Contacts Tab of screen Agreement Details. Used in morder\agreement\agreement_contacts.jsp JSP page |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| objid | fr_agr_con_role | objid | Role internal record number | 3 (UNIQUE) |
| agr_objid | fr_agrmnt | objid | Framework agreement internal record number | |
| cont_objid | contact | objid | Contact internal record number | |
| first_name | contact | first_name | Contact's first name | |
| last_name | contact | last_name | Contact's last name | |
| phone | contact | phone | Contact phone number | |
| role_name | fr_agr_con_role | role_name | Role name contacts and framework agreements play for one another | |
| is_primary | fr_agr_con_role | is_primary | Indicates primary contact for agreement. 1=is primary contact, 0=non primary contact;Default=0 |
| Join From | Join To |
|---|---|
| (fr_agr_con_role).fr_agr_con_role2fr_agrmnt | (fr_agrmnt).fr_agrmnt2fr_agr_con_role |
| (fr_agr_con_role).fr_agr_con_role2contact | (contact).contact2fr_agr_con_role |
| agr_con_v | |||