Class PersonRecordData

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

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.

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

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.

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

Type	Description
int

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.

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

Type	Description
short

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.

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

Type	Description
int

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.

Do not send E-marketing materials to this person

Type	Description
short

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.

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

Type	Description
int

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.

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

Type	Description
int

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.

Owning contact ID

Type	Description
int

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.

Country

Type	Description
int

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.

The form this person was created by

Type	Description
int

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.

Birth date (day of month), 0 if not specified

Type	Description
short

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.

Integration agent (eJournal)

Type	Description
int

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.

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

Type	Description
string

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.

When the entry was last modified.

Type	Description
DateTime

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.

Last external syncronization.

Type	Description
DateTime

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.

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

Type	Description
DateTime

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.

Internal department address

Type	Description
string

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.

First name

Type	Description
string

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.

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

Type	Description
short

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.

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

Type	Description
int

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.

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

Type	Description
string

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.

Kana last name, used in Japanese versions only

Type	Description
string

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.

Kana last name, used in Japanese versions only

Type	Description
string

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.

Last name

Type	Description
string

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.

Refinement of categories of lead type. Empty if the category is not a lead type. If this person has a contact, the leadstatus is from the contact and not editable on the person

Type	Description
int

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.

Middle name or 'van' etc.

Type	Description
string

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.

The workflow this person last was modified by

Type	Description
int

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.

When the workflow modified this person in UTC.

Type	Description
DateTime

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.

Birth month (1-12), 0 if not specified

Type	Description
short

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.

e.g. Mrs sex_title

Type	Description
string

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.

Do not send DM's to this person

Type	Description
short

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.

Primary key

Type	Description
int

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.

Alphanumeric user field

Type	Description
string

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.

flag to show there are phone registrations

Type	Description
short

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.

Link to Position list

Type	Description
int

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.

Postal address, used in Japanese versions only

Type	Description
string

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.

Postal address, used in Japanese versions only

Type	Description
string

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.

Postal address, used in Japanese versions only

Type	Description
string

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.

Display sort sequence for default sort order

Type	Description
short

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.

Registered date in UTC.

Type	Description
DateTime

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.

Registered by whom

Type	Description
int

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.

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

Type	Description
short

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.

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

Type	Description
string

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.

Has information on username/password been sent (ejournal)

Type	Description
short

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.

Should tickets related to the company be shown to this person

Type	Description
short

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.

How did we get this person? For future integration needs

Type	Description
short

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.

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

Type	Description
int

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.

Customers language (does not necessarily map to ISO languages)

Type	Description
int

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.

Info tab contents

Type	Description
int

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.

Default ticket priority for new tickets

Type	Description
int

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.

Title

Type	Description
string

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.

Default timezone location for this person

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.

Last updated date in UTC.

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.

Last updated by whom

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.

Number of times updated

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.

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

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.

User defined table record 2

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.

User defined table record 1

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.

Birth year (4 digit), 0 if not specifed

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.

Inheritance

Inherited Members

Namespace: SuperOffice.CRM.Rows

Assembly: SoDataBase.dll

Syntax

Remarks

Constructors

PersonRecordData()

Declaration

Remarks

Fields

ActiveErpLinks

Declaration

Field Value

Remarks

ActiveInterests

Declaration

Field Value

Remarks

AssociateId

Declaration

Field Value

Remarks

BlockEmarketing

Declaration

Field Value

Remarks

BusinessIdx

Declaration

Field Value

Remarks

CategoryIdx

Declaration

Field Value

Remarks

ContactId

Declaration

Field Value

Remarks

CountryId

Declaration

Field Value

Remarks

CreatedByFormId

Declaration

Field Value

Remarks

DayOfBirth

Declaration

Field Value

Remarks

DbiAgentId

Declaration

Field Value

Remarks

DbiKey

Declaration

Field Value

Remarks

DbiLastModified

Declaration

Field Value

Remarks

DbiLastSyncronized

Declaration

Field Value

Remarks

DeletedDate

Declaration

Field Value

Remarks

Department

Declaration

Field Value

Remarks

Firstname

Declaration

Field Value

Remarks