Epicor

Automotive Aftermarket, Building Supply, Distribution, Manufacturing, Retail

Enterprise Resource Planning

Conversion Procedures from other ERPs such as NetSuite

https://www.epicor.com/en-us/resources/find/videos/


Floor App

Epicor Data Analytics

Key Performance Indicators


Reports

Analytics Graphs

Execute this general SQL after selecting your Epicor database:
SELECT o.name AS tbl, c.name AS col, t.name AS type, t.max_length AS size
FROM sys.objects AS o
INNER JOIN sys.columns AS c ON o.object_id = c.object_id
INNER JOIN sys.types AS t ON c.system_type_id = t.system_type_id
WHERE o.type_desc = 'USER_TABLE'

Epicor Data Dictionary

https://www.youtube.com/watch?v=kkMMgwrOcSI

https://community.spiceworks.com/topic/2369977-epicor-9-commonly-used-db-tables-for-reporting

InvHead
InvDtl
JobHead
JobMtl
Part
PartPlant
PartDtl
PartTran
OrderHed
OrderDtl
OrderRel
OrderMisc
QuoteHed
QuoteDtl

 

Company
Plant
InvHead
InvDtl
JobProd
JobHead
JobMtl
OrderHed
OrderDtl
OrderRel
Part
PartPlant
PartDtl
QuoteHed
QuoteDtl
 

Epicor Kinetic

https://www.cdata.com/kb/tech/epicorkinetic-odbc-linked-server.rst

https://www.epicor.com/en-us/industry-productivity-solutions/distribution/

Server you install
Epicor
Hardware SQL Server

ConvertInformation.com
1-202-829-4444


Job