﻿Invoice HTML fields

<html_merge xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <offering_text></offering_text>
  <invoice_header_id>104703</invoice_header_id>
  <account_number>4901000649</account_number>
  <first_name>Fiona</first_name>
  <last_name>Mak</last_name>
  <account_name>Lunchlady Doris</account_name>
  <discount>0.00</discount>
  <opening_balance>$1,898.46</opening_balance>
  <invoice_amount>$2,155.64</invoice_amount>
  <total_due_amount>$4,054.10</total_due_amount>
  <due_date>04/02/2019</due_date>
  <doc_page1_1 xsi:nil="true" />
  <doc_page2_1 xsi:nil="true" />
  <invoice_date>15/01/2019</invoice_date>
  <discount_amount>4054.10</discount_amount>
  <invoice_run_id>0</invoice_run_id>
  <address_for_supply>Magnolia House Lights, 742 Evergreen Terrace, Botany NSW 2019</address_for_supply>
  <cust_eft_acct_no>123456789</cust_eft_acct_no>
  <bpay_ref>49010006499</bpay_ref>
</html_merge>

MyAccount HTML fields

<html_merge>
	<customer_name>Mark Johnson</customer_name>
	<first_name>Mark</first_name>
	<last_name>Johnson</last_name>
	<user_name>johnnopds@optusnet.com.au</user_name>
	<oss_url>https://benergy.utilmate.com/</oss_url>
	<oss_login_url>https://benergy.utilmate.com/Reset-Password?token=0xD000DBC032239BCF0D7340F58B74487A8C0CA276D84092C248089E0187547C33&amp;user=johnnopds@optusnet.com.au</oss_login_url>
	<access_code>AF268D39</access_code>
</html_merge>

Mail merge HTML fields

