What Is Flow Field & Sum Index Field?



What Is Flow Field & Sum Index Field?..

Answer / shaikyesvee

SumIndex fields are associated with the keys of the table. You can relate multiple SumIndex fields with a particular key. Each key can have at most 20 SumIndexFields.
SumIndexFields enable fast calculation of numeric columns in tables, even in tables with thousands of records. This is because SumIndexFields are maintained when the database record is updated.

SumIndex is a Indexing feature, to enable fast calculations, and the fields are not ment to be accessed, unlike the FlowFields.

FlowFields are virtual fields in the Table. It is not a permanent part of the table data. It is used to calculate values from another or same table based on CalcFormula specified for the field. The information in the FlowFields exists only at run time.
To update a FlowField you can you CALCFIELDS function as: record.CALCFIELDS("FieldName")

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Microsoft Dynamics NAV Interview Questions

how to disable zoom (ctrl+f8) from a form?

0 Answers   Microsoft,


How to Make a field editable on a non-editable form?

0 Answers  


What Is "data Per Company Property"?

0 Answers   Microsoft,


make a field editable on a non-editable form?

0 Answers   Microsoft,


Difference between two tier and three tier architecture in navision?

0 Answers   Microsoft,


what is blob (binary large object)?

0 Answers   Microsoft,


What Is Flow Field & Sum Index Field?

1 Answers   Microsoft,


what is role center?

0 Answers   Microsoft,


send a background email when any user unblock an item card?

0 Answers   Microsoft,


how to restrict workdate for several users

0 Answers   Microsoft,


What are the web services?

0 Answers  


What Is Transheader & Transfooter?

0 Answers   Microsoft,


Categories
  • Microsoft Dynamics CRM Interview Questions Microsoft Dynamics CRM (326)
  • Microsoft Dynamics NAV Interview Questions Microsoft Dynamics NAV (32)
  • Microsoft Dynamics 365 Interview Questions Microsoft Dynamics 365 (57)
  • Microsoft Dynamics AX Interview Questions Microsoft Dynamics AX (204)