minierp20060519.txt

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

  `DT999` datetime default NULL,
  PRIMARY KEY  (`AUTOID`)
) TYPE=InnoDB COMMENT='现金日记帐' AUTO_INCREMENT=66 ;

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

INSERT INTO `casedelt` VALUES (5, 'JHD040684', '2006-05-16', 1, 2850.00, 1, '22', '040684', 'JHD', '002', 0, '2006-05-16 17:17:49');
INSERT INTO `casedelt` VALUES (6, 'JHD040690', '2006-05-16', 1, 540.00, 1, '02', '040690', 'JHD', '002', 0, '2006-05-16 17:18:06');
INSERT INTO `casedelt` VALUES (7, 'JHD040691', '2006-05-16', 1, 1695.00, 1, '02', '040691', 'JHD', '002', 0, '2006-05-16 17:18:11');
INSERT INTO `casedelt` VALUES (8, 'JHD040692', '2006-05-16', 1, 160.00, 1, '06', '040692', 'JHD', '002', 0, '2006-05-16 17:24:51');
INSERT INTO `casedelt` VALUES (9, 'JHD040693', '2006-05-16', 1, 200.00, 1, '07', '040693', 'JHD', '002', 0, '2006-05-16 17:25:01');
INSERT INTO `casedelt` VALUES (10, 'JHD040710', '2006-05-16', 1, 2665.00, 1, '03', '040710', 'JHD', '002', 0, '2006-05-16 17:25:42');
INSERT INTO `casedelt` VALUES (11, 'JHD040709', '2006-05-16', 1, 212.00, 1, '03', '040709', 'JHD', '002', 0, '2006-05-16 17:25:44');
INSERT INTO `casedelt` VALUES (12, 'JHD040706', '2006-05-16', 1, 48.00, 1, '09', '040706', 'JHD', '002', 0, '2006-05-16 17:25:46');
INSERT INTO `casedelt` VALUES (13, 'JHD040704', '2006-05-16', 1, 2010.00, 1, '04', '040704', 'JHD', '002', 0, '2006-05-16 17:25:47');
INSERT INTO `casedelt` VALUES (14, 'JHD040703', '2006-05-16', 1, 410.00, 1, '03', '040703', 'JHD', '002', 0, '2006-05-16 17:25:49');
INSERT INTO `casedelt` VALUES (15, 'JHD040702', '2006-05-16', 1, 1660.00, 1, '03', '040702', 'JHD', '002', 0, '2006-05-16 17:25:51');
INSERT INTO `casedelt` VALUES (16, 'JHD040695', '2006-05-16', 1, 130.00, 1, '20', '040695', 'JHD', '002', 0, '2006-05-16 17:25:52');
INSERT INTO `casedelt` VALUES (17, 'JHD040694', '2006-05-16', 1, 165.00, 1, '21', '040694', 'JHD', '002', 0, '2006-05-16 17:25:54');
INSERT INTO `casedelt` VALUES (18, 'JHD040711', '2006-05-16', 1, 180.00, 1, '05', '040711', 'JHD', '002', 0, '2006-05-16 19:04:12');
INSERT INTO `casedelt` VALUES (19, 'JHD040712', '2006-05-16', 1, 995.00, 1, '01', '040712', 'JHD', '002', 0, '2006-05-16 19:04:19');
INSERT INTO `casedelt` VALUES (20, 'JHD040713', '2006-05-16', 1, 14.00, 1, '06', '040713', 'JHD', '002', 0, '2006-05-16 19:04:41');
INSERT INTO `casedelt` VALUES (21, 'JHD040714', '2006-05-16', 1, 675.00, 1, '03', '040714', 'JHD', '002', 0, '2006-05-16 19:04:47');
INSERT INTO `casedelt` VALUES (22, 'JHD040715', '2006-05-16', 1, 440.00, 1, '02', '040715', 'JHD', '002', 0, '2006-05-16 19:05:40');
INSERT INTO `casedelt` VALUES (23, 'JHD040717', '2006-05-16', 1, 1665.00, 1, '05', '040717', 'JHD', '002', 0, '2006-05-16 19:06:24');
INSERT INTO `casedelt` VALUES (24, 'JHD040718', '2006-05-16', 1, 47.00, 1, '20', '040718', 'JHD', '002', 0, '2006-05-16 19:15:17');
INSERT INTO `casedelt` VALUES (25, 'JHD040719', '2006-05-16', 1, 570.00, 1, '09', '040719', 'JHD', '002', 0, '2006-05-16 19:16:46');
INSERT INTO `casedelt` VALUES (26, 'JHD040720', '2006-05-16', 1, 254.00, 1, '03', '040720', 'JHD', '002', 0, '2006-05-16 19:16:52');
INSERT INTO `casedelt` VALUES (27, 'JHD040721', '2006-05-16', 1, 518.00, 1, '03', '040721', 'JHD', '002', 0, '2006-05-16 19:18:43');
INSERT INTO `casedelt` VALUES (28, 'JHD040675', '2006-05-16', 1, 85.00, 1, '20', '040675', 'JHD', '002', 0, '2006-05-16 19:19:05');
INSERT INTO `casedelt` VALUES (29, 'JHD040727', '2006-05-16', 1, 422.00, 1, '03', '040727', 'JHD', '002', 0, '2006-05-16 19:28:08');
INSERT INTO `casedelt` VALUES (30, 'JHD040728', '2006-05-16', 1, 130.00, 1, '03', '040728', 'JHD', '002', 0, '2006-05-16 19:28:09');
INSERT INTO `casedelt` VALUES (31, 'JHD040729', '2006-05-16', 1, 1485.00, 1, '05', '040729', 'JHD', '002', 0, '2006-05-16 19:28:10');
INSERT INTO `casedelt` VALUES (32, 'JHD040730', '2006-05-16', 1, 165.00, 1, '05', '040730', 'JHD', '002', 0, '2006-05-16 19:28:11');
INSERT INTO `casedelt` VALUES (33, 'JHD040731', '2006-05-16', 1, 23.00, 1, '04', '040731', 'JHD', '002', 0, '2006-05-16 19:28:12');
INSERT INTO `casedelt` VALUES (34, 'JHD040732', '2006-05-16', 1, 1271.00, 1, '04', '040732', 'JHD', '002', 0, '2006-05-16 19:28:13');
INSERT INTO `casedelt` VALUES (35, 'JHD040733', '2006-05-16', 1, 125.00, 1, '04', '040733', 'JHD', '002', 0, '2006-05-16 19:28:14');
INSERT INTO `casedelt` VALUES (36, 'JHD040734', '2006-05-16', 1, 310.00, 1, '24', '040734', 'JHD', '002', 0, '2006-05-16 19:28:15');
INSERT INTO `casedelt` VALUES (37, 'JHD040735', '2006-05-16', 1, 110.00, 1, '03', '040735', 'JHD', '002', 0, '2006-05-16 19:28:16');
INSERT INTO `casedelt` VALUES (38, 'JHD040736', '2006-05-16', 1, 32.00, 1, '06', '040736', 'JHD', '002', 0, '2006-05-16 19:28:17');
INSERT INTO `casedelt` VALUES (39, 'JHD040737', '2006-05-16', 1, 3000.00, 1, '02', '040737', 'JHD', '002', 0, '2006-05-16 19:28:17');
INSERT INTO `casedelt` VALUES (40, 'JHD040738', '2006-05-16', 1, 170.00, 1, '09', '040738', 'JHD', '002', 0, '2006-05-16 19:28:19');
INSERT INTO `casedelt` VALUES (41, 'JHD040739', '2006-05-16', 1, 546.00, 1, '02', '040739', 'JHD', '002', 0, '2006-05-16 19:28:20');
INSERT INTO `casedelt` VALUES (42, 'JHD040740', '2006-05-16', 1, 54.00, 1, '26', '040740', 'JHD', '002', 0, '2006-05-16 19:28:21');
INSERT INTO `casedelt` VALUES (43, 'JHD040741', '2006-05-16', 1, 3579.00, 1, '04', '040741', 'JHD', '002', 0, '2006-05-16 19:28:22');
INSERT INTO `casedelt` VALUES (44, 'JHD040742', '2006-05-16', 1, 1090.00, 1, '04', '040742', 'JHD', '002', 0, '2006-05-16 19:28:23');
INSERT INTO `casedelt` VALUES (45, 'JHD040743', '2006-05-16', 1, 170.00, 1, '10', '040743', 'JHD', '002', 0, '2006-05-16 19:28:24');
INSERT INTO `casedelt` VALUES (46, 'JHD040744', '2006-05-16', 1, 780.00, 1, '02', '040744', 'JHD', '002', 0, '2006-05-16 19:28:25');
INSERT INTO `casedelt` VALUES (47, 'JHD040745', '2006-05-16', 1, 2005.00, 1, '04', '040745', 'JHD', '002', 0, '2006-05-16 19:28:26');
INSERT INTO `casedelt` VALUES (48, 'JHD040746', '2006-05-16', 1, 161.00, 1, '04', '040746', 'JHD', '002', 0, '2006-05-16 19:28:27');
INSERT INTO `casedelt` VALUES (49, 'JHD040747', '2006-05-16', 1, 70.00, 1, '27', '040747', 'JHD', '002', 0, '2006-05-16 19:28:28');
INSERT INTO `casedelt` VALUES (50, 'JHD040748', '2006-05-16', 1, 75.00, 1, '09', '040748', 'JHD', '002', 0, '2006-05-16 19:28:29');
INSERT INTO `casedelt` VALUES (51, 'JHD040749', '2006-05-16', 1, 32.00, 1, '06', '040749', 'JHD', '002', 0, '2006-05-16 19:28:30');
INSERT INTO `casedelt` VALUES (52, 'JHD040751', '2006-05-16', 1, 185.00, 1, '09', '040751', 'JHD', '002', 0, '2006-05-16 19:28:31');
INSERT INTO `casedelt` VALUES (53, 'JHD040752', '2006-05-16', 1, 12.00, 1, '20', '040752', 'JHD', '002', 0, '2006-05-16 19:28:32');
INSERT INTO `casedelt` VALUES (54, 'JHD040753', '2006-05-16', 1, 30.00, 1, '06', '040753', 'JHD', '002', 0, '2006-05-16 19:28:32');
INSERT INTO `casedelt` VALUES (55, 'JHD040754', '2006-05-16', 1, 540.00, 1, '04', '040754', 'JHD', '002', 0, '2006-05-16 19:35:01');
INSERT INTO `casedelt` VALUES (56, 'JHD040755', '2006-05-16', 1, 170.00, 1, '09', '040755', 'JHD', '002', 0, '2006-05-16 19:35:02');
INSERT INTO `casedelt` VALUES (57, 'JHD040756', '2006-05-16', 1, 165.00, 1, '21', '040756', 'JHD', '002', 0, '2006-05-16 19:35:06');
INSERT INTO `casedelt` VALUES (58, 'JHD040757', '2006-05-16', 1, 200.00, 1, '28', '040757', 'JHD', '002', 0, '2006-05-16 19:35:07');
INSERT INTO `casedelt` VALUES (59, 'JHD040758', '2006-05-16', 1, 140.00, 1, '04', '040758', 'JHD', '002', 0, '2006-05-16 22:35:58');
INSERT INTO `casedelt` VALUES (60, 'JHD040759', '2006-05-16', 1, 18.00, 1, '20', '040759', 'JHD', '002', 0, '2006-05-16 22:36:23');
INSERT INTO `casedelt` VALUES (61, 'CKD999', '2006-05-17', 0, 100.00, 1, 'CKD999', '999', 'CKD', '002', 0, '2006-05-17 10:24:11');
INSERT INTO `casedelt` VALUES (62, 'CKD999', '2006-05-17', 1, 100.00, 1, 'CKD999', '999', 'CKD', '001', 0, '2006-05-17 10:24:11');
INSERT INTO `casedelt` VALUES (64, 'CKD200607', '2006-05-17', 1, 250.00, 1, 'CKD200607', '200607', 'CKD', '002', 0, '2006-05-17 10:45:35');
INSERT INTO `casedelt` VALUES (65, 'CKD200607', '2006-05-17', 0, 250.00, 1, 'CKD200607', '200607', 'CKD', '001', 0, '2006-05-17 10:45:36');

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

