Class DBC.ExtDatasourceFields

Fields for ExtDatasource, This table contains external datasources, used for databaseintegration of customers and companies.

Inheritance

Object

DBC.ExtDatasourceFields

Namespace: SuperOffice.CRM.Data

Assembly: SoDataBase.dll

Syntax

public static class ExtDatasourceFields : Object

Fields

DatabaseType

ExtDatasource.DatabaseType: The database type (DbType).

Declaration

public const string DatabaseType = "database_type"

Field Value

Type	Description
String

Datatype

ExtDatasource.Datatype: An enum indicating the type/protocol for this datasource.

Declaration

public const string Datatype = "datatype"

Field Value

Type	Description
String

Dbname

ExtDatasource.Dbname: The name used for accessing the datasource.

Declaration

public const string Dbname = "dbname"

Field Value

Type	Description
String

ExtDatasourceId

ExtDatasource.ExtDatasourceId: The primary key (auto-incremented)

Declaration

public const string ExtDatasourceId = "id"

Field Value

Type	Description
String

Flags

ExtDatasource.Flags: Bitmask of flags.

Declaration

public const string Flags = "flags"

Field Value

Type	Description
String

Hostname

ExtDatasource.Hostname: The hostname for accessing the datasource.

Declaration

public const string Hostname = "hostname"

Field Value

Type	Description
String

LastAccess

ExtDatasource.LastAccess: The last time this datasource was accessed.

Declaration

public const string LastAccess = "last_access"

Field Value

Type	Description
String

LastUpdate

ExtDatasource.LastUpdate: When did the last update occur?.

Declaration

public const string LastUpdate = "last_update"

Field Value

Type	Description
String

Name

ExtDatasource.Name: An alias for this datasource.

Declaration

public const string Name = "name"

Field Value

Type	Description
String

NextUpdate

ExtDatasource.NextUpdate: Next time the update process starts

Declaration

public const string NextUpdate = "next_update"

Field Value

Type	Description
String

Password

ExtDatasource.Password: The poassword used for authenticating against the datasource.

Declaration

public const string Password = "password"

Field Value

Type	Description
String

Path

ExtDatasource.Path: Path to the datasource.

Declaration

public const string Path = "path"

Field Value

Type	Description
String

Port

ExtDatasource.Port: The port used for accessing the datasource.

Declaration

public const string Port = "port"

Field Value

Type	Description
String

SqlInit

ExtDatasource.SqlInit: The SQL init used for configure the server before fetching external data.

Declaration

public const string SqlInit = "sql_init"

Field Value

Type	Description
String

UnixSocket

ExtDatasource.UnixSocket: Unix socket used with Mysql connections on Linux

Declaration

public const string UnixSocket = "unix_socket"

Field Value

Type	Description
String

UpdateCompanyCount

ExtDatasource.UpdateCompanyCount: Number of companies updated so far

Declaration

public const string UpdateCompanyCount = "update_company_count"

Field Value

Type	Description
String

UpdateCompletionTime

ExtDatasource.UpdateCompletionTime: The last update completion time in minutes.

Declaration

public const string UpdateCompletionTime = "update_completion_time"

Field Value

Type	Description
String

UpdateCustomerCount

ExtDatasource.UpdateCustomerCount: Number of customers updated so far

Declaration

public const string UpdateCustomerCount = "update_customer_count"

Field Value

Type	Description
String

UpdateErrorMessage

ExtDatasource.UpdateErrorMessage: The last error message from datasource update.

Declaration

public const string UpdateErrorMessage = "update_error_message"

Field Value

Type	Description
String

UpdateInterval

ExtDatasource.UpdateInterval: Number of hours between each database update

Declaration

public const string UpdateInterval = "update_interval"

Field Value

Type	Description
String

UpdateLock

ExtDatasource.UpdateLock: Lock to make sure not 2 updates are done simultaniously

Declaration

public const string UpdateLock = "update_lock"

Field Value

Type	Description
String

Username

ExtDatasource.Username: The username used for authenticating against the datasource.

Declaration

public const string Username = "username"

Field Value

Type	Description
String