Field Listing for Table DESCRIPTORMASTER

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