| id |
int(10)
|
|
|
|
| reference_no |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| user_id |
int(11)
|
|
|
|
| cash_register_id |
int(11)
|
|
|
|
| customer_id |
int(11)
|
|
|
|
| warehouse_id |
int(11)
|
|
|
|
| biller_id |
int(11)
|
|
|
|
| item |
int(11)
|
|
|
|
| total_qty |
double
|
|
|
|
| total_discount |
double
|
|
|
|
| total_tax |
double
|
|
|
|
| total_price |
double
|
|
|
|
| grand_total |
double
|
|
|
|
| order_tax_rate |
double
|
|
|
|
| order_tax |
double
|
|
|
|
| order_discount_type |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| order_discount_value |
double
|
|
|
|
| order_discount |
double
|
|
|
|
| coupon_id |
int(11)
|
|
|
|
| coupon_discount |
double
|
|
|
|
| shipping_cost |
double
|
|
|
|
| sale_status |
int(11)
|
|
|
|
| payment_status |
int(11)
|
|
|
|
| document |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| paid_amount |
double
|
|
|
|
| sale_note |
text
|
utf8mb4_unicode_ci
|
|
|
| staff_note |
text
|
utf8mb4_unicode_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
