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 |
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. |
|
||
ACC-LOCATION Element: Location | Alpha 5 This field contains a valid stocking location within the company inventory. |
|
||
ACC-YEAR Element: Year | Numeric 4 This field contains a valid inventory year for the company. |
|
||
ACC-PERIOD Element: Period | Numeric 2 This field contains a valid inventory period for the company. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ACCSET1 |
COMPANY LOCATION YEAR PERIOD REASON-CODE |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
---|---|---|---|---|---|---|---|---|
Company | ICCOMPANY |
Required
| ||||||
Location | ICLOCATION |
Required
| ||||||
Reason | REASON |
Not Required
|
All trademarks and registered trademarks are the property of their
respective owners.