I am trying to export agreement and related PO with receiving. Below is the relationship between tables I used. Is it correct?
AGREEMENTHEADER.RECID - AGREEMENTLINE-AGREEMENT
AGREEMENTLINE.RECID - PURCHLINE.MATCHINGAGREEMENTLINE
PURCHLINE.INVENTTRANSID - VENDPACKINGSLIPTRANS.INVENTTRANSID
PURCHTABLE.MATCHINGAGREEMENT - AGREEMENTHEADER.RECID
*This post is locked for comments
I have the same question (0)Hi YellowLarry,
You can verify the relations on the table definitions in the AOT.
At least the first one is correct.
Also the third is a valid relation. Note that you can have multiple receipts on one purchase line. So this is a 1:n relation.