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