I am trying to compile a Discoverer report showing which requisitions have been processed through iProcurement Punch-Out suppliers.
I have located 2 fields in po.po_requisitions_all. The fields are "catalog_type" and "catalog_source". Within these fields, one of the options is "external". When I specify that I want only those requisitions where the catalog_type and catalo_source are external then I get all the requisitions theough the punch-out suppliers returned.
However, I also get a number of requisitions returned where the supplier is not a punch-out supplier.
Am I looking at the correct table? Or is there a flag that is set somewhere against suppliers to indicate that they are punch-out suppliers? If so, where would I find this flag?
Thanks in Advance.