Back
/*
Table: ar_history
Columns:
card_no int
charges dbms currency
payments dbms currency
tdate datetime
trans_num varchar
Depends on:
transarchive (table), i.e. dlog_15 (table)
was: dlog (view)
Depended on by:
table ar_history_backup and its descendents
view ar_history_sum and its descendents
Use:
This table stores charges and payments on
a customer's in-store charge account.
Maintenance:
This table should be updated in conjunction with
any day-end polling system to copy appropriate
rows from transarchive to ar_history
cron/nightly.ar.php appends selected columns from
appropriate rows from dlog_15 (i.e. dtransactions)
*//* --COMMENTS - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
* 22Oct2012 Eric Lee Change Depends on:
* Break Maintenance section of comments from Use:
* add note about cronjob
*/
Back