[ Download ] Epicor 10.2.300 .CHM Schema

download
(Haso Keric) #1

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…

Link:

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.

17 Likes

Database Schema for E10
TranGLC
Sales Order Status
Do Not Ship Before
Custom Reports
(Brandon Anderson) #2

Thanks! this will be very helpful.

1 Like

(Haso Keric) #3

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

(Simon Hall) #4

Thanks @hasokeric. You are a Legend and a Scholar :slight_smile:

1 Like

(Carlos Quintanilla) #5

Awesome! Thanks a bunch for that, @hasokeric :+1:

1 Like

(Diego Laverde) #6

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?

0 Likes

(ROBERTO MORRIS) #7

Thanks @hasokeric.

1 Like

(Mark F Chinsky) #8

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

0 Likes

(Haso Keric) #9

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

0 Likes

(Paul Gaynor) #10

Thank you

1 Like

(Al) #11

many thanks @hasokeric this is awesome

1 Like

(Haso Keric) #12

2019-02-16_0147

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.

6 Likes

(Calvin Krusen) #13

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

(Haso Keric) #14

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 https://www.apexsql.com/sql-tools-doc.aspx
https://www.red-gate.com/products/sql-development/sql-doc/index

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


3 Likes

(Utah Taylor) #15

This is crazy.

0 Likes

(Haso Keric) #16

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.

2 Likes

(Brandon ) #17

@hasokeric 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.

Thanks

0 Likes

(Haso Keric) #18

Just type it into the Search Tab

2019-02-19_1355

1 Like

(Brandon ) #19

Ha! Simple enough!

1 Like

(Aaron) #20

Thank you this is beautiful.

1 Like