Class AddressFormatTableInfo

Table 'AddressFormat': Address formats for GUI and labels. See more information: Addressformat on http://techdoc.superoffice.com

Inheritance

Object

TableInfo

AddressFormatTableInfo

Implements

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("AddressFormat")]
public class AddressFormatTableInfo : 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 AddressFormat in the database dictionary: AddressFormat

Declaration

public const string DictionaryTableName = "AddressFormat"

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 .

Properties

Address1Flags

Field 'address1_flags' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Field flags for address1 field: See EAddrFormatFlags enum

Declaration

public UInt16FieldInfo Address1Flags { 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 .

Address1Leadtext

Field 'address1_leadtext' in table 'AddressFormat': Dictionary type Id, .NET type: Int32

Lead text resource ID for address1 field, 0 = no leadtext

Declaration

public Int32FieldInfo Address1Leadtext { 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 .

Address1Length

Field 'address1_length' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Field length in characters for address1 field

Declaration

public UInt16FieldInfo Address1Length { 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 .

Address1Line

Field 'address1_line' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Line no. for address1 field, 0 if not shown

Declaration

public UInt16FieldInfo Address1Line { 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 .

Address1Mask

Field 'address1_mask' in table 'AddressFormat': Dictionary type String[10], .NET type: String

Formatting mask for address1 field

Declaration

public StringFieldInfo Address1Mask { 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 .

Address1Subpos

Field 'address1_subpos' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Position within line for address1 field

Declaration

public UInt16FieldInfo Address1Subpos { 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 .

Address1Zip

Field 'address1_zip' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Zip lookup functionality for address1 field: 0 = none, 1 = source, 2 = target

Declaration

public UInt16FieldInfo Address1Zip { 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 .

Address2Flags

Field 'address2_flags' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Field flags for address2 field: See EAddrFormatFlags enum

Declaration

public UInt16FieldInfo Address2Flags { 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 .

Address2Leadtext

Field 'address2_leadtext' in table 'AddressFormat': Dictionary type Id, .NET type: Int32

Lead text resource ID for address2 field, 0 = no leadtext

Declaration

public Int32FieldInfo Address2Leadtext { 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 .

Address2Length

Field 'address2_length' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Field length in characters for address2 field

Declaration

public UInt16FieldInfo Address2Length { 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 .

Address2Line

Field 'address2_line' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Line no. for address2 field, 0 if not shown

Declaration

public UInt16FieldInfo Address2Line { 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 .

Address2Mask

Field 'address2_mask' in table 'AddressFormat': Dictionary type String[10], .NET type: String

Formatting mask for address2 field

Declaration

public StringFieldInfo Address2Mask { 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 .

Address2Subpos

Field 'address2_subpos' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Position within line for address2 field

Declaration

public UInt16FieldInfo Address2Subpos { 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 .

Address2Zip

Field 'address2_zip' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Zip lookup functionality for address2 field: 0 = none, 1 = source, 2 = target

Declaration

public UInt16FieldInfo Address2Zip { 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 .

Address3Flags

Field 'address3_flags' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Field flags for address3 field: See EAddrFormatFlags enum

Declaration

public UInt16FieldInfo Address3Flags { 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 .

Address3Leadtext

Field 'address3_leadtext' in table 'AddressFormat': Dictionary type Id, .NET type: Int32

Lead text resource ID for address3 field, 0 = no leadtext

Declaration

public Int32FieldInfo Address3Leadtext { 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 .

Address3Length

Field 'address3_length' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Field length in characters for address3 field

Declaration

public UInt16FieldInfo Address3Length { 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 .

Address3Line

Field 'address3_line' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Line no. for address3 field, 0 if not shown

Declaration

public UInt16FieldInfo Address3Line { 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 .

Address3Mask

Field 'address3_mask' in table 'AddressFormat': Dictionary type String[10], .NET type: String

Formatting mask for address3 field

Declaration

public StringFieldInfo Address3Mask { 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 .

Address3Subpos

Field 'address3_subpos' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Position within line for address3 field

Declaration

public UInt16FieldInfo Address3Subpos { 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 .

Address3Zip

Field 'address3_zip' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Zip lookup functionality for address3 field: 0 = none, 1 = source, 2 = target

Declaration

public UInt16FieldInfo Address3Zip { 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 .

AddressformatId

Field 'addressformat_id' in table 'AddressFormat': Dictionary type PK, .NET type: Int32

Primary key

Declaration

public Int32FieldInfo AddressformatId { 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 .

AtypeIdx

Field 'atype_idx' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Corresponds to Address.atype_idx

Declaration

public UInt16FieldInfo AtypeIdx { 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 .

CityFlags

Field 'city_flags' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Field flags for city field: See EAddrFormatFlags enum

Declaration

public UInt16FieldInfo CityFlags { 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 .

CityLeadtext

Field 'city_leadtext' in table 'AddressFormat': Dictionary type Id, .NET type: Int32

Lead text resource ID for city field, 0 = no leadtext

Declaration

public Int32FieldInfo CityLeadtext { 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 .

CityLength

Field 'city_length' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Field length in characters for city field

Declaration

public UInt16FieldInfo CityLength { 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 .

CityLine

Field 'city_line' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Line no. for city field, 0 if not shown

Declaration

public UInt16FieldInfo CityLine { 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 .

CityMask

Field 'city_mask' in table 'AddressFormat': Dictionary type String[10], .NET type: String

Formatting mask for city field

Declaration

public StringFieldInfo CityMask { 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 .

CitySubpos

Field 'city_subpos' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Position within line for city field

Declaration

public UInt16FieldInfo CitySubpos { 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 .

CityZip

Field 'city_zip' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Zip lookup functionality for city field: 0 = none, 1 = source, 2 = target

Declaration

public UInt16FieldInfo CityZip { 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 .

CountyFlags

Field 'county_flags' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Field flags for county field: See EAddrFormatFlags enum

Declaration

public UInt16FieldInfo CountyFlags { 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 .

CountyLeadtext

Field 'county_leadtext' in table 'AddressFormat': Dictionary type Id, .NET type: Int32

Lead text resource ID for county field, 0 = no leadtext

Declaration

public Int32FieldInfo CountyLeadtext { 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 .

CountyLength

Field 'county_length' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Field length in characters for county field

Declaration

public UInt16FieldInfo CountyLength { 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 .

CountyLine

Field 'county_line' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Line no. for county field, 0 if not shown

Declaration

public UInt16FieldInfo CountyLine { 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 .

CountyMask

Field 'county_mask' in table 'AddressFormat': Dictionary type String[10], .NET type: String

Formatting mask for county field

Declaration

public StringFieldInfo CountyMask { 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 .

CountySubpos

Field 'county_subpos' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Position within line for county field

Declaration

public UInt16FieldInfo CountySubpos { 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 .

CountyZip

Field 'county_zip' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Zip lookup functionality for county field: 0 = none, 1 = source, 2 = target

Declaration

public UInt16FieldInfo CountyZip { 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 .

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 .

DictionaryTableNumber

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

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 .

ExtraFlags

Field 'extraFlags' in table 'AddressFormat': Dictionary type UInt, .NET type: UInt32

OBSOLETE: Extra flags for tag substitution mechanism, see idb.h. This function has been taken over by the tag-based formatting, controlled by the labelLayout and labelLayout2 fields

Declaration

public FieldInfo ExtraFlags { get; }

Property Value

Type	Description
FieldInfo

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 .

IsBuiltIn

Field 'isBuiltIn' in table 'AddressFormat': Dictionary type Bool, .NET type: Int16

Is this row populated by SuperOffice?

Declaration

public UInt16FieldInfo IsBuiltIn { 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 .

LabelLayout

Field 'labelLayout' in table 'AddressFormat': Dictionary type String[255], .NET type: String

Format specification for labels, uses standard tags

Declaration

public StringFieldInfo LabelLayout { 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 .

LabelLayout2

Field 'labelLayout2' in table 'AddressFormat': Dictionary type String[255], .NET type: String

Part two of format specification, concatenated with part one above

Declaration

public StringFieldInfo LabelLayout2 { 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 .

LayoutId

Field 'layout_id' in table 'AddressFormat': Dictionary type ShortId, .NET type: Int16

Corresponds to Country.layout_id

Declaration

public UInt16FieldInfo LayoutId { 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 .

Name

Field 'name' in table 'AddressFormat': Dictionary type String[240], .NET type: String

Name of address format (descriptive, multi-language)

Declaration

public StringFieldInfo Name { 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 .

Registered

Field 'registered' in table 'AddressFormat': 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 .

RegisteredAssociateId

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

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 .

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 .

RuntimeDefinition

Definition of the table as described in the deployed runtime dictionary

Declaration

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 .

StateFlags

Field 'state_flags' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Field flags for state field: See EAddrFormatFlags enum

Declaration

public UInt16FieldInfo StateFlags { 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 .

StateLeadtext

Field 'state_leadtext' in table 'AddressFormat': Dictionary type Id, .NET type: Int32

Lead text resource ID for state field, 0 = no leadtext

Declaration

public Int32FieldInfo StateLeadtext { 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 .

StateLength

Field 'state_length' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Field length in characters for state field

Declaration

public UInt16FieldInfo StateLength { 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 .

StateLine

Field 'state_line' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Line no. for state field, 0 if not shown

Declaration

public UInt16FieldInfo StateLine { 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 .

StateMask

Field 'state_mask' in table 'AddressFormat': Dictionary type String[10], .NET type: String

Formatting mask for state field

Declaration

public StringFieldInfo StateMask { 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 .

StateSubpos

Field 'state_subpos' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Position within line for state field

Declaration

public UInt16FieldInfo StateSubpos { 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 .

StateZip

Field 'state_zip' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Zip lookup functionality for state field: 0 = none, 1 = source, 2 = target

Declaration

public UInt16FieldInfo StateZip { 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 .

Updated

Field 'updated' in table 'AddressFormat': 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 .

UpdatedAssociateId

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

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 .

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 .

UpdatedCount

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

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 .

ZipFlags

Field 'zip_flags' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Field flags for zip field: See EAddrFormatFlags enum

Declaration

public UInt16FieldInfo ZipFlags { 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 .

ZipLeadtext

Field 'zip_leadtext' in table 'AddressFormat': Dictionary type Id, .NET type: Int32

Lead text resource ID for zip field, 0 = no leadtext

Declaration

public Int32FieldInfo ZipLeadtext { 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 .

ZipLength

Field 'zip_length' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Field length in characters for zip field

Declaration

public UInt16FieldInfo ZipLength { 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 .

ZipLine

Field 'zip_line' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Line no. for zip field, 0 if not shown

Declaration

public UInt16FieldInfo ZipLine { 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 .

ZipMask

Field 'zip_mask' in table 'AddressFormat': Dictionary type String[10], .NET type: String

Formatting mask for zip field

Declaration

public StringFieldInfo ZipMask { 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 .

ZipSubpos

Field 'zip_subpos' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Position within line for zip field

Declaration

public UInt16FieldInfo ZipSubpos { 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 .

ZipZip

Field 'zip_zip' in table 'AddressFormat': Dictionary type UShort, .NET type: Int16

Zip lookup functionality for zip field: 0 = none, 1 = source, 2 = target

Declaration

public UInt16FieldInfo ZipZip { 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 .

Implements

System.ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)