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