Understanding Meter Reading Interoperability

The interoperability programs for meter readings enable you to transfer meter reading data from other systems into the JD Edwards EnterpriseOne meter readings database. You can review and modify meter reading records before updating the meter readings database, and you can purge meter reading interoperability transactions.

These steps illustrate the flow of information through the meter reading interoperability programs:

1. Run the Inbound Meter Readings File Conversion program (R47002C) to load the data from the flat file into the Unedited Meter Reading Transactions table (F12120Z1).

   Data can also be loaded into the F12120Z1 table by using any other method supported by JD Edwards EnterpriseOne software.

2. Use the Meter Reading Transactions Revisions program (P12120Z1) to review or modify the records in the F12120Z1 table.

3. Run the Inbound Meter Readings Processor program (R12120Z1I) to validate the data in the F12120Z1 table.

   If validation fails, the system issues errors and does not update the records to the meter reading database.

4. If validation succeeds, the system:

   • Writes the data to the Account Ledger table (F0911).

   • Updates the Asset Account Balances table (F1202).

   • (Optional) Updates the Maintenance Schedule table (F1207).

   • Marks the records in the F12120Z1 table as successfully processed.

The Inbound Meter Readings Processor program (R12120Z1I) requires that the F12120Z1 interface table have data in these fields:

• Meter Type (MTTP)

  Define which meter reading is being processed.

• Amount - Current Balance (BALOW) or Amount - Net Increase (NIOWM).

  Use BALOW if you are supplying the current meter reading. Use NIOWM if are supplying the net increase (decrease) in the current amount.