Seller (SL)

A seller represents a person who sells a product.

A Seller was introduced because of the Sales Compensation functionality where the person who gets the compensation does not need to be an actual user of the system.

Fields

id – ID of the seller in the database.

sellerId – (unique key) Unique ID of the seller.

name – Full name of the seller (usually printed on documents).

reportsTo – Unique ID of the seller to which this seller reports to. It is used to keep a hierarchy between the sellers. It is up to the logic to use this field properly.

attribute1..30 – Fields for storing custom properties/attributes of the seller. Ideally, values of these attributes should not change in time because there is no value history kept.