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.