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