Hello everyone,
I'm working on a tool to convert GIs to SQL Queries for an external tool, and when debugging the generated Acumatica SQL query for one of my Generic Inquiry I see that it has a LEFT JOIN to the ARPayment table, but I can't find any reference to ARPayment in the GI's editor, or in the GI's exported XML file. The ARPayment is neither a BaseType DAC for any of the DACs used in the GI.
These are the tables in the GI:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/24c1568e-2d73-46bc-ac18-53fb6dc666bf.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/8f9edf07-fee0-4cf6-b637-7a5f56e4d54e.png)
The generated query used to retrieve the GI data has this LEFT JOIN:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/50b752e0-9c68-4083-bc7a-277b412ce471.png)
There is no reference to the ARPayment in the selected fields also.
Does someone have any clue as to why this join is being added?
Thanks!
Ricardo.