View: Optional Fields

RotoID: GL0500
Table: GLOFD
Protocol: Detail, Ordered revisions
DLL:GLOFD

Compositions: 1

RotoID Tables Title DLL

GL0501 GLOFH Optional Field Locations GLOFH

Keys: 1

Title Fields

Optional Field LOCATIONOPTFIELD

Fields: 21

Field Index Type Title Attributes Presentation

LOCATION 1 Integer Location E A K R  List:2 entries
0 = Accounts
1 = Transaction Details
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 20 Long Typed Default Value Field Index E A C 
DVIFTEXT 21 String*60 Default Text Value E A C P  Mask: %-60c
DVIFMONEY 22 BCD*10.3 Default Amount Value E A C 
DVIFNUM 23 BCD*10.0 Default Number Value E A C T 
DVIFLONG 24 Long Default Integer Value E A C 
DVIFBOOL 25 Boolean Default Yes/No Value E A C  List:2 entries
0 = No
1 = Yes
DVIFDATE 26 Date Default Date Value E A C 
DVIFTIME 27 Time Default Time Value E A C 
FDESC 28 String*60 Optional Field Description E A C 
VDESC 29 String*60 Default Value Description E A C