====== pears.VATCodeForTimesheetLine ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
create function "pears"."VATCodeForTimesheetLine"( in "tslineid" char(20) ) 
returns char(3)
begin
  declare "rv" char(3);
  declare "flg" char(20);
  declare "vex" smallint;
  declare "vmrg" smallint;
  return '';
  select "companyaccount"."vatexempt","companyaccount"."vatontempmargin" into "vex","vmrg" from "temptimesheetline" key join "temptimesheet"
      key join "placement" key join "employment" key join "company" key join "companyaccount" where "temptimesheetline"."temptimesheetlineid" = "tslineid";
  if "vex" = 1 then
    set "rv" = 'E'
  elseif "vmrg" = 1 then
    set "rv" = 'S/'
  else
    set "rv" = 'S'
  end if;
  return("rv")
end
</code>