UD Columns - Does Seq num matter?

[askulte (Andris Skulte)]

Hi guys,

I imported a solution workbench file to add dozens of UD fields across 6 tables. This duplicated the sequence numbers on many fields. (i.e. there’s now two Seq 9’s, and 10’s, etc…).

Does this matter? Do I need to resequence and regen the db, or ok to leave as is? We’re on 10.2.500 if that matters.

Thanks!

[ckrusen (Calvin Krusen)]

Check the data dictionary to see what the description for that field is. Use the windows help file of the it that @hkeric.wci posted. You can search a field name and find where it might be referenced in other tables.

[ Download ] Epicor 10.2 & Kinetic .CHM Schema

We have taken the time to generate a brand new Schema .chm for easier researching, and would like to offer the file to you. It is for educational purposes, not to be sold. It is current as of 10.2.300.2: I find doing research in it I find column details, all tables that contain the column etc… its my #sidekick always open and its extremely convenient and efficient. You can also use *wildcard. In any page you can use CTRL+F to prompt a search window, and easily find a word in a desc like “Cost” …

[Doug.C (Doug Crabtree)]

I’ve had several tables the same way. I’ve never seen it cause an issue. I think the Seq is mainly used for ordering lists (baq designer maybe?) . I haven’t really dug into it since ERP doesn’t complain about duplicates. I usually just manually reorder them unless it’s a major task to update.

[askulte (Andris Skulte)]

Thanks @Doug.C and @ckrusen! I need to look at the Schema more too. Thanks @hkeric.wci for making it.