Reg: "Flow Fields" in SQL Server

mohanG

Hi Friends,
This is Mohan Kumar, working as Navision Technical Consultant, Recenly we migrated to "Navision 3.7 with Native DB" to "Nav 2009 SP1 with SQL Db". We had taken Data from Database (Navision 3.7 ) to Excel (or) any External Applocation by using CODBC but now problem is that we Native DB we can take "Flow Fields " data , in SQL "Flow Fields" are not maintaining in table. I came to know that in SQL "Flow fields" are maintained at Some other tables (SIFT Tables) .

So can u please suggest the SIFT table for "Item" .

Thanks In Advace,

Regards
Mohan Kumar >g

kriki

The SIFT-tables are only used until version 4.0SP3 and 5.0 (without SP1).
Starting with 5.0SP1, Indexed views are used to maintain the SIFT.

The SIFT views have this format : "CRONUS International Ltd_$Contract Gain_Loss Entry$VSIFT$4"

If you open SQL Server Management Studio, go to your DB,then views, you will see all the views of all tables. You can run them to see which one you need.