# Table: Inventory Worksheet Headers

Table: ICWKUH
View: IC0790
Record length: 284
Flags: A R

## Keys: 2

Title | Flags | Fields
--- | --- | ---
Location/Sort Code/Item |  | LOCATION, SORTCODE, ITEMNO
Location/Item/Quantity Variance | M | LOCATION, ITEMNO, QTYVAR

## Fields: 19

Field | Type | Title | Presentation
--- | --- | --- | ---
LOCATION | String*6 | Location | Mask: %-6N
SORTCODE | String*60 | Sort Code |
ITEMNO | String*24 | Unformatted Item Number | Mask: %-24C
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
FMTITEMNO | String*24 | Item Number | Mask: %-24C
DESC | String*60 | Item Description |
PICKINGSEQ | String*10 | Picking Sequence |
QTYONHAND | BCD*10.4 | Quantity on Hand |
QTYCOUNTED | BCD*10.4 | Quantity Counted |
QTYVAR | BCD*10.4 | Quantity Variance |
STOCKUNIT | String*10 | Stocking Unit of Measure | Mask: %-10c
CALCCOST | BCD*10.6 | Estimated Unit Cost |
ADJCOST | BCD*10.6 | Adjustment Unit Cost |
COSTVAR | BCD*10.3 | Cost Variance |
ONHOLD | Integer | Status | List: 7 entries
1 | = | Ready to post
2 | = | On hold
3 | = | Item does not exist
4 | = | Non-stock item
5 | = | Item not allowed at location
6 | = | Insufficient quantity
7 | = | Item not active
VALUES | Long | Optional Fields |

This page was generated on 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.