What table in the database stores the reference number for a transaction?
My E-commerce integration automatically populates the reference number based on source of the transaction (web, eBay, amazon). If it makes a difference all transactions are imported as workorders. I have a custom program for checking order accuracy and would like to display the reference number on the screen when an order is being checked. I have scoured what I think are the appropriate tables, but can not seem to find the right one.
Thanks,
Chris
*This post is locked for comments
Shoot me an email offline.and I should be able to help.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,900 Super User 2024 Season 2
Martin Dráb 229,297 Most Valuable Professional
nmaenpaa 101,156