Class DBC.ContactFields

Fields for Contact, Companies and Organizations. This table features a special record containing information about the contact that owns the database.

Inheritance

object

DBC.ContactFields

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: SuperOffice.CRM.Data

Assembly: SoDataBase.dll

Syntax

public static class DBC.ContactFields

Fields

ActiveErpLinks

Contact.ActiveErpLinks: The number of Erp Sync connections this record is synced with; count of the ErpExternalKey+ErpInternalKey relations

Declaration

public const string ActiveErpLinks = "activeErpLinks"

Field Value

Type	Description
string

ActiveInterests

Contact.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 const string ActiveInterests = "activeInterests"

Field Value

Type	Description
string

AssociateId

Contact.AssociateId: Our contact

Declaration

public const string AssociateId = "associate_id"

Field Value

Type	Description
string

BusinessIdx

Contact.BusinessIdx: Link to Business

Declaration

public const string BusinessIdx = "business_idx"

Field Value

Type	Description
string

CategoryIdx

Contact.CategoryIdx: Link to Category

Declaration

public const string CategoryIdx = "category_idx"

Field Value

Type	Description
string

ContactId

Contact.ContactId: Primary key

Declaration

public const string ContactId = "contact_id"

Field Value

Type	Description
string

CountryId

Contact.CountryId: Country

Declaration

public const string CountryId = "country_id"

Field Value

Type	Description
string

DbiAgentId

Contact.DbiAgentId: Integration agent (eJournal)

Declaration

public const string DbiAgentId = "dbi_agent_id"

Field Value

Type	Description
string

DbiKey

Contact.DbiKey: The primary key for the integrated entry in the external datasource.

Declaration

public const string DbiKey = "dbi_key"

Field Value

Type	Description
string

DbiLastModified

Contact.DbiLastModified: When the entry was last modified.

Declaration

public const string DbiLastModified = "dbi_last_modified"

Field Value

Type	Description
string

DbiLastSyncronized

Contact.DbiLastSyncronized: Last external syncronization.

Declaration

public const string DbiLastSyncronized = "dbi_last_syncronized"

Field Value

Type	Description
string

Deleted

Contact.Deleted: If nonzero, then this contact is 'deleted' and should generally not be shown

Declaration

public const string Deleted = "deleted"

Field Value

Type	Description
string

DeletedDate

Contact.DeletedDate: Datetime (utc) when this record was soft-deleted; if this value is set then the record should not be shown

Declaration

public const string DeletedDate = "DeletedDate"

Field Value

Type	Description
string

Department

Contact.Department: Department

Declaration

public const string Department = "department"

Field Value

Type	Description
string

GroupId

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

Declaration

public const string GroupId = "group_id"

Field Value

Type	Description
string

Kananame

Contact.Kananame: Contact kana name, used in Japanese versions only

Declaration

public const string Kananame = "kananame"

Field Value

Type	Description
string

MotherId

Contact.MotherId: Reserved

Declaration

public const string MotherId = "mother_id"

Field Value

Type	Description
string

Name

Contact.Name: Contact name

Declaration

public const string Name = "name"

Field Value

Type	Description
string

Nomailing

Contact.Nomailing: No mailings flags

Declaration

public const string Nomailing = "nomailing"

Field Value

Type	Description
string

Number1

Contact.Number1: Alphanumeric user field

Declaration

public const string Number1 = "number1"

Field Value

Type	Description
string

Number2

Contact.Number2: Alphanumeric user field

Declaration

public const string Number2 = "number2"

Field Value

Type	Description
string

OrgNr

Contact.OrgNr: VAT number or similar

Declaration

public const string OrgNr = "orgNr"

Field Value

Type	Description
string

Registered

Contact.Registered: Date registered

Declaration

public const string Registered = "registered"

Field Value

Type	Description
string

RegisteredAssociateId

Contact.RegisteredAssociateId: Registered by whom

Declaration

public const string RegisteredAssociateId = "registered_associate_id"

Field Value

Type	Description
string

SoundEx

Contact.SoundEx: What the name sounds like, for duplicate detection

Declaration

public const string SoundEx = "soundEx"

Field Value

Type	Description
string

Source

Contact.Source: How did we get this contact? For future integration needs

Declaration

public const string Source = "source"

Field Value

Type	Description
string

SupportAssociateId

Contact.SupportAssociateId: Our contact, but for support context, not sales/primary contact

Declaration

public const string SupportAssociateId = "supportAssociateId"

Field Value

Type	Description
string

SupportLanguageId

Contact.SupportLanguageId: Customers language (does not necessarily map to ISO languages)

Declaration

public const string SupportLanguageId = "supportLanguageId"

Field Value

Type	Description
string

SupportPersonId

Contact.SupportPersonId: The person (at the customer) who support talks to (the counterpart of supportAssociateId)

Declaration

public const string SupportPersonId = "supportPersonId"

Field Value

Type	Description
string

TextId

Contact.TextId: Paperclip note

Declaration

public const string TextId = "text_id"

Field Value

Type	Description
string

TicketPriorityId

Contact.TicketPriorityId: Default ticket priority for new tickets

Declaration

public const string TicketPriorityId = "ticketPriorityId"

Field Value

Type	Description
string

TzLocationId

Contact.TzLocationId: Default timezone location for this contact

Declaration

public const string TzLocationId = "tzLocationId"

Field Value

Type	Description
string

Updated

Contact.Updated: Date last updated

Declaration

public const string Updated = "updated"

Field Value

Type	Description
string

UpdatedAssociateId

Contact.UpdatedAssociateId: Last updated by whom

Declaration

public const string UpdatedAssociateId = "updated_associate_id"

Field Value

Type	Description
string

UpdatedCount

Contact.UpdatedCount: Number of times updated

Declaration

public const string UpdatedCount = "updatedCount"

Field Value

Type	Description
string

Userdef2Id

Contact.Userdef2Id: User defined table record 2

Declaration

public const string Userdef2Id = "userdef2_id"

Field Value

Type	Description
string

UserdefId

Contact.UserdefId: User defined table record 1

Declaration

public const string UserdefId = "userdef_id"

Field Value

Type	Description
string

Xstop

Contact.Xstop: STOP flag

Declaration

public const string Xstop = "xstop"

Field Value

Type	Description
string