We are using the transactions to track to expenses in the projects.
Among those expenses we have Fixed Fees. We were planning to identify in the "vendor" field of the transaction entry the company that provide the service.But unfortunately we were not able to find a view/portlet that list the transactions by vendor.
How can we get this information ?
Clarity PPM 15.x
There is not an out of the box portlet displaying the list of transactions by vendor.
The transactions would be stored on this table:
If the transaction has a header with a vendor, then an entry for such transaction will be on the following table:
A query like the following will display the transaction and the vendor:
SELECT AP.VENDOR_CODE, W.* FROM PPA_WIPAPINFO AP, PPA_WIP W WHERE AP.ID = W.PPA_WIPAPINFO_ID