Table comparison: sma_returns
|
LO PEDIS |
ELIZ |
| Table-name |
Type |
Nullable |
Type |
Nullable |
|
id |
int(11) |
NO |
int(11) |
NO |
|
date |
timestamp |
NO |
timestamp |
NO |
|
reference_no |
varchar(55) |
NO |
varchar(55) |
NO |
|
customer_id |
int(11) |
NO |
int(11) |
NO |
|
customer |
varchar(55) |
NO |
varchar(55) |
NO |
|
biller_id |
int(11) |
NO |
int(11) |
NO |
|
biller |
varchar(55) |
NO |
varchar(55) |
NO |
|
warehouse_id |
int(11) |
YES |
int(11) |
YES |
|
note |
varchar(1000) |
YES |
varchar(1000) |
YES |
|
staff_note |
varchar(1000) |
YES |
varchar(1000) |
YES |
|
total |
decimal(25,4) |
NO |
decimal(25,4) |
NO |
|
product_discount |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
order_discount_id |
varchar(20) |
YES |
varchar(20) |
YES |
|
total_discount |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
order_discount |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
product_tax |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
order_tax_id |
int(11) |
YES |
int(11) |
YES |
|
order_tax |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
total_tax |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
grand_total |
decimal(25,4) |
NO |
decimal(25,4) |
NO |
|
created_by |
int(11) |
YES |
int(11) |
YES |
|
updated_by |
int(11) |
YES |
int(11) |
YES |
|
updated_at |
timestamp |
YES |
timestamp |
YES |
|
total_items |
smallint(6) |
YES |
smallint(6) |
YES |
|
paid |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
surcharge |
decimal(25,4) |
NO |
decimal(25,4) |
NO |
|
attachment |
varchar(55) |
YES |
varchar(55) |
YES |
|
hash |
varchar(255) |
YES |
varchar(255) |
YES |
|
cgst |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
sgst |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
igst |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
shipping |
decimal(25,4) |
YES |
decimal(25,4) |
YES |