Table comparison: sma_quote_items
|
LO PEDIS |
ELIZ |
| Table-name |
Type |
Nullable |
Type |
Nullable |
|
id |
int(11) |
NO |
int(11) |
NO |
|
quote_id |
int(11) |
NO |
int(11) |
NO |
|
product_id |
bigint(20) |
NO |
bigint(11) |
NO |
|
product_code |
varchar(55) |
NO |
varchar(55) |
NO |
|
product_name |
varchar(255) |
NO |
varchar(255) |
NO |
|
product_type |
varchar(20) |
YES |
varchar(20) |
YES |
|
option_id |
int(11) |
YES |
int(11) |
YES |
|
net_unit_price |
decimal(25,4) |
NO |
decimal(25,4) |
NO |
|
unit_price |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
quantity |
decimal(15,4) |
NO |
decimal(15,4) |
NO |
|
warehouse_id |
int(11) |
YES |
int(11) |
YES |
|
item_tax |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
tax_rate_id |
int(11) |
YES |
int(11) |
YES |
|
tax |
varchar(55) |
YES |
varchar(55) |
YES |
|
discount |
varchar(55) |
YES |
varchar(55) |
YES |
|
item_discount |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
subtotal |
decimal(25,4) |
NO |
decimal(25,4) |
NO |
|
serial_no |
varchar(255) |
YES |
varchar(255) |
YES |
|
real_unit_price |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
product_unit_id |
int(11) |
YES |
int(11) |
YES |
|
product_unit_code |
varchar(10) |
YES |
varchar(10) |
YES |
|
unit_quantity |
decimal(15,4) |
NO |
decimal(15,4) |
NO |
|
gst |
varchar(20) |
YES |
varchar(20) |
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 |