ITEMNDC – Item National Drug Code

System: Inventory Control (IC)
Prefix: IDC
Primary key: ITEM-GROUP, ITEM, NDC-NBR
Fields: 14
Updated by: 10 programs
Referenced by: 12 programs

ITEMNDC is the Item National Drug Code table in Lawson Inventory Control (prefix IDC). It is indexed by ITEM-GROUP, ITEM, NDC-NBR (IDCSET1); alternate indexes: IDCSET2, IDCSET5 and IDCSET6. It is related 1:1 to ITEMMAST. It is updated by ICIC.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8, PO28.2 and 2 more and referenced by IC11.1, IC11.6, IC511, IC598, IC800, ICI8.1, RQIC.1, RQID.1 and 4 more. The table has 14 fields, 4 indexes and 1 documented relation.

About ITEMNDC

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

Fields (14)

Column = COBOL field name without the IDC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`IDC-ITEM-GROUP` PK ITEM_GROUP	Alpha 5	This field contains the identifier for a group of items that can be shared by one or more companies.	ICI8.1, ICIC.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more
`IDC-ITEM` PK ITEM	Alpha 32	This field contains the item identifier.	ICI8.1, ICIC.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more
`IDC-NDC-NBR` PK NDC_NBR	Alpha 15	National Drug Code.	ICI8.1, ICIC.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more
`IDC-UOM` UOM	Alpha 4	This field contains the valid stock unit of measure for this item.	ICI8.1, ICIC.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more
`IDC-MDPRODDESC` MDPRODDESC	Alpha 30	Generic Name for the drug	ICI8.1, ICIC.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1
`IDC-MDSTRENGTH` MDSTRENGTH	Alpha 10	Drug strength.	ICI8.1, ICIC.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1
`IDC-MDDOSEFORM` MDDOSEFORM	Alpha 10	Drug form, e.g. tabs, caps, suspension, etc.	ICI8.1, ICIC.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1
`IDC-MDPACKDESC` MDPACKDESC	Alpha 5	Container description, e.g. bottle, package, vial, etc.	ICI8.1, ICIC.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1
`IDC-MDPACKSIZE` MDPACKSIZE	Signed 13.4	The count per container.	ICI8.1, ICIC.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1
`IDC-MFGBY` MFGBY	Alpha 10	Manufacturer identifier.	ICI8.1, ICIC.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1
`IDC-UNITDOSE-FL` UNITDOSE_FL	Alpha 1	Identifies item as a unit dose version. `Y` Yes `N` No	ICI8.1, ICIC.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1
`IDC-BRAND-NAME` BRAND_NAME	Alpha 35 (Lower Case)	—	ICI8.1, ICIC.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1
`IDC-DRUG-NAME` DRUG_NAME	Alpha 32	—	ICI8.1, ICIC.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1
`IDC-ITEM-TYPE-NDC` ITEM_TYPE_NDC	Derived	—	—

Indexes (4)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Used in
`IDCSET1`	`ITEM-GROUP`, `ITEM`, `NDC-NBR`	Primary	IC11.1, IC11.6, IC511, IC800, ICI8.1, ICIC.1, PO150, PO25.6 +10 more
`IDCSET2`	`NDC-NBR`, `ITEM-GROUP`		ICI8.1, ICIC.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more
`IDCSET5`	`ITEM-GROUP`, `ITEM`, `UOM`, `NDC-NBR`	KeyChange	IC11.1, IC598, ICI8.1, ICIC.1, RQIC.1, RQID.1, RQIF.1, RQIG.1 +2 more
`IDCSET6`	`ITEM-GROUP`, `NDC-NBR`		ICI8.1, ICIC.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Itemndctoitem	ITEMMAST	Required		`IDC-ITEM-GROUP` → `ITE-ITEM-GROUP`, `IDC-ITEM` → `ITE-ITEM`

Programs

Updated by (10)

ICIC.1 ITEMNDC Invoked Object
PO150 Bid Load to Contract or Catalog
PO25.6 Vendor Agreement Line
PO25.7 Service Agreement Line
PO26.4 Vendor Agreement Line Price Breaks
PO26.5 Vendor Agreement Line Price Breaks
PO26.8 Update Vendor Agreement Line for Special Item
PO28.2 Vendor Agreement Line Detail List
PO36.2 Vendor Agreement Import Manual Input
PO536 Vendor Price Agreement Load

Referenced by (12)

IC11.1 Item Master
IC11.6 National Drug Code
IC511 Item Master-Item Location Extr
IC598 Bin Label Export
IC800 Keyword Search Load
ICI8.1 ITEMUPC Invoked Object
RQIC.1 Get Item List Invoke Object
RQID.1 RQRQHUPD Invoke Object
RQIF.1 RQRLNUPD Invoke Object
RQIG.1 Get Shopping List Invoke Object
RQIH.1 Invoke Determine Express Data
RQIJ.1 Requisition Copy