I am trying to link the EntityGLC table to Vendors. The data dictionary says that Key1 could have the Key field such as CustNum or PartNum but I am not getting results as expected. If you have a similar query please paste the code.

Ideally would display vendornum, and the GLControlType and GLControlCode.

Thanks in advance.

I beleive vendorNum is key1, APInvoice# key 2, AP Invoice line key 3

In addition to what Andrew said, you can set RelatedToFile = Vendor to get the vendor specific information.

Key1 is string and VendorNum is int. you need to convert key 1 to int, and then use it as a criteria on Vendor table