Class DBC.PersonFields
Fields for Person, Persons in a company or an organizations. All associates have a corresponding person record
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
public static class DBC.PersonFieldsFields
ActiveErpLinks
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 |
CreatedByFormId
Person.CreatedByFormId: The form this person was created by
Declaration
public const string CreatedByFormId = "created_by_form_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 |
ModifiedByWorkflowId
Person.ModifiedByWorkflowId: The workflow this person last was modified by
Declaration
public const string ModifiedByWorkflowId = "modified_by_workflow_id"Field Value
| Type | Description |
|---|---|
| string |
ModifiedByWorkflowWhen
Person.ModifiedByWorkflowWhen: When the workflow modified this person
Declaration
public const string ModifiedByWorkflowWhen = "modified_by_workflow_when"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 |