Contracts and Purchase Orders

POLINE will have your PO detail including the agreement reference.

Hi JonA, should the data from the PURCHASE AND POLINE tables or just the POLINE alone? I need purchase order, contract description (line description), PO date, Extend line amount, invoice date, total payments, purchase order amount, expense account, accounting unit, PO status, and tax ID.

I know this is late but I'll answer anyway. For PO date you'll need the PURCHORDER table. Invoice Date is in APINVOICE. For total payments you'll need MAINVDTL. Tax ID is in the APVENMAST table. Contract description is in the POVAGRMTHD table. Accounting Unit and Account (expense code) is in MMDIST.