webERP Forum
Table unitsofmeasure UnitName Too Long? - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1)
+--- Forum: Problems / Bugs? (http://www.weberp.org/forum/forumdisplay.php?fid=8)
+--- Thread: Table unitsofmeasure UnitName Too Long? (/showthread.php?tid=8236)



Table unitsofmeasure UnitName Too Long? - VortecCPI - 11-07-2018

The schema for table unitsofmeasure uses varchar(15) for unitname. As we have added UoM to so many reports isn't this way too long? Perhaps we should add a description field to the table?

We always use ANSI standard UoM which is set at two (2) characters thus making reporting much easier.

[attachment=867]


RE: Table unitsofmeasure UnitName Too Long? - dalescott - 11-07-2018

But wouldn't report writers have taken into account the maximum length when they created their reports? Or is that just silly talk? ;-)

BTW, Thanks for the chart, it prompted a quick spike into X12. What does the high-lighting mean? Are they the standard units for a particular webERP user?


RE: Table unitsofmeasure UnitName Too Long? - VortecCPI - 11-07-2018

The highlighted items are those used during an ERP upgrade we did from M2M to ECi M1. M2M used non-standard UoM so I adjusted them during data transformation process.

[attachment=868] [attachment=869]