Set appropriate data types to fields including text, numeric (integer, decimal, currency), date/time, Boolean/logical

Validation routines including range check, character check, length check, type check, format check, presence check, check digit