BEACON-to-CIS Schema Mapping

Use this spreadsheet to map all BEACON fields to corresponding fields in your billing or Customer Information System (CIS). If a given BEACON field cannot be mapped, mark it as N/A and include the reasons in this spreadsheet.

Click the link below to download and save a copy of the BEACON CIS Schema Mapping spreadsheet. Double-click the file to open it in a spreadsheet program such as Microsoft® Excel®. Alternately, you can import the file (do not double-click to open it) into an online CSV editor.

NOTE: Use the file to help you create Data Exchange files for synchronizing/interfacing BEACON and your CIS.

BEACON CIS Schema Mapping v1.3.

Last Update What Changed What You Need to Do
July 26, 2016 v1.3 Added the following fields: Account_Portal_Status, Account_Billing_Cycle, Location_Address_Line3 and Meter_Size_Unit per the BDE Specification v9.7 and v9.6.1 updates. Use this form to match them to fields in your CIS database.
March 24, 2016 v1.2 Removed four fields: Service_Agreement_ID, Billing_Unit_of_Measure, Billing_Resolution and Billing_Offset per the BDE Specification v9.3 update. Use this form to match them to fields in your CIS database.
February 16, 2016 v1.1 Added Person_ID and Service_Point_Timezone fields. If your BDE files use the new fields, use this form to match them to fields in your CIS database.
November 13, 2015  First Post Match Data Exchange fields to fields in your CIS database
Knowledge Base

User Guide
Follow via Email

Enter your email address to get new content notifications by email.

%d bloggers like this: