| price_id |
int(10)
|
|
|
|
| invoice_id |
varchar(100)
|
utf8_unicode_ci
|
|
|
| store_id |
int(10)
|
|
|
|
| subtotal |
decimal(25,4)
|
|
|
|
| discount_type |
enum('plain', 'percentage')
|
utf8_unicode_ci
|
|
|
| discount_amount |
decimal(25,4)
|
|
|
|
| interest_amount |
decimal(25,4)
|
|
|
|
| interest_percentage |
int(10)
|
|
|
|
| item_tax |
decimal(25,4)
|
|
|
|
| order_tax |
decimal(25,4)
|
|
|
|
| cgst |
decimal(25,4)
|
|
|
|
| sgst |
decimal(25,4)
|
|
|
|
| igst |
decimal(25,4)
|
|
|
|
| total_purchase_price |
decimal(25,4)
|
|
|
|
| shipping_type |
enum('plain', 'percentage')
|
utf8_unicode_ci
|
|
|
| shipping_amount |
decimal(25,4)
|
|
|
|
| others_charge |
decimal(25,4)
|
|
|
|
| payable_amount |
decimal(25,4)
|
|
|
|
| paid_amount |
decimal(25,4)
|
|
|
|
| due |
decimal(25,4)
|
|
|
|
| due_paid |
decimal(25,4)
|
|
|
|
| return_amount |
decimal(25,4)
|
|
|
|
| balance |
decimal(25,4)
|
|
|
|
| profit |
decimal(25,4)
|
|
|
|
| previous_due |
decimal(25,4)
|
|
|
|
| prev_due_paid |
decimal(25,4)
|
|
|
|
