IDENTIFIER

This is a fixed string the first field on the line. In the documentation below this is the field name

An example would be ESTATE.

CODE_STRING

This is a text string, normally a code field.

An example would be ABC.

DESC_STRING

This is a text string, a description field that may have the Tab or New Line characters in them. These would have been filtered so that any Tab characters are replaced by ~1 and any New Line characters are replaced by ~2.

An example would be ABC~1DEF~2Line 2

This would actually be (in the database): -
ABC     DEF
Line 2

BOOLEAN

This is a Boolean field where 1 is True and 0 is False

DATE

This is a date field store in the format YYYY-MM-DD

An example would be 2002-05-22

DATETIME

This is a date time field stored in the format YYYY-MM-DD-HH.MM.SS.TTTTTT

An Example would be 2002-05-22-14.35.45.125

NUMERIC

This is a Number stored in the format +#0.#

An Example would be 123456.78 or –46