Class DBC

Constants for database tables and fields

Inheritance
Object
DBC
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
public static class DBC : Object

Fields

AccessScript

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

Declaration
public const string AccessScript = "access_script"
Field Value
Type Description
String

ActiveUser

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.

Declaration
public const string ActiveUser = "activeuser"
Field Value
Type Description
String

Address

Address: Contact and Person addresses

Declaration
public const string Address = "address"
Field Value
Type Description
String

AddressFormat

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

Declaration
public const string AddressFormat = "AddressFormat"
Field Value
Type Description
String

AiChatTurn

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

Declaration
public const string AiChatTurn = "ai_chat_turn"
Field Value
Type Description
String

AmountClass

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

Declaration
public const string AmountClass = "AmountClass"
Field Value
Type Description
String

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

Declaration
public const string AmountClassGroupLink = "AmountClassGroupLink"
Field Value
Type Description
String

AmountClassHeadingLink: Heading link table for AmountClass, for MDO headers

Declaration
public const string AmountClassHeadingLink = "AmountClassHeadingLink"
Field Value
Type Description
String

Appointment

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.

Declaration
public const string Appointment = "appointment"
Field Value
Type Description
String

Area

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

Declaration
public const string Area = "area"
Field Value
Type Description
String

AreaUserAssignment

AreaUserAssignment: Link table indicating which users actually reside in this area.

Declaration
public const string AreaUserAssignment = "areauserassignment"
Field Value
Type Description
String

AreaUserInclusion

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.

Declaration
public const string AreaUserInclusion = "areauserinclusion"
Field Value
Type Description
String

Associate

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

Declaration
public const string Associate = "associate"
Field Value
Type Description
String

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

Declaration
public const string AssociateGroupLink = "AssociateGroupLink"
Field Value
Type Description
String

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

Declaration
public const string AssociateHeadingLink = "AssociateHeadingLink"
Field Value
Type Description
String

AssociateHistory

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

Declaration
public const string AssociateHistory = "AssociateHistory"
Field Value
Type Description
String

Attachment

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.

Declaration
public const string Attachment = "attachment"
Field Value
Type Description
String

AttachmentLocation

AttachmentLocation: A location for storing attachments

Declaration
public const string AttachmentLocation = "attachment_location"
Field Value
Type Description
String

AudienceConfig

AudienceConfig: Configuration data for Audience core and webparts

Declaration
public const string AudienceConfig = "AudienceConfig"
Field Value
Type Description
String

AudienceLayout

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

Declaration
public const string AudienceLayout = "AudienceLayout"
Field Value
Type Description
String

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

Declaration
public const string AudienceLayoutLink = "AudienceLayoutLink"
Field Value
Type Description
String

AudienceVisibility

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

Declaration
public const string AudienceVisibility = "AudienceVisibility"
Field Value
Type Description
String

Autosave

Autosave: Autosaved text clobs from ejscript and emarketeer messages

Declaration
public const string Autosave = "autosave"
Field Value
Type Description
String

BaseTZLocation

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

Declaration
public const string BaseTZLocation = "BaseTZLocation"
Field Value
Type Description
String

BatchTask

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

Declaration
public const string BatchTask = "BatchTask"
Field Value
Type Description
String

BatchTaskDefinition

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

Declaration
public const string BatchTaskDefinition = "BatchTaskDefinition"
Field Value
Type Description
String

BinaryObject

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

Declaration
public const string BinaryObject = "BinaryObject"
Field Value
Type Description
String

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

Declaration
public const string BinaryObjectLink = "BinaryObjectLink"
Field Value
Type Description
String

Business

Business: Business list table

Declaration
public const string Business = "Business"
Field Value
Type Description
String

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

Declaration
public const string BusinessGroupLink = "BusinessGroupLink"
Field Value
Type Description
String

BusinessHeadingLink: Heading link table for Business, for MDO headers

Declaration
public const string BusinessHeadingLink = "BusinessHeadingLink"
Field Value
Type Description
String

CacheInvalidation

CacheInvalidation: Names and generation numbers for distributed invalidation of caches

Declaration
public const string CacheInvalidation = "CacheInvalidation"
Field Value
Type Description
String

CacheTables

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.

Declaration
public const string CacheTables = "CacheTables"
Field Value
Type Description
String

Category

Category: Category list table

Declaration
public const string Category = "Category"
Field Value
Type Description
String

CategoryFamily

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

Declaration
public const string CategoryFamily = "CategoryFamily"
Field Value
Type Description
String

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

Declaration
public const string CategoryGroupLink = "CategoryGroupLink"
Field Value
Type Description
String

CategoryHeadingLink: Heading link table for Category, for MDO headers

Declaration
public const string CategoryHeadingLink = "CategoryHeadingLink"
Field Value
Type Description
String

CategoryMembership

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

Declaration
public const string CategoryMembership = "category_membership"
Field Value
Type Description
String

CcTemplate

CcTemplate: This table contains templates for the customer center

Declaration
public const string CcTemplate = "cc_template"
Field Value
Type Description
String

ChatMessage

ChatMessage: This table contains messages in a chat session.

Declaration
public const string ChatMessage = "chat_message"
Field Value
Type Description
String

ChatSession

ChatSession: This table contains chat sessions.

Declaration
public const string ChatSession = "chat_session"
Field Value
Type Description
String

ChatTopic

ChatTopic: This table contains chat topics.

Declaration
public const string ChatTopic = "chat_topic"
Field Value
Type Description
String

ChatTopicUser

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

Declaration
public const string ChatTopicUser = "chat_topic_user"
Field Value
Type Description
String

Company

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.

Declaration
public const string Company = "company"
Field Value
Type Description
String

CompanyDomain

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

Declaration
public const string CompanyDomain = "company_domain"
Field Value
Type Description
String

Comptr

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

Declaration
public const string Comptr = "Comptr"
Field Value
Type Description
String

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

Declaration
public const string ComptrGroupLink = "ComptrGroupLink"
Field Value
Type Description
String

ComptrHeadingLink: Heading link table for Comptr, for MDO headers

Declaration
public const string ComptrHeadingLink = "ComptrHeadingLink"
Field Value
Type Description
String

Config

Config: This table contains certain system-wide configuration values.

Declaration
public const string Config = "config"
Field Value
Type Description
String

ConfigurableScreenAppliesTo

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

Declaration
public const string ConfigurableScreenAppliesTo = "ConfigurableScreenAppliesTo"
Field Value
Type Description
String

ConfigurableScreenDelta

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

Declaration
public const string ConfigurableScreenDelta = "ConfigurableScreenDelta"
Field Value
Type Description
String

ConnectionConfigField

ConnectionConfigField: Configuration data for Erp and Quote Connections

Declaration
public const string ConnectionConfigField = "ConnectionConfigField"
Field Value
Type Description
String

ConsentPerson

ConsentPerson: Link table that defines who has which consents

Declaration
public const string ConsentPerson = "ConsentPerson"
Field Value
Type Description
String

ConsentPurpose

ConsentPurpose: GDPR purpose alternatives

Declaration
public const string ConsentPurpose = "ConsentPurpose"
Field Value
Type Description
String

ConsentSource

ConsentSource: Consent source for GDPR

Declaration
public const string ConsentSource = "ConsentSource"
Field Value
Type Description
String

Contact

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

Declaration
public const string Contact = "contact"
Field Value
Type Description
String

ContactInterest

ContactInterest: Link-table between contact and interests in ContInt

Declaration
public const string ContactInterest = "contactinterest"
Field Value
Type Description
String

ContInt

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

Declaration
public const string ContInt = "ContInt"
Field Value
Type Description
String

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

Declaration
public const string ContIntGroupLink = "ContIntGroupLink"
Field Value
Type Description
String

ContIntHeadingLink: Heading link table for ContInt, for MDO headers

Declaration
public const string ContIntHeadingLink = "ContIntHeadingLink"
Field Value
Type Description
String

CounterValue

CounterValue: Visible for rights

Declaration
public const string CounterValue = "CounterValue"
Field Value
Type Description
String

Country

Country: Country information

Declaration
public const string Country = "country"
Field Value
Type Description
String

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

Declaration
public const string CountryGroupLink = "CountryGroupLink"
Field Value
Type Description
String

CountryHeadingLink: Heading link table for Country, for MDO headers

Declaration
public const string CountryHeadingLink = "CountryHeadingLink"
Field Value
Type Description
String

Credentials

Credentials: Alternative credentials

Declaration
public const string Credentials = "Credentials"
Field Value
Type Description
String

Credited

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

Declaration
public const string Credited = "Credited"
Field Value
Type Description
String

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

Declaration
public const string CreditedGroupLink = "CreditedGroupLink"
Field Value
Type Description
String

CreditedHeadingLink: Heading link table for Credited, for MDO headers

Declaration
public const string CreditedHeadingLink = "CreditedHeadingLink"
Field Value
Type Description
String

Currency

Currency: Currency list table

Declaration
public const string Currency = "Currency"
Field Value
Type Description
String

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

Declaration
public const string CurrencyGroupLink = "CurrencyGroupLink"
Field Value
Type Description
String

