Database table listing

access_script table

Scripts to implement row-based access rules (sentry light)

activeuser table

Currently logged-on users. This table contains encrypted license information. Changing it may disable login for all users and require intervention by SuperOffice support. Recommended use; for determining who is logged on, at what location, etc.

address table

Contact and Person addresses

AddressFormat table

Address formats for GUI and labels. See more information; Addressformat on http;//techdoc.superoffice.com

ai_chat_turn table

Contains AI Chatbot history - contains whole chat, not just what is sent to the chatbot. History is ready ordered by timestamp

AmountClass table

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 table

User group link table for AmountClass, for MDO item hiding

AmountClassHeadingLink table

Heading link table for AmountClass, for MDO headers

appointment table

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 table

Definition of an Area (database subset for satellite and travel)

areauserassignment table

Link table indicating which users actually reside in this area.

areauserinclusion table

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 table

Employees, resources and other users - except for External persons

AssociateGroupLink table

User group link table for Associate, for MDO item hiding

AssociateHeadingLink table

Heading link table for associate for display only. Supportive table, used for grouping and filtering on lists.

AssociateHistory table

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 table

This table contains metadata for attachments. The actual attachments are stored directly on disk, with filenames based on the the primary key for this table.

attachment_location table

A location for storing attachments

AudienceConfig table

Configuration data for Audience core and webparts

AudienceLayout table

One layout (of webparts and other stuff) for an audience instance

AudienceLayoutLink table

Link between an audience layout and some target grouping table - might be Role or Category

AudienceVisibility table

How projects (or whatever) should be made visible in audience

AutomatedCategoryUpdate table

Info on how to autoupdate category when changing sale or leadstatus on person

autosave table

Autosaved text clobs from ejscript and emarketeer messages

available_fonts table

This table contains all fonts selected to be available for external usage

BaseTZLocation table

Time zone location for the database (how tz-related datetimes should be stored in the database)

BatchTask table

Batch task request details, corresponding to the message body of a batch request message

BatchTaskDefinition table

Batch task definitiopns, populated from the SuperOffice.CRM.BatchProcessing.BatchTask attribute

BinaryObject table

Binary objects, i.e., blobs. Used for images, documents, SuperOffice inbox mail and other large binary items

BinaryObjectLink table

Link table, connects a BinaryObject with one or more owners

board_view_settings table

Settings for selection board view

Business table

Business list table

BusinessGroupLink table

User group link table for Business, for MDO item hiding

BusinessHeadingLink table

Heading link table for Business, for MDO headers

CacheInvalidation table

Names and generation numbers for distributed invalidation of caches

CacheTables table

Specifies which tables should be cached to local files (or otherwise), generally these are the lists and other low-frequency-of-change tables. Contains the ID of any tables cached in SOCache. The files are binary and called <tablename>.bin. <Shift>+<F5> throws all cache files.

Category table

Category list table

category_membership table

This table connects users to categories (many-to-many).

CategoryFamily table

Grouping table so that multiple company categories can be grouped under one term; to simplify searching for things like 'all customers'

CategoryGroupLink table

User group link table for Category, for MDO item hiding

CategoryHeadingLink table

Heading link table for Category, for MDO headers

cc_template table

This table contains templates for the customer center

chat_message table

This table contains messages in a chat session.

chat_session table

This table contains chat sessions.

chat_topic table

This table contains chat topics.

chat_topic_user table

This table connected the chat topics with the users (i.e. the membership).

company table

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.

company_domain table

This table contains web-domains associated with a certain cust_company entry.

Comptr table

Comptr list table. List of all possible competitors (sale).

ComptrGroupLink table

User group link table for Comptr, for MDO item hiding

ComptrHeadingLink table

Heading link table for Comptr, for MDO headers

config table

This table contains certain system-wide configuration values.

ConfigurableScreenAppliesTo table

Mapping between recipes in scil and chosen type of data (appliesToKey) to differ layouts on

ConfigurableScreenDelta table

Parts of recipes in SCIL to insert or remove in given recipes

ConnectionConfigField table

Configuration data for Erp and Quote Connections

ConsentPerson table

Link table that defines who has which consents

ConsentPurpose table

GDPR purpose alternatives

ConsentSource table

Consent source for GDPR

contact table

Companies and Organizations.

contactinterest table

Link-table between contact and interests in ContInt

ContInt table

ContInt list table. List-text of all valid contact interest types.

ContIntGroupLink table

User group link table for ContInt, for MDO item hiding

ContIntHeadingLink table

Heading link table for ContInt, for MDO headers

copilot table

Contains all available copilots

copilot_data_source table

