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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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` SET3 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` SET3 SET4 BIN_GROUP	Alpha 7	—	IC00.1, IC01.1, IC01.2, IC01.3, IC01.4, IC04.1, IC10.2, IC12.1 +16 more
#`IAU-BIN` SET3 SET5 BIN	Alpha 7	—	IC00.1, IC01.1, IC01.2, IC01.3, IC01.4, IC04.1, IC10.2, IC12.1 +16 more

Indexes (5)

Keys are listed in index order; ↓ marks a descending key. 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

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)

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

ICAUDIT – Item/Item Location Audit

About ICAUDIT

Fields (15) Copy as SQL

Indexes (5)

Relations

One to one (8) — lookups and parents

Programs

Updated by (45)

Referenced by (3)

Fields (15)