Class ContactRecordData

POCO (Plain Old CLR Object) class that can be used to hold data corresponding to a row from the contact table.

Inheritance
object
ContactRecordData
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()

POCO (Plain Old CLR Object) class that can be used to hold data corresponding to a row from the contact table.

Declaration
public 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.

Fields

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
int

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.

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
short
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.

AssociateId

Our contact

Declaration
public int AssociateId
Field Value
Type Description
int
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.

BusinessIdx

Link to Business

Declaration
public int BusinessIdx
Field Value
Type Description
int
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.

CategoryIdx

Link to Category

Declaration
public int CategoryIdx
Field Value
Type Description
int
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.

ContactId

Primary key

Declaration
public int ContactId
Field Value
Type Description
int
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.

CountryId

Country

Declaration
public int CountryId
Field Value
Type Description
int
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.

DbiAgentId

Integration agent (eJournal)

Declaration
public int DbiAgentId
Field Value
Type Description
int
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.

DbiKey

The primary key for the integrated entry in the external datasource.

Declaration
public string DbiKey
Field Value
Type Description
string
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.

DbiLastModified

When the entry was last modified.

Declaration
public DateTime DbiLastModified
Field Value
Type Description
DateTime
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.

DbiLastSyncronized

Last external syncronization.

Declaration
public DateTime DbiLastSyncronized
Field Value
Type Description
DateTime
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.

Deleted

If nonzero, then this contact is 'deleted' and should generally not be shown

Declaration
public short Deleted
Field Value
Type Description
short
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.

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
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.

Department

Department

Declaration
public string Department
Field Value
Type Description
string
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.

GroupId

Group id of original owning associate, semantics like appnt.grp_id

Declaration
public int GroupId
Field Value
Type Description
int
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.

Kananame

Contact kana name, used in Japanese versions only

Declaration
public string Kananame
Field Value
Type Description
string
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.

MotherId

Reserved

Declaration
public int MotherId
Field Value
Type Description
int
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.

Name

Contact name

Declaration
public string Name
Field Value
Type Description
string
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.

Nomailing

No mailings flags

Declaration
public short Nomailing
Field Value
Type Description
short
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.

Number1

Alphanumeric user field

Declaration
public string Number1
Field Value
Type Description
string
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.

Number2

Alphanumeric user field

Declaration
public string Number2
Field Value
Type Description
string
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.

OrgNr

VAT number or similar

Declaration
public string OrgNr
Field Value
Type Description
string
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.

Registered

Date registered in UTC.

Declaration
public DateTime Registered
Field Value
Type Description
DateTime
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.

RegisteredAssociateId

Registered by whom

Declaration
public int RegisteredAssociateId
Field Value
Type Description
int
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.

SoundEx

What the name sounds like, for duplicate detection

Declaration
public string SoundEx
Field Value
Type Description
string
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.

Source

How did we get this contact? For future integration needs

Declaration
public short Source
Field Value
Type Description
short
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.

SupportAssociateId

Our contact, but for support context, not sales/primary contact

Declaration
public int SupportAssociateId
Field Value
Type Description
int
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.

SupportLanguageId

Customers language (does not necessarily map to ISO languages)

Declaration
public int SupportLanguageId
Field Value
Type Description
int
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.

SupportPersonId

The person (at the customer) who support talks to (the counterpart of supportAssociateId)

Declaration
public int SupportPersonId
Field Value
Type Description
int
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.

TextId

Paperclip note

Declaration
public int TextId
Field Value
Type Description
int
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.

TicketPriorityId

Default ticket priority for new tickets

Declaration
public int TicketPriorityId
Field Value
Type Description
int
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.

TzLocationId

Default timezone location for this contact

Declaration
public int TzLocationId
Field Value
Type Description
int
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.

Updated

Date last updated in UTC.

Declaration
public DateTime Updated
Field Value
Type Description
DateTime
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.

UpdatedAssociateId

Last updated by whom

Declaration
public int UpdatedAssociateId
Field Value
Type Description
int
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.

UpdatedCount

Number of times updated

Declaration
public short UpdatedCount
Field Value
Type Description
short
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.

Userdef2Id

User defined table record 2

Declaration
public int Userdef2Id
Field Value
Type Description
int
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.

UserdefId

User defined table record 1

Declaration
public int UserdefId
Field Value
Type Description
int
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.

Xstop

STOP flag

Declaration
public short Xstop
Field Value
Type Description
short
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.

Extension Methods