minierp20060519.txt

开源的 库存管理系统 www.minierp.cn php+ mysql

  PRIMARY KEY  (`AUTOID`)
) TYPE=InnoDB COMMENT='客户资料主表' AUTO_INCREMENT=42 ;

-- 
-- 导出表中的数据 `accounts`
-- 

INSERT INTO `accounts` VALUES (1, '01', 'JRA', '安得胜国际股份有限公司', '87312481', '0769', '87312484', '0769', '东莞清溪大利', 30, 15, '', '', '无发票', 'jra.com.tw', '五金塑胶', '', 1, 1, 30, 0, '2006-03-07 15:37:15', 0);
INSERT INTO `accounts` VALUES (2, '02', '勤筑', '勤筑五金塑胶制品有限公司', '87311390', '0769', '87311390', '0769', '东莞清溪大利', 25, 28, '工行', '', '东莞勤筑五金塑胶制品有限公司', '', '五金塑胶', '[e-mail]', 1, 26, 25, 1, '2006-03-30 17:24:01', 0);
INSERT INTO `accounts` VALUES (3, '03', '亿诚', '东莞亿诚塑胶制品有限公司', '87322567', '0769', '87322569', '0769', '清溪九乡', 25, 28, '建行', '', '东莞亿诚塑胶制品有限公司', '', '五金塑胶', '', 1, 26, 25, 1, '2006-03-31 09:58:59', 0);
INSERT INTO `accounts` VALUES (4, '04', '中兴', '东莞中兴模具有限公司', '87735508', '0769', '87311075', '0769', '清溪铁松', 30, 30, '', '农行', '东莞中兴模具有限公司', '', '模具', '[e-mail]', 1, 1, 30, 0, '2006-03-30 16:43:50', 0);
INSERT INTO `accounts` VALUES (5, '05', '广达', '东莞清溪广达粉末材料有限公司', '87310066', '0769', '87310077', '0769', '东莞清溪铁松', 25, 15, '', '', '东莞清溪广达粉末材料有限公司', '', '', '', 1, 26, 25, 1, '2006-03-31 09:58:55', 0);
INSERT INTO `accounts` VALUES (6, '06', '上庆', '东莞上庆塑胶制品有限公司', '87336783', '0769', '87321167', '0769', '东莞清溪九乡', 30, 30, '', '建行', '东莞上庆塑胶制品有限公司', '', '塑胶', '', 1, 1, 30, 1, '2006-03-31 09:59:14', 0);
INSERT INTO `accounts` VALUES (7, '07', '台升', '东莞台升', '87302275', '0769', '87302279', '0769', '东莞清溪大利', 30, 25, '', '', '', '', '印刷', 'taishengltd.com', 1, 1, 30, 1, '2006-03-31 09:59:20', 0);
INSERT INTO `accounts` VALUES (8, '08', '锦雅', '', '87899982', '0769', '87899983', '0769', '东莞清溪大利台升厂内', 0, 0, '', '', '收据', '', '', '[e-mail]', 1, 0, 0, 0, '2006-03-07 15:41:30', 0);
INSERT INTO `accounts` VALUES (9, '09', '大荣', '东莞大荣纸品有限公司', '87734999', '0769', '87734997', '0769', '东莞清溪大利', 30, 6, '', '', '东莞大荣纸品有限公司', '', '纸品', '', 1, 1, 30, 0, '2006-03-07 15:41:37', 0);
INSERT INTO `accounts` VALUES (10, '10', '冠镒', '东莞冠镒五金塑胶制品有限公司', '87387226', '0769', '87316973', '0769', '东莞清溪铁松', 0, 0, '', '', '', '', '五金塑胶', '', 1, 0, 0, 0, '2006-03-07 15:41:42', 0);
INSERT INTO `accounts` VALUES (11, '11', '福钢', '', '87734873', '0769', '87732851', '0769', '东莞清溪铁松', 30, 15, '', '', '', '', '', '', 1, 1, 30, 0, '2006-03-07 15:41:49', 0);
INSERT INTO `accounts` VALUES (12, '12', '庆薰', '', '87323072', '0769', '87323073', '0769', '东莞清溪九乡', 30, 0, NULL, '', '收据', '', '', '', 1, NULL, NULL, 0, '2006-03-04 19:52:08', 0);
INSERT INTO `accounts` VALUES (13, '13', '正威', '', '87311858', '0769', '87313628', '0769', '东莞清溪铁松', 0, 0, NULL, '', '收据', '', '', '', 1, NULL, NULL, 0, '2006-03-03 22:53:03', 0);
INSERT INTO `accounts` VALUES (14, '14', '广兴', '', '87895828', '0769', '87895868', '0769', '东莞清溪大利勤筑厂内', 30, 15, NULL, '', '收据', '', '', '', 1, NULL, NULL, 0, '2006-03-03 22:59:15', 0);
INSERT INTO `accounts` VALUES (15, '15', '精工', '', '87312951', '0769', '87310951', '0769', '东莞清溪三中', 0, 0, NULL, '', '收据', '', '', '', 1, NULL, NULL, 0, '2006-03-03 23:00:16', 0);
INSERT INTO `accounts` VALUES (16, '16', '宝立', '', '87322362', '0769', '87322265', '0769', '东莞清溪河板桥', 0, 0, NULL, '', '收据', '', '', '', 1, NULL, NULL, 0, '2006-03-03 23:01:23', 0);
INSERT INTO `accounts` VALUES (17, '17', '太元', '', '87386132', '0769', '', '0769', '东莞清溪鹿湖路', 0, 0, NULL, '', '太元', '', '货运公司', '', 1, NULL, NULL, 0, '2006-03-03 23:02:20', 0);
INSERT INTO `accounts` VALUES (18, '18', '帝一豪', '', '87737100', '0769', '87734638', '0769', '东莞清溪铁松', 30, 0, NULL, '', '帝一豪', '', '五金塑胶', '', 1, NULL, NULL, 0, '2006-03-03 23:05:33', 0);
INSERT INTO `accounts` VALUES (19, '19', '维冠', '东莞维冠五金塑胶制品有限公司', '87388857', '0769', '87388861', '0769', '东莞清溪林场', 25, 26, '', '', '收据', '', '', '', 1, NULL, NULL, 0, '2006-03-04 20:01:42', 0);
INSERT INTO `accounts` VALUES (20, '20', '吉亨', '东莞吉亨五金制品有限公司', '87314071', '0769', '87314073', '0769', '东莞清溪大埔', 30, 30, '', '', '收据', '', '五金', '', 1, NULL, NULL, 0, '2006-03-04 20:03:42', 0);
INSERT INTO `accounts` VALUES (21, '21', '豪冠', '东莞豪冠', '87311568', '', '87738796', '', '东莞清溪清厦', 30, 30, '', '', '收据', '', '', '', 1, NULL, NULL, 0, '2006-03-04 20:04:47', 0);
INSERT INTO `accounts` VALUES (22, '22', '合诚', '', '87319906', '', '87319907', '', '东莞清溪林场', 0, 0, '', '', '收据', '', '', '', 1, NULL, NULL, 0, '2006-03-04 20:05:55', 0);
INSERT INTO `accounts` VALUES (23, '23', '美聚', '', '87303377', '', '87381253', '', '东莞清溪康怡花园', 0, 0, '', '', '收据', '', '', '', 1, NULL, NULL, 0, '2006-03-04 20:07:40', 0);
INSERT INTO `accounts` VALUES (24, '24', '盈利', '东莞盈利幼童用品有限公司', '87736157', '', '87737860', '', '东莞清溪重河', 0, 0, '', '', '收据', '', '', '', 1, NULL, NULL, 0, '2006-03-04 20:09:06', 0);
INSERT INTO `accounts` VALUES (25, '25', '欣鼎三厂', '东莞欣鼎五金制品有限公司', '87338888', '', '87311664', '', '东莞清溪大埔', 1, 21, '', '', '', '', '', '', 1, NULL, NULL, 0, '2006-03-04 20:10:42', 0);
INSERT INTO `accounts` VALUES (26, '26', '欣晟', '东莞欣晟五金制品有限公司', '87890000', '', '87899666', '', '东莞清溪九乡', 1, 21, '', '', '', '', '', '[e-mail]', 1, 0, 0, 0, '2006-04-06 14:18:33', 0);
INSERT INTO `accounts` VALUES (27, '27', '同鸿', '', '87385009', '', '87385286', '', '东莞清溪长山头', 0, 0, '', '', '收据', '', '', '', 1, NULL, NULL, 0, '2006-03-04 20:13:22', 0);
INSERT INTO `accounts` VALUES (28, '28', '勤致', '', '87330865', '', '', '', '东莞清溪大利', 0, 0, '', '', '', '', '', '', 1, NULL, NULL, 0, '2006-03-04 20:14:07', 0);
INSERT INTO `accounts` VALUES (29, '29', '好而优', '东莞好而优塑胶制品有限公司', '87949595', '', '87946868', '', '东莞塘夏林村', 30, 1, '东莞塘夏工行', '', '东莞好而优塑胶制品有限公司', '', '', 'dg-hei.com', 1, NULL, NULL, 0, '2006-03-04 20:20:02', 0);
INSERT INTO `accounts` VALUES (30, '30', '中天', '东莞中天茶馆', '87295767', '', '', '', '东莞清溪碧月湾', 0, 0, '', '', '收据', '', '', '', 0, 0, 0, 0, '2006-03-04 20:21:34', 0);
INSERT INTO `accounts` VALUES (31, '31', '闽南胶袋', '东莞闽南胶袋厂', '87736777', '', '', '', '东莞清溪浮岗', 0, 0, '', '', '收据', '', '', '', 0, 0, 0, 0, '2006-03-04 20:22:42', 0);
INSERT INTO `accounts` VALUES (32, '32', '鼎磊', '', '3530666', '0752', '3530686', '0752', '惠州惠阳', 30, 30, '', '', '收据', '', '', '', 0, 0, 0, 0, '2006-03-04 20:24:03', 0);
INSERT INTO `accounts` VALUES (33, '33', '东图', '', '87890893', '', '87336467', '', '东莞清溪大埔', 0, 0, '', '', '', '', '', '', 0, 0, 0, 0, '2006-03-04 20:25:27', 0);
INSERT INTO `accounts` VALUES (34, '34', '介邦', '', '87386059', '', '', '', '东莞清溪铁松', 0, 0, '', '', '', '', '', '', 0, 0, 0, 0, '2006-03-04 20:26:14', 0);
INSERT INTO `accounts` VALUES (35, '35', '维信', '惠阳维信纺织', '3523558', '0752', '3523559', '0752', '惠阳', 1, 25, '', '', '惠阳维信纺织', '', '', '', 0, 0, 0, 0, '2006-03-04 20:27:35', 0);
INSERT INTO `accounts` VALUES (36, '36', '冠杰', '', '87366391', '', '87366393', '', '东莞清溪林场', 0, 0, '', '', '', '', '', '', 0, 0, 0, 0, '2006-03-04 20:28:41', 0);
INSERT INTO `accounts` VALUES (37, '999', '个人客户', '', '', '', '', '', '', 0, 0, '', '', '', '', '', '', 0, 0, 0, 0, '2006-03-04 22:07:09', 0);
INSERT INTO `accounts` VALUES (38, '37', '长城', '东莞长城', '', '', '', '', '东莞清溪九乡', 0, 0, '', '', '', '', '', '', 0, 0, 0, 0, '2006-03-07 22:59:33', 0);
INSERT INTO `accounts` VALUES (39, '38', '汇诚', '东莞市汇诚代理记帐有限公司', '87325777', '0769', '', '', '东莞清溪镇行政中心区东昌商务大厦七楼', 0, 0, '', '', '东莞市汇诚代理记帐有限公司', '', '财务公司', '', 0, 0, 0, 0, '2006-03-28 14:43:29', 0);
INSERT INTO `accounts` VALUES (40, '39', '中兴', '东莞清溪中兴模胚厂', '87312151', '', '', '', '东莞清溪大利', 31, 31, '', '', '', '', '', '', 1, 1, 31, 1, '2006-04-04 15:14:25', 0);
INSERT INTO `accounts` VALUES (41, '998', '明志', '明志电脑', '87332392', '0769', '87332392', '0769', '东莞清溪鹿湖小区', 0, 0, '', '', '', '', 'IT', '', 0, 0, 0, 0, '2006-04-08 22:42:56', 0);

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

