Show / Hide Table of Contents

Class UDefFieldTableInfo

Table 'UDefField': Definition table for user-defined fields; one row in this table corresponds to one generation of one field. The user defined fields that are in use, and earlier versions of user defined fields. ColumnId refers to the field type; see UDXXXSmall or UDXXXLarge for the referring ID. Preferences prefsection='System', prefkey='CurrentUdefVersioncontact' (or CurrentUdefVersionperson, project, sale), gives you the current version of user defined fields. prefkey='AdminUdefVersion<...>' gives you the current version that's being edited. If Current version = admin version, no editing has been done since the last Publish of user defined field was performed.

Inheritance
object
TableInfo
UDefFieldTableInfo
Implements
ICloneable
Inherited Members
TableInfo.ToString()
TableInfo.RegisterFields(params 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.this[string]
TableInfo.PrimaryKeyField
object.Equals(object)
object.Equals(object, object)
object.ReferenceEquals(object, object)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("UDefField")]
public class UDefFieldTableInfo : 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.GetUDefFieldInfo().

Fields

DictionaryTableName

Conceptual name of table UDefField in the database dictionary: UDefField

Declaration
public const string DictionaryTableName = "UDefField"
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.GetUDefFieldInfo().

Properties

ColumnId

Field 'columnId' in table 'UDefField': Dictionary type FieldId, .NET type: int

