Sample Associate Reports

These are sample reports of a successful Zane Benefits Associate.

AMC Member: Teresa Flanagan

Customer Information
Name	Teresa Flanagan
AMC Signup Date	04/23/2006
Address	555 Main Street New York, NY 14325
Phone	555-555-5555
Email	demo@nowhere.com

Payments by teresa flanagan (demo)
Date	Amount	Commission
04/16/2007	$35.99	$7.20
03/16/2007	$35.99	$7.20
02/16/2007	$35.99	$7.20
01/16/2007	$35.99	$7.20
12/16/2006	$35.99	$7.20
11/16/2006	$35.99	$7.20
10/16/2006	$35.99	$7.20
09/16/2006	$35.99	$7.20
08/16/2006	$35.99	$7.20
07/16/2006	$35.99	$7.20
06/16/2006	$35.99	$7.20
05/16/2006	$35.99	$7.20
04/16/2006	$60.99	$22.20

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

[4.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

[3.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

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

[4.0E-5s] select * from amccustomer where CustomerId=34894

[0.01776s] select * from amcpolicy 
						where CustomerId=34894 and (EndDate is null or EndDate > '2010-09-09 06:15:46')

[0.03474s] 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=34894 and amcledger.Amount<0
							group by amcledger.LedgerId
						order by Date desc limit 0, 25

[7.0E-5s] select FOUND_ROWS()