-- phpMyAdmin SQL Dump
-- version 4.0.8
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 20, 2014 at 01:19 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 `*Sales Ledger`
--

CREATE TABLE IF NOT EXISTS `*Sales Ledger` (
  `Sales Ledger ID` int(11) NOT NULL AUTO_INCREMENT,
  `Transaction Date` datetime DEFAULT NULL,
  `Posting Date` datetime DEFAULT NULL,
  `Doc Type` varchar(255) DEFAULT NULL,
  `Document Number` int(11) DEFAULT NULL,
  `Customer ID` int(11) DEFAULT NULL,
  `Work Order ID` int(11) DEFAULT NULL,
  `Work Order Sub ID` int(11) DEFAULT NULL,
  `order number` varchar(255) DEFAULT NULL,
  `invoice net` decimal(18,2) DEFAULT '0.00',
  `invoice total` decimal(18,2) DEFAULT '0.00',
  `invoice vat` decimal(18,2) DEFAULT '0.00',
  `due date` datetime DEFAULT NULL,
  `P` varchar(255) DEFAULT NULL,
  `state link` int(11) DEFAULT NULL,
  `original printed` varchar(255) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `internam-marker` varchar(5) NOT NULL,
  `devision` varchar(3) NOT NULL,
  `locked by` varchar(225) NOT NULL,
  PRIMARY KEY (`Sales Ledger ID`),
  KEY `Document Number` (`Document Number`),
  KEY `Nominal Code` (`Customer ID`),
  KEY `Work Order ID` (`Work Order ID`),
  KEY `Work Order Sub ID` (`Work Order Sub ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12046 ;

--
-- Dumping data for table `*Sales Ledger`
--

INSERT INTO `*Sales Ledger` (`Sales Ledger ID`, `Transaction Date`, `Posting Date`, `Doc Type`, `Document Number`, `Customer ID`, `Work Order ID`, `Work Order Sub ID`, `order number`, `invoice net`, `invoice total`, `invoice vat`, `due date`, `P`, `state link`, `original printed`, `timestamp`, `internam-marker`, `devision`, `locked by`) VALUES
(12006, '2012-07-18 00:00:00', '2012-07-18 00:00:00', 'I', 10000000, 10074, 100016, NULL, NULL, '37.50', '45.00', '7.50', '2012-07-18 00:00:00', NULL, NULL, NULL, '2014-01-16 08:57:37', '', '100', ''),
(12007, '2012-07-21 00:00:00', '2012-07-21 00:00:00', 'I', 10000001, 10074, 100017, NULL, NULL, '0.00', '0.00', '0.00', '2012-07-21 00:00:00', NULL, NULL, NULL, '2014-01-16 08:57:37', '', '100', ''),
(12008, '2012-07-21 00:00:00', '2012-07-21 00:00:00', 'I', 10000002, 10078, 100018, NULL, NULL, '33.34', '40.00', '6.66', '2012-07-21 00:00:00', NULL, NULL, NULL, '2014-01-16 08:57:37', '', '100', ''),
(12009, '2012-08-03 00:00:00', '2012-08-03 00:00:00', 'I', 10000003, 10080, 100019, NULL, NULL, '67.49', '80.97', '13.48', '2012-08-03 00:00:00', NULL, NULL, NULL, '2014-01-16 08:57:37', '', '100', ''),
(12010, '2012-07-23 00:00:00', '2012-07-23 00:00:00', 'I', 10000004, 10081, 100020, NULL, NULL, '0.00', '0.00', '0.00', '2012-07-23 00:00:00', NULL, NULL, NULL, '2014-01-16 08:57:37', '', '100', ''),
(12011, '2012-08-27 00:00:00', '2012-08-27 00:00:00', 'I', 10000005, 10086, 100022, NULL, NULL, '0.00', '0.00', '0.00', '2012-08-27 00:00:00', NULL, NULL, NULL, '2014-01-16 08:57:37', '', '100', ''),
(12012, '2012-08-27 00:00:00', '2012-08-27 00:00:00', 'I', 10000006, 10087, 100023, NULL, NULL, '16.67', '20.00', '3.33', '2012-08-27 00:00:00', NULL, NULL, NULL, '2014-01-16 08:57:37', '', '100', ''),
(12013, '2012-08-27 00:00:00', '2012-08-27 00:00:00', 'I', 10000007, 10088, 100024, NULL, NULL, '16.67', '20.00', '3.33', '2012-08-27 00:00:00', NULL, NULL, NULL, '2014-01-16 08:57:37', '', '100', ''),
(12014, '2012-08-28 00:00:00', '2012-08-28 00:00:00', 'I', 10000008, 10063, 100021, NULL, NULL, '25.82', '30.98', '5.16', '2012-08-28 00:00:00', NULL, NULL, NULL, '2014-01-16 08:57:37', '', '100', ''),
(12015, '2012-08-29 00:00:00', '2012-08-29 00:00:00', 'I', 10000009, 10090, 100025, NULL, NULL, '16.67', '20.00', '3.33', '2012-08-29 00:00:00', NULL, NULL, NULL, '2014-01-16 08:57:37', '', '100', ''),
(12016, '2012-08-31 00:00:00', '2012-08-31 00:00:00', 'I', 10000010, 10094, 100026, NULL, NULL, '1.67', '2.00', '0.33', '2012-08-31 00:00:00', NULL, NULL, NULL, '2014-01-16 08:57:37', '', '100', ''),
(12017, '2012-12-09 00:00:00', '2012-12-09 00:00:00', 'I', 10000011, 10123, 100031, NULL, NULL, '126.19', '151.41', '25.22', '2012-12-09 00:00:00', NULL, NULL, NULL, '2014-01-16 08:57:37', '', '100', ''),
(12018, '2012-12-13 00:00:00', '2012-12-13 00:00:00', 'I', 10000012, 10122, 100030, NULL, NULL, '37.50', '45.00', '7.50', '2012-12-13 00:00:00', NULL, NULL, NULL, '2014-01-16 08:57:37', '', '100', ''),
(12019, '2012-12-13 00:00:00', '2012-12-13 00:00:00', 'I', 10000013, 10074, 100028, NULL, NULL, '25.00', '30.00', '5.00', '2012-12-13 00:00:00', NULL, NULL, NULL, '2014-01-16 08:57:37', '', '100', ''),
(12020, '2012-12-14 00:00:00', '2012-12-14 00:00:00', 'I', 10000014, 10124, 100032, NULL, NULL, '54.18', '65.00', '10.82', '2012-12-14 00:00:00', NULL, NULL, NULL, '2014-01-16 08:57:37', '', '100', ''),
(12021, '2013-01-10 00:00:00', '2013-01-10 00:00:00', 'I', 10000015, 10126, 100033, NULL, NULL, '25.00', '30.00', '5.00', '2013-01-10 00:00:00', NULL, NULL, NULL, '2014-01-16 08:57:37', '', '100', ''),
(12022, '2013-04-19 00:00:00', '2013-04-19 00:00:00', 'I', 10000016, 10133, 100047, NULL, NULL, '0.00', '0.00', '0.00', '2013-04-19 00:00:00', NULL, NULL, NULL, '2014-01-16 08:57:37', '', '100', ''),
(12023, '2013-05-09 00:00:00', '2013-05-09 00:00:00', 'I', 10000017, 10076, 100045, NULL, NULL, '8.34', '10.00', '1.66', '2013-05-09 00:00:00', NULL, NULL, NULL, '2014-01-16 08:57:37', '', '100', ''),
(12024, '2013-05-14 00:00:00', '2013-05-14 00:00:00', 'I', 10000018, 10133, 100049, NULL, NULL, '16.67', '20.00', '3.33', '2013-05-14 00:00:00', NULL, NULL, NULL, '2014-01-16 08:57:37', '', '100', ''),
(12025, '2013-06-01 00:00:00', '2013-06-01 00:00:00', 'I', 10000019, 10099, 100027, NULL, NULL, '46.48', '55.77', '9.29', '2013-06-01 00:00:00', NULL, NULL, NULL, '2014-01-16 08:57:37', '', '100', ''),
(12026, '2013-06-15 00:00:00', '2013-06-15 00:00:00', 'I', 10000020, 10074, 100050, NULL, NULL, '33.34', '40.00', '6.66', '2013-06-15 00:00:00', NULL, NULL, NULL, '2014-01-16 08:57:37', '', '100', ''),
(12027, '2013-06-20 00:00:00', '2013-06-20 00:00:00', 'I', 10000021, 10136, 100052, NULL, NULL, '41.68', '50.00', '8.32', '2013-06-20 00:00:00', NULL, NULL, '20/06/2013', '2014-01-16 08:57:37', '', '100', ''),
(12028, '2013-08-15 00:00:00', '2013-08-15 00:00:00', 'I', 10000022, 10135, 100051, NULL, NULL, '104.51', '125.40', '20.89', '2013-08-15 00:00:00', NULL, NULL, NULL, '2014-01-16 08:57:37', '', '100', ''),
(12029, '2013-08-15 00:00:00', '2013-08-15 00:00:00', 'I', 10000023, 10130, 100055, NULL, NULL, '7.75', '9.50', '1.75', '2013-08-15 00:00:00', NULL, NULL, NULL, '2014-01-16 08:57:37', '', '100', ''),
(12030, '2013-08-17 00:00:00', '2013-08-17 00:00:00', 'I', 10000024, 10069, 100044, NULL, NULL, '0.00', '0.00', '0.00', '2013-08-17 00:00:00', NULL, NULL, NULL, '2014-01-16 08:57:37', '', '100', ''),
(12031, '2013-08-20 00:00:00', '2013-08-20 00:00:00', 'I', 10000025, 10142, 100057, NULL, NULL, '25.01', '30.00', '4.99', '2013-08-20 00:00:00', NULL, NULL, '20/08/2013', '2014-01-16 08:57:37', '', '100', ''),
(12032, '2013-08-26 00:00:00', '2013-08-26 00:00:00', 'I', 10000026, 10144, 100058, NULL, NULL, '16.67', '20.00', '3.33', '2013-08-26 00:00:00', NULL, NULL, '26/08/2013', '2014-01-16 08:57:37', '', '100', ''),
(12033, '2013-08-26 00:00:00', '2013-08-26 00:00:00', 'I', 10000027, 10078, 100053, NULL, NULL, '33.34', '40.00', '6.66', '2013-08-26 00:00:00', NULL, NULL, '26/08/2013', '2014-01-16 08:57:37', '', '100', ''),
(12034, '2013-08-30 00:00:00', '2013-08-30 00:00:00', 'I', 10000028, 10145, 100059, NULL, NULL, '16.67', '20.00', '3.33', '2013-08-30 00:00:00', NULL, NULL, '30/08/2013', '2014-01-16 08:57:37', '', '100', ''),
(12035, '2013-11-03 00:00:00', '2013-11-03 00:00:00', 'I', 10000029, 10124, 100060, NULL, NULL, '16.49', '19.78', '3.29', '2013-11-03 00:00:00', NULL, NULL, NULL, '2014-01-16 08:57:37', '', '100', ''),
(12036, '2013-11-08 00:00:00', '2013-11-08 00:00:00', 'I', 10000030, 10121, 100066, NULL, NULL, '16.67', '20.00', '3.33', '2013-11-08 00:00:00', NULL, NULL, '08/11/2013', '2014-01-16 08:57:37', '', '100', ''),
(12037, '2013-11-13 00:00:00', '2013-11-13 00:00:00', 'I', 10000031, 10154, 100073, NULL, NULL, '8.34', '10.00', '1.66', '2013-11-13 00:00:00', NULL, NULL, NULL, '2014-01-16 08:57:37', '', '100', ''),
(12038, '2013-11-16 00:00:00', '2013-11-16 00:00:00', 'I', 10000032, 10156, 100076, NULL, NULL, '83.34', '100.00', '16.66', '2013-11-16 00:00:00', NULL, NULL, NULL, '2014-01-16 08:57:37', '', '100', ''),
(12039, '2013-11-23 00:00:00', '2013-11-23 00:00:00', 'I', 10000033, 10074, 100077, NULL, NULL, '0.00', '0.00', '0.00', '2013-12-23 00:00:00', NULL, NULL, NULL, '2014-01-16 08:57:37', '', '100', ''),
(12040, '2014-01-29 00:00:00', '2014-01-29 00:00:00', 'I', 10000034, 10165, 100080, NULL, NULL, '16.67', '20.00', '3.33', '2014-01-29 00:00:00', NULL, NULL, NULL, '2014-01-29 21:32:31', 'No', '', ''),
(12041, '2014-01-30 00:00:00', '2014-01-30 00:00:00', 'I', 10000035, 10136, 100074, NULL, NULL, '62.51', '75.00', '12.49', '2014-01-30 00:00:00', NULL, NULL, '30/01/2014', '2014-01-30 19:39:43', 'No', '', ''),
(12042, '2014-01-31 00:00:00', '2014-01-31 00:00:00', 'I', 10000036, 10163, 100079, NULL, NULL, '12.50', '15.00', '2.50', '2014-01-31 00:00:00', NULL, NULL, '31/01/2014', '2014-01-31 07:20:10', 'No', '', ''),
(12043, '2014-01-31 00:00:00', '2014-01-31 00:00:00', 'I', 10000037, 10121, 100081, NULL, NULL, '16.67', '20.00', '3.33', '2014-01-31 00:00:00', NULL, NULL, '31/01/2014', '2014-01-31 15:28:31', 'No', '', ''),
(12044, '2014-02-01 00:00:00', '2014-02-01 00:00:00', 'I', 10000038, 10166, 100083, NULL, NULL, '16.67', '20.00', '3.33', '2014-02-01 00:00:00', NULL, NULL, NULL, '2014-02-01 13:02:58', 'No', '', ''),
(12045, '2014-02-16 00:00:00', '2014-02-16 00:00:00', 'I', 10000039, 10076, 100061, NULL, NULL, '83.35', '100.00', '16.65', '2014-02-16 00:00:00', NULL, NULL, NULL, '2014-02-16 11:11:30', 'No', '', '');

/*!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 */;