adlogs:adlogid;asource;adminid;logdets;tstam;aip;
admins:mem_id;adminid;password;email;phone;name;gender;natid;level;jobgroup;bankaccount;bank;bankbranch;bankcode;payrollno;nhif;nssf;servedby;staffgroupid;onpayroll;myreceipt;krapin;salarytype;store;canwholesale;editcore;canapprove;oncontract;rate;
assetst:asid;assetno;assetyr;assetqty;assetuvalue;catid;
attendance:rid;mem_id;serial;dayp;present;timein;dayo;timeout;servedbyin;servedbyout;logs;
attendanceoptions:atopid;aname;shortform;earlytime;latetime;isdefault;incomefield;incomerate;outcomefield;outcomerate;extra1;extra2;inorout;
attendancerate:serial;mem_id;fieldid;attendancefield;paydeduct;rate;
backup:backup;adminno;doneon;ip;
batches:batchid;serial;descri;ref;product;quantity;goodqty;unitselling;batchdate;stockid;createdby;belongto;
belowar:belowarid;urlidn;urlmodule;avalue;itemname;visible;
biometrics:bioid;serials;ident;userid;dtime;ldate;ltime;usertype;
cars:carid;carno;driver;driverphone;cardetails;password;balances;
cartaccounts:accountid;acref;customerno;pidzy;fullname;phonenumber;emaily;postal;pin;ide;datejoin;itemcost;shipto;shipfee;destination;destinationname;shipphone;totaldue;agree;invoicepaid;payref;stepsc;attachment1;attachment2;
cartaddons:addonid;pid;accountid;cvidv;cvanswer;addon;
cartproducts:ppid;accountid;dataid;ssid;pname;pdesc;catid;img1;price;qty;total;vat;onwhere;
categories:catid;cattype;largecat;catname;descri;stocktype;withempties;visible;generalimage;
catperiods:periodid;periodname;rential;
catprofiling:prfid;pid;profileorbill;profilename;details;periodevery;periodname;compulsory;primage;
cattype:cattypeid;cattypename;stocktype;
catvalues:cvid;pid;prfid;profilename;prfname2;cvanswer;ratetype;periodname;periodevery;profileorbill;
cdnotes:cdid;suppcreditor;supcusno;batchdlid;reduceadd;narration;amount;ndate;pby;rno;locked;ts;
charges:chargeid;prpid;chargename;oneoff;compulsory;amountrate;visible;
combinedeliveries:dlid;carno;customerid;driver;route;ddate;pby;
combinedeliveries2:serial;c;carno;dlid;customerid;loadworth;addedon;
customers:customerid;password;activated;otp;otpdate;name;email;phone;company;town;otherdetails;initialdebt;climit;balance;points;regon;issite;ide;facephoto;idfront;idback;signature;
customersgroup:grid;customerid;memid;serial;otherdetails;
customersonline:sessionno;customerid;email;phone;sessionserial;gender;name;ondate;service;others;password;servedby;
deliveries:delid;invoiceno;loadworth;deliverytitle;customerid;personn;address;carno;cardesc;deliveryon;status;pby;pbyname;tstamp;lthrough;combined;ready;done;orderby;fcomment;deleted;deletedproduct;store;tsent;tdispatched;cleared;clearing;kstamp;pendingapprove;filed;terms;cdid;issuetype;
deliveries2:did;dlid;pby;deliveryon;pid;pname;pdesc;catid;units;multiplier;receivedinform;formprice;car;serial;cf;loaded;quantity;store;discount;uprice;ucost;value;vat;others;rno;project;lthrough;empties;ssid;serialv;archived;ts;issuetype;
deliveries2b:did;dlid;pby;deliveryon;pid;pname;pdesc;catid;units;multiplier;receivedinform;formprice;car;serial;cf;loaded;quantity;store;discount;uprice;ucost;value;vat;others;rno;project;lthrough;empties;ssid;serialv;archived;ts;issuetype;
deliveries2bstores:dtosid;serial;delid;pid;store;quantity;transfer;project;rno;deliveryon;lthrough;archived;ts;
deliveries2c:did;dlid;pby;deliveryon;pid;pname;pdesc;catid;units;multiplier;receivedinform;formprice;car;serial;cf;loaded;quantity;store;discount;uprice;ucost;value;vat;others;rno;project;lthrough;empties;ssid;serialv;archived;ts;issuetype;
deliveries2cstores:dtosid;serial;delid;pid;store;quantity;transfer;project;rno;deliveryon;lthrough;archived;ts;
deliveries2report:serial;deliveryon;pid;car;bf;loaded;loadworth;solditems;itembalance;sales;worth;
deliveries2returned:serial;deliveryon;dlid;pid;car;bfue;loaded;returned;sales;price;empties;
deliveries2stores:dtosid;serial;delid;pid;store;quantity;transfer;project;rno;deliveryon;lthrough;archived;ts;
deliveries3:serial;deliveryon;pid;personn;myreceipt;
deliveriesbackup:delid;invoiceno;loadworth;deliverytitle;customerid;personn;address;carno;cardesc;deliveryon;status;pby;pbyname;tstamp;lthrough;combined;ready;done;orderby;fcomment;deleted;deletedproduct;store;tsent;tdispatched;cleared;clearing;kstamp;pendingapprove;filed;
ecommercelinks:elid;commercetitle;commerceurl;commerceothers;
empties:emptyserial;car;deliveryon;emptiesdue;emptiesexpected;returnedempties;emptiesbalance;
fin:id;f1;f2;f3;msg;
historycustomers:hsupid;ssupplier;snarration;stype;sin;sout;sdate;sref;savingid;trntype;
historyprd:hid;hpid;hcustomerid;hinorout;hquantity;hquantity2;href;storesbefore;hnarration;hdate;storesafter;deleted;
historyprdbackup:hid;hpid;hcustomerid;hinorout;hquantity;hquantity2;href;storesbefore;hnarration;hdate;storesafter;
hotelbio:bioid;part;bioname;lthrough;visible;fil;
hotelbiov:serial;bioid;dda;valu;lthrough;
hrattendanceoptions:attid;aname;shortform;aocolor;earlytime;latetime;isdefault;incomefield;incomerate;outcomefield;outcomerate;extra1;extra2;inorout;consideredas;
hrbanks:bankid;bankname;bankcode;
hrdeductions:deductid;mserial;mem_id;mname;dyear;dmonth;duration;deductname;amount1;amountrate;headid;ddate;
hrdeductionsplan:hrdedpid;dedserial;deductid;cyear;cmon;amount;mem_id;hrpayid;paid;headid;
hrleaves:leaveid;fyear;adminid;daystaken;reason;leavefrom;toreport;approver1id;approver1;approver2;reported;createdon;leavetype;altcont;
hrleavesact:hractid;actname;
hrleavespurposes:ppid;purpose;dfrom;dto;efdate;
hrleavesschedules:schid;hserial;hrltid;typename;hyear;hmonth;mem_id;mname;hdate;ppid;hreasonmess;aocolor;
hrleavestypes:hrltid;typename;lsf;aocolor;
hrneeds:hrneedid;need;needorder;visible;
hrpaycats:hrpaycatid;hrcn;visible;calculated;
hrpayfields:pfid;serial;headid;mem_id;fieldname;
hrpayheads:headid;headname;hrinout;hrinoutact;paidtofor;paidname;taxable;lessfromtaxable;visible;hasno;
hrpays:hrpayid;serial;yearp;monthp;headid;mem_id;amount;approved;doneby;
hrstaffgroups:staffgroupid;groupname;details;visible;
hrtaxbands:bandid;lowest;highest;diff;cummulative;trate;headid;perval;
hrtimeregister:rid;mem_id;serial;dayp;attid;attendmark;aocolor;timein;timeout;consideredas;usertype;rate;paymentsnid;
installments:iserial;customerid;loan;ddate;amount;
internaltrransfers:transferid;narration;pname;pid;sourcestore;tostore;tdate;qty1;pby;
invoicespay:payid;supplier;batch;paidas;amount;trans;batchdate;
levels:lid;level;incharge;others;ldesc;
lthrough:lthroughid;lthroughname;
mpesachannels:channelid;chaneltype;businessnumber;channellink;active;postto;primarylink;
ofni:id;fname;f1;visible;
ordereditems:salesid;orderno;pid;cattype;bank;paidas;stock_id;productname;unitbprice;pricepunit;unit;inside;added;discount;units;multiplier;receivedinform;qty;vat;amount;dateup;bookedto;servedby;val;dispatch;mystore;storesstring;
orders:orderno;phone;deliveryon;customerid;stime;sdetails;sothers;pcost;serviceid;servicefee;amount;vat;orderon;paidall;balance;dispatched;myreceipt;otype;servedby;delid;approvedby;terms;
ordersclientpay:oid;orderno;trans;amount;accepted;postedon;
ordersmpesas:mpid;orderno;trans;amount;phone;pdate;postedby;
paidas:paidasid;payto;payname;paidasname;paidasname2;paytoname;haschange;
payeebalances:serial;payeeid;yearop;bf;
payees:payeeid;paymentstype;paytypeid;name;identification;phone;email;postal;addedon;payableid;ifmisno;opening;balance;supid;
paymentsag:payagid;payserial;deliveryon;pby;dlid;car;debtbf;loadworth;totaldue;amountpaid;balcf;cumucut;lthrough;customerid;
paymentsag2:payag2id;payserial2;deliveryon;payid;myreceipt;myreceipt2;customerid;paydetails;pby;car;carpaying;paidasid;payto;amount;trans;combine;carid;others;lthrough;pendingapprove;
paymentsag2backup:payag2id;payserial2;deliveryon;payid;myreceipt;myreceipt2;customerid;paydetails;pby;car;carpaying;paidasid;payto;amount;trans;combine;carid;others;lthrough;pendingapprove;
paymentsagbackup:payagid;payserial;deliveryon;pby;dlid;car;debtbf;loadworth;totaldue;amountpaid;balcf;cumucut;lthrough;customerid;
paymentsmade:madeid;paymentsnid;payeeid;paymentstype;supplier;year;expected;amount;balcf;bank;paidas;paidas2;voteid;paydetails;paymentfor;datep;paidby;approved;approver;mem_id;ts;
paymentsneeds:paymentsnid;payeeid;paymentstype;year;batchid;invoiceno;narration;amount;paid;bal;createdon;paidby;rid;mem_id;subcontractname;cfrom;cto;cothers;ts;
paymentstype:paytypeid;paytypename;payto;visible;
probiodatafields:prbid;prpid;prbioname;visible;
products:pid;pcode;pname;units;catid;remaining;vremaining;price;pricewas;minprice;relatesto;serial;cattype;stocktype;vat;dailymonthly;pimage;hasempties;hasserials;reorder;unitcost;scan;bduration;bothers;cothers;cqty;details;features;
productsimages:imgid;pid;pimage;
productsprices:serial;pid;unit;maxp;minp;alias;inside2;relatesto;
productspt:ptid;pid;pby;mprice;price;pdate;
productsstore:serial;pid;store;remaining;project;
producttargets:serial;pid;monthp;yearp;target;ttype;
projectmachines:machid;machinename;typeid;machinedesc;vendor;purchasedate;pby;
quicks:quickid;quickname;urlidn;a;quiorder;visible;
quicksg:quickgid;mem_id;quickid;
receivedbatches:batchid;batchsource;batchdate;batchname;invoiceno;invoice;invoice2;invat;postedby;supplier;store;finished;adjusted;carid;returnno;trip;inspectionreport;invoicedoc;
receivedinstore:rsid;serial;batchid;pid;store;quantity;used;remaining;batchdate;transfer;unit;multiplier;receivedinform;rno;archived;ts;
receivedstock:rstockid;serial;batchid;pid;hasserials;store;quantity;batchdate;invoice;unitcost;postedby;unit;multiplier;receivedinform;rno;trip;amount;archived;ts;issuetype;
receivedstockpay:payid;madeid;supplier;batch;paidas;amount;trans;batchdate;
secgrants:sgid;mem_id;secid;
sections:secid;secname;secdet;visible;
smsout:smid;org;phone;pages;message;userid;sdate;
smsunits:suid;token;units;rdate;
stockserials:ssid;pid;batchid;cound;store;serialv;dlid;transfer;
stores:store;storename;storeabbr;tradingas;dispatchers;flatfigure;pricenegotiate;defaulttax;
supplierorders:oid;supplier;narration;pby;odate;
supplierordersi:soid;serial;scan;pid;pname;quantity;qf;ucost;total;
suppliers:supid;supplier;pin;town;phone;email;initialdebt;balance;payeeid;
tasksdone:taskdoneid;taskid;taskbyid;taskbyname;taskname;taskaccomp;todays;
taskslists:taskid;taskname;visible;
temp:tempid;receiptno;orderno;pid;stock_id;productname;unitbprice;pricepunit;discount;units;multiplier;qty;vat;total;adminid;bookedon;bookedto;
times:timesid;timesname;
units:unit;units;
url:urlid;urlname;urlaname;tooltip;urltype;show;lthrough;descri;no;color;rwidth;
urlgrants:serial;mem_id;urlid;urlmodule;opt;
urlsublinks:urlid;urlmodule;sublink;subname;title;opt;show;wid;defa;tarrif;
voteheadnames:votenid;votename;voteinitials;account;compulsory;visible;affecting;amount;
