With multi-company server direct, which table stores the association between the parent and child records for global customers?
Support says there is no such thing, which is impossible - somehow Epicor “knows” which child record to update when the parent record is updated, so obviously the data is stored somewhere. I’m just not sure where.
There is a “GlbCustomer” table which holds the customer data that will be shared, with a “GlbCompany” field that shows the owning company. I DON’T think there is anyplace that stores which other companies have the data.
There is also a boatload of other “Glbxxxx” tables for other global-aware data.
It’s been a while since I’ve played around with this, but you can create a BAQ that gives you the information you need.
@Ernie is correct, GlbCustomer is the right one to look to. When you create a customer and mark it as Global, it creates a record for every company in this table. Only if it’s linked will the information be filled into the Company, CustNum, CustID. The GlbCompany, GlbCustNum, and GlbCustID should be the “owning” company.
The CustNum and CustID can/may be different between companies. Based on what you have set on the Global Table, some items can be overwritten by that “owning” company of that global record.
Ok thanks for the tip! I do see the data in glbcustomer. I had been searching for tables containing “global” 