I have read the emails on both of Mikes Questions and decided to address both at one time without including all of the comments prior to this
Mike Rawlins asked: "Anyone out there using an "N4" code (for National Drug Code in 5-4-2 format) in DE 235 in the PO1 segment of an X12 850 or IT1 of an 810? If you are, what's the relationship between this code and the product UPC in 1-5-5 format. Seems to me that the N4 code ought to be the right most 10 digits, plus the check digit, but I have customers who have different ideas and I can't find a definitive reference to resolve the confusion." Since code N4 and UI have different code source references your client is probably correct. I believe the UCC has asked many of these codes like UI and other variations of their U.P.C. deleted in favor of GTIN or simple U.P.C. To resolve what exactly is the 11 digit NDC you may want to contact the FDA (301.443.1544). I suspect it is positions 11 through 1 of the U.P.C. but I do not know. Now that being said I can tell you, with great certainty, exactly how a pharmaceutical or medical / surgical products can be marked with a U.P.C. >From the UCC Guidelines for Supply Chain Identification: a U.P.C. may be used to identify pharmaceutical products, using the National Drug Code (NDC), or identify medical / surgical products, using the National Health Related Item Code (NHRIC). The U.P.C. consists of twelve (12) digit numbered from right to left, 1 through 12. * Position 12 is always "3" indicating the following ten digits represent a NDC or NHRIC product ID (positions 11 through 2); position 1 is the standard EAN*UCC Mod10 check digit. * The NDC or NHRIC product ID is comprised of a 4 or 5 digit labeler code, assigned by the Food and Drug Administration (FDA), and a 6 or 5 digit product / packaging code assigned by the holder of the labeler code. * The ten digit code in positions 11 through 2 is comprised of the following: o If position 11 contains a "0" the labeler code is a four digit NDC code and a six digit product / packaging code. o If position 11 contains a "1" through "7" the labeler code is a five digit NDC code and a five digit product / packaging code o If position 11 contains a "8" the labeler code is a four digit NHRIC code and a six digit product / packaging code. o If position 11 contains a "9" the labeler code is a five digit NHRIC code and a five digit product / packaging code Mike Rawlins asked: U.P.C. Consumer Package Code (1-5-5) UI in X12 DE 235 U.P.C./EAN Case Code (2-5-5) UA in X12 DE 235 EAN/UCC 14 UK in X12 DE 235 My hunch is that for any given product the first two are usually subsets of the third. Again, I've researched but can't find a definitive answer about this. Code UK is for the Global Trade Identification Number. It use to be the simple 14 digit case code but now a 12 digit U.P.C., 13 Digit EAN code, or a EAN*UCC-8 code can also be used by adding leading zeros to make 14 digits. UI was a U.P.C. without the check digit. UA I have no clue because the digits never added up because the case code is 14 digits. I think Forest Gump said summed it up "stupid is as stupid does" and I don't know anyone who is using it. I do know the suggested best practice is simply use codes UK (14 digit codes, or UP (12 digit codes), or EN (13 digit codes), or EO (8 digit codes). These as all the codes any organization would need to communicate UCC*EAN product ID codes. Mike Rawlins asked: I have a situation where the consumer package code isn't a subset of the EAN/UCC 14 code (e.g. 3-58790-00228-6 and 1-00-58790-00228-2), and my client doesn't publish the U.P.C/EAN Case code on their price list. Some of their customers think the 12 digit case code should have a "3" in the second position to match the consumer package code, and others think it should have a "0" to match the 14 digit case code. The only values that are actually barcoded are the consumer package code and the EAN/UCC 14 code on the case. OK, here is the truth and it is undisputed! There are, and always been, two ways to assign the case code. Method one is to use the indicator digit (position 14) and couple it with the base unit (U.P.C. or EAN-13) to identify up to 8 packaging variations of the base unit. Method two is to simply assign a new base unit. So what you have described is completely legitimate. The link between ultimately comes in the 888 or 832 transaction where the higher level ordering units are "linked" this includes pallets, master cases, etc. The other linking is in the very complicated GS1 data sync XML messaging. The only thing about the indicator digit is a "9" is reserved for variable weight / measure and "0" by the definition of the GTIN is a item intended to be scanned at POS identified with a U.P.C., EAN-13, or a EAN*UCC-8 item ID. That is all the free stuff for today. Mike, if you want to call me I will be happy to discuss and put you on the path, so to speak. James D. Sykes II Argolis, Inc. 1740 Pine St. Martinez, CA 94553 [EMAIL PROTECTED] Cell: 01.510.502.3333 [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hsnlga0/M=362329.6886308.7839368.1510227/D=groups/S=1705005582:TM/Y=YAHOO/EXP=1122701374/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992 ">Fair play? Video games influencing politics. Click and talk back!</a>.</font> --------------------------------------------------------------------~-> . Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Access the list online at: http://groups.yahoo.com/group/EDI-L Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/EDI-L/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