-- 
-- 表的结构 `dzdelt`
-- 

CREATE TABLE `dzdelt` (
  `AUTOID` bigint(20) NOT NULL,
  `DZD01` varchar(30) default NULL,
  `DZD02` varchar(30) default NULL,
  `DZD03` varchar(40) default NULL,
  `DZD04` varchar(30) default NULL,
  `DZD05` float(10,2) default NULL,
  `DZD06` float(10,2) default NULL,
  `DZD07` float(10,2) default NULL,
  `DZD08` tinyint(1) default NULL,
  `DZD09` date default NULL,
  `DT998` tinyint(1) default '0',
  `DT999` datetime default NULL,
  PRIMARY KEY  (`AUTOID`)
) TYPE=InnoDB COMMENT='对帐明细表' AUTO_INCREMENT=33 ;

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

INSERT INTO `dzdelt` VALUES (17, '02200603', '0500784', 'UPS山特500V UPS', '2501', 1.00, 260.00, 260.00, 0, '2006-03-10', 0, '2006-04-04 23:15:49');
INSERT INTO `dzdelt` VALUES (18, '02200603', '0500794', '打印头Epson1600KIII', '8301', 1.00, 480.00, 480.00, 0, '2006-03-15', 0, '2006-04-04 23:15:49');
INSERT INTO `dzdelt` VALUES (19, '02200603', '0500808', '扫描仪明基5000S', '3401', 1.00, 380.00, 380.00, 0, '2006-03-23', 0, '2006-04-04 23:15:49');
INSERT INTO `dzdelt` VALUES (20, '02200603', '0500804', '黑色墨盒CanonIP1000', '8109', 5.00, 70.00, 350.00, 0, '2006-03-18', 0, '2006-04-04 23:15:49');
INSERT INTO `dzdelt` VALUES (21, '02200603', '0500803', '黑色墨盒CanonIP1000', '8109', 3.00, 70.00, 210.00, 0, '2006-03-18', 0, '2006-04-04 23:15:49');
INSERT INTO `dzdelt` VALUES (22, '02200603', '0500801', '视保屏飞利蒲17寸', '9102', 1.00, 28.00, 28.00, 0, '2006-03-18', 0, '2006-04-04 23:15:49');
INSERT INTO `dzdelt` VALUES (23, '02200603', '0500800', '墨盒HP4110黑色', '8105', 2.00, 180.00, 360.00, 0, '2006-03-18', 0, '2006-04-04 23:15:49');
INSERT INTO `dzdelt` VALUES (24, '02200603', '0500798', '交换机TP-Link 8口', '2405', 1.00, 160.00, 160.00, 0, '2006-03-16', 0, '2006-04-04 23:15:49');
INSERT INTO `dzdelt` VALUES (25, '02200603', '0500796', '黑色墨盒EpsonC65', '8103', 3.00, 95.00, 285.00, 0, '2006-03-18', 0, '2006-04-04 23:15:49');
INSERT INTO `dzdelt` VALUES (26, '02200603', '0500786', '打印机Epson1600KⅢH', '3102', 1.00, 2500.00, 2500.00, 0, '2006-03-11', 0, '2006-04-04 23:15:49');
INSERT INTO `dzdelt` VALUES (27, '03200603', '0500814', '打卡纸微电脑型', '6202', 5.00, 20.00, 100.00, 0, '2006-03-24', 0, '2006-04-05 17:10:27');
INSERT INTO `dzdelt` VALUES (28, '03200603', '0500814', '彩色墨水e-820(红黄兰各一支)', '8102', 1.00, 70.00, 70.00, 0, '2006-03-24', 0, '2006-04-05 17:10:27');
INSERT INTO `dzdelt` VALUES (29, '03200603', '0500814', '硬盘金钻80G', '1403', 1.00, 510.00, 510.00, 0, '2006-03-24', 0, '2006-04-05 17:10:27');
INSERT INTO `dzdelt` VALUES (30, '03200603', '0500811', '激光打印机HP2600n彩色', '3301', 1.00, 3600.00, 3600.00, 0, '2006-03-24', 0, '2006-04-05 17:10:27');
INSERT INTO `dzdelt` VALUES (31, '39200604', '0500805', '彩色墨水e-820(红黄兰各一支)', '8102', 1.00, 70.00, 70.00, 0, '2006-03-21', 0, '2006-04-08 09:41:51');
INSERT INTO `dzdelt` VALUES (32, '05200603', '0500785', '移动盘256M移动盘B-Link', '2602', 1.00, 220.00, 220.00, 0, '2006-03-10', 0, '2006-05-11 09:27:38');

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

