Difference between revisions of "Customer:OnPac"
From Freeside
(→Usage import) |
(→Usage import) |
||
Line 9: | Line 9: | ||
= Usage import = | = Usage import = | ||
− | + | * Import usage charges into elec_usage table (Usage charges) | |
− | ** Add import | + | |
+ | ** Add import subroutine to elec_usage.pm | ||
** Add page to web UI to accept upload | ** Add page to web UI to accept upload | ||
** Add menu entry and ACL for new page ''Tools->Importing->Import electricity usage from CSV file'' | ** 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) | |
+ | * Trigger billing for that customer package (Billing) | ||
== Usage charges == | == Usage charges == |
Revision as of 08:54, 2 November 2006
Contents
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
- Import usage charges into elec_usage table (Usage charges)
- Add import subroutine 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)
- 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