dbtimestamp field HQ

I think that practically every table has a dbtimestamp field - it is like a row version. You can order by it to get the list in order of last change in table. For instance to get last 100 rows from the TransactionEntry table (beginning from the newest in the list) :

select top (100) * from TransactionEntry order by dbtimestamp desc

Read more:

I believe it is used in polling to to keep HQ in sync with the stores. If you update a transaction row in a store, the timestamp will be updated and the

401 worksheet will grab the record at its next scheduled time as HQ can see that the row versions differ between the HQ record and the store record. I have not seen that you can make the timestamp into an actual time or date.

Bjorn

"Koit Lahesoo" wrote: