Back
/*
View: dlog

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
    memType int
    staff int
    numflag int
    charflag int
    card_no int
    trans_id int
    pos_row_id int
    store_row_id int
    trans_num varchar

Depends on:
    dtransactions (table)

Use:
This view presents simplified access to
dtransactions. It omits rows from canceled
transactions and testing lane(s)/cashier(s)
*/
Back