Show / Hide Table of Contents

Namespace SuperOffice.CRM.Data

Classes

AccessScriptTableInfo

Table 'access_script': Scripts to implement row-based access rules (sentry light)

ActiveUserTableInfo

Table 'activeuser': 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.

AddressFormatTableInfo

Table 'AddressFormat': Address formats for GUI and labels. See more information: Addressformat on http://techdoc.superoffice.com

AddressTableInfo

Table 'address': Contact and Person addresses

AmountClassGroupLinkTableInfo

Table 'AmountClassGroupLink': User group link table for AmountClass, for MDO item hiding

AmountClassHeadingLinkTableInfo

Table 'AmountClassHeadingLink': Heading link table for AmountClass, for MDO headers

AmountClassTableInfo

Table '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

AppointmentTableInfo

Table '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.

AreaTableInfo

Table 'area': Definition of an Area (database subset for satellite and travel)

AreaUserAssignmentTableInfo

Table 'areauserassignment': Link table indicating which users actually reside in this area.

AreaUserInclusionTableInfo

Table '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.

AssociateGroupLinkTableInfo

Table 'AssociateGroupLink': User group link table for Associate, for MDO item hiding

AssociateHeadingLinkTableInfo

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

AssociateHistoryTableInfo

Table '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

AssociateTableInfo

Table 'associate': Employees, resources and other users - except for External persons

AttachmentLocationTableInfo

Table 'attachment_location': A location for storing attachments

AttachmentTableInfo

Table 'attachment': 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.

AudienceConfigTableInfo

Table 'AudienceConfig': Configuration data for Audience core and webparts

AudienceLayoutLinkTableInfo

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

AudienceLayoutTableInfo

Table 'AudienceLayout': One layout (of webparts and other stuff) for an audience instance

AudienceVisibilityTableInfo

Table 'AudienceVisibility': How projects (or whatever) should be made visible in audience

AutosaveTableInfo

Table 'autosave': Autosaved text clobs from ejscript and emarketeer messages

BaseTZLocationTableInfo

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

BatchTaskDefinitionTableInfo

Table 'BatchTaskDefinition': Batch task definitiopns, populated from the SuperOffice.CRM.BatchProcessing.BatchTask attribute

BatchTaskTableInfo

Table 'BatchTask': Batch task request details, corresponding to the message body of a batch request message

BinaryObjectLinkTableInfo

Table 'BinaryObjectLink': Link table, connects a BinaryObject with one or more owners

BinaryObjectTableInfo

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

BusinessGroupLinkTableInfo

Table 'BusinessGroupLink': User group link table for Business, for MDO item hiding

BusinessHeadingLinkTableInfo

Table 'BusinessHeadingLink': Heading link table for Business, for MDO headers

BusinessTableInfo

Table 'Business': Business list table

CacheInvalidationTableInfo

Table 'CacheInvalidation': Names and generation numbers for distributed invalidation of caches

CacheTablesTableInfo

Table 'CacheTables': 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.

CategoryFamilyTableInfo

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

CategoryGroupLinkTableInfo

Table 'CategoryGroupLink': User group link table for Category, for MDO item hiding

CategoryHeadingLinkTableInfo

Table 'CategoryHeadingLink': Heading link table for Category, for MDO headers

CategoryMembershipTableInfo

Table 'category_membership': This table connects users to categories (many-to-many).

CategoryTableInfo

Table 'Category': Category list table

ChatMessageTableInfo

Table 'chat_message': This table contains messages in a chat session.

ChatSessionTableInfo

Table 'chat_session': This table contains chat sessions.

ChatTopicTableInfo

Table 'chat_topic': This table contains chat topics.

ChatTopicUserTableInfo

Table 'chat_topic_user': This table connected the chat topics with the users (i.e. the membership).

CompanyDomainTableInfo

Table 'company_domain': This table contains web-domains associated with a certain cust_company entry.

CompanyTableInfo

Table '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.

ComptrGroupLinkTableInfo

Table 'ComptrGroupLink': User group link table for Comptr, for MDO item hiding

ComptrHeadingLinkTableInfo

Table 'ComptrHeadingLink': Heading link table for Comptr, for MDO headers

ComptrTableInfo

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

ConfigTableInfo

Table 'config': This table contains certain system-wide configuration values.

ConfigurableScreenDeltaTableInfo

Table 'ConfigurableScreenDelta': Parts of recipes in SCIL to insert or remove in given recipes

ConnectionConfigFieldTableInfo

Table 'ConnectionConfigField': Configuration data for Erp and Quote Connections

ConsentPersonTableInfo

Table 'ConsentPerson': Link table that defines who has which consents

ConsentPurposeTableInfo

Table 'ConsentPurpose': GDPR purpose alternatives

ConsentSourceTableInfo

Table 'ConsentSource': Consent source for GDPR

ContactInterestTableInfo

Table 'contactinterest': Link-table between contact and interests in ContInt

ContactTableInfo

Table 'contact': Companies and Organizations. This table features a special record containing information about the contact that owns the database.

ContIntGroupLinkTableInfo

Table 'ContIntGroupLink': User group link table for ContInt, for MDO item hiding

ContIntHeadingLinkTableInfo

Table 'ContIntHeadingLink': Heading link table for ContInt, for MDO headers

ContIntTableInfo

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

CounterValueTableInfo

Table 'CounterValue': Visible for rights

CountryGroupLinkTableInfo

Table 'CountryGroupLink': User group link table for Country, for MDO item hiding

CountryHeadingLinkTableInfo

Table 'CountryHeadingLink': Heading link table for Country, for MDO headers

CountryTableInfo

Table 'country': Country information

CredentialsTableInfo

Table 'Credentials': Alternative credentials

CreditedGroupLinkTableInfo

Table 'CreditedGroupLink': User group link table for Credited, for MDO item hiding

CreditedHeadingLinkTableInfo

Table 'CreditedHeadingLink': Heading link table for Credited, for MDO headers

CreditedTableInfo

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

CurrencyGroupLinkTableInfo

Table 'CurrencyGroupLink': User group link table for Currency, for MDO item hiding

CurrencyHeadingLinkTableInfo

Table 'CurrencyHeadingLink': Heading link table for Currency, for MDO headers

CurrencyTableInfo

Table 'Currency': Currency list table

CustCategoryTableInfo

Table 'cust_category': This table contains entries for categories exposed through a customer language.

CustConfigTableInfo

Table 'cust_config': This table contains JSON structures used for customizing the customer center

CustLangTableInfo

Table 'cust_lang': This table contains entries for customer languages.

DashboardTableInfo

Table 'dashboard': Describes a dashboard

DashboardThemeTableInfo

Table 'dashboard_theme': A set of style rules for the Dashboard

DashboardTileDefinitionTableInfo

Table 'dashboard_tile_definition': Describes the contents of a tile

DashboardTileFieldTableInfo

Table 'dashboard_tile_field': Describes the contents of a tile field

DashboardTileTableInfo

Table 'dashboard_tile': Represents one tile in the dashboard

DatabaseModelTableInfo

Table 'DatabaseModel': New DatabaseModel used by Continuous Database

DataRightTableInfo

Table 'DataRight': Data right definition

DBC

Constants for database tables and fields

DBC.AccessScriptFields

Fields for AccessScript, Scripts to implement row-based access rules (sentry light)

DBC.ActiveUserFields

Fields for ActiveUser, 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.

DBC.AddressFields

Fields for Address, Contact and Person addresses

DBC.AddressFormatFields

Fields for AddressFormat, Address formats for GUI and labels. See more information: Addressformat on http://techdoc.superoffice.com

DBC.AmountClassFields

Fields for 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

DBC.AmountClassGroupLinkFields

Fields for AmountClassGroupLink, User group link table for AmountClass, for MDO item hiding

DBC.AmountClassHeadingLinkFields

Fields for AmountClassHeadingLink, Heading link table for AmountClass, for MDO headers

DBC.AppointmentFields

Fields for 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.

DBC.AreaFields

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

DBC.AreaUserAssignmentFields

Fields for AreaUserAssignment, Link table indicating which users actually reside in this area.

DBC.AreaUserInclusionFields

Fields for 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.

DBC.AssociateFields

Fields for Associate, Employees, resources and other users - except for External persons

DBC.AssociateGroupLinkFields

Fields for AssociateGroupLink, User group link table for Associate, for MDO item hiding

DBC.AssociateHeadingLinkFields

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

DBC.AssociateHistoryFields

Fields for 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

DBC.AttachmentFields

Fields for Attachment, 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.

DBC.AttachmentLocationFields

Fields for AttachmentLocation, A location for storing attachments

DBC.AudienceConfigFields

Fields for AudienceConfig, Configuration data for Audience core and webparts

DBC.AudienceLayoutFields

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

DBC.AudienceLayoutLinkFields

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

DBC.AudienceVisibilityFields

Fields for AudienceVisibility, How projects (or whatever) should be made visible in audience

DBC.AutosaveFields

Fields for Autosave, Autosaved text clobs from ejscript and emarketeer messages

DBC.BaseTZLocationFields

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

DBC.BatchTaskDefinitionFields

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

DBC.BatchTaskFields

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

DBC.BinaryObjectFields

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

DBC.BinaryObjectLinkFields

Fields for BinaryObjectLink, Link table, connects a BinaryObject with one or more owners

DBC.BusinessFields

Fields for Business, Business list table

DBC.BusinessGroupLinkFields

Fields for BusinessGroupLink, User group link table for Business, for MDO item hiding

DBC.BusinessHeadingLinkFields

Fields for BusinessHeadingLink, Heading link table for Business, for MDO headers

DBC.CacheInvalidationFields

Fields for CacheInvalidation, Names and generation numbers for distributed invalidation of caches

DBC.CacheTablesFields

Fields for CacheTables, 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.

DBC.CategoryFamilyFields

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

DBC.CategoryFields

Fields for Category, Category list table

DBC.CategoryGroupLinkFields

Fields for CategoryGroupLink, User group link table for Category, for MDO item hiding

DBC.CategoryHeadingLinkFields

Fields for CategoryHeadingLink, Heading link table for Category, for MDO headers

DBC.CategoryMembershipFields

Fields for CategoryMembership, This table connects users to categories (many-to-many).

DBC.ChatMessageFields

Fields for ChatMessage, This table contains messages in a chat session.

DBC.ChatSessionFields

Fields for ChatSession, This table contains chat sessions.

DBC.ChatTopicFields

Fields for ChatTopic, This table contains chat topics.

DBC.ChatTopicUserFields

Fields for ChatTopicUser, This table connected the chat topics with the users (i.e. the membership).

DBC.CompanyDomainFields

Fields for CompanyDomain, This table contains web-domains associated with a certain cust_company entry.

DBC.CompanyFields

Fields for 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.

DBC.ComptrFields

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

DBC.ComptrGroupLinkFields

Fields for ComptrGroupLink, User group link table for Comptr, for MDO item hiding

DBC.ComptrHeadingLinkFields

Fields for ComptrHeadingLink, Heading link table for Comptr, for MDO headers

DBC.ConfigFields

Fields for Config, This table contains certain system-wide configuration values.

DBC.ConfigurableScreenDeltaFields

