Arrears Maintenance Table Records MeterDeductions//FrontierMeters

ID	Submission Entry	Name Description	Dates		Deduction Type	Deduction Rule	Deduction Percentage	Proportion Minimun	Fixed Monthly	Monthly Limit	Status	Tx %		Merchant Details
														Acc. Nr	Agent	Sector	Group
96 Update		Uthukela 40% Uthukela 40%			1	0	100	0	0	0	1	40				UTHUKELA	UTHUKELA
95 Update		Matjhabeng 90% Matjhabeng 90%			1	0	0	0	0	0	1	90				MATJHABENG
94 Update		Matjhabeng 70% Matjhabeng 70%			1	0	0	0	0	0	1	70				MATJHABENG	MATJHABENG
93 Update		Matjhabeng 50% Matjhabeng 50%			1	0	50	0	0	0	1	50				MATJHABENG	MATJHABENG
92 Update		WSLM 60/40 Split WSLM 60/40 Split			1	0	60	0	0	0	1	60				WALTERSISULU	WALTERSISULU
91 Update		20/80 Service 20/80			1	0	20	0	0	0	1	20				IP	SteveO
90 Update		Tokologo 50% 50/50			1	0	50	0	0	0	0	50				TOKOLOGO	TOKOLOGO
89 Update		75/25 Service 75/25 Service			1	0	75	0	0	0	1	75				IP	SteveO
88 Update		5/95 Service 5/95 Service			1	0	5	0	0	0	1	5				IP	XpressPrepaid
87 Update		Uthukela 20% Uthukela 20%			1	0	0	0	0	0	1	20				IP	IP1
86 Update		50/50 Service 50/50 Service			1	0	50	0	0	0	1	50				IP	Weinprop
85 Update		10/90 Service 10/90 Service			1	0	10	0	0	0	1	10				IP	IP1
84 Update		90/10 Service 90/10 Service			1	0	90	0	0	0	1	90				IP	IP1
83 Update		60/40 Service 60/40 Service			1	0	60	0	0	0	1	60				IP	XpressPrepaid
82 Update		80/20 Service 80/20			1	0	80	0	0	0	1	80				IP	IP1
81 Update		Split 40/60 Split 40/60			1	0	40	0	0	0	1	40				IP	IP1
80 Update	11826747	Default Tenant New Plan			1	0	50	10	200	200	1	100		77002618	25Joxu82	ISRAEL	ISRAEL
79 Update		Tokologo 25% 25/75			1	0	25	0	0	0	0	25				TOKOLOGO	TOKOLOGO
78 Update		Kgetleng bypass Bypassed arrangement			1	0	50	0	0	0	1	50				KOSTER	KOSTER
77 Update		Keriberi 50 50/50			1	0	50	0	0	0	1	50				IP	Boost
76 Update	17388196	L Nucci New Plan			1	0	80	10	0	0	1	100		88352610	78Tyti%41	IP	IP1
75 Update		TEST 80 Percent 80 Percent on every recharge			1	0	80	10	0	0	1	80				MKHONDO	MKHONDO
74 Update		Netta 70/30 70/30			1	0	30	0	0	0	1	30				IP	Boost
73 Update		Nizamiya 0 Arrears Nizamiya 0 Arrears			2	0	0	0	0	0	1	0				BotswanaIP	Botswana1
72 Update		Nizamiya 25% Arrears Nizamiya 25% Arrears			1	0	25	0	0	0	0	25				IP	IP1
71 Update		Nizayami 50/50 Nizayami 50/50			1	0	50	0	0	0	1	50				IP	SteveO
70 Update		Kgetleng R2258.00 Max Monthly Collect R2258.00 max monthly			1	1	0	0	0	2258	1	100				KOSTER	KOSTER
69 Update		Kgetleng No Arrears Deduction Kgetleng No Arrears Deduction			2	0	100	0	0	0	1	100				KOSTER	KOSTER
68 Update		Kgetleng R0 Max Monthly Collect 0% arrears			1	1	0	0	0	0	1	100				KOSTER	KOSTER
67 Update		Kgetleng R1500 Max Monthly Collect R1500 max monthly			1	1	0	0	0	1500	1	100				BotswanaIP	KOSTER
66 Update		Kgetleng R2000 Max Monthly Collect R2000 max monthly			1	1	0	0	0	2000	1	100				KOSTER	KOSTER
65 Update		Kgetleng R1000 Max Monthly Collect R1000 max monthly			1	1	0	0	0	1000	1	100				KOSTER	KOSTER
64 Update		Kgetleng R750 Max Monthly Collect R750 Max monthly			1	1	0	0	0	750	1	100				GOVAN	GOVAN
63 Update		Kgetleng R500 Max Monthly Collect R500 max monthly			1	1	0	0	0	500	1	100				KOSTER	KOSTER
62 Update		Proportional 70% Arrears 70% of the transaction fee to go towards arrears			1	0	70	10	0	0	1	70				IP	IP1
61 Update		Weinprop 60% Arrears Weinprop 60% Arrears			1	0	60	0	0	0	1	60				IP	IP1
60 Update	17549168	Ibis 90/10 Ibis 90/10			1	0	90	0	0	0	1	90		60998910	16Byjo(60	IP	SteveO
58 Update	10430287	IBIS 90% Arrears IBIS 90% Arrears			1	0	90	10	0	0	1	90		61648710	28Foxi%40	IP	XpressPrepaid
57 Update	16076186	Kings Langley 50/50 % New Plan			1	0	0	0	0	0	1	50		61452810	46Kequ,81	IP	Boost
56 Update	17073722	GC 40% New Plan			1	0	0	20	0	0	1	40		61509010	92Xynu,83	IP	IP1
55 Update	17832850	GC Proportional New Plan			1	0	30	20	0	0	1	100		61509010	92Xynu,83	NKANDLA	NKANDLA
54 Update		Ben 95% Arrears Ben 95% Arrears			1	0	95	0	0	0	1	95		61648710		IP	IP1
53 Update	13846210	Entire New Plan			0	0	100	0	0	0	1	100		61759610	86Voky.95	LESEDI	LESEDI
52 Update	12394568	Kambrosig 30/70 New Plan			1	0	30	10	0	0	1	30		62001710	75Soky.97	IP	SteveO
51 Update		Kambrosig 70/30 New Plan			1	0	0	20	0	0	1	70				WALTERSISULU	WALTERSISULU
50 Update	10101179	Westar 95/5 New Plan			1	0	95	0	0	0	1	95		61759610	86Voky.95	IP	SteveO
49 Update	15139318	Westar 85/15 New Plan			1	0	85	0	0	0	1	85		60893110	12Joxi%39	IP	SteveO
48 Update	17163202	Grafton 90/10 New Plan			1	0	0	10	0	0	1	90		99136810	96Nujo)61	IP	XpressPrepaid
47 Update	13761456	Herronbrook 95/5 New Plan			1	0	0	5	0	0	1	95		99032210	123456	IP	Weinprop
46 Update	10274346	Entire New Plan			0	0	0	0	0	0	1	100		60953010	26Joxi%39	IP	IP1
45 Update	19407050	Kgetengrivier 100% Arrears New Plan			0	0	100	0	0	0	1	100		99988892	75Soxi%38	KOSTER	KOSTER
44 Update	15029260	Hazeldean Medical 69/31 New Plan			1	0	0	20	0	0	1	69		60953010	26Joxi%39	IP	Boost
43 Update	14049711	Hazeldean Medical 80/20 v1 Hazeldean Medical 80/20 v1			1	0	0	10	0	0	1	80		60953010	26Joxi%39	IP	XpressPrepaid
42 Update	12086192	Hazeldean Medical 80/20 New Plan			1	0	80	0	0	0	0	80		60953010	26Joxi%39	IP	SteveO
41 Update	17119453	Sample-Entire New Plan			0	0	0	0	0	0	1	100		99900031	41Noxi%40	IP	Boost
40 Update	12149757	JHI Rent Recovery New Plan			1	0	0	0	0	0	1	95		99032210	123456	MADIBENG	MADIBENG-1
39 Update	19183579	Sheik 30% Arrears New Plan			1	0	0	0	0	0	1	30		61438110	89Wupy.98	IP	IP1
38 Update	12837393	Nabeel Sheik Water Arrears New Plan			1	0	30	0	0	0	1	100		61438110	89Wupy.98	IPRetail	IPRetailGen
37 Update	12615904	Kgetleng 30% Arrears Kgetleng 30% Arrears			1	0	0	20	0	0	1	30		99900031	41Noxi%40	TOKOLOGO	TOKOLOGO
36 Update	10901312	Arrears UT New Plan			1	0	0	20	0	0	1	30		99060110	1Greentree	IPIND	Boost
35 Update		10% Deduction 10% Deduction of face value			1	0	0	0	0	0	1	10				PILGRIMS	Boost
34 Update		Steve Ossie 50% Arrears Deducts 50% of transactional fees for arrears			1	0	100	0	0	0	1	50				IP	CityProp
32 Update	16328009	Default-Entire New Plan			0	0	100	0	0	0	1	100		11110010	1234	IP	SteveO
29 Update	18343661	Madibeng-A-50% Descrption field			1	0	100	10	0	0	1	50		99887703	123456	MADIBENG	MADIBENG-1
25 Update	16189903	My New Plan New Plan			1	0	30	20	0	0	1	100		11110010	123456	Norkem	All
24 Update	11117618	Special 60 New Plan			1	0	30	50	0	75	1	60		11110010	1234	PILGRIMS	PILGRIMS
23 Update	13332198	Special 50 New Plan			1	0	0	20	0	0	1	50		11110010	1234	ZIMIDEALELE	ZIMIDEALELE
22 Update	17897330	Assign Value 3 New Plan			0	0	100	0	0	0	1	100		11110010	1234	ZIMIDEALELE	ZIMIDEALELE
21 Update	19705518	Assign Value 2 New Plan			0	0	100	0	0	0	1	100		11110010	1234	ZIMIDEALELE	ZIMIDEALELE
20 Update	19787376	Tune B New Plan			1	0	20	60	0	0	1	40		11110010	1234	Norkem	All
12 Update	13786303	Tune A New Plan			1	2	30	20	25	100	1	75		11110010	1234	IP	Boost
11 Update		Maquassi 50 Maquassi - 50% with R20 Minimum			1	0	0	0	0	0	1	50				PILGRIMS	PILGRIMS
7 Update	11517456	Deduct 5 New Plan			0	0	51	49	55	55	1	55		11110010	1234	MADIBENG	MADIBENG-1
6 Update	18955384	Deduct 4 New Plan			0	0	50	0	44	44	1	44		11110010	1234	PHALABORWA	NKANDLA
5 Update	17614563	Deduct 3 New Plan			0	0	49	0	33	33	1	33		11110010	1234	IP	Boost
4 Update	12340454	David Rental Simcoe zzz New Plan			0	0	50	49	48	47	0	46		11110010	1234	LESEDI	LESEDI
3 Update	Test2	Arrears-B-Prop-FixedMonthly Arrears deduction fixed monthly-Test			1	2	30	50	40	500	1	60		11110010	1234	PHALABORWA	PHALABORWA
2 Update	Test	Arrears-A-Entire-Every Arrears deduction for IP-Tests			0	0	100	100	0	0	1	100		11110010	1234	ESKOM	ESKOM1
1 Update		Sample-Proportional Sample-Proportional			1	0	100	0	0	0	3	90				ALL	ALL
0 Update		Sample-Entire. Sample-Entire			0	0	100	0	0	0	0	100				ALL	ALL