Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Field Types

Field Type

Explanantion

int

integer fields

bit

Yes or No fields

1 for Yes and 0 for No

date

format dd/mm/yy or dd/mm/yyyy

nvarchar (11)

text field with maximum length 11

decimal (8,2)

Decimal field must include the decimal and 00
(8,2) the total number of digits before and after the decimal point.

e.g 42.00 17.00 18.43 26.40