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.
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 |