ICACCURACY

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
Element: Company
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
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
IC175 IC76.1
ACC-YEAR
Element: Year
Numeric 4
This field contains a valid inventory year for the company.
IC175 IC76.1
ACC-PERIOD
Element: Period
Numeric 2
This field contains a valid inventory period for the company.
IC175 IC76.1
ACC-REASON-CODE
Element: Reason 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-ITEMS
Element: Item Count
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-ITEMS
Element: Item Count
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-ITEMS
Element: Item Count
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-ITEMS
Element: Item Count
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-ITEMS
Element: Error 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-ITEMS
Element: Error 1 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-ITEMS
Element: Error 1 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-ITEMS
Element: Error 1 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


ICACCURACY FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACCSET1 COMPANY
LOCATION
YEAR
PERIOD
REASON-CODE
IC175 IC284
IC286 IC300
IC76.1


ICACCURACY FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:16:49 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.