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 DBC.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