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 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
|