| Table Name: | bus_site_role |
| Table Number: | 43 |
| Group: | Sales Mgr |
| Description: | Roles played by business organizations for site and sites for business organizations |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| active | LONG | smallint | DIRECT | Indicates whether the role is currently being used. Reserved; future | ||||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| focus_type | LONG | smallint | DIRECT | Object type ID of the role-player; i.e., 52=a site's role for the business organization, 173=a business organization's role for the site | ||||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (11) | ||
| role_name | CHAR | varchar | 80 | Name of the role | Search (10) |
| Index Name | Fields | Flags |
|---|---|---|
| bus_site_index | role_name:focus_type:bus_site_role2site:bus_site_role2bus_org | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| bus_site_index | role_name, focus_type, bus_site_role2site, bus_site_role2bus_org | nonclustered, unique located on PRIMARY |
| ind_bus_site_role2bus_org | bus_site_role2bus_org, bus_site_role2site, role_name | nonclustered located on PRIMARY |
| ind_bus_site_role2site | bus_site_role2site, bus_site_role2bus_org, role_name | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 4615 | fc_case_view | bus_org, bus_site_role, case, condition, contact, gbst_elm, site, user |
| 4616 | fc_contract_view | bus_org, bus_site_role, contract, site |
| 4618 | fc_site_part_view | bus_org, bus_site_role, mod_level, part_num, site, site_part |
| 4619 | fc_bug_view | bug, bus_org, bus_site_role, case, gbst_elm, mod_level, part_num, probdesc, site, workaround |
| 4623 | fc_acct_site_view | address, bus_org, bus_site_role, country, site |
| 5031 | acct_site_view | address, bus_site_role, country, site |
| 5098 | bus_site_ind | bus_org, bus_site_role, industry, site |
| 5340 | sfaacctsite | address, bus_org, bus_site_role, country, site |
| 5482 | acct_sites_view | address, bus_org, bus_site_role, country, site |
| 5707 | sfa_site_dtl_vw | address, bus_org, bus_site_role, country, site, time_zone |
| 5743 | busorg_bussite_vw | bus_org, bus_org_extern, bus_site_role, site |
| 6030 | cont_subs_for_sim | bus_org, bus_site_role, con_sp_role, contact, site_part |
| bus_site_role | |||