Fields for ConfigurableScreenDelta, Parts of recipes in SCIL to insert or remove in given recipes

DBC.ConnectionConfigFieldFields

Fields for ConnectionConfigField, Configuration data for Erp and Quote Connections

DBC.ConsentPersonFields

Fields for ConsentPerson, Link table that defines who has which consents

DBC.ConsentPurposeFields

Fields for ConsentPurpose, GDPR purpose alternatives

DBC.ConsentSourceFields

Fields for ConsentSource, Consent source for GDPR

DBC.ContactFields

Fields for Contact, Companies and Organizations. This table features a special record containing information about the contact that owns the database.

DBC.ContactInterestFields

Fields for ContactInterest, Link-table between contact and interests in ContInt

DBC.ContIntFields

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

DBC.ContIntGroupLinkFields

Fields for ContIntGroupLink, User group link table for ContInt, for MDO item hiding

DBC.ContIntHeadingLinkFields

Fields for ContIntHeadingLink, Heading link table for ContInt, for MDO headers

DBC.CounterValueFields

Fields for CounterValue, Visible for rights

DBC.CountryFields

Fields for Country, Country information

DBC.CountryGroupLinkFields

Fields for CountryGroupLink, User group link table for Country, for MDO item hiding

DBC.CountryHeadingLinkFields

Fields for CountryHeadingLink, Heading link table for Country, for MDO headers

DBC.CredentialsFields

Fields for Credentials, Alternative credentials

DBC.CreditedFields

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

DBC.CreditedGroupLinkFields

Fields for CreditedGroupLink, User group link table for Credited, for MDO item hiding

DBC.CreditedHeadingLinkFields

Fields for CreditedHeadingLink, Heading link table for Credited, for MDO headers

DBC.CurrencyFields

Fields for Currency, Currency list table

DBC.CurrencyGroupLinkFields

Fields for CurrencyGroupLink, User group link table for Currency, for MDO item hiding

DBC.CurrencyHeadingLinkFields

Fields for CurrencyHeadingLink, Heading link table for Currency, for MDO headers

DBC.CustCategoryFields

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

DBC.CustConfigFields

Fields for CustConfig, This table contains JSON structures used for customizing the customer center

DBC.CustLangFields

Fields for CustLang, This table contains entries for customer languages.

DBC.DashboardFields

Fields for Dashboard, Describes a dashboard

DBC.DashboardThemeFields

Fields for DashboardTheme, A set of style rules for the Dashboard

DBC.DashboardTileDefinitionFields

Fields for DashboardTileDefinition, Describes the contents of a tile

DBC.DashboardTileFieldFields

Fields for DashboardTileField, Describes the contents of a tile field

DBC.DashboardTileFields

Fields for DashboardTile, Represents one tile in the dashboard

DBC.DatabaseModelFields

Fields for DatabaseModel, New DatabaseModel used by Continuous Database

DBC.DataRightFields

Fields for DataRight, Data right definition

DBC.DbiAgentFieldFields

Fields for DbiAgentField, DBI agent fields

DBC.DbiAgentFields

Fields for DbiAgent, DBI agent settings

DBC.DbiAgentScheduleFields

Fields for DbiAgentSchedule, DBI agent schedule settings

DBC.DeliveryTermsFields

Fields for DeliveryTerms, The list of Delivery terms, in the internal product register

DBC.DeliveryTermsGroupLinkFields

Fields for DeliveryTermsGroupLink, User group link table for DeliveryTerms, for MDO item hiding

DBC.DeliveryTermsHeadingLinkFields

Fields for DeliveryTermsHeadingLink, Heading link table for DeliveryTerms, for MDO item headings

DBC.DeliveryTypeFields

Fields for DeliveryType, The list of Delivery types, in the internal product register

DBC.DeliveryTypeGroupLinkFields

Fields for DeliveryTypeGroupLink, User group link table for DeliveryType, for MDO item hiding

DBC.DeliveryTypeHeadingLinkFields

Fields for DeliveryTypeHeadingLink, Heading link table for DeliveryType, for MDO item headings

DBC.DiaryViewFields

Fields for DiaryView, Configuration of a multi-user diary view

DBC.DiaryViewRowFields

Fields for DiaryViewRow, Configuration of a multi-user diary view

DBC.DictionaryBaseFields

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

DBC.DictionaryFields

Fields for Dictionary, User added dictionary words

DBC.DocDocumentFields

Fields for DocDocument, This table contains documents.

DBC.DocFolderFields

Fields for DocFolder, A document folder.

DBC.DocTmplFields

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

DBC.DocTmplGroupLinkFields

Fields for DocTmplGroupLink, User group link table for DocTmpl, for MDO item hiding

DBC.DocTmplHeadingLinkFields

Fields for DocTmplHeadingLink, Heading link table for DocTmpl, for MDO headers

DBC.DocumentFields

Fields for 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.

DBC.EabEntryFields

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

DBC.EabFolderFields

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

DBC.EjCategoryFields

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

DBC.EjCategoryGroupLinkFields

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

DBC.EjMessageFields

Fields for EjMessage, This table contains the messages listed under tickets.

DBC.EjpackageFields

Fields for Ejpackage, This table stores packages on the system.

DBC.EjpackageItemFields

Fields for EjpackageItem, This table stores info on installed packages in the system

DBC.EjRoleFields

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

DBC.EjscriptDebugFields

Fields for EjscriptDebug, This table contains information when debugging an ejscript

DBC.EjscriptFields

Fields for Ejscript, ejscript

DBC.EjselectionFields

Fields for Ejselection, This table stores selections, dynamic groups.

DBC.EjselEjselFields

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

DBC.EjselMetaResultFields

Fields for EjselMetaResult, This table stores result meta data

DBC.EjselResultSetFields

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

DBC.EjselSourceIdlistFields

Fields for EjselSourceIdlist, This table stores id list source for selections

DBC.EjselSourceScriptFields

Fields for EjselSourceScript, This table stores a selection script source

DBC.EjselSourceXmlFields

Fields for EjselSourceXml, This table stores a selection source as xml

DBC.EjuserFields

Fields for Ejuser, This table contains entries for the users of the system.

DBC.ElementProfileFields

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

DBC.EmailAccountFields

Fields for EmailAccount, Email account information

DBC.EmailAttachmentFields

Fields for EmailAttachment, Attachment info related to an email_item

DBC.EmailFields

Fields for Email, Email addresses for contacts, projects and persons

DBC.EmailFolderFields

Fields for EmailFolder, Corresponds to an email folder on a mail server

DBC.EmailItemFields

Fields for EmailItem, Email data

DBC.ErpConfigurationFields

Fields for ErpConfiguration, Global settings for the Erp Integration Server

DBC.ErpConnectionAccessFields

Fields for ErpConnectionAccess, Access control for Erp Connections

DBC.ErpConnectionActorTypeFields

Fields for ErpConnectionActorType, Data about the configuration of one Erp Actor on one ErpConnection

DBC.ErpConnectionFields

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

DBC.ErpConnectorFields

Fields for ErpConnector, One ERP Connector, known by its URL

DBC.ErpExternalKeyFields

Fields for ErpExternalKey, The external (ERP-facing) key related to a synchronized record / connection

DBC.ErpFieldFields

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

DBC.ErpInternalKeyFields

Fields for ErpInternalKey, The internal (superoffice-facing) key related to a synchronized record

DBC.ErpListItemMappingFields

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

DBC.ErpSyncLogFields

Fields for ErpSyncLog, Record all field changes done by the Erp Sync

DBC.ExtAppFields

Fields for ExtApp, ExtApp list table. Applications startable from SuperOffice

DBC.ExtAppGroupLinkFields

Fields for ExtAppGroupLink, User group link table for ExtApp, for MDO item hiding

DBC.ExtAppHeadingLinkFields

Fields for ExtAppHeadingLink, Heading link table for ExtApp, for MDO headers

DBC.ExtDatasourceFields

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

DBC.ExternalDocumentFields

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

DBC.ExternalEventFields

Fields for ExternalEvent, The definition of projects as events in Audience (or other Collaborative apps)

DBC.ExtFieldFields

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

DBC.ExtraFieldsFields

Fields for ExtraFields, This table contains entries for the extra fields in the system.

DBC.ExtraMenusFields

Fields for ExtraMenus, This table contains entries for the extra menus in the system.

DBC.ExtraTablesEntryFields

Fields for ExtraTablesEntry, Hits/entries in result set of executed search in ejournal extra tables

DBC.ExtraTablesFields

Fields for ExtraTables, This table contains entries for the extra tables in the system.

DBC.ExtraTablesResultFields

Fields for ExtraTablesResult, Result set of executed search in ejournal extra tables

DBC.ExtTableFields

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

DBC.FavouriteFields

Fields for Favourite, Favourite records (star-marking)

DBC.FieldLabelFields

Fields for 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.

DBC.ForeignAppFields

Fields for ForeignApp, Top level of Foreign Key system

DBC.ForeignDeviceFields

Fields for ForeignDevice, Middle level of Foreign Key system

DBC.ForeignKeyFields

Fields for 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.

DBC.FormFields

Fields for Form, A form which can be published on a webpage and submitted by visitors

DBC.FormKeysFields

Fields for FormKeys, Keys that makes sure a form is not posted twice

DBC.FormSubmissionFields

Fields for FormSubmission, A form submission

DBC.FreeTextIndexFields

Fields for FreeTextIndex, 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).

DBC.FreeTextStopWordsFields

Fields for FreeTextStopWords, 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.

DBC.FreeTextWordsFields

Fields for FreeTextWords, 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

DBC.FunctionRightFields

Fields for FunctionRight, Functional right definition

DBC.FunctionRightRoleLinkFields

Fields for FunctionRightRoleLink, Functional right definition

DBC.HeadingFields

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

DBC.HelpFields

Fields for Help, This table contains the help pages.

DBC.HierarchyFields

Fields for Hierarchy, This table contains folders used to group the extra tables in the system.

DBC.HistoryFields

Fields for 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.

DBC.HotlistFields

Fields for Hotlist, The table is used by the hotlist to store the relationship between tickets and users

DBC.ImportDefaultFields

Fields for ImportDefault, Defaults for import fields/objects

DBC.ImportFieldFields

Fields for ImportField, Import object types - see localetext for names

DBC.ImportObjectFields

Fields for ImportObject, Import object types - see localetext for names.

DBC.ImportRelationFields

Fields for ImportRelation, Relations between import objects

DBC.InboxFields

Fields for Inbox, Info and status for safe email import

DBC.IntentFields

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

DBC.IntentGroupLinkFields

Fields for IntentGroupLink, User group link table for Intent, for MDO item hiding

DBC.IntentHeadingLinkFields

Fields for IntentHeadingLink, Heading link table for Intent, for MDO headers

DBC.InvitationFields

Fields for Invitation, Invitations to events

DBC.InvoiceEntryFields

Fields for InvoiceEntry, This table contain all invoices, connected to a message

DBC.InvoiceFields

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

DBC.InvoiceSumFields

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

DBC.InvoiceTypeFields

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

DBC.ItemConfigFields

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

DBC.KbAttachmentFields

Fields for KbAttachment, This table connects FAQ entries to attachments.

DBC.KbCategoryFields

Fields for KbCategory, Knowledge base folder hierarchy