-- 
-- 表的结构 `bom`
-- 

CREATE TABLE `bom` (
  `AUTOID` bigint(20) NOT NULL,
  `BOM01` varchar(20) default NULL,
  `BOM02` varchar(20) default NULL,
  `BOM03` varchar(20) default NULL,
  `BOM04` float default NULL,
  `BOM05` varchar(20) default NULL,
  `DT998` tinyint(1) NOT NULL default '0',
  `DT999` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`AUTOID`)
) TYPE=InnoDB COMMENT='材料表结构' AUTO_INCREMENT=2 ;

-- 
-- 导出表中的数据 `bom`
-- 

INSERT INTO `bom` VALUES (1, '88888', NULL, NULL, 1, NULL, 0, '2006-03-28 00:00:00');

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

-- 
-- 表的结构 `case2bank`
-- 

CREATE TABLE `case2bank` (
  `AUTOID` bigint(20) NOT NULL,
  `C2B01` varchar(30) default NULL,
  `C2B02` varchar(20) default NULL,
  `C2B03` varchar(20) default NULL,
  `C2B04` float(10,2) default NULL,
  `C2B05` date default NULL,
  `C2B06` varchar(20) default NULL,
  `C2B07` varchar(50) default NULL,
  `C2B08` varchar(50) default NULL,
  `DT998` tinyint(4) default NULL,
  `DT999` datetime default NULL,
  PRIMARY KEY  (`AUTOID`)
) TYPE=InnoDB COMMENT='银行存取款记录' AUTO_INCREMENT=17 ;

