I assume its possible that you will receive multiple payments from the same person or company where the only differentiation between records is the payment date, is this correct? Based on that I will give you my take on how to design this, it will take me a little bit to write it up.