<input type="text" name="total" fieldtype="money" />

Each input tag in the html corresponds to a field in a SQL Server table. The name and data type of the field come from the input tag name and type or value.

• input type="text"… becomes varchar
• input type="file" ... used for uploading files (images, pdfs etc)
  
• <textarea… becomes text
• _currentdate,_currenttime, and _currentdatetime values forces the field’s data type to be datetime
• _number forces the field’s data type to be int
• You can override data type using a fieldtype attribute