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
System.Object
DBC.ContactFields
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
public static class ContactFields : Object

Fields

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

AssociateId

Contact.AssociateId: Our contact

Declaration
public const string AssociateId = "associate_id"
Field Value
Type Description
System.String

BusinessIdx

Contact.BusinessIdx: Link to Business

Declaration
public const string BusinessIdx = "business_idx"
Field Value
Type Description
System.String

CategoryIdx

Contact.CategoryIdx: Link to Category

Declaration
public const string CategoryIdx = "category_idx"
Field Value
Type Description
System.String

ContactId

Contact.ContactId: Primary key

Declaration
public const string ContactId = "contact_id"
Field Value
Type Description
System.String

CountryId

Contact.CountryId: Country

Declaration
public const string CountryId = "country_id"
Field Value
Type Description
System.String

DbiAgentId

Contact.DbiAgentId: Integration agent (eJournal)

Declaration
public const string DbiAgentId = "dbi_agent_id"
Field Value
Type Description
System.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
System.String

DbiLastModified

Contact.DbiLastModified: When the entry was last modified.

Declaration
public const string DbiLastModified = "dbi_last_modified"
Field Value
Type Description
System.String

DbiLastSyncronized

Contact.DbiLastSyncronized: Last external syncronization.

Declaration
public const string DbiLastSyncronized = "dbi_last_syncronized"
Field Value
Type Description
System.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
System.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
System.String

Department

Contact.Department: Department

Declaration
public const string Department = "department"
Field Value
Type Description
System.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
System.String

Kananame

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

Declaration
public const string Kananame = "kananame"
Field Value
Type Description
System.String

MotherId

Contact.MotherId: Reserved

Declaration
public const string MotherId = "mother_id"
Field Value
Type Description
System.String

Name

Contact.Name: Contact name

Declaration
public const string Name = "name"
Field Value
Type Description
System.String

Nomailing

Contact.Nomailing: No mailings flags

Declaration
public const string Nomailing = "nomailing"
Field Value
Type Description
System.String

Number1

Contact.Number1: Alphanumeric user field

Declaration
public const string Number1 = "number1"
Field Value
Type Description
System.String

Number2

Contact.Number2: Alphanumeric user field

Declaration
public const string Number2 = "number2"
Field Value
Type Description
System.String

OrgNr

Contact.OrgNr: VAT number or similar

Declaration
public const string OrgNr = "orgNr"
Field Value
Type Description
System.String

Registered

Contact.Registered: Date registered

Declaration
public const string Registered = "registered"
Field Value
Type Description
System.String

RegisteredAssociateId

Contact.RegisteredAssociateId: Registered by whom

Declaration
public const string RegisteredAssociateId = "registered_associate_id"
Field Value
Type Description
System.String

SoundEx

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

Declaration
public const string SoundEx = "soundEx"
Field Value
Type Description
System.String

Source

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

Declaration
public const string Source = "source"
Field Value
Type Description
System.String

SupportAssociateId

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

Declaration
public const string SupportAssociateId = "supportAssociateId"
Field Value
Type Description
System.String

SupportLanguageId

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

Declaration
public const string SupportLanguageId = "supportLanguageId"
Field Value
Type Description
System.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
System.String

TextId

Contact.TextId: Paperclip note

Declaration
public const string TextId = "text_id"
Field Value
Type Description
System.String

TicketPriorityId

Contact.TicketPriorityId: Default ticket priority for new tickets

Declaration
public const string TicketPriorityId = "ticketPriorityId"
Field Value
Type Description
System.String

TzLocationId

Contact.TzLocationId: Default timezone location for this contact

Declaration
public const string TzLocationId = "tzLocationId"
Field Value
Type Description
System.String

Updated

Contact.Updated: Date last updated

Declaration
public const string Updated = "updated"
Field Value
Type Description
System.String

UpdatedAssociateId

Contact.UpdatedAssociateId: Last updated by whom

Declaration
public const string UpdatedAssociateId = "updated_associate_id"
Field Value
Type Description
System.String

UpdatedCount

Contact.UpdatedCount: Number of times updated

Declaration
public const string UpdatedCount = "updatedCount"
Field Value
Type Description
System.String

Userdef2Id

Contact.Userdef2Id: User defined table record 2

Declaration
public const string Userdef2Id = "userdef2_id"
Field Value
Type Description
System.String

UserdefId

Contact.UserdefId: User defined table record 1

Declaration
public const string UserdefId = "userdef_id"
Field Value
Type Description
System.String

Xstop

Contact.Xstop: STOP flag

Declaration
public const string Xstop = "xstop"
Field Value
Type Description
System.String