Problem Definition

The first step in the process is for the Marketing Department to produce a list of invoices that were filled in the previous month; normally this happens by the 5th day of the new month. (For this example, this file is called tbl_revenue.txt, and it is available from the book’s Web site, which is located at From that list, the FA processing the commissions applies a series of business rules against the data to generate the commissions for each salesperson.

The first two lines from tbl_revenue.txt are shown here:

 customer_number,customer_name,salesperson,country,city,state,zipcode,ship_date,item_ number,order_quantity,unit_price,net_value,invoice_number,invoice_date, invoice_quantity,invoice_value 250-700,ExecuData,4181,United ...

Get MySQL Building User Interfaces now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.