Table comparison: sma_pos_register
|
LO PEDIS |
ELIZ |
| Table-name |
Type |
Nullable |
Type |
Nullable |
|
id |
int(11) |
NO |
int(11) |
NO |
|
date |
timestamp |
NO |
timestamp |
NO |
|
user_id |
int(11) |
NO |
int(11) |
NO |
|
cash_in_hand |
decimal(25,4) |
NO |
decimal(25,4) |
NO |
|
status |
varchar(10) |
NO |
varchar(10) |
NO |
|
total_cash |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
total_cheques |
int(11) |
YES |
int(11) |
YES |
|
total_cc_slips |
int(11) |
YES |
int(11) |
YES |
|
total_cash_submitted |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
total_cheques_submitted |
int(11) |
YES |
int(11) |
YES |
|
total_cc_slips_submitted |
int(11) |
YES |
int(11) |
YES |
|
note |
text |
YES |
text |
YES |
|
closed_at |
timestamp |
YES |
timestamp |
YES |
|
transfer_opened_bills |
varchar(50) |
YES |
varchar(50) |
YES |
|
closed_by |
int(11) |
YES |
int(11) |
YES |
|
withdrawal_count |
|
|
int(11) |
NO |
|
total_withdrawals |
|
|
decimal(25,4) |
NO |