CurrencyHeadingLink: Heading link table for Currency, for MDO headers

Declaration
public const string CurrencyHeadingLink = "CurrencyHeadingLink"
Field Value
Type Description
String

CustCategory

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

Declaration
public const string CustCategory = "cust_category"
Field Value
Type Description
String

CustConfig

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

Declaration
public const string CustConfig = "cust_config"
Field Value
Type Description
String

CustLang

CustLang: This table contains entries for customer languages.

Declaration
public const string CustLang = "cust_lang"
Field Value
Type Description
String

Dashboard

Dashboard: Describes a dashboard

Declaration
public const string Dashboard = "dashboard"
Field Value
Type Description
String

DashboardTheme

DashboardTheme: A set of style rules for the Dashboard

Declaration
public const string DashboardTheme = "dashboard_theme"
Field Value
Type Description
String

DashboardTile

DashboardTile: Represents one tile in the dashboard

Declaration
public const string DashboardTile = "dashboard_tile"
Field Value
Type Description
String

DashboardTileDefinition

DashboardTileDefinition: Describes the contents of a tile

Declaration
public const string DashboardTileDefinition = "dashboard_tile_definition"
Field Value
Type Description
String

DashboardTileField

DashboardTileField: Describes the contents of a tile field

Declaration
public const string DashboardTileField = "dashboard_tile_field"
Field Value
Type Description
String

DatabaseModel

DatabaseModel: New DatabaseModel used by Continuous Database

Declaration
public const string DatabaseModel = "DatabaseModel"
Field Value
Type Description
String

DataRight

DataRight: Data right definition

Declaration
public const string DataRight = "DataRight"
Field Value
Type Description
String

DbiAgent

DbiAgent: DBI agent settings

Declaration
public const string DbiAgent = "dbi_agent"
Field Value
Type Description
String

DbiAgentField

DbiAgentField: DBI agent fields

Declaration
public const string DbiAgentField = "dbi_agent_field"
Field Value
Type Description
String

DbiAgentSchedule

DbiAgentSchedule: DBI agent schedule settings

Declaration
public const string DbiAgentSchedule = "dbi_agent_schedule"
Field Value
Type Description
String

DeliveryTerms

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

Declaration
public const string DeliveryTerms = "DeliveryTerms"
Field Value
Type Description
String

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

Declaration
public const string DeliveryTermsGroupLink = "DeliveryTermsGroupLink"
Field Value
Type Description
String

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

Declaration
public const string DeliveryTermsHeadingLink = "DeliveryTermsHeadingLink"
Field Value
Type Description
String

DeliveryType

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

Declaration
public const string DeliveryType = "DeliveryType"
Field Value
Type Description
String

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

Declaration
public const string DeliveryTypeGroupLink = "DeliveryTypeGroupLink"
Field Value
Type Description
String

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

Declaration
public const string DeliveryTypeHeadingLink = "DeliveryTypeHeadingLink"
Field Value
Type Description
String

DiaryView

DiaryView: Configuration of a multi-user diary view

Declaration
public const string DiaryView = "DiaryView"
Field Value
Type Description
String

DiaryViewRow

DiaryViewRow: Configuration of a multi-user diary view

Declaration
public const string DiaryViewRow = "DiaryViewRow"
Field Value
Type Description
String

Dictionary

Dictionary: User added dictionary words

Declaration
public const string Dictionary = "dictionary"
Field Value
Type Description
String

DictionaryBase

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

Declaration
public const string DictionaryBase = "dictionary_base"
Field Value
Type Description
String

DocDocument

DocDocument: This table contains documents.

Declaration
public const string DocDocument = "doc_document"
Field Value
Type Description
String

DocFolder

DocFolder: A document folder.

Declaration
public const string DocFolder = "doc_folder"
Field Value
Type Description
String

DocTmpl

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

Declaration
public const string DocTmpl = "DocTmpl"
Field Value
Type Description
String

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

Declaration
public const string DocTmplGroupLink = "DocTmplGroupLink"
Field Value
Type Description
String

DocTmplHeadingLink: Heading link table for DocTmpl, for MDO headers

Declaration
public const string DocTmplHeadingLink = "DocTmplHeadingLink"
Field Value
Type Description
String

Document

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.

Declaration
public const string Document = "document"
Field Value
Type Description
String

EabEntry

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

Declaration
public const string EabEntry = "eab_entry"
Field Value
Type Description
String

EabFolder

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

Declaration
public const string EabFolder = "eab_folder"
Field Value
Type Description
String

EjCategory

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

Declaration
public const string EjCategory = "ej_category"
Field Value
Type Description
String

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

Declaration
public const string EjCategoryGroupLink = "EjCategoryGroupLink"
Field Value
Type Description
String

EjMessage

EjMessage: This table contains the messages listed under tickets.

Declaration
public const string EjMessage = "ej_message"
Field Value
Type Description
String

Ejpackage

Ejpackage: This table stores packages on the system.

Declaration
public const string Ejpackage = "ejpackage"
Field Value
Type Description
String

EjpackageItem

EjpackageItem: This table stores info on installed packages in the system

Declaration
public const string EjpackageItem = "ejpackage_item"
Field Value
Type Description
String

EjRole

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

Declaration
public const string EjRole = "ej_role"
Field Value
Type Description
String

Ejscript

Ejscript: ejscript

Declaration
public const string Ejscript = "ejscript"
Field Value
Type Description
String

EjscriptDebug

EjscriptDebug: This table contains information when debugging an ejscript

Declaration
public const string EjscriptDebug = "ejscript_debug"
Field Value
Type Description
String

Ejselection

Ejselection: This table stores selections, dynamic groups.

Declaration
public const string Ejselection = "ejselection"
Field Value
Type Description
String

EjselEjsel

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

Declaration
public const string EjselEjsel = "ejsel_ejsel"
Field Value
Type Description
String

EjselMetaResult

EjselMetaResult: This table stores result meta data

Declaration
public const string EjselMetaResult = "ejsel_meta_result"
Field Value
Type Description
String

EjselResultSet

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

Declaration
public const string EjselResultSet = "ejsel_result_set"
Field Value
Type Description
String

EjselSourceIdlist

EjselSourceIdlist: This table stores id list source for selections

Declaration
public const string EjselSourceIdlist = "ejsel_source_idlist"
Field Value
Type Description
String

EjselSourceScript

EjselSourceScript: This table stores a selection script source

Declaration
public const string EjselSourceScript = "ejsel_source_script"
Field Value
Type Description
String

EjselSourceXml

EjselSourceXml: This table stores a selection source as xml

Declaration
public const string EjselSourceXml = "ejsel_source_xml"
Field Value
Type Description
String

Ejuser

Ejuser: This table contains entries for the users of the system.

Declaration
public const string Ejuser = "ejuser"
Field Value
Type Description
String

ElementProfile

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

Declaration
public const string ElementProfile = "element_profile"
Field Value
Type Description
String

Email

Email: Email addresses for contacts, projects and persons

Declaration
public const string Email = "Email"
Field Value
Type Description
String

EmailAccount

EmailAccount: Email account information

Declaration
public const string EmailAccount = "email_account"
Field Value
Type Description
String

EmailAttachment

EmailAttachment: Attachment info related to an email_item

Declaration
public const string EmailAttachment = "email_attachment"
Field Value
Type Description
String

EmailFlow

EmailFlow: A set of properties related to the email workflow.

Declaration
public const string EmailFlow = "email_flow"
Field Value
Type Description
String

EmailFlowContentLink: Links content to an email workflow

Declaration
public const string EmailFlowContentLink = "email_flow_content_link"
Field Value
Type Description
String

EmailFolder

EmailFolder: Corresponds to an email folder on a mail server

Declaration
public const string EmailFolder = "email_folder"
Field Value
Type Description
String

EmailItem

EmailItem: Email data

Declaration
public const string EmailItem = "email_item"
Field Value
Type Description
String

EntityCounts

EntityCounts: Number of different entities an associate has created for usage statistics

Declaration
public const string EntityCounts = "EntityCounts"
Field Value
Type Description
String

ErpConfiguration

ErpConfiguration: Global settings for the Erp Integration Server

Declaration
public const string ErpConfiguration = "ErpConfiguration"
Field Value
Type Description
String

ErpConnection

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

Declaration
public const string ErpConnection = "ErpConnection"
Field Value
Type Description
String

ErpConnectionAccess

ErpConnectionAccess: Access control for Erp Connections

Declaration
public const string ErpConnectionAccess = "ErpConnectionAccess"
Field Value
Type Description
String

ErpConnectionActorType

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

Declaration
public const string ErpConnectionActorType = "ErpConnectionActorType"
Field Value
Type Description
String

ErpConnector

ErpConnector: One ERP Connector, known by its URL

Declaration
public const string ErpConnector = "ErpConnector"
Field Value
Type Description
String

ErpExternalKey

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

Declaration
public const string ErpExternalKey = "ErpExternalKey"
Field Value
Type Description
String

ErpField

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

Declaration
public const string ErpField = "ErpField"
Field Value
Type Description
String

ErpInternalKey

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

Declaration
public const string ErpInternalKey = "ErpInternalKey"
Field Value
Type Description
String