Stores data sources for each copilot

copilot_data_source_setting table

Stores specific configuration values for each data source

CounterValue table

Visible for rights

country table

Country information

CountryGroupLink table

User group link table for Country, for MDO item hiding

CountryHeadingLink table

Heading link table for Country, for MDO headers

Credentials table

Alternative credentials

Credited table

Credited list table. List of who is to be credited for the sale.

CreditedGroupLink table

User group link table for Credited, for MDO item hiding

CreditedHeadingLink table

Heading link table for Credited, for MDO headers

Currency table

Currency list table

CurrencyGroupLink table

User group link table for Currency, for MDO item hiding

CurrencyHeadingLink table

Heading link table for Currency, for MDO headers

cust_category table

This table contains entries for categories exposed through a customer language.

cust_config table

This table contains JSON structures used for customizing the customer center

cust_lang table

This table contains entries for customer languages.

dashboard table

Describes a dashboard

dashboard_theme table

A set of style rules for the Dashboard

dashboard_tile table

Represents one tile in the dashboard

dashboard_tile_definition table

Describes the contents of a tile

dashboard_tile_field table

Describes the contents of a tile field

DatabaseModel table

New DatabaseModel used by Continuous Database

DataRight table

Data right definition

dbi_agent table

DBI agent settings

dbi_agent_field table

DBI agent fields

dbi_agent_schedule table

DBI agent schedule settings

DeliveryTerms table

The list of Delivery terms, in the internal product register

DeliveryTermsGroupLink table

User group link table for DeliveryTerms, for MDO item hiding

DeliveryTermsHeadingLink table

Heading link table for DeliveryTerms, for MDO item headings

DeliveryType table

The list of Delivery types, in the internal product register

DeliveryTypeGroupLink table

User group link table for DeliveryType, for MDO item hiding

DeliveryTypeHeadingLink table

Heading link table for DeliveryType, for MDO item headings

DiaryView table

Configuration of a multi-user diary view

DiaryViewRow table

Configuration of a multi-user diary view

dictionary table

User added dictionary words

dictionary_base table

Language catalog for the ejournal dictionaries (automatic proof reading of message text etc)

doc_document table

This table contains documents.

doc_folder table

A document folder.

DocTmpl table

DocTmpl list table. Describes templates available for writing new documents.

DocTmplGroupLink table

User group link table for DocTmpl, for MDO item hiding

DocTmplHeadingLink table

Heading link table for DocTmpl, for MDO headers

document table

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.

eab_entry table

This table contains eab (email address book) entries, i.e. an alias ('Ola Hansen') and an address ('ola@hansen.as').

eab_folder table

This table contains eab (email address book) folders, used for containing email addresses.

ej_category table

This table contains categories, in which tickets are categorized. The categories are organized in a hierarchial manner.

ej_message table

This table contains the messages listed under tickets.

ej_role table

Define access rights, memberships and other properties for role user members

EjCategoryGroupLink table

User group link table for EjCategory, for mass handling ej_category members

ejpackage table

This table stores packages on the system.

ejpackage_item table

This table stores info on installed packages in the system

ejscript table

ejscript

ejscript_debug table

This table contains information when debugging an ejscript

ejsel_ejsel table

This table defines sources for complex selections in a many/many relationship

ejsel_meta_result table

This table stores result meta data

ejsel_result_set table

This table stores result set reference data, result sets for selections

ejsel_source_idlist table

This table stores id list source for selections

ejsel_source_script table

This table stores a selection script source

ejsel_source_xml table

This table stores a selection source as xml

ejselection table

This table stores selections, dynamic groups.

ejuser table

This table contains entries for the users of the system.

element_profile table

The new (4.0) profile table. Contains profile for a single Html-element. Connected through element_profile_link

Email table

Email addresses for contacts, projects and persons

email_account table

Email account information

email_attachment table

Attachment info related to an email_item

email_flow table

A set of properties related to the email workflow.

email_flow_content_link table

Links content to an email workflow

email_folder table

Corresponds to an email folder on a mail server

email_item table

Email data

EntityCounts table

Number of different entities an associate has created for usage statistics

ErpConfiguration table

Global settings for the Erp Integration Server

ErpConnection table

One connection to an ERP connector, specifying Client and other required information

ErpConnectionAccess table

Access control for Erp Connections

ErpConnectionActorType table

Data about the configuration of one Erp Actor on one ErpConnection

ErpConnector table

One ERP Connector, known by its URL

ErpExternalKey table

The external (ERP-facing) key related to a synchronized record / connection

ErpField table

Store the metadata describing the fields that belong to an actor/connection combination, as described by the Erp Connector

