Class PersonTableInfo

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

Inheritance
Object
TableInfo
PersonTableInfo
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

Properties

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

Declaration
public Int32FieldInfo ActiveErpLinks { get; }
Property Value
Type Description
Int32FieldInfo

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 true

Declaration
public UInt16FieldInfo ActiveInterests { get; }
Property Value
Type Description
UInt16FieldInfo

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_id

Declaration
public Int32FieldInfo AssociateId { get; }
Property Value
Type Description
Int32FieldInfo

BlockEmarketing

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

Do not send E-marketing materials to this person

Declaration
public UInt16FieldInfo BlockEmarketing { get; }
Property Value
Type Description
UInt16FieldInfo

BusinessIdx

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

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

Declaration
public Int32FieldInfo BusinessIdx { get; }
Property Value
Type Description
Int32FieldInfo

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>

CategoryIdx

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

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

Declaration
public Int32FieldInfo CategoryIdx { get; }
Property Value
Type Description
Int32FieldInfo

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>

ContactId

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

Owning contact ID

Declaration
public Int32FieldInfo ContactId { get; }
Property Value
Type Description
Int32FieldInfo

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>

CountryId

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

Country

Declaration
public Int32FieldInfo CountryId { get; }
Property Value
Type Description
Int32FieldInfo

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>

DayOfBirth

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

Birth date (day of month)

Declaration
public UInt16FieldInfo DayOfBirth { get; }
Property Value
Type Description
UInt16FieldInfo

DbiAgentId

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

Integration agent (eJournal)

Declaration
public Int32FieldInfo DbiAgentId { get; }
Property Value
Type Description
Int32FieldInfo

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>

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

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

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

Definition

Definition of the table as described in the deployed runtime dictionary

Declaration
public override SoTable Definition { get; }
Property Value
Type Description
SoTable
Overrides

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 shown

Declaration
public DateTimeFieldInfo DeletedDate { get; }
Property Value
Type Description
DateTimeFieldInfo

Department

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

Internal department address

Declaration
public StringFieldInfo Department { get; }
Property Value
Type Description
StringFieldInfo

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

Firstname

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

First name

Declaration
public StringFieldInfo Firstname { get; }
Property Value
Type Description
StringFieldInfo

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

Declaration
public FieldInfo Gender { get; }
Property Value
Type Description
FieldInfo

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_id

Declaration
public Int32FieldInfo GroupId { get; }
Property Value
Type Description
Int32FieldInfo

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 market

Declaration
public StringFieldInfo Initials { get; }
Property Value
Type Description
StringFieldInfo

Kanafname

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

Kana last name, used in Japanese versions only

Declaration
public StringFieldInfo Kanafname { get; }
Property Value
Type Description
StringFieldInfo

Kanalname

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

Kana last name, used in Japanese versions only

Declaration
public StringFieldInfo Kanalname { get; }
Property Value
Type Description
StringFieldInfo

Lastname

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

Last name

Declaration
public StringFieldInfo Lastname { get; }
Property Value
Type Description
StringFieldInfo

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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

MonthOfBirth

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

Birth month

Declaration
public UInt16FieldInfo MonthOfBirth { get; }
Property Value
Type Description
UInt16FieldInfo

Mrmrs

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

e.g. Mrs sex_title

Declaration
public StringFieldInfo Mrmrs { get; }
Property Value
Type Description
StringFieldInfo

Nomailing

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

Do not send DM's to this person

Declaration
public UInt16FieldInfo Nomailing { get; }
Property Value
Type Description
UInt16FieldInfo

PersonId

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

Primary key

Declaration
public Int32FieldInfo PersonId { get; }
Property Value
Type Description
Int32FieldInfo

PersonNumber

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

Alphanumeric user field

Declaration
public StringFieldInfo PersonNumber { get; }
Property Value
Type Description
StringFieldInfo

PhonePresent

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

flag to show there are phone registrations

Declaration
public UInt16FieldInfo PhonePresent { get; }
Property Value
Type Description
UInt16FieldInfo

PositionIdx

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

Link to Position list

Declaration
public Int32FieldInfo PositionIdx { get; }
Property Value
Type Description
Int32FieldInfo

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>

