Each table i NAV contains a hidden field called timestamp. This is a rowversion or counter that always counts up, when records is modified og inserted.
Until NAV 2016, we could not access this field from NAV. This has changed.
The field is read-only, but besides that, it can be used like any normal field for filtering etc.
A typical use of the timestamp field is for synchronizing data changes in tables, when you want to identify records that have changed since the last synchronization. For example, you can read all the records in a table, and then store the highest timestamp value. Later, you can query and retrieve records that have a higher timestamp value than the stored value.
Create a new field in any table of type BigInteger.
Change SQLTimeStamp property to Yes.