id
int(10)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
reference_no
varchar(191)
utf8mb4_unicode_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
user_id
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
cash_register_id
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
customer_id
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
warehouse_id
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
biller_id
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
item
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
total_qty
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
total_discount
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
total_tax
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
total_price
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
grand_total
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
order_tax_rate
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
order_tax
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
order_discount_type
varchar(191)
utf8mb4_unicode_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
order_discount_value
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
order_discount
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
coupon_id
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
coupon_discount
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
shipping_cost
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
sale_status
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
payment_status
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
document
varchar(191)
utf8mb4_unicode_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
paid_amount
double
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
sale_note
text
utf8mb4_unicode_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
staff_note
text
utf8mb4_unicode_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
created_at
timestamp
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
updated_at
timestamp
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
