| Field: | ITEMCODE | Type: | VARCHAR Length: 50 |
| Field: | ITEMDESCRIPTION | Type: | VARCHAR Length: 255 |
| Field: | ITEMUNIT | Type: | VARCHAR Length: 15 |
| Field: | ITEMSTATUS | Type: | VARCHAR Length: 20 |
| Field: | ITEMBARCODE | Type: | VARCHAR Length: 50 |
| Field: | ITEMCATEGORY | Type: | VARCHAR Length: 20 |
| Field: | PRICINGGROUP | Type: | VARCHAR Length: 20 |
| Field: | TAXGROUP | Type: | VARCHAR Length: 10 |
| Field: | SOURCEDBY | Type: | VARCHAR Length: 20 |
| Field: | ANALYSISGROUP | Type: | VARCHAR Length: 20 |
| Field: | STDSELLPRICE | Type: | DOUBLE |
| Field: | STDSELLPRICEINCTAX | Type: | DOUBLE |
| Field: | STDBUYPRICE | Type: | DOUBLE |
| Field: | ROUNDPRICE | Type: | VARCHAR Length: 5 |
| Field: | NEARESTAMOUNT | Type: | DOUBLE |
| Field: | ONHANDQTY | Type: | DOUBLE |
| Field: | SUPPLYQTY | Type: | DOUBLE |
| Field: | DEMANDQTY | Type: | DOUBLE |
| Field: | AVAILABLEQTY | Type: | DOUBLE |
| Field: | FREEQTY | Type: | DOUBLE |
| Field: | LASTCOST | Type: | DOUBLE |
| Field: | LASTCOSTDATE | Type: | DATE |
| Field: | STANDARDCOST | Type: | DOUBLE |
| Field: | STANDARDCOSTDATE | Type: | DATE |
| Field: | AVERAGECOST | Type: | DOUBLE |
| Field: | AVERAGECOSTDATE | Type: | DATE |
| Field: | AVERAGECOSTCHANGE | Type: | VARCHAR Length: 10 |
| Field: | ABCCLASS | Type: | VARCHAR Length: 1 |
| Field: | REORDERBASIS | Type: | VARCHAR Length: 20 |
| Field: | REORDERLEVEL | Type: | DOUBLE |
| Field: | REORDERQTY | Type: | DOUBLE |
| Field: | REORDERMULTIPLE | Type: | DOUBLE |
| Field: | LEADTIME | Type: | INTEGER |
| Field: | CYCLECODE | Type: | VARCHAR Length: 10 |
| Field: | DEFAULTISSUEWHOUSE | Type: | VARCHAR Length: 20 |
| Field: | DEFAULTRECEIPTWHOUSE | Type: | VARCHAR Length: 20 |
| Field: | DEFAULTISSUELOCATION | Type: | VARCHAR Length: 20 |
| Field: | DEFAULTRECEIPTLOCATION | Type: | VARCHAR Length: 20 |
| Field: | SUPPLYMETHOD | Type: | VARCHAR Length: 20 |
| Field: | PRIMARYSUPPLIER | Type: | VARCHAR Length: 50 |
| Field: | ALTERNATEAVAILABLE | Type: | BOOLEAN |
| Field: | ALTERNATEITEMCODE | Type: | VARCHAR Length: 50 |
| Field: | WARRANTYAPPLIES | Type: | BOOLEAN |
| Field: | WARRANTYCODE | Type: | VARCHAR Length: 20 |
| Field: | CREATECUSTASSET | Type: | BOOLEAN |
| Field: | ASSETTYPE | Type: | VARCHAR Length: 20 |
| Field: | CREATEASSETSCHEDULE | Type: | BOOLEAN |
| Field: | SERVICEPLANCODE | Type: | VARCHAR Length: 20 |
| Field: | SERIALTRACKED | Type: | BOOLEAN |
| Field: | EXPIRYTRACKED | Type: | BOOLEAN |
| Field: | REVISIONTRACKED | Type: | BOOLEAN |
| Field: | BATCHTRACKED | Type: | BOOLEAN |
| Field: | COLOURTRACKED | Type: | BOOLEAN |
| Field: | GRADETRACKED | Type: | BOOLEAN |
| Field: | SIZETRACKED | Type: | BOOLEAN |
| Field: | LASTRECEIPTDATE | Type: | TIMESTAMP |
| Field: | LASTSALEDATE | Type: | TIMESTAMP |
| Field: | LASTPRICEUPDATEDATE | Type: | TIMESTAMP |
| Field: | LASTCOSTUPDATEDATE | Type: | TIMESTAMP |
| Field: | INTRODATE | Type: | TIMESTAMP |
| Field: | CURRENTREVISION | Type: | VARCHAR Length: 10 |
| Field: | RESTRICTPURCHASING | Type: | BOOLEAN |
| Field: | BATCHRESTRICTED | Type: | BOOLEAN |
| Field: | GRADERESTRICTED | Type: | BOOLEAN |
| Field: | SIZERESTRICTED | Type: | BOOLEAN |
| Field: | COLOURRESTRICTED | Type: | BOOLEAN |
| Field: | ADDONSALESAPPLY | Type: | BOOLEAN |
| Field: | ITEMNOTES | Type: | BLOB |
| Field: | SALESNOTES | Type: | BLOB |
| Field: | JOBNOTES | Type: | BLOB |
| Field: | PURCHASENOTES | Type: | BLOB |
| Field: | ASSEMBLYNOTES | Type: | BLOB |
| Field: | FORECASTEXISTS | Type: | BOOLEAN |
| Field: | ACTUALCOSTING | Type: | BOOLEAN |
| Field: | ALLOWZEROISSUECOSTS | Type: | BOOLEAN |
| Field: | COSTCHANGEREASON | Type: | VARCHAR Length: 50 |
| Field: | MANUFACTURER | Type: | VARCHAR Length: 50 |
| Field: | BRANDNAME | Type: | VARCHAR Length: 50 |
| Field: | MODELNAME | Type: | VARCHAR Length: 50 |
| Field: | ITEMSPECIFICATIONLINK | Type: | VARCHAR Length: 255 |
| Field: | ITEMSUBCATEGORY | Type: | VARCHAR Length: 20 |
| Field: | RTFFILEPATH | Type: | VARCHAR Length: 255 |
| Field: | ADDITIONALFIELD_1 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_2 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_3 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_4 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_5 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_6 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_7 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_8 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALDATEFIELD_1 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_2 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_3 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_4 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_5 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_6 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_7 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_8 | Type: | DATE |
| Field: | NONEGATIVESTOCK | Type: | BOOLEAN |
| Field: | PRICEFROMRECEIPTCOST | Type: | BOOLEAN |
| Field: | RECEIPTCOSTMARKUP | Type: | DOUBLE |
| Field: | DUTYPERCENT | Type: | DOUBLE |
| Field: | LINKEDIMAGES | Type: | BOOLEAN |
| Field: | LINKEDDOCUMENTS | Type: | BOOLEAN |
| Field: | LINKEDPROPERTIES | Type: | BOOLEAN |
| Field: | LINKEDHISTORYNOTES | Type: | BOOLEAN |
| Field: | LEVELCODE | Type: | INTEGER |
| Field: | BACKFLUSHAORECEIPTS | Type: | BOOLEAN |
| Field: | BACKFLUSHPORECEIPTS | Type: | BOOLEAN |
| Field: | CUSTOMSTYLE | Type: | VARCHAR Length: 10 |
| Field: | SERIALKIT | Type: | BOOLEAN |
| Field: | SERIALKITLISTCODE | Type: | VARCHAR Length: 50 |
| Field: | NEXTSUPPLYDATE | Type: | DATE |
| Field: | QTYDIMWIDTH | Type: | BOOLEAN |
| Field: | QTYDIMLENGTH | Type: | BOOLEAN |
| Field: | QTYDIMDEPTH | Type: | BOOLEAN |
| Field: | QTYDIMPACKSIZE | Type: | BOOLEAN |
| Field: | QTYDIMCONVFACTOR | Type: | DOUBLE |
| Field: | QTYDIMWIDTHFIXED | Type: | BOOLEAN |
| Field: | QTYDIMLENGTHFIXED | Type: | BOOLEAN |
| Field: | QTYDIMDEPTHFIXED | Type: | BOOLEAN |
| Field: | QTYDIMWIDTHVALUE | Type: | DOUBLE |
| Field: | QTYDIMLENGTHVALUE | Type: | DOUBLE |
| Field: | QTYDIMDEPTHVALUE | Type: | DOUBLE |
| Field: | QTYPACKSIZERESTRICTED | Type: | BOOLEAN |
| Field: | SALESMESSAGE | Type: | VARCHAR Length: 200 |
| Field: | JOBMESSAGE | Type: | VARCHAR Length: 200 |
| Field: | PURCHASEMESSAGE | Type: | VARCHAR Length: 200 |
| Field: | ASSEMBLYMESSAGE | Type: | VARCHAR Length: 200 |
| Field: | SIZEISACONVFACTOR | Type: | BOOLEAN |
| Field: | SIZEDEFAULTCONVFACTOR | Type: | DOUBLE |
| Field: | SIZEUNITNAME | Type: | VARCHAR Length: 15 |
| Field: | SIZEONHANDQTY | Type: | DOUBLE |
| Field: | EXCLUDEFROMWEB | Type: | BOOLEAN |
| Field: | ITEMSUPERSEDED | Type: | BOOLEAN |
| Field: | SUPERSESSIONTYPE | Type: | VARCHAR Length: 20 |
| Field: | NOROUNDINGOFFORECAST | Type: | BOOLEAN |
| Field: | SUPERSESSIONCODE | Type: | VARCHAR Length: 50 |
| Field: | ITEMSCHEDULESEQUENCE | Type: | INTEGER |
| Field: | PURCHASEWARRANTYAPPLIES | Type: | BOOLEAN |
| Field: | PURCHASEWARRANTYCODE | Type: | VARCHAR Length: 20 |
| Field: | EXCLUDEFROMPOS | Type: | BOOLEAN |
| Field: | DAILYFORECASTEXISTS | Type: | BOOLEAN |
| Field: | CONFIGUREDITEMTEMPLATE | Type: | BOOLEAN |
| Field: | CONFIGUREDITEMCODESTRUCTURE | Type: | VARCHAR Length: 30 |
| Field: | ORIGINALCODE | Type: | VARCHAR Length: 50 |
| Field: | BUDGETREPRESENTATIVECODE | Type: | VARCHAR Length: 50 |
| Field: | OVERRIDEPICKTIME | Type: | BOOLEAN |
| Field: | PICKTIMEINMINUTES | Type: | DOUBLE |
| Field: | MULTIPLEBYQTY | Type: | BOOLEAN |
| Field: | SETUPGROUP | Type: | VARCHAR Length: 50 |
| Field: | COSTCHANGEDFROMTRANS | Type: | BOOLEAN |
| Field: | QTYUPDATEDFROMINVENTORY | Type: | BOOLEAN |
| Field: | CREATEASSETRECURRING | Type: | BOOLEAN |
| Field: | RECURRINGGSTYLE | Type: | VARCHAR Length: 20 |
| Field: | RECURRINGWEEKDAY | Type: | VARCHAR Length: 20 |
| Field: | RECURRINGFIXEDDAY | Type: | INTEGER |
| Field: | RECURRINGFEQUENCY | Type: | INTEGER |
| Field: | RECURRINGPERIOD | Type: | VARCHAR Length: 10 |
| Field: | PREDICTIVESTYLE | Type: | VARCHAR Length: 30 |
| Field: | READINGTYPE | Type: | VARCHAR Length: 20 |
| Field: | READINGVALUE | Type: | DOUBLE |
| Field: | JOBTYPE | Type: | VARCHAR Length: 20 |
| Field: | TEMPLATECODE | Type: | VARCHAR Length: 50 |
| Field: | NEARESTWORKDAY | Type: | BOOLEAN |
| Field: | MOBILITYIMAGE | Type: | BLOB |
| Field: | MOBILITYIMAGESTORED | Type: | BOOLEAN |
| Field: | EXTERNALSHORTDESCRIPTION | Type: | VARCHAR Length: 255 |
| Field: | EXTERNALLONGDESCRIPTION | Type: | BLOB |
| Field: | EXTERNALSHOWCASEDFLAG | Type: | BOOLEAN |
| Field: | EXTERNALSPECIFICATIONS | Type: | BLOB |
| Field: | LONGDESCRIPTIONCAPTION | Type: | VARCHAR Length: 50 |
| Field: | SPECIFICATIONSCAPTION | Type: | VARCHAR Length: 50 |
| Field: | FEATURESCAPTION | Type: | VARCHAR Length: 50 |
| Field: | KEYWORDS | Type: | BLOB |
| Field: | LASTCOUNTDATE | Type: | DATE |
| Field: | POSSEGMENTEDBARCODE | Type: | BOOLEAN |
| Field: | PICKINGCLASS | Type: | VARCHAR Length: 20 |
| Field: | MULTISCAN | Type: | BOOLEAN |
| Field: | PICKINGSEQUENCE | Type: | INTEGER |
| Field: | SERIALRANGE | Type: | BOOLEAN |
| Field: | INCLUDEINBTOB | Type: | BOOLEAN |
| Field: | BATCHREQUIRESQC | Type: | BOOLEAN |
| Field: | CONTAINERBATCHNONMIX | Type: | BOOLEAN |
| Field: | CONTAINERCONTENTGROUP | Type: | VARCHAR Length: 100 |
| Field: | USEVIRTUALCONTAINER | Type: | BOOLEAN |
| Field: | SYSDATECREATED | Type: | TIMESTAMP |
| Field: | SYSDATEMODIFIED | Type: | TIMESTAMP |
| Field: | SYSUNIQUEID | Type: | DOUBLE |
| Field: | SYSUSERCREATED | Type: | VARCHAR Length: 30 |
| Field: | SYSUSERMODIFIED | Type: | VARCHAR Length: 30 |