This class is used to get sequence numbers (primary keys) for tables, where the physical sequence table is updated in batches.
A class decorated with this attribute represents a factory (possibly one of many) of TableInfo objects, and this attribute contains info about the dictionary steps the factory was generated for. Only the highest numbered step for each name is flagged
Class which can convert entities into datasets.
Class containing static methods to convert back and from the database.
Constants used in the data dictionary
Field types as used in the data dictionary, taken from the Excel master data dictionary. Note that the constants are in some cases not unique (Double and Float both have 16), this is for historical reasons.
These constants should be used to interpret the
Class containing a dictionary of all import columns available
Sometimes you need to save a number of Row or other kind of updating objects, and want to do so efficiently and in a single transaction. If so, add them to an instance of this class, and ultimately persist everything using Save.
Default implementation of INestedPersist.
Container for objects that need keys.
Cache for Preference Descriptions, stored in the prefdesc table. Since this table is only updated during upgrades, which imply a recycle anyway, it has a lifetime limited only by the database connection. There are about 700 prefdesc rows
Helper class for executing queries. This class encapsulates the process of getting a connection, making a command, running it, and cleaning up afterwards.
QuoteRights are used for quoteline and product rights Rights can be one of: N (=None or Hidden), R (=Read-only), W (=Writeable), M (=Mandatory).
Class used to contain and build information record, used to populate relation datastructures, like DataSet.
Class which can convert entities into sets of Record-instances.
Class used to contain a record's value. Include actual value and its defined type.
Utility class for dealing with reference counters.
Keeper of all functions that work on both FieldInfos and Parameters.
Class containing different static methods to support the modification of the resultset.
Use with the additionalInfo parameter for the MDO list
Utility functions for getting primary keys. Keys are "burned" permanently and cannot be re-used. Key reservation is a potential bottleneck, so if you know in advance how many keys you will need, you should reserve them in one call.
Handle the mapping of some sections in userpreference to actually be stored in the config, registry and password_rules tables; backwards compatibility with Service
The actual mapping definitions between the "pseudo" preferences an records in config, registry and possibly other tables
Implements the IDbCommand.
This class implements the IDbConnection interface, and is the wrapper used to represent a connection against a physical database. The actual connection is an inner object and is a database-specific class, potentially provided by a dynamically loaded assembly (sybase and db/2).
Hold information about a SuperOffice CRM5 database and its licenses.
Implements the IDataReader interface.
Utility class for subscribing to changes in the database. The current implementation only handles changes made from this instance of NetServer.
Attribute declaring a soft trigger.
Represents a parameter to a Command object. Implements IDbDataParameter, IDataParameter
Reads user preferences at several levels, returning the preference value that is defined at the lowest level.
A user preference defined at level 5 is more specific than a preference read at level 2.
Base class The purpose of this class is to return arguments to a sqlcommand. It contains a generated sql query and a collection of SoParameter. In order to create a command parametercollection the class uses SuperOffice.Data.SoSqlParameter.AddParametersToCommand(System.Data.IDbCommand) with a parameter IDbCommand object to build the collection
Represents a transaction to be performed at a data source, and is implemented by .NET Framework data providers that access relational databases.
Use with the additionalInfo parameter for the MDO list
This class contains helper functions for publishing user-defined fields.
Factory for generated TableInfo classes, supports both typed, named and generic lookups of tables
This class contains helper functions for handling conversion of user-defined fields from one type to another.
This class contains helper functions for handling user-defined fields.
This class contains helper functions for publishing user-defined fields.
Interface for classes which can convert entities into datasets.
Interface to be implemented by objects that are to take place in a nested persist (INSERT/UPDATE to the database).
Interface for classes which can convert entities into sets of Record-instances.
A version of IDataRecord customized for superoffice - using FieldInfo to look up fields, and missing some of the more obscure functions that we don't use. Intended for iteration over result sets
Interface implemented by soft trigger subscribers
Support for database modifications.
Completed status enum common to appointments, documents and sales
The type of Address This Enum is used by: address.atype_idx
Is this an all day event: 0 = No, 1 = Yes This Enum is used by: appointment.alldayEvent; Task.defaultAlldayEvent
Value for the availableInState field in table externalapplication This Enum is used by: ExtApp.availableInState This Enum consists of flag values that can be combined.
Appointment and invitation synchronization info This Enum is used by: appointment.cautionWarning
Value for field 'private' in table 'appointment'. This Enum is used by: appointment.private
Value for field 'status' in table 'appointment'. This Enum is used by: appointment.status
Value for field 'type' in table 'appointment'. This Enum is used by: appointment.type
Status if this appointment is in the process of being assigned to someone else
Field Type in table associate This Enum is used by: associate.type; AssociateHistory.type This Enum consists of flag values that can be combined.
The link type, often synonymous with the blob type, of a BinaryObjectLink row This Enum is used by: BinaryObjectLink.linkType
The type of booking the appointment represents
Valid iCal methods
iCal reply status
Chat Message Special type This Enum is used by: chat_message.special_type
Chat Message type This Enum is used by: chat_message.type
Value for field 'flags' in table 'chat_session'. This Enum is used by: chat_session.flags This Enum consists of flag values that can be combined.
Chat Session status This Enum is used by: chat_session.status
Value for field 'chat_status' in table 'ejuser'. This Enum is used by: ejuser.chat_status
Chat Topic flags This Enum is used by: chat_topic.flags This Enum consists of flag values that can be combined.
Chat widget size: normal or large
Color index of tasks
Result of an action
Conceptual image types
Value for field 'type' in table 'cust_config'. This Enum is used by: cust_config.type
Types of control used with user administration work with credentials
What kind of usage is this credential for This Enum is used by: Credentials.isActive
Actor type within the CRM, system, a subset of the SuperOffice Entity types This Enum is used by: ErpConnectionActorType.ActorTypeCrm
Defines which authentication info to add when creating a CS Url
Defines the authentication type of a logged in user in the login table
Defines the origina of a logged in user in the login table
Defines the status of a logged in user in the login table
Custom Field type: 1 = Number, 2 = Short text, 3 = Long text, 4 = Date, 5 = Unlimited date, 6 = Checkbox, 7 = Drop-down listbox, 8 = Decimal, 9 = DateTime, 10 = Time, 11 = TimeSpan, 12 = Relation, 13 = Attachment
Dashboard tile entity type
Dashboard tile option type
Dashboard tile type
Dashboard tile currency mode This Enum is used by: dashboard_tile_definition.currency_mode
Dashboard tile entity type (V2) This Enum is used by: dashboard_tile_definition.entity_type
Dashboard tile measure This Enum is used by: dashboard_tile_definition.measure
Dashboard tile chart type (V2) This Enum is used by: dashboard_tile_definition.tile_type
Enums for the data types used in the database
State of delta This Enum is used by: ConfigurableScreenDelta.deltaState
Type and content of delta This Enum is used by: ConfigurableScreenDelta.deltaType
Indicates what design type this message is created with This Enum is used by: s_message.designtype
Value for field 'direction' in table 'doctmpl'. This Enum is used by: DocTmpl.direction
Is this document template some kind of appointment document, and if so what This Enum is used by: DocTmpl.invitationDocType
Is this document template some kind of quote document, and if so what This Enum is used by: DocTmpl.privacyDocType
Is this document template some kind of quote document, and if so what This Enum is used by: DocTmpl.quoteDocType
Value for field 'record_type' in table 'doctmpl'. This Enum is used by: DocTmpl.record_type
Units of duration - from seconds to centuries This Enum is used by: ProjType.durationUnit; SaleType.durationUnit
Access levels to a single field. Read and/or write. This Enum consists of flag values that can be combined.
Defined in Clients\CS\lib\rms\UserLib.h, any changes must be kept in sync!
Status for adding attributes to an element in a statical list This Enum is used by: s_list_element.status
Possible statuses for an EmailAccount. This Enum is used by: email_account.account_status
This Enum is used by: email_item.flags This Enum consists of flag values that can be combined.
What type of delivery system to use for a mail merge
This Enum is used by: email_item.priority
What kind of email address - email, or some other communication type (chat, voip) This Enum is used by: Email.type
Actor type within the ERP system, related but not identitcal to SuperOffice Entity type This Enum is used by: ErpConnectionActorType.ActorTypeErp; ErpExternalKey.ActorType
Response codes used by ErpSync services
Table right is a combination of bits representing permissions on a row. This Enum consists of flag values that can be combined.
CrmScript Event triggers - when CRMScript is run based on user or system actions.
Value for the executeOnEvent field in table externalapplication This Enum is used by: ExtApp.executeOnEvent
String, int, decimal, image, url, etc. How should the value be interpreted.
Flag values for the CS extrafields dictionary This Enum consists of flag values that can be combined.
Access restrictions and mandatory status, if any. This Enum is used by: ErpField.Access
Datatype of the field in the database
Describes the different types of controls that can appear in the Configure connection dialog This Enum is used by: ErpField.FieldType
Forms recaptcha mode
What is the status of this submission This Enum is used by: form_submission.status
What kind of form is this This Enum is used by: form.type
What kind of time is this: 0 = Busy, 1 = Free This Enum is used by: appointment.freeBusy; Task.defaultFreeBusy
Action being done for the import row This Enum consists of flag values that can be combined.
Import action for blank values
Action for blank companys for import
Contact duplicate matching for import
Duplicate action for import
Entitys type for import This Enum consists of flag values that can be combined.
Import new list item
Person duplicate matching for import
Import new list item
Product duplicate matching for import
Operators to be used between restrictions, describes how this restriction is related to the next one in an array
Status if this appointment represents an invitation
Licence type, as defined in the ModuleLicence.LicenceType field in the database
The type of the locale text strings
Bits in login.flags This Enum is used by: login.flags This Enum consists of flag values that can be combined.
Service mailbox type This Enum is used by: mail_in_filter.server_type
List sort order, global for all lists
Value for the navigation field in table externalapplication This Enum is used by: ExtApp.navigation
Defines what type of content the notification contains
Value for field 'DevicePlatform' in table 'PushNotificationService' This Enum is used by: PushNotificationService.DevicePlatform
How to sort the Order by statement.
The type of the appointment's participant
The type of Phone This Enum is used by: phone.ptype_idx
Value for field 'accessflags' in table 'prefdesc'. This Enum is used by: PrefDesc.accessFlags This Enum consists of flag values that can be combined.
Value for field 'valueType' in table 'prefdesc'. This Enum is used by: PrefDesc.valueType
Value for field 'deflevel' in table 'userpreference'. This Enum is used by: UserPreference.deflevel; UserPreference.maxlevel; PrefDesc.maxLevel; PrefDesc.sysMaxLevel
Should this field be published by default? This Enum is used by: Task.defaultPublishType; DocTmpl.defaultPublishType; Publish.publishType
What kind of query - one that returns a reader with results, or some other kind
The state of a quote-alternative or line This Enum is used by: QuoteVersion.Status; QuoteAlternative.Status; QuoteLine.Status
Possible actions for QuoteVersionButton states.
State of a Quote Version This Enum is used by: QuoteVersion.State; QuoteVersion.ArchivedState
The different types of recipient sorting available This Enum is used by: s_shipment.sorting
Enumerator describing the different patterns for a daily recurrence
Enumerator describing how the series of recurring activities are terminated.
Enumerator describing the different patterns for a monthly recurrence
Enumerator describing the main pattern of recurrence. This Enum is used by: RecurrenceRule.pattern
Appointment recurrence change mode: only this, this and forward, stop
Enumerator describing the different patterns for a yearly recurrence
Value for flag field in refcounts This Enum is used by: RefCounts.flags This Enum consists of flag values that can be combined.
Target type of relation. (Contact, person or both)
The avaliable category
Describes the orientation of the paper when printing a report. The report layout must be "Label"
0 = employee, 1 = external user, 2 = anonymous This Enum is used by: Role.roleType
Specifies the direction of which to round a DateTime
Saint counters - what is counted (kind of activity)
Target of saint data, contact or project
Values for the 'done' field in the sale table This Enum is used by: sale.done; SaleHist.done
Constant index values for sale stage
Value for the 'status' field in the sale table This Enum is used by: sale.status; SaleHist.status; CounterValue.sale_status
CS system event types for custom logic hooking This Enum is used by: ticket_relation_action.event
Member type of a selection
Selection system type - defines if this selection is one that is managed by the system, and what kind it is This Enum is used by: selection.SystemType
Selection type - static/dynamic/combined. Works together with targetTable to define what kind of Selection this is.
How the selections in a combined selections should be put together This Enum is used by: selection.combinationType
Sender email mode This Enum is used by: DocTmpl.senderEmailMode
Possible statuses for a ServiceAuth. This Enum is used by: service_auth.auth_status
Status for sending to a particular recipient This Enum is used by: s_shipment_addr.status
Bitmask defining what action should be taken This Enum is used by: s_link.action_flags This Enum consists of flag values that can be combined.
Flags that control how the task is created This Enum is used by: s_link.task_flags This Enum consists of flag values that can be combined.
Customer action type (clicked a link, viewed an image etc) This Enum is used by: s_link_customer.link_type; s_link_customer_statical.link_type This Enum consists of flag values that can be combined.
Status of shipment list This Enum is used by: s_list_shipment.status
Bitmask defining what type of shipment message this is This Enum is used by: s_message.flags This Enum consists of flag values that can be combined.
Status for shipment (started, cancelled etc) This Enum is used by: s_shipment.status
Value for the showState field in table externalapplication This Enum is used by: ExtApp.showState This Enum consists of flag values that can be combined.
Normal = 0, Maximized = 1, Minimized = 2 This Enum is used by: WinPosSize.state
Version of the deployed database
Enumeration that exposes what search types that are supported.
Value for field 'scope' in table 'systemevent'.
Target Entity of Tags This Enum consists of flag values that can be combined.
Value for field 'direction' in table 'task'. Controls icons used in GUI This Enum is used by: Task.direction
Value for field 'record_type' in table 'task'. Controls icons used in GUI This Enum is used by: Task.record_type
Domains for temporary keys. This Enum is used by: TemporaryKey.domain
Value for field 'type' in table 'text'. This Enum is used by: text.type
Status of a ticket/request This Enum is used by: ticket.status; ticket_status.status
Default status for requests. Note that this is a preference which should be respected if making UI. It is not enforced by the APIs This Enum is used by: ej_category.closing_status; ej_category.msg_closing_status
The delegate method used for request assigned to this category This Enum is used by: ej_category.delegate_method
Flags for the ticket category This Enum is used by: ej_category.flags This Enum consists of flag values that can be combined.
Classification of ticket messages This Enum is used by: ej_message.message_category
Indicates if the field body contains plain or html text This Enum is used by: ej_message.type
Communication channel leading to ticket being created This Enum is used by: ticket.origin
The different types of escalate events that can be set This Enum is used by: ticket_priority.ticket_read; ticket_priority.changed_owner; ticket_priority.ticket_newinfo; ticket_priority.ticket_closed; ticket_priority.ticket_changed_priority; ticket_priority.ticket_new
Flags for the ticket priority This Enum is used by: ticket_priority.flags This Enum consists of flag values that can be combined.
Status of the ticket priority This Enum is used by: ticket_priority.status
Whether the owner has read the ticket or not (red, yellow, green) This Enum is used by: ticket.read_status
Indicates if a ticket is external or internal This Enum is used by: ej_message.slevel; ticket.slevel
Which field in ticket we count time spent on This Enum is used by: ticket_status.time_counter
Value for the encryptedComm field in traveller This Enum is used by: traveller.encryptedComm
Value for the encryptedComm field in travelcurrent This Enum is used by: travelcurrent.encryptedComm
Value for field type in traveltransctionlog This Enum is used by: traveltransactionlog.type
Flag bits for extra information in TravelTransactionLog This Enum is used by: traveltransactionlog.flags This Enum consists of flag values that can be combined.
Field type: 1 = Number, 2 = Short text, 3 = Long text, 4 = Date, 5 = Unlimited date, 6 = Checkbox, 7 = Drop-down listbox, 8 = Decimal
Justification - 0 = default, left, right, center This Enum is used by: UDefField.justification
Same as the EUDefType enum in the C++ client, this is the DATABASE value used for udef definitions
Upsert: Action to take on target table rows that do not match any incoming keys
Upsert: Action status for each row
Has a pre-calculated value been overriden in a QuoteAlternative or QuoteLine, and in that case what & how? This Enum is used by: QuoteAlternative.UserValueOverride; QuoteLine.UserValueOverride
Default video-meeting status for meetings created in SuperOffice CRM This Enum is used by: Task.default_videomeeting_status
The visibility of the record
Webhook status: active, stopped, or tooManyErrors This Enum is used by: Webhook.state
Enumerator for the days of the week This Enum consists of flag values that can be combined.
Enumerator representing a week of the month
Chat Topic required fields in pre-form. This Enum is used by: chat_topic.widget_offline_fields; chat_topic.widget_required_fields This Enum consists of flag values that can be combined.
Chat Topic widget_theme: classic(0) or modern(1). This Enum is used by: chat_topic.widget_theme
Delegate describing that an element received a primary key
Delegate describing that an element was saved to the database
Custom decoding from stored value to preference string value
Custom encoding from preference string value to stored value
Delegate implemented by subscribers to be notified on changes in the database taking place.