Keys in Navision and SQL Server

When you create a Primary key in Navision, Navision will create the key in SQL Server table as Primary Key with Clustered Index. The primary key created in SQL Server table will be named with the following format:


TableName$0


For example, primary key in Customer table will be created as clustered primary key in SQL Server and named Cronus$Customer$0




If you have enable the MaintainSQLIndex, the secondary key in Navision will be created as Non-Clustered key in SQL Server with the name $number.

Primary Key for table Item Ledger Entry

The Primary Key for the Item Ledger Entry table is the Entry No.