| id |
int(11)
|
|
|
|
| date |
timestamp
|
|
|
|
| reference_no |
varchar(55)
|
utf8_general_ci
|
|
|
| customer_id |
int(11)
|
|
|
|
| customer |
varchar(55)
|
utf8_general_ci
|
|
|
| biller_id |
int(11)
|
|
|
|
| biller |
varchar(55)
|
utf8_general_ci
|
|
|
| warehouse_id |
int(11)
|
|
|
|
| note |
varchar(1000)
|
utf8_general_ci
|
|
|
| staff_note |
varchar(1000)
|
utf8_general_ci
|
|
|
| total |
decimal(25,4)
|
|
|
|
| product_discount |
decimal(25,4)
|
|
|
|
| order_discount_id |
varchar(20)
|
utf8_general_ci
|
|
|
| total_discount |
decimal(25,4)
|
|
|
|
| order_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)
|
|
|
|
| sale_status |
varchar(20)
|
utf8_general_ci
|
|
|
| payment_status |
varchar(20)
|
utf8_general_ci
|
|
|
| payment_term |
tinyint(4)
|
|
|
|
| due_date |
date
|
|
|
|
| created_by |
int(11)
|
|
|
|
| updated_by |
int(11)
|
|
|
|
| updated_at |
timestamp
|
|
|
|
| total_items |
smallint(6)
|
|
|
|
| pos |
tinyint(1)
|
|
|
|
| paid |
decimal(25,4)
|
|
|
|
| return_id |
int(11)
|
|
|
|
| surcharge |
decimal(25,4)
|
|
|
|
| attachment |
varchar(55)
|
utf8_general_ci
|
|
|
| return_sale_ref |
varchar(55)
|
utf8_general_ci
|
|
|
| sale_id |
int(11)
|
|
|
|
| return_sale_total |
decimal(25,4)
|
|
|
|
| rounding |
decimal(10,4)
|
|
|
|
| suspend_note |
varchar(255)
|
utf8_general_ci
|
|
|
| api |
tinyint(1)
|
|
|
|
| shop |
tinyint(1)
|
|
|
|
| address_id |
int(11)
|
|
|
|
| reserve_id |
int(11)
|
|
|
|
| hash |
varchar(255)
|
utf8_general_ci
|
|
|
| manual_payment |
varchar(55)
|
utf8_general_ci
|
|
|
| cgst |
decimal(25,4)
|
|
|
|
| sgst |
decimal(25,4)
|
|
|
|
| igst |
decimal(25,4)
|
|
|
|
| payment_method |
varchar(55)
|
utf8_general_ci
|
|
|
