Class ContactTableInfo
Table 'contact': Companies and Organizations. This table features a special record containing information about the contact that owns the database.
Implements
Inherited Members
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
Fields
DictionaryTableName
Conceptual name of table Contact in the database dictionary: contact
Declaration
public const string DictionaryTableName = "contact"
Field Value
Type | Description |
---|---|
String |
Properties
ActiveErpLinks
Field 'activeErpLinks' in table 'contact': 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 'contact': Dictionary type UShort, .NET type: Int16
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 |
AssociateId
Field 'associate_id' in table 'contact': Dictionary type FK, .NET type: Int32
Our contact
Declaration
public Int32FieldInfo AssociateId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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> |
BusinessIdx
Field 'business_idx' in table 'contact': Dictionary type FK, .NET type: Int32
Link to Business
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 'contact': Dictionary type FK, .NET type: Int32
Link to Category
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 'contact': Dictionary type PK, .NET type: Int32
Primary key
Declaration
public Int32FieldInfo ContactId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
CountryId
Field 'country_id' in table 'contact': 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> |
DbiAgentId
Field 'dbi_agent_id' in table 'contact': 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 '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 |
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 |
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 |
Definition
Definition of the table as described in the deployed runtime dictionary
Declaration
public override SoTable Definition { get; }
Property Value
Type | Description |
---|---|
SoTable |
Overrides
Deleted
Field 'deleted' in table 'contact': Dictionary type UShort, .NET type: Int16
If nonzero, then this contact is 'deleted' and should generally not be shown
Declaration
public UInt16FieldInfo Deleted { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
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 |
Department
Field 'department' in table 'contact': Dictionary type String[220], .NET type: String
Department
Declaration
public StringFieldInfo Department { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
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 |
---|---|
Int32 |
GroupId
Field 'group_id' in table 'contact': Dictionary type FK, .NET type: Int32
Group id of original owning associate, semantics like appnt.grp_id
Declaration
public Int32FieldInfo GroupId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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> |
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 |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
MotherId
Field 'mother_id' in table 'contact': Dictionary type FK, .NET type: Int32
Reserved
Declaration
public Int32FieldInfo MotherId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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> |
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 |
Nomailing
Field 'nomailing' in table 'contact': Dictionary type Bool, .NET type: Int16
No mailings flags
Declaration
public UInt16FieldInfo Nomailing { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
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 |
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 |
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 |
Registered
Field 'registered' in table 'contact': Dictionary type UtcDateTime, .NET type: DateTime
Date registered
Declaration
public DateTimeFieldInfo Registered { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
RegisteredAssociateId
Field 'registered_associate_id' in table 'contact': 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> |
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 |
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 |
Source
Field 'source' in table 'contact': Dictionary type UShort, .NET type: Int16
How did we get this contact? For future integration needs
Declaration
public UInt16FieldInfo Source { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
SupportAssociateId
Field 'supportAssociateId' in table 'contact': 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 'contact': 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> |
SupportPersonId
Field 'supportPersonId' in table 'contact': Dictionary type FK, .NET type: Int32
The person (at the customer) who support talks to (the counterpart of supportAssociateId)
Declaration
public Int32FieldInfo SupportPersonId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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> |
TextId
Field 'text_id' in table 'contact': Dictionary type FK, .NET type: Int32
Paperclip note
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 'contact': 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> |
TzLocationId
Field 'tzLocationId' in table 'contact': Dictionary type FK, .NET type: Int32
Default timezone location for this contact
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 'contact': Dictionary type UtcDateTime, .NET type: DateTime
Date last updated
Declaration
public DateTimeFieldInfo Updated { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
UpdatedAssociateId
Field 'updated_associate_id' in table 'contact': 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 'contact': Dictionary type UShort, .NET type: Int16
Number of times updated
Declaration
public UInt16FieldInfo UpdatedCount { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Userdef2Id
Field 'userdef2_id' in table 'contact': Dictionary type FK, .NET type: Int32
User defined table record 2
Declaration
public Int32FieldInfo Userdef2Id { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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> |
UserdefId
Field 'userdef_id' in table 'contact': Dictionary type FK, .NET type: Int32
User defined table record 1
Declaration
public Int32FieldInfo UserdefId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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> |
Xstop
Field 'xstop' in table 'contact': Dictionary type Bool, .NET type: Int16
STOP flag
Declaration
public UInt16FieldInfo Xstop { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
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 |