<html_merge>
	<party_code>0024126</party_code>
	<account_number>4000000001138</account_number>
	<account_name>Hussain Alyami</account_name>
	<customer_type>Residential</customer_type>
	<postal_address1>Unit 719 - 268 Flinders St</postal_address1>
	<postal_address2>Melbourne</postal_address2>
	<postal_address3>VIC</postal_address3>
	<postal_code>3000</postal_code>
	<mobile_no>61448739666</mobile_no>
	<name_title></name_title>
	<first_name>Hussain</first_name>
	<last_name>Alyami</last_name>
	<correspondence>Hussain Alyami</correspondence>
	<retailer_name>Benergy</retailer_name>
	<retailer_phone_number>1300 761 390</retailer_phone_number>
	<total_owing>208.05</total_owing>
	<total_outstanding>208.05</total_outstanding>
	<current_period>0.00</current_period>
	<days_30>208.05</days_30>
	<days_60>0.00</days_60>
	<days_90>0.00</days_90>
	<days_90_plus>0.00</days_90_plus>
	<billing_notes></billing_notes>
	<adr_barcode>{®~</adr_barcode>
	<ocr_barcode>40000000011380+01+0000020551+4008+93</ocr_barcode>
	<bpay_biller_code>244863</bpay_biller_code>
	<bpay_ref>40000000011389</bpay_ref>
	<pay_method_code>CHEQUE</pay_method_code>
	<voice_ver_date>UNKNOWN</voice_ver_date>
	<product_type_desc>Power Supply Accounts</product_type_desc>
	<site_identifier>ENV0001759</site_identifier>
	<address_for_supply>719/268 Flinders Street, MELBOURNE VIC 3000</address_for_supply>
	<network_name>Citipower</network_name>
	<supply_street>Home At Flinders 268 Flinders Street</supply_street>
	<supply_suburb>Melbourne</supply_suburb>
	<supply_city>VIC</supply_city>
	<supply_state>VIC</supply_state>
	<supply_postcode>3000</supply_postcode>
	<frmp_date>16/12/2019</frmp_date>
	<next_scheduled_read_date>Unknown</next_scheduled_read_date>
	<date_connected>16/12/2019</date_connected>
	<incentive_desc></incentive_desc>
	<termination_fee_desc></termination_fee_desc>
	<contract_term>Open Contract</contract_term>
	<contract_start_date>16/12/201invo9</contract_start_date>
	<next_contract_start_date>16/12/2019</next_contract_start_date>
	<daily_rate>1.1400000</daily_rate>
	<daily_rate_gst>1.2540000</daily_rate_gst>
	<prompt_payment_discount>0.05</prompt_payment_discount>
	<peak_price1>0.2356000</peak_price1>
	<peak_price2>NA</peak_price2>
	<peak_price3>NA</peak_price3>
	<peak_price4>NA</peak_price4>
	<peak_price5>NA</peak_price5>
	<off_peak_price>NA</off_peak_price>
	<shoulder_price>NA</shoulder_price>
	<controlled_load1_price>NA</controlled_load1_price>
	<controlled_load2_price>NA</controlled_load2_price>
	<peak_price1_gst>0.2591600</peak_price1_gst>
	<peak_price2_gst>NA</peak_price2_gst>
	<peak_price3_gst>NA</peak_price3_gst>
	<peak_price4_gst>NA</peak_price4_gst>
	<peak_price5_gst>NA</peak_price5_gst>
	<off_peak_price_gst>NA</off_peak_price_gst>
	<shoulder_price_gst>NA</shoulder_price_gst>
	<controlled_load1_price_gst>NA</controlled_load1_price_gst>
	<controlled_load2_price_gst>NA</controlled_load2_price_gst>
	<peak_step1>NA</peak_step1>
	<peak_step2>NA</peak_step2>
	<peak_step3>NA</peak_step3>
	<peak_step4>NA</peak_step4>
	<solar1_price>NA</solar1_price>
	<solar2_price>NA</solar2_price>
	<solar3_price>NA</solar3_price>
	<solar1_price_gst>NA</solar1_price_gst>
	<solar2_price_gst>NA</solar2_price_gst>
	<solar3_price_gst>NA</solar3_price_gst>
	<stc_price>NA</stc_price>
	<stc_price_gst>NA</stc_price_gst>
	<lgc_price>NA</lgc_price>
	<lgc_price_gst>NA</lgc_price_gst>
	<future_daily_charge>1.1400000</future_daily_charge>
	<future_daily_charge_gst>1.2540000</future_daily_charge_gst>
	<future_peak_price1>NA</future_peak_price1>
	<future_peak_price1_gst>NA</future_peak_price1_gst>
	<future_peak_price2>NA</future_peak_price2>
	<future_peak_price2_gst>NA</future_peak_price2_gst>
	<future_peak_step1>NA</future_peak_step1>
	<future_off_peak_price>NA</future_off_peak_price>
	<future_off_peak_price_gst>NA</future_off_peak_price_gst>
	<future_shoulder_price>NA</future_shoulder_price>
	<future_shoulder_price_gst>NA</future_shoulder_price_gst>
	<future_controlled_load1_price>NA</future_controlled_load1_price>
	<future_controlled_load1_price_gst>NA</future_controlled_load1_price_gst>
	<future_controlled_load2_price>NA</future_controlled_load2_price>
	<future_controlled_load2_price_gst>NA</future_controlled_load2_price_gst>
	<future_solar1_price>NA</future_solar1_price>
	<future_solar1_price_gst>NA</future_solar1_price_gst>
	<future_solar2_price>NA</future_solar2_price>
	<future_solar2_price_gst>NA</future_solar2_price_gst>
	<future_solar3_price>NA</future_solar3_price>
	<future_solar3_price_gst>NA</future_solar3_price_gst>
	<future_stc_price>NA</future_stc_price>
	<future_stc_price_gst>NA</future_stc_price_gst>
	<future_lgc_price>NA</future_lgc_price>
	<future_lgc_price_gst>NA</future_lgc_price_gst>
	<past_stc_price>NA</past_stc_price>
	<past_stc_price_gst>NA</past_stc_price_gst>
	<past_lgc_price>NA</past_lgc_price>
	<past_lgc_price_gst>NA</past_lgc_price_gst>
	<invoice_due_date>02 Mar 2020</invoice_due_date>
	<treatment_due_date>21 Apr 2020</treatment_due_date>
	<treatment_disc_date>24 Apr 2020</treatment_disc_date>
	<treatment_amount>144.75</treatment_amount>
	<treatment_date>15 Apr 2020</treatment_date>
	<treatment_inv_power_faults_no>13 12 80</treatment_inv_power_faults_no>
	<treatment_inv_power_distributor>Citipower</treatment_inv_power_distributor>
	<treatment_inv_offering_desc>5% bQuick Discount</treatment_inv_offering_desc>
	<payplan_start_date></payplan_start_date>
	<payplan_end_date></payplan_end_date>
	<payplan_frequency></payplan_frequency>
	<payplan_broken_notice></payplan_broken_notice>
	<payplan_amt>0.00</payplan_amt>
	<payplan_install_no>0</payplan_install_no>
	<payplan_install_amt>0.00</payplan_install_amt>
	<payplan_install_due_date></payplan_install_due_date>
	<payplan_first_install_date></payplan_first_install_date>
	<payplan_first_install_amt>0.00</payplan_first_install_amt>
	<offering_code>BQUICK5</offering_code>
	<offering_desc>5% bQuick Discount</offering_desc>
	<smoothpay_barcode>{®~</smoothpay_barcode>
	<user_def_1></user_def_1>
	<user_def_2></user_def_2>
	<user_def_3></user_def_3>
	<user_def_4></user_def_4>
	<user_def_5></user_def_5>
	<user_def_6></user_def_6>
	<user_def_7></user_def_7>
	<user_def_8></user_def_8>
	<user_def_9></user_def_9>
	<user_def_10></user_def_10>
	<mm_request_id>22091</mm_request_id>
	<mm_sched_id>17</mm_sched_id>
	<mm_template_id>8</mm_template_id>
	<party_id>24126</party_id>
	<cust_account_id>5672</cust_account_id>
	<letter_desc>Final cienection Notice</letter_desc>
	<request_status>NEWWFLOWREQ</request_status>
	<cust_email_address>hussain.alyami92@hotmail.com</cust_email_address>
	<del_class_code>EMAIL</del_class_code>
	<file_name>\\vm-app\OneDrive\OneDrive - Utility Mate Limited\Benergy\Templates\FinalDisconnectionNotice.docx</file_name>
	<save_format>PDF</save_format>
	<save_file_name>15042020_4000000001138_22091</save_file_name>
	<save_directory>NEW_ARCHIVE</save_directory>
	<archive_directory>\\VM-APP\OneDrive\OneDrive - Utility Mate Limited\benergy\Letters\Treatment Letters\Archive</archive_directory>
	<one_file_per_cust>Y</one_file_per_cust>
	<create_cust_doc_record>Y</create_cust_doc_record>
	<merge_sequence>7</merge_sequence>
	<incentive_amount>0.0000000</incentive_amount>
	<penalty_amount>0.0000000</penalty_amount>
	<invoice_number>125683</invoice_number>
	<treatment_invoice_reference>202002/125683</treatment_invoice_reference>
	<invoice_issue_date>17 February 2020</invoice_issue_date>
	<abn_number>48 167 272 282</abn_number>
	<retailer_postal_addr_1>PO Box 429</retailer_postal_addr_1>
	<retailer_postal_addr_2>South Melbourne</retailer_postal_addr_2>
	<retailer_postal_addr_3>VIC 3205</retailer_postal_addr_3>
	<treatment_inv_barcode>{®~</treatment_inv_barcode>
	<meter_list>E1</meter_list>
	<tariff_type>Bundled</tariff_type>
	<account_status>Open</account_status>
	<brand_code>Benergy</brand_code>
	<next_daily_rate>NA</next_daily_rate>
	<next_daily_rate_gst>NA</next_daily_rate_gst>
	<next_prompt_payment_discount></next_prompt_payment_discount>
	<next_peak_price1>NA</next_peak_price1>
	<next_peak_price2>NA</next_peak_price2>
	<next_peak_price3>NA</next_peak_price3>
	<next_peak_price4>NA</next_peak_price4>
	<next_peak_price5>NA</next_peak_price5>
	<next_off_peak_price>NA</next_off_peak_price>
	<next_shoulder_price>NA</next_shoulder_price>
	<next_controlled_load1_price>NA</next_controlled_load1_price>
	<next_controlled_load2_price>NA</next_controlled_load2_price>
	<next_peak_price1_gst>NA</next_peak_price1_gst>
	<next_peak_price2_gst>NA</next_peak_price2_gst>
	<next_peak_price3_gst>NA</next_peak_price3_gst>
	<next_peak_price4_gst>NA</next_peak_price4_gst>
	<next_peak_price5_gst>NA</next_peak_price5_gst>
	<next_off_peak_price_gst>NA</next_off_peak_price_gst>
	<next_shoulder_price_gst>NA</next_shoulder_price_gst>
	<next_controlled_load1_price_gst>NA</next_controlled_load1_price_gst>
	<next_controlled_load2_price_gst>NA</next_controlled_load2_price_gst>
	<next_peak_step1>NA</next_peak_step1>
	<next_peak_step2>NA</next_peak_step2>
	<next_peak_step3>NA</next_peak_step3>
	<next_peak_step4>NA</next_peak_step4>
	<next_solar1_price>NA</next_solar1_price>
	<next_solar2_price>NA</next_solar2_price>
	<next_solar3_price>NA</next_solar3_price>
	<next_solar1_price_gst>NA</next_solar1_price_gst>
	<next_solar2_price_gst>NA</next_solar2_price_gst>
	<next_solar3_price_gst>NA</next_solar3_price_gst>
	<next_stc_price>NA</next_stc_price>
	<next_stc_price_gst>NA</next_stc_price_gst>
	<next_lgc_price>NA</next_lgc_price>
	<next_lgc_price_gst>NA</next_lgc_price_gst>
	<price_plan_start_date>16/12/2019</price_plan_start_date>
	<dd_bank_account_number>N/A</dd_bank_account_number>
	<dd_bank_account_bsb>N/A</dd_bank_account_bsb>
	<dd_bank_account_name>N/A</dd_bank_account_name>
	<dd_credit_card_number>N/A</dd_credit_card_number>
	<dd_credit_card_expiry>N/A</dd_credit_card_expiry>
	<dd_credit_card_name>N/A</dd_credit_card_name>
	<ombudsman_message></ombudsman_message>
	<date_today>15/04/2020</date_today>
</html_merge>


