Class TablesInfo
Factory for generated TableInfo classes, supports both typed, named and generic lookups of tables
Inherited Members
Namespace: SuperOffice.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseStep]
[DatabaseStep]
[DatabaseStep]
[DatabaseStep]
[DatabaseStep]
[DatabaseStep]
[DatabaseStep]
[DatabaseStep]
[DatabaseStep]
[DatabaseStep]
[DatabaseStep]
[DatabaseStep]
[DatabaseStep]
[DatabaseStep]
[DatabaseStep]
[DatabaseStep]
[DatabaseStep]
[DatabaseStep]
[DatabaseStep]
[DatabaseStep]
[DatabaseStep]
[DatabaseStep]
[DatabaseStep]
[DatabaseStep]
[DatabaseStep]
[DatabaseStep]
[DatabaseStep]
[DatabaseStep]
[DatabaseStep]
[DatabaseStep]
public static class TablesInfoMethods
GetAccessScriptTableInfo()
New instance of AccessScriptTableInfo: Scripts to implement row-based access rules (sentry light)
Declaration
public static AccessScriptTableInfo GetAccessScriptTableInfo()Returns
| Type | Description |
|---|---|
| AccessScriptTableInfo |
GetActiveUserTableInfo()
New instance of ActiveUserTableInfo: 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 static ActiveUserTableInfo GetActiveUserTableInfo()Returns
| Type | Description |
|---|---|
| ActiveUserTableInfo |
GetAddressFormatTableInfo()
New instance of AddressFormatTableInfo: Address formats for GUI and labels. See more information: Addressformat on http://techdoc.superoffice.com
Declaration
public static AddressFormatTableInfo GetAddressFormatTableInfo()Returns
| Type | Description |
|---|---|
| AddressFormatTableInfo |
GetAddressTableInfo()
New instance of AddressTableInfo: Contact and Person addresses
Declaration
public static AddressTableInfo GetAddressTableInfo()Returns
| Type | Description |
|---|---|
| AddressTableInfo |
GetAiChatTurnTableInfo()
New instance of AiChatTurnTableInfo: Contains AI Chatbot history - contains whole chat, not just what is sent to the chatbot. History is ready ordered by timestamp
Declaration
public static AiChatTurnTableInfo GetAiChatTurnTableInfo()Returns
| Type | Description |
|---|---|
| AiChatTurnTableInfo |
GetAmountClassGroupLinkTableInfo()
New instance of AmountClassGroupLinkTableInfo: User group link table for AmountClass, for MDO item hiding
Declaration
public static AmountClassGroupLinkTableInfo GetAmountClassGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| AmountClassGroupLinkTableInfo |
GetAmountClassHeadingLinkTableInfo()
New instance of AmountClassHeadingLinkTableInfo: Heading link table for AmountClass, for MDO headers
Declaration
public static AmountClassHeadingLinkTableInfo GetAmountClassHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| AmountClassHeadingLinkTableInfo |
GetAmountClassTableInfo()
New instance of AmountClassTableInfo: 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 static AmountClassTableInfo GetAmountClassTableInfo()Returns
| Type | Description |
|---|---|
| AmountClassTableInfo |
GetAppointmentTableInfo()
New instance of AppointmentTableInfo: 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 static AppointmentTableInfo GetAppointmentTableInfo()Returns
| Type | Description |
|---|---|
| AppointmentTableInfo |
GetAreaTableInfo()
New instance of AreaTableInfo: Definition of an Area (database subset for satellite and travel)
Declaration
public static AreaTableInfo GetAreaTableInfo()Returns
| Type | Description |
|---|---|
| AreaTableInfo |
GetAreaUserAssignmentTableInfo()
New instance of AreaUserAssignmentTableInfo: Link table indicating which users actually reside in this area.
Declaration
public static AreaUserAssignmentTableInfo GetAreaUserAssignmentTableInfo()Returns
| Type | Description |
|---|---|
| AreaUserAssignmentTableInfo |
GetAreaUserInclusionTableInfo()
New instance of AreaUserInclusionTableInfo: 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 static AreaUserInclusionTableInfo GetAreaUserInclusionTableInfo()Returns
| Type | Description |
|---|---|
| AreaUserInclusionTableInfo |
GetAssociateGroupLinkTableInfo()
New instance of AssociateGroupLinkTableInfo: User group link table for Associate, for MDO item hiding
Declaration
public static AssociateGroupLinkTableInfo GetAssociateGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| AssociateGroupLinkTableInfo |
GetAssociateHeadingLinkTableInfo()
New instance of AssociateHeadingLinkTableInfo: Heading link table for associate for display only. Supportive table, used for grouping and filtering on lists.
Declaration
public static AssociateHeadingLinkTableInfo GetAssociateHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| AssociateHeadingLinkTableInfo |
GetAssociateHistoryTableInfo()
New instance of AssociateHistoryTableInfo: 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 static AssociateHistoryTableInfo GetAssociateHistoryTableInfo()Returns
| Type | Description |
|---|---|
| AssociateHistoryTableInfo |
GetAssociateTableInfo()
New instance of AssociateTableInfo: Employees, resources and other users - except for External persons
Declaration
public static AssociateTableInfo GetAssociateTableInfo()Returns
| Type | Description |
|---|---|
| AssociateTableInfo |
GetAttachmentLocationTableInfo()
New instance of AttachmentLocationTableInfo: A location for storing attachments
Declaration
public static AttachmentLocationTableInfo GetAttachmentLocationTableInfo()Returns
| Type | Description |
|---|---|
| AttachmentLocationTableInfo |
GetAttachmentTableInfo()
New instance of AttachmentTableInfo: 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 static AttachmentTableInfo GetAttachmentTableInfo()Returns
| Type | Description |
|---|---|
| AttachmentTableInfo |
GetAudienceConfigTableInfo()
New instance of AudienceConfigTableInfo: Configuration data for Audience core and webparts
Declaration
public static AudienceConfigTableInfo GetAudienceConfigTableInfo()Returns
| Type | Description |
|---|---|
| AudienceConfigTableInfo |
GetAudienceLayoutLinkTableInfo()
New instance of AudienceLayoutLinkTableInfo: Link between an audience layout and some target grouping table - might be Role or Category
Declaration
public static AudienceLayoutLinkTableInfo GetAudienceLayoutLinkTableInfo()Returns
| Type | Description |
|---|---|
| AudienceLayoutLinkTableInfo |
GetAudienceLayoutTableInfo()
New instance of AudienceLayoutTableInfo: One layout (of webparts and other stuff) for an audience instance
Declaration
public static AudienceLayoutTableInfo GetAudienceLayoutTableInfo()Returns
| Type | Description |
|---|---|
| AudienceLayoutTableInfo |
GetAudienceVisibilityTableInfo()
New instance of AudienceVisibilityTableInfo: How projects (or whatever) should be made visible in audience
Declaration
public static AudienceVisibilityTableInfo GetAudienceVisibilityTableInfo()Returns
| Type | Description |
|---|---|
| AudienceVisibilityTableInfo |
GetAutomatedCategoryUpdateTableInfo()
New instance of AutomatedCategoryUpdateTableInfo: Info on how to autoupdate category when changing sale or leadstatus on person
Declaration
public static AutomatedCategoryUpdateTableInfo GetAutomatedCategoryUpdateTableInfo()Returns
| Type | Description |
|---|---|
| AutomatedCategoryUpdateTableInfo |
GetAutosaveTableInfo()
New instance of AutosaveTableInfo: Autosaved text clobs from ejscript and emarketeer messages
Declaration
public static AutosaveTableInfo GetAutosaveTableInfo()Returns
| Type | Description |
|---|---|
| AutosaveTableInfo |
GetBaseTZLocationTableInfo()
New instance of BaseTZLocationTableInfo: Time zone location for the database (how tz-related datetimes should be stored in the database)
Declaration
public static BaseTZLocationTableInfo GetBaseTZLocationTableInfo()Returns
| Type | Description |
|---|---|
| BaseTZLocationTableInfo |
GetBatchTaskDefinitionTableInfo()
New instance of BatchTaskDefinitionTableInfo: Batch task definitiopns, populated from the SuperOffice.CRM.BatchProcessing.BatchTask attribute
Declaration
public static BatchTaskDefinitionTableInfo GetBatchTaskDefinitionTableInfo()Returns
| Type | Description |
|---|---|
| BatchTaskDefinitionTableInfo |
GetBatchTaskTableInfo()
New instance of BatchTaskTableInfo: Batch task request details, corresponding to the message body of a batch request message
Declaration
public static BatchTaskTableInfo GetBatchTaskTableInfo()Returns
| Type | Description |
|---|---|
| BatchTaskTableInfo |
GetBinaryObjectLinkTableInfo()
New instance of BinaryObjectLinkTableInfo: Link table, connects a BinaryObject with one or more owners
Declaration
public static BinaryObjectLinkTableInfo GetBinaryObjectLinkTableInfo()Returns
| Type | Description |
|---|---|
| BinaryObjectLinkTableInfo |
GetBinaryObjectTableInfo()
New instance of BinaryObjectTableInfo: Binary objects, i.e., blobs. Used for images, documents, SuperOffice inbox mail and other large binary items
Declaration
public static BinaryObjectTableInfo GetBinaryObjectTableInfo()Returns
| Type | Description |
|---|---|
| BinaryObjectTableInfo |
GetBoardViewSettingsTableInfo()
New instance of BoardViewSettingsTableInfo: Settings for selection board view
Declaration
public static BoardViewSettingsTableInfo GetBoardViewSettingsTableInfo()Returns
| Type | Description |
|---|---|
| BoardViewSettingsTableInfo |
GetBusinessGroupLinkTableInfo()
New instance of BusinessGroupLinkTableInfo: User group link table for Business, for MDO item hiding
Declaration
public static BusinessGroupLinkTableInfo GetBusinessGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| BusinessGroupLinkTableInfo |
GetBusinessHeadingLinkTableInfo()
New instance of BusinessHeadingLinkTableInfo: Heading link table for Business, for MDO headers
Declaration
public static BusinessHeadingLinkTableInfo GetBusinessHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| BusinessHeadingLinkTableInfo |
GetBusinessTableInfo()
New instance of BusinessTableInfo: Business list table
Declaration
public static BusinessTableInfo GetBusinessTableInfo()Returns
| Type | Description |
|---|---|
| BusinessTableInfo |
GetCacheInvalidationTableInfo()
New instance of CacheInvalidationTableInfo: Names and generation numbers for distributed invalidation of caches
Declaration
public static CacheInvalidationTableInfo GetCacheInvalidationTableInfo()Returns
| Type | Description |
|---|---|
| CacheInvalidationTableInfo |
GetCacheTablesTableInfo()
New instance of CacheTablesTableInfo: 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 static CacheTablesTableInfo GetCacheTablesTableInfo()Returns
| Type | Description |
|---|---|
| CacheTablesTableInfo |
GetCategoryFamilyTableInfo()
New instance of CategoryFamilyTableInfo: Grouping table so that multiple company categories can be grouped under one term; to simplify searching for things like 'all customers'
Declaration
public static CategoryFamilyTableInfo GetCategoryFamilyTableInfo()Returns
| Type | Description |
|---|---|
| CategoryFamilyTableInfo |
GetCategoryGroupLinkTableInfo()
New instance of CategoryGroupLinkTableInfo: User group link table for Category, for MDO item hiding
Declaration
public static CategoryGroupLinkTableInfo GetCategoryGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| CategoryGroupLinkTableInfo |
GetCategoryHeadingLinkTableInfo()
New instance of CategoryHeadingLinkTableInfo: Heading link table for Category, for MDO headers
Declaration
public static CategoryHeadingLinkTableInfo GetCategoryHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| CategoryHeadingLinkTableInfo |
GetCategoryMembershipTableInfo()
New instance of CategoryMembershipTableInfo: This table connects users to categories (many-to-many).
Declaration
public static CategoryMembershipTableInfo GetCategoryMembershipTableInfo()Returns
| Type | Description |
|---|---|
| CategoryMembershipTableInfo |
GetCategoryTableInfo()
New instance of CategoryTableInfo: Category list table
Declaration
public static CategoryTableInfo GetCategoryTableInfo()Returns
| Type | Description |
|---|---|
| CategoryTableInfo |
GetCcTemplateTableInfo()
New instance of CcTemplateTableInfo: This table contains templates for the customer center
Declaration
public static CcTemplateTableInfo GetCcTemplateTableInfo()Returns
| Type | Description |
|---|---|
| CcTemplateTableInfo |
GetChatMessageTableInfo()
New instance of ChatMessageTableInfo: This table contains messages in a chat session.
Declaration
public static ChatMessageTableInfo GetChatMessageTableInfo()Returns
| Type | Description |
|---|---|
| ChatMessageTableInfo |
GetChatSessionTableInfo()
New instance of ChatSessionTableInfo: This table contains chat sessions.
Declaration
public static ChatSessionTableInfo GetChatSessionTableInfo()Returns
| Type | Description |
|---|---|
| ChatSessionTableInfo |
GetChatTopicTableInfo()
New instance of ChatTopicTableInfo: This table contains chat topics.
Declaration
public static ChatTopicTableInfo GetChatTopicTableInfo()Returns
| Type | Description |
|---|---|
| ChatTopicTableInfo |
GetChatTopicUserTableInfo()
New instance of ChatTopicUserTableInfo: This table connected the chat topics with the users (i.e. the membership).
Declaration
public static ChatTopicUserTableInfo GetChatTopicUserTableInfo()Returns
| Type | Description |
|---|---|
| ChatTopicUserTableInfo |
GetCompanyDomainTableInfo()
New instance of CompanyDomainTableInfo: This table contains web-domains associated with a certain cust_company entry.
Declaration
public static CompanyDomainTableInfo GetCompanyDomainTableInfo()Returns
| Type | Description |
|---|---|
| CompanyDomainTableInfo |
GetCompanyTableInfo()
New instance of CompanyTableInfo: 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 static CompanyTableInfo GetCompanyTableInfo()Returns
| Type | Description |
|---|---|
| CompanyTableInfo |
GetComptrGroupLinkTableInfo()
New instance of ComptrGroupLinkTableInfo: User group link table for Comptr, for MDO item hiding
Declaration
public static ComptrGroupLinkTableInfo GetComptrGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| ComptrGroupLinkTableInfo |
GetComptrHeadingLinkTableInfo()
New instance of ComptrHeadingLinkTableInfo: Heading link table for Comptr, for MDO headers
Declaration
public static ComptrHeadingLinkTableInfo GetComptrHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| ComptrHeadingLinkTableInfo |
GetComptrTableInfo()
New instance of ComptrTableInfo: Comptr list table. List of all possible competitors (sale).
Declaration
public static ComptrTableInfo GetComptrTableInfo()Returns
| Type | Description |
|---|---|
| ComptrTableInfo |
GetConfigTableInfo()
New instance of ConfigTableInfo: This table contains certain system-wide configuration values.
Declaration
public static ConfigTableInfo GetConfigTableInfo()Returns
| Type | Description |
|---|---|
| ConfigTableInfo |
GetConfigurableScreenAppliesToTableInfo()
New instance of ConfigurableScreenAppliesToTableInfo: Mapping between recipes in scil and chosen type of data (appliesToKey) to differ layouts on
Declaration
public static ConfigurableScreenAppliesToTableInfo GetConfigurableScreenAppliesToTableInfo()Returns
| Type | Description |
|---|---|
| ConfigurableScreenAppliesToTableInfo |
GetConfigurableScreenDeltaTableInfo()
New instance of ConfigurableScreenDeltaTableInfo: Parts of recipes in SCIL to insert or remove in given recipes
Declaration
public static ConfigurableScreenDeltaTableInfo GetConfigurableScreenDeltaTableInfo()Returns
| Type | Description |
|---|---|
| ConfigurableScreenDeltaTableInfo |
GetConnectionConfigFieldTableInfo()
New instance of ConnectionConfigFieldTableInfo: Configuration data for Erp and Quote Connections
Declaration
public static ConnectionConfigFieldTableInfo GetConnectionConfigFieldTableInfo()Returns
| Type | Description |
|---|---|
| ConnectionConfigFieldTableInfo |
GetConsentPersonTableInfo()
New instance of ConsentPersonTableInfo: Link table that defines who has which consents
Declaration
public static ConsentPersonTableInfo GetConsentPersonTableInfo()Returns
| Type | Description |
|---|---|
| ConsentPersonTableInfo |
GetConsentPurposeTableInfo()
New instance of ConsentPurposeTableInfo: GDPR purpose alternatives
Declaration
public static ConsentPurposeTableInfo GetConsentPurposeTableInfo()Returns
| Type | Description |
|---|---|
| ConsentPurposeTableInfo |
GetConsentSourceTableInfo()
New instance of ConsentSourceTableInfo: Consent source for GDPR
Declaration
public static ConsentSourceTableInfo GetConsentSourceTableInfo()Returns
| Type | Description |
|---|---|
| ConsentSourceTableInfo |
GetContIntGroupLinkTableInfo()
New instance of ContIntGroupLinkTableInfo: User group link table for ContInt, for MDO item hiding
Declaration
public static ContIntGroupLinkTableInfo GetContIntGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| ContIntGroupLinkTableInfo |
GetContIntHeadingLinkTableInfo()
New instance of ContIntHeadingLinkTableInfo: Heading link table for ContInt, for MDO headers
Declaration
public static ContIntHeadingLinkTableInfo GetContIntHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| ContIntHeadingLinkTableInfo |
GetContIntTableInfo()
New instance of ContIntTableInfo: ContInt list table. List-text of all valid contact interest types.
Declaration
public static ContIntTableInfo GetContIntTableInfo()Returns
| Type | Description |
|---|---|
| ContIntTableInfo |
GetContactInterestTableInfo()
New instance of ContactInterestTableInfo: Link-table between contact and interests in ContInt
Declaration
public static ContactInterestTableInfo GetContactInterestTableInfo()Returns
| Type | Description |
|---|---|
| ContactInterestTableInfo |
GetContactTableInfo()
New instance of ContactTableInfo: Companies and Organizations.
Declaration
public static ContactTableInfo GetContactTableInfo()Returns
| Type | Description |
|---|---|
| ContactTableInfo |
GetCopilotDataSourceSettingTableInfo()
New instance of CopilotDataSourceSettingTableInfo: Stores specific configuration values for each data source
Declaration
public static CopilotDataSourceSettingTableInfo GetCopilotDataSourceSettingTableInfo()Returns
| Type | Description |
|---|---|
| CopilotDataSourceSettingTableInfo |
GetCopilotDataSourceTableInfo()
New instance of CopilotDataSourceTableInfo: Stores data sources for each copilot
Declaration
public static CopilotDataSourceTableInfo GetCopilotDataSourceTableInfo()Returns
| Type | Description |
|---|---|
| CopilotDataSourceTableInfo |
GetCopilotTableInfo()
New instance of CopilotTableInfo: Contains all available copilots
Declaration
public static CopilotTableInfo GetCopilotTableInfo()Returns
| Type | Description |
|---|---|
| CopilotTableInfo |
GetCounterValueTableInfo()
New instance of CounterValueTableInfo: Visible for rights
Declaration
public static CounterValueTableInfo GetCounterValueTableInfo()Returns
| Type | Description |
|---|---|
| CounterValueTableInfo |
GetCountryGroupLinkTableInfo()
New instance of CountryGroupLinkTableInfo: User group link table for Country, for MDO item hiding
Declaration
public static CountryGroupLinkTableInfo GetCountryGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| CountryGroupLinkTableInfo |
GetCountryHeadingLinkTableInfo()
New instance of CountryHeadingLinkTableInfo: Heading link table for Country, for MDO headers
Declaration
public static CountryHeadingLinkTableInfo GetCountryHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| CountryHeadingLinkTableInfo |
GetCountryTableInfo()
New instance of CountryTableInfo: Country information
Declaration
public static CountryTableInfo GetCountryTableInfo()Returns
| Type | Description |
|---|---|
| CountryTableInfo |
GetCredentialsTableInfo()
New instance of CredentialsTableInfo: Alternative credentials
Declaration
public static CredentialsTableInfo GetCredentialsTableInfo()Returns
| Type | Description |
|---|---|
| CredentialsTableInfo |
GetCreditedGroupLinkTableInfo()
New instance of CreditedGroupLinkTableInfo: User group link table for Credited, for MDO item hiding
Declaration
public static CreditedGroupLinkTableInfo GetCreditedGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| CreditedGroupLinkTableInfo |
GetCreditedHeadingLinkTableInfo()
New instance of CreditedHeadingLinkTableInfo: Heading link table for Credited, for MDO headers
Declaration
public static CreditedHeadingLinkTableInfo GetCreditedHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| CreditedHeadingLinkTableInfo |
GetCreditedTableInfo()
New instance of CreditedTableInfo: Credited list table. List of who is to be credited for the sale.
Declaration
public static CreditedTableInfo GetCreditedTableInfo()Returns
| Type | Description |
|---|---|
| CreditedTableInfo |
GetCurrencyGroupLinkTableInfo()
New instance of CurrencyGroupLinkTableInfo: User group link table for Currency, for MDO item hiding
Declaration
public static CurrencyGroupLinkTableInfo GetCurrencyGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| CurrencyGroupLinkTableInfo |
GetCurrencyHeadingLinkTableInfo()
New instance of CurrencyHeadingLinkTableInfo: Heading link table for Currency, for MDO headers
Declaration
public static CurrencyHeadingLinkTableInfo GetCurrencyHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| CurrencyHeadingLinkTableInfo |
GetCurrencyTableInfo()
New instance of CurrencyTableInfo: Currency list table
Declaration
public static CurrencyTableInfo GetCurrencyTableInfo()Returns
| Type | Description |
|---|---|
| CurrencyTableInfo |
GetCustCategoryTableInfo()
New instance of CustCategoryTableInfo: This table contains entries for categories exposed through a customer language.
Declaration
public static CustCategoryTableInfo GetCustCategoryTableInfo()Returns
| Type | Description |
|---|---|
| CustCategoryTableInfo |
GetCustConfigTableInfo()
New instance of CustConfigTableInfo: This table contains JSON structures used for customizing the customer center
Declaration
public static CustConfigTableInfo GetCustConfigTableInfo()Returns
| Type | Description |
|---|---|
| CustConfigTableInfo |
GetCustLangTableInfo()
New instance of CustLangTableInfo: This table contains entries for customer languages.
Declaration
public static CustLangTableInfo GetCustLangTableInfo()Returns
| Type | Description |
|---|---|
| CustLangTableInfo |
GetDashboardTableInfo()
New instance of DashboardTableInfo: Describes a dashboard
Declaration
public static DashboardTableInfo GetDashboardTableInfo()Returns
| Type | Description |
|---|---|
| DashboardTableInfo |
GetDashboardThemeTableInfo()
New instance of DashboardThemeTableInfo: A set of style rules for the Dashboard
Declaration
public static DashboardThemeTableInfo GetDashboardThemeTableInfo()Returns
| Type | Description |
|---|---|
| DashboardThemeTableInfo |
GetDashboardTileDefinitionTableInfo()
New instance of DashboardTileDefinitionTableInfo: Describes the contents of a tile
Declaration
public static DashboardTileDefinitionTableInfo GetDashboardTileDefinitionTableInfo()Returns
| Type | Description |
|---|---|
| DashboardTileDefinitionTableInfo |
GetDashboardTileFieldTableInfo()
New instance of DashboardTileFieldTableInfo: Describes the contents of a tile field
Declaration
public static DashboardTileFieldTableInfo GetDashboardTileFieldTableInfo()Returns
| Type | Description |
|---|---|
| DashboardTileFieldTableInfo |
GetDashboardTileTableInfo()
New instance of DashboardTileTableInfo: Represents one tile in the dashboard
Declaration
public static DashboardTileTableInfo GetDashboardTileTableInfo()Returns
| Type | Description |
|---|---|
| DashboardTileTableInfo |
GetDataRightTableInfo()
New instance of DataRightTableInfo: Data right definition
Declaration
public static DataRightTableInfo GetDataRightTableInfo()Returns
| Type | Description |
|---|---|
| DataRightTableInfo |
GetDatabaseModelTableInfo()
New instance of DatabaseModelTableInfo: New DatabaseModel used by Continuous Database
Declaration
public static DatabaseModelTableInfo GetDatabaseModelTableInfo()Returns
| Type | Description |
|---|---|
| DatabaseModelTableInfo |
GetDbiAgentFieldTableInfo()
New instance of DbiAgentFieldTableInfo: DBI agent fields
Declaration
public static DbiAgentFieldTableInfo GetDbiAgentFieldTableInfo()Returns
| Type | Description |
|---|---|
| DbiAgentFieldTableInfo |
GetDbiAgentScheduleTableInfo()
New instance of DbiAgentScheduleTableInfo: DBI agent schedule settings
Declaration
public static DbiAgentScheduleTableInfo GetDbiAgentScheduleTableInfo()Returns
| Type | Description |
|---|---|
| DbiAgentScheduleTableInfo |
GetDbiAgentTableInfo()
New instance of DbiAgentTableInfo: DBI agent settings
Declaration
public static DbiAgentTableInfo GetDbiAgentTableInfo()Returns
| Type | Description |
|---|---|
| DbiAgentTableInfo |
GetDeliveryTermsGroupLinkTableInfo()
New instance of DeliveryTermsGroupLinkTableInfo: User group link table for DeliveryTerms, for MDO item hiding
Declaration
public static DeliveryTermsGroupLinkTableInfo GetDeliveryTermsGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| DeliveryTermsGroupLinkTableInfo |
GetDeliveryTermsHeadingLinkTableInfo()
New instance of DeliveryTermsHeadingLinkTableInfo: Heading link table for DeliveryTerms, for MDO item headings
Declaration
public static DeliveryTermsHeadingLinkTableInfo GetDeliveryTermsHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| DeliveryTermsHeadingLinkTableInfo |
GetDeliveryTermsTableInfo()
New instance of DeliveryTermsTableInfo: The list of Delivery terms, in the internal product register
Declaration
public static DeliveryTermsTableInfo GetDeliveryTermsTableInfo()Returns
| Type | Description |
|---|---|
| DeliveryTermsTableInfo |
GetDeliveryTypeGroupLinkTableInfo()
New instance of DeliveryTypeGroupLinkTableInfo: User group link table for DeliveryType, for MDO item hiding
Declaration
public static DeliveryTypeGroupLinkTableInfo GetDeliveryTypeGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| DeliveryTypeGroupLinkTableInfo |
GetDeliveryTypeHeadingLinkTableInfo()
New instance of DeliveryTypeHeadingLinkTableInfo: Heading link table for DeliveryType, for MDO item headings
Declaration
public static DeliveryTypeHeadingLinkTableInfo GetDeliveryTypeHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| DeliveryTypeHeadingLinkTableInfo |
GetDeliveryTypeTableInfo()
New instance of DeliveryTypeTableInfo: The list of Delivery types, in the internal product register
Declaration
public static DeliveryTypeTableInfo GetDeliveryTypeTableInfo()Returns
| Type | Description |
|---|---|
| DeliveryTypeTableInfo |
GetDiaryViewRowTableInfo()
New instance of DiaryViewRowTableInfo: Configuration of a multi-user diary view
Declaration
public static DiaryViewRowTableInfo GetDiaryViewRowTableInfo()Returns
| Type | Description |
|---|---|
| DiaryViewRowTableInfo |
GetDiaryViewTableInfo()
New instance of DiaryViewTableInfo: Configuration of a multi-user diary view
Declaration
public static DiaryViewTableInfo GetDiaryViewTableInfo()Returns
| Type | Description |
|---|---|
| DiaryViewTableInfo |
GetDictionaryBaseTableInfo()
New instance of DictionaryBaseTableInfo: Language catalog for the ejournal dictionaries (automatic proof reading of message text etc)
Declaration
public static DictionaryBaseTableInfo GetDictionaryBaseTableInfo()Returns
| Type | Description |
|---|---|
| DictionaryBaseTableInfo |
GetDictionaryTableInfo()
New instance of DictionaryTableInfo: User added dictionary words
Declaration
public static DictionaryTableInfo GetDictionaryTableInfo()Returns
| Type | Description |
|---|---|
| DictionaryTableInfo |
GetDocDocumentTableInfo()
New instance of DocDocumentTableInfo: This table contains documents.
Declaration
public static DocDocumentTableInfo GetDocDocumentTableInfo()Returns
| Type | Description |
|---|---|
| DocDocumentTableInfo |
GetDocFolderTableInfo()
New instance of DocFolderTableInfo: A document folder.
Declaration
public static DocFolderTableInfo GetDocFolderTableInfo()Returns
| Type | Description |
|---|---|
| DocFolderTableInfo |
GetDocTmplGroupLinkTableInfo()
New instance of DocTmplGroupLinkTableInfo: User group link table for DocTmpl, for MDO item hiding
Declaration
public static DocTmplGroupLinkTableInfo GetDocTmplGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| DocTmplGroupLinkTableInfo |
GetDocTmplHeadingLinkTableInfo()
New instance of DocTmplHeadingLinkTableInfo: Heading link table for DocTmpl, for MDO headers
Declaration
public static DocTmplHeadingLinkTableInfo GetDocTmplHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| DocTmplHeadingLinkTableInfo |
GetDocTmplTableInfo()
New instance of DocTmplTableInfo: DocTmpl list table. Describes templates available for writing new documents.
Declaration
public static DocTmplTableInfo GetDocTmplTableInfo()Returns
| Type | Description |
|---|---|
| DocTmplTableInfo |
GetDocumentTableInfo()
New instance of DocumentTableInfo: 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 static DocumentTableInfo GetDocumentTableInfo()Returns
| Type | Description |
|---|---|
| DocumentTableInfo |
GetEabEntryTableInfo()
New instance of EabEntryTableInfo: This table contains eab (email address book) entries, i.e. an alias ('Ola Hansen') and an address ('ola@hansen.as').
Declaration
public static EabEntryTableInfo GetEabEntryTableInfo()Returns
| Type | Description |
|---|---|
| EabEntryTableInfo |
GetEabFolderTableInfo()
New instance of EabFolderTableInfo: This table contains eab (email address book) folders, used for containing email addresses.
Declaration
public static EabFolderTableInfo GetEabFolderTableInfo()Returns
| Type | Description |
|---|---|
| EabFolderTableInfo |
GetEjCategoryGroupLinkTableInfo()
New instance of EjCategoryGroupLinkTableInfo: User group link table for EjCategory, for mass handling ej_category members
Declaration
public static EjCategoryGroupLinkTableInfo GetEjCategoryGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| EjCategoryGroupLinkTableInfo |
GetEjCategoryTableInfo()
New instance of EjCategoryTableInfo: This table contains categories, in which tickets are categorized. The categories are organized in a hierarchial manner.
Declaration
public static EjCategoryTableInfo GetEjCategoryTableInfo()Returns
| Type | Description |
|---|---|
| EjCategoryTableInfo |
GetEjMessageTableInfo()
New instance of EjMessageTableInfo: This table contains the messages listed under tickets.
Declaration
public static EjMessageTableInfo GetEjMessageTableInfo()Returns
| Type | Description |
|---|---|
| EjMessageTableInfo |
GetEjRoleTableInfo()
New instance of EjRoleTableInfo: Define access rights, memberships and other properties for role user members
Declaration
public static EjRoleTableInfo GetEjRoleTableInfo()Returns
| Type | Description |
|---|---|
| EjRoleTableInfo |
GetEjpackageItemTableInfo()
New instance of EjpackageItemTableInfo: This table stores info on installed packages in the system
Declaration
public static EjpackageItemTableInfo GetEjpackageItemTableInfo()Returns
| Type | Description |
|---|---|
| EjpackageItemTableInfo |
GetEjpackageTableInfo()
New instance of EjpackageTableInfo: This table stores packages on the system.
Declaration
public static EjpackageTableInfo GetEjpackageTableInfo()Returns
| Type | Description |
|---|---|
| EjpackageTableInfo |
GetEjscriptDebugTableInfo()
New instance of EjscriptDebugTableInfo: This table contains information when debugging an ejscript
Declaration
public static EjscriptDebugTableInfo GetEjscriptDebugTableInfo()Returns
| Type | Description |
|---|---|
| EjscriptDebugTableInfo |
GetEjscriptTableInfo()
New instance of EjscriptTableInfo: ejscript
Declaration
public static EjscriptTableInfo GetEjscriptTableInfo()Returns
| Type | Description |
|---|---|
| EjscriptTableInfo |
GetEjselEjselTableInfo()
New instance of EjselEjselTableInfo: This table defines sources for complex selections in a many/many relationship
Declaration
public static EjselEjselTableInfo GetEjselEjselTableInfo()Returns
| Type | Description |
|---|---|
| EjselEjselTableInfo |
GetEjselMetaResultTableInfo()
New instance of EjselMetaResultTableInfo: This table stores result meta data
Declaration
public static EjselMetaResultTableInfo GetEjselMetaResultTableInfo()Returns
| Type | Description |
|---|---|
| EjselMetaResultTableInfo |
GetEjselResultSetTableInfo()
New instance of EjselResultSetTableInfo: This table stores result set reference data, result sets for selections
Declaration
public static EjselResultSetTableInfo GetEjselResultSetTableInfo()Returns
| Type | Description |
|---|---|
| EjselResultSetTableInfo |
GetEjselSourceIdlistTableInfo()
New instance of EjselSourceIdlistTableInfo: This table stores id list source for selections
Declaration
public static EjselSourceIdlistTableInfo GetEjselSourceIdlistTableInfo()Returns
| Type | Description |
|---|---|
| EjselSourceIdlistTableInfo |
GetEjselSourceScriptTableInfo()
New instance of EjselSourceScriptTableInfo: This table stores a selection script source
Declaration
public static EjselSourceScriptTableInfo GetEjselSourceScriptTableInfo()Returns
| Type | Description |
|---|---|
| EjselSourceScriptTableInfo |
GetEjselSourceXmlTableInfo()
New instance of EjselSourceXmlTableInfo: This table stores a selection source as xml
Declaration
public static EjselSourceXmlTableInfo GetEjselSourceXmlTableInfo()Returns
| Type | Description |
|---|---|
| EjselSourceXmlTableInfo |
GetEjselectionTableInfo()
New instance of EjselectionTableInfo: This table stores selections, dynamic groups.
Declaration
public static EjselectionTableInfo GetEjselectionTableInfo()Returns
| Type | Description |
|---|---|
| EjselectionTableInfo |
GetEjuserTableInfo()
New instance of EjuserTableInfo: This table contains entries for the users of the system.
Declaration
public static EjuserTableInfo GetEjuserTableInfo()Returns
| Type | Description |
|---|---|
| EjuserTableInfo |
GetElementProfileTableInfo()
New instance of ElementProfileTableInfo: The new (4.0) profile table. Contains profile for a single Html-element. Connected through element_profile_link
Declaration
public static ElementProfileTableInfo GetElementProfileTableInfo()Returns
| Type | Description |
|---|---|
| ElementProfileTableInfo |
GetEmailAccountTableInfo()
New instance of EmailAccountTableInfo: Email account information
Declaration
public static EmailAccountTableInfo GetEmailAccountTableInfo()Returns
| Type | Description |
|---|---|
| EmailAccountTableInfo |
GetEmailAttachmentTableInfo()
New instance of EmailAttachmentTableInfo: Attachment info related to an email_item
Declaration
public static EmailAttachmentTableInfo GetEmailAttachmentTableInfo()Returns
| Type | Description |
|---|---|
| EmailAttachmentTableInfo |
GetEmailFlowContentLinkTableInfo()
New instance of EmailFlowContentLinkTableInfo: Links content to an email workflow
Declaration
public static EmailFlowContentLinkTableInfo GetEmailFlowContentLinkTableInfo()Returns
| Type | Description |
|---|---|
| EmailFlowContentLinkTableInfo |
GetEmailFlowTableInfo()
New instance of EmailFlowTableInfo: A set of properties related to the email workflow.
Declaration
public static EmailFlowTableInfo GetEmailFlowTableInfo()Returns
| Type | Description |
|---|---|
| EmailFlowTableInfo |
GetEmailFolderTableInfo()
New instance of EmailFolderTableInfo: Corresponds to an email folder on a mail server
Declaration
public static EmailFolderTableInfo GetEmailFolderTableInfo()Returns
| Type | Description |
|---|---|
| EmailFolderTableInfo |
GetEmailItemTableInfo()
New instance of EmailItemTableInfo: Email data
Declaration
public static EmailItemTableInfo GetEmailItemTableInfo()Returns
| Type | Description |
|---|---|
| EmailItemTableInfo |
GetEmailTableInfo()
New instance of EmailTableInfo: Email addresses for contacts, projects and persons
Declaration
public static EmailTableInfo GetEmailTableInfo()Returns
| Type | Description |
|---|---|
| EmailTableInfo |
GetEntityCountsTableInfo()
New instance of EntityCountsTableInfo: Number of different entities an associate has created for usage statistics
Declaration
public static EntityCountsTableInfo GetEntityCountsTableInfo()Returns
| Type | Description |
|---|---|
| EntityCountsTableInfo |
GetErpConfigurationTableInfo()
New instance of ErpConfigurationTableInfo: Global settings for the Erp Integration Server
Declaration
public static ErpConfigurationTableInfo GetErpConfigurationTableInfo()Returns
| Type | Description |
|---|---|
| ErpConfigurationTableInfo |
GetErpConnectionAccessTableInfo()
New instance of ErpConnectionAccessTableInfo: Access control for Erp Connections
Declaration
public static ErpConnectionAccessTableInfo GetErpConnectionAccessTableInfo()Returns
| Type | Description |
|---|---|
| ErpConnectionAccessTableInfo |
GetErpConnectionActorTypeTableInfo()
New instance of ErpConnectionActorTypeTableInfo: Data about the configuration of one Erp Actor on one ErpConnection
Declaration
public static ErpConnectionActorTypeTableInfo GetErpConnectionActorTypeTableInfo()Returns
| Type | Description |
|---|---|
| ErpConnectionActorTypeTableInfo |
GetErpConnectionTableInfo()
New instance of ErpConnectionTableInfo: One connection to an ERP connector, specifying Client and other required information
Declaration
public static ErpConnectionTableInfo GetErpConnectionTableInfo()Returns
| Type | Description |
|---|---|
| ErpConnectionTableInfo |
GetErpConnectorTableInfo()
New instance of ErpConnectorTableInfo: One ERP Connector, known by its URL
Declaration
public static ErpConnectorTableInfo GetErpConnectorTableInfo()Returns
| Type | Description |
|---|---|
| ErpConnectorTableInfo |
GetErpExternalKeyTableInfo()
New instance of ErpExternalKeyTableInfo: The external (ERP-facing) key related to a synchronized record / connection
Declaration
public static ErpExternalKeyTableInfo GetErpExternalKeyTableInfo()Returns
| Type | Description |
|---|---|
| ErpExternalKeyTableInfo |
GetErpFieldTableInfo()
New instance of ErpFieldTableInfo: Store the metadata describing the fields that belong to an actor/connection combination, as described by the Erp Connector
Declaration
public static ErpFieldTableInfo GetErpFieldTableInfo()Returns
| Type | Description |
|---|---|
| ErpFieldTableInfo |
GetErpInternalKeyTableInfo()
New instance of ErpInternalKeyTableInfo: The internal (superoffice-facing) key related to a synchronized record
Declaration
public static ErpInternalKeyTableInfo GetErpInternalKeyTableInfo()Returns
| Type | Description |
|---|---|
| ErpInternalKeyTableInfo |
GetErpListItemMappingTableInfo()
New instance of ErpListItemMappingTableInfo: Defines a mapping of ERP to CRM fields, per connection and actor type
Declaration
public static ErpListItemMappingTableInfo GetErpListItemMappingTableInfo()Returns
| Type | Description |
|---|---|
| ErpListItemMappingTableInfo |
GetErpSyncLogTableInfo()
New instance of ErpSyncLogTableInfo: Record all field changes done by the Erp Sync
Declaration
public static ErpSyncLogTableInfo GetErpSyncLogTableInfo()Returns
| Type | Description |
|---|---|
| ErpSyncLogTableInfo |
GetExtAppGroupLinkTableInfo()
New instance of ExtAppGroupLinkTableInfo: User group link table for ExtApp, for MDO item hiding
Declaration
public static ExtAppGroupLinkTableInfo GetExtAppGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| ExtAppGroupLinkTableInfo |
GetExtAppHeadingLinkTableInfo()
New instance of ExtAppHeadingLinkTableInfo: Heading link table for ExtApp, for MDO headers
Declaration
public static ExtAppHeadingLinkTableInfo GetExtAppHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| ExtAppHeadingLinkTableInfo |
GetExtAppTableInfo()
New instance of ExtAppTableInfo: ExtApp list table. Applications startable from SuperOffice
Declaration
public static ExtAppTableInfo GetExtAppTableInfo()Returns
| Type | Description |
|---|---|
| ExtAppTableInfo |
GetExtDatasourceTableInfo()
New instance of ExtDatasourceTableInfo: This table contains external datasources, used for databaseintegration of customers and companies.
Declaration
public static ExtDatasourceTableInfo GetExtDatasourceTableInfo()Returns
| Type | Description |
|---|---|
| ExtDatasourceTableInfo |
GetExtFieldTableInfo()
New instance of ExtFieldTableInfo: This table contains entries mapping an external field to an internal field. Used for database integration.
Declaration
public static ExtFieldTableInfo GetExtFieldTableInfo()Returns
| Type | Description |
|---|---|
| ExtFieldTableInfo |
GetExtTableTableInfo()
New instance of ExtTableTableInfo: This table contains entries used for mapping an external table to an internal table (customer or cust_company) for database integration.
Declaration
public static ExtTableTableInfo GetExtTableTableInfo()Returns
| Type | Description |
|---|---|
| ExtTableTableInfo |
GetExternalDocumentTableInfo()
New instance of ExternalDocumentTableInfo: This table stores documents which can be viewed externaly, through the customer module
Declaration
public static ExternalDocumentTableInfo GetExternalDocumentTableInfo()Returns
| Type | Description |
|---|---|
| ExternalDocumentTableInfo |
GetExternalEventTableInfo()
New instance of ExternalEventTableInfo: The definition of projects as events in Audience (or other Collaborative apps)
Declaration
public static ExternalEventTableInfo GetExternalEventTableInfo()Returns
| Type | Description |
|---|---|
| ExternalEventTableInfo |
GetExternalOwnerTableInfo()
New instance of ExternalOwnerTableInfo: Owner of external data imported into the system
Declaration
public static ExternalOwnerTableInfo GetExternalOwnerTableInfo()Returns
| Type | Description |
|---|---|
| ExternalOwnerTableInfo |
GetExtraFieldsTableInfo()
New instance of ExtraFieldsTableInfo: This table contains entries for the extra fields in the system.
Declaration
public static ExtraFieldsTableInfo GetExtraFieldsTableInfo()Returns
| Type | Description |
|---|---|
| ExtraFieldsTableInfo |
GetExtraMenusTableInfo()
New instance of ExtraMenusTableInfo: This table contains entries for the extra menus in the system.
Declaration
public static ExtraMenusTableInfo GetExtraMenusTableInfo()Returns
| Type | Description |
|---|---|
| ExtraMenusTableInfo |
GetExtraTablesEntryTableInfo()
New instance of ExtraTablesEntryTableInfo: Hits/entries in result set of executed search in ejournal extra tables
Declaration
public static ExtraTablesEntryTableInfo GetExtraTablesEntryTableInfo()Returns
| Type | Description |
|---|---|
| ExtraTablesEntryTableInfo |
GetExtraTablesResultTableInfo()
New instance of ExtraTablesResultTableInfo: Result set of executed search in ejournal extra tables
Declaration
public static ExtraTablesResultTableInfo GetExtraTablesResultTableInfo()Returns
| Type | Description |
|---|---|
| ExtraTablesResultTableInfo |
GetExtraTablesTableInfo()
New instance of ExtraTablesTableInfo: This table contains entries for the extra tables in the system.
Declaration
public static ExtraTablesTableInfo GetExtraTablesTableInfo()Returns
| Type | Description |
|---|---|
| ExtraTablesTableInfo |
GetFavouriteTableInfo()
New instance of FavouriteTableInfo: Favourite records (star-marking)
Declaration
public static FavouriteTableInfo GetFavouriteTableInfo()Returns
| Type | Description |
|---|---|
| FavouriteTableInfo |
GetFieldLabelTableInfo()
New instance of FieldLabelTableInfo: 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 static FieldLabelTableInfo GetFieldLabelTableInfo()Returns
| Type | Description |
|---|---|
| FieldLabelTableInfo |
GetForeignAppTableInfo()
New instance of ForeignAppTableInfo: Top level of Foreign Key system
Declaration
public static ForeignAppTableInfo GetForeignAppTableInfo()Returns
| Type | Description |
|---|---|
| ForeignAppTableInfo |
GetForeignDeviceTableInfo()
New instance of ForeignDeviceTableInfo: Middle level of Foreign Key system
Declaration
public static ForeignDeviceTableInfo GetForeignDeviceTableInfo()Returns
| Type | Description |
|---|---|
| ForeignDeviceTableInfo |
GetForeignKeyTableInfo()
New instance of ForeignKeyTableInfo: 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 static ForeignKeyTableInfo GetForeignKeyTableInfo()Returns
| Type | Description |
|---|---|
| ForeignKeyTableInfo |
GetFormFieldValueTableInfo()
New instance of FormFieldValueTableInfo: Form field values saved in a searchable format
Declaration
public static FormFieldValueTableInfo GetFormFieldValueTableInfo()Returns
| Type | Description |
|---|---|
| FormFieldValueTableInfo |
GetFormKeysTableInfo()
New instance of FormKeysTableInfo: Keys that makes sure a form is not posted twice
Declaration
public static FormKeysTableInfo GetFormKeysTableInfo()Returns
| Type | Description |
|---|---|
| FormKeysTableInfo |
GetFormSubmissionTableInfo()
New instance of FormSubmissionTableInfo: A form submission
Declaration
public static FormSubmissionTableInfo GetFormSubmissionTableInfo()Returns
| Type | Description |
|---|---|
| FormSubmissionTableInfo |
GetFormTableInfo()
New instance of FormTableInfo: A form which can be published on a webpage and submitted by visitors
Declaration
public static FormTableInfo GetFormTableInfo()Returns
| Type | Description |
|---|---|
| FormTableInfo |
GetFreeTextIndexTableInfo()
New instance of FreeTextIndexTableInfo: 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 static FreeTextIndexTableInfo GetFreeTextIndexTableInfo()Returns
| Type | Description |
|---|---|
| FreeTextIndexTableInfo |
GetFreeTextStopWordsTableInfo()
New instance of FreeTextStopWordsTableInfo: 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 static FreeTextStopWordsTableInfo GetFreeTextStopWordsTableInfo()Returns
| Type | Description |
|---|---|
| FreeTextStopWordsTableInfo |
GetFreeTextWordsTableInfo()
New instance of FreeTextWordsTableInfo: 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 static FreeTextWordsTableInfo GetFreeTextWordsTableInfo()Returns
| Type | Description |
|---|---|
| FreeTextWordsTableInfo |
GetFunctionRightRoleLinkTableInfo()
New instance of FunctionRightRoleLinkTableInfo: Functional right definition
Declaration
public static FunctionRightRoleLinkTableInfo GetFunctionRightRoleLinkTableInfo()Returns
| Type | Description |
|---|---|
| FunctionRightRoleLinkTableInfo |
GetFunctionRightTableInfo()
New instance of FunctionRightTableInfo: Functional right definition
Declaration
public static FunctionRightTableInfo GetFunctionRightTableInfo()Returns
| Type | Description |
|---|---|
| FunctionRightTableInfo |
GetHeadingTableInfo()
New instance of HeadingTableInfo: Heading items for all MDO lists, lists that are grouped and filtered.
Declaration
public static HeadingTableInfo GetHeadingTableInfo()Returns
| Type | Description |
|---|---|
| HeadingTableInfo |
GetHelpTableInfo()
New instance of HelpTableInfo: This table contains the help pages.
Declaration
public static HelpTableInfo GetHelpTableInfo()Returns
| Type | Description |
|---|---|
| HelpTableInfo |
GetHierarchyTableInfo()
New instance of HierarchyTableInfo: This table contains folders used to group the extra tables in the system.
Declaration
public static HierarchyTableInfo GetHierarchyTableInfo()Returns
| Type | Description |
|---|---|
| HierarchyTableInfo |
GetHistoryTableInfo()
New instance of HistoryTableInfo: 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 static HistoryTableInfo GetHistoryTableInfo()Returns
| Type | Description |
|---|---|
| HistoryTableInfo |
GetHotlistTableInfo()
New instance of HotlistTableInfo: The table is used by the hotlist to store the relationship between tickets and users
Declaration
public static HotlistTableInfo GetHotlistTableInfo()Returns
| Type | Description |
|---|---|
| HotlistTableInfo |
GetImportDefaultTableInfo()
New instance of ImportDefaultTableInfo: Defaults for import fields/objects
Declaration
public static ImportDefaultTableInfo GetImportDefaultTableInfo()Returns
| Type | Description |
|---|---|
| ImportDefaultTableInfo |
GetImportFieldTableInfo()
New instance of ImportFieldTableInfo: Import object types - see localetext for names
Declaration
public static ImportFieldTableInfo GetImportFieldTableInfo()Returns
| Type | Description |
|---|---|
| ImportFieldTableInfo |
GetImportObjectTableInfo()
New instance of ImportObjectTableInfo: Import object types - see localetext for names.
Declaration
public static ImportObjectTableInfo GetImportObjectTableInfo()Returns
| Type | Description |
|---|---|
| ImportObjectTableInfo |
GetImportRelationTableInfo()
New instance of ImportRelationTableInfo: Relations between import objects
Declaration
public static ImportRelationTableInfo GetImportRelationTableInfo()Returns
| Type | Description |
|---|---|
| ImportRelationTableInfo |
GetInboxTableInfo()
New instance of InboxTableInfo: Info and status for safe email import
Declaration
public static InboxTableInfo GetInboxTableInfo()Returns
| Type | Description |
|---|---|
| InboxTableInfo |
GetIntentGroupLinkTableInfo()
New instance of IntentGroupLinkTableInfo: User group link table for Intent, for MDO item hiding
Declaration
public static IntentGroupLinkTableInfo GetIntentGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| IntentGroupLinkTableInfo |
GetIntentHeadingLinkTableInfo()
New instance of IntentHeadingLinkTableInfo: Heading link table for Intent, for MDO headers
Declaration
public static IntentHeadingLinkTableInfo GetIntentHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| IntentHeadingLinkTableInfo |
GetIntentTableInfo()
New instance of IntentTableInfo: Intent list for SAINT. More information regarding SuperOffice Sales Intelligence on http://techdoc.superoffice.com
Declaration
public static IntentTableInfo GetIntentTableInfo()Returns
| Type | Description |
|---|---|
| IntentTableInfo |
GetInvitationTableInfo()
New instance of InvitationTableInfo: Invitations to events
Declaration
public static InvitationTableInfo GetInvitationTableInfo()Returns
| Type | Description |
|---|---|
| InvitationTableInfo |
GetInvoiceEntryTableInfo()
New instance of InvoiceEntryTableInfo: This table contain all invoices, connected to a message
Declaration
public static InvoiceEntryTableInfo GetInvoiceEntryTableInfo()Returns
| Type | Description |
|---|---|
| InvoiceEntryTableInfo |
GetInvoiceSumTableInfo()
New instance of InvoiceSumTableInfo: 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 static InvoiceSumTableInfo GetInvoiceSumTableInfo()Returns
| Type | Description |
|---|---|
| InvoiceSumTableInfo |
GetInvoiceTableInfo()
New instance of InvoiceTableInfo: This table contains invoice entries, normally created when an invoice is sent to a customer, and we want to update the balance.
Declaration
public static InvoiceTableInfo GetInvoiceTableInfo()Returns
| Type | Description |
|---|---|
| InvoiceTableInfo |
GetInvoiceTypeTableInfo()
New instance of InvoiceTypeTableInfo: A invoiceable item category (a product or service) that provides default invoice line values
Declaration
public static InvoiceTypeTableInfo GetInvoiceTypeTableInfo()Returns
| Type | Description |
|---|---|
| InvoiceTypeTableInfo |
GetItemConfigTableInfo()
New instance of ItemConfigTableInfo: This table is a generic table for storing item configuration. It is only used by the class ItemConfig.
Declaration
public static ItemConfigTableInfo GetItemConfigTableInfo()Returns
| Type | Description |
|---|---|
| ItemConfigTableInfo |
GetKbAttachmentTableInfo()
New instance of KbAttachmentTableInfo: This table connects FAQ entries to attachments.
Declaration
public static KbAttachmentTableInfo GetKbAttachmentTableInfo()Returns
| Type | Description |
|---|---|
| KbAttachmentTableInfo |
GetKbCategoryLogTableInfo()
New instance of KbCategoryLogTableInfo: Who and when, if somebody edits a knowledge base folder
Declaration
public static KbCategoryLogTableInfo GetKbCategoryLogTableInfo()Returns
| Type | Description |
|---|---|
| KbCategoryLogTableInfo |
GetKbCategoryTableInfo()
New instance of KbCategoryTableInfo: Knowledge base folder hierarchy
Declaration
public static KbCategoryTableInfo GetKbCategoryTableInfo()Returns
| Type | Description |
|---|---|
| KbCategoryTableInfo |
GetKbEntryCommentTableInfo()
New instance of KbEntryCommentTableInfo: Comments to entries in the knowledge base, typically made by customers
Declaration
public static KbEntryCommentTableInfo GetKbEntryCommentTableInfo()Returns
| Type | Description |
|---|---|
| KbEntryCommentTableInfo |
GetKbEntryKeywordTableInfo()
New instance of KbEntryKeywordTableInfo: This table contains all keywords for the faq entries
Declaration
public static KbEntryKeywordTableInfo GetKbEntryKeywordTableInfo()Returns
| Type | Description |
|---|---|
| KbEntryKeywordTableInfo |
GetKbEntryLogTableInfo()
New instance of KbEntryLogTableInfo: Who and when, if somebody edits a knowledge base entry
Declaration
public static KbEntryLogTableInfo GetKbEntryLogTableInfo()Returns
| Type | Description |
|---|---|
| KbEntryLogTableInfo |
GetKbEntryTableInfo()
New instance of KbEntryTableInfo: This table contains FAQ entries.
Declaration
public static KbEntryTableInfo GetKbEntryTableInfo()Returns
| Type | Description |
|---|---|
| KbEntryTableInfo |
GetKbEntryWordsTableInfo()
New instance of KbEntryWordsTableInfo: This table contains all the words and how many times the are refered to in the FAQ entires
Declaration
public static KbEntryWordsTableInfo GetKbEntryWordsTableInfo()Returns
| Type | Description |
|---|---|
| KbEntryWordsTableInfo |
GetKbGroupEntryTableInfo()
New instance of KbGroupEntryTableInfo: This table contains group entries for FAQ groups.
Declaration
public static KbGroupEntryTableInfo GetKbGroupEntryTableInfo()Returns
| Type | Description |
|---|---|
| KbGroupEntryTableInfo |
GetKbGroupTableInfo()
New instance of KbGroupTableInfo: 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 static KbGroupTableInfo GetKbGroupTableInfo()Returns
| Type | Description |
|---|---|
| KbGroupTableInfo |
GetKbHttpLinkTableInfo()
New instance of KbHttpLinkTableInfo: This table contains URL's associated with a single FAQ entry.
Declaration
public static KbHttpLinkTableInfo GetKbHttpLinkTableInfo()Returns
| Type | Description |
|---|---|
| KbHttpLinkTableInfo |
GetKbSolutionFinderEntryTableInfo()
New instance of KbSolutionFinderEntryTableInfo: Knowledge base problem solving wizard, items in a category linking to a knowledge base entry
Declaration
public static KbSolutionFinderEntryTableInfo GetKbSolutionFinderEntryTableInfo()Returns
| Type | Description |
|---|---|
| KbSolutionFinderEntryTableInfo |
GetKbSolutionFinderTableInfo()
New instance of KbSolutionFinderTableInfo: Knowledge base problem solving wizard, categories and subcategories for drilling down
Declaration
public static KbSolutionFinderTableInfo GetKbSolutionFinderTableInfo()Returns
| Type | Description |
|---|---|
| KbSolutionFinderTableInfo |
GetKbWorkflowAccessTableInfo()
New instance of KbWorkflowAccessTableInfo: Control of who can do what in a knowledge base workflow step
Declaration
public static KbWorkflowAccessTableInfo GetKbWorkflowAccessTableInfo()Returns
| Type | Description |
|---|---|
| KbWorkflowAccessTableInfo |
GetKbWorkflowTableInfo()
New instance of KbWorkflowTableInfo: Knowledge base workflow steps
Declaration
public static KbWorkflowTableInfo GetKbWorkflowTableInfo()Returns
| Type | Description |
|---|---|
| KbWorkflowTableInfo |
GetLanguageInfoCountryTableInfo()
New instance of LanguageInfoCountryTableInfo: Many-many link between countries and languages, to give intelligent choices for language
Declaration
public static LanguageInfoCountryTableInfo GetLanguageInfoCountryTableInfo()Returns
| Type | Description |
|---|---|
| LanguageInfoCountryTableInfo |
GetLanguageInfoTableInfo()
New instance of LanguageInfoTableInfo: Information about languages, from ISO standards and related information
Declaration
public static LanguageInfoTableInfo GetLanguageInfoTableInfo()Returns
| Type | Description |
|---|---|
| LanguageInfoTableInfo |
GetLeadstatusTableInfo()
New instance of LeadstatusTableInfo: List items of lead status that is selectable for contacts and persons that have specific category
Declaration
public static LeadstatusTableInfo GetLeadstatusTableInfo()Returns
| Type | Description |
|---|---|
| LeadstatusTableInfo |
GetLegalBaseTableInfo()
New instance of LegalBaseTableInfo: Legal base for GDPR (Article 6)
Declaration
public static LegalBaseTableInfo GetLegalBaseTableInfo()Returns
| Type | Description |
|---|---|
| LegalBaseTableInfo |
GetLegalHtmlTagsTableInfo()
New instance of LegalHtmlTagsTableInfo: 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 static LegalHtmlTagsTableInfo GetLegalHtmlTagsTableInfo()Returns
| Type | Description |
|---|---|
| LegalHtmlTagsTableInfo |
GetLicenseAssocLinkTableInfo()
New instance of LicenseAssocLinkTableInfo: Link between ModuleLicense and Associate, for per-assoc licenses; this is how licenses are assigned/consumed
Declaration
public static LicenseAssocLinkTableInfo GetLicenseAssocLinkTableInfo()Returns
| Type | Description |
|---|---|
| LicenseAssocLinkTableInfo |
GetLicenseSatlLinkTableInfo()
New instance of LicenseSatlLinkTableInfo: Link between License and Satellite, for per-database licenses
Declaration
public static LicenseSatlLinkTableInfo GetLicenseSatlLinkTableInfo()Returns
| Type | Description |
|---|---|
| LicenseSatlLinkTableInfo |
GetLocaleTextTableInfo()
New instance of LocaleTextTableInfo: 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 static LocaleTextTableInfo GetLocaleTextTableInfo()Returns
| Type | Description |
|---|---|
| LocaleTextTableInfo |
GetLockingTableInfo()
New instance of LockingTableInfo: Generic locking and error messages
Declaration
public static LockingTableInfo GetLockingTableInfo()Returns
| Type | Description |
|---|---|
| LockingTableInfo |
GetLogDebugTableInfo()
New instance of LogDebugTableInfo: A log used for debugging, especially useful for bLogic/ejscript
Declaration
public static LogDebugTableInfo GetLogDebugTableInfo()Returns
| Type | Description |
|---|---|
| LogDebugTableInfo |
GetLogEventsTableInfo()
New instance of LogEventsTableInfo: System log
Declaration
public static LogEventsTableInfo GetLogEventsTableInfo()Returns
| Type | Description |
|---|---|
| LogEventsTableInfo |
GetLoginCustomerTableInfo()
New instance of LoginCustomerTableInfo: 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 static LoginCustomerTableInfo GetLoginCustomerTableInfo()Returns
| Type | Description |
|---|---|
| LoginCustomerTableInfo |
GetLoginTableInfo()
New instance of LoginTableInfo: This table contains entries for the user sessions.
Declaration
public static LoginTableInfo GetLoginTableInfo()Returns
| Type | Description |
|---|---|
| LoginTableInfo |
GetMailAliasTableInfo()
New instance of MailAliasTableInfo: 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 static MailAliasTableInfo GetMailAliasTableInfo()Returns
| Type | Description |
|---|---|
| MailAliasTableInfo |
GetMailBlockTableInfo()
New instance of MailBlockTableInfo: 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 static MailBlockTableInfo GetMailBlockTableInfo()Returns
| Type | Description |
|---|---|
| MailBlockTableInfo |
GetMailInFilterTableInfo()
New instance of MailInFilterTableInfo: This table contains entries for the mailboxes the eJournal system is fetching mail from (POP3 or IMAP).
Declaration
public static MailInFilterTableInfo GetMailInFilterTableInfo()Returns
| Type | Description |
|---|---|
| MailInFilterTableInfo |
GetMailInUidlTableInfo()
New instance of MailInUidlTableInfo: 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 static MailInUidlTableInfo GetMailInUidlTableInfo()Returns
| Type | Description |
|---|---|
| MailInUidlTableInfo |
GetMailingDomainsTableInfo()
New instance of MailingDomainsTableInfo: List of allowed domains used in a Mailing
Declaration
public static MailingDomainsTableInfo GetMailingDomainsTableInfo()Returns
| Type | Description |
|---|---|
| MailingDomainsTableInfo |
GetMergeMoveLogTableInfo()
New instance of MergeMoveLogTableInfo: Log of merge and move operations (person, contact, project)
Declaration
public static MergeMoveLogTableInfo GetMergeMoveLogTableInfo()Returns
| Type | Description |
|---|---|
| MergeMoveLogTableInfo |
GetMessageCustomersTableInfo()
New instance of MessageCustomersTableInfo: This table contains all cutomers who are involved in a message
Declaration
public static MessageCustomersTableInfo GetMessageCustomersTableInfo()Returns
| Type | Description |
|---|---|
| MessageCustomersTableInfo |
GetMessageHandlerTableInfo()
New instance of MessageHandlerTableInfo: Presence and heartbeat of a message handler, should be updated once a minute. Older records are stale
Declaration
public static MessageHandlerTableInfo GetMessageHandlerTableInfo()Returns
| Type | Description |
|---|---|
| MessageHandlerTableInfo |
GetMessageHeaderTableInfo()
New instance of MessageHeaderTableInfo: This table contains small pieces of information which is listed over the body for each message.
Declaration
public static MessageHeaderTableInfo GetMessageHeaderTableInfo()Returns
| Type | Description |
|---|---|
| MessageHeaderTableInfo |
GetMessageIdTableInfo()
New instance of MessageIdTableInfo: This table links an email message id to an eJournal item
Declaration
public static MessageIdTableInfo GetMessageIdTableInfo()Returns
| Type | Description |
|---|---|
| MessageIdTableInfo |
GetMessageTableInfo()
New instance of MessageTableInfo: Definition of a message, corresponding to the header of a protocol
Declaration
public static MessageTableInfo GetMessageTableInfo()Returns
| Type | Description |
|---|---|
| MessageTableInfo |
GetModuleLicenseTableInfo()
New instance of ModuleLicenseTableInfo: Module licenses, belonging to one single owner
Declaration
public static ModuleLicenseTableInfo GetModuleLicenseTableInfo()Returns
| Type | Description |
|---|---|
| ModuleLicenseTableInfo |
GetModuleOwnerTableInfo()
New instance of ModuleOwnerTableInfo: Unique owner of a set of licensed modules
Declaration
public static ModuleOwnerTableInfo GetModuleOwnerTableInfo()Returns
| Type | Description |
|---|---|
| ModuleOwnerTableInfo |
GetMrMrsGroupLinkTableInfo()
New instance of MrMrsGroupLinkTableInfo: User group link table for MrMrs, for MDO item hiding
Declaration
public static MrMrsGroupLinkTableInfo GetMrMrsGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| MrMrsGroupLinkTableInfo |
GetMrMrsHeadingLinkTableInfo()
New instance of MrMrsHeadingLinkTableInfo: Heading link table for MrMrs, for MDO headers
Declaration
public static MrMrsHeadingLinkTableInfo GetMrMrsHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| MrMrsHeadingLinkTableInfo |
GetMrMrsTableInfo()
New instance of MrMrsTableInfo: MrMrs list table. List of salutations.
Declaration
public static MrMrsTableInfo GetMrMrsTableInfo()Returns
| Type | Description |
|---|---|
| MrMrsTableInfo |
GetMsFilterMailTableInfo()
New instance of MsFilterMailTableInfo: This table connects mail filters (ms_filter) to mailboxes (mail_in_filter).
Declaration
public static MsFilterMailTableInfo GetMsFilterMailTableInfo()Returns
| Type | Description |
|---|---|
| MsFilterMailTableInfo |
GetMsFilterTableInfo()
New instance of MsFilterTableInfo: This table contains email filters. These are the filters allowing you to do advanced parsing of incomming emails.
Declaration
public static MsFilterTableInfo GetMsFilterTableInfo()Returns
| Type | Description |
|---|---|
| MsFilterTableInfo |
GetMsSubstituteTableInfo()
New instance of MsSubstituteTableInfo: Regexp for extracting info from emails when they enter they system
Declaration
public static MsSubstituteTableInfo GetMsSubstituteTableInfo()Returns
| Type | Description |
|---|---|
| MsSubstituteTableInfo |
GetMsTrashbinTableInfo()
New instance of MsTrashbinTableInfo: This table contains entries for emails which have been trashed by a filter, waiting for confirmation of deletion or import.
Declaration
public static MsTrashbinTableInfo GetMsTrashbinTableInfo()Returns
| Type | Description |
|---|---|
| MsTrashbinTableInfo |
GetNoticeFrameTableInfo()
New instance of NoticeFrameTableInfo: PID controller for automatic adjustment of pop up message check rate
Declaration
public static NoticeFrameTableInfo GetNoticeFrameTableInfo()Returns
| Type | Description |
|---|---|
| NoticeFrameTableInfo |
GetNotifyTableInfo()
New instance of NotifyTableInfo: This table contains the pop-up messages displayed for users for various events, such as 'new ticket', etc.
Declaration
public static NotifyTableInfo GetNotifyTableInfo()Returns
| Type | Description |
|---|---|
| NotifyTableInfo |
GetOLEFieldTableInfo()
New instance of OLEFieldTableInfo: Control data table for the OLE DB Provider
Declaration
public static OLEFieldTableInfo GetOLEFieldTableInfo()Returns
| Type | Description |
|---|---|
| OLEFieldTableInfo |
GetOLEFieldTextTableInfo()
New instance of OLEFieldTextTableInfo: Control data table for the OLE DB Provider
Declaration
public static OLEFieldTextTableInfo GetOLEFieldTextTableInfo()Returns
| Type | Description |
|---|---|
| OLEFieldTextTableInfo |
GetOLESubjectTableInfo()
New instance of OLESubjectTableInfo: Control data table for the OLE DB Provider
Declaration
public static OLESubjectTableInfo GetOLESubjectTableInfo()Returns
| Type | Description |
|---|---|
| OLESubjectTableInfo |
GetOLESubjectTextTableInfo()
New instance of OLESubjectTextTableInfo: Control data table for the OLE DB Provider
Declaration
public static OLESubjectTextTableInfo GetOLESubjectTextTableInfo()Returns
| Type | Description |
|---|---|
| OLESubjectTextTableInfo |
GetOLEViewTableInfo()
New instance of OLEViewTableInfo: Control data table for the OLE DB Provider
Declaration
public static OLEViewTableInfo GetOLEViewTableInfo()Returns
| Type | Description |
|---|---|
| OLEViewTableInfo |
GetOLEViewTextTableInfo()
New instance of OLEViewTextTableInfo: Control data table for the OLE DB Provider
Declaration
public static OLEViewTextTableInfo GetOLEViewTextTableInfo()Returns
| Type | Description |
|---|---|
| OLEViewTextTableInfo |
GetObsolete1TableInfo()
New instance of Obsolete1TableInfo: Obsolete table for functionality that was never implemented
Declaration
public static Obsolete1TableInfo GetObsolete1TableInfo()Returns
| Type | Description |
|---|---|
| Obsolete1TableInfo |
GetObsolete2TableInfo()
New instance of Obsolete2TableInfo: Obsolete table for functionality that was never implemented
Declaration
public static Obsolete2TableInfo GetObsolete2TableInfo()Returns
| Type | Description |
|---|---|
| Obsolete2TableInfo |
GetObsolete3TableInfo()
New instance of Obsolete3TableInfo: Obsolete table for functionality that was never implemented
Declaration
public static Obsolete3TableInfo GetObsolete3TableInfo()Returns
| Type | Description |
|---|---|
| Obsolete3TableInfo |
GetObsolete4TableInfo()
New instance of Obsolete4TableInfo: Obsolete table for functionality that was never implemented
Declaration
public static Obsolete4TableInfo GetObsolete4TableInfo()Returns
| Type | Description |
|---|---|
| Obsolete4TableInfo |
GetOnlineAppTableInfo()
New instance of OnlineAppTableInfo: Echo and track information about Online Apps and their usage
Declaration
public static OnlineAppTableInfo GetOnlineAppTableInfo()Returns
| Type | Description |
|---|---|
| OnlineAppTableInfo |
GetOutboxTableInfo()
New instance of OutboxTableInfo: Outgoing emails with sending status and other info
Declaration
public static OutboxTableInfo GetOutboxTableInfo()Returns
| Type | Description |
|---|---|
| OutboxTableInfo |
GetOutgoingMessageTableInfo()
New instance of OutgoingMessageTableInfo: Delivery of outgoing messages to messageplugins, updated with status asynchroneously
Declaration
public static OutgoingMessageTableInfo GetOutgoingMessageTableInfo()Returns
| Type | Description |
|---|---|
| OutgoingMessageTableInfo |
GetOwnerContactLinkTableInfo()
New instance of OwnerContactLinkTableInfo: 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 static OwnerContactLinkTableInfo GetOwnerContactLinkTableInfo()Returns
| Type | Description |
|---|---|
| OwnerContactLinkTableInfo |
GetPMembTypeGroupLinkTableInfo()
New instance of PMembTypeGroupLinkTableInfo: User group link table for PMembType, for MDO item hiding
Declaration
public static PMembTypeGroupLinkTableInfo GetPMembTypeGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| PMembTypeGroupLinkTableInfo |
GetPMembTypeHeadingLinkTableInfo()
New instance of PMembTypeHeadingLinkTableInfo: Heading link table for PMembType, for MDO headers
Declaration
public static PMembTypeHeadingLinkTableInfo GetPMembTypeHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| PMembTypeHeadingLinkTableInfo |
GetPMembTypeTableInfo()
New instance of PMembTypeTableInfo: PMembType list table. List text of titles (member types) for project members.
Declaration
public static PMembTypeTableInfo GetPMembTypeTableInfo()Returns
| Type | Description |
|---|---|
| PMembTypeTableInfo |
GetPasswordRulesTableInfo()
New instance of PasswordRulesTableInfo: This table may contain one entry specifying rules for passwords.
Declaration
public static PasswordRulesTableInfo GetPasswordRulesTableInfo()Returns
| Type | Description |
|---|---|
| PasswordRulesTableInfo |
GetPaymentTermsGroupLinkTableInfo()
New instance of PaymentTermsGroupLinkTableInfo: User group link table for PaymentTerms, for MDO item hiding
Declaration
public static PaymentTermsGroupLinkTableInfo GetPaymentTermsGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| PaymentTermsGroupLinkTableInfo |
GetPaymentTermsHeadingLinkTableInfo()
New instance of PaymentTermsHeadingLinkTableInfo: Heading link table for PaymentTerms, for MDO item headings
Declaration
public static PaymentTermsHeadingLinkTableInfo GetPaymentTermsHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| PaymentTermsHeadingLinkTableInfo |
GetPaymentTermsTableInfo()
New instance of PaymentTermsTableInfo: The list of payment terms, in the internal product register
Declaration
public static PaymentTermsTableInfo GetPaymentTermsTableInfo()Returns
| Type | Description |
|---|---|
| PaymentTermsTableInfo |
GetPaymentTypeGroupLinkTableInfo()
New instance of PaymentTypeGroupLinkTableInfo: User group link table for PaymentType, for MDO item hiding
Declaration
public static PaymentTypeGroupLinkTableInfo GetPaymentTypeGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| PaymentTypeGroupLinkTableInfo |
GetPaymentTypeHeadingLinkTableInfo()
New instance of PaymentTypeHeadingLinkTableInfo: Heading link table for PaymentType, for MDO item headings
Declaration
public static PaymentTypeHeadingLinkTableInfo GetPaymentTypeHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| PaymentTypeHeadingLinkTableInfo |
GetPaymentTypeTableInfo()
New instance of PaymentTypeTableInfo: The list of payment types, in the internal product register
Declaration
public static PaymentTypeTableInfo GetPaymentTypeTableInfo()Returns
| Type | Description |
|---|---|
| PaymentTypeTableInfo |
GetPersIntGroupLinkTableInfo()
New instance of PersIntGroupLinkTableInfo: User group link table for PersInt, for MDO item hiding
Declaration
public static PersIntGroupLinkTableInfo GetPersIntGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| PersIntGroupLinkTableInfo |
GetPersIntHeadingLinkTableInfo()
New instance of PersIntHeadingLinkTableInfo: Heading link table for PersInt, for MDO headers
Declaration
public static PersIntHeadingLinkTableInfo GetPersIntHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| PersIntHeadingLinkTableInfo |
GetPersIntTableInfo()
New instance of PersIntTableInfo: PersInt list table. List of Person interests.
Declaration
public static PersIntTableInfo GetPersIntTableInfo()Returns
| Type | Description |
|---|---|
| PersIntTableInfo |
GetPersPosGroupLinkTableInfo()
New instance of PersPosGroupLinkTableInfo: User group link table for PersPos, for MDO item hiding
Declaration
public static PersPosGroupLinkTableInfo GetPersPosGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| PersPosGroupLinkTableInfo |
GetPersPosHeadingLinkTableInfo()
New instance of PersPosHeadingLinkTableInfo: Heading link table for PersPos, for MDO headers
Declaration
public static PersPosHeadingLinkTableInfo GetPersPosHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| PersPosHeadingLinkTableInfo |
GetPersPosTableInfo()
New instance of PersPosTableInfo: PersPos list table. Contact person position list
Declaration
public static PersPosTableInfo GetPersPosTableInfo()Returns
| Type | Description |
|---|---|
| PersPosTableInfo |
GetPersonInterestTableInfo()
New instance of PersonInterestTableInfo: 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 static PersonInterestTableInfo GetPersonInterestTableInfo()Returns
| Type | Description |
|---|---|
| PersonInterestTableInfo |
GetPersonTableInfo()
New instance of PersonTableInfo: Persons
Declaration
public static PersonTableInfo GetPersonTableInfo()Returns
| Type | Description |
|---|---|
| PersonTableInfo |
GetPhoneFormatTableInfo()
New instance of PhoneFormatTableInfo: Formatting information for telephone numbers
Declaration
public static PhoneFormatTableInfo GetPhoneFormatTableInfo()Returns
| Type | Description |
|---|---|
| PhoneFormatTableInfo |
GetPhoneTableInfo()
New instance of PhoneTableInfo: Contact and Person phonenumbers (+fax)
Declaration
public static PhoneTableInfo GetPhoneTableInfo()Returns
| Type | Description |
|---|---|
| PhoneTableInfo |
GetPrefDescLineTableInfo()
New instance of PrefDescLineTableInfo: 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 static PrefDescLineTableInfo GetPrefDescLineTableInfo()Returns
| Type | Description |
|---|---|
| PrefDescLineTableInfo |
GetPrefDescTableInfo()
New instance of PrefDescTableInfo: 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 static PrefDescTableInfo GetPrefDescTableInfo()Returns
| Type | Description |
|---|---|
| PrefDescTableInfo |
GetPreferenceTableInfo()
New instance of PreferenceTableInfo: Not quite obsolete preference table; historical info mostly. From 6.1 this table now holds an upgrade stamp.
Declaration
public static PreferenceTableInfo GetPreferenceTableInfo()Returns
| Type | Description |
|---|---|
| PreferenceTableInfo |
GetPriceListTableInfo()
New instance of PriceListTableInfo: List of prices, cached from an ERP system
Declaration
public static PriceListTableInfo GetPriceListTableInfo()Returns
| Type | Description |
|---|---|
| PriceListTableInfo |
GetPriceUnitGroupLinkTableInfo()
New instance of PriceUnitGroupLinkTableInfo: User group link table for PriceUnit, for MDO item hiding
Declaration
public static PriceUnitGroupLinkTableInfo GetPriceUnitGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| PriceUnitGroupLinkTableInfo |
GetPriceUnitHeadingLinkTableInfo()
New instance of PriceUnitHeadingLinkTableInfo: Heading link table for PriceUnit, for MDO item headings
Declaration
public static PriceUnitHeadingLinkTableInfo GetPriceUnitHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| PriceUnitHeadingLinkTableInfo |
GetPriceUnitTableInfo()
New instance of PriceUnitTableInfo: The list of price units, in the internal product register (meter, ton, bushel, microsecond, gradus, τρυβλίον, 五合枡, دونم or whatever)
Declaration
public static PriceUnitTableInfo GetPriceUnitTableInfo()Returns
| Type | Description |
|---|---|
| PriceUnitTableInfo |
GetPriorityGroupLinkTableInfo()
New instance of PriorityGroupLinkTableInfo: User group link table for Priority, for MDO item hiding
Declaration
public static PriorityGroupLinkTableInfo GetPriorityGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| PriorityGroupLinkTableInfo |
GetPriorityHeadingLinkTableInfo()
New instance of PriorityHeadingLinkTableInfo: Heading link table for Priority, for MDO headers
Declaration
public static PriorityHeadingLinkTableInfo GetPriorityHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| PriorityHeadingLinkTableInfo |
GetPriorityTableInfo()
New instance of PriorityTableInfo: Priority list table. Used with appointments: low, high.
Declaration
public static PriorityTableInfo GetPriorityTableInfo()Returns
| Type | Description |
|---|---|
| PriorityTableInfo |
GetProbGroupLinkTableInfo()
New instance of ProbGroupLinkTableInfo: User group link table for Prob, for MDO item hiding
Declaration
public static ProbGroupLinkTableInfo GetProbGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| ProbGroupLinkTableInfo |
GetProbHeadingLinkTableInfo()
New instance of ProbHeadingLinkTableInfo: Heading link table for Prob, for MDO headers
Declaration
public static ProbHeadingLinkTableInfo GetProbHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| ProbHeadingLinkTableInfo |
GetProbTableInfo()
New instance of ProbTableInfo: Prob list table. Probability, used in sales .
Declaration
public static ProbTableInfo GetProbTableInfo()Returns
| Type | Description |
|---|---|
| ProbTableInfo |
GetProductCategoryGroupLinkTableInfo()
New instance of ProductCategoryGroupLinkTableInfo: User group link table for ProductCategory, for MDO item hiding
Declaration
public static ProductCategoryGroupLinkTableInfo GetProductCategoryGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| ProductCategoryGroupLinkTableInfo |
GetProductCategoryHeadingLinkTableInfo()
New instance of ProductCategoryHeadingLinkTableInfo: Heading link table for ProductCategory, for MDO item headings
Declaration
public static ProductCategoryHeadingLinkTableInfo GetProductCategoryHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| ProductCategoryHeadingLinkTableInfo |
GetProductCategoryTableInfo()
New instance of ProductCategoryTableInfo: List for the ProductCategory field of the Product table (Quote Management)
Declaration
public static ProductCategoryTableInfo GetProductCategoryTableInfo()Returns
| Type | Description |
|---|---|
| ProductCategoryTableInfo |
GetProductFamilyGroupLinkTableInfo()
New instance of ProductFamilyGroupLinkTableInfo: User group link table for ProductFamily, for MDO item hiding
Declaration
public static ProductFamilyGroupLinkTableInfo GetProductFamilyGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| ProductFamilyGroupLinkTableInfo |
GetProductFamilyHeadingLinkTableInfo()
New instance of ProductFamilyHeadingLinkTableInfo: Heading link table for ProductFamily, for MDO item headings
Declaration
public static ProductFamilyHeadingLinkTableInfo GetProductFamilyHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| ProductFamilyHeadingLinkTableInfo |
GetProductFamilyTableInfo()
New instance of ProductFamilyTableInfo: List for the ProductFamily field of the Product table (Quote Management)
Declaration
public static ProductFamilyTableInfo GetProductFamilyTableInfo()Returns
| Type | Description |
|---|---|
| ProductFamilyTableInfo |
GetProductTableInfo()
New instance of ProductTableInfo: One Product, member of one price list
Declaration
public static ProductTableInfo GetProductTableInfo()Returns
| Type | Description |
|---|---|
| ProductTableInfo |
GetProductTypeGroupLinkTableInfo()
New instance of ProductTypeGroupLinkTableInfo: User group link table for ProductType, for MDO item hiding
Declaration
public static ProductTypeGroupLinkTableInfo GetProductTypeGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| ProductTypeGroupLinkTableInfo |
GetProductTypeHeadingLinkTableInfo()
New instance of ProductTypeHeadingLinkTableInfo: Heading link table for ProductType, for MDO item headings
Declaration
public static ProductTypeHeadingLinkTableInfo GetProductTypeHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| ProductTypeHeadingLinkTableInfo |
GetProductTypeTableInfo()
New instance of ProductTypeTableInfo: List for the ProductType field of the Product table (Quote Management)
Declaration
public static ProductTypeTableInfo GetProductTypeTableInfo()Returns
| Type | Description |
|---|---|
| ProductTypeTableInfo |
GetProductVersionTableInfo()
New instance of ProductVersionTableInfo: Version information for code modules. Owner + code module must be unique
Declaration
public static ProductVersionTableInfo GetProductVersionTableInfo()Returns
| Type | Description |
|---|---|
| ProductVersionTableInfo |
GetProfileTableInfo()
New instance of ProfileTableInfo: Deprecated. This table contains entries for the user profiles.
Declaration
public static ProfileTableInfo GetProfileTableInfo()Returns
| Type | Description |
|---|---|
| ProfileTableInfo |
GetProjStatusGroupLinkTableInfo()
New instance of ProjStatusGroupLinkTableInfo: User group link table for ProjStatus, for MDO item hiding
Declaration
public static ProjStatusGroupLinkTableInfo GetProjStatusGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| ProjStatusGroupLinkTableInfo |
GetProjStatusHeadingLinkTableInfo()
New instance of ProjStatusHeadingLinkTableInfo: Heading link table for ProjStatus, for MDO headers
Declaration
public static ProjStatusHeadingLinkTableInfo GetProjStatusHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| ProjStatusHeadingLinkTableInfo |
GetProjStatusTableInfo()
New instance of ProjStatusTableInfo: ProjStatus list table. Project status
Declaration
public static ProjStatusTableInfo GetProjStatusTableInfo()Returns
| Type | Description |
|---|---|
| ProjStatusTableInfo |
GetProjTypeGroupLinkTableInfo()
New instance of ProjTypeGroupLinkTableInfo: User group link table for ProjType, for MDO item hiding
Declaration
public static ProjTypeGroupLinkTableInfo GetProjTypeGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| ProjTypeGroupLinkTableInfo |
GetProjTypeHeadingLinkTableInfo()
New instance of ProjTypeHeadingLinkTableInfo: Heading link table for ProjType, for MDO headers
Declaration
public static ProjTypeHeadingLinkTableInfo GetProjTypeHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| ProjTypeHeadingLinkTableInfo |
GetProjTypeTableInfo()
New instance of ProjTypeTableInfo: ProjType list table. List of valid Project types.
Declaration
public static ProjTypeTableInfo GetProjTypeTableInfo()Returns
| Type | Description |
|---|---|
| ProjTypeTableInfo |
GetProjectMemberTableInfo()
New instance of ProjectMemberTableInfo: Project members. Link-table between person and project
Declaration
public static ProjectMemberTableInfo GetProjectMemberTableInfo()Returns
| Type | Description |
|---|---|
| ProjectMemberTableInfo |
GetProjectTableInfo()
New instance of ProjectTableInfo: Projects
Declaration
public static ProjectTableInfo GetProjectTableInfo()Returns
| Type | Description |
|---|---|
| ProjectTableInfo |
GetProjectTypeStatusLinkTableInfo()
New instance of ProjectTypeStatusLinkTableInfo: Many-many link table between project type and status, similar to sale type-stage link; and an anchor point for guide items
Declaration
public static ProjectTypeStatusLinkTableInfo GetProjectTypeStatusLinkTableInfo()Returns
| Type | Description |
|---|---|
| ProjectTypeStatusLinkTableInfo |
GetPublishTableInfo()
New instance of PublishTableInfo: Publishing system for external users
Declaration
public static PublishTableInfo GetPublishTableInfo()Returns
| Type | Description |
|---|---|
| PublishTableInfo |
GetPushNotificationServiceTableInfo()
New instance of PushNotificationServiceTableInfo: Used for storing handles to user devices that should receive push notifications
Declaration
public static PushNotificationServiceTableInfo GetPushNotificationServiceTableInfo()Returns
| Type | Description |
|---|---|
| PushNotificationServiceTableInfo |
GetQuickFilterInfoTableInfo()
New instance of QuickFilterInfoTableInfo: Connect quick filter info from a specific provider to a dashboard
Declaration
public static QuickFilterInfoTableInfo GetQuickFilterInfoTableInfo()Returns
| Type | Description |
|---|---|
| QuickFilterInfoTableInfo |
GetQuickReplyTableInfo()
New instance of QuickReplyTableInfo: Personal quick reply text fragments
Declaration
public static QuickReplyTableInfo GetQuickReplyTableInfo()Returns
| Type | Description |
|---|---|
| QuickReplyTableInfo |
GetQuoteAlternativeTableInfo()
New instance of QuoteAlternativeTableInfo: 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 static QuoteAlternativeTableInfo GetQuoteAlternativeTableInfo()Returns
| Type | Description |
|---|---|
| QuoteAlternativeTableInfo |
GetQuoteApprReasonGroupLinkTableInfo()
New instance of QuoteApprReasonGroupLinkTableInfo: User group link table for QuoteApprReason, for MDO item hiding
Declaration
public static QuoteApprReasonGroupLinkTableInfo GetQuoteApprReasonGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| QuoteApprReasonGroupLinkTableInfo |
GetQuoteApprReasonHeadingLinkTableInfo()
New instance of QuoteApprReasonHeadingLinkTableInfo: Heading link table for QuoteApprReason, for MDO headers
Declaration
public static QuoteApprReasonHeadingLinkTableInfo GetQuoteApprReasonHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| QuoteApprReasonHeadingLinkTableInfo |
GetQuoteApprReasonTableInfo()
New instance of QuoteApprReasonTableInfo: Predefined reasons for quote approval
Declaration
public static QuoteApprReasonTableInfo GetQuoteApprReasonTableInfo()Returns
| Type | Description |
|---|---|
| QuoteApprReasonTableInfo |
GetQuoteConnectionAccessTableInfo()
New instance of QuoteConnectionAccessTableInfo: Access control for Quote Connections
Declaration
public static QuoteConnectionAccessTableInfo GetQuoteConnectionAccessTableInfo()Returns
| Type | Description |
|---|---|
| QuoteConnectionAccessTableInfo |
GetQuoteConnectionTableInfo()
New instance of QuoteConnectionTableInfo: Primary key in the CRM database. Definition of a connection to an external system, for the Quote system.
Declaration
public static QuoteConnectionTableInfo GetQuoteConnectionTableInfo()Returns
| Type | Description |
|---|---|
| QuoteConnectionTableInfo |
GetQuoteDenyReasonGroupLinkTableInfo()
New instance of QuoteDenyReasonGroupLinkTableInfo: User group link table for QuoteDenyReason, for MDO item hiding
Declaration
public static QuoteDenyReasonGroupLinkTableInfo GetQuoteDenyReasonGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| QuoteDenyReasonGroupLinkTableInfo |
GetQuoteDenyReasonHeadingLinkTableInfo()
New instance of QuoteDenyReasonHeadingLinkTableInfo: Heading link table for QuoteDenyReason, for MDO headers
Declaration
public static QuoteDenyReasonHeadingLinkTableInfo GetQuoteDenyReasonHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| QuoteDenyReasonHeadingLinkTableInfo |
GetQuoteDenyReasonTableInfo()
New instance of QuoteDenyReasonTableInfo: Predefined reasons for quote denial
Declaration
public static QuoteDenyReasonTableInfo GetQuoteDenyReasonTableInfo()Returns
| Type | Description |
|---|---|
| QuoteDenyReasonTableInfo |
GetQuoteLineConfigurationTableInfo()
New instance of QuoteLineConfigurationTableInfo: Configuration of quote lines - which fields are in use, rights, labels etc
Declaration
public static QuoteLineConfigurationTableInfo GetQuoteLineConfigurationTableInfo()Returns
| Type | Description |
|---|---|
| QuoteLineConfigurationTableInfo |
GetQuoteLineTableInfo()
New instance of QuoteLineTableInfo: 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 static QuoteLineTableInfo GetQuoteLineTableInfo()Returns
| Type | Description |
|---|---|
| QuoteLineTableInfo |
GetQuoteTableInfo()
New instance of QuoteTableInfo: Quote root level, at most one per Sale, always connected to one Sale
Declaration
public static QuoteTableInfo GetQuoteTableInfo()Returns
| Type | Description |
|---|---|
| QuoteTableInfo |
GetQuoteVersionAttachmentTableInfo()
New instance of QuoteVersionAttachmentTableInfo: Actual attachments to a quote
Declaration
public static QuoteVersionAttachmentTableInfo GetQuoteVersionAttachmentTableInfo()Returns
| Type | Description |
|---|---|
| QuoteVersionAttachmentTableInfo |
GetQuoteVersionTableInfo()
New instance of QuoteVersionTableInfo: There may be multiple Versions of a Quote, with one of them active
Declaration
public static QuoteVersionTableInfo GetQuoteVersionTableInfo()Returns
| Type | Description |
|---|---|
| QuoteVersionTableInfo |
GetReasonGroupLinkTableInfo()
New instance of ReasonGroupLinkTableInfo: User group link table for Reason, for MDO item hiding
Declaration
public static ReasonGroupLinkTableInfo GetReasonGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| ReasonGroupLinkTableInfo |
GetReasonHeadingLinkTableInfo()
New instance of ReasonHeadingLinkTableInfo: Heading link table for Reason, for MDO headers
Declaration
public static ReasonHeadingLinkTableInfo GetReasonHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| ReasonHeadingLinkTableInfo |
GetReasonSoldGroupLinkTableInfo()
New instance of ReasonSoldGroupLinkTableInfo: User group link table for ReasonSold, for MDO item hiding
Declaration
public static ReasonSoldGroupLinkTableInfo GetReasonSoldGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| ReasonSoldGroupLinkTableInfo |
GetReasonSoldHeadingLinkTableInfo()
New instance of ReasonSoldHeadingLinkTableInfo: Heading link table for ReasonSold, for MDO headers
Declaration
public static ReasonSoldHeadingLinkTableInfo GetReasonSoldHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| ReasonSoldHeadingLinkTableInfo |
GetReasonSoldTableInfo()
New instance of ReasonSoldTableInfo: Why was the sale marked as sold (why did we succeed)
Declaration
public static ReasonSoldTableInfo GetReasonSoldTableInfo()Returns
| Type | Description |
|---|---|
| ReasonSoldTableInfo |
GetReasonStalledGroupLinkTableInfo()
New instance of ReasonStalledGroupLinkTableInfo: Link table for ReasonStalled, for MDO item hiding
Declaration
public static ReasonStalledGroupLinkTableInfo GetReasonStalledGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| ReasonStalledGroupLinkTableInfo |
GetReasonStalledHeadingLinkTableInfo()
New instance of ReasonStalledHeadingLinkTableInfo: Heading link table for ReasonStalled, for MDO headers
Declaration
public static ReasonStalledHeadingLinkTableInfo GetReasonStalledHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| ReasonStalledHeadingLinkTableInfo |
GetReasonStalledTableInfo()
New instance of ReasonStalledTableInfo: Why was the sale marked as stalled
Declaration
public static ReasonStalledTableInfo GetReasonStalledTableInfo()Returns
| Type | Description |
|---|---|
| ReasonStalledTableInfo |
GetReasonTableInfo()
New instance of ReasonTableInfo: Reason list table. Why we lost the sale (list)
Declaration
public static ReasonTableInfo GetReasonTableInfo()Returns
| Type | Description |
|---|---|
| ReasonTableInfo |
GetRecurrenceRuleTableInfo()
New instance of RecurrenceRuleTableInfo: The recurrency pattern for a recurring event. Each recurring event has an appointment.recurrenceRuleId pointing to its pattern.
Declaration
public static RecurrenceRuleTableInfo GetRecurrenceRuleTableInfo()Returns
| Type | Description |
|---|---|
| RecurrenceRuleTableInfo |
GetRedLetterDayTableInfo()
New instance of RedLetterDayTableInfo: Red letter days for calendar (holidays, birthday of king etc)
Declaration
public static RedLetterDayTableInfo GetRedLetterDayTableInfo()Returns
| Type | Description |
|---|---|
| RedLetterDayTableInfo |
GetRefCountRangeTableInfo()
New instance of RefCountRangeTableInfo: Number allocation system, for keeping track of ranges of numbers loaned out to travel and satellite databases
Declaration
public static RefCountRangeTableInfo GetRefCountRangeTableInfo()Returns
| Type | Description |
|---|---|
| RefCountRangeTableInfo |
GetRefCountsTableInfo()
New instance of RefCountsTableInfo: 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 static RefCountsTableInfo GetRefCountsTableInfo()Returns
| Type | Description |
|---|---|
| RefCountsTableInfo |
GetRegistryTableInfo()
New instance of RegistryTableInfo: System settings
Declaration
public static RegistryTableInfo GetRegistryTableInfo()Returns
| Type | Description |
|---|---|
| RegistryTableInfo |
GetRejectReasonGroupLinkTableInfo()
New instance of RejectReasonGroupLinkTableInfo: User group link table for Comptr, for MDO item hiding
Declaration
public static RejectReasonGroupLinkTableInfo GetRejectReasonGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| RejectReasonGroupLinkTableInfo |
GetRejectReasonHeadingLinkTableInfo()
New instance of RejectReasonHeadingLinkTableInfo: Heading link table for RejectReason, for MDO headers
Declaration
public static RejectReasonHeadingLinkTableInfo GetRejectReasonHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| RejectReasonHeadingLinkTableInfo |
GetRejectReasonTableInfo()
New instance of RejectReasonTableInfo: Rejection reason (suggested) for bookings
Declaration
public static RejectReasonTableInfo GetRejectReasonTableInfo()Returns
| Type | Description |
|---|---|
| RejectReasonTableInfo |
GetRelationDefinitionGroupLinkTableInfo()
New instance of RelationDefinitionGroupLinkTableInfo: User group link table for RelDef, for MDO item hiding
Declaration
public static RelationDefinitionGroupLinkTableInfo GetRelationDefinitionGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| RelationDefinitionGroupLinkTableInfo |
GetRelationDefinitionHeadingLinkTableInfo()
New instance of RelationDefinitionHeadingLinkTableInfo: Heading link table for RelDef, for MDO headers
Declaration
public static RelationDefinitionHeadingLinkTableInfo GetRelationDefinitionHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| RelationDefinitionHeadingLinkTableInfo |
GetRelationDefinitionTableInfo()
New instance of RelationDefinitionTableInfo: 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 static RelationDefinitionTableInfo GetRelationDefinitionTableInfo()Returns
| Type | Description |
|---|---|
| RelationDefinitionTableInfo |
GetRelationTargetTableInfo()
New instance of RelationTargetTableInfo: 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 static RelationTargetTableInfo GetRelationTargetTableInfo()Returns
| Type | Description |
|---|---|
| RelationTargetTableInfo |
GetRelationsTableInfo()
New instance of RelationsTableInfo: 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 static RelationsTableInfo GetRelationsTableInfo()Returns
| Type | Description |
|---|---|
| RelationsTableInfo |
GetReplyTemplateAttachmentTableInfo()
New instance of ReplyTemplateAttachmentTableInfo: This table is used to connect attachments to reply templates (many-to-many).
Declaration
public static ReplyTemplateAttachmentTableInfo GetReplyTemplateAttachmentTableInfo()Returns
| Type | Description |
|---|---|
| ReplyTemplateAttachmentTableInfo |
GetReplyTemplateBodyTableInfo()
New instance of ReplyTemplateBodyTableInfo: Contains the body of the reply templates in different languages
Declaration
public static ReplyTemplateBodyTableInfo GetReplyTemplateBodyTableInfo()Returns
| Type | Description |
|---|---|
| ReplyTemplateBodyTableInfo |
GetReplyTemplateFolderTableInfo()
New instance of ReplyTemplateFolderTableInfo: This table contains entries for folders for reply templates.
Declaration
public static ReplyTemplateFolderTableInfo GetReplyTemplateFolderTableInfo()Returns
| Type | Description |
|---|---|
| ReplyTemplateFolderTableInfo |
GetReplyTemplateTableInfo()
New instance of ReplyTemplateTableInfo: Templates for automatic and manual replies to emails/sms organized hierachically
Declaration
public static ReplyTemplateTableInfo GetReplyTemplateTableInfo()Returns
| Type | Description |
|---|---|
| ReplyTemplateTableInfo |
GetReporterListDefTableInfo()
New instance of ReporterListDefTableInfo: Reporter definitions
Declaration
public static ReporterListDefTableInfo GetReporterListDefTableInfo()Returns
| Type | Description |
|---|---|
| ReporterListDefTableInfo |
GetResourceOverrideTableInfo()
New instance of ResourceOverrideTableInfo: Generic mechanism for overriding (or even defining new) text resources, in multiple languages
Declaration
public static ResourceOverrideTableInfo GetResourceOverrideTableInfo()Returns
| Type | Description |
|---|---|
| ResourceOverrideTableInfo |
GetRoleCategoryTableInfo()
New instance of RoleCategoryTableInfo: Category membership associated with a role
Declaration
public static RoleCategoryTableInfo GetRoleCategoryTableInfo()Returns
| Type | Description |
|---|---|
| RoleCategoryTableInfo |
GetRoleElementTableInfo()
New instance of RoleElementTableInfo: Profiles associated with a role
Declaration
public static RoleElementTableInfo GetRoleElementTableInfo()Returns
| Type | Description |
|---|---|
| RoleElementTableInfo |
GetRoleMemberTableInfo()
New instance of RoleMemberTableInfo: Users linked to a role. Deprecated.
Declaration
public static RoleMemberTableInfo GetRoleMemberTableInfo()Returns
| Type | Description |
|---|---|
| RoleMemberTableInfo |
GetRoleTableInfo()
New instance of RoleTableInfo: 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 static RoleTableInfo GetRoleTableInfo()Returns
| Type | Description |
|---|---|
| RoleTableInfo |
GetRoleWorkflowTableInfo()
New instance of RoleWorkflowTableInfo: Knowledge base workflow access rights associated with a role
Declaration
public static RoleWorkflowTableInfo GetRoleWorkflowTableInfo()Returns
| Type | Description |
|---|---|
| RoleWorkflowTableInfo |
GetSAttachmentTableInfo()
New instance of SAttachmentTableInfo: A connector between a message and attachments. One message can contain many attachments.
Declaration
public static SAttachmentTableInfo GetSAttachmentTableInfo()Returns
| Type | Description |
|---|---|
| SAttachmentTableInfo |
GetSBounceShipmentTableInfo()
New instance of SBounceShipmentTableInfo: Email bounces from customers
Declaration
public static SBounceShipmentTableInfo GetSBounceShipmentTableInfo()Returns
| Type | Description |
|---|---|
| SBounceShipmentTableInfo |
GetSDynCriteriaTableInfo()
New instance of SDynCriteriaTableInfo: Contains criterias for a dynamic list.
Declaration
public static SDynCriteriaTableInfo GetSDynCriteriaTableInfo()Returns
| Type | Description |
|---|---|
| SDynCriteriaTableInfo |
GetSLinkCustomerStaticalTableInfo()
New instance of SLinkCustomerStaticalTableInfo: A connection between a customer and a link. Registered customers are identified when clicking on a link
Declaration
public static SLinkCustomerStaticalTableInfo GetSLinkCustomerStaticalTableInfo()Returns
| Type | Description |
|---|---|
| SLinkCustomerStaticalTableInfo |
GetSLinkCustomerTableInfo()
New instance of SLinkCustomerTableInfo: A connection between a customer and a link. Registered customers are identified when clicking on a link
Declaration
public static SLinkCustomerTableInfo GetSLinkCustomerTableInfo()Returns
| Type | Description |
|---|---|
| SLinkCustomerTableInfo |
GetSLinkTableInfo()
New instance of SLinkTableInfo: Links in messages to measure success rate of a campaign.
Declaration
public static SLinkTableInfo GetSLinkTableInfo()Returns
| Type | Description |
|---|---|
| SLinkTableInfo |
GetSListCustomerTableInfo()
New instance of SListCustomerTableInfo: Elements in a customer list.
Declaration
public static SListCustomerTableInfo GetSListCustomerTableInfo()Returns
| Type | Description |
|---|---|
| SListCustomerTableInfo |
GetSListElementTableInfo()
New instance of SListElementTableInfo: Elements in a static list.
Declaration
public static SListElementTableInfo GetSListElementTableInfo()Returns
| Type | Description |
|---|---|
| SListElementTableInfo |
GetSListShipmentTableInfo()
New instance of SListShipmentTableInfo: A connector between shipment and list so that one shipment can have many lists, and one list can have many shipments
Declaration
public static SListShipmentTableInfo GetSListShipmentTableInfo()Returns
| Type | Description |
|---|---|
| SListShipmentTableInfo |
GetSListTableInfo()
New instance of SListTableInfo: A list, dynamic or static
Declaration
public static SListTableInfo GetSListTableInfo()Returns
| Type | Description |
|---|---|
| SListTableInfo |
GetSMessageTableInfo()
New instance of SMessageTableInfo: A message used in a shipment. Can be html and/or plain text
Declaration
public static SMessageTableInfo GetSMessageTableInfo()Returns
| Type | Description |
|---|---|
| SMessageTableInfo |
GetSMessageblockTableInfo()
New instance of SMessageblockTableInfo: Contains a block of a mailing message, that can be reused in a mailing
Declaration
public static SMessageblockTableInfo GetSMessageblockTableInfo()Returns
| Type | Description |
|---|---|
| SMessageblockTableInfo |
GetSORCriteriaTableInfo()
New instance of SORCriteriaTableInfo: SuperOffice reporter data
Declaration
public static SORCriteriaTableInfo GetSORCriteriaTableInfo()Returns
| Type | Description |
|---|---|
| SORCriteriaTableInfo |
GetSORFCTTableInfo()
New instance of SORFCTTableInfo: SuperOffice reporter data
Declaration
public static SORFCTTableInfo GetSORFCTTableInfo()Returns
| Type | Description |
|---|---|
| SORFCTTableInfo |
GetSORFieldTableInfo()
New instance of SORFieldTableInfo: SuperOffice reporter data
Declaration
public static SORFieldTableInfo GetSORFieldTableInfo()Returns
| Type | Description |
|---|---|
| SORFieldTableInfo |
GetSORLabelLayoutTableInfo()
New instance of SORLabelLayoutTableInfo: SuperOffice reporter data
Declaration
public static SORLabelLayoutTableInfo GetSORLabelLayoutTableInfo()Returns
| Type | Description |
|---|---|
| SORLabelLayoutTableInfo |
GetSOROperatorsTableInfo()
New instance of SOROperatorsTableInfo: SuperOffice reporter data
Declaration
public static SOROperatorsTableInfo GetSOROperatorsTableInfo()Returns
| Type | Description |
|---|---|
| SOROperatorsTableInfo |
GetSORPublishGroupLinkTableInfo()
New instance of SORPublishGroupLinkTableInfo: Link table used for filtering reports by user group
Declaration
public static SORPublishGroupLinkTableInfo GetSORPublishGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| SORPublishGroupLinkTableInfo |
GetSORPublishTableInfo()
New instance of SORPublishTableInfo: SuperOffice reporter data
Declaration
public static SORPublishTableInfo GetSORPublishTableInfo()Returns
| Type | Description |
|---|---|
| SORPublishTableInfo |
GetSORSectionTableInfo()
New instance of SORSectionTableInfo: SuperOffice reporter data
Declaration
public static SORSectionTableInfo GetSORSectionTableInfo()Returns
| Type | Description |
|---|---|
| SORSectionTableInfo |
GetSORTemplateTableInfo()
New instance of SORTemplateTableInfo: SuperOffice reporter data
Declaration
public static SORTemplateTableInfo GetSORTemplateTableInfo()Returns
| Type | Description |
|---|---|
| SORTemplateTableInfo |
GetSPictureEntryTableInfo()
New instance of SPictureEntryTableInfo: This table describes each picture in the database
Declaration
public static SPictureEntryTableInfo GetSPictureEntryTableInfo()Returns
| Type | Description |
|---|---|
| SPictureEntryTableInfo |
GetSPictureFolderTableInfo()
New instance of SPictureFolderTableInfo: This table contains all picture folders
Declaration
public static SPictureFolderTableInfo GetSPictureFolderTableInfo()Returns
| Type | Description |
|---|---|
| SPictureFolderTableInfo |
GetSSentMessageTableInfo()
New instance of SSentMessageTableInfo: Emarketeer message control
Declaration
public static SSentMessageTableInfo GetSSentMessageTableInfo()Returns
| Type | Description |
|---|---|
| SSentMessageTableInfo |
GetSShipmentAddrTableInfo()
New instance of SShipmentAddrTableInfo: Addresses that are ready to be sent in a shipment.
Declaration
public static SShipmentAddrTableInfo GetSShipmentAddrTableInfo()Returns
| Type | Description |
|---|---|
| SShipmentAddrTableInfo |
GetSShipmentTableInfo()
New instance of SShipmentTableInfo: Contains info about one shipment. The addresses are stored in s_shipment_addr
Declaration
public static SShipmentTableInfo GetSShipmentTableInfo()Returns
| Type | Description |
|---|---|
| SShipmentTableInfo |
GetSSmtpServersTableInfo()
New instance of SSmtpServersTableInfo: Contains the smtp server for a shipment
Declaration
public static SSmtpServersTableInfo GetSSmtpServersTableInfo()Returns
| Type | Description |
|---|---|
| SSmtpServersTableInfo |
GetSWashingListTableInfo()
New instance of SWashingListTableInfo: Unused table that is ment to be used for active washing in spm v2
Declaration
public static SWashingListTableInfo GetSWashingListTableInfo()Returns
| Type | Description |
|---|---|
| SWashingListTableInfo |
GetSWashingTableInfo()
New instance of SWashingTableInfo: Register of all bounced mail to enabel washing
Declaration
public static SWashingTableInfo GetSWashingTableInfo()Returns
| Type | Description |
|---|---|
| SWashingTableInfo |
GetSaintConfigurationTableInfo()
New instance of SaintConfigurationTableInfo: Configuration information for the Saint system
Declaration
public static SaintConfigurationTableInfo GetSaintConfigurationTableInfo()Returns
| Type | Description |
|---|---|
| SaintConfigurationTableInfo |
GetSaleHistTableInfo()
New instance of SaleHistTableInfo: 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 static SaleHistTableInfo GetSaleHistTableInfo()Returns
| Type | Description |
|---|---|
| SaleHistTableInfo |
GetSaleStakeholderTableInfo()
New instance of SaleStakeholderTableInfo: Stakeholders in the sale, very similar to project members
Declaration
public static SaleStakeholderTableInfo GetSaleStakeholderTableInfo()Returns
| Type | Description |
|---|---|
| SaleStakeholderTableInfo |
GetSaleTableInfo()
New instance of SaleTableInfo: 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 static SaleTableInfo GetSaleTableInfo()Returns
| Type | Description |
|---|---|
| SaleTableInfo |
GetSaleTypeCatGroupLinkTableInfo()
New instance of SaleTypeCatGroupLinkTableInfo: User group link table for SaleTypeCat, for MDO item hiding
Declaration
public static SaleTypeCatGroupLinkTableInfo GetSaleTypeCatGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| SaleTypeCatGroupLinkTableInfo |
GetSaleTypeCatHeadingLinkTableInfo()
New instance of SaleTypeCatHeadingLinkTableInfo: Heading link table for SaleTypeCat, for MDO headers
Declaration
public static SaleTypeCatHeadingLinkTableInfo GetSaleTypeCatHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| SaleTypeCatHeadingLinkTableInfo |
GetSaleTypeCatTableInfo()
New instance of SaleTypeCatTableInfo: Category for sale type
Declaration
public static SaleTypeCatTableInfo GetSaleTypeCatTableInfo()Returns
| Type | Description |
|---|---|
| SaleTypeCatTableInfo |
GetSaleTypeGroupLinkTableInfo()
New instance of SaleTypeGroupLinkTableInfo: User group link table for SaleType, for MDO item hiding
Declaration
public static SaleTypeGroupLinkTableInfo GetSaleTypeGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| SaleTypeGroupLinkTableInfo |
GetSaleTypeHeadingLinkTableInfo()
New instance of SaleTypeHeadingLinkTableInfo: Heading link table for SaleType, for MDO headers
Declaration
public static SaleTypeHeadingLinkTableInfo GetSaleTypeHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| SaleTypeHeadingLinkTableInfo |
GetSaleTypeQuoteAttachmentTableInfo()
New instance of SaleTypeQuoteAttachmentTableInfo: Default attachments to quotes linked to sales of this type
Declaration
public static SaleTypeQuoteAttachmentTableInfo GetSaleTypeQuoteAttachmentTableInfo()Returns
| Type | Description |
|---|---|
| SaleTypeQuoteAttachmentTableInfo |
GetSaleTypeStageLinkTableInfo()
New instance of SaleTypeStageLinkTableInfo: Many-many link table between sale type and stage; and an anchor point for guide items
Declaration
public static SaleTypeStageLinkTableInfo GetSaleTypeStageLinkTableInfo()Returns
| Type | Description |
|---|---|
| SaleTypeStageLinkTableInfo |
GetSaleTypeTableInfo()
New instance of SaleTypeTableInfo: Type of sale - large solution, incremental, whatever fits the organization
Declaration
public static SaleTypeTableInfo GetSaleTypeTableInfo()Returns
| Type | Description |
|---|---|
| SaleTypeTableInfo |
GetSalutationGroupLinkTableInfo()
New instance of SalutationGroupLinkTableInfo: User group link table for Salutation, for MDO item hiding
Declaration
public static SalutationGroupLinkTableInfo GetSalutationGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| SalutationGroupLinkTableInfo |
GetSalutationHeadingLinkTableInfo()
New instance of SalutationHeadingLinkTableInfo: Heading link table for Salutation, for MDO headers
Declaration
public static SalutationHeadingLinkTableInfo GetSalutationHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| SalutationHeadingLinkTableInfo |
GetSalutationTableInfo()
New instance of SalutationTableInfo: Academic title for Person
Declaration
public static SalutationTableInfo GetSalutationTableInfo()Returns
| Type | Description |
|---|---|
| SalutationTableInfo |
GetSatelliteTableInfo()
New instance of SatelliteTableInfo: Definition of Satellites
Declaration
public static SatelliteTableInfo GetSatelliteTableInfo()Returns
| Type | Description |
|---|---|
| SatelliteTableInfo |
GetScheduleTableInfo()
New instance of ScheduleTableInfo: Generic scheduled tasked handling time scheduling, locking and error messages
Declaration
public static ScheduleTableInfo GetScheduleTableInfo()Returns
| Type | Description |
|---|---|
| ScheduleTableInfo |
GetScheduledTaskTableInfo()
New instance of ScheduledTaskTableInfo: A scheduled entry executing a script at certain times
Declaration
public static ScheduledTaskTableInfo GetScheduledTaskTableInfo()Returns
| Type | Description |
|---|---|
| ScheduledTaskTableInfo |
GetScreenChooserTableInfo()
New instance of ScreenChooserTableInfo: Screen choosers
Declaration
public static ScreenChooserTableInfo GetScreenChooserTableInfo()Returns
| Type | Description |
|---|---|
| ScreenChooserTableInfo |
GetScreenDefinitionActionTableInfo()
New instance of ScreenDefinitionActionTableInfo: An action to perform for a certain button in an screen
Declaration
public static ScreenDefinitionActionTableInfo GetScreenDefinitionActionTableInfo()Returns
| Type | Description |
|---|---|
| ScreenDefinitionActionTableInfo |
GetScreenDefinitionElementTableInfo()
New instance of ScreenDefinitionElementTableInfo: An element in a configurable screen
Declaration
public static ScreenDefinitionElementTableInfo GetScreenDefinitionElementTableInfo()Returns
| Type | Description |
|---|---|
| ScreenDefinitionElementTableInfo |
GetScreenDefinitionHiddenTableInfo()
New instance of ScreenDefinitionHiddenTableInfo: The name of a hidden variable to keep for this screen
Declaration
public static ScreenDefinitionHiddenTableInfo GetScreenDefinitionHiddenTableInfo()Returns
| Type | Description |
|---|---|
| ScreenDefinitionHiddenTableInfo |
GetScreenDefinitionLanguageTableInfo()
New instance of ScreenDefinitionLanguageTableInfo: Custom language variables used for screens
Declaration
public static ScreenDefinitionLanguageTableInfo GetScreenDefinitionLanguageTableInfo()Returns
| Type | Description |
|---|---|
| ScreenDefinitionLanguageTableInfo |
GetScreenDefinitionTableInfo()
New instance of ScreenDefinitionTableInfo: A configurable screen
Declaration
public static ScreenDefinitionTableInfo GetScreenDefinitionTableInfo()Returns
| Type | Description |
|---|---|
| ScreenDefinitionTableInfo |
GetScriptTraceRunTableInfo()
New instance of ScriptTraceRunTableInfo: Traces of executed scripts
Declaration
public static ScriptTraceRunTableInfo GetScriptTraceRunTableInfo()Returns
| Type | Description |
|---|---|
| ScriptTraceRunTableInfo |
GetScriptTraceTableInfo()
New instance of ScriptTraceTableInfo: Scripts which should be traced
Declaration
public static ScriptTraceTableInfo GetScriptTraceTableInfo()Returns
| Type | Description |
|---|---|
| ScriptTraceTableInfo |
GetSearchCatGroupLinkTableInfo()
New instance of SearchCatGroupLinkTableInfo: User group link table for SearchCat, for MDO item hiding
Declaration
public static SearchCatGroupLinkTableInfo GetSearchCatGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| SearchCatGroupLinkTableInfo |
GetSearchCatHeadingLinkTableInfo()
New instance of SearchCatHeadingLinkTableInfo: Heading link table for SearchCat, for MDO headers
Declaration
public static SearchCatHeadingLinkTableInfo GetSearchCatHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| SearchCatHeadingLinkTableInfo |
GetSearchCatTableInfo()
New instance of SearchCatTableInfo: SearchCat list table
Declaration
public static SearchCatTableInfo GetSearchCatTableInfo()Returns
| Type | Description |
|---|---|
| SearchCatTableInfo |
GetSearchCriteriaGroupTableInfo()
New instance of SearchCriteriaGroupTableInfo: Criteria storage for Selection and other Find mechanisms
Declaration
public static SearchCriteriaGroupTableInfo GetSearchCriteriaGroupTableInfo()Returns
| Type | Description |
|---|---|
| SearchCriteriaGroupTableInfo |
GetSearchCriteriaTableInfo()
New instance of SearchCriteriaTableInfo: Criteria storage for Selection and other Find mechanisms
Declaration
public static SearchCriteriaTableInfo GetSearchCriteriaTableInfo()Returns
| Type | Description |
|---|---|
| SearchCriteriaTableInfo |
GetSearchCriterionTableInfo()
New instance of SearchCriterionTableInfo: Criteria storage for Selection and other Find mechanisms
Declaration
public static SearchCriterionTableInfo GetSearchCriterionTableInfo()Returns
| Type | Description |
|---|---|
| SearchCriterionTableInfo |
GetSearchCriterionValueTableInfo()
New instance of SearchCriterionValueTableInfo: Criteria storage for Selection and other Find mechanisms
Declaration
public static SearchCriterionValueTableInfo GetSearchCriterionValueTableInfo()Returns
| Type | Description |
|---|---|
| SearchCriterionValueTableInfo |
GetSelectionMemberTableInfo()
New instance of SelectionMemberTableInfo: 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 static SelectionMemberTableInfo GetSelectionMemberTableInfo()Returns
| Type | Description |
|---|---|
| SelectionMemberTableInfo |
GetSelectionTableInfo()
New instance of SelectionTableInfo: Selections
Declaration
public static SelectionTableInfo GetSelectionTableInfo()Returns
| Type | Description |
|---|---|
| SelectionTableInfo |
GetSequenceTableInfo()
New instance of SequenceTableInfo: next_id to be used for each table
Declaration
public static SequenceTableInfo GetSequenceTableInfo()Returns
| Type | Description |
|---|---|
| SequenceTableInfo |
GetServiceAuthTableInfo()
New instance of ServiceAuthTableInfo: Authentication for a service (imap, smtp...)
Declaration
public static ServiceAuthTableInfo GetServiceAuthTableInfo()Returns
| Type | Description |
|---|---|
| ServiceAuthTableInfo |
GetSessionObjectTableInfo()
New instance of SessionObjectTableInfo: Generic session object, accessible from ejscript etc, typically xml or name=value syntax, may be stored over several rows if big
Declaration
public static SessionObjectTableInfo GetSessionObjectTableInfo()Returns
| Type | Description |
|---|---|
| SessionObjectTableInfo |
GetShipmentTypeReservationTableInfo()
New instance of ShipmentTypeReservationTableInfo: ShipmentTypes a person has reserved against. Note that the absense of a record here implies acceptance of a mailings of this type
Declaration
public static ShipmentTypeReservationTableInfo GetShipmentTypeReservationTableInfo()Returns
| Type | Description |
|---|---|
| ShipmentTypeReservationTableInfo |
GetShipmentTypeTableInfo()
New instance of ShipmentTypeTableInfo: Shipment type list table. Classification of a mailing, allowing recipients to subscribe to lists
Declaration
public static ShipmentTypeTableInfo GetShipmentTypeTableInfo()Returns
| Type | Description |
|---|---|
| ShipmentTypeTableInfo |
GetSmsHysteriaTableInfo()
New instance of SmsHysteriaTableInfo: Avoid sending too many sms messages in a short time interval to one person
Declaration
public static SmsHysteriaTableInfo GetSmsHysteriaTableInfo()Returns
| Type | Description |
|---|---|
| SmsHysteriaTableInfo |
GetSmsTableInfo()
New instance of SmsTableInfo: This table will hold outgoing sms messages when transmitted with WebServices
Declaration
public static SmsTableInfo GetSmsTableInfo()Returns
| Type | Description |
|---|---|
| SmsTableInfo |
GetSnapshotTableInfo()
New instance of SnapshotTableInfo: Snapshots taken of the system database and attachments via soap
Declaration
public static SnapshotTableInfo GetSnapshotTableInfo()Returns
| Type | Description |
|---|---|
| SnapshotTableInfo |
GetSoapAccessTableInfo()
New instance of SoapAccessTableInfo: Table that contains constraints on the access to the soap interface
Declaration
public static SoapAccessTableInfo GetSoapAccessTableInfo()Returns
| Type | Description |
|---|---|
| SoapAccessTableInfo |
GetSourceGroupLinkTableInfo()
New instance of SourceGroupLinkTableInfo: User group link table for Source, for MDO item hiding
Declaration
public static SourceGroupLinkTableInfo GetSourceGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| SourceGroupLinkTableInfo |
GetSourceHeadingLinkTableInfo()
New instance of SourceHeadingLinkTableInfo: Heading link table for Source, for MDO headers
Declaration
public static SourceHeadingLinkTableInfo GetSourceHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| SourceHeadingLinkTableInfo |
GetSourceTableInfo()
New instance of SourceTableInfo: Source list table. Source for sale (list)
Declaration
public static SourceTableInfo GetSourceTableInfo()Returns
| Type | Description |
|---|---|
| SourceTableInfo |
GetStakeholderRoleGroupLinkTableInfo()
New instance of StakeholderRoleGroupLinkTableInfo: User group link table for StakeholderRole, for MDO item hiding
Declaration
public static StakeholderRoleGroupLinkTableInfo GetStakeholderRoleGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| StakeholderRoleGroupLinkTableInfo |
GetStakeholderRoleHeadingLinkTableInfo()
New instance of StakeholderRoleHeadingLinkTableInfo: Heading link table for StakeholderRole, for MDO headers
Declaration
public static StakeholderRoleHeadingLinkTableInfo GetStakeholderRoleHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| StakeholderRoleHeadingLinkTableInfo |
GetStakeholderRoleTableInfo()
New instance of StakeholderRoleTableInfo: Role a stakeholder has in a sale
Declaration
public static StakeholderRoleTableInfo GetStakeholderRoleTableInfo()Returns
| Type | Description |
|---|---|
| StakeholderRoleTableInfo |
GetStaticListRefTableInfo()
New instance of StaticListRefTableInfo: This table stores id references for selections id lists
Declaration
public static StaticListRefTableInfo GetStaticListRefTableInfo()Returns
| Type | Description |
|---|---|
| StaticListRefTableInfo |
GetStatusDefTableInfo()
New instance of StatusDefTableInfo: Status definitions. Name and description are in LocaleText for internationalization
Declaration
public static StatusDefTableInfo GetStatusDefTableInfo()Returns
| Type | Description |
|---|---|
| StatusDefTableInfo |
GetStatusValueTableInfo()
New instance of StatusValueTableInfo: Values for statuses
Declaration
public static StatusValueTableInfo GetStatusValueTableInfo()Returns
| Type | Description |
|---|---|
| StatusValueTableInfo |
GetSubscriptionUnitGroupLinkTableInfo()
New instance of SubscriptionUnitGroupLinkTableInfo: User group link table for SubscriptionUnit, for MDO item hiding
Declaration
public static SubscriptionUnitGroupLinkTableInfo GetSubscriptionUnitGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| SubscriptionUnitGroupLinkTableInfo |
GetSubscriptionUnitHeadingLinkTableInfo()
New instance of SubscriptionUnitHeadingLinkTableInfo: Heading link table for SubscriptionUnit, for MDO item headings
Declaration
public static SubscriptionUnitHeadingLinkTableInfo GetSubscriptionUnitHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| SubscriptionUnitHeadingLinkTableInfo |
GetSubscriptionUnitTableInfo()
New instance of SubscriptionUnitTableInfo: The list of Subscription units, in the internal product register (year/quarter/month etc., or perhaps amounts if volume-based subscription)
Declaration
public static SubscriptionUnitTableInfo GetSubscriptionUnitTableInfo()Returns
| Type | Description |
|---|---|
| SubscriptionUnitTableInfo |
GetSuggestedAppointmentTableInfo()
New instance of SuggestedAppointmentTableInfo: Defines a suggested appointment for use in a Sale Guide or Project Guide
Declaration
public static SuggestedAppointmentTableInfo GetSuggestedAppointmentTableInfo()Returns
| Type | Description |
|---|---|
| SuggestedAppointmentTableInfo |
GetSuggestedDocumentTableInfo()
New instance of SuggestedDocumentTableInfo: Unique owner of a set of licensed modules
Declaration
public static SuggestedDocumentTableInfo GetSuggestedDocumentTableInfo()Returns
| Type | Description |
|---|---|
| SuggestedDocumentTableInfo |
GetSuperListColumnSizeTableInfo()
New instance of SuperListColumnSizeTableInfo: Stores the relative size (in percent) or in characters of a column in a SuperList
Declaration
public static SuperListColumnSizeTableInfo GetSuperListColumnSizeTableInfo()Returns
| Type | Description |
|---|---|
| SuperListColumnSizeTableInfo |
GetSystemEventTableInfo()
New instance of SystemEventTableInfo: System events, such as freetext rebuild, SAINT rebuild and such. Makes broadcasts to keep its siblings and clients updated.
Declaration
public static SystemEventTableInfo GetSystemEventTableInfo()Returns
| Type | Description |
|---|---|
| SystemEventTableInfo |
GetSystemScriptTableInfo()
New instance of SystemScriptTableInfo: A table containing the system script
Declaration
public static SystemScriptTableInfo GetSystemScriptTableInfo()Returns
| Type | Description |
|---|---|
| SystemScriptTableInfo |
GetTZDstRuleTableInfo()
New instance of TZDstRuleTableInfo: Time zone rule for daylight saving time
Declaration
public static TZDstRuleTableInfo GetTZDstRuleTableInfo()Returns
| Type | Description |
|---|---|
| TZDstRuleTableInfo |
GetTZLocationTableInfo()
New instance of TZLocationTableInfo: Time zone location
Declaration
public static TZLocationTableInfo GetTZLocationTableInfo()Returns
| Type | Description |
|---|---|
| TZLocationTableInfo |
GetTZStdRuleTableInfo()
New instance of TZStdRuleTableInfo: Time zone rule for standard time
Declaration
public static TZStdRuleTableInfo GetTZStdRuleTableInfo()Returns
| Type | Description |
|---|---|
| TZStdRuleTableInfo |
GetTabOrderTableInfo()
New instance of TabOrderTableInfo: Order of tabs within a tab control, if configured by a user
Declaration
public static TabOrderTableInfo GetTabOrderTableInfo()Returns
| Type | Description |
|---|---|
| TabOrderTableInfo |
GetTableInfo(SoTable)
Returns new instance of the table-info for the given table definition
Declaration
public static TableInfo GetTableInfo(SoTable table)Parameters
| Type | Name | Description |
|---|---|---|
| SoTable | table |
Returns
| Type | Description |
|---|---|
| TableInfo |
GetTableInfo(int)
Returns new instance of the table-info for the given Table Number.
Declaration
public static TableInfo GetTableInfo(int tableNumber)Parameters
| Type | Name | Description |
|---|---|---|
| int | tableNumber | The table number you want info for (5 = "contact" or 6 = "person" for example) |
Returns
| Type | Description |
|---|---|
| TableInfo | A sub-class of TableInfo |
GetTableInfo(string)
Returns new instance of the table-info for the given table name.
Declaration
public static TableInfo GetTableInfo(string tableName)Parameters
| Type | Name | Description |
|---|---|---|
| string | tableName | The table you want info for ("contact or "person" for example) |
Returns
| Type | Description |
|---|---|
| TableInfo | A sub-class of TableInfo |
GetTableInfo(Type)
Returns new instance of the table-info for the given table type (useful when working with template classes)
Declaration
public static TableInfo GetTableInfo(Type tableInfoType)Parameters
| Type | Name | Description |
|---|---|---|
| Type | tableInfoType | Type of tableinfo to get, such as CompanyTableInfo |
Returns
| Type | Description |
|---|---|
| TableInfo |
GetTableInfo<T>()
Returns new instance of the table-info for the given table type (useful when working with template classes)
Declaration
public static T GetTableInfo<T>() where T : TableInfoReturns
| Type | Description |
|---|---|
| T |
Type Parameters
| Name | Description |
|---|---|
| T | Type of tableinfo to get, such as CompanyTableInfo |
GetTagsGroupLinkTableInfo()
New instance of TagsGroupLinkTableInfo: User group link table for Tags, for MDO item hiding
Declaration
public static TagsGroupLinkTableInfo GetTagsGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| TagsGroupLinkTableInfo |
GetTagsHeadingLinkTableInfo()
New instance of TagsHeadingLinkTableInfo: Heading link table for Source, for MDO headers
Declaration
public static TagsHeadingLinkTableInfo GetTagsHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| TagsHeadingLinkTableInfo |
GetTagsTableInfo()
New instance of TagsTableInfo: MDO List of tags for Service entities
Declaration
public static TagsTableInfo GetTagsTableInfo()Returns
| Type | Description |
|---|---|
| TagsTableInfo |
GetTargetAssignmentInfoTableInfo()
New instance of TargetAssignmentInfoTableInfo: Linking associate, company or user group target and other information with target values
Declaration
public static TargetAssignmentInfoTableInfo GetTargetAssignmentInfoTableInfo()Returns
| Type | Description |
|---|---|
| TargetAssignmentInfoTableInfo |
GetTargetAssignmentValueTableInfo()
New instance of TargetAssignmentValueTableInfo: A set of values linked to assignment info and a period in a target group.
Declaration
public static TargetAssignmentValueTableInfo GetTargetAssignmentValueTableInfo()Returns
| Type | Description |
|---|---|
| TargetAssignmentValueTableInfo |
GetTargetChangeTableInfo()
New instance of TargetChangeTableInfo: A single field change.
Declaration
public static TargetChangeTableInfo GetTargetChangeTableInfo()Returns
| Type | Description |
|---|---|
| TargetChangeTableInfo |
GetTargetDimensionTableInfo()
New instance of TargetDimensionTableInfo: Defining target dimension
Declaration
public static TargetDimensionTableInfo GetTargetDimensionTableInfo()Returns
| Type | Description |
|---|---|
| TargetDimensionTableInfo |
GetTargetGroupTableInfo()
New instance of TargetGroupTableInfo: Info about a set of (sales, project, selection...) targets
Declaration
public static TargetGroupTableInfo GetTargetGroupTableInfo()Returns
| Type | Description |
|---|---|
| TargetGroupTableInfo |
GetTargetPeriodTableInfo()
New instance of TargetPeriodTableInfo: A set of periods linked with target amounts for users/usergroups and the target groups/years.
Declaration
public static TargetPeriodTableInfo GetTargetPeriodTableInfo()Returns
| Type | Description |
|---|---|
| TargetPeriodTableInfo |
GetTargetRevisionHistoryTableInfo()
New instance of TargetRevisionHistoryTableInfo: Revision history info in case the original target group or assignment info was deleted
Declaration
public static TargetRevisionHistoryTableInfo GetTargetRevisionHistoryTableInfo()Returns
| Type | Description |
|---|---|
| TargetRevisionHistoryTableInfo |
GetTargetRevisionTableInfo()
New instance of TargetRevisionTableInfo: One batch of changes made to targets
Declaration
public static TargetRevisionTableInfo GetTargetRevisionTableInfo()Returns
| Type | Description |
|---|---|
| TargetRevisionTableInfo |
GetTaskGroupLinkTableInfo()
New instance of TaskGroupLinkTableInfo: User group link table for Task, for MDO item hiding
Declaration
public static TaskGroupLinkTableInfo GetTaskGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| TaskGroupLinkTableInfo |
GetTaskHeadingLinkTableInfo()
New instance of TaskHeadingLinkTableInfo: Heading link table for Task, for MDO headers
Declaration
public static TaskHeadingLinkTableInfo GetTaskHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| TaskHeadingLinkTableInfo |
GetTaskMenuGroupLinkTableInfo()
New instance of TaskMenuGroupLinkTableInfo: User group link table for TaskMenu, for MDO item hiding
Declaration
public static TaskMenuGroupLinkTableInfo GetTaskMenuGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| TaskMenuGroupLinkTableInfo |
GetTaskMenuHeadingLinkTableInfo()
New instance of TaskMenuHeadingLinkTableInfo: Heading link table for TaskMenu, for MDO headers
Declaration
public static TaskMenuHeadingLinkTableInfo GetTaskMenuHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| TaskMenuHeadingLinkTableInfo |
GetTaskMenuTableInfo()
New instance of TaskMenuTableInfo: List items to merge into menues
Declaration
public static TaskMenuTableInfo GetTaskMenuTableInfo()Returns
| Type | Description |
|---|---|
| TaskMenuTableInfo |
GetTaskTableInfo()
New instance of TaskTableInfo: Task list table, activity types, like Phone, Meeting
Declaration
public static TaskTableInfo GetTaskTableInfo()Returns
| Type | Description |
|---|---|
| TaskTableInfo |
GetTempDbLockTableInfo()
New instance of TempDbLockTableInfo: Represents a temporary lock on a resource identified by table_id and key
Declaration
public static TempDbLockTableInfo GetTempDbLockTableInfo()Returns
| Type | Description |
|---|---|
| TempDbLockTableInfo |
GetTemporaryKeyTableInfo()
New instance of TemporaryKeyTableInfo: Temporary keys for lightweight authentications such as changing ones subscriptions
Declaration
public static TemporaryKeyTableInfo GetTemporaryKeyTableInfo()Returns
| Type | Description |
|---|---|
| TemporaryKeyTableInfo |
GetTemporaryWordsTableInfo()
New instance of TemporaryWordsTableInfo: This table is used as a temporary table, containing the words we want to search for in the FAQs
Declaration
public static TemporaryWordsTableInfo GetTemporaryWordsTableInfo()Returns
| Type | Description |
|---|---|
| TemporaryWordsTableInfo |
GetTextTableInfo()
New instance of TextTableInfo: Long text fields from all over the system
Declaration
public static TextTableInfo GetTextTableInfo()Returns
| Type | Description |
|---|---|
| TextTableInfo |
GetTicketAlertTableInfo()
New instance of TicketAlertTableInfo: This table will contain ticket escalation levels. A ticket will be escalated along a 'chain' of these levels.
Declaration
public static TicketAlertTableInfo GetTicketAlertTableInfo()Returns
| Type | Description |
|---|---|
| TicketAlertTableInfo |
GetTicketAttachmentTableInfo()
New instance of TicketAttachmentTableInfo: This table connects an attachment to a message. It references the entry in the attachment table, and the message.
Declaration
public static TicketAttachmentTableInfo GetTicketAttachmentTableInfo()Returns
| Type | Description |
|---|---|
| TicketAttachmentTableInfo |
GetTicketCustomersTableInfo()
New instance of TicketCustomersTableInfo: This table allows several customers to be connected to several tickets (many-to-many)
Declaration
public static TicketCustomersTableInfo GetTicketCustomersTableInfo()Returns
| Type | Description |
|---|---|
| TicketCustomersTableInfo |
GetTicketLogActionTableInfo()
New instance of TicketLogActionTableInfo: This table contains actions for the tickets.
Declaration
public static TicketLogActionTableInfo GetTicketLogActionTableInfo()Returns
| Type | Description |
|---|---|
| TicketLogActionTableInfo |
GetTicketLogChangeTableInfo()
New instance of TicketLogChangeTableInfo: This table contains log entries for the tickets.
Declaration
public static TicketLogChangeTableInfo GetTicketLogChangeTableInfo()Returns
| Type | Description |
|---|---|
| TicketLogChangeTableInfo |
GetTicketLogTableInfo()
New instance of TicketLogTableInfo: This table contains log entries for the tickets.
Declaration
public static TicketLogTableInfo GetTicketLogTableInfo()Returns
| Type | Description |
|---|---|
| TicketLogTableInfo |
GetTicketPriorityTableInfo()
New instance of TicketPriorityTableInfo: This table contains the ticket priorities.
Declaration
public static TicketPriorityTableInfo GetTicketPriorityTableInfo()Returns
| Type | Description |
|---|---|
| TicketPriorityTableInfo |
GetTicketRelDefTicketTypeTableInfo()
New instance of TicketRelDefTicketTypeTableInfo: Link table defining what Ticket types are involved in this relation. Will have M:N rows for a single relation definition
Declaration
public static TicketRelDefTicketTypeTableInfo GetTicketRelDefTicketTypeTableInfo()Returns
| Type | Description |
|---|---|
| TicketRelDefTicketTypeTableInfo |
GetTicketRelationDefTableInfo()
New instance of TicketRelationDefTableInfo: Ticket relation definition
Declaration
public static TicketRelationDefTableInfo GetTicketRelationDefTableInfo()Returns
| Type | Description |
|---|---|
| TicketRelationDefTableInfo |
GetTicketRelationTableInfo()
New instance of TicketRelationTableInfo: A relation between 2 tickets
Declaration
public static TicketRelationTableInfo GetTicketRelationTableInfo()Returns
| Type | Description |
|---|---|
| TicketRelationTableInfo |
GetTicketStatusHistoryTableInfo()
New instance of TicketStatusHistoryTableInfo: 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 static TicketStatusHistoryTableInfo GetTicketStatusHistoryTableInfo()Returns
| Type | Description |
|---|---|
| TicketStatusHistoryTableInfo |
GetTicketStatusTableInfo()
New instance of TicketStatusTableInfo: This table user defined ticket status values.
Declaration
public static TicketStatusTableInfo GetTicketStatusTableInfo()Returns
| Type | Description |
|---|---|
| TicketStatusTableInfo |
GetTicketTableInfo()
New instance of TicketTableInfo: This table contains the tickets (requests) of the system. Its purpose should be evident.
Declaration
public static TicketTableInfo GetTicketTableInfo()Returns
| Type | Description |
|---|---|
| TicketTableInfo |
GetTicketTypePriorityTableInfo()
New instance of TicketTypePriorityTableInfo: Link table defining what Priorities are relevant to a particular Ticket type
Declaration
public static TicketTypePriorityTableInfo GetTicketTypePriorityTableInfo()Returns
| Type | Description |
|---|---|
| TicketTypePriorityTableInfo |
GetTicketTypeStatusTableInfo()
New instance of TicketTypeStatusTableInfo: Link table defining what Statuses are relevant to a particular Ticket type
Declaration
public static TicketTypeStatusTableInfo GetTicketTypeStatusTableInfo()Returns
| Type | Description |
|---|---|
| TicketTypeStatusTableInfo |
GetTicketTypeTableInfo()
New instance of TicketTypeTableInfo: A ticket (request) type
Declaration
public static TicketTypeTableInfo GetTicketTypeTableInfo()Returns
| Type | Description |
|---|---|
| TicketTypeTableInfo |
GetTimeKeepingTableInfo()
New instance of TimeKeepingTableInfo: Time keeping for how much time a sale or project or other entity has spent in a given stage or other state
Declaration
public static TimeKeepingTableInfo GetTimeKeepingTableInfo()Returns
| Type | Description |
|---|---|
| TimeKeepingTableInfo |
GetTimestampsTableInfo()
New instance of TimestampsTableInfo: Timestamp information
Declaration
public static TimestampsTableInfo GetTimestampsTableInfo()Returns
| Type | Description |
|---|---|
| TimestampsTableInfo |
GetTravelCurrentTableInfo()
New instance of TravelCurrentTableInfo: Information about this database and its place in the hierarchy
Declaration
public static TravelCurrentTableInfo GetTravelCurrentTableInfo()Returns
| Type | Description |
|---|---|
| TravelCurrentTableInfo |
GetTravelGeneratedDatabaseTableInfo()
New instance of TravelGeneratedDatabaseTableInfo: Information about all databases generated from this database
Declaration
public static TravelGeneratedDatabaseTableInfo GetTravelGeneratedDatabaseTableInfo()Returns
| Type | Description |
|---|---|
| TravelGeneratedDatabaseTableInfo |
GetTravelGeneratedTransactionTableInfo()
New instance of TravelGeneratedTransactionTableInfo: 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 static TravelGeneratedTransactionTableInfo GetTravelGeneratedTransactionTableInfo()Returns
| Type | Description |
|---|---|
| TravelGeneratedTransactionTableInfo |
GetTravelIDMappingTableInfo()
New instance of TravelIDMappingTableInfo: 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 static TravelIDMappingTableInfo GetTravelIDMappingTableInfo()Returns
| Type | Description |
|---|---|
| TravelIDMappingTableInfo |
GetTravelTransactionLogTableInfo()
New instance of TravelTransactionLogTableInfo: Log of all updates made to the database, that need to be replicated.
Declaration
public static TravelTransactionLogTableInfo GetTravelTransactionLogTableInfo()Returns
| Type | Description |
|---|---|
| TravelTransactionLogTableInfo |
GetTravellerTableInfo()
New instance of TravellerTableInfo: Associates traveling out from this database
Declaration
public static TravellerTableInfo GetTravellerTableInfo()Returns
| Type | Description |
|---|---|
| TravellerTableInfo |
GetTrayAppTableInfo()
New instance of TrayAppTableInfo: Tray application presence. SuperOffice CRM web extensions.
Declaration
public static TrayAppTableInfo GetTrayAppTableInfo()Returns
| Type | Description |
|---|---|
| TrayAppTableInfo |
GetTreeExplorerEntryTableInfo()
New instance of TreeExplorerEntryTableInfo: This table stores the entries in a tree-explorer
Declaration
public static TreeExplorerEntryTableInfo GetTreeExplorerEntryTableInfo()Returns
| Type | Description |
|---|---|
| TreeExplorerEntryTableInfo |
GetTreeExplorerLinkTableInfo()
New instance of TreeExplorerLinkTableInfo: This table stores the link of entries in a tree-explorer
Declaration
public static TreeExplorerLinkTableInfo GetTreeExplorerLinkTableInfo()Returns
| Type | Description |
|---|---|
| TreeExplorerLinkTableInfo |
GetTypicalSearchTableInfo()
New instance of TypicalSearchTableInfo: Owner of a set of predefined selection criteria
Declaration
public static TypicalSearchTableInfo GetTypicalSearchTableInfo()Returns
| Type | Description |
|---|---|
| TypicalSearchTableInfo |
GetUDAppntLargeTableInfo()
New instance of UDAppntLargeTableInfo: User-defined fields
Declaration
public static UDAppntLargeTableInfo GetUDAppntLargeTableInfo()Returns
| Type | Description |
|---|---|
| UDAppntLargeTableInfo |
GetUDAppntSmallTableInfo()
New instance of UDAppntSmallTableInfo: User-defined fields
Declaration
public static UDAppntSmallTableInfo GetUDAppntSmallTableInfo()Returns
| Type | Description |
|---|---|
| UDAppntSmallTableInfo |
GetUDContactLargeTableInfo()
New instance of UDContactLargeTableInfo: User-defined fields for contact (long strings)
Declaration
public static UDContactLargeTableInfo GetUDContactLargeTableInfo()Returns
| Type | Description |
|---|---|
| UDContactLargeTableInfo |
GetUDContactSmallTableInfo()
New instance of UDContactSmallTableInfo: User-defined fields for contact
Declaration
public static UDContactSmallTableInfo GetUDContactSmallTableInfo()Returns
| Type | Description |
|---|---|
| UDContactSmallTableInfo |
GetUDDocLargeTableInfo()
New instance of UDDocLargeTableInfo: User-defined fields
Declaration
public static UDDocLargeTableInfo GetUDDocLargeTableInfo()Returns
| Type | Description |
|---|---|
| UDDocLargeTableInfo |
GetUDDocSmallTableInfo()
New instance of UDDocSmallTableInfo: User-defined fields
Declaration
public static UDDocSmallTableInfo GetUDDocSmallTableInfo()Returns
| Type | Description |
|---|---|
| UDDocSmallTableInfo |
GetUDListDefinitionTableInfo()
New instance of UDListDefinitionTableInfo: 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 static UDListDefinitionTableInfo GetUDListDefinitionTableInfo()Returns
| Type | Description |
|---|---|
| UDListDefinitionTableInfo |
GetUDListGroupLinkTableInfo()
New instance of UDListGroupLinkTableInfo: 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 static UDListGroupLinkTableInfo GetUDListGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| UDListGroupLinkTableInfo |
GetUDListHeadingLinkTableInfo()
New instance of UDListHeadingLinkTableInfo: 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 static UDListHeadingLinkTableInfo GetUDListHeadingLinkTableInfo()Returns
| Type | Description |
|---|---|
| UDListHeadingLinkTableInfo |
GetUDListTableInfo()
New instance of UDListTableInfo: 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 static UDListTableInfo GetUDListTableInfo()Returns
| Type | Description |
|---|---|
| UDListTableInfo |
GetUDPersonLargeTableInfo()
New instance of UDPersonLargeTableInfo: User-defined fields
Declaration
public static UDPersonLargeTableInfo GetUDPersonLargeTableInfo()Returns
| Type | Description |
|---|---|
| UDPersonLargeTableInfo |
GetUDPersonSmallTableInfo()
New instance of UDPersonSmallTableInfo: User-defined fields
Declaration
public static UDPersonSmallTableInfo GetUDPersonSmallTableInfo()Returns
| Type | Description |
|---|---|
| UDPersonSmallTableInfo |
GetUDProjectLargeTableInfo()
New instance of UDProjectLargeTableInfo: User-defined fields. During conversion of user defined fields the data is stored in this table.
Declaration
public static UDProjectLargeTableInfo GetUDProjectLargeTableInfo()Returns
| Type | Description |
|---|---|
| UDProjectLargeTableInfo |
GetUDProjectSmallTableInfo()
New instance of UDProjectSmallTableInfo: User-defined fields
Declaration
public static UDProjectSmallTableInfo GetUDProjectSmallTableInfo()Returns
| Type | Description |
|---|---|
| UDProjectSmallTableInfo |
GetUDSaleLargeTableInfo()
New instance of UDSaleLargeTableInfo: User-defined fields
Declaration
public static UDSaleLargeTableInfo GetUDSaleLargeTableInfo()Returns
| Type | Description |
|---|---|
| UDSaleLargeTableInfo |
GetUDSaleSmallTableInfo()
New instance of UDSaleSmallTableInfo: User-defined fields
Declaration
public static UDSaleSmallTableInfo GetUDSaleSmallTableInfo()Returns
| Type | Description |
|---|---|
| UDSaleSmallTableInfo |
GetUDTempLargeTableInfo()
New instance of UDTempLargeTableInfo: User-defined fields
Declaration
public static UDTempLargeTableInfo GetUDTempLargeTableInfo()Returns
| Type | Description |
|---|---|
| UDTempLargeTableInfo |
GetUDTempSmallTableInfo()
New instance of UDTempSmallTableInfo: User-defined fields. During conversion of user defined fields the data is stored in this table.
Declaration
public static UDTempSmallTableInfo GetUDTempSmallTableInfo()Returns
| Type | Description |
|---|---|
| UDTempSmallTableInfo |
GetUDefFieldGLTableInfo()
New instance of UDefFieldGLTableInfo: User group link table for UDefField, for MDO item hiding
Declaration
public static UDefFieldGLTableInfo GetUDefFieldGLTableInfo()Returns
| Type | Description |
|---|---|
| UDefFieldGLTableInfo |
GetUDefFieldTableInfo()
New instance of UDefFieldTableInfo: 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 static UDefFieldTableInfo GetUDefFieldTableInfo()Returns
| Type | Description |
|---|---|
| UDefFieldTableInfo |
GetURLTableInfo()
New instance of URLTableInfo: Unified Resource Locators, URL to contacts, persons or projects.
Declaration
public static URLTableInfo GetURLTableInfo()Returns
| Type | Description |
|---|---|
| URLTableInfo |
GetUsageStatsTableInfo()
New instance of UsageStatsTableInfo: Usage statistics
Declaration
public static UsageStatsTableInfo GetUsageStatsTableInfo()Returns
| Type | Description |
|---|---|
| UsageStatsTableInfo |
GetUserAttributeTableInfo()
New instance of UserAttributeTableInfo: This table is used for storing various attributes for users.
Declaration
public static UserAttributeTableInfo GetUserAttributeTableInfo()Returns
| Type | Description |
|---|---|
| UserAttributeTableInfo |
GetUserCandidateTableInfo()
New instance of UserCandidateTableInfo: This table will hold user candidate secrets
Declaration
public static UserCandidateTableInfo GetUserCandidateTableInfo()Returns
| Type | Description |
|---|---|
| UserCandidateTableInfo |
GetUserGroupLinkTableInfo()
New instance of UserGroupLinkTableInfo: 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 static UserGroupLinkTableInfo GetUserGroupLinkTableInfo()Returns
| Type | Description |
|---|---|
| UserGroupLinkTableInfo |
GetUserGroupTableInfo()
New instance of UserGroupTableInfo: Secondary user groups
Declaration
public static UserGroupTableInfo GetUserGroupTableInfo()Returns
| Type | Description |
|---|---|
| UserGroupTableInfo |
GetUserPreferenceTableInfo()
New instance of UserPreferenceTableInfo: Preference system. If deflevel is set to 5; the user may change the preferences
Declaration
public static UserPreferenceTableInfo GetUserPreferenceTableInfo()Returns
| Type | Description |
|---|---|
| UserPreferenceTableInfo |
GetUserRoleLinkTableInfo()
New instance of UserRoleLinkTableInfo: Link between user role and user
Declaration
public static UserRoleLinkTableInfo GetUserRoleLinkTableInfo()Returns
| Type | Description |
|---|---|
| UserRoleLinkTableInfo |
GetUtmParametersTableInfo()
New instance of UtmParametersTableInfo: Table for utm parameters collected from visits and formsubmissions
Declaration
public static UtmParametersTableInfo GetUtmParametersTableInfo()Returns
| Type | Description |
|---|---|
| UtmParametersTableInfo |
GetVisibleForTableInfo()
New instance of VisibleForTableInfo: Visible for rights, who may see this appointment/document, sale, salehist or selection
Declaration
public static VisibleForTableInfo GetVisibleForTableInfo()Returns
| Type | Description |
|---|---|
| VisibleForTableInfo |
GetWebAppUsageTableInfo()
New instance of WebAppUsageTableInfo: Usage statistics for web applications
Declaration
public static WebAppUsageTableInfo GetWebAppUsageTableInfo()Returns
| Type | Description |
|---|---|
| WebAppUsageTableInfo |
GetWebhookTableInfo()
New instance of WebhookTableInfo: Webhook URL to call when events occur in the client or in NetServer. Also tracks call+error statistics.
Declaration
public static WebhookTableInfo GetWebhookTableInfo()Returns
| Type | Description |
|---|---|
| WebhookTableInfo |
GetWebhookUsageTableInfo()
New instance of WebhookUsageTableInfo: Webhook usage statistics - tracks call+error statistics. Same primary key as the webhook.
Declaration
public static WebhookUsageTableInfo GetWebhookUsageTableInfo()Returns
| Type | Description |
|---|---|
| WebhookUsageTableInfo |
GetWinPosSizeTableInfo()
New instance of WinPosSizeTableInfo: Stores the position and size of each window, so they can be shown in the same place again
Declaration
public static WinPosSizeTableInfo GetWinPosSizeTableInfo()Returns
| Type | Description |
|---|---|
| WinPosSizeTableInfo |
GetWordRelationsTableInfo()
New instance of WordRelationsTableInfo: This table shows which word are used in which FAQ entry, and how many times they are used in each
Declaration
public static WordRelationsTableInfo GetWordRelationsTableInfo()Returns
| Type | Description |
|---|---|
| WordRelationsTableInfo |
GetWorkflowGoalTableInfo()
New instance of WorkflowGoalTableInfo: 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 static WorkflowGoalTableInfo GetWorkflowGoalTableInfo()Returns
| Type | Description |
|---|---|
| WorkflowGoalTableInfo |
GetWorkflowInstanceTableInfo()
New instance of WorkflowInstanceTableInfo: A set of properties related to the workflow instance of one participant going through the flow
Declaration
public static WorkflowInstanceTableInfo GetWorkflowInstanceTableInfo()Returns
| Type | Description |
|---|---|
| WorkflowInstanceTableInfo |
GetWorkflowRootStepLinkTableInfo()
New instance of WorkflowRootStepLinkTableInfo: Link root steps to the workflow
Declaration
public static WorkflowRootStepLinkTableInfo GetWorkflowRootStepLinkTableInfo()Returns
| Type | Description |
|---|---|
| WorkflowRootStepLinkTableInfo |
GetWorkflowStepOptionLinkTableInfo()
New instance of WorkflowStepOptionLinkTableInfo: Link steps to other steps through step options
Declaration
public static WorkflowStepOptionLinkTableInfo GetWorkflowStepOptionLinkTableInfo()Returns
| Type | Description |
|---|---|
| WorkflowStepOptionLinkTableInfo |
GetWorkflowStepOptionTableInfo()
New instance of WorkflowStepOptionTableInfo: Some steps can have optional child 'flows', a new series of steps
Declaration
public static WorkflowStepOptionTableInfo GetWorkflowStepOptionTableInfo()Returns
| Type | Description |
|---|---|
| WorkflowStepOptionTableInfo |
GetWorkflowStepTableInfo()
New instance of WorkflowStepTableInfo: A set of steps related to a workflow.
Declaration
public static WorkflowStepTableInfo GetWorkflowStepTableInfo()Returns
| Type | Description |
|---|---|
| WorkflowStepTableInfo |
GetWorkflowTableInfo()
New instance of WorkflowTableInfo: SuperOffice specific info about a workflow
Declaration
public static WorkflowTableInfo GetWorkflowTableInfo()Returns
| Type | Description |
|---|---|
| WorkflowTableInfo |
GetWorkflowTriggerTableInfo()
New instance of WorkflowTriggerTableInfo: A set of triggers related to a workflow.
Declaration
public static WorkflowTriggerTableInfo GetWorkflowTriggerTableInfo()Returns
| Type | Description |
|---|---|
| WorkflowTriggerTableInfo |
GetWorkflowWaitForActionTableInfo()
New instance of WorkflowWaitForActionTableInfo: Some steps wait for actions, this is info about those actions
Declaration
public static WorkflowWaitForActionTableInfo GetWorkflowWaitForActionTableInfo()Returns
| Type | Description |
|---|---|
| WorkflowWaitForActionTableInfo |
GetWsdlDescriptionTableInfo()
New instance of WsdlDescriptionTableInfo: Soap wsdl files
Declaration
public static WsdlDescriptionTableInfo GetWsdlDescriptionTableInfo()Returns
| Type | Description |
|---|---|
| WsdlDescriptionTableInfo |
GetZipToCityTableInfo()
New instance of ZipToCityTableInfo: 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 static ZipToCityTableInfo GetZipToCityTableInfo()Returns
| Type | Description |
|---|---|
| ZipToCityTableInfo |