Numbering sequences: identifiers people can read — Several sequences on one field

More than one sequence can target the same field. Each carries a condition and a priority, and the first match by priority wins. That is what "different prefixes per category" means in practice: PO- and SO- can live on one Orders table, each with its own counter, numbering independently off the same column.