DMT Matrix

Kinetic ERP
1

So, I am helping a customer building some DMT templates with specific field requirements, but trying to find those fields is giving me challenging time. Is there a kind of DMT matrix where I can search for a field and letting me know the DMT(s) where I can find them?

Thanks

2

Try Classic Field Help will give table and column name. DMT tool template builder will also show columns.

2 Likes
3

I did that already but is difficult to identify which DMT templates contain all the fields I’m looking for, so I was wondering if by using the “matrix” will allow me to narrow down which templates can be used instead that looking at them one-by-one.

4

Mauricio, if you work for Cre8, maybe you can leverage the Epicor partnership to get ahold of José Martínez Martínez or David Hogue. Jose, knows the DMT templates very well and can answer any question you have about which ones to use and how.

1 Like
5

Or just ask . . . what are you trying to DMT that you can’t find? There is a template for most tables. The field help tells you which table its in, so . . .

2 Likes
6

There will likely need to be SEVERAL DMT templates used, as the Customer functionality is broken up into a dozen or so SQL tables, and it’s the SQL tables that DMT imports update. As @aosemwengie1 indicates, which particular fields are you having trouble finding? There isn’t a “DMT Matrix”, but there are some schema tables (and @Chris_Conn’s amazing Visual Schema ERP Schema Visualizer +) you can find through searching the forum.

3 Likes