Back
/*
Table: dlog_15
Columns:
tdate datetime
register_no int
emp_no int
trans_no int
upc varchar
trans_type varchar
trans_subtype varchar
trans_status varchar
department int
quantity double
unitPrice dbms currency
total dbms currency
tax int
foodstamp int
ItemQtty double
card_no int
trans_id int
pos_row_id int
store_row_id int
trans_num
Depends on:
dlog_90_view (view)
Use:
This is just a look-up table. It contains the
past 15 days worth of dlog entries. For reports
on data within that time frame, it's faster to
use this small table.
Maintenance:
Truncated and populated by cron/nightly.dtrans.php
*//* --COMMENTS - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
* 23Oct2012 Eric Lee Added Maintenance section to comments.
*/
Back