# Table: Items

Table: ICITEM
View: IC0310
Record length: 796
Flags: A R

## Keys: 6

Title | Flags | Fields
--- | --- | ---
Item Number |  | ITEMNO
Category | M | CATEGORY, ITEMNO
Alternate Item Number | M | ALTSET, ITEMNO
Formatted Item Number |  | FMTITEMNO
Item Description | M | DESC, ITEMNO
Allow in Web Store | M | ALLOWONWEB, ITEMNO

## Fields: 39

Field | Type | Title | Presentation
--- | --- | --- | ---
ITEMNO | String*24 | Unformatted Item Number | Mask: %-24C
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
ALTSET | Long | Alternate Item Set Number |
DESC | String*60 | Description |
DATELASTMN | Date | Date Last Maintained |
INACTIVE | Boolean | Status | List: 2 entries
0 | = | Active
1 | = | Inactive
ITEMBRKID | String*6 | Structure Code | Mask: %-6N
FMTITEMNO | String*24 | Item Number | Mask: %-24C
CATEGORY | String*6 | Category | Mask: %-6N
CNTLACCT | String*6 | Account Set Code | Mask: %-6N
STOCKITEM | Boolean | Stock Item | List: 2 entries
0 | = | No
1 | = | Yes
STOCKUNIT | String*10 | Stocking Unit of Measure | Mask: %-10c
DEFPRICLST | String*6 | Default Price List Code | Mask: %-6N
UNITWGT | BCD*10.4 | Unit Weight |
PICKINGSEQ | String*10 | Default Picking Sequence |
SERIALNO | Boolean | Serial Numbers |
COMMODIM | String*16 | Commodity Number |
DATEINACTV | Date | Date Inactive |
SEGMENT1 | String*24 | Segment 1 |
SEGMENT2 | String*24 | Segment 2 |
SEGMENT3 | String*24 | Segment 3 |
SEGMENT4 | String*24 | Segment 4 |
SEGMENT5 | String*24 | Segment 5 |
SEGMENT6 | String*24 | Segment 6 |
SEGMENT7 | String*24 | Segment 7 |
SEGMENT8 | String*24 | Segment 8 |
SEGMENT9 | String*24 | Segment 9 |
SEGMENT10 | String*24 | Segment 10 |
COMMENT1 | String*80 | Comment 1 |
COMMENT2 | String*80 | Comment 2 |
COMMENT3 | String*80 | Comment 3 |
COMMENT4 | String*80 | Comment 4 |
ALLOWONWEB | Boolean | Item can be ordered from web |
KITTING | Boolean | Kitting Item | List: 2 entries
0 | = | No
1 | = | Yes
VALUES | Long | Optional Fields |
DEFKITNO | String*6 | Default Kit Number |

This page was generated on 2004-Oct-28

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