WF or some other methods for propagating the updates from Markets BusComp to Countries and Country A
I have urgent Business Request to make updates on Country / Areas Sales Reps once the data have been updates on the side of our custom BusComp for Markets. This is our extension we have made on Countries. Let me explain, we have created extension table to store the IMD Markets names with Sales Reps names. Then I have extended the S_ZIPCODE table to store the IMD Markets IDs and along with it the Sales Reps Names.
Now I have request to enable the Sales Reps team to make updates on the IMD Markets data (i.e. Market Name, Sales Reps assignments) and then these updates needs to be propagated to S_ZIPCODE Table and Countries Administration BusComp. Below the Country Administration we have the child BusComp Country Areas administration that is as well holding the information about IMD Markets and Sales Rep team assignments.