ICICLAUDIT – The IC Location Audit table is created as a result of choosing the audit option in IC01.1 (IC Company).

System: Inventory Control (IC)
Prefix: ILA
Primary key: COMPANY, LOCATION, SYSTEM-CD, SEQ, DATE, TIME, FLD-NBR
Fields: 11
Updated by: 17 programs
Referenced by: 1 program

ICICLAUDIT is the The IC Location Audit table is created as a result of choosing the audit option in IC01.1 (IC Company). table in Lawson Inventory Control (prefix ILA). It is indexed by COMPANY, LOCATION, SYSTEM-CD, SEQ, DATE, TIME, FLD-NBR (ILASET1). It is related 1:1 to ICDICT, ICLOCATION and ICLOCGRP. It is updated by AP510, IC02.1, IC02.2, IC193, IC64.1, IC64.2, IC64.3, IC64.4 and 9 more and referenced by IC92.1. The table has 11 fields, 1 index and 3 documented relations.

About ICICLAUDIT

The IC Location Audit table is created as a result of choosing the audit option in IC01.1 (IC Company). When this option is selected, entries to the table are added whenever changes are made to an IC Location.

Fields (11)

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

Field / column	Type	Description & values	Updated by
`ILA-COMPANY` PK COMPANY	Numeric 4	—	AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
`ILA-LOCATION` PK LOCATION	Alpha 5	—	AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
`ILA-SYSTEM-CD` PK SYSTEM_CD	Alpha 2	—	AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
`ILA-SEQ` PK SEQ	Numeric 3	—	AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
`ILA-DATE` PK DATE	Numeric 8 (yyyymmdd)	—	AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
`ILA-TIME` PK TIME	Numeric 8	—	AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
`ILA-FLD-NBR` PK FLD_NBR	Numeric 4	—	AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
`ILA-BEFORE-IMAGE` BEFORE_IMAGE	Alpha 60	—	AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
`ILA-AFTER-IMAGE` AFTER_IMAGE	Alpha 60	This field contains the field image after the change.	AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
`ILA-OPERATOR` OPERATOR	Alpha 10	—	AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more
`ILA-FLD-DESC` FLD_DESC	Derived	—	—

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
`ILASET1`	`COMPANY`, `LOCATION`, `SYSTEM-CD`, `SEQ`, `DATE`, `TIME`, `FLD-NBR`	Primary		AP510, IC02.1, IC02.2, IC193, IC64.1, IC64.2, IC64.3, IC64.4 +10 more

Relations

One to one (3) — lookups and parents

Relation	Table	Rules	Field map
Icdict	ICDICT	Required	`ILA-FLD-NBR` → `IDI-FLD-NBR`
Iclocation	ICLOCATION	Required	`ILA-COMPANY` → `ICL-COMPANY`, `ILA-LOCATION` → `ICL-LOCATION`
Iclocgrp	ICLOCGRP	Not Required	`ILA-COMPANY` → `ILG-COMPANY`, `ILA-LOCATION` → `ILG-LOCATION`, `ILA-SYSTEM-CD` → `ILG-SYSTEM-CD`, `ILA-SEQ` → `ILG-SEQ`

Programs

Updated by (17)

AP510 Vendor Conversion
IC02.1 Location
IC02.2 Substitute Locations
IC193 IC Location Audit Report
IC64.1 Global Location Nbr Assignment GL/IC Company
IC64.2 Global Location Nbr Assignment IC Location
IC64.3 Global Location Number Assignment RQ Location
IC64.4 Global Location Number Assignment Manuf Code
IC64.5 Global Location Number Assignment Manuf Div
IC64.6 Global Location Number Assignment Vendor
IC64.7 Global Location Number Assignment Vendor Location
IC64.8 Global Location Number Assignment IC Bin
IC64.9 Global Location Number Assignment Buyer
IC802 Locations to LRO via BCI
IC81.1 Cart, Par Location
IC840 Cart Par Location Conversion
TX140 Vertex Geocode Update

Referenced by (1)

IC92.1 IC Location Audit Inquiry