Assign unique client codes to new company records

New company records arriving without a client code break billing and credit workflows and force manual duplicate checks by IT. This assigns a sequential client code and flags duplicates so systems have consistent IDs same day.