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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IDC-ITEM-GROUP Alpha 5 ICI8.1
Item Group This field contains the identifier for
a group of items that can be shared by
one or more companies.
IDC-ITEM Alpha 32 ICI8.1
Item Number This field contains the item
identifier.
IDC-NDC-NBR Alpha 15 ICI8.1
National Drug Code National Drug Code.
IDC-UOM Alpha 4 ICI8.1
Unit of Measure This field contains the valid stock
unit of measure for this item.
IDC-UOM-COST Signed 13.5 ICI8.1
Unit of Measure Cost Unit of measure cost.
IDC-UOM-QTY Signed 13.4 ICI8.1
Unit of Measure Unit of measure quantity.
Quantity
IDC-PHAR-OHQ Signed 13.4 ICI8.1
Pharmacy's On-hand Pharmacy's on-hand quantity.
Quantity
IDC-DESCRIPTION-PH Alpha 60 ICI8.1
Pharmacy's Phamacy's description.
Description
IDC-OLD-NDC Alpha 15 ICI8.1
Old National Drug Old National Drug Code.
Code
IDC-ORDER-MULT Numeric 4 ICI8.1
Order Multiple Designate quantity for the order
multiple. Indicates that the reorder
quantity should be a multiple of this
quantity.
ITEMNDC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IDCSET1 ITEM-GROUP IC11.1 ICI8.1
ITEM
NDC-NBR
IDCSET2 NDC-NBR ICI8.1
IDCSET5 ITEM-GROUP ICI8.1
ITEM
UOM
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
|