-- 
-- 表的结构 `dzmast`
-- 

CREATE TABLE `dzmast` (
  `AUTOID` bigint(20) NOT NULL,
  `DZM01` varchar(30) default NULL,
  `DZM02` varchar(30) default NULL,
  `DZM03` int(6) default '0',
  `DZM04` date default '0000-00-00',
  `DZM05` date default '0000-00-00',
  `DZM06` date default '0000-00-00',
  `DZM07` tinyint(1) default '0',
  `DT998` tinyint(1) default '0',
  `DT999` datetime default NULL,
  PRIMARY KEY  (`AUTOID`)
) TYPE=InnoDB COMMENT='对帐单主表' AUTO_INCREMENT=36 ;

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

INSERT INTO `dzmast` VALUES (29, '02200603', '02', 200603, '2006-04-04', '2006-02-26', '2006-03-25', 0, 0, '2006-04-05 17:10:44');
INSERT INTO `dzmast` VALUES (30, '03200603', '03', 200603, '2006-04-05', '2006-02-26', '2006-03-25', 0, 0, '2006-04-05 17:10:22');
INSERT INTO `dzmast` VALUES (31, '39200604', '39', 200604, '2006-04-08', '2006-03-01', '2006-03-31', 0, 0, '2006-04-08 09:41:50');
INSERT INTO `dzmast` VALUES (32, '39200603', '39', 200603, '2006-04-08', '2006-02-01', '2006-02-28', 0, 0, '2006-04-08 09:43:50');
INSERT INTO `dzmast` VALUES (33, '07200603', '07', 200603, '2006-05-11', '2006-02-01', '2006-02-28', 0, 0, '2006-05-11 09:27:31');
INSERT INTO `dzmast` VALUES (34, '05200603', '05', 200603, '2006-05-11', '2006-02-26', '2006-03-25', 0, 0, '2006-05-11 09:27:37');
INSERT INTO `dzmast` VALUES (35, '06200603', '06', 200603, '2006-05-11', '2006-02-01', '2006-02-28', 0, 0, '2006-05-11 09:27:43');

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

-- 
-- 表的结构 `factsoftlist`
-- 

CREATE TABLE `factsoftlist` (
  `AUTOID` bigint(20) NOT NULL,