ErpInternalKey table

The internal (superoffice-facing) key related to a synchronized record

ErpListItemMapping table

Defines a mapping of ERP to CRM fields, per connection and actor type

ErpSyncLog table

Record all field changes done by the Erp Sync

ext_datasource table

This table contains external datasources, used for databaseintegration of customers and companies.

ext_field table

This table contains entries mapping an external field to an internal field. Used for database integration.

ext_table table

This table contains entries used for mapping an external table to an internal table (customer or cust_company) for database integration.

ExtApp table

ExtApp list table. Applications startable from SuperOffice

ExtAppGroupLink table

User group link table for ExtApp, for MDO item hiding

ExtAppHeadingLink table

Heading link table for ExtApp, for MDO headers

external_document table

This table stores documents which can be viewed externaly, through the customer module

external_owner table

Owner of external data imported into the system

ExternalEvent table

The definition of projects as events in Audience (or other Collaborative apps)

extra_fields table

This table contains entries for the extra fields in the system.

extra_menus table

This table contains entries for the extra menus in the system.

extra_tables table

This table contains entries for the extra tables in the system.

extra_tables_entry table

Hits/entries in result set of executed search in ejournal extra tables

extra_tables_result table

Result set of executed search in ejournal extra tables

Favourite table

Favourite records (star-marking)

FieldLabel table

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 table

Top level of Foreign Key system

foreigndevice table

Middle level of Foreign Key system

foreignkey table

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 table

A form which can be published on a webpage and submitted by visitors

form_field_restriction table

This table contains all form fields restrictions

form_field_value table

Form field values saved in a searchable format

form_keys table

Keys that makes sure a form is not posted twice

form_submission table

A form submission

freetextindex table

This is the index table for the free text search function. Each word in FreeTextWords can have multiple occurrences in this table. Each record in this table points to one occurrence of the word, and points to both the table in which the word occurs (which might be contact or text), and also a pointer to the owner table (which is one of contact, person, project, appointment or sale).

freetextstopwords table

Here are the words that can be excluded from Free Text Search by using the FreeTextAdmin. The words that appear here will not be found in FreeTextWords and typically include "are", "this", "that", and so on - words that occur frequently, but are not useful for searching. The more (good) stop words you have, the smaller the index will be.

freetextwords table

This table contains the word list (automatically updated by the indexer) for the free-text search. Words are in UPPERCASE and truncated to 9 significant characters. Indexed words, dynamically updated by the freetext index

FunctionRight table

Functional right definition

FunctionRightRoleLink table

Functional right definition

Heading table

Heading items for all MDO lists, lists that are grouped and filtered.

help table

This table contains the help pages.

hierarchy table

This table contains folders used to group the extra tables in the system.

History table

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.

hotlist table

The table is used by the hotlist to store the relationship between tickets and users

ImportDefault table

Defaults for import fields/objects

ImportField table

Import object types - see localetext for names

ImportObject table

Import object types - see localetext for names.

ImportRelation table

Relations between import objects

inbox table

Info and status for safe email import

Intent table

Intent list for SAINT. More information regarding SuperOffice Sales Intelligence on http;//techdoc.superoffice.com

IntentGroupLink table

User group link table for Intent, for MDO item hiding

IntentHeadingLink table

Heading link table for Intent, for MDO headers

invitation table

Invitations to events

invoice table

This table contains invoice entries, normally created when an invoice is sent to a customer, and we want to update the balance.

invoice_entry table

This table contain all invoices, connected to a message

invoice_sum table

This table is used temporarily when listing invoice statistics. It is used because we need to sort balances from both customers and companies.

invoice_type table

A invoiceable item category (a product or service) that provides default invoice line values

item_config table

This table is a generic table for storing item configuration. It is only used by the class ItemConfig.

kb_attachment table

This table connects FAQ entries to attachments.

kb_category table

Knowledge base folder hierarchy

kb_category_log table

Who and when, if somebody edits a knowledge base folder

kb_entry table

This table contains FAQ entries.

kb_entry_comment table

Comments to entries in the knowledge base, typically made by customers

kb_entry_keyword table

This table contains all keywords for the faq entries

kb_entry_log table

Who and when, if somebody edits a knowledge base entry

kb_entry_words table

This table contains all the words and how many times the are refered to in the FAQ entires

kb_group table

This table contains FAQ groups. A group is a cluster of entries (potentially located anywhere in the FAQ hierarchy). A group is located in a certain category.

kb_group_entry table

This table contains group entries for FAQ groups.

kb_http_link table

This table contains URL's associated with a single FAQ entry.

kb_solution_finder table

