• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

UserGroup Table (59)

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

UserGroup table relationship diagram

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

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.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top