Class ErpSyncLogTableInfo

Table 'ErpSyncLog': Record all field changes done by the Erp Sync

Inheritance
object
TableInfo
ErpSyncLogTableInfo
Implements
Inherited Members
Namespace: SuperOfficeCRMData
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("ErpSyncLog")]
public class ErpSyncLogTableInfo : 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.GetErpSyncLogInfo().

Fields

DictionaryTableName

Conceptual name of table ErpSyncLog in the database dictionary: ErpSyncLog

Declaration
public const string DictionaryTableName = "ErpSyncLog"
Field Value
Type Description
string

Properties

CrmFieldKey

Field 'CrmFieldKey' in table 'ErpSyncLog': Dictionary type String[255], .NET type: string

CRM field name/key

Declaration
public StringFieldInfo CrmFieldKey { get; }
Property Value
Type Description
StringFieldInfo

Definition

Definition of the table as described in the deployed runtime dictionary

Declaration
public override SoTable Definition { get; }
Property Value
Type Description
SoTable
Overrides

DictionaryTableNumber

Table number for table ErpSyncLog 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

ErpExternalKeyId

Field 'ErpExternalKeyId' in table 'ErpSyncLog': Dictionary type FK, target: ErpExternalKey, .NET type: int

Link to the external key, indirectly also to the connection and internal key

Declaration
public Int32FieldInfo ErpExternalKeyId { get; }
Property Value
Type Description
Int32FieldInfo

ErpExternalKeyId_InnerJoin_ErpExternalKey

Generated join from the foreign key ErpExternalKeyId in this table, to its target table ErpExternalKeyTableInfo.

Declaration
public TargetedInnerJoin<ErpExternalKeyTableInfo> ErpExternalKeyId_InnerJoin_ErpExternalKey { get; }
Property Value
Type Description
TargetedInnerJoinErpExternalKeyTableInfo

ErpFieldKey

Field 'ErpFieldKey' in table 'ErpSyncLog': Dictionary type String[255], .NET type: string

ERP field name/key

Declaration
public StringFieldInfo ErpFieldKey { get; }
Property Value
Type Description
StringFieldInfo

ErpSyncLogId

Field 'erpsynclog_id' in table 'ErpSyncLog': Dictionary type PK, .NET type: int

Primary key

Declaration
public Int32FieldInfo ErpSyncLogId { get; }
Property Value
Type Description
Int32FieldInfo

NewValue

Field 'NewValue' in table 'ErpSyncLog': Dictionary type String[255], .NET type: string

The new value of the target field

Declaration
public StringFieldInfo NewValue { get; }
Property Value
Type Description
StringFieldInfo

OldValue

Field 'OldValue' in table 'ErpSyncLog': Dictionary type String[255], .NET type: string

The old value of the target field

Declaration
public StringFieldInfo OldValue { get; }
Property Value
Type Description
StringFieldInfo

Registered

Field 'registered' in table 'ErpSyncLog': Dictionary type UtcDateTime, .NET type: DateTime

Registered when

Declaration
public DateTimeFieldInfo Registered { get; }
Property Value
Type Description
DateTimeFieldInfo

RegisteredAssociateId

Field 'registered_associate_id' in table 'ErpSyncLog': Dictionary type FK, target: Associate, .NET type: int

Registered by whom

Declaration
public Int32FieldInfo RegisteredAssociateId { get; }
Property Value
Type Description
Int32FieldInfo

RegisteredAssociateId_InnerJoin_Associate

Generated join from the foreign key RegisteredAssociateId in this table, to its target table AssociateTableInfo.

Declaration
public TargetedInnerJoin<AssociateTableInfo> RegisteredAssociateId_InnerJoin_Associate { get; }
Property Value
Type Description
TargetedInnerJoinAssociateTableInfo

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

TargetIsCrm

Field 'TargetIsCrm' in table 'ErpSyncLog': Dictionary type Bool, .NET type: short

Was the CRM field the target of the change? If false, then it was the ERP field that was changed by this sync operation

Declaration
public UInt16FieldInfo TargetIsCrm { get; }
Property Value
Type Description
UInt16FieldInfo

Updated

Field 'updated' in table 'ErpSyncLog': Dictionary type UtcDateTime, .NET type: DateTime

Last updated when

Declaration
public DateTimeFieldInfo Updated { get; }
Property Value
Type Description
DateTimeFieldInfo

UpdatedAssociateId

Field 'updated_associate_id' in table 'ErpSyncLog': Dictionary type FK, target: Associate, .NET type: int

Last updated by whom

Declaration
public Int32FieldInfo UpdatedAssociateId { get; }
Property Value
Type Description
Int32FieldInfo

UpdatedAssociateId_InnerJoin_Associate

Generated join from the foreign key UpdatedAssociateId in this table, to its target table AssociateTableInfo.

Declaration
public TargetedInnerJoin<AssociateTableInfo> UpdatedAssociateId_InnerJoin_Associate { get; }
Property Value
Type Description
TargetedInnerJoinAssociateTableInfo

UpdatedCount

Field 'updatedCount' in table 'ErpSyncLog': Dictionary type UShort, .NET type: short

Number of updates made to this record

Declaration
public UInt16FieldInfo UpdatedCount { get; }
Property Value
Type Description
UInt16FieldInfo

Implements

Extension Methods