/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qs_Transaction` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transactionId` varchar(255) NOT NULL,
  `billingFirstName` varchar(255) NOT NULL,
  `billingLastName` varchar(255) NOT NULL,
  `billingAddress` varchar(255) NOT NULL,
  `billingCity` varchar(255) NOT NULL,
  `billingState` varchar(255) NOT NULL,
  `billingZip` varchar(255) NOT NULL,
  `billingPhone` varchar(255) NOT NULL,
  `billingEmail` varchar(255) NOT NULL,
  `shippingAsBilling` enum('y','n') NOT NULL,
  `shippingFirstName` varchar(255) NOT NULL,
  `shippingLastName` varchar(255) NOT NULL,
  `shippingAddress` varchar(255) NOT NULL,
  `shippingCity` varchar(255) NOT NULL,
  `shippingState` varchar(255) NOT NULL,
  `shippingZip` varchar(255) NOT NULL,
  `shippingAddressType` enum('residential','commercial') NOT NULL DEFAULT 'residential',
  `shippingName` varchar(255) NOT NULL,
  `shippingNameTitle` varchar(255) DEFAULT NULL,
  `shippingServiceCode` varchar(255) NOT NULL,
  `shippingServiceCodeTitle` varchar(255) DEFAULT NULL,
  `shippingHandling` decimal(10,2) NOT NULL,
  `shippingHandlingTax` decimal(10,2) NOT NULL,
  `shippingRate` decimal(10,2) NOT NULL,
  `shippingTax` decimal(10,2) NOT NULL,
  `paymentType` varchar(255) DEFAULT NULL,
  `paymentTypeTitle` varchar(255) NOT NULL,
  `paid` enum('y','n') NOT NULL DEFAULT 'n',
  `status` enum('new','packed','sent','closed') NOT NULL DEFAULT 'new',
  `promo` decimal(10,2) NOT NULL,
  `giftCard` decimal(10,2) NOT NULL,
  `subtotal` decimal(10,2) NOT NULL,
  `tax` decimal(10,2) NOT NULL,
  `total` decimal(10,2) NOT NULL,
  `oldTotal` decimal(10,2) NOT NULL,
  `paymentCardNumber` varchar(255) NOT NULL,
  `paymentExpirationDate` date DEFAULT NULL,
  `paymentPoNumber` varchar(255) DEFAULT NULL,
  `trackingCode` varchar(255) NOT NULL,
  `adminAdditionalNote` text NOT NULL,
  `userAdditionalNote` text NOT NULL,
  `enabled` enum('y','n') NOT NULL DEFAULT 'y',
  `added` datetime NOT NULL,
  `changed` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `deliveryType` (`shippingName`),
  KEY `shippingMethod` (`shippingAsBilling`),
  KEY `status` (`status`),
  KEY `paymentType` (`paymentType`),
  KEY `shippingAddressType` (`shippingAddressType`),
  KEY `paid` (`paid`)
) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
INSERT INTO `qs_Transaction` (`id`, `transactionId`, `billingFirstName`, `billingLastName`, `billingAddress`, `billingCity`, `billingState`, `billingZip`, `billingPhone`, `billingEmail`, `shippingAsBilling`, `shippingFirstName`, `shippingLastName`, `shippingAddress`, `shippingCity`, `shippingState`, `shippingZip`, `shippingAddressType`, `shippingName`, `shippingNameTitle`, `shippingServiceCode`, `shippingServiceCodeTitle`, `shippingHandling`, `shippingHandlingTax`, `shippingRate`, `shippingTax`, `paymentType`, `paymentTypeTitle`, `paid`, `status`, `promo`, `giftCard`, `subtotal`, `tax`, `total`, `oldTotal`, `paymentCardNumber`, `paymentExpirationDate`, `paymentPoNumber`, `trackingCode`, `adminAdditionalNote`, `userAdditionalNote`, `enabled`, `added`, `changed`) VALUES (1,'','Jaam','xXx','11 Suite','Plymoth','MN','55441','','jaam@adaptainc.com','y','Jaam','xXx','11 Suite','Plymoth','MN','55441','residential','FedEx','FedEx','FEDEX_EXPRESS_SAVER','FedEx Express Saver®',5.00,0.00,44.55,0.00,'po','P.O. (For approved customers only)','n','new',0.00,0.00,3450.00,0.00,3499.55,0.00,'',NULL,'232','','Nice customer','Sample note from customer','y','2012-10-19 15:17:29','2012-10-19 16:34:52'),(2,'','Jaam','xXx','11 Suite','Plymoth','MN','55441','','jaam@adaptainc.com','y','Jaam','xXx','11 Suite','Plymoth','MN','55441','residential','Manual','Our Shipping','',NULL,7.98,0.00,20.00,0.00,'po','P.O. (For approved customers only)','n','new',0.00,0.00,1950.00,0.00,1977.98,0.00,'',NULL,'123','','','','y','2012-10-19 17:08:23','2012-10-19 17:08:23'),(3,'','','','','','','','','','y','','','','','','','residential','',NULL,'',NULL,0.00,0.00,0.00,0.00,NULL,'','n','new',0.00,0.00,0.00,0.00,0.00,0.00,'',NULL,NULL,'','','','n','2012-10-19 17:42:45','2012-10-19 17:42:45'),(4,'','Jaam','xXx','11 Suite','Plymoth','MN','55441','','jaam@adaptainc.com','y','Jaam','xXx','11 Suite','Plymoth','MN','55441','residential','Ups','UPS','12','UPS 3 Day Select',50.00,0.00,14.02,0.00,'po','P.O. (For approved customers only)','n','new',20.00,0.00,150.00,0.00,194.02,0.00,'',NULL,'232','','','','y','2012-10-19 18:19:26','2012-10-22 10:50:46'),(5,'','Jaam','xXx','11 Suite','Plymoth','MN','55441','','jaam@adaptainc.com','y','Jaam','xXx','11 Suite','Plymoth','MN','55441','residential','Manual','Our Shipping','',NULL,7.98,0.00,20.00,0.00,'po','P.O.','n','new',0.00,0.00,300.00,0.00,327.98,0.00,'',NULL,'232','','','','y','2012-10-19 18:24:24','2012-10-22 14:46:44'),(6,'','Jaam','xXx','11 Suite','Plymoth','MN','55441','','jaam@adaptainc.com','y','Jaam','xXx','11 Suite','Plymoth','MN','55441','residential','Usps','USPS','EXPRESS','Express Mail®',4.50,0.00,31.60,0.00,'authorizeNet','Credit Card','n','new',0.00,0.00,0.00,0.00,0.00,0.00,'**** **** **** *111','2016-05-01',NULL,'','','','n','2012-10-22 09:54:17','2012-10-22 09:55:25'),(7,'','Jaam','xXx','11 Suite','Plymoth','MN','55441','','jaam@adaptainc.com','y','Jaam','xXx','11 Suite','Plymoth','MN','55441','residential','Manual','Our Shipping','',NULL,7.98,0.00,20.00,0.00,'po','P.O. (For approved customers only)','n','new',0.00,0.00,0.00,0.00,0.00,0.00,'',NULL,'232','','','','n','2012-10-22 09:58:27','2012-10-22 09:59:24'),(8,'','Jaam','xXx','11 Suite','Plymoth','MN','55441','','jaam@adaptainc.com','y','Jaam','xXx','11 Suite','Plymoth','MN','55441','residential','Manual','Our Shipping','',NULL,7.98,0.00,20.00,0.00,'po','P.O. (For approved customers only)','n','new',0.00,0.00,0.00,0.00,0.00,0.00,'',NULL,'123','','','','n','2012-10-22 14:21:51','2012-10-22 14:22:47'),(9,'','Jaam','xXx','11 Suite','Plymoth','MN','55441','','jaam@adaptainc.com','y','Jaam','xXx','11 Suite','Plymoth','MN','55441','residential','Manual','Our Shipping','',NULL,7.98,0.00,20.00,0.00,'po','P.O.','n','new',0.00,0.00,50.00,0.00,77.98,0.00,'',NULL,'123','','','','y','2012-10-22 14:43:48','2012-10-22 14:43:48'),(10,'','Jaam','xXx','11 Suite','Plymoth','MN','55441','','jaam@adaptainc.com','y','Jaam','xXx','11 Suite','Plymoth','MN','55441','residential','Manual','Our Shipping','',NULL,7.98,0.00,20.00,0.00,'po','P.O.','y','new',0.00,0.00,1950.00,0.00,1977.98,0.00,'**** **** **** *111','2013-02-01','123','','','','y','2012-10-22 14:51:33','2012-10-22 15:03:30'),(11,'','Jaam','xXx','11 Suite','Plymoth','MN','55441','','jaam@adaptainc.com','y','Jaam','xXx','11 Suite','Plymoth','MN','55441','residential','',NULL,'',NULL,0.00,0.00,0.00,0.00,NULL,'','n','new',0.00,0.00,0.00,0.00,0.00,0.00,'',NULL,NULL,'','','','n','2012-10-22 15:17:27','2012-10-22 15:17:56'),(12,'','Vitalii','Tornopilskyi','KoNovaltsa 2','Ternopil','MN','46020','','test@vityk.fr-wd.com','y','Vitalii','Tornopilskyi','KoNovaltsa 2','Ternopil','MN','46020','residential','Manual','Our Shipping','',NULL,7.98,0.00,20.00,0.00,'po','P.O.','n','new',0.00,0.00,250.00,0.00,277.98,0.00,'',NULL,'123','','','','y','2012-10-26 17:49:27','2012-10-26 17:49:27'),(13,'','Liudmyla','Chekhovska','address','city','PA','16801','','customer@sha.fr-wd.com','y','Liudmyla','Chekhovska','address','city','PA','16801','residential','Usps','USPS','PRIORITY','Priority Mail®',4.50,0.00,14.55,0.00,'authorizeNet','Credit Card','y','new',0.00,0.00,50.00,0.00,69.05,0.00,'**** **** **** *111','2015-02-01',NULL,'','','','y','2012-10-29 16:34:54','2012-11-02 09:58:31'),(14,'','','','','','','','','','y','','','','','','','residential','',NULL,'',NULL,0.00,0.00,0.00,0.00,NULL,'','n','new',0.00,0.00,0.00,0.00,0.00,0.00,'',NULL,NULL,'','','','n','2012-10-31 17:38:18','2012-10-31 17:38:18'),(15,'','Liudmyla','Chekhovska','address','city','PA','16801','','customer@sha.fr-wd.com','y','Liudmyla','Chekhovska','address','city','PA','16801','residential','Ups','UPS','12','UPS 3 Day Select',50.00,0.00,35.41,0.00,'authorizeNet','Credit Card','y','new',0.00,0.00,500.00,0.00,585.41,0.00,'**** **** **** *111','2014-04-01',NULL,'','','','y','2012-11-02 17:25:06','2012-11-02 17:25:07'),(16,'','','','','','','','','','y','','','','','','','residential','',NULL,'',NULL,0.00,0.00,0.00,0.00,NULL,'','n','new',0.00,0.00,0.00,0.00,0.00,0.00,'',NULL,NULL,'','','','n','2012-11-06 15:33:42','2012-11-06 15:33:42'),(17,'','Liudmyla','Chekhovska','address','city','PA','16801','','customer@sha.fr-wd.com','y','Liudmyla','Chekhovska','address','city','PA','16801','residential','Ups','UPS','03','UPS Ground',50.00,0.00,15.57,0.00,'authorizeNet','Credit Card','y','new',0.00,0.00,50.00,0.00,115.57,0.00,'**** **** **** *111','2014-06-01',NULL,'','','','y','2012-11-09 10:38:53','2012-11-09 10:38:54'),(18,'','Liudmyla','Chekhovska','address','city','PA','16801','','t@sha.fr-wd.com','y','Liudmyla','Chekhovska','address','city','PA','16801','residential','Ups','UPS','03','UPS Ground',50.00,0.00,13.66,0.00,'authorizeNet','Credit Card','y','new',0.00,0.00,150.00,0.00,213.66,0.00,'**** **** **** *111','2013-03-01',NULL,'','','','y','2012-11-09 10:43:22','2012-11-19 17:31:24'),(19,'','M','Kloo','address','Minnetonka','MN','55343','','qsf@kloo.fr-wd.com','y','M','Kloo','address','Minnetonka','MN','55343','residential','Manual','Our Shipping','',NULL,7.98,0.00,20.00,0.00,'po','P.O.','n','sent',0.00,0.00,300.00,0.00,327.98,0.00,'',NULL,'123','','','test','y','2012-11-14 15:34:08','2012-12-11 10:52:02'),(20,'','Liudmyla','Chekhovska','address','city','PA','16801','','lia@sha.fr-wd.com','y','Liudmyla','Chekhovska','address','city','PA','16801','residential','FedEx','FedEx','FEDEX_2_DAY','FedEx 2Day®',5.00,0.00,34.93,0.00,'po','P.O.','y','new',0.00,0.00,100.00,0.00,139.93,0.00,'**** **** **** *111','2015-04-01','123','','','','y','2012-11-19 17:44:43','2012-11-28 16:42:09'),(21,'','Vitalii','Tornopilskyi','KoNovaltsa 2','Ternopil','MN','46020','','test@vityk.fr-wd.com','y','Vitalii','Tornopilskyi','KoNovaltsa 2','Ternopil','MN','46020','residential','Manual','Our Shipping','',NULL,7.98,0.00,20.00,0.00,'po','P.O.','n','new',0.00,0.00,150.00,0.00,177.98,0.00,'',NULL,'123','','','','y','2012-11-20 09:53:51','2012-11-20 09:53:51'),(22,'','Vitalii','Tornopilskyi','KoNovaltsa 2','Ternopil','MN','46020','','vityk@adaptainc.com','y','Vitalii','Tornopilskyi','KoNovaltsa 2','Ternopil','MN','46020','residential','Manual','Our Shipping','',NULL,7.98,0.00,20.00,0.00,'po','P.O.','n','new',0.00,0.00,100.00,0.00,127.98,0.00,'',NULL,'123','','','','y','2012-11-20 09:59:36','2012-11-20 09:59:36'),(23,'','Liudmyla','Chekhovska','address','city','PA','16801','','t@sha.fr-wd.com','y','Liudmyla','Chekhovska','address','city','PA','16801','residential','Ups','UPS','12','UPS 3 Day Select',50.00,0.00,19.32,0.00,'authorizeNet','Credit Card','y','new',0.00,0.00,150.00,0.00,219.32,0.00,'**** **** **** *111','2015-08-01',NULL,'','','','y','2012-11-20 12:41:06','2012-11-20 12:41:07'),(24,'','Vitalii','Tornopilskyi','KoNovaltsa 2','Minnetonka','MN','55345','','vityk@adaptainc.com','y','Vitalii','Tornopilskyi','KoNovaltsa 2','Minnetonka','MN','55345','residential','FedEx','FedEx','FEDEX_2_DAY','FedEx 2Day®',5.00,0.00,18.35,0.00,'po','P.O.','n','new',0.00,0.00,350.00,0.00,373.35,369.93,'',NULL,'123','','','','y','2012-11-20 13:04:57','2012-11-26 16:33:40'),(25,'','Vitalii','Tornopilskyi','KoNovaltsa 2','Ternopil','MN','46020','','vityk@adaptainc.com','y','Vitalii','Tornopilskyi','KoNovaltsa 2','Ternopil','MN','46020','residential','Manual','Our Shipping','',NULL,7.98,0.00,20.00,0.00,'po','P.O.','n','new',0.00,0.00,0.00,0.00,0.00,0.00,'',NULL,'123','','','','n','2012-11-20 14:22:32','2012-11-20 14:23:31'),(30,'','Vitalii','Tornopilskyi','KoNovaltsa 2','Minnetonka','MN','55345','','vityk@adaptainc.com','y','Vitalii','Tornopilskyi','KoNovaltsa 2','Minnetonka','MN','55345','residential','FedEx','FedEx','STANDARD_OVERNIGHT','FedEx Standard Overnight®',5.00,0.00,29.37,0.00,'po','P.O.','n','new',10.00,0.00,600.00,0.00,624.37,0.00,'',NULL,'123','','test','test','y','2012-11-26 16:58:02','2012-12-05 10:05:34'),(29,'','Vitalii','Tornopilskyi','KoNovaltsa 2','Minnetonka','MN','55345','','vityk@adaptainc.com','y','Vitalii','Tornopilskyi','KoNovaltsa 2','Minnetonka','MN','55345','residential','FedEx','FedEx','FEDEX_2_DAY','FedEx 2Day®',5.00,0.00,20.61,0.00,'po','P.O.','n','new',0.00,0.00,250.00,0.00,275.61,272.19,'',NULL,'123','','','','y','2012-11-26 16:38:14','2012-11-26 16:40:55'),(31,'','','','','','','','','','y','','','','','','','residential','',NULL,'',NULL,0.00,0.00,0.00,0.00,NULL,'','n','new',0.00,0.00,0.00,0.00,0.00,0.00,'',NULL,NULL,'','','','n','2012-11-26 16:58:55','2012-11-26 16:58:55'),(33,'','','','','','','','','','y','','','','','','','residential','',NULL,'',NULL,0.00,0.00,0.00,0.00,NULL,'','n','new',0.00,0.00,0.00,0.00,0.00,0.00,'',NULL,NULL,'','','','n','2012-12-03 12:43:44','2012-12-03 12:43:44'),(36,'','','','','','','','','','y','','','','','','','residential','',NULL,'',NULL,0.00,0.00,0.00,0.00,NULL,'','n','new',0.00,0.00,0.00,0.00,0.00,0.00,'',NULL,NULL,'','','','n','2012-12-05 14:10:31','2012-12-05 14:10:31'),(37,'','test','test','test','test','IA','1234','','test@kloo.fr-wd.com','y','test','test','test','test','IA','1234','residential','Manual','Our Shipping','',NULL,7.98,0.00,20.00,0.00,'po','P.O.','n','sent',0.00,0.00,250.00,0.00,277.98,0.00,'',NULL,'123','','','','y','2012-12-05 14:16:54','2012-12-11 10:50:51'),(38,'','test','test','test','test','KS','1234','','test@kloo.fr-wd.com','y','test','test','test','test','KS','1234','residential','Manual','Our Shipping','',NULL,7.98,0.00,20.00,0.00,'po','P.O.','y','sent',0.00,0.00,310.00,0.00,337.98,0.00,'',NULL,'123','','','','y','2012-12-05 14:23:47','2012-12-11 10:49:39'),(39,'','','','','','','','','','y','','','','','','','residential','',NULL,'',NULL,0.00,0.00,0.00,0.00,NULL,'','n','new',0.00,0.00,0.00,0.00,0.00,0.00,'',NULL,NULL,'','','','n','2012-12-05 14:51:37','2012-12-05 14:51:37'),(40,'','Vitalii','Tornopilskyi','Planet Express','Plymoth','MN','55447','','test@vityk.fr.wd.com','y','Vitalii','Tornopilskyi','Planet Express','Plymoth','MN','55447','residential','Ups','UPS','03','UPS Ground',50.00,0.00,87.50,0.00,'authorizeNet','Credit Card','y','new',0.00,0.00,1000.00,0.00,1137.50,0.00,'**** **** **** *111','2013-01-01',NULL,'','','','y','2012-12-05 15:50:13','2012-12-05 15:50:15'),(41,'','Vitalii','Ternopilskyi','5th ave','Plymouth','MN','55447','','test@vityk.fr-wd.com','y','Vitalii','Ternopilskyi','5th ave','Plymouth','MN','55447','residential','Manual','Our Shipping','',NULL,7.98,0.00,20.00,0.00,'po','P.O.','n','new',0.00,0.00,500.00,0.00,527.98,0.00,'',NULL,'123','','','','y','2012-12-05 17:04:36','2012-12-05 17:04:36'),(42,'','Vitalii','Tornopilskyi','5th ave','Plymouth','MN','55447','','test@vityk.fr-wd.com','y','Vitalii','Tornopilskyi','5th ave','Plymouth','MN','55447','residential','Manual','Our Shipping','',NULL,7.98,0.00,20.00,0.00,'po','P.O.','n','new',0.00,0.00,310.00,0.00,337.98,0.00,'',NULL,'123','','','','y','2012-12-05 17:09:37','2012-12-05 17:09:37'),(43,'','Vitalii','Tornopilskyi','5th ave','Plymouth','MN','55447','','test@vityk.fr-wd.com','y','Vitalii','Tornopilskyi','5th ave','Plymouth','MN','55447','residential','Manual','Our Shipping','',NULL,7.98,0.00,20.00,0.00,'po','P.O.','n','new',0.00,0.00,155.00,0.00,182.98,0.00,'',NULL,'123','','','','y','2012-12-05 17:13:36','2012-12-05 17:13:36'),(44,'','Vitalii','Tornopilskyi','5th ave','Plymouth','MN','55447','','test@vityk.fr-wd.com','y','Vitalii','Tornopilskyi','5th ave','Plymouth','MN','55447','residential','Manual','Our Shipping','',NULL,7.98,0.00,20.00,0.00,'po','P.O.','n','new',0.00,0.00,500.00,0.00,527.98,0.00,'',NULL,'12','','','','y','2012-12-05 17:30:44','2012-12-05 17:30:44'),(45,'','Vitalii','Tornopilskyi','5th ave','Plymouth','MN','55447','','test@vityk.fr-wd.com','y','Vitalii','Tornopilskyi','5th ave','Plymouth','MN','55447','residential','Manual','Our Shipping','',NULL,7.98,0.00,20.00,0.00,'authorizeNet','Credit Card','y','packed',0.00,0.00,500.00,0.00,527.98,0.00,'**** **** **** *111','2013-01-01',NULL,'','Dude can\'t wait anymore. He needs semki immediately','','y','2012-12-05 17:42:57','2012-12-06 15:18:26'),(46,'','Jaam','xXx','11 Suite','Plymoth','MN','55441','','jaam@adaptainc.com','y','Jaam','xXx','11 Suite','Plymoth','MN','55441','residential','Ups','UPS','03','UPS Ground',50.00,0.00,26.44,0.00,'po','P.O.','y','sent',0.00,0.00,500.00,0.00,576.44,0.00,'',NULL,'232','','','Love your semki.','y','2012-12-06 18:06:54','2012-12-12 17:27:37'),(47,'','Jaam','xXx','11 Suite','Plymoth','MN','55441','','jaam@adaptainc.com','y','Jaam','xXx','11 Suite','Plymoth','MN','55441','residential','Ups','UPS','03','UPS Ground',50.00,0.00,89.95,0.00,'po','P.O.','y','sent',0.00,0.00,1150.00,0.00,1289.95,0.00,'',NULL,'232','','','please prepare a gift pack for my ma\'','y','2012-12-06 18:09:33','2012-12-12 17:27:37'),(48,'','Jaam','xXx','11 Suite','Plymoth','MN','55441','','jaam@adaptainc.com','n','Jaam','xXx','11 Suite','Miami','FL','33132','residential','FedEx','FedEx','FEDEX_GROUND','FedEx Ground®',5.00,0.00,77.25,0.00,'po','P.O.','y','sent',0.00,0.00,1000.00,0.00,1082.25,0.00,'',NULL,'232','','','Discover the finest, the Hilton in downtown Miami, where engaging colors, sharp lines, and modern design elements welcome leisure and business travelers.','y','2012-12-07 10:09:38','2012-12-12 17:27:37'),(49,'','Test','Test','Test','Test','CT','123123','','guest@kloo.fr-wd.com','y','Test','Test','Test','Test','CT','123123','residential','Manual','Our Shipping','',NULL,7.98,0.00,20.00,0.00,'po','P.O.','n','sent',0.00,0.00,1000.00,0.00,1027.98,0.00,'',NULL,'123','','','','y','2012-12-11 10:57:52','2012-12-12 17:31:54'),(50,'','Jaam','xXx','11 Suite','Plymoth','MN','55441','','jaam@adaptainc.com','y','Jaam','xXx','11 Suite','Plymoth','MN','55441','residential','Ups','UPS','03','UPS Ground',50.00,1.50,139.30,4.18,'po','P.O.','n','new',0.00,0.00,71.64,7.83,268.77,0.00,'',NULL,'232','','','To schedule an appointment, call 952.767.6700','y','2012-12-13 11:50:59','2012-12-13 11:50:59'),(51,'','Jaam','xXx','11 Suite','Plymoth','MN','55441','','jaam@adaptainc.com','y','Jaam','xXx','11 Suite','Plymoth','MN','55441','residential','Ups','UPS','03','UPS Ground',50.00,0.00,118.85,0.00,'po','P.O.','n','new',0.00,0.00,1965.00,0.00,2133.85,0.00,'',NULL,'232','','','ll transactions with this website','y','2012-12-13 11:57:07','2012-12-13 11:57:07');