DBC.KbCategoryLogFields

Fields for KbCategoryLog, Who and when, if somebody edits a knowledge base folder

DBC.KbEntryCommentFields

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

DBC.KbEntryFields

Fields for KbEntry, This table contains FAQ entries.

DBC.KbEntryKeywordFields

Fields for KbEntryKeyword, This table contains all keywords for the faq entries

DBC.KbEntryLogFields

Fields for KbEntryLog, Who and when, if somebody edits a knowledge base entry

DBC.KbEntryWordsFields

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

DBC.KbGroupEntryFields

Fields for KbGroupEntry, This table contains group entries for FAQ groups.

DBC.KbGroupFields

Fields for KbGroup, 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.

DBC.KbHttpLinkFields

Fields for KbHttpLink, This table contains URL's associated with a single FAQ entry.

DBC.KbSolutionFinderEntryFields

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

DBC.KbSolutionFinderFields

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

DBC.KbWorkflowAccessFields

Fields for KbWorkflowAccess, Control of who can do what in a knowledge base workflow step

DBC.KbWorkflowFields

Fields for KbWorkflow, Knowledge base workflow steps

DBC.LanguageInfoCountryFields

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

DBC.LanguageInfoFields

Fields for LanguageInfo, Information about languages, from ISO standards and related information

DBC.LegalBaseFields

Fields for LegalBase, Legal base for GDPR (Article 6)

DBC.LegalHtmlTagsFields

Fields for LegalHtmlTags, 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

DBC.LicenseAssocLinkFields

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

DBC.LicenseSatlLinkFields

Fields for LicenseSatlLink, Link between License and Satellite, for per-database licenses

DBC.LocaleTextFields

Fields for 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.

DBC.LockingFields

Fields for Locking, Generic locking and error messages

DBC.LogDebugFields

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

DBC.LogEventsFields

Fields for LogEvents, System log

DBC.LoginCustomerFields

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

DBC.LoginFields

Fields for Login, This table contains entries for the user sessions.

DBC.MailAliasFields

Fields for MailAlias, 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.

DBC.MailBlockFields

Fields for MailBlock, 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.

DBC.MailInFilterFields

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

DBC.MailInUidlFields

Fields for MailInUidl, 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.

DBC.MergeMoveLogFields

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

DBC.MessageCustomersFields

Fields for MessageCustomers, This table contains all cutomers who are involved in a message

DBC.MessageFields

Fields for Message, Definition of a message, corresponding to the header of a protocol

DBC.MessageHandlerFields

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

DBC.MessageHeaderFields

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

DBC.MessageIdFields

Fields for MessageId, This table links an email message id to an eJournal item

DBC.ModuleLicenseFields

Fields for ModuleLicense, Module licenses, belonging to one single owner

DBC.ModuleOwnerFields

Fields for ModuleOwner, Unique owner of a set of licensed modules

DBC.MrMrsFields

Fields for MrMrs, MrMrs list table. List of salutations.

DBC.MrMrsGroupLinkFields

Fields for MrMrsGroupLink, User group link table for MrMrs, for MDO item hiding

DBC.MrMrsHeadingLinkFields

Fields for MrMrsHeadingLink, Heading link table for MrMrs, for MDO headers

DBC.MsFilterFields

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

DBC.MsFilterMailFields

Fields for MsFilterMail, This table connects mail filters (ms_filter) to mailboxes (mail_in_filter).

DBC.MsSubstituteFields

Fields for MsSubstitute, Regexp for extracting info from emails when they enter they system

DBC.MsTrashbinFields

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

DBC.NoticeFrameFields

Fields for NoticeFrame, PID controller for automatic adjustment of pop up message check rate

DBC.NotifyFields

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

DBC.OLEFieldFields

Fields for OLEField, Control data table for the OLE DB Provider

DBC.OLEFieldTextFields

Fields for OLEFieldText, Control data table for the OLE DB Provider

DBC.OLESubjectFields

Fields for OLESubject, Control data table for the OLE DB Provider

DBC.OLESubjectTextFields

Fields for OLESubjectText, Control data table for the OLE DB Provider

DBC.OLEViewFields

Fields for OLEView, Control data table for the OLE DB Provider

DBC.OLEViewTextFields

Fields for OLEViewText, Control data table for the OLE DB Provider

DBC.OnlineAppFields

Fields for OnlineApp, Echo and track information about Online Apps and their usage

DBC.OutboxFields

Fields for Outbox, Outgoing emails with sending status and other info

DBC.OutgoingMessageFields

Fields for OutgoingMessage, Delivery of outgoing messages to messageplugins, updated with status asynchroneously

DBC.OwnerContactLinkFields

Fields for 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.

DBC.PasswordRulesFields

Fields for PasswordRules, This table may contain one entry specifying rules for passwords.

DBC.PaymentTermsFields

Fields for PaymentTerms, The list of payment terms, in the internal product register

DBC.PaymentTermsGroupLinkFields

Fields for PaymentTermsGroupLink, User group link table for PaymentTerms, for MDO item hiding

DBC.PaymentTermsHeadingLinkFields

Fields for PaymentTermsHeadingLink, Heading link table for PaymentTerms, for MDO item headings

DBC.PaymentTypeFields

Fields for PaymentType, The list of payment types, in the internal product register

DBC.PaymentTypeGroupLinkFields

Fields for PaymentTypeGroupLink, User group link table for PaymentType, for MDO item hiding

DBC.PaymentTypeHeadingLinkFields

Fields for PaymentTypeHeadingLink, Heading link table for PaymentType, for MDO item headings

DBC.PersIntFields

Fields for PersInt, PersInt list table. List of Person interests.

DBC.PersIntGroupLinkFields

Fields for PersIntGroupLink, User group link table for PersInt, for MDO item hiding

DBC.PersIntHeadingLinkFields

Fields for PersIntHeadingLink, Heading link table for PersInt, for MDO headers

DBC.PersonFields

Fields for Person, Persons in a company or an organizations. All associates have a corresponding person record

DBC.PersonInterestFields

Fields for 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.

DBC.PersPosFields

Fields for PersPos, PersPos list table. Contact person position list

DBC.PersPosGroupLinkFields

Fields for PersPosGroupLink, User group link table for PersPos, for MDO item hiding

DBC.PersPosHeadingLinkFields

Fields for PersPosHeadingLink, Heading link table for PersPos, for MDO headers

DBC.PhoneFields

Fields for Phone, Contact and Person phonenumbers (+fax)

DBC.PhoneFormatFields

Fields for PhoneFormat, Formatting information for telephone numbers

DBC.PMembTypeFields

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

DBC.PMembTypeGroupLinkFields

Fields for PMembTypeGroupLink, User group link table for PMembType, for MDO item hiding

DBC.PMembTypeHeadingLinkFields

Fields for PMembTypeHeadingLink, Heading link table for PMembType, for MDO headers

DBC.PrefDescFields

Fields for 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.

DBC.PrefDescLineFields

Fields for 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.

DBC.PreferenceFields

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

DBC.PriceListFields

Fields for PriceList, List of prices, cached from an ERP system

DBC.PriceUnitFields

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

DBC.PriceUnitGroupLinkFields

Fields for PriceUnitGroupLink, User group link table for PriceUnit, for MDO item hiding

DBC.PriceUnitHeadingLinkFields

Fields for PriceUnitHeadingLink, Heading link table for PriceUnit, for MDO item headings

DBC.PriorityFields

Fields for Priority, Priority list table. Used with appointments: low, high.

DBC.PriorityGroupLinkFields

Fields for PriorityGroupLink, User group link table for Priority, for MDO item hiding

DBC.PriorityHeadingLinkFields

Fields for PriorityHeadingLink, Heading link table for Priority, for MDO headers

DBC.ProbFields

Fields for Prob, Prob list table. Probability, used in sales .

DBC.ProbGroupLinkFields

Fields for ProbGroupLink, User group link table for Prob, for MDO item hiding

DBC.ProbHeadingLinkFields

Fields for ProbHeadingLink, Heading link table for Prob, for MDO headers

DBC.ProductCategoryFields

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

DBC.ProductCategoryGroupLinkFields

Fields for ProductCategoryGroupLink, User group link table for ProductCategory, for MDO item hiding

DBC.ProductCategoryHeadingLinkFields

Fields for ProductCategoryHeadingLink, Heading link table for ProductCategory, for MDO item headings

DBC.ProductFamilyFields

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

DBC.ProductFamilyGroupLinkFields

Fields for ProductFamilyGroupLink, User group link table for ProductFamily, for MDO item hiding

DBC.ProductFamilyHeadingLinkFields

Fields for ProductFamilyHeadingLink, Heading link table for ProductFamily, for MDO item headings

DBC.ProductFields

Fields for Product, One Product, member of one price list

DBC.ProductTypeFields

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

DBC.ProductTypeGroupLinkFields

Fields for ProductTypeGroupLink, User group link table for ProductType, for MDO item hiding

DBC.ProductTypeHeadingLinkFields

Fields for ProductTypeHeadingLink, Heading link table for ProductType, for MDO item headings

DBC.ProductVersionFields

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

DBC.ProfileFields

Fields for Profile, Deprecated. This table contains entries for the user profiles.

DBC.ProjectFields

Fields for Project, Projects

DBC.ProjectMemberFields

Fields for ProjectMember, Project members. Link-table between person and project

DBC.ProjectTypeStatusLinkFields

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

DBC.ProjStatusFields

Fields for ProjStatus, ProjStatus list table. Project status

DBC.ProjStatusGroupLinkFields

Fields for ProjStatusGroupLink, User group link table for ProjStatus, for MDO item hiding

DBC.ProjStatusHeadingLinkFields

Fields for ProjStatusHeadingLink, Heading link table for ProjStatus, for MDO headers

DBC.ProjTypeFields

Fields for ProjType, ProjType list table. List of valid Project types.

DBC.ProjTypeGroupLinkFields

Fields for ProjTypeGroupLink, User group link table for ProjType, for MDO item hiding

DBC.ProjTypeHeadingLinkFields

Fields for ProjTypeHeadingLink, Heading link table for ProjType, for MDO headers

DBC.PublishFields

Fields for Publish, Publishing system for external users

DBC.PushNotificationServiceFields

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

DBC.QuickReplyFields

Fields for QuickReply, Personal quick reply text fragments

DBC.QuoteAlternativeFields

Fields for 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.

DBC.QuoteConnectionAccessFields

Fields for QuoteConnectionAccess, Access control for Quote Connections

DBC.QuoteConnectionFields

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

DBC.QuoteFields

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

DBC.QuoteLineConfigurationFields

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

DBC.QuoteLineFields

Fields for 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.

DBC.QuoteVersionAttachmentFields

Fields for QuoteVersionAttachment, Actual attachments to a quote

DBC.QuoteVersionFields

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

DBC.ReasonFields

Fields for Reason, Reason list table. Why we lost the sale (list)

DBC.ReasonGroupLinkFields

Fields for ReasonGroupLink, User group link table for Reason, for MDO item hiding

DBC.ReasonHeadingLinkFields

Fields for ReasonHeadingLink, Heading link table for Reason, for MDO headers

DBC.ReasonSoldFields

