| |
AVAILABLE FIELDS |
TYPE |
|
| |
Alias |
Text (50) |
This value is what you need to use with advanced searches and manages |
| |
BackgroundColour |
Text (25) |
|
| |
CacheIndex |
Numeric |
|
| |
Caption |
Text (100) |
|
| |
Category |
Numeric |
|
| |
CategoryText |
Text (50) |
|
| |
DataType |
Numeric |
1=Text - Multi Line,2=Select / Choice,3=Date,4=Text - Single Line,5=Numeric |
| |
DataTypeText |
Text (100) |
|
| |
Description |
Text (2000) |
|
| |
Displayorder |
Numeric |
|
| |
Hint |
Text (2000) |
|
| |
Id |
Numeric |
|
| |
InternalReference |
Numeric |
|
| |
Mandatory |
Text (1) |
Y / N |
| |
Notes |
Text (Very Large) |
|
| |
NotesType |
Numeric |
1=Text - Multi Line,4=Text - Single Line |
| |
NotesTypeText |
Text (100) |
|
| |
Object |
Numeric |
|
| |
ObjectText |
Text (50) |
|
| |
Public |
Text (1) |
Y / N |
| |
Reference |
Numeric |
Deprecated. Use alias instead |
| |
Status |
Numeric |
1 = Enabled, 2 = Disabled |
| |
StatusText |
Text (50) |
|
| |
Structure |
Numeric |
|
| |
StructureText |
Text (100) |
|
| |
TextColour |
Text (25) |
|
| |
Title |
Text (250) |
|
| |
|
|
|
| |
Audit Fields |
|
Click here for more information |
