What are the rules governing who is paid what?

Can you post a file with clear explanation of the rules (logic) for assigning commission.

Problem suggests one or more Table "lookups".