Field Class "FlowField"

sindrem

Hey people!
I have moved Navision Attain from Navision database to SQL-Server. Some of mye stored procedures uses fields that have field class "FlowField".

These fields does not appear on SQL-Server.

The table name is "Purchase Header", column "Completely Recieved". Table 38.

Is there any way to get this field? I need to know when the order is completely recieved...

Luc_VanDyck

Flowfields in SQL are stored in separate tables (each flowfield has its own table). You have to look for tables with the name COMPANYNAME$TableNo$FieldNo.

sindrem

I can only find table 37 and table 39... But I hope 38 is in there some place. I'll take a closer look at it after lunch.

Thanks for the answer

kine

If you don't know hoe to use SIFT, use select statement based on FlowField definition. Look into definition of the FlowField and create own select based on this definition. 8)

sindrem

Uhm.. Yeah that is also a solution.. Sounds like a lot of work though.