Two tables are used in current release other tables are for the future
enhancements.
UDFType
This table hold definitions for
user defined fields.
|
ID |
Unique identifier |
|
Type. |
The type of this field.
{Text=0,Numeric=1,Boolean=2,Date=3,Time=4,DateTime=5,
WebLink=11,Email=12} |
|
HelpText |
Tooltip for the field. |
|
Caption |
Field's caption. |
|
Unit |
Not used in this release.
|
|
Mandatory |
Not used in this release. |
|
Pos |
Position of the field in the list
of fields.
|
|
GroupID |
Group ID, to which group this
field belongs to. Null if groping is not used.
|
|
ListCaptionID |
Not used in this release. |
|
GID
|
For Internal use only. Used to
track multiple users changes. |
|
TABLENAME |
Table that this user fields extends. |
UDFValues There are values held in this table for user defined fields.
|
ID |
Unique identifier. |
| TypeID |
Reference to UDFType table. |
|
FieldValue |
Value of this field. |
|
ParentID |
Reference to original table that this user field is extending.
Example customer,defect table...
|
|
AttachmentID |
Not used in this release. |
|
GID |
For Internal use only. Used to track multiple users changes. |
|
TABLENAME |
Table that this user fields extends. |