pears.NetReportUniTimesheetLines [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.NetReportUniTimesheetLines ======
<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 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
}
</code>