Data basics

Data type

The kind of value a field can hold.

  • Data basics

Definition

The kind of value a field can hold. Common types are text, whole numbers, decimals and dates. The type decides what you can do with the value. A field can look like a number and still be stored as text.

Example

Raket Parts gives customers 30-day payment terms. If a field holds the text "30 days" you cannot average it. Stored as the whole number 30, it can be compared with the actual average of 47 days.

Raket Parts B.V. is a fictional company created for Insyt.

For your role

Choose your role to see what this term means in your work.

Why it matters

The wrong data type causes errors in calculations and sorting.

Where it is used

Database design, data imports and formula errors.