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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#ILA-COMPANY PKCOMPANY | Numeric 4 | — | AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
#ILA-LOCATION PKLOCATION | Alpha 5 | — | AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
#ILA-SYSTEM-CD PKSYSTEM_CD | Alpha 2 | — | AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
#ILA-SEQ PKSEQ | Numeric 3 | — | AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
#ILA-DATE PKDATE | Numeric 8 (yyyymmdd) | — | AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
#ILA-TIME PKTIME | Numeric 8 | — | AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
#ILA-FLD-NBR PKFLD_NBR | Numeric 4 | — | AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
#ILA-BEFORE-IMAGEBEFORE_IMAGE | Alpha 60 | — | AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
#ILA-AFTER-IMAGEAFTER_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-OPERATOROPERATOR | Alpha 10 | — | AP510, IC02.1, IC02.2, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5 +8 more |
#ILA-FLD-DESCFLD_DESC | Derived | — | — |
Indexes (1)
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 |
|---|---|---|---|---|
ILASET1 |
| 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 | Condition | Field map | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Icdict | ICDICT | Required |
| |||||||||||||
| Iclocation | ICLOCATION | Required |
| |||||||||||||
| Iclocgrp | ICLOCGRP | Not Required |
|
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