UserGroup Table (59)
•
Environment: onsite, online
Some tooltip text!
• 8 minutes to read
• 8 minutes to read
Secondary user groups
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| UserGroup_id | Primary key | PK | |
| name | UserGroup name | String(239) | |
| rank | Rank order | UShort | ● |
| tooltip | Tooltip or other description | String(254) | ● |
| deleted | 0 -> record is active 1 -> record is 'deleted' and should not be shown in lists | UShort | ● |
| type | 0 = department, other values = ? (workgroup, role, …) | UShort | ● |
| registered | Registered when | UtcDateTime | |
| registered_associate_id | Registered by whom | FK associate | |
| updated | Last updated when | UtcDateTime | |
| updated_associate_id | Last updated by whom | FK associate | |
| updatedCount | Number of updates made to this record | UShort |
Indexes
| Fields | Types | Description |
|---|---|---|
| UserGroup_id | PK | Clustered, Unique |
| name | String(239) | Unique |
Relationships
| Table | Description |
|---|---|
| AmountClassGroupLink | User group link table for AmountClass, for MDO item hiding |
| appointment | Tasks, appointments, followups, phone calls; and documents (document_id != 0). An appointment always has a corresponding record in VisibleFor specifying who may see this. |
| associate | Employees, resources and other users - except for External persons |
| AssociateGroupLink | User group link table for Associate, for MDO item hiding |
| BusinessGroupLink | User group link table for Business, for MDO item hiding |
| CategoryGroupLink | User group link table for Category, for MDO item hiding |
| ComptrGroupLink | User group link table for Comptr, for MDO item hiding |
| contact | Companies and Organizations. This table features a special record containing information about the contact that owns the database. |
| ContIntGroupLink | User group link table for ContInt, for MDO item hiding |
| CountryGroupLink | User group link table for Country, for MDO item hiding |
| CreditedGroupLink | User group link table for Credited, for MDO item hiding |
| CurrencyGroupLink | User group link table for Currency, for MDO item hiding |
| dashboard | Describes a dashboard |
| DeliveryTermsGroupLink | User group link table for DeliveryTerms, for MDO item hiding |
| DeliveryTypeGroupLink | User group link table for DeliveryType, for MDO item hiding |
| DocTmplGroupLink | User group link table for DocTmpl, for MDO item hiding |
| EjCategoryGroupLink | User group link table for EjCategory, for mass handling ej_category members |
| ErpConnectionAccess | Access control for Erp Connections |
| ExtAppGroupLink | User group link table for ExtApp, for MDO item hiding |
| form | A form which can be published on a webpage and submitted by visitors |
| IntentGroupLink | User group link table for Intent, for MDO item hiding |
| MrMrsGroupLink | User group link table for MrMrs, for MDO item hiding |
| PaymentTermsGroupLink | User group link table for PaymentTerms, for MDO item hiding |
| PaymentTypeGroupLink | User group link table for PaymentType, for MDO item hiding |
| PersIntGroupLink | User group link table for PersInt, for MDO item hiding |
| PersPosGroupLink | User group link table for PersPos, for MDO item hiding |
| PMembTypeGroupLink | User group link table for PMembType, for MDO item hiding |
| PriceUnitGroupLink | User group link table for PriceUnit, for MDO item hiding |
| PriorityGroupLink | User group link table for Priority, for MDO item hiding |
| ProbGroupLink | User group link table for Prob, for MDO item hiding |
| ProductCategoryGroupLink | User group link table for ProductCategory, for MDO item hiding |
| ProductFamilyGroupLink | User group link table for ProductFamily, for MDO item hiding |
| ProductTypeGroupLink | User group link table for ProductType, for MDO item hiding |
| project | Projects |
| ProjStatusGroupLink | User group link table for ProjStatus, for MDO item hiding |
| ProjTypeGroupLink | User group link table for ProjType, for MDO item hiding |
| QuoteApprReasonGroupLink | User group link table for QuoteApprReason, for MDO item hiding |
| QuoteConnectionAccess | Access control for Quote Connections |
| QuoteDenyReasonGroupLink | User group link table for QuoteDenyReason, for MDO item hiding |
| ReasonGroupLink | User group link table for Reason, for MDO item hiding |
| ReasonSoldGroupLink | User group link table for ReasonSold, for MDO item hiding |
| ReasonStalledGroupLink | Link table for ReasonStalled, for MDO item hiding |
| RejectReasonGroupLink | User group link table for Comptr, for MDO item hiding |
| relations | Instance of a relation, in principle between any two records, as long as they are defined in RelationDefinition. All instances of relations are held in this table; their definitions are in the RelDef table (RelDef + RelTarg define which relations you can have, this table contains the relations the user has actually entered). From 6.1 all links between appointments, sales and documents are also stored in this tabel. |
| RelDefGroupLink | User group link table for RelDef, for MDO item hiding |
| sale | Sales For every Sale record edited through the SuperOffice GUI, a copy of the current version of the record will be saved in the SaleHist table. This also applies to editing done through the SaleModel COM interface, but not to editing done through the OLE DB Provider or other channels. |
| SaleHist | Mirror image of the Sale table, providing a full transaction history. Every time you edit a sale, the current record of the sale is also saved here. |
| SaleTypeCatGroupLink | User group link table for SaleTypeCat, for MDO item hiding |
| SaleTypeGroupLink | User group link table for SaleType, for MDO item hiding |
| SalutationGroupLink | User group link table for Salutation, for MDO item hiding |
| SearchCatGroupLink | User group link table for SearchCat, for MDO item hiding |
| selection | Selections |
| SORPublishGroupLink | Link table used for filtering reports by user group |
| SourceGroupLink | User group link table for Source, for MDO item hiding |
| StakeholderRoleGroupLink | User group link table for StakeholderRole, for MDO item hiding |
| SubscriptionUnitGroupLink | User group link table for SubscriptionUnit, for MDO item hiding |
| SuperListColumnSize | Stores the relative size (in percent) or in characters of a column in a SuperList |
| TagsGroupLink | User group link table for Tags, for MDO item hiding |
| target_assignment_info | Linking associate, company or user group target and other information with target values |
| target_revision_history | Revision history info in case the original target group or assignment info was deleted |
| TaskGroupLink | User group link table for Task, for MDO item hiding |
| TaskMenuGroupLink | User group link table for TaskMenu, for MDO item hiding |
| UDefFieldGL | User group link table for UDefField, for MDO item hiding |
| UDListGroupLink | User group link table for UDList, for MDO item hiding. Note - MDO mode for userdefinede lists are either turned on or off, you may not have it on for one userdefined list and off for the others. |
| UserGroupLink | Link table between associate and usergroup, specifies secondary group membership. From SIX an associate may belong to more than one usergroup. Http://techdoc.superoffice.com has more information about how roles are implemented. |
| VisibleFor | Visible for rights, who may see this appointment/document, sale, salehist or selection |
| workflow | SuperOffice specific info about a workflow |
Replication Flags
- Replicate changes DOWN from central to satellites and travellers.
- Replicate changes UP from satellites and travellers back to central.
- Copy to satellite and travel prototypes.
Security Flags
- No access control via user's Role.