Class DBC.UDefFieldFields

Fields for 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
DBC.UDefFieldFields
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
public static class UDefFieldFields

Fields

ColumnId

UDefField.ColumnId: The ID of the database column this field corresponds to

Declaration
public const string ColumnId = "columnId"
Field Value
Type Description
String

FieldDefault

UDefField.FieldDefault: Optional default value for String fields

Declaration
public const string FieldDefault = "fieldDefault"
Field Value
Type Description
String

FieldHeight

UDefField.FieldHeight: field height in pixels, 0 = 'enough' (from font)

Declaration
public const string FieldHeight = "fieldHeight"
Field Value
Type Description
String

FieldLabel

UDefField.FieldLabel: The label (lead text)

Declaration
public const string FieldLabel = "fieldLabel"
Field Value
Type Description
String

FieldLeft

UDefField.FieldLeft: X pixel coordinate of field

Declaration
public const string FieldLeft = "fieldLeft"
Field Value
Type Description
String

FieldTop

UDefField.FieldTop: Y pixel coordinate of field

Declaration
public const string FieldTop = "fieldTop"
Field Value
Type Description
String

FieldType

UDefField.FieldType: Field type: 0 = leadtext only, 1 = Edit, 2 = CheckBox, 3 = dropdown, 4 = listbox

Declaration
public const string FieldType = "fieldType"
Field Value
Type Description
String

FieldWidth

UDefField.FieldWidth: field width in pixels, 0 = 'enough' (from font)

Declaration
public const string FieldWidth = "fieldWidth"
Field Value
Type Description
String

FormatMask

UDefField.FormatMask: Formatting mask, can be whatever the controls understand (currently nothing :-))

Declaration
public const string FormatMask = "formatMask"
Field Value
Type Description
String

HideLabel

UDefField.HideLabel: Hide the label if 1

Declaration
public const string HideLabel = "hideLabel"
Field Value
Type Description
String

Indexed

UDefField.Indexed: Is this field indexed? 0 if no, index no. if yes

Declaration
public const string Indexed = "indexed"
Field Value
Type Description
String

Justification

UDefField.Justification: Justification - 0 = default, left, right, center

Declaration
public const string Justification = "justification"
Field Value
Type Description
String

LabelHeight

UDefField.LabelHeight: label height in pixels, 0 = 'enough' (from font)

Declaration
public const string LabelHeight = "labelHeight"
Field Value
Type Description
String

LabelLeft

UDefField.LabelLeft: X pixel coordinate of label

Declaration
public const string LabelLeft = "labelLeft"
Field Value
Type Description
String

LabelTop

UDefField.LabelTop: Y pixel coordinate of label

Declaration
public const string LabelTop = "labelTop"
Field Value
Type Description
String

LabelWidth

UDefField.LabelWidth: label width in pixels, 0 = 'enough' (from font)

Declaration
public const string LabelWidth = "labelWidth"
Field Value
Type Description
String

LastVersionId

UDefField.LastVersionId: UDefFieldId this field had in the previous version, 0 = field is new in this version

Declaration
public const string LastVersionId = "lastVersionId"
Field Value
Type Description
String

ListTableId

UDefField.ListTableId: The table ID of the source table for lists: kTableAssoc, kTableContInt or whatever

Declaration
public const string ListTableId = "listTableId"
Field Value
Type Description
String

Mandatory

UDefField.Mandatory: 0 = no, 1 = yes (field must be filled out)

Declaration
public const string Mandatory = "mandatory"
Field Value
Type Description
String

OwnerTableId

UDefField.OwnerTableId: ID of owning table (contact, person, project) - this is not the actual tableNumber, rather it's an enum

Declaration
public const string OwnerTableId = "ownerTable_id"
Field Value
Type Description
String

Page1LineNo

UDefField.Page1LineNo: Line no on View Page 1, used if MDO flags are OFF. 0 = this field is not visible on page 1

Declaration
public const string Page1LineNo = "page1LineNo"
Field Value
Type Description
String

ProgId

UDefField.ProgId: 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 const string ProgId = "progId"
Field Value
Type Description
String

ReadOnly

UDefField.ReadOnly: 0 = read/write, 1 = readonly (don't combine with mandatory 8-) )

Declaration
public const string ReadOnly = "readOnly"
Field Value
Type Description
String

Registered

UDefField.Registered: Registered when

Declaration
public const string Registered = "registered"
Field Value
Type Description
String

RegisteredAssociateId

UDefField.RegisteredAssociateId: Registered by whom

Declaration
public const string RegisteredAssociateId = "registered_associate_id"
Field Value
Type Description
String

ShortLabel

UDefField.ShortLabel: Short name to be used in Archive headings and on page 1. If blank, the fieldLabel will be used everywhere.

Declaration
public const string ShortLabel = "shortLabel"
Field Value
Type Description
String

TabOrder

UDefField.TabOrder: Tab order value, sets the field processing sequence

Declaration
public const string TabOrder = "tabOrder"
Field Value
Type Description
String

TextLength

UDefField.TextLength: Length (in characters) of a text field, 0 for other types

Declaration
public const string TextLength = "textLength"
Field Value
Type Description
String

Tooltip

UDefField.Tooltip: Optional tooltip text for this field

Declaration
public const string Tooltip = "tooltip"
Field Value
Type Description
String

UDefFieldId

UDefField.UDefFieldId: Primary key

Declaration
public const string UDefFieldId = "UDefField_Id"
Field Value
Type Description
String

UdefIdentity

UDefField.UdefIdentity: Unique number used to track field identity across layout changes

Declaration
public const string UdefIdentity = "udefIdentity"
Field Value
Type Description
String

UDListDefinitionId

UDefField.UDListDefinitionId: List to use for populating dropdown or listbox

Declaration
public const string UDListDefinitionId = "UDListDefinition_id"
Field Value
Type Description
String

Updated

UDefField.Updated: Last updated when

Declaration
public const string Updated = "updated"
Field Value
Type Description
String

UpdatedAssociateId

UDefField.UpdatedAssociateId: Last updated by whom

Declaration
public const string UpdatedAssociateId = "updated_associate_id"
Field Value
Type Description
String

UpdatedCount

UDefField.UpdatedCount: Number of updates made to this record

Declaration
public const string UpdatedCount = "updatedCount"
Field Value
Type Description
String

Version

UDefField.Version: Definition version number; ALL fields get new version whenever layout is updated.

Declaration
public const string Version = "version"
Field Value
Type Description
String