Fields for ReasonSold, Why was the sale marked as sold (why did we succeed)

DBC.ReasonSoldGroupLinkFields

Fields for ReasonSoldGroupLink, User group link table for ReasonSold, for MDO item hiding

DBC.ReasonSoldHeadingLinkFields

Fields for ReasonSoldHeadingLink, Heading link table for ReasonSold, for MDO headers

DBC.ReasonStalledFields

Fields for ReasonStalled, Why was the sale marked as stalled

DBC.ReasonStalledGroupLinkFields

Fields for ReasonStalledGroupLink, Link table for ReasonStalled, for MDO item hiding

DBC.ReasonStalledHeadingLinkFields

Fields for ReasonStalledHeadingLink, Heading link table for ReasonStalled, for MDO headers

DBC.RecurrenceRuleFields

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

DBC.RedLetterDayFields

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

DBC.RefCountRangeFields

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

DBC.RefCountsFields

Fields for 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.

DBC.RegistryFields

Fields for Registry, System settings

DBC.RejectReasonFields

Fields for RejectReason, Rejection reason (suggested) for bookings

DBC.RejectReasonGroupLinkFields

Fields for RejectReasonGroupLink, User group link table for Comptr, for MDO item hiding

DBC.RejectReasonHeadingLinkFields

Fields for RejectReasonHeadingLink, Heading link table for RejectReason, for MDO headers

DBC.RelationDefinitionFields

Fields for 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".

DBC.RelationDefinitionGroupLinkFields

Fields for RelationDefinitionGroupLink, User group link table for RelDef, for MDO item hiding

DBC.RelationDefinitionHeadingLinkFields

Fields for RelationDefinitionHeadingLink, Heading link table for RelDef, for MDO headers

DBC.RelationsFields

Fields for 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.

DBC.RelationTargetFields

Fields for 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.

DBC.ReplyTemplateAttachmentFields

Fields for ReplyTemplateAttachment, This table is used to connect attachments to reply templates (many-to-many).

DBC.ReplyTemplateBodyFields

Fields for ReplyTemplateBody, Contains the body of the reply templates in different languages

DBC.ReplyTemplateFields

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

DBC.ReplyTemplateFolderFields

Fields for ReplyTemplateFolder, This table contains entries for folders for reply templates.

DBC.ReporterListDefFields

Fields for ReporterListDef, Reporter definitions

DBC.ResourceOverrideFields

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

DBC.RoleCategoryFields

Fields for RoleCategory, Category membership associated with a role

DBC.RoleElementFields

Fields for RoleElement, Profiles associated with a role

DBC.RoleFields

Fields for 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

DBC.RoleMemberFields

Fields for RoleMember, Users linked to a role. Deprecated.

DBC.RoleWorkflowFields

Fields for RoleWorkflow, Knowledge base workflow access rights associated with a role

DBC.SaintConfigurationFields

Fields for SaintConfiguration, Configuration information for the Saint system

DBC.SaleFields

Fields for Sale, Sales For every Sale record edited through the SuperOffice GUI, a copy of the previous 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.

DBC.SaleHistFields

Fields for SaleHist, Mirror image of the Sale table, providing a full transaction history. Every time you edit a sale, the previous record of the sale is moved here.

DBC.SaleStakeholderFields

Fields for SaleStakeholder, Stakeholders in the sale, very similar to project members

DBC.SaleTypeCatFields

Fields for SaleTypeCat, Category for sale type

DBC.SaleTypeCatGroupLinkFields

Fields for SaleTypeCatGroupLink, User group link table for SaleTypeCat, for MDO item hiding

DBC.SaleTypeCatHeadingLinkFields

Fields for SaleTypeCatHeadingLink, Heading link table for SaleTypeCat, for MDO headers

DBC.SaleTypeFields

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

DBC.SaleTypeGroupLinkFields

Fields for SaleTypeGroupLink, User group link table for SaleType, for MDO item hiding

DBC.SaleTypeHeadingLinkFields

Fields for SaleTypeHeadingLink, Heading link table for SaleType, for MDO headers

DBC.SaleTypeQuoteAttachmentFields

Fields for SaleTypeQuoteAttachment, Default attachments to quotes linked to sales of this type

DBC.SaleTypeStageLinkFields

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

DBC.SalutationFields

Fields for Salutation, Academic title for Person

DBC.SalutationGroupLinkFields

Fields for SalutationGroupLink, User group link table for Salutation, for MDO item hiding

DBC.SalutationHeadingLinkFields

Fields for SalutationHeadingLink, Heading link table for Salutation, for MDO headers

DBC.SatelliteFields

Fields for Satellite, Definition of Satellites

DBC.SAttachmentFields

Fields for SAttachment, A connector between a message and attachments. One message can contain many attachments.

DBC.SBounceShipmentFields

Fields for SBounceShipment, Email bounces from customers

DBC.ScheduledTaskFields

Fields for ScheduledTask, A scheduled entry executing a script at certain times

DBC.ScheduleFields

Fields for Schedule, Generic scheduled tasked handling time scheduling, locking and error messages

DBC.ScreenChooserFields

Fields for ScreenChooser, Screen choosers

DBC.ScreenDefinitionActionFields

Fields for ScreenDefinitionAction, An action to perform for a certain button in an screen

DBC.ScreenDefinitionElementFields

Fields for ScreenDefinitionElement, An element in a configurable screen

DBC.ScreenDefinitionFields

Fields for ScreenDefinition, A configurable screen

DBC.ScreenDefinitionHiddenFields

Fields for ScreenDefinitionHidden, The name of a hidden variable to keep for this screen

DBC.ScreenDefinitionLanguageFields

Fields for ScreenDefinitionLanguage, Custom language variables used for screens

DBC.ScriptTraceFields

Fields for ScriptTrace, Scripts which should be traced

DBC.ScriptTraceRunFields

Fields for ScriptTraceRun, Traces of executed scripts

DBC.SDynCriteriaFields

Fields for SDynCriteria, Contains criterias for a dynamic list.

DBC.SearchCatFields

Fields for SearchCat, SearchCat list table

DBC.SearchCatGroupLinkFields

Fields for SearchCatGroupLink, User group link table for SearchCat, for MDO item hiding

DBC.SearchCatHeadingLinkFields

Fields for SearchCatHeadingLink, Heading link table for SearchCat, for MDO headers

DBC.SearchCriteriaFields

Fields for SearchCriteria, Criteria storage for Selection and other Find mechanisms

DBC.SearchCriteriaGroupFields

Fields for SearchCriteriaGroup, Criteria storage for Selection and other Find mechanisms

DBC.SearchCriterionFields

Fields for SearchCriterion, Criteria storage for Selection and other Find mechanisms

DBC.SearchCriterionValueFields

Fields for SearchCriterionValue, Criteria storage for Selection and other Find mechanisms

DBC.SelectionFields

Fields for Selection, Selections

DBC.SelectionMemberFields

Fields for SelectionMember, 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.

DBC.SequenceFields

Fields for Sequence, next_id to be used for each table

DBC.ServiceAuthFields

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

DBC.SessionObjectFields

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

DBC.ShipmentTypeFields

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

DBC.ShipmentTypeReservationFields

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

DBC.SLinkCustomerFields

Fields for SLinkCustomer, A connection between a customer and a link. Registered customers are identified when clicking on a link

DBC.SLinkCustomerStaticalFields

Fields for SLinkCustomerStatical, A connection between a customer and a link. Registered customers are identified when clicking on a link

DBC.SLinkFields

Fields for SLink, Links in messages to measure success rate of a campaign.

DBC.SListCustomerFields

Fields for SListCustomer, Elements in a customer list.

DBC.SListElementFields

Fields for SListElement, Elements in a static list.

DBC.SListFields

Fields for SList, A list, dynamic or static

DBC.SListShipmentFields

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

DBC.SMessageblockFields

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

DBC.SMessageFields

Fields for SMessage, A message used in a shipment. Can be html and/or plain text

DBC.SmsFields

Fields for Sms, This table will hold outgoing sms messages when transmitted with WebServices

DBC.SmsHysteriaFields

Fields for SmsHysteria, Avoid sending too many sms messages in a short time interval to one person

DBC.SnapshotFields

Fields for Snapshot, Snapshots taken of the system database and attachments via soap

DBC.SoapAccessFields

Fields for SoapAccess, Table that contains constraints on the access to the soap interface

DBC.SORCriteriaFields

Fields for SORCriteria, SuperOffice reporter data

DBC.SORFCTFields

Fields for SORFCT, SuperOffice reporter data

DBC.SORFieldFields

Fields for SORField, SuperOffice reporter data

DBC.SORLabelLayoutFields

Fields for SORLabelLayout, SuperOffice reporter data

DBC.SOROperatorsFields

Fields for SOROperators, SuperOffice reporter data

DBC.SORPublishFields

Fields for SORPublish, SuperOffice reporter data

DBC.SORPublishGroupLinkFields

Fields for SORPublishGroupLink, Link table used for filtering reports by user group

DBC.SORSectionFields

Fields for SORSection, SuperOffice reporter data

DBC.SORTemplateFields

Fields for SORTemplate, SuperOffice reporter data

DBC.SourceFields

Fields for Source, Source list table. Source for sale (list)

DBC.SourceGroupLinkFields

Fields for SourceGroupLink, User group link table for Source, for MDO item hiding

DBC.SourceHeadingLinkFields

Fields for SourceHeadingLink, Heading link table for Source, for MDO headers

DBC.SPictureEntryFields

Fields for SPictureEntry, This table describes each picture in the database

DBC.SPictureFolderFields

Fields for SPictureFolder, This table contains all picture folders

DBC.SSentMessageFields

Fields for SSentMessage, Emarketeer message control

DBC.SShipmentAddrFields

Fields for SShipmentAddr, Addresses that are ready to be sent in a shipment.

DBC.SShipmentFields

Fields for SShipment, Contains info about one shipment. The addresses are stored in s_shipment_addr

DBC.SSmtpServersFields

Fields for SSmtpServers, Contains the smtp server for a shipment

DBC.StakeholderRoleFields

Fields for StakeholderRole, Role a stakeholder has in a sale

DBC.StakeholderRoleGroupLinkFields

Fields for StakeholderRoleGroupLink, User group link table for StakeholderRole, for MDO item hiding

DBC.StakeholderRoleHeadingLinkFields

Fields for StakeholderRoleHeadingLink, Heading link table for StakeholderRole, for MDO headers

DBC.StaticListRefFields

Fields for StaticListRef, This table stores id references for selections id lists

DBC.StatusDefFields

Fields for StatusDef, Status definitions. Name and description are in LocaleText for internationalization

DBC.StatusValueFields

Fields for StatusValue, Values for statuses

DBC.SubscriptionUnitFields

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

DBC.SubscriptionUnitGroupLinkFields

Fields for SubscriptionUnitGroupLink, User group link table for SubscriptionUnit, for MDO item hiding

DBC.SubscriptionUnitHeadingLinkFields

Fields for SubscriptionUnitHeadingLink, Heading link table for SubscriptionUnit, for MDO item headings

DBC.SuggestedAppointmentFields

Fields for SuggestedAppointment, Defines a suggested appointment for use in a Sale Guide or Project Guide

DBC.SuggestedDocumentFields

