Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Table unitsofmeasure UnitName Too Long?
11-07-2018, 01:50 AM
Post: #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
Visit this user's website Find all posts by this user
Quote this message in a reply
11-07-2018, 02:13 AM
Post: #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
Visit this user's website Find all posts by this user
Quote this message in a reply
11-07-2018, 02:47 AM (This post was last modified: 11-07-2018 03:11 AM by VortecCPI.)
Post: #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
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)