Class ErpFieldTableInfo

Table 'ErpField': Store the metadata describing the fields that belong to an actor/connection combination, as described by the Erp Connector

Inheritance

System.Object

TableInfo

ErpFieldTableInfo

Implements

System.ICloneable

Inherited Members

TableInfo.ToString()

TableInfo.RegisterFields(FieldInfo[])

TableInfo.FieldInfoFromSoField(SoField)

TableInfo.Clone()

TableInfo.IsSameTable(TableInfo)

TableInfo.FindField(String)

TableInfo.ProtAll

TableInfo.HashCheckFields

TableInfo.TableName

TableInfo.DbName

TableInfo.IsDictionaryTable

TableInfo.All

TableInfo.Item[String]

TableInfo.PrimaryKeyField

Namespace: SuperOffice.CRM.Data

Assembly: SoDataBase.dll

Syntax

[DatabaseTable("ErpField")]
public class ErpFieldTableInfo : 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 .

Fields

DictionaryTableName

Conceptual name of table ErpField in the database dictionary: ErpField

Declaration

public const string DictionaryTableName = "ErpField"

Field Value

Type	Description
System.String

Properties

Access

Field 'Access' in table 'ErpField': Dictionary type Enum, .NET type: FieldAccess

Access restrictions for the field

Declaration

public FieldAccessFieldInfo Access { get; }

Property Value

Type	Description
FieldAccessFieldInfo

CrmFieldKey

Field 'CrmFieldKey' in table 'ErpField': Dictionary type String[255], .NET type: System.String

The CRM field name, as implemented by the Sync entities

Declaration

public StringFieldInfo CrmFieldKey { get; }

Property Value

Type	Description
StringFieldInfo

DefaultValue

Field 'DefaultValue' in table 'ErpField': Dictionary type String[255], .NET type: System.String

Default value, stored using CultureDataFormatter format if it is not a string

Declaration

