View: Optional Fields

RotoID: MT0405
Table: MTOFD
Protocol: Detail, Ordered revisions
DLL:MTOFD

Compositions: 1

RotoID Tables Title DLL

MT0410 MTOFH Optional Field Locations MTOFH

Keys: 1

Title Fields

Optional Field LOCATIONOPTFIELD

Fields: 21

Field Index Type Title Attributes Presentation

LOCATION 1 Integer Location E A K R  List:1 entries
0 = Contacts
OPTFIELD 2 String*12 Optional Field E A K R  Mask: %-12N
DEFVAL 3 String*60 Default Value E A P  Mask: %-60c
TYPE 4 Integer Type E A C  List:7 entries
1 = Text
100 = Amount
6 = Number
8 = Integer
9 = Yes/No
3 = Date
4 = Time
LENGTH 5 Integer Length E A C 
DECIMALS 6 Integer Decimals E A C 
ALLOWNULL 7 Boolean Allow Blank E A C  List:2 entries
0 = No
1 = Yes
VALIDATE 8 Boolean Validate E A C  List:2 entries
0 = No
1 = Yes
INITFLAG 9 Integer Auto Insert E A  List:2 entries
0 = No
1 = Yes
SWREQUIRED 10 Integer Required E A  List:2 entries
0 = No
1 = Yes
SWSET 11 Integer Value Set E A  List:2 entries
0 = No
1 = Yes
DVINDEX 35 Long Typed Default Value Field Index E A C 
DVIFTEXT 36 String*60 Default Text Value E A C P  Mask: %-60c
DVIFMONEY 37 BCD*10.3 Default Money Value E A C 
DVIFNUM 38 BCD*10.0 Default Number Value E A C T 
DVIFLONG 39 Long Default Integer Value E A C 
DVIFBOOL 40 Boolean Default Yes/No Value E A C  List:2 entries
0 = No
1 = Yes
DVIFDATE 41 Date Default Date Value E A C 
DVIFTIME 42 Time Default Time Value E A C 
FDESC 43 String*60 Optional Field Description E A C 
VDESC 44 String*60 Default Value Description E A C