Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Table unitsofmeasure UnitName Too Long?
11-07-2018, 01:50 AM,
#1
Table unitsofmeasure UnitName Too Long?
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.

   
https://www.linkedin.com/in/eclipsepaulbecker
Reply
11-07-2018, 02:13 AM,
#2
RE: Table unitsofmeasure UnitName Too Long?
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?
http://www.dalescott.net
Reply
11-07-2018, 02:47 AM, (This post was last modified: 11-07-2018, 03:11 AM by VortecCPI.)
#3
RE: Table unitsofmeasure UnitName Too Long?
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.

       
https://www.linkedin.com/in/eclipsepaulbecker
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)