Transactionentry table in HQ has a field labeled dbtimestamp..does anyone know what this field is and is it a time/date field
dbtimestamp field HQ
Feb 04, 2009
3 Replies
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:
formatting link
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:
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required