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) |