CREATE OR REPLACE FUNCTION a_createlines()
RETURNS void AS
$BODY$ DECLARE 
  lineId VARCHAR(32);
  BEGIN
   select c_orderline_id
     into lineId
    from c_orderline 
    order by created desc limit 1;
    


	FOR x IN 1..7000
	LOOP   	
	raise notice '%', x;
		INSERT INTO c_orderline (c_orderline_id, ad_client_id, ad_org_id, isactive, created, createdby, 
			updated, updatedby, c_order_id, line, c_bpartner_id, c_bpartner_location_id, dateordered, 
			datepromised, datedelivered, dateinvoiced, description, m_product_id, m_warehouse_id, 
			directship, c_uom_id, qtyordered, qtyreserved, qtydelivered, qtyinvoiced, m_shipper_id, 
			c_currency_id, pricelist, priceactual, pricelimit, linenetamt, discount, freightamt,
			c_charge_id, chargeamt, c_tax_id, s_resourceassignment_id, ref_orderline_id, m_attributesetinstance_id,
			isdescription, quantityorder, m_product_uom_id, m_offer_id, pricestd, cancelpricead, 
			c_order_discount_id, iseditlinenetamt, taxbaseamt, m_inoutline_id, c_return_reason_id, 
			gross_unit_price, line_gross_amount, grosspricelist, c_costcenter_id, grosspricestd, a_asset_id,
			m_warehouse_rule_id, user1_id, quotationline_id, user2_id, create_reservation, c_project_id,
			so_res_status, manage_reservation, manage_prereservation, explode, bom_parent_id, 
			print_description, overdue_return_days, relate_orderline, replacedorderline_id, c_aum, aumqty)
			 (SELECT get_uuid(), ad_client_id, ad_org_id, isactive, created, createdby, 
			updated, updatedby, c_order_id, line, c_bpartner_id, c_bpartner_location_id, dateordered, 
			datepromised, datedelivered, dateinvoiced, description, m_product_id, m_warehouse_id, 
			directship, c_uom_id, qtyordered, qtyreserved, qtydelivered, qtyinvoiced, m_shipper_id, 
			c_currency_id, pricelist, priceactual, pricelimit, linenetamt, discount, freightamt,
			c_charge_id, chargeamt, c_tax_id, s_resourceassignment_id, ref_orderline_id, m_attributesetinstance_id,
			isdescription, quantityorder, m_product_uom_id, m_offer_id, pricestd, cancelpricead, 
			c_order_discount_id, iseditlinenetamt, taxbaseamt, m_inoutline_id, c_return_reason_id, 
			gross_unit_price, line_gross_amount, grosspricelist, c_costcenter_id, grosspricestd, a_asset_id,
			m_warehouse_rule_id, user1_id, quotationline_id, user2_id, create_reservation, c_project_id,
			so_res_status, manage_reservation, manage_prereservation, explode, bom_parent_id, 
			print_description, overdue_return_days, relate_orderline, replacedorderline_id, c_aum, aumqty
			FROM c_orderline WHERE c_orderline_id = lineId);
	END LOOP;

END ; $BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;