Class CustLangTableInfo

Table 'cust_lang': This table contains entries for customer languages.

Inheritance
Object
TableInfo
CustLangTableInfo
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("cust_lang")]
public class CustLangTableInfo : 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 CustLang in the database dictionary: cust_lang

Declaration
public const string DictionaryTableName = "cust_lang"
Field Value
Type Description
String

Properties

CustLangId

Field 'id' in table 'cust_lang': Dictionary type PK, .NET type: Int32

The primary key (auto-incremented)

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

Definition

Definition of the table as described in the deployed runtime dictionary

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

DictionaryTableNumber

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

EmailDomains

Field 'email_domains' in table 'cust_lang': Dictionary type String[256], .NET type: String

Commaseparated list of toplevel domains from where an email should originate in order to trigger this language.

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

EmailHeader

Field 'email_header' in table 'cust_lang': Dictionary type String[256], .NET type: String

The email header line for this language ('Please keep the subject in any replies...').

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

IsDefault

Field 'is_default' in table 'cust_lang': Dictionary type Bool, .NET type: Int16

Bool indicating whether this language is the default (fallback) language.

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

IsoCode

Field 'iso_code' in table 'cust_lang': Dictionary type String[64], .NET type: String

A two letter iso code for this customer language

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

KbRoot

Field 'kb_root' in table 'cust_lang': Dictionary type FK, .NET type: Int32

The reference to the FAQ category which is the root category for this language (for separating the FAQ per language).

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

KbRoot_InnerJoin_KbCategory

Generated join from the foreign key KbRoot in this table, to its target table KbCategoryTableInfo.

Declaration
public TargetedInnerJoin<KbCategoryTableInfo> KbRoot_InnerJoin_KbCategory { get; }
Property Value
Type Description
TargetedInnerJoin<KbCategoryTableInfo>

LangCode

Field 'lang_code' in table 'cust_lang': Dictionary type String[6], .NET type: String

A short code for this language ('no', 'dk', etc). Used in pathname to templates.

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

LeftOuterJoin_ChatTopic_LanguageId

Generated left outer join from the primary key CustLangId on this table, to ChatTopic.LanguageId.

Declaration
public TargetedLeftOuterJoin<ChatTopicTableInfo> LeftOuterJoin_ChatTopic_LanguageId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ChatTopicTableInfo>

LeftOuterJoin_Contact_SupportLanguageId

Generated left outer join from the primary key CustLangId on this table, to Contact.SupportLanguageId.

Declaration
public TargetedLeftOuterJoin<ContactTableInfo> LeftOuterJoin_Contact_SupportLanguageId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ContactTableInfo>

LeftOuterJoin_CustCategory_LanguageId

Generated left outer join from the primary key CustLangId on this table, to CustCategory.LanguageId.

Declaration
public TargetedLeftOuterJoin<CustCategoryTableInfo> LeftOuterJoin_CustCategory_LanguageId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<CustCategoryTableInfo>

LeftOuterJoin_CustConfig_CustLangId

Generated left outer join from the primary key CustLangId on this table, to CustConfig.CustLangId.

Declaration
public TargetedLeftOuterJoin<CustConfigTableInfo> LeftOuterJoin_CustConfig_CustLangId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<CustConfigTableInfo>

LeftOuterJoin_MailInFilter_LanguageId

Generated left outer join from the primary key CustLangId on this table, to MailInFilter.LanguageId.

Declaration
public TargetedLeftOuterJoin<MailInFilterTableInfo> LeftOuterJoin_MailInFilter_LanguageId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<MailInFilterTableInfo>

LeftOuterJoin_Person_SupportLanguageId

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

Declaration
public TargetedLeftOuterJoin<PersonTableInfo> LeftOuterJoin_Person_SupportLanguageId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<PersonTableInfo>

LeftOuterJoin_ReplyTemplateBody_LanguageId

Generated left outer join from the primary key CustLangId on this table, to ReplyTemplateBody.LanguageId.

Declaration
public TargetedLeftOuterJoin<ReplyTemplateBodyTableInfo> LeftOuterJoin_ReplyTemplateBody_LanguageId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ReplyTemplateBodyTableInfo>

Name

Field 'name' in table 'cust_lang': Dictionary type String[256], .NET type: String

The name/alias for this language.

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

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

VirtualDomain

Field 'virtual_domain' in table 'cust_lang': Dictionary type String[256], .NET type: String

The virtual domain which should trigger this language (e.g. 'support.company.dk' vs. 'support.company.uk')

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

WebDomains

Field 'web_domains' in table 'cust_lang': Dictionary type String[256], .NET type: String

The domains from where the user should originate (when surfing) in order to trigger this language. Commaseparated list.

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

Implements

Extension Methods

EnumUtil.MapEnums<From, To>(From)