| id |
int(10)
|
|
|
|
| reference_no |
varchar(100)
|
utf8_unicode_ci
|
|
|
| store_id |
int(10)
|
|
|
|
| sup_id |
int(10)
|
|
|
|
| category_id |
int(10)
|
|
|
|
| brand_id |
int(10)
|
|
|
|
| item_id |
int(10)
|
|
|
|
| item_name |
varchar(100)
|
utf8_unicode_ci
|
|
|
| item_price |
decimal(25,4)
|
|
|
|
| item_discount |
decimal(25,4)
|
|
|
|
| item_tax |
decimal(25,4)
|
|
|
|
| tax_method |
enum('exclusive', 'inclusive')
|
utf8_unicode_ci
|
|
|
| taxrate_id |
int(10)
|
|
|
|
| tax |
varchar(55)
|
utf8_unicode_ci
|
|
|
| gst |
varchar(20)
|
utf8_unicode_ci
|
|
|
| cgst |
decimal(25,4)
|
|
|
|
| sgst |
decimal(25,4)
|
|
|
|
| igst |
decimal(25,4)
|
|
|
|
| item_quantity |
decimal(25,4)
|
|
|
|
| item_purchase_price |
decimal(25,4)
|
|
|
|
| item_total |
decimal(25,4)
|
|
|
|
| purchase_invoice_id |
varchar(100)
|
utf8_unicode_ci
|
|
|