Fields for SuggestedDocument, Unique owner of a set of licensed modules

DBC.SuperListColumnSizeFields

Fields for SuperListColumnSize, Stores the relative size (in percent) or in characters of a column in a SuperList

DBC.SWashingFields

Fields for SWashing, Register of all bounced mail to enabel washing

DBC.SWashingListFields

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

DBC.SystemEventFields

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

DBC.SystemScriptFields

Fields for SystemScript, A table containing the system script

DBC.TabOrderFields

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

DBC.TagsFields

Fields for Tags, MDO List of tags for Service entities

DBC.TagsGroupLinkFields

Fields for TagsGroupLink, User group link table for Tags, for MDO item hiding

DBC.TagsHeadingLinkFields

Fields for TagsHeadingLink, Heading link table for Source, for MDO headers

DBC.TaskFields

Fields for Task, Task list table, activity types, like Phone, Meeting

DBC.TaskGroupLinkFields

Fields for TaskGroupLink, User group link table for Task, for MDO item hiding

DBC.TaskHeadingLinkFields

Fields for TaskHeadingLink, Heading link table for Task, for MDO headers

DBC.TemporaryKeyFields

Fields for TemporaryKey, Temporary keys for lightweight authentications such as changing ones subscriptions

DBC.TemporaryWordsFields

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

DBC.TextFields

Fields for Text, Long text fields from all over the system

DBC.TicketAlertFields

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

DBC.TicketAttachmentFields

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

DBC.TicketCustomersFields

Fields for TicketCustomers, This table allows several customers to be connected to several tickets (many-to-many)

DBC.TicketFields

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

DBC.TicketLogActionFields

Fields for TicketLogAction, This table contains actions for the tickets.

DBC.TicketLogChangeFields

Fields for TicketLogChange, This table contains log entries for the tickets.

DBC.TicketLogFields

Fields for TicketLog, This table contains log entries for the tickets.

DBC.TicketPriorityFields

Fields for TicketPriority, This table contains the ticket priorities.

DBC.TicketRelationActionFields

Fields for TicketRelationAction, Contains ticket relation actions, used to drive processing logic together with ticket relations

DBC.TicketRelationFields

Fields for TicketRelation, Contains ticket relations, used to drive processing logic

DBC.TicketRelationTypeFields

Fields for TicketRelationType, Contains ticket relation types, used to drive processing logic together with ticket relations

DBC.TicketStatusFields

Fields for TicketStatus, This table user defined ticket status values.

DBC.TicketStatusHistoryFields

Fields for TicketStatusHistory, 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

DBC.TicketTypeFields

Fields for TicketType, Contains ticket types, used to drive processing logic together with ticket relations

DBC.TimestampsFields

Fields for Timestamps, Timestamp information

DBC.TravelCurrentFields

Fields for TravelCurrent, Information about this database and its place in the hierarchy

DBC.TravelGeneratedDatabaseFields

Fields for TravelGeneratedDatabase, Information about all databases generated from this database

DBC.TravelGeneratedTransactionFields

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

DBC.TravelIDMappingFields

Fields for 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.

DBC.TravellerFields

Fields for Traveller, Associates traveling out from this database

DBC.TravelTransactionLogFields

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

DBC.TrayAppFields

Fields for TrayApp, Tray application presence. SuperOffice CRM web extensions.

DBC.TreeExplorerEntryFields

Fields for TreeExplorerEntry, This table stores the entries in a tree-explorer

DBC.TreeExplorerLinkFields

Fields for TreeExplorerLink, This table stores the link of entries in a tree-explorer

DBC.TypicalSearchFields

Fields for TypicalSearch, Owner of a set of predefined selection criteria

DBC.TZDstRuleFields

Fields for TZDstRule, Time zone rule for daylight saving time

DBC.TZLocationFields

Fields for TZLocation, Time zone location

DBC.TZStdRuleFields

Fields for TZStdRule, Time zone rule for standard time

DBC.UDAppntLargeFields

Fields for UDAppntLarge, User-defined fields

DBC.UDAppntSmallFields

Fields for UDAppntSmall, User-defined fields

DBC.UDContactLargeFields

Fields for UDContactLarge, User-defined fields for contact (long strings)

DBC.UDContactSmallFields

Fields for UDContactSmall, User-defined fields for contact

DBC.UDDocLargeFields

Fields for UDDocLarge, User-defined fields

DBC.UDDocSmallFields

Fields for UDDocSmall, User-defined fields

DBC.UDefFieldFields

Fields for 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.

DBC.UDefFieldGLFields

Fields for UDefFieldGL, User group link table for UDefField, for MDO item hiding

DBC.UDListDefinitionFields

Fields for 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.

DBC.UDListFields

Fields for 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.

DBC.UDListGroupLinkFields

Fields for 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.

DBC.UDListHeadingLinkFields

Fields for 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.

DBC.UDPersonLargeFields

Fields for UDPersonLarge, User-defined fields

DBC.UDPersonSmallFields

Fields for UDPersonSmall, User-defined fields

DBC.UDProjectLargeFields

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

DBC.UDProjectSmallFields

Fields for UDProjectSmall, User-defined fields

DBC.UDSaleLargeFields

Fields for UDSaleLarge, User-defined fields

DBC.UDSaleSmallFields

Fields for UDSaleSmall, User-defined fields

DBC.UDTempLargeFields

Fields for UDTempLarge, User-defined fields

DBC.UDTempSmallFields

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

DBC.URLFields

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

DBC.UsageStatsFields

Fields for UsageStats, Usage statistics

DBC.UserAttributeFields

Fields for UserAttribute, This table is used for storing various attributes for users.

DBC.UserCandidateFields

Fields for UserCandidate, This table will hold user candidate secrets

DBC.UserGroupFields

Fields for UserGroup, Secondary user groups

DBC.UserGroupLinkFields

Fields for 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.

DBC.UserPreferenceFields

Fields for UserPreference, Preference system. If deflevel is set to 5; the user may change the preferences

DBC.UserRoleLinkFields

Fields for UserRoleLink, Link between user role and user

DBC.VisibleForFields

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

DBC.WebAppUsageFields

Fields for WebAppUsage, Usage statistics for web applications

DBC.WebhookFields

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

DBC.WinPosSizeFields

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

DBC.WordRelationsFields

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

DBC.WsdlDescriptionFields

Fields for WsdlDescription, Soap wsdl files

DBC.ZipToCityFields

Fields for ZipToCity, Zip codes and city names. Zip codes used during address entry. You will find more information about addressformat on http://techdoc.superoffice.com

DbiAgentFieldTableInfo

Table 'dbi_agent_field': DBI agent fields

DbiAgentScheduleTableInfo

Table 'dbi_agent_schedule': DBI agent schedule settings

DbiAgentTableInfo

Table 'dbi_agent': DBI agent settings

DeliveryTermsGroupLinkTableInfo

Table 'DeliveryTermsGroupLink': User group link table for DeliveryTerms, for MDO item hiding

DeliveryTermsHeadingLinkTableInfo

Table 'DeliveryTermsHeadingLink': Heading link table for DeliveryTerms, for MDO item headings

DeliveryTermsTableInfo

Table 'DeliveryTerms': The list of Delivery terms, in the internal product register

DeliveryTypeGroupLinkTableInfo

Table 'DeliveryTypeGroupLink': User group link table for DeliveryType, for MDO item hiding

DeliveryTypeHeadingLinkTableInfo

Table 'DeliveryTypeHeadingLink': Heading link table for DeliveryType, for MDO item headings

DeliveryTypeTableInfo

Table 'DeliveryType': The list of Delivery types, in the internal product register

DiaryViewRowTableInfo

Table 'DiaryViewRow': Configuration of a multi-user diary view

DiaryViewTableInfo

Table 'DiaryView': Configuration of a multi-user diary view

DictionaryBaseTableInfo

Table 'dictionary_base': Language catalog for the ejournal dictionaries (automatic proof reading of message text etc)

DictionaryTableInfo

Table 'dictionary': User added dictionary words

DocDocumentTableInfo

Table 'doc_document': This table contains documents.

DocFolderTableInfo

Table 'doc_folder': A document folder.

DocTmplGroupLinkTableInfo

Table 'DocTmplGroupLink': User group link table for DocTmpl, for MDO item hiding

DocTmplHeadingLinkTableInfo

Table 'DocTmplHeadingLink': Heading link table for DocTmpl, for MDO headers

DocTmplTableInfo

Table 'DocTmpl': DocTmpl list table. Describes templates available for writing new documents.

DocumentTableInfo

Table '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.

EabEntryTableInfo

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

EabFolderTableInfo

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

EjCategoryGroupLinkTableInfo

Table 'EjCategoryGroupLink': User group link table for EjCategory, for mass handling ej_category members

EjCategoryTableInfo

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

EjMessageTableInfo

Table 'ej_message': This table contains the messages listed under tickets.

EjpackageItemTableInfo

Table 'ejpackage_item': This table stores info on installed packages in the system

EjpackageTableInfo

Table 'ejpackage': This table stores packages on the system.

EjRoleTableInfo

Table 'ej_role': Define access rights, memberships and other properties for role user members

EjscriptDebugTableInfo

Table 'ejscript_debug': This table contains information when debugging an ejscript

EjscriptTableInfo

Table 'ejscript': ejscript

EjselectionTableInfo

Table 'ejselection': This table stores selections, dynamic groups.

EjselEjselTableInfo

Table 'ejsel_ejsel': This table defines sources for complex selections in a many/many relationship

EjselMetaResultTableInfo

Table 'ejsel_meta_result': This table stores result meta data

EjselResultSetTableInfo

Table 'ejsel_result_set': This table stores result set reference data, result sets for selections

EjselSourceIdlistTableInfo

Table 'ejsel_source_idlist': This table stores id list source for selections

EjselSourceScriptTableInfo

Table 'ejsel_source_script': This table stores a selection script source

EjselSourceXmlTableInfo

Table 'ejsel_source_xml': This table stores a selection source as xml

EjuserTableInfo

Table 'ejuser': This table contains entries for the users of the system.

ElementProfileTableInfo

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

EmailAccountTableInfo

Table 'email_account': Email account information

EmailAttachmentTableInfo

Table 'email_attachment': Attachment info related to an email_item

EmailFolderTableInfo

Table 'email_folder': Corresponds to an email folder on a mail server

EmailItemTableInfo

Table 'email_item': Email data

EmailTableInfo

Table 'Email': Email addresses for contacts, projects and persons

ErpConfigurationTableInfo

Table 'ErpConfiguration': Global settings for the Erp Integration Server

ErpConnectionAccessTableInfo

Table 'ErpConnectionAccess': Access control for Erp Connections

ErpConnectionActorTypeTableInfo

Table 'ErpConnectionActorType': Data about the configuration of one Erp Actor on one ErpConnection

ErpConnectionTableInfo

Table 'ErpConnection': One connection to an ERP connector, specifying Client and other required information

ErpConnectorTableInfo

Table 'ErpConnector': One ERP Connector, known by its URL

ErpExternalKeyTableInfo

Table 'ErpExternalKey': The external (ERP-facing) key related to a synchronized record / connection

ErpFieldTableInfo

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

ErpInternalKeyTableInfo

