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