MDO List Providers

List of MDO table names

Provider NameImplemented by Class
AmountClassMDO List for database table ID: Table id 225. amountclass.tooltip
AssociateMDO List for database table ID: Table id 2. associate.tooltip
BusinessMDO List for database table ID: Table id 61. business.tooltip
CategoryMDO List for database table ID: Table id 64. category.tooltip
ComptrMDO List for database table ID: Table id 109. comptr.tooltip
ContIntMDO List for database table ID: Table id 70. contint.tooltip
CountryMDO List for database table ID: Table id 19. country.tooltip
CreditedMDO List for database table ID: Table id 97. credited.tooltip
CurrencyMDO List for database table ID: Table id 112. currency.tooltip
DeliveryTermsMDO List for database table ID: Table id 433. deliveryterms.tooltip
DeliveryTypeMDO List for database table ID: Table id 436. deliverytype.tooltip
DocTmplMDO List for database table ID: Table id 130. doctmpl.tooltip
ExtAppMDO List for database table ID: Table id 133. extapp.tooltip
IntentMDO List for database table ID: Table id 216. intent.tooltip
MrMrsMDO List for database table ID: Table id 94. mrmrs.tooltip
PaymentTermsMDO List for database table ID: Table id 427. paymentterms.tooltip
PaymentTypeMDO List for database table ID: Table id 430. paymenttype.tooltip
PersIntMDO List for database table ID: Table id 73. persint.tooltip
PersPosMDO List for database table ID: Table id 76. perspos.tooltip
PMembTypeMDO List for database table ID: Table id 91. pmembtype.tooltip
PriceUnitMDO List for database table ID: Table id 439. priceunit.tooltip
PriorityMDO List for database table ID: Table id 79. priority.tooltip
ProbMDO List for database table ID: Table id 82. prob.tooltip
ProductCategoryMDO List for database table ID: Table id 408. productcategory.tooltip
ProductFamilyMDO List for database table ID: Table id 411. productfamily.tooltip
ProductTypeMDO List for database table ID: Table id 414. producttype.tooltip
ProjStatusMDO List for database table ID: Table id 88. projstatus.tooltip
ProjTypeMDO List for database table ID: Table id 85. projtype.tooltip
QuoteApprReasonMDO List for database table ID: Table id 504. quoteapprreason.tooltip
QuoteDenyReasonMDO List for database table ID: Table id 507. quotedenyreason.tooltip
ReasonMDO List for database table ID: Table id 103. reason.tooltip
ReasonSoldMDO List for database table ID: Table id 115. reasonsold.tooltip
ReasonStalledMDO List for database table ID: Table id 154. reasonstalled.tooltip
RejectReasonMDO List for database table ID: Table id 222. rejectreason.tooltip
RelationdefinitionMDO List for database table ID: Table id 48. relationdefinition.tooltip
SaleTypeMDO List for database table ID: Table id 149. saletype.tooltip
SaleTypeCatMDO List for database table ID: Table id 118. saletypecat.tooltip
SalutationMDO List for database table ID: Table id 219. salutation.tooltip
SearchCatMDO List for database table ID: Table id 106. searchcat.tooltip
SourceMDO List for database table ID: Table id 100. source.tooltip
StakeholderRoleMDO List for database table ID: Table id 122. stakeholderrole.tooltip
SubscriptionUnitMDO List for database table ID: Table id 442. subscriptionunit.tooltip
TagsMDO List for database table ID: Table id 488. tags.tooltip
TaskMDO List for database table ID: Table id 67. task.tooltip
TaskMenuMDO List for database table ID: Table id 520. taskmenu.tooltip
UDListMDO List for database table ID: Table id 136. udlist.tooltip

List of other valid MDO providers

