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 ContactRecordData
Remarks
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 ActiveErpLinks
Field 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 ActiveInterests
Field Value
Type | Description |
---|---|
Int16 |
AssociateId
Our contact
Declaration
public int AssociateId
Field Value
Type | Description |
---|---|
Int32 |
BusinessIdx
Link to Business
Declaration
public int BusinessIdx
Field Value
Type | Description |
---|---|
Int32 |
CategoryIdx
Link to Category
Declaration
public int CategoryIdx
Field Value
Type | Description |
---|---|
Int32 |
ContactId
Primary key
Declaration
public int ContactId
Field Value
Type | Description |
---|---|
Int32 |
CountryId
Country
Declaration
public int CountryId
Field Value
Type | Description |
---|---|
Int32 |
DbiAgentId
Integration agent (eJournal)
Declaration
public int DbiAgentId
Field Value
Type | Description |
---|---|
Int32 |
DbiKey
The primary key for the integrated entry in the external datasource.
Declaration
public string DbiKey
Field Value
Type | Description |
---|---|
String |
DbiLastModified
When the entry was last modified.
Declaration
public DateTime DbiLastModified
Field Value
Type | Description |
---|---|
DateTime |
DbiLastSyncronized
Last external syncronization.
Declaration
public DateTime DbiLastSyncronized
Field Value
Type | Description |
---|---|
DateTime |
Deleted
If nonzero, then this contact is 'deleted' and should generally not be shown
Declaration
public short Deleted
Field 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 DeletedDate
Field Value
Type | Description |
---|---|
DateTime |
Department
Department
Declaration
public string Department
Field Value
Type | Description |
---|---|
String |
GroupId
Group id of original owning associate, semantics like appnt.grp_id
Declaration
public int GroupId
Field Value
Type | Description |
---|---|
Int32 |
Kananame
Contact kana name, used in Japanese versions only
Declaration
public string Kananame
Field Value
Type | Description |
---|---|
String |
MotherId
Reserved
Declaration
public int MotherId
Field Value
Type | Description |
---|---|
Int32 |
Name
Contact name
Declaration
public string Name
Field Value
Type | Description |
---|---|
String |
Nomailing
No mailings flags
Declaration
public short Nomailing
Field Value
Type | Description |
---|---|
Int16 |
Number1
Alphanumeric user field
Declaration
public string Number1
Field Value
Type | Description |
---|---|
String |
Number2
Alphanumeric user field
Declaration
public string Number2
Field Value
Type | Description |
---|---|
String |
OrgNr
VAT number or similar
Declaration
public string OrgNr
Field Value
Type | Description |
---|---|
String |
Registered
Date registered in UTC.
Declaration
public DateTime Registered
Field Value
Type | Description |
---|---|
DateTime |
RegisteredAssociateId
Registered by whom
Declaration
public int RegisteredAssociateId
Field Value
Type | Description |
---|---|
Int32 |
SoundEx
What the name sounds like, for duplicate detection
Declaration
public string SoundEx
Field Value
Type | Description |
---|---|
String |
Source
How did we get this contact? For future integration needs
Declaration
public short Source
Field Value
Type | Description |
---|---|
Int16 |
SupportAssociateId
Our contact, but for support context, not sales/primary contact
Declaration
public int SupportAssociateId
Field Value
Type | Description |
---|---|
Int32 |
SupportLanguageId
Customers language (does not necessarily map to ISO languages)
Declaration
public int SupportLanguageId
Field Value
Type | Description |
---|---|
Int32 |
SupportPersonId
The person (at the customer) who support talks to (the counterpart of supportAssociateId)
Declaration
public int SupportPersonId
Field Value
Type | Description |
---|---|
Int32 |
TextId
Paperclip note
Declaration
public int TextId
Field Value
Type | Description |
---|---|
Int32 |
TicketPriorityId
Default ticket priority for new tickets
Declaration
public int TicketPriorityId
Field Value
Type | Description |
---|---|
Int32 |
TzLocationId
Default timezone location for this contact
Declaration
public int TzLocationId
Field Value
Type | Description |
---|---|
Int32 |
Updated
Date last updated in UTC.
Declaration
public DateTime Updated
Field Value
Type | Description |
---|---|
DateTime |
UpdatedAssociateId
Last updated by whom
Declaration
public int UpdatedAssociateId
Field Value
Type | Description |
---|---|
Int32 |
UpdatedCount
Number of times updated
Declaration
public short UpdatedCount
Field Value
Type | Description |
---|---|
Int16 |
Userdef2Id
User defined table record 2
Declaration
public int Userdef2Id
Field Value
Type | Description |
---|---|
Int32 |
UserdefId
User defined table record 1
Declaration
public int UserdefId
Field Value
Type | Description |
---|---|
Int32 |
Xstop
STOP flag
Declaration
public short Xstop
Field Value
Type | Description |
---|---|
Int16 |