Class ContactTableInfo

Table 'contact': Companies and Organizations.

Inheritance

object

TableInfo

ContactTableInfo

Implements

ICloneable

Inherited Members

TableInfo.ToString()

TableInfo.RegisterFields(params FieldInfo[])

TableInfo.FieldInfoFromSoField(SoField)

TableInfo.Clone()

TableInfo.IsSameTable(TableInfo)

TableInfo.FindField(string)

TableInfo.ProtAll

TableInfo.UseNolockIfPossible

TableInfo.HashCheckFields

TableInfo.TableName

TableInfo.DbName

TableInfo.IsDictionaryTable

TableInfo.All

TableInfo.this[string]

TableInfo.PrimaryKeyField

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: SuperOffice.CRM.Data

Assembly: SoDataBase.dll

Syntax

[DatabaseTable("contact")]
public class ContactTableInfo : 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 TablesInfo.GetContactInfo().

Fields

DictionaryTableName

Conceptual name of table Contact in the database dictionary: contact

Declaration

public const string DictionaryTableName = "contact"

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 TablesInfo.GetContactInfo().

Properties

ActiveErpLinks

Field 'activeErpLinks' in table 'contact': Dictionary type Int, .NET type: int

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

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 TablesInfo.GetContactInfo().

ActiveInterests

Field 'activeInterests' in table 'contact': Dictionary type UShort, .NET type: short

Number of records in cintr table; select count(*) from cintr ci where ci.contact_id = this.contact_id == activeInterests is always true

Declaration

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 TablesInfo.GetContactInfo().

AssociateId

Field 'associate_id' in table 'contact': Dictionary type FK, target: Associate, .NET type: int

Our contact

Declaration

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 TablesInfo.GetContactInfo().

AssociateId_InnerJoin_Associate

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

Declaration

public TargetedInnerJoin<AssociateTableInfo> AssociateId_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 TablesInfo.GetContactInfo().

BusinessIdx

Field 'business_idx' in table 'contact': Dictionary type FK, target: Business, .NET type: int

Link to Business

Declaration

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 TablesInfo.GetContactInfo().

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 TablesInfo.GetContactInfo().

CategoryIdx

Field 'category_idx' in table 'contact': Dictionary type FK, target: Category, .NET type: int

Link to Category

Declaration

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 TablesInfo.GetContactInfo().

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 TablesInfo.GetContactInfo().

ContactId

Field 'contact_id' in table 'contact': Dictionary type PK, .NET type: int

Primary key

Declaration

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 TablesInfo.GetContactInfo().

CountryId

Field 'country_id' in table 'contact': Dictionary type FK, target: Country, .NET type: int

Country

Declaration

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 TablesInfo.GetContactInfo().

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 TablesInfo.GetContactInfo().

DbiAgentId

Field 'dbi_agent_id' in table 'contact': Dictionary type FK, target: DbiAgent, .NET type: int

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 TablesInfo.GetContactInfo().

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 TablesInfo.GetContactInfo().

DbiKey

Field 'dbi_key' in table 'contact': 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 TablesInfo.GetContactInfo().

DbiLastModified

Field 'dbi_last_modified' in table 'contact': 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 TablesInfo.GetContactInfo().

DbiLastSyncronized

Field 'dbi_last_syncronized' in table 'contact': 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 TablesInfo.GetContactInfo().

Definition

Definition of the table as described in the deployed runtime dictionary

Declaration

public override SoTable Definition { get; }

Property Value

Type	Description
SoTable

Overrides

TableInfo.Definition

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 TablesInfo.GetContactInfo().

Deleted

Field 'deleted' in table 'contact': Dictionary type UShort, .NET type: short

If nonzero, then this contact is 'deleted' and should generally not be shown

Declaration

