Users - Commission Data Model
Posted by
Vinay Agarwal on
May 03, 2006; 7:57pm
URL: http://ofbiz.116.s1.nabble.com/Users-Commission-Data-Model-tp138846.html
Hello,
As I am in process of developing a simple, but hopefully generic enough
to be useful, commission model, I am leaning toward the following data model. I
would appreciate feedback. If there isn’t a drastic change in the model,
I hope to submit a patch by end of this week.
Regards,
Vinay Agarwal
- Commissions are modeled as Agreement entities
with agreementTypeId of COMMISSION_AGREEMENT.
- Related AgreementItems are not used and the
currency is determined from the OrderHeader or ReturnHeader.
- Related AgreementTerms specify the commission
amount. Two type of terms are defined so far
- FIN_COMM_FIXED: itemValue specifies per unit commission
in the currency of the order.
- FIN_COMM_VARIABLE: itemValue specifies
percentage commission.
- There can be a number of agreements applicable to
each product involving multiple parties (both To and From).
- Find applicable agreements using AgreementProductAppl.
- The commission invoices are created when payments
are applied.
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users