--------------------------------------------------------------------
 
 -- Сброс генераторов - начало блока
 

select Coalesce(Max(Bank_id),  0 ) from Bank into :New_id;  -- Банки
 
  New_id = gen_id(Bank_id_gen, New_id - gen_id(Bank_id_gen,  0 ));

select Coalesce(Max(Bill_id),  0 ) from Bill into :New_id;  -- Счет
 
  New_id = gen_id(Bill_id_gen, New_id - gen_id(Bill_id_gen,  0 ));

 --...
 
 --...
 
 --...
 

select Coalesce(Max(Unit_id),  0 ) from Unit into :New_id;  -- Ед.измерения
 
  New_id = gen_id(Unit_id_gen, New_id - gen_id(Unit_id_gen,  0 ));

 -- Сброс генераторов - конец блока
 
 --------------------------------------------------------------------
 

end

CREATE PROCEDURE %TemplateName AS
declare variable New_Id bigint;
begin
 --------------------------------------------------------------------
 
 -- Сброс генераторов - начало блока
 

%ForEachEntity() {
%if(%==(%EntityProp(generate_id),yes))
{  select Coalesce(Max(%TableName_id),  0 ) from %TableName into :New_id;  -- %EntityName
 
  New_id = gen_id(%TableName_id_gen, New_id - gen_id(%TableName_id_gen,  0 ));
}
}
 -- Сброс генераторов - конец блока
 
 --------------------------------------------------------------------
 

end