Class PersonTableInfo

Table 'person': Persons in a company or an organizations. All associates have a corresponding person record

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Conceptual name of table Person in the database dictionary: person

Type	Description
String

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'activeErpLinks' in table 'person': Dictionary type Int, .NET type: Int32

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

Type	Description
Int32FieldInfo

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'activeInterests' in table 'person': Dictionary type UShort, .NET type: Int16

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

Type	Description
UInt16FieldInfo

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'associate_id' in table 'person': Dictionary type Id, .NET type: Int32

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

Type	Description
Int32FieldInfo

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'blockEmarketing' in table 'person': Dictionary type Bool, .NET type: Int16

Do not send E-marketing materials to this person

Type	Description
UInt16FieldInfo

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'business_idx' in table 'person': Dictionary type FK, target: Business, .NET type: Int32

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

Type	Description
Int32FieldInfo

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated join from the foreign key BusinessIdx in this table, to its target table BusinessTableInfo.

Type	Description
TargetedInnerJoin<BusinessTableInfo>

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'category_idx' in table 'person': Dictionary type FK, target: Category, .NET type: Int32

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

Type	Description
Int32FieldInfo

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated join from the foreign key CategoryIdx in this table, to its target table CategoryTableInfo.

Type	Description
TargetedInnerJoin<CategoryTableInfo>

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'contact_id' in table 'person': Dictionary type FK, target: Contact, .NET type: Int32

Owning contact ID

Type	Description
Int32FieldInfo

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated join from the foreign key ContactId in this table, to its target table ContactTableInfo.

Type	Description
TargetedInnerJoin<ContactTableInfo>

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'country_id' in table 'person': Dictionary type FK, target: Country, .NET type: Int32

Country

Type	Description
Int32FieldInfo

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated join from the foreign key CountryId in this table, to its target table CountryTableInfo.

Type	Description
TargetedInnerJoin<CountryTableInfo>

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'created_by_form_id' in table 'person': Dictionary type FK, target: Form, .NET type: Int32

The form this person was created by

Type	Description
Int32FieldInfo

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated join from the foreign key CreatedByFormId in this table, to its target table FormTableInfo.

Type	Description
TargetedInnerJoin<FormTableInfo>

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'day_of_birth' in table 'person': Dictionary type UShort, .NET type: Int16

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

Type	Description
UInt16FieldInfo

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'dbi_agent_id' in table 'person': Dictionary type FK, target: DbiAgent, .NET type: Int32

Integration agent (eJournal)

Type	Description
Int32FieldInfo

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated join from the foreign key DbiAgentId in this table, to its target table DbiAgentTableInfo.

Type	Description
TargetedInnerJoin<DbiAgentTableInfo>

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'dbi_key' in table 'person': Dictionary type String[256], .NET type: String

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

Type	Description
StringFieldInfo

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'dbi_last_modified' in table 'person': Dictionary type DateTime, .NET type: DateTime

When the entry was last modified.

Type	Description
DateTimeFieldInfo

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'dbi_last_syncronized' in table 'person': Dictionary type DateTime, .NET type: DateTime

Last external syncronization.

Type	Description
DateTimeFieldInfo

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Definition of the table as described in the deployed runtime dictionary

Type	Description
SoTable

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'DeletedDate' in table 'person': Dictionary type UtcDateTime, .NET type: DateTime

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

Type	Description
DateTimeFieldInfo

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'department' in table 'person': Dictionary type String[255], .NET type: String

Internal department address

Type	Description
StringFieldInfo

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Table number for table Person in the database dictionary; potentially changes between databases, but always the same over the lifetime of any single database

Type	Description
Int32

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'firstname' in table 'person': Dictionary type String[100], .NET type: String

First name

Type	Description
StringFieldInfo

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'gender' in table 'person': Dictionary type Enum, .NET type: Int16

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

Type	Description
FieldInfo

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'group_id' in table 'person': Dictionary type Id, .NET type: Int32

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

Type	Description
Int32FieldInfo

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'initials' in table 'person': Dictionary type String[64], .NET type: String

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

Type	Description
StringFieldInfo

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'kanafname' in table 'person': Dictionary type String[100], .NET type: String

Kana last name, used in Japanese versions only

Type	Description
StringFieldInfo

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'kanalname' in table 'person': Dictionary type String[100], .NET type: String

Kana last name, used in Japanese versions only

Type	Description
StringFieldInfo

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'lastname' in table 'person': Dictionary type String[100], .NET type: String

Last name

Type	Description
StringFieldInfo

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to Appointment.InvitedPersonId.

