LO PEDIS		ELIZ
Table-name	Type	Nullable	Type	Nullable
id	int(11)	NO	int(11)	NO
reference_no	varchar(55)	NO	varchar(55)	NO
date	timestamp	NO	timestamp	NO
supplier_id	int(11)	NO	int(11)	NO
supplier	varchar(55)	NO	varchar(55)	NO
warehouse_id	int(11)	NO	int(11)	NO
note	varchar(1000)	NO	varchar(1000)	NO
total	decimal(25,4)	YES	decimal(25,4)	YES
product_discount	decimal(25,4)	YES	decimal(25,4)	YES
order_discount_id	varchar(20)	YES	varchar(20)	YES
order_discount	decimal(25,4)	YES	decimal(25,4)	YES
total_discount	decimal(25,4)	YES	decimal(25,4)	YES
product_tax	decimal(25,4)	YES	decimal(25,4)	YES
order_tax_id	int(11)	YES	int(11)	YES
order_tax	decimal(25,4)	YES	decimal(25,4)	YES
total_tax	decimal(25,4)	YES	decimal(25,4)	YES
shipping	decimal(25,4)	YES	decimal(25,4)	YES
grand_total	decimal(25,4)	NO	decimal(25,4)	NO
paid	decimal(25,4)	NO	decimal(25,4)	NO
status	varchar(55)	YES	varchar(55)	YES
payment_status	varchar(20)	YES	varchar(20)	YES
created_by	int(11)	YES	int(11)	YES
updated_by	int(11)	YES	int(11)	YES
updated_at	timestamp	YES	timestamp	YES
attachment	varchar(55)	YES	varchar(55)	YES
payment_term	tinyint(4)	YES	tinyint(4)	YES
due_date	date	YES	date	YES
return_id	int(11)	YES	int(11)	YES
surcharge	decimal(25,4)	NO	decimal(25,4)	NO
return_purchase_ref	varchar(55)	YES	varchar(55)	YES
purchase_id	int(11)	YES	int(11)	YES
return_purchase_total	decimal(25,4)	NO	decimal(25,4)	NO
cgst	decimal(25,4)	YES	decimal(25,4)	YES
sgst	decimal(25,4)	YES	decimal(25,4)	YES
igst	decimal(25,4)	YES	decimal(25,4)	YES
actualiza_stock	varchar(2)	YES	varchar(2)	YES