| View Name: | ctct_web_acct_vw |
| View Number: | 5460 |
| Group: | Sales Mgr |
| Description: | Displays all web users and their roles for the account. Used by form 11671 Web Users |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| objid | ct_bus_role | objid | View internal record number | 3 (UNIQUE) |
| bus_org_objid | bus_org | objid | Bus_org internal record number | |
| contact_objid | contact | objid | Contact internal record number | |
| web_user_objid | web_user | objid | Web_user internal record number | |
| role_name | ct_bus_role | role_name | Name of the contact's role at the Account | |
| first_name | contact | first_name | First name of contact | |
| last_name | contact | last_name | Last name of contact | |
| account_name | bus_org | name | Name of the Account | |
| login_name | web_user | login_name | Web user's login name |
| Join From | Join To |
|---|---|
| (web_user).web_user2contact | (contact).contact2web_user |
| (ct_bus_role).ct_bus_role2bus_org | (bus_org).bus_org2ct_bus_role |
| (ct_bus_role).ct_bus_role2contact | (contact).contact2ct_bus_role |
| ctct_web_acct_vw | |||