Type	Description
TargetedLeftOuterJoin<AppointmentTableInfo>

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to Appointment.PersonId.

Type	Description
TargetedLeftOuterJoin<AppointmentTableInfo>

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to Associate.PersonId.

Type	Description
TargetedLeftOuterJoin<AssociateTableInfo>

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to ChatSession.CustomerId.

Type	Description
TargetedLeftOuterJoin<ChatSessionTableInfo>

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to ConsentPerson.PersonId.

Type	Description
TargetedLeftOuterJoin<ConsentPersonTableInfo>

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to Contact.SupportPersonId.

Type	Description
TargetedLeftOuterJoin<ContactTableInfo>

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to CounterValue.PersonId.

Type	Description
TargetedLeftOuterJoin<CounterValueTableInfo>

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to Credentials.PersonId.

Type	Description
TargetedLeftOuterJoin<CredentialsTableInfo>

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to EjMessage.CustomerId.

Type	Description
TargetedLeftOuterJoin<EjMessageTableInfo>

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to Email.PersonId.

Type	Description
TargetedLeftOuterJoin<EmailTableInfo>

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to EmailItem.PersonId.

Type	Description
TargetedLeftOuterJoin<EmailItemTableInfo>

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to FormSubmission.PersonId.

Type	Description
TargetedLeftOuterJoin<FormSubmissionTableInfo>

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to Invoice.CustomerId.

Type	Description
TargetedLeftOuterJoin<InvoiceTableInfo>

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to InvoiceSum.CustomerId.

Type	Description
TargetedLeftOuterJoin<InvoiceSumTableInfo>

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to KbEntryComment.CustomerId.

Type	Description
TargetedLeftOuterJoin<KbEntryCommentTableInfo>

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to LoginCustomer.CustomerId.

Type	Description
TargetedLeftOuterJoin<LoginCustomerTableInfo>

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to MessageCustomers.CustomerId.

Type	Description
TargetedLeftOuterJoin<MessageCustomersTableInfo>

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to PersonInterest.PersonId.

Type	Description
TargetedLeftOuterJoin<PersonInterestTableInfo>

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to ProjectMember.PersonId.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to Sale.PersonId.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to SaleHist.PersonId.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to SaleStakeholder.PersonId.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to SBounceShipment.CustomerId.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to SelectionMember.PersonId.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to ShipmentTypeReservation.PersonId.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to SLinkCustomer.CustomerId.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to SListCustomer.CustomerId.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to Sms.CustomerId.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to SSentMessage.CustomerId.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to SShipmentAddr.CustomerId.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to StatusValue.PersonId.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to TemporaryKey.PersonId.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to Ticket.CustId.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to TicketCustomers.CustomerId.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to TicketLogAction.CustomerId.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to URL.PersonId.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to UserCandidate.PersonId.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key PersonId on this table, to WorkflowInstance.PersonId.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'middleName' in table 'person': Dictionary type String[100], .NET type: String

Middle name or 'van' etc.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'modified_by_workflow_id' in table 'person': Dictionary type FK, target: Workflow, .NET type: Int32

The workflow this person last was modified by

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated join from the foreign key ModifiedByWorkflowId in this table, to its target table WorkflowTableInfo.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'modified_by_workflow_when' in table 'person': Dictionary type UtcDateTime, .NET type: DateTime

When the workflow modified this person

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'month_of_birth' in table 'person': Dictionary type UShort, .NET type: Int16

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

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'mrmrs' in table 'person': Dictionary type String[240], .NET type: String

e.g. Mrs sex_title

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'nomailing' in table 'person': Dictionary type Bool, .NET type: Int16

Do not send DM's to this person

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'person_id' in table 'person': Dictionary type PK, .NET type: Int32

Primary key

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'person_number' in table 'person': Dictionary type String[50], .NET type: String

Alphanumeric user field

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'phone_present' in table 'person': Dictionary type UShort, .NET type: Int16

flag to show there are phone registrations

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'position_idx' in table 'person': Dictionary type FK, target: PersPos, .NET type: Int32

Link to Position list

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated join from the foreign key PositionIdx in this table, to its target table PersPosTableInfo.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'post1' in table 'person': Dictionary type String[100], .NET type: String

Postal address, used in Japanese versions only

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'post2' in table 'person': Dictionary type String[100], .NET type: String

Postal address, used in Japanese versions only

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'post3' in table 'person': Dictionary type String[100], .NET type: String

Postal address, used in Japanese versions only

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'rank' in table 'person': Dictionary type UShort, .NET type: Int16

