IBM Sterling Ideas
formerly Watson Supply Chain
Submit new product ideas for IBM Sterling solutions. Before you submit, please review existing ideas; if an idea close to yours already exists, it's better to add comments or vote on the existing idea. We will review your ideas and use them to help prioritize our product development. Best of all, the portal will automatically update you when the status of your idea has been changed. Order Management, Store Engagement, Watson Order Optimizer, Inventory Visibility, CPQ and Call Center are now part of Watson Supply Chain
Connect with IBM experts and your peers on the
Supply Chain Collaboration Community and the Order Management Interest Group
Recent attention has been raised to the Pharmaceutical Industry, EDI data codes resulting in an item aggregate failure.
Like the Universal Product Code (UPC), the National Drug Code (NDC) is a unique 10-digit, 3-segment number. It is a universal product identifier for human drugs in the United States. The code is present on all nonprescription (OTC) and prescription medication packages and inserts in the US. Being able to see the NDC# in the displays of BTI could be as important as the UPC# for the pharmaceutical company's.
The X12 Standard uses this code list to represent NDC#'s:
10 Digit format
N1 NATIONAL DRUG CODE IN 4-4-2 FORMAT
N2 NATIONAL DRUG CODE IN 5-3-2 FORMAT
N3 NATIONAL DRUG CODE IN 5-4-1 FORMAT
11 Digit format
N4 NATIONAL DRUG CODE IN 5-4-2 FORMAT
It should be noted that many National Drug Code (NDC) are displayed on drug packing in a 10-digit format. Proper billing of a National Drug Code (NDC) requires an 11-digit number in a 5-4-2 format (N4 EDI code).
The NDC# is divided in 3-segments.
The first segment identifies the product labeler:
the repackager or distributer of the product
The second segment identifies the product itself:
drug specific strength
The third segment identifies the package size and type.
attached document contains a graphic representation of the 10-digit code and the conversion table between 10-digit and 11-digit format
How will this idea be used?
As Gina, who works for a OTC drug manufacturer, I would like BTI to use the NDC# as part of the Item aggregate process and to display the NDC# / Part# in the document Item Milestone panel.
Purchase Order Data Samples of use:
side thought - There might be certain circumstances when both NDC# and UPC#, are present in the EDI data. As Gina, I will need to have UPC#, NDC#, and Part# displayed in the Item Milestone panel.
|What is your industry?||Consumer Products|
|What is the idea priority?||Medium|