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 ICI8.1 RQID.1 RQIF.1 RQIH.1 RQIJ.1
IC598
UPDATED BY
PO150 PO25.6 PO25.7 PO36.2 PO536
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IDC-ITEM-GROUP Alpha 5 ICI8.1 PO150
Element: Item Group This field contains the identifier for PO25.6 PO25.7
a group of items that can be shared by PO36.2 PO536
one or more companies. RQID.1 RQIF.1
RQIH.1 RQIJ.1
IDC-ITEM Alpha 32 ICI8.1 PO150
Element: Item Number This field contains the item PO25.6 PO25.7
identifier. PO36.2 PO536
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IDC-NDC-NBR Alpha 15 ICI8.1 PO150
Element: National Drug National Drug Code. PO25.6 PO25.7
PO36.2 PO536
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IDC-UOM Alpha 4 ICI8.1 PO150
Element: Unit of MeasurThis field contains the valid stock PO25.6 PO25.7
unit of measure for this item. PO36.2 PO536
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IDC-UOM-COST Signed 13.5 ICI8.1 RQID.1
Element: Unit of MeasurUnit of measure cost. RQIF.1 RQIH.1
RQIJ.1
IDC-UOM-QTY Signed 13.4 ICI8.1 RQID.1
Unit of Measure Unit of measure quantity. RQIF.1 RQIH.1
Quantity RQIJ.1
IDC-PHAR-OHQ Signed 13.4 ICI8.1 RQID.1
Pharmacy's On-hand Pharmacy's on-hand quantity. RQIF.1 RQIH.1
Quantity RQIJ.1
IDC-DESCRIPTION-PH Alpha 60 ICI8.1 RQID.1
Pharmacy's Phamacy's description. RQIF.1 RQIH.1
Description RQIJ.1
IDC-OLD-NDC Alpha 15 ICI8.1 RQID.1
Old National Drug Old National Drug Code. RQIF.1 RQIH.1
Code RQIJ.1
IDC-ORDER-MULT Numeric 4 ICI8.1 RQID.1
Element: Order MultipleDesignate quantity for the order RQIF.1 RQIH.1
multiple. Indicates that the reorder RQIJ.1
quantity should be a multiple of this
quantity.
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 ICI8.1
ITEM PO150 PO25.6
NDC-NBR PO25.7 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IDCSET2 NDC-NBR ICI8.1 PO150
ITEM-GROUP PO25.6 PO25.7
PO36.2 PO536
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IDCSET5 ITEM-GROUP KeyChange IC598 ICI8.1
ITEM RQID.1 RQIF.1
UOM RQIH.1 RQIJ.1
NDC-NBR
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
ITEMNDC FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Ndctopharitem PHARITEM
IDC-NDC-NBR -> PHI-NDC-NBR
PHI-UPC
PHI-COMPANY
PHI-LOCATION
|