The link is no longer activee, would you be able to send a new link or diagram?
2 Likes
It’s been quite a long time. I believe this has the link in it:
Let me know if this is what you’re looking for.
The link no longer works. I am looking for a data relationship diagram.
Along with a data dictionary.
Thanks,
Jen
1 Like
Vantage, Epicor and Kinetic all contain a data dictionary viewing tool. But I too would love to have a relationship map, if such a thing even exists considering Epicor’s quasi-relational database model.
Haso Keric very kindly created a help file (.CHM) of the data dictionary. Here’s a link to one of the threads where it can be downloaded: [ Download ] Epicor 10.2 & Kinetic .CHM Schema - #16 by hkeric.wci I just tested the link for 10.2.500 and it works… Searching for “chm” brings up a number of threads on the topic.
With the huge number of tables, fields, and relationships, a data relationship diagram would be unreadable. Last time I saw one was in 2003 (for Enterprise), and that one was incomplete yet still covered an entire wall of my office.
Welcome to the forum, Jeni!
But if you are new to Epicor/Kinetic - especially in the cloud, it’s useful to think about objects and not the database internals. Learn to read traces instead. It will save yourself a lot of grief. I like to know the gritty details as much as the next dev, but I cannot access the database directly in the cloud anyway. The system changes quickly and up-to-date documentation is not readily at hand. You will find that F12 is your friend. And so are most of the people here…
1 Like
You still have BAQ’s which is close enough to want to understand the relationships.
1 Like
Very true. And those relationships are implicit in the Business Objects as well.
1 Like