Table 'ErpInternalKey': The internal (superoffice-facing) key related to a synchronized record

ErpListItemMappingTableInfo

Table 'ErpListItemMapping': Defines a mapping of ERP to CRM fields, per connection and actor type

ErpSyncLogTableInfo

Table 'ErpSyncLog': Record all field changes done by the Erp Sync

ExtAppGroupLinkTableInfo

Table 'ExtAppGroupLink': User group link table for ExtApp, for MDO item hiding

ExtAppHeadingLinkTableInfo

Table 'ExtAppHeadingLink': Heading link table for ExtApp, for MDO headers

ExtAppTableInfo

Table 'ExtApp': ExtApp list table. Applications startable from SuperOffice

ExtDatasourceTableInfo

Table 'ext_datasource': This table contains external datasources, used for databaseintegration of customers and companies.

ExternalDocumentTableInfo

Table 'external_document': This table stores documents which can be viewed externaly, through the customer module

ExternalEventTableInfo

Table 'ExternalEvent': The definition of projects as events in Audience (or other Collaborative apps)

ExtFieldTableInfo

Table 'ext_field': This table contains entries mapping an external field to an internal field. Used for database integration.

ExtraFieldsTableInfo

Table 'extra_fields': This table contains entries for the extra fields in the system.

ExtraMenusTableInfo

Table 'extra_menus': This table contains entries for the extra menus in the system.

ExtraTablesEntryTableInfo

Table 'extra_tables_entry': Hits/entries in result set of executed search in ejournal extra tables

ExtraTablesResultTableInfo

Table 'extra_tables_result': Result set of executed search in ejournal extra tables

ExtraTablesTableInfo

Table 'extra_tables': This table contains entries for the extra tables in the system.

ExtTableTableInfo

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

FavouriteTableInfo

Table 'Favourite': Favourite records (star-marking)

FieldLabelTableInfo

Table '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.

ForeignAppTableInfo

Table 'foreignapp': Top level of Foreign Key system

ForeignDeviceTableInfo

Table 'foreigndevice': Middle level of Foreign Key system

ForeignKeyTableInfo

Table '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.

FormKeysTableInfo

Table 'form_keys': Keys that makes sure a form is not posted twice

FormSubmissionTableInfo

Table 'form_submission': A form submission

FormTableInfo

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

FreeTextIndexTableInfo

Table 'freetextindex': 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).

FreeTextStopWordsTableInfo

Table 'freetextstopwords': 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.

FreeTextWordsTableInfo

Table 'freetextwords': 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

FunctionRightRoleLinkTableInfo

Table 'FunctionRightRoleLink': Functional right definition

FunctionRightTableInfo

Table 'FunctionRight': Functional right definition

GenericTableInfo

'Generic' tableinfo class, that can be used to represent any table that is defined in the runtime dictionary in the database. These can be both system tables and user-defined tables. It does not provide a typed interface to the individual fields.

HeadingTableInfo

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

HelpTableInfo

Table 'help': This table contains the help pages.

HierarchyTableInfo

Table 'hierarchy': This table contains folders used to group the extra tables in the system.

HistoryTableInfo

Table '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.

HotlistTableInfo

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

ImportDefaultTableInfo

Table 'ImportDefault': Defaults for import fields/objects

ImportFieldTableInfo

Table 'ImportField': Import object types - see localetext for names

ImportObjectTableInfo

Table 'ImportObject': Import object types - see localetext for names.

ImportRelationTableInfo

Table 'ImportRelation': Relations between import objects

InboxTableInfo

Table 'inbox': Info and status for safe email import

IntentGroupLinkTableInfo

Table 'IntentGroupLink': User group link table for Intent, for MDO item hiding

IntentHeadingLinkTableInfo

Table 'IntentHeadingLink': Heading link table for Intent, for MDO headers

IntentTableInfo

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

InvitationTableInfo

Table 'invitation': Invitations to events

InvoiceEntryTableInfo

Table 'invoice_entry': This table contain all invoices, connected to a message

InvoiceSumTableInfo

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

InvoiceTableInfo

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

InvoiceTypeTableInfo

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

ItemConfigTableInfo

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

KbAttachmentTableInfo

Table 'kb_attachment': This table connects FAQ entries to attachments.

KbCategoryLogTableInfo

Table 'kb_category_log': Who and when, if somebody edits a knowledge base folder

KbCategoryTableInfo

Table 'kb_category': Knowledge base folder hierarchy

KbEntryCommentTableInfo

Table 'kb_entry_comment': Comments to entries in the knowledge base, typically made by customers

KbEntryKeywordTableInfo

Table 'kb_entry_keyword': This table contains all keywords for the faq entries

KbEntryLogTableInfo

Table 'kb_entry_log': Who and when, if somebody edits a knowledge base entry

KbEntryTableInfo

Table 'kb_entry': This table contains FAQ entries.

KbEntryWordsTableInfo

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

KbGroupEntryTableInfo

Table 'kb_group_entry': This table contains group entries for FAQ groups.

KbGroupTableInfo

Table 'kb_group': 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.

KbHttpLinkTableInfo

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

KbSolutionFinderEntryTableInfo

Table 'kb_solution_finder_entry': Knowledge base problem solving wizard, items in a category linking to a knowledge base entry

KbSolutionFinderTableInfo

Table 'kb_solution_finder': Knowledge base problem solving wizard, categories and subcategories for drilling down

KbWorkflowAccessTableInfo

Table 'kb_workflow_access': Control of who can do what in a knowledge base workflow step

KbWorkflowTableInfo

Table 'kb_workflow': Knowledge base workflow steps

LanguageInfoCountryTableInfo

Table 'LanguageInfoCountry': Many-many link between countries and languages, to give intelligent choices for language

LanguageInfoTableInfo

Table 'LanguageInfo': Information about languages, from ISO standards and related information

LegalBaseTableInfo

Table 'LegalBase': Legal base for GDPR (Article 6)

LegalHtmlTagsTableInfo

Table 'legal_html_tags': 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

LicenseAssocLinkTableInfo

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

LicenseSatlLinkTableInfo

Table 'LicenseSatlLink': Link between License and Satellite, for per-database licenses

LocaleTextTableInfo

Table '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.

LockingTableInfo

Table 'locking': Generic locking and error messages

LogDebugTableInfo

Table 'log_debug': A log used for debugging, especially useful for bLogic/ejscript

LogEventsTableInfo

Table 'log_events': System log

LoginCustomerTableInfo

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

LoginTableInfo

Table 'login': This table contains entries for the user sessions.

MailAliasTableInfo

Table 'mail_alias': 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.

MailBlockTableInfo

Table 'mail_block': 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.

MailInFilterTableInfo

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

MailInUidlTableInfo

Table 'mail_in_uidl': 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.

MergeMoveLogTableInfo

Table 'MergeMoveLog': Log of merge and move operations (person, contact, project)

MessageCustomersTableInfo

Table 'message_customers': This table contains all cutomers who are involved in a message

MessageHandlerTableInfo

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

MessageHeaderTableInfo

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

MessageIdTableInfo

Table 'message_id': This table links an email message id to an eJournal item

MessageTableInfo

Table 'Message': Definition of a message, corresponding to the header of a protocol

ModuleLicenseTableInfo

Table 'ModuleLicense': Module licenses, belonging to one single owner

ModuleOwnerTableInfo

Table 'ModuleOwner': Unique owner of a set of licensed modules

MrMrsGroupLinkTableInfo

Table 'MrMrsGroupLink': User group link table for MrMrs, for MDO item hiding

MrMrsHeadingLinkTableInfo

Table 'MrMrsHeadingLink': Heading link table for MrMrs, for MDO headers

MrMrsTableInfo

Table 'MrMrs': MrMrs list table. List of salutations.

MsFilterMailTableInfo

Table 'ms_filter_mail': This table connects mail filters (ms_filter) to mailboxes (mail_in_filter).

MsFilterTableInfo

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

MsSubstituteTableInfo

Table 'ms_substitute': Regexp for extracting info from emails when they enter they system

MsTrashbinTableInfo

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

NoticeFrameTableInfo

Table 'notice_frame': PID controller for automatic adjustment of pop up message check rate

NotifyTableInfo

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

OLEFieldTableInfo

Table 'OLEField': Control data table for the OLE DB Provider

OLEFieldTextTableInfo

Table 'OLEFieldText': Control data table for the OLE DB Provider

OLESubjectTableInfo

Table 'OLESubject': Control data table for the OLE DB Provider

OLESubjectTextTableInfo

Table 'OLESubjectText': Control data table for the OLE DB Provider

OLEViewTableInfo

Table 'OLEView': Control data table for the OLE DB Provider

OLEViewTextTableInfo

Table 'OLEViewText': Control data table for the OLE DB Provider

OnlineAppTableInfo

Table 'OnlineApp': Echo and track information about Online Apps and their usage

OutboxTableInfo

Table 'outbox': Outgoing emails with sending status and other info

OutgoingMessageTableInfo

Table 'outgoing_message': Delivery of outgoing messages to messageplugins, updated with status asynchroneously

OwnerContactLinkTableInfo

Table '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.

PasswordRulesTableInfo

Table 'password_rules': This table may contain one entry specifying rules for passwords.

PaymentTermsGroupLinkTableInfo

Table 'PaymentTermsGroupLink': User group link table for PaymentTerms, for MDO item hiding

PaymentTermsHeadingLinkTableInfo

Table 'PaymentTermsHeadingLink': Heading link table for PaymentTerms, for MDO item headings

PaymentTermsTableInfo

Table 'PaymentTerms': The list of payment terms, in the internal product register

PaymentTypeGroupLinkTableInfo

Table 'PaymentTypeGroupLink': User group link table for PaymentType, for MDO item hiding

PaymentTypeHeadingLinkTableInfo

Table 'PaymentTypeHeadingLink': Heading link table for PaymentType, for MDO item headings

PaymentTypeTableInfo

Table 'PaymentType': The list of payment types, in the internal product register

PersIntGroupLinkTableInfo

Table 'PersIntGroupLink': User group link table for PersInt, for MDO item hiding

PersIntHeadingLinkTableInfo

Table 'PersIntHeadingLink': Heading link table for PersInt, for MDO headers

PersIntTableInfo

Table 'PersInt': PersInt list table. List of Person interests.

PersonInterestTableInfo

Table '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.

PersonTableInfo

Table 'person': Persons in a company or an organizations. All associates have a corresponding person record

PersPosGroupLinkTableInfo

Table 'PersPosGroupLink': User group link table for PersPos, for MDO item hiding

PersPosHeadingLinkTableInfo

Table 'PersPosHeadingLink': Heading link table for PersPos, for MDO headers

PersPosTableInfo

Table 'PersPos': PersPos list table. Contact person position list

PhoneFormatTableInfo

Table 'PhoneFormat': Formatting information for telephone numbers

PhoneTableInfo

Table 'phone': Contact and Person phonenumbers (+fax)

PMembTypeGroupLinkTableInfo

Table 'PMembTypeGroupLink': User group link table for PMembType, for MDO item hiding

PMembTypeHeadingLinkTableInfo

Table 'PMembTypeHeadingLink': Heading link table for PMembType, for MDO headers

PMembTypeTableInfo

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

