Lawson Add-ins Technical Documentation

Legacy Contributor

Hi,
Is there any documentation available that discusses table relationships that addin uses? I have looked in the table file text. The two Tables are in PO
PURCHORDER AND POAUDIT

Legacy Contributor

Hi lwilsey - what exactly are you wanting to know? Just what the relationships are to each other?

PURCHORDER has a one-to-many relationship to POAUDIT on COMPANY, PO-NUMBER, PO-RELEASE, and PO-CODE.

POAUDIT has a one-to-one relationship to PURCHORDER on COMPANY, PO-CODE, PO-NUMBER, PO-RELEASE WHEN PO-LINE-NBR = ZEROES

If you have command-line access, you can get this information by using "dbdoc {prodline} {systemcode} {tablename}. If not, you can look them up here: lawsonguru.com/.../DataDictionary.aspx.

Good Luck!