====== pears.NetOrderReasonList ======
<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"."NetOrderReasonList" IS 
{create FUNCTION pears."NetOrderReasonList"()
returns long varchar
//IQXWeb
begin
  declare "rv" long varchar;
  select "list"("string"("tempshiftorderreasonid",']~[',"description"),']~[' order by "sortorder" asc,"description" asc) into "rv" from "tempshiftorderreason";
  return "rv"
end

/* DOC
2016-10-20 PC modify to include doc and test

inputs:
    none

outputs:
    delimited list

tests:
    test inherited through NetClientShiftOrderReasons

*/

/* TEST

*/
}
</code>