public UInt16FieldInfo Deleted { 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 TablesInfo.GetContactInfo().

DeletedDate

Field 'DeletedDate' in table 'contact': 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

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 TablesInfo.GetContactInfo().

Department

Field 'department' in table 'contact': Dictionary type String[220], .NET type: string

Department

Declaration

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 TablesInfo.GetContactInfo().

DictionaryTableNumber

Table number for table Contact 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
int

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 TablesInfo.GetContactInfo().

GroupId

Field 'group_id' in table 'contact': Dictionary type FK, target: UserGroup, .NET type: int

Group id of original owning associate, semantics like appnt.grp_id

Declaration

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 TablesInfo.GetContactInfo().

GroupId_InnerJoin_UserGroup

Generated join from the foreign key GroupId in this table, to its target table UserGroupTableInfo.

Declaration

public TargetedInnerJoin<UserGroupTableInfo> GroupId_InnerJoin_UserGroup { get; }

Property Value

Type	Description
TargetedInnerJoin<UserGroupTableInfo>

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 TablesInfo.GetContactInfo().

Kananame

Field 'kananame' in table 'contact': Dictionary type String[220], .NET type: string

Contact kana name, used in Japanese versions only

Declaration

public StringFieldInfo Kananame { 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 TablesInfo.GetContactInfo().

LeftOuterJoin_Appointment_ContactId

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

Declaration

public TargetedLeftOuterJoin<AppointmentTableInfo> LeftOuterJoin_Appointment_ContactId { 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 TablesInfo.GetContactInfo().

LeftOuterJoin_ChatSession_ContactId

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

Declaration

public TargetedLeftOuterJoin<ChatSessionTableInfo> LeftOuterJoin_ChatSession_ContactId { 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 TablesInfo.GetContactInfo().

LeftOuterJoin_CompanyDomain_CompanyId

Generated left outer join from the primary key ContactId on this table, to CompanyDomain.CompanyId.

Declaration

public TargetedLeftOuterJoin<CompanyDomainTableInfo> LeftOuterJoin_CompanyDomain_CompanyId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<CompanyDomainTableInfo>

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 TablesInfo.GetContactInfo().

LeftOuterJoin_ContactInterest_ContactId

Generated left outer join from the primary key ContactId on this table, to ContactInterest.ContactId.

Declaration

public TargetedLeftOuterJoin<ContactInterestTableInfo> LeftOuterJoin_ContactInterest_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<ContactInterestTableInfo>

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 TablesInfo.GetContactInfo().

LeftOuterJoin_CounterValue_ContactId

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

Declaration

public TargetedLeftOuterJoin<CounterValueTableInfo> LeftOuterJoin_CounterValue_ContactId { 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 TablesInfo.GetContactInfo().

LeftOuterJoin_EmailItem_ContactId

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

Declaration

public TargetedLeftOuterJoin<EmailItemTableInfo> LeftOuterJoin_EmailItem_ContactId { 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 TablesInfo.GetContactInfo().

LeftOuterJoin_Email_ContactId

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

Declaration

public TargetedLeftOuterJoin<EmailTableInfo> LeftOuterJoin_Email_ContactId { 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 TablesInfo.GetContactInfo().

LeftOuterJoin_FormSubmission_ContactId

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

Declaration

public TargetedLeftOuterJoin<FormSubmissionTableInfo> LeftOuterJoin_FormSubmission_ContactId { 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 TablesInfo.GetContactInfo().

LeftOuterJoin_FreeTextIndex_ContactId

Generated left outer join from the primary key ContactId on this table, to FreeTextIndex.ContactId.

Declaration

public TargetedLeftOuterJoin<FreeTextIndexTableInfo> LeftOuterJoin_FreeTextIndex_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<FreeTextIndexTableInfo>

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 TablesInfo.GetContactInfo().

LeftOuterJoin_InvoiceSum_CompanyId

Generated left outer join from the primary key ContactId on this table, to InvoiceSum.CompanyId.

Declaration

public TargetedLeftOuterJoin<InvoiceSumTableInfo> LeftOuterJoin_InvoiceSum_CompanyId { 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 TablesInfo.GetContactInfo().

LeftOuterJoin_Invoice_CompanyId

Generated left outer join from the primary key ContactId on this table, to Invoice.CompanyId.

Declaration

public TargetedLeftOuterJoin<InvoiceTableInfo> LeftOuterJoin_Invoice_CompanyId { 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 TablesInfo.GetContactInfo().

LeftOuterJoin_Notify_ContactId

Generated left outer join from the primary key ContactId on this table, to Notify.ContactId.

Declaration

public TargetedLeftOuterJoin<NotifyTableInfo> LeftOuterJoin_Notify_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<NotifyTableInfo>

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 TablesInfo.GetContactInfo().

LeftOuterJoin_OwnerContactLink_ContactId

Generated left outer join from the primary key ContactId on this table, to OwnerContactLink.ContactId.

Declaration

public TargetedLeftOuterJoin<OwnerContactLinkTableInfo> LeftOuterJoin_OwnerContactLink_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<OwnerContactLinkTableInfo>

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 TablesInfo.GetContactInfo().

LeftOuterJoin_Person_ContactId

Generated left outer join from the primary key ContactId on this table, to Person.ContactId.

Declaration

public TargetedLeftOuterJoin<PersonTableInfo> LeftOuterJoin_Person_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<PersonTableInfo>

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 TablesInfo.GetContactInfo().

LeftOuterJoin_ProjectMember_ContactId

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

Declaration

public TargetedLeftOuterJoin<ProjectMemberTableInfo> LeftOuterJoin_ProjectMember_ContactId { 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 TablesInfo.GetContactInfo().

LeftOuterJoin_SShipmentAddr_ContactId

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

Declaration

public TargetedLeftOuterJoin<SShipmentAddrTableInfo> LeftOuterJoin_SShipmentAddr_ContactId { 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 TablesInfo.GetContactInfo().

LeftOuterJoin_SaleHist_ContactId

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

Declaration

public TargetedLeftOuterJoin<SaleHistTableInfo> LeftOuterJoin_SaleHist_ContactId { 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 TablesInfo.GetContactInfo().

LeftOuterJoin_SaleStakeholder_ContactId

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

Declaration

public TargetedLeftOuterJoin<SaleStakeholderTableInfo> LeftOuterJoin_SaleStakeholder_ContactId { 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 TablesInfo.GetContactInfo().

LeftOuterJoin_Sale_ContactId

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

Declaration

public TargetedLeftOuterJoin<SaleTableInfo> LeftOuterJoin_Sale_ContactId { 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 TablesInfo.GetContactInfo().

LeftOuterJoin_Satellite_ContactId

Generated left outer join from the primary key ContactId on this table, to Satellite.ContactId.

Declaration

public TargetedLeftOuterJoin<SatelliteTableInfo> LeftOuterJoin_Satellite_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<SatelliteTableInfo>

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 TablesInfo.GetContactInfo().

LeftOuterJoin_SelectionMember_ContactId

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

Declaration

public TargetedLeftOuterJoin<SelectionMemberTableInfo> LeftOuterJoin_SelectionMember_ContactId { 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 TablesInfo.GetContactInfo().

LeftOuterJoin_StatusValue_ContactId

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

Declaration

public TargetedLeftOuterJoin<StatusValueTableInfo> LeftOuterJoin_StatusValue_ContactId { 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 TablesInfo.GetContactInfo().

LeftOuterJoin_TargetAssignmentInfo_ContactId

Generated left outer join from the primary key ContactId on this table, to TargetAssignmentInfo.ContactId.

Declaration

public TargetedLeftOuterJoin<TargetAssignmentInfoTableInfo> LeftOuterJoin_TargetAssignmentInfo_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<TargetAssignmentInfoTableInfo>

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 TablesInfo.GetContactInfo().

LeftOuterJoin_TargetRevisionHistory_ContactId

Generated left outer join from the primary key ContactId on this table, to TargetRevisionHistory.ContactId.

Declaration

public TargetedLeftOuterJoin<TargetRevisionHistoryTableInfo> LeftOuterJoin_TargetRevisionHistory_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<TargetRevisionHistoryTableInfo>

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 TablesInfo.GetContactInfo().

LeftOuterJoin_Ticket_ContactId

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

Declaration

public TargetedLeftOuterJoin<TicketTableInfo> LeftOuterJoin_Ticket_ContactId { 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 TablesInfo.GetContactInfo().

LeftOuterJoin_URL_ContactId

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

Declaration

public TargetedLeftOuterJoin<URLTableInfo> LeftOuterJoin_URL_ContactId { 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 TablesInfo.GetContactInfo().

LeftOuterJoin_UtmParameters_CreatedContactId

Generated left outer join from the primary key ContactId on this table, to UtmParameters.CreatedContactId.

Declaration

public TargetedLeftOuterJoin<UtmParametersTableInfo> LeftOuterJoin_UtmParameters_CreatedContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<UtmParametersTableInfo>

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 TablesInfo.GetContactInfo().

LeftOuterJoin_WorkflowInstance_ContactId

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

Declaration

public TargetedLeftOuterJoin<WorkflowInstanceTableInfo> LeftOuterJoin_WorkflowInstance_ContactId { 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 TablesInfo.GetContactInfo().

MotherId

Field 'mother_id' in table 'contact': Dictionary type FK, target: Contact, .NET type: int

Reserved

Declaration

public Int32FieldInfo MotherId { 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 TablesInfo.GetContactInfo().

MotherId_InnerJoin_Contact

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

Declaration

public TargetedInnerJoin<ContactTableInfo> MotherId_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 TablesInfo.GetContactInfo().

Name

Field 'name' in table 'contact': Dictionary type String[220], .NET type: string

Contact name

Declaration

public StringFieldInfo Name { 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 TablesInfo.GetContactInfo().

Nomailing

Field 'nomailing' in table 'contact': Dictionary type Bool, .NET type: short

No mailings flags

Declaration

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 TablesInfo.GetContactInfo().

Number1

Field 'number1' in table 'contact': Dictionary type String[50], .NET type: string

Alphanumeric user field

Declaration

public StringFieldInfo Number1 { 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 TablesInfo.GetContactInfo().

Number2

Field 'number2' in table 'contact': Dictionary type String[50], .NET type: string

Alphanumeric user field

Declaration

public StringFieldInfo Number2 { 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 TablesInfo.GetContactInfo().

OrgNr

Field 'orgNr' in table 'contact': Dictionary type String[50], .NET type: string

VAT number or similar

Declaration

public StringFieldInfo OrgNr { 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 TablesInfo.GetContactInfo().

Registered

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

Date registered

Declaration

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 TablesInfo.GetContactInfo().

RegisteredAssociateId

Field 'registered_associate_id' in table 'contact': Dictionary type FK, target: Associate, .NET type: int

Registered by whom

Declaration

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 TablesInfo.GetContactInfo().

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 TablesInfo.GetContactInfo().

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

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 TablesInfo.GetContactInfo().

SoundEx

Field 'soundEx' in table 'contact': Dictionary type String[10], .NET type: string

What the name sounds like, for duplicate detection

Declaration

public StringFieldInfo SoundEx { 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 TablesInfo.GetContactInfo().

Source

Field 'source' in table 'contact': Dictionary type UShort, .NET type: short

How did we get this contact? For future integration needs

Declaration

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 TablesInfo.GetContactInfo().

SupportAssociateId

Field 'supportAssociateId' in table 'contact': Dictionary type FK, target: Associate, .NET type: int

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

Declaration

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 TablesInfo.GetContactInfo().

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 TablesInfo.GetContactInfo().

SupportLanguageId

Field 'supportLanguageId' in table 'contact': Dictionary type FK, target: CustLang, .NET type: int

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 TablesInfo.GetContactInfo().

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 TablesInfo.GetContactInfo().

SupportPersonId

Field 'supportPersonId' in table 'contact': Dictionary type FK, target: Person, .NET type: int

The person (at the customer) who support talks to (the counterpart of supportAssociateId)

Declaration

public Int32FieldInfo SupportPersonId { 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 TablesInfo.GetContactInfo().

SupportPersonId_InnerJoin_Person

Generated join from the foreign key SupportPersonId in this table, to its target table PersonTableInfo.

Declaration

public TargetedInnerJoin<PersonTableInfo> SupportPersonId_InnerJoin_Person { get; }

Property Value

Type	Description
TargetedInnerJoin<PersonTableInfo>

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 TablesInfo.GetContactInfo().

TextId

Field 'text_id' in table 'contact': Dictionary type FK, target: Text, .NET type: int

Paperclip note

Declaration

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 TablesInfo.GetContactInfo().

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 TablesInfo.GetContactInfo().

TicketPriorityId

Field 'ticketPriorityId' in table 'contact': Dictionary type FK, target: TicketPriority, .NET type: int

Default ticket priority for new tickets

Declaration

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 TablesInfo.GetContactInfo().

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 TablesInfo.GetContactInfo().

TzLocationId

Field 'tzLocationId' in table 'contact': Dictionary type FK, target: TZLocation, .NET type: int

Default timezone location for this contact

Declaration

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 TablesInfo.GetContactInfo().

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 TablesInfo.GetContactInfo().

Updated

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

Date last updated

Declaration

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 TablesInfo.GetContactInfo().

UpdatedAssociateId

Field 'updated_associate_id' in table 'contact': Dictionary type FK, target: Associate, .NET type: int

Last updated by whom

Declaration

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 TablesInfo.GetContactInfo().

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 TablesInfo.GetContactInfo().

UpdatedCount

Field 'updatedCount' in table 'contact': Dictionary type UShort, .NET type: short

Number of times updated

Declaration

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 TablesInfo.GetContactInfo().

Userdef2Id

Field 'userdef2_id' in table 'contact': Dictionary type FK, target: UDContactLarge, .NET type: int

User defined table record 2

Declaration

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 TablesInfo.GetContactInfo().

Userdef2Id_InnerJoin_UDContactLarge

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

Declaration

public TargetedInnerJoin<UDContactLargeTableInfo> Userdef2Id_InnerJoin_UDContactLarge { get; }

Property Value

Type	Description
TargetedInnerJoin<UDContactLargeTableInfo>

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 TablesInfo.GetContactInfo().

UserdefId

Field 'userdef_id' in table 'contact': Dictionary type FK, target: UDContactSmall, .NET type: int

User defined table record 1

Declaration

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 TablesInfo.GetContactInfo().

UserdefId_InnerJoin_UDContactSmall

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

Declaration

public TargetedInnerJoin<UDContactSmallTableInfo> UserdefId_InnerJoin_UDContactSmall { get; }

Property Value

Type	Description
TargetedInnerJoin<UDContactSmallTableInfo>

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 TablesInfo.GetContactInfo().

Xstop

Field 'xstop' in table 'contact': Dictionary type Bool, .NET type: short

STOP flag

Declaration

public UInt16FieldInfo Xstop { 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 TablesInfo.GetContactInfo().

Methods

IdxName(string)

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

Field	Description
Name	Contact name

Declaration

public Restriction IdxName(string name)

Parameters

Type	Name	Description
string	name

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 TablesInfo.GetContactInfo().

Implements

ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)