DATABASE AxisPro ( axisproerp.com ) Database Breach , Leaked Download

Quote:type smallint(6) unsigned NOT NULL DEFAULT '0',
sql_srv_srno int(10) unsigned NOT NULL DEFAULT '0',
sql_srv_vtype varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
sql_srv_status int(11) NOT NULL DEFAULT '1' COMMENT '0 = Error, 1 = Success, -1 = Edited, -2 = Deleted',
version tinyint(1) unsigned NOT NULL DEFAULT '0',
debtor_no int(11) unsigned NOT NULL,
branch_code int(11) NOT NULL DEFAULT '-1',
tran_date date DEFAULT NULL,
due_date date DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
reference varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
barcode varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
tpe int(11) NOT NULL DEFAULT '0',
order_ int(11) NOT NULL DEFAULT '0',
ov_amount double NOT NULL DEFAULT '0',
ov_gst double NOT NULL DEFAULT '0',
ov_freight double NOT NULL DEFAULT '0',
ov_freight_tax double NOT NULL DEFAULT '0',
ov_discount double NOT NULL DEFAULT '0',
alloc double NOT NULL DEFAULT '0',
prep_amount double NOT NULL DEFAULT '0',
round_of_amount double NOT NULL DEFAULT '0',
rate double NOT NULL DEFAULT '1',
ship_via int(11) DEFAULT NULL,
dimension_id int(11) NOT NULL DEFAULT '0',
dimension2_id int(11) NOT NULL DEFAULT '0',
payment_terms int(11) DEFAULT NULL,
tax_included tinyint(1) unsigned NOT NULL DEFAULT '0',
display_customer varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
customer_trn varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
customer_mobile varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
customer_email varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
customer_ref varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
payment_method varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
credit_card_charge varchar(255) COLLATE utf8_unicode_ci DEFAULT '0',
show_bank_charge int(11) DEFAULT '0',
payment_flag int(11) DEFAULT '0' COMMENT '0-Amer,1-Tasheel Edirham card, 2-Tasheel Customer Card,3-Amer Customer Card',
cust_emp_id varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
cust_emp_name varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
invoice_type varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
inv_total double DEFAULT '0',
customer_card_amount double DEFAULT '0',
created_by int(11) DEFAULT NULL,
payment_type int(11) DEFAULT NULL,
cheq_no varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
cheq_date date DEFAULT NULL,
token_number varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (type,trans_no,debtor_no),

Click to expand...