SET TERM ^ ;
CREATE OR ALTER procedure XX_SET_VAT_22_RUS (
    PARAMSTR varchar(250))
as
declare variable id integer;
declare variable code varchar(6);
declare variable name varchar(50);
declare variable counter integer;
begin
  /* Процедура для изменения налога НДС 20% на налог НДС 22% */
  counter = 0;
  for select id, code, name from tax where rate=20 and enabled=1 order by id
    into id, code, name do
    begin
      if (counter=0) then
      begin
        name = 'НДС 22% (бывш. НДС 20%)';
        code = 'TAX22';
      end
      else
      begin
        name = 'НДС 22% ('|| counter ||') (бывш. ' || substr(name,1, 22) ||  ')';
        code = 'T22_' || counter;
      end
      update TAX set rate=22,name=:name, code=:code where id=:id;
      counter = counter + 1;
    end
end
^
commit ^
 
CREATE OR ALTER trigger tr_xx_vat_22_rus_enabled for workshifts
active after insert position 0
AS
declare variable ss integer;
begin
--01.01.2026
  if (new.id=46023) then
  begin
     execute procedure XX_SET_VAT_22_RUS('');
  end
end
^
commit ^
set term ; ^