Sim Greenbaum
08/17/2022, 2:14 PMSELECT
transaction.ID as transaction_id,
transactionLine.ID as transactionLine_id,
transactionLine.item as item_id,
transactionLine.custcol6 as po_number,
PreviousTransactionLineLink.previousdoc AS PO_ID
FROM transaction
JOIN transactionLine ON transaction.ID = transactionLine.transaction
JOIN PreviousTransactionLineLink ON PreviousTransactionLineLink.nextline = transactionLine.id AND
PreviousTransactionLineLink.nextdoc = transactionLine.transaction
WHERE transaction.ID = 13636399 AND transactionLine.item IS NOT NULL