Adding new fields to the tables

Go back to the Table Designer screen for our Table 50000. The requirement list states that we need the customer and vendor information. We also need the date on which that document is created. So let's do that.

The Data Type and Length of these fields mimic the Customer table. Since this data is related, you have to ensure that Data Type and Length are the same, or else you will get a lot of errors when you're trying to copy data between these tables and fields. If you go back and look at the Sales Header table, you'll see that the Data Type and Length of the fields are the same as the Customer table.

Note

It's generally a very bad idea to try to expand the length or change the data type of the fields in the standard Dynamics NAV tables. The reason is because the standard logic and business rules are all based on the standard data type and field length. Changing them may cause serious damage to your Dynamics NAV database. If, for whatever reason, you need to...