CREATE OR REPLACE FUNCTION createBPs()
  RETURNS void AS
$BODY$ DECLARE 
  bpID varchar(32);
  i numeric;
BEGIN
  for i in 1..10000 loop
    bpID := get_uuid();
    insert into c_bpartner 
         (c_bpartner_id, aD_client_id, ad_org_id, isactive, createdby, updatedby,
					value, name, iscustomer,
					m_pricelist_id, c_bp_group_id)
		values
				(bpID, 'FF8080812AFBCB14012AFBD3E373001F', '4F68EB1C1B734E79B27DE9D2DF56089F', 'Y', '0', '0',
				'BP'||i, 'BP- name -'||i, 'Y',
				'8A64B71A2B0B2946012B0BD97324018A', '8A64B71A2B0B2946012B0FE1E8AB01FF');

		insert into c_bpartner_location
				(c_bpartner_location_id, aD_client_id, ad_org_id, isactive, createdby, updatedby,
				name, isbillto, isshipto, isremitto,
				c_bpartner_id, c_location_id)
		values
				(get_uuid(), 'FF8080812AFBCB14012AFBD3E373001F', '4F68EB1C1B734E79B27DE9D2DF56089F', 'Y', '0', '0',
				'addr'||i, 'Y', 'Y', 'Y',
				 bpID,'8A64B71A2B0B2946012B0FE1E8C20202');
  end loop;
END ; $BODY$
  LANGUAGE plpgsql;

  select createBPs();

  DROP FUNCTION createBPs();