sdg.marinusvz
2015-07-22 12:43
Just to make it absolutely clear. The MDA export will not even work, if the 3 additional account numbers are not called exactly 'Site code', 'Building' and 'Shop Number', in that sequence. In that way it is easy to exclude a Meter Account from the normal MDA export.
The Shop Number and Building can contain alphabetic characters and spaces, possibly special characters.
I'm not sure about the Account Number (Tenant Code) and the Site code.
The Site code is typically only 4 digits, and the Account Number is typically 8 digits, of which the first 4 is typically equivalent to the Site code. I don't think they can include spaces. These two codes are very important. The Building and Shop Number fields are less important.
sdg.marinusvz
2021-02-25 10:38
It looks at the utility:
if(UTILITY.equalsIgnoreCase('Water'))
meterAccountName += 'WT00';
else if(UTILITY.equalsIgnoreCase('Effluent'))
meterAccountName += 'EF00';
else if(UTILITY.equalsIgnoreCase('Sewerage') || UTILITY.equals('Sewage') || UTILITY.equals('Sanitation') || UTILITY.equals('Refuse'))
meterAccountName += 'SE00';
else if(UTILITY.equalsIgnoreCase('Gas'))
meterAccountName += 'GS00';
else
{
// OK. I assume this is electricity. However, the question arises: is this a MD meter? If so, replace the EL00 with EL11.
...
if(tr.next())
meterAccountName += 'EL11';
else
meterAccountName += 'EL00';
}
For Electricity, it looks whether the person was billed for Maximum Demand. If so, the type is EL11, otherwise it is EL00.