| id |
int(11)
|
|
|
|
| quote_id |
int(11)
|
|
|
|
| product_id |
int(11)
|
|
|
|
| product_code |
varchar(55)
|
utf8_general_ci
|
|
|
| product_name |
varchar(255)
|
utf8_general_ci
|
|
|
| product_type |
varchar(20)
|
utf8_general_ci
|
|
|
| option_id |
int(11)
|
|
|
|
| net_unit_price |
decimal(25,4)
|
|
|
|
| unit_price |
decimal(25,4)
|
|
|
|
| quantity |
decimal(15,4)
|
|
|
|
| warehouse_id |
int(11)
|
|
|
|
| item_tax |
decimal(25,4)
|
|
|
|
| tax_rate_id |
int(11)
|
|
|
|
| tax |
varchar(55)
|
utf8_general_ci
|
|
|
| discount |
varchar(55)
|
utf8_general_ci
|
|
|
| item_discount |
decimal(25,4)
|
|
|
|
| subtotal |
decimal(25,4)
|
|
|
|
| serial_no |
varchar(255)
|
utf8_general_ci
|
|
|
| real_unit_price |
decimal(25,4)
|
|
|
|
| product_unit_id |
int(11)
|
|
|
|
| product_unit_code |
varchar(10)
|
utf8_general_ci
|
|
|
| unit_quantity |
decimal(15,4)
|
|
|
|
| gst |
varchar(20)
|
utf8_general_ci
|
|
|
| cgst |
decimal(25,4)
|
|
|
|
| sgst |
decimal(25,4)
|
|
|
|
| igst |
decimal(25,4)
|
|
|
|