ErpListItemMapping

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

Declaration
public const string ErpListItemMapping = "ErpListItemMapping"
Field Value
Type Description
String

ErpSyncLog

ErpSyncLog: Record all field changes done by the Erp Sync

Declaration
public const string ErpSyncLog = "ErpSyncLog"
Field Value
Type Description
String

ExtApp

ExtApp: ExtApp list table. Applications startable from SuperOffice

Declaration
public const string ExtApp = "ExtApp"
Field Value
Type Description
String

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

Declaration
public const string ExtAppGroupLink = "ExtAppGroupLink"
Field Value
Type Description
String

ExtAppHeadingLink: Heading link table for ExtApp, for MDO headers

Declaration
public const string ExtAppHeadingLink = "ExtAppHeadingLink"
Field Value
Type Description
String

ExtDatasource

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

Declaration
public const string ExtDatasource = "ext_datasource"
Field Value
Type Description
String

ExternalDocument

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

Declaration
public const string ExternalDocument = "external_document"
Field Value
Type Description
String

ExternalEvent

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

Declaration
public const string ExternalEvent = "ExternalEvent"
Field Value
Type Description
String

ExtField

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

Declaration
public const string ExtField = "ext_field"
Field Value
Type Description
String

ExtraFields

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

Declaration
public const string ExtraFields = "extra_fields"
Field Value
Type Description
String

ExtraMenus

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

Declaration
public const string ExtraMenus = "extra_menus"
Field Value
Type Description
String

ExtraTables

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

Declaration
public const string ExtraTables = "extra_tables"
Field Value
Type Description
String

ExtraTablesEntry

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

Declaration
public const string ExtraTablesEntry = "extra_tables_entry"
Field Value
Type Description
String

ExtraTablesResult

ExtraTablesResult: Result set of executed search in ejournal extra tables

Declaration
public const string ExtraTablesResult = "extra_tables_result"
Field Value
Type Description
String

ExtTable

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

Declaration
public const string ExtTable = "ext_table"
Field Value
Type Description
String

Favourite

Favourite: Favourite records (star-marking)

Declaration
public const string Favourite = "Favourite"
Field Value
Type Description
String

FieldLabel

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.

Declaration
public const string FieldLabel = "FieldLabel"
Field Value
Type Description
String

ForeignApp

ForeignApp: Top level of Foreign Key system

Declaration
public const string ForeignApp = "foreignapp"
Field Value
Type Description
String

ForeignDevice

ForeignDevice: Middle level of Foreign Key system

Declaration
public const string ForeignDevice = "foreigndevice"
Field Value
Type Description
String

ForeignKey

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.

Declaration
public const string ForeignKey = "foreignkey"
Field Value
Type Description
String

Form

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

Declaration
public const string Form = "form"
Field Value
Type Description
String

FormFieldValue

FormFieldValue: Form field values saved in a searchable format

Declaration
public const string FormFieldValue = "form_field_value"
Field Value
Type Description
String

FormKeys

FormKeys: Keys that makes sure a form is not posted twice

Declaration
public const string FormKeys = "form_keys"
Field Value
Type Description
String

FormSubmission

FormSubmission: A form submission

Declaration
public const string FormSubmission = "form_submission"
Field Value
Type Description
String

FreeTextIndex

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

Declaration
public const string FreeTextIndex = "freetextindex"
Field Value
Type Description
String

FreeTextStopWords

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.

Declaration
public const string FreeTextStopWords = "freetextstopwords"
Field Value
Type Description
String

FreeTextWords

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

Declaration
public const string FreeTextWords = "freetextwords"
Field Value
Type Description
String

FunctionRight

FunctionRight: Functional right definition

Declaration
public const string FunctionRight = "FunctionRight"
Field Value
Type Description
String

FunctionRightRoleLink: Functional right definition

Declaration
public const string FunctionRightRoleLink = "FunctionRightRoleLink"
Field Value
Type Description
String

Heading

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

Declaration
public const string Heading = "Heading"
Field Value
Type Description
String

Help

Help: This table contains the help pages.

Declaration
public const string Help = "help"
Field Value
Type Description
String

Hierarchy

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

Declaration
public const string Hierarchy = "hierarchy"
Field Value
Type Description
String

History

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.

Declaration
public const string History = "History"
Field Value
Type Description
String

Hotlist

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

Declaration
public const string Hotlist = "hotlist"
Field Value
Type Description
String

ImportDefault

ImportDefault: Defaults for import fields/objects

Declaration
public const string ImportDefault = "ImportDefault"
Field Value
Type Description
String

ImportField

ImportField: Import object types - see localetext for names

Declaration
public const string ImportField = "ImportField"
Field Value
Type Description
String

ImportObject

ImportObject: Import object types - see localetext for names.

Declaration
public const string ImportObject = "ImportObject"
Field Value
Type Description
String

ImportRelation

ImportRelation: Relations between import objects

Declaration
public const string ImportRelation = "ImportRelation"
Field Value
Type Description
String

Inbox

Inbox: Info and status for safe email import

Declaration
public const string Inbox = "inbox"
Field Value
Type Description
String

Intent

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

Declaration
public const string Intent = "Intent"
Field Value
Type Description
String

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

Declaration
public const string IntentGroupLink = "IntentGroupLink"
Field Value
Type Description
String

IntentHeadingLink: Heading link table for Intent, for MDO headers

Declaration
public const string IntentHeadingLink = "IntentHeadingLink"
Field Value
Type Description
String

Invitation

Invitation: Invitations to events

Declaration
public const string Invitation = "invitation"
Field Value
Type Description
String

Invoice

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

Declaration
public const string Invoice = "invoice"
Field Value
Type Description
String

InvoiceEntry

InvoiceEntry: This table contain all invoices, connected to a message

Declaration
public const string InvoiceEntry = "invoice_entry"
Field Value
Type Description
String

InvoiceSum

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

Declaration
public const string InvoiceSum = "invoice_sum"
Field Value
Type Description
String

InvoiceType

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

Declaration
public const string InvoiceType = "invoice_type"
Field Value
Type Description
String

ItemConfig

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

Declaration
public const string ItemConfig = "item_config"
Field Value
Type Description
String

KbAttachment

KbAttachment: This table connects FAQ entries to attachments.

Declaration
public const string KbAttachment = "kb_attachment"
Field Value
Type Description
String

KbCategory

KbCategory: Knowledge base folder hierarchy

Declaration
public const string KbCategory = "kb_category"
Field Value
Type Description
String

KbCategoryLog

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

Declaration
public const string KbCategoryLog = "kb_category_log"
Field Value
Type Description
String

KbEntry

KbEntry: This table contains FAQ entries.

Declaration
public const string KbEntry = "kb_entry"
Field Value
Type Description
String

KbEntryComment

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

Declaration
public const string KbEntryComment = "kb_entry_comment"
Field Value
Type Description
String

KbEntryKeyword

KbEntryKeyword: This table contains all keywords for the faq entries

Declaration
public const string KbEntryKeyword = "kb_entry_keyword"
Field Value
Type Description
String

KbEntryLog

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

Declaration
public const string KbEntryLog = "kb_entry_log"
Field Value
Type Description
String

KbEntryWords

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

Declaration
public const string KbEntryWords = "kb_entry_words"
Field Value
Type Description
String

KbGroup

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.

Declaration
public const string KbGroup = "kb_group"
Field Value
Type Description
String

KbGroupEntry

KbGroupEntry: This table contains group entries for FAQ groups.

Declaration
public const string KbGroupEntry = "kb_group_entry"
Field Value
Type Description
String

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

Declaration
public const string KbHttpLink = "kb_http_link"
Field Value
Type Description
String

KbSolutionFinder

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

Declaration
public const string KbSolutionFinder = "kb_solution_finder"
Field Value
Type Description
String

KbSolutionFinderEntry

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

Declaration
public const string KbSolutionFinderEntry = "kb_solution_finder_entry"
Field Value
Type Description
String

KbWorkflow

KbWorkflow: Knowledge base workflow steps

Declaration
public const string KbWorkflow = "kb_workflow"
Field Value
Type Description
String

KbWorkflowAccess

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

Declaration
public const string KbWorkflowAccess = "kb_workflow_access"
Field Value
Type Description
String

LanguageInfo

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

Declaration
public const string LanguageInfo = "LanguageInfo"
Field Value
Type Description
String

LanguageInfoCountry

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

Declaration
public const string LanguageInfoCountry = "LanguageInfoCountry"
Field Value
Type Description
String

LegalBase

LegalBase: Legal base for GDPR (Article 6)

Declaration
public const string LegalBase = "LegalBase"
Field Value
Type Description
String

LegalHtmlTags

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

Declaration
public const string LegalHtmlTags = "legal_html_tags"
Field Value
Type Description
String

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

Declaration
public const string LicenseAssocLink = "LicenseAssocLink"
Field Value
Type Description
String

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

Declaration
public const string LicenseSatlLink = "LicenseSatlLink"
Field Value
Type Description
String

LocaleText

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.

Declaration
public const string LocaleText = "LocaleText"
Field Value
Type Description
String

Locking

Locking: Generic locking and error messages

