where is the flow fields in SQL DB

Reply

satheeshNav Posted: 12-20-2007 7:08

rated by 0 users

Hi  friends

I  have  changed the back end from Nav native DB  to  SQL sever 2005 . I open the sql DB and check the flow fields in customer  ledger  ex:- Amount, Original Amt. (LCY), Remaining Amt. (LCY), Original Amt. (LCY) . there are not there   where can I find them . how this fields are exsist . for the purpose of using Sql reporting service i need this help

Reply

HW replied on 12-20-2007 9:31

rated by 0 users

If you open the SQL Server with Enterprise Manager, you will see a lot of table name with the following format:

Company_name$xxx$1

Company_name$xxx$2

 xxx = table number.

If not mistaken, the info for flowfields are stored inside these tables.  

Reply

Jörg A. Stryk replied on 12-20-2007 12:59

rated by 0 users

"Flow Fields" are fields which do not store physically any value - this value is calculated on demand; this refers to C/SIDE and SQL Server. The only way to access FF is via C/SIDE C/AL. With SQL Server the FF aren't even defined within the table - they simply do not exist with SQL Server.

When NAV is "calculating" a FF for display, it is querying the related table (CalcFormula) in addition to the "master" table.

Thus, in your case, if you want to deal with the FF e.g. "Amount" etc. on "Customer Ledger Entry" with SQL, you have to query the data from the "Detailed Cust. Ledger Entry" table.