UD tables - Built-in fields or Extended fields (pseudo poll)

Epicor ERP 10
1

Just curious, do most people just use the built-in UD table fields (CharacterXX, CheckboxXX, etc…), or do you Extend the table (add a field via “Extended UD Table Maintenance”)?

The first doesn’t require doing a schema update (or whatever that is technically called). But you have to remember which CharacterXX field holds what data. You end up with code in customizations like

epiUltraComboC1.ValueMember = "ShortChar01"

The second way would allow the code to be more readable:

epiUltraComboC1.ValueMember = "PM_Name_c"

But would require the schema update.

Thoughts?

2

in 10 I ALWAYS make custom fields, there is negligible over-head to doing this (1 - 1 Join) and it makes everything so much easier

3

How do you manage the key fields? Keep an excel file cheat sheet?

4

You can modify the extended properties to tell you what’s there.

5

That 1 to 1 limitation exists to both styles of UD. Something we are working on - TBD.

6

No comment (lest I Jose bans me from the forum) haha

7

I vote for

because any issues that could occur from it would be handled by a different Support team :grimacing::smirk:

8

Hey now @Chris_Conn , I’ve never banned anyone… now I may mock you mercilessly but that’s about it :slight_smile:

9

Custom fields using UD Table Maintenance for the most part, but we do use UD tables in certain situations.