Field Listing for Table CATALOGUELINES

Field:CATALOGUENO Type: DOUBLE
Field:CATALOGUECODE Type: VARCHAR Length: 50
Field:CODEDESCRIPTION Type: VARCHAR Length: 255
Field:CODEUNIT Type: VARCHAR Length: 15
Field:TAXGROUP Type: VARCHAR Length: 10
Field:ANALYSISGROUP Type: VARCHAR Length: 20
Field:CATEGORY Type: VARCHAR Length: 20
Field:STDSELLPRICE Type: DOUBLE
Field:STDBUYPRICE Type: DOUBLE
Field:STANDARDCOST Type: DOUBLE
Field:LINKEDITEMCODE Type: VARCHAR Length: 50
Field:LEADTIME Type: INTEGER
Field:MANUFACTURER Type: VARCHAR Length: 50
Field:BRANDNAME Type: VARCHAR Length: 50
Field:MODELNAME Type: VARCHAR Length: 50
Field:SPECIFICATIONWEBLINK Type: VARCHAR Length: 255
Field:ALTERNATECODE Type: VARCHAR Length: 50
Field:LASTUPDATEDATE Type: DATE
Field:CODENOTES Type: BLOB
Field:SALESNOTES Type: BLOB
Field:JOBNOTES Type: BLOB
Field:PURCHASENOTES Type: BLOB
Field:UNITWEIGHT Type: DOUBLE
Field:UNITVOLUME Type: DOUBLE
Field:UNITAREA Type: DOUBLE
Field:SYSDATECREATED Type: TIMESTAMP
Field:SYSDATEMODIFIED Type: TIMESTAMP
Field:CURRENCYCODE Type: VARCHAR Length: 3
Field:CATALOGUEBARCODE Type: VARCHAR Length: 50
Field:SUBCATEGORY Type: VARCHAR Length: 20
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:ADDITIONALDATEFIELD_1 Type: DATE
Field:ADDITIONALDATEFIELD_2 Type: DATE
Field:SYSUNIQUEID Type: DOUBLE
Field:SYSUSERCREATED Type: VARCHAR Length: 30
Field:SYSUSERMODIFIED Type: VARCHAR Length: 30