[ Download ] Epicor 10.2 & Kinetic .CHM Schema

We have taken the time to generate a brand new Schema .chm for easier researching, and would like to offer the file to you. It is for educational purposes, not to be sold. It is current as of 10.2.300.2:

I find doing research in it I find column details, all tables that contain the column etc… its my #sidekick always open and its extremely convenient and efficient. You can also use *wildcard. In any page you can use CTRL+F to prompt a search window, and easily find a word in a desc like “Cost” and it will hilight them all etc…


Contains Regular .chm and Extended .chm which has Procedures etc… I usually just use the Basic one for the sake of easier finding Tables/Columns and looking up descriptions while I build a BAQ or Report.

If you are experiencing BLANK Content Bug then make sure you uncheck the “Always Ask” Security Checkbox when you run it and it also does not like to be opened from a UNC Path. WinHelp Bugs.

Thank you for flying with E10Help. Consider being a Patreon to support the Hosting fees of this project, Jose and other Mods would appreciate it =) Enjoy.


Thanks! this will be very helpful.

1 Like

I love using CTRL+F in it, to also narrow down all Misc or Cost related fields etc… It’s Epicor’s Data Dictionary on Steroids. I can mark my word and scroll down fast, without missing a single formula that may be using it.

1 Like

Thanks @hkeric.wci. You are a Legend and a Scholar :slight_smile:

1 Like

Awesome! Thanks a bunch for that, @hkeric.wci :+1:

1 Like

Hi. I can not access the URL (it seems that the account in DropBox is already expired). Do you think you could help to update this link, and thus be able to download the information?

Thanks @hkeric.wci.

1 Like

But the ‘Ctrl-F’ only works on the one field you have in the detail view at a tim. Correct?

Correct, but you can go to the Search tab and do *wildcard * searches.

Thank you

1 Like

many thanks @hkeric.wci this is awesome

1 Like


Epicor 10.2.300 SSRS .CHM

Power-up your Due Diligence Game with this .CHM. When combined with the Schema CHM you become a force to be reckoned with. You are no longer an Analyst, but THE Analyst.

The Link is the same as above, I added it to the Folder, just in-case:

Thank you for flying with E10Help. Consider being a Patreon to support the Hosting fees of this project, Jose and other Mods would appreciate it =) Enjoy.


How are these created? Any way for users (us the admins, not end users) to create these so they include our UD fields, and custom SSRS reports?

1 Like

I can write a post about it… In a Nutshell the SSRS was simple I used Apex SQL Doc. But when it comes to the Database - tools like Apex/RedGate read the MS_Description property which is a metadata column in SQL and Epicors database does not have those set, so I wrote a Script that sets them by reading from their ZDataTable Table. Once you have set them, then you can use again any SQL Doc tool out there.

You can get the Trial of Apex or RedGate and give it a try see which one you like SQL Database documentation tool | ApexSQL
Database Documentation Generator For SQL Server | SQL Doc

So In Simple Terms, Yes it will pickup _UD Tables and Columns.


This is crazy.

not much to do in Michigan when its snowing like crazy. :slight_smile: plus it was the only way to get @MikeGross and @carlosqt to visit the forums, again.


@hkeric.wci Anyway to view all the tables a field is used in? Similar to what my screen shot shows? This is showing all the Tables the ‘OrderQty’ field is used in.


Just type it into the Search Tab


1 Like

Ha! Simple enough!

1 Like

Thank you this is beautiful.

1 Like