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.
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
public static class UDefFieldFields : ObjectFields
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 |