Class PersonTableInfo
Table 'person': Persons in a company or an organizations. All associates have a corresponding person record
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("person")]
public class PersonTableInfo : TableInfo, ICloneable
Remarks
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
Fields
DictionaryTableName
Conceptual name of table Person in the database dictionary: person
Declaration
public const string DictionaryTableName = "person"
Field Value
Type | Description |
---|---|
String |
Remarks
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
Properties
ActiveErpLinks
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 relationsDeclaration
public Int32FieldInfo ActiveErpLinks { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
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
ActiveInterests
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 trueDeclaration
public UInt16FieldInfo ActiveInterests { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
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
AssociateId
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_idDeclaration
public Int32FieldInfo AssociateId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
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
BlockEmarketing
Field 'blockEmarketing' in table 'person': Dictionary type Bool, .NET type: Int16
Do not send E-marketing materials to this personDeclaration
public UInt16FieldInfo BlockEmarketing { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
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
BusinessIdx
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_idxDeclaration
public Int32FieldInfo BusinessIdx { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
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
BusinessIdx_InnerJoin_Business
Generated join from the foreign key BusinessIdx in this table, to its target table BusinessTableInfo.
Declaration
public TargetedInnerJoin<BusinessTableInfo> BusinessIdx_InnerJoin_Business { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<BusinessTableInfo> |
Remarks
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
CategoryIdx
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_idxDeclaration
public Int32FieldInfo CategoryIdx { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
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
CategoryIdx_InnerJoin_Category
Generated join from the foreign key CategoryIdx in this table, to its target table CategoryTableInfo.
Declaration
public TargetedInnerJoin<CategoryTableInfo> CategoryIdx_InnerJoin_Category { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<CategoryTableInfo> |
Remarks
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
ContactId
Field 'contact_id' in table 'person': Dictionary type FK, target: Contact, .NET type: Int32
Owning contact IDDeclaration
public Int32FieldInfo ContactId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
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
ContactId_InnerJoin_Contact
Generated join from the foreign key ContactId in this table, to its target table ContactTableInfo.
Declaration
public TargetedInnerJoin<ContactTableInfo> ContactId_InnerJoin_Contact { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<ContactTableInfo> |
Remarks
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
CountryId
Field 'country_id' in table 'person': Dictionary type FK, target: Country, .NET type: Int32
CountryDeclaration
public Int32FieldInfo CountryId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
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
CountryId_InnerJoin_Country
Generated join from the foreign key CountryId in this table, to its target table CountryTableInfo.
Declaration
public TargetedInnerJoin<CountryTableInfo> CountryId_InnerJoin_Country { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<CountryTableInfo> |
Remarks
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
CreatedByFormId
Field 'created_by_form_id' in table 'person': Dictionary type FK, target: Form, .NET type: Int32
The form this person was created byDeclaration
public Int32FieldInfo CreatedByFormId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
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
CreatedByFormId_InnerJoin_Form
Generated join from the foreign key CreatedByFormId in this table, to its target table FormTableInfo.
Declaration
public TargetedInnerJoin<FormTableInfo> CreatedByFormId_InnerJoin_Form { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<FormTableInfo> |
Remarks
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
DayOfBirth
Field 'day_of_birth' in table 'person': Dictionary type UShort, .NET type: Int16
Birth date (day of month), 0 if not specifiedDeclaration
public UInt16FieldInfo DayOfBirth { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
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
DbiAgentId
Field 'dbi_agent_id' in table 'person': Dictionary type FK, target: DbiAgent, .NET type: Int32
Integration agent (eJournal)Declaration
public Int32FieldInfo DbiAgentId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
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
DbiAgentId_InnerJoin_DbiAgent
Generated join from the foreign key DbiAgentId in this table, to its target table DbiAgentTableInfo.
Declaration
public TargetedInnerJoin<DbiAgentTableInfo> DbiAgentId_InnerJoin_DbiAgent { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<DbiAgentTableInfo> |
Remarks
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
DbiKey
Field 'dbi_key' in table 'person': Dictionary type String[256], .NET type: String
The primary key for the integrated entry in the external datasource.Declaration
public StringFieldInfo DbiKey { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
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
DbiLastModified
Field 'dbi_last_modified' in table 'person': Dictionary type DateTime, .NET type: DateTime
When the entry was last modified.Declaration
public DateTimeFieldInfo DbiLastModified { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
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
DbiLastSyncronized
Field 'dbi_last_syncronized' in table 'person': Dictionary type DateTime, .NET type: DateTime
Last external syncronization.Declaration
public DateTimeFieldInfo DbiLastSyncronized { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
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
Definition of the table as described in the deployed runtime dictionary
Declaration
public override SoTable Definition { get; }
Property Value
Type | Description |
---|---|
SoTable |
Overrides
Remarks
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
DeletedDate
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 shownDeclaration
public DateTimeFieldInfo DeletedDate { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
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
Department
Field 'department' in table 'person': Dictionary type String[255], .NET type: String
Internal department addressDeclaration
public StringFieldInfo Department { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
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
DictionaryTableNumber
Table number for table Person in the database dictionary; potentially changes between databases, but always the same over the lifetime of any single database
Declaration
public int DictionaryTableNumber { get; }
Property Value
Type | Description |
---|---|
Int32 |
Remarks
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
Firstname
Field 'firstname' in table 'person': Dictionary type String[100], .NET type: String
First nameDeclaration
public StringFieldInfo Firstname { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
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
Gender
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 = maleDeclaration
public FieldInfo Gender { get; }
Property Value
Type | Description |
---|---|
FieldInfo |
Remarks
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
GroupId
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_idDeclaration
public Int32FieldInfo GroupId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
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
Initials
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 marketDeclaration
public StringFieldInfo Initials { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
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
Kanafname
Field 'kanafname' in table 'person': Dictionary type String[100], .NET type: String
Kana last name, used in Japanese versions onlyDeclaration
public StringFieldInfo Kanafname { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
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
Kanalname
Field 'kanalname' in table 'person': Dictionary type String[100], .NET type: String
Kana last name, used in Japanese versions onlyDeclaration
public StringFieldInfo Kanalname { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
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
Lastname
Field 'lastname' in table 'person': Dictionary type String[100], .NET type: String
Last nameDeclaration
public StringFieldInfo Lastname { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
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
LeftOuterJoin_Appointment_InvitedPersonId
Generated left outer join from the primary key PersonId on this table, to Appointment.InvitedPersonId.
Declaration
public TargetedLeftOuterJoin<AppointmentTableInfo> LeftOuterJoin_Appointment_InvitedPersonId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<AppointmentTableInfo> |
Remarks
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
LeftOuterJoin_Appointment_PersonId
Generated left outer join from the primary key PersonId on this table, to Appointment.PersonId.
Declaration
public TargetedLeftOuterJoin<AppointmentTableInfo> LeftOuterJoin_Appointment_PersonId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<AppointmentTableInfo> |
Remarks
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
LeftOuterJoin_Associate_PersonId
Generated left outer join from the primary key PersonId on this table, to Associate.PersonId.
Declaration
public TargetedLeftOuterJoin<AssociateTableInfo> LeftOuterJoin_Associate_PersonId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<AssociateTableInfo> |
Remarks
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
LeftOuterJoin_ChatSession_CustomerId
Generated left outer join from the primary key PersonId on this table, to ChatSession.CustomerId.
Declaration
public TargetedLeftOuterJoin<ChatSessionTableInfo> LeftOuterJoin_ChatSession_CustomerId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<ChatSessionTableInfo> |
Remarks
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
LeftOuterJoin_ConsentPerson_PersonId
Generated left outer join from the primary key PersonId on this table, to ConsentPerson.PersonId.
Declaration
public TargetedLeftOuterJoin<ConsentPersonTableInfo> LeftOuterJoin_ConsentPerson_PersonId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<ConsentPersonTableInfo> |
Remarks
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
LeftOuterJoin_Contact_SupportPersonId
Generated left outer join from the primary key PersonId on this table, to Contact.SupportPersonId.
Declaration
public TargetedLeftOuterJoin<ContactTableInfo> LeftOuterJoin_Contact_SupportPersonId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<ContactTableInfo> |
Remarks
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
LeftOuterJoin_CounterValue_PersonId
Generated left outer join from the primary key PersonId on this table, to CounterValue.PersonId.
Declaration
public TargetedLeftOuterJoin<CounterValueTableInfo> LeftOuterJoin_CounterValue_PersonId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<CounterValueTableInfo> |
Remarks
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
LeftOuterJoin_Credentials_PersonId
Generated left outer join from the primary key PersonId on this table, to Credentials.PersonId.
Declaration
public TargetedLeftOuterJoin<CredentialsTableInfo> LeftOuterJoin_Credentials_PersonId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<CredentialsTableInfo> |
Remarks
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
LeftOuterJoin_EjMessage_CustomerId
Generated left outer join from the primary key PersonId on this table, to EjMessage.CustomerId.
Declaration
public TargetedLeftOuterJoin<EjMessageTableInfo> LeftOuterJoin_EjMessage_CustomerId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<EjMessageTableInfo> |
Remarks
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
LeftOuterJoin_Email_PersonId
Generated left outer join from the primary key PersonId on this table, to Email.PersonId.
Declaration
public TargetedLeftOuterJoin<EmailTableInfo> LeftOuterJoin_Email_PersonId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<EmailTableInfo> |
Remarks
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
LeftOuterJoin_EmailItem_PersonId
Generated left outer join from the primary key PersonId on this table, to EmailItem.PersonId.
Declaration
public TargetedLeftOuterJoin<EmailItemTableInfo> LeftOuterJoin_EmailItem_PersonId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<EmailItemTableInfo> |
Remarks
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
LeftOuterJoin_FormSubmission_PersonId
Generated left outer join from the primary key PersonId on this table, to FormSubmission.PersonId.
Declaration
public TargetedLeftOuterJoin<FormSubmissionTableInfo> LeftOuterJoin_FormSubmission_PersonId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<FormSubmissionTableInfo> |
Remarks
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
LeftOuterJoin_Invoice_CustomerId
Generated left outer join from the primary key PersonId on this table, to Invoice.CustomerId.
Declaration
public TargetedLeftOuterJoin<InvoiceTableInfo> LeftOuterJoin_Invoice_CustomerId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<InvoiceTableInfo> |
Remarks
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
LeftOuterJoin_InvoiceSum_CustomerId
Generated left outer join from the primary key PersonId on this table, to InvoiceSum.CustomerId.
Declaration
public TargetedLeftOuterJoin<InvoiceSumTableInfo> LeftOuterJoin_InvoiceSum_CustomerId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<InvoiceSumTableInfo> |
Remarks
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
LeftOuterJoin_KbEntryComment_CustomerId
Generated left outer join from the primary key PersonId on this table, to KbEntryComment.CustomerId.
Declaration
public TargetedLeftOuterJoin<KbEntryCommentTableInfo> LeftOuterJoin_KbEntryComment_CustomerId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<KbEntryCommentTableInfo> |
Remarks
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
LeftOuterJoin_LoginCustomer_CustomerId
Generated left outer join from the primary key PersonId on this table, to LoginCustomer.CustomerId.
Declaration
public TargetedLeftOuterJoin<LoginCustomerTableInfo> LeftOuterJoin_LoginCustomer_CustomerId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<LoginCustomerTableInfo> |
Remarks
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
LeftOuterJoin_MessageCustomers_CustomerId
Generated left outer join from the primary key PersonId on this table, to MessageCustomers.CustomerId.
Declaration
public TargetedLeftOuterJoin<MessageCustomersTableInfo> LeftOuterJoin_MessageCustomers_CustomerId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<MessageCustomersTableInfo> |
Remarks
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
LeftOuterJoin_PersonInterest_PersonId
Generated left outer join from the primary key PersonId on this table, to PersonInterest.PersonId.
Declaration
public TargetedLeftOuterJoin<PersonInterestTableInfo> LeftOuterJoin_PersonInterest_PersonId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<PersonInterestTableInfo> |
Remarks
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
LeftOuterJoin_ProjectMember_PersonId
Generated left outer join from the primary key PersonId on this table, to ProjectMember.PersonId.
Declaration
public TargetedLeftOuterJoin<ProjectMemberTableInfo> LeftOuterJoin_ProjectMember_PersonId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<ProjectMemberTableInfo> |
Remarks
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
LeftOuterJoin_Sale_PersonId
Generated left outer join from the primary key PersonId on this table, to Sale.PersonId.
Declaration
public TargetedLeftOuterJoin<SaleTableInfo> LeftOuterJoin_Sale_PersonId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<SaleTableInfo> |
Remarks
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
LeftOuterJoin_SaleHist_PersonId
Generated left outer join from the primary key PersonId on this table, to SaleHist.PersonId.
Declaration
public TargetedLeftOuterJoin<SaleHistTableInfo> LeftOuterJoin_SaleHist_PersonId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<SaleHistTableInfo> |
Remarks
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
LeftOuterJoin_SaleStakeholder_PersonId
Generated left outer join from the primary key PersonId on this table, to SaleStakeholder.PersonId.
Declaration
public TargetedLeftOuterJoin<SaleStakeholderTableInfo> LeftOuterJoin_SaleStakeholder_PersonId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<SaleStakeholderTableInfo> |
Remarks
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
LeftOuterJoin_SBounceShipment_CustomerId
Generated left outer join from the primary key PersonId on this table, to SBounceShipment.CustomerId.
Declaration
public TargetedLeftOuterJoin<SBounceShipmentTableInfo> LeftOuterJoin_SBounceShipment_CustomerId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<SBounceShipmentTableInfo> |
Remarks
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
LeftOuterJoin_SelectionMember_PersonId
Generated left outer join from the primary key PersonId on this table, to SelectionMember.PersonId.
Declaration
public TargetedLeftOuterJoin<SelectionMemberTableInfo> LeftOuterJoin_SelectionMember_PersonId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<SelectionMemberTableInfo> |
Remarks
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
LeftOuterJoin_ShipmentTypeReservation_PersonId
Generated left outer join from the primary key PersonId on this table, to ShipmentTypeReservation.PersonId.
Declaration
public TargetedLeftOuterJoin<ShipmentTypeReservationTableInfo> LeftOuterJoin_ShipmentTypeReservation_PersonId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<ShipmentTypeReservationTableInfo> |
Remarks
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
LeftOuterJoin_SLinkCustomer_CustomerId
Generated left outer join from the primary key PersonId on this table, to SLinkCustomer.CustomerId.
Declaration
public TargetedLeftOuterJoin<SLinkCustomerTableInfo> LeftOuterJoin_SLinkCustomer_CustomerId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<SLinkCustomerTableInfo> |
Remarks
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
LeftOuterJoin_SListCustomer_CustomerId
Generated left outer join from the primary key PersonId on this table, to SListCustomer.CustomerId.
Declaration
public TargetedLeftOuterJoin<SListCustomerTableInfo> LeftOuterJoin_SListCustomer_CustomerId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<SListCustomerTableInfo> |
Remarks
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
LeftOuterJoin_Sms_CustomerId
Generated left outer join from the primary key PersonId on this table, to Sms.CustomerId.
Declaration
public TargetedLeftOuterJoin<SmsTableInfo> LeftOuterJoin_Sms_CustomerId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<SmsTableInfo> |
Remarks
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
LeftOuterJoin_SSentMessage_CustomerId
Generated left outer join from the primary key PersonId on this table, to SSentMessage.CustomerId.
Declaration
public TargetedLeftOuterJoin<SSentMessageTableInfo> LeftOuterJoin_SSentMessage_CustomerId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<SSentMessageTableInfo> |
Remarks
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
LeftOuterJoin_SShipmentAddr_CustomerId
Generated left outer join from the primary key PersonId on this table, to SShipmentAddr.CustomerId.
Declaration
public TargetedLeftOuterJoin<SShipmentAddrTableInfo> LeftOuterJoin_SShipmentAddr_CustomerId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<SShipmentAddrTableInfo> |
Remarks
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
LeftOuterJoin_StatusValue_PersonId
Generated left outer join from the primary key PersonId on this table, to StatusValue.PersonId.
Declaration
public TargetedLeftOuterJoin<StatusValueTableInfo> LeftOuterJoin_StatusValue_PersonId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<StatusValueTableInfo> |
Remarks
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
LeftOuterJoin_TemporaryKey_PersonId
Generated left outer join from the primary key PersonId on this table, to TemporaryKey.PersonId.
Declaration
public TargetedLeftOuterJoin<TemporaryKeyTableInfo> LeftOuterJoin_TemporaryKey_PersonId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<TemporaryKeyTableInfo> |
Remarks
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
LeftOuterJoin_Ticket_CustId
Generated left outer join from the primary key PersonId on this table, to Ticket.CustId.
Declaration
public TargetedLeftOuterJoin<TicketTableInfo> LeftOuterJoin_Ticket_CustId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<TicketTableInfo> |
Remarks
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
LeftOuterJoin_TicketCustomers_CustomerId
Generated left outer join from the primary key PersonId on this table, to TicketCustomers.CustomerId.
Declaration
public TargetedLeftOuterJoin<TicketCustomersTableInfo> LeftOuterJoin_TicketCustomers_CustomerId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<TicketCustomersTableInfo> |
Remarks
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
LeftOuterJoin_TicketLogAction_CustomerId
Generated left outer join from the primary key PersonId on this table, to TicketLogAction.CustomerId.
Declaration
public TargetedLeftOuterJoin<TicketLogActionTableInfo> LeftOuterJoin_TicketLogAction_CustomerId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<TicketLogActionTableInfo> |
Remarks
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
LeftOuterJoin_URL_PersonId
Generated left outer join from the primary key PersonId on this table, to URL.PersonId.
Declaration
public TargetedLeftOuterJoin<URLTableInfo> LeftOuterJoin_URL_PersonId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<URLTableInfo> |
Remarks
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
LeftOuterJoin_UserCandidate_PersonId
Generated left outer join from the primary key PersonId on this table, to UserCandidate.PersonId.
Declaration
public TargetedLeftOuterJoin<UserCandidateTableInfo> LeftOuterJoin_UserCandidate_PersonId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<UserCandidateTableInfo> |
Remarks
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
LeftOuterJoin_WorkflowInstance_PersonId
Generated left outer join from the primary key PersonId on this table, to WorkflowInstance.PersonId.
Declaration
public TargetedLeftOuterJoin<WorkflowInstanceTableInfo> LeftOuterJoin_WorkflowInstance_PersonId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<WorkflowInstanceTableInfo> |
Remarks
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
MiddleName
Field 'middleName' in table 'person': Dictionary type String[100], .NET type: String
Middle name or 'van' etc.Declaration
public StringFieldInfo MiddleName { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
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
ModifiedByWorkflowId
Field 'modified_by_workflow_id' in table 'person': Dictionary type FK, target: Workflow, .NET type: Int32
The workflow this person last was modified byDeclaration
public Int32FieldInfo ModifiedByWorkflowId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
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
ModifiedByWorkflowId_InnerJoin_Workflow
Generated join from the foreign key ModifiedByWorkflowId in this table, to its target table WorkflowTableInfo.
Declaration
public TargetedInnerJoin<WorkflowTableInfo> ModifiedByWorkflowId_InnerJoin_Workflow { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<WorkflowTableInfo> |
Remarks
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
ModifiedByWorkflowWhen
Field 'modified_by_workflow_when' in table 'person': Dictionary type UtcDateTime, .NET type: DateTime
When the workflow modified this personDeclaration
public DateTimeFieldInfo ModifiedByWorkflowWhen { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
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
MonthOfBirth
Field 'month_of_birth' in table 'person': Dictionary type UShort, .NET type: Int16
Birth month (1-12), 0 if not specifiedDeclaration
public UInt16FieldInfo MonthOfBirth { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
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
Mrmrs
Field 'mrmrs' in table 'person': Dictionary type String[240], .NET type: String
e.g. Mrs sex_titleDeclaration
public StringFieldInfo Mrmrs { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
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
Nomailing
Field 'nomailing' in table 'person': Dictionary type Bool, .NET type: Int16
Do not send DM's to this personDeclaration
public UInt16FieldInfo Nomailing { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
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
PersonId
Field 'person_id' in table 'person': Dictionary type PK, .NET type: Int32
Primary keyDeclaration
public Int32FieldInfo PersonId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
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
PersonNumber
Field 'person_number' in table 'person': Dictionary type String[50], .NET type: String
Alphanumeric user fieldDeclaration
public StringFieldInfo PersonNumber { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
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
PhonePresent
Field 'phone_present' in table 'person': Dictionary type UShort, .NET type: Int16
flag to show there are phone registrationsDeclaration
public UInt16FieldInfo PhonePresent { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
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
PositionIdx
Field 'position_idx' in table 'person': Dictionary type FK, target: PersPos, .NET type: Int32
Link to Position listDeclaration
public Int32FieldInfo PositionIdx { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
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
PositionIdx_InnerJoin_PersPos
Generated join from the foreign key PositionIdx in this table, to its target table PersPosTableInfo.
Declaration
public TargetedInnerJoin<PersPosTableInfo> PositionIdx_InnerJoin_PersPos { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<PersPosTableInfo> |
Remarks
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
Post1
Field 'post1' in table 'person': Dictionary type String[100], .NET type: String
Postal address, used in Japanese versions onlyDeclaration
public StringFieldInfo Post1 { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
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
Post2
Field 'post2' in table 'person': Dictionary type String[100], .NET type: String
Postal address, used in Japanese versions onlyDeclaration
public StringFieldInfo Post2 { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
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
Post3
Field 'post3' in table 'person': Dictionary type String[100], .NET type: String
Postal address, used in Japanese versions onlyDeclaration
public StringFieldInfo Post3 { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
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
Rank
Field 'rank' in table 'person': Dictionary type UShort, .NET type: Int16
Display sort sequence for default sort orderDeclaration
public UInt16FieldInfo Rank { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
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
Registered
Field 'registered' in table 'person': Dictionary type UtcDateTime, .NET type: DateTime
Registered dateDeclaration
public DateTimeFieldInfo Registered { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
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
RegisteredAssociateId
Field 'registered_associate_id' in table 'person': Dictionary type FK, target: Associate, .NET type: Int32
Registered by whomDeclaration
public Int32FieldInfo RegisteredAssociateId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
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
RegisteredAssociateId_InnerJoin_Associate
Generated join from the foreign key RegisteredAssociateId in this table, to its target table AssociateTableInfo.
Declaration
public TargetedInnerJoin<AssociateTableInfo> RegisteredAssociateId_InnerJoin_Associate { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<AssociateTableInfo> |
Remarks
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
Retired
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.Declaration
public UInt16FieldInfo Retired { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
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
RuntimeDefinition
Definition of the table as described in the deployed runtime dictionary
Declaration
public static SoTable RuntimeDefinition { get; }
Property Value
Type | Description |
---|---|
SoTable |
Remarks
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
Salutation
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 allDeclaration
public StringFieldInfo Salutation { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
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
SentInfo
Field 'sentInfo' in table 'person': Dictionary type UShort, .NET type: Int16
Has information on username/password been sent (ejournal)Declaration
public UInt16FieldInfo SentInfo { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
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
ShowContactTickets
Field 'showContactTickets' in table 'person': Dictionary type UShort, .NET type: Int16
Should tickets related to the company be shown to this personDeclaration
public UInt16FieldInfo ShowContactTickets { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
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
Source
Field 'source' in table 'person': Dictionary type UShort, .NET type: Int16
How did we get this person? For future integration needsDeclaration
public UInt16FieldInfo Source { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
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
SupportAssociateId
Field 'supportAssociateId' in table 'person': Dictionary type FK, target: Associate, .NET type: Int32
Our contact, but for support context, not sales/primary contactDeclaration
public Int32FieldInfo SupportAssociateId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
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
SupportAssociateId_InnerJoin_Associate
Generated join from the foreign key SupportAssociateId in this table, to its target table AssociateTableInfo.
Declaration
public TargetedInnerJoin<AssociateTableInfo> SupportAssociateId_InnerJoin_Associate { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<AssociateTableInfo> |
Remarks
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
SupportLanguageId
Field 'supportLanguageId' in table 'person': Dictionary type FK, target: CustLang, .NET type: Int32
Customers language (does not necessarily map to ISO languages)Declaration
public Int32FieldInfo SupportLanguageId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
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
SupportLanguageId_InnerJoin_CustLang
Generated join from the foreign key SupportLanguageId in this table, to its target table CustLangTableInfo.
Declaration
public TargetedInnerJoin<CustLangTableInfo> SupportLanguageId_InnerJoin_CustLang { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<CustLangTableInfo> |
Remarks
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
TextId
Field 'text_id' in table 'person': Dictionary type FK, target: Text, .NET type: Int32
Info tab contentsDeclaration
public Int32FieldInfo TextId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
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
TextId_InnerJoin_Text
Generated join from the foreign key TextId in this table, to its target table TextTableInfo.
Declaration
public TargetedInnerJoin<TextTableInfo> TextId_InnerJoin_Text { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<TextTableInfo> |
Remarks
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
TicketPriorityId
Field 'ticketPriorityId' in table 'person': Dictionary type FK, target: TicketPriority, .NET type: Int32
Default ticket priority for new ticketsDeclaration
public Int32FieldInfo TicketPriorityId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
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
TicketPriorityId_InnerJoin_TicketPriority
Generated join from the foreign key TicketPriorityId in this table, to its target table TicketPriorityTableInfo.
Declaration
public TargetedInnerJoin<TicketPriorityTableInfo> TicketPriorityId_InnerJoin_TicketPriority { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<TicketPriorityTableInfo> |
Remarks
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
Title
Field 'title' in table 'person': Dictionary type String[240], .NET type: String
TitleDeclaration
public StringFieldInfo Title { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
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
TzLocationId
Field 'tzLocationId' in table 'person': Dictionary type FK, target: TZLocation, .NET type: Int32
Default timezone location for this personDeclaration
public Int32FieldInfo TzLocationId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
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
TzLocationId_InnerJoin_TZLocation
Generated join from the foreign key TzLocationId in this table, to its target table TZLocationTableInfo.
Declaration
public TargetedInnerJoin<TZLocationTableInfo> TzLocationId_InnerJoin_TZLocation { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<TZLocationTableInfo> |
Remarks
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
Updated
Field 'updated' in table 'person': Dictionary type UtcDateTime, .NET type: DateTime
Last updated dateDeclaration
public DateTimeFieldInfo Updated { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
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
UpdatedAssociateId
Field 'updated_associate_id' in table 'person': Dictionary type FK, target: Associate, .NET type: Int32
Last updated by whomDeclaration
public Int32FieldInfo UpdatedAssociateId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
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
UpdatedAssociateId_InnerJoin_Associate
Generated join from the foreign key UpdatedAssociateId in this table, to its target table AssociateTableInfo.
Declaration
public TargetedInnerJoin<AssociateTableInfo> UpdatedAssociateId_InnerJoin_Associate { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<AssociateTableInfo> |
Remarks
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
UpdatedCount
Field 'updatedCount' in table 'person': Dictionary type UShort, .NET type: Int16
Number of times updatedDeclaration
public UInt16FieldInfo UpdatedCount { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
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
Usepersonaddress
Field 'usepersonaddress' in table 'person': Dictionary type UShort, .NET type: Int16
If 1, use person's address for mailing instead of company addressDeclaration
public UInt16FieldInfo Usepersonaddress { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
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
Userdef2Id
Field 'userdef2_id' in table 'person': Dictionary type FK, target: UDPersonLarge, .NET type: Int32
User defined table record 2Declaration
public Int32FieldInfo Userdef2Id { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
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
Userdef2Id_InnerJoin_UDPersonLarge
Generated join from the foreign key Userdef2Id in this table, to its target table UDPersonLargeTableInfo.
Declaration
public TargetedInnerJoin<UDPersonLargeTableInfo> Userdef2Id_InnerJoin_UDPersonLarge { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<UDPersonLargeTableInfo> |
Remarks
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
UserdefId
Field 'userdef_id' in table 'person': Dictionary type FK, target: UDPersonSmall, .NET type: Int32
User defined table record 1Declaration
public Int32FieldInfo UserdefId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
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
UserdefId_InnerJoin_UDPersonSmall
Generated join from the foreign key UserdefId in this table, to its target table UDPersonSmallTableInfo.
Declaration
public TargetedInnerJoin<UDPersonSmallTableInfo> UserdefId_InnerJoin_UDPersonSmall { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<UDPersonSmallTableInfo> |
Remarks
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
YearOfBirth
Field 'year_of_birth' in table 'person': Dictionary type UShort, .NET type: Int16
Birth year (4 digit), 0 if not specifedDeclaration
public UInt16FieldInfo YearOfBirth { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
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
Methods
IdxContactId(Int32)
Shortcut method for looking up using the database index ContactId, which spans the following fields:
Field | Description |
---|---|
ContactId | Owning contact ID |
Declaration
public Restriction IdxContactId(int contactId)
Parameters
Type | Name | Description |
---|---|---|
Int32 | contactId |
Returns
Type | Description |
---|---|
Restriction |
Remarks
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