Knowledge base problem solving wizard, categories and subcategories for drilling down

kb_solution_finder_entry table

Knowledge base problem solving wizard, items in a category linking to a knowledge base entry

kb_workflow table

Knowledge base workflow steps

kb_workflow_access table

Control of who can do what in a knowledge base workflow step

landing_page table

Per-associate landing page configuration for a given entity type

landing_page_tab table

A tab (pinned selection or entity record) on a landing page

LanguageInfo table

Information about languages, from ISO standards and related information

LanguageInfoCountry table

Many-many link between countries and languages, to give intelligent choices for language

leadstatus table

List items of lead status that is selectable for contacts and persons that have specific category

legal_html_tags table

This table is used as a list of all legal HTML tags. HTML tags not in this list will be ignored when viewing html versions of messages

LegalBase table

Legal base for GDPR (Article 6)

LicenseAssocLink table

Link between ModuleLicense and Associate, for per-assoc licenses; this is how licenses are assigned/consumed

LicenseSatlLink table

Link between License and Satellite, for per-database licenses

LocaleText table

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.

locking table

Generic locking and error messages

log_debug table

A log used for debugging, especially useful for bLogic/ejscript

log_events table

System log

login table

This table contains entries for the user sessions.

login_customer table

This table contains entries for customer sessions. At first only used for Soap logins, but will later also be used for web logins

mail_alias table

This table contains the alias'es for each mailbox, one-to-many-relation. It is in so we can substract the alias'es when when listing the recipients of a message.

mail_block table

This table controls the spam-protection system, ensuring that a single email recipient does not recieve too many emails during a certain period of time.

mail_in_filter table

This table contains entries for the mailboxes the eJournal system is fetching mail from (POP3 or IMAP).

mail_in_uidl table

This table is used to avoid spamming the system by importing the same message several times (normally a result of a crash somewhere). When a mailbox is openede, then unique id for each message is stored in this table, and then removed only when the message has been correctly imported and deleted from mailbox.

MailingDomains table

List of allowed domains used in a Mailing

MergeMoveLog table

Log of merge and move operations (person, contact, project)

Message table

Definition of a message, corresponding to the header of a protocol

message_customers table

This table contains all cutomers who are involved in a message

message_header table

This table contains small pieces of information which is listed over the body for each message.

message_id table

This table links an email message id to an eJournal item

MessageHandler table

Presence and heartbeat of a message handler, should be updated once a minute. Older records are stale

metering_log table

Metering log table

ModuleLicense table

Module licenses, belonging to one single owner

ModuleOwner table

Unique owner of a set of licensed modules

MrMrs table

MrMrs list table. List of salutations.

MrMrsGroupLink table

User group link table for MrMrs, for MDO item hiding

MrMrsHeadingLink table

Heading link table for MrMrs, for MDO headers

ms_filter table

This table contains email filters. These are the filters allowing you to do advanced parsing of incomming emails.

ms_filter_mail table

This table connects mail filters (ms_filter) to mailboxes (mail_in_filter).

ms_substitute table

Regexp for extracting info from emails when they enter they system

ms_trashbin table

This table contains entries for emails which have been trashed by a filter, waiting for confirmation of deletion or import.

navigation_history table

Per-associate navigation state; Current (persisted soprotocol) and Recent navigation entries, keyed by client and key

NewsFeedItem table

Contains news feed items - published to one or more users, with one or more language descriptions

NewsFeedItemCta table

List of Calls-to-Action buttons to attach to a given news item. One item may have multiple CTAs (e.g. Approve + Reject).

NewsFeedItemHtml table

Detailed description of the news item, in a specific language.

NewsFeedItemRecipient table

Recipients of the news feed item. One news feed item may be sent to multiple recipients (users).

notice_frame table

PID controller for automatic adjustment of pop up message check rate

notify table

This table contains the pop-up messages displayed for users for various events, such as 'new ticket', etc.

OnlineApp table

Echo and track information about Online Apps and their usage

outbox table

Outgoing emails with sending status and other info

outgoing_message table

Delivery of outgoing messages to messageplugins, updated with status asynchroneously

OwnerContactLink table

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.

password_rules table

This table may contain one entry specifying rules for passwords.

PaymentTerms table

The list of payment terms, in the internal product register

PaymentTermsGroupLink table

User group link table for PaymentTerms, for MDO item hiding

PaymentTermsHeadingLink table

Heading link table for PaymentTerms, for MDO item headings

PaymentType table

The list of payment types, in the internal product register

PaymentTypeGroupLink table

User group link table for PaymentType, for MDO item hiding

PaymentTypeHeadingLink table

