# Table: Items

Table: ICITEM
View: IC0310
Record length: 960
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: 65

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: %-10w
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 | List: 2 entries
0 | = | No
1 | = | Yes
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 | Allow Item in Web Store | List: 2 entries
0 | = | No
1 | = | Yes
KITTING | Boolean | Kitting Item | List: 2 entries
0 | = | No
1 | = | Yes
VALUES | Long | Optional Fields |
DEFKITNO | String*6 | Default Kit Number |
SELLABLE | Boolean | Sellable | List: 2 entries
0 | = | No
1 | = | Yes
WEIGHTUNIT | String*10 | Weight Unit of Measure |
SERIALMASK | String*6 | Serial Number Mask | Mask: %-6N
NEXTSERFMT | String*40 | Next Serial Number | Mask: %-40c
SUSEEXPDAY | Boolean | Use Serials Days to Expire | List: 2 entries
0 | = | No
1 | = | Yes
SEXPDAYS | Integer | Serials Days to Expire |
SDIFQTYOK | Boolean | Allow Different Serial Qty | List: 2 entries
0 | = | No
1 | = | Yes
SVALUES | Long | Serials Optional Fields |
SWARYCODE | String*6 | Default Serial Warranty Code | Mask: %-6N
SCONTCODE | String*6 | Default Serial Contract Code | Mask: %-6N
SCONTRECE | Boolean | Serial is on Cont. When Received | List: 2 entries
0 | = | No
1 | = | Yes
SWARYSOLD | Boolean | Serial is on Warr.When Sold | List: 2 entries
0 | = | No
1 | = | Yes
SWARYREG | Boolean | Serial is on Warr. When Registered | List: 2 entries
0 | = | No
1 | = | Yes
LOTITEM | Boolean | Lot Numbers | List: 2 entries
0 | = | No
1 | = | Yes
LOTMASK | String*6 | Lot Number Mask | Mask: %-6N
NEXTLOTFMT | String*40 | Next Lot Number | Mask: %-40c
LUSEEXPDAY | Boolean | Use Lots Days to Expire | List: 2 entries
0 | = | No
1 | = | Yes
LEXPDAYS | Integer | Lots Days to Expire |
LUSEQRNDAY | Boolean | Use Lots Days on Quarantine | List: 2 entries
0 | = | No
1 | = | Yes
LQRNDAYS | Integer | Lots Days on Quarantine |
LDIFQTYOK | Boolean | Allow Different Lot Qty | List: 2 entries
0 | = | No
1 | = | Yes
LVALUES | Long | Lots Optional Fields |
LWARYCODE | String*6 | Default Lot Warranty Code | Mask: %-6N
LCONTCODE | String*6 | Default Lot Contract Code | Mask: %-6N
LCONTRECE | Boolean | Lot is on Cont. When Received | List: 2 entries
0 | = | No
1 | = | Yes
LWARYSOLD | Boolean | Lot is on Warr.When Sold | List: 2 entries
0 | = | No
1 | = | Yes

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.