MDO List Providers
Some tooltip text!
• 33 minutes to read
• 33 minutes to read
List of MDO table names
| Provider Name | Implemented by Class |
|---|---|
| AmountClass | MDO List for database table ID: Table id 225. amountclass.tooltip |
| Associate | MDO List for database table ID: Table id 2. associate.tooltip |
| Business | MDO List for database table ID: Table id 61. business.tooltip |
| Category | MDO List for database table ID: Table id 64. category.tooltip |
| Comptr | MDO List for database table ID: Table id 109. comptr.tooltip |
| ContInt | MDO List for database table ID: Table id 70. contint.tooltip |
| Country | MDO List for database table ID: Table id 19. country.tooltip |
| Credited | MDO List for database table ID: Table id 97. credited.tooltip |
| Currency | MDO List for database table ID: Table id 112. currency.tooltip |
| DeliveryTerms | MDO List for database table ID: Table id 433. deliveryterms.tooltip |
| DeliveryType | MDO List for database table ID: Table id 436. deliverytype.tooltip |
| DocTmpl | MDO List for database table ID: Table id 130. doctmpl.tooltip |
| ExtApp | MDO List for database table ID: Table id 133. extapp.tooltip |
| Intent | MDO List for database table ID: Table id 216. intent.tooltip |
| MrMrs | MDO List for database table ID: Table id 94. mrmrs.tooltip |
| PaymentTerms | MDO List for database table ID: Table id 427. paymentterms.tooltip |
| PaymentType | MDO List for database table ID: Table id 430. paymenttype.tooltip |
| PersInt | MDO List for database table ID: Table id 73. persint.tooltip |
| PersPos | MDO List for database table ID: Table id 76. perspos.tooltip |
| PMembType | MDO List for database table ID: Table id 91. pmembtype.tooltip |
| PriceUnit | MDO List for database table ID: Table id 439. priceunit.tooltip |
| Priority | MDO List for database table ID: Table id 79. priority.tooltip |
| Prob | MDO List for database table ID: Table id 82. prob.tooltip |
| ProductCategory | MDO List for database table ID: Table id 408. productcategory.tooltip |
| ProductFamily | MDO List for database table ID: Table id 411. productfamily.tooltip |
| ProductType | MDO List for database table ID: Table id 414. producttype.tooltip |
| ProjStatus | MDO List for database table ID: Table id 88. projstatus.tooltip |
| ProjType | MDO List for database table ID: Table id 85. projtype.tooltip |
| QuoteApprReason | MDO List for database table ID: Table id 504. quoteapprreason.tooltip |
| QuoteDenyReason | MDO List for database table ID: Table id 507. quotedenyreason.tooltip |
| Reason | MDO List for database table ID: Table id 103. reason.tooltip |
| ReasonSold | MDO List for database table ID: Table id 115. reasonsold.tooltip |
| ReasonStalled | MDO List for database table ID: Table id 154. reasonstalled.tooltip |
| RejectReason | MDO List for database table ID: Table id 222. rejectreason.tooltip |
| Relationdefinition | MDO List for database table ID: Table id 48. relationdefinition.tooltip |
| SaleType | MDO List for database table ID: Table id 149. saletype.tooltip |
| SaleTypeCat | MDO List for database table ID: Table id 118. saletypecat.tooltip |
| Salutation | MDO List for database table ID: Table id 219. salutation.tooltip |
| SearchCat | MDO List for database table ID: Table id 106. searchcat.tooltip |
| Source | MDO List for database table ID: Table id 100. source.tooltip |
| StakeholderRole | MDO List for database table ID: Table id 122. stakeholderrole.tooltip |
| SubscriptionUnit | MDO List for database table ID: Table id 442. subscriptionunit.tooltip |
| Tags | MDO List for database table ID: Table id 488. tags.tooltip |
| Task | MDO List for database table ID: Table id 67. task.tooltip |
| TaskMenu | MDO List for database table ID: Table id 519. taskmenu.tooltip |
| UDList | MDO List for database table ID: Table id 136. udlist.tooltip |
List of other valid MDO providers
| Provider Name | Implemented by Class |
|---|---|
| activitystatus | MDO provider for the ActivityStatus enum: NotStarted, Started, Completed |
| addressformat | MDO list provider for AddressFormats Id returned is the layout_id, not the addressformat_id. |
| allpersonsearch | Provider for selecting a Person, including search on contacts that match as well as persons. this provider wil |
| allpreferencekeys | MDO Provider that retrieves all preference keys |
| amountclass | GenericMDOProvider reads MDO lists with default settings |
| appointment | |
| appointmentcategory | |
| appointmentcautionwarning | Appointment.CautionWarning. Appointment and invitation synchronization info |
| appointmentcompleted | Appointment completed statuses: AppointmentStatus.NotStarted, AppointmentStatus.Completed |
| appointmentfavourite | MDO list provider for Favourites |
| appointmentgroup | Appointment grouping types: TaskType.Appointment, Phone, ToDo |
| appointmenttask | MDO list provider for the task list of the AppointmentDialog. This list extends the basic |
| appointmenttextid | Special case of appointment list where we get the id value from the Text table. For use when we wan |
| appointmenttype | List of AppointmentType values: inDiary, inChecklist, Note, Document, SavedReport, BookingForDiary, BookingForChecklist |
| archiveprovider | MDO provider for available archive providera |
| area | List of all defined areas. |
| associaterestrictions | Public MDO provider based on the AssociateRestrictionsMDOProviderBase. |
| associatewithmail | |
| attachment | |
| availablereports | AvailableReportsProvider creates an MDO list containing the available reports |
| business | GenericMDOProvider reads MDO lists with default settings |
| category | GenericMDOProvider reads MDO lists with default settings |
| chartselection | |
| chatbot | List of all script folders that contain a script named like "%bot%register%" |
| chatchannel | |
| chatservice | |
| chatsessionstatus | Chat session status values |
| chatuser | |
| colorindex | List of named colors from the "ColorIndex" enum |
| combinedcontactpersonsearch | Provider for selecting a Person or a Contact, including search on contacts that match as well as persons. this provider wil |
| comptr | GenericMDOProvider reads MDO lists with default settings |
| consentpurpose | MDO list provider for ConsentPurpose |
| consentsource | MDO list provider for Consent source |
| contact | Provider for selecting a Contact - without person search |
| contactfavourite | MDO list provider for Favourites |
| contactperson_freetextsearch | Provider for selecting a Contact - with person search |
| contactphone | |
| contactrelationdefinition | MDO list provider for contact/person relation definitions. This provider is a takes a mandator |
| contactwithpersonsearch | Provider for selecting a Contact, including search on persons that match as well as contacts. this provider wil |
| contactwithpersonsearch_new | Provider for selecting a Contact, including search on persons that match as well as contacts. this provider wil |
| contact_freetextsearch | Provider for selecting a Contact - without person search |
| contact_new | Provider for selecting a Contact - without person search |
| contint | GenericMDOProvider reads MDO lists with default settings |
| createdocumenttemplateplugin | List of document plugins that can create document templates. |
| credentialgroup | List of user groups supported by a named creditial plugin, sorted by group name. |
| credited | GenericMDOProvider reads MDO lists with default settings |
| crmfields | |
| crmscript | Archive of CRMScripts. Returns script id + name of script as hierarchy. |
| culture | |
| culturesolanguage | List of SuperOffice cultures with old-style SO Culture name in ExtraInfo |
| currency | GenericMDOProvider reads MDO lists with default settings |
| currentudeffields | Get a list of udef fields for a given type. Pass the type as AdditionalInfo |
| customerlanguage | Customer Languages list. From the CustLang table. |
| dashboard | MDO list provider for Dashboard, can be used by Navigator. |
| dashboardcurrency | |
| dashboardentity | |
| dashboardtheme | |
| dashboardtile | MDO list provider for Dashboard tile |
| dashboardtileentitytype | List of dashboard tile types: Company, Project, Sale, Product, Activity, Web Panel |
| dashtilemeasure | |
| dayofmonth | MDO provider for the hard-coded list of day alternatives in the recurrence dialog. |
| deliveryterms | GenericMDOProvider reads MDO lists with default settings |
| deliverytype | GenericMDOProvider reads MDO lists with default settings |
| diaryowner | List provider that returns diary owners, i.e., our own employees plus resources |
| direction | Document and Task directions: TaskDirection.Incoming, Outgoing |
| disconnectpersonactions | List of actions to perform when disconnecting a contact from a company |
| doctmpl | GenericMDOProvider reads MDO lists with default settings |
| document | MDO list provider for documents. |
| documentcategory | |
| documentcompleted | Document completed status list: Not done, Done. |
| documentfavourite | MDO list provider for Favourites |
| documentgroup | Document types: TaskType.Document, Email, Fax, Merge draft, Merge Final. |
| documentmailing | Document shipments (mail merges). |
| documentmailingtemplate | Document mailing templates |
| documenttemplatelanguage | |
| documenttemplatesfiltered | MDO Provider for Document Templates, excluding Document details and quote mail templates, which are for system use rather than end-user choosing. |
| documenttypes | List of document types for the given plugin |
| efd_13 | Extra fields dropdown lists. Contains list of string values defined on the extra_field |
| ejcategory | EjCategoryProvider creates a flat or tree list based on the table: EJ_CATEGORY |
| ejuser | |
| emailaddress | List of e-mail addresses matching the search valu |
| emailfolder | EmailFolderProvider gives you the folder hierarchy of a given mail account |
| emailrecipient | List of most recent e-mail recipients cached for the current user. |
| erpactortype | |
| erpconnections | Retrieve the list of all defined Erp Connections (not Connectors, that's another list) |
| erpconnectors | Retrieve the list of all defined Erp Connectors (not Connections, that's another list) |
| erpdeliveryterms | Dynamic provider that dispatches Quote Connector lists, based on QuoteAlternativeId or SaleId and "Erp"+<list name> |
| erpdeliverytype | Dynamic provider that dispatches Quote Connector lists, based on QuoteAlternativeId or SaleId and "Erp"+<list name> |
| erpfields | |
| erppaymentterms | Dynamic provider that dispatches Quote Connector lists, based on QuoteAlternativeId or SaleId and "Erp"+<list name> |
| erppaymenttype | Dynamic provider that dispatches Quote Connector lists, based on QuoteAlternativeId or SaleId and "Erp"+<list name> |
| erpproductcategory | Dynamic provider that dispatches Quote Connector lists, based on QuoteAlternativeId or SaleId and "Erp"+<list name> |
| erpproductfamily | Dynamic provider that dispatches Quote Connector lists, based on QuoteAlternativeId or SaleId and "Erp"+<list name> |
| erpproducttype | Dynamic provider that dispatches Quote Connector lists, based on QuoteAlternativeId or SaleId and "Erp"+<list name> |
| eventhandlertype | Screen trigger event types: members of |
| everymonth | MDO provider for the hard-coded list of day month in the recurrence dialog. |
| executeonevent | List of windows client events to execute tasks on: Logon, Logoff, LocalUpdate |
| exporttemplate | MDO provider for the list of template files for the 'export to file' functio |
| extapp | GenericMDOProvider reads MDO lists with default settings |
| faqcategory | |
| faqreplytemplate | |
| faqreplytemplatefavourite | MDO list provider for Favourites |
| favouritetype | MDO list provider for Favourite types |
| filterassociates | Associate list for the Filter dialog. This associate list differs from the standard list in two ways |
| filterfuturedate | MDO provider for the hard-coded list of future date alternatives in the Filter dialog |
| filtergroups | User groups, filtered according to the usergroups selected in the filter dialog. |
| findproduct | QuickSearch for the Add Quote Line dialog, where a single-line user input is passed to th |
| fontsize | List of font types |
| fonttype | List of font types |
| form | Get all forms with folder hierarchy. Set ExtraInfo to "onlyActive" if you only want to get active forms |
| formfolder | EjCategoryProvider creates a flat or tree list based on the table: EJ_CATEGORY |
| formmailings | |
| formsubmissionstatusprovider | |
| freetextsearchentity | List provider that returns the entities supported by free text search. The extraInfo field contains th |
| functionrights | FunctionRightsListProvider returns a MDO list of function rights in the database |
| genericperson | List of persons with mail. Supports Selection(any type), project and associate |
| genericpersonwithmail | List of persons with mail. Supports Selection(any type), project and associate |
| groupview | GroupViewMDOProvider uses the AssociateMDOProvider + DiaryView to create the MDOlist for Groupview in Diary view. |
| heading | List provider for the Heading table. While this table looks like an MDO table |
| hierarchy | List provider for the Hierarchy table. Pass the domain using Additional info |
| htmlmailing | MDO provider for the different types of Mailings |
| htmlmailingtemplate | MDO provider for the different types of Mailing templates |
| importblankaction | Import actions for blank values: Use Person Name, Skip |
| importcontactduplicatematch | List of fields to match contact imports. |
| importduplicateaction | Import Duplicate actions: Add, Merge, Replace, Skip |
| importduplicateactionwithoutadd | Import duplicate; Merge, Replace, Skip |
| importfields | MDO provider for column headers used in import |
| importnewlistitem | Import list items: Add item, use default, use blank |
| importnewpositionitem | Import position items: Add to list, set to blank |
| importnewproductlistitem | Import product list items: add, use blank |
| importpersonduplicatematch | Import Person Fields to match on: Name, E-mail, phone, number, id, None |
| importphoneurlsemail | Import phone/url/email values: Add, Replace, Skip |
| importproductduplicatematch | Import product detect duplicates based on field: Name, Code, Name+Code |
| importproductfields | MDO provider for column headers used in import |
| intent | GenericMDOProvider reads MDO lists with default settings |
| iso639language | |
| kbentry | |
| language | |
| legalbase | MDO list provider for Legal base |
| lists | List of all MDO list providers. |
| locatecontact | Provider for selecting a Contact, including search on persons that match as well as contacts. this provider wil |
| locatecontact_new | Provider for selecting a Contact, including search on persons that match as well as contacts. this provider wil |
| locateperson | Person list with contact name. |
| location | Implements the mdo provider for the list of avaiable locations. This list aggregates element |
| mailhtmltemplate | List provider for the Mailtemplates. |
| mailing | All mailings - history ids |
| mailingfavourite | MDO list provider for Favourites |
| mailingstatus | |
| mailingsubscriptiontype | Mailing subscription types; Invitations, news, etc |
| mailingtemplate | General mailing templates |
| mailingtype | Mailing types: Html mail, SMS, Word Document |
| mailtemplate | List provider for the Mailtemplates. |
| mergedocument | MDO list provider for documents marked as type |
| mergetags | |
| month | MDO provider for the hard-coded list of "of" months in the recurrence dialog. |
| mrmrs | GenericMDOProvider reads MDO lists with default settings |
| nextavailabletime | |
| ofmonth | MDO provider for the hard-coded list of "of" months in the recurrence dialog. |
| ownercontact | MDO provider for listing owner contacts. |
| paymentterms | GenericMDOProvider reads MDO lists with default settings |
| paymenttype | GenericMDOProvider reads MDO lists with default settings |
| period | Period values: Day, Week, Month, Quarter, Year |
| periods | Period values: Day, Week, Month, Quarter, Year |
| persint | GenericMDOProvider reads MDO lists with default settings |
| person | List of persons from the Archive provider |
| personcontactfavourite | MDO list provider for Favourites |
| personcontact_freetextsearch | Provider for selecting a Person - with contact search |
| personemailaddress | List of e-mail addresses matching the search value, possibly restricted to a given company or person. |
| personfavourite | MDO list provider for Favourites |
| personphone | Search phone numbers for matching values, restricted to a given company or person. |
| personrestrictions | Implements a person mdolist provider that uses the conflicts detector to append information o |
| personurl | List of urls (web pages) matching the search value, possibly restricted to a given company or person. |
| personwithmail | List of persons fetched based on provided criteri |
| person_freetextsearch | Provider for selecting a Person - without contact search |
| perspos | GenericMDOProvider reads MDO lists with default settings |
| phonesearch | Search phone numbers for matching stripped numbers, across person and contacts |
| plugin | List of installed and available Document plugins |
| pmembtype | GenericMDOProvider reads MDO lists with default settings |
| prefdescline | PrefDesc creates a MDO list of prefdesclines for a given prefdesc id. |
| preferencekey | MDO Provider that retrieves a list of preference keys corresponding to a given section |
| preferencelineitem | |
| preferencesection | MDO Provider that retrieves a list of preference sections |
| pricelist | List of pricelists from the PriceList table |
| priceunit | GenericMDOProvider reads MDO lists with default settings |
| priority | GenericMDOProvider reads MDO lists with default settings |
| privacytemplate | This is a variant of the DocTmpl list - document templates - restricted to those that are of some privacy document type. |
| prob | GenericMDOProvider reads MDO lists with default settings |
| productcategory | GenericMDOProvider reads MDO lists with default settings |
| productfamily | GenericMDOProvider reads MDO lists with default settings |
| productimage | Return product images from the blob table |
| producttype | GenericMDOProvider reads MDO lists with default settings |
| project | Provider for selecting a project. |
| projectassociate | MDO provider for associates that are members of a project |
| projectfavourite | MDO list provider for Favourites |
| projectimage | Project images from the blob table |
| projectmemberwithmail | |
| projectstatus | List of project guide steps status values. |
| projecttype | Project type list. Encodes Default project duration in extra info. |
| projecttypeflatlist | Project type list. Encodes Default project duration in extra info. |
| project_freetextsearch | Provider for selecting a Project |
| project_new | Provider for selecting a project. Returns search results in rank orde |
| projstatus | GenericMDOProvider reads MDO lists with default settings |
| projtype | GenericMDOProvider reads MDO lists with default settings |
| quotealternatives | Quote alternative selector for one Quote Version. Send QuoteVersionId=<id> in ExtraInfo to specify quote version id |
| quoteapprovalassociate | MDO provider for associates that are allowed to approve a quote. |
| quoteapprovers | Retrieve the list of all users that can approve quotes |
| quoteapprreason | GenericMDOProvider reads MDO lists with default settings |
| quoteconnections | Retrieve the list of all defined Quote Connections - i.e. not the connectors (DLLs) |
| quoteconnectors | Retrieve the list of all installed (i.e., loaded assemblies) Quote Connectors |
| quotedenyreason | GenericMDOProvider reads MDO lists with default settings |
| quotedocumentgroupfields | Possible choices for fields that you can GROUP BY in quote detail documents. |
| quotedocumentorderbyfields | Possible choices for fields you can ORDER BY, within a group (or without grouping) |
| quotedocuments | |
| quotedocumenttype | List of quote document types - assumes ExtraInfo is the name of RecordType enum value |
| quotelinestatus | Hard-coded list of values for the QuoteLine.Status field, see |
| quotetemplate | This is a variant of the DocTmpl list - document templates - restricted to those that are of some quote document type |
| quoteversion | Quote version selector for one Quote. Send QuoteId=<id> in ExtraInfo to specify quote id |
| quoteversionstate | List provider for the |
| reason | GenericMDOProvider reads MDO lists with default settings |
| reasonsold | GenericMDOProvider reads MDO lists with default settings |
| reasonstalled | GenericMDOProvider reads MDO lists with default settings |
| recordtype | A complete and generic mapping of record types to resource strings |
| recurrenceweekcycle | MDO provider for the hard-coded list of week cycle alternatives in the recurrence dialog. |
| rejectreason | GenericMDOProvider reads MDO lists with default settings |
| relateddatafields | |
| relationssearchlistproviderappointmentactive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistproviderappointmentappointmentactive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistproviderappointmentappointmentpassive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistproviderappointmentdocumentactive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistproviderappointmentdocumentpassive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistproviderappointmentpassive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistproviderappointmentsaleactive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistproviderappointmentsalepassive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistprovidercontactactive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistprovidercontactcontactactive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistprovidercontactcontactpassive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistprovidercontactpassive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistprovidercontactpersonactive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistprovidercontactpersonpassive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistproviderdocumentactive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistproviderdocumentappointmentactive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistproviderdocumentappointmentpassive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistproviderdocumentdocumentactive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistproviderdocumentdocumentpassive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistproviderdocumentpassive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistproviderdocumentsaleactive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistproviderdocumentsalepassive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistproviderpersonactive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistproviderpersoncontactactive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistproviderpersoncontactpassive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistproviderpersonpassive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistproviderpersonpersonactive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistproviderpersonpersonpassive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistprovidersaleactive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistprovidersaleappointmentactive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistprovidersaleappointmentpassive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistprovidersaledocumentactive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistprovidersaledocumentpassive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistprovidersalepassive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistprovidersalesaleactive | Serve the active and passive texts of relations, with a given table as source (active |
| relationssearchlistprovidersalesalepassive | Serve the active and passive texts of relations, with a given table as source (active |
| replytemplate | |
| reportcategory | ReportCategoryProvider creates an MDO list that consists of the values in |
| reportlayout | ReportCategoryProvider creates an MDO list that consists of the values in |
| resource | MDO provider for resources (from the associate table) |
| resourcerestrictions | MDO provider for resources (from the associate table) that uses restrictions to includ |
| restrictionoperators | This SoList provider will generate the operator list for a given search criterion data type. The data type i |
| roles | RoleListProvider creates a MDO list of roles in the database |
| saintactivitytype | This SoList provider generates the appointment/task type list for the Saint criteria. This is a simple, hard-coded list correspondin |
| saintamountclass | This SoList provider generates the amount class list for the Saint criteria. This list is an extension of the basi |
| saintdirection | This SoList provider generates the appointment/task direction list for the Saint criteria. This is a simple, hard-coded list correspondin |
| saintintention | This SoList provider generates the Intent list for the Saint criteria. This list is an extension of the basi |
| saintsalestatus | This SoList provider generates the sale status list for the Saint criteria. This is a simple, hard-coded list correspondin |
| saintticketcategory | This SoList provider generates the eJournal top-level categories, meant for the saint system |
| 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 | List of sales |
| salecategory | |
| saledone | Sale Done status: SaleDone.Done or NotDone. |
| salefavourite | MDO list provider for Favourites |
| saleguidestage | MDO provider for the stage list, customized for the sale guide stage button row |
| saleprobability | MDO list provider for the probability list of the Sale dialog. This list extends the basic |
| salesource | MDO list provider for the source list of the Sale dialog |
| salestage | Provider for selecting a stage. AdditionalInfo is used as criteria to filter stages based on SaleType. |
| salestatus | List for the Sale.Status field: Open, Lost, Sold, Stalled. |
| saletype | List of sale types, with default sale duration in minutes in extra info. |
| saletypecat | GenericMDOProvider reads MDO lists with default settings |
| saletypecategories | SaleTypeCategories creates a MDO list of sale type categories in the database. |
| sale_freetextsearch | Provider for selecting a Sale |
| sale_new | List of sales |
| salutation | GenericMDOProvider reads MDO lists with default settings |
| satellites | SatelliteProvider creates a MDO list of satellites. |
| searchcat | GenericMDOProvider reads MDO lists with default settings |
| selection | Provider for selecting a selection |
| selectioncriteriamembertype | |
| selectionfavourite | MDO list provider for selection favourites |
| selectionmembertype | MDO provider for the selection archive providers types |
| selectionmembertypeclean | |
| selectionmembertypev2 | MDO provider for the selection archive providers types |
| selectionmemberwithmail | List of selection members fetched based on provided criteri |
| selectiontype | MDO provider for the hard-coded list of selection kinds: Static, Dynamic, Combined |
| selectionuniontype | Different ways to combine selections: Union, Intersect, Disjoin, Left or Right Subtraction. |
| selection_freetextsearch | Provider for selecting a Selection |
| sentiment | |
| serviceassociate | MDO provider for associates that are allowed to approve a quote. |
| shipmentaddrstatusprovider | |
| shipmenttype | MDO list provider for ConsentPurpose |
| simplemailingstatus | |
| smsmailing | SMS Shipment names |
| smsmailingtemplate | SMS Mailing templates |
| source | GenericMDOProvider reads MDO lists with default settings |
| sourceproduct | Products: Sales & Marketing, Customer Service |
| stakeholderrole | GenericMDOProvider reads MDO lists with default settings |
| statusdef | Return list of status monitors defined in the system |
| statusmonitorimage | List of images for status monitors in the blob table. |
| stopword | List of stop words. i.e. words which will not be included in the free-text index. |
| subscriptionunit | GenericMDOProvider reads MDO lists with default settings |
| suggestedappointment | Suggested Appointment Provider creates a MDO list of suggested appointments for a given guide stage. |
| suggesteddocument | SuggestedDocumentProvider creates a MDO list of suggested documents in the database. |
| suggestedstopword | Analyze free text records and suggest stop words based on word frequency |
| systemeventtype | System event types: NoLogin, NoFreeText, NoTravel, Message-of-the-day |
| tags | GenericMDOProvider reads MDO lists with default settings |
| targetentitytype | TargetEntities |
| targetmeasurementunit | MeasurementUnits |
| targettypes | |
| targetyear | Year MDO list. Includes the two coming years, this year, and previous 5 years |
| task | Task table MDO list. Optional include "None" as first value. |
| taskmenu | GenericMDOProvider reads MDO lists with default settings |
| taskmenudestination | |
| taskmenugroup | List of TaskMenus with visible for groups as commaseperated ids in extrainfo field |
| ticket | Provider for selecting a ticket |
| ticketalert | |
| ticketfavourite | |
| ticketorigin | Ticket Origin |
| ticketpriority | MDO list provider for ticket priorities. |
| ticketpriorityescalateevent | MDO list provider for ticket Priority EscalateEvents enum. |
| ticketread | |
| ticketselectionwithstaticmenu | Provider for selecting ticket selections |
| ticketslevel | Ticket Security Level |
| ticketstatus | Ticket status values: Open, Closed, Inactive, Deleted, Connected |
| ticketstatustimecounter | Ticket status timer count values: None, Internall, Externally, Queue |
| ticketstatuswithpostpone | |
| ticketticketstatus | TicketTicketStatusProvider creates a flat list based on the table: TICKET_STATUS |
| ticket_freetextsearch | Provider for selecting a Ticket - with contact and person search |
| time | MDO provider for the hard-coded list of time alternatives in the appointment dialog and in edit/preference |
| timezone | Provides the timezone list |
| timezonewithcode | Provides the timezone list. The country code is given in the type field |
| typegroup | Type Group: Task, Activity, Document, Sale |
| typicalsearch | MDO provider for the TypicalSearch Title, Tooltip and I |
| udeffields | Get a list of udef fields for a given type |
| udeffieldswithchanges | Get a list of udef fields for a given type |
| udeffieldtype | |
| udlist | MDO Provider for 'user-defined' lists, i.e., those that reside in the UDList table. Mandatory additionalInfo is th |
| udlist28 | Dynamic MDO provider that will create a list with the name udlist<id> for each user-defined list in the UDListDefinition table |
| udlist30002 | MDO provider for the ChatService |
| urlencoding | |
| usergroup | List provider for the UserGroup table. While this table looks like an MDO table |
| usergroupwithhistoryall | List provider for the UserGroup table. While this table looks like an MDO table |
| userplan | List provider for the UserPlan in the module license table |
| usertype | Simple, hard-coded provider for the associate type: Employee, ExternalPerson, Resource, Anonymous, System, Invalid User Type |
| visiblefor | List provider for the VisibleFor dropdown control. Items are of type associate, usergroup or all, wit |
| visibleforassociate | List provider that returns a list suitable for VisibleFor and PinTo (with groups and possibly some other special items like All). |
| visiblein | Visible in list for web panels. |
| visibleinmenu | Visible in menu list: Toolbox menu, View menu |
| visibleintask | Visible in list for tasks: places where task button can appear. |
| webpanel | List of WebPanels visible possible for use with groups and headings. |
| webpanelgroup | List of WebPanels with visible for groups as commaseperated ids in extrainfo field |
| weekday | MDO provider for the hard-coded list of week days. |
| weeknumber | MDO provider for the hard-coded list of numbered weeks in the recurrence dialog. |
| y_equipment | Extra tables lists. List names are 'y_xyz' - based on the custom table name |