View: Items

RotoID: IC0310
Table: ICITEM
Protocol: Header
DLL:ICITEM

Compositions: 11

RotoID Tables Title DLL
IC0750 ICUNIT Units of Measure ICUNIT
IC0330 ICITMTX Item Tax Authorities ICITMTX
IC0340 ICITMV Vendor Item Numbers 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
IC0314 ICITEMSO Item Serial Optional Fields ICITEMSO
IC0312 ICITEMLO Item Lot Optional Fields ICITEMLO

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: 99

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 X  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:8 entries
1 = Moving Average
2 = FIFO
3 = LIFO
4 = Standard Cost
5 = Most Recent Cost
6 = User-Specified
7 = Serial
8 = Lot
PROCESSCMD 60 Integer Process Command E A C  List:4 entries
0 = Nothing to Process
1 = Insert Optional Fields
6 = Insert Item Serial Optional Fields
7 = Insert Item Lot 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
SERIALMASK 63 String*6 Serial Number Mask E A X  Mask: %-6N
NEXTSERFMT 64 String*40 Next Serial Number E A X  Mask: %-40c
SUSEEXPDAY 65 Boolean Use Serials Days to Expire E A X  List:2 entries
0 = No
1 = Yes
SEXPDAYS 66 Integer Serials Days to Expire E A X 
SDIFQTYOK 67 Boolean Allow Different Serial Qty E A X  List:2 entries
0 = No
1 = Yes
SVALUES 68 Long Serials Optional Fields E A C X 
SWARYCODE 69 String*6 Default Serial Warranty Code E A X  Mask: %-6N
SCONTCODE 70 String*6 Default Serial Contract Code E A X  Mask: %-6N
SCONTRECE 71 Boolean Serial is on Cont. When Received E A X  List:2 entries
0 = No
1 = Yes
SWARYSOLD 72 Boolean Serial is on Warr. When Sold E A X  List:2 entries
0 = No
1 = Yes
SWARYREG 73 Boolean Serial is on Warr. When Registered E A X  List:2 entries
0 = No
1 = Yes
LOTITEM 74 Boolean Lot Numbers E A X  List:2 entries
0 = No
1 = Yes
LOTMASK 75 String*6 Lot Number Mask E A X  Mask: %-6N
NEXTLOTFMT 76 String*40 Next Lot Number E A X  Mask: %-40c
LUSEEXPDAY 77 Boolean Use Lots Days to Expire E A X  List:2 entries
0 = No
1 = Yes
LEXPDAYS 78 Integer Lots Days to Expire E A X 
LUSEQRNDAY 79 Boolean Use Lots Days on Quarantine E A X  List:2 entries
0 = No
1 = Yes
LQRNDAYS 80 Integer Lots Days on Quarantine E A X 
LDIFQTYOK 81 Boolean Allow Different Lot Qty E A X  List:2 entries
0 = No
1 = Yes
LVALUES 82 Long Lots Optional Fields E A C X 
LWARYCODE 83 String*6 Default Lot Warranty Code E A X  Mask: %-6N
LCONTCODE 84 String*6 Default Lot Contract Code E A X  Mask: %-6N
LCONTRECE 85 Boolean Lot is on Cont. When Received E A X  List:2 entries
0 = No
1 = Yes
LWARYSOLD 86 Boolean Lot is on Warr. When Sold E A X  List:2 entries
0 = No
1 = Yes
SERIALUSED 87 Boolean Serial Numbers in Use A C  List:2 entries
0 = No
1 = Yes
SMSKSTRUCT 88 String*40 Serial Mask Structure A C  Mask: %-40c
SMSKDESC 89 String*60 Serial Mask Description A C 
UNFSERIAL 90 String*40 Unformatted Serial Number E A C 
FMTSERIAL 91 String*40 Serial Number E A C 
NXTAUTOSER 92 String*40 Auto-gen Serial Number A C 
GENNEWSER 93 BCD*10.4 Number of Serials to Generate E A C 
GENRMNSER 94 BCD*10.4 Number of Serials not Generated A C 
SFIRSTGEN 95 String*40 First Generated Serial A C  Mask: %-40c
SLASTGEN 96 String*40 Last Generated Serial A C  Mask: %-40c
LOTUSED 97 Boolean Lot Numbers in Use A C  List:2 entries
0 = No
1 = Yes
LMSKSTRUCT 98 String*40 Lot Mask Structure A C  Mask: %-40c
LMSKDESC 99 String*60 Lot Mask Description A C 
UNFLOT 100 String*40 Unformatted Lot Number E A C 
FMTLOT 101 String*40 Lot Number E A C 
NXTAUTOLOT 102 String*40 Auto-gen Lot Number A C 
GENNEWLOT 103 BCD*10.4 Number of Lots to Generate E A C 
GENRMNLOT 104 BCD*10.4 Number of Lots not Generated A C 
LFIRSTGEN 105 String*40 First Generated Lot A C  Mask: %-40c
LLASTGEN 106 String*40 Last Generated Lot A C  Mask: %-40c
PREVENDTY 107 Integer SIA Preferred Vendor Type E A 
DEFBOMNO 108 String*6 Default BOM Number E A 
SEASONAL 109 Boolean Seasonal? E A  List:2 entries
0 = No
1 = Yes
QTONHANDA 110 BCD*10.4 Qty. on Hand E A C 
QTONORDERA 111 BCD*10.4 Qty. on Purchase Order E A C 
QTSALORDRA 112 BCD*10.4 Qty. on Sales Order E A C 
QTAVAILA 113 BCD*10.4 Qty. Available E A C 
QTYCOMMITA 114 BCD*10.4 Qty. Committed E A C 
PREVENDOR 115 String*75 Preferred Vendor E A C 
VENDITEM 116 String*24 Preferred Vendor Item E A C 
TARIFFCODE 117 String*20 Tariff Code E A 

This page was generated on 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).