Class ContactRecordData
POCO (Plain Old CLR Object) class that can be used to hold data corresponding to a row from the contact table.
Inherited Members
Namespace: SuperOffice.CRM.Rows
Assembly: SoDataBase.dll
Syntax
public class ContactRecordDataRemarks
Please use this class instead of a full ContactRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ContactTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
Constructors
ContactRecordData()
Declaration
public ContactRecordData()Fields
ActiveErpLinks
The number of Erp Sync connections this record is synced with; count of the ErpExternalKey+ErpInternalKey relations
Declaration
public int ActiveErpLinksField Value
| Type | Description |
|---|---|
| Int32 |
ActiveInterests
Number of records in cintr table; select count(*) from cintr ci where ci.contact_id = this.contact_id == activeInterests is always true
Declaration
public short ActiveInterestsField Value
| Type | Description |
|---|---|
| Int16 |
AssociateId
Our contact
Declaration
public int AssociateIdField Value
| Type | Description |
|---|---|
| Int32 |
BusinessIdx
Link to Business
Declaration
public int BusinessIdxField Value
| Type | Description |
|---|---|
| Int32 |
CategoryIdx
Link to Category
Declaration
public int CategoryIdxField Value
| Type | Description |
|---|---|
| Int32 |
ContactId
Primary key
Declaration
public int ContactIdField Value
| Type | Description |
|---|---|
| Int32 |
CountryId
Country
Declaration
public int CountryIdField Value
| Type | Description |
|---|---|
| Int32 |
DbiAgentId
Integration agent (eJournal)
Declaration
public int DbiAgentIdField Value
| Type | Description |
|---|---|
| Int32 |
DbiKey
The primary key for the integrated entry in the external datasource.
Declaration
public string DbiKeyField Value
| Type | Description |
|---|---|
| String |
DbiLastModified
When the entry was last modified.
Declaration
public DateTime DbiLastModifiedField Value
| Type | Description |
|---|---|
| DateTime |
DbiLastSyncronized
Last external syncronization.
Declaration
public DateTime DbiLastSyncronizedField Value
| Type | Description |
|---|---|
| DateTime |
Deleted
If nonzero, then this contact is 'deleted' and should generally not be shown
Declaration
public short DeletedField Value
| Type | Description |
|---|---|
| Int16 |
DeletedDate
Datetime (utc) when this record was soft-deleted; if this value is set then the record should not be shown in UTC.
Declaration
public DateTime DeletedDateField Value
| Type | Description |
|---|---|
| DateTime |
Department
Department
Declaration
public string DepartmentField Value
| Type | Description |
|---|---|
| String |
GroupId
Group id of original owning associate, semantics like appnt.grp_id
Declaration
public int GroupIdField Value
| Type | Description |
|---|---|
| Int32 |
Kananame
Contact kana name, used in Japanese versions only
Declaration
public string KananameField Value
| Type | Description |
|---|---|
| String |
MotherId
Reserved
Declaration
public int MotherIdField Value
| Type | Description |
|---|---|
| Int32 |
Name
Contact name
Declaration
public string NameField Value
| Type | Description |
|---|---|
| String |
Nomailing
No mailings flags
Declaration
public short NomailingField Value
| Type | Description |
|---|---|
| Int16 |
Number1
Alphanumeric user field
Declaration
public string Number1Field Value
| Type | Description |
|---|---|
| String |
Number2
Alphanumeric user field
Declaration
public string Number2Field Value
| Type | Description |
|---|---|
| String |
OrgNr
VAT number or similar
Declaration
public string OrgNrField Value
| Type | Description |
|---|---|
| String |
Registered
Date registered in UTC.
Declaration
public DateTime RegisteredField Value
| Type | Description |
|---|---|
| DateTime |
RegisteredAssociateId
Registered by whom
Declaration
public int RegisteredAssociateIdField Value
| Type | Description |
|---|---|
| Int32 |
SoundEx
What the name sounds like, for duplicate detection
Declaration
public string SoundExField Value
| Type | Description |
|---|---|
| String |
Source
How did we get this contact? For future integration needs
Declaration
public short SourceField Value
| Type | Description |
|---|---|
| Int16 |
SupportAssociateId
Our contact, but for support context, not sales/primary contact
Declaration
public int SupportAssociateIdField Value
| Type | Description |
|---|---|
| Int32 |
SupportLanguageId
Customers language (does not necessarily map to ISO languages)
Declaration
public int SupportLanguageIdField Value
| Type | Description |
|---|---|
| Int32 |
SupportPersonId
The person (at the customer) who support talks to (the counterpart of supportAssociateId)
Declaration
public int SupportPersonIdField Value
| Type | Description |
|---|---|
| Int32 |
TextId
Paperclip note
Declaration
public int TextIdField Value
| Type | Description |
|---|---|
| Int32 |
TicketPriorityId
Default ticket priority for new tickets
Declaration
public int TicketPriorityIdField Value
| Type | Description |
|---|---|
| Int32 |
TzLocationId
Default timezone location for this contact
Declaration
public int TzLocationIdField Value
| Type | Description |
|---|---|
| Int32 |
Updated
Date last updated in UTC.
Declaration
public DateTime UpdatedField Value
| Type | Description |
|---|---|
| DateTime |
UpdatedAssociateId
Last updated by whom
Declaration
public int UpdatedAssociateIdField Value
| Type | Description |
|---|---|
| Int32 |
UpdatedCount
Number of times updated
Declaration
public short UpdatedCountField Value
| Type | Description |
|---|---|
| Int16 |
Userdef2Id
User defined table record 2
Declaration
public int Userdef2IdField Value
| Type | Description |
|---|---|
| Int32 |
UserdefId
User defined table record 1
Declaration
public int UserdefIdField Value
| Type | Description |
|---|---|
| Int32 |
Xstop
STOP flag
Declaration
public short XstopField Value
| Type | Description |
|---|---|
| Int16 |