Name | Data Type | Max Length (Bytes) | Nullability | Description |
---|
FieldID | int | 4 | NULL allowed | Key to the FORMS_DD table |
TableName | varchar(50) | 50 | NULL allowed | Table name the field pulls from |
FieldName | varchar(50) | 50 | NULL allowed | Column name the field pulls |
DataType | varchar(20) | 20 | NULL allowed | Type of database field (text, date, memo) |
Length | int | 4 | NULL allowed | Length of database field |
Decimals | int | 4 | NULL allowed | If using an int or numeric datatype, this is how many decimals |
ObjType | int | 4 | NULL allowed | Type of object |
FieldDescription | varchar(50) | 50 | NULL allowed | Display name of field for form builder |