Usage of SPLIT_PCT Column in CN_COMMISSION_HEADERS

We are Populating split_pct column as part of the collection process. This is typicaly populated with 100%, since we are bringing the sales credits split_pct from source system.

In OIC sometimes we have a need to split this up and share between multiple salesreps. In such a case, we would like to change the split_pct, but not affect the transaction amount on cn_commission_headers. How can we accomplish this:

Example:

Trx1 --> Rep A --> $100 --> 100%

Now in OIC we want to split using maintain transactions to Rep A --> 20%, Rep B --> 30%, Rep C --> 50%. So the end result should look like this