Field Definition

• For each field in the table, the type and size of the field is selected. For the fields in the MATERIAL table, these are:

  P8	Up to 8 pseudo-numeric characters can be entered for the material code key. This field type is suitable for storing a bar code
  C20	Up to 20 ASCII characters can be entered for the material description, in upper and lower case
  N8	Up to 8 digits can be entered for the price field. This includes the decimal point
  I5	Up to 5 digits of an integer, including the sign, can be entered for the quantity in stock (a number between -9999 and 30000)

  
  

• For numeric, date and time fields you can also specify the valid range of values. Other parts of DP4 can (and do) check entered data is within range.