Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ITEMNDC


                              ITEMNDC FILE

                        Item National Drug Code

The Item NDC file contains the National Drug Codes related to an item in the
Item Master file.

REFERENCED BY

IC11.1    IC11.6    IC800     ICI8.1    RQID.1    RQIF.1
RQIH.1    RQIJ.1    IC598

UPDATED BY

ICIC.1    PO150     PO25.6    PO25.7    PO36.2    PO536

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IDC-ITEM-GROUP         Alpha 5                                   ICI8.1  ICIC.1
Element: Item Group    This field contains the identifier for    PO150   PO25.6
                       a group of items that can be shared by    PO25.7  PO36.2
                       one or more companies.                    PO536   RQID.1
                                                                 RQIF.1  RQIH.1
                                                                 RQIJ.1

IDC-ITEM               Alpha 32                                  ICI8.1  ICIC.1
Element: Item Number   This field contains the item              PO150   PO25.6
                       identifier.                               PO25.7  PO36.2
                                                                 PO536   RQID.1
                                                                 RQIF.1  RQIH.1
                                                                 RQIJ.1

IDC-NDC-NBR            Alpha 15                                  ICI8.1  ICIC.1
Element: National Drug National Drug Code.                       PO150   PO25.6
                                                                 PO25.7  PO36.2
                                                                 PO536   RQID.1
                                                                 RQIF.1  RQIH.1
                                                                 RQIJ.1

IDC-UOM                Alpha 4                                   ICI8.1  ICIC.1
Element: Unit of MeasurThis field contains the valid stock       PO150   PO25.6
                       unit of measure for this item.            PO25.7  PO36.2
                                                                 PO536   RQID.1
                                                                 RQIF.1  RQIH.1
                                                                 RQIJ.1

IDC-MDPRODDESC         Alpha 30                                  ICI8.1  ICIC.1
Element: Brand of Drug Generic Name for the drug                 RQID.1  RQIF.1
                                                                 RQIH.1  RQIJ.1

IDC-MDSTRENGTH         Alpha 10                                  ICI8.1  ICIC.1
Element: Drug Strength Drug strength.                            RQID.1  RQIF.1
                                                                 RQIH.1  RQIJ.1

IDC-MDDOSEFORM         Alpha 10                                  ICI8.1  ICIC.1
Element: Drug Form     Drug form, e.g. tabs, caps, suspension,   RQID.1  RQIF.1
                       etc.                                      RQIH.1  RQIJ.1


IDC-MDPACKDESC         Alpha 5                                   ICI8.1  ICIC.1
Container              Container description, e.g. bottle,       RQID.1  RQIF.1
Description            package, vial, etc.                       RQIH.1  RQIJ.1


IDC-MDPACKSIZE         Signed 13.4                               ICI8.1  ICIC.1
Element: Count per ContThe count per container.                  RQID.1  RQIF.1
                                                                 RQIH.1  RQIJ.1

IDC-MFGBY              Alpha 10                                  ICI8.1  ICIC.1
Element: Manufacturer  Manufacturer identifier.                  RQID.1  RQIF.1
                                                                 RQIH.1  RQIJ.1

IDC-UNITDOSE-FL        Alpha 1                                   ICI8.1  ICIC.1
Unit Dose Version      Identifies item as a unit dose version.   RQID.1  RQIF.1
Flag                   Y = Yes                                   RQIH.1  RQIJ.1
                       N = No

IDC-BRAND-NAME         Alpha 30                                  ICI8.1  ICIC.1
Element: Brand Name                                              RQID.1  RQIF.1
                                                                 RQIH.1  RQIJ.1

IDC-DRUG-NAME          Alpha 32                                  ICI8.1  ICIC.1
Element: Drug Name                                               RQID.1  RQIF.1
                                                                 RQIH.1  RQIJ.1

IDC-ITEM-TYPE-NDC      Derived
Element: Item Type Ndc

                         ITEMNDC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IDCSET1   ITEM-GROUP                                             IC11.1  IC11.6
          ITEM                                                   IC800   ICI8.1
          NDC-NBR                                                ICIC.1  PO150
                                                                 PO25.6  PO25.7
                                                                 PO36.2  PO536
                                                                 RQID.1  RQIF.1
                                                                 RQIH.1  RQIJ.1

IDCSET2   NDC-NBR                                                ICI8.1  ICIC.1
          ITEM-GROUP                                             PO150   PO25.6
                                                                 PO25.7  PO36.2
                                                                 PO536   RQID.1
                                                                 RQIF.1  RQIH.1
                                                                 RQIJ.1

IDCSET5   ITEM-GROUP    KeyChange                                IC598   ICI8.1
          ITEM                                                   ICIC.1  RQID.1
          UOM                                                    RQIF.1  RQIH.1
          NDC-NBR                                                RQIJ.1

IDCSET6   ITEM-GROUP                                             ICI8.1  ICIC.1
          NDC-NBR                                                RQID.1  RQIF.1
                                                                 RQIH.1  RQIJ.1

                         ITEMNDC FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Itemndctoitem  ITEMMAST     Required

                            IDC-ITEM-GROUP    -> ITE-ITEM-GROUP
                            IDC-ITEM          -> ITE-ITEM