pears.ValuesForInvoiceFixedWTRLine

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Original SQL

CREATE FUNCTION "pears"."ValuesForInvoiceFixedWTRLine"( IN "tsid" CHAR(20),IN "tslineid" CHAR(20),IN "RecordType" CHAR(1) ) 
RETURNS long VARCHAR
-- can do line specific stuff with timesheet line id
BEGIN
  DECLARE "rv" long VARCHAR;
  DECLARE "vex" INTEGER;
  SET "rv" = NULL;
  CASE "RecordType"
  WHEN 'D' THEN
    -- could lookup percentage
    SET "rv" = 'Fixed WTR'
  WHEN 'N' THEN
    SELECT "analysis" INTO "rv" FROM "temptimesheet" KEY JOIN "placement"
        KEY JOIN "staff" KEY JOIN "agencydetails" WHERE "temptimesheetid" = "tsid";
    SET "rv" = "string"('1000',"rv")
  WHEN 'V' THEN
    SELECT "companyaccount"."vatexempt" INTO "vex" FROM "temptimesheet" KEY JOIN "placement" KEY JOIN "employment" KEY JOIN "company" KEY JOIN "companyaccount" WHERE "temptimesheetid" = "tsid";
    IF "vex" = 1 THEN SET "rv" = 'E'
    ELSE SET "rv" = 'S'
    END IF
  END CASE;
  RETURN("rv")
END