ICACCURACY – Inventory Accuracy Statistics
- System
- Inventory Control (IC)
- Prefix
ACC- Primary key
COMPANY,LOCATION,YEAR,PERIOD,REASON-CODE- Fields
- 13
- Updated by
- 3 programs
- Referenced by
- 2 programs
ICACCURACY is the Inventory Accuracy Statistics table in Lawson Inventory Control (prefix ACC). It is indexed by COMPANY, LOCATION, YEAR, PERIOD, REASON-CODE (ACCSET1). It is related 1:1 to ICCOMPANY, ICLOCATION and REASON. It is updated by IC175, IC300 and IC76.1 and referenced by IC284 and IC286. The table has 13 fields, 1 index and 3 documented relations.
About ICACCURACY
The Inventory Accuracy Statistics file is a physical inventory file used to track the accuracy of the physical inventory process. When a variance update is run, the file is updated with the number of items that were counted and with the number of items that had variances.
Fields (13)
Column = COBOL field name without the ACC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
ACC-COMPANY PKCOMPANY | 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. | IC175, IC76.1 |
ACC-LOCATION PKLOCATION | Alpha 5 | This field contains a valid stocking location within the company inventory. | IC175, IC76.1 |
ACC-YEAR PKYEAR | Numeric 4 | This field contains a valid inventory year for the company. | IC175, IC76.1 |
ACC-PERIOD PKPERIOD | Numeric 2 | This field contains a valid inventory period for the company. | IC175, IC76.1 |
ACC-REASON-CODE PKREASON_CODE | Alpha 4 | This field is used to enter any physical inventory transactions to explain the reason for a count variance. | IC175, IC76.1 |
ACC-COUNT-1-ITEMSCOUNT_1_ITEMS | Numeric 6 | This field contains the total number of movement class 1 items counted for the period or year. | IC175, IC76.1 |
ACC-COUNT-2-ITEMSCOUNT_2_ITEMS | Numeric 6 | This field contains the total number of movement class 2 items counted for the period or year. | IC175, IC76.1 |
ACC-COUNT-3-ITEMSCOUNT_3_ITEMS | Numeric 6 | This field contains the total number of movement class 3 items counted for the period or year. | IC175, IC76.1 |
ACC-COUNT-X-ITEMSCOUNT_X_ITEMS | Numeric 6 | This field contains the total number of special cycle count items counted for the period or year. | IC175, IC76.1 |
ACC-ERROR-1-ITEMSERROR_1_ITEMS | Numeric 6 | This field contains the total number of movement class 1 items that were counted which showed a variance for the period or year. | IC175, IC76.1 |
ACC-ERROR-2-ITEMSERROR_2_ITEMS | Numeric 6 | This field contains the total number of movement class 2 items that were counted which showed a variance for the period or year. | IC175, IC76.1 |
ACC-ERROR-3-ITEMSERROR_3_ITEMS | Numeric 6 | This field contains the total number of movement class 3 items that were counted which showed a variance for the period or year. | IC175, IC76.1 |
ACC-ERROR-X-ITEMSERROR_X_ITEMS | Numeric 6 | This field contains the total number of special cycle count items that were counted which showed a variance for the period or year. | IC175, IC76.1 |
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 |
|---|---|---|---|---|
ACCSET1 | COMPANY, LOCATION, YEAR, PERIOD, REASON-CODE | Primary | IC175, IC284, IC286, IC300, IC76.1 |
Relations
One to one (3) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Company | ICCOMPANY | Required | ACC-COMPANY → ICC-COMPANY | |
| Location | ICLOCATION | Required | ACC-COMPANY → ICL-COMPANY, ACC-LOCATION → ICL-LOCATION | |
| Reason | REASON | Not Required | ACC-COMPANY → REA-COMPANY, ACC-REASON-CODE → REA-REASON-CODE |