EPICOR

Origin

When creating an epicor Origin, you must supply your username, password, Epicor API URL, and then choose a Service. The Epicor API URL will look like: https://starfish.epicorhosting.com/EpicorERPCTS/api/v1

The Service you select will look like ERP.BO.QuoteSvc or Ice.BO.DynamicQuerySvc. Each service contains a number of tables of data. You can only join between tables in the same Service. For example, if you are using the ERP.BO.QuoteSvc, you can join the Quotes and QuoteCnts tables:

SELECT * FROM Quotes
left join QuoteCnts on Quotes.Company = QuoteCnts.Company and Quotes.QuoteNum = QuoteCnts.QuoteNum and QuoteCnts.PrimeContact = True