// Do not edit this file!  It was generated by Melati POEM's DSD preprocessor.
   
   package org.paneris.jammyjoes.model.generated;
   
   import org.melati.poem.AccessPoemException;
   import org.melati.poem.BooleanPoemType;
   import org.melati.poem.Column;
   import org.melati.poem.Database;
   import org.melati.poem.DefinitionSource;
  import org.melati.poem.DisplayLevel;
  import org.melati.poem.DoublePoemType;
  import org.melati.poem.Field;
  import org.melati.poem.IntegerPoemType;
  import org.melati.poem.JdbcPersistent;
  import org.melati.poem.Persistent;
  import org.melati.poem.PoemException;
  import org.melati.poem.ReferencePoemType;
  import org.melati.poem.Searchability;
  import org.melati.poem.StringPoemType;
  import org.melati.poem.TroidPoemType;
  import org.melati.poem.ValidationPoemException;
  import org.paneris.jammyjoes.model.Award;
  import org.paneris.jammyjoes.model.JammyjoesDatabaseTables;
  import org.paneris.jammyjoes.model.JammyjoesTable;
  import org.paneris.jammyjoes.model.Manufacturer;
  import org.paneris.jammyjoes.model.Product;
  import org.paneris.jammyjoes.model.ProductStatus;
  import org.paneris.jammyjoes.model.Sex;
  import org.paneris.jammyjoes.model.Supplier;
  import org.paneris.jammyjoes.model.Type;
  
  
  /**
   * Melati POEM generated base class for 
  <code>Table</code> <code>Product</code>.
   *
   * @generator org.melati.poem.prepro.TableDef#generateTableBaseJava 
   */
  
  public class ProductTableBase extends JammyjoesTable {
  
    private Column col_id = null;
    private Column col_name = null;
    private Column col_status = null;
    private Column col_type = null;
    private Column col_type2 = null;
    private Column col_sex = null;
    private Column col_description = null;
    private Column col_supplier = null;
    private Column col_manufacturer = null;
    private Column col_suppliercode = null;
    private Column col_costprice = null;
    private Column col_retailpriceincvat = null;
    private Column col_vatexempt = null;
    private Column col_saleprice = null;
    private Column col_retailprice = null;
    private Column col_margin = null;
    private Column col_marginpercent = null;
    private Column col_markuppercent = null;
    private Column col_deliverycost = null;
    private Column col_minage = null;
    private Column col_maxage = null;
    private Column col_pieces = null;
    private Column col_stocklevel = null;
    private Column col_reorderlevel = null;
    private Column col_reorderquantity = null;
    private Column col_minimumorder = null;
    private Column col_leadtime = null;
    private Column col_weight = null;
    private Column col_width = null;
    private Column col_height = null;
    private Column col_depth = null;
    private Column col_picture = null;
    private Column col_picture2 = null;
    private Column col_catalogue = null;
    private Column col_deleted = null;
    private Column col_award = null;
    private Column col_onorderquantity = null;
  
   /**
    * Constructor. 
    * 
    * @generator org.melati.poem.prepro.TableDef#generateTableBaseJava 
    * @param database          the POEM database we are using
    * @param name              the name of this <code>Table</code>
    * @param definitionSource  which definition is being used
    * @throws PoemException    if anything goes wrong
    */
  
    public ProductTableBase(
        Database database, String name,
        DefinitionSource definitionSource) throws PoemException {
      super(database, name, definitionSource);
    }
  
  
   /**
    * Get the database tables.
    *
   * @generator org.melati.poem.prepro.TableDef#generateTableBaseJava 
   * @return the database tables
   */
   public JammyjoesDatabaseTables getJammyjoesDatabaseTables() {
     return (JammyjoesDatabaseTables)getDatabase();
   }
 
   public void init() throws PoemException {
     super.init();
     defineColumn(col_id =
         new Column(this, "id",
                    new TroidPoemType(),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getId();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setId((Integer)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getIdField();
           }
 
           protected boolean defaultUserEditable() {
             return false;
           }
 
           protected boolean defaultUserCreateable() {
             return false;
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.summary;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.primary;
           }
 
           protected Integer defaultDisplayOrderPriority() {
             return new Integer(0);
           }
 
           protected boolean defaultSortDescending() {
             return true;
           }
 
           protected int defaultDisplayOrder() {
             return 0;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getId_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setId_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getId();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setId((Integer)raw);
           }
         });
 
     defineColumn(col_name =
         new Column(this, "name",
                    new StringPoemType(false, -1),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getName();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setName((String)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getNameField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.primary;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.yes;
           }
 
           protected String defaultDisplayName() {
             return "Product Name";
           }
 
           protected int defaultDisplayOrder() {
             return 1;
           }
 
           protected int defaultWidth() {
             return 40;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getName_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setName_unsafe((String)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getName();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setName((String)raw);
           }
         });
 
     defineColumn(col_status =
         new Column(this, "status",
                    new ReferencePoemType(getJammyjoesDatabaseTables().
                                              getProductStatusTable(), false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getStatus();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setStatus((ProductStatus)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getStatusField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.yes;
           }
 
           protected int defaultDisplayOrder() {
             return 2;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getStatus_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setStatus_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getStatusTroid();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setStatusTroid((Integer)raw);
           }
         });
 
     defineColumn(col_type =
         new Column(this, "type",
                    new ReferencePoemType(getJammyjoesDatabaseTables().
                                              getTypeTable(), false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getType();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setType((Type)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getTypeField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.yes;
           }
 
           protected int defaultDisplayOrder() {
             return 3;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getType_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setType_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getTypeTroid();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setTypeTroid((Integer)raw);
           }
         });
 
     defineColumn(col_type2 =
         new Column(this, "type2",
                    new ReferencePoemType(getJammyjoesDatabaseTables().
                                              getTypeTable(), true),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getType2();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setType2((Type)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getType2Field();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.yes;
           }
 
           protected int defaultDisplayOrder() {
             return 4;
           }
 
           protected String defaultDescription() {
             return "You can add this product to another category here";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getType2_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setType2_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getType2Troid();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setType2Troid((Integer)raw);
           }
         });
 
     defineColumn(col_sex =
         new Column(this, "sex",
                    new ReferencePoemType(getJammyjoesDatabaseTables().
                                              getSexTable(), true),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getSex();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setSex((Sex)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getSexField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.yes;
           }
 
           protected String defaultDisplayName() {
             return "Gender";
           }
 
           protected int defaultDisplayOrder() {
             return 5;
           }
 
           protected String defaultDescription() {
             return "Is this toy is targeted at boys or girls?";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getSex_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setSex_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getSexTroid();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setSexTroid((Integer)raw);
           }
         });
 
     defineColumn(col_description =
         new Column(this, "description",
                    new StringPoemType(true, -1),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getDescription();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setDescription((String)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getDescriptionField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.yes;
           }
 
           protected String defaultDisplayName() {
             return "Description";
           }
 
           protected int defaultDisplayOrder() {
             return 6;
           }
 
           protected int defaultWidth() {
             return 40;
           }
 
           protected int defaultHeight() {
             return 5;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getDescription_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setDescription_unsafe((String)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getDescription();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setDescription((String)raw);
           }
         });
 
     defineColumn(col_supplier =
         new Column(this, "supplier",
                    new ReferencePoemType(getJammyjoesDatabaseTables().
                                              getSupplierTable(), false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getSupplier();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setSupplier((Supplier)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getSupplierField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.summary;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.yes;
           }
 
           protected String defaultDisplayName() {
             return "Supplier";
           }
 
           protected int defaultDisplayOrder() {
             return 7;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getSupplier_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setSupplier_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getSupplierTroid();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setSupplierTroid((Integer)raw);
           }
         });
 
     defineColumn(col_manufacturer =
         new Column(this, "manufacturer",
                    new ReferencePoemType(getJammyjoesDatabaseTables().
                                              getManufacturerTable(), false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getManufacturer();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setManufacturer((Manufacturer)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getManufacturerField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.yes;
           }
 
           protected String defaultDisplayName() {
             return "Manufacturer";
           }
 
           protected int defaultDisplayOrder() {
             return 8;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getManufacturer_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setManufacturer_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getManufacturerTroid();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setManufacturerTroid((Integer)raw);
           }
         });
 
     defineColumn(col_suppliercode =
         new Column(this, "suppliercode",
                    new StringPoemType(true, -1),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getSuppliercode();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setSuppliercode((String)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getSuppliercodeField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.yes;
           }
 
           protected String defaultDisplayName() {
             return "Supplier's Product Code";
           }
 
           protected int defaultDisplayOrder() {
             return 9;
           }
 
           protected int defaultWidth() {
             return 20;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getSuppliercode_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setSuppliercode_unsafe((String)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getSuppliercode();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setSuppliercode((String)raw);
           }
         });
 
     defineColumn(col_costprice =
         new Column(this, "costprice",
                    new DoublePoemType(false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getCostprice();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setCostprice((Double)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getCostpriceField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "Cost Price";
           }
 
           protected int defaultDisplayOrder() {
             return 10;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getCostprice_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setCostprice_unsafe((Double)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getCostprice();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setCostprice((Double)raw);
           }
         });
 
     defineColumn(col_retailpriceincvat =
         new Column(this, "retailpriceincvat",
                    new DoublePoemType(false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getRetailpriceincvat();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setRetailpriceincvat((Double)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getRetailpriceincvatField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "Retail Price inc VAT (if VAT is payable)";
           }
 
           protected int defaultDisplayOrder() {
             return 11;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getRetailpriceincvat_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setRetailpriceincvat_unsafe((Double)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getRetailpriceincvat();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setRetailpriceincvat((Double)raw);
           }
         });
 
     defineColumn(col_vatexempt =
         new Column(this, "vatexempt",
                    new BooleanPoemType(false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getVatexempt();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setVatexempt((Boolean)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getVatexemptField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.yes;
           }
 
           protected String defaultDisplayName() {
             return "Exempt from VAT?";
           }
 
           protected int defaultDisplayOrder() {
             return 12;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getVatexempt_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setVatexempt_unsafe((Boolean)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getVatexempt();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setVatexempt((Boolean)raw);
           }
         });
 
     defineColumn(col_saleprice =
         new Column(this, "saleprice",
                    new DoublePoemType(true),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getSaleprice();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setSaleprice((Double)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getSalepriceField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "Pre Discount Price inc VAT";
           }
 
           protected int defaultDisplayOrder() {
             return 13;
           }
 
           protected String defaultDescription() {
             return "To put items in the sale, enter the original price here, and put the Sale price into the Retail Price inc VAT field";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getSaleprice_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setSaleprice_unsafe((Double)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getSaleprice();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setSaleprice((Double)raw);
           }
         });
 
     defineColumn(col_retailprice =
         new Column(this, "retailprice",
                    new DoublePoemType(false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getRetailprice();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setRetailprice((Double)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getRetailpriceField();
           }
 
           protected boolean defaultUserEditable() {
             return false;
           }
 
           protected boolean defaultUserCreateable() {
             return false;
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "Retail Price ex VAT";
           }
 
           protected int defaultDisplayOrder() {
             return 14;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getRetailprice_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setRetailprice_unsafe((Double)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getRetailprice();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setRetailprice((Double)raw);
           }
         });
 
     defineColumn(col_margin =
         new Column(this, "margin",
                    new DoublePoemType(true),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getMargin();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setMargin((Double)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getMarginField();
           }
 
           protected boolean defaultUserEditable() {
             return false;
           }
 
           protected boolean defaultUserCreateable() {
             return false;
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "Margin / Markup";
           }
 
           protected int defaultDisplayOrder() {
             return 15;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getMargin_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setMargin_unsafe((Double)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getMargin();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setMargin((Double)raw);
           }
         });
 
     defineColumn(col_marginpercent =
         new Column(this, "marginpercent",
                    new DoublePoemType(true),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getMarginpercent();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setMarginpercent((Double)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getMarginpercentField();
           }
 
           protected boolean defaultUserEditable() {
             return false;
           }
 
           protected boolean defaultUserCreateable() {
             return false;
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "Margin Percent";
           }
 
           protected int defaultDisplayOrder() {
             return 16;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getMarginpercent_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setMarginpercent_unsafe((Double)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getMarginpercent();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setMarginpercent((Double)raw);
           }
         });
 
     defineColumn(col_markuppercent =
         new Column(this, "markuppercent",
                    new DoublePoemType(true),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getMarkuppercent();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setMarkuppercent((Double)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getMarkuppercentField();
           }
 
           protected boolean defaultUserEditable() {
             return false;
           }
 
           protected boolean defaultUserCreateable() {
             return false;
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "Markup Percent";
           }
 
           protected int defaultDisplayOrder() {
             return 17;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getMarkuppercent_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setMarkuppercent_unsafe((Double)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getMarkuppercent();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setMarkuppercent((Double)raw);
           }
         });
 
     defineColumn(col_deliverycost =
         new Column(this, "deliverycost",
                    new DoublePoemType(true),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getDeliverycost();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setDeliverycost((Double)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getDeliverycostField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected Integer defaultDisplayOrderPriority() {
             return new Integer(99);
           }
 
           protected String defaultDisplayName() {
             return "Delivery Cost";
           }
 
           protected int defaultDisplayOrder() {
             return 18;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getDeliverycost_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setDeliverycost_unsafe((Double)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getDeliverycost();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setDeliverycost((Double)raw);
           }
         });
 
     defineColumn(col_minage =
         new Column(this, "minage",
                    new IntegerPoemType(true),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getMinage();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setMinage((Integer)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getMinageField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "Minimum Age";
           }
 
           protected int defaultDisplayOrder() {
             return 19;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getMinage_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setMinage_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getMinage();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setMinage((Integer)raw);
           }
         });
 
     defineColumn(col_maxage =
         new Column(this, "maxage",
                    new IntegerPoemType(true),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getMaxage();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setMaxage((Integer)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getMaxageField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "Maximum Age";
           }
 
           protected int defaultDisplayOrder() {
             return 20;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getMaxage_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setMaxage_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getMaxage();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setMaxage((Integer)raw);
           }
         });
 
     defineColumn(col_pieces =
         new Column(this, "pieces",
                    new IntegerPoemType(true),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getPieces();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setPieces((Integer)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getPiecesField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "Number of Pieces";
           }
 
           protected int defaultDisplayOrder() {
             return 21;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getPieces_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setPieces_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getPieces();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setPieces((Integer)raw);
           }
         });
 
     defineColumn(col_stocklevel =
         new Column(this, "stocklevel",
                    new IntegerPoemType(true),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getStocklevel();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setStocklevel((Integer)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getStocklevelField();
           }
 
           protected boolean defaultUserEditable() {
             return false;
           }
 
           protected boolean defaultUserCreateable() {
             return false;
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "Stock Level";
           }
 
           protected int defaultDisplayOrder() {
             return 22;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getStocklevel_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setStocklevel_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getStocklevel();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setStocklevel((Integer)raw);
           }
         });
 
     defineColumn(col_reorderlevel =
         new Column(this, "reorderlevel",
                    new IntegerPoemType(false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getReorderlevel();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setReorderlevel((Integer)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getReorderlevelField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "Reorder Level";
           }
 
           protected int defaultDisplayOrder() {
             return 23;
           }
 
           protected String defaultDescription() {
             return "The level at which stock needs to fall to before JammyJoes normally orders";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getReorderlevel_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setReorderlevel_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getReorderlevel();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setReorderlevel((Integer)raw);
           }
         });
 
     defineColumn(col_reorderquantity =
         new Column(this, "reorderquantity",
                    new IntegerPoemType(false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getReorderquantity();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setReorderquantity((Integer)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getReorderquantityField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "Reorder Quantity";
           }
 
           protected int defaultDisplayOrder() {
             return 24;
           }
 
           protected String defaultDescription() {
             return "The quantity that JammyJoes normally orders";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getReorderquantity_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setReorderquantity_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getReorderquantity();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setReorderquantity((Integer)raw);
           }
         });
 
     defineColumn(col_minimumorder =
         new Column(this, "minimumorder",
                    new IntegerPoemType(true),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getMinimumorder();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setMinimumorder((Integer)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getMinimumorderField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "Minimum Order Quantity";
           }
 
           protected int defaultDisplayOrder() {
             return 25;
           }
 
           protected String defaultDescription() {
             return "The minimum quantity that can be ordered";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getMinimumorder_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setMinimumorder_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getMinimumorder();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setMinimumorder((Integer)raw);
           }
         });
 
     defineColumn(col_leadtime =
         new Column(this, "leadtime",
                    new IntegerPoemType(true),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getLeadtime();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setLeadtime((Integer)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getLeadtimeField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "Lead Time (Days)";
           }
 
           protected int defaultDisplayOrder() {
             return 26;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getLeadtime_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setLeadtime_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getLeadtime();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setLeadtime((Integer)raw);
           }
         });
 
     defineColumn(col_weight =
         new Column(this, "weight",
                    new DoublePoemType(true),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getWeight();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setWeight((Double)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getWeightField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "Weight in Grammes";
           }
 
           protected int defaultDisplayOrder() {
             return 27;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getWeight_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setWeight_unsafe((Double)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getWeight();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setWeight((Double)raw);
           }
         });
 
     defineColumn(col_width =
         new Column(this, "width",
                    new DoublePoemType(true),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getWidth();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setWidth((Double)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getWidthField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.detail;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "Width (or size) in cm";
           }
 
           protected int defaultDisplayOrder() {
             return 28;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getWidth_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setWidth_unsafe((Double)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getWidth();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setWidth((Double)raw);
           }
         });
 
     defineColumn(col_height =
         new Column(this, "height",
                    new DoublePoemType(true),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getHeight();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setHeight((Double)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getHeightField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.detail;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "Height in cm";
           }
 
           protected int defaultDisplayOrder() {
             return 29;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getHeight_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setHeight_unsafe((Double)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getHeight();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setHeight((Double)raw);
           }
         });
 
     defineColumn(col_depth =
         new Column(this, "depth",
                    new DoublePoemType(true),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getDepth();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setDepth((Double)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getDepthField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.detail;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "Depth in cm";
           }
 
           protected int defaultDisplayOrder() {
             return 30;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getDepth_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setDepth_unsafe((Double)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getDepth();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setDepth((Double)raw);
           }
         });
 
     defineColumn(col_picture =
         new Column(this, "picture",
                    new StringPoemType(true, -1),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getPicture();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setPicture((String)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getPictureField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "Small Picture";
           }
 
           protected int defaultDisplayOrder() {
             return 31;
           }
 
           protected int defaultWidth() {
             return 20;
           }
 
           protected String defaultRenderinfo() {
             return "ImageUpload";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getPicture_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setPicture_unsafe((String)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getPicture();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setPicture((String)raw);
           }
         });
 
     defineColumn(col_picture2 =
         new Column(this, "picture2",
                    new StringPoemType(true, -1),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getPicture2();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setPicture2((String)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getPicture2Field();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "Big Picture";
           }
 
           protected int defaultDisplayOrder() {
             return 32;
           }
 
           protected int defaultWidth() {
             return 20;
           }
 
           protected String defaultRenderinfo() {
             return "ImageUpload";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getPicture2_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setPicture2_unsafe((String)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getPicture2();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setPicture2((String)raw);
           }
         });
 
     defineColumn(col_catalogue =
         new Column(this, "catalogue",
                    new BooleanPoemType(false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getCatalogue();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setCatalogue((Boolean)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getCatalogueField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.yes;
           }
 
           protected String defaultDisplayName() {
             return "Use in Catalogue?";
           }
 
           protected int defaultDisplayOrder() {
             return 33;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getCatalogue_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setCatalogue_unsafe((Boolean)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getCatalogue();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setCatalogue((Boolean)raw);
           }
         });
 
     defineColumn(col_deleted =
         new Column(this, "deleted",
                    new BooleanPoemType(false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getDeleted();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setDeleted((Boolean)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getDeletedField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.detail;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "Deleted?";
           }
 
           protected int defaultDisplayOrder() {
             return 34;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getDeleted_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setDeleted_unsafe((Boolean)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getDeleted();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setDeleted((Boolean)raw);
           }
         });
 
     defineColumn(col_award =
         new Column(this, "award",
                    new ReferencePoemType(getJammyjoesDatabaseTables().
                                              getAwardTable(), true),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getAward();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setAward((Award)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getAwardField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.never;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected int defaultDisplayOrder() {
             return 35;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getAward_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setAward_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getAwardTroid();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setAwardTroid((Integer)raw);
           }
         });
 
     defineColumn(col_onorderquantity =
         new Column(this, "onorderquantity",
                    new IntegerPoemType(true),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((Product)g).getOnorderquantity();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((Product)g).setOnorderquantity((Integer)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((Product)g).getOnorderquantityField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "On-order Level";
           }
 
           protected int defaultDisplayOrder() {
             return 36;
           }
 
           protected String defaultDescription() {
             return "Not currently used";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getOnorderquantity_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setOnorderquantity_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((Product)g).getOnorderquantity();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((Product)g).setOnorderquantity((Integer)raw);
           }
         });
   }
 
 
  /**
   * Retrieves the <code>Id</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the id <code>Column</code>
   */
   public final Column getIdColumn() {
     return col_id;
   }
 
 
  /**
   * Retrieves the <code>Name</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the name <code>Column</code>
   */
   public final Column getNameColumn() {
     return col_name;
   }
 
 
  /**
   * Retrieves the <code>Status</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the status <code>Column</code>
   */
   public final Column getStatusColumn() {
     return col_status;
   }
 
 
  /**
   * Retrieves the <code>Type</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the type <code>Column</code>
   */
   public final Column getTypeColumn() {
     return col_type;
   }
 
 
  /**
   * Retrieves the <code>Type2</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the type2 <code>Column</code>
   */
   public final Column getType2Column() {
     return col_type2;
   }
 
 
  /**
   * Retrieves the <code>Sex</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the sex <code>Column</code>
   */
   public final Column getSexColumn() {
     return col_sex;
   }
 
 
  /**
   * Retrieves the <code>Description</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the description <code>Column</code>
   */
   public final Column getDescriptionColumn() {
     return col_description;
   }
 
 
  /**
   * Retrieves the <code>Supplier</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the supplier <code>Column</code>
   */
   public final Column getSupplierColumn() {
     return col_supplier;
   }
 
 
  /**
   * Retrieves the <code>Manufacturer</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the manufacturer <code>Column</code>
   */
   public final Column getManufacturerColumn() {
     return col_manufacturer;
   }
 
 
  /**
   * Retrieves the <code>Suppliercode</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the suppliercode <code>Column</code>
   */
   public final Column getSuppliercodeColumn() {
     return col_suppliercode;
   }
 
 
  /**
   * Retrieves the <code>Costprice</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the costprice <code>Column</code>
   */
   public final Column getCostpriceColumn() {
     return col_costprice;
   }
 
 
  /**
   * Retrieves the <code>Retailpriceincvat</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the retailpriceincvat <code>Column</code>
   */
   public final Column getRetailpriceincvatColumn() {
     return col_retailpriceincvat;
   }
 
 
  /**
   * Retrieves the <code>Vatexempt</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the vatexempt <code>Column</code>
   */
   public final Column getVatexemptColumn() {
     return col_vatexempt;
   }
 
 
  /**
   * Retrieves the <code>Saleprice</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the saleprice <code>Column</code>
   */
   public final Column getSalepriceColumn() {
     return col_saleprice;
   }
 
 
  /**
   * Retrieves the <code>Retailprice</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the retailprice <code>Column</code>
   */
   public final Column getRetailpriceColumn() {
     return col_retailprice;
   }
 
 
  /**
   * Retrieves the <code>Margin</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the margin <code>Column</code>
   */
   public final Column getMarginColumn() {
     return col_margin;
   }
 
 
  /**
   * Retrieves the <code>Marginpercent</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the marginpercent <code>Column</code>
   */
   public final Column getMarginpercentColumn() {
     return col_marginpercent;
   }
 
 
  /**
   * Retrieves the <code>Markuppercent</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the markuppercent <code>Column</code>
   */
   public final Column getMarkuppercentColumn() {
     return col_markuppercent;
   }
 
 
  /**
   * Retrieves the <code>Deliverycost</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the deliverycost <code>Column</code>
   */
   public final Column getDeliverycostColumn() {
     return col_deliverycost;
   }
 
 
  /**
   * Retrieves the <code>Minage</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the minage <code>Column</code>
   */
   public final Column getMinageColumn() {
     return col_minage;
   }
 
 
  /**
   * Retrieves the <code>Maxage</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the maxage <code>Column</code>
   */
   public final Column getMaxageColumn() {
     return col_maxage;
   }
 
 
  /**
   * Retrieves the <code>Pieces</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the pieces <code>Column</code>
   */
   public final Column getPiecesColumn() {
     return col_pieces;
   }
 
 
  /**
   * Retrieves the <code>Stocklevel</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the stocklevel <code>Column</code>
   */
   public final Column getStocklevelColumn() {
     return col_stocklevel;
   }
 
 
  /**
   * Retrieves the <code>Reorderlevel</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the reorderlevel <code>Column</code>
   */
   public final Column getReorderlevelColumn() {
     return col_reorderlevel;
   }
 
 
  /**
   * Retrieves the <code>Reorderquantity</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the reorderquantity <code>Column</code>
   */
   public final Column getReorderquantityColumn() {
     return col_reorderquantity;
   }
 
 
  /**
   * Retrieves the <code>Minimumorder</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the minimumorder <code>Column</code>
   */
   public final Column getMinimumorderColumn() {
     return col_minimumorder;
   }
 
 
  /**
   * Retrieves the <code>Leadtime</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the leadtime <code>Column</code>
   */
   public final Column getLeadtimeColumn() {
     return col_leadtime;
   }
 
 
  /**
   * Retrieves the <code>Weight</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the weight <code>Column</code>
   */
   public final Column getWeightColumn() {
     return col_weight;
   }
 
 
  /**
   * Retrieves the <code>Width</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the width <code>Column</code>
   */
   public final Column getWidthColumn() {
     return col_width;
   }
 
 
  /**
   * Retrieves the <code>Height</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the height <code>Column</code>
   */
   public final Column getHeightColumn() {
     return col_height;
   }
 
 
  /**
   * Retrieves the <code>Depth</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the depth <code>Column</code>
   */
   public final Column getDepthColumn() {
     return col_depth;
   }
 
 
  /**
   * Retrieves the <code>Picture</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the picture <code>Column</code>
   */
   public final Column getPictureColumn() {
     return col_picture;
   }
 
 
  /**
   * Retrieves the <code>Picture2</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the picture2 <code>Column</code>
   */
   public final Column getPicture2Column() {
     return col_picture2;
   }
 
 
  /**
   * Retrieves the <code>Catalogue</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the catalogue <code>Column</code>
   */
   public final Column getCatalogueColumn() {
     return col_catalogue;
   }
 
 
  /**
   * Retrieves the <code>Deleted</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the deleted <code>Column</code>
   */
   public final Column getDeletedColumn() {
     return col_deleted;
   }
 
 
  /**
   * Retrieves the <code>Award</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the award <code>Column</code>
   */
   public final Column getAwardColumn() {
     return col_award;
   }
 
 
  /**
   * Retrieves the <code>Onorderquantity</code> <code>Column</code> for this 
   * <code>Product</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the onorderquantity <code>Column</code>
   */
   public final Column getOnorderquantityColumn() {
     return col_onorderquantity;
   }
 
 
  /**
   * Retrieve the <code>Product</code> as a <code>Product</code>.
   *
   * @generator org.melati.poem.prepro.TableDef#generateTableBaseJava 
   * @param troid a Table Row Oject ID
   * @return the <code>Persistent</code> identified by the <code>troid</code>
   */
   public Product getProductObject(Integer troid) {
     return (Product)getObject(troid);
   }
 
 
  /**
   * Retrieve the <code>Product</code> 
   * as a <code>Product</code>.
   *
   * @generator org.melati.poem.prepro.TableDef#generateTableBaseJava 
   * @param troid a Table Row Object ID
   * @return the <code>Persistent</code> identified   */
   public Product getProductObject(int troid) {
     return (Product)getObject(troid);
   }
 
   protected JdbcPersistent _newPersistent() {
     return new Product();
   }
   protected String defaultDisplayName() {
     return "Products";
   }
 
   protected String defaultDescription() {
     return "JammyJoes Products";
   }
 
   protected boolean defaultRememberAllTroids() {
     return true;
   }
 
   protected Integer defaultCacheLimit() {
     return new Integer(999999999);
   }
 
   protected String defaultCategory() {
     return "Data";
   }
 
   protected int defaultDisplayOrder() {
     return 10;
   }
 }