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 |
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 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:
Field | Description |
---|---|
ContactId | Owning contact ID |
Declaration
public Restriction IdxContactId(int contactId)
Parameters
Type | Name | Description |
---|---|---|
Int32 | contactId |
Returns
Type | Description |
---|---|
Restriction |