Table comparison: sma_quotes2
|
LO PEDIS |
ELIZ |
| Table-name |
Type |
Nullable |
Type |
Nullable |
|
id |
int(11) |
NO |
int(11) |
NO |
|
date |
timestamp |
NO |
timestamp |
NO |
|
dateentrega |
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 |
|
warehouse_id |
int(11) |
YES |
int(11) |
YES |
|
biller_id |
int(11) |
NO |
int(11) |
NO |
|
biller |
varchar(55) |
NO |
varchar(55) |
NO |
|
note |
varchar(1000) |
YES |
varchar(1000) |
YES |
|
internal_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 |
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 |
|
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 |
|
shipping |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
grand_total |
decimal(25,4) |
NO |
decimal(25,4) |
NO |
|
status |
varchar(20) |
YES |
varchar(20) |
YES |
|
created_by |
int(11) |
YES |
int(11) |
YES |
|
updated_by |
int(11) |
YES |
int(11) |
YES |
|
updated_at |
timestamp |
YES |
timestamp |
YES |
|
attachment |
varchar(55) |
YES |
varchar(55) |
YES |
|
attachment_aparato |
varchar(55) |
YES |
varchar(55) |
YES |
|
attachment_aparato2 |
varchar(55) |
YES |
varchar(55) |
YES |
|
supplier_id |
int(11) |
YES |
int(11) |
YES |
|
supplier |
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 |
|
marca |
varchar(200) |
YES |
varchar(200) |
YES |
|
modelo |
varchar(200) |
YES |
varchar(200) |
YES |
|
color |
varchar(200) |
YES |
varchar(200) |
YES |
|
estado |
varchar(200) |
YES |
varchar(200) |
YES |
|
falla |
varchar(200) |
YES |
varchar(200) |
YES |
|
nombre_tecnico |
int(11) |
YES |
int(11) |
YES |
|
adelanto |
int(11) |
YES |
int(11) |
YES |
|
tipo_adelanto |
varchar(300) |
YES |
varchar(300) |
YES |
|
tipo_adelanto_tarjeta |
varchar(300) |
YES |
varchar(300) |
YES |
|
idventaasociada |
int(11) |
YES |
int(11) |
YES |
|
idquote |
int(11) |
YES |
int(11) |
YES |
|
apynom |
varchar(500) |
YES |
varchar(500) |
YES |
|
telefono |
varchar(50) |
YES |
varchar(50) |
YES |
|
dni |
varchar(50) |
YES |
varchar(50) |
YES |