Billing Export to MDA (Property Management System)

Avatar

sdg.corrie
2013-07-04 19:05

Hi All
I was asked the following question.
Q: What is the formatting criteria for a Meter account to comply with Billing Export to MDA (Property Management System)
A: Please make sure that the Site code, Building and Shop Number fields is set as in the example.

Regards,

Avatar

sdg.matiaan
2015-02-17 08:23

Also note that the Account Number in your Meter Account should be set to the Account Number in MDA

Avatar

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.

Avatar

sdg.marinusvz
2021-02-25 09:12

Kevin Asked:

I'm trying to work out - where does MDA export get the utility type from? So the EL00 etc... ?

Avatar

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.

Please log in to post a comment