Class DbiAgentScheduleTableInfo
Table 'dbi_agent_schedule': DBI agent schedule settings
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("dbi_agent_schedule")]
public class DbiAgentScheduleTableInfo : 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 TablesInfo.GetDbiAgentScheduleInfo().
Fields
DictionaryTableName
Conceptual name of table DbiAgentSchedule in the database dictionary: dbi_agent_schedule
Declaration
public const string DictionaryTableName = "dbi_agent_schedule"
Field Value
Type | Description |
---|---|
string |
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 TablesInfo.GetDbiAgentScheduleInfo().
Properties
AgentId
Field 'agent_id' in table 'dbi_agent_schedule': Dictionary type FK, target: DbiAgent, .NET type: int
AgentDeclaration
public Int32FieldInfo AgentId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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 TablesInfo.GetDbiAgentScheduleInfo().
AgentId_InnerJoin_DbiAgent
Generated join from the foreign key AgentId in this table, to its target table DbiAgentTableInfo.
Declaration
public TargetedInnerJoin<DbiAgentTableInfo> AgentId_InnerJoin_DbiAgent { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<DbiAgentTableInfo> |
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 TablesInfo.GetDbiAgentScheduleInfo().
DbiAgentScheduleId
Field 'id' in table 'dbi_agent_schedule': Dictionary type PK, .NET type: int
Primary keyDeclaration
public Int32FieldInfo DbiAgentScheduleId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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 TablesInfo.GetDbiAgentScheduleInfo().
Definition
Definition of the table as described in the deployed runtime dictionary
Declaration
public override SoTable Definition { get; }
Property Value
Type | Description |
---|---|
SoTable |
Overrides
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 TablesInfo.GetDbiAgentScheduleInfo().
DictionaryTableNumber
Table number for table DbiAgentSchedule 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 |
---|---|
int |
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 TablesInfo.GetDbiAgentScheduleInfo().
IdString
Field 'id_string' in table 'dbi_agent_schedule': Dictionary type String[256], .NET type: string
A field for an id_string which may be used to access the agent scheduleDeclaration
public StringFieldInfo IdString { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
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 TablesInfo.GetDbiAgentScheduleInfo().
ReceivedObjects
Field 'received_objects' in table 'dbi_agent_schedule': Dictionary type Int, .NET type: int
Number of objects received during the last syncronizationDeclaration
public Int32FieldInfo ReceivedObjects { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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 TablesInfo.GetDbiAgentScheduleInfo().
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 |
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 TablesInfo.GetDbiAgentScheduleInfo().
ScheduleId
Field 'schedule_id' in table 'dbi_agent_schedule': Dictionary type FK, target: Schedule, .NET type: int
Update scheduleDeclaration
public Int32FieldInfo ScheduleId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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 TablesInfo.GetDbiAgentScheduleInfo().
ScheduleId_InnerJoin_Schedule
Generated join from the foreign key ScheduleId in this table, to its target table ScheduleTableInfo.
Declaration
public TargetedInnerJoin<ScheduleTableInfo> ScheduleId_InnerJoin_Schedule { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<ScheduleTableInfo> |
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 TablesInfo.GetDbiAgentScheduleInfo().
ScriptId
Field 'script_id' in table 'dbi_agent_schedule': Dictionary type FK, target: Ejscript, .NET type: int
Communication scriptDeclaration
public Int32FieldInfo ScriptId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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 TablesInfo.GetDbiAgentScheduleInfo().
ScriptId_InnerJoin_Ejscript
Generated join from the foreign key ScriptId in this table, to its target table EjscriptTableInfo.
Declaration
public TargetedInnerJoin<EjscriptTableInfo> ScriptId_InnerJoin_Ejscript { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<EjscriptTableInfo> |
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 TablesInfo.GetDbiAgentScheduleInfo().
SentObjects
Field 'sent_objects' in table 'dbi_agent_schedule': Dictionary type Int, .NET type: int
Number of objects sent during the last syncronizationDeclaration
public Int32FieldInfo SentObjects { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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 TablesInfo.GetDbiAgentScheduleInfo().