Back
/*
Table: AR_EOM_Summary

Columns:
    card_no int
    memName varchar
    priorBalance money
    threeMonthCharges money
    threeMonthPayments money
    threeMonthBalance money
    twoMonthCharges money
    twoMonthPayments money
    twoMonthBalance money
    lastMonthCharges money
    lastMonthPayments money
    lastMonthBalance money

Use:
List of customer start/end AR balances
over past few months

Maintenance:
cron/nightly.ar.php, after updating ar_history,
 truncates ar_history_backup and then appends all of ar_history
 to it, giving new data for AR_EOM_Summary.

*//* --COMMENTS - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    * 22Oct2012 EL Add Maintenance section
  * 20Oct2012 Eric Lee Fix capitalization in array index.
    *                    Add MSSQL version.

*/
Back