Show / Hide Table of Contents

Class PersonRecordData

POCO (Plain Old CLR Object) class that can be used to hold data corresponding to a row from the person table.

Inheritance
Object
PersonRecordData
Inherited Members
Object.ToString()
Object.Equals(Object)
Object.Equals(Object, Object)
Object.ReferenceEquals(Object, Object)
Object.GetHashCode()
Object.GetType()
Object.MemberwiseClone()
Namespace: SuperOffice.CRM.Rows
Assembly: SoDataBase.dll
Syntax
public class PersonRecordData
Remarks

Please use this class instead of a full PersonRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding PersonTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Constructors

PersonRecordData()

Declaration
public PersonRecordData()

Fields

ActiveErpLinks

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

Declaration
public int ActiveErpLinks
Field Value
Type Description
Int32

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 short ActiveInterests
Field Value
Type Description
Int16

AssociateId

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

Declaration
public int AssociateId
Field Value
Type Description
Int32

BlockEmarketing

Do not send E-marketing materials to this person

Declaration
public short BlockEmarketing
Field Value
Type Description
Int16

BusinessIdx

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

Declaration
public int BusinessIdx
Field Value
Type Description
Int32

CategoryIdx

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

Declaration
public int CategoryIdx
Field Value
Type Description
Int32

ContactId

Owning contact ID

Declaration
public int ContactId
Field Value
Type Description
Int32

CountryId

Country

Declaration
public int CountryId
Field Value
Type Description
Int32

DayOfBirth

Birth date (day of month)

Declaration
public short DayOfBirth
Field Value
Type Description
Int16

DbiAgentId

Integration agent (eJournal)

Declaration
public int DbiAgentId
Field Value
Type Description
Int32

DbiKey

The primary key for the integrated entry in the external datasource.

Declaration
public string DbiKey
Field Value
Type Description
String

DbiLastModified

When the entry was last modified.

Declaration
public DateTime DbiLastModified
Field Value
Type Description
DateTime

DbiLastSyncronized

Last external syncronization.

Declaration
public DateTime DbiLastSyncronized
Field Value
Type Description
DateTime

DeletedDate

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

Declaration
public DateTime DeletedDate
Field Value
Type Description
DateTime

Department

Internal department address

Declaration
public string Department
Field Value
Type Description
String

Firstname

First name

Declaration
public string Firstname
Field Value
Type Description
String

Gender

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

Declaration
public short Gender
Field Value
Type Description
Int16

GroupId

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

Declaration
public int GroupId
Field Value
Type Description
Int32

Initials

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

Declaration
public string Initials
Field Value
Type Description
String

Kanafname

Kana last name, used in Japanese versions only

Declaration
public string Kanafname
Field Value
Type Description
String

Kanalname

Kana last name, used in Japanese versions only

Declaration
public string Kanalname
Field Value
Type Description
String

Lastname

Last name

Declaration
public string Lastname
Field Value
Type Description
String

MiddleName

Middle name or 'van' etc.

Declaration
public string MiddleName
Field Value
Type Description
String

MonthOfBirth

Birth month

Declaration
public short MonthOfBirth
Field Value
Type Description
Int16

Mrmrs

e.g. Mrs sex_title

Declaration
public string Mrmrs
Field Value
Type Description
String

Nomailing

Do not send DM's to this person

Declaration
public short Nomailing
Field Value
Type Description
Int16

PersonId

Primary key

Declaration
public int PersonId
Field Value
Type Description
Int32

PersonNumber

Alphanumeric user field

Declaration
public string PersonNumber
Field Value
Type Description
String

PhonePresent

flag to show there are phone registrations

Declaration
public short PhonePresent
Field Value
Type Description
Int16

PositionIdx

Link to Position list

Declaration
public int PositionIdx
Field Value
Type Description
Int32

Post1

Postal address, used in Japanese versions only

Declaration
public string Post1
Field Value
Type Description
String

Post2

Postal address, used in Japanese versions only

Declaration
public string Post2
Field Value
Type Description
String

Post3

Postal address, used in Japanese versions only

Declaration
public string Post3
Field Value
Type Description
String

Rank

Display sort sequence for default sort order

Declaration
public short Rank
Field Value
Type Description
Int16

Registered

Registered date in UTC.

Declaration
public DateTime Registered
Field Value
Type Description
DateTime

RegisteredAssociateId

Registered by whom

Declaration
public int RegisteredAssociateId
Field Value
Type Description
Int32

Retired

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

Declaration
public short Retired
Field Value
Type Description
Int16

Salutation

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

Declaration
public string Salutation
Field Value
Type Description
String

SentInfo

Has information on username/password been sent (ejournal)

Declaration
public short SentInfo
Field Value
Type Description
Int16

ShowContactTickets

Should tickets related to the company be shown to this person

Declaration
public short ShowContactTickets
Field Value
Type Description
Int16

Source

How did we get this person? For future integration needs

Declaration
public short Source
Field Value
Type Description
Int16

SupportAssociateId

Our contact, but for support context, not sales/primary contact

Declaration
public int SupportAssociateId
Field Value
Type Description
Int32

SupportLanguageId

Customers language (does not necessarily map to ISO languages)

Declaration
public int SupportLanguageId
Field Value
Type Description
Int32

TextId

Info tab contents

Declaration
public int TextId
Field Value
Type Description
Int32

TicketPriorityId

Default ticket priority for new tickets

Declaration
public int TicketPriorityId
Field Value
Type Description
Int32

Title

Title

Declaration
public string Title
Field Value
Type Description
String

TzLocationId

Default timezone location for this person

Declaration
public int TzLocationId
Field Value
Type Description
Int32

Updated

Last updated date in UTC.

Declaration
public DateTime Updated
Field Value
Type Description
DateTime

UpdatedAssociateId

Last updated by whom

Declaration
public int UpdatedAssociateId
Field Value
Type Description
Int32

UpdatedCount

Number of times updated

Declaration
public short UpdatedCount
Field Value
Type Description
Int16

Usepersonaddress

If 1, use person's address for mailing instead of company address

Declaration
public short Usepersonaddress
Field Value
Type Description
Int16

Userdef2Id

User defined table record 2

Declaration
public int Userdef2Id
Field Value
Type Description
Int32

UserdefId

User defined table record 1

Declaration
public int UserdefId
Field Value
Type Description
Int32

YearOfBirth

Birth year (4 digit)

Declaration
public short YearOfBirth
Field Value
Type Description
Int16

Extension Methods

EnumUtil.MapEnums<From, To>(From)
ObjectExtensions.AssignByReflection<T>(T, T)
ObjectExtensions.GraphCopy<T>(T)
PersonRecordDataExtensions.ToInsert(PersonRecordData)
Converters.MapEnums<From, To>(From)
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top