Post1

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

Postal address, used in Japanese versions only

Declaration
public StringFieldInfo Post1 { get; }
Property Value
Type Description
StringFieldInfo

Post2

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

Postal address, used in Japanese versions only

Declaration
public StringFieldInfo Post2 { get; }
Property Value
Type Description
StringFieldInfo

Post3

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

Postal address, used in Japanese versions only

Declaration
public StringFieldInfo Post3 { get; }
Property Value
Type Description
StringFieldInfo

Rank

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

Display sort sequence for default sort order

Declaration
public UInt16FieldInfo Rank { get; }
Property Value
Type Description
UInt16FieldInfo

Registered

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

Registered date

Declaration
public DateTimeFieldInfo Registered { get; }
Property Value
Type Description
DateTimeFieldInfo

RegisteredAssociateId

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

Registered by whom

Declaration
public Int32FieldInfo RegisteredAssociateId { get; }
Property Value
Type Description
Int32FieldInfo

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>

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

RuntimeDefinition

Definition of the table as described in the deployed runtime dictionary

Declaration
[Obsolete("Use instance property Definition or static member DictionaryTableNumber", true)]
public static SoTable RuntimeDefinition { get; }
Property Value
Type Description
SoTable

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 all

Declaration
public StringFieldInfo Salutation { get; }
Property Value
Type Description
StringFieldInfo

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

ShowContactTickets

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

Should tickets related to the company be shown to this person

Declaration
public UInt16FieldInfo ShowContactTickets { get; }
Property Value
Type Description
UInt16FieldInfo

Source

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

How did we get this person? For future integration needs

Declaration
public UInt16FieldInfo Source { get; }
Property Value
Type Description
UInt16FieldInfo

SupportAssociateId

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

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

Declaration
public Int32FieldInfo SupportAssociateId { get; }
Property Value
Type Description
Int32FieldInfo

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>

SupportLanguageId

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

Customers language (does not necessarily map to ISO languages)

Declaration
public Int32FieldInfo SupportLanguageId { get; }
Property Value
Type Description
Int32FieldInfo

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>

TextId

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

Info tab contents

Declaration
public Int32FieldInfo TextId { get; }
Property Value
Type Description
Int32FieldInfo

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>

TicketPriorityId

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

Default ticket priority for new tickets

Declaration
public Int32FieldInfo TicketPriorityId { get; }
Property Value
Type Description
Int32FieldInfo

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>

Title

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

Title

Declaration
public StringFieldInfo Title { get; }
Property Value
Type Description
StringFieldInfo

TzLocationId

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

Default timezone location for this person

Declaration
public Int32FieldInfo TzLocationId { get; }
Property Value
Type Description
Int32FieldInfo

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>

Updated

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

Last updated date

Declaration
public DateTimeFieldInfo Updated { get; }
Property Value
Type Description
DateTimeFieldInfo

UpdatedAssociateId

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

Last updated by whom

Declaration
public Int32FieldInfo UpdatedAssociateId { get; }
Property Value
Type Description
Int32FieldInfo

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>

UpdatedCount

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

Number of times updated

Declaration
public UInt16FieldInfo UpdatedCount { get; }
Property Value
Type Description
UInt16FieldInfo

Usepersonaddress

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

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

Declaration
public UInt16FieldInfo Usepersonaddress { get; }
Property Value
Type Description
UInt16FieldInfo

Userdef2Id

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

User defined table record 2

Declaration
public Int32FieldInfo Userdef2Id { get; }
Property Value
Type Description
Int32FieldInfo

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>

UserdefId

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

User defined table record 1

Declaration
public Int32FieldInfo UserdefId { get; }
Property Value
Type Description
Int32FieldInfo

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>

YearOfBirth

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

Birth year (4 digit)

Declaration
public UInt16FieldInfo YearOfBirth { get; }
Property Value
Type Description
UInt16FieldInfo

Methods

IdxContactId(Int32)

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

FieldDescription
ContactIdOwning contact ID
Declaration
public Restriction IdxContactId(int contactId)
Parameters
Type Name Description
Int32 contactId
Returns
Type Description
Restriction

Implements

Extension Methods

EnumUtil.MapEnums<From, To>(From)