public StringFieldInfo DefaultValue { 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

TableInfo.Definition

DictionaryTableNumber

Table number for table ErpField 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
System.Int32

DisplayDescription

Field 'DisplayDescription' in table 'ErpField': Dictionary type String[255], .NET type: System.String

Tooltip for the field name.

Declaration

public StringFieldInfo DisplayDescription { get; }

Property Value

Type	Description
StringFieldInfo

DisplayName

Field 'DisplayName' in table 'ErpField': Dictionary type String[255], .NET type: System.String

Localized field name – shown in the GUI as the label for the control.

Declaration

public StringFieldInfo DisplayName { get; }

Property Value

Type	Description
StringFieldInfo

ErpConnectionActorTypeId

Field 'ErpConnectionActorTypeId' in table 'ErpField': Dictionary type FK, target: ErpConnectionActorType, .NET type: System.Int32

Link to Erp Connection/Actor type

Declaration

public Int32FieldInfo ErpConnectionActorTypeId { get; }

Property Value

Type	Description
Int32FieldInfo

ErpConnectionActorTypeId_InnerJoin_ErpConnectionActorType

Generated join from the foreign key ErpConnectionActorTypeId in this table, to its target table ErpConnectionActorTypeTableInfo.

Declaration

public TargetedInnerJoin<ErpConnectionActorTypeTableInfo> ErpConnectionActorTypeId_InnerJoin_ErpConnectionActorType { get; }

Property Value

Type	Description
TargetedInnerJoin<ErpConnectionActorTypeTableInfo>

ErpFieldId

Field 'erpfield_id' in table 'ErpField': Dictionary type PK, .NET type: System.Int32

Primary key

Declaration

public Int32FieldInfo ErpFieldId { get; }

Property Value

Type	Description
Int32FieldInfo

ErpFieldKey

Field 'ErpFieldKey' in table 'ErpField': Dictionary type String[255], .NET type: System.String

The ERP field key

Declaration

public StringFieldInfo ErpFieldKey { get; }

Property Value

Type	Description
StringFieldInfo

FieldType

Field 'FieldType' in table 'ErpField': Dictionary type Enum, .NET type: FieldMetadataType

Field type

Declaration

public FieldMetadataTypeFieldInfo FieldType { get; }

Property Value

Type	Description
FieldMetadataTypeFieldInfo

FirstSyncDefaultValue

Field 'FirstSyncDefaultValue' in table 'ErpField': Dictionary type String[255], .NET type: System.String

The default value to be set, can be blank

Declaration

public StringFieldInfo FirstSyncDefaultValue { get; }

Property Value

Type	Description
StringFieldInfo

HasFirstSyncDefaultValue

Field 'HasFirstSyncDefaultValue' in table 'ErpField': Dictionary type Bool, .NET type: System.Int16

Should a default value be set on first sync

Declaration

public UInt16FieldInfo HasFirstSyncDefaultValue { get; }

Property Value

Type	Description
UInt16FieldInfo

LeftOuterJoin_ErpListItemMapping_ErpFieldId

Generated left outer join from the primary key ErpFieldId on this table, to ErpListItemMapping.ErpFieldId.

Declaration

public TargetedLeftOuterJoin<ErpListItemMappingTableInfo> LeftOuterJoin_ErpListItemMapping_ErpFieldId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<ErpListItemMappingTableInfo>

ListName

Field 'ListName' in table 'ErpField': Dictionary type String[255], .NET type: System.String

The ERP list name, if the field has a list of values supplied by the ERP Connector

Declaration

public StringFieldInfo ListName { get; }

Property Value

Type	Description
StringFieldInfo

ListReference

Field 'ListReference' in table 'ErpField': Dictionary type String[255], .NET type: System.String

Reference to CRM list, if a mapping exists. Format: table=<table name>[&<extra id>=<value>], to make it independent of actual table numbers

Declaration

public StringFieldInfo ListReference { get; }

Property Value

Type	Description
StringFieldInfo

Mandatory

Field 'Mandatory' in table 'ErpField': Dictionary type Bool, .NET type: System.Int16

Should the user be forced to set a value (the Erp Connector may declare fields mandatory as well)

Declaration

public UInt16FieldInfo Mandatory { get; }

Property Value

Type	Description
UInt16FieldInfo

MaxLength

Field 'MaxLength' in table 'ErpField': Dictionary type Int, .NET type: System.Int32

Maximum size of the field, if there is a limit

Declaration

public Int32FieldInfo MaxLength { get; }

Property Value

Type	Description
Int32FieldInfo

MissingInERP

Field 'MissingInERP' in table 'ErpField': Dictionary type Bool, .NET type: System.Int16

Set to true if this field has previously been defined, but was no longer in the 'supported fields' response from the connector. This typically happens if the target ERP system changes, and means the field needs to be unmapped.

Declaration

public UInt16FieldInfo MissingInERP { get; }

Property Value

Type	Description
UInt16FieldInfo

PromptUser

Field 'PromptUser' in table 'ErpField': Dictionary type Bool, .NET type: System.Int16

Should the field be shown in the first-sync GUI; independent of whether a default value should be set

Declaration

public UInt16FieldInfo PromptUser { get; }

Property Value

Type	Description
UInt16FieldInfo

Rank

Field 'Rank' in table 'ErpField': Dictionary type Int, .NET type: System.Int32

Rank order of lines in GUI, relevant if ShowInGui is true

Declaration

public Int32FieldInfo Rank { get; }

Property Value

Type	Description
Int32FieldInfo

Registered

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

Registered when

Declaration

public DateTimeFieldInfo Registered { get; }

Property Value

Type	Description
DateTimeFieldInfo

RegisteredAssociateId

Field 'registered_associate_id' in table 'ErpField': Dictionary type FK, target: Associate, .NET type: System.Int32

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
TargetedInnerJoin<AssociateTableInfo>

RuntimeDefinition

Definition of the table as described in the deployed runtime dictionary

Declaration

public static SoTable RuntimeDefinition { get; }

Property Value

Type	Description
SoTable

ShowInGui

Field 'ShowInGui' in table 'ErpField': Dictionary type Bool, .NET type: System.Int16

Should this field be shown as a (read-only!) field in the CRM Gui

Declaration

public UInt16FieldInfo ShowInGui { get; }

Property Value

Type	Description
UInt16FieldInfo

ShowInSearch

Field 'ShowInSearch' in table 'ErpField': Dictionary type Bool, .NET type: System.Int16

Should this field be shown in searches

Declaration

public UInt16FieldInfo ShowInSearch { get; }

Property Value

Type	Description
UInt16FieldInfo

SyncToCrm

Field 'SyncToCrm' in table 'ErpField': Dictionary type Bool, .NET type: System.Int16

Should value changes in ERP be automatically transferred to CRM

Declaration

public UInt16FieldInfo SyncToCrm { get; }

Property Value

Type	Description
UInt16FieldInfo

SyncToErp

Field 'SyncToErp' in table 'ErpField': Dictionary type Bool, .NET type: System.Int16

Should value changes in CRM be automatically transferred to ERP

Declaration

public UInt16FieldInfo SyncToErp { get; }

Property Value

Type	Description
UInt16FieldInfo

Updated

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

Last updated when

Declaration

public DateTimeFieldInfo Updated { get; }

Property Value

Type	Description
DateTimeFieldInfo

UpdatedAssociateId

Field 'updated_associate_id' in table 'ErpField': Dictionary type FK, target: Associate, .NET type: System.Int32

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
TargetedInnerJoin<AssociateTableInfo>

UpdatedCount

Field 'updatedCount' in table 'ErpField': Dictionary type UShort, .NET type: System.Int16

Number of updates made to this record

Declaration

public UInt16FieldInfo UpdatedCount { get; }

Property Value

Type	Description
UInt16FieldInfo

Methods

IdxErpConnectionActorTypeId(Int32)

Shortcut method for looking up using the database index ErpConnectionActorTypeId, which spans the following fields:

Field	Description
ErpConnectionActorTypeId	Link to Erp Connection/Actor type

Declaration

public Restriction IdxErpConnectionActorTypeId(int erpConnectionActorTypeId)

Parameters

Type	Name	Description
System.Int32	erpConnectionActorTypeId

Returns

Type	Description
Restriction

Implements

System.ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)