pears.VATCodeForTimesheetLine [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== 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>
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."VATCodeForTimesheetLine" IS 
{create function 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>