Each field has to be displayed in two different ways for the Detail view and Edit view. Display type column defines a field to be displayed either in Edit view or the Detail view or both.
The following are some of the display types that are used:
typeofdata | data type |
C | Checkbox/Boolean |
D | Date |
DT | DateTime |
E | |
I | Integer |
N | Number |
NN | Negative Number |
O | RecurringType/Duration_minutes |
P | Password |
T | Time |
V | Varchar |
typeofdata |
C~O |
DT~M~time_start |
DT~M~time_start~Time Start |
D~M |
D~M~OTH~GE~date_start~Start Date & Time |
D~O |
D~O~OTH~GE~sales_start_date~Sales Start Date |
D~O~OTH~GE~start_date~Start Date |
D~O~OTH~GE~support_start_date~Support Start Date |
D~O~OTH~G~start_period~Start Period |
E~M |
E~O |
I~M |
I~O |
NN~O |
N~M |
N~O |
N~O~10,2 |
N~O~2,2 |
N~O~2~2 |
O~O |
P~M |
T~M |
T~O |
V~M |
V~O |
V~O~LE~150 |
V~O~LE~16 |
V~O~LE~25 |
V~O~LE~4 |
V~O~LE~9 |
In the above examples:
*M; Indicates Mandatory field
*O; Indicates Optional field
On numeric and date fields you can add some more information on the typeofdata column in order to perform some basic validations when editing.
Numeric fields accept a comparison operator followed by a number to use in the comparison.
N~O~LE~22
will assure that the number in this field is smaller or equal to 22
Date fields accept the same comparison operator followed by the field name of another date field being edited in the browser and will make sure that the relation indicated by the operator is true.
D~O~OTH~GE~dateinservice~Date in Service
the date in this field will be equal to or bigger than the value in dateinservice field
Accepted comparators are: L,LE,E,NE,G,GE