EPICOR: Difference between revisions
Jump to navigation
Jump to search
Jkuehlthau (talk | contribs) (Created page with "=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://starfi...") |
Jkuehlthau (talk | contribs) (→Origin) |
||
| Line 2: | Line 2: | ||
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 | 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 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: | ||
<source lang="sql"> | |||
SELECT * FROM Quotes | |||
left join QuoteCnts on Quotes.Company = QuoteCnts.Company and Quotes.QuoteNum = QuoteCnts.QuoteNum and QuoteCnts.PrimeContact = True | |||
</source> | |||
Revision as of 20:15, 30 July 2019
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