Finding table - Credit Release (OECRDREL) 1

[mlbechard]

I have to create a SELECT Transact-SQL query to extract all the customer with a credit in hold and their credit limit. I know that the customer table is arcusfil_sql but I can't find the credit hold flag. Does someone know which table(s) in Macola that contains the information in the Credit Release screen?

Your help is appreciated.

Thanks

ML

 

[crystalreporting]

I presume you are on Macola ES given your earlier question regarding CashFlow? If that is the case, then the table you are looking for is cicmpy. The ARCUSFIL and APVENFIL 'tables' are actually views provided by Exact that access the cicmpy table and they only include a few of the total customer/vendor fields. The cicmpy table contacts all of your contacts (customer and vendors) so you will need to filter the results to only return the information you need.

Here's a tip that may help you find tables in ES - on any search results screen, highlight any of the search results rows and enter Ctrl-Q. That will open a window that shows you the underlying SQL query used to generate the search results.

Peter Shirley
Macola Consultant, PA and surrounding states.

http://www.erpessentials.com

 

[mlbechard]

Thank you so much for your help and tips.