Hello,
I am trying to get data about transactions made per account between dates and get information about related documents with transactions.
Payable and receivable. So I need Purchase Orders and Sales Orders documents etc.

What I know / discovered in database:
Tables:
nltranm - transactions
nlmastm - transactions
plitemm - purchase transactions
opheadm - sales orders
opdetm - sales orders details
opsadetm - purchase orders
podetm - purchase orders details

But I cannot join these PO and SO to tables with Account transactions informaiton.
In nltranm there are:
unique_no
seq
columns which looks unique, but I couldn't find it in PO, SO tables.
Maybe I missed any table?

BTW. Do you have any documentations for Sage 500 7.1 database?

Thank you!

Kind regards,
Simon