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 |