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

associate Table (2)

Some tooltip text!
• 40 minutes to read
 • 40 minutes to read

associate MDO list item table. Employees, resources and other users - except for External persons

Fields

Name Description Type Null
associate_id Primary key PK
name Initials, also login name, possibly database user name String(239)
rank Rank order UShort ●
tooltip Tooltip or other description String(254) ●
deleted 1 = the user is retired and should have no rights, not appear in lists, etc. UShort ●
group_idx Primary group membership, see UserGroupLink for secondary memberships FK UserGroup
lastlogin Last login date DateTime
lastlogout Last logout date DateTime
person_id Owning person record FK person
checklistlimit Diary checklist scan limit DateTime
type Associate type Enum AssociateType ●
userFlags user-specific GUI flags String(127) ●
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 UShort
isLocation For resources only: 1 if this resource represents a location Bool ●
tzLocationId Default timezone location for this associate FK TZLocation ●
locationAddress Address of location, if this is a resource that is a location String(239) ●
ejuserId ID of the ej user record corresponding to this associate; 0 for associates that are not ej users FK ejuser ●
encryptedCheck Encrypted hash checksum String(254)
userName Associate user name String(254) ●
waiting_for_approval 0 = Approved (default). 1 = Associate/User must be approved by an administrator. User cannot log in while waiting, but can be assigned licenses. Used in Online. Bool

associate table relationship diagram

Field type in table associate

This enumeration consists of flag values that can be combined.

Type Comment
0 User / Employee
1 Associates with this bit is not associated with any person. Disregard the PersonId for associates with this bit set.
2 Associates of this type is not authenticated for SuperOffice
4 Associates with this bit do not have a calendar
8 Associates with this bit has full access rights, and the Sentry mechanism is bypassed

A resource like meeting room or projector would typically be type = 1

An external associate who may log in via Audience or any Collaborative CRM would be type = 4

Unknown party accessing the system (e.g. prospecting, eCRM) = 7 (no person (1) + not authenticated (2) + no diary(4))

Application with full access rights (EAI) (system user) = 13 (no person (1) + no diary(4) + full access/bypass sentry (8))

Indexes

Fields Types Description
associate_id PK Clustered, Unique
name String(239) Unique
person_id FK Index
type Enum Index

Relationships

