Home > Technical > Table Definitions > USERDEFFIELD
This table records any used defined fields that have been added to the system as part of User Defined Fields functionality.
Column |
Type |
Description |
||||||||||||
INT |
A unique number assigned by the system to identify the record. |
|||||||||||||
STRFUNCTION |
VARCHAR(10) |
Indicates which function this user defined field is for. CUSTOMER, ITEM, LOCATION, SUPPLIER, USER. |
||||||||||||
STRNAME |
VARCHAR(20) |
The name of the field. This is the name assigned by the user so they can easily identify the control. |
||||||||||||
INTSEQUENCE |
INT |
The sequence in which the fields should be created (controls the tab order). |
||||||||||||
INTFIELDTYPE |
INT |
Indicates the type of control.
|
||||||||||||
INTLEFT |
INT |
Position of left hand side of control (pixels). |
||||||||||||
INTTOP |
INT |
Position of top of control (pixels). |
||||||||||||
INTWIDTH |
INT |
The width (in pixels) of the control. |
||||||||||||
INTHEIGHT |
INT |
The height (in pixels) of the control. |
||||||||||||
STRLABEL |
VARCHAR(255) |
Descriptive label identifying the field to be shown. |
||||||||||||
INTDATATYPE |
INT |
Indicates the type of data (used when INTFIELDTYPE = 0)
|
||||||||||||
INTMAXLENGTH |
INT |
The maximum length of data allowed for the value. |
||||||||||||
MEMCOMBOITEMS |
TEXT |
A list of the items to appear in the drop-down list. This represents a StringList.Text where each entry would be on a separate line in the StringList. |
||||||||||||
STRDEFAULT |
VARCHAR(255) |
The default value for this control. |
||||||||||||
YSNDELETED |
VARCHAR(1) |
True if the field has been deleted. |
Primary Key: CTRCODE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |