> ## Documentation Index > Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt > Use this file to discover all available pages before exploring further. # MDO List Provider names > Valid list of provider names ## MDO List Providers ## List of MDO table names | Provider Name | Implemented by Class | | ------------------------------------------ | ----------------------------------------------------------------------- | | [AmountClass](./amountclass) | MDO List for database table ID: Table id 225. amountclass.tooltip | | [Associate](./associate) | MDO List for database table ID: Table id 2. associate.tooltip | | [Business](./business) | MDO List for database table ID: Table id 61. business.tooltip | | [Category](./category) | MDO List for database table ID: Table id 64. category.tooltip | | [Comptr](./comptr) | MDO List for database table ID: Table id 109. comptr.tooltip | | [ContInt](./contint) | MDO List for database table ID: Table id 70. contint.tooltip | | [Country](./country) | MDO List for database table ID: Table id 19. country.tooltip | | [Credited](./credited) | MDO List for database table ID: Table id 97. credited.tooltip | | [Currency](./currency) | MDO List for database table ID: Table id 112. currency.tooltip | | [DeliveryTerms](./deliveryterms) | MDO List for database table ID: Table id 433. deliveryterms.tooltip | | [DeliveryType](./deliverytype) | MDO List for database table ID: Table id 436. deliverytype.tooltip | | [DocTmpl](./doctmpl) | MDO List for database table ID: Table id 130. doctmpl.tooltip | | [ExtApp](./extapp) | MDO List for database table ID: Table id 133. extapp.tooltip | | [Intent](./intent) | MDO List for database table ID: Table id 216. intent.tooltip | | [MrMrs](./mrmrs) | MDO List for database table ID: Table id 94. mrmrs.tooltip | | [PaymentTerms](./paymentterms) | MDO List for database table ID: Table id 427. paymentterms.tooltip | | [PaymentType](./paymenttype) | MDO List for database table ID: Table id 430. paymenttype.tooltip | | [PersInt](./persint) | MDO List for database table ID: Table id 73. persint.tooltip | | [PersPos](./perspos) | MDO List for database table ID: Table id 76. perspos.tooltip | | [PMembType](./pmembtype) | MDO List for database table ID: Table id 91. pmembtype.tooltip | | [PriceUnit](./priceunit) | MDO List for database table ID: Table id 439. priceunit.tooltip | | [Priority](./priority) | MDO List for database table ID: Table id 79. priority.tooltip | | [Prob](./prob) | MDO List for database table ID: Table id 82. prob.tooltip | | [ProductCategory](./productcategory) | MDO List for database table ID: Table id 408. productcategory.tooltip | | [ProductFamily](./productfamily) | MDO List for database table ID: Table id 411. productfamily.tooltip | | [ProductType](./producttype) | MDO List for database table ID: Table id 414. producttype.tooltip | | [ProjStatus](./projstatus) | MDO List for database table ID: Table id 88. projstatus.tooltip | | [ProjType](./projtype) | MDO List for database table ID: Table id 85. projtype.tooltip | | [QuoteApprReason](./quoteapprreason) | MDO List for database table ID: Table id 504. quoteapprreason.tooltip | | [QuoteDenyReason](./quotedenyreason) | MDO List for database table ID: Table id 507. quotedenyreason.tooltip | | [Reason](./reason) | MDO List for database table ID: Table id 103. reason.tooltip | | [ReasonSold](./reasonsold) | MDO List for database table ID: Table id 115. reasonsold.tooltip | | [ReasonStalled](./reasonstalled) | MDO List for database table ID: Table id 154. reasonstalled.tooltip | | [RejectReason](./rejectreason) | MDO List for database table ID: Table id 222. rejectreason.tooltip | | [Relationdefinition](./relationdefinition) | MDO List for database table ID: Table id 48. relationdefinition.tooltip | | [SaleType](./saletype) | MDO List for database table ID: Table id 149. saletype.tooltip | | [SaleTypeCat](./saletypecat) | MDO List for database table ID: Table id 118. saletypecat.tooltip | | [Salutation](./salutation) | MDO List for database table ID: Table id 219. salutation.tooltip | | [SearchCat](./searchcat) | MDO List for database table ID: Table id 106. searchcat.tooltip | | [Source](./source) | MDO List for database table ID: Table id 100. source.tooltip | | [StakeholderRole](./stakeholderrole) | MDO List for database table ID: Table id 122. stakeholderrole.tooltip | | [SubscriptionUnit](./subscriptionunit) | MDO List for database table ID: Table id 442. subscriptionunit.tooltip | | [Tags](./tags) | MDO List for database table ID: Table id 488. tags.tooltip | | [Task](./task) | MDO List for database table ID: Table id 67. task.tooltip | | [TaskMenu](./taskmenu) | MDO List for database table ID: Table id 520. taskmenu.tooltip | | [UDList](./udlist) | MDO List for database table ID: Table id 136. udlist.tooltip | ## List of other valid MDO providers | Provider Name | Implemented by Class | | ---------------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | [Activelanguage](./activelanguage) | | | [Activitystatus](./activitystatus) | MDO provider for the ActivityStatus enum: NotStarted, Started, Completed | | [Addressformat](./addressformat) | MDO list provider for AddressFormats Id returned is the layout\_id, not the addressformat\_id. | | [Allpersonsearch](./allpersonsearch) | Provider for selecting a Person, including search on contacts that match as well as persons. This provider wil | | [Allpersonwithassociatesearch](./allpersonwithassociatesearch) | Provides the same baseline functionality as , but additionally adds the associateId of the person to the extrainf | | [Allpreferencekeys](./allpreferencekeys) | MDO Provider that retrieves all preference keys | | [Amountclass](./amountclass) | GenericMDOProvider reads MDO lists with default settings | | [Appointment](./appointment) | | | [Appointmentcategory](./appointmentcategory) | | | [Appointmentcautionwarning](./appointmentcautionwarning) | Appointment.CautionWarning. Appointment and invitation synchronization info | | [Appointmentcompleted](./appointmentcompleted) | Appointment completed statuses: AppointmentStatus.NotStarted, AppointmentStatus.Completed | | [Appointmentfavourite](./appointmentfavourite) | MDO list provider for Favourites | | [Appointmentgroup](./appointmentgroup) | Appointment grouping types: TaskType.Appointment, Phone, ToDo | | [Appointmentresource](./appointmentresource) | | | [Appointmenttask](./appointmenttask) | MDO list provider for the task list of the AppointmentDialog. This list extends the basic wit | | [Appointmenttextid](./appointmenttextid) | Special case of appointment list where we get the id value from the Text table. For use when we wan | | [Appointmenttype](./appointmenttype) | List of AppointmentType values: inDiary, inChecklist, Note, Document, SavedReport, BookingForDiary, BookingForChecklist | | [Archiveprovider](./archiveprovider) | MDO provider for available archive providers for Configurable screens | | [Area](./area) | List of all defined areas. | | [Associaterestrictions](./associaterestrictions) | Public MDO provider based on the AssociateRestrictionsMDOProviderBase. | | [Associatewithmail](./associatewithmail) | Returns associates with their email addresses in the format "Full Name \" | | [Attachment](./attachment) | | | [Business](./business) | GenericMDOProvider reads MDO lists with default settings | | [Category](./category) | GenericMDOProvider reads MDO lists with default settings | | [Categorygroup](./categorygroup) | MDO provider for the CategoryGroup enum. | | [Chartselection](./chartselection) | | | [Chatbot](./chatbot) | List of all script folders that contain a script named like "%bot%register%" | | [Chatchannel](./chatchannel) | | | [Chatservice](./chatservice) | | | [Chatsessionstatus](./chatsessionstatus) | Chat session status values | | [Chatuser](./chatuser) | | | [Colorindex](./colorindex) | List of named colors from the "ColorIndex" enum | | [Combinedcontactpersonsearch](./combinedcontactpersonsearch) | Consider using the ContactAndPersonListFreetextSearchProvider/"contact\_and\_person\_freetextsearch" MDO list instead of this one | | [Comptr](./comptr) | GenericMDOProvider reads MDO lists with default settings | | [Consentpurpose](./consentpurpose) | MDO list provider for ConsentPurpose | | [Consentsource](./consentsource) | MDO list provider for Consent source | | [Contact](./contact) | Provider for selecting a Contact - without person search | | [Contactfavourite](./contactfavourite) | MDO list provider for Favourites | | [Contactperson\_freetextsearch](./contactperson_freetextsearch) | Provider for selecting a Contact - with person search | | [Contactphone](./contactphone) | | | [Contactrelationdefinition](./contactrelationdefinition) | MDO list provider for contact/person relation definitions. This provider is a takes a mandator | | [Contactwithpersonsearch](./contactwithpersonsearch) | Provider for selecting a Contact, including search on persons that match as well as contacts. this provider wil | | [Contactwithpersonsearch\_new](./contactwithpersonsearch_new) | Provider for selecting a Contact, including search on persons that match as well as contacts. this provider wil | | [Contact\_and\_person\_freetextsearch](./contact_and_person_freetextsearch) | Provider for selecting a Contact or a Perso | | [Contact\_and\_person\_freetextsearch\_hierarchical](./contact_and_person_freetextsearch_hierarchical) | | | [Contact\_freetextsearch](./contact_freetextsearch) | Provider for selecting a Contact - without person search | | [Contact\_new](./contact_new) | Provider for selecting a Contact - without person search | | [Contint](./contint) | GenericMDOProvider reads MDO lists with default settings | | [Country2](./country2) | Same as CountryProvider, but with icon hints based on the countrys name. | | [Createdocumenttemplateplugin](./createdocumenttemplateplugin) | List of document plugins that can create document templates. | | [Credentialgroup](./credentialgroup) | List of user groups supported by a named creditial plugin, sorted by group name. | | [Credited](./credited) | GenericMDOProvider reads MDO lists with default settings | | [Crmfields](./crmfields) | | | [Crmscript](./crmscript) | Archive of CRMScripts. Returns script id + name of script as hierarchy. | | [Culture](./culture) | | | [Culturesolanguage](./culturesolanguage) | List of SuperOffice cultures with old-style SO Culture name in ExtraInfo | | [Currency](./currency) | GenericMDOProvider reads MDO lists with default settings | | [Currentudeffields](./currentudeffields) | Get a list of udef fields for a given type. Pass the type as AdditionalInfo | | [Customerlanguage](./customerlanguage) | Customer Languages list. From the CustLang table. | | [Customobjectfavourite](./customobjectfavourite) | | | [Customobjectlist](./customobjectlist) | creates tree list of the custom objects | | [Customobjectrelation](./customobjectrelation) | MDO list provider for custom object relation | | [Dashboard](./dashboard) | MDO list provider for Dashboard, can be used by Navigator. | | [Dashboardcurrency](./dashboardcurrency) | | | [Dashboardentity](./dashboardentity) | | | [Dashboardtheme](./dashboardtheme) | | | [Dashboardtile](./dashboardtile) | MDO list provider for Dashboard tile | | [Dashboardtileentitytype](./dashboardtileentitytype) | List of dashboard tile types: Company, Project, Sale, Product, Activity, Web Panel | | [Dashtilemeasure](./dashtilemeasure) | | | [Dayofmonth](./dayofmonth) | MDO provider for the hard-coded list of day alternatives in the recurrence dialog. | | [Deliveryterms](./deliveryterms) | GenericMDOProvider reads MDO lists with default settings | | [Deliverytype](./deliverytype) | GenericMDOProvider reads MDO lists with default settings | | [Diaryowner](./diaryowner) | List provider that returns diary owners, i.e., our own employees plus resources | | [Direction](./direction) | Document and Task directions: TaskDirection.Incoming, Outgoing | | [Disconnectpersonactions](./disconnectpersonactions) | List of actions to perform when disconnecting a contact from a company | | [Doctmpl](./doctmpl) | GenericMDOProvider reads MDO lists with default settings | | [Document](./document) | MDO list provider for documents. | | [Documentcategory](./documentcategory) | | | [Documentcompleted](./documentcompleted) | Document completed status list: Not done, Done. | | [Documentfavourite](./documentfavourite) | MDO list provider for Favourites | | [Documentgroup](./documentgroup) | Document types: TaskType.Document, Email, Fax, Merge draft, Merge Final. | | [Documenthandler](./documenthandler) | | | [Documentmailing](./documentmailing) | Document shipments (mail merges). | | [Documentmailingtemplate](./documentmailingtemplate) | Document mailing templates | | [Documenttemplatelanguage](./documenttemplatelanguage) | MDO Provider for Document Template langauges. | | [Documenttemplatesfiltered](./documenttemplatesfiltered) | MDO Provider for Document Templates, excluding Document details and quote mail templates, which are for system use rather than end-user choosing. | | [Documenttypes](./documenttypes) | List of document types for the given plugin | | [Efd\_13](./efd_13) | Extra fields dropdown lists. Contains list of string values defined on the extra\_field | | [Ejcategory](./ejcategory) | EjCategoryProvider creates a flat or tree list based on the table: EJ\_CATEGORY | | [Ejuser](./ejuser) | | | [Emailaddress](./emailaddress) | List of e-mail addresses matching the search valu | | [Emailflow](./emailflow) | List provider for EmailFlow | | [Emailfolder](./emailfolder) | EmailFolderProvider gives you the folder hierarchy of a given mail account | | [Emailfromtype](./emailfromtype) | MDO provider for the EmailFromType enum | | [Emailphone](./emailphone) | List of e-mail addresses and phone numbers matching the search valu | | [Emailpriorityprovider](./emailpriorityprovider) | MDO List provider for email priority: Highest, High, Normal, Low, Lowest, No Priority | | [Emailreplytotype](./emailreplytotype) | MDO provider for the EmailReplyToType enum | | [Enrichcontact](./enrichcontact) | List of possible contacts to import from outside sources. | | [Erpactortype](./erpactortype) | | | [Erpconnections](./erpconnections) | Retrieve the list of all defined Erp Connections (not Connectors, that's another list) | | [Erpconnectors](./erpconnectors) | Retrieve the list of all defined Erp Connectors (not Connections, that's another list) | | [Erpdeliveryterms](./erpdeliveryterms) | | | [Erpdeliverytype](./erpdeliverytype) | | | [Erpfields](./erpfields) | | | [Erppaymentterms](./erppaymentterms) | | | [Erppaymenttype](./erppaymenttype) | | | [Erpproductcategory](./erpproductcategory) | | | [Erpproductfamily](./erpproductfamily) | | | [Erpproducttype](./erpproducttype) | | | [Eventhandlertype](./eventhandlertype) | Screen trigger event types: members of enum. | | [Everymonth](./everymonth) | MDO provider for the hard-coded list of day month in the recurrence dialog. | | [Executeonevent](./executeonevent) | List of windows client events to execute tasks on: Logon, Logoff, LocalUpdate | | [Exporttemplate](./exporttemplate) | MDO provider for the list of template files for the 'export to file' functio | | [Extapp](./extapp) | GenericMDOProvider reads MDO lists with default settings | | [Faqcategory](./faqcategory) | | | [Faqreplytemplate](./faqreplytemplate) | | | [Faqreplytemplatefavourite](./faqreplytemplatefavourite) | MDO list provider for Favourites | | [Favouritetype](./favouritetype) | MDO list provider for Favourite types | | [Filterassociates](./filterassociates) | Associate list for the Filter dialog. This associate list differs from the standard list in two ways | | [Filterfuturedate](./filterfuturedate) | MDO provider for the hard-coded list of future date alternatives in the Filter dialog | | [Filtergroups](./filtergroups) | User groups, filtered according to the usergroups selected in the filter dialog. | | [Findproduct](./findproduct) | QuickSearch for the Add Quote Line dialog, where a single-line user input is passed to th | | [Font](./font) | List provider for availablefonts table. | | [Fontsize](./fontsize) | List of font types | | [Fonttype](./fonttype) | List of font types | | [Form](./form) | Get all forms with folder hierarchy | | [Formfields](./formfields) | List of customizable fields for forms | | [Formfolder](./formfolder) | FormFolderProvider creates a flat or tree list based on the table: s\_picture\_folder | | [Formmailings](./formmailings) | | | [Formratingdice](./formratingdice) | | | [Formratingnps](./formratingnps) | | | [Formratingsmileys](./formratingsmileys) | | | [Formratingstars](./formratingstars) | MDO provider for the Ratings as used in forms | | [Formratingthumbs](./formratingthumbs) | | | [Formsubmissionstatusprovider](./formsubmissionstatusprovider) | | | [Freetextsearchentity](./freetextsearchentity) | List provider that returns the entities supported by free text search. The extraInfo field contains th | | [Functionrights](./functionrights) | FunctionRightsListProvider returns a MDO list of function rights in the database | | [Genericperson](./genericperson) | List of persons with mail. Supports Selection(any type), project and associate | | [Genericpersonwithmail](./genericpersonwithmail) | List of persons with mail. Supports Selection(any type), project and associate | | [Groupview](./groupview) | GroupViewMDOProvider uses the AssociateMDOProvider + DiaryView to create the MDOlist for Groupview in Diary view. | | [Heading](./heading) | List provider for the Heading table. While this table looks like an MDO table | | [Hierarchy](./hierarchy) | List provider for the Hierarchy table. Pass the domain using Additional info | | [Htmlmailing](./htmlmailing) | MDO provider for the different types of Mailings | | [Htmlmailingtemplate](./htmlmailingtemplate) | MDO provider for the different types of Mailing templates | | [Importblankaction](./importblankaction) | Import actions for blank values: Use Person Name, Skip | | [Importcontactduplicatematch](./importcontactduplicatematch) | List of fields to match contact imports. | | [Importduplicateaction](./importduplicateaction) | Import Duplicate actions: Add, Merge, Replace, Skip | | [Importduplicateactionwithoutadd](./importduplicateactionwithoutadd) | Import duplicate; Merge, Replace, Skip | | [Importfields](./importfields) | MDO provider for column headers used in import | | [Importnewlistitem](./importnewlistitem) | Import list items: Add item, use default, use blank | | [Importnewpositionitem](./importnewpositionitem) | Import position items: Add to list, set to blank | | [Importnewproductlistitem](./importnewproductlistitem) | Import product list items: add, use blank | | [Importpersonduplicatematch](./importpersonduplicatematch) | Import Person Fields to match on: Name, E-mail, phone, number, id, None | | [Importphoneurlsemail](./importphoneurlsemail) | Import phone/url/email values: Add, Replace, Skip | | [Importproductduplicatematch](./importproductduplicatematch) | Import product detect duplicates based on field: Name, Code, Name+Code | | [Importproductfields](./importproductfields) | MDO provider for column headers used in import | | [Intent](./intent) | GenericMDOProvider reads MDO lists with default settings | | [Invitationtemplatelanguage](./invitationtemplatelanguage) | | | [Iso639language](./iso639language) | | | [Kbaccesslevel](./kbaccesslevel) | MDO provider for the KbAccessLevel enum | | [Kbentry](./kbentry) | | | [Kbworkflow](./kbworkflow) | MDO list provider for KB Workflow. | | [Landingpage](./landingpage) | | | [Language](./language) | | | [Leadstatus](./leadstatus) | List provider for LeadStatus | | [Legalbase](./legalbase) | MDO list provider for Legal base | | [Lists](./lists) | List of all MDO list providers. | | [Locatecontact](./locatecontact) | Provider for selecting a Contact, including search on persons that match as well as contacts. this provider wil | | [Locatecontact\_new](./locatecontact_new) | Provider for selecting a Contact, including search on persons that match as well as contacts. this provider wil | | [Locateperson](./locateperson) | Person list with contact name. | | [Location](./location) | Implements the mdo provider for the list of avaiable locations. This list aggregates element | | [Mailclient](./mailclient) | | | [Mailhtmltemplate](./mailhtmltemplate) | List provider for the Mailtemplates. | | [Mailing](./mailing) | All mailings - history ids | | [Mailingdomains](./mailingdomains) | MDO list provider for Mailing domains, including leading @ | | [Mailingfavourite](./mailingfavourite) | MDO list provider for Favourites | | [Mailingstatus](./mailingstatus) | | | [Mailingsubscriptiontype](./mailingsubscriptiontype) | Mailing subscription types; Invitations, news, etc | | [Mailingtemplate](./mailingtemplate) | General mailing templates | | [Mailingtype](./mailingtype) | Mailing types: Html mail, SMS, Word Document | | [Mailtemplate](./mailtemplate) | List provider for the Mailtemplates. | | [Mergedocument](./mergedocument) | MDO list provider for documents marked as type . | | [Mergetags](./mergetags) | | | [Month](./month) | MDO provider for the hard-coded list of "of" months in the recurrence dialog. | | [Mrmrs](./mrmrs) | GenericMDOProvider reads MDO lists with default settings | | [Newsfeeditemstatusprovider](./newsfeeditemstatusprovider) | MDO List provider for news feed item status: Normal, Handling, Handled | | [Ofmonth](./ofmonth) | MDO provider for the hard-coded list of "of" months in the recurrence dialog. | | [Onlinefontlibrary](./onlinefontlibrary) | MDO provider for the available fonts from the Online Template Library. | | [Ownercontact](./ownercontact) | MDO provider for listing owner contacts. | | [Paymentterms](./paymentterms) | GenericMDOProvider reads MDO lists with default settings | | [Paymenttype](./paymenttype) | GenericMDOProvider reads MDO lists with default settings | | [Period](./period) | Period values: Day, Week, Month, Quarter, Year | | [Periods](./periods) | Period values: Day, Week, Month, Quarter, Year | | [Persint](./persint) | GenericMDOProvider reads MDO lists with default settings | | [Person](./person) | List of persons from the Archive provider | | [Personcontactfavourite](./personcontactfavourite) | MDO list provider for Favourites | | [Personcontact\_freetextsearch](./personcontact_freetextsearch) | Provider for selecting a Person - with contact search | | [Personemailaddress](./personemailaddress) | List of e-mail addresses matching the search value, possibly restricted to a given company or person. | | [Personfavourite](./personfavourite) | MDO list provider for Favourites | | [Personphone](./personphone) | Search phone numbers for matching values, restricted to a given company or person. | | [Personrestrictions](./personrestrictions) | Implements a person mdolist provider that uses the conflicts detector to append information o | | [Personurl](./personurl) | List of urls (web pages) matching the search value, possibly restricted to a given company or person. | | [Personwithmail](./personwithmail) | List of persons fetched based on provided criteri | | [Person\_freetextsearch](./person_freetextsearch) | Provider for selecting a Person - without contact search | | [Perspos](./perspos) | GenericMDOProvider reads MDO lists with default settings | | [Phonesearch](./phonesearch) | Search phone numbers for matching stripped numbers, across person and contacts | | [Plugin](./plugin) | List of installed and available Document plugins | | [Pmembtype](./pmembtype) | GenericMDOProvider reads MDO lists with default settings | | [Prefdescline](./prefdescline) | PrefDesc creates a MDO list of prefdesclines for a given prefdesc id. | | [Preferencekey](./preferencekey) | MDO Provider that retrieves a list of preference keys corresponding to a given section | | [Preferencelineitem](./preferencelineitem) | MDO Provider for preferences that have a list of possible values in the database | | [Preferencesection](./preferencesection) | MDO Provider that retrieves a list of preference sections | | [Pricelist](./pricelist) | List of pricelists from the PriceList table | | [Priceunit](./priceunit) | GenericMDOProvider reads MDO lists with default settings | | [Priority](./priority) | GenericMDOProvider reads MDO lists with default settings | | [Privacytemplate](./privacytemplate) | This is a variant of the DocTmpl list - document templates - restricted to those that are of some privacy document type. | | [Prob](./prob) | GenericMDOProvider reads MDO lists with default settings | | [Productcategory](./productcategory) | GenericMDOProvider reads MDO lists with default settings | | [Productfamily](./productfamily) | GenericMDOProvider reads MDO lists with default settings | | [Productimage](./productimage) | Return product images from the blob table | | [Producttype](./producttype) | GenericMDOProvider reads MDO lists with default settings | | [Project](./project) | Provider for selecting a project. | | [Projectassociate](./projectassociate) | MDO provider for associates that are members of a project | | [Projectfavourite](./projectfavourite) | MDO list provider for Favourites | | [Projectimage](./projectimage) | Project images from the blob table | | [Projectmembereventparticipantstatus](./projectmembereventparticipantstatus) | List of project member event status fields. | | [Projectmemberwithmail](./projectmemberwithmail) | | | [Projectstatus](./projectstatus) | List of project guide steps status values. | | [Projecttype](./projecttype) | Project type list. Encodes Default project duration in extra info. | | [Projecttypeflatlist](./projecttypeflatlist) | Project type list. Encodes Default project duration in extra info. | | [Project\_freetextsearch](./project_freetextsearch) | Provider for selecting a Project | | [Project\_new](./project_new) | Provider for selecting a project. Returns search results in rank orde | | [Projstatus](./projstatus) | GenericMDOProvider reads MDO lists with default settings | | [Projtype](./projtype) | GenericMDOProvider reads MDO lists with default settings | | [Quotealternatives](./quotealternatives) | Quote alternative selector for one Quote Version. Send QuoteVersionId=\ in ExtraInfo to specify quote version id | | [Quoteapprovalassociate](./quoteapprovalassociate) | MDO provider for associates that are allowed to approve a quote. | | [Quoteapprovers](./quoteapprovers) | Retrieve the list of all users that can approve quotes | | [Quoteapprreason](./quoteapprreason) | GenericMDOProvider reads MDO lists with default settings | | [Quoteconnections](./quoteconnections) | Retrieve the list of all defined Quote Connections - i.e. not the connectors (DLLs) | | [Quoteconnectors](./quoteconnectors) | Retrieve the list of all installed (i.e., loaded assemblies) Quote Connectors | | [Quotedenyreason](./quotedenyreason) | GenericMDOProvider reads MDO lists with default settings | | [Quotedocumentgroupfields](./quotedocumentgroupfields) | Possible choices for fields that you can GROUP BY in quote detail documents. | | [Quotedocumentorderbyfields](./quotedocumentorderbyfields) | Possible choices for fields you can ORDER BY, within a group (or without grouping) | | [Quotedocuments](./quotedocuments) | MDO provider for the list of current / candidate "main document" for a given quote | | [Quotedocumenttype](./quotedocumenttype) | List of quote document types - assumes ExtraInfo is the name of RecordType enum value | | [Quotelinestatus](./quotelinestatus) | Hard-coded list of values for the QuoteLine.Status field, see enum. | | [Quotetemplate](./quotetemplate) | This is a variant of the DocTmpl list - document templates - restricted to those that are of some quote document type | | [Quoteversion](./quoteversion) | Quote version selector for one Quote. Send QuoteId=\ in ExtraInfo to specify quote id | | [Quoteversionstate](./quoteversionstate) | List provider for the enum | | [Reason](./reason) | GenericMDOProvider reads MDO lists with default settings | | [Reasonsold](./reasonsold) | GenericMDOProvider reads MDO lists with default settings | | [Reasonstalled](./reasonstalled) | GenericMDOProvider reads MDO lists with default settings | | [Recentnavigation](./recentnavigation) | MDO list provider for the Recent navigation history of the current associate: the ranked list o | | [Recipientfavourite](./recipientfavourite) | MDO list provider for Favourites | | [Recordtype](./recordtype) | A complete and generic mapping of record types to resource strings | | [Recurrenceweekcycle](./recurrenceweekcycle) | MDO provider for the hard-coded list of week cycle alternatives in the recurrence dialog. | | [Rejectreason](./rejectreason) | GenericMDOProvider reads MDO lists with default settings | | [Relateddatafields](./relateddatafields) | | | [Relationssearchlistproviderappointmentactive](./relationssearchlistproviderappointmentactive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistproviderappointmentappointmentactive](./relationssearchlistproviderappointmentappointmentactive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistproviderappointmentappointmentpassive](./relationssearchlistproviderappointmentappointmentpassive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistproviderappointmentdocumentactive](./relationssearchlistproviderappointmentdocumentactive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistproviderappointmentdocumentpassive](./relationssearchlistproviderappointmentdocumentpassive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistproviderappointmentpassive](./relationssearchlistproviderappointmentpassive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistproviderappointmentsaleactive](./relationssearchlistproviderappointmentsaleactive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistproviderappointmentsalepassive](./relationssearchlistproviderappointmentsalepassive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistprovidercontactactive](./relationssearchlistprovidercontactactive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistprovidercontactcontactactive](./relationssearchlistprovidercontactcontactactive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistprovidercontactcontactpassive](./relationssearchlistprovidercontactcontactpassive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistprovidercontactpassive](./relationssearchlistprovidercontactpassive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistprovidercontactpersonactive](./relationssearchlistprovidercontactpersonactive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistprovidercontactpersonpassive](./relationssearchlistprovidercontactpersonpassive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistproviderdocumentactive](./relationssearchlistproviderdocumentactive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistproviderdocumentappointmentactive](./relationssearchlistproviderdocumentappointmentactive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistproviderdocumentappointmentpassive](./relationssearchlistproviderdocumentappointmentpassive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistproviderdocumentdocumentactive](./relationssearchlistproviderdocumentdocumentactive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistproviderdocumentdocumentpassive](./relationssearchlistproviderdocumentdocumentpassive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistproviderdocumentpassive](./relationssearchlistproviderdocumentpassive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistproviderdocumentsaleactive](./relationssearchlistproviderdocumentsaleactive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistproviderdocumentsalepassive](./relationssearchlistproviderdocumentsalepassive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistproviderpersonactive](./relationssearchlistproviderpersonactive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistproviderpersoncontactactive](./relationssearchlistproviderpersoncontactactive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistproviderpersoncontactpassive](./relationssearchlistproviderpersoncontactpassive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistproviderpersonpassive](./relationssearchlistproviderpersonpassive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistproviderpersonpersonactive](./relationssearchlistproviderpersonpersonactive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistproviderpersonpersonpassive](./relationssearchlistproviderpersonpersonpassive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistprovidersaleactive](./relationssearchlistprovidersaleactive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistprovidersaleappointmentactive](./relationssearchlistprovidersaleappointmentactive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistprovidersaleappointmentpassive](./relationssearchlistprovidersaleappointmentpassive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistprovidersaledocumentactive](./relationssearchlistprovidersaledocumentactive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistprovidersaledocumentpassive](./relationssearchlistprovidersaledocumentpassive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistprovidersalepassive](./relationssearchlistprovidersalepassive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistprovidersalesaleactive](./relationssearchlistprovidersalesaleactive) | Serve the active and passive texts of relations, with a given table as source (active | | [Relationssearchlistprovidersalesalepassive](./relationssearchlistprovidersalesalepassive) | Serve the active and passive texts of relations, with a given table as source (active | | [Replytemplate](./replytemplate) | | | [Replytemplateaccesslevel](./replytemplateaccesslevel) | MDO provider for the ReplyTemplateAccessLevel enum | | [Resource](./resource) | MDO provider for resources (from the associate table) | | [Resourcerestrictions](./resourcerestrictions) | MDO provider for resources (from the associate table) that uses restrictions to includ | | [Restrictionoperators](./restrictionoperators) | This SoList provider will generate the operator list for a given search criterion data type. The data type i | | [Roles](./roles) | RoleListProvider creates a MDO list of roles in the database | | [Saintactivitytype](./saintactivitytype) | This SoList provider generates the appointment/task type list for the Saint criteria. This is a simple, hard-coded list correspondin | | [Saintamountclass](./saintamountclass) | This SoList provider generates the amount class list for the Saint criteria. This list is an extension of the basi | | [Saintdirection](./saintdirection) | This SoList provider generates the appointment/task direction list for the Saint criteria. This is a simple, hard-coded list correspondin | | [Saintintention](./saintintention) | This SoList provider generates the Intent list for the Saint criteria. This list is an extension of the basi | | [Saintsalestatus](./saintsalestatus) | This SoList provider generates the sale status list for the Saint criteria. This is a simple, hard-coded list correspondin | | [Saintticketcategory](./saintticketcategory) | This SoList provider generates the eJournal top-level categories, meant for the saint system | | [Saintticketstatus](./saintticketstatus) | This SoList provider generates the ticket status list for the Saint criteria. This is a simple, hard-coded list, special for this context | | [Sale](./sale) | List of sales | | [Salecategory](./salecategory) | | | [Saledone](./saledone) | Sale Done status: SaleDone.Done or NotDone. | | [Salefavourite](./salefavourite) | MDO list provider for Favourites | | [Saleguidestage](./saleguidestage) | MDO provider for the stage list, customized for the sale guide stage button row | | [Saleprobability](./saleprobability) | MDO list provider for the probability list of the Sale dialog. This list extends the basic list with a leadin | | [Salesource](./salesource) | MDO list provider for the source list of the Sale dialog | | [Salestage](./salestage) | Provider for selecting a stage. AdditionalInfo is used as criteria to filter stages based on SaleType. | | [Salestatus](./salestatus) | List for the Sale.Status field: Open, Lost, Sold, Stalled. | | [Saletype](./saletype) | List of sale types, with default sale duration in minutes in extra info. | | [Saletypecat](./saletypecat) | GenericMDOProvider reads MDO lists with default settings | | [Saletypecategories](./saletypecategories) | SaleTypeCategories creates a MDO list of sale type categories in the database. | | [Sale\_freetextsearch](./sale_freetextsearch) | Provider for selecting a Sale | | [Sale\_new](./sale_new) | List of sales | | [Salutation](./salutation) | GenericMDOProvider reads MDO lists with default settings | | [Satellites](./satellites) | SatelliteProvider creates a MDO list of satellites. | | [Searchcat](./searchcat) | GenericMDOProvider reads MDO lists with default settings | | [Selection](./selection) | Provider for selecting a selection | | [Selectioncriteriamembertype](./selectioncriteriamembertype) | | | [Selectionfavourite](./selectionfavourite) | MDO list provider for selection favourites | | [Selectionmembertype](./selectionmembertype) | MDO provider for the selection archive providers types | | [Selectionmembertypeclean](./selectionmembertypeclean) | | | [Selectionmembertypev2](./selectionmembertypev2) | MDO provider for the selection archive providers types | | [Selectionmemberwithmail](./selectionmemberwithmail) | List of selection members fetched based on provided criteri | | [Selectiontype](./selectiontype) | MDO provider for the hard-coded list of selection kinds: Static, Dynamic, Combined | | [Selectionuniontype](./selectionuniontype) | Different ways to combine selections: Union, Intersect, Disjoin, Left or Right Subtraction. | | [Selection\_freetextsearch](./selection_freetextsearch) | Provider for selecting a Selection | | [Sentiment](./sentiment) | | | [Serviceassociate](./serviceassociate) | MDO provider for associates that are allowed to approve a quote. | | [Shipmentaddrstatusprovider](./shipmentaddrstatusprovider) | | | [Shipmentfolder](./shipmentfolder) | ShipmentFolderProvider creates a flat or tree list based on the table: s\_picture\_folder | | [Shipmentlinks](./shipmentlinks) | Create a list of specified mailings (flow, form, regular mailing/shipment...), hierarchy optional | | [Shipmenttype](./shipmenttype) | MDO list provider for ConsentPurpose | | [Simplemailingstatus](./simplemailingstatus) | | | [Smsmailing](./smsmailing) | SMS Shipment names | | [Smsmailingtemplate](./smsmailingtemplate) | SMS Mailing templates | | [Source](./source) | GenericMDOProvider reads MDO lists with default settings | | [Sourceproduct](./sourceproduct) | Products: Sales & Marketing, Customer Service | | [Specifiedmailings](./specifiedmailings) | Create a list of mailings (flow, form, regular mailing/shipment...), hierarchy optional | | [Stakeholderrole](./stakeholderrole) | GenericMDOProvider reads MDO lists with default settings | | [Statusdef](./statusdef) | Return list of status monitors defined in the system | | [Statusmonitorimage](./statusmonitorimage) | List of images for status monitors in the blob table. | | [Subscriptionunit](./subscriptionunit) | GenericMDOProvider reads MDO lists with default settings | | [Suggestedappointment](./suggestedappointment) | Suggested Appointment Provider creates a MDO list of suggested appointments for a given guide stage. | | [Suggesteddocument](./suggesteddocument) | SuggestedDocumentProvider creates a MDO list of suggested documents in the database. | | [Systemeventtype](./systemeventtype) | System event types: NoLogin, NoFreeText, NoTravel, Message-of-the-day | | [Tags](./tags) | GenericMDOProvider reads MDO lists with default settings | | [Targetentitytype](./targetentitytype) | TargetEntities | | [Targetmeasurementunit](./targetmeasurementunit) | MeasurementUnits | | [Targettypes](./targettypes) | | | [Targetyear](./targetyear) | Year MDO list. Includes the two coming years, this year, and previous 5 years | | [Task](./task) | Task table MDO list. Optional include "None" as first value. | | [Taskmenu](./taskmenu) | GenericMDOProvider reads MDO lists with default settings | | [Taskmenudestination](./taskmenudestination) | | | [Taskmenugroup](./taskmenugroup) | List of TaskMenus with visible for groups as commaseperated ids in extrainfo field | | [Templatevariables](./templatevariables) | | | [Ticket](./ticket) | Provider for selecting a ticket | | [Ticketalert](./ticketalert) | | | [Ticketfavourite](./ticketfavourite) | | | [Ticketorigin](./ticketorigin) | Ticket Origin | | [Ticketpriority](./ticketpriority) | MDO list provider for ticket priorities. | | [Ticketpriorityescalateevent](./ticketpriorityescalateevent) | MDO list provider for ticket Priority EscalateEvents enum. | | [Ticketread](./ticketread) | | | [Ticketrelationdefinition](./ticketrelationdefinition) | MDO list provider for ticket relation definitions. | | [Ticketrelationtype](./ticketrelationtype) | Ticket Relation Type | | [Ticketselectionwithstaticmenu](./ticketselectionwithstaticmenu) | Provider for selecting ticket selections | | [Ticketslevel](./ticketslevel) | Ticket Security Level | | [Ticketstatus](./ticketstatus) | Ticket status values: Open, Closed, Inactive, Deleted, Connected and Spam (if enabled). | | [Ticketstatustimecounter](./ticketstatustimecounter) | Ticket status timer count values: None, Internall, Externally, Queue | | [Ticketstatuswithoutpostpone](./ticketstatuswithoutpostpone) | | | [Ticketstatuswithpostpone](./ticketstatuswithpostpone) | | | [Ticketticketstatus](./ticketticketstatus) | TicketTicketStatusProvider creates a flat list based on the table: TICKET\_STATUS | | [Tickettype](./tickettype) | TicketTypeProvider creates a flat list based on the table: TICKET\_TYPE | | [Ticket\_freetextsearch](./ticket_freetextsearch) | Provider for selecting a Ticket - with contact and person search | | [Ticket\_selection\_freetextsearch](./ticket_selection_freetextsearch) | Provider for selecting Ticket Selection or a Ticket | | [Time](./time) | MDO provider for the hard-coded list of time alternatives in the appointment dialog and in edit/preference | | [Timezone](./timezone) | | | [Timezoneiana](./timezoneiana) | Provides the timezone list | | [Timezonewithcode](./timezonewithcode) | Provides the timezone list. The country code is given in the type field | | [Typegroup](./typegroup) | Type Group: Task, Activity, Document, Sale | | [Typicalsearch](./typicalsearch) | MDO provider for the TypicalSearch Title, Tooltip and I | | [Udeffields](./udeffields) | Get a list of udef fields for a given type | | [Udeffieldswithchanges](./udeffieldswithchanges) | Get a list of udef fields for a given type | | [Udeffieldtype](./udeffieldtype) | List of UDef field types for a given owner table, and possibly restricted based on the current field type | | [Udlist](./udlist) | MDO Provider for 'user-defined' lists, i.e., those that reside in the UDList table. Mandatory additionalInfo is th | | [Udlist28](./udlist28) | Dynamic MDO provider that will create a list with the name udlist\ for each user-defined list in the UDListDefinition table | | [Udlist30002](./udlist30002) | MDO provider for the ChatService | | [Urlencoding](./urlencoding) | | | [Usergroup](./usergroup) | List provider for the UserGroup table. While this table looks like an MDO table | | [Usergroupwithhistoryall](./usergroupwithhistoryall) | List provider for the UserGroup table. While this table looks like an MDO table | | [Userplan](./userplan) | List provider for the UserPlan in the module license table | | [Usertype](./usertype) | Simple, hard-coded provider for the associate type: Employee, ExternalPerson, Resource, Anonymous, System, Invalid User Type | | [Visiblefor](./visiblefor) | List provider for the VisibleFor dropdown control. Items are of type associate, usergroup or all, wit | | [Visibleforassociate](./visibleforassociate) | List provider that returns a list suitable for VisibleFor and PinTo (with groups and possibly some other special items like All). | | [Visiblein](./visiblein) | Visible in list for web panels. | | [Visibleinmenu](./visibleinmenu) | Visible in menu list: Toolbox menu, View menu | | [Visibleintask](./visibleintask) | Visible in list for tasks: places where task button can appear. | | [Webhookentitylist](./webhookentitylist) | | | [Webhookeventlist](./webhookeventlist) | | | [Webpanel](./webpanel) | List of WebPanels visible possible for use with groups and headings. | | [Webpanelgroup](./webpanelgroup) | List of WebPanels with visible for groups as commaseperated ids in extrainfo field | | [Weekday](./weekday) | MDO provider for the hard-coded list of week days. | | [Weeknumber](./weeknumber) | MDO provider for the hard-coded list of numbered weeks in the recurrence dialog. | | [Workflowdefinitionstatus](./workflowdefinitionstatus) | MDO provider for the WorkflowDefinitionStatus enum | | [Workflowgoaltype](./workflowgoaltype) | MDO provider for the WorkflowGoalType enum | | [Workflowinstancestatus](./workflowinstancestatus) | MDO provider for the WorkflowInstanceStatus enum | | [Workflowsplitoptiontype](./workflowsplitoptiontype) | MDO provider for the WorkflowTriggerType enum | | [Workflowsteptype](./workflowsteptype) | MDO provider for the WorkflowStepType enum | | [Workflowtimewaitalgorithm](./workflowtimewaitalgorithm) | MDO provider for the WorkflowTimeWaitAlgorithm enum | | [Workflowtimewaitintervaltype](./workflowtimewaitintervaltype) | MDO provider for the WorkflowTimeWaitIntervalType enum | | [Workflowtriggertype](./workflowtriggertype) | MDO provider for the WorkflowTriggerType enum | | [Y\_car](./y_car) | Extra tables lists. List names are 'y\_xyz' - based on the custom table name | ## Related topics - [MDO List Provider names](/en/api/mdo-providers/reference/index.md) - [lists](/en/api/mdo-providers/reference/lists.md) - [Get List Names](/en/api/reference/restful/agent/mdo_agent/get-list-names.md) - [RelationsSearchListProviderContactActive](/en/api/mdo-providers/reference/relationssearchlistprovidercontactactive.md) - [RelationsSearchListProviderContactPassive](/en/api/mdo-providers/reference/relationssearchlistprovidercontactpassive.md) - [RelationsSearchListProviderDocumentActive](/en/api/mdo-providers/reference/relationssearchlistproviderdocumentactive.md) - [RelationsSearchListProviderDocumentPassive](/en/api/mdo-providers/reference/relationssearchlistproviderdocumentpassive.md)