-- 
-- 导出表中的数据 `case2bank`
-- 

INSERT INTO `case2bank` VALUES (8, '20060617', '001', '002', 5000.00, '2006-01-01', '祁宽红', '备用', '00101', NULL, '2006-05-16 22:37:21');
INSERT INTO `case2bank` VALUES (9, '200101', '002', '', 0.99, '2006-05-17', 'a', 'a', 'a', NULL, '2006-05-17 10:05:01');
INSERT INTO `case2bank` VALUES (10, '1001', '001', '002', 0.99, '2006-05-17', '11', '11', '11', NULL, '2006-05-17 10:06:17');
INSERT INTO `case2bank` VALUES (11, '10', '001', '002', 0.90, '2006-05-17', '11', '111', '11', NULL, '2006-05-17 10:07:52');
INSERT INTO `case2bank` VALUES (12, '999', '001', '002', 100.00, '2006-05-17', 'q', 'q', 'q', NULL, '2006-05-17 10:20:42');
INSERT INTO `case2bank` VALUES (13, '999', '001', '002', 100.00, '2006-05-17', 'q', 'q', 'q', NULL, '2006-05-17 10:22:41');
INSERT INTO `case2bank` VALUES (14, '999', '001', '002', 100.00, '2006-05-17', 'q', 'q', 'q', NULL, '2006-05-17 10:23:59');
INSERT INTO `case2bank` VALUES (15, '999', '001', '002', 100.00, '2006-05-17', 'q', 'q', 'q', NULL, '2006-05-17 10:24:11');
INSERT INTO `case2bank` VALUES (16, '200607', '002', '001', 250.00, '2006-05-17', 'A', 'A', 'A', NULL, '2006-05-17 10:45:35');

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

