Column c = _getShopOrderItemTable().getIdColumn();
    return new Field(c.getRaw(this), c);
  }


 /**
  * Retrieves the <code>User</code> value, without locking, 
  * for this <code>ShopOrderItem</code> <code>Persistent</code>.
  *
  * @generator org.melati.poem.prepro.FieldDef#generateBaseMethods 
  * @return the Integer user
  */
  public Integer getUser_unsafe() {
    return user;
  }


 /**
  * Sets the <code>User</code> value directly, without checking, 
  * for this ShopOrderItem <code>Persistent</code>.
  * 
  * @generator org.melati.poem.prepro.FieldDef#generateBaseMethods 
  * @param cooked  the pre-validated value to set
  */
  public void setUser_unsafe(Integer cooked) {
    user = cooked;
  }

 /**
  * Retrieves the Table Row Object ID. 
  *
  * @generator org.melati.poem.prepro.ReferenceFieldDef#generateBaseMethods 
  * @throws AccessPoemException  
  *         if the current <code>AccessToken</code> 
  *         does not confer read access rights 
  * @return the TROID as an <code>Integer</code> 
  */

  public Integer getUserTroid()
      throws AccessPoemException {
    readLock();
    return getUser_unsafe();
  }


 /**
  * Sets the Table Row Object ID. 
  * 
  * @generator org.melati.poem.prepro.ReferenceFieldDef#generateBaseMethods 
  * @param raw  a Table Row Object Id 
  * @throws AccessPoemException  
  *         if the current <code>AccessToken</code> 
  *         does not confer write access rights
  */
  public void setUserTroid(Integer raw)
      throws AccessPoemException {
    setUser(raw == null ? null : 
        (User)getJammyjoesDatabaseTables().getUserTable().getUserObject(raw));
  }


 /**
  * Retrieves the <code>User</code> object referred to.
  *  
  * @generator org.melati.poem.prepro.ReferenceFieldDef#generateBaseMethods 
  * @throws AccessPoemException  
  *         if the current <code>AccessToken</code> 
  *         does not confer read access rights 
  * @throws NoSuchRowPoemException  
  *         if the <code>Persistent</code> has yet to be allocated a TROID 
  * @return the <code>User</code> as a <code>User</code> 
  */
  public User getUser()
      throws AccessPoemException, NoSuchRowPoemException {
    Integer troid = getUserTroid();
    return troid == null ? null :
        (User)getJammyjoesDatabaseTables().getUserTable().getUserObject(troid);
  }


 /**
  * Set the User.
  * 
  * @generator org.melati.poem.prepro.ReferenceFieldDef#generateBaseMethods 
  * @param cooked  a validated <code>User</code>
  * @throws AccessPoemException  
  *         if the current <code>AccessToken</code> 
  *         does not confer write access rights 
  */
  public void setUser(User cooked)
      throws AccessPoemException {

    Column c = _getUserTable().getCurrencyColumn();
    return new Field(c.getRaw(this), c);
  }


 /**
  * Retrieves the <code>Zone</code> value, without locking, 
  * for this <code>User</code> <code>Persistent</code>.
  *
  * @generator org.melati.poem.prepro.FieldDef#generateBaseMethods 
  * @return the Integer zone
  */
  public Integer getZone_unsafe() {
    return zone;
  }


 /**
  * Sets the <code>Zone</code> value directly, without checking, 
  * for this User <code>Persistent</code>.
  * 
  * @generator org.melati.poem.prepro.FieldDef#generateBaseMethods 
  * @param cooked  the pre-validated value to set
  */
  public void setZone_unsafe(Integer cooked) {
    zone = cooked;
  }

 /**
  * Retrieves the Table Row Object ID. 
  *
  * @generator org.melati.poem.prepro.ReferenceFieldDef#generateBaseMethods 
  * @throws AccessPoemException  
  *         if the current <code>AccessToken</code> 
  *         does not confer read access rights 
  * @return the TROID as an <code>Integer</code> 
  */

  public Integer getZoneTroid()
      throws AccessPoemException {
    readLock();
    return getZone_unsafe();
  }


 /**
  * Sets the Table Row Object ID. 
  * 
  * @generator org.melati.poem.prepro.ReferenceFieldDef#generateBaseMethods 
  * @param raw  a Table Row Object Id 
  * @throws AccessPoemException  
  *         if the current <code>AccessToken</code> 
  *         does not confer write access rights
  */
  public void setZoneTroid(Integer raw)
      throws AccessPoemException {
    setZone(raw == null ? null : 
        getJammyjoesDatabaseTables().getDeliveryZoneTable().getDeliveryZoneObject(raw));
  }


 /**
  * Retrieves the <code>Zone</code> object referred to.
  *  
  * @generator org.melati.poem.prepro.ReferenceFieldDef#generateBaseMethods 
  * @throws AccessPoemException  
  *         if the current <code>AccessToken</code> 
  *         does not confer read access rights 
  * @throws NoSuchRowPoemException  
  *         if the <code>Persistent</code> has yet to be allocated a TROID 
  * @return the <code>Zone</code> as a <code>DeliveryZone</code> 
  */
  public DeliveryZone getZone()
      throws AccessPoemException, NoSuchRowPoemException {
    Integer troid = getZoneTroid();
    return troid == null ? null :
        getJammyjoesDatabaseTables().getDeliveryZoneTable().getDeliveryZoneObject(troid);
  }


 /**
  * Set the Zone.
  * 
  * @generator org.melati.poem.prepro.ReferenceFieldDef#generateBaseMethods 
  * @param cooked  a validated <code>DeliveryZone</code>
  * @throws AccessPoemException  
  *         if the current <code>AccessToken</code> 
  *         does not confer write access rights 
  */
  public void setZone(DeliveryZone cooked)
      throws AccessPoemException {

    Column c = _getUserTable().getCountryColumn();
    return new Field(c.getRaw(this), c);
  }


 /**
  * Retrieves the <code>Currency</code> value, without locking, 
  * for this <code>User</code> <code>Persistent</code>.
  *
  * @generator org.melati.poem.prepro.FieldDef#generateBaseMethods 
  * @return the Integer currency
  */
  public Integer getCurrency_unsafe() {
    return currency;
  }


 /**
  * Sets the <code>Currency</code> value directly, without checking, 
  * for this User <code>Persistent</code>.
  * 
  * @generator org.melati.poem.prepro.FieldDef#generateBaseMethods 
  * @param cooked  the pre-validated value to set
  */
  public void setCurrency_unsafe(Integer cooked) {
    currency = cooked;
  }

 /**
  * Retrieves the Table Row Object ID. 
  *
  * @generator org.melati.poem.prepro.ReferenceFieldDef#generateBaseMethods 
  * @throws AccessPoemException  
  *         if the current <code>AccessToken</code> 
  *         does not confer read access rights 
  * @return the TROID as an <code>Integer</code> 
  */

  public Integer getCurrencyTroid()
      throws AccessPoemException {
    readLock();
    return getCurrency_unsafe();
  }


 /**
  * Sets the Table Row Object ID. 
  * 
  * @generator org.melati.poem.prepro.ReferenceFieldDef#generateBaseMethods 
  * @param raw  a Table Row Object Id 
  * @throws AccessPoemException  
  *         if the current <code>AccessToken</code> 
  *         does not confer write access rights
  */
  public void setCurrencyTroid(Integer raw)
      throws AccessPoemException {
    setCurrency(raw == null ? null : 
        getJammyjoesDatabaseTables().getShopCurrencyTable().getShopCurrencyObject(raw));
  }


 /**
  * Retrieves the <code>Currency</code> object referred to.
  *  
  * @generator org.melati.poem.prepro.ReferenceFieldDef#generateBaseMethods 
  * @throws AccessPoemException  
  *         if the current <code>AccessToken</code> 
  *         does not confer read access rights 
  * @throws NoSuchRowPoemException  
  *         if the <code>Persistent</code> has yet to be allocated a TROID 
  * @return the <code>Currency</code> as a <code>ShopCurrency</code> 
  */
  public ShopCurrency getCurrency()
      throws AccessPoemException, NoSuchRowPoemException {
    Integer troid = getCurrencyTroid();
    return troid == null ? null :
        getJammyjoesDatabaseTables().getShopCurrencyTable().getShopCurrencyObject(troid);
  }


 /**
  * Set the Currency.
  * 
  * @generator org.melati.poem.prepro.ReferenceFieldDef#generateBaseMethods 
  * @param cooked  a validated <code>ShopCurrency</code>
  * @throws AccessPoemException  
  *         if the current <code>AccessToken</code> 
  *         does not confer write access rights 
  */
  public void setCurrency(ShopCurrency cooked)
      throws AccessPoemException {

    Column c = _getUserTable().getCurrencyColumn();
    return new Field(c.getRaw(this), c);
  }


 /**
  * Retrieves the <code>Zone</code> value, without locking, 
  * for this <code>User</code> <code>Persistent</code>.
  *
  * @generator org.melati.poem.prepro.FieldDef#generateBaseMethods 
  * @return the Integer zone
  */
  public Integer getZone_unsafe() {
    return zone;
  }


 /**
  * Sets the <code>Zone</code> value directly, without checking, 
  * for this User <code>Persistent</code>.
  * 
  * @generator org.melati.poem.prepro.FieldDef#generateBaseMethods 
  * @param cooked  the pre-validated value to set
  */
  public void setZone_unsafe(Integer cooked) {
    zone = cooked;
  }

 /**
  * Retrieves the Table Row Object ID. 
  *
  * @generator org.melati.poem.prepro.ReferenceFieldDef#generateBaseMethods 
  * @throws AccessPoemException  
  *         if the current <code>AccessToken</code> 
  *         does not confer read access rights 
  * @return the TROID as an <code>Integer</code> 
  */

  public Integer getZoneTroid()
      throws AccessPoemException {
    readLock();
    return getZone_unsafe();
  }


 /**
  * Sets the Table Row Object ID. 
  * 
  * @generator org.melati.poem.prepro.ReferenceFieldDef#generateBaseMethods 
  * @param raw  a Table Row Object Id 
  * @throws AccessPoemException  
  *         if the current <code>AccessToken</code> 
  *         does not confer write access rights
  */
  public void setZoneTroid(Integer raw)
      throws AccessPoemException {
    setZone(raw == null ? null : 
        getJammyjoesDatabaseTables().getDeliveryZoneTable().getDeliveryZoneObject(raw));
  }


 /**
  * Retrieves the <code>Zone</code> object referred to.
  *  
  * @generator org.melati.poem.prepro.ReferenceFieldDef#generateBaseMethods 
  * @throws AccessPoemException  
  *         if the current <code>AccessToken</code> 
  *         does not confer read access rights 
  * @throws NoSuchRowPoemException  
  *         if the <code>Persistent</code> has yet to be allocated a TROID 
  * @return the <code>Zone</code> as a <code>DeliveryZone</code> 
  */
  public DeliveryZone getZone()
      throws AccessPoemException, NoSuchRowPoemException {
    Integer troid = getZoneTroid();
    return troid == null ? null :
        getJammyjoesDatabaseTables().getDeliveryZoneTable().getDeliveryZoneObject(troid);
  }


 /**
  * Set the Zone.
  * 
  * @generator org.melati.poem.prepro.ReferenceFieldDef#generateBaseMethods 
  * @param cooked  a validated <code>DeliveryZone</code>
  * @throws AccessPoemException  
  *         if the current <code>AccessToken</code> 
  *         does not confer write access rights 
  */
  public void setZone(DeliveryZone cooked)
      throws AccessPoemException {

    Column c = _getStockTransactionTable().getDateColumn();
    return new Field(c.getRaw(this), c);
  }


 /**
  * Retrieves the <code>Product</code> value, without locking, 
  * for this <code>StockTransaction</code> <code>Persistent</code>.
  *
  * @generator org.melati.poem.prepro.FieldDef#generateBaseMethods 
  * @return the Integer product
  */
  public Integer getProduct_unsafe() {
    return product;
  }


 /**
  * Sets the <code>Product</code> value directly, without checking, 
  * for this StockTransaction <code>Persistent</code>.
  * 
  * @generator org.melati.poem.prepro.FieldDef#generateBaseMethods 
  * @param cooked  the pre-validated value to set
  */
  public void setProduct_unsafe(Integer cooked) {
    product = cooked;
  }

 /**
  * Retrieves the Table Row Object ID. 
  *
  * @generator org.melati.poem.prepro.ReferenceFieldDef#generateBaseMethods 
  * @throws AccessPoemException  
  *         if the current <code>AccessToken</code> 
  *         does not confer read access rights 
  * @return the TROID as an <code>Integer</code> 
  */

  public Integer getProductTroid()
      throws AccessPoemException {
    readLock();
    return getProduct_unsafe();
  }


 /**
  * Sets the Table Row Object ID. 
  * 
  * @generator org.melati.poem.prepro.ReferenceFieldDef#generateBaseMethods 
  * @param raw  a Table Row Object Id 
  * @throws AccessPoemException  
  *         if the current <code>AccessToken</code> 
  *         does not confer write access rights
  */
  public void setProductTroid(Integer raw)
      throws AccessPoemException {
    setProduct(raw == null ? null : 
        getJammyjoesDatabaseTables().getProductTable().getProductObject(raw));
  }


 /**
  * Retrieves the <code>Product</code> object referred to.
  *  
  * @generator org.melati.poem.prepro.ReferenceFieldDef#generateBaseMethods 
  * @throws AccessPoemException  
  *         if the current <code>AccessToken</code> 
  *         does not confer read access rights 
  * @throws NoSuchRowPoemException  
  *         if the <code>Persistent</code> has yet to be allocated a TROID 
  * @return the <code>Product</code> as a <code>Product</code> 
  */
  public Product getProduct()
      throws AccessPoemException, NoSuchRowPoemException {
    Integer troid = getProductTroid();
    return troid == null ? null :
        getJammyjoesDatabaseTables().getProductTable().getProductObject(troid);
  }


 /**
  * Set the Product.
  * 
  * @generator org.melati.poem.prepro.ReferenceFieldDef#generateBaseMethods 
  * @param cooked  a validated <code>Product</code>
  * @throws AccessPoemException  
  *         if the current <code>AccessToken</code> 
  *         does not confer write access rights 
  */
  public void setProduct(Product cooked)
      throws AccessPoemException {

    Column c = _getUserTable().getZoneColumn();
    return new Field(c.getRaw(this), c);
  }


 /**
  * Retrieves the <code>Affiliate</code> value, without locking, 
  * for this <code>User</code> <code>Persistent</code>.
  *
  * @generator org.melati.poem.prepro.FieldDef#generateBaseMethods 
  * @return the Integer affiliate
  */
  public Integer getAffiliate_unsafe() {
    return affiliate;
  }


 /**
  * Sets the <code>Affiliate</code> value directly, without checking, 
  * for this User <code>Persistent</code>.
  * 
  * @generator org.melati.poem.prepro.FieldDef#generateBaseMethods 
  * @param cooked  the pre-validated value to set
  */
  public void setAffiliate_unsafe(Integer cooked) {
    affiliate = cooked;
  }

 /**
  * Retrieves the Table Row Object ID. 
  *
  * @generator org.melati.poem.prepro.ReferenceFieldDef#generateBaseMethods 
  * @throws AccessPoemException  
  *         if the current <code>AccessToken</code> 
  *         does not confer read access rights 
  * @return the TROID as an <code>Integer</code> 
  */

  public Integer getAffiliateTroid()
      throws AccessPoemException {
    readLock();
    return getAffiliate_unsafe();
  }


 /**
  * Sets the Table Row Object ID. 
  * 
  * @generator org.melati.poem.prepro.ReferenceFieldDef#generateBaseMethods 
  * @param raw  a Table Row Object Id 
  * @throws AccessPoemException  
  *         if the current <code>AccessToken</code> 
  *         does not confer write access rights
  */
  public void setAffiliateTroid(Integer raw)
      throws AccessPoemException {
    setAffiliate(raw == null ? null : 
        getJammyjoesDatabaseTables().getAffiliateTable().getAffiliateObject(raw));
  }


 /**
  * Retrieves the <code>Affiliate</code> object referred to.
  *  
  * @generator org.melati.poem.prepro.ReferenceFieldDef#generateBaseMethods 
  * @throws AccessPoemException  
  *         if the current <code>AccessToken</code> 
  *         does not confer read access rights 
  * @throws NoSuchRowPoemException  
  *         if the <code>Persistent</code> has yet to be allocated a TROID 
  * @return the <code>Affiliate</code> as a <code>Affiliate</code> 
  */
  public Affiliate getAffiliate()
      throws AccessPoemException, NoSuchRowPoemException {
    Integer troid = getAffiliateTroid();
    return troid == null ? null :
        getJammyjoesDatabaseTables().getAffiliateTable().getAffiliateObject(troid);
  }


 /**
  * Set the Affiliate.
  * 
  * @generator org.melati.poem.prepro.ReferenceFieldDef#generateBaseMethods 
  * @param cooked  a validated <code>Affiliate</code>
  * @throws AccessPoemException  
  *         if the current <code>AccessToken</code> 
  *         does not confer write access rights 
  */
  public void setAffiliate(Affiliate cooked)
      throws AccessPoemException {

    Column c = _getDeliveryChargeTable().getIdColumn();
    return new Field(c.getRaw(this), c);
  }


 /**
  * Retrieves the <code>Zone</code> value, without locking, 
  * for this <code>DeliveryCharge</code> <code>Persistent</code>.
  *
  * @generator org.melati.poem.prepro.FieldDef#generateBaseMethods 
  * @return the Integer zone
  */
  public Integer getZone_unsafe() {
    return zone;
  }


 /**
  * Sets the <code>Zone</code> value directly, without checking, 
  * for this DeliveryCharge <code>Persistent</code>.
  * 
  * @generator org.melati.poem.prepro.FieldDef#generateBaseMethods 
  * @param cooked  the pre-validated value to set
  */
  public void setZone_unsafe(Integer cooked) {
    zone = cooked;
  }

 /**
  * Retrieves the Table Row Object ID. 
  *
  * @generator org.melati.poem.prepro.ReferenceFieldDef#generateBaseMethods 
  * @throws AccessPoemException  
  *         if the current <code>AccessToken</code> 
  *         does not confer read access rights 
  * @return the TROID as an <code>Integer</code> 
  */

  public Integer getZoneTroid()
      throws AccessPoemException {
    readLock();
    return getZone_unsafe();
  }


 /**
  * Sets the Table Row Object ID. 
  * 
  * @generator org.melati.poem.prepro.ReferenceFieldDef#generateBaseMethods 
  * @param raw  a Table Row Object Id 
  * @throws AccessPoemException  
  *         if the current <code>AccessToken</code> 
  *         does not confer write access rights
  */
  public void setZoneTroid(Integer raw)
      throws AccessPoemException {
    setZone(raw == null ? null : 
        getJammyjoesDatabaseTables().getDeliveryZoneTable().getDeliveryZoneObject(raw));
  }


 /**
  * Retrieves the <code>Zone</code> object referred to.
  *  
  * @generator org.melati.poem.prepro.ReferenceFieldDef#generateBaseMethods 
  * @throws AccessPoemException  
  *         if the current <code>AccessToken</code> 
  *         does not confer read access rights 
  * @throws NoSuchRowPoemException  
  *         if the <code>Persistent</code> has yet to be allocated a TROID 
  * @return the <code>Zone</code> as a <code>DeliveryZone</code> 
  */
  public DeliveryZone getZone()
      throws AccessPoemException, NoSuchRowPoemException {
    Integer troid = getZoneTroid();
    return troid == null ? null :
        getJammyjoesDatabaseTables().getDeliveryZoneTable().getDeliveryZoneObject(troid);
  }


 /**
  * Set the Zone.
  * 
  * @generator org.melati.poem.prepro.ReferenceFieldDef#generateBaseMethods 
  * @param cooked  a validated <code>DeliveryZone</code>
  * @throws AccessPoemException  
  *         if the current <code>AccessToken</code> 
  *         does not confer write access rights 
  */
  public void setZone(DeliveryZone cooked)
      throws AccessPoemException {

      write(out, product.getSuppliercode()+"\t");
      write(out, "http://www.jammyjoes.co.uk/jammyjoes/toys/" + product.getId().toString()+"\t");
      write(out, product.getName()+"\t");
      write(out, product.getDescription()+"\t");
      write(out, "http://www.jammyjoes.co.uk" + product.getPicture()+"\t");
      write(out, product.getType().getType()+"\t");
      write(out, JammyJoesContextUtil.getPriceDisplayWithoutPound(product.getRetailpriceincvat())+"\t");
      write(out, product.getManufacturer().getName()+"\t");