Declaration
public const string Locking = "locking"
Field Value
Type Description
String

LogDebug

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

Declaration
public const string LogDebug = "log_debug"
Field Value
Type Description
String

LogEvents

LogEvents: System log

Declaration
public const string LogEvents = "log_events"
Field Value
Type Description
String

Login

Login: This table contains entries for the user sessions.

Declaration
public const string Login = "login"
Field Value
Type Description
String

LoginCustomer

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

Declaration
public const string LoginCustomer = "login_customer"
Field Value
Type Description
String

MailAlias

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.

Declaration
public const string MailAlias = "mail_alias"
Field Value
Type Description
String

MailBlock

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.

Declaration
public const string MailBlock = "mail_block"
Field Value
Type Description
String

MailInFilter

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

Declaration
public const string MailInFilter = "mail_in_filter"
Field Value
Type Description
String

MailingDomains

MailingDomains: List of allowed domains used in a Mailing

Declaration
public const string MailingDomains = "MailingDomains"
Field Value
Type Description
String

MailInUidl

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.

Declaration
public const string MailInUidl = "mail_in_uidl"
Field Value
Type Description
String

MergeMoveLog

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

Declaration
public const string MergeMoveLog = "MergeMoveLog"
Field Value
Type Description
String

Message

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

Declaration
public const string Message = "Message"
Field Value
Type Description
String

MessageCustomers

MessageCustomers: This table contains all cutomers who are involved in a message

Declaration
public const string MessageCustomers = "message_customers"
Field Value
Type Description
String

MessageHandler

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

Declaration
public const string MessageHandler = "MessageHandler"
Field Value
Type Description
String

MessageHeader

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

Declaration
public const string MessageHeader = "message_header"
Field Value
Type Description
String

MessageId

MessageId: This table links an email message id to an eJournal item

Declaration
public const string MessageId = "message_id"
Field Value
Type Description
String

ModuleLicense

ModuleLicense: Module licenses, belonging to one single owner

Declaration
public const string ModuleLicense = "ModuleLicense"
Field Value
Type Description
String

ModuleOwner

ModuleOwner: Unique owner of a set of licensed modules

Declaration
public const string ModuleOwner = "ModuleOwner"
Field Value
Type Description
String

MrMrs

MrMrs: MrMrs list table. List of salutations.

Declaration
public const string MrMrs = "MrMrs"
Field Value
Type Description
String

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

Declaration
public const string MrMrsGroupLink = "MrMrsGroupLink"
Field Value
Type Description
String

MrMrsHeadingLink: Heading link table for MrMrs, for MDO headers

Declaration
public const string MrMrsHeadingLink = "MrMrsHeadingLink"
Field Value
Type Description
String

MsFilter

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

Declaration
public const string MsFilter = "ms_filter"
Field Value
Type Description
String

MsFilterMail

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

Declaration
public const string MsFilterMail = "ms_filter_mail"
Field Value
Type Description
String

MsSubstitute

MsSubstitute: Regexp for extracting info from emails when they enter they system

Declaration
public const string MsSubstitute = "ms_substitute"
Field Value
Type Description
String

MsTrashbin

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

Declaration
public const string MsTrashbin = "ms_trashbin"
Field Value
Type Description
String

NoticeFrame

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

Declaration
public const string NoticeFrame = "notice_frame"
Field Value
Type Description
String

Notify

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

Declaration
public const string Notify = "notify"
Field Value
Type Description
String

Obsolete1

Obsolete1: Obsolete table for functionality that was never implemented

Declaration
public const string Obsolete1 = "obsolete_1"
Field Value
Type Description
String

Obsolete2

Obsolete2: Obsolete table for functionality that was never implemented

Declaration
public const string Obsolete2 = "obsolete_2"
Field Value
Type Description
String

Obsolete3

Obsolete3: Obsolete table for functionality that was never implemented

Declaration
public const string Obsolete3 = "obsolete_3"
Field Value
Type Description
String

Obsolete4

Obsolete4: Obsolete table for functionality that was never implemented

Declaration
public const string Obsolete4 = "obsolete_4"
Field Value
Type Description
String

OLEField

OLEField: Control data table for the OLE DB Provider

Declaration
public const string OLEField = "OLEField"
Field Value
Type Description
String

OLEFieldText

OLEFieldText: Control data table for the OLE DB Provider

Declaration
public const string OLEFieldText = "OLEFieldText"
Field Value
Type Description
String

OLESubject

OLESubject: Control data table for the OLE DB Provider

Declaration
public const string OLESubject = "OLESubject"
Field Value
Type Description
String

OLESubjectText

OLESubjectText: Control data table for the OLE DB Provider

Declaration
public const string OLESubjectText = "OLESubjectText"
Field Value
Type Description
String

OLEView

OLEView: Control data table for the OLE DB Provider

Declaration
public const string OLEView = "OLEView"
Field Value
Type Description
String

OLEViewText

OLEViewText: Control data table for the OLE DB Provider

Declaration
public const string OLEViewText = "OLEViewText"
Field Value
Type Description
String

OnlineApp

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

Declaration
public const string OnlineApp = "OnlineApp"
Field Value
Type Description
String

Outbox

Outbox: Outgoing emails with sending status and other info

Declaration
public const string Outbox = "outbox"
Field Value
Type Description
String

OutgoingMessage

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

Declaration
public const string OutgoingMessage = "outgoing_message"
Field Value
Type Description
String

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.

Declaration
public const string OwnerContactLink = "OwnerContactLink"
Field Value
Type Description
String

PasswordRules

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

Declaration
public const string PasswordRules = "password_rules"
Field Value
Type Description
String

PaymentTerms

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

Declaration
public const string PaymentTerms = "PaymentTerms"
Field Value
Type Description
String

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

Declaration
public const string PaymentTermsGroupLink = "PaymentTermsGroupLink"
Field Value
Type Description
String

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

Declaration
public const string PaymentTermsHeadingLink = "PaymentTermsHeadingLink"
Field Value
Type Description
String

PaymentType

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

Declaration
public const string PaymentType = "PaymentType"
Field Value
Type Description
String

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

Declaration
public const string PaymentTypeGroupLink = "PaymentTypeGroupLink"
Field Value
Type Description
String

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

Declaration
public const string PaymentTypeHeadingLink = "PaymentTypeHeadingLink"
Field Value
Type Description
String

PersInt

PersInt: PersInt list table. List of Person interests.

Declaration
public const string PersInt = "PersInt"
Field Value
Type Description
String

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

Declaration
public const string PersIntGroupLink = "PersIntGroupLink"
Field Value
Type Description
String

PersIntHeadingLink: Heading link table for PersInt, for MDO headers

Declaration
public const string PersIntHeadingLink = "PersIntHeadingLink"
Field Value
Type Description
String

Person

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

Declaration
public const string Person = "person"
Field Value
Type Description
String

PersonInterest

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.

Declaration
public const string PersonInterest = "personinterest"
Field Value
Type Description
String

PersPos

PersPos: PersPos list table. Contact person position list

Declaration
public const string PersPos = "PersPos"
Field Value
Type Description
String

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

Declaration
public const string PersPosGroupLink = "PersPosGroupLink"
Field Value
Type Description
String

PersPosHeadingLink: Heading link table for PersPos, for MDO headers

Declaration
public const string PersPosHeadingLink = "PersPosHeadingLink"
Field Value
Type Description
String

Phone

Phone: Contact and Person phonenumbers (+fax)

Declaration
public const string Phone = "phone"
Field Value
Type Description
String

PhoneFormat

PhoneFormat: Formatting information for telephone numbers

Declaration
public const string PhoneFormat = "PhoneFormat"
Field Value
Type Description
String

PMembType

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

Declaration
public const string PMembType = "PMembType"
Field Value
Type Description
String

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

Declaration
public const string PMembTypeGroupLink = "PMembTypeGroupLink"
Field Value
Type Description
String

PMembTypeHeadingLink: Heading link table for PMembType, for MDO headers

Declaration
public const string PMembTypeHeadingLink = "PMembTypeHeadingLink"
Field Value
Type Description
String

PrefDesc

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.

Declaration
public const string PrefDesc = "PrefDesc"
Field Value
Type Description
String

PrefDescLine

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.

Declaration
public const string PrefDescLine = "PrefDescLine"
Field Value
Type Description
String

Preference

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

Declaration
public const string Preference = "preference"
Field Value
Type Description
String

PriceList

PriceList: List of prices, cached from an ERP system

Declaration
public const string PriceList = "PriceList"
Field Value
Type Description
String

PriceUnit

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

Declaration
public const string PriceUnit = "PriceUnit"
Field Value
Type Description
String

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

Declaration
public const string PriceUnitGroupLink = "PriceUnitGroupLink"
Field Value
Type Description
String

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

Declaration
public const string PriceUnitHeadingLink = "PriceUnitHeadingLink"
Field Value
Type Description
String

Priority

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

Declaration
public const string Priority = "Priority"
Field Value
Type Description
String

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

Declaration
public const string PriorityGroupLink = "PriorityGroupLink"
Field Value
Type Description
String

PriorityHeadingLink: Heading link table for Priority, for MDO headers

