Table comparison: sma_transfers
|
LO PEDIS |
ELIZ |
| Table-name |
Type |
Nullable |
Type |
Nullable |
|
id |
int(11) |
NO |
int(11) |
NO |
|
transfer_no |
varchar(55) |
NO |
varchar(55) |
NO |
|
date |
timestamp |
NO |
timestamp |
NO |
|
from_warehouse_id |
int(11) |
NO |
int(11) |
NO |
|
from_warehouse_code |
varchar(55) |
NO |
varchar(55) |
NO |
|
from_warehouse_name |
varchar(55) |
NO |
varchar(55) |
NO |
|
to_warehouse_id |
int(11) |
NO |
int(11) |
NO |
|
to_warehouse_code |
varchar(55) |
NO |
varchar(55) |
NO |
|
to_warehouse_name |
varchar(55) |
NO |
varchar(55) |
NO |
|
note |
varchar(1000) |
YES |
varchar(1000) |
YES |
|
total |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
total_tax |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
grand_total |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
created_by |
varchar(255) |
YES |
varchar(255) |
YES |
|
status |
varchar(55) |
NO |
varchar(55) |
NO |
|
shipping |
decimal(25,4) |
NO |
decimal(25,4) |
NO |
|
attachment |
varchar(55) |
YES |
varchar(55) |
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 |