Heading link table for PaymentType, for MDO item headings

PersInt table

PersInt list table. List of Person interests.

PersIntGroupLink table

User group link table for PersInt, for MDO item hiding

PersIntHeadingLink table

Heading link table for PersInt, for MDO headers

person table

Persons

personinterest table

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 table

PersPos list table. Contact person position list

PersPosGroupLink table

User group link table for PersPos, for MDO item hiding

PersPosHeadingLink table

Heading link table for PersPos, for MDO headers

phone table

Contact and Person phonenumbers (+fax)

PhoneFormat table

Formatting information for telephone numbers

PMembType table

PMembType list table. List text of titles (member types) for project members.

PMembTypeGroupLink table

User group link table for PMembType, for MDO item hiding

PMembTypeHeadingLink table

Heading link table for PMembType, for MDO headers

PrefDesc table

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 table

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 table

Not quite obsolete preference table; historical info mostly. From 6.1 this table now holds an upgrade stamp.

PriceList table

List of prices, cached from an ERP system

PriceUnit table

The list of price units, in the internal product register (meter, ton, bushel, microsecond, gradus, τρυβλίον, 五合枡, دونم or whatever)

PriceUnitGroupLink table

User group link table for PriceUnit, for MDO item hiding

PriceUnitHeadingLink table

Heading link table for PriceUnit, for MDO item headings

Priority table

Priority list table. Used with appointments; low, high.

PriorityGroupLink table

User group link table for Priority, for MDO item hiding

PriorityHeadingLink table

Heading link table for Priority, for MDO headers

Prob table

Prob list table. Probability, used in sales .

ProbGroupLink table

User group link table for Prob, for MDO item hiding

ProbHeadingLink table

Heading link table for Prob, for MDO headers

Product table

One Product, member of one price list

ProductCategory table

List for the ProductCategory field of the Product table (Quote Management)

ProductCategoryGroupLink table

User group link table for ProductCategory, for MDO item hiding

ProductCategoryHeadingLink table

Heading link table for ProductCategory, for MDO item headings

ProductFamily table

List for the ProductFamily field of the Product table (Quote Management)

ProductFamilyGroupLink table

User group link table for ProductFamily, for MDO item hiding

ProductFamilyHeadingLink table

Heading link table for ProductFamily, for MDO item headings

ProductType table

List for the ProductType field of the Product table (Quote Management)

ProductTypeGroupLink table

User group link table for ProductType, for MDO item hiding

ProductTypeHeadingLink table

Heading link table for ProductType, for MDO item headings

ProductVersion table

Version information for code modules. Owner + code module must be unique

profile table

Deprecated. This table contains entries for the user profiles.

project table

Projects

projectmember table

Project members. Link-table between person and project

ProjectTypeStatusLink table

Many-many link table between project type and status, similar to sale type-stage link; and an anchor point for guide items

ProjStatus table

ProjStatus list table. Project status

ProjStatusGroupLink table

User group link table for ProjStatus, for MDO item hiding

ProjStatusHeadingLink table

Heading link table for ProjStatus, for MDO headers

ProjType table

ProjType list table. List of valid Project types.

ProjTypeGroupLink table

User group link table for ProjType, for MDO item hiding

ProjTypeHeadingLink table

Heading link table for ProjType, for MDO headers

Publish table

Publishing system for external users

PushNotificationService table

Used for storing handles to user devices that should receive push notifications

quick_filter_info table

Connect quick filter info from a specific provider to a dashboard

quick_reply table

Personal quick reply text fragments

Quote table

Quote root level, at most one per Sale, always connected to one Sale

QuoteAlternative table

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 table

Predefined reasons for quote approval

QuoteApprReasonGroupLink table

User group link table for QuoteApprReason, for MDO item hiding

QuoteApprReasonHeadingLink table

Heading link table for QuoteApprReason, for MDO headers

QuoteConnection table

Primary key in the CRM database. Definition of a connection to an external system, for the Quote system.

QuoteConnectionAccess table

Access control for Quote Connections

QuoteDenyReason table

Predefined reasons for quote denial

QuoteDenyReasonGroupLink table

User group link table for QuoteDenyReason, for MDO item hiding

QuoteDenyReasonHeadingLink table

Heading link table for QuoteDenyReason, for MDO headers

QuoteLine table

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 table

Configuration of quote lines - which fields are in use, rights, labels etc

QuoteVersion table

There may be multiple Versions of a Quote, with one of them active

QuoteVersionAttachment table

Actual attachments to a quote

Reason table

Reason list table. Why we lost the sale (list)

ReasonGroupLink table

User group link table for Reason, for MDO item hiding

