Timestamp Field Available in Tables
1.
If you open a Navision table from SQL server you might have
noticed that a timestamp field is available which is a hidden field and was not accessible from Navision
in the earlier versions.
2.
With the release of NAV 2016 they made this available to NAV
users and you can access that from the Navision, add filters and write code
against it.
3.
In order to access the timestamp field we need to add a
custom field to the table with data type biginteger and we can name it anything but in the
properties of the field and we need to set the new property SQL Timestamp to yes.
Whenever you add a record to the table a row version number is generated
for that record and stored in that field.
One important note you can only read the timestamp field we added and
use if for filtering purpose or other purpose, but cannot write the data to the field.
Note: We cannot add the field as a key in the
table, but that does not prevent us from sorting on it. This method will
find not only new records, but also existing records that were modified since
last check. To locate deleted records however would require some
additional logic.
**But
this field provide integer no not date and time