PrefDescLineTableInfo

Table '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.

PrefDescTableInfo

Table '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.

PreferenceTableInfo

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

PriceListTableInfo

Table 'PriceList': List of prices, cached from an ERP system

PriceUnitGroupLinkTableInfo

Table 'PriceUnitGroupLink': User group link table for PriceUnit, for MDO item hiding

PriceUnitHeadingLinkTableInfo

Table 'PriceUnitHeadingLink': Heading link table for PriceUnit, for MDO item headings

PriceUnitTableInfo

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

PriorityGroupLinkTableInfo

Table 'PriorityGroupLink': User group link table for Priority, for MDO item hiding

PriorityHeadingLinkTableInfo

Table 'PriorityHeadingLink': Heading link table for Priority, for MDO headers

PriorityTableInfo

Table 'Priority': Priority list table. Used with appointments: low, high.

ProbGroupLinkTableInfo

Table 'ProbGroupLink': User group link table for Prob, for MDO item hiding

ProbHeadingLinkTableInfo

Table 'ProbHeadingLink': Heading link table for Prob, for MDO headers

ProbTableInfo

Table 'Prob': Prob list table. Probability, used in sales .

ProductCategoryGroupLinkTableInfo

Table 'ProductCategoryGroupLink': User group link table for ProductCategory, for MDO item hiding

ProductCategoryHeadingLinkTableInfo

Table 'ProductCategoryHeadingLink': Heading link table for ProductCategory, for MDO item headings

ProductCategoryTableInfo

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

ProductFamilyGroupLinkTableInfo

Table 'ProductFamilyGroupLink': User group link table for ProductFamily, for MDO item hiding

ProductFamilyHeadingLinkTableInfo

Table 'ProductFamilyHeadingLink': Heading link table for ProductFamily, for MDO item headings

ProductFamilyTableInfo

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

ProductTableInfo

Table 'Product': One Product, member of one price list

ProductTypeGroupLinkTableInfo

Table 'ProductTypeGroupLink': User group link table for ProductType, for MDO item hiding

ProductTypeHeadingLinkTableInfo

Table 'ProductTypeHeadingLink': Heading link table for ProductType, for MDO item headings

ProductTypeTableInfo

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

ProductVersionTableInfo

Table 'ProductVersion': Version information for code modules. Owner + code module must be unique

ProfileTableInfo

Table 'profile': Deprecated. This table contains entries for the user profiles.

ProjectMemberTableInfo

Table 'projectmember': Project members. Link-table between person and project

ProjectTableInfo

Table 'project': Projects

ProjectTypeStatusLinkTableInfo

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

ProjStatusGroupLinkTableInfo

Table 'ProjStatusGroupLink': User group link table for ProjStatus, for MDO item hiding

ProjStatusHeadingLinkTableInfo

Table 'ProjStatusHeadingLink': Heading link table for ProjStatus, for MDO headers

ProjStatusTableInfo

Table 'ProjStatus': ProjStatus list table. Project status

ProjTypeGroupLinkTableInfo

Table 'ProjTypeGroupLink': User group link table for ProjType, for MDO item hiding

ProjTypeHeadingLinkTableInfo

Table 'ProjTypeHeadingLink': Heading link table for ProjType, for MDO headers

ProjTypeTableInfo

Table 'ProjType': ProjType list table. List of valid Project types.

PublishTableInfo

Table 'Publish': Publishing system for external users

PushNotificationServiceTableInfo

Table 'PushNotificationService': Used for storing handles to user devices that should receive push notifications

QuickReplyTableInfo

Table 'quick_reply': Personal quick reply text fragments

QuoteAlternativeTableInfo

Table '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.

QuoteConnectionAccessTableInfo

Table 'QuoteConnectionAccess': Access control for Quote Connections

QuoteConnectionTableInfo

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

QuoteLineConfigurationTableInfo

Table 'QuoteLineConfiguration': Configuration of quote lines - which fields are in use, rights, labels etc

QuoteLineTableInfo

Table '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.

QuoteTableInfo

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

QuoteVersionAttachmentTableInfo

Table 'QuoteVersionAttachment': Actual attachments to a quote

QuoteVersionTableInfo

Table 'QuoteVersion': There may be multiple Versions of a Quote, with one of them active

ReasonGroupLinkTableInfo

Table 'ReasonGroupLink': User group link table for Reason, for MDO item hiding

ReasonHeadingLinkTableInfo

Table 'ReasonHeadingLink': Heading link table for Reason, for MDO headers

ReasonSoldGroupLinkTableInfo

Table 'ReasonSoldGroupLink': User group link table for ReasonSold, for MDO item hiding

ReasonSoldHeadingLinkTableInfo

Table 'ReasonSoldHeadingLink': Heading link table for ReasonSold, for MDO headers

ReasonSoldTableInfo

Table 'ReasonSold': Why was the sale marked as sold (why did we succeed)

ReasonStalledGroupLinkTableInfo

Table 'ReasonStalledGroupLink': Link table for ReasonStalled, for MDO item hiding

ReasonStalledHeadingLinkTableInfo

Table 'ReasonStalledHeadingLink': Heading link table for ReasonStalled, for MDO headers

ReasonStalledTableInfo

Table 'ReasonStalled': Why was the sale marked as stalled

ReasonTableInfo

Table 'Reason': Reason list table. Why we lost the sale (list)

RecurrenceRuleTableInfo

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

RedLetterDayTableInfo

Table 'redletterday': Red letter days for calendar (holidays, birthday of king etc)

RefCountRangeTableInfo

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

RefCountsTableInfo

Table '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.

RegistryTableInfo

Table 'registry': System settings

RejectReasonGroupLinkTableInfo

Table 'RejectReasonGroupLink': User group link table for Comptr, for MDO item hiding

RejectReasonHeadingLinkTableInfo

Table 'RejectReasonHeadingLink': Heading link table for RejectReason, for MDO headers

RejectReasonTableInfo

Table 'RejectReason': Rejection reason (suggested) for bookings

RelationDefinitionGroupLinkTableInfo

Table 'RelDefGroupLink': User group link table for RelDef, for MDO item hiding

RelationDefinitionHeadingLinkTableInfo

Table 'RelDefHeadingLink': Heading link table for RelDef, for MDO headers

RelationDefinitionTableInfo

Table '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".

RelationsTableInfo

Table '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.

RelationTargetTableInfo

Table '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.

ReplyTemplateAttachmentTableInfo

Table 'reply_template_attachment': This table is used to connect attachments to reply templates (many-to-many).

ReplyTemplateBodyTableInfo

Table 'reply_template_body': Contains the body of the reply templates in different languages

ReplyTemplateFolderTableInfo

Table 'reply_template_folder': This table contains entries for folders for reply templates.

ReplyTemplateTableInfo

Table 'reply_template': Templates for automatic and manual replies to emails/sms organized hierachically

ReporterListDefTableInfo

Table 'ReporterListDef': Reporter definitions

ResourceOverrideTableInfo

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

RoleCategoryTableInfo

Table 'role_category': Category membership associated with a role

RoleElementTableInfo

Table 'role_element': Profiles associated with a role

RoleMemberTableInfo

Table 'role_member': Users linked to a role. Deprecated.

RoleTableInfo

Table '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

RoleWorkflowTableInfo

Table 'role_workflow': Knowledge base workflow access rights associated with a role

SaintConfigurationTableInfo

Table 'SaintConfiguration': Configuration information for the Saint system

SaleHistTableInfo

Table 'SaleHist': Mirror image of the Sale table, providing a full transaction history. Every time you edit a sale, the previous record of the sale is moved here.

SaleStakeholderTableInfo

Table 'SaleStakeholder': Stakeholders in the sale, very similar to project members

SaleTableInfo

Table 'sale': Sales For every Sale record edited through the SuperOffice GUI, a copy of the previous 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.

SaleTypeCatGroupLinkTableInfo

Table 'SaleTypeCatGroupLink': User group link table for SaleTypeCat, for MDO item hiding

SaleTypeCatHeadingLinkTableInfo

Table 'SaleTypeCatHeadingLink': Heading link table for SaleTypeCat, for MDO headers

SaleTypeCatTableInfo

Table 'SaleTypeCat': Category for sale type

SaleTypeGroupLinkTableInfo

Table 'SaleTypeGroupLink': User group link table for SaleType, for MDO item hiding

SaleTypeHeadingLinkTableInfo

Table 'SaleTypeHeadingLink': Heading link table for SaleType, for MDO headers

SaleTypeQuoteAttachmentTableInfo

Table 'SaleTypeQuoteAttachment': Default attachments to quotes linked to sales of this type

SaleTypeStageLinkTableInfo

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

SaleTypeTableInfo

Table 'SaleType': Type of sale - large solution, incremental, whatever fits the organization

SalutationGroupLinkTableInfo

Table 'SalutationGroupLink': User group link table for Salutation, for MDO item hiding

SalutationHeadingLinkTableInfo

Table 'SalutationHeadingLink': Heading link table for Salutation, for MDO headers

SalutationTableInfo

Table 'Salutation': Academic title for Person

SatelliteTableInfo

Table 'satellite': Definition of Satellites

SAttachmentTableInfo

Table 's_attachment': A connector between a message and attachments. One message can contain many attachments.

SBounceShipmentTableInfo

Table 's_bounce_shipment': Email bounces from customers

ScheduledTaskTableInfo

Table 'scheduled_task': A scheduled entry executing a script at certain times

ScheduleTableInfo

Table 'schedule': Generic scheduled tasked handling time scheduling, locking and error messages

ScreenChooserTableInfo

Table 'screen_chooser': Screen choosers

ScreenDefinitionActionTableInfo

Table 'screen_definition_action': An action to perform for a certain button in an screen

ScreenDefinitionElementTableInfo

Table 'screen_definition_element': An element in a configurable screen

ScreenDefinitionHiddenTableInfo

Table 'screen_definition_hidden': The name of a hidden variable to keep for this screen

ScreenDefinitionLanguageTableInfo

Table 'screen_definition_language': Custom language variables used for screens

ScreenDefinitionTableInfo

Table 'screen_definition': A configurable screen

ScriptTraceRunTableInfo

Table 'script_trace_run': Traces of executed scripts

ScriptTraceTableInfo

Table 'script_trace': Scripts which should be traced

SDynCriteriaTableInfo

Table 's_dyn_criteria': Contains criterias for a dynamic list.

SearchCatGroupLinkTableInfo

Table 'SearchCatGroupLink': User group link table for SearchCat, for MDO item hiding

SearchCatHeadingLinkTableInfo

Table 'SearchCatHeadingLink': Heading link table for SearchCat, for MDO headers

SearchCatTableInfo

Table 'SearchCat': SearchCat list table

SearchCriteriaGroupTableInfo

Table 'SearchCriteriaGroup': Criteria storage for Selection and other Find mechanisms

SearchCriteriaTableInfo

Table 'SearchCriteria': Criteria storage for Selection and other Find mechanisms

SearchCriterionTableInfo

Table 'SearchCriterion': Criteria storage for Selection and other Find mechanisms

SearchCriterionValueTableInfo

Table 'SearchCriterionValue': Criteria storage for Selection and other Find mechanisms

SelectionMemberTableInfo

