Watson Supply Chain Ideas

Submit new product ideas for Watson Supply Chain 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

Submit ideas for other Watson Customer Engagement Products:

Watson Marketing
Watson Campaign Automation
Watson Commerce

National Drug Code (NDC) implementation for Business Transaction Intelligence to aggregate and display NDC#'s

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 manufacturer
the marketer
the repackager or distributer of the product
The second segment identifies the product itself:
drug specific strength
dosage form
drug formula
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

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Mar 22 2019
  • Needs More Information
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:
PO1**2*CT*9750**ND*65293000101~
PO1*14*576*EA*490.52**N4*00781234301*VN*10167988~
PO1**12*EA*18**N4*61314063136*VN*61314063136*IN*137421~
PO1*4*192*EA*12.5**ND*00781552831*UP*307815528317*VN*00781552831*IN*327932~
PO1*10*1296*EA*577.6**N4*00781223410*IN*5468814|
PO1*00220*612*EA*24.72**N1*00168009915~

 

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
DeveloperWorks ID
RTC ID
Link to original RFE
  • Attach files
  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    20 May 12:08

    Sure, I can help out with additional information.  Do you have a specific area of concern? Or specific questions I can answer for you?