Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICACCURACY


                            ICACCURACY FILE

                     Inventory Accuracy Statistics

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.

REFERENCED BY

IC284     IC286

UPDATED BY

IC175     IC300     IC76.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ACC-COMPANY            Numeric 4                                 IC175   IC76.1
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

ACC-LOCATION           Alpha 5                                   IC175   IC76.1
Element: Location Code This field contains a valid stocking
                       location within the company inventory.

ACC-YEAR               Numeric 4                                 IC175   IC76.1
Element: Last Closed YeThis field contains a valid inventory
                       year for the company.

ACC-PERIOD             Numeric 2                                 IC175   IC76.1
Element: Current PeriodThis field contains a valid inventory
                       period for the company.

ACC-REASON-CODE        Alpha 4                                   IC175   IC76.1
Accounts Receivable    This field is used to enter any
Code                   physical inventory transactions to
                       explain the reason for a count variance.

ACC-COUNT-1-ITEMS      Numeric 6                                 IC175   IC76.1
Element: Item Count    This field contains the total number of
                       movement class 1 items counted for the
                       period or year.

ACC-COUNT-2-ITEMS      Numeric 6                                 IC175   IC76.1
Element: Item Count    This field contains the total number of
                       movement class 2 items counted for the
                       period or year.

ACC-COUNT-3-ITEMS      Numeric 6                                 IC175   IC76.1
Element: Item Count    This field contains the total number of
                       movement class 3 items counted for the
                       period or year.

ACC-COUNT-X-ITEMS      Numeric 6                                 IC175   IC76.1
Element: Item Count    This field contains the total number of
                       special cycle count items counted for
                       the period or year.

ACC-ERROR-1-ITEMS      Numeric 6                                 IC175   IC76.1
Class 1 Items with     This field contains the total number of
Variance               movement class 1 items that were counted
                       which showed a variance for the period
                       or year.

ACC-ERROR-2-ITEMS      Numeric 6                                 IC175   IC76.1
Class 1 Items with     This field contains the total number of
Variance               movement class 2 items that were counted
                       which showed a variance for the period
                       or year.

ACC-ERROR-3-ITEMS      Numeric 6                                 IC175   IC76.1
Class 1 Items with     This field contains the total number of
Variance               movement class 3 items that were counted
                       which showed a variance for the period
                       or year.

ACC-ERROR-X-ITEMS      Numeric 6                                 IC175   IC76.1
Class 1 Items with     This field contains the total number of
Variance               special cycle count items that were
                       counted which showed a variance for the
                       period or year.

                         ICACCURACY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ACCSET1   COMPANY                                                IC175   IC284
          LOCATION                                               IC286   IC300
          YEAR                                                   IC76.1
          PERIOD
          REASON-CODE

                         ICACCURACY FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

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