-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 02, 2010 at 12:11 AM
-- Server version: 5.1.41
-- PHP Version: 5.3.1
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!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: `rieglepr_inventory`
--
-- --------------------------------------------------------
--
-- Table structure for table `bc_backgrounds`
--
CREATE TABLE IF NOT EXISTS `bc_backgrounds` (
`BC_Back_ID` int(11) NOT NULL,
`BC_Back_Name` varchar(255) NOT NULL,
`BC_Back_Image` varchar(255) NOT NULL,
`BC_Group_ID` int(11) NOT NULL,
PRIMARY KEY (`BC_Back_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `bc_backgrounds`
--
-- --------------------------------------------------------
--
-- Table structure for table `business_cards`
--
CREATE TABLE IF NOT EXISTS `business_cards` (
`BC_ID` bigint(20) NOT NULL,
`BC_Name` varchar(50) NOT NULL,
`BC_Title` varchar(25) NOT NULL,
`BC_Title2` varchar(25) NOT NULL,
`BC_Address` varchar(25) NOT NULL,
`BC_City` varchar(25) NOT NULL,
`BC_State` varchar(2) NOT NULL,
`BC_Zip` varchar(12) NOT NULL,
`BC_Phone` varchar(25) NOT NULL,
`BC_Fax` varchar(25) NOT NULL,
`BC_Email` varchar(50) NOT NULL,
`BC_Quantity` int(11) NOT NULL,
`Ship_Location_ID` bigint(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `business_cards`
--
INSERT INTO `business_cards` (`BC_ID`, `BC_Name`, `BC_Title`, `BC_Title2`, `BC_Address`, `BC_City`, `BC_State`, `BC_Zip`, `BC_Phone`, `BC_Fax`, `BC_Email`, `BC_Quantity`, `Ship_Location_ID`) VALUES
(65, 'Chris Carmody', 'Riegle Press, Inc.', '', '1282 N. Gale Rd.', '', 'MI', '', '', '', '', 500, 0),
(66, 'Chris Carmody12345', '', '', '2100 Woodward Ave', 'wwww', 'MI', '12345', '', '', '', 250, 0),
(67, 'xxxx', 'yyyy', '', '', '', 'MI', '', '', '', '', 250, 0),
(68, 'Chris Carmody12345xxxxx', 'Riegle Press, Inc.xxxxxxx', '', '', '', 'MI', '', '', '', '', 250, 0),
(70, 'Chris Carmody123', 'Riegle Press, Inc.xxxxxx', 'General Manager', '', '', 'MI', '', '810-653-9631', '', '', 500, 0),
(71, 'Susan R. Slater', 'VP', '', '3205 S. Center Road', 'Burton', 'MI', '48519', '810 600-0000', '810 600-0001', 'susan.slater@elgacu.com', 500, 0),
(72, 'Joe Blow from Kokomo', 'Secretary', '', 'ldldldl', 'Davison', 'MI', '45898', '810 600-1000', '810 600-1001', 'joe.kokomo@elgacu.com', 250, 0),
(73, 'Chris Carmodyx', 'Riegle Press, Inc.', '', '', '', 'MI', '', '', '', '', 500, 0),
(74, 'dsfadfdsa', 'fdaadsffsd', '', '', '', 'MI', '', '', '', '', 250, 0),
(75, 'Susan R. Slater', 'Secretary', '', '2305 S. Center Road', 'Davison', 'MI', '45898', '810 600-1000', '810 600-1001', 'joe.kokomo@elgacu.com', 500, 0),
(76, 'Tommy Tuna', 'Secretary', 'lsowl', '23235 S. dude', 'Davison', 'MI', '48423', '810 600-52200', '810 653-8520', 'tommy.tuna@elgacu.com', 250, 0),
(77, 'xx', '', '', '', 'xx', 'MI', '', '', '', '', 250, 0),
(78, 'trre', 'dfdfs', '', '', '', 'MI', '', '', '', 'fdsdfg', 500, 0),
(79, 'xcxcxcxcx', 'ololo', '', 'dddddd', 'zzzzzzz', 'MI', '', '', '', '', 500, 0),
(80, 'xcxcxcxcx', 'ololo', '', 'dddddd', 'zzzzzzz', 'MI', '', '', '', '', 500, 0),
(81, 'xcxcxcxcx', 'ololo', '', 'dddddd', 'zzzzzzz', 'MI', '', '', '', '', 250, 0),
(82, 'ggf', 'dsds', '', '', '', 'MI', '', '', '', 'sgfgf', 500, 0),
(83, 'kkkkkkk', 'llllll', '', '', '', 'MI', '', '', '', '', 250, 0),
(84, 'mmmmmm', '', '', '', '', 'MI', '', '', '', '', 250, 0),
(85, 'ssssss', 'dddddd', '', '', '', 'MI', '', '', '', '', 250, 0),
(86, 'zzzzz', 'xxxxx', '', '', '', 'MI', '', '', '', '', 250, 0),
(87, 'fsadfad', 'fadsfsddas', '', '', '', 'MI', '', '', 'fasdsafda', '', 250, 0),
(88, 'rewrtttr', 'hgddgfhdfh', '', '', '', 'MI', '', '', '', '', 500, 0),
(89, '11111', '333333', '', '', '', 'MI', '', '', '', '', 500, 0),
(90, 'bbb', 'ccc', '', '', '', 'MI', '', '', '', '', 500, 0),
(91, '', '', '', '', '', '', '', '', '', '', 500, 0),
(92, '', '', '', '', '', '', '', '', '', '', 500, 0),
(93, '', '', '', '', '', '', '', '', '', '', 500, 0),
(94, '', '', '', '', '', '', '', '', '', '', 500, 0),
(95, 'aaaa', 'bbbb', '', '', '', 'MI', '', '', '', '', 500, 0),
(96, 'cccc', 'dddd', '', '', '', 'MI', '', '', '', '', 250, 0),
(97, 'eeee', 'ffff', '', '', '', 'MI', '', '', '', '', 250, 0),
(98, 'ffff', 'gggg', '', '', '', 'MI', '', '', '', '', 250, 0),
(99, 'xxxx', 'vvvv', '', '', '', 'MI', '', '', '', '', 250, 0),
(100, 'pppp', 'lll', '', '', '', 'MI', '', '', '', '', 250, 0),
(101, 'gggg', 'hhhh', '', '', '', 'MI', '', '', '', '', 250, 0),
(102, 'ssss', 'bbbb', '', '', '', 'MI', '', '', '', '', 250, 0),
(103, 'aaaa', 'zzzz', '', '', '', 'MI', '', '', '', '', 250, 0),
(104, 'dddd', 'jjjj', '', '', '', 'MI', '', '', '', '', 250, 0),
(105, 'iiii', 'oooo', '', '', '', 'MI', '', '', '', '', 250, 0),
(106, 'cccc', 'nnnn', '', '', '', 'MI', '', '', '', '', 250, 0),
(107, 'eeee', 'tttt', '', '', '', 'MI', '', '', '', '', 250, 0),
(108, 'yyyy', 'vvvv', '', '', '', 'MI', '', '', '', '', 250, 0),
(109, '1111', '2222', '', '', '', 'MI', '', '', '', '', 250, 0),
(110, '1111', '2222', '', '', '', 'MI', '', '', '', '', 250, 0),
(111, '1111', '2222', '', '', '', 'MI', '', '', '', '', 250, 0),
(112, '1111', '2222', '', '', '', 'MI', '', '', '', '', 250, 0),
(114, 'vvvvv', 'ccccc', '', '', '', 'MI', '', '', '', '', 250, 0),
(144, 'fdsfdsafsda', 'fasfdfdsafds', '', '', '', 'MI', '', '', '', '', 250, 0),
(145, 'fdsfdsafsda', 'fasfdfdsafds', '', '', '', 'MI', '', '', '', '', 250, 0),
(146, 'vvvbbbb', 'xxxcccc', '', '', '', 'MI', '', '', '', '', 250, 0),
(147, '11111', '22222', '', '', '', 'MI', '', '', '', '', 250, 0),
(148, 'xvxvxvxvx', 'vcvcvcvcv', '', '', '', 'MI', '', '', '', '', 250, 0),
(149, 'qwqwqwq', 'ererere', '', '', '', 'MI', '', '', '', '', 250, 0),
(150, '1212121', '3434343', '', '', '', 'MI', '', '', '', '', 250, 0),
(151, '4545454', '6767676', '', '', '', 'MI', '', '', '', '', 250, 0),
(152, 'asasasa', 'fgfgfgf', '', '', '', 'MI', '', '', '', '', 250, 0),
(153, 'hjhjhjh', 'klklklk', '', '', '', 'MI', '', '', '', '', 250, 0),
(154, 'hjhjhjh', 'mnmnmnm', '', '', '', 'MI', '', '', '', '', 250, 0),
(155, 'bvbvbvb', 'wewewew', '', '', '', 'MI', '', '', '', '', 250, 0),
(156, 'azazazaz', 'jdjdjdjdj', '', '', '', 'MI', '', '', '', '', 250, 0),
(157, 'nbnbnbnbn', 'zxzxzxzxz', '', '', '', 'MI', '', '', '', '', 250, 0),
(158, 'ijijijiji', 'popopopop', '', '', '', 'MI', '', '', '', '', 250, 0),
(159, 'szszszs', 'qsqsqsqsq', '', '', '', 'MI', '', '', '', '', 250, 0),
(160, 'fafdsfdsa', 'fsafsddsafds', '', '12345', '', 'MI', '', '', '678', '', 250, 0),
(161, 'ffffffhhhhh', 'lllllkkkkk', '', '', '', 'MI', '', '', '', '', 250, 0),
(162, 'fdsafsafdsa', 'fdsfdsaafsfd', 'fsfsadsafd', '', '', 'MI', '', '', '', '', 250, 0),
(163, 'cbcbcbcbc', 'mnmnmnm', '', '', '', 'MI', '', '', '', '', 250, 0),
(164, '1234567', '123456', '', '12345', '', 'MI', '', '', '', '', 250, 0),
(165, 'vcxzcvcvxz', 'vcxzvvcxzcv', '', 'zvcxvzvxc', '', 'MI', '', '', '', '', 250, 0),
(166, 'agggf', 'gfgfagf', '', '', '', 'MI', '', 'fdagfaag', '', 'fgffdafg', 250, 0),
(167, 'fsafdsafds', 'fdsfdsaf', '', '', '', 'MI', '', '', 'fdsdfsafd', '', 250, 0),
(168, 'fdgs', 'fdgdfs', '', '', '', 'MI', '', '', 'sgf', '', 250, 0),
(169, 'qwqwqwq', 'qwwqqw', '', '', '', 'MI', '', '', '', '', 250, 0),
(170, 'adfdsaffds', 'asdfdsaffadsfds', '', '', '', 'MI', '', '', '', '', 250, 0),
(171, '54354', '432253', '', '', '', 'MI', '', '', '2435544532', '', 250, 0),
(172, 'vbbnmmdfgf', 'wtrrewtrew', '', '', '', 'MI', '', '', '', '', 250, 0),
(173, 'fdsafdsafd', 'fdsfadsfdsafds', 'dfsfdsfdsafdsa', '', '', 'MI', '', '', '', '', 250, 0),
(174, '5544332211', '1122334455', '', '', '', 'MI', '', '', '', '', 250, 0),
(571, '', '', '', '', '', 'MI', '', '', '', '', 500, 0),
(572, '', '', '', '', '', 'MI', '', '', '', '', 500, 0),
(573, '', '', '', '', '', 'MI', '', '', '', '', 1000, 0);
-- --------------------------------------------------------
--
-- Table structure for table `customers`
--
CREATE TABLE IF NOT EXISTS `customers` (
`Cust_ID` bigint(20) NOT NULL,
`Cust_Desc` varchar(50) NOT NULL,
`Cust_Logo` varchar(255) NOT NULL,
PRIMARY KEY (`Cust_ID`),
UNIQUE KEY `Cust_Desc` (`Cust_Desc`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `customers`
--
INSERT INTO `customers` (`Cust_ID`, `Cust_Desc`, `Cust_Logo`) VALUES
(0, 'McLaren Business Card System', ''),
(1, 'HealthPlus of Michigan', 'images/HP-Logo.png'),
(2, 'ELGA Credit Union', ''),
(3, 'Visiting Nurse Services', 'images/VNSlogo.png');
-- --------------------------------------------------------
--
-- Table structure for table `customer_login`
--
CREATE TABLE IF NOT EXISTS `customer_login` (
`Cust_Login_ID` bigint(20) NOT NULL,
`Cust_ID` bigint(20) NOT NULL,
`Cust_Login_Name` varchar(12) NOT NULL,
`Cust_Login_PW` varchar(12) NOT NULL,
`Cust_Login_First` varchar(25) NOT NULL,
`Cust_Login_Last` varchar(25) NOT NULL,
`Cust_Login_Email` varchar(255) NOT NULL,
`Cust_Admin_Flag` binary(1) NOT NULL DEFAULT '0',
`Cust_Login_Res_Flag` smallint(1) NOT NULL DEFAULT '0',
`BC_Back_Group_ID` int(11) NOT NULL,
PRIMARY KEY (`Cust_Login_ID`),
UNIQUE KEY `Cust_Login_Name` (`Cust_Login_Name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `customer_login`
--
INSERT INTO `customer_login` (`Cust_Login_ID`, `Cust_ID`, `Cust_Login_Name`, `Cust_Login_PW`, `Cust_Login_First`, `Cust_Login_Last`, `Cust_Login_Email`, `Cust_Admin_Flag`, `Cust_Login_Res_Flag`, `BC_Back_Group_ID`) VALUES
(1, 1, 'hp', 'test', 'HP', 'Admin', 'ccarmody@rieglepress.com', '1', 9, 0),
(18, 1, 'jblount', 'jimb', 'Jim', 'Blount', 'jblount@healthplus.org', '1', 0, 0),
(99, 0, 'ccarmody', 'goblue', 'Chris', 'Carmody', 'ccarmody@rieglepress.com', '0', 1, 0),
(2, 1, 'cfranzel', 'candif', 'Candi', 'Franzel', 'cfranzel@rieglepress.com', '1', 9, 0),
(4, 3, 'kcaldwell', 'trstar1633', 'Ken', 'Caldwell', 'KennethC@vnsm.org', '0', 0, 0),
(6, 3, 'vns', 'test', 'vns', 'system', 'ccarmody@rieglepress.com', '1', 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `documents`
--
CREATE TABLE IF NOT EXISTS `documents` (
`Doc_ID` int(11) NOT NULL,
`Doc_Desc` varchar(255) NOT NULL,
`Doc_Loc` varchar(255) NOT NULL,
`Doc_Type` varchar(25) NOT NULL,
`Doc_Image` varchar(255) NOT NULL,
`Doc_Pgcnt` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `documents`
--
INSERT INTO `documents` (`Doc_ID`, `Doc_Desc`, `Doc_Loc`, `Doc_Type`, `Doc_Image`, `Doc_Pgcnt`) VALUES
(1, 'Primary Cover', 'Unum1', 'Cover', 'hp200', 1),
(2, 'Primary Inside', 'Unum2', 'Inside', 'hp204', 32),
(3, 'Test', 'Unum1', 'Cover', 'hp200', 4);
-- --------------------------------------------------------
--
-- Table structure for table `doc_orders`
--
CREATE TABLE IF NOT EXISTS `doc_orders` (
`Doc_Order_ID` bigint(20) NOT NULL AUTO_INCREMENT,
`Cust_ID` bigint(20) NOT NULL,
`Cust_Login_ID` bigint(20) NOT NULL,
`Doc_Order_Date` date NOT NULL,
PRIMARY KEY (`Doc_Order_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=52 ;
--
-- Dumping data for table `doc_orders`
--
INSERT INTO `doc_orders` (`Doc_Order_ID`, `Cust_ID`, `Cust_Login_ID`, `Doc_Order_Date`) VALUES
(1, 1, 1, '2010-03-01'),
(2, 1, 1, '2010-03-01'),
(3, 1, 1, '2010-03-01'),
(4, 1, 1, '2010-03-01'),
(5, 1, 1, '2010-03-01'),
(6, 1, 1, '2010-03-01'),
(7, 1, 1, '2010-03-01'),
(8, 1, 1, '2010-03-01'),
(9, 1, 1, '2010-03-01'),
(10, 1, 1, '2010-03-01'),
(11, 1, 1, '2010-03-01'),
(12, 1, 1, '2010-03-01'),
(13, 1, 1, '2010-03-01'),
(14, 1, 1, '2010-03-01'),
(15, 1, 1, '2010-03-01'),
(16, 1, 1, '2010-03-01'),
(17, 1, 1, '2010-03-01'),
(18, 1, 1, '2010-03-01'),
(19, 1, 1, '2010-03-01'),
(20, 1, 1, '2010-03-01'),
(21, 1, 1, '2010-03-01'),
(22, 1, 1, '2010-03-01'),
(23, 1, 1, '2010-03-01'),
(24, 1, 1, '2010-03-01'),
(25, 1, 1, '2010-03-01'),
(26, 1, 1, '2010-03-01'),
(27, 1, 1, '2010-03-01'),
(28, 1, 1, '2010-03-01'),
(29, 1, 1, '2010-03-01'),
(30, 1, 1, '2010-03-01'),
(31, 1, 1, '2010-03-01'),
(32, 1, 1, '2010-03-01'),
(33, 1, 1, '2010-03-01'),
(34, 1, 1, '2010-03-01'),
(35, 1, 1, '2010-03-01'),
(36, 1, 1, '2010-03-01'),
(37, 1, 1, '2010-03-01'),
(38, 1, 1, '2010-03-01'),
(39, 1, 1, '2010-03-01'),
(40, 1, 1, '2010-03-01'),
(41, 1, 1, '2010-03-01'),
(42, 1, 1, '2010-03-01'),
(43, 1, 1, '2010-03-01'),
(44, 1, 1, '2010-03-01'),
(45, 1, 1, '2010-03-01'),
(46, 1, 1, '2010-03-01'),
(47, 1, 1, '2010-03-01'),
(48, 1, 1, '2010-03-01'),
(49, 1, 1, '2010-03-01'),
(50, 1, 1, '2010-03-01'),
(51, 1, 1, '2010-03-01');
-- --------------------------------------------------------
--
-- Table structure for table `doc_order_items`
--
CREATE TABLE IF NOT EXISTS `doc_order_items` (
`Doc_Order_ID` bigint(20) NOT NULL,
`Doc_ID` bigint(20) NOT NULL,
`Doc_Item_No` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `doc_order_items`
--
INSERT INTO `doc_order_items` (`Doc_Order_ID`, `Doc_ID`, `Doc_Item_No`) VALUES
(2, 1, 1),
(2, 2, 2),
(3, 3, 1),
(3, 2, 2),
(4, 1, 1),
(4, 3, 2),
(5, 1, 1),
(5, 3, 2),
(6, 1, 1),
(6, 3, 2),
(7, 1, 1),
(7, 3, 2),
(8, 1, 1),
(8, 3, 2),
(9, 1, 1),
(9, 3, 2),
(10, 1, 1),
(10, 3, 2),
(11, 1, 1),
(11, 3, 2),
(12, 1, 1),
(12, 3, 2),
(13, 1, 1),
(13, 3, 2),
(14, 1, 1),
(14, 3, 2),
(15, 1, 1),
(15, 3, 2),
(16, 1, 1),
(16, 3, 2),
(17, 1, 1),
(17, 3, 2),
(18, 1, 1),
(18, 3, 2),
(19, 1, 1),
(19, 3, 2),
(20, 1, 1),
(20, 3, 2),
(21, 1, 1),
(21, 3, 2),
(22, 1, 1),
(22, 3, 2),
(23, 1, 1),
(23, 3, 2),
(24, 1, 1),
(24, 3, 2),
(25, 1, 1),
(25, 3, 2),
(26, 1, 1),
(26, 3, 2),
(27, 1, 1),
(27, 3, 2),
(28, 1, 1),
(28, 3, 2),
(29, 1, 1),
(29, 3, 2),
(30, 1, 1),
(30, 3, 2),
(31, 1, 1),
(31, 3, 2),
(32, 1, 1),
(32, 3, 2),
(33, 1, 1),
(33, 3, 2),
(34, 1, 1),
(34, 3, 2),
(35, 1, 1),
(35, 3, 2),
(36, 1, 1),
(36, 3, 2),
(37, 1, 1),
(37, 3, 2),
(38, 1, 1),
(38, 3, 2),
(39, 1, 1),
(39, 3, 2),
(40, 1, 1),
(40, 3, 2),
(41, 1, 1),
(41, 3, 2),
(42, 1, 1),
(42, 3, 2),
(43, 1, 1),
(43, 3, 2),
(44, 1, 1),
(44, 3, 2),
(45, 1, 1),
(45, 3, 2),
(46, 1, 1),
(46, 3, 2),
(47, 1, 1),
(47, 3, 2),
(48, 1, 1),
(48, 3, 2),
(49, 1, 1),
(50, 3, 1),
(50, 2, 2),
(51, 3, 1),
(51, 2, 2);
-- --------------------------------------------------------
--
-- Table structure for table `orders`
--
CREATE TABLE IF NOT EXISTS `orders` (
`Order_ID` bigint(20) NOT NULL AUTO_INCREMENT,
`Cust_ID` bigint(20) NOT NULL,
`Cust_Login_ID` bigint(20) NOT NULL,
`Order_Date` date NOT NULL,
`Order_Type` char(1) NOT NULL,
`Order_Sub` enum('yes','no') NOT NULL,
`Ship_Location_ID` bigint(20) NOT NULL,
`Order_Del_Date` date NOT NULL,
`Order_Del_Text` varchar(50) NOT NULL,
`Order_Status` varchar(1) NOT NULL DEFAULT 'o',
`Order_Cost` decimal(10,2) NOT NULL,
`Order_Attn` varchar(255) NOT NULL,
PRIMARY KEY (`Order_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=596 ;
--
-- Dumping data for table `orders`
--
INSERT INTO `orders` (`Order_ID`, `Cust_ID`, `Cust_Login_ID`, `Order_Date`, `Order_Type`, `Order_Sub`, `Ship_Location_ID`, `Order_Del_Date`, `Order_Del_Text`, `Order_Status`, `Order_Cost`, `Order_Attn`) VALUES
(313, 1, 18, '2009-04-28', '', 'yes', 1, '2009-04-28', 'Delivered', 'c', '0.00', ''),
(306, 1, 0, '2009-04-21', 'w', 'yes', 98, '2009-04-21', 'Warehouse Addition', 'c', '0.00', ''),
(309, 1, 18, '2009-04-22', '', 'yes', 1, '2009-04-22', 'Delivered', 'c', '0.00', ''),
(310, 1, 0, '2009-04-22', 'w', 'yes', 99, '2009-04-22', 'Warehouse Subtraction', 'c', '0.00', ''),
(307, 1, 18, '2009-04-21', '', 'yes', 1, '2009-04-21', 'Delivered', 'c', '0.00', ''),
(308, 1, 18, '2009-04-22', '', 'yes', 1, '2009-04-22', 'Delivered', 'c', '0.00', ''),
(302, 1, 18, '2009-04-17', '', 'yes', 1, '2009-04-20', 'Delivered', 'c', '0.00', ''),
(301, 1, 18, '2009-04-16', '', 'yes', 1, '2009-04-20', 'Delivered', 'c', '0.00', ''),
(300, 1, 18, '2009-04-16', '', 'yes', 1, '2009-04-16', 'Delivered', 'c', '0.00', ''),
(299, 1, 18, '2009-04-15', '', 'yes', 1, '2009-04-16', 'Delivered', 'c', '0.00', ''),
(298, 1, 18, '2009-04-07', '', 'yes', 1, '2009-04-08', 'Delivered', 'c', '0.00', ''),
(297, 1, 18, '2009-04-07', '', 'yes', 1, '2009-04-08', 'Delivered', 'c', '0.00', ''),
(296, 1, 18, '2009-04-07', '', 'yes', 1, '2009-04-08', 'Delivered', 'c', '0.00', ''),
(295, 1, 18, '2009-04-06', '', 'yes', 1, '2009-04-07', 'Delivered', 'c', '0.00', ''),
(294, 1, 18, '2009-04-03', '', 'yes', 1, '2009-04-04', 'Delivered', 'c', '0.00', ''),
(293, 1, 18, '2009-04-01', '', 'yes', 1, '2009-04-02', 'Delivered', 'c', '0.00', ''),
(292, 1, 18, '2009-03-30', '', 'yes', 1, '2009-03-31', 'Delivered', 'c', '0.00', ''),
(291, 1, 18, '2009-03-30', '', 'yes', 1, '2009-03-31', 'Delivered', 'c', '0.00', ''),
(314, 1, 18, '2009-05-01', '', 'yes', 1, '2009-05-04', 'Delivered', 'c', '0.00', ''),
(315, 1, 0, '2009-05-01', 'w', 'yes', 99, '2009-05-01', 'Warehouse Subtraction', 'c', '0.00', ''),
(316, 1, 18, '2009-05-04', '', 'yes', 1, '2009-05-04', 'Delivered', 'c', '0.00', ''),
(317, 1, 18, '2009-05-04', '', 'yes', 1, '2009-05-04', 'Delivered', 'c', '0.00', ''),
(318, 1, 18, '2009-05-04', '', 'yes', 1, '2009-05-05', 'Delivered', 'c', '0.00', ''),
(319, 1, 18, '2009-05-05', '', 'yes', 1, '2009-05-06', 'Delivered', 'c', '0.00', ''),
(320, 1, 18, '2009-05-05', '', 'yes', 1, '2009-05-06', 'Delivered', 'c', '0.00', ''),
(321, 1, 18, '2009-05-13', '', 'yes', 1, '2009-05-13', 'Delivered', 'c', '0.00', ''),
(322, 1, 18, '2009-05-13', '', 'yes', 1, '2009-05-14', 'Delivered', 'c', '0.00', ''),
(323, 1, 18, '2009-05-14', '', 'yes', 1, '2009-05-14', 'Delivered', 'c', '0.00', ''),
(324, 1, 18, '2009-05-14', '', 'yes', 1, '2009-05-14', 'Delivered', 'c', '0.00', ''),
(325, 1, 18, '2009-05-15', '', 'yes', 1, '2009-05-18', 'Delivered', 'c', '0.00', ''),
(326, 1, 18, '2009-05-19', '', 'yes', 1, '2009-05-19', 'Delivered', 'c', '0.00', ''),
(327, 1, 18, '2009-05-19', '', 'yes', 1, '2009-05-20', 'Delivered', 'c', '0.00', ''),
(328, 1, 18, '2009-05-20', '', 'yes', 1, '2009-05-20', 'Delivered', 'c', '0.00', ''),
(329, 1, 0, '2009-05-22', 'w', 'yes', 98, '2009-05-22', 'Warehouse Addition', 'c', '0.00', ''),
(335, 1, 0, '2009-06-01', 'w', 'yes', 99, '2009-06-01', 'Warehouse Subtraction', 'c', '0.00', ''),
(331, 1, 18, '2009-05-27', '', 'yes', 1, '2009-05-27', 'Delivered', 'c', '0.00', ''),
(332, 1, 18, '2009-05-27', '', 'yes', 2, '2009-05-27', 'Delivered', 'c', '0.00', ''),
(333, 1, 18, '2009-05-28', '', 'yes', 1, '2009-05-29', 'Delivered', 'c', '0.00', ''),
(334, 1, 18, '2009-06-01', '', 'yes', 1, '2009-06-02', 'Delivered', 'c', '0.00', ''),
(336, 1, 0, '2009-05-11', 'w', 'yes', 99, '2009-05-11', 'Warehouse Subtraction', 'c', '0.00', ''),
(337, 1, 18, '2009-06-02', '', 'yes', 1, '2009-06-02', 'Delivered', 'c', '0.00', ''),
(338, 1, 18, '2009-06-03', '', 'yes', 1, '2009-06-04', 'Delivered', 'c', '0.00', ''),
(339, 1, 18, '2009-06-03', '', 'yes', 1, '2009-06-04', 'Delivered', 'c', '0.00', ''),
(340, 1, 0, '2009-06-04', 'w', 'yes', 98, '2009-06-04', 'Warehouse Addition', 'c', '0.00', ''),
(341, 1, 0, '2009-06-04', 'w', 'yes', 99, '2009-06-04', 'Warehouse Subtraction', 'c', '0.00', ''),
(342, 1, 0, '2009-06-04', 'w', 'yes', 99, '2009-06-04', 'Warehouse Subtraction', 'c', '0.00', ''),
(343, 1, 0, '2009-06-04', 'w', 'yes', 99, '2009-06-04', 'Warehouse Subtraction', 'c', '0.00', ''),
(344, 1, 0, '2009-06-04', 'w', 'yes', 98, '2009-06-04', 'Warehouse Addition', 'c', '0.00', ''),
(345, 1, 18, '2009-06-10', '', 'yes', 1, '2009-06-10', 'Delivered', 'c', '0.00', ''),
(346, 1, 18, '2009-06-11', '', 'yes', 1, '2009-06-11', 'Delivered', 'c', '0.00', ''),
(347, 1, 18, '2009-06-11', '', 'yes', 1, '2009-06-11', 'Delivered', 'c', '0.00', ''),
(348, 1, 0, '2009-06-11', 'w', 'yes', 98, '2009-06-11', 'Warehouse Addition', 'c', '0.00', ''),
(349, 1, 18, '2009-06-15', '', 'yes', 1, '2009-06-16', 'Delivered', 'c', '0.00', ''),
(350, 1, 18, '2009-06-17', '', 'yes', 1, '2009-06-18', 'Delivered', 'c', '0.00', ''),
(351, 1, 18, '2009-06-18', '', 'yes', 1, '2009-06-18', 'Delivered', 'c', '0.00', ''),
(352, 1, 18, '2009-06-22', '', 'yes', 1, '2009-06-22', 'Delivered', 'c', '0.00', ''),
(353, 1, 18, '2009-06-23', '', 'yes', 1, '2009-06-23', 'Delivered', 'c', '0.00', ''),
(354, 1, 18, '2009-06-24', '', 'yes', 1, '2009-06-24', 'Delivered', 'c', '0.00', ''),
(355, 1, 18, '2009-06-24', '', 'yes', 1, '2009-06-24', 'Delivered', 'c', '0.00', ''),
(356, 1, 18, '2009-06-25', '', 'yes', 1, '2009-06-26', 'Delivered', 'c', '0.00', ''),
(357, 1, 18, '2009-06-29', '', 'yes', 1, '2009-06-30', 'Delivered', 'c', '0.00', ''),
(358, 1, 18, '2009-06-29', '', 'yes', 1, '2009-06-30', 'Delivered', 'c', '0.00', ''),
(359, 1, 0, '2009-06-29', 'w', 'yes', 98, '2009-06-29', 'Warehouse Addition', 'c', '0.00', ''),
(360, 1, 18, '2009-06-30', '', 'yes', 1, '2009-06-30', 'Delivered', 'c', '0.00', ''),
(361, 1, 18, '2009-07-02', '', 'yes', 1, '2009-07-06', 'Delivered', 'c', '0.00', ''),
(362, 1, 18, '2009-07-06', '', 'yes', 1, '2009-07-06', 'Delivered', 'c', '0.00', ''),
(363, 1, 0, '2009-07-07', 'w', 'yes', 98, '2009-07-07', 'Warehouse Addition', 'c', '0.00', ''),
(364, 1, 0, '2009-07-08', 'w', 'yes', 98, '2009-07-08', 'Warehouse Addition', 'c', '0.00', ''),
(365, 1, 18, '2009-07-08', '', 'yes', 1, '2009-07-09', 'Delivered', 'c', '0.00', ''),
(366, 1, 18, '2009-07-09', '', 'yes', 1, '2009-07-09', 'Delivered', 'c', '0.00', ''),
(367, 1, 18, '2009-07-09', '', 'yes', 1, '2009-07-10', 'Delivered', 'c', '0.00', ''),
(368, 1, 0, '2009-07-09', 'w', 'yes', 98, '2009-07-09', 'Warehouse Addition', 'c', '0.00', ''),
(369, 1, 0, '2009-07-09', 'w', 'yes', 99, '2009-07-09', 'Warehouse Subtraction', 'c', '0.00', ''),
(370, 1, 0, '2009-07-09', 'w', 'yes', 99, '2009-07-09', 'Warehouse Subtraction', 'c', '0.00', ''),
(371, 1, 0, '2009-07-09', 'w', 'yes', 99, '2009-07-09', 'Warehouse Subtraction', 'c', '0.00', ''),
(372, 1, 0, '2009-07-09', 'w', 'yes', 99, '2009-07-09', 'Warehouse Subtraction', 'c', '0.00', ''),
(373, 1, 0, '2009-07-09', 'w', 'yes', 99, '2009-07-09', 'Warehouse Subtraction', 'c', '0.00', ''),
(374, 1, 0, '2009-07-09', 'w', 'yes', 99, '2009-07-09', 'Warehouse Subtraction', 'c', '0.00', ''),
(375, 1, 18, '2009-07-10', '', 'yes', 1, '2009-07-13', 'Delivered', 'c', '0.00', ''),
(376, 1, 18, '2009-07-14', '', 'yes', 1, '2009-07-14', 'Delivered', 'c', '0.00', ''),
(377, 1, 18, '2009-07-15', '', 'yes', 1, '2009-07-16', 'Delivered', 'c', '0.00', ''),
(378, 1, 18, '2009-07-16', '', 'yes', 1, '2009-07-16', 'Delivered', 'c', '0.00', ''),
(379, 1, 18, '2009-07-16', '', 'yes', 1, '2009-07-17', 'Delivered', 'c', '0.00', ''),
(380, 1, 0, '2009-07-17', 'w', 'yes', 99, '2009-07-17', 'Warehouse Subtraction', 'c', '0.00', ''),
(381, 1, 0, '2009-07-17', 'w', 'yes', 98, '2009-07-17', 'Warehouse Addition', 'c', '0.00', ''),
(382, 1, 0, '2009-07-27', 'w', 'yes', 98, '2009-07-27', 'Warehouse Addition', 'c', '0.00', ''),
(383, 1, 0, '2009-07-28', 'w', 'yes', 99, '2009-07-28', 'Warehouse Subtraction', 'c', '0.00', ''),
(384, 1, 18, '2009-07-28', '', 'yes', 1, '2009-07-29', 'Delivered', 'c', '0.00', ''),
(385, 1, 0, '2009-07-29', 'w', 'yes', 99, '2009-07-29', 'Warehouse Subtraction', 'c', '0.00', ''),
(386, 1, 18, '2009-07-29', '', 'yes', 1, '2009-07-29', 'Delivered', 'c', '0.00', ''),
(387, 1, 18, '2009-07-29', '', 'yes', 1, '2009-07-31', 'Delivered', 'c', '0.00', ''),
(388, 1, 18, '2009-07-31', '', 'yes', 1, '2009-07-31', 'Delivered', 'c', '0.00', ''),
(389, 1, 18, '2009-08-03', '', 'yes', 1, '2009-08-03', 'Delivered', 'c', '0.00', ''),
(390, 1, 18, '2009-08-04', '', 'yes', 1, '2009-08-05', 'Delivered', 'c', '0.00', ''),
(391, 1, 0, '2009-08-06', 'w', 'yes', 98, '2009-08-06', 'Warehouse Addition', 'c', '0.00', ''),
(392, 1, 0, '2009-08-06', 'w', 'yes', 98, '2009-08-06', 'Warehouse Addition', 'c', '0.00', ''),
(393, 1, 0, '2009-08-06', 'w', 'yes', 98, '2009-08-06', 'Warehouse Addition', 'c', '0.00', ''),
(394, 1, 18, '2009-08-07', '', 'yes', 1, '2009-08-07', 'Delivered', 'c', '0.00', ''),
(395, 1, 18, '2009-08-11', '', 'yes', 1, '2009-08-11', 'Delivered', 'c', '0.00', ''),
(396, 1, 0, '2009-08-12', 'w', 'yes', 98, '2009-08-12', 'Warehouse Addition', 'c', '0.00', ''),
(397, 1, 0, '2009-08-12', 'w', 'yes', 99, '2009-08-12', 'Warehouse Subtraction', 'c', '0.00', ''),
(398, 1, 0, '2009-08-12', 'w', 'yes', 98, '2009-08-12', 'Warehouse Addition', 'c', '0.00', ''),
(399, 1, 18, '2009-08-12', '', 'yes', 1, '2009-08-12', 'Delivered', 'c', '0.00', ''),
(400, 1, 18, '2009-08-13', '', 'yes', 1, '2009-08-13', 'Delivered', 'c', '0.00', ''),
(401, 1, 18, '2009-08-17', '', 'yes', 1, '2009-08-17', 'delivered', 'c', '0.00', ''),
(402, 1, 18, '2009-08-18', '', 'yes', 1, '2009-08-18', 'Delivered', 'c', '0.00', ''),
(403, 1, 18, '2009-08-18', '', 'yes', 1, '2009-08-19', 'Delivered', 'c', '0.00', ''),
(404, 1, 18, '2009-08-18', '', 'yes', 1, '2009-08-19', 'Delivered', 'c', '0.00', ''),
(405, 1, 18, '2009-08-18', '', 'yes', 2, '2009-08-19', 'Delivered', 'c', '0.00', ''),
(406, 1, 18, '2009-08-19', '', 'yes', 1, '2009-08-19', 'Delivered', 'c', '0.00', ''),
(407, 1, 18, '2009-08-19', '', 'yes', 1, '2009-08-19', 'Delivered', 'c', '0.00', ''),
(408, 1, 18, '2009-08-20', '', 'yes', 1, '2009-08-21', 'Delivered', 'c', '0.00', ''),
(409, 1, 18, '2009-08-21', '', 'yes', 1, '2009-08-21', 'Delivered', 'c', '0.00', ''),
(410, 1, 0, '2009-08-21', 'w', 'yes', 99, '2009-08-21', 'Warehouse Subtraction', 'c', '0.00', ''),
(411, 1, 0, '2009-08-21', 'w', 'yes', 98, '2009-08-21', 'Warehouse Addition', 'c', '0.00', ''),
(412, 1, 0, '2009-08-21', 'w', 'yes', 99, '2009-08-21', 'Warehouse Subtraction', 'c', '0.00', ''),
(413, 1, 18, '2009-08-28', '', 'yes', 1, '2009-08-28', 'Delivered', 'c', '0.00', ''),
(414, 1, 18, '2009-08-28', '', 'yes', 1, '2009-08-28', 'Delivered', 'c', '0.00', ''),
(415, 1, 0, '2009-08-31', 'w', 'yes', 98, '2009-08-31', 'Warehouse Addition', 'c', '0.00', ''),
(416, 1, 0, '2009-09-02', 'w', 'yes', 99, '2009-09-02', 'Warehouse Subtraction', 'c', '0.00', ''),
(417, 1, 0, '2009-09-02', 'w', 'yes', 98, '2009-09-02', 'Warehouse Addition', 'c', '0.00', ''),
(418, 1, 0, '2009-09-02', 'w', 'yes', 98, '2009-09-02', 'Warehouse Addition', 'c', '0.00', ''),
(419, 1, 0, '2009-09-02', 'w', 'yes', 99, '2009-09-02', 'Warehouse Subtraction', 'c', '0.00', ''),
(420, 1, 0, '2009-09-04', 'w', 'yes', 99, '2009-09-04', 'Warehouse Subtraction', 'c', '0.00', ''),
(421, 1, 0, '2009-09-04', 'w', 'yes', 99, '2009-09-04', 'Warehouse Subtraction', 'c', '0.00', ''),
(422, 1, 18, '2009-09-04', '', 'yes', 1, '2009-09-08', 'Delivered', 'c', '0.00', ''),
(423, 1, 18, '2009-09-04', '', 'yes', 1, '2009-09-08', 'Delivered', 'c', '0.00', ''),
(424, 1, 18, '2009-09-08', '', 'yes', 1, '2009-09-08', 'Delivered', 'c', '0.00', ''),
(425, 1, 18, '2009-09-10', '', 'yes', 1, '2009-09-10', 'Delivered', 'c', '0.00', ''),
(426, 1, 18, '2009-09-11', '', 'yes', 1, '2009-09-14', 'Delivered', 'c', '0.00', ''),
(427, 1, 0, '2009-09-16', 'w', 'yes', 98, '2009-09-16', 'Warehouse Addition', 'c', '0.00', ''),
(428, 1, 18, '2009-09-16', '', 'yes', 1, '0000-00-00', 'Delivered', 'c', '0.00', ''),
(429, 1, 18, '2009-09-16', '', 'yes', 1, '2009-09-17', 'delivered', 'c', '0.00', ''),
(430, 1, 18, '2009-09-21', '', 'yes', 1, '2009-09-21', 'Delivered', 'c', '0.00', ''),
(431, 1, 18, '2009-09-21', '', 'yes', 1, '2009-09-22', 'Delivered', 'c', '0.00', ''),
(432, 1, 18, '2009-09-23', '', 'yes', 0, '2009-09-23', 'Delivered', 'c', '0.00', ''),
(433, 1, 18, '2009-09-23', '', 'yes', 1, '2009-09-24', 'Delivered', 'c', '0.00', ''),
(434, 1, 18, '2009-09-24', '', 'yes', 0, '2009-09-24', 'Delivered', 'c', '0.00', ''),
(435, 1, 18, '2009-09-25', '', 'yes', 1, '2009-09-28', 'Delivered', 'c', '0.00', ''),
(436, 1, 18, '2009-09-28', '', 'yes', 1, '2009-09-28', 'delivered', 'c', '0.00', ''),
(437, 1, 18, '2009-09-30', '', 'yes', 1, '2009-09-30', 'Delivered', 'c', '0.00', ''),
(438, 1, 0, '2009-10-01', 'w', 'yes', 99, '2009-10-01', 'Warehouse Subtraction', 'c', '0.00', ''),
(439, 1, 0, '2009-10-01', 'w', 'yes', 99, '2009-10-01', 'Warehouse Subtraction', 'c', '0.00', ''),
(440, 1, 18, '2009-10-01', '', 'yes', 1, '2009-10-02', 'Delivered', 'c', '0.00', ''),
(441, 1, 18, '2009-10-06', '', 'yes', 1, '2009-10-07', 'Delivered', 'c', '0.00', ''),
(442, 1, 18, '2009-10-06', '', 'yes', 1, '2009-10-07', 'Delivered', 'c', '0.00', ''),
(443, 1, 18, '2009-10-06', '', 'yes', 1, '2009-10-07', 'Delivered', 'c', '0.00', ''),
(444, 1, 18, '2009-10-06', '', 'yes', 1, '2009-10-07', 'Delivered', 'c', '0.00', ''),
(445, 1, 18, '2009-10-07', '', 'yes', 1, '2009-10-07', 'Delivered', 'c', '0.00', ''),
(446, 1, 18, '2009-10-07', '', 'yes', 1, '2009-10-08', 'Delivered', 'c', '0.00', ''),
(447, 1, 0, '2009-10-08', 'w', 'yes', 98, '2009-10-08', 'Warehouse Addition', 'c', '0.00', ''),
(448, 1, 0, '2009-10-08', 'w', 'yes', 99, '2009-10-08', 'Warehouse Subtraction', 'c', '0.00', ''),
(449, 1, 0, '2009-10-14', 'w', 'yes', 98, '2009-10-14', 'Warehouse Addition', 'c', '0.00', ''),
(450, 1, 0, '2009-10-14', 'w', 'yes', 99, '2009-10-14', 'Warehouse Subtraction', 'c', '0.00', ''),
(451, 1, 1, '2009-10-16', '', 'yes', 1, '2009-10-19', 'Delivered', 'c', '0.00', ''),
(452, 1, 18, '2009-10-19', '', 'yes', 1, '2009-10-19', 'dELIVERED', 'c', '0.00', ''),
(453, 1, 18, '2009-10-19', '', 'yes', 1, '2009-10-19', 'DELIVERED', 'c', '0.00', ''),
(454, 1, 18, '2009-10-19', '', 'yes', 1, '2009-10-19', 'dELIVERED', 'c', '0.00', ''),
(455, 1, 0, '2009-10-19', 'w', 'yes', 98, '2009-10-19', 'Warehouse Addition', 'c', '0.00', ''),
(456, 1, 18, '2009-10-22', '', 'yes', 1, '2009-10-23', 'Delivered', 'c', '0.00', ''),
(457, 1, 0, '2009-10-26', 'w', 'yes', 99, '2009-10-26', 'Warehouse Subtraction', 'c', '0.00', ''),
(458, 1, 18, '2009-10-26', '', 'yes', 1, '2009-10-27', 'Delivered', 'c', '0.00', ''),
(459, 1, 18, '2009-10-28', '', 'yes', 1, '2009-10-30', 'Delivered', 'c', '0.00', ''),
(460, 1, 18, '2009-10-29', '', 'yes', 1, '2009-10-30', 'Delivered', 'c', '0.00', ''),
(461, 1, 18, '2009-10-29', '', 'yes', 1, '2009-10-30', 'Delivered', 'c', '0.00', ''),
(462, 1, 18, '2009-10-29', '', 'yes', 1, '2009-10-30', 'Delivered', 'c', '0.00', ''),
(463, 1, 0, '2009-11-03', 'w', 'yes', 98, '2009-11-03', 'Warehouse Addition', 'c', '0.00', ''),
(464, 1, 18, '2009-11-03', '', 'yes', 1, '2009-11-03', 'Delivered', 'c', '0.00', ''),
(465, 1, 0, '2009-11-03', 'w', 'yes', 99, '2009-11-03', 'Warehouse Subtraction', 'c', '0.00', ''),
(466, 1, 0, '2009-11-03', 'w', 'yes', 99, '2009-11-03', 'Warehouse Subtraction', 'c', '0.00', ''),
(467, 1, 18, '2009-11-04', '', 'yes', 1, '2009-11-05', 'Delivered', 'c', '0.00', ''),
(468, 1, 18, '2009-11-09', '', 'yes', 1, '2009-11-10', 'Delivered', 'c', '0.00', ''),
(469, 1, 18, '2009-11-09', '', 'yes', 1, '2009-11-10', 'Delivered', 'c', '0.00', ''),
(470, 1, 18, '2009-11-09', '', 'yes', 1, '2009-11-10', 'Delivered', 'c', '0.00', ''),
(471, 1, 18, '2009-11-10', '', 'yes', 1, '2009-11-10', 'Delivered', 'c', '0.00', ''),
(472, 1, 18, '2009-11-11', '', 'yes', 1, '2009-11-11', 'Delivered', 'c', '0.00', ''),
(473, 1, 18, '2009-11-11', '', 'yes', 1, '2009-11-12', 'Delivered', 'c', '0.00', ''),
(474, 1, 0, '2009-11-11', 'w', 'yes', 99, '2009-11-11', 'Warehouse Subtraction', 'c', '0.00', ''),
(475, 1, 18, '2009-11-12', '', 'yes', 1, '2009-11-12', 'Delivered', 'c', '0.00', ''),
(476, 1, 18, '2009-11-12', '', 'yes', 1, '2009-11-12', 'Delivered', 'c', '0.00', ''),
(477, 1, 0, '2009-11-12', 'w', 'yes', 98, '2009-11-12', 'Warehouse Addition', 'c', '0.00', ''),
(478, 1, 0, '2009-11-12', 'w', 'yes', 98, '2009-11-12', 'Warehouse Addition', 'c', '0.00', ''),
(479, 1, 18, '2009-11-16', '', 'yes', 1, '2009-11-16', 'Delivered', 'c', '0.00', ''),
(480, 1, 18, '2009-11-16', '', 'yes', 1, '2009-11-16', 'Delivered', 'c', '0.00', ''),
(481, 1, 18, '2009-11-16', '', 'yes', 1, '2009-11-17', 'Delivered', 'c', '0.00', ''),
(482, 1, 18, '2009-11-17', '', 'yes', 1, '2009-11-17', 'Delivered', 'c', '0.00', ''),
(483, 1, 0, '2009-11-18', 'w', 'yes', 99, '2009-11-18', 'Warehouse Subtraction', 'c', '0.00', ''),
(484, 1, 0, '2009-11-18', 'w', 'yes', 99, '2009-11-18', 'Warehouse Subtraction', 'c', '0.00', ''),
(485, 1, 0, '2009-11-18', 'w', 'yes', 98, '2009-11-18', 'Warehouse Addition', 'c', '0.00', ''),
(486, 1, 0, '2009-11-18', 'w', 'yes', 99, '2009-11-18', 'Warehouse Subtraction', 'c', '0.00', ''),
(487, 1, 0, '2009-11-18', 'w', 'yes', 98, '2009-11-18', 'Warehouse Addition', 'c', '0.00', ''),
(488, 1, 18, '2009-11-18', '', 'yes', 1, '2009-11-19', 'Delivered', 'c', '0.00', ''),
(494, 1, 0, '2009-12-01', 'w', 'yes', 98, '2009-12-01', 'Warehouse Addition', 'c', '0.00', ''),
(490, 1, 18, '2009-11-23', '', 'yes', 1, '2009-11-23', 'Delivered', 'c', '0.00', ''),
(491, 1, 18, '2009-11-23', '', 'yes', 1, '2009-11-24', 'Delivered', 'c', '0.00', ''),
(492, 1, 18, '2009-11-24', '', 'yes', 1, '2009-11-25', 'Delivered', 'c', '0.00', ''),
(493, 1, 18, '2009-11-25', '', 'yes', 1, '2009-11-25', 'Delivered', 'c', '0.00', ''),
(495, 1, 0, '2009-12-01', 'w', 'yes', 99, '2009-12-01', 'Warehouse Subtraction', 'c', '0.00', ''),
(496, 1, 0, '2009-12-01', 'w', 'yes', 98, '2009-12-01', 'Warehouse Addition', 'c', '0.00', ''),
(497, 1, 0, '2009-12-01', 'w', 'yes', 99, '2009-12-01', 'Warehouse Subtraction', 'c', '0.00', ''),
(498, 1, 0, '2009-12-01', 'w', 'yes', 99, '2009-12-01', 'Warehouse Subtraction', 'c', '0.00', ''),
(499, 1, 0, '2009-12-01', 'w', 'yes', 98, '2009-12-01', 'Warehouse Addition', 'c', '0.00', ''),
(500, 1, 0, '2009-12-01', 'w', 'yes', 99, '2009-12-01', 'Warehouse Subtraction', 'c', '0.00', ''),
(501, 1, 18, '2009-12-02', '', 'yes', 1, '2009-12-02', 'Delivered', 'c', '0.00', ''),
(502, 1, 18, '2009-12-02', '', 'yes', 1, '2009-12-03', 'Delivered', 'c', '0.00', ''),
(503, 1, 18, '2009-12-02', '', 'yes', 1, '2009-12-03', 'Delivered', 'c', '0.00', ''),
(504, 1, 18, '2009-12-02', '', 'yes', 1, '2009-12-03', 'Delivered', 'c', '0.00', ''),
(505, 1, 18, '2009-12-02', '', 'yes', 1, '2009-12-03', 'Delivered', 'c', '0.00', ''),
(506, 1, 18, '2009-12-03', '', 'yes', 1, '2009-12-04', 'Delivered', 'c', '0.00', ''),
(507, 1, 0, '2009-12-03', 'w', 'yes', 99, '2009-12-03', 'Warehouse Subtraction', 'c', '0.00', ''),
(508, 1, 0, '2009-12-03', 'w', 'yes', 99, '2009-12-03', 'Warehouse Subtraction', 'c', '0.00', ''),
(509, 1, 18, '2009-12-03', '', 'yes', 1, '2009-12-04', 'Delivered', 'c', '0.00', ''),
(510, 1, 0, '2009-12-04', 'w', 'yes', 98, '2009-12-04', 'Warehouse Addition', 'c', '0.00', ''),
(511, 1, 18, '2009-12-04', '', 'yes', 1, '2009-12-07', 'Delivered', 'c', '0.00', ''),
(512, 1, 18, '2009-12-09', '', 'yes', 1, '2009-12-10', 'Delivered', 'c', '0.00', ''),
(513, 1, 18, '2009-12-09', '', 'yes', 1, '2009-12-10', 'Delivered', 'c', '0.00', ''),
(514, 1, 0, '2009-12-15', 'w', 'yes', 99, '2009-12-15', 'Warehouse Subtraction', 'c', '0.00', ''),
(515, 1, 18, '2009-12-15', '', 'yes', 1, '2009-12-16', 'Delivered', 'c', '0.00', ''),
(516, 1, 18, '2009-12-16', '', 'yes', 1, '2009-12-16', 'Delivered', 'c', '0.00', ''),
(517, 1, 0, '2009-12-16', 'w', 'yes', 99, '2009-12-16', 'Warehouse Subtraction', 'c', '0.00', ''),
(518, 1, 18, '2009-12-16', '', 'yes', 1, '2009-12-17', 'Delivered', 'c', '0.00', ''),
(519, 1, 0, '2009-12-16', 'w', 'yes', 98, '2009-12-16', 'Warehouse Addition', 'c', '0.00', ''),
(520, 1, 0, '2009-12-16', 'w', 'yes', 98, '2009-12-16', 'Warehouse Addition', 'c', '0.00', ''),
(521, 1, 0, '2009-12-16', 'w', 'yes', 99, '2009-12-16', 'Warehouse Subtraction', 'c', '0.00', ''),
(522, 1, 0, '2009-12-16', 'w', 'yes', 99, '2009-12-16', 'Warehouse Subtraction', 'c', '0.00', ''),
(523, 1, 0, '2009-12-16', 'w', 'yes', 98, '2009-12-16', 'Warehouse Addition', 'c', '0.00', ''),
(524, 1, 0, '2009-12-16', 'w', 'yes', 99, '2009-12-16', 'Warehouse Subtraction', 'c', '0.00', ''),
(525, 1, 18, '2009-12-17', '', 'yes', 1, '2009-12-17', 'Delivered', 'c', '0.00', ''),
(526, 1, 18, '2009-12-17', '', 'yes', 2, '2009-12-21', 'Delivered', 'c', '0.00', ''),
(527, 1, 18, '2009-12-21', '', 'yes', 1, '2009-12-22', 'Delivered', 'c', '0.00', ''),
(528, 1, 18, '2009-12-23', '', 'yes', 1, '2009-12-23', 'Delivered', 'c', '0.00', ''),
(529, 1, 0, '2010-01-04', 'w', 'yes', 99, '2010-01-04', 'Warehouse Subtraction', 'c', '0.00', ''),
(530, 1, 0, '2010-01-04', 'w', 'yes', 98, '2010-01-04', 'Warehouse Addition', 'c', '0.00', ''),
(531, 1, 0, '2010-01-04', 'w', 'yes', 99, '2010-01-04', 'Warehouse Subtraction', 'c', '0.00', ''),
(532, 1, 18, '2010-01-05', '', 'yes', 1, '2010-01-05', 'Delivered', 'c', '0.00', ''),
(533, 1, 18, '2010-01-05', '', 'yes', 1, '2010-01-06', 'Delivered', 'c', '0.00', ''),
(534, 1, 18, '2010-01-06', '', 'yes', 1, '2010-01-06', 'Delivered', 'c', '0.00', ''),
(535, 1, 18, '2010-01-06', '', 'yes', 1, '2010-01-08', 'delivered', 'c', '0.00', ''),
(536, 1, 18, '2010-01-08', '', 'yes', 1, '2010-01-08', 'delivered', 'c', '0.00', ''),
(537, 1, 18, '2010-01-11', '', 'yes', 1, '2010-01-12', 'Delivered', 'c', '0.00', ''),
(538, 1, 18, '2010-01-11', '', 'yes', 1, '2010-01-12', 'Delivered', 'c', '0.00', ''),
(539, 1, 18, '2010-01-11', '', 'yes', 1, '2010-01-13', 'Delivered', 'c', '0.00', ''),
(540, 1, 18, '2010-01-12', '', 'yes', 1, '0000-00-00', '', 'o', '0.00', ''),
(541, 1, 18, '2010-01-12', '', 'yes', 2, '2010-01-13', 'Delivered', 'c', '0.00', ''),
(542, 1, 18, '2010-01-13', '', 'yes', 1, '2010-01-14', 'Delivered', 'c', '0.00', ''),
(543, 1, 18, '2010-01-13', '', 'yes', 1, '2010-01-14', 'Delivered', 'c', '0.00', ''),
(544, 1, 18, '2010-01-13', '', 'yes', 1, '2010-01-14', 'Delivered', 'c', '0.00', ''),
(545, 1, 18, '2010-01-14', '', 'yes', 1, '2010-01-14', 'Delivered', 'c', '0.00', ''),
(546, 1, 0, '2010-01-15', 'w', 'yes', 98, '2010-01-15', 'Warehouse Addition', 'c', '0.00', ''),
(547, 1, 18, '2010-01-15', '', 'yes', 1, '2010-01-19', 'Delivered', 'c', '0.00', ''),
(548, 1, 18, '2010-01-19', '', 'yes', 1, '2010-01-19', 'Delivered', 'c', '0.00', ''),
(549, 1, 1, '2010-01-20', '', 'yes', 1, '2010-01-21', 'Delivered', 'c', '0.00', ''),
(550, 1, 0, '2010-01-20', 'w', 'yes', 98, '2010-01-20', 'Warehouse Addition', 'c', '0.00', ''),
(551, 1, 2, '2010-01-20', '', 'yes', 1, '2010-01-20', 'Delivered', 'c', '0.00', ''),
(552, 1, 18, '2010-01-20', '', 'yes', 1, '2010-01-21', 'Delivered', 'c', '0.00', ''),
(553, 1, 18, '2010-01-22', '', 'yes', 1, '2010-01-25', 'Delivered', 'c', '0.00', ''),
(554, 1, 2, '2010-01-25', '', 'yes', 1, '2010-01-25', 'Delivered', 'c', '0.00', ''),
(555, 1, 0, '2010-01-28', 'w', 'yes', 98, '2010-01-28', 'Warehouse Addition', 'c', '0.00', ''),
(556, 1, 0, '2010-01-28', 'w', 'yes', 99, '2010-01-28', 'Warehouse Subtraction', 'c', '0.00', ''),
(557, 1, 0, '2010-01-28', 'w', 'yes', 98, '2010-01-28', 'Warehouse Addition', 'c', '0.00', ''),
(558, 1, 0, '2010-01-28', 'w', 'yes', 98, '2010-01-28', 'Warehouse Addition', 'c', '0.00', ''),
(559, 1, 0, '2010-01-28', 'w', 'yes', 99, '2010-01-28', 'Warehouse Subtraction', 'c', '0.00', ''),
(561, 1, 0, '2010-02-01', 'w', 'yes', 99, '2010-02-01', 'Warehouse Subtraction', 'c', '0.00', ''),
(562, 1, 0, '2010-02-01', 'w', 'yes', 98, '2010-02-01', 'Warehouse Addition', 'c', '0.00', ''),
(563, 1, 0, '2010-02-01', 'w', 'yes', 98, '2010-02-01', 'Warehouse Addition', 'c', '0.00', ''),
(564, 1, 18, '2010-02-01', '', 'yes', 1, '2010-02-02', 'Delivered', 'c', '0.00', ''),
(568, 1, 0, '2010-02-03', 'w', 'yes', 98, '2010-02-03', 'Warehouse Addition', 'c', '0.00', ''),
(569, 1, 18, '2010-02-03', '', 'yes', 1, '2010-02-04', 'Delivered', 'c', '0.00', ' '),
(574, 1, 0, '2010-02-09', 'w', 'yes', 99, '2010-02-09', 'Warehouse Subtraction', 'c', '0.00', ''),
(575, 1, 0, '2010-02-09', 'w', 'yes', 98, '2010-02-09', 'Warehouse Addition', 'c', '0.00', ''),
(576, 1, 0, '2010-02-09', 'w', 'yes', 98, '2010-02-09', 'Warehouse Addition', 'c', '0.00', ''),
(577, 1, 0, '2010-02-09', 'w', 'yes', 99, '2010-02-09', 'Warehouse Subtraction', 'c', '0.00', ''),
(578, 1, 0, '2010-02-09', 'w', 'yes', 99, '2010-02-09', 'Warehouse Subtraction', 'c', '0.00', ''),
(581, 3, 4, '2010-02-09', '', 'yes', 1, '2010-02-10', 'Delivered', 'c', '0.00', ' Ken Caldwell, Marketing'),
(582, 1, 18, '2010-02-12', '', 'yes', 1, '0000-00-00', '', 'o', '0.00', ' '),
(583, 1, 18, '2010-02-12', '', 'yes', 1, '2010-02-15', 'Delivered', 'c', '0.00', ' '),
(587, 1, 18, '2010-02-12', '', 'yes', 1, '2010-02-15', 'Delivered', 'c', '0.00', ' '),
(586, 1, 18, '2010-02-12', '', 'yes', 1, '2010-02-15', 'Delivered', 'c', '0.00', ' '),
(588, 3, 4, '2010-02-16', '', 'yes', 3, '2010-02-16', 'UPS', 'c', '0.00', 'Matthew Meeuwse, Medical Records Dept.'),
(589, 1, 18, '2010-02-17', '', 'yes', 1, '2010-02-17', 'Delivered', 'c', '0.00', ' '),
(590, 1, 18, '2010-02-18', '', 'yes', 1, '0000-00-00', '', 'o', '0.00', ' '),
(591, 3, 4, '2010-02-18', '', 'yes', 1, '0000-00-00', '', 'o', '0.00', 'Ken Caldwell, Marketing Dept.'),
(595, 1, 1, '2010-02-27', '', 'yes', 1, '0000-00-00', '', 'o', '0.00', ' test');
-- --------------------------------------------------------
--
-- Table structure for table `order_items`
--
CREATE TABLE IF NOT EXISTS `order_items` (
`Order_ID` bigint(20) NOT NULL,
`Part_ID` bigint(20) NOT NULL,
`Order_Item_No` smallint(6) NOT NULL,
`Order_Amount` bigint(20) NOT NULL,
`Order_Item_Description` varchar(255) NOT NULL,
`Order_Item_Cost` decimal(10,2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `order_items`
--
INSERT INTO `order_items` (`Order_ID`, `Part_ID`, `Order_Item_No`, `Order_Amount`, `Order_Item_Description`, `Order_Item_Cost`) VALUES
(302, 24, 1, 2, '', '0.00'),
(301, 59, 4, 1, '', '0.00'),
(301, 16, 3, 5, '', '0.00'),
(301, 14, 2, 6, '', '0.00'),
(301, 2, 1, 1, '', '0.00'),
(300, 42, 1, 2, '', '0.00'),
(299, 5, 2, 4, '', '0.00'),
(299, 47, 1, 4, '', '0.00'),
(298, 74, 4, 1, '', '0.00'),
(298, 14, 3, 6, '', '0.00'),
(298, 2, 2, 2, '', '0.00'),
(298, 1, 1, 3, '', '0.00'),
(297, 69, 2, 1, '', '0.00'),
(297, 24, 1, 1, '', '0.00'),
(296, 70, 2, 10, '', '0.00'),
(296, 114, 1, 20, '', '0.00'),
(295, 35, 1, 5, '', '0.00'),
(294, 11, 1, 1, '', '0.00'),
(293, 9, 1, 3, '', '0.00'),
(292, 18, 2, 6, '', '0.00'),
(292, 12, 1, 3, '', '0.00'),
(291, 79, 2, 2, '', '0.00'),
(291, 32, 1, 5, '', '0.00'),
(307, 42, 1, 5, '', '0.00'),
(306, 68, 1, 301, 'Reprint from 11/08.', '0.00'),
(307, 7, 2, 2, '', '0.00'),
(308, 32, 1, 10, '', '0.00'),
(309, 1, 1, 2, '', '0.00'),
(309, 2, 2, 1, '', '0.00'),
(309, 14, 3, 10, '', '0.00'),
(310, 111, 1, 12, 'Used for mailer on 4/16/09.', '0.00'),
(313, 22, 1, 2, '', '0.00'),
(313, 98, 2, 5, '', '0.00'),
(314, 1, 1, 2, '', '0.00'),
(314, 2, 2, 2, '', '0.00'),
(314, 14, 3, 6, '', '0.00'),
(314, 74, 4, 1, '', '0.00'),
(314, 50, 5, 1, '', '0.00'),
(314, 59, 6, 2, '', '0.00'),
(315, 110, 1, 1250, 'Balance after May 2009 mailer.', '0.00'),
(316, 12, 1, 4, '', '0.00'),
(317, 68, 1, 48, '', '0.00'),
(318, 10, 1, 2, '', '0.00'),
(319, 35, 1, 4, '', '0.00'),
(320, 10, 1, 4, '', '0.00'),
(321, 28, 1, 6, '', '0.00'),
(322, 1, 1, 1, '', '0.00'),
(322, 2, 2, 2, '', '0.00'),
(322, 14, 3, 6, '', '0.00'),
(322, 59, 4, 1, '', '0.00'),
(323, 114, 1, 16, '', '0.00'),
(324, 44, 1, 5, '', '0.00'),
(325, 42, 1, 2, '', '0.00'),
(326, 23, 1, 1, '', '0.00'),
(327, 41, 1, 3, '', '0.00'),
(327, 42, 2, 8, '', '0.00'),
(328, 108, 2, 30, '', '0.00'),
(328, 4, 1, 9, '', '0.00'),
(329, 22, 1, 4, 'Reprint 5/13.', '0.00'),
(335, 14, 1, 4, 'Used for job B528. Envelope imprint.', '0.00'),
(331, 1, 1, 1, '', '0.00'),
(331, 2, 2, 3, '', '0.00'),
(331, 14, 3, 6, '', '0.00'),
(331, 17, 4, 5, '', '0.00'),
(331, 74, 5, 1, '', '0.00'),
(331, 59, 6, 3, '', '0.00'),
(331, 19, 7, 2, '', '0.00'),
(332, 56, 1, 6, '', '0.00'),
(333, 32, 1, 10, '', '0.00'),
(334, 6, 1, 8, '', '0.00'),
(336, 18, 1, 17, 'Used for job A8685. Mailing.', '0.00'),
(337, 12, 1, 4, '', '0.00'),
(338, 59, 4, 2, '', '0.00'),
(338, 14, 3, 8, '', '0.00'),
(338, 2, 2, 4, '', '0.00'),
(338, 1, 1, 2, '', '0.00'),
(339, 39, 1, 4, '', '0.00'),
(340, 8, 1, 22, 'Reprint 5/09. Balance of 10m reprint.', '0.00'),
(341, 110, 1, 1550, 'Used for packet mailing 6/2/2009.', '0.00'),
(342, 18, 1, 13, 'Used for ProviderPlus mailing job #B534. 6/3/2009', '0.00'),
(343, 111, 1, 17, 'Used for mailing on 6/3/2009.', '0.00'),
(344, 16, 1, 100, 'Reprint from 05/01/09.', '0.00'),
(345, 18, 1, 10, '', '0.00'),
(346, 113, 1, 28, '', '0.00'),
(347, 14, 1, 6, '', '0.00'),
(347, 74, 2, 2, '', '0.00'),
(347, 50, 3, 2, '', '0.00'),
(348, 74, 1, 9, 'Reprint with change 5/09.', '0.00'),
(349, 24, 1, 2, '', '0.00'),
(349, 69, 2, 1, '', '0.00'),
(350, 32, 1, 10, '', '0.00'),
(351, 108, 3, 11, '', '0.00'),
(351, 8, 2, 14, '', '0.00'),
(351, 4, 1, 2, '', '0.00'),
(352, 26, 1, 3, '', '0.00'),
(353, 9, 1, 3, '', '0.00'),
(354, 38, 1, 2, '', '0.00'),
(355, 10, 1, 5, '', '0.00'),
(356, 1, 1, 3, '', '0.00'),
(356, 2, 2, 3, '', '0.00'),
(356, 14, 3, 8, '', '0.00'),
(356, 17, 4, 4, '', '0.00'),
(356, 59, 5, 3, '', '0.00'),
(357, 84, 1, 4, '', '0.00'),
(358, 76, 1, 1, '', '0.00'),
(359, 1, 1, 40, 'Reprint 6/09.', '0.00'),
(360, 16, 1, 8, '', '0.00'),
(361, 109, 1, 2, '', '0.00'),
(362, 94, 1, 2, '', '0.00'),
(363, 19, 1, 51, 'Reprint 6/09.', '0.00'),
(364, 44, 1, 36, 'Reprint 6/09.', '0.00'),
(365, 19, 4, 3, '', '0.00'),
(365, 59, 3, 3, '', '0.00'),
(365, 50, 2, 1, '', '0.00'),
(365, 14, 1, 7, '', '0.00'),
(366, 10, 1, 2, '', '0.00'),
(367, 6, 1, 18, '', '0.00'),
(368, 6, 1, 50, 'Reprint 6/09.', '0.00'),
(369, 111, 1, 9, 'Used for mailing job #B617', '0.00'),
(370, 77, 1, 3, 'Used for mailing job #B602.', '0.00'),
(371, 86, 1, 19, 'Disposed of all forms 6/09.', '0.00'),
(372, 18, 1, 30, 'Used for mailing in jobs #B592,B593,B594,B595.', '0.00'),
(373, 18, 1, 1, 'Used for mailing job #B572.', '0.00'),
(374, 32, 1, 1, 'Used for mailing job #572 (Bev Seddon)', '0.00'),
(375, 57, 1, 1, '', '0.00'),
(376, 8, 1, 8, '', '0.00'),
(376, 108, 2, 10, '', '0.00'),
(376, 4, 3, 5, '', '0.00'),
(377, 94, 1, 3, '', '0.00'),
(378, 7, 1, 2, '', '0.00'),
(379, 1, 1, 4, '', '0.00'),
(379, 2, 2, 2, '', '0.00'),
(379, 14, 3, 6, '', '0.00'),
(380, 7, 1, 14, 'Used for mailing in job #B640', '0.00'),
(381, 110, 1, 3800, 'Addition to warehouse 7/09.', '0.00'),
(382, 69, 1, 5, 'Reprint 7/09.', '0.00'),
(383, 115, 1, 43, 'Used for mailing dated 7/14/09.', '0.00'),
(384, 6, 1, 10, '', '0.00'),
(384, 32, 2, 10, '', '0.00'),
(385, 110, 1, 1949, 'Used for mailing in job #B596', '0.00'),
(386, 1, 1, 2, '', '0.00'),
(386, 2, 2, 2, '', '0.00'),
(386, 14, 3, 1, '', '0.00'),
(386, 50, 4, 1, '', '0.00'),
(386, 59, 5, 2, '', '0.00'),
(387, 14, 1, 12, '', '0.00'),
(388, 74, 1, 1, '', '0.00'),
(389, 12, 1, 3, '', '0.00'),
(390, 1, 1, 2, '', '0.00'),
(390, 2, 2, 3, '', '0.00'),
(391, 24, 1, 6, 'Reprint 7/09.', '0.00'),
(392, 70, 1, 14, 'Reprint 7/09.', '0.00'),
(393, 114, 1, 60, 'Reprint 7/09.', '0.00'),
(394, 74, 4, 1, '', '0.00'),
(394, 59, 3, 2, '', '0.00'),
(394, 16, 2, 4, '', '0.00'),
(394, 14, 1, 4, '', '0.00'),
(395, 114, 1, 16, '', '0.00'),
(395, 70, 2, 8, '', '0.00'),
(396, 12, 1, 87, 'Reprint 8/09.', '0.00'),
(397, 12, 1, 10, 'Used for imprint mailer B709 and future mailer.', '0.00'),
(398, 14, 1, 218, 'Reprint 8/09.', '0.00'),
(399, 12, 1, 4, '', '0.00'),
(400, 14, 1, 8, '', '0.00'),
(400, 59, 2, 2, '', '0.00'),
(401, 9, 1, 2, '', '0.00'),
(402, 42, 1, 3, '', '0.00'),
(403, 11, 1, 1, '', '0.00'),
(404, 42, 1, 7, '', '0.00'),
(405, 56, 1, 10, '', '0.00'),
(406, 4, 1, 3, '', '0.00'),
(407, 24, 1, 2, '', '0.00'),
(407, 69, 2, 5, '', '0.00'),
(408, 23, 1, 1, '', '0.00'),
(409, 1, 1, 1, '', '0.00'),
(409, 2, 2, 2, '', '0.00'),
(410, 110, 1, 1933, 'Used for mailer #B685 8/1/09.', '0.00'),
(411, 110, 1, 2230, 'Stock left over after mailer on 8/1/09', '0.00'),
(412, 111, 1, 11, 'Used for mailer #B735 8/19/09.', '0.00'),
(413, 2, 1, 2, '', '0.00'),
(413, 14, 2, 6, '', '0.00'),
(413, 74, 3, 1, '', '0.00'),
(413, 59, 4, 2, '', '0.00'),
(414, 112, 1, 1, '', '0.00'),
(415, 42, 1, 75, 'Reprint 6/09 job#B586.', '0.00'),
(416, 110, 1, 1449, 'Used for mailer #B754 8/28/09.', '0.00'),
(417, 2, 1, 38, 'Reprint 8/09.', '0.00'),
(418, 32, 1, 50, 'Reprint 8/09.', '0.00'),
(419, 7, 1, 4, 'Used for mailer #B753 8/1/09.', '0.00'),
(420, 18, 1, 15, 'Used for mailer #B726 9/3/09.', '0.00'),
(421, 18, 1, 13, 'Used for mailer #B705 8/31/09.', '0.00'),
(422, 14, 1, 4, '', '0.00'),
(422, 59, 2, 2, '', '0.00'),
(422, 10, 3, 1, '', '0.00'),
(422, 19, 4, 2, '', '0.00'),
(423, 28, 1, 6, '', '0.00'),
(424, 73, 1, 10, '', '0.00'),
(425, 1, 1, 4, '', '0.00'),
(426, 68, 1, 48, '', '0.00'),
(427, 4, 1, 50, 'Reprint 9/09 job#B760.', '0.00'),
(428, 84, 1, 4, '', '0.00'),
(428, 114, 2, 40, '', '0.00'),
(428, 70, 3, 6, '', '0.00'),
(429, 2, 1, 3, '', '0.00'),
(429, 14, 2, 6, '', '0.00'),
(429, 59, 3, 1, '', '0.00'),
(430, 116, 1, 2, '', '0.00'),
(431, 12, 1, 6, '', '0.00'),
(432, 50, 1, 2, '', '0.00'),
(433, 42, 1, 3, '', '0.00'),
(433, 44, 2, 4, '', '0.00'),
(433, 46, 3, 4, '', '0.00'),
(433, 47, 4, 4, '', '0.00'),
(433, 112, 5, 1, '', '0.00'),
(434, 1, 1, 1, '', '0.00'),
(434, 2, 2, 3, '', '0.00'),
(434, 14, 3, 2, '', '0.00'),
(434, 64, 4, 1, '', '0.00'),
(434, 74, 5, 2, '', '0.00'),
(434, 59, 6, 3, '', '0.00'),
(435, 116, 1, 4, '', '0.00'),
(436, 9, 1, 2, '', '0.00'),
(437, 32, 1, 10, '', '0.00'),
(438, 42, 1, 8, 'Used for SOM Mailer 8/09.', '0.00'),
(439, 42, 1, 31, 'Used for mailer dated 9/18/09 - #B922,#B923', '0.00'),
(440, 18, 1, 6, '', '0.00'),
(440, 12, 2, 5, '', '0.00'),
(441, 1, 1, 3, '', '0.00'),
(441, 14, 2, 8, '', '0.00'),
(441, 59, 3, 2, '', '0.00'),
(442, 42, 1, 7, '', '0.00'),
(443, 108, 1, 29, '', '0.00'),
(444, 5, 1, 4, '', '0.00'),
(445, 46, 1, 4, '', '0.00'),
(446, 44, 1, 4, '', '0.00'),
(447, 110, 1, 1163, 'Receipt 10/09.', '0.00'),
(448, 110, 1, 1499, 'Used for mailer #B824.', '0.00'),
(449, 7, 1, 51, 'Reorder 9/09. Job#B758/B00620.', '0.00'),
(450, 7, 1, 10, 'Used for mailer #B753 Medicaid Exec Order.', '0.00'),
(451, 1, 1, 4, '', '0.00'),
(452, 59, 1, 2, '', '0.00'),
(452, 2, 2, 4, '', '0.00'),
(452, 14, 3, 8, '', '0.00'),
(452, 74, 4, 1, '', '0.00'),
(452, 19, 5, 2, '', '0.00'),
(452, 6, 6, 10, '', '0.00'),
(452, 32, 7, 10, '', '0.00'),
(453, 112, 1, 2, '', '0.00'),
(454, 45, 1, 4, '', '0.00'),
(455, 18, 1, 206, 'Reprint 10/09 job #B817.', '0.00'),
(456, 32, 1, 15, '', '0.00'),
(457, 27, 1, 7, 'Used for mailer #B1266.', '0.00'),
(458, 79, 1, 3, '', '0.00'),
(459, 2, 1, 2, '', '0.00'),
(459, 14, 2, 8, '', '0.00'),
(459, 17, 3, 4, '', '0.00'),
(459, 74, 4, 1, '', '0.00'),
(459, 59, 5, 3, '', '0.00'),
(460, 44, 1, 4, '', '0.00'),
(461, 94, 1, 8, '', '0.00'),
(462, 4, 1, 6, '', '0.00'),
(463, 64, 1, 4, 'Receipt 10/09 job#B865.', '0.00'),
(464, 103, 1, 8, '', '0.00'),
(465, 28, 1, 2, 'Used for mailer #B875.', '0.00'),
(466, 28, 1, 7, 'Used for mailer #B920.', '0.00'),
(467, 2, 1, 3, '', '0.00'),
(467, 14, 2, 6, '', '0.00'),
(467, 50, 3, 2, '', '0.00'),
(468, 42, 1, 5, '', '0.00'),
(469, 46, 1, 4, '', '0.00'),
(470, 68, 1, 48, '', '0.00'),
(471, 116, 1, 5, '', '0.00'),
(472, 38, 1, 1, '', '0.00'),
(473, 28, 1, 4, '', '0.00'),
(474, 16, 1, 35, 'Used for mailer #B.', '0.00'),
(475, 38, 1, 5, '', '0.00'),
(476, 2, 1, 1, '', '0.00'),
(476, 14, 2, 12, '', '0.00'),
(476, 59, 3, 3, '', '0.00'),
(477, 74, 1, 10, 'Reprint 10/09.', '0.00'),
(478, 59, 1, 40, 'Receipt 10/09 job#B829.', '0.00'),
(479, 9, 1, 2, '', '0.00'),
(480, 116, 1, 4, '', '0.00'),
(481, 24, 1, 2, '', '0.00'),
(482, 8, 1, 10, '', '0.00'),
(483, 118, 1, 14, 'Delivery 10/29/09.', '0.00'),
(484, 118, 1, 4, 'Delivery 11/16/09.', '0.00'),
(485, 8, 1, 29, 'Reprint 10/09 job #B859.', '0.00'),
(486, 8, 1, 10, 'Delivery 10/29/09.', '0.00'),
(487, 28, 1, 71, 'Reprint 11/09 job #B901. Also changed ctn qty to 700.', '0.00'),
(488, 1, 1, 2, '', '0.00'),
(488, 2, 2, 1, '', '0.00'),
(488, 14, 3, 5, '', '0.00'),
(488, 59, 4, 2, '', '0.00'),
(494, 119, 1, 50, 'Initial printing 11/09. Job#B924.', '0.00'),
(490, 11, 1, 1, '', '0.00'),
(491, 117, 1, 2, '', '0.00'),
(492, 32, 1, 10, '', '0.00'),
(493, 2, 1, 4, '', '0.00'),
(495, 119, 1, 8, 'Delivery on 11/09.', '0.00'),
(496, 120, 1, 20, 'initial printing 11/09. Job#B987.', '0.00'),
(497, 120, 1, 6, 'Delivery on 11/09.', '0.00'),
(498, 62, 1, 1, 'Destroy old version 11/09.', '0.00'),
(499, 62, 1, 20, 'Reprint w/changes 11/09. New ctn count 250 from 200. Job#B988.', '0.00'),
(500, 62, 1, 6, 'Delivery on 11/09.', '0.00'),
(501, 16, 1, 6, '', '0.00'),
(502, 19, 8, 2, '', '0.00'),
(502, 59, 7, 2, '', '0.00'),
(502, 74, 6, 1, '', '0.00'),
(502, 64, 5, 1, '', '0.00'),
(502, 17, 4, 5, '', '0.00'),
(502, 14, 3, 6, '', '0.00'),
(502, 2, 2, 1, '', '0.00'),
(502, 1, 1, 2, '', '0.00'),
(503, 119, 1, 5, '', '0.00'),
(504, 73, 1, 1, '', '0.00'),
(505, 23, 1, 1, '', '0.00'),
(506, 7, 1, 4, '', '0.00'),
(507, 62, 1, 4, 'Delivery on 12/2/09.', '0.00'),
(508, 120, 1, 4, 'Delivery on 12/2/09.', '0.00'),
(509, 73, 1, 9, '', '0.00'),
(510, 53, 1, 50, 'Reprint 12/09. Job#B984. Changed package qty to 500.', '0.00'),
(511, 2, 1, 3, '', '0.00'),
(512, 62, 1, 8, '', '0.00'),
(513, 83, 1, 10, '', '0.00'),
(514, 28, 1, 1, 'Used for mailers B1027-B1030.', '0.00'),
(515, 32, 1, 10, '', '0.00'),
(515, 119, 2, 20, '', '0.00'),
(516, 8, 1, 9, '', '0.00'),
(517, 28, 1, 7, 'Used for mailer B1548..', '0.00'),
(518, 19, 9, 3, '', '0.00'),
(518, 18, 8, 10, '', '0.00'),
(518, 59, 7, 3, '', '0.00'),
(518, 117, 6, 2, '', '0.00'),
(518, 74, 5, 1, '', '0.00'),
(518, 14, 4, 12, '', '0.00'),
(518, 12, 3, 6, '', '0.00'),
(518, 2, 2, 3, '', '0.00'),
(518, 1, 1, 3, '', '0.00'),
(519, 121, 1, 207, 'Initial printing 11/09. Job#B883.', '0.00'),
(520, 38, 1, 10, 'Reprint 12/09. Job#B1023.', '0.00'),
(521, 38, 1, 3, 'Delivery on 12/7/09.', '0.00'),
(522, 18, 1, 16, 'Used for mailer B1709.', '0.00'),
(523, 113, 1, 322, 'Reprint 12/09. Job#B1394. Carton quantity changed to 14.', '0.00'),
(524, 113, 1, 72, 'Delivery on 11/23/09.', '0.00'),
(525, 53, 1, 12, '', '0.00'),
(526, 56, 1, 10, '', '0.00'),
(527, 112, 1, 3, '', '0.00'),
(528, 44, 1, 4, '', '0.00'),
(529, 12, 1, 5, 'Used for mailer B1860 (UAW GM Retiree Letters)', '0.00'),
(530, 110, 1, 1181, 'Rec''d for future mailings. 12/09.', '0.00'),
(531, 110, 1, 1291, 'Used for mailer 12/09.', '0.00'),
(532, 116, 1, 3, '', '0.00'),
(533, 1, 1, 2, '', '0.00'),
(533, 2, 2, 2, '', '0.00'),
(533, 14, 3, 6, '', '0.00'),
(533, 74, 4, 1, '', '0.00'),
(534, 84, 1, 4, '', '0.00'),
(535, 35, 1, 4, '', '0.00'),
(536, 59, 1, 4, '', '0.00'),
(537, 42, 1, 2, '', '0.00'),
(538, 28, 1, 6, '', '0.00'),
(539, 119, 1, 4, '', '0.00'),
(539, 117, 2, 1, '', '0.00'),
(540, 35, 1, 6, '', '0.00'),
(541, 56, 1, 10, '', '0.00'),
(542, 121, 1, 10, '', '0.00'),
(543, 4, 1, 10, '', '0.00'),
(544, 109, 1, 1, '', '0.00'),
(545, 2, 1, 3, '', '0.00'),
(545, 14, 2, 6, '', '0.00'),
(545, 74, 3, 2, '', '0.00'),
(545, 99, 4, 1, '', '0.00'),
(545, 117, 5, 1, '', '0.00'),
(545, 59, 6, 2, '', '0.00'),
(546, 32, 1, 40, 'Reprint 11/09 job#B928.', '0.00'),
(547, 114, 1, 28, '', '0.00'),
(548, 24, 1, 3, '', '0.00'),
(549, 108, 1, 12, '', '0.00'),
(550, 108, 1, 229, 'Reprint 12/09 job#B1810.', '0.00'),
(551, 9, 1, 4, '', '0.00'),
(552, 121, 1, 8, '', '0.00'),
(553, 1, 1, 3, '', '0.00'),
(553, 2, 2, 2, '', '0.00'),
(553, 14, 3, 5, '', '0.00'),
(553, 117, 4, 1, '', '0.00'),
(554, 63, 1, 20, '', '0.00'),
(555, 8, 1, 267, 'Reprint 12/09 job#B1774. Changed unit to 150/ctn.', '0.00'),
(556, 8, 1, 17, 'Delivered 2500 on 12/22/09.', '0.00'),
(557, 24, 1, 8, 'Reprint 1/10 job#B1910.', '0.00'),
(558, 69, 1, 20, 'Reprint 1/10 job#B1909.', '0.00'),
(559, 69, 1, 5, 'Delivered 2500 on 1/13/10.', '0.00'),
(561, 73, 1, 7, 'Used in mailer 2/2010. Job# B1172.', '0.00'),
(562, 9, 1, 30, 'Reprint 1/10 job#B1953. 22500 adjustment from previous print.', '0.00'),
(563, 2, 1, 40, 'Reprint 1/10 job#B1140.', '0.00'),
(564, 1, 1, 2, '', '0.00'),
(564, 2, 2, 4, '', '0.00'),
(564, 14, 3, 5, '', '0.00'),
(564, 74, 4, 1, '', '0.00'),
(564, 59, 5, 3, '', '0.00'),
(568, 70, 1, 60, 'Reprint 1/10 job#B1152.', '0.00'),
(569, 70, 1, 20, '', '0.00'),
(574, 80, 1, 5, 'Used in mailer 2/2010. Job# B1196.', '0.00'),
(575, 15, 1, 8, 'Reprint 2/10 job#B2124.', '0.00'),
(576, 110, 1, 1437, 'Rec''d for future mailings. 1/10.', '0.00'),
(577, 110, 1, 1772, 'Used in mailer 1/2010. Job# B1173.', '0.00'),
(578, 73, 1, 7, 'Used in mailer 1/2010. Job# B1172.', '0.00'),
(581, 301, 1, 1, '', '0.00'),
(582, 35, 1, 4, '', '0.00'),
(583, 1, 1, 1, '', '0.00'),
(583, 2, 2, 2, '', '0.00'),
(583, 14, 3, 8, '', '0.00'),
(583, 74, 4, 1, '', '0.00'),
(583, 59, 5, 2, '', '0.00'),
(583, 32, 6, 10, '', '0.00'),
(583, 119, 7, 8, '', '0.00'),
(587, 15, 1, 2, '', '0.00'),
(586, 121, 1, 6, '', '0.00'),
(588, 313, 1, 1, '', '0.00'),
(589, 24, 1, 3, '', '0.00'),
(589, 69, 2, 10, '', '0.00'),
(590, 8, 1, 20, '', '0.00'),
(591, 311, 1, 1, '', '0.00'),
(591, 312, 2, 1, '', '0.00'),
(595, 91, 2, 5, '', '0.00'),
(595, 60, 1, 4, '', '0.00');
-- --------------------------------------------------------
--
-- Table structure for table `parts`
--
CREATE TABLE IF NOT EXISTS `parts` (
`Part_ID` bigint(20) NOT NULL,
`Customer_ID` bigint(20) NOT NULL,
`Part_Desc` varchar(50) NOT NULL,
`Part_No` varchar(25) NOT NULL,
`Part_Pix` varchar(100) NOT NULL,
`Part_Type` varchar(25) NOT NULL,
`Part_Unit` varchar(12) NOT NULL,
`Part_Unit_Qty` smallint(6) NOT NULL,
`Part_Inv_Qty` int(11) NOT NULL,
`Part_Inv_Thres` int(11) NOT NULL DEFAULT '0',
`Part_Res_Flag` smallint(1) NOT NULL DEFAULT '0',
`Part_Cost` decimal(10,2) NOT NULL,
PRIMARY KEY (`Part_ID`),
UNIQUE KEY `Part_Desc` (`Part_Desc`,`Part_No`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `parts`
--
INSERT INTO `parts` (`Part_ID`, `Customer_ID`, `Part_Desc`, `Part_No`, `Part_Pix`, `Part_Type`, `Part_Unit`, `Part_Unit_Qty`, `Part_Inv_Qty`, `Part_Inv_Thres`, `Part_Res_Flag`, `Part_Cost`) VALUES
(110, 1, 'Medicaid Packets Furnished', '6089', 'hp206a', 'Miscellaneous', 'Each', 1, 0, 0, 0, '0.00'),
(75, 1, 'GHP #10 Regular Envelope', '6059', 'hp6059', 'Small Envelopes', 'Ctn', 2500, 0, 0, 0, '0.00'),
(74, 1, 'GHP #10 Window Envelope', '6058', 'hp6058', 'Small Envelopes', 'Ctn', 2500, 3, 0, 0, '0.00'),
(73, 1, 'Get Smart Know When Antibiotics Work Brochures', '6057', 'hp6057', 'Brochures/Flyers', 'Pkg', 100, 31, 0, 0, '0.00'),
(113, 1, 'MedicarePlus Provider Directory', '6046', 'hp6046', 'Directories/Formularies', 'Ctn', 14, 250, 0, 0, '0.00'),
(71, 1, 'Employer Administrative Guide', '6055', 'hp6055', 'Manuals/Guides', 'Each', 1, 348, 0, 0, '0.00'),
(34, 1, 'FEHB Brochure 2009', '6056', 'hp6056', 'Riders/Contracts', 'Ctn', 75, 15, 0, 0, '0.00'),
(35, 1, 'Plain Scratch Pad - Box', '6090', 'hp6090', 'Miscellaneous', 'Ctn', 1, 15, 0, 0, '0.00'),
(68, 1, 'Commercial Provider Directory April 1, 2008', '6047', 'hp6047', 'Directories/Formularies', 'Ctn', 30, 157, 0, 0, '0.00'),
(67, 1, 'Enjoy The Beauty Comm. Brochure Blanks', '6052', 'hp6052', 'Brochures/Flyers', 'Pkg', 250, 4, 0, 0, '0.00'),
(66, 1, 'Commercial Mammogram Cards', '6051', 'hp6051', 'Postcards', 'Pkg', 250, 22, 0, 0, '0.00'),
(65, 1, 'Sets Provider Manual Chapter 14 & 15', '6050', 'hp6050', 'Manuals/Guides', 'Each', 1, 12, 0, 0, '0.00'),
(64, 1, 'BHP #10 Window Envelope', '6049', 'hp6049', 'Small Envelopes', 'Ctn', 2500, 4, 0, 0, '0.00'),
(63, 1, '2010 Abridged Formulary', '6048', 'hp6048', 'Directories/Formularies', 'Ctn', 50, 26, 0, 0, '0.00'),
(62, 1, 'Senior Summary Of Benefits', '9426', 'hp9426', 'Riders/Contracts', 'Ctn', 250, 2, 0, 0, '0.00'),
(61, 1, 'Healthy Solutions Treatment Plan', '9425', 'hp9425', 'Brochures/Flyers', 'Pkg', 500, 10, 0, 0, '0.00'),
(60, 1, 'Healthy Solutions #10 Envelope', '9424', 'hp9424', 'Small Envelopes', 'Ctn', 2500, 3, 0, 0, '0.00'),
(59, 1, 'PPO #10 Window Envelope', '9371', 'hp9371', 'Small Envelopes', 'Ctn', 2500, 16, 0, 0, '0.00'),
(58, 1, 'PPO #10 Regular Envelope', '9370', 'hp9370', 'Small Envelopes', 'Ctn', 2500, 1, 0, 0, '0.00'),
(57, 1, 'HealthQuest Letterhead', '9362', 'hp9362', 'Letterhead/Blanks', 'Ctn', 2000, 21, 5, 0, '0.00'),
(56, 1, 'Special Window Envelope (Print On Demand)', '9361', 'hp9361', 'Large Envelopes', 'Ctn', 500, 34, 0, 0, '0.00'),
(55, 1, 'Senior Benefit Rider B8', '9352', 'hpnoimage', 'Riders/Contracts', 'Ctn', 0, 0, 0, 0, '0.00'),
(54, 1, 'Senior Benefit Rider B2', '9350', 'hpnoimage', 'Riders/Contracts', 'Ctn', 0, 0, 0, 0, '0.00'),
(53, 1, 'PPO Letterhead', '9343', 'hp9343', 'Letterhead/Blanks', 'Pkg', 500, 38, 0, 0, '0.00'),
(52, 1, 'Benefit Summary Sheets w/photo (4 people)', '9320', 'hpnoimage', 'Letterhead/Blanks', 'Ctn', 2000, 0, 0, 0, '0.00'),
(51, 1, 'Benefit Summary Sheets w/photo (3 people)', '9319', 'hp9319', 'Letterhead/Blanks', 'Ctn', 2000, 0, 0, 0, '0.00'),
(50, 1, 'Senior #10 Window Envelope', '9275', 'hp9275', 'Small Envelopes', 'Ctn', 2500, 5, 0, 0, '0.00'),
(49, 1, 'H+ Healthy Solutions/Saver Plus', '8181-1', 'hp81811', 'Brochures/Flyers', 'Pkg', 500, 30, 0, 0, '0.00'),
(48, 1, 'Commercial Map One Sheet', '81567', 'hp81567', 'Brochures/Flyers', 'Pkg', 250, 16, 0, 0, '0.00'),
(47, 1, 'Ask For 90 One Sheet', '81566', 'hp81566', 'Brochures/Flyers', 'Pkg', 250, 18, 0, 0, '0.00'),
(46, 1, 'HealthQuest One Sheet', '81565', 'hp81565', 'Brochures/Flyers', 'Pkg', 250, 8, 0, 0, '0.00'),
(45, 1, 'POS One Sheet', '81563', 'hp81563', 'Brochures/Flyers', 'Pkg', 250, 6, 0, 0, '0.00'),
(44, 1, 'PPO One Sheet', '81562', 'hp81562', 'Brochures/Flyers', 'Pkg', 250, 26, 0, 0, '0.00'),
(43, 1, 'HMO One Sheet', '81561', 'hp81561', 'Brochures/Flyers', 'Pkg', 250, 0, 0, 0, '0.00'),
(42, 1, 'H+ Enrollment Brochure', '8128-8', 'hp81288', 'Brochures/Flyers', 'Ctn', 200, 12, 0, 0, '0.00'),
(41, 1, 'H+ Employer Brochure', '8128-7', 'hp81287', 'Brochures/Flyers', 'Ctn', 200, 2, 0, 0, '0.00'),
(40, 1, 'H+ Member Retention Postcards', '8128-11', 'hp812811', 'Postcards', 'Ctn', 1275, 6, 0, 0, '0.00'),
(39, 1, 'H+ Member Brochures', '8106-3', 'hp81063', 'Brochures/Flyers', 'Ctn', 300, 3, 0, 0, '0.00'),
(111, 1, 'Mammogram and Pap Postcard', '9427', 'hp9427', 'Postcards', 'Pkg', 250, 133, 0, 0, '0.00'),
(36, 1, 'Enjoy the Beauty Brochure Comm 8 1/2 x 11', '6091', 'hp6091', 'Brochures/Flyers', 'Pkg', 25, 30, 0, 0, '0.00'),
(37, 1, 'Enjoy the Beauty Brochure Med 8 1/2 x 11', '6092', 'hp6092', 'Brochures/Flyers', 'Pkg', 25, 21, 0, 0, '0.00'),
(38, 1, 'MedicarePlus Reply Envelope ', '704B', 'hp704b', 'Large Envelopes', 'Box', 500, 7, 0, 0, '0.00'),
(33, 1, 'Smooth Second Sheet', '6060B', 'hp6060b', 'Letterhead/Blanks', 'Ctn', 2000, 11, 0, 0, '0.00'),
(32, 1, '2 Color Letterhead', '6010B', 'hp6010b', 'Letterhead/Blanks', 'Ctn', 2000, 42, 20, 0, '0.00'),
(69, 1, 'PPO Lock Box Envelope', '9359', 'hp9359', 'Small Envelopes', 'Box', 500, 5, 0, 0, '0.00'),
(30, 1, '10x13 Senior Pres Stik Catalog Env.', '5601', 'hp5601', 'Large Envelopes', 'Ctn', 500, 21, 10, 0, '0.00'),
(29, 1, '9x12 Senior Booklet Envelope', '5600', 'hp5600', 'Large Envelopes', 'Ctn', 500, 0, 0, 0, '0.00'),
(28, 1, 'HPM 2 Color 10x13 Pres Stik Catalog Env.', '5130A', 'hp5130a', 'Large Envelopes', 'Ctn', 700, 53, 10, 0, '0.00'),
(27, 1, 'HPM 2 Color 10x13 Booklet Envelope', '5130', 'hp5130', 'Large Envelopes', 'Ctn', 500, 7, 10, 0, '0.00'),
(26, 1, 'Claim Return Envelope', '5120', 'hp5120', 'Large Envelopes', 'Ctn', 500, 13, 0, 0, '0.00'),
(25, 1, '#9 Bus. Reply Health & Lifestyles Envelope', '5077', 'hp5077', 'Small Envelopes', 'Ctn', 2500, 10, 0, 0, '0.00'),
(24, 1, '#9 Lock Box Envelope', '5075', 'hp5075', 'Small Envelopes', 'Ctn', 2500, 5, 5, 0, '0.00'),
(23, 1, 'Attn: COB #9 Business Reply Envelope', '5072', 'hp5072', 'Small Envelopes', 'Ctn', 2500, 5, 5, 0, '0.00'),
(22, 1, 'Business Reply Enrollment Envelope', '5071', 'hp5071', 'Small Envelopes', 'Ctn', 2500, 5, 5, 0, '0.00'),
(20, 1, '#9 Business Reply Envelope', '5070', 'hp5070', 'Small Envelopes', 'Ctn', 2500, 0, 5, 0, '0.00'),
(21, 1, '#9 Business Reply Envelope for Medical Sv', '5070D', 'hp5070d', 'Small Envelopes', 'Ctn', 2500, 0, 5, 0, '0.00'),
(19, 1, '9x12 Special Window Envelope', '5060', 'hp5060', 'Large Envelopes', 'Ctn', 500, 43, 5, 0, '0.00'),
(18, 1, '2 Color 9x12 Booklet Envelope', '5050A', 'hp5050a', 'Large Envelopes', 'Ctn', 500, 209, 40, 0, '0.00'),
(17, 1, '6x9 Window Envelope w/Inside Tint', '5048', 'hp5048', 'Small Envelopes', 'Ctn', 1000, 18, 10, 0, '0.00'),
(16, 1, '6x9 Booklet Envelope , Flint', '5046', 'hp5046', 'Small Envelopes', 'Ctn', 500, 47, 5, 0, '0.00'),
(15, 1, 'HPM 9x12 Booklet Envelopes, Saginaw', '5040', 'hp5040', 'Large Envelopes', 'Ctn', 500, 6, 5, 0, '0.00'),
(14, 1, '2 Color #10 Inside Tint Window Envelope', '5030B', 'hp5030b', 'Small Envelopes', 'Ctn', 2500, 81, 25, 0, '0.00'),
(13, 1, '2 Color #10 Window Smooth Envelope', '5030A', 'hp5030a', 'Small Envelopes', 'Box', 500, 2, 5, 0, '0.00'),
(12, 1, '2 Color #10 Reg. Smooth Envelope', '5020A', 'hp5020a', 'Small Envelopes', 'Ctn', 2500, 55, 5, 0, '0.00'),
(11, 1, '2 Color #10 Reg. Envelope, Saginaw', '5000', 'hp5000', 'Small Envelopes', 'Ctn', 2500, 0, 5, 0, '0.00'),
(10, 1, '9x11 1/2 Catalog Envelope, Double Window', '301', 'hp301', 'Large Envelopes', 'Ctn', 600, 12, 10, 0, '0.00'),
(9, 1, 'Double Window Envelope', '300', 'hp300', 'Small Envelopes', 'Ctn', 2500, 26, 5, 0, '0.00'),
(8, 1, 'Medicaid Subscriber Contracts', '2150', 'hp2150', 'Riders/Contracts', 'Ctn', 150, 250, 5, 0, '0.00'),
(7, 1, 'Partners #10 Regular Envelopes', '209A', 'hp209a', 'Small Envelopes', 'Ctn', 2500, 37, 5, 0, '0.00'),
(6, 1, '2 Color Partners Letterhead', '209', 'hp209', 'Letterhead/Blanks', 'Ctn', 2000, 22, 4, 0, '0.00'),
(5, 1, 'HPP 9x12 Booklet Envelope', '207', 'hp207', 'Large Envelopes', 'Ctn', 500, 11, 5, 0, '0.00'),
(4, 1, 'HHP 10x13 Pres Stik Catalog Envelope', '206A', 'hp206a', 'Large Envelopes', 'Ctn', 600, 38, 10, 0, '0.00'),
(3, 1, '10x13 Booklet Envelope', '206', 'hp206', 'Large Envelopes', 'Ctn', 500, 10, 5, 0, '0.00'),
(2, 1, 'HPP #10 Window Envelope', '204', 'hp204', 'Small Envelopes', 'Ctn', 2500, 35, 4, 0, '0.00'),
(1, 1, 'HPO #10 Window Envelope w/inside tint', '200', 'hp200', 'Small Envelopes', 'Ctn', 2500, 4, 4, 0, '0.00'),
(76, 1, 'Glaucoma Postcard', '6060', 'hp6060', 'Postcards', 'Pkg', 250, 0, 0, 0, '0.00'),
(77, 1, 'New Glaucoma Postcard', '6061', 'hp6061', 'Postcards', 'Pkg', 250, 15, 0, 0, '0.00'),
(78, 1, 'GM SALRET Folders', '6062', 'hp6062', 'Miscellaneous', 'Pkg', 25, 80, 0, 0, '0.00'),
(79, 1, 'HealthPlus Options Letterhead', '6063', 'hp6063', 'Letterhead/Blanks', 'Ctn', 2000, 11, 5, 0, '0.00'),
(80, 1, 'HealthQuest Reminder Postcard', '6064', 'hp6064', 'Postcards', 'Pkg', 250, 1, 0, 0, '0.00'),
(81, 1, 'HealthPlus Binder', '6065', 'hpnoimage', 'Miscellaneous', 'Ctn', 13, 49, 0, 0, '0.00'),
(82, 1, 'Set HP Partners Provider Dir Covers & Back Covers', '6066', 'hpnoimage', 'Directories/Formularies', 'Ctn', 1000, 10, 0, 0, '0.00'),
(83, 1, 'HPI Certificate Of Coverage Book', '6067', 'hp6067', 'Riders/Contracts', 'Ctn', 20, 181, 0, 0, '0.00'),
(84, 1, 'HPP Membership Card', '6068', 'hp6068', 'Miscellaneous', 'Ctn', 3000, 14, 0, 0, '0.00'),
(85, 1, 'HealthQuest Welcome To HPM Brochure', '6069', 'hp6069', 'Brochures/Flyers', 'Pkg', 250, 3, 0, 0, '0.00'),
(86, 1, 'Group Bill Invoice Form', '6070', 'hp6070', 'Letterhead/Blanks', 'Ctn', 2000, 0, 0, 0, '0.00'),
(112, 1, 'Cofinity Directory', '6045', 'hp6045', 'Directories/Formularies', 'Ctn', 30, 55, 0, 0, '0.00'),
(88, 1, 'Enjoy The Beauty Medicaid Brochure Blanks', '6072', 'hp6072', 'Brochures/Flyers', 'Pkg', 250, 1, 0, 0, '0.00'),
(89, 1, 'Medicaid Mammogram Postcard', '6073', 'hp6073', 'Postcards', 'Pkg', 250, 17, 0, 0, '0.00'),
(90, 1, 'New Provider Manual - 2007 (Complete)', '6074', 'hpnoimage', 'Manuals/Guides', 'Each', 1, 12, 0, 0, '0.00'),
(91, 1, 'Point Of Service Member Handbooks, 2007-2008', '6075', 'hp6075', 'Handbooks', 'Ctn', 150, 16, 0, 0, '0.00'),
(93, 1, 'HPM PPO Member Handbook', '6076', 'hp6076', 'Handbooks', 'Ctn', 100, 33, 0, 0, '0.00'),
(94, 1, 'PPO Provider Directory, 2007-2008', '6077', 'hp6077', 'Directories/Formularies', 'Ctn', 18, 193, 0, 0, '0.00'),
(95, 1, 'Commercial Resource Guide', '6078', 'hp6078', 'Manuals/Guides', 'Ctn', 125, 3, 0, 0, '0.00'),
(96, 1, 'Retention Mailer', '6079', 'hp6079', 'Brochures/Flyers', 'Pkg', 250, 18, 0, 0, '0.00'),
(97, 1, 'Benefit Rider WR', '9256', 'hp9256', 'Riders/Contracts', 'Ctn', 575, 0, 0, 0, '0.00'),
(98, 1, 'Senior Letterhead', '6080', 'hp6080', 'Letterhead/Blanks', 'Ctn', 2000, 20, 0, 0, '0.00'),
(99, 1, 'SHP #10 Window Envelope', '6081', 'hp6081', 'Small Envelopes', 'Ctn', 2500, 4, 0, 0, '0.00'),
(100, 1, 'Transportation Card', '6082', 'hp6082', 'Miscellaneous', 'Ctn', 9000, 5, 0, 0, '0.00'),
(102, 1, 'Well Baby Postcard, Comm Ages 1-18 Months', '6083', 'hp6083', 'Postcards', 'Pkg', 250, 6, 0, 0, '0.00'),
(103, 1, 'Well Baby Postcard, Medicaid Ages 1-18 Months', '6084', 'hp6084', 'Postcards', 'Pkg', 250, 18, 0, 0, '0.00'),
(104, 1, 'Well Care Exam Postcard Age 12-17 Commercial', '6085', 'hp6085', 'Postcards', 'Pkg', 250, 21, 0, 0, '0.00'),
(105, 1, 'Well Care Exam Postcard Age 12-17 Medicaid', '6086', 'hp6086', 'Postcards', 'Pkg', 250, 19, 0, 0, '0.00'),
(106, 1, 'Well Child Postcard, Comm Ages 2-6', '6087', 'hp6087', 'Postcards', 'Pkg', 250, 14, 0, 0, '0.00'),
(107, 1, 'Well Child Postcard, Medicaid Ages 2-6', '6088', 'hp6088', 'Postcards', 'Pkg', 250, 28, 0, 0, '0.00'),
(108, 1, 'H+ Partners Handbook 2009-2010', '8165-1', 'hp81651', 'Handbooks', 'Ctn', 175, 217, 0, 0, '0.00'),
(109, 1, 'MI Child HPM Book', '8165-2', 'hp81652', 'Handbooks', 'Ctn', 175, 5, 0, 0, '0.00'),
(70, 1, 'PPO Line Group Bill Invoice', '9360', 'hp9360', 'Letterhead/Blanks', 'Pkg', 500, 40, 0, 0, '0.00'),
(114, 1, 'HPM Group Bill Invoice', '6070a', 'hp6070a', 'Letterhead/Blanks', 'Pkg', 500, 0, 5, 0, '0.00'),
(115, 1, 'Heart Help Mailer (6x8)', '6096', 'hp6096', 'Postcards', 'pkg', 250, 37, 5, 0, '0.00'),
(116, 1, 'Generic Return Address #10 Window Envelopes', '6097', 'hp6097', 'Small Envelopes', 'Ctn', 2500, 2, 2, 0, '0.00'),
(117, 1, 'MedicarePlus #10 Window Envelope', '6102', 'hp6102', 'Small Envelopes', 'Ctn', 2500, 13, 2, 0, '0.00'),
(118, 1, 'FEHB 2010 Brochure', '9429', 'hp9429', 'Riders/Contracts', 'Ctn', 100, 13, 0, 0, '0.00'),
(119, 1, 'MedicarePlus Letterhead', '6103', 'hp6103', 'Letterhead/Blanks', 'Pkg', 500, 5, 0, 0, '0.00'),
(120, 1, 'PPO Summary of Benefits', '9428', 'hp9428', 'Riders/Contracts', 'Ctn', 250, 10, 0, 0, '0.00'),
(121, 1, 'Medicare Advantage HMO Subscriber Contract', '8089', 'hp8089', 'Riders/Contracts', 'Ctn', 54, 183, 0, 0, '0.00'),
(122, 1, 'Heart Help Mailer (8.5x11)', '9435', 'hp6096', 'Postcards', 'pkg', 250, 31, 0, 0, '0.00'),
(123, 1, 'Glaucoma Mailer', '9434', 'hp9434', 'Postcards', 'pkg', 250, 16, 0, 0, '0.00'),
(300, 3, 'Donation Envelopes - Lansing', '0001', 'vn0001', 'Donation Envelopes', 'Box', 500, 3, 0, 0, '0.00'),
(301, 3, 'Donation Envelopes - Davison', '0002', 'vn0002', 'Donation Envelopes', 'Box', 500, 4, 0, 0, '0.00'),
(302, 3, 'Donation Envelopes - Bay City', '0003', 'vn0003', 'Donation Envelopes', 'Box', 500, 1, 0, 0, '0.00'),
(303, 3, '#10 Regular Envelopes - Davison', '0004', 'vn0004', 'Business Envelopes', 'Box', 500, 3, 0, 0, '0.00'),
(304, 3, 'Hospice...A Guide Caring Handbook', '0005', 'vn0005', 'Handbooks', 'Ctn', 240, 10, 0, 0, '0.00'),
(305, 3, 'Medical Equipment & Supplies Handbook', '0006', 'vn0006', 'Handbooks', 'Ctn', 200, 2, 0, 0, '0.00'),
(306, 3, '#10 Regular Envelopes - Bay City', '0007', 'vn0007', 'Business Envelopes', 'Box', 500, 10, 0, 0, '0.00'),
(307, 3, 'Letterhead - Davison', '0008', 'vn0008', 'Letterhead', 'Pkg', 500, 12, 0, 0, '0.00'),
(308, 3, 'Letterhead - Mount Clemons', '0009', 'vn0009', 'Letterhead', 'Pkg', 500, 19, 0, 0, '0.00'),
(309, 3, 'Letterhead - Lansing', '0010', 'vn0010', 'Letterhead', 'Pkg', 500, 8, 0, 0, '0.00'),
(310, 3, 'Letterhead - Bay City', '0011', 'vn0011', 'Letterhead', 'Pkg', 500, 11, 0, 0, '0.00'),
(311, 3, 'Home Health & Palliative Care Brochure', '0012', 'vn0012', 'Brochures', 'Ctn', 900, 3, 0, 0, '0.00'),
(312, 3, 'Home Medical Brochure', '0013', 'vn0013', 'Brochures', 'Ctn', 900, 3, 0, 0, '0.00'),
(313, 3, 'Hospice Brochure', '0014', 'vn0014', 'Brochures', 'Ctn', 900, 0, 0, 0, '0.00'),
(314, 3, 'VNS Medical Supplies Brochure', '0015', 'vn0015', 'Brochures', 'Ctn', 1200, 5, 0, 0, '0.00'),
(315, 3, '#9 BRE Envelope - Davison', '0016', 'vn0016', 'Business Envelopes', 'Box', 500, 5, 0, 0, '0.00'),
(316, 3, '#10 Envelope - Home Medical', '0017', 'vn0017', 'Business Envelopes', 'Box', 500, 5, 0, 0, '0.00'),
(317, 3, '#10 Regular Envelopes - Lansing', '0018', 'vn0018', 'Business Envelopes', 'Box', 500, 10, 0, 0, '0.00');
-- --------------------------------------------------------
--
-- Table structure for table `quotes`
--
CREATE TABLE IF NOT EXISTS `quotes` (
`qte_id` bigint(20) NOT NULL AUTO_INCREMENT,
`qte_date` date NOT NULL,
`qte_name` varchar(255) NOT NULL,
`qte_business` varchar(255) NOT NULL,
`qte_phone` varchar(255) NOT NULL,
`qte_email` varchar(255) NOT NULL,
`qte_title` varchar(255) NOT NULL,
`qte_qty1` int(11) NOT NULL,
`qte_qty2` int(11) NOT NULL,
`qte_qty3` int(11) NOT NULL,
`qte_desc` varchar(255) NOT NULL,
PRIMARY KEY (`qte_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=357 ;
--
-- Dumping data for table `quotes`
--
INSERT INTO `quotes` (`qte_id`, `qte_date`, `qte_name`, `qte_business`, `qte_phone`, `qte_email`, `qte_title`, `qte_qty1`, `qte_qty2`, `qte_qty3`, `qte_desc`) VALUES
(1, '2008-07-24', '', '', '', '', '', 0, 0, 0, ''),
(2, '2008-07-24', '', '', '', '', '', 0, 0, 0, ''),
(3, '2008-07-24', '', '', '', '', '', 0, 0, 0, ''),
(4, '2008-07-24', '', 'text', '', '', '', 0, 0, 0, ''),
(5, '2008-07-24', 'test', 'test2', 'test3', 'test4', 'test5', 1, 2, 3, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nyyyyyyyyyyyyyyyyyyyyyyyyy'),
(6, '2008-07-24', 'fdsaf', 'fdsafdsa', 'fdsafds', 'fdsafdsa', 'fdsafdsa', 0, 0, 0, 'fdsafdsafdsa'),
(7, '2008-07-24', 'fdsaf', 'fdsafdsa', 'fdsafds', 'fdsafdsa', 'fdsafdsa', 0, 0, 0, 'fdsafdsafdsa'),
(8, '2008-07-24', 'fdsaf', 'fdsafdsa', 'fdsafds', 'fdsafdsa', 'fdsafdsa', 0, 0, 0, 'fdsafdsafdsa'),
(9, '2008-07-24', '12345', 'sadff', 'asdffdsa', 'dsfafsa', 'dffdsa', 12, 34, 56, 'fdsaffsadfda\r\nfdsdfsaafds\r\nfdsfdsfdsads'),
(10, '2008-07-24', 'Test', 'xxx', 'xxx', 'xxx', 'Brochures', 1000, 2000, 3000, 'kjfdsajkfhfdsaklhfsadkj\r\nasfdh;akshdfkjsakjdfjhk\r\ndsafllkdsakllkfdhdsf'),
(11, '2008-07-25', 'Mike', 'A', '1313', '', 'pix', 1, 0, 0, 'Ha Ha'),
(12, '2008-07-25', 'Mike', 'A', '1313', '', 'pix', 1, 0, 0, 'Ha Ha'),
(13, '2008-07-25', 'vdvdsvcxz', '', 'vcxvcxzvcx', 'vcxzvcxzvcxz', '', 0, 0, 0, 'vcxzvcxzvcxz'),
(14, '2008-07-29', 'Randall D. Cooper', 'Early College Alliance at Eastern Michigan University', '734-487-7520', 'rcooper4@emich.eud', 'Class Record Book Form 267-M-W.O. , Daily Lesson Plan Book Form N. 106', 10, 10, 0, 'Looking for a quote for 10 of the Class Record Book Form 267-M-W.O. and the Daily Lesson Plan Book Form N. 106. These item numbers were given to me, but I couldn''t find anything on your site. Please let me know. Thanks!\r\n\r\nRandall D. Cooper'),
(15, '2008-07-30', 'Mary Makarewicz', 'Edison Learning Inc.', '865-329-3637', 'mmakarewicz@edisonlearning.com', '201-9-10 and CB910', 50, 100, 0, '201-9-10: Deluxe Edition Class Record Book; Qty 50\r\nCB910: Class Record Book: qty 100 \r\n\r\n'),
(16, '2008-07-30', 'Maria Voli', 'Center Street Elementary School', '516 3058333', 'mvoli@herricks.org', 'National School Calendar, Class Plan Books', 5, 10, 0, ''),
(17, '2008-08-01', '', '', '', '', '', 0, 0, 0, ''),
(18, '2008-08-04', 'Rebecca Brink', 'WA State University', '(509)335-3694', 'rlbrink@wsu.edu', 'National School Calendar', 20, 0, 0, 'Quote for 20 calendars & any applicable shipping/handling charges. Do I fax, phone the order in, or am I able to order on line?'),
(19, '2008-08-04', '', '', '', '', '', 0, 0, 0, ''),
(20, '2008-08-05', 'Mae Anderson', 'Norland Middle School', '305 653-1210', 'mcolely@dadeschools.net', 'national school calendar 2008-2009', 12, 0, 0, ''),
(21, '2008-08-05', 'frank stanwood', '', '9782237414', 'frankstanwood@live.com', 'class record book', 50, 0, 0, 'I would like to have some old class record books that used to be mad by the JL Hammett Co. made. It is the Eaton No.5 Class Rgister. I think you might have printed this several years ago for them. The printing color is green and brown. It has a heavy gree'),
(22, '2008-08-06', 'Dennis Burin', 'Hazel Park Schools', '248-542-0800', 'd.burin@hazelpark.k12.mi.us', '', 200, 0, 0, 'We would like price info on CA-60''s and the inserts for Health Records and scholastic data'),
(23, '2008-08-06', 'Hazel Johnson', 'Anchor Bay Middle School North', '586-725-7373', 'hjohnson@abs.misd.net', '201-9 or 10 Deluxe Class Record Book, 2-Year Educational Calendar, Deluxe National School Calendar', 25, 4, 4, ''),
(24, '2008-08-08', 'Laura Monrroy', 'Morristown School District 75', '623-388-2336', 'lmonrroy@morristowneld75.org', 'CUMULATIVE RECORD FOLDER CA-39', 0, 0, 0, 'We are a small district the most that I could order would 100.'),
(25, '2008-08-12', 'Teresa Naylor', 'Webber Elementary(Lake Orion)', '', 'tnaylor@lakeorion.k12.mi.us', 'Teacher Daily Memorandum Book', 0, 0, 0, 'We had previously purchased the 40 wk. books from you, but my school no longer orders them. I''d like to purchase some if the price and shipping is reasonable. Can you provide me with some info. on this product: Teacher''s Daily Memorandum Book (40 weeks) F'),
(26, '2008-08-12', 'Susan Tune', 'Fort Worth ISD', '817-871-2202', 'Susan.Tune@fwisd.org', 'National School Calendar', 50, 0, 0, 'I need a quote for your regular edition school calendar.'),
(27, '2008-08-13', 'Virginia Waugaman', 'Michigan School for the Deaf', '810-257-1429', 'waugamanv@michigan.gov', '106-8 and 201-9-10', 23, 11, 0, 'Need 23 copies of the Daily Lesson Plan and 11 copies of the Delux Class Record Book \r\n\r\nNeed Quote back by email, need documentation for purchase order. '),
(28, '2008-08-13', 'Mike Grocholski', 'Houser & Hennesse Advertising', '9899211172', 'mikeg@houserhennessee.com', 'Newspaper FSI', 100, 0, 0, '4/4\r\nSize - 10.5x12 - with bleeds\r\nStock - Please quote on #70 gloss text and #80 gloss text'),
(29, '2008-08-13', 'Danielle Litwin ', 'OE 324 JATF, Inc.', '517-546-9610 Ext 1700', 'danielle.litwin@iuoe324.org', '', 2000, 3000, 0, 'I am looking for quotation on applications for an upcoming application process. The application 4 page (front & back), one color (black & white). \r\n\r\nLook forward to hearing from you. '),
(30, '2008-08-15', 'tracy jungmann', 'Southwestern Illinois College', '618 222-5252', 'tracy.jungmann@swic.edu ', 'form 210-G-W-O', 20, 0, 0, 'class record books'),
(31, '2008-08-16', '', '', '', '', '', 0, 0, 0, ''),
(32, '2008-08-19', 'Trish Lustila', 'Woodstock Board of Ed', '860 928-5524', 'lustilat@woodstockschools.net', '2008-09 National School Calendar', 1, 0, 0, 'We are a public school. Do you accept purchase orders?'),
(33, '2008-08-19', 'Trish Lustila', 'Woodstock Board of Ed', '860 928-5524', 'lustilat@woodstockschools.net', '2008-09 National School Calendar', 1, 0, 0, 'We are a public school. Do you accept purchase orders?'),
(34, '2008-08-19', 'Christine Hagman', 'Canfield Local School District', '330-533-3303', 'canf_clh@access-k12.org', 'National School Calendar Bood for 2008-09 Regular Edition', 1, 0, 0, 'Please send quote for one calendar, and shipping.'),
(35, '2008-08-21', 'Janie Gurica', 'HCCS Thomas More School', '517 423-6771', 'jgurica@hccsnet.org', 'Form 210-G-W.O.', 20, 0, 0, 'Price of 20 grade books'),
(36, '2008-08-21', 'Patricia L. Porcelli', 'Farmingdale School District', '516-752-3219', 'pporcelli@fpsmail.k12.ny.us', 'The National School Calendar 2008-2009', 6, 0, 0, ''),
(37, '2008-08-21', 'Gwen Douglass', 'Redford Union Schools', '313-242-6019', 'douglag@redfordu.k12.mi.us', 'CA-39 Special Services Record Folders', 1, 0, 0, 'apparently this wasn''t ordered last spring. Not sure if it comes in cases or not...please advise as to how many come in a case/box..thank you'),
(38, '2008-08-21', 'Heather McMullen', 'Woodland Park Academy', '810-695-4710', 'hmcmullen@wp-academy.org', 'Teacher Planners and Teacher Record/Grade/Attendance Books', 30, 0, 0, 'Need 30 Lesson Planners and 30 Grade/Attendance Books'),
(39, '2008-08-23', '', '', '', '', '', 0, 0, 0, ''),
(40, '2008-08-24', '', '', '', '', '', 0, 0, 0, ''),
(41, '2008-08-25', 'Szczerbinski, Thomas', 'Teacher', '703-243-3230', 'TSerbin@GWU.edu', 'The National School Calendar, 2008-9', 0, 0, 0, 'As a teacher, I very much find this product useful. I would like to order one for myself at a reasonable price: will pay postage & handling.'),
(42, '2008-08-27', 'BARBARA LEAK', 'UNIVERSITY HIGH SCHOOL', '248-586-8846', 'BTLEAK@FERNDALESCHOOLS.ORG', '', 0, 0, 0, 'Please call me. I do not have a catalog.'),
(43, '2008-08-27', 'Nancy P. Elledge', 'Teaching', '', 'nelledge@grandblancschools.org', 'daily lesson plan book, 2 columns', 1, 0, 0, ''),
(44, '2008-08-27', 'Nancy P. Elledge', 'Teaching', '', 'nelledge@grandblancschools.org', 'daily lesson plan book, 2 columns', 1, 0, 0, ''),
(45, '2008-08-28', 'JENNIFER LOPEZ', 'CORPORATE EXPRESS', '303-323-7866', 'jennifer.lopez@cexp.com', 'THE NATIONAL SCHOOL CALENDAR', 50, 0, 0, 'Please quote pricing and lead time for 50 ea and shipping charges to Rochester MN 55904. Thanks '),
(46, '2008-08-29', 'Rachael Horne', 'NEICAC-HEAD START', '563-382-8436 ext.133', 'rhorne@neicac.org', 'National School Calendar', 18, 0, 0, 'I am wanting to order 18 of the National School Calendars. I did not see a price for them. We are a non-profit organization. I am also wondering how long it will take to ship. Please have someone call me on Tuesday and I will place an order. Thank yo'),
(47, '2008-08-29', 'Gloria Perkins', 'Hilda Lahti Elementary School', '5034586162 ext. 221', 'eversong@knappasd.k12.or.us', 'Class Record Book Form 201-9-W.O. Long', 5, 0, 0, 'Please let me know how to order and the unit cost.\r\n\r\nThank you'),
(48, '2008-09-02', 'Rachael Horne', 'NEICAC-HEAD START', '563-382-8436 ext. 133', 'rhorne@neicac.org', 'National School Calendar', 0, 0, 0, 'Last week, I requested information on these calendars. At this time I will not be needing any information and will not be purchasing any. Thank you for your time.\r\nRachael Horne'),
(49, '2008-09-03', 'Susan Essiambre', 'Maple Lane Elementary School', '586-977-9170', 'sessiambre@misd.net', 'Class Record Book-Form 210-G-W.O.', 50, 0, 0, ''),
(50, '2008-09-03', 'Mary Pierson', 'Azusa Unified School District', '626-858-4241', 'maryp@azusausd.k12.ca.us', 'The National School Calendar 2008-2009', 4, 3, 0, 'I have two requisitions. I will order 4 each on one purchase order and 3 each on the other.\r\nThe full description on the requisition is The National School Calendar 2008-09 Academic School Year, July-June.'),
(51, '2008-09-08', 'Robin Setzler', 'Monroe Public Schools', '734-265-3152', 'setzler@monroe.k12.mi.us', 'National School Calendar', 25, 0, 0, 'I need the price of the National School Calendar and a price for attendance books.'),
(52, '2008-09-11', 'Georgine Mueller', 'Sheboygan Area Schools', '(920)459-3524', 'gmueller@sheboygan.k12.wi.us', '210', 300, 0, 0, 'Record class books'),
(53, '2008-09-12', 'Brenda Fowler', 'Coldwater High School', '517-279-5930', 'fowlbj@coldwaterschools.org', 'Combination Plan Record Book Form 201 CR & P', 10, 0, 0, ''),
(54, '2008-09-16', 'Tonya Sancrant', 'Ogemaw Hills Christian School', '989-345-2084', 'info@myohcs.com', 'CA-60 A inserts', 5, 0, 0, 'Can you tell me how much these forms cost and if there is a minimum quantity that needs to be ordered. Thanks.'),
(55, '2008-09-22', 'Phil Phillips', 'Special Ed/River Rouge', '313 297-9600', 'pphillip@rrouge.k12.mi.us', 'Student Homework Book', 100, 0, 0, 'Please give me the cost for 100 of your Student Homework Books.'),
(56, '2008-09-23', '', '', '', '', '', 0, 0, 0, ''),
(57, '2008-09-25', '', '', '', '', '', 0, 0, 0, ''),
(58, '2008-09-25', '', 'Ogemaw Hills Christian School', '989-345-2084', 'info@myohcs.com', 'CA-60 A inserts', 0, 0, 0, 'Please send us information about this item. This is the second request I have submitted. Thank you.'),
(59, '2008-09-25', '', 'Ogemaw Hills Christian School', '989-345-2084', 'info@myohcs.com', 'CA-60 A inserts', 0, 0, 0, 'Please send us information about this item. This is the second request I have submitted. Thank you.'),
(60, '2008-09-25', '', 'Ogemaw Hills Christian School', '989-345-2084', 'info@myohcs.com', 'CA-60 A inserts', 0, 0, 0, 'Please send us information about this item. This is the second request I have submitted. Thank you.'),
(61, '2008-09-25', 'Julia Corrin', 'MDSCC Campaign for Change', '(313) 283-9754', 'jcorrin@michiganforchange.com', 'Door Hangers', 150, 200, 250, 'Are you able to print door hangers?\r\nWe are looking to get quotes for door hangers with precinct polling locations lasered on.'),
(62, '2008-09-25', '', '', '', '', '', 0, 0, 0, ''),
(63, '2008-09-26', 'Robin Menke', 'Cedar Crest Academy', '248-625-7270', 'rmenke@cedarcrestacademy.com', 'Form No. CA-60T Record of Test Results', 100, 0, 0, ''),
(64, '2008-09-29', 'Julia Corrin', 'MDSCC Campaign for Change', '313 283 9754', 'jcorrin@michiganforchange.com', 'Palmcard', 100, 250, 500, '4 1/4 x 11, full color, two sided.\r\nMost likely on glossy coverstock.\r\n\r\nWould need to go to print as soon as possible with fast turn around.\r\n\r\nShipping not required.'),
(65, '2008-09-30', 'Renee Darga', 'Ira Township', '586-339-3951', 'taxes@iratownship.org', 'TUA-12', 5, 0, 0, 'Ira Township Receipt Books Pre Numbered Beginning with # 22801'),
(66, '2008-09-30', 'Renee Darga', 'Ira Township', '586-339-3951', 'taxes@iratownship.org', 'TUA-12', 5, 0, 0, 'Ira Township Receipt Books Pre Numbered Beginning with # 22801'),
(67, '2008-09-30', 'Renee Darga', 'Ira Township', '586-339-3951', 'taxes@iratownship.org', 'TUA-12', 5, 0, 0, 'Ira Township Receipt Books Pre Numbered Beginning with # 22801'),
(68, '2008-10-01', 'Wendy Fetty', 'New Haven Community Schools', '586-749-9535', 'wfetty@nhav.misd.net', 'see below', 0, 0, 0, 'please email quote for the following:\r\nCA-60/CA-60C/CA-60T 100 each\r\nSFA-17 / 2 packs of 50\r\nSFA-16 / 2 packs of 50\r\nD-17 / 20 packs of 100\r\nE-22 / 10 packs of 100\r\n\r\n\r\n'),
(69, '2008-10-19', '', '', '', '', '', 0, 0, 0, ''),
(70, '2008-10-21', 'V.Barbour', 'Billerica Memorial High School', '978-528-8761', 'vbarbour@billerica.k12.ma.us', 'System Wide Student Cum Folders', 0, 0, 0, ''),
(71, '2008-10-23', 'Mickie Brakke', 'Perry Child Development Center', '734-714-1750', 'mbrakke6@ypsd.org', 'Plan-106/40 Roll book/40 CA60T/500', 0, 0, 0, ''),
(72, '2008-10-23', 'Mickie Brakke', 'Perry Child Development Center', '734-714-1750', 'mbrakke6@ypsd.org', 'Plan-106/40 Roll book/40 CA60T/500', 0, 0, 0, ''),
(73, '2008-10-23', '', '', '', '', '', 0, 0, 0, ''),
(74, '2008-10-31', '', '', '', '', '', 0, 0, 0, ''),
(75, '2008-11-03', '', '', '', '', '', 0, 0, 0, ''),
(76, '2008-11-03', '', '', '', '', '', 0, 0, 0, ''),
(77, '2008-11-04', 'Cindy Kociba', 'EFR Middle School', '989.652.4612', 'ckociba@frankenmuth.k12.mi.us', 'CA 60 Folders', 0, 0, 0, 'Do you carry Form No. CA-60 (Cumulative Record Folders)?\r\n\r\nHow many in a box? What would they cost?\r\n\r\nPlease call or e-mail @ your convenience.'),
(78, '2008-11-13', 'Donna Garvey', 'Maple Valley Jr-Sr High School', '517-852-9275', 'dgarvey@mvs.k12.mi.us', 'GO-10, GO-22, GO-39, GO-28', 100, 500, 0, ''),
(79, '2008-11-13', 'Karen Brown', 'Northview High School', '616-365-6101', 'kbrown@nvps.net', 'B-3 Admission Slips', 2000, 0, 0, 'Would like two sets - one printed on white, one printed on blue. Thank you.'),
(80, '2008-11-15', '', '', '', '', '', 0, 0, 0, ''),
(81, '2008-11-15', '', '', '', '', '', 0, 0, 0, ''),
(82, '2008-11-17', 'Denise Culps', 'Plymouth High School', '734-582-5503', 'culpsd@pccs.k12.mi.us', 'Form 201- CR & P Record/Plan Book', 0, 0, 0, 'The school no longer provides for teachers. I''d like to give them individual or low quantity prices so they could order on their own. If this is possible, please let me know.'),
(83, '2008-11-18', '', '', '', '', '', 0, 0, 0, ''),
(84, '2008-11-19', '', '', '', '', '', 0, 0, 0, ''),
(85, '2008-11-20', 'Karen Brown', 'NORTHVIEW HIGH SCHOOL', '616-365-6101', 'kbrown@nvps.net', 'B-3 Admission Slips (3 x 5)white/blue', 30, 0, 0, 'Please send us a quote - we are running out of passes. Thank you'),
(86, '2008-11-20', 'Karen Brown', 'NORTHVIEW HIGH SCHOOL', '616-365-6101', 'kbrown@nvps.net', 'B-3 Admission Slips (3 x 5)white/blue', 30, 0, 0, 'Please send us a quote - we are running out of passes. Thank you'),
(87, '2008-11-22', '', '', '', '', '', 0, 0, 0, ''),
(88, '2008-11-22', '', '', '', '', '', 0, 0, 0, ''),
(89, '2008-11-22', '', '', '', '', '', 0, 0, 0, ''),
(90, '2008-11-22', '', '', '', '', '', 0, 0, 0, ''),
(91, '2008-11-22', '', '', '', '', '', 0, 0, 0, ''),
(92, '2008-11-22', '', '', '', '', '', 0, 0, 0, ''),
(93, '2008-11-22', '', '', '', '', '', 0, 0, 0, ''),
(94, '2008-11-22', '', '', '', '', '', 0, 0, 0, ''),
(95, '2008-11-22', '', '', '', '', '', 0, 0, 0, ''),
(96, '2008-12-01', '', '', '', '', '', 0, 0, 0, ''),
(97, '2008-12-02', 'Taeko Greenwood', 'Language Instructor', '248-449-8672', 'davidtaeko@aol.com', 'form 201-7-6-7-W.O.Long', 2, 0, 0, 'Class Record Book\r\nSize 5 5/8 inches X 10 inches\r\n\r\nThis size is very convenient and will fit in my purse.'),
(98, '2008-12-04', '', '', '', '', '', 0, 0, 0, ''),
(99, '2008-12-08', 'Stacey Thurston', 'Northwood University', '989-837-4214', 'thurston@northwood.edu', 'Class Record Book', 12, 0, 0, ''),
(100, '2008-12-12', '', '', '', '', '', 0, 0, 0, ''),
(101, '2008-12-18', '', '', '', '', '', 0, 0, 0, ''),
(102, '2008-12-18', '', '', '', '', '', 0, 0, 0, ''),
(103, '2008-12-18', 'LUANNE', 'VILLAGE OF GAINES', '989-271-8386', 'villageofgaines@chartermi.net', 'council meeting minute paper', 0, 0, 0, 'i am not sure how it comes-packs of 100??? if so maybe 5 packs or if i order more is it a better deal.'),
(104, '2008-12-24', '', '', '', '', '', 0, 0, 0, ''),
(105, '2008-12-29', 'Lorie Bowman', 'Muncie Community Schools', '765-254-4811', 'lbowman@muncie.k12.in.us', 'Nat''l. School Calendars 2009-2010', 100, 0, 0, 'We order these 5 x 8, spiral bound, blue and silver calendars each year. Can you tell me how many we ordered last year and what the price per calendar will be plus shipping and handling? Thank you.'),
(106, '2009-01-01', '', '', '', '', '', 0, 0, 0, ''),
(107, '2009-01-02', '', '', '', '', '', 0, 0, 0, ''),
(108, '2009-01-08', 'fzehcvaml', 'mYqGOCYk', 'yMIWYfClydrAwx', 'dwdexh@vievta.com', 'kuxiPCPJyHpJg', 0, 0, 0, 'X8ZbIo hcntnyixtzqv, [url=http://jbzcgdkxychr.com/]jbzcgdkxychr[/url], [link=http://aiwnlzmctgsb.com/]aiwnlzmctgsb[/link], http://lktczoddbwcu.com/'),
(109, '2009-01-08', '', '', '', '', '', 0, 0, 0, ''),
(110, '2009-01-14', '', '', '', '', '', 0, 0, 0, ''),
(111, '2009-01-14', 'Diane Lampe', 'Downriver High School', '734-379-4663', 'lamped@gibdist.net', 'CA-60B - Secondary Record', 200, 0, 0, 'Please include shipping'),
(112, '2009-01-23', '', '', '', '', '', 0, 0, 0, ''),
(113, '2009-01-23', 'Debbie RIchey', 'Briarwood Elementary School', '270 782-5554', 'DEBBIE.RICHEY@WARREN.KYSCHOOLS.US', 'CA32--Cumulative Folder', 1000, 0, 0, 'Would you please send the price of the folders.'),
(114, '2009-01-25', '', '', '', '', '', 0, 0, 0, ''),
(115, '2009-01-27', '', '', '', '', '', 0, 0, 0, ''),
(116, '2009-01-27', '', '', '', '', '', 0, 0, 0, ''),
(117, '2009-02-01', '', '', '', '', '', 0, 0, 0, ''),
(118, '2009-02-02', 'charlotte gambrel', 'Genesee Intermediate School District', '810-591-5093', 'cgambrel@geneseeisd.org', 'Educational Calendar - 3 year', 6, 0, 0, 'I have a 3 year educational calendar for 2007 through 2009 and really get good use out of it. I would like to order a new one for 2010 - 2013. My co-workers would like one too.'),
(119, '2009-02-03', 'Joe McCormick', 'sigma graphics', '815-433-1000', 'jmccormick@sigmagraphics.net', 'the national school calendar', 500, 750, 1000, '5 1/2 x 8 1/2 spiral bound school calendar book\r\nimprint 1/color front cover'),
(120, '2009-02-04', 'SUSAN DRUSS', 'MARTIN VAN BUREN HIGH SCHOOL', '7187764728 X103', 'SDRUSS@SCHOOLS.NYC.GOV', 'THE NATIONAL SCHOOL CALENDAR 09-10', 24, 0, 0, 'WE ORDER FROM YOU EVERY YEAR. CAN YOU PLEASE GIVE ME A QUOTE SO I CAN GET AND EARLY JUMP ON THIS? THANKS - SUE DRUSS'),
(121, '2009-02-04', 'Joni Olmsted', 'Red Hawk Elementary School', '616-696-7330', 'joni.olmsted@csredhawks.org', 'CA-60T Test Insert Card', 1, 0, 0, 'Please let me know how much one package of the CA-60 T test inserts are so I can finish my purchase order. Thanks.'),
(122, '2009-02-05', 'Ruth Madalinski', 'Escanaba Area Schools', '906-786-5412', 'rmadalinski@dsisd.k12.mi.us', 'Basic National School Calender', 31, 0, 0, '2009-2010 calender price quote'),
(123, '2009-02-11', 'Liz Tucci', 'Cherokee Elementary School', '(586) 723-4804', 'ltucci@cvs.k12.mi.us', 'CA-60 and insert files', 100, 500, 10, 'Please send quotes for above quantities on the CA-60, CA-60T, CA-60E, CA-60A and CA-60C. Thanks for all your help!'),
(124, '2009-02-16', 'Annette Godwin', 'Richmond County School System', '706-826-1121', 'godwian@boe.richmond.k12.ga.us', '9-week class record books', 3, 4, 0, '8 1/2 X 11 9-week style class record book with leather-like cover with wire-o binding (paper covers are not acceptable)\r\n\r\nnine or ten week grading, 2 semesters\r\n\r\nstudent name capacity: 35-40 names\r\n\r\nextra column to right of name, body pages perforated'),
(125, '2009-02-19', '', '', '', '', '', 0, 0, 0, ''),
(126, '2009-02-20', 'Debbie Craves', 'Bangor West Elementary School', '9896843373', 'cravesd@bangorschools.org', 'National School Calendar, Daily Lesson Plan Book 106-8-d', 8, 12, 0, ''),
(127, '2009-02-22', '', '', '', '', '', 0, 0, 0, ''),
(128, '2009-02-25', 'Cheryl Leva', 'West Hartford Public Schools', '860-561-6644', 'cheryl_leva@whps.org', 'Deluxe National School Calendar 2009-2010', 12, 0, 0, ''),
(129, '2009-02-26', 'Amanda Stoll', 'Digital Age Technologies', '810-658-4008', 'astoll@dat-inc.us', 'Full Color Gloss Brochure', 500, 0, 0, 'Please send me a quote for printing 500 copies of a single page full color brochure with gloss finish.'),
(130, '2009-02-27', '', '', '', '', '', 0, 0, 0, ''),
(131, '2009-03-02', 'Connie', '', '', '', '', 0, 0, 0, ''),
(132, '2009-03-02', 'Connie Guthrie', 'Ida Public Schools', '734-269-9003', 'guthrie@ida.k12.mi.us', 'ST-5 Bus Trip Authorization', 10, 0, 0, ''),
(133, '2009-03-02', 'Glenda Frohriep', 'Woodworth Elementary', '517-589-5151', 'frohrieg@lesliek12.net', 'CA60 ', 50, 0, 0, ''),
(134, '2009-03-05', 'Maggie Ruple', 'Caledonia Community Schools', '616 891 6220', 'ruplem@caledonia.k12.mi.us', 'CA-60 supplies', 0, 0, 0, 'Hello. I am in need of some CA 60 supplies.\r\nI need Ca-60, CA-60 A, CA-60 C, CA-60 E.\r\nPlease let me know current prices. \r\nThank you'),
(135, '2009-03-12', 'Karen Nugent', 'Schickler Elementary', '810-667-2440', 'knugent@lapeerschools.org', 'We would like you to print ourDiscipline slips that we have made on triplicate they would be 1/2 sheets and we have to of them', 2, 0, 0, 'We have two forms we would like to be put on the duplicate forms system. One set we would like White, pink and yellow and the other white blue and yellow if possible. We want them on half sheets'),
(136, '2009-03-17', 'CHERYL OWSEN', 'BROWNELL MIDDLE SCHOOL', '313/432-3903', 'CHERYL.OWSEN@GPSCHOOLS.ORG', 'FORM NO. 201 CR & P/COMBINATION PLAN RECORD BOOK', 48, 0, 0, ''),
(137, '2009-03-18', 'Kristin Zubiena', 'Copper Country ISD', '(906) 482-7260', 'kzubiena@copperisd.org', '', 0, 0, 0, 'Is there a price list on the website?'),
(138, '2009-03-23', 'paula hallowell', 'photography', '818-951-8140', 'paula@hallowellphotography.com', 'school calendar', 50, 0, 0, 'imprint w/name and logo'),
(139, '2009-03-23', 'Sherri Maley', 'Sacaton Elementary School District #18', '520-562-8600 x1008', 'smaley@sacatonschools.org', 'Cumulative Record Folder CA-39', 0, 0, 0, ''),
(140, '2009-03-24', 'Lynn Willis', 'Cleveland County Schools', '704-476-8032', 'lwillis@clevelandcountyschools.org', '2009-2010 Deluxe National School calendar', 0, 0, 0, ''),
(141, '2009-03-25', '', '', '', '', '', 0, 0, 0, ''),
(142, '2009-04-08', 'Sharon Lentz', 'York Co School of Technology', '717-741-0820 x 5013', 'slentz@ycstech.org', 'National School Calendar', 29, 0, 0, 'Please email a quote for the 09/10 National School Calendar...quantity of 29. Please also include estimated shipping/handling cost. Order will be placed either in May or June of this year.'),
(143, '2009-04-14', '', '', '', '', '', 0, 0, 0, ''),
(144, '2009-04-19', '', '', '', '', '', 0, 0, 0, ''),
(145, '2009-04-20', '', '', '', '', '', 0, 0, 0, ''),
(146, '2009-04-20', 'Ellen Watters', 'Ferndale Public Schools', '248-586-8657', 'ewatters@ferndaleschools.org', 'The National School Calendar 2009-2010', 2, 0, 0, 'Please quote price for The National School Calendar 2009-2010 (please quote shipping/handling as well). Thank you for your prompt attention to this request.'),
(147, '2009-04-20', 'Jamie Stratton', 'Pittsford Area Schools', '517-523-3481', 'stratton@pas.k12.mi.us', 'ST-5', 3, 0, 0, 'Please quote 3 pads of 25 sheets in dup. (totaling 150 trips) of ST-5 "Special Bus Trip Authorization & Report of Driver.\r\nThank you.'),
(148, '2009-04-21', 'Kim Radina', 'Frankenmuth High School', '989-652-2071', 'kradina@frankenmuth.k12.mi.us', 'CA-60 Test Record Sheets', 200, 300, 0, 'We need approx. 200-300 of the Test Record sheets for ca60''s. What is the cost of them per package (100 sheets). Thank you. '),
(149, '2009-04-21', 'Karla Irvin', 'School Board Pinellas County', '727-793-2723', 'irvink@pcsb.org', 'National School Calendar', 10, 0, 0, 'Requesting cost plus shipping, please'),
(150, '2009-04-22', 'Annie Jones', 'Naches Valley School Dist', '509 653 2725', 'ajones@naches.wednet.edu', 'National School Calendar', 1, 0, 0, 'I am looking to purchase one of these 5 X 8 calendars but I am only finding 08-09 school Years. is the 09-10 school year in print yet? If so, where can I purchase on line?'),
(151, '2009-04-26', '', '', '', '', '', 0, 0, 0, ''),
(152, '2009-04-27', 'Kathleen Tarrago', 'The King''s Academy', '561-686-4244', 'k.tarrago@tka.net', 'National School Calendar', 15, 0, 0, 'Regular Edition'),
(153, '2009-04-27', 'Kathleen Tarrago', 'The King''s Academy', '561-686-4244', 'k.tarrago@tka.net', '2 year Education Calendar', 3, 0, 0, ''),
(154, '2009-04-27', 'Kathleen Tarrago', 'The King''s Academy', '561-686-4244', 'k.tarrago@tka.net', 'J 3 Pass Slip Pads', 500, 0, 0, ''),
(155, '2009-04-27', 'Kathleen Tarrago', 'The King''s Academy', '561-686-4244', 'k.tarrago@tka.net', 'J 3 Pass Slip Pads', 500, 0, 0, ''),
(156, '2009-04-27', 'Kathleen Tarrago', 'The King''s Academy', '561-686-4244', 'k.tarrago@tka.net', 'J 3 Pass Slip Pads', 250, 0, 0, '3 X 3-1/2 Blue pad of 100'),
(157, '2009-04-27', 'Mona Kelly', 'J. B. Lafargue Special Education Center', '318-443-4572', 'kellym@rapides.k12.la.us', 'National School Calender Regular Edition', 1, 0, 0, 'Please send me current price for the National School Calendar for 2009-2010 - Regular Edition and shipping charge. Thank you for your assistance.'),
(158, '2009-04-27', 'MONICA ANTHONY', 'HAMPTON ELEMENTARY SCHOOL', '(989) 893-1100', 'anthonym@bcschools.net', '#210-G-W.O. class record book & the National School Calendar 2009-10', 20, 40, 0, 'need prices on these 2 items. I am putting through a P.O. for the items this week. Thanks. Monica'),
(159, '2009-04-28', 'Maggie Ruple', 'Caledonia Community Schools', '616 891 6220', 'ruplem@caledonia.k12.mi.us', 'CA 60 supplies', 0, 0, 0, 'Please email me asap current pricing into on CA60 supplies.\r\nYou did sent me a fax, but I can not read it. \r\nThanks\r\n'),
(160, '2009-04-28', 'Christine Shelly', 'Pennsylvania School for the Deaf', '215.754.4770', 'CShelly@psd.org', 'National School Calendar', 3, 0, 0, 'Can I order 3 of these Calendars and will you bill us, or do I need to fax a requisition # to you?\r\nThank you!\r\n~Christine'),
(161, '2009-04-30', 'Sherry Carroll', 'First Place Bank', '810-695-7080', 'scarroll@fpfc.net', 'Coated Legal Size 2 pocket folders', 500, 100, 1500, 'Looking for coated legal size folders with our name on the front only..\r\nThank You\r\nSherry'),
(162, '2009-05-01', 'Debbie Klig', 'Great Neck North Middle School', '516-773-1568', 'dklig@greatneck.k12.ny.us', '2 year educational calendar ', 4, 0, 0, ''),
(163, '2009-05-01', 'debbie klig', 'Great Neck North Middle School', '516-773-1568', 'dklig@greatneck.k12.ny.us', 'national school calendar ', 5, 0, 0, ''),
(164, '2009-05-02', '', '', '', '', '', 0, 0, 0, ''),
(165, '2009-05-04', 'Ms. P. Williams', 'American High School', '305-557-3770', '255313@dadeschools.net', 'The National School Calender', 15, 0, 0, 'Please provide quote for 15 calenders including shipping.\r\nThank You!'),
(166, '2009-05-05', 'Sharon ', 'Bayonne Brd of Education', '201-858-5830', 'olsens@bboed.org', 'Deluxe National School Calendar 09-10', 30, 0, 0, 'Could you please send me a price and shipping charges. \r\nThank you. '),
(167, '2009-05-05', 'Kathy Nestler', '', '', '', '', 0, 0, 0, ''),
(168, '2009-05-05', 'Kathy Nestler', 'Hendrick Hudson School Dist.', '9142575152', 'knestler@henhudschools.org', '2009-2010 National School Calendar', 10, 0, 0, 'Regular Edition -\r\nState, National and Church holidays in distinguishing colors.\r\nSpecial days and weeks of significance to schools included.\r\nSpace for appointments and memoranda, page size is 5 1/2 x 8 1/2.\r\nCalendars for present, preceding, and succeed'),
(169, '2009-05-06', 'Beth Jacob School', 'Beth Jacob School', '248.544.9070', 'beth_jacob@ameritech.net', 'form no. 201 - c r & p', 60, 0, 0, 'can you please let me know how much 60 of the above roll books are. thank you.'),
(170, '2009-05-06', '', '', '', '', '', 0, 0, 0, ''),
(171, '2009-05-06', '', '', '', '', '', 0, 0, 0, ''),
(172, '2009-05-06', '', '', '', '', '', 0, 0, 0, ''),
(173, '2009-05-06', '', '', '', '', '', 0, 0, 0, ''),
(174, '2009-05-07', '', '', '', '', '', 0, 0, 0, ''),
(175, '2009-05-07', 'Barbara Convery', 'Campbell Library/Rowan Univ.', '856-256-4986', 'convery@rowan.edu', '2009-2010 National School calendar', 35, 0, 0, ' 8 1/2 x 5 1/2 '),
(176, '2009-05-08', 'Shannon Davis', 'Exceptional Education-CCPS', '804-594-1785', 'Shannon_Davis@ccpsnet.net', 'National School Calendar 2009-2010', 90, 0, 0, ''),
(177, '2009-05-12', 'Stacey Brewer', 'Current Office Solutions', '4196366563', 'staceyb@currentofficesolutions.com', '#838 Will w/ lines & #118C Rental Agreements', 1, 0, 0, 'We only need quotes on these two products and are looking for only 50-100 sheets per item.\r\n\r\nthank you.\r\n\r\nOur office is formerly Hillsdale Office Supply'),
(178, '2009-05-12', 'brianna', 'studio brio', '8106563010', 'monarchbri@netzero.net', 'color copies', 500, 0, 0, 'hello. i need a quote on color copies/prints...i have 14 double sided pages 4/4 color (but it''s mostly b&w with spots of colors on pages) and i need 500 copies of each. please let me know the cost...there will be no binding & no folding...just the 8 1/2 x'),
(179, '2009-05-15', 'Portage Township schools', '', '', 'pmuniz@portage.k12.in.us', 'classic record book & plan book 106-8', 100, 0, 0, ''),
(180, '2009-05-15', 'KAREN', 'NORTH SHORE CENTRAL SCHOOL DISTICT', '516-277-7828', 'STERNK@NORTHSHORESCHOOLS.ORG', 'DELUXE NATIONAL SCHOOL CALENDAR 2009-20010', 4, 0, 0, 'THE DELUXE NATIONAL SCHOOL CALENDAR 2009-2010'),
(181, '2009-05-17', '', '', '', '', '', 0, 0, 0, ''),
(182, '2009-05-17', '', '', '', '', '', 0, 0, 0, ''),
(183, '2009-05-21', 'Tony Perrini', 'St. Mary School', '517-543-3460', 'stmaryprincipal@sbcglobal.net', 'Educational Calendars', 0, 0, 0, 'Only two - one for me and one for my secretary.'),
(184, '2009-05-21', 'Alison Weaver', 'Solomon Schechter School of Queens', '718-591-9800 ext. 313', 'AStopol@sssq.org', 'The Deluxe National School Calendar', 5, 0, 0, 'Please let me know the cost per item and the shipping charge for 5 calendars. \r\nThank you, Alison Weaver, Admin. Asst. to the Headmaster'),
(185, '2009-05-22', '', '', '', '', '', 0, 0, 0, ''),
(186, '2009-05-22', '', '', '', '', '', 0, 0, 0, ''),
(187, '2009-05-23', '', '', '', '', '', 0, 0, 0, ''),
(188, '2009-05-24', 'marlene roy', 'marlene roy consulting', '9148341149', 'mroyedu@optonline.net', '', 1, 0, 0, 'would like a quote for the delux edition, national school calendar for 09-10'),
(189, '2009-05-25', '', '', '', '', '', 0, 0, 0, ''),
(190, '2009-05-26', 'Virginia Woods', 'Bay Shore UFSD', '631-968-1111', 'vwoods@bayshore.k12.ny.us', '2009/10 Deluxe National School Calendar', 5, 0, 0, 'Please quote me a price for 5 deluxe national school calendars. Thank you'),
(191, '2009-05-28', 'Leah Sellers', 'Sweetwater Elementary School', '305-559-1101', 'gibson@dadeschools.net', 'The National School Calendar ', 2, 0, 0, 'I would like to purchase (2) 2009 - 2010 National School Calendars. \r\n\r\nThank you, Leah Sellers - Secretary/Treasurer'),
(192, '2009-05-29', '', '', '', '', '', 0, 0, 0, ''),
(193, '2009-06-01', 'Donna Walin', 'Inland Lakes Elementary', '231-238-6868', 'dwalin@inlandlakes.org', 'record books', 0, 0, 0, 'Class Record book 210-G WO 1 only\r\nAttendance book CA-10Y 1 1 only'),
(194, '2009-06-01', '', '', '', '', '', 0, 0, 0, ''),
(195, '2009-06-01', '', '', '', '', '', 0, 0, 0, ''),
(196, '2009-06-04', 'Patsy Sellers', 'Stump Early Childhood Center', '239 605-2701', 'Patsy.Sellers@bhas.org', 'Teacher', 0, 0, 0, ''),
(197, '2009-06-04', 'Patsy Sellers', 'Stump Early Childhood Center', '239 605-2701', 'Patsy.Sellers@bhas.org', 'Teacher''s Class Attendance and Summary Record', 6, 0, 0, 'Form Ca-10Y-1\r\n9 or 10 week attendance period\r\n(1 spread)\r\n'),
(198, '2009-06-04', 'Amy Marlin', 'Spring Vale Acdemy', '989-725-2391', 'amarlin@springvale.us', 'CA-39', 100, 0, 0, 'Would like a quote to include minimum quantity, as well as where the price break is. I also would like to get prices of certificates such as the GO-39 for a minimum qty. Please EMAIL me the pricing.'),
(199, '2009-06-04', 'Sherry Kull', 'St. Pius School', '734-284-6500', 'skull@saintpius-x.org', 'Test Record Inserts / Elem Record', 0, 0, 0, '200 of each insert'),
(200, '2009-06-04', 'wandarovenskie', 'stjosephschool', '7346762565', 'wrovenskie@mycomcast.com', 'class record book form210-G-W.O.', 60, 0, 0, 'please include a phone number with the quote'),
(201, '2009-06-04', 'Rene'' Boddy', 'Bay de Noc Community College', '906-786-5802 ', 'boddyr@baycollege.edu', '2009-10 National School Calendar', 5, 0, 0, '2009-10 National School Calendars'),
(202, '2009-06-05', 'Barbara Hunter', 'Baldwinsville School District', '315-635-4500', 'bhunter@bville.org', 'The National School Calendar', 3, 0, 0, 'Please let me know the price per calendar and shipping and/or handling charges for 3 calendars.'),
(203, '2009-06-05', 'Barbara Hunter', 'Baldwinsville School District', '315-635-4500', 'bhunter@bville.org', 'The National School Calendar', 3, 0, 0, 'Please let me know the price per calendar and shipping and/or handling charges for 3 calendars.'),
(204, '2009-06-07', 'William J O''Connell', 'School Psychological Services', '207 532 3118', '', 'soft-cover book', 0, 0, 0, 'I am writing a soft-cover book of about 250 pages. It will have a color jacket. This is my first book. It will be for teachers and parents. I don''t know how many copies I will sell.'),
(205, '2009-06-07', '', '', '', '', '', 0, 0, 0, ''),
(206, '2009-06-08', 'Lourdes Juncadella', 'Coral Park Elementary School', '305-221-5632', 'della19@dadeschools.net', 'National School Calendars', 7, 0, 0, 'Please call me so we can order the calendars - ASAP\r\nThank You'),
(207, '2009-06-08', 'Linda Compau', 'Tecumseh Acres Elementary', '517-423-9744', 'lcompau@tps.k12.mi.us', 'Form 101 Teacher''s Daily Memorandium Book', 10, 0, 0, ''),
(208, '2009-06-09', 'Lisa Odom', 'Leesburg Elementary School', '352-365-6308', 'Odoml@lake.k12.fl.us', '2009-10 National School Calendar', 2, 0, 0, ''),
(209, '2009-06-10', 'PAT ROBERTS', 'LAPEER COUNTY ED-TECH ', '810-667-6138', 'proberts@lcisd.k12.mi.us', 'A-14 Students Pass', 10, 0, 0, '3x5 canary, pads of 100'),
(210, '2009-06-10', 'Julia Dulek', 'Wood Oaks Junior High', '847-272-1900', 'dulek.j@nb27.org', '106-8 8-period plan book', 42, 0, 0, 'I would also like to know your shipping fees. Thank you.'),
(211, '2009-06-11', 'Darci Mowbray', 'Standish-Sterling High School', '989-846-3660', 'dmowbray@standish-sterling.org', 'Class Record Book - Form267 - M-WO', 50, 0, 0, 'I cannot seem to find this # anywhere. Do you still have this item?'),
(212, '2009-06-12', 'Crystal DiCino', 'Adams 12 Five Star Schools', '7209724241', 'Crystal.DiCino@adams12.org', 'National School Calendar', 2, 0, 0, 'Please provide a quote including shipping, will offer to entire district if price is good.'),
(213, '2009-06-15', 'E.F. Rittmueller Middle School', '', '989.652.6119', 'ckociba@frankenmuth.k12.mi.us', '', 0, 0, 0, '15 Class Record Books (I have form #CB910)\r\n10 Teacher''s Daily Lesson Plans (I have form #106-8).\r\n\r\nWould you please e-mail or fax me a quote.\r\n\r\nMy Fax number is 989.652.2921.\r\n\r\nThank you for your assistance.'),
(214, '2009-06-16', 'Sheila', 'Cherry Creek Elem', '9062254399', 'sespinoza@mapsnet.org', '201-9-10', 13, 0, 0, 'Deluxe Class Record Book'),
(215, '2009-06-16', 'Janet Pickford', 'Park Spanish Immersion School', '952-848-5527', 'pickford.janet@slpschools.org', 'The National School Calendar', 5, 0, 0, 'I would like pricing on 5 (five) National School Calendar... including shipping costs.\r\n\r\nThank you.'),
(216, '2009-06-22', 'monica baker', 'Schofield Elementary School', '586-757-5150', 'baker@fps.fitz.k12.mi.us', 'form 106 plan book & National school calendar', 8, 1, 0, ''),
(217, '2009-06-22', 'Freddie Singletary', 'Southfield Public Schools', '248-746-8855', 'singletaryf@southfield.k12.mi.us', 'Record Book', 50, 0, 0, ''),
(218, '2009-06-22', 'Christine Hagman', 'Canfield Locla Schools', '330-533-3303', 'canf_clh@access-k12.org', 'National School Calendar Book for 2009-10 Regular Edition', 10, 0, 0, ''),
(219, '2009-06-23', 'BettyJo Holloway', 'Destin Elementary School', '850-833-4360', 'hollowayb@mail.okaloosa.k12.fl.us', 'Form No. 106-D Teacher''s Lesson Plans', 45, 0, 0, ''),
(220, '2009-06-26', '', '', '', '', '', 0, 0, 0, ''),
(221, '2009-06-29', 'Michelle Rivera', 'East Ramapo CSD', '845-577-6074', 'mrivera@ercsd.k12.ny.us', 'Form #205', 12, 0, 0, 'Class Record Book'),
(222, '2009-06-29', 'GERI GRECO', 'ROSLYN HIGH SCHOOL', '516-801-5060', 'ggreco@roslynschools.org', 'DELUXEnat''l school calendars2009-10', 5, 0, 0, 'Please supply a price quote for the above mentioned item. I did not see this item on your website, is it still available? Thank you.'),
(223, '2009-06-30', 'Priscilla Hall', 'Eastern Michigan University', '734-487-1444', 'phall@emich.edu', 'Visualaid Grade Book Form 201-9V-56', 4, 0, 0, 'Riegle Press'),
(224, '2009-07-01', 'Donna Dinson', 'Summit Board of Ed', '908-273-6658', 'ddinson@summit.k12.nj.us', 'The National School Calendar', 12, 0, 0, ''),
(225, '2009-07-02', 'Colleen Nault', 'Livonia Career Technical Center', '734-744-2816', 'cnault@livoniapublicschools.org', 'National School Calendar', 2, 0, 0, 'Please provide me with the cost of purchasing two national school calendars and any shipping and handling charges.\r\n\r\nThanks!'),
(226, '2009-07-08', 'Linda Springall', 'Waterford Kettering High School', '248-673-1261', 'sprinl01@wsdmi.org', 'National School Calendar', 7, 0, 0, ''),
(227, '2009-07-08', 'Annette Simmonds', 'Mahopac Middle School', '845-621-1330', 'simmondsa@mahopac.k12.ny.us', 'Class Record Form 205 WO Long', 100, 0, 0, 'Please let me know how much per book'),
(228, '2009-07-08', 'Robin Setzler', 'Monroe Public Schools', '734-265-3152', 'setzler@monroe.k12.mi.us', 'The National School Calendar', 21, 0, 0, ''),
(229, '2009-07-08', 'Robin Setzler', 'Monroe Public Schools', '734-265-3152', 'setzler@monroe.k12.mi.us', 'Form 210', 10, 0, 0, ''),
(230, '2009-07-08', 'Robin Setzler', 'Monroe Public Schools', '734-265-3152', 'setzler@monroe.k12.mi.us', 'Two-Year Educational Calendar', 1, 0, 0, ''),
(231, '2009-07-08', '', '', '', '', '', 0, 0, 0, ''),
(232, '2009-07-09', 'Joe Torok', 'Lansing Comunity College', '(517) 483-1098', 'torokjoe@lcc.edu', 'The National School Calendar', 5, 5, 0, 'Would you please provide us with a quote for 5 regular and 5 deluxe editions of the National School Calendar -- we would like to compare the price difference. Thank you.'),
(233, '2009-07-13', 'Anne', 'Oldfield', '516-592-4072', 'anne_oldfield@mail.seaford.k12.ny.us', 'National Deluxe School Calendar', 2, 0, 0, 'Do you take purchase orders from a school?'),
(234, '2009-07-16', 'Armida Gonzalez', 'Cornerstone Prep School', '(323) 582-7736', 'armgonzalez@sbcglobal.net', 'Cumulative Record Folders', 200, 0, 0, 'The form number on the folders is CA60. They are white in color. '),
(235, '2009-07-17', 'Billie J Stemple', 'Fairview High School', '989-848-7050', 'billie_stemple@fairview.k12.mi.us', 'Educational Calendar', 4, 0, 0, 'Two year educational calendars 2009-2011 '),
(236, '2009-07-18', '', '', '', '', '', 0, 0, 0, ''),
(237, '2009-07-19', '', '', '', '', '', 0, 0, 0, ''),
(238, '2009-07-21', 'Karen Y Christmas', 'Oakwood University', '2567267352', 'kchristmas@oakwood.edu', 'Class Record Book Form No. CB67', 500, 1000, 1500, 'Please provide pricing for the quantities listed above with shipping charges to Huntsville, AL 35896. ALso indicate if you accept Purchas Orders and what that process is.'),
(239, '2009-07-22', 'Peggy Koziorowski', 'Lakes Community High School', '', '', '', 0, 0, 0, ''),
(240, '2009-07-22', 'Peggy Koziorowski', 'Lakes Community High School', '847/838-7106', 'pkoziorowski@lakeseagles.com', 'RIE1068 Lesson Plan Book', 34, 0, 0, 'Lesson Plan Books - 8 classes per day'),
(241, '2009-07-22', 'Rene'' Boddy', 'Bay de Noc Community College', '906-786-5802', 'boddyr@baycollege.edu', 'National School Calendar 2009-10', 3, 0, 0, 'National School Calendars'),
(242, '2009-07-23', 'Rene'' Boddy', 'Bay de Noc Community College', '906-786-5802 X1283', 'boddyr@baycollege.edu', 'National School Calendar 2009-10', 3, 0, 0, 'price quote please'),
(243, '2009-07-23', 'Linda Beitelshees', 'Pinellas County Schools', '727-507-4764', 'BeitelsheesL@pcsb.org', 'National School Calendars', 12, 0, 0, 'Please send price for ordering 12 calendars.\r\nThanks\r\nLinda Beitelshees'),
(244, '2009-07-27', 'Hazel Johnson', 'Anchor Bay Middle School North', '586-725-7373', 'hjohnson@abs.misd.net', 'National School Calendar, B3 Duplicate Spiral', 8, 25, 0, 'Are prices listed on your website? I could not find them.'),
(245, '2009-07-28', 'Mary Makarewicz', 'EdisonLearning, Inc.', '865-329-3637', 'Mary.Makarewicz@edisonlearning.com', 'CB910', 40, 0, 0, 'Class Record book '),
(246, '2009-07-28', 'Mary ', '', '', '', '', 0, 0, 0, ''),
(247, '2009-07-28', 'Mary Makarewicz', 'EdisonLearning, Inc.', '865-329-3637', 'Mary.Makarewicz@edisonlearning.com', '201-9 or 10', 30, 0, 0, 'Class Record Book'),
(248, '2009-07-28', 'Jennifer Mazurek', 'Walsh College', '248.823.1264', 'Jmazurek@walshcollege.edu', '201-6 W.O.Long', 100, 0, 0, 'Please send me a price for 100 class record books. If you ship in higher or lower quanties, I would appreciate that information as well. Thank you for your assistance.'),
(249, '2009-07-29', 'Krista Weaver', 'Contour Fabricators, Inc.', '810-750-5300', 'kweaver@cfimedical.com', 'Paper insert, white, 70LB; 6.25" x 14"', 350, 0, 0, 'Terry Byers recommended Reigle to me. A rep was in here yesterday but unfortunately it was too late in the day to meet with him. Please contact me with any questions.\r\nThanks,\r\nKrista Weaver\r\nPurchasing\r\nContour Fabricators.'),
(250, '2009-07-29', 'Joanne Love', 'Jackson County Intermediate School District', '517-768-5210', 'joanne.love@jcisd.org', 'Teachers Daily lesson Plans #106, Class Record Book #201-767', 75, 75, 0, ''),
(251, '2009-07-30', 'Devon B. Furr', 'Bamberg School District One', '803-245-3053 ext.106', 'Dblume@bamberg1.net', 'Deluxe Class Record Book and Teacher''s Daily Lesson', 28, 12, 0, 'Item 201-6-7 Need 28\r\nItem 106 Need 12'),
(252, '2009-08-03', 'Deb Steaban', 'West Hills Middle School', '248-341-6101', 'dsteaban@bloomfield.org', 'pb6/8 cb67/910 210-g-w.o. ', 20, 20, 10, ''),
(253, '2009-08-03', '', '', '', '', '', 0, 0, 0, ''),
(254, '2009-08-05', 'Catherine Emrick', 'Immcaulate Conception School', '978-454-5339', 'i.c.s.lowell@hotmail.com', 'Lesson Plan #p88 and Record Book #201-6 or 7', 7, 5, 0, ''),
(255, '2009-08-06', 'Sheila Lee', 'Rochester Public Schools', '507-', '', '', 0, 0, 0, ''),
(256, '2009-08-06', 'Sheila Lee', 'Rochester Public Schools', '507-328-4305', 'shlee@rochester.k12.mn.us', 'National School Daily Planner', 20, 0, 0, 'Please send me the cost of the National School Daily Planners.'),
(257, '2009-08-06', 'Sheila Lee', 'Rochester Public Schools', '507-328-4305', 'shlee@rochester.k12.mn.us', 'National School Daily Planner', 20, 0, 0, 'Please send me the cost of the National School Daily Planners'),
(258, '2009-08-11', 'Susan Cater', 'Lansing School District', '517-755-4070', 'susan.cater@lansingschoolsnet', 'CA-60A Cumulative Record Insert', 3000, 6000, 0, '11.75x8.5 cardstock, brown print, with die cut tab in yellow'),
(259, '2009-08-11', 'Susan', 'Cater', '517-755-4070', 'susan.cater@lansingschoolsnet', 'CA60 Cumulative Record Folder', 3000, 6000, 0, 'Brown print, 18.5x11.75, Folder for CA60 Information'),
(260, '2009-08-11', 'Inas Rabiah', 'central Academy', '734-822-1120', 'rabiahi@centralacademy.net', '201', 70, 0, 0, 'Form 201 — 6-7-Deluxe Edition\r\nWhat is the price for 70 '),
(261, '2009-08-11', 'Debb', '', '', '', '', 0, 0, 0, ''),
(262, '2009-08-11', 'Debbie Reynolds', 'Riverside Academy West', '313-945-6504', 'reynoldsd@riverside-academy.net', 'Teacher attendance books and Desk calendars', 44, 0, 0, 'Need attendance books for 4 10 week marking periods: Each teacher has 7 class periods'),
(263, '2009-08-17', 'Windy Fatchett', 'Current Office Solutions', '517-437-3651', '', '', 0, 0, 0, ''),
(264, '2009-08-17', 'Windy Fatchett', 'Current Office Solutions', '517-437-3651', 'windyf@currentofficesolutions.com', 'CA10Y1 9-10wk', 12, 0, 0, ''),
(265, '2009-08-18', 'janis rosenburg', 'pinellas county schools', '727-588-6000x2160', 'rosenburgj@pcsb.org', 'educational calendar and national school calendar', 1, 0, 0, ''),
(266, '2009-08-18', 'Sue Weertz', 'St. Clement Catholic School', '586-757-7500', 'sweertz@stclementcc.org', '201-9 or 10 and 106', 12, 12, 0, 'the teacher''s deluxe class record book (201-9 or 10)\r\nTeacher''s daily lesson plans (106)\r\nPlease let me know the cost of these items and a total cost with shipping for 12 of each.\r\nThank you\r\nSue'),
(267, '2009-08-18', 'Taunya', 'Gaston', '313.537.9311', 'tgaston@mtacademy.us', 'Classic Class Record Book', 30, 0, 0, 'Classic Class Record Book, 9 week marking period book.'),
(268, '2009-08-18', 'Taunya Gaston', 'Michigan Technical Academy', '313.537.9311', 'tgaston@mtacademy.us', 'Class Record Book ', 30, 0, 0, 'I am looking for a teacher''s class record obok for a 14-16 week period for Trimesters. Do you have anything like that?'),
(269, '2009-08-20', '', '', '', '', '', 0, 0, 0, ''),
(270, '2009-08-20', 'Ed Swindell', 'Oakland Schools', '248.209.2514', 'swindelle@oakland.k12.mi.is', 'DVD Wallet', 325, 0, 0, 'Sample only attach -Finish size 5.7/8 x 5.7/8 full color, file provided. '),
(271, '2009-08-20', 'Rose Loher', 'Germantown Academy', '215-646-3300 x280', 'rose.loher@germantownacademy.org', 'Student Homework Bk-8', 16, 0, 0, 'Student Homework Book / Form SHB-8'),
(272, '2009-08-21', '', '', '', '', '', 0, 0, 0, ''),
(273, '2009-08-24', 'Kelly Huling', 'Lincoln Middle School', '734-484-7033', 'huling@gw.lincoln.k12.mi.us', 'PB6/8 & CB67/910', 50, 100, 0, ''),
(274, '2009-08-28', 'Kristin Zubiena', 'Copper Country ISD', '(906) 482-7260', 'kzubiena@copperisd.org', 'Form SHB-8 Student Homework Book', 12, 0, 0, ''),
(275, '2009-08-28', 'Kristin Zubiena', 'Copper Country ISD', '(906) 482-7260', 'kzubiena@copperisd.org', 'Form PB8 8 period lesson plan book', 12, 0, 0, ''),
(276, '2009-08-28', 'Willie D. Anderson', 'Houston ISD', '713-696-6430', 'wanders3@houstonisd.org', 'appointment book', 0, 0, 0, ''),
(277, '2009-09-01', 'Genevieve Downes', 'Detroit Public School Teacher', '248-933-2585', 'gennydownes@hotmail.com', 'Lesson Plan Book #106, ', 2, 0, 0, 'I would like to purchase two lesson plan books.\r\nI can''t find this in any of the stores around here.\r\nCan I mail you a check or charge over the phone?'),
(278, '2009-09-01', 'unxrdhzjrhf', 'CoEGVCNpxuEd', 'cAeXcDRRfB', 'mewdxp@hdoavs.com', 'imQFfgjcZHyFYSRbE', 0, 0, 0, 'qjAzAk tnqwdcftovke, [url=http://izlawnzpdgez.com/]izlawnzpdgez[/url], [link=http://tlioimnytdpo.com/]tlioimnytdpo[/link], http://vhvckhbaahzg.com/'),
(279, '2009-09-01', '', '', '', '', '', 0, 0, 0, ''),
(280, '2009-09-02', '', '', '', '', '', 0, 0, 0, ''),
(281, '2009-09-03', 'Liz Mowan', 'Coldwater Comm. Schools', '517-279-5910, ext 247', 'emowan@coldwaterschools.org', 'S-16 Teaching Personnel Folder', 25, 50, 100, 'Please quote the price for this product.'),
(282, '2009-09-07', '', '', '', '', '', 0, 0, 0, ''),
(283, '2009-09-08', 'Shirley Bechtel', 'Ferndale Public Schools', '248.586.8758', 'sbechtel@ferndaleschools.org', 'Lesson Plan Book Form 106', 10, 0, 0, 'Please confirm shipping costs. Thank you.'),
(284, '2009-09-10', 'June Parker', 'Covert Public Schools', '269-764-3705', 'parkerj@covertps.org', 'SIA9 (s-51)', 10, 0, 0, 'NEED COST PER BOOK TO OBTAIN PURCHASE ORDER\r\nFROM ACCOUNTING - THANK YOU'),
(285, '2009-09-14', 'jqmrvq', 'JLAIYWbiLDYWhW', 'NRmdJwzC', 'fbhble@kyaowj.com', 'pUdjymNdqhEB', 0, 0, 0, 'wSETLg nrsfebzdrxqv, [url=http://dfvnileztcfg.com/]dfvnileztcfg[/url], [link=http://ojpaxanlmycl.com/]ojpaxanlmycl[/link], http://yrdinewvvnfy.com/'),
(286, '2009-09-14', '', '', '', '', '', 0, 0, 0, ''),
(287, '2009-09-15', 'Timothy Candell', 'University of WI - Eau Claire', '715-836-4283', 'candeltp@uwec.edu', '#205 Class Record Book W.O. Long', 144, 0, 0, 'We should have an account with you although we have not purchased anything for a couple of years. '),
(288, '2009-09-15', 'Barb Bonkowski', 'Fraser Public Schools', '586-439-7174', 'barbara.bonkowski@fraserk12.org', '2 yr educational calendar', 7, 0, 0, 'Please include any S/H charges in your quote.\r\nThank you,\r\nBarb Bonkowski'),
(289, '2009-09-16', 'Marj Wehner', 'Armada High School', '586-784-2400', 'm.wehner@armadaschools.org', '', 2, 0, 0, 'Cumulative Redcord folder plus shipping'),
(290, '2009-09-17', 'Dee Wellwood', 'UM Children''s Center', '734 763-6784', 'wellwood@umich.edu', 'Teachers Daily Lesson Plan books', 10, 0, 0, 'How do I purchase these?'),
(291, '2009-09-18', 'Patti Chambers', 'Haviland Elementary', '(248) 682-2620', 'ChambP01@wsdmi.org', 'Class Record Book Form No. CB67', 5, 0, 0, 'Please give me a price for you Class Record Book Form No. CB67.'),
(292, '2009-09-22', '', '', '', '', '', 0, 0, 0, ''),
(293, '2009-10-05', '', '', '', '', '', 0, 0, 0, '');
INSERT INTO `quotes` (`qte_id`, `qte_date`, `qte_name`, `qte_business`, `qte_phone`, `qte_email`, `qte_title`, `qte_qty1`, `qte_qty2`, `qte_qty3`, `qte_desc`) VALUES
(294, '2009-10-06', 'Sarah Razak', 'Metro Community Development, Inc.', '810-767-4622 x 26', 'srazak@flint.org', 'Business Cards & Letterhead', 15, 1000, 0, 'Hello, We are looking for a quote on colored business cards and letterhead. We have a staff of 15 and would like to know the pricing of approximately 250 cards per person, as well as, 1,000-10,000 pages of letterhead.\r\n\r\nThank you, Sarah'),
(295, '2009-10-07', 'Margaret Antilla', 'Clatsop Community College', '503.338.2428', 'mantilla@clatsopcc.edu', '201-9-W.O. Long', 24, 0, 0, 'Class Record Book - 9 week with additional 2 weeks'),
(296, '2009-10-12', 'Kim Radina', 'Frankenmuth High School', '989-652-2071', 'kradina@frankenmuth.k12.mi.us', 'Test Record Cards CA-60T', 500, 0, 0, 'Please email the cost of 500 cards to me at email above....'),
(297, '2009-10-13', '', '', '', '', '', 0, 0, 0, ''),
(298, '2009-10-16', 'Mickey Bellia', 'St. Clare of Montefalco', '313-647-5100', 'mbellia@stclarem.org', 'Form A-641', 0, 0, 0, 'Price'),
(299, '2009-10-22', 'Lori McCullough', 'John F. Kennedy High', '734-374-1275', 'mcculll@taylor.k12.mi.us', 'CA-60 Cumulative Record Folder', 200, 0, 0, ''),
(300, '2009-10-27', '', '', '', '', '', 0, 0, 0, ''),
(301, '2009-10-29', 'Maria Belmonte', 'Marist College', '845-575-3295', 'Maria.Belmonte@Marist.edu', 'Class Record Book', 48, 0, 0, 'How much would these books cost; \r\nform 201-9-W.O. Long?'),
(302, '2009-10-30', 'Ginger Payne', 'Pinewood Christian Academy', '912-739-1272 Ext. 60', 'gingerburnsed@yahoo.com', 'CA-60, CA-60A, CA60B, CA60C, CA60E, CA60T, CA60P', 300, 300, 300, 'We would like quote on 300 of each of the items listed above. '),
(303, '2009-11-04', 'rose hartwell', 'algonac community schools', '810 794 9364', 'rhartwell@algonac.k12.mi.us', 'educational calendar-2 year', 4, 0, 0, '2010-2012 calendars'),
(304, '2009-11-12', 'Cheryl Thivierge', 'Lincoln Park Public Schools', '313-389-0210', 'thiviec@lpark.k12.mi.us', '106-DD', 25, 0, 0, 'Plan Books : Form 106-DD Day by Day. We currently have a bid award for Riegle, but it does not include this item.'),
(305, '2009-11-13', '', '', '', '', '', 0, 0, 0, ''),
(306, '2009-11-18', 'Mary Johnson', 'New Lothrop Area Schools', '810-638-5400', 'mjohnson@newlothrop.k12.mi.us', 'Activities Fund Receipts', 0, 0, 0, 'can you quote for me form S1A-2 and S1A-3 in the 400 sets per pad. Thank you. Do you have a catalog to shop online?'),
(307, '2009-11-22', '', '', '', '', '', 0, 0, 0, ''),
(308, '2009-11-22', '', '', '', '', '', 0, 0, 0, ''),
(309, '2009-12-01', 'Doreen Johnson', 'East Rockaway JR/SR High School', '516-887-8300 ext 423', 'djohnson@eastrockawayschools.org', '2010-2011 National School Calender--Deluxe Edition', 6, 0, 0, 'National School Calendar--Deluxe Edition'),
(310, '2009-12-01', '', '', '', '', '', 0, 0, 0, ''),
(311, '2009-12-01', 'ISABELLE KOVARIK', 'DEKALB HIGH SCHOOL', '815-754-2100', 'ikovarik@dist428.org', 'Lab Data Notebook', 125, 0, 0, 'Hello!\r\n\r\nCan you please e-mail me an updated price for these lab data notebooks (carbon paper)\r\n\r\nThanks! Isabelle'),
(312, '2009-12-04', 'Reed Gordon', 'Imlay City Ford LM', '810-724-5900', 'reedicf@charter.net', 'Advisor Route Sheets', 500, 0, 0, 'I have a design for a Service department Route sheet would like to get min 11" x 17" card stock coil bound made up can email you an excel file and see what quote would be if this is possible.'),
(313, '2009-12-09', 'Doreen Johnson', 'East Rockaway Jr/Sr High School', '516-887-8300, ext. 423', 'djohnson@eastrockawayschools.org', '2010-11 National School Calendar--Deluxe Edition', 5, 0, 0, 'Please give me a price for the 2010-11 National School Calendar--Deluxe Edition, including shipping, so I can prepare the purchase order.'),
(314, '2009-12-09', '', '', '', '', '', 0, 0, 0, ''),
(315, '2009-12-09', 'Marsha Schmitz', 'Comm', '', '', '', 0, 0, 0, ''),
(316, '2009-12-09', 'Marsha Schmitz', 'Community Baptist Church', '810-513-9655', 'grimmaw1@gmail.com', 'letterhead and envelopes', 1000, 2000, 0, 'Need prices for printing of letterhead and #10 envelopes in both one and two color. I requested a quote on Monday but haven''t heard a reply and thought the salesman might have gotten my e-mail wrong. Waiting to hear from you. Thanks.'),
(317, '2009-12-13', '', '', '', '', '', 0, 0, 0, ''),
(318, '2009-12-17', '', '', '', '', '', 0, 0, 0, ''),
(319, '2009-12-17', 'Cheryl Purdy', 'Waldon Middle School', '', '', '', 0, 0, 0, ''),
(320, '2009-12-17', 'Cheryl Purdy', 'Waldon Middle School', '248-391-1102', 'cpurdy@lakeorion.k12.mi.us', 'Form No. CA-60', 150, 0, 0, ''),
(321, '2009-12-19', '', '', '', '', '', 0, 0, 0, ''),
(322, '2009-12-23', '', '', '', '', '', 0, 0, 0, ''),
(323, '2010-01-04', '', '', '', '', '', 0, 0, 0, ''),
(324, '2010-01-04', 'Marsha J. Ybema', 'Taft Elementary School', '616-530-7548', 'ybemam@wyoming.k12.mi.us', 'Form No. CA-60', 25, 0, 0, 'Please give me a quote for 25 -50 of the CA-60 forms and let me know how I can go about ordering them. Thank you'),
(325, '2010-01-06', '', '', '', '', '', 0, 0, 0, ''),
(326, '2010-01-07', 'Debbie Obsniuk', 'Winchester Elementary School', '', '', '', 0, 0, 0, ''),
(327, '2010-01-07', 'Debbie Obsniuk', 'Winchester Elementary School', '248 344-8415', 'obsniude@northvilleschools.org', 'CA60 and CA60 A', 0, 0, 0, 'Not sure of quantities.... depending on the price\r\nThanks!'),
(328, '2010-01-11', 'Tiffany Marquell', 'Muncie Community Schools', '765 254 4811', 'tmarquell@muncie.k12.in.us', 'CB67 School yr. calendar 2010-2011', 60, 0, 0, 'School yr. calendar for 2010-2011, 5x8 1/2 spiral bound'),
(329, '2010-01-12', 'Cheryl Purdy', 'Lake Orion Schools', '248-391-1102', 'cpurdy@lakeorion.k12.mi.us', 'Form No. CA60', 200, 0, 0, ''),
(330, '2010-01-12', '', '', '', '', '', 0, 0, 0, ''),
(331, '2010-01-15', 'Jennifer Stachowiak', 'Erie 1 BOCES', '716-821-7035', 'jstachowiak@e1b.org', 'record plan books - form 201 CR&P', 250, 0, 0, ''),
(332, '2010-01-15', '', '', '', '', '', 0, 0, 0, ''),
(333, '2010-01-15', '', '', '', '', '', 0, 0, 0, ''),
(334, '2010-01-17', '', '', '', '', '', 0, 0, 0, ''),
(335, '2010-01-18', '', '', '', '', '', 0, 0, 0, 'Form No. M-2'),
(336, '2010-01-19', 'Jillian', 'Helwig', '716-821-7076', 'jhelwig@e1b.org', 'Record plan Book Form 201 CR&P', 220, 0, 0, 'Can you please give me the cost of a single book and the cost of 220 books. Thank you'),
(337, '2010-01-21', '', '', '', '', '', 0, 0, 0, ''),
(338, '2010-01-25', 'Janet Mead', 'Cornerstone Elementary', '734-424-4120', 'meadj@dexterschools.org', 'CA-60E', 1, 0, 0, ''),
(339, '2010-01-25', 'DCED', 'City of Flint', '810-766-7436', '', '145 Page Document ', 25, 0, 0, 'Would like a quote for color copy of The Econimic Developement Strategy. You can go to the City of Flint Website and view the document . If possible could you fax us your quote, Fax# is 810-766-7351. Cover Page is color rest black/white.'),
(340, '2010-01-26', 'Catherine A. Bylinski', 'Woodbridge Township School District', '732-602-8574', 'catherine.bylinski@woodbridge.k12.nj.us', 'National School Calendar 2010', 15, 0, 0, 'Need quote for 15, please note any additional cost for shipping. Also is there a product number we need to reference?\r\nPlease advise if any companies, e.g. Barnes & Noble, or catalog companies, e.g. Staples or W.B. Mason, carry this product.\r\nAs the Purc'),
(341, '2010-01-26', '', '', '', '', '', 0, 0, 0, ''),
(342, '2010-01-27', 'John Borovsky', 'Pioneer High school', '734-994-2196', 'borovsky@aaps.k12.mi.us', '210-G.W.O. class record book', 6, 0, 0, 'I need to purchase 6 of these. They are the only record books I will use. Have depended on them for many years and can not teach without them. Our school foolishly orders another brand for our staff.'),
(343, '2010-02-01', 'Joan Tinsey', 'Brandon School Dist.', '248.627.1855', 'jtinsey@brandon.k12.mi.us', 'CA-60 B', 100, 0, 0, ''),
(344, '2010-02-01', 'Ellen Avery', 'Belvidere Elemetary School', '816-316-5302', 'ellen.avery@csd4.k12.mo.us', 'The Deluxe National School Calendar', 2, 0, 0, ''),
(345, '2010-02-03', 'Carole Kinsella', 'Keene State College Bookstore', '603-358-2245', 'ckinsella@keene.edu', 'class record book form 201-9', 0, 0, 0, 'I am not sure what minumum order is. Can you help as our buyer has left.I am looking for about 12 each.'),
(346, '2010-02-03', 'Carole Kinsella', 'Keene State College Bookstore', '603-358-2245', 'ckinsella@keene.edu', 'class record book form 201-9', 0, 0, 0, 'I am not sure what minumum order is. Can you help as our buyer has left.I am looking for about 12 each.'),
(347, '2010-02-03', '', '', '', '', '', 0, 0, 0, ''),
(348, '2010-02-05', 'Erica Alvardo', 'Publicom Inc.', '517-487-3700', 'ericaa@publicom.com', 'self mailer', 6882, 0, 0, 'I would like a mailing service quote for the piece described below. I already have a printer. I have recently purchased a NCOA approved list as well. How many days do you require before you drop? I will need the piece dropped at the Flint PO. Should '),
(349, '2010-02-06', '', '', '', '', '', 0, 0, 0, ''),
(350, '2010-02-08', 'Rob Baker', 'Christmas City Studio', '610-691-2109 x18', 'rbaker@christmascitystudio.com', '2010-2011 National School Calendars', 550, 650, 700, 'We have ordered these calendars through your company for the past few years. Last years'' order number was 20858 and our account number is 0041765.\r\n\r\nWe would like to order the same calendar type, with our full color logo on the front, I think the back c'),
(351, '2010-02-16', 'Vicky C. Strange', 'Spartanburg Day School', '864-582-7539', 'vicky.strange@sdsgriffin.org', '2010-2011 Deluxe National School Calendar', 1, 0, 0, 'I will need only 1 calendar. I have ordered a calendar for 9 years. It is very useful. I will mail you a check upon receiving the quote.\r\n\r\nVicky Strange'),
(352, '2010-02-16', '', '', '', '', '', 0, 0, 0, ''),
(353, '2010-02-16', 'dr gary wease', 'surgeon', '5869292936', 'surgfun1@aol.com', 'post cards', 1500, 0, 0, 'i would like a post card mailer and access to a mailing list to target certain groups in genesse county to advertis a new surgical procedure'),
(354, '2010-02-18', 'Cheryl', 'Erie 1 BOCES', '716-821-7195', 'cborowiak@e1b.org', 'Form 201 CR & P - Record Plan Book', 24, 0, 0, 'Please send us a quote my e-mail ASAP.\r\n\r\nThank you for your time.\r\n'),
(355, '2010-02-18', 'KATHY WILSON', 'OWOSSO GRAPHIC ARTS', '9897257112', 'KATHYWILSON@OWOSSOGRAPHIC.COM', 'NEWSLETTER', 5200, 5000, 4800, 'We are currently bidding our quarterly newsletter which you may be familiar with. \r\n8 page booklet, 4 color\r\nfoil stamped mast head (foil supplies)\r\ntabbed, addressed and mailed\r\n\r\nPlease breakout pricing for each item:\r\nPrinting\r\nFoil Stamping\r\nTabbing, '),
(356, '2010-02-20', 'Taunya Gaston', 'Michigan Technical Academy High School', '313.537.9311 ext. 340', 'tgaston@mtacademy.us', 'CB910', 10, 0, 0, 'Class Record Book 9-10 weeks. Need delivered by 02/23/10 to 23750 Elmira, Redford, MI 48239. Please include overnight shipping costs in quote. Thanks.');
-- --------------------------------------------------------
--
-- Table structure for table `ship_locations`
--
CREATE TABLE IF NOT EXISTS `ship_locations` (
`Ship_Location_ID` bigint(20) NOT NULL,
`Cust_ID` bigint(20) NOT NULL,
`Ship_Name` varchar(50) NOT NULL,
`Ship_Street` varchar(50) NOT NULL,
`Ship_City` varchar(50) NOT NULL,
`Ship_State` varchar(2) NOT NULL,
`Ship_Zip` varchar(12) NOT NULL,
UNIQUE KEY `Ship_Name` (`Ship_Name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `ship_locations`
--
INSERT INTO `ship_locations` (`Ship_Location_ID`, `Cust_ID`, `Ship_Name`, `Ship_Street`, `Ship_City`, `Ship_State`, `Ship_Zip`) VALUES
(1, 1, 'HealthPlus - Flint', '2050 S. Linden', 'Flint', 'MI', '48532'),
(2, 1, 'TGI Direct (1)', '5365 Hill-23 Dr', 'Flint', 'MI', '48507'),
(1, 2, 'Burton', '2303 S. Center Rd', 'Burton', 'MI', '48519'),
(2, 2, 'Davison', '8415 Davison Rd.', 'Davison', 'MI', '48423'),
(3, 1, 'TGI Direct (2)', '3085 E Reid Rd', 'Grand Blanc', 'MI', '48439'),
(3, 2, 'Fenton - VG''s', '1390 N. Leroy St.', 'Fenton', 'MI', '48430'),
(4, 2, 'Flint - VG''s', '5080 Corunna Rd.', 'Flint', 'MI', '48532'),
(5, 2, 'Flushing', 'G6238 Pierson Rd.', 'Flushing', 'MI', '48433'),
(6, 2, 'Lapeer', '800 West St. - Suite C', 'Lapeer', 'MI', '48446'),
(7, 2, 'Montrose/Clio', '7026 W. Vienna Rd.', 'Clio', 'MI', '48420'),
(8, 2, 'Administration Buildling', '2305 S. Center Rd', 'Burton', 'MI', '48519'),
(1, 3, 'Davison Corporate Office', '1515 Cal Drive', 'Davison', 'MI', '48423'),
(2, 3, 'Davison Main Warehouse', '1443 Granger', 'Davison', 'MI', '48423'),
(3, 3, 'Lansing Certified/Hospice', '2316 S. Cedar St., Ste. 600', 'Lansing', 'MI', '48910'),
(4, 3, 'Bay Certified/Hospice', '3140 W. Campus Dr.', 'Bay City', 'MI', '48706'),
(5, 3, 'Sterling Heights Certified/Hospice', '12900 Hall Rd., Ste. 200', 'Sterling Heights', 'MI', '48313'),
(6, 3, 'Clarkston', '5701 Bow Pointe Dr., Ste. 105', 'Clarkston', 'MI', '48346'),
(7, 3, 'Medical Mall East', '1454 W.Center Road, #3', 'Essexville', 'MI', '48732'),
(1, 0, 'Location1', '123 xxx', 'Flint', 'MI', '48501'),
(2, 0, 'Location2', '234 xxx', 'Flint', 'MI', '48501');
/*!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 */;