# View: Items

RotoID: IC0310
Table: ICITEM
DLL: ICITEM

## Compositions: 9

RotoID | Table | Title | DLL
--- | --- | --- | ---
IC0750 | ICUNIT | Units of Measure | ICUNIT
IC0330 | ICITMTX | Item Tax Authorities | ICITMTX
IC0340 | ICITMV | Vendors | ICITMV
IC0320 | ICITMS | Item Structures | ICITMS
IC0210 | ICCATG | Categories | ICCATG
IC0100 | ICACCT | Account Sets | ICACCT
IC0390 | ICPCOD | Price List Codes | ICPCOD
IC0313 | ICITEMO | Item Optional Fields | ICITEMO
IC0319 | ICITMC | Customer Item Numbers | ICITMC

## Keys: 6

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

## Fields: 44

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
ITEMNO | 1 | String*24 | Unformatted Item Number | E A K R | Mask: %-24C
ALTSET | 2 | Long | Alternate Item Set Number | E A |
DESC | 3 | String*60 | Description | E A |
DATELASTMN | 4 | Date | Date Last Maintained | A C |
INACTIVE | 5 | Boolean | Status | E A | List: 2 entries
0 | = | Active
1 | = | Inactive
ITEMBRKID | 6 | String*6 | Structure Code | E A X | Mask: %-6N
FMTITEMNO | 7 | String*24 | Item Number | E A | Mask: %-24C
CATEGORY | 8 | String*6 | Category | E A | Mask: %-6N
CNTLACCT | 9 | String*6 | Account Set Code | E A | Mask: %-6N
STOCKITEM | 10 | Boolean | Stock Item | E A | List: 2 entries
0 | = | No
1 | = | Yes
STOCKUNIT | 11 | String*10 | Stocking Unit of Measure | E A | Mask: %-10w
DEFPRICLST | 12 | String*6 | Default Price List Code | E A | Mask: %-6N
UNITWGT | 13 | BCD*10.4 | Unit Weight | E A |
PICKINGSEQ | 14 | String*10 | Default Picking Sequence | E A |
SERIALNO | 15 | Boolean | Serial Numbers | E A | List: 2 entries
0 | = | No
1 | = | Yes
COMMODIM | 24 | String*16 | Commodity Number | E A |
DATEINACTV | 25 | Date | Date Inactive | A C |
SEGMENT1 | 26 | String*24 | Segment 1 | A C |
SEGMENT2 | 27 | String*24 | Segment 2 | A C |
SEGMENT3 | 28 | String*24 | Segment 3 | A C |
SEGMENT4 | 29 | String*24 | Segment 4 | A C |
SEGMENT5 | 30 | String*24 | Segment 5 | A C |
SEGMENT6 | 31 | String*24 | Segment 6 | A C |
SEGMENT7 | 32 | String*24 | Segment 7 | A C |
SEGMENT8 | 33 | String*24 | Segment 8 | A C |
SEGMENT9 | 34 | String*24 | Segment 9 | A C |
SEGMENT10 | 35 | String*24 | Segment 10 | A C |
COMMENT1 | 36 | String*80 | Comment 1 | E A |
COMMENT2 | 37 | String*80 | Comment 2 | E A |
COMMENT3 | 38 | String*80 | Comment 3 | E A |
COMMENT4 | 39 | String*80 | Comment 4 | E A |
ALLOWONWEB | 40 | Boolean | Allow Item in Web Store | E A | List: 2 entries
0 | = | No
1 | = | Yes
KITTING | 41 | Boolean | Kitting Item | E A | List: 2 entries
0 | = | No
1 | = | Yes
VALUES | 42 | Long | Optional Fields | E A C |
DEFKITNO | 43 | String*6 | Default Kit Number | E A |
SELLABLE | 44 | Boolean | Sellable | E A | List: 2 entries
0 | = | No
1 | = | Yes
WEIGHTUNIT | 45 | String*10 | Weight Unit of Measure | E A |
ALTITEMNO | 56 | String*24 | Unformatted Alternate Item No. | E A | Mask: %-24C
FMTALTITEM | 57 | String*24 | Alternate Item Number | A C |
ALTITEMDSC | 58 | String*60 | Alternate Item Description | A C |
COSTMETHOD | 59 | Integer | Costing Method | E A | List: 6 entries
1 | = | Moving Average
2 | = | FIFO
3 | = | LIFO
4 | = | Standard Cost
5 | = | Most Recent Cost
6 | = | User-Specified
PROCESSCMD | 60 | Integer | Process Command | E A C | List: 2 entries
0 | = | Nothing to Process
1 | = | Insert Optional Fields
WEIGHTCONV | 61 | BCD*10.6 | Weight Conversion Factor | E A C |
ISBOMCMPN | 62 | Boolean | Is item a BOM Component? | E A | List: 2 entries
0 | = | No
1 | = | Yes

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.