ReasonHeadingLink table

Heading link table for Reason, for MDO headers

ReasonSold table

Why was the sale marked as sold (why did we succeed)

ReasonSoldGroupLink table

User group link table for ReasonSold, for MDO item hiding

ReasonSoldHeadingLink table

Heading link table for ReasonSold, for MDO headers

ReasonStalled table

Why was the sale marked as stalled

ReasonStalledGroupLink table

Link table for ReasonStalled, for MDO item hiding

ReasonStalledHeadingLink table

Heading link table for ReasonStalled, for MDO headers

RecurrenceRule table

The recurrency pattern for a recurring event. Each recurring event has an appointment.recurrenceRuleId pointing to its pattern.

redletterday table

Red letter days for calendar (holidays, birthday of king etc)

RefCountRange table

Number allocation system, for keeping track of ranges of numbers loaned out to travel and satellite databases

RefCounts table

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.

registry table

System settings

RejectReason table

Rejection reason (suggested) for bookings

RejectReasonGroupLink table

User group link table for Comptr, for MDO item hiding

RejectReasonHeadingLink table

Heading link table for RejectReason, for MDO headers

relationdefinition table

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 table

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 table

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 table

User group link table for RelDef, for MDO item hiding

RelDefHeadingLink table

Heading link table for RelDef, for MDO headers

reply_template table

Templates for automatic and manual replies to emails/sms organized hierachically

reply_template_attachment table

This table is used to connect attachments to reply templates (many-to-many).

reply_template_body table

Contains the body of the reply templates in different languages

reply_template_folder table

This table contains entries for folders for reply templates.

ResourceOverride table

Generic mechanism for overriding (or even defining new) text resources, in multiple languages

Role table

User roles for role-based security, names and tooltips are in LocaleText. For more information regarding role based security, see http;//techdoc.superoffice.com

role_category table

Category membership associated with a role

role_element table

Profiles associated with a role

role_member table

Users linked to a role. Deprecated.

role_workflow table

Knowledge base workflow access rights associated with a role

s_attachment table

A connector between a message and attachments. One message can contain many attachments.

s_bounce_shipment table

Email bounces from customers

s_dyn_criteria table

Contains criterias for a dynamic list.

s_link table

Links in messages to measure success rate of a campaign.

s_link_customer table

A connection between a customer and a link. Registered customers are identified when clicking on a link

s_link_customer_statical table

A connection between a customer and a link. Registered customers are identified when clicking on a link

s_list table

A list, dynamic or static

s_list_customer table

Elements in a customer list.

s_list_element table

Elements in a static list.

s_list_shipment table

A connector between shipment and list so that one shipment can have many lists, and one list can have many shipments

s_message table

A message used in a shipment. Can be html and/or plain text

s_messageblock table

Contains a block of a mailing message, that can be reused in a mailing

s_picture_entry table

This table describes each picture in the database

s_picture_folder table

This table contains all picture folders

s_sent_message table

Emarketeer message control

s_shipment table

Contains info about one shipment. The addresses are stored in s_shipment_addr

s_shipment_addr table

Addresses that are ready to be sent in a shipment.

s_smtp_servers table

Contains the smtp server for a shipment

s_washing table

Register of all bounced mail to enabel washing

s_washing_list table

Unused table that is ment to be used for active washing in spm v2

SaintConfiguration table

Configuration information for the Saint system

sale table

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 table

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 table

Stakeholders in the sale, very similar to project members

SaleType table

Type of sale - large solution, incremental, whatever fits the organization

SaleTypeCat table

Category for sale type

SaleTypeCatGroupLink table

User group link table for SaleTypeCat, for MDO item hiding

SaleTypeCatHeadingLink table

Heading link table for SaleTypeCat, for MDO headers

SaleTypeGroupLink table

User group link table for SaleType, for MDO item hiding

SaleTypeHeadingLink table

Heading link table for SaleType, for MDO headers

SaleTypeQuoteAttachment table

Default attachments to quotes linked to sales of this type

SaleTypeStageLink table

Many-many link table between sale type and stage; and an anchor point for guide items

Salutation table

Academic title for Person

SalutationGroupLink table

User group link table for Salutation, for MDO item hiding

SalutationHeadingLink table

Heading link table for Salutation, for MDO headers

satellite table

Definition of Satellites

schedule table

Generic scheduled tasked handling time scheduling, locking and error messages

scheduled_task table

A scheduled entry executing a script at certain times

screen_chooser table

Screen choosers

screen_definition table

A configurable screen

screen_definition_action table

An action to perform for a certain button in an screen

screen_definition_element table

