ICAUDIT – Item/Item Location Audit

System: Inventory Control (IC)
Prefix: IAU
Primary key: ITEM-GROUP, COMPANY, LOCATION, ITEM, GL-CATEGORY, DATE, TIME, FLD-NBR
Fields: 15
Updated by: 45 programs
Referenced by: 3 programs

ICAUDIT is the Item/Item Location Audit table in Lawson Inventory Control (prefix IAU). It is indexed by ITEM-GROUP, COMPANY, LOCATION, ITEM, GL-CATEGORY, DATE, TIME, FLD-NBR (IAUSET1); alternate indexes: IAUSET2, IAUSET3, IAUSET4 and IAUSET5. It is related 1:1 to ICCATEGORY, ICCOMPANY, ICDICT, ITEMGROUP, ITEMLOC, ITEMMAST and ICLOCATION. It is updated by IC00.1, IC01.1, IC01.2, IC01.3, IC01.4, IC04.1, IC10.2, IC11.1 and 37 more and referenced by IC524, IC93.1 and IC93.2. The table has 15 fields, 5 indexes and 8 documented relations.

About ICAUDIT

The Item/Item Location Audit file is created as a result of choosing the audit options in IC00.1 (Corporate Item Group) and/or IC01.1 (Company). When the options are selected, the file is updated whenever a change is made to either the Item Master or the Item Location Master file.

Fields (15)

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

