Affiliate Database Design question

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

:confused:

Probably have a flag either in payments or on the client/company to say its an affiliate. Then you can pinpoint all those payments or orders or whatever.

Vince