issue #20040: wasquote required field for so
issue #20040: coalesce for required fields
issue #20040: crud test passes
issue #20040: cleanup