• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

UCC Codes

rgepes

Member
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C07F2D.4282FB30
Content-Type: text/plain;
charset="iso-8859-1"


List,

Could somebody explain better than what the JDE documentation explains the
following code, specifically the check digit?

UPC Code example:
companyid productid chk
131211109 8765432 1

How does JDE validate these and where do they get setup at? As much detail
would be appreciated...

Thanks,
Rich

perotsystems/AdvanceWatch RichardW.Gepes
email:<mailto:rgepes@awcus.com> Phone: 810.755.3000 ext. 206


------_=_NextPart_001_01C07F2D.4282FB30
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>UCC Codes</TITLE>
</HEAD>
<BODY>





<FONT SIZE=3D2 FACE=3D"Arial">List,</FONT>
</P>



<FONT SIZE=3D2 FACE=3D"Arial">Could somebody explain better than =
what the JDE documentation explains the following code, specifically =
the check digit?</FONT></P>



<FONT SIZE=3D2 FACE=3D"Arial">UPC Code example:</FONT>

<FONT SIZE=3D2 FACE=3D"Arial">companyid productid =
chk</FONT>

<FONT SIZE=3D2 FACE=3D"Arial">131211109 =
8765432 1</FONT>
</P>



<FONT SIZE=3D2 FACE=3D"Arial">How does JDE validate these and where =
do they get setup at? As much detail would be =
appreciated...</FONT>
</P>



<FONT SIZE=3D2 FACE=3D"Arial">Thanks,</FONT>

<FONT SIZE=3D2 FACE=3D"Arial">Rich </FONT>
</P>



<FONT COLOR=3D"#800000" SIZE=3D2 FACE=3D"Arial =
Black">perot</FONT><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Arial =
Black">systems/</FONT><FONT COLOR=3D"#800000" SIZE=3D2 FACE=3D"Arial =
Black">Advance</FONT><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Arial =
Black">Watch =
</FONT> <FONT =
COLOR=3D"#800000" SIZE=3D2 FACE=3D"Arial Black">Richard</FONT><FONT =
COLOR=3D"#000000" SIZE=3D2 FACE=3D"Arial Black">W.Gepes</FONT>

<FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Arial =
Black">email:</FONT><U><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial =
Black"><<A =
HREF=3D"mailto:rgepes@awcus.com">mailto:rgepes@awcus.com</A>></FONT><=
/U> <FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Arial Black">Phone: =
810.755.3000 ext. 206 =
</FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C07F2D.4282FB30--
 

amwalshjde

Well Known Member
Rich-

UCC-128 codes are used to uniquiely identify all products. First off here
are some basic definitions:

UCC-Uniform Code Council. They make the standards for North America. They
are responsible for assigning Company Numbers

EAN-European somthing or other, they make the standerds for everywhere but
North America

UCC Company numbers-Each company can have as many company numbers as they
would like, but each number is unique. If it is assigned by the UCC then it
is a six digit number, if assigned by the EAN it is a seven digit number

UPC-12 -A twelve digit number that is comprised of six digit (US) company
number, followed by a five digit code that is unique to that item. The last
digit is the check digit. IT is calulated, and based on the preceding
numbers.Calculation is

1)add all the numbers in odd places.(positions 1,3,5,etc)
2) add all the numbers in even positions (2,4,6,etc) then mulitply by three
3) add the result from steps 1 and 2 together
4)divide by 10 and take the remainder
5)substract 10 from the result in step 4, and then get the absolute value

EAN-13 -This the the same as the UPC-12 but used everywhere else in the
world. It is one digit bigger becuase the company code is seven instead of
six outside the US.

On top of that there are SCC-14, and SSCC-18 codes that JDE also uses A8.1,
and B7.33 (maybe B732, it's been a while) in the transportation modules.

UCC company code information is set up in the 41/UC UDC table. Leading
zeros are not needed.

UPC and SCC data is set up at the item level. There is a row exit titled
"Storage/Shipping" Under the shipping tab

In the shipping screen JDE will requre that you input a 13 digit number(the
EAN code). Make sure that the extra digit is in the front and part of the
company code. It will calculate the check digit and tell you if it is
wrong, but it will not tell you what the correct digit is!!!

The number you gave me is to long to be a UPC, it could a SSCC
number.....which is the seven digit company nunber, then a nine digit serial
number and then the check digit number.

It is a little confusing and I will take another shoot at it if you need.
Also let me know if you have any other questions...
AW


List,

Could somebody explain better than what the JDE documentation explains the
following code, specifically the check digit?

UPC Code example:
companyid productid chk
131211109 8765432 1

How does JDE validate these and where do they get setup at? As much detail
would be appreciated...

Thanks,
Rich

perotsystems/AdvanceWatch RichardW.Gepes
email:<mailto:rgepes@awcus.com> Phone: 810.755.3000 ext. 206


------_=_NextPart_001_01C07F2D.4282FB30
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>UCC Codes</TITLE>
</HEAD>
<BODY>





<FONT SIZE=3D2 FACE=3D"Arial">List,</FONT>
</P>



<FONT SIZE=3D2 FACE=3D"Arial">Could somebody explain better than =
what the JDE documentation explains the following code, specifically =
the check digit?</FONT></P>



<FONT SIZE=3D2 FACE=3D"Arial">UPC Code example:</FONT>

<FONT SIZE=3D2 FACE=3D"Arial">companyid productid =
chk</FONT>

<FONT SIZE=3D2 FACE=3D"Arial">131211109 =
8765432 1</FONT>
</P>



<FONT SIZE=3D2 FACE=3D"Arial">How does JDE validate these and where =
do they get setup at? As much detail would be =
appreciated...</FONT>
</P>



<FONT SIZE=3D2 FACE=3D"Arial">Thanks,</FONT>

<FONT SIZE=3D2 FACE=3D"Arial">Rich </FONT>
</P>



<FONT COLOR=3D"#800000" SIZE=3D2 FACE=3D"Arial =
Black">perot</FONT><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Arial =
Black">systems/</FONT><FONT COLOR=3D"#800000" SIZE=3D2 FACE=3D"Arial =
Black">Advance</FONT><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Arial =
Black">Watch =
</FONT> <FONT =
COLOR=3D"#800000" SIZE=3D2 FACE=3D"Arial Black">Richard</FONT><FONT =
COLOR=3D"#000000" SIZE=3D2 FACE=3D"Arial Black">W.Gepes</FONT>

<FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Arial =
Black">email:</FONT><U><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial =
Black"><<A =
HREF=3D"mailto:rgepes@awcus.com">mailto:rgepes@awcus.com</A>></FONT><=
/U> <FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Arial Black">Phone: =
810.755.3000 ext. 206 =
</FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C07F2D.4282FB30--




--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=
3985
*************************************************************
This is the JDEList One World / XE Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************


__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com
 

jeffv

Member
Re: RE: UCC Codes

Does anybody know why JDE only accepts 13 characters? It seems to me as if this is a bug, especially in the US where the UPC code is 12 characters including the check digit. Has anybody found a way around this, other than using some other field to store the correctly formatted UPC codes?
 

PeterD123

Member
Does anybody know why JDE only accepts 13 characters? It seems to me as if this is a bug, especially in the US where the UPC code is 12 characters including the check digit. Has anybody found a way around this, other than using some other field to store the correctly formatted UPC codes?
Hello,
The way around it is to add a zero to the front of the number (prepend).
The 12 digit UPC code (UPC-A) is made into a 13 digit EAN by prepending a zero.
It is made into a 14 digit UCC 128 / GTIN-14 by prepending two zeros.
 
Top