added support for hex color codes, setting idcolumn, syscode