| View Name: | bus_site_ind |
| View Number: | 5098 |
| Group: | Sales Mgr |
| Description: | Retrieves Account, Site and Industry info. Used by forms Select Contact (SC) Quoted Part (9661), SC Installed Part (9662), SC (9663), SC for Campaign (9664) and SC by Industry (9667) |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| ind_objid | industry | objid | Industry internal record number | |
| ind_name | industry | name | Name of the industry | |
| bus_objid | bus_org | objid | Business organization internal record number | |
| bus_name | bus_org | name | Business organization name | |
| objid | bus_site_role | objid | Business site role internal record number | 3 (UNIQUE) |
| role_name | bus_site_role | role_name | Business site role name | |
| site_objid | site | objid | Site internal record number | |
| site_id | site | site_id | Unique identifier of the site | |
| site_name | site | name | Name of the site |
| Join From | Join To |
|---|---|
| (industry).bus_industry2bus_org | (bus_org).bus_industry2industry |
| (bus_site_role).bus_site_role2bus_org | (bus_org).bus_org2bus_site_role |
| (bus_site_role).bus_site_role2site | (site).site2bus_site_role |
| bus_site_ind | |||