Patch Field Blank Title 124793

Hi Devin,

 

The PatchFld table has unfortunately been abused over time, consider this an internal table in Epicor.

 

The original intension of the table was to provide a way to introduce fixes and features that would normally require a schema (Table Change) without requiring a schema change.

The PatchFld is keyed on the tablename and a set of key columns hence it doesn’t need to change to support new fields to extend tables.

 

What should of happened at the next schema change is these fields all being normalized back into their corresponding tables, but that hasn’t happened in all cases (maybe E10 will be a start towards this)

 

Storing things in the PatchFld is not actually a problem for the system it is just not intuitive for the users trying to report off the tables, and introduces a slight performance overhead.

 

Other tables like this include ComXRef and Local001

local001 is designed to be used for Localization related items

 

Hope this helps.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of devin.draeger
Sent: 20 September 2013 21:29
To: vantage@yahoogroups.com
Subject: [Vantage] Patch Field

 

 

What is the patch field table do or what is it used for. I had someone for epicor use it for tax realated in formation Can someone tell what it is used or how it can be used.

What is the patch field table do or what is it used for. I had someone for epicor use it for tax realated in formation Can someone tell what it is used or how it can be used.