O'Reilly logo

Microsoft Dynamics NAV 2009 Programming Cookbook by Matt Traxinger

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Understanding SIFT tables

SIFT stands for Sum Index Field Technology and is used by NAV to keep track of data to quickly perform complex calculations. This recipe will show you how they work.

How to do it...

  1. Design Table 379, Detailed Cust. Ledg. Entry.
  2. Click on View | Keys from the menu.
    How to do it...
  3. View the Properties for some of the enabled keys. You will notice one property called MaintainSIFTIndex. This is the property that tells SQL Server to store the totals of the SumIndexFields.

How it works...

Prior to NAV 5.0 SP1, SIFT values were stored in actual tables. In later versions, they earned the nickname VSIFT because they are stored as views. This explanation ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required