Table 'selectionmember': 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.

SelectionTableInfo

Table 'selection': Selections

SequenceTableInfo

Table 'sequence': next_id to be used for each table

ServiceAuthTableInfo

Table 'service_auth': Authentication for a service (imap, smtp...)

SessionObjectTableInfo

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

ShipmentTypeReservationTableInfo

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

ShipmentTypeTableInfo

Table 'ShipmentType': Shipment type list table. Classification of a mailing, allowing recipients to subscribe to lists

SLinkCustomerStaticalTableInfo

Table 's_link_customer_statical': A connection between a customer and a link. Registered customers are identified when clicking on a link

SLinkCustomerTableInfo

Table 's_link_customer': A connection between a customer and a link. Registered customers are identified when clicking on a link

SLinkTableInfo

Table 's_link': Links in messages to measure success rate of a campaign.

SListCustomerTableInfo

Table 's_list_customer': Elements in a customer list.

SListElementTableInfo

Table 's_list_element': Elements in a static list.

SListShipmentTableInfo

Table 's_list_shipment': A connector between shipment and list so that one shipment can have many lists, and one list can have many shipments

SListTableInfo

Table 's_list': A list, dynamic or static

SMessageblockTableInfo

Table 's_messageblock': Contains a block of a mailing message, that can be reused in a mailing

SMessageTableInfo

Table 's_message': A message used in a shipment. Can be html and/or plain text

SmsHysteriaTableInfo

Table 'sms_hysteria': Avoid sending too many sms messages in a short time interval to one person

SmsTableInfo

Table 'sms': This table will hold outgoing sms messages when transmitted with WebServices

SnapshotTableInfo

Table 'snapshot': Snapshots taken of the system database and attachments via soap

SoapAccessTableInfo

Table 'soap_access': Table that contains constraints on the access to the soap interface

SORCriteriaTableInfo

Table 'SORCriteria': SuperOffice reporter data

SORFCTTableInfo

Table 'SORFCT': SuperOffice reporter data

SORFieldTableInfo

Table 'SORField': SuperOffice reporter data

SORLabelLayoutTableInfo

Table 'SORLabelLayout': SuperOffice reporter data

SOROperatorsTableInfo

Table 'SOROperators': SuperOffice reporter data

SORPublishGroupLinkTableInfo

Table 'SORPublishGroupLink': Link table used for filtering reports by user group

SORPublishTableInfo

Table 'SORPublish': SuperOffice reporter data

SORSectionTableInfo

Table 'SORSection': SuperOffice reporter data

SORTemplateTableInfo

Table 'SORTemplate': SuperOffice reporter data

SourceGroupLinkTableInfo

Table 'SourceGroupLink': User group link table for Source, for MDO item hiding

SourceHeadingLinkTableInfo

Table 'SourceHeadingLink': Heading link table for Source, for MDO headers

SourceTableInfo

Table 'Source': Source list table. Source for sale (list)

SPictureEntryTableInfo

Table 's_picture_entry': This table describes each picture in the database

SPictureFolderTableInfo

Table 's_picture_folder': This table contains all picture folders

SSentMessageTableInfo

Table 's_sent_message': Emarketeer message control

SShipmentAddrTableInfo

Table 's_shipment_addr': Addresses that are ready to be sent in a shipment.

SShipmentTableInfo

Table 's_shipment': Contains info about one shipment. The addresses are stored in s_shipment_addr

SSmtpServersTableInfo

Table 's_smtp_servers': Contains the smtp server for a shipment

StakeholderRoleGroupLinkTableInfo

Table 'StakeholderRoleGroupLink': User group link table for StakeholderRole, for MDO item hiding

StakeholderRoleHeadingLinkTableInfo

Table 'StakeholderRoleHeadingLink': Heading link table for StakeholderRole, for MDO headers

StakeholderRoleTableInfo

Table 'StakeholderRole': Role a stakeholder has in a sale

StaticListRefTableInfo

Table 'static_list_ref': This table stores id references for selections id lists

StatusDefTableInfo

Table 'StatusDef': Status definitions. Name and description are in LocaleText for internationalization

StatusValueTableInfo

Table 'StatusValue': Values for statuses

SubscriptionUnitGroupLinkTableInfo

Table 'SubscriptionUnitGroupLink': User group link table for SubscriptionUnit, for MDO item hiding

SubscriptionUnitHeadingLinkTableInfo

Table 'SubscriptionUnitHeadingLink': Heading link table for SubscriptionUnit, for MDO item headings

SubscriptionUnitTableInfo

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

SuggestedAppointmentTableInfo

Table 'SuggestedAppointment': Defines a suggested appointment for use in a Sale Guide or Project Guide

SuggestedDocumentTableInfo

Table 'SuggestedDocument': Unique owner of a set of licensed modules

SuperListColumnSizeTableInfo

Table 'SuperListColumnSize': Stores the relative size (in percent) or in characters of a column in a SuperList

SWashingListTableInfo

Table 's_washing_list': Unused table that is ment to be used for active washing in spm v2

SWashingTableInfo

Table 's_washing': Register of all bounced mail to enabel washing

SystemEventTableInfo

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

SystemScriptTableInfo

Table 'system_script': A table containing the system script

TabOrderTableInfo

Table 'TabOrder': Order of tabs within a tab control, if configured by a user

TagsGroupLinkTableInfo

Table 'TagsGroupLink': User group link table for Tags, for MDO item hiding

TagsHeadingLinkTableInfo

Table 'TagsHeadingLink': Heading link table for Source, for MDO headers

TagsTableInfo

Table 'Tags': MDO List of tags for Service entities

TaskGroupLinkTableInfo

Table 'TaskGroupLink': User group link table for Task, for MDO item hiding

TaskHeadingLinkTableInfo

Table 'TaskHeadingLink': Heading link table for Task, for MDO headers

TaskTableInfo

Table 'Task': Task list table, activity types, like Phone, Meeting

TemporaryKeyTableInfo

Table 'TemporaryKey': Temporary keys for lightweight authentications such as changing ones subscriptions

TemporaryWordsTableInfo

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

TextTableInfo

Table 'text': Long text fields from all over the system

TicketAlertTableInfo

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

TicketAttachmentTableInfo

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

TicketCustomersTableInfo

Table 'ticket_customers': This table allows several customers to be connected to several tickets (many-to-many)

TicketLogActionTableInfo

Table 'ticket_log_action': This table contains actions for the tickets.

TicketLogChangeTableInfo

Table 'ticket_log_change': This table contains log entries for the tickets.

TicketLogTableInfo

Table 'ticket_log': This table contains log entries for the tickets.

TicketPriorityTableInfo

Table 'ticket_priority': This table contains the ticket priorities.

TicketRelationActionTableInfo

Table 'ticket_relation_action': Contains ticket relation actions, used to drive processing logic together with ticket relations

TicketRelationTableInfo

Table 'ticket_relation': Contains ticket relations, used to drive processing logic

TicketRelationTypeTableInfo

Table 'ticket_relation_type': Contains ticket relation types, used to drive processing logic together with ticket relations

TicketStatusHistoryTableInfo

Table 'ticket_status_history': 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

TicketStatusTableInfo

Table 'ticket_status': This table user defined ticket status values.

TicketTableInfo

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

TicketTypeTableInfo

Table 'ticket_type': Contains ticket types, used to drive processing logic together with ticket relations

TimestampsTableInfo

Table 'timestamps': Timestamp information

TravelCurrentTableInfo

Table 'travelcurrent': Information about this database and its place in the hierarchy

TravelGeneratedDatabaseTableInfo

Table 'travelgenerateddatabase': Information about all databases generated from this database

TravelGeneratedTransactionTableInfo

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

TravelIDMappingTableInfo

Table '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.

TravellerTableInfo

Table 'traveller': Associates traveling out from this database

TravelTransactionLogTableInfo

Table 'traveltransactionlog': Log of all updates made to the database, that need to be replicated.

TrayAppTableInfo

Table 'TrayApp': Tray application presence. SuperOffice CRM web extensions.

TreeExplorerEntryTableInfo

Table 'tree_explorer_entry': This table stores the entries in a tree-explorer

TreeExplorerLinkTableInfo

Table 'tree_explorer_link': This table stores the link of entries in a tree-explorer

TypicalSearchTableInfo

Table 'TypicalSearch': Owner of a set of predefined selection criteria

TZDstRuleTableInfo

Table 'TZDstRule': Time zone rule for daylight saving time

TZLocationTableInfo

Table 'TZLocation': Time zone location

TZStdRuleTableInfo

Table 'TZStdRule': Time zone rule for standard time

UDAppntLargeTableInfo

Table 'udappntlarge': User-defined fields

UDAppntSmallTableInfo

Table 'udappntsmall': User-defined fields

UDContactLargeTableInfo

Table 'udcontactLarge': User-defined fields for contact (long strings)

UDContactSmallTableInfo

Table 'udcontactSmall': User-defined fields for contact

UDDocLargeTableInfo

Table 'uddoclarge': User-defined fields

UDDocSmallTableInfo

Table 'uddocsmall': User-defined fields

UDefFieldGLTableInfo

Table 'UDefFieldGL': User group link table for UDefField, for MDO item hiding

UDefFieldTableInfo

Table '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.

UDListDefinitionTableInfo

Table '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.

UDListGroupLinkTableInfo

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.

UDListHeadingLinkTableInfo

Table '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.

UDListTableInfo

Table '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.

UDPersonLargeTableInfo

Table 'udpersonLarge': User-defined fields

UDPersonSmallTableInfo

Table 'udpersonSmall': User-defined fields

UDProjectLargeTableInfo

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

UDProjectSmallTableInfo

Table 'udprojectSmall': User-defined fields

UDSaleLargeTableInfo

Table 'udsalelarge': User-defined fields

UDSaleSmallTableInfo

Table 'udsalesmall': User-defined fields

UDTempLargeTableInfo

Table 'udtempLarge': User-defined fields

UDTempSmallTableInfo

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

URLTableInfo

Table 'URL': Unified Resource Locators, URL to contacts, persons or projects.

UsageStatsTableInfo

Table 'UsageStats': Usage statistics

UserAttributeTableInfo

Table 'user_attribute': This table is used for storing various attributes for users.

UserCandidateTableInfo

Table 'user_candidate': This table will hold user candidate secrets

UserGroupLinkTableInfo

Table '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.

UserGroupTableInfo

Table 'UserGroup': Secondary user groups

UserPreferenceTableInfo

Table 'UserPreference': Preference system. If deflevel is set to 5; the user may change the preferences

UserRoleLinkTableInfo

Table 'UserRoleLink': Link between user role and user

VisibleForTableInfo

Table 'VisibleFor': Visible for rights, who may see this appointment/document, sale, salehist or selection

WebAppUsageTableInfo

Table 'WebAppUsage': Usage statistics for web applications

WebhookTableInfo

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

WebhookUsageTableInfo

Table 'WebhookUsage': Usage counters for a specific webhook. Since these are updated frequently, we keep them in a separate table. Used to determine if too many errors are happening.

WinPosSizeTableInfo

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

WordRelationsTableInfo

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

WsdlDescriptionTableInfo

Table 'wsdl_description': Soap wsdl files

ZipToCityTableInfo

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

© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top