| View Name: | rol_contct_v |
| View Number: | 6073 |
| Group: | Customer Mgr |
| Description: | Used by form New Case (411), Previous Cases (412), CCList (414), Part Sel O (415) Case Win (420), Prev Cases (421), Site Contracts (717) and Site More Info (719) |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| objid | contact_role | objid | Contact role internal record number | 3 (UNIQUE) |
| con_objid | contact | objid | Contact internal record number | |
| loc_objid | site | objid | Site internal record number | |
| first_name | contact | first_name | Contact first name | 15 |
| last_name | contact | last_name | Contact last name | 14 |
| phone | contact | phone | Contact phone number which includes area code, number, and extension | |
| e_mail | contact | e_mail | Contact e-mail address | |
| site | site | name | Site name | |
| site_id | site | site_id | Site ID number assigned according to auto-numbering definition | |
| bus_org_objid | bus_org | objid | Bus Org internal record number | |
| org_id | bus_org | org_id | Business organization's ID number | |
| org_name | bus_org | name | Name of the organization |
| Join From | Join To |
|---|---|
| (contact_role).contact_role2site | (site).site2contact_role |
| (contact_role).contact_role2contact | (contact).contact2contact_role |
| (site).primary2bus_org | (bus_org).primary_org2site |
| rol_contct_v | |||