// Do not edit this file!  It was generated by Melati POEM's DSD preprocessor.
   
   package org.paneris.jammyjoes.model.generated;
   
   import java.sql.Timestamp;
   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.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.TimestampPoemType;
  import org.melati.poem.TroidPoemType;
  import org.melati.poem.ValidationPoemException;
  import org.paneris.jammyjoes.model.Affiliate;
  import org.paneris.jammyjoes.model.DeliveryZone;
  import org.paneris.jammyjoes.model.JammyjoesDatabaseTables;
  import org.paneris.jammyjoes.model.JammyjoesTable;
  import org.paneris.jammyjoes.model.OrderStatus;
  import org.paneris.jammyjoes.model.OrderType;
  import org.paneris.jammyjoes.model.ShopCurrency;
  import org.paneris.jammyjoes.model.ShopOrder;
  import org.paneris.jammyjoes.model.User;
  import org.paneris.jammyjoes.model.Wrapping;
  
  
  /**
   * Melati POEM generated base class for 
  <code>Table</code> <code>ShopOrder</code>.
   *
   * @generator org.melati.poem.prepro.TableDef#generateTableBaseJava 
   */
  
  public class ShopOrderTableBase extends JammyjoesTable {
  
    private Column col_id = null;
    private Column col_user = null;
    private Column col_operator = null;
    private Column col_status = null;
    private Column col_type = null;
    private Column col_date = null;
    private Column col_fufilleddate = null;
    private Column col_comment = null;
    private Column col_customerComment = null;
    private Column col_alert = null;
    private Column col_message = null;
    private Column col_amount = null;
    private Column col_delivery = null;
    private Column col_amountUK = null;
    private Column col_deliveryUK = null;
    private Column col_name = null;
    private Column col_deliveryName = null;
    private Column col_email = null;
    private Column col_address = null;
    private Column col_town = null;
    private Column col_tel = null;
    private Column col_postcode = null;
    private Column col_country = null;
    private Column col_currency = null;
    private Column col_zone = null;
    private Column col_wrapping = null;
    private Column col_affiliate = null;
    private Column col_affiliatepaid = null;
    private Column col_comission = null;
    private Column col_spam = 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 ShopOrderTableBase(
        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 ((ShopOrder)g).getId();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setId((Integer)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((ShopOrder)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 int defaultDisplayOrder() {
             return 0;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getId_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setId_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getId();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setId((Integer)raw);
           }
         });
 
     defineColumn(col_user =
         new Column(this, "user",
                    new ReferencePoemType(getJammyjoesDatabaseTables().
                                              getUserTable(), false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getUser();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setUser((User)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((ShopOrder)g).getUserField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.summary;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.yes;
           }
 
           protected String defaultDisplayName() {
             return "User";
           }
 
           protected int defaultDisplayOrder() {
             return 1;
           }
 
           protected String defaultDescription() {
             return "The Customer";
           }
 
           protected boolean defaultIndexed() {
             return true;
           }
 
           protected String defaultRenderinfo() {
             return "SelectionWindow";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getUser_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setUser_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getUserTroid();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setUserTroid((Integer)raw);
           }
         });
 
     defineColumn(col_operator =
         new Column(this, "operator",
                    new ReferencePoemType(getJammyjoesDatabaseTables().
                                              getUserTable(), true),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getOperator();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setOperator((User)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((ShopOrder)g).getOperatorField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.yes;
           }
 
           protected String defaultDisplayName() {
             return "Operator";
           }
 
           protected int defaultDisplayOrder() {
             return 2;
           }
 
           protected String defaultDescription() {
             return "The Operator who took this Order";
           }
 
           protected boolean defaultIndexed() {
             return true;
           }
 
           protected String defaultRenderinfo() {
             return "SelectionWindow";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getOperator_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setOperator_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getOperatorTroid();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setOperatorTroid((Integer)raw);
           }
         });
 
     defineColumn(col_status =
         new Column(this, "status",
                    new ReferencePoemType(getJammyjoesDatabaseTables().
                                              getOrderStatusTable(), false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getStatus();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setStatus((OrderStatus)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((ShopOrder)g).getStatusField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.summary;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.yes;
           }
 
           protected String defaultDisplayName() {
             return "Status";
           }
 
           protected int defaultDisplayOrder() {
             return 3;
           }
 
           protected String defaultDescription() {
             return "The status of this order";
           }
 
           protected boolean defaultIndexed() {
             return true;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getStatus_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setStatus_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getStatusTroid();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setStatusTroid((Integer)raw);
           }
         });
 
     defineColumn(col_type =
         new Column(this, "type",
                    new ReferencePoemType(getJammyjoesDatabaseTables().
                                              getOrderTypeTable(), false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getType();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setType((OrderType)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((ShopOrder)g).getTypeField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.yes;
           }
 
           protected String defaultDisplayName() {
             return "Type";
           }
 
           protected int defaultDisplayOrder() {
             return 4;
           }
 
           protected String defaultDescription() {
             return "The type of this order";
           }
 
           protected boolean defaultIndexed() {
             return true;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getType_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setType_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getTypeTroid();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setTypeTroid((Integer)raw);
           }
         });
 
     defineColumn(col_date =
         new Column(this, "date",
                    new TimestampPoemType(true),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getDate();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setDate((Timestamp)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((ShopOrder)g).getDateField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.summary;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.yes;
           }
 
           protected Integer defaultDisplayOrderPriority() {
             return new Integer(1);
           }
 
           protected boolean defaultSortDescending() {
             return true;
           }
 
           protected String defaultDisplayName() {
             return "Date";
           }
 
           protected int defaultDisplayOrder() {
             return 5;
           }
 
           protected String defaultDescription() {
             return "The date that this order was placed (leave blank to autocomplete)";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getDate_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setDate_unsafe((Timestamp)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getDate();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setDate((Timestamp)raw);
           }
         });
 
     defineColumn(col_fufilleddate =
         new Column(this, "fufilleddate",
                    new TimestampPoemType(true),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getFufilleddate();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setFufilleddate((Timestamp)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((ShopOrder)g).getFufilleddateField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected boolean defaultSortDescending() {
             return true;
           }
 
           protected String defaultDisplayName() {
             return "Fufilled Date";
           }
 
           protected int defaultDisplayOrder() {
             return 6;
           }
 
           protected String defaultDescription() {
             return "The date that this order was fufilled (leave blank to autocomplete)";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getFufilleddate_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setFufilleddate_unsafe((Timestamp)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getFufilleddate();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setFufilleddate((Timestamp)raw);
           }
         });
 
     defineColumn(col_comment =
         new Column(this, "comment",
                    new StringPoemType(true, -1),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getComment();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setComment((String)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((ShopOrder)g).getCommentField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.yes;
           }
 
           protected String defaultDisplayName() {
             return "Comment";
           }
 
           protected int defaultDisplayOrder() {
             return 7;
           }
 
           protected String defaultDescription() {
             return "Any comments by JammyJoes people reguarding this order";
           }
 
           protected int defaultWidth() {
             return 30;
           }
 
           protected int defaultHeight() {
             return 5;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getComment_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setComment_unsafe((String)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getComment();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setComment((String)raw);
           }
         });
 
     defineColumn(col_customerComment =
         new Column(this, "customerComment",
                    new StringPoemType(true, -1),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getCustomerComment();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setCustomerComment((String)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((ShopOrder)g).getCustomerCommentField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "Comment";
           }
 
           protected int defaultDisplayOrder() {
             return 8;
           }
 
           protected String defaultDescription() {
             return "Commends by the customer reguarding this order";
           }
 
           protected int defaultWidth() {
             return 30;
           }
 
           protected int defaultHeight() {
             return 5;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getCustomerComment_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setCustomerComment_unsafe((String)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getCustomerComment();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setCustomerComment((String)raw);
           }
         });
 
     defineColumn(col_alert =
         new Column(this, "alert",
                    new BooleanPoemType(false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getAlert();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setAlert((Boolean)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((ShopOrder)g).getAlertField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.yes;
           }
 
           protected Integer defaultDisplayOrderPriority() {
             return new Integer(0);
           }
 
           protected boolean defaultSortDescending() {
             return true;
           }
 
           protected String defaultDisplayName() {
             return "Alert!";
           }
 
           protected int defaultDisplayOrder() {
             return 9;
           }
 
           protected String defaultDescription() {
             return "Please read the comments to find out new actions for this order";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getAlert_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setAlert_unsafe((Boolean)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getAlert();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setAlert((Boolean)raw);
           }
         });
 
     defineColumn(col_message =
         new Column(this, "message",
                    new StringPoemType(true, -1),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getMessage();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setMessage((String)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((ShopOrder)g).getMessageField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.yes;
           }
 
           protected String defaultDisplayName() {
             return "Message";
           }
 
           protected int defaultDisplayOrder() {
             return 10;
           }
 
           protected String defaultDescription() {
             return "A message to be included with this order";
           }
 
           protected int defaultWidth() {
             return 30;
           }
 
           protected int defaultHeight() {
             return 5;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getMessage_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setMessage_unsafe((String)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getMessage();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setMessage((String)raw);
           }
         });
 
     defineColumn(col_amount =
         new Column(this, "amount",
                    new DoublePoemType(false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getAmount();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setAmount((Double)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((ShopOrder)g).getAmountField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "Total Amount (in customer's currency)";
           }
 
           protected int defaultDisplayOrder() {
             return 11;
           }
 
           protected String defaultDescription() {
             return "The total amount of the order (in customer's currency)";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getAmount_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setAmount_unsafe((Double)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getAmount();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setAmount((Double)raw);
           }
         });
 
     defineColumn(col_delivery =
         new Column(this, "delivery",
                    new DoublePoemType(false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getDelivery();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setDelivery((Double)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((ShopOrder)g).getDeliveryField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "Total Delivery (in customer's currency)";
           }
 
           protected int defaultDisplayOrder() {
             return 12;
           }
 
           protected String defaultDescription() {
             return "The total delivery charge for the order (in customer's currency)";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getDelivery_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setDelivery_unsafe((Double)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getDelivery();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setDelivery((Double)raw);
           }
         });
 
     defineColumn(col_amountUK =
         new Column(this, "amountUK",
                    new DoublePoemType(false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getAmountUK();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setAmountUK((Double)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((ShopOrder)g).getAmountUKField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.summary;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "Total Amount";
           }
 
           protected int defaultDisplayOrder() {
             return 13;
           }
 
           protected String defaultDescription() {
             return "The total amount of the order (UK Sterling Equivalent)";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getAmountUK_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setAmountUK_unsafe((Double)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getAmountUK();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setAmountUK((Double)raw);
           }
         });
 
     defineColumn(col_deliveryUK =
         new Column(this, "deliveryUK",
                    new DoublePoemType(false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getDeliveryUK();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setDeliveryUK((Double)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((ShopOrder)g).getDeliveryUKField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "Total Delivery (UK Sterling Equivalent)";
           }
 
           protected int defaultDisplayOrder() {
             return 14;
           }
 
           protected String defaultDescription() {
             return "The total delivery charge for the order (UK Sterling Equivalent)";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getDeliveryUK_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setDeliveryUK_unsafe((Double)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getDeliveryUK();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setDeliveryUK((Double)raw);
           }
         });
 
     defineColumn(col_name =
         new Column(this, "name",
                    new StringPoemType(false, -1),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getName();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setName((String)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((ShopOrder)g).getNameField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected String defaultDisplayName() {
             return "Full name";
           }
 
           protected int defaultDisplayOrder() {
             return 15;
           }
 
           protected String defaultDescription() {
             return "The user's real name";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getName_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setName_unsafe((String)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getName();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setName((String)raw);
           }
         });
 
     defineColumn(col_deliveryName =
         new Column(this, "deliveryName",
                    new StringPoemType(true, -1),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getDeliveryName();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setDeliveryName((String)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((ShopOrder)g).getDeliveryNameField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected String defaultDisplayName() {
             return "Delivery name";
           }
 
           protected int defaultDisplayOrder() {
             return 16;
           }
 
           protected String defaultDescription() {
             return "The name of the persone to whom we are delivering";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getDeliveryName_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setDeliveryName_unsafe((String)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getDeliveryName();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setDeliveryName((String)raw);
           }
         });
 
     defineColumn(col_email =
         new Column(this, "email",
                    new StringPoemType(true, -1),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getEmail();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setEmail((String)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((ShopOrder)g).getEmailField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected int defaultDisplayOrder() {
             return 17;
           }
 
           protected String defaultDescription() {
             return "email";
           }
 
           protected int defaultWidth() {
             return 40;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getEmail_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setEmail_unsafe((String)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getEmail();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setEmail((String)raw);
           }
         });
 
     defineColumn(col_address =
         new Column(this, "address",
                    new StringPoemType(false, -1),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getAddress();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setAddress((String)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((ShopOrder)g).getAddressField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected String defaultDisplayName() {
             return "Address";
           }
 
           protected int defaultDisplayOrder() {
             return 18;
           }
 
           protected int defaultWidth() {
             return 30;
           }
 
           protected int defaultHeight() {
             return 4;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getAddress_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setAddress_unsafe((String)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getAddress();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setAddress((String)raw);
           }
         });
 
     defineColumn(col_town =
         new Column(this, "town",
                    new StringPoemType(false, -1),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getTown();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setTown((String)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((ShopOrder)g).getTownField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected String defaultDisplayName() {
             return "Town / City";
           }
 
           protected int defaultDisplayOrder() {
             return 19;
           }
 
           protected int defaultWidth() {
             return 30;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getTown_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setTown_unsafe((String)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getTown();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setTown((String)raw);
           }
         });
 
     defineColumn(col_tel =
         new Column(this, "tel",
                    new StringPoemType(false, -1),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getTel();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setTel((String)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((ShopOrder)g).getTelField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected String defaultDisplayName() {
             return "Telephone";
           }
 
           protected int defaultDisplayOrder() {
             return 20;
           }
 
           protected String defaultDescription() {
             return "Order telephone number";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getTel_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setTel_unsafe((String)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getTel();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setTel((String)raw);
           }
         });
 
     defineColumn(col_postcode =
         new Column(this, "postcode",
                    new StringPoemType(false, -1),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getPostcode();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setPostcode((String)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((ShopOrder)g).getPostcodeField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected String defaultDisplayName() {
             return "Postcode";
           }
 
           protected int defaultDisplayOrder() {
             return 21;
           }
 
           protected String defaultDescription() {
             return "Order postcode";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getPostcode_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setPostcode_unsafe((String)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getPostcode();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setPostcode((String)raw);
           }
         });
 
     defineColumn(col_country =
         new Column(this, "country",
                    new StringPoemType(false, -1),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getCountry();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setCountry((String)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((ShopOrder)g).getCountryField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.yes;
           }
 
           protected String defaultDisplayName() {
             return "Country";
           }
 
           protected int defaultDisplayOrder() {
             return 22;
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getCountry_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setCountry_unsafe((String)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getCountry();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setCountry((String)raw);
           }
         });
 
     defineColumn(col_currency =
         new Column(this, "currency",
                    new ReferencePoemType(getJammyjoesDatabaseTables().
                                              getShopCurrencyTable(), false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getCurrency();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setCurrency((ShopCurrency)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((ShopOrder)g).getCurrencyField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected int defaultDisplayOrder() {
             return 23;
           }
 
           protected String defaultDescription() {
             return "The currency for this order";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getCurrency_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setCurrency_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getCurrencyTroid();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setCurrencyTroid((Integer)raw);
           }
         });
 
     defineColumn(col_zone =
         new Column(this, "zone",
                    new ReferencePoemType(getJammyjoesDatabaseTables().
                                              getDeliveryZoneTable(), false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getZone();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setZone((DeliveryZone)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((ShopOrder)g).getZoneField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected int defaultDisplayOrder() {
             return 24;
           }
 
           protected String defaultDescription() {
             return "The delivery zone for this order";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getZone_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setZone_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getZoneTroid();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setZoneTroid((Integer)raw);
           }
         });
 
     defineColumn(col_wrapping =
         new Column(this, "wrapping",
                    new ReferencePoemType(getJammyjoesDatabaseTables().
                                              getWrappingTable(), false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getWrapping();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setWrapping((Wrapping)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((ShopOrder)g).getWrappingField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected int defaultDisplayOrder() {
             return 25;
           }
 
           protected String defaultDescription() {
             return "What kind of wrapping paper should be used";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getWrapping_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setWrapping_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getWrappingTroid();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setWrappingTroid((Integer)raw);
           }
         });
 
     defineColumn(col_affiliate =
         new Column(this, "affiliate",
                    new ReferencePoemType(getJammyjoesDatabaseTables().
                                              getAffiliateTable(), true),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getAffiliate();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setAffiliate((Affiliate)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((ShopOrder)g).getAffiliateField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected int defaultDisplayOrder() {
             return 26;
           }
 
           protected String defaultDescription() {
             return "The affiliate for this order (if any)";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getAffiliate_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setAffiliate_unsafe((Integer)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getAffiliateTroid();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setAffiliateTroid((Integer)raw);
           }
         });
 
     defineColumn(col_affiliatepaid =
         new Column(this, "affiliatepaid",
                    new BooleanPoemType(false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getAffiliatepaid();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setAffiliatepaid((Boolean)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((ShopOrder)g).getAffiliatepaidField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "Affiliate Paid?";
           }
 
           protected int defaultDisplayOrder() {
             return 27;
           }
 
           protected String defaultDescription() {
             return "Has the Affiliate been paid for this order?";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getAffiliatepaid_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setAffiliatepaid_unsafe((Boolean)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getAffiliatepaid();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setAffiliatepaid((Boolean)raw);
           }
         });
 
     defineColumn(col_comission =
         new Column(this, "comission",
                    new DoublePoemType(false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getComission();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setComission((Double)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((ShopOrder)g).getComissionField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "Commission Percentage";
           }
 
           protected int defaultDisplayOrder() {
             return 28;
           }
 
           protected String defaultDescription() {
             return "The Commission Percentage to go to the Affiliate";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getComission_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setComission_unsafe((Double)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getComission();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setComission((Double)raw);
           }
         });
 
     defineColumn(col_spam =
         new Column(this, "spam",
                    new BooleanPoemType(false),
                    DefinitionSource.dsd) { 
           public Object getCooked(Persistent g)
               throws AccessPoemException, PoemException {
             return ((ShopOrder)g).getSpam();
           }
 
           public void setCooked(Persistent g, Object cooked)
               throws AccessPoemException, ValidationPoemException {
             ((ShopOrder)g).setSpam((Boolean)cooked);
           }
 
           public Field asField(Persistent g) {
             return ((ShopOrder)g).getSpamField();
           }
 
           protected DisplayLevel defaultDisplayLevel() {
             return DisplayLevel.record;
           }
 
           protected Searchability defaultSearchability() {
             return Searchability.no;
           }
 
           protected String defaultDisplayName() {
             return "Want Spam?";
           }
 
           protected int defaultDisplayOrder() {
             return 29;
           }
 
           protected String defaultDescription() {
             return "Does the user want to receive spam email?";
           }
 
           public Object getRaw_unsafe(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getSpam_unsafe();
           }
 
           public void setRaw_unsafe(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setSpam_unsafe((Boolean)raw);
           }
 
           public Object getRaw(Persistent g)
               throws AccessPoemException {
             return ((ShopOrder)g).getSpam();
           }
 
           public void setRaw(Persistent g, Object raw)
               throws AccessPoemException {
             ((ShopOrder)g).setSpam((Boolean)raw);
           }
         });
   }
 
 
  /**
   * Retrieves the <code>Id</code> <code>Column</code> for this 
   * <code>ShopOrder</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>User</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the user <code>Column</code>
   */
   public final Column getUserColumn() {
     return col_user;
   }
 
 
  /**
   * Retrieves the <code>Operator</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the operator <code>Column</code>
   */
   public final Column getOperatorColumn() {
     return col_operator;
   }
 
 
  /**
   * Retrieves the <code>Status</code> <code>Column</code> for this 
   * <code>ShopOrder</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>ShopOrder</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>Date</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the date <code>Column</code>
   */
   public final Column getDateColumn() {
     return col_date;
   }
 
 
  /**
   * Retrieves the <code>Fufilleddate</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the fufilleddate <code>Column</code>
   */
   public final Column getFufilleddateColumn() {
     return col_fufilleddate;
   }
 
 
  /**
   * Retrieves the <code>Comment</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the comment <code>Column</code>
   */
   public final Column getCommentColumn() {
     return col_comment;
   }
 
 
  /**
   * Retrieves the <code>CustomerComment</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the customerComment <code>Column</code>
   */
   public final Column getCustomerCommentColumn() {
     return col_customerComment;
   }
 
 
  /**
   * Retrieves the <code>Alert</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the alert <code>Column</code>
   */
   public final Column getAlertColumn() {
     return col_alert;
   }
 
 
  /**
   * Retrieves the <code>Message</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the message <code>Column</code>
   */
   public final Column getMessageColumn() {
     return col_message;
   }
 
 
  /**
   * Retrieves the <code>Amount</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the amount <code>Column</code>
   */
   public final Column getAmountColumn() {
     return col_amount;
   }
 
 
  /**
   * Retrieves the <code>Delivery</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the delivery <code>Column</code>
   */
   public final Column getDeliveryColumn() {
     return col_delivery;
   }
 
 
  /**
   * Retrieves the <code>AmountUK</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the amountUK <code>Column</code>
   */
   public final Column getAmountUKColumn() {
     return col_amountUK;
   }
 
 
  /**
   * Retrieves the <code>DeliveryUK</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the deliveryUK <code>Column</code>
   */
   public final Column getDeliveryUKColumn() {
     return col_deliveryUK;
   }
 
 
  /**
   * Retrieves the <code>Name</code> <code>Column</code> for this 
   * <code>ShopOrder</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>DeliveryName</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the deliveryName <code>Column</code>
   */
   public final Column getDeliveryNameColumn() {
     return col_deliveryName;
   }
 
 
  /**
   * Retrieves the <code>Email</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the email <code>Column</code>
   */
   public final Column getEmailColumn() {
     return col_email;
   }
 
 
  /**
   * Retrieves the <code>Address</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the address <code>Column</code>
   */
   public final Column getAddressColumn() {
     return col_address;
   }
 
 
  /**
   * Retrieves the <code>Town</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the town <code>Column</code>
   */
   public final Column getTownColumn() {
     return col_town;
   }
 
 
  /**
   * Retrieves the <code>Tel</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the tel <code>Column</code>
   */
   public final Column getTelColumn() {
     return col_tel;
   }
 
 
  /**
   * Retrieves the <code>Postcode</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the postcode <code>Column</code>
   */
   public final Column getPostcodeColumn() {
     return col_postcode;
   }
 
 
  /**
   * Retrieves the <code>Country</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the country <code>Column</code>
   */
   public final Column getCountryColumn() {
     return col_country;
   }
 
 
  /**
   * Retrieves the <code>Currency</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the currency <code>Column</code>
   */
   public final Column getCurrencyColumn() {
     return col_currency;
   }
 
 
  /**
   * Retrieves the <code>Zone</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the zone <code>Column</code>
   */
   public final Column getZoneColumn() {
     return col_zone;
   }
 
 
  /**
   * Retrieves the <code>Wrapping</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the wrapping <code>Column</code>
   */
   public final Column getWrappingColumn() {
     return col_wrapping;
   }
 
 
  /**
   * Retrieves the <code>Affiliate</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the affiliate <code>Column</code>
   */
   public final Column getAffiliateColumn() {
     return col_affiliate;
   }
 
 
  /**
   * Retrieves the <code>Affiliatepaid</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the affiliatepaid <code>Column</code>
   */
   public final Column getAffiliatepaidColumn() {
     return col_affiliatepaid;
   }
 
 
  /**
   * Retrieves the <code>Comission</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the comission <code>Column</code>
   */
   public final Column getComissionColumn() {
     return col_comission;
   }
 
 
  /**
   * Retrieves the <code>Spam</code> <code>Column</code> for this 
   * <code>ShopOrder</code> <code>Table</code>.
   * 
   * @generator org.melati.poem.prepro.FieldDef#generateColAccessor 
   * @return the spam <code>Column</code>
   */
   public final Column getSpamColumn() {
     return col_spam;
   }
 
 
  /**
   * Retrieve the <code>ShopOrder</code> as a <code>ShopOrder</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 ShopOrder getShopOrderObject(Integer troid) {
     return (ShopOrder)getObject(troid);
   }
 
 
  /**
   * Retrieve the <code>ShopOrder</code> 
   * as a <code>ShopOrder</code>.
   *
   * @generator org.melati.poem.prepro.TableDef#generateTableBaseJava 
   * @param troid a Table Row Object ID
   * @return the <code>Persistent</code> identified   */
   public ShopOrder getShopOrderObject(int troid) {
     return (ShopOrder)getObject(troid);
   }
 
   protected JdbcPersistent _newPersistent() {
     return new ShopOrder();
   }
   protected String defaultDisplayName() {
     return "Order";
   }
 
   protected String defaultDescription() {
     return "A Customer's Order";
   }
 
   protected String defaultCategory() {
     return "Data";
   }
 
   protected int defaultDisplayOrder() {
     return 60;
   }
 }