====== 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>
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>