Sample Associate Reports

These are sample reports of a successful Zane Benefits Associate.

AMC Member: Travis Ho

Customer Information
Name	Travis Ho
AMC Signup Date	06/21/2006
Address	555 Main Street New York, NY 14325
Phone	555-555-5555
Email	demo@nowhere.com

Payments by travis ho (demo)
Date	Amount	Commission
04/14/2007	$35.99	$7.20
03/14/2007	$35.99	$7.20
02/14/2007	$35.99	$7.20
01/14/2007	$35.99	$7.20
12/14/2006	$35.99	$7.20
11/14/2006	$35.99	$7.20
10/14/2006	$35.99	$7.20
09/14/2006	$35.99	$7.20
08/14/2006	$35.99	$7.20
07/14/2006	$35.99	$7.20
06/14/2006	$60.99	$22.20

Entries per page:


[8.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.01376s] select * from amccustomer where CustomerId=35640

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

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

[7.0E-5s] select FOUND_ROWS()