A Code	SR#	Sales ID	Cash Amount	CPF Amount	Cust Name	Branch
101	1-12345	1-A111	0	        100,000	        Allan	        North
101	1-12346	1-A112	50,000	        50,000	        Cora	        South
101	1-12347	1-A113	99,000	        0	        Brian     	West

Total # of records				3
Total Amount		149,000		150,000		
		
120	1-10001	1-A555	0		100,000		Allan		North
120	1-10002	1-A556	10,000		150,000		Cora		South
120	1-10003	1-A557	20,000		0		Brian		West
120	1-10004	1-A558	30,000		120,000		Kay		West
120	1-10005	1-A559	50,000		50,000		Leah		East

Total # of records				5
Total Amount		110,000		420,000		
		
150	1-50001	1-A522	0		100,000		Allan		North
150	1-50002	1-A523	10,000		150,000		Cora		South
150	1-50003	1-A524	20,000		0		Brian		West
150	1-50004	1-A525	30,000		120,000		Kay		West
150	1-50005	1-A526	50,000		50,000		Leah		East
150	1-50005	1-A527	50,000		50,000		Michelle		East

Total # of records				6
Total Amount		160,000		470,000		
		
Grand Amount		419,000		1,040,000		
Grand total # of records			14