Field / column	Type	Description & values	Updated by
`IAU-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.	IC00.1, IC01.1, IC01.2, IC01.3, IC01.4, IC04.1, IC10.2, IC11.1 +26 more
`IAU-COMPANY` PK COMPANY	Numeric 4	Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	IC00.1, IC01.1, IC01.2, IC01.3, IC01.4, IC04.1, IC10.2, IC11.1 +26 more
`IAU-LOCATION` PK LOCATION	Alpha 5	This field contains a valid stocking location within the company inventory.	IC00.1, IC01.1, IC01.2, IC01.3, IC01.4, IC04.1, IC10.2, IC11.1 +26 more
`IAU-ITEM` PK ITEM	Alpha 32	This field contains the item's identifier.	IC00.1, IC01.1, IC01.2, IC01.3, IC01.4, IC04.1, IC10.2, IC11.1 +26 more
`IAU-GL-CATEGORY` PK GL_CATEGORY	Alpha 4	—	IC00.1, IC01.1, IC01.2, IC01.3, IC01.4, IC04.1, IC10.2, IC12.1 +16 more
`IAU-DATE` PK DATE	Numeric 8 (yyyymmdd)	This field contains the system date when the audit record was created.	IC00.1, IC01.1, IC01.2, IC01.3, IC01.4, IC04.1, IC10.2, IC11.1 +26 more
`IAU-TIME` PK TIME	Numeric 8	This field contains the system time when the audit record was created.	IC00.1, IC01.1, IC01.2, IC01.3, IC01.4, IC04.1, IC10.2, IC11.1 +26 more
`IAU-FLD-NBR` PK FLD_NBR	Numeric 4	This field contains a unique number assigned to a field that identifies the description of the field.	IC00.1, IC01.1, IC01.2, IC01.3, IC01.4, IC04.1, IC10.2, IC11.1 +26 more
`IAU-BEFORE-IMAGE` BEFORE_IMAGE	Alpha 350 (Lower Case)	This field contains the field image before the change.	IC00.1, IC01.1, IC01.2, IC01.3, IC01.4, IC04.1, IC10.2, IC11.1 +26 more
`IAU-AFTER-IMAGE` AFTER_IMAGE	Alpha 350 (Lower Case)	This field contains the field image after the change.	IC00.1, IC01.1, IC01.2, IC01.3, IC01.4, IC04.1, IC10.2, IC11.1 +26 more
`IAU-DB-FILE` DB_FILE	Alpha 3	This field identifies which file is being maintained by this audit record. `ITE` Item Master File (ITEMMAST) `ITL` Item Location File (ITEMLOC) `ITM` Item Source File (ITEMSRC) `ICA` GL Category File (ICCATEGORY) `ICB` IC Bin (ICBIN) `BGD` Bin Group Detail (BINGRPDTL) `ITG` Item Group File (ITEMGROUP) `ICC` IC Company File (ICCOMPANY)	IC00.1, IC01.1, IC01.2, IC01.3, IC01.4, IC04.1, IC10.2, IC11.1 +26 more
`IAU-OPERATOR-ID` OPERATOR_ID	Alpha 10	This field contains the terminal sign on when this update was performed to the database.	IC00.1, IC01.1, IC01.2, IC01.3, IC01.4, IC04.1, IC10.2, IC11.1 +25 more
`IAU-FLD-DESC` FLD_DESC	Derived	—	—
`IAU-BIN-GROUP` BIN_GROUP	Alpha 7	—	IC00.1, IC01.1, IC01.2, IC01.3, IC01.4, IC04.1, IC10.2, IC12.1 +16 more
`IAU-BIN` BIN	Alpha 7	—	IC00.1, IC01.1, IC01.2, IC01.3, IC01.4, IC04.1, IC10.2, IC12.1 +16 more

Indexes (5)

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
`IAUSET1`	`ITEM-GROUP`, `COMPANY`, `LOCATION`, `ITEM`, `GL-CATEGORY`, `DATE`, `TIME`, `FLD-NBR`	Primary		IC00.1, IC01.1, IC01.2, IC01.3, IC01.4, IC04.1, IC10.2, IC12.1 +22 more (list truncated in source)
`IAUSET2`	`DATE`, `TIME`, `ITEM-GROUP`, `COMPANY`, `LOCATION`, `ITEM`, `GL-CATEGORY`, `FLD-NBR`			—
`IAUSET3`	`DATE`, `TIME`, `DB-FILE`, `COMPANY`, `LOCATION`, `BIN-GROUP`, `BIN`, `FLD-NBR`	Subset	Where BIN-GROUP != Spaces	IC00.1, IC01.1, IC01.2, IC01.3, IC01.4, IC04.1, IC10.2, IC12.1 +16 more
`IAUSET4`	`COMPANY`, `LOCATION`, `BIN-GROUP`, `DATE`, `TIME`, `FLD-NBR`	Subset	Where BIN-GROUP != Spaces	IC198, IC93.2
`IAUSET5`	`COMPANY`, `LOCATION`, `BIN`, `DATE`, `TIME`, `FLD-NBR`	Subset	Where BIN != Spaces	IC189, IC93.1

Relations

One to one (8) — lookups and parents

Relation	Table	Rules	Condition	Field map
Iccategory	ICCATEGORY	Not Required	Valid When IAU-GL-CATEGORY != Spaces	`IAU-COMPANY` → `ICA-COMPANY`, `IAU-LOCATION` → `ICA-LOCATION`, `IAU-GL-CATEGORY` → `ICA-GL-CATEGORY`
Iccompany	ICCOMPANY	Required	When IAU-COMPANY != Zeroes	`IAU-COMPANY` → `ICC-COMPANY`
Icdict	ICDICT	Required		`IAU-FLD-NBR` → `IDI-FLD-NBR`
Itemgroup	ITEMGROUP	Required	When IAU-ITEM-GROUP != Spaces	`IAU-ITEM-GROUP` → `ITG-ITEM-GROUP`
Itemloc	ITEMLOC	Not Required	Valid When IAU-COMPANY != Zeroes And IAU-GL-CATEGORY = Spaces	`IAU-COMPANY` → `ITL-COMPANY`, `IAU-ITEM` → `ITL-LOCATION`, `IAU-ITEM` → `ITL-ITEM`
Itemmast	ITEMMAST	Not Required	Valid When IAU-ITEM-GROUP != Spaces	`IAU-ITEM-GROUP` → `ITE-ITEM-GROUP`, `IAU-ITEM` → `ITE-ITEM`
Itemmast2	ITEMMAST	Not Required	Valid When IAU-COMPANY != Zeroes And IAU-GL-CATEGORY = Spaces	`ICC-ITEM-GROUP` → `ITE-ITEM-GROUP`, `IAU-ITEM` → `ITE-ITEM`
Location	ICLOCATION	Required		`IAU-COMPANY` → `ICL-COMPANY`, `IAU-LOCATION` → `ICL-LOCATION`

Programs

Updated by (45)

IC00.1 Corporate Item Group
IC01.1 Company
IC01.2 Period End Dates
IC01.3 Bin Usage Types
IC01.4 Report Options
IC04.1 General Ledger Category
IC10.2 Item Master and Location
IC11.1 Item Master
IC12.1 Item Location
IC12.2 Replenishment Setup
IC120 Economic Order Quantity and Reorder Calculation
IC15.2 Bins
IC15.3 Bin Groups
IC150 Movement Analysis - Cost
IC151 Movement Analysis - Sales
IC152 Movement Analysis - GMROI
IC183 Par Level Load
IC189 Bin Audit Report
IC191 Item Master Audit Trail
IC192 Item Location Audit Trail
IC194 GL Category Audit Report
IC196 Item Group Audit Report
IC197 IC Company Audit Report
IC198 Bin Group Audit Report
IC320 Mass Item Location Copy
IC330 Item Mass Change
IC331 Par Cart Mass Changes
IC512 Item Audit Extract
IC81.1 Cart, Par Location
IC811 Item Master Load
IC812 Item Location Load
IC82.1 Par Location Item Mass Change
IC840 Cart Par Location Conversion
IC841 General Ledger Category Conversion
IC91.3 GL Category Audit Inquiry
IC91.4 Item Group Audit Inquiry
IC91.5 IC Company Audit Inquiry
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
PO28.2 Vendor Agreement Line Detail List
PO36.2 Vendor Agreement Import Manual Input
PO536 Vendor Price Agreement Load

Referenced by (3)

IC524 CSV Item Master
IC93.1 Bin Audit
IC93.2 Bin Group Audit