I am building an affiliate progam for my client and I have a question to ask of you.

In terms of keeping track of payments made to affiliates, would you create a table that would house all payments made to affiliates? Would you also create a table to house all commissions earned by an affiliate or would you generate that report based on the Orders table on the fly?

Thanks