Declaration
public const string PriorityHeadingLink = "PriorityHeadingLink"
Field Value
Type Description
String

Prob

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

Declaration
public const string Prob = "Prob"
Field Value
Type Description
String

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

Declaration
public const string ProbGroupLink = "ProbGroupLink"
Field Value
Type Description
String

ProbHeadingLink: Heading link table for Prob, for MDO headers

Declaration
public const string ProbHeadingLink = "ProbHeadingLink"
Field Value
Type Description
String

Product

Product: One Product, member of one price list

Declaration
public const string Product = "Product"
Field Value
Type Description
String

ProductCategory

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

Declaration
public const string ProductCategory = "ProductCategory"
Field Value
Type Description
String

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

Declaration
public const string ProductCategoryGroupLink = "ProductCategoryGroupLink"
Field Value
Type Description
String

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

Declaration
public const string ProductCategoryHeadingLink = "ProductCategoryHeadingLink"
Field Value
Type Description
String

ProductFamily

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

Declaration
public const string ProductFamily = "ProductFamily"
Field Value
Type Description
String

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

Declaration
public const string ProductFamilyGroupLink = "ProductFamilyGroupLink"
Field Value
Type Description
String

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

Declaration
public const string ProductFamilyHeadingLink = "ProductFamilyHeadingLink"
Field Value
Type Description
String

ProductType

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

Declaration
public const string ProductType = "ProductType"
Field Value
Type Description
String

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

Declaration
public const string ProductTypeGroupLink = "ProductTypeGroupLink"
Field Value
Type Description
String

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

Declaration
public const string ProductTypeHeadingLink = "ProductTypeHeadingLink"
Field Value
Type Description
String

ProductVersion

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

Declaration
public const string ProductVersion = "ProductVersion"
Field Value
Type Description
String

Profile

Profile: Deprecated. This table contains entries for the user profiles.

Declaration
public const string Profile = "profile"
Field Value
Type Description
String

Project

Project: Projects

Declaration
public const string Project = "project"
Field Value
Type Description
String

ProjectMember

ProjectMember: Project members. Link-table between person and project

Declaration
public const string ProjectMember = "projectmember"
Field Value
Type Description
String

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

Declaration
public const string ProjectTypeStatusLink = "ProjectTypeStatusLink"
Field Value
Type Description
String

ProjStatus

ProjStatus: ProjStatus list table. Project status

Declaration
public const string ProjStatus = "ProjStatus"
Field Value
Type Description
String

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

Declaration
public const string ProjStatusGroupLink = "ProjStatusGroupLink"
Field Value
Type Description
String

ProjStatusHeadingLink: Heading link table for ProjStatus, for MDO headers

Declaration
public const string ProjStatusHeadingLink = "ProjStatusHeadingLink"
Field Value
Type Description
String

ProjType

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

Declaration
public const string ProjType = "ProjType"
Field Value
Type Description
String

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

Declaration
public const string ProjTypeGroupLink = "ProjTypeGroupLink"
Field Value
Type Description
String

ProjTypeHeadingLink: Heading link table for ProjType, for MDO headers

Declaration
public const string ProjTypeHeadingLink = "ProjTypeHeadingLink"
Field Value
Type Description
String

Publish

Publish: Publishing system for external users

Declaration
public const string Publish = "Publish"
Field Value
Type Description
String

PushNotificationService

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

Declaration
public const string PushNotificationService = "PushNotificationService"
Field Value
Type Description
String

QuickReply

QuickReply: Personal quick reply text fragments

Declaration
public const string QuickReply = "quick_reply"
Field Value
Type Description
String

Quote

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

Declaration
public const string Quote = "Quote"
Field Value
Type Description
String

QuoteAlternative

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.

Declaration
public const string QuoteAlternative = "QuoteAlternative"
Field Value
Type Description
String

QuoteApprReason

QuoteApprReason: Predefined reasons for quote approval

Declaration
public const string QuoteApprReason = "QuoteApprReason"
Field Value
Type Description
String

QuoteApprReasonGroupLink: User group link table for QuoteApprReason, for MDO item hiding

Declaration
public const string QuoteApprReasonGroupLink = "QuoteApprReasonGroupLink"
Field Value
Type Description
String

QuoteApprReasonHeadingLink: Heading link table for QuoteApprReason, for MDO headers

Declaration
public const string QuoteApprReasonHeadingLink = "QuoteApprReasonHeadingLink"
Field Value
Type Description
String

QuoteConnection

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

Declaration
public const string QuoteConnection = "QuoteConnection"
Field Value
Type Description
String

QuoteConnectionAccess

QuoteConnectionAccess: Access control for Quote Connections

Declaration
public const string QuoteConnectionAccess = "QuoteConnectionAccess"
Field Value
Type Description
String

QuoteDenyReason

QuoteDenyReason: Predefined reasons for quote denial

Declaration
public const string QuoteDenyReason = "QuoteDenyReason"
Field Value
Type Description
String

QuoteDenyReasonGroupLink: User group link table for QuoteDenyReason, for MDO item hiding

Declaration
public const string QuoteDenyReasonGroupLink = "QuoteDenyReasonGroupLink"
Field Value
Type Description
String

QuoteDenyReasonHeadingLink: Heading link table for QuoteDenyReason, for MDO headers

Declaration
public const string QuoteDenyReasonHeadingLink = "QuoteDenyReasonHeadingLink"
Field Value
Type Description
String

QuoteLine

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.

Declaration
public const string QuoteLine = "QuoteLine"
Field Value
Type Description
String

QuoteLineConfiguration

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

Declaration
public const string QuoteLineConfiguration = "QuoteLineConfiguration"
Field Value
Type Description
String

QuoteVersion

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

Declaration
public const string QuoteVersion = "QuoteVersion"
Field Value
Type Description
String

QuoteVersionAttachment

QuoteVersionAttachment: Actual attachments to a quote

Declaration
public const string QuoteVersionAttachment = "QuoteVersionAttachment"
Field Value
Type Description
String

Reason

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

Declaration
public const string Reason = "Reason"
Field Value
Type Description
String

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

Declaration
public const string ReasonGroupLink = "ReasonGroupLink"
Field Value
Type Description
String

ReasonHeadingLink: Heading link table for Reason, for MDO headers

Declaration
public const string ReasonHeadingLink = "ReasonHeadingLink"
Field Value
Type Description
String

ReasonSold

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

Declaration
public const string ReasonSold = "ReasonSold"
Field Value
Type Description
String

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

Declaration
public const string ReasonSoldGroupLink = "ReasonSoldGroupLink"
Field Value
Type Description
String

ReasonSoldHeadingLink: Heading link table for ReasonSold, for MDO headers

Declaration
public const string ReasonSoldHeadingLink = "ReasonSoldHeadingLink"
Field Value
Type Description
String

ReasonStalled

ReasonStalled: Why was the sale marked as stalled

Declaration
public const string ReasonStalled = "ReasonStalled"
Field Value
Type Description
String

ReasonStalledGroupLink: Link table for ReasonStalled, for MDO item hiding

Declaration
public const string ReasonStalledGroupLink = "ReasonStalledGroupLink"
Field Value
Type Description
String

ReasonStalledHeadingLink: Heading link table for ReasonStalled, for MDO headers

Declaration
public const string ReasonStalledHeadingLink = "ReasonStalledHeadingLink"
Field Value
Type Description
String

RecurrenceRule

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

Declaration
public const string RecurrenceRule = "RecurrenceRule"
Field Value
Type Description
String

RedLetterDay

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

Declaration
public const string RedLetterDay = "redletterday"
Field Value
Type Description
String

RefCountRange

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

Declaration
public const string RefCountRange = "RefCountRange"
Field Value
Type Description
String

RefCounts

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.

Declaration
public const string RefCounts = "RefCounts"
Field Value
Type Description
String

Registry

Registry: System settings

Declaration
public const string Registry = "registry"
Field Value
Type Description
String

RejectReason

RejectReason: Rejection reason (suggested) for bookings

Declaration
public const string RejectReason = "RejectReason"
Field Value
Type Description
String

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

Declaration
public const string RejectReasonGroupLink = "RejectReasonGroupLink"
Field Value
Type Description
String

RejectReasonHeadingLink: Heading link table for RejectReason, for MDO headers

Declaration
public const string RejectReasonHeadingLink = "RejectReasonHeadingLink"
Field Value
Type Description
String

RelationDefinition

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

Declaration
public const string RelationDefinition = "relationdefinition"
Field Value
Type Description
String

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

Declaration
public const string RelationDefinitionGroupLink = "RelDefGroupLink"
Field Value
Type Description
String

RelationDefinitionHeadingLink: Heading link table for RelDef, for MDO headers

Declaration
public const string RelationDefinitionHeadingLink = "RelDefHeadingLink"
Field Value
Type Description
String

Relations

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.

Declaration
public const string Relations = "relations"
Field Value
Type Description
String

RelationTarget

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.

Declaration
public const string RelationTarget = "relationtarget"
Field Value
Type Description
String

ReplyTemplate

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

Declaration
public const string ReplyTemplate = "reply_template"
Field Value
Type Description
String

ReplyTemplateAttachment

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

