Class DBC.ExtTableFields

Fields for ExtTable, This table contains entries used for mapping an external table to an internal table (customer or cust_company) for database integration.

Inheritance
Object
DBC.ExtTableFields
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
public static class ExtTableFields

Fields

ChildTable

ExtTable.ChildTable: The reference to the child table.

Declaration
public const string ChildTable = "child_table"
Field Value
Type Description
String

ExtDatasource

ExtTable.ExtDatasource: The reference to the associated datasource.

Declaration
public const string ExtDatasource = "ext_datasource"
Field Value
Type Description
String

ExtTableId

ExtTable.ExtTableId: The primary key (auto-incremented)

Declaration
public const string ExtTableId = "id"
Field Value
Type Description
String

LdapSearchBase2

ExtTable.LdapSearchBase2: LDAP search base, multiple search bases are seperated by new line

Declaration
public const string LdapSearchBase2 = "ldap_search_base2"
Field Value
Type Description
String

LdapSearchFilter

ExtTable.LdapSearchFilter: LDAP search query

Declaration
public const string LdapSearchFilter = "ldap_search_filter"
Field Value
Type Description
String

LdapSearchResult

ExtTable.LdapSearchResult: Select which data to return from LDAP

Declaration
public const string LdapSearchResult = "ldap_search_result"
Field Value
Type Description
String

Name

ExtTable.Name: The name for this field

Declaration
public const string Name = "name"
Field Value
Type Description
String

ParentTable

ExtTable.ParentTable: The reference to the parent table.

Declaration
public const string ParentTable = "parent_table"
Field Value
Type Description
String

PrimaryKey

ExtTable.PrimaryKey: The name of the primary key. TODO: depreciated?

Declaration
public const string PrimaryKey = "primary_key"
Field Value
Type Description
String

Priority

ExtTable.Priority: TODO: depreciated?

Declaration
public const string Priority = "priority"
Field Value
Type Description
String

SqlLimit

ExtTable.SqlLimit: Used for LIMIT optimiziation of the search query

Declaration
public const string SqlLimit = "sql_limit"
Field Value
Type Description
String

SqlQuery

ExtTable.SqlQuery: The SQL query used for fetching the external data.

Declaration
public const string SqlQuery = "sql_query"
Field Value
Type Description
String

SqlQuery2

ExtTable.SqlQuery2: The SQL query used for fetching the external data. Part 2

Declaration
public const string SqlQuery2 = "sql_query2"
Field Value
Type Description
String

Target

ExtTable.Target: Enum indicating the target table (customer or cust_company).

Declaration
public const string Target = "target"
Field Value
Type Description
String