pears.NetReportUniTimesheetLines

CREATE PROCEDURE "pears"."NetReportUniTimesheetLines"( IN "pWebUserID" CHAR(20),IN "pTimesheetID" CHAR(20) ) 
RESULT( "Pay_Type" CHAR(100),"Unit" CHAR(100),"Units__R" DOUBLE,"Pay_Rate__MR" DOUBLE,"Charge_Rate__MR" DOUBLE,"Total_Charge__MR" DOUBLE ) 
BEGIN
  SELECT "b"."description",
    "b"."unit",
    "l"."unitspaid",
    "l"."payrate",
    "l"."chargerate",
    "l"."unitscharged"*"l"."chargerate"
    FROM "temptimesheetline" AS "l" KEY JOIN "temppayband" AS "b"
    WHERE "l"."temptimesheetid" = "pTimesheetID"
    ORDER BY "b"."sortorder" ASC,"b"."description" ASC
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetReportUniTimesheetLines" IS 
{CREATE PROCEDURE pears."NetReportUniTimesheetLines"( IN "pWebUserID" CHAR(20),IN "pTimesheetID" CHAR(20) ) 
RESULT( "Pay_Type" CHAR(100),"Unit" CHAR(100),"Units__R" DOUBLE,"Pay_Rate__MR" DOUBLE,"Charge_Rate__MR" DOUBLE,"Total_Charge__MR" DOUBLE ) 
BEGIN
  SELECT "b"."description",
    "b"."unit",
    "l"."unitspaid",
    "l"."payrate",
    "l"."chargerate",
    "l"."unitscharged"*"l"."chargerate"
    FROM "temptimesheetline" AS "l" KEY JOIN "temppayband" AS "b"
    WHERE "l"."temptimesheetid" = "pTimesheetID"
    ORDER BY "b"."sortorder" ASC,"b"."description" ASC
END
}