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