Use DMT to create extended UD table?

Epicor ERP 10
1

DMT has two Extended UD templates: Extended UD and Extended UD Fields.

Extended UD Fields work as I expect: I can add a new UD field (FieldName_c) to an existing UD table (Part_UD, for example).

I was hoping that I could create a UD table (ABCCode_UD) by using the Add New mode with Extended UD. However I received an error when trying to upload to ABCCode_UD.

The name of the table must begin with a valid database table name.

Tried erp.ABCCode_UD, but that did not work, either.

Is it possible to create a UD table in this way?

2

@skhayatt How many fields are you adding? I usually add the table and fields to my dev environment and then copy paste insert those into test then live as I go.

2 Likes
3

Not so many fields that I cannot do it manually. Everything is already in TEST.

I can DMT the fields. Or paste/insert them.

It was more a question of whether I could create the extended table via DMT or whether I had to create the table first and then add the fields. Could not figure out why ABCCode was not a valid database table name.

Thanks.

4

@skhayatt Solution workbench will add the table then the fields, but with everything else the table has to exist.

5

That’s what I was trying to figure out. Thanks. Only a few tables, so I created them manually and paste-inserted the fields.

1 Like