Sample Associate Reports

These are sample reports of a successful Zane Benefits Associate.

AMC Member: Grace Talbert

Customer Information
Name	Grace Talbert
AMC Signup Date	05/20/2006
Address	555 Main Street New York, NY 14325
Phone	555-555-5555
Email	demo@nowhere.com

Payments by grace talbert (demo)
Date	Amount	Commission
04/13/2007	$19.99	$4.00
03/13/2007	$19.99	$4.00
02/13/2007	$19.99	$4.00
01/13/2007	$19.99	$4.00
12/13/2006	$19.99	$4.00
11/13/2006	$19.99	$4.00
10/13/2006	$19.99	$4.00
09/13/2006	$19.99	$4.00
08/13/2006	$19.99	$4.00
07/13/2006	$19.99	$4.00
06/13/2006	$19.99	$4.00
05/13/2006	$44.99	$19.00

Entries per page:


[7.0E-5s] select AffiliateId from affiliate where IsDemo=2

[3.0E-5s] select AffiliateId from affiliate where IsDemo=2

[3.0E-5s] select AffiliateId from affiliate where IsDemo=2

[5.0E-5s] select affiliateclass.* from affiliateclass
							inner join affiliate on affiliate.AffiliateClassId=affiliateclass.AffiliateClassId
						where affiliate.AffiliateId = 36651

[4.0E-5s] select * from affiliatelicense where AffiliateId = 36651

[4.0E-5s] select AffiliateId from affiliate where IsDemo=2

[4.0E-5s] select affiliateclass.* from affiliateclass
							inner join affiliate on affiliate.AffiliateClassId=affiliateclass.AffiliateClassId
						where affiliate.AffiliateId = 36651

[3.0E-5s] select AffiliateId from affiliate where IsDemo=2

[5.0E-5s] select affiliateclass.* from affiliateclass
							inner join affiliate on affiliate.AffiliateClassId=affiliateclass.AffiliateClassId
						where affiliate.AffiliateId = 36651

[0.02058s] select * from amccustomer where CustomerId=35114

[0.01162s] select * from amcpolicy 
						where CustomerId=35114 and (EndDate is null or EndDate > '2010-09-09 06:12:03')

[0.03336s] select SQL_CALC_FOUND_ROWS sum(paymentledger.Amount) as Commission, amcledger.Amount, amcledger.Date from amcledger
								left outer join paymentledger on paymentledger.RecordId=amcledger.LedgerId and paymentledger.Type like 'AMC%'
							where amcledger.CustomerId=35114 and amcledger.Amount<0
							group by amcledger.LedgerId
						order by Date desc limit 0, 25

[7.0E-5s] select FOUND_ROWS()