| Name | Type | Length | Decimal | Relation | Description |
| ITEMNUM | String | 25 | IN ITEMNUM | ||
| ITEMDESC | String | 40 | IN INVENTORY ITEM ITEMDESC - Inventory item description | ||
| ITEMDIV | String | 4 | IN INVENTORY ITEM ITEMDIV - The product line that item belongs to | ||
| ITEMTYPE | String | 1 | IN INVENTORY ITEM ITEMTYPE - The item type (R=Raw material,K=Kit /Bill,F=Finished Good) | ||
| ITEMVAL | String | 1 | IN INVENTORY ITEM ITEMVAL - The costing method for the item (1=Standard cost,2=Average Cost,3=LIFO,4=FIFO,5=Lot,6=Serial No.) | ||
| PRICECODE | String | 4 | IN INVENTORY ITEM PRICECODE - Special item pricing code that relates to an entry in the special item pricing file. | ||
| BACKORDERS | Boolean | 1 | IN INVENTORY ITEM BACKORDERS - Set to ture if backorders are allowed for the item | ||
| TAXABLE | Boolean | 1 | IN INVENTORY ITEM TAXABLE - Set to ture if the item is taxable | ||
| COMMISSION | String | 1 | IN INVENTORY ITEM COMMISSION - The method to use to base commissions on (g=Gross Profit) | ||
| UMSTAND | String | 4 | IN INVENTORY ITEM UMSTAND - The standard unit of measure of the item. (the unit the item is stocked in inventory). | ||
| UMPURCH | String | 4 | IN INVENTORY ITEM UMPURCH - The unit of measure that the item is purchased in. | ||
| UMSALES | String | 4 | IN INVENTORY ITEM UMSALES - The unit of measure that the item is sold in. | ||
| DEFWARE | String | 8 | IN INVENTORY ITEM DEFWARE - The default warehouse that the item is stocked in. | ||
| LASTSOLD | DateTime | 8 | IN INVENTORY ITEM LASTSOLD - The date that the item was last sold. | ||
| LASTRCPT | DateTime | 8 | IN INVENTORY ITEM LASTRCPT - The date that the item was last received | ||
| CAT1 | String | 24 | IN INVENTORY ITEM CAT1 - User defined field | ||
| CAT2 | String | 25 | IN INVENTORY ITEM CAT2 - User defined field | ||
| CAT3 | String | 25 | IN INVENTORY ITEM CAT3 - User defined field | ||
| CAT4 | String | 25 | IN INVENTORY ITEM CAT4 - User defined field | ||
| USERDEFINE | String | 25 | IN USERDEFINE | ||
| USERDEFIN2 | String | 25 | IN USERDEFIN2 | ||
| USERDEFIN3 | String | 25 | IN USERDEFIN3 | ||
| USERDEFIN4 | String | 25 | IN USERDEFIN4 | ||
| USERDEFIN5 | String | 25 | IN USERDEFIN5 | ||
| USERDEFIN6 | String | 25 | IN USERDEFIN6 | ||
| ALTITEMS | Boolean | 1 | IN INVENTORY ITEM ALTITEMS - Set to true if there are alternate or substitute items | ||
| RETPRICE | Decimal | 10 | 3 | IN INVENTORY ITEM RETPRICE - The retail price of the item | |
| WEIGHT | Decimal | 8 | 2 | IN INVENTORY ITEM WEIGHT - The weight of the item. | |
| STANDPRICE | Decimal | 12 | 4 | IN INVENTORY ITEM STANDPRICE - The selling price of the item | |
| STANDCOST | Decimal | 12 | 4 | IN INVENTORY ITEM STANDCOST - The standard cost of the item | |
| LASTCOST | Decimal | 12 | 4 | IN INVENTORY ITEM LASTCOST - The last cost of the item | |
| AVGCOST | Decimal | 12 | 4 | IN INVENTORY ITEM AVGCOST - The average cost of the item | |
| PURCHFACT | Decimal | 12 | 4 | IN INVENTORY ITEM PURCHFACT - The purchase factor of the item or the number of purchase unit of measure that equals the standard unit of measure. | |
| SALESFACT | Decimal | 12 | 4 | IN INVENTORY ITEM SALESFACT - The sales factor of the item or the number of sales unit of measure that equals the standard unit of measure. | |
| NOTES | String | 4 | IN INVENTORY ITEM NOTES - Comments for the item | ||
| ITEMPIC | String | 4 | IN INVENTORY ITEM ITEMPIC - Image of the item | ||
| ISINACTIVE | Boolean | 1 | IN INVENTORY ITEM ISINACTIVE - T= Item is inactive | ||
| DROPSHIP | Boolean | 1 | IN INVENTORY ITEM DROPSHIP - T= Default Drop Ship | ||
| DONOTSTOCK | Boolean | 1 | IN INVENTORY ITEM DONOTSTOCK - Set to true if this item is always ordered on demand. | ||
| BINIMAGE | String | 4 | IN INVENTORY ITEM BINIMAGE - Document image | ||
| INVCYCLE | String | 10 | INITEMMM INVCYCLE - Invcycle | ||
| ITEMCAT | String | 3 | INITEMMM ITEMCAT - Itemcat | ||
| BINLOC | String | 10 | IN BINLOC | ||
| LEADTIME | Int32 | 4 | INITEMMM LEADTIME - Leadtime | ||
| UPCCODE | String | 12 | IN INVENTORY ITEM ENT UPC - UPC CODE | ||
| ALTITEMNUM | String | 25 | INITEMMM ALTITEMNUM - Altitemnum | ||
| VOLUME | Decimal | 10 | 3 | INITEMMM VOLUME - Volume | |
| CUBE | Decimal | 10 | 3 | INITEMMM CUBE - Cube | |
| PALM_MIN | String | 8 | INITEMMM PALM_MIN - Palm_min | ||
| PALM_MULT | String | 8 | INITEMMM PALM_MULT - Palm_mult | ||
| CASEPACK | String | 10 | INITEMMM CASEPACK - Casepack | ||
| CASE_UM | String | 10 | INITEMMM CASE_UM - Case_um | ||
| CASE_UPC | String | 15 | INITEMMM CASE_UPC - Case_upc | ||
| AUTHCODE | String | 3 | INITEMMM AUTHCODE - Authcode | ||
| ROYRATE | Decimal | 9 | 3 | INITEMMM ROYRATE - Royrate | |
| LANDCOST | Decimal | 12 | 4 | INITEMMM LANDCOST - Landcost | |
| POCOST | Decimal | 12 | 4 | INITEMMM POCOST - Pocost | |
| LASTLNDCST | Decimal | 12 | 4 | INITEMMM LASTLNDCST - Lastlndcst | |
| FREIGHT | Decimal | 10 | 2 | INITEMMM FREIGHT - Freight | |
| CURRENCY | String | 3 | INITEMMM CURRENCY - Currency | ||
| COUNTRY | String | 10 | INITEMMM COUNTRY - Country | ||
| DUTY | Decimal | 10 | 2 | INITEMMM DUTY - Duty | |
| DIMHTIN | Decimal | 8 | 3 | INITEMMM DIMHTIN - Dimhtin | |
| DIMWTIN | Decimal | 8 | 3 | INITEMMM DIMWTIN - Dimwtin | |
| DIMDPTIN | Decimal | 8 | 3 | INITEMMM DIMDPTIN - Dimdptin | |
| DIMHTMC | Decimal | 8 | 3 | INITEMMM DIMHTMC - Dimhtmc | |
| DIMWTMC | Decimal | 8 | 3 | INITEMMM DIMWTMC - Dimwtmc | |
| DIMDPMC | Decimal | 8 | 3 | INITEMMM DIMDPMC - Dimdpmc | |
| DISCOUNT | Boolean | 1 | INITEMMM DISCOUNT - Discount | ||
| ORIGNDATE | DateTime | 8 | INITEMMM ORIGNDATE - Origndate | ||
| COMMRATE | Decimal | 5 | 2 | INITEMMM COMMRATE - Commrate | |
| STYLECODE | String | 10 | INITEMMM STYLECODE - Stylecode | ||
| INTMEMO | String | 4 | INITEMMM INTMEMO - Intmemo | ||
| VENDMEMO | String | 4 | INITEMMM VENDMEMO - Vendmemo | ||
| NRFCOLCODE | String | 14 | INITEMMM NRFCOLCODE - Nrfcolcode | ||
| NRFCOLDESC | String | 13 | INITEMMM NRFCOLDESC - Nrfcoldesc | ||
| NRFSIZECOD | String | 12 | IN NRFSIZECOD | ||
| NRFSIZDSC1 | String | 12 | INITEMMM NRFSIZDSC1 - Nrfsizdsc1 | ||
| NRFSIZDSC2 | String | 12 | INITEMMM NRFSIZDSC2 - Nrfsizdsc2 | ||
| SELDES | String | 12 | INITEMMM SELDES - Seldes | ||
| SELCODE | String | 7 | INITEMMM SELCODE - Selcode | ||
| UMPROD | String | 4 | INITEMMM UMPROD - Umprod | ||
| PRODFACT | Decimal | 12 | 4 | INITEMMM PRODFACT - Prodfact | |
| USERDEF11 | String | 10 | INITEMMM USERDEF11 - Userdef11 | ||
| USERDEF12 | String | 10 | INITEMMM USERDEF12 - Userdef12 | ||
| USERDEF13 | String | 10 | INITEMMM USERDEF13 - Userdef13 | ||
| USERDEF14 | String | 10 | INITEMMM USERDEF14 - Userdef14 | ||
| USERDEF15 | String | 10 | INITEMMM USERDEF15 - Userdef15 | ||
| USERDEF16 | String | 10 | INITEMMM USERDEF16 - Userdef16 | ||
| USERDEF17 | Decimal | 12 | 2 | INITEMMM USERDEF17 - Userdef17 | |
| USERDEF18 | Decimal | 12 | 2 | INITEMMM USERDEF18 - Userdef18 | |
| USERDEF19 | Decimal | 12 | 2 | INITEMMM USERDEF19 - Userdef19 | |
| USERDEF20 | Decimal | 12 | 2 | INITEMMM USERDEF20 - Userdef20 | |
| MULTIBIN | Boolean | 1 | INITEMMM MULTIBIN - Multibin | ||
| NMFCSUB | String | 2 | INITEMMM NMFCSUB - Nmfcsub | ||
| NMFCCODE | String | 6 | INITEMMM NMFCCODE - Nmfccode | ||
| NMFCCLASS | String | 4 | INITEMMM NMFCCLASS - Nmfcclass | ||
| CARTPERBOX | Decimal | 10 | 4 | INITEMMM CARTPERBOX - Cartperbox | |
| DUTYCOST | Decimal | 12 | 4 | INITEMMM DUTYCOST - Dutycost | |
| BROKERCOST | Decimal | 12 | 4 | INITEMMM BROKERCOST - Brokercost | |
| FREIGHTCST | Decimal | 12 | 4 | INITEMMM FREIGHTCST - Freightcst | |
| FIRSTCOST | Decimal | 12 | 4 | INITEMMM FIRSTCOST - Firstcost | |
| ISSERIAL | Boolean | 1 | INITEMMM ISSERIAL - Isserial | ||
| TAXCLASS | String | 2 | INITEMMM TAXCLASS - Taxclass | ||
| PRICELIST | String | 5 | INITEMMM PRICELIST - Pricelist | ||
| COLLECTION | String | 30 | INITEMMM COLLECTION - Collection | ||
| CATEGORY | String | 30 | INITEMMM CATEGORY - Category | ||
| SUBCAT | String | 30 | INITEMMM SUBCAT - Subcat | ||
| COLOR | String | 20 | INITEMMM COLOR - Color | ||
| PARENTPART | String | 20 | INITEMMM PARENTPART - Parentpart | ||
| CONTMIN | Int32 | 4 | INITEMMM CONTMIN - Contmin | ||
| MAT1 | String | 15 | INITEMMM MAT1 - Mat1 | ||
| MAT2 | String | 15 | INITEMMM MAT2 - Mat2 | ||
| CONFIRMED | String | 10 | INITEMMM CONFIRMED - Confirmed | ||
| RANK | String | 10 | INITEMMM RANK - Rank | ||
| INTRODATE | DateTime | 8 | INITEMMM INTRODATE - Introdate | ||
| POAUTHOR | String | 15 | INITEMMM POAUTHOR - Poauthor | ||
| BOXED | Boolean | 1 | INITEMMM BOXED - Boxed | ||
| STATUS | String | 20 | INITEMMM STATUS - Status | ||
| EXTDESC | String | 100 | INITEMMM EXTDESC - Extdesc | ||
| SUBCOLLECT | String | 30 | INITEMMM SUBCOLLECT - Subcollect | ||
| PDAUTHOR | String | 15 | INITEMMM PDAUTHOR - Pdauthor | ||
| ASSEMBLY | Boolean | 1 | INITEMMM ASSEMBLY - Assembly | ||
| KD | Boolean | 1 | INITEMMM KD - Kd | ||
| PSF | Boolean | 1 | INITEMMM PSF - Psf | ||
| ZONE | String | 2 | INITEMMM ZONE - Zone | ||
| TARRIFNO | String | 10 | INITEMMM TARRIFNO - Tarrifno | ||
| ITEMID | Int32 | 4 | INITEMMM ITEMID - Itemid | ||
| ITEMWEIGHT | Decimal | 8 | 3 | INITEMMM ITEMWEIGHT - Itemweight | |
| DUTYUNIT | String | 15 | INITEMMM DUTYUNIT - Dutyunit | ||
| FRGHTRATE | Decimal | 6 | 2 | INITEMMM FRGHTRATE - Frghtrate | |
| COLLECT2 | String | 30 | INITEMMM COLLECT2 - Collect2 | ||
| COLLECT3 | String | 30 | INITEMMM COLLECT3 - Collect3 | ||
| COLLECT4 | String | 30 | INITEMMM COLLECT4 - Collect4 | ||
| COLLECT5 | String | 30 | INITEMMM COLLECT5 - Collect5 | ||
| SUBCOLL2 | String | 30 | INITEMMM SUBCOLL2 - Subcoll2 | ||
| SUBCOLL3 | String | 30 | INITEMMM SUBCOLL3 - Subcoll3 | ||
| SUBCOLL4 | String | 30 | INITEMMM SUBCOLL4 - Subcoll4 | ||
| SUBCOLL5 | String | 30 | INITEMMM SUBCOLL5 - Subcoll5 | ||
| CATEGORY2 | String | 30 | INITEMMM CATEGORY2 - Category2 | ||
| CATEGORY3 | String | 30 | INITEMMM CATEGORY3 - Category3 | ||
| CATEGORY4 | String | 30 | INITEMMM CATEGORY4 - Category4 | ||
| CATEGORY5 | String | 30 | INITEMMM CATEGORY5 - Category5 | ||
| SUBCAT2 | String | 30 | INITEMMM SUBCAT2 - Subcat2 | ||
| SUBCAT3 | String | 30 | INITEMMM SUBCAT3 - Subcat3 | ||
| SUBCAT4 | String | 30 | INITEMMM SUBCAT4 - Subcat4 | ||
| SUBCAT5 | String | 30 | INITEMMM SUBCAT5 - Subcat5 | ||
| FINISH | String | 20 | INITEMMM FINISH - Finish | ||
| MATERIAL | String | 20 | INITEMMM MATERIAL - Material | ||
| BRAND | String | 30 | INITEMMM BRAND - Brand | ||
| PO_MIN | Int32 | 4 | INITEMMM PO_MIN - Po_min | ||
| PO_MULT | Int32 | 4 | INITEMMM PO_MULT - Po_mult | ||
| AUTHCODE2 | String | 3 | INITEMMM AUTHCODE2 - Authcode2 | ||
| AUTHCODE3 | String | 3 | INITEMMM AUTHCODE3 - Authcode3 | ||
| ROYRATE2 | Decimal | 9 | 3 | INITEMMM ROYRATE2 - Royrate2 | |
| ROYRATE3 | Decimal | 9 | 3 | INITEMMM ROYRATE3 - Royrate3 | |
| MISCRATE | Decimal | 6 | 2 | INITEMMM MISCRATE - Miscrate | |
| MISCCOST | Decimal | 12 | 4 | INITEMMM MISCCOST - Misccost | |
| PROCSTAT | String | 2 | INITEMMM PROCSTAT - Procstat | ||
| EAN | String | 13 | INITEMMM EAN - Ean |