Declaration
public const string ReplyTemplateAttachment = "reply_template_attachment"
Field Value
Type Description
String

ReplyTemplateBody

ReplyTemplateBody: Contains the body of the reply templates in different languages

Declaration
public const string ReplyTemplateBody = "reply_template_body"
Field Value
Type Description
String

ReplyTemplateFolder

ReplyTemplateFolder: This table contains entries for folders for reply templates.

Declaration
public const string ReplyTemplateFolder = "reply_template_folder"
Field Value
Type Description
String

ReporterListDef

ReporterListDef: Reporter definitions

Declaration
public const string ReporterListDef = "ReporterListDef"
Field Value
Type Description
String

ResourceOverride

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

Declaration
public const string ResourceOverride = "ResourceOverride"
Field Value
Type Description
String

Role

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

Declaration
public const string Role = "Role"
Field Value
Type Description
String

RoleCategory

RoleCategory: Category membership associated with a role

Declaration
public const string RoleCategory = "role_category"
Field Value
Type Description
String

RoleElement

RoleElement: Profiles associated with a role

Declaration
public const string RoleElement = "role_element"
Field Value
Type Description
String

RoleMember

RoleMember: Users linked to a role. Deprecated.

Declaration
public const string RoleMember = "role_member"
Field Value
Type Description
String

RoleWorkflow

RoleWorkflow: Knowledge base workflow access rights associated with a role

Declaration
public const string RoleWorkflow = "role_workflow"
Field Value
Type Description
String

SaintConfiguration

SaintConfiguration: Configuration information for the Saint system

Declaration
public const string SaintConfiguration = "SaintConfiguration"
Field Value
Type Description
String

Sale

Sale: Sales For every Sale record edited through the SuperOffice GUI, a copy of the current version of the record will be saved in the SaleHist table. This also applies to editing done through the SaleModel COM interface, but not to editing done through the OLE DB Provider or other channels.

Declaration
public const string Sale = "sale"
Field Value
Type Description
String

SaleHist

SaleHist: Mirror image of the Sale table, providing a full transaction history. Every time you edit a sale, the current record of the sale is also saved here.

Declaration
public const string SaleHist = "SaleHist"
Field Value
Type Description
String

SaleStakeholder

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

Declaration
public const string SaleStakeholder = "SaleStakeholder"
Field Value
Type Description
String

SaleType

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

Declaration
public const string SaleType = "SaleType"
Field Value
Type Description
String

SaleTypeCat

SaleTypeCat: Category for sale type

Declaration
public const string SaleTypeCat = "SaleTypeCat"
Field Value
Type Description
String

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

Declaration
public const string SaleTypeCatGroupLink = "SaleTypeCatGroupLink"
Field Value
Type Description
String

SaleTypeCatHeadingLink: Heading link table for SaleTypeCat, for MDO headers

Declaration
public const string SaleTypeCatHeadingLink = "SaleTypeCatHeadingLink"
Field Value
Type Description
String

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

Declaration
public const string SaleTypeGroupLink = "SaleTypeGroupLink"
Field Value
Type Description
String

SaleTypeHeadingLink: Heading link table for SaleType, for MDO headers

Declaration
public const string SaleTypeHeadingLink = "SaleTypeHeadingLink"
Field Value
Type Description
String

SaleTypeQuoteAttachment

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

Declaration
public const string SaleTypeQuoteAttachment = "SaleTypeQuoteAttachment"
Field Value
Type Description
String

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

Declaration
public const string SaleTypeStageLink = "SaleTypeStageLink"
Field Value
Type Description
String

Salutation

Salutation: Academic title for Person

Declaration
public const string Salutation = "Salutation"
Field Value
Type Description
String

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

Declaration
public const string SalutationGroupLink = "SalutationGroupLink"
Field Value
Type Description
String

SalutationHeadingLink: Heading link table for Salutation, for MDO headers

Declaration
public const string SalutationHeadingLink = "SalutationHeadingLink"
Field Value
Type Description
String

Satellite

Satellite: Definition of Satellites

Declaration
public const string Satellite = "satellite"
Field Value
Type Description
String

SAttachment

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

Declaration
public const string SAttachment = "s_attachment"
Field Value
Type Description
String

SBounceShipment

SBounceShipment: Email bounces from customers

Declaration
public const string SBounceShipment = "s_bounce_shipment"
Field Value
Type Description
String

Schedule

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

Declaration
public const string Schedule = "schedule"
Field Value
Type Description
String

ScheduledTask

ScheduledTask: A scheduled entry executing a script at certain times

Declaration
public const string ScheduledTask = "scheduled_task"
Field Value
Type Description
String

ScreenChooser

ScreenChooser: Screen choosers

Declaration
public const string ScreenChooser = "screen_chooser"
Field Value
Type Description
String

ScreenDefinition

ScreenDefinition: A configurable screen

Declaration
public const string ScreenDefinition = "screen_definition"
Field Value
Type Description
String

ScreenDefinitionAction

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

Declaration
public const string ScreenDefinitionAction = "screen_definition_action"
Field Value
Type Description
String

ScreenDefinitionElement

ScreenDefinitionElement: An element in a configurable screen

Declaration
public const string ScreenDefinitionElement = "screen_definition_element"
Field Value
Type Description
String

ScreenDefinitionHidden

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

Declaration
public const string ScreenDefinitionHidden = "screen_definition_hidden"
Field Value
Type Description
String

ScreenDefinitionLanguage

ScreenDefinitionLanguage: Custom language variables used for screens

Declaration
public const string ScreenDefinitionLanguage = "screen_definition_language"
Field Value
Type Description
String

ScriptTrace

ScriptTrace: Scripts which should be traced

Declaration
public const string ScriptTrace = "script_trace"
Field Value
Type Description
String

ScriptTraceRun

ScriptTraceRun: Traces of executed scripts

Declaration
public const string ScriptTraceRun = "script_trace_run"
Field Value
Type Description
String

SDynCriteria

SDynCriteria: Contains criterias for a dynamic list.

Declaration
public const string SDynCriteria = "s_dyn_criteria"
Field Value
Type Description
String

SearchCat

SearchCat: SearchCat list table

Declaration
public const string SearchCat = "SearchCat"
Field Value
Type Description
String

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

Declaration
public const string SearchCatGroupLink = "SearchCatGroupLink"
Field Value
Type Description
String

SearchCatHeadingLink: Heading link table for SearchCat, for MDO headers

Declaration
public const string SearchCatHeadingLink = "SearchCatHeadingLink"
Field Value
Type Description
String

SearchCriteria

SearchCriteria: Criteria storage for Selection and other Find mechanisms

Declaration
public const string SearchCriteria = "SearchCriteria"
Field Value
Type Description
String

SearchCriteriaGroup

SearchCriteriaGroup: Criteria storage for Selection and other Find mechanisms

Declaration
public const string SearchCriteriaGroup = "SearchCriteriaGroup"
Field Value
Type Description
String

SearchCriterion

SearchCriterion: Criteria storage for Selection and other Find mechanisms

Declaration
public const string SearchCriterion = "SearchCriterion"
Field Value
Type Description
String

SearchCriterionValue

SearchCriterionValue: Criteria storage for Selection and other Find mechanisms

Declaration
public const string SearchCriterionValue = "SearchCriterionValue"
Field Value
Type Description
String

Selection

Selection: Selections

Declaration
public const string Selection = "selection"
Field Value
Type Description
String

SelectionMember

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.

Declaration
public const string SelectionMember = "selectionmember"
Field Value
Type Description
String

Sequence

Sequence: next_id to be used for each table

Declaration
public const string Sequence = "sequence"
Field Value
Type Description
String

ServiceAuth

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

Declaration
public const string ServiceAuth = "service_auth"
Field Value
Type Description
String

SessionObject

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

Declaration
public const string SessionObject = "session_object"
Field Value
Type Description
String

ShipmentType

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

Declaration
public const string ShipmentType = "ShipmentType"
Field Value
Type Description
String

ShipmentTypeReservation

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

Declaration
public const string ShipmentTypeReservation = "ShipmentTypeReservation"
Field Value
Type Description
String

SLink: Links in messages to measure success rate of a campaign.

Declaration
public const string SLink = "s_link"
Field Value
Type Description
String

SLinkCustomer

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

Declaration
public const string SLinkCustomer = "s_link_customer"
Field Value
Type Description
String

SLinkCustomerStatical

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

Declaration
public const string SLinkCustomerStatical = "s_link_customer_statical"
Field Value
Type Description
String

SList

SList: A list, dynamic or static

Declaration
public const string SList = "s_list"
Field Value
Type Description
String

SListCustomer

SListCustomer: Elements in a customer list.

Declaration
public const string SListCustomer = "s_list_customer"
Field Value
Type Description
String

SListElement

SListElement: Elements in a static list.

Declaration
public const string SListElement = "s_list_element"
Field Value
Type Description
String

SListShipment

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

Declaration
public const string SListShipment = "s_list_shipment"
Field Value
Type Description
String

SMessage

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

Declaration
public const string SMessage = "s_message"
Field Value
Type Description
String

SMessageblock

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

