Back
/*
View: unpaid_ar_balances
Columns:
card_no int
old_balance (calculated)
recent_payments (calculated)
Depends on:
ar_history (table)
Depended on by:
unpaid_ar_today (view)
Use:
This view lists A/R balances older than
20 days and payments made in the last 20 days.
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:, code style
*/
Back