How can I find out tio which SQL server table a NAV table relates? Thanks for your help.
If the table has the DataPerCompany property set to Yes (as most of them), then NAV creates one table for each company you have in the database. The name in SQL contains the name of the company plus the name of the table, changing some characters that are not managed by SQL such as the space or the dot. You can have for example Cronus_International_Ltd_SalesHeader or something similar (I don’t remember the exact name) for table 36.
Hope this helps you.