Lawson Insight Technical Documentation |
|
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 RQIC.1 RQIG.1
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 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: Ndc Nbr 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: Uom This 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: Mdproddesc Generic Name for the drug RQID.1 RQIF.1
RQIH.1 RQIJ.1
IDC-MDSTRENGTH Alpha 10 ICI8.1 ICIC.1
Element: Mdstrength Drug strength. RQID.1 RQIF.1
RQIH.1 RQIJ.1
IDC-MDDOSEFORM Alpha 10 ICI8.1 ICIC.1
Element: Mddoseform Drug form, e.g. tabs, caps, suspension, RQID.1 RQIF.1
etc. RQIH.1 RQIJ.1
IDC-MDPACKDESC Alpha 5 ICI8.1 ICIC.1
Element: Mdpackdesc Container description, e.g. bottle, RQID.1 RQIF.1
package, vial, etc. RQIH.1 RQIJ.1
IDC-MDPACKSIZE Signed 13.4 ICI8.1 ICIC.1
Element: Mdpacksize The count per container. RQID.1 RQIF.1
RQIH.1 RQIJ.1
IDC-MFGBY Alpha 10 ICI8.1 ICIC.1
Element: Mfgby Manufacturer identifier. RQID.1 RQIF.1
RQIH.1 RQIJ.1
IDC-UNITDOSE-FL Alpha 1 ICI8.1 ICIC.1
Element: Unitdose Fl Identifies item as a unit dose version. RQID.1 RQIF.1
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 ICI8.1 ICIC.1
ITEM RQIC.1 RQID.1
UOM RQIF.1 RQIG.1
NDC-NBR RQIH.1 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
|