Person/Contact Table Links

Epicor ERP 10
1

Hi

Please can somebody help me spot the obvious…!

PerCon Table
SysRowId Company PerConID Name
B51A97D0-BD11-4C45-8FE3-FC58209A54C9 BVD 593 Lesley

PerConLnk Table
SysRowID LinkSysRowID Company PerConID ContextLink
610594EC-A076-43AB-A2B9-C09841D59849 7D8C84BC-6E1A-409F-B3A0-5C49F27A1BC4 BVD 593 Customer

Customer Table
SysRowID Company CustID CustNum
9686445C-4B68-E2BA-E211-5D68C564A029 BVD BDELI 75

When I look on Person/Contact Maintenance for this entry (593), it shows as being linked to the customer ID shown above. It also shows this contact against the customer when viewed from Customer Maintenance.

I’m trying to create what should be a very simple BAQ containing a list of customers vs contacts. BUT, what links between PerConLnk table and Customer table? I was assuming the LinkSysRowID, but they aren’t the same here. Any clues please?

Many Thanks
Mark

2

Use Customer and CustCnt tables.

3

I will have to find my BAQ, but I know you would have to use the ContextLink to filter the contacts. The contextLink in PerConLnk will tell you how the contact is used. For us, ContextLink has the values Customer, Supplier or Ship To. I will respond later with the results of my BAQ. I may also have an SQL View or Stored Procedure.