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
Company The company number represents an
established company and is entered on
all function codes.
ACC-LOCATION Alpha 5 IC175 IC76.1
Location Code This field contains a valid stocking
location within the company inventory.
ACC-YEAR Numeric 4 IC175 IC76.1
Last Closed Year This field contains a valid inventory
year for the company.
ACC-PERIOD Numeric 2 IC175 IC76.1
Last Closed Period This field contains a valid inventory
period for the company.
ACC-REASON-CODE Alpha 4 IC175 IC76.1
Reason Code This field is used to enter any
physical inventory transactions to
explain the reason for a count variance.
ACC-COUNT-1-ITEMS Numeric 6 IC175 IC76.1
Nbr of Class 1 This field contains the total number of
Items Counted movement class 1 items counted for the
period or year.
ACC-COUNT-2-ITEMS Numeric 6 IC175 IC76.1
Nbr of Class 2 This field contains the total number of
Items Counted movement class 2 items counted for the
period or year.
ACC-COUNT-3-ITEMS Numeric 6 IC175 IC76.1
Nbr of Class 3 This field contains the total number of
Items Counted movement class 3 items counted for the
period or year.
ACC-COUNT-X-ITEMS Numeric 6 IC175 IC76.1
Nbr of Class X This field contains the total number of
Items Counted 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 2 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 3 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 X 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
|