Table Description
address Contact and Person addresses
AddressFormat Address formats for GUI and labels. See more information: Addressformat on http://techdoc.superoffice.com
AmountClass Amount Class list for SuperOffice Sales Intelligence (Saint) - used to group sales by amounts, into bins (low --> high) called amount classes. More information regarding SuperOffice Sales Intelligence on http://techdoc.superoffice.com
AmountClassGroupLink User group link table for AmountClass, for MDO item hiding
AmountClassHeadingLink Heading link table for AmountClass, for MDO headers
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.
area Definition of an Area (database subset for satellite and travel)
areauserassignment Link table indicating which users actually reside in this area.
areauserinclusion Link table incidated whose data should be included in this area. If Include all data in Area (no filtering) is ticket then there will be no rows for this area in this table.
associate Employees, resources and other users - except for External persons
AssociateGroupLink User group link table for Associate, for MDO item hiding
AssociateHeadingLink Heading link table for associate for display only. Supportive table, used for grouping and filtering on lists.
AssociateHistory Historical information about associates that have been deleted. Most references are NOT declared as foreign keys; this is a historical table that should not be updated when further changes occur in the database
attachment_location A location for storing attachments
AudienceConfig Configuration data for Audience core and webparts
AudienceLayout One layout (of webparts and other stuff) for an audience instance
AudienceLayoutLink Link between an audience layout and some target grouping table - might be Role or Category
AudienceVisibility How projects (or whatever) should be made visible in audience
BaseTZLocation Time zone location for the database (how tz-related datetimes should be stored in the database)
BatchTask Batch task request details, corresponding to the message body of a batch request message
BatchTaskDefinition Batch task definitiopns, populated from the SuperOffice.CRM.BatchProcessing.BatchTask attribute
BinaryObject Binary objects, i.e., blobs. Used for images, documents, SuperOffice inbox mail and other large binary items
BinaryObjectLink Link table, connects a BinaryObject with one or more owners
Business Business list table
BusinessGroupLink User group link table for Business, for MDO item hiding
BusinessHeadingLink Heading link table for Business, for MDO headers
Category Category list table
CategoryFamily Grouping table so that multiple company categories can be grouped under one term; to simplify searching for things like 'all customers'
CategoryGroupLink User group link table for Category, for MDO item hiding
CategoryHeadingLink Heading link table for Category, for MDO headers
company Information on license and owner of this SuperOffice database. This table should only have 1 row. This table contains encrypted license information. Changing it will disable login for all users and require you to restore the database from backup.
Comptr Comptr list table. List of all possible competitors (sale).
ComptrGroupLink User group link table for Comptr, for MDO item hiding
ComptrHeadingLink Heading link table for Comptr, for MDO headers
ConfigurableScreenAppliesTo Mapping between recipes in scil and chosen type of data (appliesToKey) to differ layouts on
ConfigurableScreenDelta Parts of recipes in SCIL to insert or remove in given recipes
ConnectionConfigField Configuration data for Erp and Quote Connections
ConsentPerson Link table that defines who has which consents
ConsentPurpose GDPR purpose alternatives
ConsentSource Consent source for GDPR
contact Companies and Organizations. This table features a special record containing information about the contact that owns the database.
contactinterest Link-table between contact and interests in ContInt
ContInt ContInt list table. List-text of all valid contact interest types.
ContIntGroupLink User group link table for ContInt, for MDO item hiding
ContIntHeadingLink Heading link table for ContInt, for MDO headers
CounterValue Visible for rights
country Country information
CountryGroupLink User group link table for Country, for MDO item hiding
CountryHeadingLink Heading link table for Country, for MDO headers
Credentials Alternative credentials
Credited Credited list table. List of who is to be credited for the sale.
CreditedGroupLink User group link table for Credited, for MDO item hiding
CreditedHeadingLink Heading link table for Credited, for MDO headers
Currency Currency list table
CurrencyGroupLink User group link table for Currency, for MDO item hiding
CurrencyHeadingLink Heading link table for Currency, for MDO headers
cust_config This table contains JSON structures used for customizing the customer center
dashboard Describes a dashboard
dashboard_theme A set of style rules for the Dashboard
dashboard_tile Represents one tile in the dashboard
dashboard_tile_definition Describes the contents of a tile
dashboard_tile_field Describes the contents of a tile field
DataRight Data right definition
DeliveryTerms The list of Delivery terms, in the internal product register
DeliveryTermsGroupLink User group link table for DeliveryTerms, for MDO item hiding
DeliveryTermsHeadingLink Heading link table for DeliveryTerms, for MDO item headings
DeliveryType The list of Delivery types, in the internal product register
DeliveryTypeGroupLink User group link table for DeliveryType, for MDO item hiding
DeliveryTypeHeadingLink Heading link table for DeliveryType, for MDO item headings
DiaryView Configuration of a multi-user diary view
DiaryViewRow Configuration of a multi-user diary view
DocTmpl DocTmpl list table. Describes templates available for writing new documents.
DocTmplGroupLink User group link table for DocTmpl, for MDO item hiding
DocTmplHeadingLink Heading link table for DocTmpl, for MDO headers
document Documents, this table is an extension of the Appointment table. There is always a corresponding appointment record; the relation between appointment and document is navigable in both directions. A document-type appointment record always has a corresponding document record and a record in VisibleFor specifying who may see this.
EjCategoryGroupLink User group link table for EjCategory, for mass handling ej_category members
ejscript ejscript
ejuser This table contains entries for the users of the system.
Email Email addresses for contacts, projects and persons
email_account Email account information
email_folder Corresponds to an email folder on a mail server
email_item Email data
ErpConfiguration Global settings for the Erp Integration Server
ErpConnection One connection to an ERP connector, specifying Client and other required information
ErpConnectionAccess Access control for Erp Connections
ErpConnectionActorType Data about the configuration of one Erp Actor on one ErpConnection
ErpConnector One ERP Connector, known by its URL
ErpExternalKey The external (ERP-facing) key related to a synchronized record / connection
ErpField Store the metadata describing the fields that belong to an actor/connection combination, as described by the Erp Connector
ErpInternalKey The internal (superoffice-facing) key related to a synchronized record
ErpListItemMapping Defines a mapping of ERP to CRM fields, per connection and actor type
ErpSyncLog Record all field changes done by the Erp Sync
ExtApp ExtApp list table. Applications startable from SuperOffice
ExtAppGroupLink User group link table for ExtApp, for MDO item hiding
ExtAppHeadingLink Heading link table for ExtApp, for MDO headers
ExternalEvent The definition of projects as events in Audience (or other Collaborative apps)
Favourite Favourite records (star-marking)
FieldLabel Field label override table, makes it possible to override internal string resources. Define your own text for the panels in SuperOffice, e.g. rename Project to Cars in SOAdmin - System Options - Labels This table contains controlling data for the string substitution mechanism. There is one row in this table for each label or string that can be substituted; the active field indicates whether the string is actually being substituted or not. Initially, all rows have this field set to 0. The table is loaded with initial data during database setup. Only SuperOffice Development has the necessary expertise to safely add rows to this table. If a row has active = 1, the table LocaleText should contain one or more rows pointing back to this table, with the actual text to be used.
foreignapp Top level of Foreign Key system
foreigndevice Middle level of Foreign Key system
foreignkey Foreign Key - enables storage of arbitrary extra key information for every table/row in SuperOffice. You may use this table to store your extra information instead of using the dictionary SDK to create your own tables.
form A form which can be published on a webpage and submitted by visitors
FunctionRight Functional right definition
FunctionRightRoleLink Functional right definition
Heading Heading items for all MDO lists, lists that are grouped and filtered.
hierarchy This table contains folders used to group the extra tables in the system.
History History lists for lists and searchable controls. Maintains history for Navigator or other search (find dialogs). A single table may have more than one record here, as indicated by the extra_id field. The HistorySize (preference may be set in maintenance client) defines how many records you can have in a history list.
ImportDefault Defaults for import fields/objects
ImportField Import object types - see localetext for names
ImportObject Import object types - see localetext for names.
ImportRelation Relations between import objects
Intent Intent list for SAINT. More information regarding SuperOffice Sales Intelligence on http://techdoc.superoffice.com
IntentGroupLink User group link table for Intent, for MDO item hiding
IntentHeadingLink Heading link table for Intent, for MDO headers
invitation Invitations to events
LanguageInfo Information about languages, from ISO standards and related information
LanguageInfoCountry Many-many link between countries and languages, to give intelligent choices for language
LegalBase Legal base for GDPR (Article 6)
LicenseAssocLink Link between ModuleLicense and Associate, for per-assoc licenses; this is how licenses are assigned/consumed
LicenseSatlLink Link between License and Satellite, for per-database licenses
LocaleText Multi-language text items. Used for user-defined field labels. Must be assigned correct name to match the language they start SuperOffice in. This table should be viewed in conjunction with FieldLabel. If a row in FieldLable has active = 1 this table will need to contain at least one row with the same resourceId as the FieldLabel row. The language id can be either 0 or one of the Windows language ID's; SuperOffice will pick the correct language on startup according to the user settings. If a label cannot be found with the given language and also not with language 0, it will not be substituted.
MergeMoveLog Log of merge and move operations (person, contact, project)
Message Definition of a message, corresponding to the header of a protocol
MessageHandler Presence and heartbeat of a message handler, should be updated once a minute. Older records are stale
ModuleLicense Module licenses, belonging to one single owner
ModuleOwner Unique owner of a set of licensed modules
MrMrs MrMrs list table. List of salutations.
MrMrsGroupLink User group link table for MrMrs, for MDO item hiding
MrMrsHeadingLink Heading link table for MrMrs, for MDO headers
OLEField Control data table for the OLE DB Provider
OLEFieldText Control data table for the OLE DB Provider
OLESubject Control data table for the OLE DB Provider
OLESubjectText Control data table for the OLE DB Provider
OLEView Control data table for the OLE DB Provider
OLEViewText Control data table for the OLE DB Provider
OnlineApp Echo and track information about Online Apps and their usage
outgoing_message Delivery of outgoing messages to messageplugins, updated with status asynchroneously
OwnerContactLink Table specifying which contacts can own associates. All contacts that have rows in this table (i.e. rows with contact_id pointing to them) will be offered as associate owners in the maintenance client and as candidate Satellite owners. Such contacts have restrictions on editing and deletion to protect database consistency.
PaymentTerms The list of payment terms, in the internal product register
PaymentTermsGroupLink User group link table for PaymentTerms, for MDO item hiding
PaymentTermsHeadingLink Heading link table for PaymentTerms, for MDO item headings
PaymentType The list of payment types, in the internal product register
PaymentTypeGroupLink User group link table for PaymentType, for MDO item hiding
PaymentTypeHeadingLink Heading link table for PaymentType, for MDO item headings
PersInt PersInt list table. List of Person interests.
PersIntGroupLink User group link table for PersInt, for MDO item hiding
PersIntHeadingLink Heading link table for PersInt, for MDO headers
person Persons in a company or an organizations. All associates have a corresponding person record
personinterest Note: If you add or remove rows in this table, you will need to update the interestCount field in the person table accordingly. This field should always reflect the number of interest records a person has, to enable the correct setting of the interest indicator on the tab in the person dialog. Replication note: The combination of person_id and pinterest_idx is unique. If a duplicate is made on a replicated database, the system will replace the record in the target database with the one derived from the source database during replication. Therefore, do not assume that a record in this table will retain its ID indefinitely, even if the person keeps the interest.
PersPos PersPos list table. Contact person position list
PersPosGroupLink User group link table for PersPos, for MDO item hiding
PersPosHeadingLink Heading link table for PersPos, for MDO headers
phone Contact and Person phonenumbers (+fax)
PhoneFormat Formatting information for telephone numbers
PMembType PMembType list table. List text of titles (member types) for project members.
PMembTypeGroupLink User group link table for PMembType, for MDO item hiding
PMembTypeHeadingLink Heading link table for PMembType, for MDO headers
PrefDesc Preference description, drives the Preference GUI. Maintenance client - controls all preferences in SuperOffice. You find an overview off all standard preference on http://techdoc.superoffice.com. May be used by third-party developers to add system preferences to be updated from SuperOffice Maintenance client, instead of ini-files.
PrefDescLine Preference description - multiple choice line - drives the Preference GUI. May be used by third-party developers to add system preferences to be updated from SuperOffice Maintenance client, instead of ini-files.
preference Not quite obsolete preference table; historical info mostly. From 6.1 this table now holds an upgrade stamp.
PriceList List of prices, cached from an ERP system
PriceUnit The list of price units, in the internal product register (meter, ton, bushel, microsecond, gradus, τρυβλίον, 五合枡, دونم or whatever)
PriceUnitGroupLink User group link table for PriceUnit, for MDO item hiding
PriceUnitHeadingLink Heading link table for PriceUnit, for MDO item headings
Priority Priority list table. Used with appointments: low, high.
PriorityGroupLink User group link table for Priority, for MDO item hiding
PriorityHeadingLink Heading link table for Priority, for MDO headers
Prob Prob list table. Probability, used in sales .
ProbGroupLink User group link table for Prob, for MDO item hiding
ProbHeadingLink Heading link table for Prob, for MDO headers
Product One Product, member of one price list
ProductCategory List for the ProductCategory field of the Product table (Quote Management)
ProductCategoryGroupLink User group link table for ProductCategory, for MDO item hiding
ProductCategoryHeadingLink Heading link table for ProductCategory, for MDO item headings
ProductFamily List for the ProductFamily field of the Product table (Quote Management)
ProductFamilyGroupLink User group link table for ProductFamily, for MDO item hiding
ProductFamilyHeadingLink Heading link table for ProductFamily, for MDO item headings
ProductType List for the ProductType field of the Product table (Quote Management)
ProductTypeGroupLink User group link table for ProductType, for MDO item hiding
ProductTypeHeadingLink Heading link table for ProductType, for MDO item headings
ProductVersion Version information for code modules. Owner + code module must be unique
project Projects
projectmember Project members. Link-table between person and project
ProjectTypeStatusLink Many-many link table between project type and status, similar to sale type-stage link; and an anchor point for guide items
ProjStatus ProjStatus list table. Project status
ProjStatusGroupLink User group link table for ProjStatus, for MDO item hiding
ProjStatusHeadingLink Heading link table for ProjStatus, for MDO headers
ProjType ProjType list table. List of valid Project types.
ProjTypeGroupLink User group link table for ProjType, for MDO item hiding
ProjTypeHeadingLink Heading link table for ProjType, for MDO headers
Publish Publishing system for external users
PushNotificationService Used for storing handles to user devices that should receive push notifications
quick_reply Personal quick reply text fragments
Quote Quote root level, at most one per Sale, always connected to one Sale
QuoteAlternative Quote Version is made up of one or more Alternatives. One of 1..n possible alternatives in a Quote Version. The reason we have alternatives is that a quote can say to a customer, “we can solve you problem in two (or more) different ways, with different technology and sideeffects (and price)”. An Alternative may have discounts on the total amount. The Alternative tracks whether the user on the order level entered the Discount , Earning amount or the TotalPrice fields so that the discount and earning and total can be re-calculated correctly when Quote Lines are added or changed.
QuoteApprReason Predefined reasons for quote approval
QuoteApprReasonGroupLink User group link table for QuoteApprReason, for MDO item hiding
QuoteApprReasonHeadingLink Heading link table for QuoteApprReason, for MDO headers
QuoteConnection Primary key in the CRM database. Definition of a connection to an external system, for the Quote system.
QuoteConnectionAccess Access control for Quote Connections
QuoteDenyReason Predefined reasons for quote denial
QuoteDenyReasonGroupLink User group link table for QuoteDenyReason, for MDO item hiding
QuoteDenyReasonHeadingLink Heading link table for QuoteDenyReason, for MDO headers
QuoteLine One line in a QuoteAlternative. QuoteLines are mainly information copied from the Products provider. Products information is sometimes edited by the user before being included in the quote, so most information is duplicated from Product rather than referenced directly.
QuoteLineConfiguration Configuration of quote lines - which fields are in use, rights, labels etc
QuoteVersion There may be multiple Versions of a Quote, with one of them active
QuoteVersionAttachment Actual attachments to a quote
Reason Reason list table. Why we lost the sale (list)
ReasonGroupLink User group link table for Reason, for MDO item hiding
ReasonHeadingLink Heading link table for Reason, for MDO headers
ReasonSold Why was the sale marked as sold (why did we succeed)
ReasonSoldGroupLink User group link table for ReasonSold, for MDO item hiding
ReasonSoldHeadingLink Heading link table for ReasonSold, for MDO headers
ReasonStalled Why was the sale marked as stalled
ReasonStalledGroupLink Link table for ReasonStalled, for MDO item hiding
ReasonStalledHeadingLink Heading link table for ReasonStalled, for MDO headers
RecurrenceRule The recurrency pattern for a recurring event. Each recurring event has an appointment.recurrenceRuleId pointing to its pattern.
RefCountRange Number allocation system, for keeping track of ranges of numbers loaned out to travel and satellite databases
RefCounts Number counter for all tables that generate numbers, e.g. templates, contacts... This table is used for the number allocation system and should not be confused with sequence, used for allocating internal ID's. This table is replicated during generation of satellites and during local update for travellers, using special logic. By default it contains rows for the SuperOffice standard counters, including one row for each DocTemplate record. It is permissible to add new rows to this table, and such records are maintainable through the Maintenance client. Changing the contents of the standard records is not recommended.
RejectReason Rejection reason (suggested) for bookings
RejectReasonGroupLink User group link table for Comptr, for MDO item hiding
RejectReasonHeadingLink Heading link table for RejectReason, for MDO headers
relationdefinition Definition of a relation. This table defines the relations that can exist in the database. Each relation has an active text and a passive text. The table RelationTarget specifies which pairs of tables this relation can connect. Use of the active and passive texts is dependent on which direction the relation is viewed in, e.g., active text = "Owns" and passive text = "Is owned by".
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.
relationtarget Definition of targets for a relation. Links a relation definition (RelDef) to source and target tables. In general, a relation can be created between any pair of tables. This table is used for specifying which table pairs a particular relation can be used for. A relation definition should have at least one row in this table, and can have more. Note: The 5.0 Maintenance and GUI only support contact and person as valid values for the source_table and destination_table fields, in any combination. Other relations will not be shown, and relation definitions pointing to other tables will not be editable from the Maintenance GUI; however, nothing will crash.
RelDefGroupLink User group link table for RelDef, for MDO item hiding
RelDefHeadingLink Heading link table for RelDef, for MDO headers
ReporterListDef Reporter definitions
ResourceOverride Generic mechanism for overriding (or even defining new) text resources, in multiple languages
Role User roles for role-based security, names and tooltips are in LocaleText. For more information regarding role based security, see http://techdoc.superoffice.com
s_link Links in messages to measure success rate of a campaign.
s_message A message used in a shipment. Can be html and/or plain text
s_messageblock Contains a block of a mailing message, that can be reused in a mailing
s_picture_entry This table describes each picture in the database
s_picture_folder This table contains all picture folders
s_shipment Contains info about one shipment. The addresses are stored in s_shipment_addr
SaintConfiguration Configuration information for the Saint system
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.
SaleStakeholder Stakeholders in the sale, very similar to project members
SaleType Type of sale - large solution, incremental, whatever fits the organization
SaleTypeCat Category for sale type
SaleTypeCatGroupLink User group link table for SaleTypeCat, for MDO item hiding
SaleTypeCatHeadingLink Heading link table for SaleTypeCat, for MDO headers
SaleTypeGroupLink User group link table for SaleType, for MDO item hiding
SaleTypeHeadingLink Heading link table for SaleType, for MDO headers
SaleTypeQuoteAttachment Default attachments to quotes linked to sales of this type
SaleTypeStageLink Many-many link table between sale type and stage; and an anchor point for guide items
Salutation Academic title for Person
SalutationGroupLink User group link table for Salutation, for MDO item hiding
SalutationHeadingLink Heading link table for Salutation, for MDO headers
satellite Definition of Satellites
screen_chooser Screen choosers
script_trace Scripts which should be traced
script_trace_run Traces of executed scripts
SearchCat SearchCat list table
SearchCatGroupLink User group link table for SearchCat, for MDO item hiding
SearchCatHeadingLink Heading link table for SearchCat, for MDO headers
SearchCriteria Criteria storage for Selection and other Find mechanisms
SearchCriteriaGroup Criteria storage for Selection and other Find mechanisms
SearchCriterion Criteria storage for Selection and other Find mechanisms
SearchCriterionValue Criteria storage for Selection and other Find mechanisms
selection Selections
service_auth Authentication for a service (imap, smtp...)
ShipmentType Shipment type list table. Classification of a mailing, allowing recipients to subscribe to lists
ShipmentTypeReservation ShipmentTypes a person has reserved against. Note that the absense of a record here implies acceptance of a mailings of this type
SORCriteria SuperOffice reporter data
SORFCT SuperOffice reporter data
SORField SuperOffice reporter data
SORLabelLayout SuperOffice reporter data
SOROperators SuperOffice reporter data
SORPublish SuperOffice reporter data
SORPublishGroupLink Link table used for filtering reports by user group
SORSection SuperOffice reporter data
SORTemplate SuperOffice reporter data
Source Source list table. Source for sale (list)
SourceGroupLink User group link table for Source, for MDO item hiding
SourceHeadingLink Heading link table for Source, for MDO headers
StakeholderRole Role a stakeholder has in a sale
StakeholderRoleGroupLink User group link table for StakeholderRole, for MDO item hiding
StakeholderRoleHeadingLink Heading link table for StakeholderRole, for MDO headers
StatusDef Status definitions. Name and description are in LocaleText for internationalization
StatusValue Values for statuses
SubscriptionUnit The list of Subscription units, in the internal product register (year/quarter/month etc., or perhaps amounts if volume-based subscription)
SubscriptionUnitGroupLink User group link table for SubscriptionUnit, for MDO item hiding
SubscriptionUnitHeadingLink Heading link table for SubscriptionUnit, for MDO item headings
SuggestedAppointment Defines a suggested appointment for use in a Sale Guide or Project Guide
SuggestedDocument Unique owner of a set of licensed modules
SuperListColumnSize Stores the relative size (in percent) or in characters of a column in a SuperList
SystemEvent System events, such as freetext rebuild, SAINT rebuild and such. Makes broadcasts to keep its siblings and clients updated.
TabOrder Order of tabs within a tab control, if configured by a user
Tags MDO List of tags for Service entities
TagsGroupLink User group link table for Tags, for MDO item hiding
TagsHeadingLink Heading link table for Source, for MDO headers
target_assignment_info Linking associate, company or user group target and other information with target values
target_assignment_value A set of values linked to assignment info and a period in a target group.
target_change A single field change.
target_dimension Defining target dimension
target_group Info about a set of (sales, project, selection...) targets
target_period A set of periods linked with target amounts for users/usergroups and the target groups/years.
target_revision One batch of changes made to targets
target_revision_history Revision history info in case the original target group or assignment info was deleted
Task Task list table, activity types, like Phone, Meeting
TaskGroupLink User group link table for Task, for MDO item hiding
TaskHeadingLink Heading link table for Task, for MDO headers
TaskMenu List items to merge into menues
TaskMenuGroupLink User group link table for TaskMenu, for MDO item hiding
TaskMenuHeadingLink Heading link table for TaskMenu, for MDO headers
TemporaryKey Temporary keys for lightweight authentications such as changing ones subscriptions
text Long text fields from all over the system
ticket_relation Contains ticket relations, used to drive processing logic
ticket_relation_action Contains ticket relation actions, used to drive processing logic together with ticket relations
ticket_relation_type Contains ticket relation types, used to drive processing logic together with ticket relations
ticket_type Contains ticket types, used to drive processing logic together with ticket relations
travelcurrent Information about this database and its place in the hierarchy
travelgenerateddatabase Information about all databases generated from this database
travelgeneratedtransaction Record of all generated replication data files from this database (*.dwn files from mother database to child, *.up from child database to mother)
travelidmapping Mapping of primary keys between Travel databases and the mother database All travel database transactions get a high id to be able to see that this entry came from a database outside the central database. When update files are read into the central database, they get a normal low id. This table remembers the high travel id to map it to the low central id as long as this travel user is travelling.
traveller Associates traveling out from this database
traveltransactionlog Log of all updates made to the database, that need to be replicated.
TrayApp Tray application presence. SuperOffice CRM web extensions.
TypicalSearch Owner of a set of predefined selection criteria
TZDstRule Time zone rule for daylight saving time
TZLocation Time zone location
TZStdRule Time zone rule for standard time
UDefField Definition table for user-defined fields; one row in this table corresponds to one generation of one field. The user defined fields that are in use, and earlier versions of user defined fields. ColumnId refers to the field type; see UDXXXSmall or UDXXXLarge for the referring ID. Preferences prefsection='System', prefkey='CurrentUdefVersioncontact' (or CurrentUdefVersionperson, project, sale), gives you the current version of user defined fields. prefkey='AdminUdefVersion<...>' gives you the current version that's being edited. If Current version = admin version, no editing has been done since the last Publish of user defined field was performed.
UDefFieldGL User group link table for UDefField, for MDO item hiding
UDList List table for user-defined lists, contains all user-defined lists. 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.
UDListDefinition List table that contains the list of user-defined lists, as well as system-defined lists. The list items are stored in the UDList table.
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.
UDListHeadingLink Heading link table for UDList, for MDO headers. 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.
URL Unified Resource Locators, URL to contacts, persons or projects.
UsageStats Usage statistics
UserGroup Secondary user groups
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.
UserPreference Preference system. If deflevel is set to 5; the user may change the preferences
UserRoleLink Link between user role and user
VisibleFor Visible for rights, who may see this appointment/document, sale, salehist or selection
WebAppUsage Usage statistics for web applications
Webhook Webhook URL to call when events occur in the client or in NetServer. Also tracks call+error statistics.
Webhook_usage Webhook usage statistics - tracks call+error statistics. Same primary key as the webhook.
WinPosSize Stores the position and size of each window, so they can be shown in the same place again

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.
  • Cache table during filtering.

Security Flags

  • Sentry controls access to items in this table using user's Role and data rights matrix.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top