How to Add a field to a table in NAV


I try to add a field to a table in my NAV DATA BASE but I received a licence error. A add the field directely in SQL server but it is not visible in NAV. How can I do this . What type of licence I need ?

Hi and welcome to the user group.

You should NEVER alter the tables directly from SQL. You have to use the build in table editor.

You can read more here:

When adding a new field in the table designer (which can be started by selecting the “Object Designer” from the “Tools” menu, be aware of the fact that you may add fields with an id between 50000 and 99999 only. All other ranges (below or above) are reserved for either Microsoft or AddOn developing partners.

Thank you,

It is OK. the field ID must be between 50000 and 99999