Display sort sequence for default sort order

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'registered' in table 'person': Dictionary type UtcDateTime, .NET type: DateTime

Registered date

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'registered_associate_id' in table 'person': Dictionary type FK, target: Associate, .NET type: Int32

Registered by whom

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated join from the foreign key RegisteredAssociateId in this table, to its target table AssociateTableInfo.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'retired' in table 'person': Dictionary type UShort, .NET type: Int16

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

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Definition of the table as described in the deployed runtime dictionary

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'salutation' in table 'person': Dictionary type String[240], .NET type: String

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

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'sentInfo' in table 'person': Dictionary type UShort, .NET type: Int16

Has information on username/password been sent (ejournal)

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'showContactTickets' in table 'person': Dictionary type UShort, .NET type: Int16

Should tickets related to the company be shown to this person

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'source' in table 'person': Dictionary type UShort, .NET type: Int16

How did we get this person? For future integration needs

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'supportAssociateId' in table 'person': Dictionary type FK, target: Associate, .NET type: Int32

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

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated join from the foreign key SupportAssociateId in this table, to its target table AssociateTableInfo.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'supportLanguageId' in table 'person': Dictionary type FK, target: CustLang, .NET type: Int32

Customers language (does not necessarily map to ISO languages)

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated join from the foreign key SupportLanguageId in this table, to its target table CustLangTableInfo.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'text_id' in table 'person': Dictionary type FK, target: Text, .NET type: Int32

Info tab contents

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated join from the foreign key TextId in this table, to its target table TextTableInfo.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'ticketPriorityId' in table 'person': Dictionary type FK, target: TicketPriority, .NET type: Int32

Default ticket priority for new tickets

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated join from the foreign key TicketPriorityId in this table, to its target table TicketPriorityTableInfo.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'title' in table 'person': Dictionary type String[240], .NET type: String

Title

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'tzLocationId' in table 'person': Dictionary type FK, target: TZLocation, .NET type: Int32

Default timezone location for this person

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated join from the foreign key TzLocationId in this table, to its target table TZLocationTableInfo.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'updated' in table 'person': Dictionary type UtcDateTime, .NET type: DateTime

Last updated date

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'updated_associate_id' in table 'person': Dictionary type FK, target: Associate, .NET type: Int32

Last updated by whom

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated join from the foreign key UpdatedAssociateId in this table, to its target table AssociateTableInfo.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'updatedCount' in table 'person': Dictionary type UShort, .NET type: Int16

Number of times updated

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'usepersonaddress' in table 'person': Dictionary type UShort, .NET type: Int16

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

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'userdef2_id' in table 'person': Dictionary type FK, target: UDPersonLarge, .NET type: Int32

User defined table record 2

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated join from the foreign key Userdef2Id in this table, to its target table UDPersonLargeTableInfo.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'userdef_id' in table 'person': Dictionary type FK, target: UDPersonSmall, .NET type: Int32

User defined table record 1

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated join from the foreign key UserdefId in this table, to its target table UDPersonSmallTableInfo.

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Field 'year_of_birth' in table 'person': Dictionary type UShort, .NET type: Int16

Birth year (4 digit), 0 if not specifed

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Shortcut method for looking up using the database index ContactId, which spans the following fields:

Field	Description
ContactId	Owning contact ID

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Inheritance

Implements

Inherited Members

Namespace: SuperOffice.CRM.Data

Assembly: SoDataBase.dll

Syntax

Remarks

Fields

DictionaryTableName

Declaration

Field Value

Remarks

Properties

ActiveErpLinks

Declaration

Property Value

Remarks

ActiveInterests

Declaration

Property Value

Remarks

AssociateId

Declaration

Property Value

Remarks

BlockEmarketing

Declaration

Property Value

Remarks

BusinessIdx

Declaration

Property Value

Remarks

BusinessIdx_InnerJoin_Business

Declaration

Property Value

Remarks

CategoryIdx

Declaration

Property Value

Remarks

CategoryIdx_InnerJoin_Category

Declaration

Property Value

Remarks

ContactId

Declaration

Property Value

Remarks

ContactId_InnerJoin_Contact

Declaration

Property Value

Remarks

CountryId

Declaration

Property Value

Remarks

CountryId_InnerJoin_Country

Declaration

Property Value

Remarks

CreatedByFormId

Declaration

Property Value

Remarks

CreatedByFormId_InnerJoin_Form

Declaration

Property Value

Remarks

DayOfBirth

Declaration

Property Value

Remarks

DbiAgentId

Declaration

Property Value

Remarks

DbiAgentId_InnerJoin_DbiAgent

Declaration