Difference between revisions of "Customer:OnPac"

From Freeside
Jump to: navigation, search
(Schema changes)
(Usage import)
Line 10: Line 10:
  
 
# Import usage charges into elec_usage table (Usage charges)
 
# Import usage charges into elec_usage table (Usage charges)
 +
** Add import subrouting to elec_usage.pm
 +
** Add page to web UI to accept upload
 +
** Add menu entry and ACL for new page ''Tools->Importing->Import electricity usage from CSV file''
 
# Associate usage charges with specific customer/package (Static mapping)
 
# Associate usage charges with specific customer/package (Static mapping)
 
# Trigger billing for that customer package (Billing)
 
# Trigger billing for that customer package (Billing)

Revision as of 08:53, 2 November 2006

Schema changes

  • Add elec_usage table and class (see Schema Changes)
    • id serial primary_key
    • _date @date_type
    • kwatts int
    • TDSP @money_type

Usage import

  1. Import usage charges into elec_usage table (Usage charges)
    • Add import subrouting to elec_usage.pm
    • Add page to web UI to accept upload
    • Add menu entry and ACL for new page Tools->Importing->Import electricity usage from CSV file
  1. Associate usage charges with specific customer/package (Static mapping)
  2. Trigger billing for that customer package (Billing)

Usage charges

  • KW -> kwatts
  • Invoice date -> _date

Static mapping

  • Customer Name -> informational only, or sanity check w/ Freeside data
  • Customer Number -> cust_main.custnum
  • Meter Number -> cust_pkg.pkgnum?

Unknown

Still have to determine how to handle these fields in import:

  • Invoice number -> need to store/use somehow instead of autogenerated invoice number?
  • Cross reference -> what is this for?
  • ESSID -> what is this for?

Billing

  • Add a rate plan to bill on demand
  • Calculate Kw difference & multiply by a rate (rate stored in part_pkg_option)
  • Pass through the desired details as cust_bill_pkg_detail

Add'l work

  • Handle Due Date
    • Add new cust_bill column to store per-invoice due dates
    • Have import associate this with the bills it triggers