Class DBC.PersonFields

Fields for Person, Persons in a company or an organizations. All associates have a corresponding person record

Inheritance
object
DBC.PersonFields
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
public static class DBC.PersonFields

Fields

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

Person.ActiveInterests: Number of records in pintr table; select count(*) from pintr pi where pi.person_id = this.person_id == activeInterests is always true

Declaration
public const string ActiveInterests = "activeInterests"
Field Value
Type Description
string

AssociateId

Person.AssociateId: Our contact, if this is a B2C person, otherwise mirror of contact.assoc_id

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

BlockEmarketing

Person.BlockEmarketing: Do not send E-marketing materials to this person

Declaration
public const string BlockEmarketing = "blockEmarketing"
Field Value
Type Description
string

BusinessIdx

Person.BusinessIdx: Business if this is a B2C person, otherwise mirror of contact.business_idx

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

CategoryIdx

Person.CategoryIdx: Category if this is a B2C person, otherwise mirror of contact.category_idx

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

ContactId

Person.ContactId: Owning contact ID

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

CountryId

Person.CountryId: Country

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

DayOfBirth

Person.DayOfBirth: Birth date (day of month), 0 if not specified

Declaration
public const string DayOfBirth = "day_of_birth"
Field Value
Type Description
string

DbiAgentId

Person.DbiAgentId: Integration agent (eJournal)

Declaration
public const string DbiAgentId = "dbi_agent_id"
Field Value
Type Description
string

DbiKey

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

Person.DbiLastModified: When the entry was last modified.

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

DbiLastSyncronized

Person.DbiLastSyncronized: Last external syncronization.

Declaration
public const string DbiLastSyncronized = "dbi_last_syncronized"
Field Value
Type Description
string

DeletedDate

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

Person.Department: Internal department address

Declaration
public const string Department = "department"
Field Value
Type Description
string

Firstname

Person.Firstname: First name

Declaration
public const string Firstname = "firstname"
Field Value
Type Description
string

Gender

Person.Gender: Male/female. No jokes please. To be used for selecting correct salutations & grammar. 0 = unknown, 1 = female, 2 = male

Declaration
public const string Gender = "gender"
Field Value
Type Description
string

GroupId

Person.GroupId: Our contact's original group, if this is a B2C person, otherwise mirror of contact.group_id

Declaration
public const string GroupId = "group_id"
Field Value
Type Description
string

Initials

Person.Initials: Where Pierre van Mever becomes P. van Mever. Actually, initials to be used in formal addresses, mostly in the Ducth market

Declaration
public const string Initials = "initials"
Field Value
Type Description
string

Kanafname

Person.Kanafname: Kana last name, used in Japanese versions only

Declaration
public const string Kanafname = "kanafname"
Field Value
Type Description
string

Kanalname

Person.Kanalname: Kana last name, used in Japanese versions only

Declaration
public const string Kanalname = "kanalname"
Field Value
Type Description
string

Lastname

Person.Lastname: Last name

Declaration
public const string Lastname = "lastname"
Field Value
Type Description
string

MiddleName

Person.MiddleName: Middle name or 'van' etc.

Declaration
public const string MiddleName = "middleName"
Field Value
Type Description
string

MonthOfBirth

Person.MonthOfBirth: Birth month (1-12), 0 if not specified

Declaration
public const string MonthOfBirth = "month_of_birth"
Field Value
Type Description
string

Mrmrs

Person.Mrmrs: e.g. Mrs sex_title

Declaration
public const string Mrmrs = "mrmrs"
Field Value
Type Description
string

Nomailing

Person.Nomailing: Do not send DM's to this person

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

PersonId

Person.PersonId: Primary key

Declaration
public const string PersonId = "person_id"
Field Value
Type Description
string

PersonNumber

Person.PersonNumber: Alphanumeric user field

Declaration
public const string PersonNumber = "person_number"
Field Value
Type Description
string

PhonePresent

Person.PhonePresent: flag to show there are phone registrations

Declaration
public const string PhonePresent = "phone_present"
Field Value
Type Description
string

PositionIdx

Person.PositionIdx: Link to Position list

Declaration
public const string PositionIdx = "position_idx"
Field Value
Type Description
string

Post1

Person.Post1: Postal address, used in Japanese versions only

Declaration
public const string Post1 = "post1"
Field Value
Type Description
string

Post2

Person.Post2: Postal address, used in Japanese versions only

Declaration
public const string Post2 = "post2"
Field Value
Type Description
string

Post3

Person.Post3: Postal address, used in Japanese versions only

Declaration
public const string Post3 = "post3"
Field Value
Type Description
string

Rank

Person.Rank: Display sort sequence for default sort order

Declaration
public const string Rank = "rank"
Field Value
Type Description
string

Registered

Person.Registered: Registered date

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

RegisteredAssociateId

Person.RegisteredAssociateId: Registered by whom

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

Retired

Person.Retired: 1 = the user is retired and should have no rights, not appear in lists, etc.

Declaration
public const string Retired = "retired"
Field Value
Type Description
string

Salutation

Person.Salutation: Academic title, populated from Salutation list but can be overwritten with anything at all

Declaration
public const string Salutation = "salutation"
Field Value
Type Description
string

SentInfo

Person.SentInfo: Has information on username/password been sent (ejournal)

Declaration
public const string SentInfo = "sentInfo"
Field Value
Type Description
string

ShowContactTickets

Person.ShowContactTickets: Should tickets related to the company be shown to this person

Declaration
public const string ShowContactTickets = "showContactTickets"
Field Value
Type Description
string

Source

Person.Source: How did we get this person? For future integration needs

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

SupportAssociateId

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

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

SupportLanguageId

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

Declaration
public const string SupportLanguageId = "supportLanguageId"
Field Value
Type Description
string

TextId

Person.TextId: Info tab contents

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

TicketPriorityId

Person.TicketPriorityId: Default ticket priority for new tickets

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

Title

Person.Title: Title

Declaration
public const string Title = "title"
Field Value
Type Description
string

TzLocationId

Person.TzLocationId: Default timezone location for this person

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

Updated

Person.Updated: Last updated date

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

UpdatedAssociateId

Person.UpdatedAssociateId: Last updated by whom

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

UpdatedCount

Person.UpdatedCount: Number of times updated

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

Usepersonaddress

Person.Usepersonaddress: If 1, use person's address for mailing instead of company address

Declaration
public const string Usepersonaddress = "usepersonaddress"
Field Value
Type Description
string

Userdef2Id

Person.Userdef2Id: User defined table record 2

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

UserdefId

Person.UserdefId: User defined table record 1

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

YearOfBirth

Person.YearOfBirth: Birth year (4 digit), 0 if not specifed

Declaration
public const string YearOfBirth = "year_of_birth"
Field Value
Type Description
string