Provider NameImplemented by Class
activelanguage
activitystatusMDO provider for the ActivityStatus enum: NotStarted, Started, Completed
addressformatMDO list provider for AddressFormats Id returned is the layout_id, not the addressformat_id.
allpersonsearchProvider for selecting a Person, including search on contacts that match as well as persons. This provider wil
allpersonwithassociatesearchProvides the same baseline functionality as , but additionally adds the associateId of the person to the extrainf
allpreferencekeysMDO Provider that retrieves all preference keys
amountclassGenericMDOProvider reads MDO lists with default settings
appointment
appointmentcategory
appointmentcautionwarningAppointment.CautionWarning. Appointment and invitation synchronization info
appointmentcompletedAppointment completed statuses: AppointmentStatus.NotStarted, AppointmentStatus.Completed
appointmentfavouriteMDO list provider for Favourites
appointmentgroupAppointment grouping types: TaskType.Appointment, Phone, ToDo
appointmentresource
appointmenttaskMDO list provider for the task list of the AppointmentDialog. This list extends the basic wit
appointmenttextidSpecial case of appointment list where we get the id value from the Text table. For use when we wan
appointmenttypeList of AppointmentType values: inDiary, inChecklist, Note, Document, SavedReport, BookingForDiary, BookingForChecklist
archiveproviderMDO provider for available archive providers for Configurable screens
areaList of all defined areas.
associaterestrictionsPublic MDO provider based on the AssociateRestrictionsMDOProviderBase.
associatewithmail
attachment
businessGenericMDOProvider reads MDO lists with default settings
categoryGenericMDOProvider reads MDO lists with default settings
categorygroupMDO provider for the WorkflowGoalType enum
chartselection
chatbotList of all script folders that contain a script named like “%bot%register%“
chatchannel
chatservice
chatsessionstatusChat session status values
chatuser
colorindexList of named colors from the “ColorIndex” enum
combinedcontactpersonsearchConsider using the ContactAndPersonListFreetextSearchProvider/“contact_and_person_freetextsearch” MDO list instead of this one
comptrGenericMDOProvider reads MDO lists with default settings
consentpurposeMDO list provider for ConsentPurpose
consentsourceMDO list provider for Consent source
contactProvider for selecting a Contact - without person search
contactfavouriteMDO list provider for Favourites
contactperson_freetextsearchProvider for selecting a Contact - with person search
contactphone
contactrelationdefinitionMDO list provider for contact/person relation definitions. This provider is a takes a mandator
contactwithpersonsearchProvider for selecting a Contact, including search on persons that match as well as contacts. this provider wil
contactwithpersonsearch_newProvider for selecting a Contact, including search on persons that match as well as contacts. this provider wil
contact_and_person_freetextsearchProvider for selecting a Contact or a Perso
contact_and_person_freetextsearch_hierarchical
contact_freetextsearchProvider for selecting a Contact - without person search
contact_newProvider for selecting a Contact - without person search
contintGenericMDOProvider reads MDO lists with default settings
country2Same as CountryProvider, but with icon hints based on the countrys name.
createdocumenttemplatepluginList of document plugins that can create document templates.
credentialgroupList of user groups supported by a named creditial plugin, sorted by group name.
creditedGenericMDOProvider reads MDO lists with default settings
crmfields
crmscriptArchive of CRMScripts. Returns script id + name of script as hierarchy.
culture
culturesolanguageList of SuperOffice cultures with old-style SO Culture name in ExtraInfo
currencyGenericMDOProvider reads MDO lists with default settings
currentudeffieldsGet a list of udef fields for a given type. Pass the type as AdditionalInfo
customerlanguageCustomer Languages list. From the CustLang table.
customobjectfavourite
customobjectlist creates tree list of the custom objects
customobjectrelationMDO list provider for custom object relation
dashboardMDO list provider for Dashboard, can be used by Navigator.
dashboardcurrency
dashboardentity
dashboardtheme
dashboardtileMDO list provider for Dashboard tile
dashboardtileentitytypeList of dashboard tile types: Company, Project, Sale, Product, Activity, Web Panel
dashtilemeasure
dayofmonthMDO provider for the hard-coded list of day alternatives in the recurrence dialog.
deliverytermsGenericMDOProvider reads MDO lists with default settings
deliverytypeGenericMDOProvider reads MDO lists with default settings
diaryownerList provider that returns diary owners, i.e., our own employees plus resources
directionDocument and Task directions: TaskDirection.Incoming, Outgoing
disconnectpersonactionsList of actions to perform when disconnecting a contact from a company
doctmplGenericMDOProvider reads MDO lists with default settings
documentMDO list provider for documents.
documentcategory
documentcompletedDocument completed status list: Not done, Done.
documentfavouriteMDO list provider for Favourites
documentgroupDocument types: TaskType.Document, Email, Fax, Merge draft, Merge Final.
documenthandler
documentmailingDocument shipments (mail merges).
documentmailingtemplateDocument mailing templates
documenttemplatelanguageMDO Provider for Document Template langauges.
documenttemplatesfilteredMDO Provider for Document Templates, excluding Document details and quote mail templates, which are for system use rather than end-user choosing.
documenttypesList of document types for the given plugin
efd_13Extra fields dropdown lists. Contains list of string values defined on the extra_field
ejcategoryEjCategoryProvider creates a flat or tree list based on the table: EJ_CATEGORY
ejuser
emailaddressList of e-mail addresses matching the search valu
emailflowList provider for EmailFlow
emailfolderEmailFolderProvider gives you the folder hierarchy of a given mail account
emailfromtypeMDO provider for the EmailFromType enum
emailphoneList of e-mail addresses and phone numbers matching the search valu
emailreplytotypeMDO provider for the EmailReplyToType enum
enrichcontactList of possible contacts to import from outside sources.
erpactortype
erpconnectionsRetrieve the list of all defined Erp Connections (not Connectors, that’s another list)
erpconnectorsRetrieve the list of all defined Erp Connectors (not Connections, that’s another list)
erpdeliveryterms
erpdeliverytype
erpfields
erppaymentterms
erppaymenttype
erpproductcategory
erpproductfamily
erpproducttype
eventhandlertypeScreen trigger event types: members of enum.
everymonthMDO provider for the hard-coded list of day month in the recurrence dialog.
executeoneventList of windows client events to execute tasks on: Logon, Logoff, LocalUpdate
exporttemplateMDO provider for the list of template files for the ‘export to file’ functio
extappGenericMDOProvider reads MDO lists with default settings
faqcategory
faqreplytemplate
faqreplytemplatefavouriteMDO list provider for Favourites
favouritetypeMDO list provider for Favourite types
filterassociatesAssociate list for the Filter dialog. This associate list differs from the standard list in two ways
filterfuturedateMDO provider for the hard-coded list of future date alternatives in the Filter dialog
filtergroupsUser groups, filtered according to the usergroups selected in the filter dialog.
findproductQuickSearch for the Add Quote Line dialog, where a single-line user input is passed to th
fontsizeList of font types
fonttypeList of font types
formGet all forms with folder hierarchy
formfolderFormFolderProvider creates a flat or tree list based on the table: s_picture_folder
formmailings
formratingdice
formratingnps
formratingsmileys
formratingstarsMDO provider for the Ratings as used in forms
formratingthumbs
formsubmissionstatusprovider
freetextsearchentityList provider that returns the entities supported by free text search. The extraInfo field contains th
functionrightsFunctionRightsListProvider returns a MDO list of function rights in the database
genericpersonList of persons with mail. Supports Selection(any type), project and associate
genericpersonwithmailList of persons with mail. Supports Selection(any type), project and associate
groupviewGroupViewMDOProvider uses the AssociateMDOProvider + DiaryView to create the MDOlist for Groupview in Diary view.
headingList provider for the Heading table. While this table looks like an MDO table
hierarchyList provider for the Hierarchy table. Pass the domain using Additional info
htmlmailingMDO provider for the different types of Mailings
htmlmailingtemplateMDO provider for the different types of Mailing templates
importblankactionImport actions for blank values: Use Person Name, Skip
importcontactduplicatematchList of fields to match contact imports.
importduplicateactionImport Duplicate actions: Add, Merge, Replace, Skip
importduplicateactionwithoutaddImport duplicate; Merge, Replace, Skip
importfieldsMDO provider for column headers used in import
importnewlistitemImport list items: Add item, use default, use blank
importnewpositionitemImport position items: Add to list, set to blank
importnewproductlistitemImport product list items: add, use blank
importpersonduplicatematchImport Person Fields to match on: Name, E-mail, phone, number, id, None
importphoneurlsemailImport phone/url/email values: Add, Replace, Skip
importproductduplicatematchImport product detect duplicates based on field: Name, Code, Name+Code
importproductfieldsMDO provider for column headers used in import
intentGenericMDOProvider reads MDO lists with default settings
invitationtemplatelanguage
iso639language
kbentry
language
leadstatusList provider for LeadStatus
legalbaseMDO list provider for Legal base
listsList of all MDO list providers.
locatecontactProvider for selecting a Contact, including search on persons that match as well as contacts. this provider wil
locatecontact_newProvider for selecting a Contact, including search on persons that match as well as contacts. this provider wil
locatepersonPerson list with contact name.
locationImplements the mdo provider for the list of avaiable locations. This list aggregates element
mailclient
mailhtmltemplateList provider for the Mailtemplates.
mailingAll mailings - history ids
mailingdomainsMDO list provider for Mailing domains, including leading @
mailingfavouriteMDO list provider for Favourites
mailingstatus
mailingsubscriptiontypeMailing subscription types; Invitations, news, etc
mailingtemplateGeneral mailing templates
mailingtypeMailing types: Html mail, SMS, Word Document
mailtemplateList provider for the Mailtemplates.
mergedocumentMDO list provider for documents marked as type .
mergetags
monthMDO provider for the hard-coded list of “of” months in the recurrence dialog.
mrmrsGenericMDOProvider reads MDO lists with default settings
ofmonthMDO provider for the hard-coded list of “of” months in the recurrence dialog.
ownercontactMDO provider for listing owner contacts.
paymenttermsGenericMDOProvider reads MDO lists with default settings
paymenttypeGenericMDOProvider reads MDO lists with default settings
periodPeriod values: Day, Week, Month, Quarter, Year
periodsPeriod values: Day, Week, Month, Quarter, Year
persintGenericMDOProvider reads MDO lists with default settings
personList of persons from the Archive provider
personcontactfavouriteMDO list provider for Favourites
personcontact_freetextsearchProvider for selecting a Person - with contact search
personemailaddressList of e-mail addresses matching the search value, possibly restricted to a given company or person.
personfavouriteMDO list provider for Favourites
personphoneSearch phone numbers for matching values, restricted to a given company or person.
personrestrictionsImplements a person mdolist provider that uses the conflicts detector to append information o
personurlList of urls (web pages) matching the search value, possibly restricted to a given company or person.
personwithmailList of persons fetched based on provided criteri
person_freetextsearchProvider for selecting a Person - without contact search
persposGenericMDOProvider reads MDO lists with default settings
phonesearchSearch phone numbers for matching stripped numbers, across person and contacts
pluginList of installed and available Document plugins
pmembtypeGenericMDOProvider reads MDO lists with default settings
prefdesclinePrefDesc creates a MDO list of prefdesclines for a given prefdesc id.
preferencekeyMDO Provider that retrieves a list of preference keys corresponding to a given section
preferencelineitemMDO Provider for preferences that have a list of possible values in the database
preferencesectionMDO Provider that retrieves a list of preference sections
pricelistList of pricelists from the PriceList table
priceunitGenericMDOProvider reads MDO lists with default settings
priorityGenericMDOProvider reads MDO lists with default settings
privacytemplateThis is a variant of the DocTmpl list - document templates - restricted to those that are of some privacy document type.
probGenericMDOProvider reads MDO lists with default settings
productcategoryGenericMDOProvider reads MDO lists with default settings
productfamilyGenericMDOProvider reads MDO lists with default settings
productimageReturn product images from the blob table
producttypeGenericMDOProvider reads MDO lists with default settings
projectProvider for selecting a project.
projectassociateMDO provider for associates that are members of a project
projectfavouriteMDO list provider for Favourites
projectimageProject images from the blob table
projectmemberwithmail
projectstatusList of project guide steps status values.
projecttypeProject type list. Encodes Default project duration in extra info.
projecttypeflatlistProject type list. Encodes Default project duration in extra info.
project_freetextsearchProvider for selecting a Project
project_newProvider for selecting a project. Returns search results in rank orde
projstatusGenericMDOProvider reads MDO lists with default settings
projtypeGenericMDOProvider reads MDO lists with default settings
quotealternativesQuote alternative selector for one Quote Version. Send QuoteVersionId=<id> in ExtraInfo to specify quote version id
quoteapprovalassociateMDO provider for associates that are allowed to approve a quote.
quoteapproversRetrieve the list of all users that can approve quotes
quoteapprreasonGenericMDOProvider reads MDO lists with default settings
quoteconnectionsRetrieve the list of all defined Quote Connections - i.e. not the connectors (DLLs)
quoteconnectorsRetrieve the list of all installed (i.e., loaded assemblies) Quote Connectors
quotedenyreasonGenericMDOProvider reads MDO lists with default settings
quotedocumentgroupfieldsPossible choices for fields that you can GROUP BY in quote detail documents.
quotedocumentorderbyfieldsPossible choices for fields you can ORDER BY, within a group (or without grouping)
quotedocumentsMDO provider for the list of current / candidate “main document” for a given quote
quotedocumenttypeList of quote document types - assumes ExtraInfo is the name of RecordType enum value
quotelinestatusHard-coded list of values for the QuoteLine.Status field, see enum.
quotetemplateThis is a variant of the DocTmpl list - document templates - restricted to those that are of some quote document type
quoteversionQuote version selector for one Quote. Send QuoteId=<id> in ExtraInfo to specify quote id
quoteversionstateList provider for the enum
reasonGenericMDOProvider reads MDO lists with default settings
reasonsoldGenericMDOProvider reads MDO lists with default settings
reasonstalledGenericMDOProvider reads MDO lists with default settings
recipientfavouriteMDO list provider for Favourites
recordtypeA complete and generic mapping of record types to resource strings
recurrenceweekcycleMDO provider for the hard-coded list of week cycle alternatives in the recurrence dialog.
rejectreasonGenericMDOProvider reads MDO lists with default settings
relateddatafields
relationssearchlistproviderappointmentactiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistproviderappointmentappointmentactiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistproviderappointmentappointmentpassiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistproviderappointmentdocumentactiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistproviderappointmentdocumentpassiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistproviderappointmentpassiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistproviderappointmentsaleactiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistproviderappointmentsalepassiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistprovidercontactactiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistprovidercontactcontactactiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistprovidercontactcontactpassiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistprovidercontactpassiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistprovidercontactpersonactiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistprovidercontactpersonpassiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistproviderdocumentactiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistproviderdocumentappointmentactiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistproviderdocumentappointmentpassiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistproviderdocumentdocumentactiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistproviderdocumentdocumentpassiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistproviderdocumentpassiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistproviderdocumentsaleactiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistproviderdocumentsalepassiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistproviderpersonactiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistproviderpersoncontactactiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistproviderpersoncontactpassiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistproviderpersonpassiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistproviderpersonpersonactiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistproviderpersonpersonpassiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistprovidersaleactiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistprovidersaleappointmentactiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistprovidersaleappointmentpassiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistprovidersaledocumentactiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistprovidersaledocumentpassiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistprovidersalepassiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistprovidersalesaleactiveServe the active and passive texts of relations, with a given table as source (active
relationssearchlistprovidersalesalepassiveServe the active and passive texts of relations, with a given table as source (active
replytemplate
resourceMDO provider for resources (from the associate table)
resourcerestrictionsMDO provider for resources (from the associate table) that uses restrictions to includ
restrictionoperatorsThis SoList provider will generate the operator list for a given search criterion data type. The data type i
rolesRoleListProvider creates a MDO list of roles in the database
saintactivitytypeThis SoList provider generates the appointment/task type list for the Saint criteria. This is a simple, hard-coded list correspondin
saintamountclassThis SoList provider generates the amount class list for the Saint criteria. This list is an extension of the basi
saintdirectionThis SoList provider generates the appointment/task direction list for the Saint criteria. This is a simple, hard-coded list correspondin
saintintentionThis SoList provider generates the Intent list for the Saint criteria. This list is an extension of the basi
saintsalestatusThis SoList provider generates the sale status list for the Saint criteria. This is a simple, hard-coded list correspondin
saintticketcategoryThis SoList provider generates the eJournal top-level categories, meant for the saint system
saintticketstatusThis SoList provider generates the ticket status list for the Saint criteria. This is a simple, hard-coded list, special for this context
saleList of sales
salecategory
saledoneSale Done status: SaleDone.Done or NotDone.
salefavouriteMDO list provider for Favourites
saleguidestageMDO provider for the stage list, customized for the sale guide stage button row
saleprobabilityMDO list provider for the probability list of the Sale dialog. This list extends the basic list with a leadin
salesourceMDO list provider for the source list of the Sale dialog
salestageProvider for selecting a stage. AdditionalInfo is used as criteria to filter stages based on SaleType.
salestatusList for the Sale.Status field: Open, Lost, Sold, Stalled.
saletypeList of sale types, with default sale duration in minutes in extra info.
saletypecatGenericMDOProvider reads MDO lists with default settings
saletypecategoriesSaleTypeCategories creates a MDO list of sale type categories in the database.
sale_freetextsearchProvider for selecting a Sale
sale_newList of sales
salutationGenericMDOProvider reads MDO lists with default settings
satellitesSatelliteProvider creates a MDO list of satellites.
searchcatGenericMDOProvider reads MDO lists with default settings
selectionProvider for selecting a selection
selectioncriteriamembertype
selectionfavouriteMDO list provider for selection favourites
selectionmembertypeMDO provider for the selection archive providers types
selectionmembertypeclean
selectionmembertypev2MDO provider for the selection archive providers types
selectionmemberwithmailList of selection members fetched based on provided criteri
selectiontypeMDO provider for the hard-coded list of selection kinds: Static, Dynamic, Combined
selectionuniontypeDifferent ways to combine selections: Union, Intersect, Disjoin, Left or Right Subtraction.
selection_freetextsearchProvider for selecting a Selection
sentiment
serviceassociateMDO provider for associates that are allowed to approve a quote.
shipmentaddrstatusprovider
shipmentlinksCreate a list of specified mailings (flow, form, regular mailing/shipment…), hierarchy optional
shipmenttypeMDO list provider for ConsentPurpose
simplemailingstatus
smsmailingSMS Shipment names
smsmailingtemplateSMS Mailing templates
sourceGenericMDOProvider reads MDO lists with default settings
sourceproductProducts: Sales & Marketing, Customer Service
specifiedmailingsCreate a list of mailings (flow, form, regular mailing/shipment…), hierarchy optional
stakeholderroleGenericMDOProvider reads MDO lists with default settings
statusdefReturn list of status monitors defined in the system
statusmonitorimageList of images for status monitors in the blob table.
subscriptionunitGenericMDOProvider reads MDO lists with default settings
suggestedappointmentSuggested Appointment Provider creates a MDO list of suggested appointments for a given guide stage.
suggesteddocumentSuggestedDocumentProvider creates a MDO list of suggested documents in the database.
systemeventtypeSystem event types: NoLogin, NoFreeText, NoTravel, Message-of-the-day
tagsGenericMDOProvider reads MDO lists with default settings
targetentitytypeTargetEntities
targetmeasurementunitMeasurementUnits
targettypes
targetyearYear MDO list. Includes the two coming years, this year, and previous 5 years
taskTask table MDO list. Optional include “None” as first value.
taskmenuGenericMDOProvider reads MDO lists with default settings
taskmenudestination
taskmenugroupList of TaskMenus with visible for groups as commaseperated ids in extrainfo field
templatevariables
ticketProvider for selecting a ticket
ticketalert
ticketfavourite
ticketoriginTicket Origin
ticketpriorityMDO list provider for ticket priorities.
ticketpriorityescalateeventMDO list provider for ticket Priority EscalateEvents enum.
ticketread
ticketselectionwithstaticmenuProvider for selecting ticket selections
ticketslevelTicket Security Level
ticketstatusTicket status values: Open, Closed, Inactive, Deleted, Connected
ticketstatustimecounterTicket status timer count values: None, Internall, Externally, Queue
ticketstatuswithoutpostpone
ticketstatuswithpostpone
ticketticketstatusTicketTicketStatusProvider creates a flat list based on the table: TICKET_STATUS
tickettypeTicketTypeProvider creates a flat list based on the table: TICKET_TYPE
ticket_freetextsearchProvider for selecting a Ticket - with contact and person search
ticket_selection_freetextsearchProvider for selecting Ticket Selection or a Ticket
timeMDO provider for the hard-coded list of time alternatives in the appointment dialog and in edit/preference
timezone
timezoneianaProvides the timezone list
timezonewithcodeProvides the timezone list. The country code is given in the type field
typegroupType Group: Task, Activity, Document, Sale
typicalsearchMDO provider for the TypicalSearch Title, Tooltip and I
udeffieldsGet a list of udef fields for a given type
udeffieldswithchangesGet a list of udef fields for a given type
udeffieldtypeList of UDef field types for a given owner table, and possibly restricted based on the current field type
udlistMDO Provider for ‘user-defined’ lists, i.e., those that reside in the UDList table. Mandatory additionalInfo is th
udlist28Dynamic MDO provider that will create a list with the name udlist<id> for each user-defined list in the UDListDefinition table
udlist30002MDO provider for the ChatService
urlencoding
usergroupList provider for the UserGroup table. While this table looks like an MDO table
usergroupwithhistoryallList provider for the UserGroup table. While this table looks like an MDO table
userplanList provider for the UserPlan in the module license table
usertypeSimple, hard-coded provider for the associate type: Employee, ExternalPerson, Resource, Anonymous, System, Invalid User Type
visibleforList provider for the VisibleFor dropdown control. Items are of type associate, usergroup or all, wit
visibleforassociateList provider that returns a list suitable for VisibleFor and PinTo (with groups and possibly some other special items like All).
visibleinVisible in list for web panels.
visibleinmenuVisible in menu list: Toolbox menu, View menu
visibleintaskVisible in list for tasks: places where task button can appear.
webpanelList of WebPanels visible possible for use with groups and headings.
webpanelgroupList of WebPanels with visible for groups as commaseperated ids in extrainfo field
weekdayMDO provider for the hard-coded list of week days.
weeknumberMDO provider for the hard-coded list of numbered weeks in the recurrence dialog.
workflowdefinitionstatusMDO provider for the WorkflowDefinitionStatus enum
workflowgoaltypeMDO provider for the WorkflowGoalType enum
workflowinstancestatusMDO provider for the WorkflowInstanceStatus enum
workflowsplitoptiontypeMDO provider for the WorkflowTriggerType enum
workflowsteptypeMDO provider for the WorkflowStepType enum
workflowtimewaitalgorithmMDO provider for the WorkflowTimeWaitAlgorithm enum
workflowtimewaitintervaltypeMDO provider for the WorkflowTimeWaitIntervalType enum
workflowtriggertypeMDO provider for the WorkflowTriggerType enum
y_carExtra tables lists. List names are ‘y_xyz’ - based on the custom table name