A nice interesting one for you all
I need to remove this synthetic key for obvious reasons, the key is currently made up of a concatenated key of Sales Order & Item. And also DIVISION. Both of these fields are needed to be key fields however I can't seem to be able to imagine a better data model at this moment.
Any input or comments would be helpful!