-- 
-- 表的结构 `casebank`
-- 

CREATE TABLE `casebank` (
  `AUTOID` bigint(20) NOT NULL,
  `CAB01` varchar(20) default NULL,
  `CAB02` varchar(40) default NULL,
  `CAB03` varchar(40) default NULL,
  `CAB04` float(10,2) default NULL,
  `CAB05` tinyint(1) default '0',
  `CAB06` varchar(100) default NULL,
  `DT998` tinyint(1) default '0',
  `DT999` datetime default NULL,
  PRIMARY KEY  (`AUTOID`)
) TYPE=InnoDB COMMENT='现金银行资料' AUTO_INCREMENT=3 ;

-- 
-- 导出表中的数据 `casebank`
-- 

INSERT INTO `casebank` VALUES (1, '001', '中国银行', '010000999999910', 99949.10, 0, '清溪银桥', 0, '2006-05-17 10:07:24');
INSERT INTO `casebank` VALUES (2, '002', '现金帐户', '', 1150.90, 0, '', 0, '2006-05-17 10:07:30');

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

-- 
-- 表的结构 `casedelt`
-- 

CREATE TABLE `casedelt` (
  `AUTOID` bigint(20) NOT NULL,
  `CAD01` varchar(20) default NULL,
  `CAD02` date default NULL,
  `CAD03` tinyint(1) default NULL,
  `CAD04` float(10,2) default NULL,
  `CAD05` tinyint(1) default NULL,
  `CAD06` varchar(100) default NULL,
  `CAD07` varchar(20) default NULL,
  `CAD08` varchar(20) default NULL,
  `CAD09` varchar(20) default NULL,
  `DT998` tinyint(1) default '0',