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