Declaration
public const string SMessageblock = "s_messageblock"
Field Value
Type Description
String

Sms

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

Declaration
public const string Sms = "sms"
Field Value
Type Description
String

SmsHysteria

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

Declaration
public const string SmsHysteria = "sms_hysteria"
Field Value
Type Description
String

Snapshot

Snapshot: Snapshots taken of the system database and attachments via soap

Declaration
public const string Snapshot = "snapshot"
Field Value
Type Description
String

SoapAccess

SoapAccess: Table that contains constraints on the access to the soap interface

Declaration
public const string SoapAccess = "soap_access"
Field Value
Type Description
String

SORCriteria

SORCriteria: SuperOffice reporter data

Declaration
public const string SORCriteria = "SORCriteria"
Field Value
Type Description
String

SORFCT

SORFCT: SuperOffice reporter data

Declaration
public const string SORFCT = "SORFCT"
Field Value
Type Description
String

SORField

SORField: SuperOffice reporter data

Declaration
public const string SORField = "SORField"
Field Value
Type Description
String

SORLabelLayout

SORLabelLayout: SuperOffice reporter data

Declaration
public const string SORLabelLayout = "SORLabelLayout"
Field Value
Type Description
String

SOROperators

SOROperators: SuperOffice reporter data

Declaration
public const string SOROperators = "SOROperators"
Field Value
Type Description
String

SORPublish

SORPublish: SuperOffice reporter data

Declaration
public const string SORPublish = "SORPublish"
Field Value
Type Description
String

SORPublishGroupLink: Link table used for filtering reports by user group

Declaration
public const string SORPublishGroupLink = "SORPublishGroupLink"
Field Value
Type Description
String

SORSection

SORSection: SuperOffice reporter data

Declaration
public const string SORSection = "SORSection"
Field Value
Type Description
String

SORTemplate

SORTemplate: SuperOffice reporter data

Declaration
public const string SORTemplate = "SORTemplate"
Field Value
Type Description
String

Source

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

Declaration
public const string Source = "Source"
Field Value
Type Description
String

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

Declaration
public const string SourceGroupLink = "SourceGroupLink"
Field Value
Type Description
String

SourceHeadingLink: Heading link table for Source, for MDO headers

Declaration
public const string SourceHeadingLink = "SourceHeadingLink"
Field Value
Type Description
String

SPictureEntry

SPictureEntry: This table describes each picture in the database

Declaration
public const string SPictureEntry = "s_picture_entry"
Field Value
Type Description
String

SPictureFolder

SPictureFolder: This table contains all picture folders

Declaration
public const string SPictureFolder = "s_picture_folder"
Field Value
Type Description
String

SSentMessage

SSentMessage: Emarketeer message control

Declaration
public const string SSentMessage = "s_sent_message"
Field Value
Type Description
String

SShipment

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

Declaration
public const string SShipment = "s_shipment"
Field Value
Type Description
String

SShipmentAddr

SShipmentAddr: Addresses that are ready to be sent in a shipment.

Declaration
public const string SShipmentAddr = "s_shipment_addr"
Field Value
Type Description
String

SSmtpServers

SSmtpServers: Contains the smtp server for a shipment

Declaration
public const string SSmtpServers = "s_smtp_servers"
Field Value
Type Description
String

StakeholderRole

StakeholderRole: Role a stakeholder has in a sale

Declaration
public const string StakeholderRole = "StakeholderRole"
Field Value
Type Description
String

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

Declaration
public const string StakeholderRoleGroupLink = "StakeholderRoleGroupLink"
Field Value
Type Description
String

StakeholderRoleHeadingLink: Heading link table for StakeholderRole, for MDO headers

Declaration
public const string StakeholderRoleHeadingLink = "StakeholderRoleHeadingLink"
Field Value
Type Description
String

StaticListRef

StaticListRef: This table stores id references for selections id lists

Declaration
public const string StaticListRef = "static_list_ref"
Field Value
Type Description
String

StatusDef

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

Declaration
public const string StatusDef = "StatusDef"
Field Value
Type Description
String

StatusValue

StatusValue: Values for statuses

Declaration
public const string StatusValue = "StatusValue"
Field Value
Type Description
String

SubscriptionUnit

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

Declaration
public const string SubscriptionUnit = "SubscriptionUnit"
Field Value
Type Description
String

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

Declaration
public const string SubscriptionUnitGroupLink = "SubscriptionUnitGroupLink"
Field Value
Type Description
String

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

Declaration
public const string SubscriptionUnitHeadingLink = "SubscriptionUnitHeadingLink"
Field Value
Type Description
String

SuggestedAppointment

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

Declaration
public const string SuggestedAppointment = "SuggestedAppointment"
Field Value
Type Description
String

SuggestedDocument

SuggestedDocument: Unique owner of a set of licensed modules

Declaration
public const string SuggestedDocument = "SuggestedDocument"
Field Value
Type Description
String

SuperListColumnSize

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

Declaration
public const string SuperListColumnSize = "SuperListColumnSize"
Field Value
Type Description
String

SWashing

SWashing: Register of all bounced mail to enabel washing

Declaration
public const string SWashing = "s_washing"
Field Value
Type Description
String

SWashingList

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

Declaration
public const string SWashingList = "s_washing_list"
Field Value
Type Description
String

SystemEvent

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

Declaration
public const string SystemEvent = "SystemEvent"
Field Value
Type Description
String

SystemScript

SystemScript: A table containing the system script

Declaration
public const string SystemScript = "system_script"
Field Value
Type Description
String

TabOrder

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

Declaration
public const string TabOrder = "TabOrder"
Field Value
Type Description
String

Tags

Tags: MDO List of tags for Service entities

Declaration
public const string Tags = "Tags"
Field Value
Type Description
String

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

Declaration
public const string TagsGroupLink = "TagsGroupLink"
Field Value
Type Description
String

TagsHeadingLink: Heading link table for Source, for MDO headers

Declaration
public const string TagsHeadingLink = "TagsHeadingLink"
Field Value
Type Description
String

TargetAssignmentInfo

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

Declaration
public const string TargetAssignmentInfo = "target_assignment_info"
Field Value
Type Description
String

TargetAssignmentValue

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

Declaration
public const string TargetAssignmentValue = "target_assignment_value"
Field Value
Type Description
String

TargetChange

TargetChange: A single field change.

Declaration
public const string TargetChange = "target_change"
Field Value
Type Description
String

TargetDimension

TargetDimension: Defining target dimension

Declaration
public const string TargetDimension = "target_dimension"
Field Value
Type Description
String

TargetGroup

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

Declaration
public const string TargetGroup = "target_group"
Field Value
Type Description
String

TargetPeriod

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

Declaration
public const string TargetPeriod = "target_period"
Field Value
Type Description
String

TargetRevision

TargetRevision: One batch of changes made to targets

Declaration
public const string TargetRevision = "target_revision"
Field Value
Type Description
String

TargetRevisionHistory

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

Declaration
public const string TargetRevisionHistory = "target_revision_history"
Field Value
Type Description
String

Task

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

Declaration
public const string Task = "Task"
Field Value
Type Description
String

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

Declaration
public const string TaskGroupLink = "TaskGroupLink"
Field Value
Type Description
String

TaskHeadingLink: Heading link table for Task, for MDO headers

Declaration
public const string TaskHeadingLink = "TaskHeadingLink"
Field Value
Type Description
String

TaskMenu

TaskMenu: List items to merge into menues

Declaration
public const string TaskMenu = "TaskMenu"
Field Value
Type Description
String

TaskMenuGroupLink: User group link table for TaskMenu, for MDO item hiding

Declaration
public const string TaskMenuGroupLink = "TaskMenuGroupLink"
Field Value
Type Description
String

TaskMenuHeadingLink: Heading link table for TaskMenu, for MDO headers

Declaration
public const string TaskMenuHeadingLink = "TaskMenuHeadingLink"
Field Value
Type Description
String

TempDbLock

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

Declaration
public const string TempDbLock = "temp_db_lock"
Field Value
Type Description
String

TemporaryKey

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

Declaration
public const string TemporaryKey = "TemporaryKey"
Field Value
Type Description
String

TemporaryWords

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

Declaration
public const string TemporaryWords = "temporary_words"
Field Value
Type Description
String

Text

Text: Long text fields from all over the system

Declaration
public const string Text = "text"
Field Value
Type Description
String

Ticket

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

Declaration
public const string Ticket = "ticket"
Field Value
Type Description
String

TicketAlert

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

Declaration
public const string TicketAlert = "ticket_alert"
Field Value
Type Description
String

TicketAttachment

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

Declaration
public const string TicketAttachment = "ticket_attachment"
Field Value
Type Description
String

TicketCustomers

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

Declaration
public const string TicketCustomers = "ticket_customers"
Field Value
Type Description
String

TicketLog

TicketLog: This table contains log entries for the tickets.

Declaration
public const string TicketLog = "ticket_log"
Field Value
Type Description
String

TicketLogAction

TicketLogAction: This table contains actions for the tickets.

Declaration
public const string TicketLogAction = "ticket_log_action"
Field Value
Type Description
String

TicketLogChange

TicketLogChange: This table contains log entries for the tickets.

