| id |
int(10)
|
|
|
|
| invoice_id |
varchar(100)
|
latin1_swedish_ci
|
|
|
| store_id |
int(10)
|
|
|
|
| item_id |
int(10)
|
|
|
|
| category_id |
int(10)
|
|
|
|
| brand_id |
int(10)
|
|
|
|
| item_name |
varchar(100)
|
utf8_unicode_ci
|
|
|
| item_purchase_price |
decimal(25,4)
|
|
|
|
| item_selling_price |
decimal(25,4)
|
|
|
|
| item_quantity |
decimal(25,4)
|
|
|
|
| total_sell |
decimal(25,4)
|
|
|
|
| status |
enum('stock', 'active', 'sold')
|
utf8_unicode_ci
|
|
|
| item_total |
decimal(25,4)
|
|
|
|
| item_tax |
decimal(25,4)
|
|
|
|
| tax_method |
enum('exclusive', 'inclusive')
|
utf8_unicode_ci
|
|
|
| tax |
varchar(20)
|
utf8_unicode_ci
|
|
|
| gst |
varchar(20)
|
utf8_unicode_ci
|
|
|
| cgst |
decimal(25,4)
|
|
|
|
| sgst |
decimal(25,4)
|
|
|
|
| igst |
decimal(25,4)
|
|
|
|
| return_quantity |
decimal(25,4)
|
|
|
|
| installment_quantity |
int(11)
|
|
|
|
