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 |