An element in a configurable screen

screen_definition_hidden table

The name of a hidden variable to keep for this screen

screen_definition_language table

Custom language variables used for screens

script_trace table

Scripts which should be traced

script_trace_run table

Traces of executed scripts

SearchCat table

SearchCat list table

SearchCatGroupLink table

User group link table for SearchCat, for MDO item hiding

SearchCatHeadingLink table

Heading link table for SearchCat, for MDO headers

SearchCriteria table

Criteria storage for Selection and other Find mechanisms

SearchCriteriaGroup table

Criteria storage for Selection and other Find mechanisms

SearchCriterion table

Criteria storage for Selection and other Find mechanisms

SearchCriterionValue table

Criteria storage for Selection and other Find mechanisms

selection table

Selections

selectionmember table

Selection detail table Each row in a selection is represented by one record in this table. Contact_id is always filled in, person_id is optional, but if used, must point to a person belonging to the contact in contact_id.

sequence table

next_id to be used for each table

service_auth table

Authentication for a service (imap, smtp...)

session_object table

Generic session object, accessible from ejscript etc, typically xml or name=value syntax, may be stored over several rows if big

ShipmentType table

Shipment type list table. Classification of a mailing, allowing recipients to subscribe to lists

ShipmentTypeReservation table

ShipmentTypes a person has reserved against. Note that the absense of a record here implies acceptance of a mailings of this type

sms table

This table will hold outgoing sms messages when transmitted with WebServices

sms_hysteria table

Avoid sending too many sms messages in a short time interval to one person

snapshot table

Snapshots taken of the system database and attachments via soap

soap_access table

Table that contains constraints on the access to the soap interface

SORLabelLayout table

SuperOffice reporter data

Source table

Source list table. Source for sale (list)

SourceGroupLink table

User group link table for Source, for MDO item hiding

SourceHeadingLink table

Heading link table for Source, for MDO headers

StakeholderRole table

Role a stakeholder has in a sale

StakeholderRoleGroupLink table

User group link table for StakeholderRole, for MDO item hiding

StakeholderRoleHeadingLink table

Heading link table for StakeholderRole, for MDO headers

static_list_ref table

This table stores id references for selections id lists

StatusDef table

Status definitions. Name and description are in LocaleText for internationalization

StatusValue table

Values for statuses

SubscriptionUnit table

The list of Subscription units, in the internal product register (year/quarter/month etc., or perhaps amounts if volume-based subscription)

SubscriptionUnitGroupLink table

User group link table for SubscriptionUnit, for MDO item hiding

SubscriptionUnitHeadingLink table

Heading link table for SubscriptionUnit, for MDO item headings

SuggestedAppointment table

Defines a suggested appointment for use in a Sale Guide or Project Guide

SuggestedDocument table

Unique owner of a set of licensed modules

SuperListColumnSize table

Stores the relative size (in percent) or in characters of a column in a SuperList

system_script table

A table containing the system script

SystemEvent table

System events, such as freetext rebuild, SAINT rebuild and such. Makes broadcasts to keep its siblings and clients updated.

TabOrder table

Order of tabs within a tab control, if configured by a user

Tags table

MDO List of tags for Service entities

TagsGroupLink table

User group link table for Tags, for MDO item hiding

TagsHeadingLink table

Heading link table for Source, for MDO headers

target_assignment_info table

Linking associate, company or user group target and other information with target values

target_assignment_value table

A set of values linked to assignment info and a period in a target group.

target_change table

A single field change.

target_dimension table

Defining target dimension

target_group table

Info about a set of (sales, project, selection...) targets

target_period table

A set of periods linked with target amounts for users/usergroups and the target groups/years.

target_revision table

One batch of changes made to targets

target_revision_history table

Revision history info in case the original target group or assignment info was deleted

Task table

Task list table, activity types, like Phone, Meeting

TaskGroupLink table

User group link table for Task, for MDO item hiding

TaskHeadingLink table

Heading link table for Task, for MDO headers

TaskMenu table

List items to merge into menues

TaskMenuGroupLink table

User group link table for TaskMenu, for MDO item hiding

TaskMenuHeadingLink table

Heading link table for TaskMenu, for MDO headers

temp_db_lock table

Represents a temporary lock on a resource identified by table_id and key

temporary_words table

This table is used as a temporary table, containing the words we want to search for in the FAQs

TemporaryKey table

Temporary keys for lightweight authentications such as changing ones subscriptions

text table

Long text fields from all over the system

ticket table

This table contains the tickets (requests) of the system. Its purpose should be evident.

ticket_alert table

This table will contain ticket escalation levels. A ticket will be escalated along a 'chain' of these levels.

