Field Types Reference
C : Character (Text String)
N : Numeric Float (Fixed Length)
I : 4-Byte Signed Integer
D : Date (YYYYMMDD, 8 Bytes)
L : Logical Boolean (T/F, 1 Byte)
B : Binary BLOB (Length >= 24)
Index Rules:
- Use + to concatenate composite fields (e.g., CODE+DATE).
- BLOB (Type B) fields cannot be used as index keys.