You should be using this:
https://support.apple.com/guide/apple-business-manager/what-...
https://support.apple.com/guide/apple-business-manager/creat...
Not the consumer Apple IDs. This lets you programically generate the Apple IDs (you can even set permissions on them).
Works great.
Not that they've made it straightforward to make it explicit who should use what, or anything, but they do have solutions for this. It also has other perks (like being able manage distribution of your app)
To be fair to anyone, the Developer Documentation does not talk one bit about this, at all, as a solution.