Extract Customer Contact Info

Where can we extract the contact information from customers’ accounts from Epicor? The contact information that we are referring to would be from “Ship To”, under Sales Order Entry.

If you want to find what table any field is pulling data from, do a right click near the field/textbox, the option of field help will come up, click on that and a dialogue box will open on the left side of the screen, click on the “Tech Details” then click on the field, in the tech details it will tell you which table on the DB it is pulling data from

Hi,

Yes i need to extract using sql. Do Epicor have any report called customer master?

The data is held in the CustCnt table linked to the customer/ship to records as follows:

Customer.Company = ShipTo.Company
Customer.CustNum = ShipTo.CustNum
ShipTo.Company = CustCnt.Company
ShipTo.CustNum = CustCnt.CustNum
ShipTo.ShipToNum = CustCnt.ShipToNum

1 Like

Another option is to use the BAQ designer, maybe using one of Epicor’s BAQ’s and look at the SQL there.