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

Namespace: SuperOffice.CRM.Data

Assembly: SoDataBase.dll

Syntax

public static class ExtTableFields : Object

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