Field Listing for Table ITEMMASTER

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:SYSDATECREATED Type: TIMESTAMP
Field:SYSDATEMODIFIED Type: TIMESTAMP
Field:SYSUNIQUEID Type: DOUBLE
Field:SYSUSERCREATED Type: VARCHAR Length: 30
Field:SYSUSERMODIFIED Type: VARCHAR Length: 30
Field:ADDITIONALFIELD_9 Type: VARCHAR Length: 100