oInsertDespatch = oConn.prepareStatement("INSERT INTO k_despatch_advices (gu_despatch,gu_workarea,pg_despatch,gu_shop,id_currency,bo_approved,bo_credit_ok,id_priority,gu_warehouse,dt_modified,dt_delivered,dt_printed,dt_promised,dt_payment,dt_cancel,de_despatch,tx_location,gu_company,gu_contact,nm_client ,id_legal,gu_ship_addr,gu_bill_addr,id_ref,id_status,id_pay_status,id_ship_method,im_subtotal,im_taxes,im_shipping,im_discount,im_total,tx_ship_notes,tx_email_to,tx_comments) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
oInsertLine = oConn.prepareStatement("INSERT INTO k_despatch_lines (gu_despatch,pg_line,pr_sale,nu_quantity,id_unit,pr_total,pct_tax_rate,is_tax_included,nm_product,gu_product,gu_item,id_status,tx_promotion,tx_options) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
oInsertRelationWithOrder = oConn.prepareStatement("INSERT INTO k_x_orders_despatch (gu_order,gu_despatch) VALUES (?,?)");
oFindProductGUID = oConn.prepareStatement("SELECT gu_product FROM k_products WHERE nm_product=?", ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
oLoadOrder = new DBCommand();
}