-- phpMyAdmin SQL Dump
-- version 4.0.8
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 20, 2014 at 01:22 PM
-- Server version: 5.1.72-cll
-- PHP Version: 5.3.17

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `wefixito_WFIT`
--

-- --------------------------------------------------------

--
-- Table structure for table `Payments`
--

CREATE TABLE IF NOT EXISTS `Payments` (
  `Payment ID` int(11) DEFAULT NULL,
  `Payment Date` varchar(255) DEFAULT NULL,
  `Payment Method` varchar(255) DEFAULT NULL,
  `Payment Amount` decimal(18,2) DEFAULT '0.00',
  `PL ID` int(11) DEFAULT NULL,
  `PL Document` varchar(255) DEFAULT NULL,
  `SL ID` int(11) DEFAULT NULL,
  `SL Document` int(11) DEFAULT NULL,
  `Ref 1` varchar(255) DEFAULT NULL,
  `Ref 2` varchar(255) DEFAULT NULL,
  `Cistomer ID` int(11) DEFAULT NULL,
  `in buffer` tinyint(1) DEFAULT '0',
  `poa allocated` tinyint(1) DEFAULT '0',
  `doc` tinyint(1) DEFAULT '0',
  `Proforma ID` int(11) DEFAULT NULL,
  `Estimate ID` int(11) DEFAULT NULL,
  `WO ID` int(11) DEFAULT NULL,
  `wo allocation marker` varchar(255) DEFAULT NULL,
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `devision` varchar(3) NOT NULL,
  `processed by` varchar(225) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `Cistomer ID` (`Cistomer ID`),
  KEY `Estimate ID` (`Estimate ID`),
  KEY `ID` (`ID`),
  KEY `Payment ID` (`Payment ID`),
  KEY `Payment Method` (`Payment Method`),
  KEY `PL ID` (`PL ID`),
  KEY `Proforma ID` (`Proforma ID`),
  KEY `SL Document` (`SL Document`),
  KEY `SL ID` (`SL ID`),
  KEY `WO ID` (`WO ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=153 ;

--
-- Dumping data for table `Payments`
--

INSERT INTO `Payments` (`Payment ID`, `Payment Date`, `Payment Method`, `Payment Amount`, `PL ID`, `PL Document`, `SL ID`, `SL Document`, `Ref 1`, `Ref 2`, `Cistomer ID`, `in buffer`, `poa allocated`, `doc`, `Proforma ID`, `Estimate ID`, `WO ID`, `wo allocation marker`, `ID`, `timestamp`, `devision`, `processed by`) VALUES
(100003, '01/05/2012', 'V', '81.59', 12006, '97380', NULL, NULL, 'Invoice Payment', 'PL12006 97380', 10066, 0, 0, 0, NULL, NULL, NULL, NULL, 1, '2014-01-16 08:14:01', '100', 'DH010010'),
(100004, '03/05/2012', 'V', '25.46', 12007, '9080893272', NULL, NULL, 'Invoice Payment', 'PL12007 9080893272', 10067, 0, 0, 0, NULL, NULL, NULL, NULL, 2, '2014-01-16 08:14:01', '100', 'DH010010'),
(100005, '10/05/2012', 'V', '14.99', 12008, '016591', NULL, NULL, 'Invoice Payment', 'PL12008 016591', 10065, 0, 0, 0, NULL, NULL, NULL, NULL, 3, '2014-01-16 08:14:01', '100', 'DH010010'),
(100006, '10/05/2012', 'V', '47.48', 12010, '016589', NULL, NULL, 'Invoice Payment', 'PL12010 016589', 10065, 0, 0, 0, NULL, NULL, NULL, NULL, 4, '2014-01-16 08:14:01', '100', 'DH010010'),
(100007, '11/05/2012', 'V', '51.59', 12011, '9081606176', NULL, NULL, 'Invoice Payment', 'PL12011 9081606176', 10067, 0, 0, 0, NULL, NULL, NULL, NULL, 5, '2014-01-16 08:14:01', '100', 'DH010010'),
(100008, '01/06/2012', 'V', '9.59', 12012, '100160', NULL, NULL, 'Invoice Payment', 'PL12012 100160', 10066, 0, 0, 0, NULL, NULL, NULL, NULL, 6, '2014-01-16 08:14:01', '100', 'DH010010'),
(100009, '01/07/2012', 'V', '9.59', 12013, '102903', NULL, NULL, 'Invoice Payment', 'PL12013 102903', 10066, 0, 0, 0, NULL, NULL, NULL, NULL, 7, '2014-01-16 08:14:01', '100', 'DH010010'),
(100010, '07/07/2012', 'V', '69.97', 12014, '017254', NULL, NULL, 'Invoice Payment', 'PL12014 017254', 10065, 0, 0, 0, NULL, NULL, NULL, NULL, 8, '2014-01-16 08:14:01', '100', 'DH010010'),
(100011, '12/07/2012', 'V', '52.70', 12015, 'SP-3799911', NULL, NULL, 'Invoice Payment', 'PL12015 SP-3799911', 10075, 0, 0, 0, NULL, NULL, NULL, NULL, 9, '2014-01-16 08:14:01', '100', 'DH010010'),
(100012, '13/07/2012', 'V', '52.70', 12016, 'SP-3808101', NULL, NULL, 'Invoice Payment', 'PL12016 SP-3808101', 10075, 0, 0, 0, NULL, NULL, NULL, NULL, 10, '2014-01-16 08:14:01', '100', 'DH010010'),
(100013, '19/07/2012', 'V', '64.98', 12018, '063273', NULL, NULL, 'Invoice Payment', 'PL12018 063273', 10079, 0, 0, 0, NULL, NULL, NULL, NULL, 11, '2014-01-16 08:14:01', '100', 'DH010010'),
(100014, '22/07/2012', 'V', '50.97', 12019, '207914', NULL, NULL, 'Invoice Payment', 'PL12019 207914', 10065, 0, 0, 0, NULL, NULL, NULL, NULL, 12, '2014-01-16 08:14:01', '100', 'DH010010'),
(100015, '28/07/2012', 'V', '8.39', 12022, '8684654', NULL, NULL, 'Invoice Payment', 'PL12022 8684654', 10084, 0, 0, 0, NULL, NULL, NULL, NULL, 13, '2014-01-16 08:14:01', '100', 'DH010010'),
(100016, '28/07/2012', 'V', '8.39', 12023, 'W127002/96274', NULL, NULL, 'Invoice Payment', 'PL12023 W127002/96274', 10068, 0, 0, 0, NULL, NULL, NULL, NULL, 14, '2014-01-16 08:14:01', '100', 'DH010010'),
(100017, '30/07/2012', 'V', '34.46', 12024, '9088373960', NULL, NULL, 'Invoice Payment', 'PL12024 9088373960', 10067, 0, 0, 0, NULL, NULL, NULL, NULL, 15, '2014-01-16 08:14:01', '100', 'DH010010'),
(100018, '31/07/2012', 'V', '138.32', 12025, '209444', NULL, NULL, 'Invoice Payment', 'PL12025 209444', 10065, 0, 0, 0, NULL, NULL, NULL, NULL, 16, '2014-01-16 08:14:01', '100', 'DH010010'),
(100022, '18/07/2012', 'C', '45.00', NULL, NULL, 12006, 10000000, 'Invoice Payment', 'SL12006 10000000', 10074, 0, 0, 0, NULL, NULL, NULL, NULL, 17, '2014-02-20 11:28:16', '100', 'DH010010'),
(100023, '21/07/2012', 'C', '40.00', NULL, NULL, 12008, 10000002, 'Invoice Payment', 'SL12008 10000002', 10078, 0, 0, 0, NULL, NULL, NULL, NULL, 18, '2014-01-16 08:14:01', '100', 'DH010010'),
(100024, '03/08/2012', 'C', '80.97', NULL, NULL, 12009, 10000003, 'Invoice Payment', 'SL12009 10000003', 10080, 0, 0, 0, NULL, NULL, NULL, NULL, 19, '2014-01-16 08:14:01', '100', 'DH010010'),
(100025, '23/07/2012', 'V', '4.99', 12028, '208053', NULL, NULL, 'Invoice Payment', 'PL12028 208053', 10065, 0, 0, 0, NULL, NULL, NULL, NULL, 20, '2014-01-16 08:14:01', '100', 'DH010010'),
(100026, '23/07/2012', 'V', '6.99', 12029, '208052', NULL, NULL, 'Invoice Payment', 'PL12029 208052', 10065, 0, 0, 0, NULL, NULL, NULL, NULL, 21, '2014-01-16 08:14:01', '100', 'DH010010'),
(100027, '24/07/2012', 'V', '19.98', 12030, '95918770GC8030822', NULL, NULL, 'Invoice Payment', 'PL12030 95918770GC8030822', 10082, 0, 0, 0, NULL, NULL, NULL, NULL, 22, '2014-01-16 08:14:01', '100', 'DH010010'),
(100028, '24/07/2012', 'V', '39.99', 12031, '6P9010040Y253112H', NULL, NULL, 'Invoice Payment', 'PL12031 6P9010040Y253112H', 10083, 0, 0, 0, NULL, NULL, NULL, NULL, 23, '2014-01-16 08:14:01', '100', 'DH010010'),
(100029, '09/08/2012', 'V', '-39.99', 12032, '6P9010040Y253112H', NULL, NULL, 'Invoice Payment', 'PL12032 6P9010040Y253112H', 10083, 0, 0, 0, NULL, NULL, NULL, NULL, 24, '2014-01-16 08:14:01', '100', 'DH010010'),
(100030, '06/08/2012', 'C', '120.97', NULL, NULL, NULL, NULL, 'TRA', NULL, NULL, 0, 0, 0, NULL, NULL, NULL, NULL, 25, '2014-01-16 08:14:01', '100', 'DH010010'),
(100031, '28/04/2012', 'B', '769.02', NULL, NULL, NULL, NULL, 'Capital Introduced', NULL, 10071, 0, 0, 0, NULL, NULL, NULL, NULL, 26, '2014-01-16 08:14:01', '100', 'DH010010'),
(100037, '04/08/2012', 'V', '30.98', 12033, '6MC88536F9251831W', NULL, NULL, 'Invoice Payment', 'PL12033 6MC88536F9251831W', 10085, 0, 0, 0, NULL, NULL, NULL, NULL, 27, '2014-01-16 08:14:01', '100', 'DH010010'),
(100038, '04/08/2012', 'B', '30.98', NULL, NULL, NULL, NULL, 'Capital Introduced', NULL, 10071, 0, 0, 0, NULL, NULL, NULL, NULL, 28, '2014-01-16 08:14:01', '100', 'DH010010'),
(100039, '27/08/2012', 'C', '10.00', NULL, NULL, 12012, 10000006, 'Invoice Payment', 'SL12012 10000006', 10087, 0, 0, 0, NULL, NULL, NULL, NULL, 29, '2014-01-16 08:14:01', '100', 'DH010010'),
(100040, '27/08/2012', 'C', '20.00', NULL, NULL, 12013, 10000007, 'Invoice Payment', 'SL12013 10000007', 10088, 0, 0, 0, NULL, NULL, NULL, NULL, 30, '2014-01-16 08:14:01', '100', 'DH010010'),
(100041, '09/08/2012', 'B', '70.89', NULL, NULL, NULL, NULL, 'Capital Introduced', NULL, 10071, 0, 0, 0, NULL, NULL, NULL, NULL, 31, '2014-01-16 08:14:01', '100', 'DH010010'),
(100042, '27/08/2012', 'V', '5.00', NULL, NULL, NULL, NULL, 'TRA', NULL, NULL, 0, 0, 0, NULL, NULL, NULL, NULL, 32, '2014-01-16 08:14:01', '100', 'DH010010'),
(100043, '09/08/2012', 'V', '65.89', 12034, '3C737851KU321951E', NULL, NULL, 'Invoice Payment', 'PL12034 3C737851KU321951E', 10089, 0, 0, 0, NULL, NULL, NULL, NULL, 33, '2014-01-16 08:14:01', '100', 'DH010010'),
(100103, '20/03/2013', 'B', '-36.55', 12087, '01/12/2012-28/02/2013', NULL, NULL, 'Invoice Payment', 'PL12087 01/12/2012-28/02/2013', 10095, 0, 0, 0, NULL, NULL, NULL, NULL, 34, '2014-01-16 08:14:01', '100', 'DH010010'),
(100104, '01/06/2013', 'V', '41.97', 12088, '1254858875A', NULL, NULL, 'Invoice Payment', 'PL12088 1254858875A', 10100, 0, 0, 0, NULL, NULL, NULL, NULL, 35, '2014-01-16 08:14:01', '100', 'DH010010'),
(100105, '01/06/2013', 'C', '55.77', NULL, NULL, 12025, 10000019, 'Invoice Payment', 'SL12025 10000019', 10099, 0, 0, 0, NULL, NULL, NULL, NULL, 36, '2014-01-16 08:14:01', '100', 'DH010010'),
(100106, '01/06/2013', 'B', '4.77', 12089, '523652458', NULL, NULL, 'Invoice Payment', 'PL12089 523652458', 10103, 0, 0, 0, NULL, NULL, NULL, NULL, 37, '2014-01-16 08:14:01', '100', 'DH010010'),
(100044, '01/08/2012', 'B', '15.90', NULL, NULL, NULL, NULL, 'Capital Introduced', NULL, 10071, 0, 0, 0, NULL, NULL, NULL, NULL, 38, '2014-01-16 08:14:01', '100', 'DH010010'),
(100045, '01/08/2012', 'V', '15.90', 12035, '4402987421', NULL, NULL, 'Invoice Payment', 'PL12035 4402987421', 10093, 0, 0, 0, NULL, NULL, NULL, NULL, 39, '2014-01-16 08:14:01', '100', 'DH010010'),
(100046, '28/08/2012', 'V', '8.39', 12036, 'W128665/96274', NULL, NULL, 'Invoice Payment', 'PL12036 W128665/96274', 10068, 0, 0, 0, NULL, NULL, NULL, NULL, 40, '2014-01-16 08:14:01', '100', 'DH010010'),
(100047, '29/08/2012', 'C', '20.00', NULL, NULL, 12015, 10000009, 'Invoice Payment', 'SL12015 10000009', 10090, 0, 0, 0, NULL, NULL, NULL, NULL, 41, '2014-01-16 08:14:01', '100', 'DH010010'),
(100048, '30/08/2012', 'C', '10.00', NULL, NULL, 12012, 10000006, 'Invoice Payment', 'SL12012 10000006', 10087, 0, 0, 0, NULL, NULL, NULL, NULL, 42, '2014-01-16 08:14:01', '100', 'DH010010'),
(100049, '31/08/2012', 'P', '2.00', NULL, NULL, 12016, 10000010, 'Invoice Payment', 'SL12016 10000010', 10094, 0, 0, 0, NULL, NULL, NULL, NULL, 43, '2014-01-16 08:14:01', '100', 'DH010010'),
(100050, '05/09/2012', 'C', '60.00', NULL, NULL, NULL, NULL, 'TRA', NULL, NULL, 0, 0, 0, NULL, NULL, NULL, NULL, 44, '2014-01-16 08:14:01', '100', 'DH010010'),
(100051, '01/08/2012', 'V', '9.62', 12037, '105729', NULL, NULL, 'Invoice Payment', 'PL12037 105729', 10066, 0, 0, 0, NULL, NULL, NULL, NULL, 45, '2014-01-16 08:14:01', '100', 'DH010010'),
(100052, '01/09/2012', 'V', '9.59', 12038, '108511', NULL, NULL, 'Invoice Payment', 'PL12038 108511', 10066, 0, 0, 0, NULL, NULL, NULL, NULL, 46, '2014-01-16 08:14:01', '100', 'DH010010'),
(100053, '06/09/2012', 'C', '40.00', NULL, NULL, NULL, NULL, 'TRA', NULL, NULL, 0, 0, 0, NULL, NULL, NULL, NULL, 47, '2014-01-16 08:14:01', '100', 'DH010010'),
(100054, '10/09/2012', 'C', '10.00', NULL, NULL, NULL, NULL, 'TRA', NULL, NULL, 0, 0, 0, NULL, NULL, NULL, NULL, 48, '2014-01-16 08:14:01', '100', 'DH010010'),
(100055, '10/09/2012', 'B', '10.00', NULL, NULL, NULL, NULL, 'Capital Introduced', NULL, 10071, 0, 0, 0, NULL, NULL, NULL, NULL, 49, '2014-01-16 08:14:01', '100', 'DH010010'),
(100056, '31/08/2012', 'B', '-119.68', 12039, '01/04/2012-31/08/2012', NULL, NULL, 'Invoice Payment', 'PL12039 01/04/2012-31/08/2012', 10095, 0, 0, 0, NULL, NULL, NULL, NULL, 50, '2014-01-16 08:14:01', '100', 'DH010010'),
(100057, '05/09/2012', 'V', '7.59', 12040, 'ID2TB084069Y6009836', NULL, NULL, 'Invoice Payment', 'PL12040 ID2TB084069Y6009836', 10096, 0, 0, 0, NULL, NULL, NULL, NULL, 51, '2014-01-16 08:14:01', '100', 'DH010010'),
(100058, '05/09/2012', 'V', '17.99', 12042, 'ID3W6098501F418280B', NULL, NULL, 'Invoice Payment', 'PL12042 ID3W6098501F418280B', 10101, 0, 0, 0, NULL, NULL, NULL, NULL, 52, '2014-01-16 08:14:01', '100', 'DH010010'),
(100059, '06/09/2012', 'V', '31.25', 12043, 'ID3A1877135K421934G', NULL, NULL, 'Invoice Payment', 'PL12043 ID3A1877135K421934G', 10102, 0, 0, 0, NULL, NULL, NULL, NULL, 53, '2014-01-16 08:14:01', '100', 'DH010010'),
(100060, '06/09/2012', 'V', '29.98', 12044, 'ID6LK93486U0440842C', NULL, NULL, 'Invoice Payment', 'PL12044 ID6LK93486U0440842C', 10104, 0, 0, 0, NULL, NULL, NULL, NULL, 54, '2014-01-16 08:14:01', '100', 'DH010010'),
(100061, '06/09/2012', 'V', '27.99', 12045, 'ID4NH211407B6442211', NULL, NULL, 'Invoice Payment', 'PL12045 ID4NH211407B6442211', 10105, 0, 0, 0, NULL, NULL, NULL, NULL, 55, '2014-01-16 08:14:01', '100', 'DH010010'),
(100062, '10/09/2012', 'V', '32.50', 12046, 'ID9PM32017HF296150N', NULL, NULL, 'Invoice Payment', 'PL12046 ID9PM32017HF296150N', 10106, 0, 0, 0, NULL, NULL, NULL, NULL, 56, '2014-01-16 08:14:01', '100', 'DH010010'),
(100063, '13/12/2012', 'B', '151.41', NULL, NULL, 12017, 10000011, 'Invoice Payment', 'SL12017 10000011', 10123, 0, 0, 0, NULL, NULL, NULL, NULL, 57, '2014-01-16 08:14:01', '100', 'DH010010'),
(100064, '15/09/2012', 'C', '30.98', NULL, NULL, 12014, 10000008, 'Invoice Payment', 'SL12014 10000008', 10063, 0, 0, 0, NULL, NULL, NULL, NULL, 58, '2014-01-16 08:14:01', '100', 'DH010010'),
(100065, '13/12/2012', 'C', '30.00', NULL, NULL, 12019, 10000013, 'Invoice Payment', 'SL12019 10000013', 10074, 0, 0, 0, NULL, NULL, NULL, NULL, 59, '2014-01-16 08:14:01', '100', 'DH010010'),
(100066, '14/12/2012', 'C', '65.00', NULL, NULL, 12020, 10000014, 'Invoice Payment', 'SL12020 10000014', 10124, 0, 0, 0, NULL, NULL, NULL, NULL, 60, '2014-01-16 08:14:01', '100', 'DH010010'),
(100067, '01/10/2012', 'V', '9.72', 12049, '111348', NULL, NULL, 'Invoice Payment', 'PL12049 111348', 10066, 0, 0, 0, NULL, NULL, NULL, NULL, 61, '2014-01-16 08:14:01', '100', 'DH010010'),
(100068, '01/11/2012', 'V', '117.95', 12051, '114168', NULL, NULL, 'Invoice Payment', 'PL12051 114168', 10066, 0, 0, 0, NULL, NULL, NULL, NULL, 62, '2014-01-16 08:14:01', '100', 'DH010010'),
(100069, '28/09/2012', 'V', '8.39', 12054, 'W130554/96274', NULL, NULL, 'Invoice Payment', 'PL12054 W130554/96274', 10068, 0, 0, 0, NULL, NULL, NULL, NULL, 63, '2014-01-16 08:14:01', '100', 'DH010010'),
(100070, '28/10/2012', 'V', '8.39', 12055, 'W132371/96274', NULL, NULL, 'Invoice Payment', 'PL12055 W132371/96274', 10068, 0, 0, 0, NULL, NULL, NULL, NULL, 64, '2014-01-16 08:14:01', '100', 'DH010010'),
(100092, '01/01/2013', 'B', '9.90', 12083, '119713', NULL, NULL, 'Invoice Payment', 'PL12083 119713', 10066, 0, 0, 0, NULL, NULL, NULL, NULL, 65, '2014-01-16 08:14:01', '100', 'DH010010'),
(100093, '01/02/2013', 'V', '10.01', 12084, '122599', NULL, NULL, 'Invoice Payment', 'PL12084 122599', 10066, 0, 0, 0, NULL, NULL, NULL, NULL, 66, '2014-01-16 08:14:01', '100', 'DH010010'),
(100094, '01/03/2013', 'B', '9.69', 12085, '125320', NULL, NULL, 'Invoice Payment', 'PL12085 125320', 10066, 0, 0, 0, NULL, NULL, NULL, NULL, 67, '2014-01-16 08:14:01', '100', 'DH010010'),
(100095, '01/12/2012', 'B', '21.65', 12086, '116974', NULL, NULL, 'Invoice Payment', 'PL12086 116974', 10066, 0, 0, 0, NULL, NULL, NULL, NULL, 68, '2014-01-16 08:14:01', '100', 'DH010010'),
(100096, '01/12/2012', 'C', '200.98', NULL, NULL, NULL, NULL, 'TRA', NULL, NULL, 0, 0, 0, NULL, NULL, NULL, NULL, 69, '2014-01-16 08:14:01', '100', 'DH010010'),
(100097, '01/12/2012', 'B', '428.56', NULL, NULL, NULL, NULL, 'Capital Introduced', NULL, 10071, 0, 0, 0, NULL, NULL, NULL, NULL, 70, '2014-01-16 08:14:01', '100', 'DH010010'),
(100100, '01/01/2012', 'B', '-0.27', NULL, NULL, NULL, NULL, 'BSA', 'Account Charges', NULL, 0, 0, 0, NULL, NULL, NULL, NULL, 71, '2014-01-16 08:14:01', '100', 'DH010010'),
(100100, '01/01/2012', 'B', '0.27', NULL, NULL, NULL, NULL, 'BSA', 'Account Charges', NULL, 0, 0, 0, NULL, NULL, NULL, NULL, 72, '2014-01-16 08:14:01', '100', 'DH010010'),
(100071, '28/11/2012', 'V', '8.39', 12056, 'W134360/96274', NULL, NULL, 'Invoice Payment', 'PL12056 W134360/96274', 10068, 0, 0, 0, NULL, NULL, NULL, NULL, 73, '2014-01-16 08:14:01', '100', 'DH010010'),
(100072, '10/01/2013', 'C', '30.00', NULL, NULL, 12021, 10000015, 'Invoice Payment', 'SL12021 10000015', 10126, 0, 0, 0, NULL, NULL, NULL, NULL, 74, '2014-01-16 08:14:01', '100', 'DH010010'),
(100101, '09/05/2013', 'C', '10.00', NULL, NULL, 12023, 10000017, 'Invoice Payment', 'SL12023 10000017', 10076, 0, 0, 0, NULL, NULL, NULL, NULL, 75, '2014-01-16 08:14:01', '100', 'DH010010'),
(100102, '14/05/2013', 'C', '20.00', NULL, NULL, 12024, 10000018, 'Invoice Payment', 'SL12024 10000018', 10133, 0, 0, 0, NULL, NULL, NULL, NULL, 76, '2014-01-16 08:14:01', '100', 'DH010010'),
(100073, '13/12/2012', 'C', '45.00', NULL, NULL, 12018, 10000012, 'Invoice Payment', 'SL12018 10000012', 10122, 0, 0, 0, NULL, NULL, NULL, NULL, 77, '2014-01-16 08:14:01', '100', 'DH010010'),
(100074, '18/03/2013', 'V', '34.50', 12065, 'WHUK2009-108190', NULL, NULL, 'Invoice Payment', 'PL12065 WHUK2009-108190', 10132, 0, 0, 0, NULL, NULL, NULL, NULL, 78, '2014-01-16 08:14:01', '100', 'DH010010'),
(100075, '01/12/2012', 'V', '37.48', 12066, 'WHUK2009-93468', NULL, NULL, 'Invoice Payment', 'PL12066 WHUK2009-93468', 10132, 0, 0, 0, NULL, NULL, NULL, NULL, 79, '2014-01-16 08:14:01', '100', 'DH010010'),
(100076, '01/12/2012', 'V', '10.00', 12068, 'WHUK2009-93561', NULL, NULL, 'Invoice Payment', 'PL12068 WHUK2009-93561', 10132, 0, 0, 0, NULL, NULL, NULL, NULL, 80, '2014-01-16 08:14:01', '100', 'DH010010'),
(100077, '01/12/2012', 'V', '7.49', 12070, 'WHUK2009-94345', NULL, NULL, 'Invoice Payment', 'PL12070 WHUK2009-94345', 10132, 0, 0, 0, NULL, NULL, NULL, NULL, 81, '2014-01-16 08:14:01', '100', 'DH010010'),
(100078, '05/01/2013', 'V', '10.00', 12072, 'WHUK2009-101874', NULL, NULL, 'Invoice Payment', 'PL12072 WHUK2009-101874', 10132, 0, 0, 0, NULL, NULL, NULL, NULL, 82, '2014-01-16 08:14:01', '100', 'DH010010'),
(100079, '28/12/2012', 'V', '8.39', 12073, 'W136113/96274', NULL, NULL, 'Invoice Payment', 'PL12073 W136113/96274', 10068, 0, 0, 0, NULL, NULL, NULL, NULL, 83, '2014-01-16 08:14:01', '100', 'DH010010'),
(100080, '01/12/2012', 'V', '8.39', 12074, 'W138072/96274', NULL, NULL, 'Invoice Payment', 'PL12074 W138072/96274', 10068, 0, 0, 0, NULL, NULL, NULL, NULL, 84, '2014-01-16 08:14:01', '100', 'DH010010'),
(100081, '28/02/2013', 'V', '8.39', 12075, 'W140368/96274', NULL, NULL, 'Invoice Payment', 'PL12075 W140368/96274', 10068, 0, 0, 0, NULL, NULL, NULL, NULL, 85, '2014-01-16 08:14:01', '100', 'DH010010'),
(100082, '05/12/2012', 'V', '-51.64', 12057, '01/09/2012-30/11/2012', NULL, NULL, 'Invoice Payment', 'PL12057 01/09/2012-30/11/2012', 10095, 0, 0, 0, NULL, NULL, NULL, NULL, 86, '2014-01-16 08:14:01', '100', 'DH010010'),
(100083, '01/12/2012', 'V', '243.07', 12081, 'Dummy - 00000001', NULL, NULL, 'Invoice Payment', 'PL12081 Dummy - 00000001', 10071, 0, 0, 0, NULL, NULL, NULL, NULL, 87, '2014-01-16 08:14:01', '100', 'DH010010'),
(100084, '21/03/2013', 'V', '78.47', 12063, 'PRSIN102943', NULL, NULL, 'Invoice Payment', 'PL12063 PRSIN102943', 10131, 0, 0, 0, NULL, NULL, NULL, NULL, 88, '2014-01-16 08:14:01', '100', 'DH010010'),
(100085, '22/03/2013', 'V', '21.44', 12062, 'PRSIN102981', NULL, NULL, 'Invoice Payment', 'PL12062 PRSIN102981', 10131, 0, 0, 0, NULL, NULL, NULL, NULL, 89, '2014-01-16 08:14:01', '100', 'DH010010'),
(100086, '01/12/2012', 'V', '9.99', 12077, '199645', NULL, NULL, 'Invoice Payment', 'PL12077 199645', 10065, 0, 0, 0, NULL, NULL, NULL, NULL, 90, '2014-01-16 08:14:01', '100', 'DH010010'),
(100087, '01/12/2012', 'V', '39.99', 12078, '086369', NULL, NULL, 'Invoice Payment', 'PL12078 086369', 10065, 0, 0, 0, NULL, NULL, NULL, NULL, 91, '2014-01-16 08:14:01', '100', 'DH010010'),
(100088, '01/12/2012', 'V', '34.99', 12079, '208152', NULL, NULL, 'Invoice Payment', 'PL12079 208152', 10065, 0, 0, 0, NULL, NULL, NULL, NULL, 92, '2014-01-16 08:14:01', '100', 'DH010010'),
(100089, '01/12/2012', 'V', '10.79', 12076, '9154319', NULL, NULL, 'Invoice Payment', 'PL12076 9154319', 10084, 0, 0, 0, NULL, NULL, NULL, NULL, 93, '2014-01-16 08:14:01', '100', 'DH010010'),
(100090, '08/12/2012', 'V', '69.97', 12047, '192839', NULL, NULL, 'Invoice Payment', 'PL12047 192839', 10065, 0, 0, 0, NULL, NULL, NULL, NULL, 94, '2014-01-16 08:14:01', '100', 'DH010010'),
(100091, '05/01/2013', 'B', '63.60', 12061, '110636085709310075', NULL, NULL, 'Invoice Payment', 'PL12061 110636085709310075', 10095, 0, 0, 0, NULL, NULL, NULL, NULL, 95, '2014-01-16 08:14:01', '100', 'DH010010'),
(100000, '28/04/2012', 'V', '11.99', 12003, 'W122009/96274', NULL, NULL, 'Invoice Payment', 'PL12003 W122009/96274', 10068, 0, 0, 0, NULL, NULL, NULL, NULL, 96, '2014-01-16 08:14:01', '100', 'DH010010'),
(100001, '28/04/2012', 'V', '52.12', 12004, 'W122010/96278', NULL, NULL, 'Invoice Payment', 'PL12004 W122010/96278', 10068, 0, 0, 0, NULL, NULL, NULL, NULL, 97, '2014-01-16 08:14:01', '100', 'DH010010'),
(100002, '28/04/2012', 'V', '30.95', 12005, '97375', NULL, NULL, 'Invoice Payment', 'PL12005 97375', 10066, 0, 0, 0, NULL, NULL, NULL, NULL, 98, '2014-01-16 08:14:01', '100', 'DH010010'),
(100107, '30/04/2013', 'B', '7.99', 12090, 'C30813-1', NULL, NULL, 'Invoice Payment', 'PL12090 C30813-1', 10066, 0, 0, 0, NULL, NULL, NULL, NULL, 99, '2014-01-16 08:14:01', '100', 'DH010010'),
(100108, '31/05/2013', 'B', '9.38', 12091, 'C30813-2', NULL, NULL, 'Invoice Payment', 'PL12091 C30813-2', 10066, 0, 0, 0, NULL, NULL, NULL, NULL, 100, '2014-01-16 08:14:01', '100', 'DH010010'),
(100109, '15/06/2013', 'C', '40.00', NULL, NULL, 12026, 10000020, 'Invoice Payment', 'SL12026 10000020', 10074, 0, 0, 0, NULL, NULL, NULL, NULL, 101, '2014-01-16 08:14:01', '100', 'DH010010'),
(100110, '18/06/2013', 'C', '125.77', NULL, NULL, NULL, NULL, 'TRA', NULL, NULL, 0, 0, 0, NULL, NULL, NULL, NULL, 102, '2014-01-16 08:14:01', '100', 'DH010010'),
(100111, '19/06/2013', 'Q', '50.00', NULL, NULL, 12027, 10000021, 'Invoice Payment', 'SL12027 10000021', 10136, 0, 0, 0, NULL, NULL, NULL, NULL, 103, '2014-01-16 08:14:01', '100', 'DH010010'),
(100112, '20/06/2013', 'B', '-19.22', 12092, '01/03/2013-31/05/2013', NULL, NULL, 'Invoice Payment', 'PL12092 01/03/2013-31/05/2013', 10095, 0, 0, 0, NULL, NULL, NULL, NULL, 104, '2014-01-16 08:14:01', '100', 'DH010010'),
(100113, '31/05/2013', 'V', '30.24', 12095, 'PRSIN104694', NULL, NULL, 'Invoice Payment', 'PL12095 PRSIN104694', 10131, 0, 0, 0, NULL, NULL, NULL, NULL, 105, '2014-01-16 08:14:01', '100', 'DH010010'),
(100114, '20/06/2013', 'V', '3.50', 12094, '53063793KL934281S', NULL, NULL, 'Invoice Payment', 'PL12094 53063793KL934281S', 10137, 0, 0, 0, NULL, NULL, NULL, NULL, 106, '2014-01-16 08:14:01', '100', 'DH010010'),
(100115, '13/07/2013', 'O', '-68.90', 12098, '110689085709310077', NULL, NULL, 'Contra', 'PL12093 110689085709310077', 10095, 0, 0, 0, NULL, NULL, NULL, NULL, 107, '2014-01-16 08:14:01', '100', 'DH010010'),
(100115, '13/07/2013', 'O', '68.90', 12093, '110689085709310077', NULL, NULL, 'Contra', 'PL12098 110689085709310077', 10095, 0, 0, 0, NULL, NULL, NULL, NULL, 108, '2014-01-16 08:14:01', '100', 'DH010010'),
(100116, '13/07/2013', 'Q', '-68.90', 12099, '110636085709310075', NULL, NULL, 'Invoice Payment', 'PL12099 110636085709310075', 10095, 0, 0, 0, NULL, NULL, NULL, NULL, 109, '2014-01-16 08:14:01', '100', 'DH010010'),
(100117, '15/08/2013', 'C', '125.40', NULL, NULL, 12028, 10000022, 'Invoice Payment', 'SL12028 10000022', 10135, 0, 0, 0, NULL, NULL, NULL, NULL, 110, '2014-01-16 08:14:01', '100', 'DH010010'),
(100118, '15/08/2013', 'P', '9.50', NULL, NULL, NULL, NULL, 'Payment On Account', '107371601R279745G', 10130, 0, 1, 0, NULL, NULL, NULL, NULL, 111, '2014-01-16 08:14:01', '100', 'DH010010'),
(100119, '15/08/2013', 'O', '9.50', NULL, NULL, 12029, 10000023, 'Contra', 'SL10000023', 10130, 0, 0, 0, NULL, NULL, NULL, NULL, 112, '2014-01-16 08:14:01', '100', 'DH010010'),
(100120, '20/08/2013', 'P', '30.00', NULL, NULL, 12031, 10000025, 'Invoice Payment', 'SL12031 10000025', 10142, 0, 0, 0, NULL, NULL, NULL, NULL, 113, '2014-01-16 08:14:01', '100', 'DH010010'),
(100121, '26/08/2013', 'C', '20.00', NULL, NULL, 12032, 10000026, 'Invoice Payment', 'SL12032 10000026', 10144, 0, 0, 0, NULL, NULL, NULL, NULL, 114, '2014-01-16 08:14:01', '100', 'DH010010'),
(100122, '26/08/2013', 'C', '40.00', NULL, NULL, 12033, 10000027, 'Invoice Payment', 'SL12033 10000027', 10078, 0, 0, 0, NULL, NULL, NULL, NULL, 115, '2014-01-16 08:14:01', '100', 'DH010010'),
(100123, '30/08/2013', 'C', '20.00', NULL, NULL, 12034, 10000028, 'Invoice Payment', 'SL12034 10000028', 10145, 0, 0, 0, NULL, NULL, NULL, NULL, 116, '2014-01-16 08:14:01', '100', 'DH010010'),
(100124, '26/09/2013', 'B', '25.46', 12112, '01/06/2013-31/08/2013', NULL, NULL, 'Invoice Payment', 'PL12112 01/06/2013-31/08/2013', 10095, 0, 0, 0, NULL, NULL, NULL, NULL, 117, '2014-01-16 08:14:01', '100', 'DH010010'),
(100127, '03/11/2013', 'C', '19.78', NULL, NULL, 12035, 10000029, 'Invoice Payment', 'SL12035 10000029', 10124, 0, 0, 0, NULL, NULL, NULL, NULL, 118, '2014-01-16 08:14:01', '100', 'DH010010'),
(100128, '13/11/2013', 'C', '10.00', NULL, NULL, 12037, 10000031, 'Invoice Payment', 'SL12037 10000031', 10154, 0, 0, 0, NULL, NULL, NULL, NULL, 119, '2014-01-16 08:14:01', '100', 'DH010010'),
(100129, '16/11/2013', 'C', '100.00', NULL, NULL, 12038, 10000032, 'Invoice Payment', 'SL12038 10000032', 10156, 0, 0, 0, NULL, NULL, NULL, NULL, 120, '2014-01-16 08:14:01', '100', 'DH010010'),
(100130, '04/12/2013', 'V', '1.16', 12063, 'PRSIN102943', NULL, NULL, 'Invoice Payment', 'PL12063 PRSIN102943', 10131, 0, 0, 0, NULL, NULL, NULL, NULL, 121, '2014-01-16 08:14:01', '100', 'DH010010'),
(100131, '04/12/2013', 'V', '14.99', 12096, '198368', NULL, NULL, 'Invoice Payment', 'PL12096 198368', 10065, 0, 0, 0, NULL, NULL, NULL, NULL, 122, '2014-01-16 08:14:01', '100', 'DH010010'),
(100132, '04/12/2013', 'V', '25.00', 12097, '005427', NULL, NULL, 'Invoice Payment', 'PL12097 005427', 10138, 0, 0, 0, NULL, NULL, NULL, NULL, 123, '2014-01-16 08:14:01', '100', 'DH010010'),
(100133, '04/12/2013', 'V', '-61.95', 12100, '262245210N871912W', NULL, NULL, 'Invoice Payment', 'PL12100 262245210N871912W', 10139, 0, 0, 0, NULL, NULL, NULL, NULL, 124, '2014-01-16 08:14:01', '100', 'DH010010'),
(100134, '04/12/2013', 'V', '61.95', 12101, '262245210N871912W', NULL, NULL, 'Invoice Payment', 'PL12101 262245210N871912W', 10139, 0, 0, 0, NULL, NULL, NULL, NULL, 125, '2014-01-16 08:14:01', '100', 'DH010010'),
(100135, '04/12/2013', 'V', '90.00', 12102, '0CM74396PX229164H', NULL, NULL, 'Invoice Payment', 'PL12102 0CM74396PX229164H', 10141, 0, 0, 0, NULL, NULL, NULL, NULL, 126, '2014-01-16 08:14:01', '100', 'DH010010'),
(100136, '04/12/2013', 'V', '5.22', 12103, '12009490', NULL, NULL, 'Invoice Payment', 'PL12103 12009490', 10084, 0, 0, 0, NULL, NULL, NULL, NULL, 127, '2014-01-16 08:14:01', '100', 'DH010010'),
(100137, '04/12/2013', 'V', '-17.00', 12104, '0CM74396PX229164H', NULL, NULL, 'Invoice Payment', 'PL12104 0CM74396PX229164H', 10141, 0, 0, 0, NULL, NULL, NULL, NULL, 128, '2014-01-16 08:14:01', '100', 'DH010010'),
(100138, '04/12/2013', 'V', '39.88', 12107, '9FS077847M3690234', NULL, NULL, 'Invoice Payment', 'PL12107 9FS077847M3690234', 10149, 0, 0, 0, NULL, NULL, NULL, NULL, 129, '2014-01-16 08:14:01', '100', 'DH010010'),
(100139, '04/12/2013', 'V', '99.00', 12108, 'BV11178146', NULL, NULL, 'Invoice Payment', 'PL12108 BV11178146', 10150, 0, 0, 0, NULL, NULL, NULL, NULL, 130, '2014-01-16 08:14:01', '100', 'DH010010'),
(100140, '04/12/2013', 'V', '7.99', 12109, 'C30813-3', NULL, NULL, 'Invoice Payment', 'PL12109 C30813-3', 10066, 0, 0, 0, NULL, NULL, NULL, NULL, 131, '2014-01-16 08:14:01', '100', 'DH010010'),
(100141, '04/12/2013', 'V', '7.99', 12110, 'C30813-4', NULL, NULL, 'Invoice Payment', 'PL12110 C30813-4', 10066, 0, 0, 0, NULL, NULL, NULL, NULL, 132, '2014-01-16 08:14:01', '100', 'DH010010'),
(100142, '04/12/2013', 'V', '7.99', 12111, 'C30813-5', NULL, NULL, 'Invoice Payment', 'PL12111 C30813-5', 10066, 0, 0, 0, NULL, NULL, NULL, NULL, 133, '2014-01-16 08:14:01', '100', 'DH010010'),
(100143, '04/12/2013', 'P', '46.00', 12113, '80X9565656NS026040K', NULL, NULL, 'Invoice Payment', 'PL12113 80X9565656NS026040K', 10157, 0, 0, 0, NULL, NULL, NULL, NULL, 134, '2014-01-16 08:14:01', '100', 'DH010010'),
(100144, '07/12/2013', 'C', '20.00', NULL, NULL, 12036, 10000030, 'Invoice Payment', 'SL12036 10000030', 10121, 0, 0, 0, NULL, NULL, NULL, NULL, 135, '2014-01-16 08:14:01', '100', 'DH010010'),
(100145, '07/12/2013', 'V', '8.79', 12114, '033020193', NULL, NULL, 'Invoice Payment', 'PL12114 033020193', 10093, 0, 0, 0, NULL, NULL, NULL, NULL, 136, '2014-01-16 08:14:01', '100', 'DH010010'),
(100146, '07/12/2013', 'V', '8.79', 12115, '033034478', NULL, NULL, 'Invoice Payment', 'PL12115 033034478', 10093, 0, 0, 0, NULL, NULL, NULL, NULL, 137, '2014-01-16 08:14:01', '100', 'DH010010'),
(100147, '07/12/2013', 'V', '27.99', 12119, '014456', NULL, NULL, 'Invoice Payment', 'PL12119 014456', 10065, 0, 0, 0, NULL, NULL, NULL, NULL, 138, '2014-01-16 08:14:01', '100', 'DH010010'),
(100148, '07/12/2013', 'V', '38.99', 12120, '013966', NULL, NULL, 'Invoice Payment', 'PL12120 013966', 10065, 0, 0, 0, NULL, NULL, NULL, NULL, 139, '2014-01-16 08:14:01', '100', 'DH010010'),
(100149, '07/12/2013', 'V', '25.46', 12121, '092989', NULL, NULL, 'Invoice Payment', 'PL12121 092989', 10160, 0, 0, 0, NULL, NULL, NULL, NULL, 140, '2014-01-16 08:14:01', '100', 'DH010010'),
(100150, '07/12/2013', 'V', '10.00', 12122, '1576', NULL, NULL, 'Invoice Payment', 'PL12122 1576', 10161, 0, 0, 0, NULL, NULL, NULL, NULL, 141, '2014-01-16 08:14:01', '100', 'DH010010'),
(100151, '29/09/2013', 'V', '3.99', 12124, '9MF13029SE8933211', NULL, NULL, 'Invoice Payment', 'PL12124 9MF13029SE8933211', 10152, 0, 0, 0, NULL, NULL, NULL, NULL, 142, '2014-01-16 08:14:01', '100', 'DH010010'),
(100152, '30/11/2013', 'V', '112.94', 12125, '24149935', NULL, NULL, 'Invoice Payment', 'PL12125 24149935', 10079, 0, 0, 0, NULL, NULL, NULL, NULL, 143, '2014-01-16 08:14:01', '100', 'DH010010'),
(100153, '15/10/2013', 'V', '16.99', 12127, '49E05721MN900135Y', NULL, NULL, 'Invoice Payment', 'PL12127 49E05721MN900135Y', 10082, 0, 0, 0, NULL, NULL, NULL, NULL, 144, '2014-01-16 08:14:01', '100', 'DH010010'),
(100154, '12/12/2013', 'B', '-36.47', 12128, '01/09/2013-30/11/2013', NULL, NULL, 'Invoice Payment', 'PL12128 01/09/2013-30/11/2013', 10095, 0, 0, 0, NULL, NULL, NULL, NULL, 145, '2014-01-16 08:14:01', '100', 'DH010010'),
(100155, '29/01/2014', 'C', '20.00', NULL, NULL, 12040, 10000034, 'Invoice Payment', 'SL12040 10000034', 10165, 0, 0, 0, NULL, NULL, NULL, NULL, 146, '2014-01-29 21:32:59', '', ''),
(100156, '30/01/2014', 'Q', '75.00', NULL, NULL, 12041, 10000035, 'Invoice Payment', 'SL12041 10000035', 10136, 0, 0, 0, NULL, NULL, NULL, NULL, 147, '2014-01-30 19:39:19', '', ''),
(100157, '31/01/2014', 'C', '20.00', NULL, NULL, 12043, 10000037, 'Invoice Payment', 'SL12043 10000037', 10121, 0, 0, 0, NULL, NULL, NULL, NULL, 148, '2014-02-01 12:59:58', '', ''),
(100158, '31/01/2014', 'C', '15.00', NULL, NULL, 12042, 10000036, 'Invoice Payment', 'SL12042 10000036', 10163, 0, 0, 0, NULL, NULL, NULL, NULL, 149, '2014-02-01 13:00:15', '', ''),
(100159, '01/02/2014', 'C', '20.00', NULL, NULL, 12044, 10000038, 'Invoice Payment', 'SL12044 10000038', 10166, 0, 0, 0, NULL, NULL, NULL, NULL, 150, '2014-02-01 13:03:11', '', ''),
(100160, '16/02/2014', 'C', '100.00', NULL, NULL, 12045, 10000039, 'Invoice Payment', 'SL12045 10000039', 10076, 0, 0, 0, NULL, NULL, NULL, NULL, 151, '2014-02-16 11:11:47', '', ''),
(100161, '03/01/2014', 'V', '47.58', 12129, '25617', NULL, NULL, 'Invoice Payment', 'PL12129 25617', 10167, 0, 0, 0, NULL, NULL, NULL, NULL, 152, '2014-02-16 11:21:07', '', '');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;