id | int(11) |
|
|
|
kot_no | varchar(16) |
|
|
|
type | tinyint(4) |
|
|
|
type_id | int(11) |
|
|
|
hash | varchar(128) |
|
|
|
customer_id | int(11) |
|
|
|
service_id | int(16) |
|
|
|
grand_total | int(16) |
|
|
|
amount_received | decimal(10,2) |
|
|
|
total_amount | decimal(10,2) |
|
|
|
tax_amount | int(16) |
|
|
|
discount_percent | decimal(10,2) |
|
|
|
discount | decimal(10,2) |
|
|
|
delivery_charges | decimal(10,2) |
|
|
|
service_charges_percent | decimal(10,2) |
|
|
|
service_charges | decimal(10,2) |
|
|
|
reward_discount | decimal(10,2) |
|
|
|
details | varchar(256) |
|
|
|
post_date | date |
|
|
|
post_time | time |
|
|
|
status | tinyint(4) |
|
|
|
last_updated | varchar(36) |
|
|
|