I have to extract these items for audit purposes
Transaction ID Transaction Date Business Facility Item Description Supplier Name Supplier Country Transaction Amount Currency
I’m able to extract all of them through the vendtrans table except for the item description.
Regarding your answer, isn’t the VendorTrans table related to each transaction for a vendor for each item? if there are more than one items , there is a seperate transaction for that vendor?