| id |
int(11)
|
|
|
|
| reference_no |
varchar(55)
|
utf8_general_ci
|
|
|
| date |
timestamp
|
|
|
|
| supplier_id |
int(11)
|
|
|
|
| supplier |
varchar(55)
|
utf8_general_ci
|
|
|
| warehouse_id |
int(11)
|
|
|
|
| note |
varchar(1000)
|
utf8_general_ci
|
|
|
| total |
decimal(25,4)
|
|
|
|
| product_discount |
decimal(25,4)
|
|
|
|
| order_discount_id |
varchar(20)
|
utf8_general_ci
|
|
|
| order_discount |
decimal(25,4)
|
|
|
|
| total_discount |
decimal(25,4)
|
|
|
|
| product_tax |
decimal(25,4)
|
|
|
|
| order_tax_id |
int(11)
|
|
|
|
| order_tax |
decimal(25,4)
|
|
|
|
| total_tax |
decimal(25,4)
|
|
|
|
| shipping |
decimal(25,4)
|
|
|
|
| grand_total |
decimal(25,4)
|
|
|
|
| paid |
decimal(25,4)
|
|
|
|
| status |
varchar(55)
|
utf8_general_ci
|
|
|
| payment_status |
varchar(20)
|
utf8_general_ci
|
|
|
| created_by |
int(11)
|
|
|
|
| updated_by |
int(11)
|
|
|
|
| updated_at |
timestamp
|
|
|
|
| attachment |
varchar(55)
|
utf8_general_ci
|
|
|
| payment_term |
tinyint(4)
|
|
|
|
| due_date |
date
|
|
|
|
| return_id |
int(11)
|
|
|
|
| surcharge |
decimal(25,4)
|
|
|
|
| return_purchase_ref |
varchar(55)
|
utf8_general_ci
|
|
|
| purchase_id |
int(11)
|
|
|
|
| return_purchase_total |
decimal(25,4)
|
|
|
|
| cgst |
decimal(25,4)
|
|
|
|
| sgst |
decimal(25,4)
|
|
|
|
| igst |
decimal(25,4)
|
|
|
|
