Table: Items

Table: ICITEM
View: IC0310
Record Length: 990

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

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
PREVENDTY Integer SIA Preferred Vendor Type
DEFBOMNO String*6 Default BOM Number
SEASONAL Boolean Seasonal? List:2 entries
0 = No
1 = Yes
TARIFFCODE String*20 Tariff Code

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).