ICDICT – Item/Item Location Dictionary

System: Inventory Control (IC)
Prefix: IDI
Primary key: FLD-NBR
Fields: 8
Updated by: 1 program
Referenced by: 27 programs

ICDICT is the Item/Item Location Dictionary table in Lawson Inventory Control (prefix IDI). It is indexed by FLD-NBR (IDISET1). It is updated by IC180 and referenced by IC00.1, IC01.1, IC10.1, IC10.2, IC11.1, IC12.1, IC120, IC183 and 19 more. The table has 8 fields, 1 index and 0 documented relations.

About ICDICT

The Item/Item Location Dictionary file is a file of all Item Master and Item Location fields that can be selected for user-defined item maintenance and inquiry formats. Initially, IC180 (Dictionary Setup) must be run once to load this file.

Fields (8)

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

Field / column	Type	Description & values	Updated by
`IDI-FLD-NBR` PK FLD_NBR	Numeric 4	This field contains a unique number assigned to the field.	IC180
`IDI-FLD-NAME` FLD_NAME	Alpha 15	This field contains the database field name.	IC180
`IDI-DB-FILE` DB_FILE	Alpha 3	This field identifies the file related to the field name. `ITE` Item Master File (ITEMMAST) `ITL` Item Location File (ITEMLOC) `ITM` Item Source File (ITEMSRC) `ICA` GL Category File (ICCATEGORY) `ICL` IC Location (ICLOCATION) `ILA` IC Location Group (ICLOCGRP) `HCI` Patient Charge Item HCCRGITEM	IC180
`IDI-PROMPT` PROMPT	Alpha 20	This field contains the name for the field that displays on forms or prints on reports identifying the field.	IC180
`IDI-DATA-TYPE` DATA_TYPE	Alpha 1	This field indicates whether the field is alphanumeric or numeric. `A` Alpha `N` Numeric	IC180
`IDI-SIZE` SIZE	Numeric 3	This field contains the size of the database field.	IC180
`IDI-DECIMALS` DECIMALS	Numeric 1	This field contains the number of decimals in the database field.	IC11.1, IC180
`IDI-REQUIRED-FL` REQUIRED_FL	Alpha 1	This field indicates whether the database field is required. `N` No `Y` Yes	IC180

Indexes (1)

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

Index	Keys	Flags	Condition	Used in
`IDISET1`	`FLD-NBR`	Primary		IC00.1, IC01.1, IC10.1, IC10.2, IC11.1, IC12.1, IC120, IC180 +20 more

Programs

Updated by (1)

IC180 Dictionary Setup

Referenced by (27)

IC00.1 Corporate Item Group
IC01.1 Company
IC10.1 Item Formats
IC10.2 Item Master and Location
IC11.1 Item Master
IC12.1 Item Location
IC120 Economic Order Quantity and Reorder Calculation
IC183 Par Level Load
IC189 Bin Audit Report
IC191 Item Master Audit Trail
IC192 Item Location Audit Trail
IC193 IC Location Audit Report
IC194 GL Category Audit Report
IC198 Bin Group Audit Report
IC290 Item Format Listing
IC330 Item Mass Change
IC331 Par Cart Mass Changes
IC35.1 Inquiry Formats
IC36.1 User Defined Item Inquiry
IC81.1 Cart, Par Location
IC82.1 Par Location Item Mass Change
IC91.1 Item Audit Inquiry
IC91.2 Item Location and Item Source Audit Inquiry
IC91.3 GL Category Audit Inquiry
IC92.1 IC Location Audit Inquiry
IC93.1 Bin Audit
IC93.2 Bin Group Audit