-- Table structure for table `stockmovestaxes`
--

CREATE TABLE `stockmovestaxes` (
  `stkmoveno` int(11) NOT NULL DEFAULT '0',
  `taxauthid` tinyint(4) NOT NULL DEFAULT '0',
  `taxrate` double NOT NULL DEFAULT '0',
  `taxontax` tinyint(4) NOT NULL DEFAULT '0',
  `taxcalculationorder` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`stkmoveno`,`taxauthid`),
  KEY `taxauthid` (`taxauthid`),
  KEY `calculationorder` (`taxcalculationorder`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `stockmovestaxes`
--

INSERT INTO `stockmovestaxes` VALUES (3,5,0.09,0,0),(4,5,0.09,0,0),(5,5,0.09,0,0),(6,5,0.09,0,0),(7,5,0.09,0,0),(8,5,0.09,0,0),(9,5,0.09,0,0),(10,5,0.09,0,0),(11,5,0.09,0,0),(19,5,0.09,0,0),(20,5,0.09,0,0),(21,5,0.09,0,0),(22,5,0.09,0,0),(23,5,0.09,0,0),(24,5,0.09,0,0),(25,5,0.09,0,0),(26,5,0.09,0,0),(27,5,0.09,0,0),(28,5,0.09,0,0),(29,5,0.09,0,0),(30,5,0.09,0,0),(31,5,0.09,0,0),(32,5,0.09,0,0),(33,5,0.09,0,0),(34,5,0.09,0,0),(35,5,0.09,0,0),(36,5,0.09,0,0),(37,5,0.09,0,0),(38,5,0.09,0,0),(39,5,0.09,0,0),(40,5,0.09,0,0),(41,5,0.09,0,0),(42,5,0.09,0,0),(43,5,0.09,0,0),(44,5,0.09,0,0),(45,5,0.09,0,0),(46,5,0.09,0,0),(47,5,0.09,0,0),(48,5,0.09,0,0),(49,5,0.09,0,0),(50,5,0.09,0,0),(51,5,0.09,0,0),(52,5,0.09,0,0),(53,5,0.09,0,0),(54,5,0.09,0,0),(55,5,0.09,0,0);

--
-- Table structure for table `stockrequest`
--

CREATE TABLE `stockrequest` (
  `dispatchid` int(11) NOT NULL AUTO_INCREMENT,
  `loccode` varchar(5) NOT NULL DEFAULT '',
  `departmentid` int(11) NOT NULL DEFAULT '0',
  `despatchdate` date NOT NULL,
  `jobno` tinyint(4) NOT NULL,
  `authorised` tinyint(4) NOT NULL DEFAULT '0',
  `authorized_by` varchar(100) DEFAULT NULL,
  `closed` tinyint(4) NOT NULL DEFAULT '0',
  `narrative` text NOT NULL,
  `initiator` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`dispatchid`),
  KEY `loccode` (`loccode`),
  KEY `departmentid` (`departmentid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `stockrequest`
--


--
-- Table structure for table `stockrequestitems`
--

CREATE TABLE `stockrequestitems` (
  `dispatchitemsid` int(11) NOT NULL DEFAULT '0',
  `dispatchid` int(11) NOT NULL DEFAULT '0',
  `stockid` varchar(20) NOT NULL DEFAULT '',
  `quantity` double NOT NULL DEFAULT '0',
  `qtydelivered` double NOT NULL DEFAULT '0',
  `decimalplaces` int(11) NOT NULL DEFAULT '0',
  `uom` varchar(20) NOT NULL DEFAULT '',
  `completed` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`dispatchitemsid`,`dispatchid`),
  KEY `dispatchid` (`dispatchid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `stockrequestitems`
--

INSERT INTO `stockrequestitems` VALUES (0,10,'1418',10,10,2,'each',1);

--
-- Table structure for table `stockserialitems`
--

CREATE TABLE `stockserialitems` (
  `stockid` varchar(20) NOT NULL DEFAULT '',
  `loccode` varchar(5) NOT NULL DEFAULT '',
  `serialno` varchar(30) NOT NULL DEFAULT '',
  `expirationdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `quantity` double NOT NULL DEFAULT '0',
  `qualitytext` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `stockserialitems`
--


--
-- Table structure for table `stockserialmoves`
--

CREATE TABLE `stockserialmoves` (
  `stkitmmoveno` int(11) NOT NULL AUTO_INCREMENT,
  `stockmoveno` int(11) NOT NULL DEFAULT '0',
  `stockid` varchar(20) NOT NULL DEFAULT '',
  `serialno` varchar(30) NOT NULL DEFAULT '',
  `moveqty` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`stkitmmoveno`),
  KEY `StockMoveNo` (`stockmoveno`),
  KEY `StockID_SN` (`stockid`,`serialno`),
  KEY `serialno` (`serialno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `stockserialmoves`
--


--
-- Table structure for table `stocktype`
--

CREATE TABLE `stocktype` (
  `typeabbrev` char(2) NOT NULL DEFAULT '',
  `stock_type` varchar(40) NOT NULL DEFAULT '',
  PRIMARY KEY (`typeabbrev`),
  KEY `Sales_Type` (`stock_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `stocktype`
--


--
-- Table structure for table `supervisorrostering`
--

CREATE TABLE `supervisorrostering` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `period` varchar(100) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `employeeid` int(11) NOT NULL,
  `debtorno` varchar(10) NOT NULL,
  `location` tinyint(4) NOT NULL,
  `mon_shift` varchar(100) NOT NULL,
  `mon_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `tues_shift` varchar(100) NOT NULL,
  `tues_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `wed_shift` varchar(100) NOT NULL,
  `wed_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `thurs_shift` varchar(100) NOT NULL,
  `thurs_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `fri_shift` varchar(100) NOT NULL,
  `fri_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `sat_shift` varchar(100) NOT NULL,
  `sat_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `sun_shift` varchar(100) NOT NULL,
  `sun_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `mon_shift_2` varchar(100) NOT NULL,
  `mon_hrs_2` decimal(10,1) NOT NULL,
  `total_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `normal_hours` decimal(10,1) NOT NULL,
  `time_half_hours` decimal(10,1) NOT NULL,
  `double_hours` decimal(10,1) NOT NULL,
  `status` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `employeeid_2` (`employeeid`),
  KEY `employeeid` (`employeeid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `supervisorrostering`
--

INSERT INTO `supervisorrostering` VALUES (1,'Week1','2016-08-08','2016-08-14',10931,'2,4,5',45,'',0.0,'30',9.0,'',0.0,'',0.0,'',0.0,'',0.0,'',0.0,'',0.0,9.0,8.0,1.0,0.0,'pending');

--
-- Table structure for table `supervisortimesheet`
--

CREATE TABLE `supervisortimesheet` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `period` varchar(100) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `employeeid` int(11) NOT NULL,
  `debtorno` varchar(10) NOT NULL,
  `location` tinyint(4) NOT NULL,
  `mon_shift` varchar(100) NOT NULL,
  `mon_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `tues_shift` varchar(100) NOT NULL,
  `tues_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `wed_shift` varchar(100) NOT NULL,
  `wed_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `thurs_shift` varchar(100) NOT NULL,
  `thurs_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `fri_shift` varchar(100) NOT NULL,
  `fri_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `sat_shift` varchar(100) NOT NULL,
  `sat_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `sun_shift` varchar(100) NOT NULL,
  `sun_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `mon_shift_2` varchar(100) NOT NULL,
  `mon_hrs_2` decimal(10,1) NOT NULL,
  `total_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `normal_hours` decimal(10,1) NOT NULL,
  `time_half_hours` decimal(10,1) NOT NULL,
  `double_hours` decimal(10,1) NOT NULL,
  `status` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `employeeid_2` (`employeeid`),
  KEY `employeeid` (`employeeid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `supervisortimesheet`
--

INSERT INTO `supervisortimesheet` VALUES (1,'Week1','2016-08-08','2016-08-14',10931,'2,4,5',45,'',0.0,'64',6.0,'',0.0,'',0.0,'',0.0,'64',6.0,'30',0.0,'',0.0,12.0,12.0,0.0,0.0,'pending');

--
-- Table structure for table `suppallocs`
--

CREATE TABLE `suppallocs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `amt` double NOT NULL DEFAULT '0',
  `datealloc` date NOT NULL DEFAULT '0000-00-00',
  `transid_allocfrom` int(11) NOT NULL DEFAULT '0',
  `transid_allocto` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `TransID_AllocFrom` (`transid_allocfrom`),
  KEY `TransID_AllocTo` (`transid_allocto`),
  KEY `DateAlloc` (`datealloc`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `suppallocs`
--

INSERT INTO `suppallocs` VALUES (2,202.28,'2018-02-05',2,1),(3,500,'2018-02-07',5,4);

--
-- Table structure for table `suppinvstogrn`
--

CREATE TABLE `suppinvstogrn` (
  `suppinv` int(11) NOT NULL,
  `grnno` int(11) NOT NULL,
  PRIMARY KEY (`suppinv`,`grnno`),
  KEY `suppinvstogrn_ibfk_1` (`grnno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `suppinvstogrn`
--


--
-- Table structure for table `supplier_provisional_tax_management`
--

CREATE TABLE `supplier_provisional_tax_management` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `name` varchar(100) NOT NULL,
  `invoice` varchar(100) NOT NULL,
  `invoice_amount` decimal(10,2) NOT NULL,
  `ptax` decimal(10,2) NOT NULL,
  `department` int(11) NOT NULL,
  `comment` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `supplier_provisional_tax_management`
--

INSERT INTO `supplier_provisional_tax_management` VALUES (3,'2018-02-05','107','13',212.01,9.73,1,'');

--
-- Table structure for table `suppliercontacts`
--

CREATE TABLE `suppliercontacts` (
  `supplierid` varchar(10) NOT NULL DEFAULT '',
  `contact` varchar(30) NOT NULL DEFAULT '',
  `position` varchar(30) NOT NULL DEFAULT '',
  `tel` varchar(30) NOT NULL DEFAULT '',
  `fax` varchar(30) NOT NULL DEFAULT '',
  `mobile` varchar(30) NOT NULL DEFAULT '',
  `email` varchar(55) NOT NULL DEFAULT '',
  `ordercontact` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`supplierid`,`contact`),
  KEY `Contact` (`contact`),
  KEY `SupplierID` (`supplierid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `suppliercontacts`
--


--
-- Table structure for table `supplierdiscounts`
--

CREATE TABLE `supplierdiscounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `supplierno` varchar(10) NOT NULL,
  `stockid` varchar(20) NOT NULL,
  `discountnarrative` varchar(20) NOT NULL,
  `discountpercent` double NOT NULL,
  `discountamount` double NOT NULL,
  `effectivefrom` date NOT NULL,
  `effectiveto` date NOT NULL,
  PRIMARY KEY (`id`),
  KEY `supplierno` (`supplierno`),
  KEY `effectivefrom` (`effectivefrom`),
  KEY `effectiveto` (`effectiveto`),
  KEY `stockid` (`stockid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `supplierdiscounts`
--


--
-- Table structure for table `suppliers`
--

CREATE TABLE `suppliers` (
  `supplierid` varchar(10) NOT NULL DEFAULT '',
  `suppname` varchar(1000) NOT NULL DEFAULT '',
  `address1` varchar(500) NOT NULL DEFAULT '',
  `address2` varchar(40) NOT NULL DEFAULT '',
  `address3` varchar(40) NOT NULL DEFAULT '',
  `address4` varchar(50) NOT NULL DEFAULT '',
  `address5` varchar(20) NOT NULL DEFAULT '',
  `address6` varchar(40) NOT NULL DEFAULT '',
  `supptype` tinyint(4) NOT NULL DEFAULT '1',
  `lat` float(10,6) NOT NULL DEFAULT '0.000000',
  `lng` float(10,6) NOT NULL DEFAULT '0.000000',
  `currcode` char(3) NOT NULL DEFAULT '',
  `suppliersince` date DEFAULT '0000-00-00',
  `paymentterms` char(2) NOT NULL DEFAULT '',
  `lastpaid` double NOT NULL DEFAULT '0',
  `lastpaiddate` datetime DEFAULT NULL,
  `bankact` varchar(30) NOT NULL DEFAULT '',
  `bankref` varchar(12) NOT NULL DEFAULT '',
  `bankpartics` varchar(12) NOT NULL DEFAULT '',
  `remittance` tinyint(4) NOT NULL DEFAULT '1',
  `taxgroupid` tinyint(4) NOT NULL DEFAULT '1',
  `factorcompanyid` int(11) NOT NULL DEFAULT '1',
  `taxref` varchar(20) NOT NULL DEFAULT '',
  `phn` varchar(50) NOT NULL DEFAULT '',
  `port` varchar(200) NOT NULL DEFAULT '',
  `email` varchar(55) DEFAULT NULL,
  `fax` varchar(25) DEFAULT NULL,
  `telephone` varchar(25) DEFAULT NULL,
  `url` varchar(50) NOT NULL DEFAULT '',
  `contracted` tinyint(1) NOT NULL,
  PRIMARY KEY (`supplierid`),
  KEY `CurrCode` (`currcode`),
  KEY `PaymentTerms` (`paymentterms`),
  KEY `SuppName` (`suppname`(255)),
  KEY `taxgroupid` (`taxgroupid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `suppliers`
--

INSERT INTO `suppliers` VALUES ('1','Abduls Car ','P.O.BOX  4758 ,Lautoka,Fiji','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-15272-0-2','','','abdulscars@connect.com.fj','','6721783','',0),('10','Aon Fiji','P.O.BOX 16960, Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-10809-0-9','','','georgina.lasaqa@aon.com.fj','3313373','7733374','',0),('100','Parmars Lautoka','P.O.BOX 413 , Lautoka','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-17224-0-5','','','accounts@parmarsltka.com','6662768','6661700','',0),('101','Pawans Upholstery Works','P.O.BOX 2310 Nadi','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'19-26910-0-2','','','pawansupholsteryworks@live.com','','6282946','',0),('102','Philips and Smiths Limited','P.O.BOX 69-028 , Auckland ,New Zealand','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'38-949-047','','','Cherie@pslfireandsafety.co.nz','64-98184484','64 - 98188048','',0),('103','Premier Distributors','P.O.BOX 13936,Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'09-01468-0-2','','','premier_distributors@yahoo.com','3395322','3340301','',0),('104','Print Tec','P.O.BOX 1257, Nadi','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'01-05311-0-9','','','','6726137','9911215','',0),('105','Process Vavles','P.O.BOX 4553, Lautoka','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-25836-0-1','','','','6664862','6663300','',0),('106','Professional Maids','P.O.BOX A464, RB Centerpoint , Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-54340-0-7','','','praneelvchand@gmail.com','','9235219','',0),('107','Protech Electrical and Safety Supplies','P.O.BOX 167, Nabua','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',500,'2018-02-07 00:00:00','','0','',1,1,0,'50-16061-0-3','','','accounts@protechelectrical.com.fj','3373085','3373285','',0),('108','Q Video','P.O.BOX 132, Port Melbourne','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'99-12081-13292','','','accounts@qsecuritysystems.com.au','03-9646-9086','03-9676-7000','',0),('109','R C Manubhai','P.O.BOX 9 , Ba','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-05534-0-0','','','svar@rcmanubhai.com.fj','3382655','3384300','',0),('11','Aon Inspection Services NZ','P.O.BOX 331240,Takapuna , Auckland 0740','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'65-943-328','','','lissa.mitchell@aon.com','','800266347','',0),('110','Ravinesh Nair','P.O.BOX 962, Lautoka','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'14-28985-0-1','','','','','8666116','',0),('111','Rentokil Intitial','P.O.BOX 486, Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-1112-0-6','','','ashika.rattan@rentokil-initial.com','3395720','3340000','',0),('112','Road Side Assistance','P.O.BOX 4004,Nausori','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'19-00207-0-1','','','rodesidetowing@yahoo.com','','9382692','',0),('113','S.N.P Fiji','3 Ravouvou St , Lautoka','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-55741-0-3','','','','6640441','6640440','',0),('114','Safequip','P.O.BOX 782, Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-08742-0-4','','','safequip@connect.com.fj','3304845','3315326','',0),('115','Safety Auto Electrical','P.O.BOX 12472, Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'03-19926-0-2','','','','','3581691','',0),('116','Safeway Electronics','P.O.BOX 10200 Laucala Beach','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-09175-0-9','','','safeway@connect.com.fj','3395489','3395300','',0),('117','Sengo','P.O.BOX 5016, Hamilton','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'76-467-102','','','admin@segno.co.nz','07-8466140','07-8466146','',0),('118','Shop n Save','Ba','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-14534-0-2','','','ArtikaR@shopnsave.com.fj','','3383400','',0),('119','Shopfittings','P.O.BOX 10031,Nadi Airport','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-14552-0-8','','','','6728333','6721899','',0),('12','Archer Testing Pty Ltd','Tuggerah,NSW 2219 . Australia','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'82-074-094-941','','','messaging-service@post.xero.com','','243510460','',0),('120','Sigatoka Electrical Limited','P.O.BOX 113, Sigatoka','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-04244-0-1','','','sel@connect.com.fj','6520152','6500081','',0),('121','Sonals Keyworld','P.O.BOX 1216, Nadi','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-13676-0-4','','','adm.sonals@gmail.com','','6705100','',0),('122','Sound Vision Multimedia','Labasa','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'04-06694-0-9','','','kumar801@yahoo.com','','8816473','',0),('123','South Pacific Electronics','P.O.BOX 1417, Nadi Airport','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-08866-0-1','','','vn@spe.com.fj','6720303','6720290','',0),('124','South Sea Cruises','Denarau Island','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-07286-0-0','','','lusi@ssc.com.fj','6750501','6750500','',0),('125','ST John Ambulance','G.P.O Box 70, Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'','','','','3304425','3302584','',0),('126','Superior Electronic','Lot 1 Rams Corp','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'03-54774-0-2','','','rail18@gmail.com','','9351516','',0),('127','Suva Book Shop','G.P.O BOX 17097 , Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-13069-0-2','','','suvabookshop@connect.com.fj','3301721','3311355','',0),('128','Switchboard Fabricators & Electrical Work','P.O.BOX 3830, Sambula','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'16-16725-0-6','','','','3381727','3381727','',0),('129','Tappoo Limited','P.O.BOX 46 , Sigatoka','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-061810-0-5','','','roneshp@tappoo.com.fj','6500515','6500199','',0),('13','Asco Motors','GPO BOX 355 SUVA FIJI','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-00026-0-5','','','ShelvinL@asco.com.fj','337 0309','338 4888','',0),('130','Telecom Fiji','Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-08737-0-8','','','Timaima.Bose@TFL.COM.FJ','','112233','',0),('131','The Family Medical','Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'13-19149-0-2','','','juliaroundsting@ymail.com','','3310100','',0),('132','The Green house','Factort 8 Tax Free Zone`','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-54564-0-7','','','finance@greenhouse.com.fj','','3561063','',0),('133','The Print & Design Shop','P.O.BOX 1436, Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-17530-0-3','','','design@printndesign.com.fj','','3343588','',0),('134','Total (Fiji) Limited','GPO BOX 168, Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-05174-0-2','','','anne.madigibuli@total.com','3313184','3313933','',0),('135','Tourist Garments','P.O.BOX 557, Lautoka','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-073040-3','','','','6661142','6660620','',0),('136','Tower Insurance','P.O.BOX 950, Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'40-00093-0-0','','','','3301376','3315955','',0),('137','Trade Hut','P.OBOX 11193, Nadi Airport','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-53152-0-7','','','','','9997676','',0),('138','Trade Supplies Limited','P.O.BOX 3817, Sambula','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-09343-0-6','','','accounts@tradesupplies.com','3308730','3301644','',0),('139','Tyco Australia','Locked Bag 45, Mount Waverly , Aus','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'80-008-399-004','','','','','','',0),('14','Ashabhai & Co','G.P.O .BOX 908 ,Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-04603-0-6','','','mark@ashbhai.com.fj','3370093','3387399','',0),('140','Tyco Logistics & Distribution','8 Henderson, Auckland','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'52-147-476','','','nipowell@tycoint.com','03-8272288','09-6350760','',0),('141','Tyre Pro Retread Co. Ltd','lot 23 Lalita Bhindi Street Vatuwaqa','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-13597-0-6','','','tyrepro@connect.com.fj','','3380536','',0),('142','UB Freight','P.O.BOX 10154, Nadi Airport','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-14579-0-1','','','shobnas@ubfreight.com','6726498','6724587','',0),('143','Ullrich Exports Limited','P.O.BOX 98843, Manukau, New Zealand','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'','','','','','','',0),('144','Universal Electronic','P.O.BOX 175 , Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-14892-0-1','','','accounts@dsefiji.com','3302878','3312808','',0),('145','Universal Printing Press','P.O.BOX 125, Lautoka','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-03873-0-8','','','joshika.devi@punjas.com','6662955','6662588','',0),('146','Valve & Fittings Supplies','P.O.BOX 3000 Lautoka','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'30-61174-0-0','','','valvesfittingssuppliesfijiltd@gmail.com','','8951021','',0),('147','Viking Sales and Services','P.O.BOX 30737,Lower Hutt','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'58-678-597','','','lucia@vikingnz.co.nz','64-45890413','64-45890856','',0),('148','Vinit Energy','P.O.BOX 4572, Sambula','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'19-47090-0-0','','','energyrefer50@gmail.com','','7480957/8379498','',0),('149','Vinod Patel','P.O.BOX 14416,Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-04527-0-7','','','ho.credit@vinodpatel.com.fj','3340255','3393111','',0),('15','Atlas Gentech Distribution Ltd','Private Bag 14927 , Panmure, Auckland NZ','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'60-981-310','','','SonyaS@atlasgentech.co.nz','09-5735055','09- 5742700','',0),('150','Water Authority of Fiji','GPO.BOX 1272,Nasinu','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'','','','contact@waf.com.fj','','','',0),('151','West Power Electrical & Industrial Supplies','P.O.BOX 8034, Nakasi','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'12-16869-0-1','','','atish.westpower@gmail.com','','3411360','',0),('152','Western Fire Protection','P.O.BOX 1014, Lautoka','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-135035-0-9','','','wsfpsl@connect.com.fj','6664646','6662639','',0),('153','Wholesale Warehouse (Fiji) Ltd','P.O.BOX 11193, Nadi Airport','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-16651-0-0','','','wwfl@connect.com.fj','6725850','6725800','',0),('154','test','test','','','','','Fiji',1,0.000000,0.000000,'FJD','2018-02-07','20',0,NULL,'','0','',0,1,0,'','','','','','','',0),('155','Tropic Towers Ltd','88 Robertson Road','','','','','Fiji',1,0.000000,0.000000,'FJD','2018-02-07','20',0,NULL,'','0','',0,1,0,'50-0145-07','','','','','','',0),('16','Babasiga Auto Electrical','Nasekula, Labasa','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'','','','','','','',0),('17','Biz Clothing Limited','P.O.BOX 19 .Nadi','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-16256-0-3','','','AccountsWest@biz.com.fj','','3275130','',0),('18','Car City T/A Creative Holdings','P.O.BOX 1105,Nadi','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-56060-0-2','','','debtors@kia.com.fj','','6701023','',0),('19','Carpenters Motors','Private Mail Bag , Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-00034-0-0','','','b.nath.motors@carpenters.com.fj','3305715','3313644','',0),('2','Ace Medical Clinic','P.O.BOX MT.29 Martintar, Nadi','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'07-07272-0-3','','','acemedical2@gmail.com','6727532','6727530','',0),('20','Carpenters Shipping','Private Mail Bag , Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-00034-0-0','','','credit.shipping@carpenters.com.fj','3301572','3312244','',0),('21','CEM Systems','Manchester ,M40 2WL','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'','','','tycosecurityfinance@tycoint.com','','44-0- 1612594890','',0),('22','Central Fire Design Ltd','East Tamaki, Auckland , NZ','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'094-481-384','','','karen@centralfiredesign.co.nz','','92732424','',0),('23','Challenge Engineering','P.O.BOX 1260, Lautoka','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-09778-0-6','','','accounts@challengefiji.com','','9993666','',0),('24','Chands Towing','Nadi Bk Rd','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'','','','','','6724785','',0),('25','Chester Consultants','P.O.BOX NMK 169, Namaka','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-53081-0-4','','','admin@chester.com.fj','','4005100/8300918','',0),('26','Colin Carr Agencies Ltd','P.O.BOX 6852, Wellingtion ,NZ','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'','','','ccagnys@xtra.co.nz','64-4-3829370','64-4-3829368','',0),('27','Color Market Ltd','P.O.BOX 3688 177, Sambula','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-07072-0-5','','','accounts@colormarketfiji.com','3370495','3384644','',0),('28','Comtech Communications Ltd','G.P.O.BOX 139 ,Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-13463-0-8','','','accounts@comtechfiji.com','3309232','3309205','',0),('29','Connect','Suva Fiji','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-08737-0-8','','','billing@connect.com.fj','','112777','',0),('3','Advantage Aluminium','Lot 7 Jai Ammba Rd, Vatuwaqa','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-16901-0-4','','','accounts@3sacarpet.com.fj','3373626','3373623','',0),('30','Courts','P.O.BOX 3726, Sambula','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-01532-0-0','','','enquiries@courts.com.fj','3370483','3381333','',0),('31','Crusader Hose Pty Ltd','Australia','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'','','','sales@crusaderhose.com.au','+61 3 9720 5756','+61 3 9720 1100','',0),('32','Dai- ichi (West) Company','P.O.BOX 1263,Lautoka','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-10416-0-9','','','bobdaiichi@gmail.com','6664800','6664455','',0),('33','Deluxe Footwear','Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-13682-0-3','','','','3314801','3311624','',0),('34','Deoji & Sons Ltd','P.O.BOX 67 , Lautoka','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-05945-0-6','','','deoji@kidanet.com.fj','6661022','6660282','',0),('35','Devia Bookshop','Nadi Town','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-14511-0-1','','','sales@deviafiji.com','6703311','6702075','',0),('36','DHL Express (Fiji) Ltd','P.O.BOX 13036, Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-03936-0-6','','','donald.singh@dhl.com','','3372766','',0),('37','DHL Global','P.O.BOX 10157 , Nadi Airport','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-09397-0-3','','','AshikaLata.Ram@dhl.com','6720484','6720538','',0),('38','Dive Centre (Fiji)','P.O.BOX 3066, Lami','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-07336-0-2','','','divecentre@unwired.com.fj','3302639','3300599','',0),('39','Dominion Wire and Cables','P.O.BOX 1562, Ba','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-05047-0-5','','','sales@dominioncables.com','6670023','6675244','',0),('4','Airports Fiji Limited','Private Mail Bag,     Nadi Airport,                         Fiji Islands','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-12567-0-2','','','riyazm@afl.com.fj','672 5161','672 5777','',0),('40','Dulux Trade Centre','P.O.BOX 1260, Lautoka','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-08704-06','','','automartdtc@connect.com.fj','','6650001','',0),('41','Dynamic Switchboard','P.O.BOX 3012, Lami','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-16740-0-6','','','','3240027','3605164','',0),('43','E-BUSINESS','89 Robertson Rd, Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','7',0,NULL,'','0','',1,1,0,'19-38582-0-8','','','sachin@ebusinessfiji.com','3311664','3311663','',0),('44','Entec Limited','P.O.BOX 12309, Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-12715-0-7','','','info@entecfiji.com','3318618','3300300','',0),('45','Execellent Garment','Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'03-33610-0-4','','','','','','',0),('46','Faiyaz Ali Services','Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'01-11232-0-0','','','afaiyazrk@gmail.com','','9247841','',0),('47','Fiji Airways','Private Mail bag, Nadi Airport , Nadi','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'T.I.N 50-00123-0-9','','','farina.nisha@fijiairways.com','672 0707','672 0777','',0),('48','Fiji Electricity Authority','Suva Fiji','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-12291-0-8','','','','','132333','',0),('49','Fiji Gas Ltd','G.P.O.BOX 548','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-00365-0-5','','','','3302546','3304188','',0),('5','Ajax Fasteners','G.P.O. Box 1334,Suva, Fiji Islands','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-13431-0-9','','','admin@ajaxfasteners.com.fj','3302078','3315122','',0),('50','Fiji Rubber Stamp','G.P.O BOX 341, Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'19-08876-0-9','','','','3300252','3300272','',0),('51','Fiji Sun T/A Sun (Fiji) News Limited','Private Mail Bag, Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-12771-0-1','','','atisht@fijisun.com.fj','3311455','3307555','',0),('52','Fiji Times','G.P.O BOX 1167, Suva,','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-07042-0-2','','','finance@fijitimes.com.fj','3305935','3304111','',0),('53','Flametree Development','P.O.BOX 10929 Nadi Airport','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-15671-0-1','','','','6750997','6750995','',0),('54','Gallagher','New Zealand','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'24-824-357','','','Susan.Forsyth@gallagher.com','+64 7 838 9801 ','02 9439 8599','',0),('55','Getrix Limited','P.O.BOX 065 Garden City','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-56347-0-0','','','getrix.limited@gmail.com','3370111','3371101','',0),('56','Grand Melanesian Hotel','P.O.BOX 10410 , Nadi Airport','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-17197-0-8','','','agentmelhotl@gmail.com','6720425','6722438','',0),('57','Habitat Designs','Fiji','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-16567-0-6','','','ravi@habitatdesigns.com.fj','','6664508','',0),('58','Howards Fiji','G.P.O BOX 13687, Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'03-14860-0-0','','','accts@howardslaw.com.fj','33000180','3300046','',0),('59','Hydraulic Hose','P.O.BOX 5220 Lautoka','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-11891-0-5','','','receivables@hydhosefiji.com.fj','6650877','6662666','',0),('6','Ajynk Electrical T/A Top Energy','P.O.BOX 4288, Lautoka','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-84652-0-2','','','moreen.kiran@ajynkgroup.com','6664732','6661179','',0),('60','Jacks Engineering and Mechanical','P.O.BOX 604, Labasa','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-09353-0-7','','','jacks.motor@yahoo.com','','9265915','',0),('61','Jacks Motor Traders','Price Andrew Road, Buleka Labasa','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-9353-0-07','','','jacks.motor@yahoo.com','8811767','8812199','',0),('62','Janty Bondwell','G.P.O .BOX 565, Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-17839-0-9','','','admin@bondwell.com.fj','3382713','3385549','',0),('63','Janty Kanvan Limited','P.O.BOX 1430, Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-12148-0-1','','','info@kanvan.com.fj','3387383','3381300','',0),('64','Jedis Stationery','P.O.BOX 4251, Sambula','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-52316-0-0','','','jedist@connect.com.fj','3315360','3301276','',0),('65','Jobco Services Fiji','P.O.BOX 1785, Nabua','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'15-01049-0-0','','','jobcofj@gmail.com','3370111','9425837/337166','',0),('66','Kasabias','P.O.BOX 167, Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-01387-0-4','','','','','3315622','',0),('67','Kimono Sales','P.O.BOX 628, Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-13310-0-1','','','kimono@connect.com.fj','3396139','3340521','',0),('68','Kings Neon Sign','P.O.BOX 2292, Nadi','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-11180-0-0','','','finance.kns@gmail.com','6725698','6725669','',0),('69','Kiwi Pipes and Fittings','P.O.BOX 202158, Auckland , NZ','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'119-306-106','','','cfussell@kiwipipeandfittings.co.nz','','5735926','',0),('7','All Crash Repairs','P.O.BOX 3654 Sambula','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-16792-0-0','','','allcrashrepairsltd@gmail.com','','3364049','',0),('70','Kooline','P.O.BOX 2433 Govt Bulidng , Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-04478-0-2','','','accounts@kooline.com.fj','3303343','3313277','',0),('71','L.B. Masters','G.P.O.BOX 14423,Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'12-007415-0-0','','','engravers@connect.com.fj','3302302','3313545','',0),('72','Laminating Wholesalers','G.P.O BOX 11-767 Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-11344-0-04','','','Imxpt@xtra.co.nz','3319979','3319989','',0),('73','Lan cabling','5 Holland st Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-15583-0-5','','','','','3384778','',0),('74','Leeward Island Services Ltd','P.O.BOX 9777, Nadi Airport','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-03698-0-9','','','accounts9@leewardisl.com','6750812','6750205','',0),('75','Longrun Fiji','P.O.BOX 4643, Lautoka','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-09183-0-4','','','','6661154','6661133','',0),('76','Lotus Garments','GPO BOX 16125, Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-13745-0-1','','','laladinesh@hotmail.com','3313483','3313797','',0),('77','M Recht Accessories','P O BOX 1616,  Nadi','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-16750-0-0','','','accounts@mrecht.com.fj','6725854','6725965','',0),('78','Mahijibhai','P O BOX 417 , Nadi','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-07329-0-0','','','accounts@mahijibhai.com.fj','6724508','6724160','',0),('79','Mechanical Services Limited','P.O.BOX Gvt Bulding , Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-05159-0-5','','','mechanical@connect.com.fj','3300451','3314933','',0),('8','All Engineering','P.O.BOX 1546,Lautoka','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-13643-0-2','','','pradeep.kumar@allengineering.com.fj','6652696','6645745','',0),('80','Mercure Hotel','P O BOX 11133 , Nadi Airport','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-14966-0-3','','','reservations@mecurenadi.com.fj','6720187','6722255','',0),('81','Morris Hedstrom','GPO BOX 295, Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-00034-0-0','','','a.wong.mh@carpenters.com.fj','3301216','3315299','',0),('82','Motiram & Co','P.O.BOX 202 , Nadi','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-17355-0-4','','','jayshree@motiram.com','6702247','6701093','',0),('83','Naivilakalaka Pte Limited  - Setareki','','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-55178-0-9','','','sranavue@yahoo.com','','8392349/7131092','',0),('84','Narhari Electrical Co','GPO BOX 1199 , Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-07419-0-2','','','info@narharifiji.com','330791','3304155','',0),('85','Nasinu Metal Works','P.OBOX 7907, Nasinu','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'04-21370-0-7','','','','','9725550','',0),('86','Neritak Equipment Ltd','P O BOX 3856, Sambula','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-13920-0-0','','','sales@neritak.com.fj','3310343','3310344','',0),('87','Nivis Motors','G.P.O BOX 156, Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-05699-0-4','','','accounts3@nivismotors.com','3380722','3383411','',0),('88','No Way Out','P.O.BOX 6528, Valelevu , Nasinu','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-53894-0-8','','','','','9954193','',0),('89','Novotel Nadi','P.O.BOX 11133, Nadi Airport','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-15642-0-1','','','ar@novotelnadi.com.fj','6720234','6722000','',0),('9','Angies Catering','14 Transville Rd, Namaka','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'13-27399-0-4','','','angiescatering@gmail.com','','9047590/9433306','',0),('90','Novotel Suva','Queens Road, Lami','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-14942-0-9','','','accounts@novotelsuva.com.fj','3364255','3362450','',0),('91','Oceania Gas - Boc','G.P.O.BOX 687, Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-008460-0-1','','','avinesh.prakash@oceaniagas.com','3361378','3361011','',0),('92','Office 2000+ Limited','GPO BOX 17752 , Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-08796-0-1','','','office2000@connect.com.fj','3303150','3312108','',0),('93','Office Mart','P O BOX 2630 Govt Bulding , Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-16115-0-3','','','officemart@connect.com.fj','3319796','3319798','',0),('94','Office Mate','P.O.BOX 2370, Labasa','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-84994-0-1','','','ofcemate@connect.com.fj','8818687','8818686','',0),('95','On the Go Limited','P.O.BOX 46 , Sigatoka','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-55763-0-1','','','credit.otg@onthego.com.fj','3385106','3384081','',0),('96','One Stop Paint Shop','P.O.BOX 1406,Nadi','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-53083-0-0','','','onestoppaintshopltd@gmail.com','6728896','6726466','',0),('97','Ontime Electronic','65, Moala ,Sambula','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-25643-0-7','','','ontimeelectronics@connect.com.fj','','9921929','',0),('98','Pacific Energy (SWP) Fiji','P.O.BOX 118. Suva','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'50-00138-0-5','','','lorraine.penjueli@p.energy','3300933','3311622','',0),('99','Pacific Tourist Store','P.O.BOX 171, Nadi','','','','','',1,0.000000,0.000000,'FJD','2016-01-01','20',0,NULL,'','0','',1,1,0,'04-01599-0-6','','','ptsnadi@gmail.com','6702421','6700085','',0);

--
-- Table structure for table `suppliertype`
--

CREATE TABLE `suppliertype` (
  `typeid` tinyint(4) NOT NULL AUTO_INCREMENT,
  `typename` varchar(100) NOT NULL,
  PRIMARY KEY (`typeid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `suppliertype`
--

INSERT INTO `suppliertype` VALUES (1,'General');

--
-- Table structure for table `supplieruploads`
--

CREATE TABLE `supplieruploads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `supp_id` int(11) NOT NULL,
  `file` blob NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `supplieruploads`
--

INSERT INTO `supplieruploads` VALUES (1,107,'78950.jpg');

--
-- Table structure for table `supptrans`
--

CREATE TABLE `supptrans` (
  `transno` int(11) NOT NULL DEFAULT '0',
  `type` smallint(6) NOT NULL DEFAULT '0',
  `supplierno` varchar(10) NOT NULL DEFAULT '',
  `suppreference` varchar(20) NOT NULL DEFAULT '',
  `trandate` date NOT NULL DEFAULT '0000-00-00',
  `duedate` date NOT NULL DEFAULT '0000-00-00',
  `inputdate` datetime NOT NULL,
  `prd` int(11) NOT NULL,
  `settled` tinyint(4) NOT NULL DEFAULT '0',
  `rate` double NOT NULL DEFAULT '1',
  `ovamount` double NOT NULL DEFAULT '0',
  `ovgst` double NOT NULL DEFAULT '0',
  `diffonexch` double NOT NULL DEFAULT '0',
  `alloc` double NOT NULL DEFAULT '0',
  `ptax` decimal(10,2) DEFAULT NULL,
  `entered_by` varchar(100) NOT NULL,
  `transtext` text,
  `hold` tinyint(4) NOT NULL DEFAULT '0',
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`),
  UNIQUE KEY `TypeTransNo` (`transno`,`type`),
  KEY `DueDate` (`duedate`),
  KEY `Hold` (`hold`),
  KEY `SupplierNo` (`supplierno`),
  KEY `Settled` (`settled`),
  KEY `SupplierNo_2` (`supplierno`,`suppreference`),
  KEY `SuppReference` (`suppreference`),
  KEY `TranDate` (`trandate`),
  KEY `TransNo` (`transno`),
  KEY `Type` (`type`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `supptrans`
--

INSERT INTO `supptrans` VALUES (13,20,'107','3333','2018-02-04','2018-03-22','2018-02-05 00:00:00',0,0,1,194.5,17.505,0,202.28,9.73,'','',0,1),(3,22,'107','Cheque','2018-02-05','0000-00-00','2018-02-05 12:43:03',0,1,1,-202.28,0,0,-202.28,NULL,'','',0,2),(14,20,'107','78950','2018-02-06','2018-03-22','2018-02-07 00:00:00',0,0,1,2068.29,186.1461,0,500,NULL,'','',0,4),(4,22,'107','Cheque','2018-02-07','0000-00-00','2018-02-07 15:55:27',0,1,1,-500,0,0,-500,NULL,'','',0,5),(15,20,'107','799999','2018-02-07','2018-03-22','2018-02-08 00:00:00',0,0,1,1468.29,132.1461,0,0,NULL,'','',0,6),(16,20,'107','88888','2018-02-07','2018-03-22','2018-02-08 00:00:00',0,0,1,1468.29,132.1461,0,0,NULL,'','',0,7),(17,20,'107','44444','2018-02-07','2018-03-22','2018-02-08 00:00:00',0,0,1,1468.29,132.1461,0,0,NULL,'','',0,8),(18,20,'107','1234','2018-05-02','2018-06-22','2018-05-03 00:00:00',0,0,1,40,3.6,0,0,NULL,'','',0,9);

--
-- Table structure for table `supptranstaxes`
--

CREATE TABLE `supptranstaxes` (
  `supptransid` int(11) NOT NULL DEFAULT '0',
  `taxauthid` tinyint(4) NOT NULL DEFAULT '0',
  `taxamount` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`supptransid`,`taxauthid`),
  KEY `taxauthid` (`taxauthid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `supptranstaxes`
--

INSERT INTO `supptranstaxes` VALUES (1,5,17.505),(4,5,186.1461),(6,5,132.1461),(7,5,132.1461),(8,5,132.1461),(9,5,3.6);

--
-- Table structure for table `systypes`
--

CREATE TABLE `systypes` (
  `typeid` smallint(6) NOT NULL DEFAULT '0',
  `typename` char(50) NOT NULL DEFAULT '',
  `typeno` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`typeid`),
  KEY `TypeNo` (`typeno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `systypes`
--

INSERT INTO `systypes` VALUES (0,'Journal - GL',0),(1,'Payment - GL',0),(2,'Receipt - GL',0),(3,'Standing Journal',0),(10,'Sales Invoice',0),(11,'Credit Note',0),(12,'Receipt',0),(14,'Job Quotation',0),(15,'Journal - Debtors',0),(16,'Location Transfer',10),(17,'Stock Adjustment',929),(18,'Purchase Order',0),(19,'Picking List',0),(20,'Purchase Invoice',0),(21,'Debit Note',0),(22,'Creditors Payment',0),(23,'Creditors Journal',0),(25,'Purchase Order Delivery',0),(26,'Work Order Receipt',0),(28,'Work Order Issue',0),(29,'Work Order Variance',0),(30,'Sales Order',0),(31,'Shipment Close',0),(32,'Contract Close',0),(35,'Cost Update',0),(36,'Exchange Difference',0),(37,'Tenders',0),(38,'Stock Requests',10),(40,'Work Order',1),(41,'Asset Addition',0),(42,'Asset Category Change',0),(43,'Delete w/down asset',0),(44,'Depreciation',0),(49,'Import Fixed Assets',0),(50,'Opening Balance',0),(51,'LPR',0),(52,'PTax',7),(53,'Retention',0),(97,'POS Trans',0),(99,'Stock Transfer Projects',7),(500,'Auto Debtor Number',77000),(600,'Auto Supplier Number',155);

--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `tagref` tinyint(4) NOT NULL AUTO_INCREMENT,
  `tagdescription` varchar(50) NOT NULL,
  PRIMARY KEY (`tagref`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tags`
--

INSERT INTO `tags` VALUES (19,'FS 058'),(20,'IB 324'),(21,'IB 325'),(22,'IC 675'),(23,'IA 155'),(24,'HZ 318'),(25,'HZ 319'),(26,'HZ 320'),(27,'FU 808'),(28,'FU 809'),(29,'IF 230'),(30,'FQ 781'),(31,'FW 579'),(32,'HQ 219'),(33,'IN 442'),(34,'IN 443'),(35,'HD 353'),(36,'IC 676'),(37,'IC 679'),(38,'IC 680'),(39,'HE 782'),(40,'HZ 361'),(41,'FU 878'),(42,'FW 053'),(43,'II861'),(44,'IJ 855'),(45,'HJ 668'),(46,'FG 712'),(47,'FX 501'),(48,'HA 355');

--
-- Table structure for table `taxauthorities`
--

CREATE TABLE `taxauthorities` (
  `taxid` tinyint(4) NOT NULL AUTO_INCREMENT,
  `description` varchar(20) NOT NULL DEFAULT '',
  `taxglcode` varchar(20) NOT NULL DEFAULT '0',
  `purchtaxglaccount` varchar(20) NOT NULL DEFAULT '0',
  `bank` varchar(50) NOT NULL DEFAULT '',
  `bankacctype` varchar(20) NOT NULL DEFAULT '',
  `bankacc` varchar(50) NOT NULL DEFAULT '',
  `bankswift` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`taxid`),
  KEY `TaxGLCode` (`taxglcode`),
  KEY `PurchTaxGLAccount` (`purchtaxglaccount`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `taxauthorities`
--

INSERT INTO `taxauthorities` VALUES (5,'VAT','2200025','2200023','','','','');

--
-- Table structure for table `taxauthrates`
--

CREATE TABLE `taxauthrates` (
  `taxauthority` tinyint(4) NOT NULL DEFAULT '1',
  `dispatchtaxprovince` tinyint(4) NOT NULL DEFAULT '1',
  `taxcatid` tinyint(4) NOT NULL DEFAULT '0',
  `taxrate` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`taxauthority`,`dispatchtaxprovince`,`taxcatid`),
  KEY `TaxAuthority` (`taxauthority`),
  KEY `dispatchtaxprovince` (`dispatchtaxprovince`),
  KEY `taxcatid` (`taxcatid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `taxauthrates`
--

INSERT INTO `taxauthrates` VALUES (5,1,1,0.09),(5,1,5,0),(5,1,6,0),(5,1,7,0),(5,1,8,0);

--
-- Table structure for table `taxcategories`
--

CREATE TABLE `taxcategories` (
  `taxcatid` tinyint(4) NOT NULL AUTO_INCREMENT,
  `taxcatname` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`taxcatid`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `taxcategories`
--

INSERT INTO `taxcategories` VALUES (1,'VAT'),(5,'Freight'),(6,'Contracted Supply'),(7,'NON VAT'),(8,'ECAL');

--
-- Table structure for table `taxgroups`
--

CREATE TABLE `taxgroups` (
  `taxgroupid` tinyint(4) NOT NULL AUTO_INCREMENT,
  `taxgroupdescription` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`taxgroupid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `taxgroups`
--

INSERT INTO `taxgroups` VALUES (1,'FRCA');

--
-- Table structure for table `taxgrouptaxes`
--

CREATE TABLE `taxgrouptaxes` (
  `taxgroupid` tinyint(4) NOT NULL DEFAULT '0',
  `taxauthid` tinyint(4) NOT NULL DEFAULT '0',
  `calculationorder` tinyint(4) NOT NULL DEFAULT '0',
  `taxontax` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`taxgroupid`,`taxauthid`),
  KEY `taxgroupid` (`taxgroupid`),
  KEY `taxauthid` (`taxauthid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `taxgrouptaxes`
--

INSERT INTO `taxgrouptaxes` VALUES (1,5,0,0);

--
-- Table structure for table `taxprovinces`
--

CREATE TABLE `taxprovinces` (
  `taxprovinceid` tinyint(4) NOT NULL AUTO_INCREMENT,
  `taxprovincename` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`taxprovinceid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `taxprovinces`
--

INSERT INTO `taxprovinces` VALUES (1,'Default Tax province');

--
-- Table structure for table `taxrates`
--

CREATE TABLE `taxrates` (
  `taxid` tinyint(4) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `rate` decimal(10,2) NOT NULL,
  PRIMARY KEY (`taxid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `taxrates`
--

INSERT INTO `taxrates` VALUES (1,'VAT',9.00),(2,'Contract Provisional Tax',5.00),(3,'Income Tax',20.00);

--
-- Table structure for table `techniciantimesheet`
--

CREATE TABLE `techniciantimesheet` (
  `techtimeid` int(11) NOT NULL AUTO_INCREMENT,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `job_no` tinyint(4) NOT NULL,
  `client` varchar(100) NOT NULL,
  `account_number` int(11) NOT NULL,
  `department` varchar(100) NOT NULL,
  `job_type` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `last_modifiedby` varchar(100) NOT NULL,
  `lastupdate` datetime NOT NULL,
  PRIMARY KEY (`techtimeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `techniciantimesheet`
--


--
-- Table structure for table `techniciantimesheetdetails`
--

CREATE TABLE `techniciantimesheetdetails` (
  `techtimedetailid` int(11) NOT NULL AUTO_INCREMENT,
  `techtimeid` int(11) NOT NULL,
  `employeeid` int(11) NOT NULL,
  `mon_date` date NOT NULL,
  `montime_in` time DEFAULT NULL,
  `montime_out` time DEFAULT NULL,
  `mon_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `montime_in1` time DEFAULT NULL,
  `montime_out1` time DEFAULT NULL,
  `mon_hrs2` decimal(10,1) NOT NULL,
  `mon_total` decimal(10,1) NOT NULL,
  `tues_date` date NOT NULL,
  `tuestime_in` time DEFAULT NULL,
  `tuestime_out` time DEFAULT NULL,
  `tues_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `tuestime_in1` time DEFAULT NULL,
  `tuestime_out1` time DEFAULT NULL,
  `tues_hrs2` decimal(10,1) NOT NULL,
  `tues_total` decimal(10,1) NOT NULL,
  `wed_date` date NOT NULL,
  `wedtime_in` time DEFAULT NULL,
  `wedtime_out` time DEFAULT NULL,
  `wed_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `wedtime_in1` time DEFAULT NULL,
  `wedtime_out1` time DEFAULT NULL,
  `wed_hrs2` decimal(10,1) NOT NULL,
  `wed_total` decimal(10,1) NOT NULL,
  `thurs_date` date NOT NULL,
  `thurstime_in` time DEFAULT NULL,
  `thurstime_out` time DEFAULT NULL,
  `thurs_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `thurstime_in1` time DEFAULT NULL,
  `thurstime_out1` time DEFAULT NULL,
  `thurs_hrs2` decimal(10,1) NOT NULL,
  `thurs_total` decimal(10,1) NOT NULL,
  `fri_date` date NOT NULL,
  `fritime_in` time DEFAULT NULL,
  `fritime_out` time DEFAULT NULL,
  `fri_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `fritime_in1` time DEFAULT NULL,
  `fritime_out1` time DEFAULT NULL,
  `fri_hrs2` decimal(10,1) NOT NULL,
  `fri_total` decimal(10,1) NOT NULL,
  `sat_date` date NOT NULL,
  `sattime_in` time DEFAULT NULL,
  `sattime_out` time DEFAULT NULL,
  `sat_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `sattime_in1` time DEFAULT NULL,
  `sattime_out2` time DEFAULT NULL,
  `sat_hrs2` decimal(10,1) NOT NULL DEFAULT '0.0',
  `sat_total` decimal(10,1) NOT NULL,
  `sun_date` date NOT NULL,
  `sunttime_in` time DEFAULT NULL,
  `sunttime_out` time DEFAULT NULL,
  `sun_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `suntime_in1` time DEFAULT NULL,
  `suntime_out1` time DEFAULT NULL,
  `sun_hrs2` decimal(10,1) NOT NULL,
  `sun_total` decimal(10,2) NOT NULL,
  `mon2_date` date NOT NULL,
  `mon2time_in` time DEFAULT NULL,
  `mon2time_out` time DEFAULT NULL,
  `mon2_total` decimal(10,1) NOT NULL,
  `total_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `normal_hours` decimal(10,2) NOT NULL,
  `time_half_hours` decimal(10,2) NOT NULL,
  `double_hours` decimal(10,2) NOT NULL,
  PRIMARY KEY (`techtimedetailid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `techniciantimesheetdetails`
--

INSERT INTO `techniciantimesheetdetails` VALUES (1,73,5513,'1969-12-31','04:00:00','23:00:00',19.0,NULL,NULL,0.0,19.0,'1970-01-01',NULL,NULL,0.0,NULL,NULL,0.0,0.0,'1970-01-02',NULL,NULL,0.0,NULL,NULL,0.0,0.0,'1970-01-03',NULL,NULL,0.0,NULL,NULL,0.0,0.0,'1970-01-04',NULL,NULL,0.0,NULL,NULL,0.0,0.0,'1970-01-05',NULL,NULL,0.0,NULL,NULL,0.0,0.0,'1970-01-06',NULL,NULL,0.0,NULL,NULL,0.0,0.00,'1970-01-07',NULL,NULL,0.0,19.0,8.00,4.00,7.00),(2,80,5528,'1969-12-31','01:00:00','08:00:00',7.0,NULL,NULL,0.0,7.0,'1970-01-01',NULL,NULL,0.0,NULL,NULL,0.0,0.0,'1970-01-02',NULL,NULL,0.0,NULL,NULL,0.0,0.0,'1970-01-03',NULL,NULL,0.0,NULL,NULL,0.0,0.0,'1970-01-04',NULL,NULL,0.0,NULL,NULL,0.0,0.0,'1970-01-05',NULL,NULL,0.0,NULL,NULL,0.0,0.0,'1970-01-06',NULL,NULL,0.0,NULL,NULL,0.0,0.00,'1970-01-07',NULL,NULL,0.0,7.0,7.00,0.00,0.00),(3,1,4048,'1969-12-31','08:00:00','23:00:00',15.0,NULL,NULL,0.0,15.0,'1970-01-01',NULL,NULL,0.0,NULL,NULL,0.0,0.0,'1970-01-02',NULL,NULL,0.0,NULL,NULL,0.0,0.0,'1970-01-03',NULL,NULL,0.0,NULL,NULL,0.0,0.0,'1970-01-04',NULL,NULL,0.0,NULL,NULL,0.0,0.0,'1970-01-05',NULL,NULL,0.0,NULL,NULL,0.0,0.0,'1970-01-06',NULL,NULL,0.0,NULL,NULL,0.0,0.00,'1970-01-07',NULL,NULL,0.0,15.0,9.00,4.00,2.00),(4,13,5697,'1970-01-01','08:00:00','17:00:00',9.0,NULL,NULL,0.0,9.0,'1970-01-02',NULL,NULL,0.0,NULL,NULL,0.0,0.0,'1970-01-03','08:00:00','22:00:00',14.0,NULL,NULL,0.0,14.0,'1970-01-04',NULL,NULL,0.0,NULL,NULL,0.0,0.0,'1970-01-05',NULL,NULL,0.0,NULL,NULL,0.0,0.0,'1970-01-06',NULL,NULL,0.0,NULL,NULL,0.0,0.0,'1970-01-07',NULL,NULL,0.0,NULL,NULL,0.0,0.00,'1970-01-08',NULL,NULL,0.0,23.0,16.00,5.00,2.00);

--
-- Table structure for table `tenderitems`
--

CREATE TABLE `tenderitems` (
  `tenderid` int(11) NOT NULL DEFAULT '0',
  `stockid` varchar(20) NOT NULL DEFAULT '',
  `quantity` varchar(40) NOT NULL DEFAULT '',
  `units` varchar(20) NOT NULL DEFAULT 'each',
  PRIMARY KEY (`tenderid`,`stockid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tenderitems`
--

INSERT INTO `tenderitems` VALUES (1,'gt0054','50','each');

--
-- Table structure for table `tendersuppliers`
--

CREATE TABLE `tendersuppliers` (
  `tenderid` int(11) NOT NULL DEFAULT '0',
  `supplierid` varchar(10) NOT NULL DEFAULT '',
  `email` varchar(40) NOT NULL DEFAULT '',
  `responded` int(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tenderid`,`supplierid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tendersuppliers`
--

INSERT INTO `tendersuppliers` VALUES (1,'EBUZ','sachin@ebusinessfiji.com',0);

--
-- Table structure for table `timesheet`
--

CREATE TABLE `timesheet` (
  `timesheetid` int(11) NOT NULL AUTO_INCREMENT,
  `period` varchar(100) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `client` varchar(100) NOT NULL,
  `patrol_location` varchar(100) NOT NULL,
  `premium_rate` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `last_modified_by` varchar(100) NOT NULL,
  PRIMARY KEY (`timesheetid`),
  KEY `client` (`client`),
  KEY `patrol_location` (`patrol_location`),
  KEY `client_2` (`client`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `timesheet`
--


--
-- Table structure for table `timesheetdetails`
--

CREATE TABLE `timesheetdetails` (
  `id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `period` varchar(100) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `client` tinyint(4) NOT NULL,
  `patrol_location` tinyint(4) NOT NULL,
  `department` tinyint(4) NOT NULL,
  `premium_rate` int(11) NOT NULL,
  `employeeid` tinyint(4) NOT NULL,
  `mon_shift` varchar(100) NOT NULL,
  `mon_hrs` decimal(10,1) NOT NULL,
  `tues_shift` varchar(100) NOT NULL,
  `tues_hrs` decimal(10,1) NOT NULL,
  `wed_shift` varchar(100) NOT NULL,
  `wed_hrs` decimal(10,1) NOT NULL,
  `thurs_shift` varchar(100) NOT NULL,
  `thurs_hrs` decimal(10,1) NOT NULL,
  `fri_shift` varchar(100) NOT NULL,
  `fri_hrs` decimal(10,1) NOT NULL,
  `sat_shift` varchar(100) NOT NULL,
  `sat_hrs` decimal(10,1) NOT NULL,
  `sun_shift` varchar(100) NOT NULL,
  `sun_hrs` decimal(10,1) NOT NULL,
  `mon_shift1` varchar(100) NOT NULL,
  `mon_hrs1` int(11) NOT NULL,
  `total_hrs` decimal(10,1) NOT NULL,
  `total_premium` decimal(10,2) NOT NULL DEFAULT '0.00',
  `base_wage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `total_gross` decimal(10,2) NOT NULL DEFAULT '0.00',
  `status` varchar(100) NOT NULL,
  `last_modifiedby` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `employeeid` (`employeeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `timesheetdetails`
--


--
-- Table structure for table `timesheetnorth`
--

CREATE TABLE `timesheetnorth` (
  `northid` int(11) NOT NULL AUTO_INCREMENT,
  `period` varchar(100) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `client` varchar(100) NOT NULL,
  `patrol_location` varchar(100) NOT NULL,
  `account_number` int(11) NOT NULL,
  `department` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `last_modified_by` varchar(100) NOT NULL,
  PRIMARY KEY (`northid`),
  KEY `client` (`client`),
  KEY `patrol_location` (`patrol_location`),
  KEY `client_2` (`client`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `timesheetnorth`
--


--
-- Table structure for table `timesheetnorthdetails`
--

CREATE TABLE `timesheetnorthdetails` (
  `northtimeid` int(11) NOT NULL AUTO_INCREMENT,
  `northid` int(11) NOT NULL,
  `employeeid` int(11) NOT NULL,
  `mon_shift` varchar(100) NOT NULL,
  `mon_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `tues_shift` varchar(100) NOT NULL,
  `tues_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `wed_shift` varchar(100) NOT NULL,
  `wed_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `thurs_shift` varchar(100) NOT NULL,
  `thurs_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `fri_shift` varchar(100) NOT NULL,
  `fri_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `sat_shift` varchar(100) NOT NULL,
  `sat_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `sun_shift` varchar(100) NOT NULL,
  `sun_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `total_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `normal_hours` decimal(10,2) NOT NULL,
  `time_half_hours` decimal(10,2) NOT NULL,
  `double_hours` decimal(10,2) NOT NULL,
  PRIMARY KEY (`northtimeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `timesheetnorthdetails`
--


--
-- Table structure for table `timesheetsuva`
--

CREATE TABLE `timesheetsuva` (
  `timesuvaid` int(11) NOT NULL AUTO_INCREMENT,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `sectors` varchar(100) DEFAULT NULL,
  `patrol_location` varchar(100) DEFAULT NULL,
  `account_number` int(11) DEFAULT NULL,
  `department` varchar(100) DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL,
  `last_modified_by` varchar(100) DEFAULT NULL,
  `lastupdate` datetime NOT NULL,
  PRIMARY KEY (`timesuvaid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `timesheetsuva`
--

INSERT INTO `timesheetsuva` VALUES (5,'2018-01-08 00:00:00','2018-01-14 00:00:00','6','314',0,NULL,'approved','admin','2018-05-11 09:39:18');

--
-- Table structure for table `timesheetsuvadetails`
--

CREATE TABLE `timesheetsuvadetails` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `timesuvaid` int(11) NOT NULL,
  `employeeid` int(11) NOT NULL,
  `mon_date` date NOT NULL,
  `montime_in` time DEFAULT NULL,
  `montime_out` time DEFAULT NULL,
  `mon_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `montime_in1` time DEFAULT NULL,
  `montime_out1` time DEFAULT NULL,
  `mon_hrs2` decimal(10,1) NOT NULL,
  `mon_total` decimal(10,1) NOT NULL,
  `tues_date` date NOT NULL,
  `tuestime_in` time DEFAULT NULL,
  `tuestime_out` time DEFAULT NULL,
  `tues_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `tuestime_in1` time DEFAULT NULL,
  `tuestime_out1` time DEFAULT NULL,
  `tues_hrs2` decimal(10,1) NOT NULL,
  `tues_total` decimal(10,1) NOT NULL,
  `wed_date` date NOT NULL,
  `wedtime_in` time DEFAULT NULL,
  `wedtime_out` time DEFAULT NULL,
  `wed_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `wedtime_in1` time DEFAULT NULL,
  `wedtime_out1` time DEFAULT NULL,
  `wed_hrs2` decimal(10,1) NOT NULL,
  `wed_total` decimal(10,1) NOT NULL,
  `thurs_date` date NOT NULL,
  `thurstime_in` time DEFAULT NULL,
  `thurstime_out` time DEFAULT NULL,
  `thurs_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `thurstime_in1` time DEFAULT NULL,
  `thurstime_out1` time DEFAULT NULL,
  `thurs_hrs2` decimal(10,1) NOT NULL,
  `thurs_total` decimal(10,1) NOT NULL,
  `fri_date` date NOT NULL,
  `fritime_in` time DEFAULT NULL,
  `fritime_out` time DEFAULT NULL,
  `fri_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `fritime_in1` time DEFAULT NULL,
  `fritime_out1` time DEFAULT NULL,
  `fri_hrs2` decimal(10,1) NOT NULL,
  `fri_total` decimal(10,1) NOT NULL,
  `sat_date` date NOT NULL,
  `sattime_in` time DEFAULT NULL,
  `sattime_out` time DEFAULT NULL,
  `sat_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `sattime_in1` time DEFAULT NULL,
  `sattime_out2` time DEFAULT NULL,
  `sat_hrs2` decimal(10,1) NOT NULL DEFAULT '0.0',
  `sat_total` decimal(10,1) NOT NULL,
  `sun_date` date NOT NULL,
  `sunttime_in` time DEFAULT NULL,
  `sunttime_out` time DEFAULT NULL,
  `sun_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `suntime_in1` time DEFAULT NULL,
  `suntime_out1` time DEFAULT NULL,
  `sun_hrs2` decimal(10,1) NOT NULL,
  `sun_total` decimal(10,2) NOT NULL,
  `mon2_date` date NOT NULL,
  `mon2time_in` time DEFAULT NULL,
  `mon2time_out` time DEFAULT NULL,
  `mon2_total` decimal(10,1) NOT NULL,
  `total_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `normal_hours` decimal(10,2) NOT NULL,
  `time_half_hours` decimal(10,2) NOT NULL,
  `double_hours` decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `timesheetsuvadetails`
--

INSERT INTO `timesheetsuvadetails` VALUES (1,5,1442,'2018-01-08','04:00:00','14:00:00',10.0,NULL,NULL,0.0,10.0,'2018-01-09',NULL,NULL,0.0,NULL,NULL,0.0,0.0,'2018-01-10',NULL,NULL,0.0,NULL,NULL,0.0,0.0,'2018-01-11',NULL,NULL,0.0,NULL,NULL,0.0,0.0,'2018-01-12',NULL,NULL,0.0,NULL,NULL,0.0,0.0,'2018-01-13',NULL,NULL,0.0,NULL,NULL,0.0,0.0,'2018-01-14',NULL,NULL,0.0,NULL,NULL,0.0,0.00,'2018-01-15',NULL,NULL,0.0,10.0,8.00,2.00,0.00);

--
-- Table structure for table `timesheetwest`
--

CREATE TABLE `timesheetwest` (
  `twestid` int(11) NOT NULL AUTO_INCREMENT,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `client` varchar(100) NOT NULL,
  `patrol_location` varchar(100) NOT NULL,
  `account_number` int(11) NOT NULL,
  `department` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `last_modified_by` varchar(100) NOT NULL,
  `lastupdate` datetime NOT NULL,
  PRIMARY KEY (`twestid`),
  KEY `client` (`client`),
  KEY `patrol_location` (`patrol_location`),
  KEY `client_2` (`client`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `timesheetwest`
--


--
-- Table structure for table `timesheetwestdetails`
--

CREATE TABLE `timesheetwestdetails` (
  `twesttimeid` int(11) NOT NULL AUTO_INCREMENT,
  `twestid` int(11) NOT NULL,
  `employeeid` int(11) NOT NULL,
  `mon_shift` varchar(100) NOT NULL,
  `mon_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `tues_shift` varchar(100) NOT NULL,
  `tues_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `wed_shift` varchar(100) NOT NULL,
  `wed_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `thurs_shift` varchar(100) NOT NULL,
  `thurs_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `fri_shift` varchar(100) NOT NULL,
  `fri_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `sat_shift` varchar(100) NOT NULL,
  `sat_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `sun_shift` varchar(100) NOT NULL,
  `sun_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `total_hrs` decimal(10,1) NOT NULL DEFAULT '0.0',
  `normal_hours` decimal(10,2) NOT NULL,
  `time_half_hours` decimal(10,2) NOT NULL,
  `double_hours` decimal(10,2) NOT NULL,
  PRIMARY KEY (`twesttimeid`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `timesheetwestdetails`
--

INSERT INTO `timesheetwestdetails` VALUES (17,15,53081,'145',8.0,'145',8.0,'145',8.0,'118',0.0,'118',0.0,'162',9.0,'162',9.0,42.0,40.00,2.00,0.00),(18,15,53218,'',0.0,'',0.0,'',0.0,'',0.0,'',0.0,'',0.0,'',0.0,0.0,0.00,0.00,0.00);

--
-- Table structure for table `training`
--

CREATE TABLE `training` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employeeid` int(5) NOT NULL,
  `type` varchar(100) NOT NULL,
  `description` varchar(200) NOT NULL,
  `duration` varchar(100) NOT NULL,
  `completed` tinyint(1) NOT NULL,
  `entered_by` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `training`
--


--
-- Table structure for table `unitsofmeasure`
--

CREATE TABLE `unitsofmeasure` (
  `unitid` tinyint(4) NOT NULL AUTO_INCREMENT,
  `unitname` varchar(15) NOT NULL DEFAULT '',
  PRIMARY KEY (`unitid`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `unitsofmeasure`
--

INSERT INTO `unitsofmeasure` VALUES (1,'each'),(3,'kgs'),(4,'litres'),(5,'length'),(6,'hours'),(11,'bag'),(12,'packet');

--
-- Table structure for table `vms`
--

CREATE TABLE `vms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `trans_id` int(11) NOT NULL,
  `client` varchar(100) NOT NULL,
  `reftransid` int(11) DEFAULT NULL,
  `voided` tinyint(1) DEFAULT NULL,
  `trans_type` varchar(100) NOT NULL,
  `account` varchar(100) NOT NULL,
  `trans_date` datetime NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=902 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `vms`
--

INSERT INTO `vms` VALUES (8,1969,'WESTPAC FIJI',2007,1,'Supply','Suva Order','2018-03-22 12:25:00',498000.00),(9,1970,'WESTPAC FIJI',0,1,'Supply','ATM Transfer','2018-03-22 15:04:00',3470000.00),(10,1971,'WESTPAC FIJI',1970,0,'Supply','ATM Transfer','2018-03-22 18:11:00',-3470000.00),(11,1972,'WESTPAC FIJI',0,1,'Supply','ATM Transfer','2018-03-22 18:13:00',3452000.00),(12,1973,'WESTPAC FIJI',1972,0,'Supply','ATM Transfer','2018-03-22 18:45:00',-3452000.00),(13,1974,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-03-22 18:48:00',3447000.00),(14,1975,'WESTPAC FIJI',2213,0,'Deposit','RBF','2018-03-22 19:04:00',7000000.00),(15,1976,'WESTPAC FIJI',1969,0,'Supply','Suva Order','2018-03-22 19:14:00',-498000.00),(16,1977,'WESTPAC FIJI',2214,0,'Deposit','RBF','2018-03-22 19:24:00',140000.00),(17,1978,'WESTPAC FIJI',2008,0,'Supply','Suva Order','2018-03-22 19:31:00',710000.00),(18,1983,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-03-23 11:28:00',2472000.00),(19,1984,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-03-23 17:22:00',-100000.00),(20,1985,'WESTPAC FIJI',1984,0,'Cash Conversion','NULL ACCOUNT','2018-03-23 17:22:00',100000.00),(21,1986,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-03-23 17:23:00',-550000.00),(22,1987,'WESTPAC FIJI',1986,0,'Cash Conversion','NULL ACCOUNT','2018-03-23 17:23:00',550000.00),(23,1988,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-03-23 17:26:00',-1100000.00),(24,1989,'WESTPAC FIJI',1988,0,'Cash Conversion','NULL ACCOUNT','2018-03-23 17:26:00',1100000.00),(25,1990,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-03-23 17:27:00',-1750000.00),(26,1991,'WESTPAC FIJI',1990,0,'Cash Conversion','NULL ACCOUNT','2018-03-23 17:27:00',1750000.00),(27,1992,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-03-23 17:29:00',-3500000.00),(28,1993,'WESTPAC FIJI',1992,0,'Cash Conversion','NULL ACCOUNT','2018-03-23 17:29:00',3500000.00),(29,1994,'WESTPAC FIJI',2009,0,'Supply','RBF','2018-03-23 17:31:00',7000000.00),(30,2003,'WESTPAC FIJI',2011,0,'Supply','Suva Order','2018-03-23 17:51:00',10000.00),(31,2004,'WESTPAC FIJI',2215,0,'Deposit','Suva Deposit','2018-03-23 13:00:00',50000.00),(32,2005,'WESTPAC FIJI',2216,0,'Deposit','Suva Deposit','2018-03-23 13:44:00',500000.00),(33,2006,'WESTPAC FIJI',2217,0,'Deposit','Suva Deposit','2018-03-23 13:45:00',250000.00),(34,2007,'WESTPAC FIJI',2218,0,'Deposit','Suva Deposit','2018-03-23 15:11:00',250000.00),(35,2008,'WESTPAC FIJI',2219,0,'Deposit','Suva Deposit','2018-03-23 15:51:00',99987.00),(36,2009,'WESTPAC FIJI',2220,0,'Deposit','Suva Deposit','2018-03-23 15:53:00',100000.00),(37,2010,'WESTPAC FIJI',2221,0,'Deposit','Suva Deposit','2018-03-23 15:54:00',500000.00),(38,2011,'WESTPAC FIJI',2222,0,'Deposit','Suva Deposit','2018-03-23 15:55:00',250000.00),(39,2012,'WESTPAC FIJI',2223,0,'Deposit','Suva Deposit','2018-03-23 15:56:00',400000.00),(40,2013,'WESTPAC FIJI',2224,0,'Deposit','Suva Deposit','2018-03-23 15:57:00',50000.00),(41,2014,'WESTPAC FIJI',2226,0,'Deposit','Nabua Deposit','2018-03-23 17:09:00',50000.00),(42,2015,'WESTPAC FIJI',2227,0,'Deposit','Nabua Deposit','2018-03-23 17:10:00',100000.00),(43,2016,'WESTPAC FIJI',2228,0,'Deposit','Nabua Deposit','2018-03-23 17:12:00',250000.00),(44,2017,'WESTPAC FIJI',2229,0,'Deposit','Nabua Deposit','2018-03-23 17:14:00',500000.00),(45,2018,'WESTPAC FIJI',2230,0,'Deposit','Suva Deposit','2018-03-23 19:43:00',100000.00),(46,2019,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-03-23 20:02:00',1075950.00),(47,2024,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-03-26 09:50:00',-600.00),(48,2025,'WESTPAC FIJI',2024,0,'Cash Conversion','NULL ACCOUNT','2018-03-26 09:50:00',600.00),(49,2026,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-03-26 09:51:00',-380.00),(50,2027,'WESTPAC FIJI',2026,0,'Cash Conversion','NULL ACCOUNT','2018-03-26 09:51:00',380.00),(51,2028,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-03-26 09:52:00',-10.00),(52,2029,'WESTPAC FIJI',2028,0,'Cash Conversion','NULL ACCOUNT','2018-03-26 09:52:00',10.00),(53,2030,'WESTPAC FIJI',2231,0,'Deposit','RBF','2018-03-26 17:10:00',138200.00),(54,2031,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-03-26 17:17:00',205670.00),(55,2036,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-03-27 10:15:00',340000.00),(56,2037,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-03-27 10:52:00',1531000.00),(57,2038,'WESTPAC FIJI',2012,0,'Supply','Laucala Order','2018-03-27 15:47:00',50000.00),(58,2039,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-03-27 15:53:00',4150.00),(59,2040,'WESTPAC FIJI',2013,0,'Supply','Suva Order','2018-03-27 18:24:00',112000.00),(60,2041,'WESTPAC FIJI',2014,0,'Supply','Laucala Order','2018-03-27 18:26:00',48000.00),(61,2046,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-03-28 10:29:00',4670000.00),(62,2047,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-03-28 20:51:00',244370.00),(63,2048,'WESTPAC FIJI',2232,0,'Deposit','Nausori Deposit','2018-03-28 11:52:00',50000.00),(64,2049,'WESTPAC FIJI',2233,0,'Deposit','Nausori Deposit','2018-03-28 11:53:00',50000.00),(65,2050,'WESTPAC FIJI',2234,0,'Deposit','Nausori Deposit','2018-03-28 11:54:00',50000.00),(66,2051,'WESTPAC FIJI',2235,0,'Deposit','Nausori Deposit','2018-03-28 11:54:00',100000.00),(67,2052,'WESTPAC FIJI',2236,0,'Deposit','Nausori Deposit','2018-03-28 12:09:00',50000.00),(68,2053,'WESTPAC FIJI',2237,0,'Deposit','Nausori Deposit','2018-03-28 12:22:00',100000.00),(69,2054,'WESTPAC FIJI',2238,0,'Deposit','Nausori Deposit','2018-03-28 12:27:00',100000.00),(70,2055,'WESTPAC FIJI',2239,0,'Deposit','Nausori Deposit','2018-03-28 13:13:00',100000.00),(71,2056,'WESTPAC FIJI',2240,0,'Deposit','Nausori Deposit','2018-03-28 13:13:00',250000.00),(72,2057,'WESTPAC FIJI',2241,0,'Deposit','Nausori Deposit','2018-03-28 13:14:00',500000.00),(73,2058,'WESTPAC FIJI',2242,0,'Deposit','Nausori Deposit','2018-03-28 13:15:00',250000.00),(74,2059,'WESTPAC FIJI',2243,0,'Deposit','Nausori Deposit','2018-03-28 13:16:00',250000.00),(75,2060,'WESTPAC FIJI',2244,0,'Deposit','Nausori Deposit','2018-03-28 13:18:00',500000.00),(76,2061,'WESTPAC FIJI',2246,0,'Deposit','Nausori Deposit','2018-03-28 14:19:00',25000.00),(77,2062,'WESTPAC FIJI',2247,0,'Deposit','Nausori Deposit','2018-03-28 14:22:00',25000.00),(78,2063,'WESTPAC FIJI',2248,0,'Deposit','Laucala Deposit','2018-03-28 17:41:00',250000.00),(79,2064,'WESTPAC FIJI',2249,0,'Deposit','Laucala Deposit','2018-03-28 17:42:00',250000.00),(80,2065,'WESTPAC FIJI',2250,0,'Deposit','Laucala Deposit','2018-03-28 17:43:00',300000.00),(81,2066,'WESTPAC FIJI',2251,0,'Deposit','Laucala Deposit','2018-03-28 17:44:00',250000.00),(82,2067,'WESTPAC FIJI',2252,0,'Deposit','Laucala Deposit','2018-03-28 17:45:00',500000.00),(83,2068,'WESTPAC FIJI',2253,0,'Deposit','Laucala Deposit','2018-03-28 17:46:00',100000.00),(84,2069,'WESTPAC FIJI',2254,0,'Deposit','Laucala Deposit','2018-03-28 17:46:00',100000.00),(85,2070,'WESTPAC FIJI',2255,0,'Deposit','Laucala Deposit','2018-03-28 17:48:00',50000.00),(86,2071,'WESTPAC FIJI',2256,0,'Deposit','Suva Deposit','2018-03-28 17:50:00',250000.00),(87,2072,'WESTPAC FIJI',2257,0,'Deposit','Suva Deposit','2018-03-28 17:51:00',500000.00),(88,2073,'WESTPAC FIJI',2258,0,'Deposit','Suva Deposit','2018-03-28 17:54:00',500000.00),(89,2074,'WESTPAC FIJI',2259,0,'Deposit','Suva Deposit','2018-03-28 17:56:00',500000.00),(90,2075,'WESTPAC FIJI',2260,0,'Deposit','Suva Deposit','2018-03-28 17:56:00',250000.00),(91,2076,'WESTPAC FIJI',2261,0,'Deposit','Suva Deposit','2018-03-28 17:59:00',500000.00),(92,2077,'WESTPAC FIJI',2262,0,'Deposit','Suva Deposit','2018-03-28 17:59:00',250000.00),(93,2078,'WESTPAC FIJI',2263,0,'Deposit','Suva Deposit','2018-03-28 18:00:00',250000.00),(94,2079,'WESTPAC FIJI',2264,0,'Deposit','Suva Deposit','2018-03-28 18:01:00',100000.00),(95,2080,'WESTPAC FIJI',2265,0,'Deposit','Suva Deposit','2018-03-28 18:01:00',250000.00),(96,2081,'WESTPAC FIJI',2266,0,'Deposit','Suva Deposit','2018-03-28 18:02:00',100000.00),(97,2082,'WESTPAC FIJI',2267,0,'Deposit','Suva Deposit','2018-03-28 18:03:00',250000.00),(98,2083,'WESTPAC FIJI',2268,0,'Deposit','Suva Deposit','2018-03-28 18:04:00',100000.00),(99,2084,'WESTPAC FIJI',2269,0,'Deposit','Suva Deposit','2018-03-28 18:04:00',250000.00),(100,2085,'WESTPAC FIJI',2270,0,'Deposit','Suva Deposit','2018-03-28 18:07:00',250000.00),(101,2086,'WESTPAC FIJI',2271,0,'Deposit','Suva Deposit','2018-03-28 18:08:00',100000.00),(102,2087,'WESTPAC FIJI',2272,0,'Deposit','Suva Deposit','2018-03-28 18:08:00',50000.00),(103,2088,'WESTPAC FIJI',2273,0,'Deposit','Suva Deposit','2018-03-28 18:09:00',50000.00),(104,2089,'WESTPAC FIJI',2274,0,'Deposit','Nakasi Deposit','2018-03-28 18:15:00',250000.00),(105,2090,'WESTPAC FIJI',2275,0,'Deposit','Nakasi Deposit','2018-03-28 18:16:00',100000.00),(106,2091,'WESTPAC FIJI',2277,0,'Deposit','Nakasi Deposit','2018-03-28 18:20:00',250000.00),(107,2092,'WESTPAC FIJI',2278,0,'Deposit','Nakasi Deposit','2018-03-28 18:21:00',100000.00),(108,2093,'WESTPAC FIJI',2279,0,'Deposit','Nakasi Deposit','2018-03-28 18:22:00',400000.00),(109,2094,'WESTPAC FIJI',2280,0,'Deposit','Nakasi Deposit','2018-03-28 18:23:00',50000.00),(110,2095,'WESTPAC FIJI',2281,0,'Deposit','Nakasi Deposit','2018-03-28 18:24:00',50000.00),(111,2096,'WESTPAC FIJI',2282,0,'Deposit','Nakasi Deposit','2018-03-28 18:24:00',500000.00),(112,2097,'WESTPAC FIJI',2283,0,'Deposit','University Deposit','2018-03-28 18:27:00',100000.00),(113,2098,'WESTPAC FIJI',2284,0,'Deposit','Nakasi Deposit','2018-03-28 18:33:00',250000.00),(114,2099,'WESTPAC FIJI',2289,0,'Deposit','Nakasi Deposit','2018-03-28 20:23:00',25000.00),(115,2100,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-03-28 21:52:00',1340000.00),(116,2101,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-03-28 22:46:00',-18300.00),(117,2102,'WESTPAC FIJI',2101,0,'Cash Conversion','NULL ACCOUNT','2018-03-28 22:46:00',18300.00),(118,2103,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-03-28 22:47:00',-80750.00),(119,2104,'WESTPAC FIJI',2103,0,'Cash Conversion','NULL ACCOUNT','2018-03-28 22:47:00',80750.00),(120,2105,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-03-28 22:48:00',-201520.00),(121,2106,'WESTPAC FIJI',2105,0,'Cash Conversion','NULL ACCOUNT','2018-03-28 22:48:00',201520.00),(122,2107,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-03-28 22:49:00',-49400.00),(123,2108,'WESTPAC FIJI',2107,0,'Cash Conversion','NULL ACCOUNT','2018-03-28 22:49:00',49400.00),(124,2109,'WESTPAC FIJI',2285,0,'Deposit','University Deposit','2018-03-28 19:41:00',3615.35),(125,2110,'WESTPAC FIJI',2287,0,'Deposit','Nakasi Deposit','2018-03-28 19:55:00',43000.00),(126,2111,'WESTPAC FIJI',2288,0,'Deposit','Nausori Deposit','2018-03-28 20:01:00',6000.00),(127,2116,'WESTPAC FIJI',2290,0,'Deposit','Nausori Deposit','2018-03-29 11:41:00',50000.00),(128,2117,'WESTPAC FIJI',2291,0,'Deposit','Nausori Deposit','2018-03-29 11:42:00',100000.00),(129,2118,'WESTPAC FIJI',2292,0,'Deposit','Nausori Deposit','2018-03-29 11:43:00',250000.00),(130,2119,'WESTPAC FIJI',2293,0,'Deposit','Suva Deposit','2018-03-29 19:05:00',250000.00),(131,2120,'WESTPAC FIJI',2294,0,'Deposit','Suva Deposit','2018-03-29 19:12:00',250000.00),(132,2121,'WESTPAC FIJI',2295,0,'Deposit','Suva Deposit','2018-03-29 19:13:00',250000.00),(133,2122,'WESTPAC FIJI',2296,0,'Deposit','Suva Deposit','2018-03-29 19:13:00',250000.00),(134,2123,'WESTPAC FIJI',2297,0,'Deposit','Suva Deposit','2018-03-29 19:14:00',500000.00),(135,2124,'WESTPAC FIJI',2298,0,'Deposit','Suva Deposit','2018-03-29 19:18:00',400000.00),(136,2125,'WESTPAC FIJI',2299,0,'Deposit','Suva Deposit','2018-03-29 19:19:00',200000.00),(137,2126,'WESTPAC FIJI',2300,0,'Deposit','Suva Deposit','2018-03-29 19:20:00',300000.00),(138,2127,'WESTPAC FIJI',2301,0,'Deposit','Suva Deposit','2018-03-29 19:20:00',100000.00),(139,2128,'WESTPAC FIJI',2302,0,'Deposit','Suva Deposit','2018-03-29 19:21:00',100000.00),(140,2129,'WESTPAC FIJI',2303,0,'Deposit','Suva Deposit','2018-03-29 19:22:00',100000.00),(141,2130,'WESTPAC FIJI',2304,0,'Deposit','Suva Deposit','2018-03-29 19:22:00',100000.00),(142,2131,'WESTPAC FIJI',2305,0,'Deposit','Suva Deposit','2018-03-29 19:23:00',100000.00),(143,2132,'WESTPAC FIJI',2306,0,'Deposit','Suva Deposit','2018-03-29 19:24:00',100000.00),(144,2133,'WESTPAC FIJI',2307,0,'Deposit','Suva Deposit','2018-03-29 19:24:00',100000.00),(145,2134,'WESTPAC FIJI',2308,0,'Deposit','Suva Deposit','2018-03-29 19:25:00',100000.00),(146,2135,'WESTPAC FIJI',2309,0,'Deposit','Suva Deposit','2018-03-29 19:26:00',100000.00),(147,2136,'WESTPAC FIJI',2310,0,'Deposit','Suva Deposit','2018-03-29 19:26:00',50000.00),(148,2137,'WESTPAC FIJI',2311,0,'Deposit','Suva Deposit','2018-03-29 19:27:00',50000.00),(149,2138,'WESTPAC FIJI',2312,0,'Deposit','Suva Deposit','2018-03-29 19:28:00',50000.00),(150,2139,'WESTPAC FIJI',2313,0,'Deposit','Suva Deposit','2018-03-29 19:29:00',50000.00),(151,2140,'WESTPAC FIJI',2314,0,'Deposit','Suva Deposit','2018-03-29 19:31:00',50000.00),(152,2141,'WESTPAC FIJI',2315,0,'Deposit','Suva Deposit','2018-03-29 19:32:00',50000.00),(153,2142,'WESTPAC FIJI',2316,0,'Deposit','Suva Deposit','2018-03-29 19:42:00',50000.00),(154,2143,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-03-29 21:20:00',996140.00),(155,2144,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-03-29 21:59:00',-103100.00),(156,2145,'WESTPAC FIJI',2144,0,'Cash Conversion','NULL ACCOUNT','2018-03-29 21:59:00',103100.00),(157,2146,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-03-29 22:00:00',-391740.00),(158,2147,'WESTPAC FIJI',2146,0,'Cash Conversion','NULL ACCOUNT','2018-03-29 22:00:00',391740.00),(159,2148,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-03-29 22:01:00',-100000.00),(160,2149,'WESTPAC FIJI',2148,0,'Cash Conversion','NULL ACCOUNT','2018-03-29 22:01:00',100000.00),(161,2150,'WESTPAC FIJI',0,1,'Supply','ATM Transfer','2018-04-03 09:51:00',245000.00),(162,2151,'WESTPAC FIJI',0,1,'Supply','ATM Transfer','2018-04-03 09:57:00',818000.00),(163,2152,'WESTPAC FIJI',0,1,'Cash Conversion','NULL ACCOUNT','2018-04-03 11:55:00',-234630.00),(164,2153,'WESTPAC FIJI',2152,1,'Cash Conversion','NULL ACCOUNT','2018-04-03 11:55:00',234630.00),(165,2154,'WESTPAC FIJI',2015,1,'Supply','RBF','2018-04-03 11:55:00',7000000.00),(166,2155,'WESTPAC FIJI',0,1,'Deposit','ATM Transfer','2018-04-03 16:45:00',100340.00),(167,2156,'WESTPAC FIJI',0,1,'Cash Conversion','NULL ACCOUNT','2018-04-03 17:38:00',-305370.00),(168,2157,'WESTPAC FIJI',2156,1,'Cash Conversion','NULL ACCOUNT','2018-04-03 17:38:00',305370.00),(169,2158,'WESTPAC FIJI',0,1,'Cash Conversion','NULL ACCOUNT','2018-04-03 17:39:00',-50000.00),(170,2159,'WESTPAC FIJI',2158,1,'Cash Conversion','NULL ACCOUNT','2018-04-03 17:39:00',50000.00),(171,2160,'WESTPAC FIJI',0,1,'Cash Conversion','NULL ACCOUNT','2018-04-03 17:39:00',-1280000.00),(172,2161,'WESTPAC FIJI',2160,1,'Cash Conversion','NULL ACCOUNT','2018-04-03 17:39:00',1280000.00),(173,2162,'WESTPAC FIJI',0,1,'Cash Conversion','NULL ACCOUNT','2018-04-03 17:40:00',-1250000.00),(174,2163,'WESTPAC FIJI',2162,1,'Cash Conversion','NULL ACCOUNT','2018-04-03 17:40:00',1250000.00),(175,2164,'WESTPAC FIJI',0,1,'Cash Conversion','NULL ACCOUNT','2018-04-03 17:40:00',-500000.00),(176,2165,'WESTPAC FIJI',2164,1,'Cash Conversion','NULL ACCOUNT','2018-04-03 17:40:00',500000.00),(177,2166,'WESTPAC FIJI',2150,0,'Supply','ATM Transfer','2018-04-03 18:07:00',-245000.00),(178,2167,'WESTPAC FIJI',2151,0,'Supply','ATM Transfer','2018-04-03 18:07:00',-818000.00),(179,2168,'WESTPAC FIJI',2154,0,'Supply','RBF','2018-04-03 18:07:00',-7000000.00),(180,2169,'WESTPAC FIJI',2155,0,'Deposit','ATM Transfer','2018-04-03 18:07:00',-100340.00),(181,2170,'WESTPAC FIJI',2152,0,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:08:00',234630.00),(182,2171,'WESTPAC FIJI',2153,0,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:08:00',-234630.00),(183,2172,'WESTPAC FIJI',2156,1,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:08:00',305370.00),(184,2173,'WESTPAC FIJI',2156,0,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:08:00',305370.00),(185,2174,'WESTPAC FIJI',2157,0,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:08:00',-305370.00),(186,2175,'WESTPAC FIJI',2158,0,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:08:00',50000.00),(187,2176,'WESTPAC FIJI',2159,0,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:08:00',-50000.00),(188,2177,'WESTPAC FIJI',2158,1,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:08:00',50000.00),(189,2178,'WESTPAC FIJI',2160,0,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:08:00',1280000.00),(190,2179,'WESTPAC FIJI',2161,0,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:08:00',-1280000.00),(191,2180,'WESTPAC FIJI',2162,0,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:08:00',1250000.00),(192,2181,'WESTPAC FIJI',2163,0,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:08:00',-1250000.00),(193,2182,'WESTPAC FIJI',2162,1,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:08:00',1250000.00),(194,2183,'WESTPAC FIJI',2164,0,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:08:00',500000.00),(195,2184,'WESTPAC FIJI',2165,0,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:08:00',-500000.00),(196,2185,'WESTPAC FIJI',2165,1,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:08:00',-500000.00),(197,2186,'WESTPAC FIJI',2172,0,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:15:00',-305370.00),(198,2187,'WESTPAC FIJI',2177,0,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:15:00',-50000.00),(199,2188,'WESTPAC FIJI',2182,0,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:16:00',-1250000.00),(200,2189,'WESTPAC FIJI',2185,0,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:16:00',500000.00),(201,2194,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-04-03 18:19:00',245000.00),(202,2195,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-04-03 18:20:00',818000.00),(203,2196,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:26:00',-234630.00),(204,2197,'WESTPAC FIJI',2196,0,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:26:00',234630.00),(205,2198,'WESTPAC FIJI',2016,0,'Supply','RBF','2018-04-03 18:27:00',7000000.00),(206,2199,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-04-03 18:28:00',100340.00),(207,2200,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:32:00',-50000.00),(208,2201,'WESTPAC FIJI',2200,0,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:32:00',50000.00),(209,2202,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:32:00',-305370.00),(210,2203,'WESTPAC FIJI',2202,0,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:32:00',305370.00),(211,2204,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:33:00',-1280000.00),(212,2205,'WESTPAC FIJI',2204,0,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:33:00',1280000.00),(213,2206,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:33:00',-1250000.00),(214,2207,'WESTPAC FIJI',2206,0,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:33:00',1250000.00),(215,2208,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:33:00',-500000.00),(216,2209,'WESTPAC FIJI',2208,0,'Cash Conversion','NULL ACCOUNT','2018-04-03 18:33:00',500000.00),(217,2214,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-04 18:11:00',-2.00),(218,2215,'WESTPAC FIJI',2214,0,'Cash Conversion','NULL ACCOUNT','2018-04-04 18:11:00',2.00),(219,2216,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-04 18:13:00',-2.00),(220,2217,'WESTPAC FIJI',2216,0,'Cash Conversion','NULL ACCOUNT','2018-04-04 18:13:00',2.00),(221,2218,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-04-04 23:40:00',293590.00),(222,2219,'WESTPAC FIJI',2318,0,'Deposit','Laucala Deposit','2018-04-04 22:21:00',50000.00),(223,2220,'WESTPAC FIJI',2319,0,'Deposit','Laucala Deposit','2018-04-04 22:22:00',100000.00),(224,2221,'WESTPAC FIJI',2320,0,'Deposit','Laucala Deposit','2018-04-04 22:22:00',250000.00),(225,2222,'WESTPAC FIJI',2321,0,'Deposit','Laucala Deposit','2018-04-04 22:23:00',250000.00),(226,2223,'WESTPAC FIJI',2322,0,'Deposit','Laucala Deposit','2018-04-04 22:23:00',200000.00),(227,2224,'WESTPAC FIJI',2323,0,'Deposit','Laucala Deposit','2018-04-04 22:24:00',500000.00),(228,2225,'WESTPAC FIJI',2324,0,'Deposit','Suva Deposit','2018-04-04 22:25:00',500000.00),(229,2226,'WESTPAC FIJI',2325,0,'Deposit','Suva Deposit','2018-04-04 22:25:00',500000.00),(230,2227,'WESTPAC FIJI',2326,0,'Deposit','Suva Deposit','2018-04-04 22:26:00',500000.00),(231,2228,'WESTPAC FIJI',2327,0,'Deposit','Suva Deposit','2018-04-04 22:26:00',500000.00),(232,2229,'WESTPAC FIJI',2328,0,'Deposit','Suva Deposit','2018-04-04 22:29:00',250000.00),(233,2230,'WESTPAC FIJI',2329,0,'Deposit','Suva Deposit','2018-04-04 22:29:00',250000.00),(234,2231,'WESTPAC FIJI',2330,0,'Deposit','Suva Deposit','2018-04-04 22:30:00',250000.00),(235,2232,'WESTPAC FIJI',2331,0,'Deposit','Suva Deposit','2018-04-04 22:30:00',250000.00),(236,2233,'WESTPAC FIJI',2332,0,'Deposit','Suva Deposit','2018-04-04 22:30:00',250000.00),(237,2234,'WESTPAC FIJI',2333,0,'Deposit','Suva Deposit','2018-04-04 22:31:00',250000.00),(238,2235,'WESTPAC FIJI',2334,0,'Deposit','Suva Deposit','2018-04-04 22:32:00',250000.00),(239,2236,'WESTPAC FIJI',2335,0,'Deposit','Suva Deposit','2018-04-04 22:32:00',250000.00),(240,2237,'WESTPAC FIJI',2336,0,'Deposit','Suva Deposit','2018-04-04 22:35:00',250000.00),(241,2238,'WESTPAC FIJI',2337,0,'Deposit','Suva Deposit','2018-04-04 22:36:00',100000.00),(242,2239,'WESTPAC FIJI',2338,0,'Deposit','Suva Deposit','2018-04-04 22:36:00',100000.00),(243,2240,'WESTPAC FIJI',2339,0,'Deposit','Suva Deposit','2018-04-04 22:37:00',100000.00),(244,2241,'WESTPAC FIJI',2340,0,'Deposit','Suva Deposit','2018-04-04 22:37:00',100000.00),(245,2242,'WESTPAC FIJI',2341,0,'Deposit','Suva Deposit','2018-04-04 22:38:00',50000.00),(246,2243,'WESTPAC FIJI',2342,0,'Deposit','Suva Deposit','2018-04-04 22:38:00',50000.00),(247,2244,'WESTPAC FIJI',2343,0,'Deposit','Suva Deposit','2018-04-04 22:39:00',50000.00),(248,2245,'WESTPAC FIJI',2344,0,'Deposit','Suva Deposit','2018-04-04 22:39:00',50000.00),(249,2246,'WESTPAC FIJI',2345,0,'Deposit','Suva Deposit','2018-04-04 22:40:00',100000.00),(250,2247,'WESTPAC FIJI',2346,0,'Deposit','RBF','2018-04-04 22:57:00',140000.00),(251,2248,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-05 00:18:00',-12000.00),(252,2249,'WESTPAC FIJI',2248,0,'Cash Conversion','NULL ACCOUNT','2018-04-05 00:18:00',12000.00),(253,2250,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-05 00:31:00',-2060.00),(254,2251,'WESTPAC FIJI',2250,0,'Cash Conversion','NULL ACCOUNT','2018-04-05 00:31:00',2060.00),(255,2252,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-05 00:33:00',-19400.00),(256,2253,'WESTPAC FIJI',2252,0,'Cash Conversion','NULL ACCOUNT','2018-04-05 00:33:00',19400.00),(257,2254,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-05 00:33:00',-92750.00),(258,2255,'WESTPAC FIJI',2254,0,'Cash Conversion','NULL ACCOUNT','2018-04-05 00:33:00',92750.00),(259,2256,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-05 00:34:00',-1910.00),(260,2257,'WESTPAC FIJI',2256,0,'Cash Conversion','NULL ACCOUNT','2018-04-05 00:34:00',1910.00),(261,2258,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-05 00:35:00',-4490.00),(262,2259,'WESTPAC FIJI',2258,0,'Cash Conversion','NULL ACCOUNT','2018-04-05 00:35:00',4490.00),(263,2264,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-04-05 11:18:00',2650000.00),(264,2265,'WESTPAC FIJI',2017,0,'Supply','Laucala Order','2018-04-05 13:28:00',43000.00),(265,2266,'WESTPAC FIJI',2018,0,'Supply','Laucala Order','2018-04-05 13:29:00',30000.00),(266,2271,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-04-06 12:47:00',680000.00),(267,2272,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-04-06 14:11:00',340000.00),(268,2273,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-04-06 16:10:00',3030000.00),(269,2274,'WESTPAC FIJI',2347,0,'Deposit','Nakasi Deposit','2018-04-06 19:32:00',25000.00),(270,2275,'WESTPAC FIJI',2348,0,'Deposit','Nakasi Deposit','2018-04-06 19:35:00',35000.00),(271,2276,'WESTPAC FIJI',2349,0,'Deposit','Nakasi Deposit','2018-04-06 19:36:00',50000.00),(272,2277,'WESTPAC FIJI',2350,0,'Deposit','Nakasi Deposit','2018-04-06 19:36:00',50000.00),(273,2278,'WESTPAC FIJI',2351,0,'Deposit','Nakasi Deposit','2018-04-06 19:37:00',100000.00),(274,2279,'WESTPAC FIJI',2352,0,'Deposit','Nakasi Deposit','2018-04-06 19:38:00',100000.00),(275,2280,'WESTPAC FIJI',2353,0,'Deposit','Nakasi Deposit','2018-04-06 19:39:00',250000.00),(276,2281,'WESTPAC FIJI',2354,0,'Deposit','Nakasi Deposit','2018-04-06 19:40:00',200000.00),(277,2282,'WESTPAC FIJI',2355,0,'Deposit','Nakasi Deposit','2018-04-06 19:42:00',250000.00),(278,2283,'WESTPAC FIJI',2356,0,'Deposit','Nakasi Deposit','2018-04-06 19:42:00',500000.00),(279,2284,'WESTPAC FIJI',2357,0,'Deposit','Nakasi Deposit','2018-04-06 19:43:00',200000.00),(280,2285,'WESTPAC FIJI',2358,0,'Deposit','Nabua Deposit','2018-04-06 19:55:00',500000.00),(281,2286,'WESTPAC FIJI',2359,0,'Deposit','Nabua Deposit','2018-04-06 19:57:00',250000.00),(282,2287,'WESTPAC FIJI',2360,0,'Deposit','Nabua Deposit','2018-04-06 19:57:00',250000.00),(283,2288,'WESTPAC FIJI',2361,0,'Deposit','Nabua Deposit','2018-04-06 19:58:00',100000.00),(284,2289,'WESTPAC FIJI',2362,0,'Deposit','Nabua Deposit','2018-04-06 19:59:00',50000.00),(285,2290,'WESTPAC FIJI',2363,0,'Deposit','Nabua Deposit','2018-04-06 20:34:00',29584.30),(286,2291,'WESTPAC FIJI',2364,0,'Deposit','Nakasi Deposit','2018-04-06 20:48:00',35978.00),(287,2292,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-04-06 21:45:00',495330.00),(288,2293,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-06 22:26:00',-100.00),(289,2294,'WESTPAC FIJI',2293,0,'Cash Conversion','NULL ACCOUNT','2018-04-06 22:26:00',100.00),(290,2295,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-06 22:27:00',-25000.00),(291,2296,'WESTPAC FIJI',2295,0,'Cash Conversion','NULL ACCOUNT','2018-04-06 22:27:00',25000.00),(292,2297,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-06 22:28:00',-2000.00),(293,2298,'WESTPAC FIJI',2297,0,'Cash Conversion','NULL ACCOUNT','2018-04-06 22:28:00',2000.00),(294,2299,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-06 22:30:00',-20.00),(295,2300,'WESTPAC FIJI',2299,0,'Cash Conversion','NULL ACCOUNT','2018-04-06 22:30:00',20.00),(296,2301,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-06 22:31:00',-2000.00),(297,2302,'WESTPAC FIJI',2301,0,'Cash Conversion','NULL ACCOUNT','2018-04-06 22:31:00',2000.00),(298,2303,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-06 22:34:00',-210.00),(299,2304,'WESTPAC FIJI',2303,0,'Cash Conversion','NULL ACCOUNT','2018-04-06 22:34:00',210.00),(300,2309,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-04-09 10:20:00',920000.00),(301,2310,'WESTPAC FIJI',2365,0,'Deposit','Nausori Deposit','2018-04-09 19:35:00',500000.00),(302,2311,'WESTPAC FIJI',2366,0,'Deposit','Nausori Deposit','2018-04-09 19:36:00',500000.00),(303,2312,'WESTPAC FIJI',2367,0,'Deposit','Nausori Deposit','2018-04-09 19:37:00',250000.00),(304,2313,'WESTPAC FIJI',2368,0,'Deposit','Nausori Deposit','2018-04-09 19:37:00',250000.00),(305,2314,'WESTPAC FIJI',2369,0,'Deposit','Nausori Deposit','2018-04-09 19:38:00',250000.00),(306,2315,'WESTPAC FIJI',2370,0,'Deposit','Nausori Deposit','2018-04-09 19:39:00',250000.00),(307,2316,'WESTPAC FIJI',2371,0,'Deposit','Nausori Deposit','2018-04-09 19:40:00',100000.00),(308,2317,'WESTPAC FIJI',2372,0,'Deposit','Nausori Deposit','2018-04-09 19:40:00',100000.00),(309,2318,'WESTPAC FIJI',2373,0,'Deposit','Nausori Deposit','2018-04-09 19:41:00',100000.00),(310,2319,'WESTPAC FIJI',2374,0,'Deposit','Nausori Deposit','2018-04-09 19:42:00',50000.00),(311,2320,'WESTPAC FIJI',2375,0,'Deposit','Nausori Deposit','2018-04-09 19:42:00',50000.00),(312,2321,'WESTPAC FIJI',2376,0,'Deposit','Nausori Deposit','2018-04-09 19:43:00',50000.00),(313,2322,'WESTPAC FIJI',2377,0,'Deposit','Nausori Deposit','2018-04-09 19:44:00',50000.00),(314,2323,'WESTPAC FIJI',2378,0,'Deposit','Nausori Deposit','2018-04-09 19:44:00',35000.00),(315,2324,'WESTPAC FIJI',2379,0,'Deposit','Nausori Deposit','2018-04-09 19:45:00',25000.00),(316,2325,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-04-09 20:46:00',99750.00),(317,2330,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-04-10 09:16:00',2120000.00),(318,2335,'WESTPAC FIJI',2380,0,'Deposit','Suva Deposit','2018-04-11 21:45:00',50000.00),(319,2336,'WESTPAC FIJI',2381,0,'Deposit','Suva Deposit','2018-04-11 21:45:00',50000.00),(320,2337,'WESTPAC FIJI',2382,0,'Deposit','Suva Deposit','2018-04-11 21:46:00',50000.00),(321,2338,'WESTPAC FIJI',2383,0,'Deposit','Suva Deposit','2018-04-11 21:47:00',50000.00),(322,2339,'WESTPAC FIJI',2384,0,'Deposit','Suva Deposit','2018-04-11 21:48:00',100000.00),(323,2340,'WESTPAC FIJI',2385,0,'Deposit','Suva Deposit','2018-04-11 21:48:00',100000.00),(324,2341,'WESTPAC FIJI',2386,0,'Deposit','Suva Deposit','2018-04-11 21:49:00',100000.00),(325,2342,'WESTPAC FIJI',2387,0,'Deposit','Suva Deposit','2018-04-11 21:50:00',100000.00),(326,2343,'WESTPAC FIJI',2388,0,'Deposit','Suva Deposit','2018-04-11 21:50:00',100000.00),(327,2344,'WESTPAC FIJI',2389,0,'Deposit','Suva Deposit','2018-04-11 21:51:00',100000.00),(328,2345,'WESTPAC FIJI',2390,0,'Deposit','Suva Deposit','2018-04-11 21:51:00',250000.00),(329,2346,'WESTPAC FIJI',2391,0,'Deposit','Suva Deposit','2018-04-11 21:52:00',250000.00),(330,2347,'WESTPAC FIJI',2392,0,'Deposit','Suva Deposit','2018-04-11 21:53:00',250000.00),(331,2348,'WESTPAC FIJI',2393,0,'Deposit','Suva Deposit','2018-04-11 21:53:00',250000.00),(332,2349,'WESTPAC FIJI',2394,0,'Deposit','Suva Deposit','2018-04-11 21:54:00',250000.00),(333,2350,'WESTPAC FIJI',2395,0,'Deposit','Suva Deposit','2018-04-11 21:55:00',250000.00),(334,2351,'WESTPAC FIJI',2396,0,'Deposit','Suva Deposit','2018-04-11 21:55:00',250000.00),(335,2352,'WESTPAC FIJI',2397,0,'Deposit','Suva Deposit','2018-04-11 21:56:00',250000.00),(336,2353,'WESTPAC FIJI',2398,0,'Deposit','Suva Deposit','2018-04-11 21:56:00',250000.00),(337,2354,'WESTPAC FIJI',2399,0,'Deposit','Suva Deposit','2018-04-11 21:57:00',250000.00),(338,2355,'WESTPAC FIJI',2400,0,'Deposit','Suva Deposit','2018-04-11 21:57:00',500000.00),(339,2356,'WESTPAC FIJI',2401,0,'Deposit','Suva Deposit','2018-04-11 21:58:00',500000.00),(340,2357,'WESTPAC FIJI',2402,0,'Deposit','Suva Deposit','2018-04-11 21:59:00',500000.00),(341,2358,'WESTPAC FIJI',2403,0,'Deposit','Suva Deposit','2018-04-11 21:59:00',500000.00),(342,2359,'WESTPAC FIJI',2404,0,'Deposit','Suva Deposit','2018-04-11 22:00:00',500000.00),(343,2360,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-04-11 22:52:00',375850.00),(344,2361,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-11 23:23:00',-9470.00),(345,2362,'WESTPAC FIJI',2361,0,'Cash Conversion','NULL ACCOUNT','2018-04-11 23:23:00',9470.00),(346,2367,'WESTPAC FIJI',2019,0,'Supply','Laucala Order','2018-04-12 10:40:00',39000.00),(347,2368,'WESTPAC FIJI',2020,0,'Supply','University Order','2018-04-12 10:41:00',50000.00),(348,2369,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-04-12 11:22:00',2220000.00),(349,2374,'WESTPAC FIJI',2021,0,'Supply','Suva Order','2018-04-13 09:52:00',27000.00),(350,2375,'WESTPAC FIJI',0,1,'Supply','ATM Transfer','2018-04-13 12:50:00',240000.00),(351,2376,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-04-13 23:52:00',515000.00),(352,2377,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-04-14 00:37:00',1140000.00),(353,2378,'WESTPAC FIJI',2405,0,'Deposit','Nakasi Deposit','2018-04-14 00:04:00',3996.30),(354,2379,'WESTPAC FIJI',2406,0,'Deposit','University Deposit','2018-04-14 00:09:00',4800.75),(355,2380,'WESTPAC FIJI',2407,0,'Deposit','Laucala Deposit','2018-04-14 00:12:00',100000.00),(356,2381,'WESTPAC FIJI',2408,0,'Deposit','Laucala Deposit','2018-04-14 00:13:00',100000.00),(357,2382,'WESTPAC FIJI',2409,0,'Deposit','Laucala Deposit','2018-04-14 00:14:00',250000.00),(358,2383,'WESTPAC FIJI',2410,0,'Deposit','Laucala Deposit','2018-04-14 00:15:00',250000.00),(359,2384,'WESTPAC FIJI',2411,0,'Deposit','Laucala Deposit','2018-04-14 00:16:00',500000.00),(360,2385,'WESTPAC FIJI',2412,0,'Deposit','Laucala Deposit','2018-04-14 00:18:00',50000.00),(361,2386,'WESTPAC FIJI',2413,0,'Deposit','University Deposit','2018-04-14 00:20:00',20000.00),(362,2387,'WESTPAC FIJI',2414,0,'Deposit','University Deposit','2018-04-14 00:21:00',100000.00),(363,2388,'WESTPAC FIJI',2415,0,'Deposit','Nabua Deposit','2018-04-14 00:25:00',14000.00),(364,2389,'WESTPAC FIJI',2416,0,'Deposit','Nabua Deposit','2018-04-14 00:26:00',300000.00),(365,2390,'WESTPAC FIJI',2417,0,'Deposit','Nabua Deposit','2018-04-14 00:26:00',150000.00),(366,2391,'WESTPAC FIJI',2418,0,'Deposit','Nabua Deposit','2018-04-14 00:27:00',250000.00),(367,2392,'WESTPAC FIJI',2419,0,'Deposit','Nabua Deposit','2018-04-14 00:28:00',100000.00),(368,2393,'WESTPAC FIJI',2420,0,'Deposit','Nakasi Deposit','2018-04-14 00:30:00',500000.00),(369,2394,'WESTPAC FIJI',2421,0,'Deposit','Nakasi Deposit','2018-04-14 00:31:00',50000.00),(370,2395,'WESTPAC FIJI',2422,0,'Deposit','Nakasi Deposit','2018-04-14 00:32:00',50000.00),(371,2396,'WESTPAC FIJI',2423,0,'Deposit','Nakasi Deposit','2018-04-14 00:32:00',200000.00),(372,2397,'WESTPAC FIJI',2424,0,'Deposit','Nakasi Deposit','2018-04-14 00:33:00',100000.00),(373,2398,'WESTPAC FIJI',2425,0,'Deposit','Nakasi Deposit','2018-04-14 00:34:00',100000.00),(374,2399,'WESTPAC FIJI',2426,0,'Deposit','Nakasi Deposit','2018-04-14 00:59:00',250000.00),(375,2400,'WESTPAC FIJI',2427,0,'Deposit','Nakasi Deposit','2018-04-14 01:02:00',250000.00),(376,2401,'WESTPAC FIJI',2428,0,'Deposit','Nakasi Deposit','2018-04-14 01:07:00',25000.00),(377,2402,'WESTPAC FIJI',2375,0,'Supply','ATM Transfer','2018-04-16 07:58:00',-240000.00),(378,2403,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-04-16 08:00:00',242000.00),(379,2404,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-16 08:12:00',-66300.00),(380,2405,'WESTPAC FIJI',2404,0,'Cash Conversion','NULL ACCOUNT','2018-04-16 08:12:00',66300.00),(381,2406,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-16 08:14:00',-66300.00),(382,2407,'WESTPAC FIJI',2406,0,'Cash Conversion','NULL ACCOUNT','2018-04-16 08:14:00',66300.00),(383,2408,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-16 08:16:00',-15000.00),(384,2409,'WESTPAC FIJI',2408,0,'Cash Conversion','NULL ACCOUNT','2018-04-16 08:16:00',15000.00),(385,2410,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-16 08:21:00',-188180.00),(386,2411,'WESTPAC FIJI',2410,0,'Cash Conversion','NULL ACCOUNT','2018-04-16 08:21:00',188180.00),(387,2412,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-16 08:25:00',-22000.00),(388,2413,'WESTPAC FIJI',2412,0,'Cash Conversion','NULL ACCOUNT','2018-04-16 08:25:00',22000.00),(389,2418,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-04-16 12:44:00',191060.00),(390,2419,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-04-16 15:06:00',240000.00),(391,2420,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-04-16 19:49:00',1090.00),(392,2421,'WESTPAC FIJI',2429,0,'Deposit','Nausori Deposit','2018-04-16 19:56:00',250000.00),(393,2422,'WESTPAC FIJI',2430,0,'Deposit','Nausori Deposit','2018-04-16 19:57:00',100000.00),(394,2423,'WESTPAC FIJI',2431,0,'Deposit','Nausori Deposit','2018-04-16 19:58:00',100000.00),(395,2424,'WESTPAC FIJI',2432,0,'Deposit','Nausori Deposit','2018-04-16 19:59:00',100000.00),(396,2425,'WESTPAC FIJI',2433,0,'Deposit','Nausori Deposit','2018-04-16 20:00:00',50000.00),(397,2426,'WESTPAC FIJI',2434,0,'Deposit','Nausori Deposit','2018-04-16 20:01:00',50000.00),(398,2427,'WESTPAC FIJI',2435,0,'Deposit','Nausori Deposit','2018-04-16 20:02:00',50000.00),(399,2428,'WESTPAC FIJI',2436,0,'Deposit','Nausori Deposit','2018-04-16 20:03:00',250000.00),(400,2429,'WESTPAC FIJI',2437,0,'Deposit','Suva Deposit','2018-04-16 20:05:00',250000.00),(401,2430,'WESTPAC FIJI',2438,0,'Deposit','Suva Deposit','2018-04-16 20:06:00',250000.00),(402,2431,'WESTPAC FIJI',2439,0,'Deposit','Suva Deposit','2018-04-16 20:08:00',100000.00),(403,2432,'WESTPAC FIJI',2440,0,'Deposit','Suva Deposit','2018-04-16 20:09:00',250000.00),(404,2433,'WESTPAC FIJI',2441,0,'Deposit','Suva Deposit','2018-04-16 20:21:00',250000.00),(405,2434,'WESTPAC FIJI',2442,0,'Deposit','Suva Deposit','2018-04-16 20:33:00',250000.00),(406,2435,'WESTPAC FIJI',2443,0,'Deposit','Suva Deposit','2018-04-16 20:34:00',50000.00),(407,2436,'WESTPAC FIJI',2444,0,'Deposit','Suva Deposit','2018-04-16 20:35:00',250000.00),(408,2437,'WESTPAC FIJI',2445,0,'Deposit','Nausori Deposit','2018-04-16 20:45:00',500000.00),(409,2438,'WESTPAC FIJI',2446,0,'Deposit','Suva Deposit','2018-04-16 20:47:00',200000.00),(410,2439,'WESTPAC FIJI',2447,0,'Deposit','Nausori Deposit','2018-04-16 20:55:00',25000.00),(411,2448,'WESTPAC FIJI',2022,0,'Supply','Suva Order','2018-04-17 09:51:00',81000.00),(412,2449,'WESTPAC FIJI',2023,0,'Supply','Suva Order','2018-04-17 11:01:00',250000.00),(413,2450,'WESTPAC FIJI',2024,0,'Supply','Laucala Order','2018-04-17 11:02:00',24000.00),(414,2451,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-04-17 11:19:00',330000.00),(415,2452,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-04-17 11:33:00',1300000.00),(416,2453,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-17 14:31:00',-366330.00),(417,2454,'WESTPAC FIJI',2453,0,'Cash Conversion','NULL ACCOUNT','2018-04-17 14:31:00',366330.00),(418,2455,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-17 14:33:00',-340840.00),(419,2456,'WESTPAC FIJI',2455,0,'Cash Conversion','NULL ACCOUNT','2018-04-17 14:33:00',340840.00),(420,2457,'WESTPAC FIJI',2025,0,'Supply','RBF','2018-04-17 14:33:00',7000000.00),(421,2458,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-04-17 16:33:00',3780.00),(422,2459,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-17 19:43:00',-200000.00),(423,2460,'WESTPAC FIJI',2459,0,'Cash Conversion','NULL ACCOUNT','2018-04-17 19:43:00',200000.00),(424,2461,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-17 19:43:00',-1000000.00),(425,2462,'WESTPAC FIJI',2461,0,'Cash Conversion','NULL ACCOUNT','2018-04-17 19:43:00',1000000.00),(426,2463,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-17 19:44:00',-400000.00),(427,2464,'WESTPAC FIJI',2463,0,'Cash Conversion','NULL ACCOUNT','2018-04-17 19:44:00',400000.00),(428,2465,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-17 19:44:00',-117670.00),(429,2466,'WESTPAC FIJI',2465,0,'Cash Conversion','NULL ACCOUNT','2018-04-17 19:44:00',117670.00),(430,2467,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-17 19:44:00',-753160.00),(431,2468,'WESTPAC FIJI',2467,0,'Cash Conversion','NULL ACCOUNT','2018-04-17 19:44:00',753160.00),(432,2469,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-17 19:45:00',-1750000.00),(433,2470,'WESTPAC FIJI',2469,0,'Cash Conversion','NULL ACCOUNT','2018-04-17 19:45:00',1750000.00),(434,2471,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-17 19:45:00',-1100000.00),(435,2472,'WESTPAC FIJI',2471,0,'Cash Conversion','NULL ACCOUNT','2018-04-17 19:45:00',1100000.00),(436,2477,'WESTPAC FIJI',2475,0,'Deposit','RBF','2018-04-18 22:49:00',138958.15),(437,2478,'WESTPAC FIJI',2448,0,'Deposit','Nakasi Deposit','2018-04-18 21:47:00',50000.00),(438,2479,'WESTPAC FIJI',2449,0,'Deposit','Nakasi Deposit','2018-04-18 21:48:00',100000.00),(439,2480,'WESTPAC FIJI',2450,0,'Deposit','Nakasi Deposit','2018-04-18 21:49:00',100000.00),(440,2481,'WESTPAC FIJI',2451,0,'Deposit','Nakasi Deposit','2018-04-18 21:50:00',250000.00),(441,2482,'WESTPAC FIJI',2452,0,'Deposit','Nakasi Deposit','2018-04-18 21:50:00',250000.00),(442,2483,'WESTPAC FIJI',2453,0,'Deposit','Nakasi Deposit','2018-04-18 21:51:00',500000.00),(443,2484,'WESTPAC FIJI',2454,0,'Deposit','Laucala Deposit','2018-04-18 21:54:00',50000.00),(444,2485,'WESTPAC FIJI',2455,0,'Deposit','Laucala Deposit','2018-04-18 21:55:00',100000.00),(445,2486,'WESTPAC FIJI',2456,0,'Deposit','Laucala Deposit','2018-04-18 21:56:00',250000.00),(446,2487,'WESTPAC FIJI',2457,0,'Deposit','Laucala Deposit','2018-04-18 21:56:00',250000.00),(447,2488,'WESTPAC FIJI',2458,0,'Deposit','Laucala Deposit','2018-04-18 21:57:00',500000.00),(448,2489,'WESTPAC FIJI',2459,0,'Deposit','Suva Deposit','2018-04-18 22:14:00',500000.00),(449,2490,'WESTPAC FIJI',2460,0,'Deposit','Suva Deposit','2018-04-18 22:14:00',500000.00),(450,2491,'WESTPAC FIJI',2461,0,'Deposit','Suva Deposit','2018-04-18 22:15:00',500000.00),(451,2492,'WESTPAC FIJI',2462,0,'Deposit','Suva Deposit','2018-04-18 22:16:00',250000.00),(452,2493,'WESTPAC FIJI',2463,0,'Deposit','Suva Deposit','2018-04-18 22:17:00',250000.00),(453,2494,'WESTPAC FIJI',2464,0,'Deposit','Suva Deposit','2018-04-18 22:18:00',250000.00),(454,2495,'WESTPAC FIJI',2465,0,'Deposit','Suva Deposit','2018-04-18 22:18:00',250000.00),(455,2496,'WESTPAC FIJI',2466,0,'Deposit','Suva Deposit','2018-04-18 22:19:00',250000.00),(456,2497,'WESTPAC FIJI',2467,0,'Deposit','Suva Deposit','2018-04-18 22:21:00',250000.00),(457,2498,'WESTPAC FIJI',2468,0,'Deposit','Suva Deposit','2018-04-18 22:23:00',100000.00),(458,2499,'WESTPAC FIJI',2469,0,'Deposit','Suva Deposit','2018-04-18 22:23:00',100000.00),(459,2500,'WESTPAC FIJI',2470,0,'Deposit','Suva Deposit','2018-04-18 22:25:00',100000.00),(460,2501,'WESTPAC FIJI',2471,0,'Deposit','Suva Deposit','2018-04-18 22:26:00',100000.00),(461,2502,'WESTPAC FIJI',2472,0,'Deposit','Suva Deposit','2018-04-18 22:28:00',35000.00),(462,2503,'WESTPAC FIJI',2473,0,'Deposit','Suva Deposit','2018-04-18 22:28:00',35000.00),(463,2504,'WESTPAC FIJI',2474,0,'Deposit','Suva Deposit','2018-04-18 22:29:00',35000.00),(464,2505,'WESTPAC FIJI',2476,0,'Deposit','Suva Deposit','2018-04-18 23:16:00',50000.00),(465,2506,'WESTPAC FIJI',2477,0,'Deposit','Suva Deposit','2018-04-18 23:17:00',50000.00),(466,2507,'WESTPAC FIJI',2478,0,'Deposit','Suva Deposit','2018-04-18 23:31:00',50000.00),(467,2508,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-04-19 00:19:00',138940.00),(468,2509,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-19 01:09:00',-4000.00),(469,2510,'WESTPAC FIJI',2509,0,'Cash Conversion','NULL ACCOUNT','2018-04-19 01:09:00',4000.00),(470,2515,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-04-19 11:19:00',3631000.00),(471,2516,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-04-19 16:24:00',2250.00),(472,2521,'WESTPAC FIJI',2479,0,'Deposit','Nabua Deposit','2018-04-20 14:41:00',400000.00),(473,2522,'WESTPAC FIJI',2480,0,'Deposit','Nabua Deposit','2018-04-20 14:42:00',250000.00),(474,2523,'WESTPAC FIJI',2481,0,'Deposit','Nabua Deposit','2018-04-20 14:42:00',100000.00),(475,2524,'WESTPAC FIJI',2482,0,'Deposit','Nabua Deposit','2018-04-20 14:43:00',50000.00),(476,2525,'WESTPAC FIJI',2483,0,'Deposit','Nausori Deposit','2018-04-20 19:15:00',500000.00),(477,2526,'WESTPAC FIJI',2484,0,'Deposit','Nausori Deposit','2018-04-20 19:16:00',250000.00),(478,2527,'WESTPAC FIJI',2485,0,'Deposit','Nausori Deposit','2018-04-20 19:17:00',250000.00),(479,2528,'WESTPAC FIJI',2486,0,'Deposit','Nausori Deposit','2018-04-20 19:18:00',100000.00),(480,2529,'WESTPAC FIJI',2487,0,'Deposit','Nausori Deposit','2018-04-20 19:18:00',100000.00),(481,2530,'WESTPAC FIJI',2488,0,'Deposit','Nausori Deposit','2018-04-20 19:19:00',100000.00),(482,2531,'WESTPAC FIJI',2489,0,'Deposit','Nausori Deposit','2018-04-20 19:20:00',100000.00),(483,2532,'WESTPAC FIJI',2490,0,'Deposit','Nausori Deposit','2018-04-20 19:20:00',50000.00),(484,2533,'WESTPAC FIJI',2491,0,'Deposit','Nausori Deposit','2018-04-20 19:21:00',50000.00),(485,2534,'WESTPAC FIJI',2492,0,'Deposit','Nausori Deposit','2018-04-20 19:22:00',50000.00),(486,2535,'WESTPAC FIJI',2493,0,'Deposit','Nabua Deposit','2018-04-20 19:30:00',25000.00),(487,2536,'WESTPAC FIJI',2494,0,'Deposit','Nausori Deposit','2018-04-20 20:46:00',25000.00),(488,2537,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-04-20 21:55:00',1360000.00),(489,2538,'WESTPAC FIJI',2516,0,'Deposit','Nausori Deposit','2018-04-21 01:04:00',56002.20),(490,2539,'WESTPAC FIJI',2495,0,'Deposit','Suva Deposit','2018-04-21 00:17:00',50000.00),(491,2540,'WESTPAC FIJI',2496,0,'Deposit','Suva Deposit','2018-04-21 00:18:00',50000.00),(492,2541,'WESTPAC FIJI',2497,0,'Deposit','Suva Deposit','2018-04-21 00:19:00',50000.00),(493,2542,'WESTPAC FIJI',2498,0,'Deposit','Suva Deposit','2018-04-21 00:19:00',100000.00),(494,2543,'WESTPAC FIJI',2499,0,'Deposit','Suva Deposit','2018-04-21 00:20:00',100000.00),(495,2544,'WESTPAC FIJI',2500,0,'Deposit','Suva Deposit','2018-04-21 00:21:00',100000.00),(496,2545,'WESTPAC FIJI',2501,0,'Deposit','Suva Deposit','2018-04-21 00:22:00',100000.00),(497,2546,'WESTPAC FIJI',2502,0,'Deposit','Suva Deposit','2018-04-21 00:23:00',100000.00),(498,2547,'WESTPAC FIJI',2503,0,'Deposit','Suva Deposit','2018-04-21 00:23:00',100000.00),(499,2548,'WESTPAC FIJI',2504,0,'Deposit','Suva Deposit','2018-04-21 00:24:00',100000.00),(500,2549,'WESTPAC FIJI',2505,0,'Deposit','Suva Deposit','2018-04-21 00:25:00',500000.00),(501,2550,'WESTPAC FIJI',2506,0,'Deposit','Suva Deposit','2018-04-21 00:26:00',500000.00),(502,2551,'WESTPAC FIJI',2507,0,'Deposit','Suva Deposit','2018-04-21 00:30:00',500000.00),(503,2552,'WESTPAC FIJI',2508,0,'Deposit','Suva Deposit','2018-04-21 00:31:00',300000.00),(504,2553,'WESTPAC FIJI',2509,0,'Deposit','Suva Deposit','2018-04-21 00:33:00',500000.00),(505,2554,'WESTPAC FIJI',2510,0,'Deposit','Suva Deposit','2018-04-21 00:34:00',500000.00),(506,2555,'WESTPAC FIJI',2511,0,'Deposit','Suva Deposit','2018-04-21 00:35:00',500000.00),(507,2556,'WESTPAC FIJI',2512,0,'Deposit','Suva Deposit','2018-04-21 00:36:00',500000.00),(508,2557,'WESTPAC FIJI',2513,0,'Deposit','Suva Deposit','2018-04-21 00:41:00',499950.00),(509,2558,'WESTPAC FIJI',2514,0,'Deposit','Suva Deposit','2018-04-21 00:42:00',500000.00),(510,2559,'WESTPAC FIJI',2515,0,'Deposit','Suva Deposit','2018-04-21 01:01:00',249970.00),(511,2560,'WESTPAC FIJI',2517,0,'Deposit','Suva Deposit','2018-04-21 01:13:00',250000.00),(512,2561,'WESTPAC FIJI',2518,0,'Deposit','Suva Deposit','2018-04-21 01:33:00',250000.00),(513,2562,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-04-21 02:59:00',650500.00),(514,2563,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-21 03:42:00',-10000.00),(515,2564,'WESTPAC FIJI',2563,0,'Cash Conversion','NULL ACCOUNT','2018-04-21 03:42:00',10000.00),(516,2569,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-04-23 11:14:00',851000.00),(517,2570,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-04-23 16:37:00',146570.00),(518,2575,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-04-24 09:36:00',1094000.00),(519,2576,'WESTPAC FIJI',0,1,'Cash Conversion','NULL ACCOUNT','2018-04-24 10:00:00',-204730.00),(520,2577,'WESTPAC FIJI',2576,1,'Cash Conversion','NULL ACCOUNT','2018-04-24 10:00:00',204730.00),(521,2578,'WESTPAC FIJI',2576,1,'Cash Conversion','NULL ACCOUNT','2018-04-24 10:05:00',204730.00),(522,2579,'WESTPAC FIJI',2577,1,'Cash Conversion','NULL ACCOUNT','2018-04-24 10:05:00',-204730.00),(523,2580,'WESTPAC FIJI',2578,0,'Cash Conversion','NULL ACCOUNT','2018-04-24 10:06:00',-204730.00),(524,2581,'WESTPAC FIJI',2579,0,'Cash Conversion','NULL ACCOUNT','2018-04-24 10:07:00',204730.00),(525,2582,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-24 10:39:00',-87000.00),(526,2583,'WESTPAC FIJI',2582,0,'Cash Conversion','NULL ACCOUNT','2018-04-24 10:39:00',87000.00),(527,2584,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-24 10:42:00',-59260.00),(528,2585,'WESTPAC FIJI',2584,0,'Cash Conversion','NULL ACCOUNT','2018-04-24 10:42:00',59260.00),(529,2586,'WESTPAC FIJI',2026,0,'Supply','RBF','2018-04-24 10:43:00',7000000.00),(530,2587,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-24 16:50:00',-450000.00),(531,2588,'WESTPAC FIJI',2587,0,'Cash Conversion','NULL ACCOUNT','2018-04-24 16:50:00',450000.00),(532,2589,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-24 16:51:00',-1050000.00),(533,2590,'WESTPAC FIJI',2589,0,'Cash Conversion','NULL ACCOUNT','2018-04-24 16:51:00',1050000.00),(534,2591,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-24 16:52:00',-100000.00),(535,2592,'WESTPAC FIJI',2591,0,'Cash Conversion','NULL ACCOUNT','2018-04-24 16:52:00',100000.00),(536,2593,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-24 16:52:00',-900000.00),(537,2594,'WESTPAC FIJI',2593,0,'Cash Conversion','NULL ACCOUNT','2018-04-24 16:52:00',900000.00),(538,2595,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-24 16:53:00',-750000.00),(539,2596,'WESTPAC FIJI',2595,0,'Cash Conversion','NULL ACCOUNT','2018-04-24 16:53:00',750000.00),(540,2597,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-24 16:53:00',-100000.00),(541,2598,'WESTPAC FIJI',2597,0,'Cash Conversion','NULL ACCOUNT','2018-04-24 16:53:00',100000.00),(542,2599,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-24 16:54:00',-740740.00),(543,2600,'WESTPAC FIJI',2599,0,'Cash Conversion','NULL ACCOUNT','2018-04-24 16:54:00',740740.00),(544,2601,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-24 16:55:00',-110000.00),(545,2602,'WESTPAC FIJI',2601,0,'Cash Conversion','NULL ACCOUNT','2018-04-24 16:55:00',110000.00),(546,2603,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-24 16:56:00',-1730.00),(547,2604,'WESTPAC FIJI',2603,0,'Cash Conversion','NULL ACCOUNT','2018-04-24 16:56:00',1730.00),(548,2605,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-24 16:58:00',-50000.00),(549,2606,'WESTPAC FIJI',2605,0,'Cash Conversion','NULL ACCOUNT','2018-04-24 16:58:00',50000.00),(550,2611,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-04-25 09:16:00',1170000.00),(551,2612,'WESTPAC FIJI',0,0,'Deposit','RBF','2018-04-25 21:09:00',1000000.00),(552,2613,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-04-25 21:53:00',173060.00),(553,2614,'WESTPAC FIJI',2519,0,'Deposit','Nakasi Deposit','2018-04-25 11:36:00',50000.00),(554,2615,'WESTPAC FIJI',2520,0,'Deposit','Nakasi Deposit','2018-04-25 11:36:00',50000.00),(555,2616,'WESTPAC FIJI',2521,0,'Deposit','Nakasi Deposit','2018-04-25 11:37:00',100000.00),(556,2617,'WESTPAC FIJI',2522,0,'Deposit','Nakasi Deposit','2018-04-25 11:38:00',100000.00),(557,2618,'WESTPAC FIJI',2523,0,'Deposit','Nakasi Deposit','2018-04-25 11:38:00',250000.00),(558,2619,'WESTPAC FIJI',2524,0,'Deposit','Nakasi Deposit','2018-04-25 11:39:00',250000.00),(559,2620,'WESTPAC FIJI',2525,0,'Deposit','Nakasi Deposit','2018-04-25 11:40:00',500000.00),(560,2621,'WESTPAC FIJI',2526,0,'Deposit','Laucala Deposit','2018-04-25 11:41:00',500000.00),(561,2622,'WESTPAC FIJI',2527,0,'Deposit','Laucala Deposit','2018-04-25 11:45:00',250000.00),(562,2623,'WESTPAC FIJI',2528,0,'Deposit','Laucala Deposit','2018-04-25 12:34:00',100000.00),(563,2624,'WESTPAC FIJI',2529,0,'Deposit','Laucala Deposit','2018-04-25 12:35:00',250000.00),(564,2625,'WESTPAC FIJI',2555,0,'Deposit','Nakasi Deposit','2018-04-25 20:57:00',25000.00),(565,2626,'WESTPAC FIJI',2556,1,'Deposit','RBF','2018-04-25 21:43:00',149983.30),(566,2627,'WESTPAC FIJI',2530,0,'Deposit','Suva Deposit','2018-04-25 20:01:00',50000.00),(567,2628,'WESTPAC FIJI',2531,0,'Deposit','Suva Deposit','2018-04-25 20:02:00',50000.00),(568,2629,'WESTPAC FIJI',2532,0,'Deposit','Suva Deposit','2018-04-25 20:03:00',50000.00),(569,2630,'WESTPAC FIJI',2533,0,'Deposit','Suva Deposit','2018-04-25 20:03:00',100000.00),(570,2631,'WESTPAC FIJI',2534,0,'Deposit','Suva Deposit','2018-04-25 20:04:00',100000.00),(571,2632,'WESTPAC FIJI',2535,0,'Deposit','Suva Deposit','2018-04-25 20:05:00',100000.00),(572,2633,'WESTPAC FIJI',2536,0,'Deposit','Suva Deposit','2018-04-25 20:05:00',100000.00),(573,2634,'WESTPAC FIJI',2537,0,'Deposit','Suva Deposit','2018-04-25 20:06:00',100000.00),(574,2635,'WESTPAC FIJI',2538,0,'Deposit','Suva Deposit','2018-04-25 20:07:00',250000.00),(575,2636,'WESTPAC FIJI',2539,0,'Deposit','Suva Deposit','2018-04-25 20:08:00',250000.00),(576,2637,'WESTPAC FIJI',2540,0,'Deposit','Suva Deposit','2018-04-25 20:09:00',250000.00),(577,2638,'WESTPAC FIJI',2541,0,'Deposit','Suva Deposit','2018-04-25 20:09:00',250000.00),(578,2639,'WESTPAC FIJI',2542,0,'Deposit','Suva Deposit','2018-04-25 20:10:00',250000.00),(579,2640,'WESTPAC FIJI',2543,0,'Deposit','Suva Deposit','2018-04-25 20:11:00',250000.00),(580,2641,'WESTPAC FIJI',2544,0,'Deposit','Suva Deposit','2018-04-25 20:11:00',250000.00),(581,2642,'WESTPAC FIJI',2545,0,'Deposit','Suva Deposit','2018-04-25 20:12:00',250000.00),(582,2643,'WESTPAC FIJI',2546,0,'Deposit','Suva Deposit','2018-04-25 20:13:00',250000.00),(583,2644,'WESTPAC FIJI',2547,0,'Deposit','Suva Deposit','2018-04-25 20:14:00',250000.00),(584,2645,'WESTPAC FIJI',2548,0,'Deposit','Suva Deposit','2018-04-25 20:15:00',500000.00),(585,2646,'WESTPAC FIJI',2549,0,'Deposit','Suva Deposit','2018-04-25 20:15:00',500000.00),(586,2647,'WESTPAC FIJI',2550,0,'Deposit','Suva Deposit','2018-04-25 20:16:00',500000.00),(587,2648,'WESTPAC FIJI',2551,0,'Deposit','Suva Deposit','2018-04-25 20:17:00',500000.00),(588,2649,'WESTPAC FIJI',2552,0,'Deposit','Nabua Deposit','2018-04-25 20:19:00',250000.00),(589,2650,'WESTPAC FIJI',2553,0,'Deposit','Nabua Deposit','2018-04-25 20:20:00',400000.00),(590,2651,'WESTPAC FIJI',2554,0,'Deposit','Nabua Deposit','2018-04-25 20:33:00',100000.00),(591,2652,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-25 22:47:00',-1000.00),(592,2653,'WESTPAC FIJI',2652,0,'Cash Conversion','NULL ACCOUNT','2018-04-25 22:47:00',1000.00),(593,2654,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-04-25 22:48:00',-5000.00),(594,2655,'WESTPAC FIJI',2654,0,'Cash Conversion','NULL ACCOUNT','2018-04-25 22:48:00',5000.00),(595,2656,'WESTPAC FIJI',2626,0,'Deposit','RBF','2018-04-25 22:53:00',-149983.30),(596,2657,'WESTPAC FIJI',2557,0,'Deposit','Suva Deposit','2018-04-25 23:01:00',149983.30),(597,2662,'WESTPAC FIJI',2028,0,'Supply','Suva Order','2018-04-26 09:00:00',131000.00),(598,2663,'WESTPAC FIJI',0,1,'Deposit','ATM Transfer','2018-04-26 10:04:00',500000.00),(599,2664,'WESTPAC FIJI',2027,0,'Supply','Suva Order','2018-04-26 10:08:00',500000.00),(600,2665,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-04-26 11:12:00',2941000.00),(601,2666,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-04-26 14:15:00',163410.00),(602,2667,'WESTPAC FIJI',2663,0,'Deposit','ATM Transfer','2018-04-26 15:11:00',-500000.00),(603,2668,'WESTPAC FIJI',2558,0,'Deposit','RBF','2018-04-26 15:14:00',500000.00),(604,2673,'WESTPAC FIJI',2029,0,'Supply','Laucala Order','2018-04-27 09:13:00',26000.00),(605,2674,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-04-27 09:23:00',2604000.00),(606,2675,'WESTPAC FIJI',2559,0,'Deposit','Nausori Deposit','2018-04-27 14:23:00',50000.00),(607,2676,'WESTPAC FIJI',2560,0,'Deposit','Nausori Deposit','2018-04-27 14:23:00',50000.00),(608,2677,'WESTPAC FIJI',2561,0,'Deposit','Nausori Deposit','2018-04-27 14:26:00',25000.00),(609,2678,'WESTPAC FIJI',2562,0,'Deposit','Nausori Deposit','2018-04-27 14:27:00',500000.00),(610,2679,'WESTPAC FIJI',2563,0,'Deposit','Nausori Deposit','2018-04-27 14:28:00',500000.00),(611,2680,'WESTPAC FIJI',2564,0,'Deposit','Nausori Deposit','2018-04-27 14:29:00',100000.00),(612,2681,'WESTPAC FIJI',2565,0,'Deposit','Nausori Deposit','2018-04-27 14:30:00',100000.00),(613,2682,'WESTPAC FIJI',2566,0,'Deposit','Nausori Deposit','2018-04-27 14:31:00',100000.00),(614,2683,'WESTPAC FIJI',2567,0,'Deposit','Nausori Deposit','2018-04-27 14:31:00',250000.00),(615,2684,'WESTPAC FIJI',2568,0,'Deposit','Nausori Deposit','2018-04-27 14:32:00',250000.00),(616,2685,'WESTPAC FIJI',2569,0,'Deposit','Nausori Deposit','2018-04-27 14:33:00',250000.00),(617,2686,'WESTPAC FIJI',2570,0,'Deposit','Nausori Deposit','2018-04-27 14:33:00',250000.00),(618,2687,'WESTPAC FIJI',2571,0,'Deposit','Suva Deposit','2018-04-27 14:37:00',400000.00),(619,2688,'WESTPAC FIJI',2572,0,'Deposit','Suva Deposit','2018-04-27 14:37:00',500000.00),(620,2689,'WESTPAC FIJI',2573,0,'Deposit','Suva Deposit','2018-04-27 14:38:00',250000.00),(621,2690,'WESTPAC FIJI',2574,0,'Deposit','Suva Deposit','2018-04-27 14:40:00',100000.00),(622,2691,'WESTPAC FIJI',2575,0,'Deposit','Suva Deposit','2018-04-27 14:41:00',50000.00),(623,2692,'WESTPAC FIJI',2576,0,'Deposit','Suva Deposit','2018-04-27 14:42:00',500000.00),(624,2693,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-04-27 15:57:00',483950.00),(625,2698,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-04-30 13:05:00',321990.00),(626,2703,'WESTPAC FIJI',2030,0,'Supply','RBF','2018-05-01 10:49:00',7000000.00),(627,2704,'WESTPAC FIJI',2031,0,'Supply','Laucala Order','2018-05-01 10:58:00',52000.00),(628,2705,'WESTPAC FIJI',2032,0,'Supply','Laucala Order','2018-05-01 11:18:00',20000.00),(629,2706,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-05-01 15:49:00',340000.00),(630,2707,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-05-01 16:26:00',-200000.00),(631,2708,'WESTPAC FIJI',2707,0,'Cash Conversion','NULL ACCOUNT','2018-05-01 16:26:00',200000.00),(632,2709,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-05-01 16:26:00',-300000.00),(633,2710,'WESTPAC FIJI',2709,0,'Cash Conversion','NULL ACCOUNT','2018-05-01 16:26:00',300000.00),(634,2711,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-05-01 16:27:00',-250000.00),(635,2712,'WESTPAC FIJI',2711,0,'Cash Conversion','NULL ACCOUNT','2018-05-01 16:27:00',250000.00),(636,2713,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-05-01 16:27:00',-750000.00),(637,2714,'WESTPAC FIJI',2713,0,'Cash Conversion','NULL ACCOUNT','2018-05-01 16:27:00',750000.00),(638,2715,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-05-01 16:28:00',-200000.00),(639,2716,'WESTPAC FIJI',2715,0,'Cash Conversion','NULL ACCOUNT','2018-05-01 16:28:00',200000.00),(640,2717,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-05-01 16:29:00',-50000.00),(641,2718,'WESTPAC FIJI',2717,0,'Cash Conversion','NULL ACCOUNT','2018-05-01 16:29:00',50000.00),(642,2719,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-05-01 16:29:00',-50000.00),(643,2720,'WESTPAC FIJI',2719,0,'Cash Conversion','NULL ACCOUNT','2018-05-01 16:29:00',50000.00),(644,2725,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-05-02 09:44:00',340000.00),(645,2726,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-05-02 19:14:00',336510.00),(646,2727,'WESTPAC FIJI',2577,0,'Deposit','Nakasi Deposit','2018-05-02 10:23:00',400000.00),(647,2728,'WESTPAC FIJI',2578,0,'Deposit','Nakasi Deposit','2018-05-02 10:24:00',500000.00),(648,2729,'WESTPAC FIJI',2579,0,'Deposit','Nakasi Deposit','2018-05-02 10:40:00',250000.00),(649,2730,'WESTPAC FIJI',2580,0,'Deposit','Nakasi Deposit','2018-05-02 10:56:00',250000.00),(650,2731,'WESTPAC FIJI',2581,0,'Deposit','Nakasi Deposit','2018-05-02 11:27:00',100000.00),(651,2732,'WESTPAC FIJI',2582,0,'Deposit','Nakasi Deposit','2018-05-02 11:27:00',250000.00),(652,2733,'WESTPAC FIJI',2583,0,'Deposit','Nakasi Deposit','2018-05-02 12:34:00',50000.00),(653,2734,'WESTPAC FIJI',2584,0,'Deposit','Nakasi Deposit','2018-05-02 12:34:00',100000.00),(654,2735,'WESTPAC FIJI',2585,0,'Deposit','Suva Deposit','2018-05-02 16:42:00',500000.00),(655,2736,'WESTPAC FIJI',2586,0,'Deposit','Suva Deposit','2018-05-02 16:43:00',500000.00),(656,2737,'WESTPAC FIJI',2587,0,'Deposit','Suva Deposit','2018-05-02 16:44:00',500000.00),(657,2738,'WESTPAC FIJI',2588,0,'Deposit','Suva Deposit','2018-05-02 16:45:00',500000.00),(658,2739,'WESTPAC FIJI',2589,0,'Deposit','Suva Deposit','2018-05-02 16:45:00',250000.00),(659,2740,'WESTPAC FIJI',2590,0,'Deposit','Suva Deposit','2018-05-02 16:46:00',250000.00),(660,2741,'WESTPAC FIJI',2591,0,'Deposit','Suva Deposit','2018-05-02 16:47:00',250000.00),(661,2742,'WESTPAC FIJI',2592,0,'Deposit','Suva Deposit','2018-05-02 16:47:00',250000.00),(662,2743,'WESTPAC FIJI',2593,0,'Deposit','Suva Deposit','2018-05-02 16:48:00',250000.00),(663,2744,'WESTPAC FIJI',2594,0,'Deposit','Suva Deposit','2018-05-02 16:49:00',250000.00),(664,2745,'WESTPAC FIJI',2595,0,'Deposit','Suva Deposit','2018-05-02 16:50:00',250000.00),(665,2746,'WESTPAC FIJI',2596,0,'Deposit','Suva Deposit','2018-05-02 16:51:00',250000.00),(666,2747,'WESTPAC FIJI',2597,0,'Deposit','Suva Deposit','2018-05-02 16:57:00',250000.00),(667,2748,'WESTPAC FIJI',2598,0,'Deposit','Suva Deposit','2018-05-02 16:57:00',100000.00),(668,2749,'WESTPAC FIJI',2599,0,'Deposit','Suva Deposit','2018-05-02 16:58:00',100000.00),(669,2750,'WESTPAC FIJI',2600,0,'Deposit','Suva Deposit','2018-05-02 16:59:00',100000.00),(670,2751,'WESTPAC FIJI',2601,0,'Deposit','Suva Deposit','2018-05-02 16:59:00',100000.00),(671,2752,'WESTPAC FIJI',2602,0,'Deposit','Suva Deposit','2018-05-02 17:01:00',100000.00),(672,2753,'WESTPAC FIJI',2603,0,'Deposit','Suva Deposit','2018-05-02 17:02:00',100000.00),(673,2754,'WESTPAC FIJI',2604,0,'Deposit','Suva Deposit','2018-05-02 17:03:00',50000.00),(674,2755,'WESTPAC FIJI',2605,0,'Deposit','Suva Deposit','2018-05-02 17:03:00',50000.00),(675,2756,'WESTPAC FIJI',2606,0,'Deposit','Suva Deposit','2018-05-02 17:04:00',50000.00),(676,2757,'WESTPAC FIJI',2607,0,'Deposit','Suva Deposit','2018-05-02 17:05:00',50000.00),(677,2758,'WESTPAC FIJI',2608,0,'Deposit','Laucala Deposit','2018-05-02 17:52:00',250000.00),(678,2759,'WESTPAC FIJI',2609,0,'Deposit','Laucala Deposit','2018-05-02 17:52:00',250000.00),(679,2760,'WESTPAC FIJI',2610,0,'Deposit','Laucala Deposit','2018-05-02 17:53:00',250000.00),(680,2761,'WESTPAC FIJI',2611,0,'Deposit','Laucala Deposit','2018-05-02 17:54:00',500000.00),(681,2762,'WESTPAC FIJI',2612,0,'Deposit','Laucala Deposit','2018-05-02 17:55:00',300000.00),(682,2763,'WESTPAC FIJI',2613,0,'Deposit','Laucala Deposit','2018-05-02 17:55:00',100000.00),(683,2764,'WESTPAC FIJI',2614,0,'Deposit','Laucala Deposit','2018-05-02 18:04:00',40000.00),(684,2765,'WESTPAC FIJI',2615,0,'Deposit','Laucala Deposit','2018-05-02 18:11:00',50000.00),(685,2766,'WESTPAC FIJI',2616,0,'Deposit','Nabua Deposit','2018-05-02 18:21:00',50000.00),(686,2767,'WESTPAC FIJI',2617,0,'Deposit','Nabua Deposit','2018-05-02 18:29:00',80000.00),(687,2768,'WESTPAC FIJI',2618,0,'Deposit','Nabua Deposit','2018-05-02 18:40:00',250000.00),(688,2769,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-05-02 20:16:00',-50.00),(689,2770,'WESTPAC FIJI',2769,0,'Cash Conversion','NULL ACCOUNT','2018-05-02 20:16:00',50.00),(690,2771,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-05-02 20:16:00',-2000.00),(691,2772,'WESTPAC FIJI',2771,0,'Cash Conversion','NULL ACCOUNT','2018-05-02 20:16:00',2000.00),(692,2773,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-05-02 20:17:00',-1000.00),(693,2774,'WESTPAC FIJI',2773,0,'Cash Conversion','NULL ACCOUNT','2018-05-02 20:17:00',1000.00),(694,2779,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-05-03 10:46:00',416000.00),(695,2780,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-05-03 11:09:00',3334000.00),(696,2781,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-05-03 15:23:00',4990.00),(697,2786,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-05-04 10:13:00',1600000.00),(698,2787,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-05-04 13:10:00',340000.00),(699,2788,'WESTPAC FIJI',2619,0,'Deposit','Nausori Deposit','2018-05-04 19:14:00',74036.85),(700,2789,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-05-04 20:35:00',333660.00),(701,2790,'WESTPAC FIJI',2620,0,'Deposit','Nausori Deposit','2018-05-04 19:20:00',25000.00),(702,2791,'WESTPAC FIJI',2621,0,'Deposit','Nausori Deposit','2018-05-04 19:20:00',25000.00),(703,2792,'WESTPAC FIJI',2622,0,'Deposit','Nausori Deposit','2018-05-04 19:21:00',50000.00),(704,2793,'WESTPAC FIJI',2623,0,'Deposit','Nausori Deposit','2018-05-04 19:22:00',50000.00),(705,2794,'WESTPAC FIJI',2624,0,'Deposit','Nausori Deposit','2018-05-04 19:23:00',50000.00),(706,2795,'WESTPAC FIJI',2625,0,'Deposit','Nausori Deposit','2018-05-04 19:23:00',100000.00),(707,2796,'WESTPAC FIJI',2626,0,'Deposit','Nausori Deposit','2018-05-04 19:24:00',100000.00),(708,2797,'WESTPAC FIJI',2627,0,'Deposit','Nausori Deposit','2018-05-04 19:25:00',100000.00),(709,2798,'WESTPAC FIJI',2628,0,'Deposit','Nausori Deposit','2018-05-04 19:28:00',250000.00),(710,2799,'WESTPAC FIJI',2629,0,'Deposit','Nausori Deposit','2018-05-04 19:36:00',250000.00),(711,2800,'WESTPAC FIJI',2630,0,'Deposit','Nausori Deposit','2018-05-04 19:45:00',250000.00),(712,2801,'WESTPAC FIJI',2631,0,'Deposit','Nausori Deposit','2018-05-04 19:46:00',500000.00),(713,2802,'WESTPAC FIJI',2632,0,'Deposit','Suva Deposit','2018-05-04 19:48:00',250000.00),(714,2803,'WESTPAC FIJI',2633,0,'Deposit','Suva Deposit','2018-05-04 19:49:00',100000.00),(715,2804,'WESTPAC FIJI',2634,0,'Deposit','Suva Deposit','2018-05-04 19:58:00',50000.00),(716,2805,'WESTPAC FIJI',2635,0,'Deposit','Suva Deposit','2018-05-04 19:59:00',50000.00),(717,2806,'WESTPAC FIJI',2636,0,'Deposit','Suva Deposit','2018-05-04 20:00:00',50000.00),(718,2807,'WESTPAC FIJI',2637,0,'Deposit','Suva Deposit','2018-05-04 20:03:00',50000.00),(719,2808,'WESTPAC FIJI',2638,0,'Deposit','Suva Deposit','2018-05-04 20:04:00',100000.00),(720,2809,'WESTPAC FIJI',2639,0,'Deposit','Suva Deposit','2018-05-04 20:04:00',100000.00),(721,2810,'WESTPAC FIJI',2640,0,'Deposit','Suva Deposit','2018-05-04 20:05:00',250000.00),(722,2811,'WESTPAC FIJI',2641,0,'Deposit','Suva Deposit','2018-05-04 20:06:00',100000.00),(723,2812,'WESTPAC FIJI',2642,0,'Deposit','Suva Deposit','2018-05-04 20:06:00',100000.00),(724,2813,'WESTPAC FIJI',2643,0,'Deposit','Suva Deposit','2018-05-04 20:07:00',250000.00),(725,2814,'WESTPAC FIJI',2644,0,'Deposit','Suva Deposit','2018-05-04 20:07:00',250000.00),(726,2815,'WESTPAC FIJI',2645,0,'Deposit','Suva Deposit','2018-05-04 20:08:00',200000.00),(727,2816,'WESTPAC FIJI',2646,0,'Deposit','Suva Deposit','2018-05-04 20:09:00',500000.00),(728,2817,'WESTPAC FIJI',2647,0,'Deposit','Suva Deposit','2018-05-04 20:09:00',100000.00),(729,2818,'WESTPAC FIJI',2648,0,'Deposit','Suva Deposit','2018-05-04 20:10:00',50000.00),(730,2819,'WESTPAC FIJI',2649,0,'Deposit','Suva Deposit','2018-05-04 20:10:00',50000.00),(731,2820,'WESTPAC FIJI',2650,0,'Deposit','Suva Deposit','2018-05-04 20:11:00',50000.00),(732,2825,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-05-07 08:56:00',169000.00),(733,2826,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-05-07 09:21:00',585000.00),(734,2827,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-05-07 10:55:00',150000.00),(735,2828,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-05-07 15:27:00',322490.00),(736,2833,'WESTPAC FIJI',2033,0,'Supply','RBF','2018-05-08 10:08:00',6975000.00),(737,2834,'WESTPAC FIJI',2034,0,'Supply','Laucala Order','2018-05-08 10:30:00',35000.00),(738,2835,'WESTPAC FIJI',2035,0,'Supply','Laucala Order','2018-05-08 10:33:00',30000.00),(739,2836,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-05-08 15:53:00',925000.00),(740,2837,'WESTPAC FIJI',2036,0,'Supply','Suva Order','2018-05-08 15:57:00',25000.00),(741,2838,'WESTPAC FIJI',2651,0,'Deposit','Suva Deposit','2018-05-08 16:53:00',25000.00),(742,2839,'WESTPAC FIJI',2652,0,'Deposit','RBF','2018-05-08 17:13:00',18500.00),(743,2840,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-05-08 17:58:00',-5000.00),(744,2841,'WESTPAC FIJI',2840,0,'Cash Conversion','NULL ACCOUNT','2018-05-08 17:58:00',5000.00),(745,2842,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-05-08 17:58:00',-110000.00),(746,2843,'WESTPAC FIJI',2842,0,'Cash Conversion','NULL ACCOUNT','2018-05-08 17:58:00',110000.00),(747,2844,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-05-08 17:58:00',-220000.00),(748,2845,'WESTPAC FIJI',2844,0,'Cash Conversion','NULL ACCOUNT','2018-05-08 17:58:00',220000.00),(749,2846,'WESTPAC FIJI',0,1,'Cash Conversion','NULL ACCOUNT','2018-05-08 17:59:00',-750000.00),(750,2847,'WESTPAC FIJI',2846,1,'Cash Conversion','NULL ACCOUNT','2018-05-08 17:59:00',750000.00),(751,2848,'WESTPAC FIJI',0,1,'Cash Conversion','NULL ACCOUNT','2018-05-08 17:59:00',-750000.00),(752,2849,'WESTPAC FIJI',2848,1,'Cash Conversion','NULL ACCOUNT','2018-05-08 17:59:00',750000.00),(753,2850,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-05-08 18:00:00',-750000.00),(754,2851,'WESTPAC FIJI',2850,0,'Cash Conversion','NULL ACCOUNT','2018-05-08 18:00:00',750000.00),(755,2852,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-05-08 18:00:00',-750000.00),(756,2853,'WESTPAC FIJI',2852,0,'Cash Conversion','NULL ACCOUNT','2018-05-08 18:00:00',750000.00),(757,2854,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-05-08 18:01:00',-20000.00),(758,2855,'WESTPAC FIJI',2854,0,'Cash Conversion','NULL ACCOUNT','2018-05-08 18:01:00',20000.00),(759,2856,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-05-08 18:02:00',-190000.00),(760,2857,'WESTPAC FIJI',2856,0,'Cash Conversion','NULL ACCOUNT','2018-05-08 18:02:00',190000.00),(761,2858,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-05-08 18:02:00',-380000.00),(762,2859,'WESTPAC FIJI',2858,0,'Cash Conversion','NULL ACCOUNT','2018-05-08 18:02:00',380000.00),(763,2860,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-05-08 18:05:00',-750000.00),(764,2861,'WESTPAC FIJI',2860,0,'Cash Conversion','NULL ACCOUNT','2018-05-08 18:05:00',750000.00),(765,2862,'WESTPAC FIJI',2846,0,'Cash Conversion','NULL ACCOUNT','2018-05-08 18:07:00',750000.00),(766,2863,'WESTPAC FIJI',2847,0,'Cash Conversion','NULL ACCOUNT','2018-05-08 18:08:00',-750000.00),(767,2864,'WESTPAC FIJI',2848,0,'Cash Conversion','NULL ACCOUNT','2018-05-08 18:09:00',750000.00),(768,2865,'WESTPAC FIJI',2849,0,'Cash Conversion','NULL ACCOUNT','2018-05-08 18:10:00',-750000.00),(769,2870,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-05-09 09:24:00',245000.00),(770,2871,'WESTPAC FIJI',2653,0,'Deposit','Nakasi Deposit','2018-05-09 10:34:00',10000.00),(771,2872,'WESTPAC FIJI',2037,0,'Supply','Suva Order','2018-05-09 11:22:00',99000.00),(772,2873,'WESTPAC FIJI',2038,0,'Supply','Suva Order','2018-05-09 12:20:00',125000.00),(773,2874,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-05-09 15:02:00',490000.00),(774,2875,'WESTPAC FIJI',2701,0,'Deposit','University Deposit','2018-05-09 21:16:00',11198.20),(775,2876,'WESTPAC FIJI',2654,0,'Deposit','Nabua Deposit','2018-05-09 11:12:00',40000.00),(776,2877,'WESTPAC FIJI',2655,0,'Deposit','Nabua Deposit','2018-05-09 11:13:00',100000.00),(777,2878,'WESTPAC FIJI',2656,0,'Deposit','Nabua Deposit','2018-05-09 11:13:00',250000.00),(778,2879,'WESTPAC FIJI',2657,0,'Deposit','Nabua Deposit','2018-05-09 11:14:00',500000.00),(779,2880,'WESTPAC FIJI',2658,0,'Deposit','Laucala Deposit','2018-05-09 12:24:00',500000.00),(780,2881,'WESTPAC FIJI',2659,0,'Deposit','Laucala Deposit','2018-05-09 12:24:00',100000.00),(781,2882,'WESTPAC FIJI',2660,0,'Deposit','Laucala Deposit','2018-05-09 12:25:00',250000.00),(782,2883,'WESTPAC FIJI',2661,0,'Deposit','Laucala Deposit','2018-05-09 12:25:00',250000.00),(783,2884,'WESTPAC FIJI',2662,0,'Deposit','Laucala Deposit','2018-05-09 12:26:00',50000.00),(784,2885,'WESTPAC FIJI',2663,0,'Deposit','Nakasi Deposit','2018-05-09 14:39:00',500000.00),(785,2886,'WESTPAC FIJI',2664,0,'Deposit','Nakasi Deposit','2018-05-09 14:41:00',200000.00),(786,2887,'WESTPAC FIJI',2665,0,'Deposit','Nakasi Deposit','2018-05-09 14:42:00',250000.00),(787,2888,'WESTPAC FIJI',2666,0,'Deposit','Nakasi Deposit','2018-05-09 14:42:00',250000.00),(788,2889,'WESTPAC FIJI',2667,0,'Deposit','Nakasi Deposit','2018-05-09 14:43:00',250000.00),(789,2890,'WESTPAC FIJI',2668,0,'Deposit','Nakasi Deposit','2018-05-09 14:44:00',100000.00),(790,2891,'WESTPAC FIJI',2669,0,'Deposit','Nakasi Deposit','2018-05-09 14:45:00',100000.00),(791,2892,'WESTPAC FIJI',2670,0,'Deposit','Nakasi Deposit','2018-05-09 14:46:00',50000.00),(792,2893,'WESTPAC FIJI',2671,0,'Deposit','Nakasi Deposit','2018-05-09 14:46:00',50000.00),(793,2894,'WESTPAC FIJI',2672,0,'Deposit','Nakasi Deposit','2018-05-09 14:47:00',15000.00),(794,2895,'WESTPAC FIJI',2673,0,'Deposit','Suva Deposit','2018-05-09 20:15:00',500000.00),(795,2896,'WESTPAC FIJI',2674,0,'Deposit','Suva Deposit','2018-05-09 20:16:00',500000.00),(796,2897,'WESTPAC FIJI',2675,0,'Deposit','Suva Deposit','2018-05-09 20:16:00',500000.00),(797,2898,'WESTPAC FIJI',2676,0,'Deposit','Suva Deposit','2018-05-09 20:17:00',500000.00),(798,2899,'WESTPAC FIJI',2677,0,'Deposit','Suva Deposit','2018-05-09 20:18:00',500000.00),(799,2900,'WESTPAC FIJI',2678,0,'Deposit','Suva Deposit','2018-05-09 20:19:00',250000.00),(800,2901,'WESTPAC FIJI',2679,0,'Deposit','Suva Deposit','2018-05-09 20:19:00',250000.00),(801,2902,'WESTPAC FIJI',2680,0,'Deposit','Suva Deposit','2018-05-09 20:20:00',250000.00),(802,2903,'WESTPAC FIJI',2681,0,'Deposit','Suva Deposit','2018-05-09 20:20:00',250000.00),(803,2904,'WESTPAC FIJI',2682,0,'Deposit','Suva Deposit','2018-05-09 20:21:00',250000.00),(804,2905,'WESTPAC FIJI',2683,0,'Deposit','Suva Deposit','2018-05-09 20:22:00',250000.00),(805,2906,'WESTPAC FIJI',2684,0,'Deposit','Suva Deposit','2018-05-09 20:22:00',250000.00),(806,2907,'WESTPAC FIJI',2685,0,'Deposit','Suva Deposit','2018-05-09 20:23:00',250000.00),(807,2908,'WESTPAC FIJI',2686,0,'Deposit','Suva Deposit','2018-05-09 20:24:00',250000.00),(808,2909,'WESTPAC FIJI',2687,0,'Deposit','Suva Deposit','2018-05-09 20:25:00',250000.00),(809,2910,'WESTPAC FIJI',2688,0,'Deposit','Suva Deposit','2018-05-09 20:26:00',250000.00),(810,2911,'WESTPAC FIJI',2689,0,'Deposit','Suva Deposit','2018-05-09 20:27:00',100000.00),(811,2912,'WESTPAC FIJI',2690,0,'Deposit','Suva Deposit','2018-05-09 20:28:00',100000.00),(812,2913,'WESTPAC FIJI',2691,0,'Deposit','Suva Deposit','2018-05-09 20:28:00',100000.00),(813,2914,'WESTPAC FIJI',2692,0,'Deposit','Suva Deposit','2018-05-09 20:30:00',100000.00),(814,2915,'WESTPAC FIJI',2693,0,'Deposit','Suva Deposit','2018-05-09 20:31:00',100000.00),(815,2916,'WESTPAC FIJI',2694,0,'Deposit','Suva Deposit','2018-05-09 20:32:00',100000.00),(816,2917,'WESTPAC FIJI',2695,0,'Deposit','Suva Deposit','2018-05-09 20:33:00',50000.00),(817,2918,'WESTPAC FIJI',2696,0,'Deposit','Suva Deposit','2018-05-09 20:34:00',50000.00),(818,2919,'WESTPAC FIJI',2697,0,'Deposit','Suva Deposit','2018-05-09 20:35:00',50000.00),(819,2920,'WESTPAC FIJI',2698,0,'Deposit','Suva Deposit','2018-05-09 20:51:00',50000.00),(820,2921,'WESTPAC FIJI',2699,0,'Deposit','University Deposit','2018-05-09 21:11:00',200000.00),(821,2922,'WESTPAC FIJI',2700,0,'Deposit','University Deposit','2018-05-09 21:11:00',20000.00),(822,2923,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-05-09 22:13:00',522180.00),(823,2924,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-05-09 22:49:00',-1000.00),(824,2925,'WESTPAC FIJI',2924,0,'Cash Conversion','NULL ACCOUNT','2018-05-09 22:49:00',1000.00),(825,2926,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-05-09 22:49:00',-5000.00),(826,2927,'WESTPAC FIJI',2926,0,'Cash Conversion','NULL ACCOUNT','2018-05-09 22:49:00',5000.00),(827,2932,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-05-10 11:00:00',245000.00),(828,2933,'WESTPAC FIJI',0,1,'Supply','ATM Transfer','2018-05-10 11:21:00',2740000.00),(829,2934,'WESTPAC FIJI',2933,0,'Supply','ATM Transfer','2018-05-10 11:40:00',-2740000.00),(830,2935,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-05-10 11:42:00',2735000.00),(831,2936,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-05-10 11:49:00',245000.00),(832,2937,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-05-10 17:42:00',245000.00),(833,2938,'WESTPAC FIJI',2702,0,'Deposit','Suva Deposit','2018-05-10 18:05:00',100000.00),(834,2939,'WESTPAC FIJI',2703,0,'Deposit','Suva Deposit','2018-05-10 18:06:00',200000.00),(835,2940,'WESTPAC FIJI',2704,0,'Deposit','Suva Deposit','2018-05-10 18:07:00',250000.00),(836,2941,'WESTPAC FIJI',2705,0,'Deposit','Suva Deposit','2018-05-10 18:07:00',250000.00),(837,2942,'WESTPAC FIJI',2706,0,'Deposit','Suva Deposit','2018-05-10 18:08:00',250000.00),(838,2943,'WESTPAC FIJI',2707,0,'Deposit','Suva Deposit','2018-05-10 18:08:00',500000.00),(839,2944,'WESTPAC FIJI',2708,0,'Deposit','Suva Deposit','2018-05-10 18:09:00',500000.00),(840,2945,'WESTPAC FIJI',2709,0,'Deposit','Suva Deposit','2018-05-10 18:10:00',50000.00),(841,2946,'WESTPAC FIJI',2710,0,'Deposit','Suva Deposit','2018-05-10 18:10:00',100000.00),(842,2947,'WESTPAC FIJI',2711,0,'Deposit','Suva Deposit','2018-05-10 18:11:00',100000.00),(843,2948,'WESTPAC FIJI',2712,0,'Deposit','Suva Deposit','2018-05-10 18:11:00',250000.00),(844,2949,'WESTPAC FIJI',2713,0,'Deposit','Suva Deposit','2018-05-10 18:12:00',250000.00),(845,2950,'WESTPAC FIJI',2714,0,'Deposit','Suva Deposit','2018-05-10 18:13:00',500000.00),(846,2951,'WESTPAC FIJI',2715,0,'Deposit','Suva Deposit','2018-05-10 18:13:00',50000.00),(847,2952,'WESTPAC FIJI',2716,0,'Deposit','Suva Deposit','2018-05-10 18:13:00',25000.00),(848,2953,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-05-10 19:13:00',21330.00),(849,2958,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-05-11 09:46:00',925000.00),(850,2959,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-05-11 09:57:00',164000.00),(851,2960,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-05-11 14:04:00',340000.00),(852,2961,'WESTPAC FIJI',2717,0,'Deposit','Nausori Deposit','2018-05-11 15:31:00',500000.00),(853,2962,'WESTPAC FIJI',2718,0,'Deposit','Nausori Deposit','2018-05-11 15:32:00',500000.00),(854,2963,'WESTPAC FIJI',2719,0,'Deposit','Nausori Deposit','2018-05-11 15:33:00',250000.00),(855,2964,'WESTPAC FIJI',2720,0,'Deposit','Nausori Deposit','2018-05-11 15:34:00',250000.00),(856,2965,'WESTPAC FIJI',2721,0,'Deposit','Nausori Deposit','2018-05-11 15:34:00',250000.00),(857,2966,'WESTPAC FIJI',2722,0,'Deposit','Nausori Deposit','2018-05-11 15:35:00',250000.00),(858,2967,'WESTPAC FIJI',2723,0,'Deposit','Nausori Deposit','2018-05-11 15:36:00',100000.00),(859,2968,'WESTPAC FIJI',2724,0,'Deposit','Nausori Deposit','2018-05-11 15:36:00',100000.00),(860,2969,'WESTPAC FIJI',2725,0,'Deposit','Nausori Deposit','2018-05-11 15:37:00',100000.00),(861,2970,'WESTPAC FIJI',2726,0,'Deposit','Nausori Deposit','2018-05-11 15:38:00',100000.00),(862,2971,'WESTPAC FIJI',2727,0,'Deposit','Nausori Deposit','2018-05-11 15:39:00',25000.00),(863,2972,'WESTPAC FIJI',2728,0,'Deposit','Nausori Deposit','2018-05-11 15:39:00',50000.00),(864,2973,'WESTPAC FIJI',2729,0,'Deposit','Nausori Deposit','2018-05-11 15:40:00',50000.00),(865,2974,'WESTPAC FIJI',2730,0,'Deposit','Nausori Deposit','2018-05-11 15:41:00',50000.00),(866,2975,'WESTPAC FIJI',2731,0,'Deposit','Nausori Deposit','2018-05-11 15:42:00',50000.00),(867,2976,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-05-11 17:38:00',276230.00),(868,2981,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-05-14 09:28:00',1020000.00),(869,2982,'WESTPAC FIJI',2732,0,'Deposit','Nakasi Deposit','2018-05-14 11:01:00',50000.00),(870,2983,'WESTPAC FIJI',2733,0,'Deposit','Nakasi Deposit','2018-05-14 11:01:00',80000.00),(871,2984,'WESTPAC FIJI',2734,0,'Deposit','Nakasi Deposit','2018-05-14 11:02:00',250000.00),(872,2985,'WESTPAC FIJI',2735,0,'Deposit','Nakasi Deposit','2018-05-14 11:02:00',200000.00),(873,2986,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-05-14 16:42:00',91220.00),(874,2987,'WESTPAC FIJI',2736,0,'Deposit','RBF','2018-05-14 18:16:00',60027.10),(875,2988,'WESTPAC FIJI',2737,0,'Deposit','Nakasi Deposit','2018-05-14 18:20:00',1992.30),(876,2989,'WESTPAC FIJI',2039,0,'Supply','Suva Order','2018-05-14 18:27:00',149000.00),(877,2994,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-05-15 10:18:00',490000.00),(878,2995,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-05-15 10:20:00',585000.00),(879,2996,'WESTPAC FIJI',2041,0,'Supply','Laucala Order','2018-05-15 11:19:00',37000.00),(880,2997,'WESTPAC FIJI',2040,0,'Supply','Laucala Order','2018-05-15 11:29:00',30000.00),(881,2998,'WESTPAC FIJI',0,0,'Supply','ATM Transfer','2018-05-15 11:29:00',245000.00),(882,2999,'WESTPAC FIJI',2043,0,'Supply','RBF','2018-05-15 11:49:00',6975000.00),(883,3000,'WESTPAC FIJI',0,0,'Deposit','ATM Transfer','2018-05-15 15:58:00',1700.00),(884,3001,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-05-15 16:28:00',-600000.00),(885,3002,'WESTPAC FIJI',3001,0,'Cash Conversion','NULL ACCOUNT','2018-05-15 16:28:00',600000.00),(886,3003,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-05-15 16:28:00',-700000.00),(887,3004,'WESTPAC FIJI',3003,0,'Cash Conversion','NULL ACCOUNT','2018-05-15 16:28:00',700000.00),(888,3005,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-05-15 16:29:00',-300000.00),(889,3006,'WESTPAC FIJI',3005,0,'Cash Conversion','NULL ACCOUNT','2018-05-15 16:29:00',300000.00),(890,3007,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-05-15 16:29:00',-200000.00),(891,3008,'WESTPAC FIJI',3007,0,'Cash Conversion','NULL ACCOUNT','2018-05-15 16:29:00',200000.00),(892,3009,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-05-15 16:30:00',-400000.00),(893,3010,'WESTPAC FIJI',3009,0,'Cash Conversion','NULL ACCOUNT','2018-05-15 16:30:00',400000.00),(894,3011,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-05-15 16:30:00',-550000.00),(895,3012,'WESTPAC FIJI',3011,0,'Cash Conversion','NULL ACCOUNT','2018-05-15 16:30:00',550000.00),(896,3013,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-05-15 16:30:00',-300000.00),(897,3014,'WESTPAC FIJI',3013,0,'Cash Conversion','NULL ACCOUNT','2018-05-15 16:30:00',300000.00),(898,3015,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-05-15 16:31:00',-100000.00),(899,3016,'WESTPAC FIJI',3015,0,'Cash Conversion','NULL ACCOUNT','2018-05-15 16:31:00',100000.00),(900,3017,'WESTPAC FIJI',0,0,'Cash Conversion','NULL ACCOUNT','2018-05-15 16:31:00',-25000.00),(901,3018,'WESTPAC FIJI',3017,0,'Cash Conversion','NULL ACCOUNT','2018-05-15 16:31:00',25000.00);

--
-- Table structure for table `woitems`
--

CREATE TABLE `woitems` (
  `wo` int(11) NOT NULL,
  `stockid` char(20) NOT NULL DEFAULT '',
  `qtyreqd` double NOT NULL DEFAULT '1',
  `qtyrecd` double NOT NULL DEFAULT '0',
  `stdcost` double NOT NULL,
  `nextlotsnref` varchar(20) DEFAULT '',
  `comments` longblob,
  PRIMARY KEY (`wo`,`stockid`),
  KEY `stockid` (`stockid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woitems`
--


--
-- Table structure for table `worequirements`
--

CREATE TABLE `worequirements` (
  `wo` int(11) NOT NULL,
  `parentstockid` varchar(20) NOT NULL,
  `stockid` varchar(20) NOT NULL,
  `qtypu` double NOT NULL DEFAULT '1',
  `stdcost` double NOT NULL DEFAULT '0',
  `autoissue` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`wo`,`parentstockid`,`stockid`),
  KEY `stockid` (`stockid`),
  KEY `worequirements_ibfk_3` (`parentstockid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `worequirements`
--


--
-- Table structure for table `workcentres`
--

CREATE TABLE `workcentres` (
  `code` char(5) NOT NULL DEFAULT '',
  `location` char(5) NOT NULL DEFAULT '',
  `description` char(20) NOT NULL DEFAULT '',
  `capacity` double NOT NULL DEFAULT '1',
  `overheadperhour` decimal(10,0) NOT NULL DEFAULT '0',
  `overheadrecoveryact` varchar(20) NOT NULL DEFAULT '0',
  `setuphrs` decimal(10,0) NOT NULL DEFAULT '0',
  PRIMARY KEY (`code`),
  KEY `Description` (`description`),
  KEY `Location` (`location`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `workcentres`
--

INSERT INTO `workcentres` VALUES ('01','SUVA','testing',1,0,'1',0);

--
-- Table structure for table `workorders`
--

CREATE TABLE `workorders` (
  `wo` int(11) NOT NULL,
  `loccode` char(5) NOT NULL DEFAULT '',
  `requiredby` date NOT NULL DEFAULT '0000-00-00',
  `startdate` date NOT NULL DEFAULT '0000-00-00',
  `costissued` double NOT NULL DEFAULT '0',
  `closed` tinyint(4) NOT NULL DEFAULT '0',
  `closecomments` longblob,
  `reference` varchar(40) NOT NULL DEFAULT '',
  `remark` text,
  PRIMARY KEY (`wo`),
  KEY `LocCode` (`loccode`),
  KEY `StartDate` (`startdate`),
  KEY `RequiredBy` (`requiredby`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `workorders`
--

INSERT INTO `workorders` VALUES (1,'SUVA','2016-09-13','2016-09-13',0,0,NULL,'',NULL),(2,'SUVA','2016-10-27','2016-10-27',0,0,NULL,'',NULL);

--
-- Table structure for table `woserialnos`
--

CREATE TABLE `woserialnos` (
  `wo` int(11) NOT NULL,
  `stockid` varchar(20) NOT NULL,
  `serialno` varchar(30) NOT NULL,
  `quantity` double NOT NULL DEFAULT '1',
  `qualitytext` text NOT NULL,
  PRIMARY KEY (`wo`,`stockid`,`serialno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woserialnos`
--


--
-- Table structure for table `www_users`
--

CREATE TABLE `www_users` (
  `userid` varchar(20) NOT NULL DEFAULT '',
  `password` text NOT NULL,
  `realname` varchar(35) NOT NULL DEFAULT '',
  `customerid` varchar(10) NOT NULL DEFAULT '',
  `supplierid` varchar(10) NOT NULL DEFAULT '',
  `salesman` char(3) NOT NULL,
  `phone` varchar(30) NOT NULL DEFAULT '',
  `email` varchar(55) DEFAULT NULL,
  `defaultlocation` varchar(5) NOT NULL DEFAULT '',
  `fullaccess` int(11) NOT NULL DEFAULT '1',
  `cancreatetender` tinyint(1) NOT NULL DEFAULT '0',
  `lastvisitdate` datetime DEFAULT NULL,
  `branchcode` varchar(10) NOT NULL DEFAULT '',
  `pagesize` varchar(20) NOT NULL DEFAULT 'A4',
  `modulesallowed` varchar(25) NOT NULL,
  `showdashboard` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Display dashboard after login',
  `blocked` tinyint(4) NOT NULL DEFAULT '0',
  `displayrecordsmax` int(11) NOT NULL DEFAULT '0',
  `theme` varchar(30) NOT NULL DEFAULT 'fresh',
  `language` varchar(10) NOT NULL DEFAULT 'en_GB.utf8',
  `pdflanguage` tinyint(1) NOT NULL DEFAULT '0',
  `department` int(11) NOT NULL DEFAULT '0',
  `margin_limit` decimal(10,2) NOT NULL,
  PRIMARY KEY (`userid`),
  KEY `CustomerID` (`customerid`),
  KEY `DefaultLocation` (`defaultlocation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `www_users`
--

INSERT INTO `www_users` VALUES ('admin','$2y$10$S1Jh5nawoRoYC0Zk.lRoQ.6n8HjgrGb7jGmonteuHY1jCogoceSqO','E-Business','','','','9223300','sachin@wormaldfj.com','5',65,1,'2019-09-30 09:05:10','','A4','1,1,1,1,1,1,1,1,1,1,1,1,1',0,0,50,'evergreen2','en_US.utf8',0,0,35.00),('ebusiness','$2y$10$1xANu5hjiJq4FwLGZEEKC.8p4gfxpHt8DGewiKT4wXxPlzLSQ67si','training purpose','','','','','sales@ebusinessfiji.com','SUVA',68,0,'2018-01-09 11:40:49','','A4','1,1,1,1,1,1,1,1,1,1,1,1,1',0,0,50,'evergreen2','en_US.utf8',0,0,0.00),('jhairud','$2y$10$oFLuW6BVLl1J52k/aK2qY.1MZzow4/gEVo1B6XCpKNlHLzOuTBXf2','Jhairud','','','','','jhairud@tebarahalalmeatsuva.com','3',65,0,'2019-09-28 09:56:15','','A4','1,1,1,1,1,1,1,1,1,1,1,1,1',0,0,50,'evergreen2','en_US.utf8',0,0,0.00),('sachin','$2y$10$jgczp.cQW7rlCfc971b8SOX6E.DSikhk98naknsqjse3yLnDDX6Wi','Sachin Singh','','','','','sachinebusiness@gmail.com','SUVA',65,1,'2019-09-02 08:07:51','','A4','1,1,1,1,1,1,1,1,1,1,1,1,1',0,0,50,'evergreen2','en_US.utf8',0,0,0.00);


