# Epicor User Defined Field Register Worksheet > Source: https://netray.co/tools/epicor-user-defined-field-register-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer A register of UD fields with table, column, label, owner and populated row counts. Spot unused fields and export to Excel. ## Category epicor ## Erp Epicor Kinetic ## Audience - Epicor administrator - Epicor developer - Business analyst ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Table **Key:** table **Type:** text #### UD column **Key:** column **Type:** text #### Data type **Key:** dtype **Type:** select **Options:** - Character - Number - Date - Check box - Long text #### Business label **Key:** label **Type:** text #### Used by **Key:** used **Type:** text #### Owner **Key:** owner **Type:** text #### Total rows **Key:** total **Type:** number #### Rows populated **Key:** filled **Type:** number #### Fill % **Key:** pct **Type:** number **Expr:** if(gt(total,0), filled / total * 100, 0) **Format:** percent #### Action **Key:** action **Type:** select **Options:** - Keep - Document - Retire - Move to UD table **Rows:** #### Customer buyer ID **Table:** OrderHed **Column:** Character01 **Dtype:** Character **Used:** Order entry, acknowledgment **Owner:** Sales ops **Total:** 48200 **Filled:** 41800 **Action:** Keep #### Shelf life days **Table:** Part **Column:** Number01 **Dtype:** Number **Used:** Receiving **Owner:** Quality **Total:** 18500 **Filled:** 2600 **Action:** Document #### Fixture ID **Table:** JobOper **Column:** Character02 **Dtype:** Character **Used:** Shop traveler **Owner:** Production **Total:** 96000 **Filled:** 52000 **Action:** Keep #### Legacy flag **Table:** Customer **Column:** CheckBox01 **Dtype:** Check box **Used:** Unknown **Total:** 2400 **Filled:** 0 **Action:** Retire #### Last cost review **Table:** PartCost **Column:** Date01 **Dtype:** Date **Used:** Finance report **Owner:** Finance **Total:** 18500 **Filled:** 900 **Action:** Document **Totals:** #### UD fields registered **Key:** table **Agg:** count **Format:** integer #### Average fill % **Key:** pct **Agg:** avg **Format:** percent **Summary:** #### Lowest fill % **Key:** low **Expr:** min_pct **Format:** percent **Primary:** true #### Highest fill % **Key:** high **Expr:** max_pct **Format:** percent **Notes:** Run counts of populated rows from a SQL or BAQ query against each table and paste them here. Fields with near zero fill and no owner are retirement candidates, after checking reports and customizations that reference them. ## Content **Intro:** UD fields are how Epicor sites extend standard tables, and over the years they pile up with names like Character07 that nobody can explain. This register gives each field a meaning, an owner and a usage count. **Sections:** #### How to use the register **Body:** List each user defined column with its table, data type and business label. Add who uses it, such as a screen, report or integration, and name an owner. Enter total rows and populated rows from a query and the worksheet computes fill percentage. Use the action column to mark what to keep, document or retire. Export to Excel for review sessions. **Bullets:** - Record the business label, not only the column - Name a human owner - Pull fill counts from the database - Check reports before retiring #### Reading fill percentage **Body:** A high fill percentage on a table with many rows suggests an active, important field. A very low percentage may indicate a one time project field, a field used by a single team, or a field created and abandoned. Context matters, so low fill is a prompt to ask, not an instruction to delete. #### UD fields versus UD tables **Body:** UD fields are columns added to existing tables such as parts or orders and suit a small number of extra attributes. When data is one to many, needs its own key, or has grown to dozens of fields, a UD table is usually cleaner. The action column includes Move to UD table to flag such cases for design work. #### Common mistakes **Body:** Teams reuse a UD field for a second meaning when the first is forgotten, which corrupts reports. Others delete a field that a custom report, BAQ or integration still reads. Search your customizations and queries for each column before retiring, and keep a record of the old definition. **Cta:** If you want help finding where each UD field is referenced across screens, reports and queries, Netray can assist. **Faq:** #### What are UD fields in Epicor? **Answer:** UD fields are user defined columns on standard tables, such as character, number, date and check box fields, that you label and show on screens through customization. They let you store extra data without changing the standard schema. #### How do I count populated rows? **Answer:** Run a query or BAQ that counts rows where the column is not empty for each table, and compare to the total rows. Do this per table, then paste the counts into the register. Numeric and check box fields need a rule for default values. #### Is it safe to remove an unused UD field? **Answer:** Only after checking every place that references it: screen customizations, BPM directives, reports, BAQs and integrations. Disable usage in a test system first, then keep a backup of the label and customization definition for rollback. #### When should I choose a UD table instead? **Answer:** Choose a UD table when the data repeats per parent record, has its own key, or needs many attributes. Adding many UD fields to a busy standard table makes the model harder to explain and test than a dedicated table. ## Search terms epicor ud fields list, epicor user defined fields register, epicor ud column documentation, epicor ud field cleanup, epicor character01 field usage, epicor udfield inventory, epicor data dictionary excel --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json