Integrated Business Communications Alliance
|
|
|
FREQUENTLY ASKED QUESTIONS: Database Layout for U.P.C. Numbers Question: Should I treat the U.P.C. number as a 12 digit number including the check digit or not? Answer: There are many different ways to lay out a database. The treatment of the number is based on database design and application software. Those people using the U.P.C. numbers should be aware that earlier explanations of the fields of information contained in the U.P.C. number may convey some misconceptions. According to the latest Industrial/Commercial Guidelines published by the Uniform Code Council (UCC), some new terminology has emerged that is helpful in understanding database layout and the use of the numbers. The base U.P.C. number in the United States is viewed as an 11 digit number, not including the calculated check digit. The number contained in a U.P.C. symbol contains all 12 digits including the calculated check digit. Throughout the rest of the world, the base UPC/EAN is looked at as a 12 digit number without the calculated check digit and a 13 digit number is represented in the UPC/EAN symbol. The base shipping container code is a 13 digit number and when represented in the Interleaved 2 of 5 Symbol, contains 14 digits including the calculated check digit. See illustration below. In summation, data files should be laid out to accommodate all 14 characters. The simplest way to use the numbers is to right fill the fields and fill with zeros in the most significant positions. If this is done, then any parsing technique can be used to key for the item number, the manufacturers number, or the package level indicator. Further database considerations are contained in the U.P.C. Industrial / Commercial Guidelines.
|
|
IBCA Phone: 215.489.1722 Email: kelleyt@quadii.com |