ticket_attachment table

This table connects an attachment to a message. It references the entry in the attachment table, and the message.

ticket_customers table

This table allows several customers to be connected to several tickets (many-to-many)

ticket_log table

This table contains log entries for the tickets.

ticket_log_action table

This table contains actions for the tickets.

ticket_log_change table

This table contains log entries for the tickets.

ticket_priority table

This table contains the ticket priorities.

ticket_rel_def_ticket_type table

Link table defining what Ticket types are involved in this relation. Will have M;N rows for a single relation definition

ticket_relation table

A relation between 2 tickets

ticket_relation_def table

Ticket relation definition

ticket_status table

This table user defined ticket status values.

ticket_status_history table

This table contains the history of a tickets statuses. Each time a ticket changes status a copy of the previous status of the record will be saved

ticket_type table

A ticket (request) type

ticket_type_priority table

Link table defining what Priorities are relevant to a particular Ticket type

ticket_type_status table

Link table defining what Statuses are relevant to a particular Ticket type

time_keeping table

Time keeping for how much time a sale or project or other entity has spent in a given stage or other state

timestamps table

Timestamp information

travelcurrent table

Information about this database and its place in the hierarchy

travelgenerateddatabase table

Information about all databases generated from this database

travelgeneratedtransaction table

Record of all generated replication data files from this database (*.dwn files from mother database to child, *.up from child database to mother)

travelidmapping table

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 table

Associates traveling out from this database

traveltransactionlog table

Log of all updates made to the database, that need to be replicated.

TrayApp table

Tray application presence. SuperOffice CRM web extensions.

tree_explorer_entry table

This table stores the entries in a tree-explorer

tree_explorer_link table

This table stores the link of entries in a tree-explorer

TypicalSearch table

Owner of a set of predefined selection criteria

TZDstRule table

Time zone rule for daylight saving time

TZLocation table

Time zone location

TZStdRule table

Time zone rule for standard time

udappntlarge table

User-defined fields

udappntsmall table

User-defined fields

udcontactLarge table

User-defined fields for contact (long strings)

udcontactSmall table

User-defined fields for contact

uddoclarge table

User-defined fields

uddocsmall table

User-defined fields

UDefField table

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 table

User group link table for UDefField, for MDO item hiding

UDList table

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 table

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 table

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 table

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.

udpersonLarge table

User-defined fields

udpersonSmall table

User-defined fields

udprojectLarge table

User-defined fields. During conversion of user defined fields the data is stored in this table.

udprojectSmall table

User-defined fields

udsalelarge table

User-defined fields

udsalesmall table

User-defined fields

udtempLarge table

User-defined fields

udtempSmall table

User-defined fields. During conversion of user defined fields the data is stored in this table.

URL table

Unified Resource Locators, URL to contacts, persons or projects.

user_attribute table

This table is used for storing various attributes for users.

user_candidate table

This table will hold user candidate secrets

UserGroup table

Secondary user groups

UserGroupLink table

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 table

Preference system. If deflevel is set to 5; the user may change the preferences

UserRoleLink table

Link between user role and user

utm_parameters table

Table for utm parameters collected from visits and formsubmissions

VisibleFor table

Visible for rights, who may see this appointment/document, sale, salehist or selection

WebAppUsage table

Usage statistics for web applications

Webhook table

Webhook URL to call when events occur in the client or in NetServer. Also tracks call+error statistics.

Webhook_notify table

Notification recipients for webhook failure events. Each row defines one recipient (associate or ad-hoc email) that should be notified when a webhook fails.

Webhook_usage table

Webhook usage statistics - tracks call+error statistics. Same primary key as the webhook.

WinPosSize table

Stores the position and size of each window, so they can be shown in the same place again

word_relations table

This table shows which word are used in which FAQ entry, and how many times they are used in each

workflow table

SuperOffice specific info about a workflow

workflow_goal table

A set of goals related to a workflow. Some goals will have search criterias associated with it to determine if the goal has been reached.

workflow_instance table

A set of properties related to the workflow instance of one participant going through the flow

workflow_root_step_link table

Link root steps to the workflow

workflow_step table

A set of steps related to a workflow.

workflow_step_option table

Some steps can have optional child 'flows', a new series of steps

workflow_step_option_link table

Link steps to other steps through step options

workflow_trigger table

A set of triggers related to a workflow.

workflow_wait_for_action table

Some steps wait for actions, this is info about those actions

wsdl_description table

Soap wsdl files

ziptocity table

Zip codes and city names. Zip codes used during address entry. You will find more information about addressformat on http;//techdoc.superoffice.com