Declaration
public const string TicketLogChange = "ticket_log_change"
Field Value
Type Description
String

TicketPriority

TicketPriority: This table contains the ticket priorities.

Declaration
public const string TicketPriority = "ticket_priority"
Field Value
Type Description
String

TicketStatus

TicketStatus: This table user defined ticket status values.

Declaration
public const string TicketStatus = "ticket_status"
Field Value
Type Description
String

TicketStatusHistory

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

Declaration
public const string TicketStatusHistory = "ticket_status_history"
Field Value
Type Description
String

TicketType

TicketType: A ticket (request) type

Declaration
public const string TicketType = "ticket_type"
Field Value
Type Description
String

TicketTypePriority

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

Declaration
public const string TicketTypePriority = "ticket_type_priority"
Field Value
Type Description
String

TicketTypeStatus

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

Declaration
public const string TicketTypeStatus = "ticket_type_status"
Field Value
Type Description
String

Timestamps

Timestamps: Timestamp information

Declaration
public const string Timestamps = "timestamps"
Field Value
Type Description
String

TravelCurrent

TravelCurrent: Information about this database and its place in the hierarchy

Declaration
public const string TravelCurrent = "travelcurrent"
Field Value
Type Description
String

TravelGeneratedDatabase

TravelGeneratedDatabase: Information about all databases generated from this database

Declaration
public const string TravelGeneratedDatabase = "travelgenerateddatabase"
Field Value
Type Description
String

TravelGeneratedTransaction

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

Declaration
public const string TravelGeneratedTransaction = "travelgeneratedtransaction"
Field Value
Type Description
String

TravelIDMapping

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.

Declaration
public const string TravelIDMapping = "travelidmapping"
Field Value
Type Description
String

Traveller

Traveller: Associates traveling out from this database

Declaration
public const string Traveller = "traveller"
Field Value
Type Description
String

TravelTransactionLog

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

Declaration
public const string TravelTransactionLog = "traveltransactionlog"
Field Value
Type Description
String

TrayApp

TrayApp: Tray application presence. SuperOffice CRM web extensions.

Declaration
public const string TrayApp = "TrayApp"
Field Value
Type Description
String

TreeExplorerEntry

TreeExplorerEntry: This table stores the entries in a tree-explorer

Declaration
public const string TreeExplorerEntry = "tree_explorer_entry"
Field Value
Type Description
String

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

Declaration
public const string TreeExplorerLink = "tree_explorer_link"
Field Value
Type Description
String

TypicalSearch

TypicalSearch: Owner of a set of predefined selection criteria

Declaration
public const string TypicalSearch = "TypicalSearch"
Field Value
Type Description
String

TZDstRule

TZDstRule: Time zone rule for daylight saving time

Declaration
public const string TZDstRule = "TZDstRule"
Field Value
Type Description
String

TZLocation

TZLocation: Time zone location

Declaration
public const string TZLocation = "TZLocation"
Field Value
Type Description
String

TZStdRule

TZStdRule: Time zone rule for standard time

Declaration
public const string TZStdRule = "TZStdRule"
Field Value
Type Description
String

UDAppntLarge

UDAppntLarge: User-defined fields

Declaration
public const string UDAppntLarge = "udappntlarge"
Field Value
Type Description
String

UDAppntSmall

UDAppntSmall: User-defined fields

Declaration
public const string UDAppntSmall = "udappntsmall"
Field Value
Type Description
String

UDContactLarge

UDContactLarge: User-defined fields for contact (long strings)

Declaration
public const string UDContactLarge = "udcontactLarge"
Field Value
Type Description
String

UDContactSmall

UDContactSmall: User-defined fields for contact

Declaration
public const string UDContactSmall = "udcontactSmall"
Field Value
Type Description
String

UDDocLarge

UDDocLarge: User-defined fields

Declaration
public const string UDDocLarge = "uddoclarge"
Field Value
Type Description
String

UDDocSmall

UDDocSmall: User-defined fields

Declaration
public const string UDDocSmall = "uddocsmall"
Field Value
Type Description
String

UDefField

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.

Declaration
public const string UDefField = "UDefField"
Field Value
Type Description
String

UDefFieldGL

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

Declaration
public const string UDefFieldGL = "UDefFieldGL"
Field Value
Type Description
String

UDList

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.

Declaration
public const string UDList = "UDList"
Field Value
Type Description
String

UDListDefinition

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.

Declaration
public const string UDListDefinition = "UDListDefinition"
Field Value
Type Description
String

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.

Declaration
public const string UDListGroupLink = "UDListGroupLink"
Field Value
Type Description
String

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.

Declaration
public const string UDListHeadingLink = "UDListHeadingLink"
Field Value
Type Description
String

UDPersonLarge

UDPersonLarge: User-defined fields

Declaration
public const string UDPersonLarge = "udpersonLarge"
Field Value
Type Description
String

UDPersonSmall

UDPersonSmall: User-defined fields

Declaration
public const string UDPersonSmall = "udpersonSmall"
Field Value
Type Description
String

UDProjectLarge

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

Declaration
public const string UDProjectLarge = "udprojectLarge"
Field Value
Type Description
String

UDProjectSmall

UDProjectSmall: User-defined fields

Declaration
public const string UDProjectSmall = "udprojectSmall"
Field Value
Type Description
String

UDSaleLarge

UDSaleLarge: User-defined fields

Declaration
public const string UDSaleLarge = "udsalelarge"
Field Value
Type Description
String

UDSaleSmall

UDSaleSmall: User-defined fields

Declaration
public const string UDSaleSmall = "udsalesmall"
Field Value
Type Description
String

UDTempLarge

UDTempLarge: User-defined fields

Declaration
public const string UDTempLarge = "udtempLarge"
Field Value
Type Description
String

UDTempSmall

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

Declaration
public const string UDTempSmall = "udtempSmall"
Field Value
Type Description
String

URL

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

Declaration
public const string URL = "URL"
Field Value
Type Description
String

UsageStats

UsageStats: Usage statistics

Declaration
public const string UsageStats = "UsageStats"
Field Value
Type Description
String

UserAttribute

UserAttribute: This table is used for storing various attributes for users.

Declaration
public const string UserAttribute = "user_attribute"
Field Value
Type Description
String

UserCandidate

UserCandidate: This table will hold user candidate secrets

Declaration
public const string UserCandidate = "user_candidate"
Field Value
Type Description
String

UserGroup

UserGroup: Secondary user groups

Declaration
public const string UserGroup = "UserGroup"
Field Value
Type Description
String

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.

Declaration
public const string UserGroupLink = "UserGroupLink"
Field Value
Type Description
String

UserPreference

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

Declaration
public const string UserPreference = "UserPreference"
Field Value
Type Description
String

UserRoleLink: Link between user role and user

Declaration
public const string UserRoleLink = "UserRoleLink"
Field Value
Type Description
String

VisibleFor

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

Declaration
public const string VisibleFor = "VisibleFor"
Field Value
Type Description
String

WebAppUsage

WebAppUsage: Usage statistics for web applications

Declaration
public const string WebAppUsage = "WebAppUsage"
Field Value
Type Description
String

Webhook

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

Declaration
public const string Webhook = "Webhook"
Field Value
Type Description
String

WebhookUsage

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

Declaration
public const string WebhookUsage = "Webhook_usage"
Field Value
Type Description
String

WinPosSize

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

Declaration
public const string WinPosSize = "WinPosSize"
Field Value
Type Description
String

WordRelations

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

Declaration
public const string WordRelations = "word_relations"
Field Value
Type Description
String

Workflow

Workflow: SuperOffice specific info about a workflow

Declaration
public const string Workflow = "workflow"
Field Value
Type Description
String

WorkflowGoal

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

Declaration
public const string WorkflowGoal = "workflow_goal"
Field Value
Type Description
String

WorkflowInstance

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

Declaration
public const string WorkflowInstance = "workflow_instance"
Field Value
Type Description
String

WorkflowRootStepLink: Link root steps to the workflow

Declaration
public const string WorkflowRootStepLink = "workflow_root_step_link"
Field Value
Type Description
String

WorkflowStep

WorkflowStep: A set of steps related to a workflow.

Declaration
public const string WorkflowStep = "workflow_step"
Field Value
Type Description
String

WorkflowStepOption

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

Declaration
public const string WorkflowStepOption = "workflow_step_option"
Field Value
Type Description
String

WorkflowStepOptionLink: Link steps to other steps through step options

Declaration
public const string WorkflowStepOptionLink = "workflow_step_option_link"
Field Value
Type Description
String

WorkflowTrigger

WorkflowTrigger: A set of triggers related to a workflow.

Declaration
public const string WorkflowTrigger = "workflow_trigger"
Field Value
Type Description
String

WorkflowWaitForAction

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

Declaration
public const string WorkflowWaitForAction = "workflow_wait_for_action"
Field Value
Type Description
String

WsdlDescription

WsdlDescription: Soap wsdl files

Declaration
public const string WsdlDescription = "wsdl_description"
Field Value
Type Description
String

ZipToCity

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

Declaration
public const string ZipToCity = "ziptocity"
Field Value
Type Description
String