Class PersonRecordData
POCO (Plain Old CLR Object) class that can be used to hold data corresponding to a row from the person table.
Inherited Members
Namespace: SuperOffice.CRM.Rows
Assembly: SoDataBase.dll
Syntax
public class PersonRecordDataRemarks
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 ActiveErpLinksField 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 ActiveInterestsField Value
| Type | Description |
|---|---|
| Int16 |
AssociateId
Our contact, if this is a B2C person, otherwise mirror of contact.assoc_id
Declaration
public int AssociateIdField Value
| Type | Description |
|---|---|
| Int32 |
BlockEmarketing
Do not send E-marketing materials to this person
Declaration
public short BlockEmarketingField Value
| Type | Description |
|---|---|
| Int16 |
BusinessIdx
Business if this is a B2C person, otherwise mirror of contact.business_idx
Declaration
public int BusinessIdxField Value
| Type | Description |
|---|---|
| Int32 |
CategoryIdx
Category if this is a B2C person, otherwise mirror of contact.category_idx
Declaration
public int CategoryIdxField Value
| Type | Description |
|---|---|
| Int32 |
ContactId
Owning contact ID
Declaration
public int ContactIdField Value
| Type | Description |
|---|---|
| Int32 |
CountryId
Country
Declaration
public int CountryIdField Value
| Type | Description |
|---|---|
| Int32 |
DayOfBirth
Birth date (day of month)
Declaration
public short DayOfBirthField Value
| Type | Description |
|---|---|
| Int16 |
DbiAgentId
Integration agent (eJournal)
Declaration
public int DbiAgentIdField Value
| Type | Description |
|---|---|
| Int32 |
DbiKey
The primary key for the integrated entry in the external datasource.
Declaration
public string DbiKeyField Value
| Type | Description |
|---|---|
| String |
DbiLastModified
When the entry was last modified.
Declaration
public DateTime DbiLastModifiedField Value
| Type | Description |
|---|---|
| DateTime |
DbiLastSyncronized
Last external syncronization.
Declaration
public DateTime DbiLastSyncronizedField 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 DeletedDateField Value
| Type | Description |
|---|---|
| DateTime |
Department
Internal department address
Declaration
public string DepartmentField Value
| Type | Description |
|---|---|
| String |
Firstname
First name
Declaration
public string FirstnameField 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 GenderField 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 GroupIdField 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 InitialsField Value
| Type | Description |
|---|---|
| String |
Kanafname
Kana last name, used in Japanese versions only
Declaration
public string KanafnameField Value
| Type | Description |
|---|---|
| String |
Kanalname
Kana last name, used in Japanese versions only
Declaration
public string KanalnameField Value
| Type | Description |
|---|---|
| String |
Lastname
Last name
Declaration
public string LastnameField Value
| Type | Description |
|---|---|
| String |
MiddleName
Middle name or 'van' etc.
Declaration
public string MiddleNameField Value
| Type | Description |
|---|---|
| String |
MonthOfBirth
Birth month
Declaration
public short MonthOfBirthField Value
| Type | Description |
|---|---|
| Int16 |
Mrmrs
e.g. Mrs sex_title
Declaration
public string MrmrsField Value
| Type | Description |
|---|---|
| String |
Nomailing
Do not send DM's to this person
Declaration
public short NomailingField Value
| Type | Description |
|---|---|
| Int16 |
PersonId
Primary key
Declaration
public int PersonIdField Value
| Type | Description |
|---|---|
| Int32 |
PersonNumber
Alphanumeric user field
Declaration
public string PersonNumberField Value
| Type | Description |
|---|---|
| String |
PhonePresent
flag to show there are phone registrations
Declaration
public short PhonePresentField Value
| Type | Description |
|---|---|
| Int16 |
PositionIdx
Link to Position list
Declaration
public int PositionIdxField Value
| Type | Description |
|---|---|
| Int32 |
Post1
Postal address, used in Japanese versions only
Declaration
public string Post1Field Value
| Type | Description |
|---|---|
| String |
Post2
Postal address, used in Japanese versions only
Declaration
public string Post2Field Value
| Type | Description |
|---|---|
| String |
Post3
Postal address, used in Japanese versions only
Declaration
public string Post3Field Value
| Type | Description |
|---|---|
| String |
Rank
Display sort sequence for default sort order
Declaration
public short RankField Value
| Type | Description |
|---|---|
| Int16 |
Registered
Registered date in UTC.
Declaration
public DateTime RegisteredField Value
| Type | Description |
|---|---|
| DateTime |
RegisteredAssociateId
Registered by whom
Declaration
public int RegisteredAssociateIdField Value
| Type | Description |
|---|---|
| Int32 |
Retired
1 = the user is retired and should have no rights, not appear in lists, etc.
Declaration
public short RetiredField Value
| Type | Description |
|---|---|
| Int16 |
Salutation
Academic title, populated from Salutation list but can be overwritten with anything at all
Declaration
public string SalutationField Value
| Type | Description |
|---|---|
| String |
SentInfo
Has information on username/password been sent (ejournal)
Declaration
public short SentInfoField Value
| Type | Description |
|---|---|
| Int16 |
ShowContactTickets
Should tickets related to the company be shown to this person
Declaration
public short ShowContactTicketsField Value
| Type | Description |
|---|---|
| Int16 |
Source
How did we get this person? For future integration needs
Declaration
public short SourceField Value
| Type | Description |
|---|---|
| Int16 |
SupportAssociateId
Our contact, but for support context, not sales/primary contact
Declaration
public int SupportAssociateIdField Value
| Type | Description |
|---|---|
| Int32 |
SupportLanguageId
Customers language (does not necessarily map to ISO languages)
Declaration
public int SupportLanguageIdField Value
| Type | Description |
|---|---|
| Int32 |
TextId
Info tab contents
Declaration
public int TextIdField Value
| Type | Description |
|---|---|
| Int32 |
TicketPriorityId
Default ticket priority for new tickets
Declaration
public int TicketPriorityIdField Value
| Type | Description |
|---|---|
| Int32 |
Title
Title
Declaration
public string TitleField Value
| Type | Description |
|---|---|
| String |
TzLocationId
Default timezone location for this person
Declaration
public int TzLocationIdField Value
| Type | Description |
|---|---|
| Int32 |
Updated
Last updated date in UTC.
Declaration
public DateTime UpdatedField Value
| Type | Description |
|---|---|
| DateTime |
UpdatedAssociateId
Last updated by whom
Declaration
public int UpdatedAssociateIdField Value
| Type | Description |
|---|---|
| Int32 |
UpdatedCount
Number of times updated
Declaration
public short UpdatedCountField Value
| Type | Description |
|---|---|
| Int16 |
Usepersonaddress
If 1, use person's address for mailing instead of company address
Declaration
public short UsepersonaddressField Value
| Type | Description |
|---|---|
| Int16 |
Userdef2Id
User defined table record 2
Declaration
public int Userdef2IdField Value
| Type | Description |
|---|---|
| Int32 |
UserdefId
User defined table record 1
Declaration
public int UserdefIdField Value
| Type | Description |
|---|---|
| Int32 |
YearOfBirth
Birth year (4 digit)
Declaration
public short YearOfBirthField Value
| Type | Description |
|---|---|
| Int16 |