D365 Excel add-in: link table between purchase orders and purchase requisition

Hi all,

does anyone knows the name of the table to see the link between purchase requisition and purchase order in excel add-in?

thanks!

I’m not sure if there is any table for that. The link between purchase requisition and purchase order I use is: PurchLine.PurchId=PurchReqLine.PurchId; PurchLine.PurchReqId=PurchReqLine.PurchReqTable; PurchLine.LineNumber=PurchReqLine.LineNum; PurchLine.ItemId.ItemId

I don’t know if there is an entity to import in Excel add-in with all this information, maybe you’ll need to import PR and PO information in separate sheets and then link them