For those who have been developing in Epicor for a while and have been part of the users group, you’ve probably come across the HTML versions of the Data Dictionary on here. For those who haven’t, and are on Vantage or E9 go download it immediately as they’re incredibly quick and useful.
My question is, has anyone come across one for E10? Has one been built yet? I have no idea who built the others, but is there an E10 version in the works, or is there one out there that I haven’t seen yet?
Something I built from the EDU Database in .400 had to write a SQL Script first to populate MS_Description fields in SQL and then I could use various Database Documentation Applications from Redgate.
Attached are SQL Scripts that will lookup the info from Epicor’s ZData Tables.
Then you can build it with Apex or Redgate.
Attached:
AddExtendedPropertiesToColumns
It will check for DBTableName/DBFieldName if empty it will use DataTableID and FieldName
AddExtendedPropertiesToTables
Both Procedures check if the Object(Table/Column) exist before grabbing the Description from ZDataTable or ZDataField and populating the MS_Description.
Is this diagram around any longer? (link is dead) I’m trying to get my head around a few table relationships and would benefit from something to look at (in addition to the data dictionary).
Weird. I don’t get that popup mentioned in the link. I just double-click and it opens (but no content displays). I’ll use this issue to dig further. Thanks.
I have had to move the chm file to a local drive before I can see the descriptions, and/or right click on the .chm file, choose properties and select Unblock.