The ID of the database column this field corresponds to
Declaration
public Int32FieldInfo ColumnId { 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.GetUDefFieldInfo().

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
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.GetUDefFieldInfo().

DictionaryTableNumber

Table number for table UDefField 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.GetUDefFieldInfo().

FieldDefault

Field 'fieldDefault' in table 'UDefField': Dictionary type String[255], .NET type: string

Optional default value for String fields
Declaration
public StringFieldInfo FieldDefault { 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.GetUDefFieldInfo().

FieldHeight

Field 'fieldHeight' in table 'UDefField': Dictionary type UShort, .NET type: short

field height in pixels, 0 = 'enough' (from font)
Declaration
public UInt16FieldInfo FieldHeight { get; }
Property Value
Type Description
UInt16FieldInfo
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.GetUDefFieldInfo().

FieldLabel

Field 'fieldLabel' in table 'UDefField': Dictionary type String[255], .NET type: string

The label (lead text)
Declaration
public StringFieldInfo FieldLabel { 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.GetUDefFieldInfo().

FieldLeft

Field 'fieldLeft' in table 'UDefField': Dictionary type UShort, .NET type: short

X pixel coordinate of field
Declaration
public UInt16FieldInfo FieldLeft { get; }
Property Value
Type Description
UInt16FieldInfo
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.GetUDefFieldInfo().

FieldTop

Field 'fieldTop' in table 'UDefField': Dictionary type UShort, .NET type: short

Y pixel coordinate of field
Declaration
public UInt16FieldInfo FieldTop { get; }
Property Value
Type Description
UInt16FieldInfo
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.GetUDefFieldInfo().

FieldType

Field 'fieldType' in table 'UDefField': Dictionary type UShort, .NET type: short

Field type: 0 = leadtext only, 1 = Edit, 2 = CheckBox, 3 = dropdown, 4 = listbox
Declaration
public UInt16FieldInfo FieldType { get; }
Property Value
Type Description
UInt16FieldInfo
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.GetUDefFieldInfo().

FieldWidth

Field 'fieldWidth' in table 'UDefField': Dictionary type UShort, .NET type: short

field width in pixels, 0 = 'enough' (from font)
Declaration
public UInt16FieldInfo FieldWidth { get; }
Property Value
Type Description
UInt16FieldInfo
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.GetUDefFieldInfo().

FormatMask

Field 'formatMask' in table 'UDefField': Dictionary type String[255], .NET type: string

Formatting mask, can be whatever the controls understand (currently nothing :-))
Declaration
public StringFieldInfo FormatMask { 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.GetUDefFieldInfo().

HideLabel

Field 'hideLabel' in table 'UDefField': Dictionary type Bool, .NET type: short

Hide the label if 1
Declaration
public UInt16FieldInfo HideLabel { get; }
Property Value
Type Description
UInt16FieldInfo
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.GetUDefFieldInfo().

Indexed

Field 'indexed' in table 'UDefField': Dictionary type Bool, .NET type: short

Is this field indexed? 0 if no, index no. if yes
Declaration
public UInt16FieldInfo Indexed { get; }
Property Value
Type Description
UInt16FieldInfo
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.GetUDefFieldInfo().

Justification

Field 'justification' in table 'UDefField': Dictionary type Enum, .NET type: UdefJustification

Justification - 0 = default, left, right, center
Declaration
public UdefJustificationFieldInfo Justification { get; }
Property Value
Type Description
UdefJustificationFieldInfo
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.GetUDefFieldInfo().

LabelHeight

Field 'labelHeight' in table 'UDefField': Dictionary type UShort, .NET type: short

label height in pixels, 0 = 'enough' (from font)
Declaration
public UInt16FieldInfo LabelHeight { get; }
Property Value
Type Description
UInt16FieldInfo
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.GetUDefFieldInfo().

LabelLeft

Field 'labelLeft' in table 'UDefField': Dictionary type UShort, .NET type: short

X pixel coordinate of label
Declaration
public UInt16FieldInfo LabelLeft { get; }
Property Value
Type Description
UInt16FieldInfo
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.GetUDefFieldInfo().

LabelTop

Field 'labelTop' in table 'UDefField': Dictionary type UShort, .NET type: short

Y pixel coordinate of label
Declaration
public UInt16FieldInfo LabelTop { get; }
Property Value
Type Description
UInt16FieldInfo
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.GetUDefFieldInfo().

LabelWidth

Field 'labelWidth' in table 'UDefField': Dictionary type UShort, .NET type: short

label width in pixels, 0 = 'enough' (from font)
Declaration
public UInt16FieldInfo LabelWidth { get; }
Property Value
Type Description
UInt16FieldInfo
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.GetUDefFieldInfo().

LastVersionId

Field 'lastVersionId' in table 'UDefField': Dictionary type FK, target: UDefField, .NET type: int

UDefFieldId this field had in the previous version, 0 = field is new in this version
Declaration
public Int32FieldInfo LastVersionId { 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.GetUDefFieldInfo().

LastVersionId_InnerJoin_UDefField

Generated join from the foreign key LastVersionId in this table, to its target table UDefFieldTableInfo.

Declaration
public TargetedInnerJoin<UDefFieldTableInfo> LastVersionId_InnerJoin_UDefField { get; }
Property Value
Type Description
TargetedInnerJoin<UDefFieldTableInfo>
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.GetUDefFieldInfo().

LeftOuterJoin_UDefFieldGL_UDefFieldId

Generated left outer join from the primary key UDefFieldId on this table, to UDefFieldGL.UDefFieldId.

Declaration
public TargetedLeftOuterJoin<UDefFieldGLTableInfo> LeftOuterJoin_UDefFieldGL_UDefFieldId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<UDefFieldGLTableInfo>
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.GetUDefFieldInfo().

ListTableId

Field 'listTableId' in table 'UDefField': Dictionary type TableNumber, .NET type: short

The table ID of the source table for lists: kTableAssoc, kTableContInt or whatever
Declaration
public UInt16FieldInfo ListTableId { get; }
Property Value
Type Description
UInt16FieldInfo
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.GetUDefFieldInfo().

Mandatory

Field 'mandatory' in table 'UDefField': Dictionary type Bool, .NET type: short

0 = no, 1 = yes (field must be filled out)
Declaration
public UInt16FieldInfo Mandatory { get; }
Property Value
Type Description
UInt16FieldInfo
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.GetUDefFieldInfo().

OwnerTableId

Field 'ownerTable_id' in table 'UDefField': Dictionary type UShort, .NET type: short

ID of owning table (contact, person, project) - this is not the actual tableNumber, rather it's an enum
Declaration
public UInt16FieldInfo OwnerTableId { get; }
Property Value
Type Description
UInt16FieldInfo
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.GetUDefFieldInfo().

Page1LineNo

Field 'page1LineNo' in table 'UDefField': Dictionary type UShort, .NET type: short

Line no on View Page 1, used if MDO flags are OFF. 0 = this field is not visible on page 1
Declaration
public UInt16FieldInfo Page1LineNo { get; }
Property Value
Type Description
UInt16FieldInfo
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.GetUDefFieldInfo().

ProgId

Field 'progId' in table 'UDefField': Dictionary type String[255], .NET type: string

Programmatic ID, for use by software that needs to find a particular field. Carried over like udefIdentity across generations. Use a Company.Product.Field format to avoid naming conflicts; the Company name SuperOffice is reserved.
Declaration
public StringFieldInfo ProgId { 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.GetUDefFieldInfo().

ReadOnly

Field 'readOnly' in table 'UDefField': Dictionary type UShort, .NET type: short

0 = read/write, 1 = readonly (don't combine with mandatory 8-) )
Declaration
public UInt16FieldInfo ReadOnly { get; }
Property Value
Type Description
UInt16FieldInfo
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.GetUDefFieldInfo().

Registered

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

Registered when
Declaration
public DateTimeFieldInfo Registered { get; }
Property Value
Type Description
DateTimeFieldInfo
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.GetUDefFieldInfo().

RegisteredAssociateId

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

Registered by whom
Declaration
public Int32FieldInfo RegisteredAssociateId { 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.GetUDefFieldInfo().

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>
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.GetUDefFieldInfo().

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.GetUDefFieldInfo().

ShortLabel

Field 'shortLabel' in table 'UDefField': Dictionary type String[255], .NET type: string

Short name to be used in Archive headings and on page 1. If blank, the fieldLabel will be used everywhere.
Declaration
public StringFieldInfo ShortLabel { 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.GetUDefFieldInfo().

TabOrder

Field 'tabOrder' in table 'UDefField': Dictionary type UShort, .NET type: short

Tab order value, sets the field processing sequence
Declaration
public UInt16FieldInfo TabOrder { get; }
Property Value
Type Description
UInt16FieldInfo
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.GetUDefFieldInfo().

TextLength

Field 'textLength' in table 'UDefField': Dictionary type UShort, .NET type: short

Length (in characters) of a text field, 0 for other types
Declaration
public UInt16FieldInfo TextLength { get; }
Property Value
Type Description
UInt16FieldInfo
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.GetUDefFieldInfo().

Tooltip

Field 'tooltip' in table 'UDefField': Dictionary type String[255], .NET type: string

Optional tooltip text for this field
Declaration
public StringFieldInfo Tooltip { 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.GetUDefFieldInfo().

UDListDefinitionId

Field 'UDListDefinition_id' in table 'UDefField': Dictionary type FK, target: UDListDefinition, .NET type: int

List to use for populating dropdown or listbox
Declaration
public Int32FieldInfo UDListDefinitionId { 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.GetUDefFieldInfo().

UDListDefinitionId_InnerJoin_UDListDefinition

Generated join from the foreign key UDListDefinitionId in this table, to its target table UDListDefinitionTableInfo.

Declaration
public TargetedInnerJoin<UDListDefinitionTableInfo> UDListDefinitionId_InnerJoin_UDListDefinition { get; }
Property Value
Type Description
TargetedInnerJoin<UDListDefinitionTableInfo>
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.GetUDefFieldInfo().

UDefFieldId

Field 'UDefField_Id' in table 'UDefField': Dictionary type PK, .NET type: int

Primary key
Declaration
public Int32FieldInfo UDefFieldId { 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.GetUDefFieldInfo().

UdefIdentity

Field 'udefIdentity' in table 'UDefField': Dictionary type Id, .NET type: int

Unique number used to track field identity across layout changes
Declaration
public Int32FieldInfo UdefIdentity { 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.GetUDefFieldInfo().

Updated

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

Last updated when
Declaration
public DateTimeFieldInfo Updated { get; }
Property Value
Type Description
DateTimeFieldInfo
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.GetUDefFieldInfo().

UpdatedAssociateId

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

Last updated by whom
Declaration
public Int32FieldInfo UpdatedAssociateId { 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.GetUDefFieldInfo().

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>
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.GetUDefFieldInfo().

UpdatedCount

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

Number of updates made to this record
Declaration
public UInt16FieldInfo UpdatedCount { get; }
Property Value
Type Description
UInt16FieldInfo
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.GetUDefFieldInfo().

Version

Field 'version' in table 'UDefField': Dictionary type UShort, .NET type: short

Definition version number; ALL fields get new version whenever layout is updated.
Declaration
public UInt16FieldInfo Version { get; }
Property Value
Type Description
UInt16FieldInfo
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.GetUDefFieldInfo().

Implements

ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)
Converters.MapEnums<From, To>(From)
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top