Clients table

ClientID | ClientType
---------+-----------
0001     | 12pP!
0002     | 2SW
0003     | 2W

And so on

ClientTypes table

ClientType | Description
-----------+--------------------
1          | Subsidiary 1 Client
2          | Subsidiary 2 Client
S          | Shop
W          | Workshop

And so on.