Back
/*
View: unpaid_ar_today

Columns:
    card_no int
    old_balance (calculated)
    recent_payments (calculated)
    mark (calculated)

Depends on:
    ar_history (table)
    unpaid_ar_balances (view of t.ar_history)
    ar_history_today_sum (view of t.dtransactions via v.dlog)

Depended on by:
  cron/LanePush/UpdateUnpaidAR.php
   to update each lane opdata.unpaid_ar_today.recent_payments

Use:
This view adds payments from the current
day to the view unpaid_ar_balances

The logic is pretty WFC-specific, but the 
general idea is to notify customers that they
have a balance overdue at checkout

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

    * 24Oct2012 Eric Lee Comments Add Depended on by:, add to Depends on:, code style

*/
Back