| id |
int(11)
|
|
|
|
| transfer_id |
int(11)
|
|
|
|
| product_id |
int(11)
|
|
|
|
| product_code |
varchar(55)
|
utf8_general_ci
|
|
|
| product_name |
varchar(255)
|
utf8_general_ci
|
|
|
| option_id |
int(11)
|
|
|
|
| expiry |
date
|
|
|
|
| quantity |
decimal(15,4)
|
|
|
|
| tax_rate_id |
int(11)
|
|
|
|
| tax |
varchar(55)
|
utf8_general_ci
|
|
|
| item_tax |
decimal(25,4)
|
|
|
|
| net_unit_cost |
decimal(25,4)
|
|
|
|
| subtotal |
decimal(25,4)
|
|
|
|
| quantity_balance |
decimal(15,4)
|
|
|
|
| unit_cost |
decimal(25,4)
|
|
|
|
| real_unit_cost |
decimal(25,4)
|
|
|
|
| date |
date
|
|
|
|
| warehouse_id |
int(11)
|
|
|
|
| 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)
|
|
|
|
