Field: | DESCRIPTORCODE | Type: | VARCHAR Length: 50 |
Field: | DESCRIPTORDESCRIPTION | Type: | VARCHAR Length: 255 |
Field: | DESCRIPTORUNIT | Type: | VARCHAR Length: 15 |
Field: | DESCRIPTORSTATUS | Type: | VARCHAR Length: 20 |
Field: | DESCRIPTORBARCODE | Type: | VARCHAR Length: 50 |
Field: | DESCRIPTORCATEGORY | Type: | VARCHAR Length: 20 |
Field: | INTRODATE | Type: | DATE |
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: | STDBUYPRICE | Type: | DOUBLE |
Field: | STDSELLPRICE | Type: | DOUBLE |
Field: | STDSELLPRICEINCTAX | Type: | DOUBLE |
Field: | ROUNDPRICE | Type: | VARCHAR Length: 5 |
Field: | NEARESTAMOUNT | Type: | DOUBLE |
Field: | LASTCOST | Type: | DOUBLE |
Field: | LASTCOSTDATE | Type: | DATE |
Field: | STANDARDCOST | Type: | DOUBLE |
Field: | STANDARDCOSTDATE | Type: | DATE |
Field: | AVERAGECOST | Type: | DOUBLE |
Field: | LEADTIME | Type: | INTEGER |
Field: | PRIMARYSUPPLIER | Type: | VARCHAR Length: 50 |
Field: | WARRANTYAPPLIES | Type: | BOOLEAN |
Field: | WARRANTYCODE | Type: | VARCHAR Length: 20 |
Field: | DESCRIPTORUSE | Type: | VARCHAR Length: 15 |
Field: | COSTCENTRECODE | Type: | VARCHAR Length: 50 |
Field: | LASTRECEIPTDATE | Type: | TIMESTAMP |
Field: | LASTSALEDATE | Type: | TIMESTAMP |
Field: | LASTPRICEUPDATEDATE | Type: | TIMESTAMP |
Field: | RESTRICTPURCHASING | Type: | BOOLEAN |
Field: | DESCRIPTORNOTES | Type: | BLOB |
Field: | SALESNOTES | Type: | BLOB |
Field: | JOBNOTES | Type: | BLOB |
Field: | PURCHASENOTES | Type: | BLOB |
Field: | ASSEMBLYNOTES | Type: | BLOB |
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: | PRICEFROMRECEIPTCOST | Type: | BOOLEAN |
Field: | RECEIPTCOSTMARKUP | Type: | DOUBLE |
Field: | FREEFORMCODESTYLE | Type: | BOOLEAN |
Field: | DUTYPERCENT | Type: | DOUBLE |
Field: | UNITWEIGHT | Type: | DOUBLE |
Field: | UNITVOLUME | Type: | DOUBLE |
Field: | UNITAREA | Type: | DOUBLE |
Field: | RENTALFLAG | Type: | BOOLEAN |
Field: | RENTALITEMCODE | Type: | VARCHAR Length: 50 |
Field: | RENTALDEFAULTQTY | Type: | DOUBLE |
Field: | RENTALQTYLINKEDTODESCRIPTOR | Type: | BOOLEAN |
Field: | DESCRIPTORSUBCATEGORY | Type: | VARCHAR Length: 20 |
Field: | SALESMESSAGE | Type: | VARCHAR Length: 200 |
Field: | JOBMESSAGE | Type: | VARCHAR Length: 200 |
Field: | ASSEMBLYMESSAGE | Type: | VARCHAR Length: 200 |
Field: | PURCHASEMESSAGE | Type: | VARCHAR Length: 200 |
Field: | FREIGHTFLAG | Type: | BOOLEAN |
Field: | ONCHARGEFLAG | Type: | BOOLEAN |
Field: | ONCHARGECUSTOMER | Type: | VARCHAR Length: 50 |
Field: | ONCHARGEACTION | Type: | VARCHAR Length: 20 |
Field: | ACCUMULATECODE | Type: | VARCHAR Length: 50 |
Field: | BUDGETREPRESENTATIVECODE | Type: | VARCHAR Length: 50 |
Field: | EXCLUDEFROMWEB | Type: | BOOLEAN |
Field: | OVERRIDEPICKTIME | Type: | BOOLEAN |
Field: | PICKTIMEINMINUTES | Type: | DOUBLE |
Field: | MULTIPLEBYQTY | 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: | POSSEGMENTEDBARCODE | Type: | BOOLEAN |
Field: | MULTISCAN | Type: | BOOLEAN |
Field: | PICKINGSEQUENCE | Type: | INTEGER |
Field: | INCLUDEINBTOB | Type: | BOOLEAN |
Field: | INCOMECOSTCENTRECODE | Type: | VARCHAR Length: 50 |
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: | MOBILITYQTYSTYLE | Type: | VARCHAR Length: 50 |
Field: | MOBILITYQTYAGGREGATE | Type: | VARCHAR Length: 20 |
Field: | MOBILITYQTYLINKEDTO | Type: | VARCHAR Length: 20 |
Field: | MOBILITYQTYLINKEDASSET | Type: | VARCHAR Length: 30 |
Field: | MOBILITYQTYASSETREADINGNAME | Type: | VARCHAR Length: 50 |
Field: | EXTERNALKEYWORDS | Type: | BLOB |
Field: | MOBILITYQTYCHARGE | Type: | VARCHAR Length: 20 |
Field: | EXCLUDEFROMCONTAINERS | Type: | BOOLEAN |