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