Table comparison: sma_payments
|
LO PEDIS |
ELIZ |
| Table-name |
Type |
Nullable |
Type |
Nullable |
|
id |
int(11) |
NO |
int(11) |
NO |
|
date |
timestamp |
YES |
timestamp |
YES |
|
sale_id |
int(11) |
YES |
int(11) |
YES |
|
return_id |
int(11) |
YES |
int(11) |
YES |
|
purchase_id |
int(11) |
YES |
int(11) |
YES |
|
reference_no |
varchar(50) |
NO |
varchar(50) |
NO |
|
transaction_id |
varchar(50) |
YES |
varchar(50) |
YES |
|
paid_by |
varchar(20) |
NO |
varchar(20) |
NO |
|
cheque_no |
varchar(20) |
YES |
varchar(20) |
YES |
|
cc_no |
varchar(20) |
YES |
varchar(20) |
YES |
|
cc_holder |
varchar(25) |
YES |
varchar(25) |
YES |
|
cc_month |
varchar(2) |
YES |
varchar(2) |
YES |
|
cc_year |
varchar(4) |
YES |
varchar(4) |
YES |
|
cc_type |
varchar(20) |
YES |
varchar(20) |
YES |
|
amount |
decimal(25,4) |
NO |
decimal(25,4) |
NO |
|
currency |
varchar(3) |
YES |
varchar(3) |
YES |
|
created_by |
int(11) |
NO |
int(11) |
NO |
|
attachment |
varchar(55) |
YES |
varchar(55) |
YES |
|
type |
varchar(20) |
NO |
varchar(20) |
NO |
|
note |
varchar(1000) |
YES |
varchar(1000) |
YES |
|
pos_paid |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
pos_balance |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
approval_code |
varchar(50) |
YES |
varchar(50) |
YES |
|
cantidad_cuota |
int(11) |
YES |
int(11) |
YES |
|
recargototal |
float |
YES |
float |
YES |
|
recargotarjeta |
float |
YES |
float |
YES |