invoice.sql

十分好的一个医院管理系统

CREATE TABLE invoice (
	flowcode char(12),
	orders float,
	unitcode char(6),
	feedate datetime,
	unitpaydate datetime,
	paymonth float,
	paymode float,
	sumfee decimal(16, 2),
	latedate float,
	latefee decimal(16, 2),
	z_employs float,
	z_sumwage decimal(16, 2),
	t_employs float,
	t_sumwage decimal(16, 2),
	l_employs float,
	l_sumwage decimal(16, 2),
	upay_percent decimal(16, 2),
	ppay_percent decimal(16, 2),
	zdis_percent decimal(16, 2),
	tdis_percent decimal(16, 2),
	upay decimal(16, 2),
	fpay decimal(16, 2),
	ppay decimal(16, 2),
	zdis decimal(16, 2),
	tdis decimal(16, 2),
	addpay decimal(16, 2),
	outdis decimal(16, 2),
	sypay_percent decimal(16, 2),
	sypay decimal(16, 2),
	gspay_percent decimal(16, 2),
	gspay decimal(16, 2),
	notes char(255),
	operator char(10),
	stateflag float,
	cwzg char(10),
	skr char(10));
INSERT INTO invoice VALUES (
	'021217102056',
	1,
	'011061',
	'1-1-2002 0:0:0.000',
	'12-17-2002 10:17:0.000',
	1,
	2,
	1169.28,
	0,
	0,
	22,
	14616.00,
	19,
	11962.67,
	0,
	0,
	6.00,
	2.00,
	3.07,
	3.50,
	876.96,
	0,
	292.32,
	448.71,
	418.70,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021217102056',
	2,
	'011061',
	'2-1-2002 0:0:0.000',
	'12-17-2002 10:17:0.000',
	1,
	2,
	1169.28,
	0,
	0,
	22,
	14616.00,
	19,
	11962.67,
	0,
	0,
	6.00,
	2.00,
	3.07,
	3.50,
	876.96,
	0,
	292.32,
	448.71,
	418.70,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021217102056',
	3,
	'011061',
	'3-1-2002 0:0:0.000',
	'12-17-2002 10:17:0.000',
	1,
	2,
	1169.28,
	240,
	0,
	22,
	14616.00,
	19,
	11962.67,
	0,
	0,
	6.00,
	2.00,
	3.07,
	3.50,
	876.96,
	0,
	292.32,
	448.71,
	418.70,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021217103519',
	1,
	'011061',
	'4-1-2002 0:0:0.000',
	'12-17-2002 10:34:0.000',
	1,
	2,
	1100.56,
	0,
	0,
	21,
	13757.00,
	20,
	12821.67,
	0,
	0,
	6.00,
	2.00,
	3.06,
	3.50,
	825.42,
	0,
	275.14,
	420.96,
	448.80,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021217103519',
	2,
	'011061',
	'5-1-2002 0:0:0.000',
	'12-17-2002 10:34:0.000',
	1,
	2,
	1100.56,
	0,
	0,
	21,
	13757.00,
	20,
	12821.67,
	0,
	0,
	6.00,
	2.00,
	3.06,
	3.50,
	825.42,
	0,
	275.14,
	420.96,
	448.80,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021217103519',
	3,
	'011061',
	'6-1-2002 0:0:0.000',
	'12-17-2002 10:34:0.000',
	1,
	2,
	1100.56,
	150,
	0,
	21,
	13757.00,
	20,
	12821.67,
	0,
	0,
	6.00,
	2.00,
	3.06,
	3.50,
	825.42,
	0,
	275.14,
	420.96,
	448.80,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021217161308',
	1,
	'011061',
	'7-1-2002 0:0:0.000',
	'12-17-2002 16:12:0.000',
	1,
	2,
	1145.96,
	0,
	0,
	22,
	14324.58,
	20,
	12821.67,
	0,
	0,
	6.00,
	2.00,
	3.06,
	3.50,
	859.47,
	0,
	286.49,
	438.33,
	448.80,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'系统管理员',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021217161308',
	2,
	'011061',
	'8-1-2002 0:0:0.000',
	'12-17-2002 16:12:0.000',
	1,
	2,
	1145.96,
	0,
	0,
	22,
	14324.58,
	20,
	12821.67,
	0,
	0,
	6.00,
	2.00,
	3.06,
	3.50,
	859.47,
	0,
	286.49,
	438.33,
	448.80,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'系统管理员',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021217161308',
	3,
	'011061',
	'9-1-2002 0:0:0.000',
	'12-17-2002 16:12:0.000',
	1,
	2,
	1145.96,
	60,
	0,
	22,
	14324.58,
	20,
	12821.67,
	0,
	0,
	6.00,
	2.00,
	3.06,
	3.50,
	859.47,
	0,
	286.49,
	438.33,
	448.80,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'系统管理员',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021218093058',
	1,
	'018004',
	'1-1-2002 0:0:0.000',
	'12-18-2002 9:29:0.000',
	1,
	1,
	847.84,
	0,
	0,
	18,
	10598.00,
	4,
	1101.60,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	635.88,
	0,
	211.96,
	309.46,
	38.60,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021218093058',
	2,
	'018004',
	'2-1-2002 0:0:0.000',
	'12-18-2002 9:29:0.000',
	1,
	1,
	847.84,
	0,
	0,
	18,
	10598.00,
	4,
	1101.60,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	635.88,
	0,
	211.96,
	309.46,
	38.60,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021218093058',
	3,
	'018004',
	'3-1-2002 0:0:0.000',
	'12-18-2002 9:29:0.000',
	1,
	1,
	847.84,
	240,
	0,
	18,
	10598.00,
	4,
	1101.60,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	635.88,
	0,
	211.96,
	309.46,
	38.60,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021218093226',
	1,
	'018004',
	'4-1-2002 0:0:0.000',
	'12-18-2002 9:32:0.000',
	1,
	1,
	847.84,
	0,
	0,
	18,
	10598.00,
	4,
	1101.60,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	635.88,
	0,
	211.96,
	309.46,
	38.60,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021218093226',
	2,
	'018004',
	'5-1-2002 0:0:0.000',
	'12-18-2002 9:32:0.000',
	1,
	1,
	847.84,
	0,
	0,
	18,
	10598.00,
	4,
	1101.60,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	635.88,
	0,
	211.96,
	309.46,
	38.60,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021218093226',
	3,
	'018004',
	'6-1-2002 0:0:0.000',
	'12-18-2002 9:32:0.000',
	1,
	1,
	847.84,
	150,
	0,
	18,
	10598.00,
	4,
	1101.60,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	635.88,
	0,
	211.96,
	309.46,
	38.60,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021218093303',
	1,
	'018004',
	'7-1-2002 0:0:0.000',
	'12-18-2002 9:33:0.000',
	1,
	1,
	847.84,
	0,
	0,
	18,
	10598.00,
	4,
	1101.60,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	635.88,
	0,
	211.96,
	309.46,
	38.60,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021218093303',
	2,
	'018004',
	'8-1-2002 0:0:0.000',
	'12-18-2002 9:33:0.000',
	1,
	1,
	847.84,
	0,
	0,
	18,
	10598.00,
	4,
	1101.60,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	635.88,
	0,
	211.96,
	309.46,
	38.60,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021218093303',
	3,
	'018004',
	'9-1-2002 0:0:0.000',
	'12-18-2002 9:33:0.000',
	1,
	1,
	847.84,
	60,
	0,
	18,
	10598.00,
	4,
	1101.60,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	635.88,
	0,
	211.96,
	309.46,
	38.60,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021219153816',
	1,
	'011259',
	'1-1-2002 0:0:0.000',
	'12-19-2002 15:38:0.000',
	1,
	1,
	164.60,
	0,
	0,
	11,
	8230.09,
	5,
	4404.64,
	0,
	0,
	6.00,
	2.00,
	0,
	3.50,
	0,
	493.81,
	164.60,
	0,
	154.20,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021219153816',
	2,
	'011259',
	'2-1-2002 0:0:0.000',
	'12-19-2002 15:38:0.000',
	1,
	1,
	164.60,
	0,
	0,
	11,
	8230.09,
	5,
	4404.64,
	0,
	0,
	6.00,
	2.00,
	0,
	3.50,
	0,
	493.81,
	164.60,
	0,
	154.20,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021219153816',
	3,
	'011259',
	'3-1-2002 0:0:0.000',
	'12-19-2002 15:38:0.000',
	1,
	1,
	164.60,
	0,
	0,
	11,
	8230.09,
	5,
	4404.64,
	0,
	0,
	6.00,
	2.00,
	0,
	3.50,
	0,
	493.81,
	164.60,
	0,
	154.20,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021219154204',
	1,
	'011259',
	'4-1-2002 0:0:0.000',
	'12-19-2002 15:42:0.000',
	1,
	1,
	164.60,
	0,
	0,
	11,
	8230.09,
	5,
	4404.64,
	0,
	0,
	6.00,
	2.00,
	0,
	3.50,
	0,
	493.81,
	164.60,
	0,
	154.20,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021219154204',
	2,
	'011259',
	'5-1-2002 0:0:0.000',
	'12-19-2002 15:42:0.000',
	1,
	1,
	164.60,
	0,
	0,
	11,
	8230.09,
	5,
	4404.64,
	0,
	0,
	6.00,
	2.00,
	0,
	3.50,
	0,
	493.81,
	164.60,
	0,
	154.20,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021219154204',
	3,
	'011259',
	'6-1-2002 0:0:0.000',
	'12-19-2002 15:42:0.000',
	1,
	1,
	164.60,
	0,
	0,
	11,
	8230.09,
	5,
	4404.64,
	0,
	0,
	6.00,
	2.00,
	0,
	3.50,
	0,
	493.81,
	164.60,
	0,
	154.20,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021219154249',
	1,
	'011259',
	'7-1-2002 0:0:0.000',
	'12-19-2002 15:42:0.000',
	1,
	1,
	164.60,
	0,
	0,
	11,
	8230.09,
	5,
	4404.64,
	0,
	0,
	6.00,
	2.00,
	0,
	3.50,
	0,
	493.81,
	164.60,
	0,
	154.20,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021219154249',
	2,
	'011259',
	'8-1-2002 0:0:0.000',
	'12-19-2002 15:42:0.000',
	1,
	1,
	164.60,
	0,
	0,
	11,
	8230.09,
	5,
	4404.64,
	0,
	0,
	6.00,
	2.00,
	0,
	3.50,
	0,
	493.81,
	164.60,
	0,
	154.20,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021219154249',
	3,
	'011259',
	'9-1-2002 0:0:0.000',
	'12-19-2002 15:42:0.000',
	1,
	1,
	164.60,
	0,
	0,
	11,
	8230.09,
	5,
	4404.64,
	0,
	0,
	6.00,
	2.00,
	0,
	3.50,
	0,
	493.81,
	164.60,
	0,
	154.20,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021219154326',
	1,
	'011239',
	'1-1-2002 0:0:0.000',
	'12-19-2002 15:41:0.000',
	1,
	2,
	4015.37,
	0,
	0,
	76,
	50192.10,
	14,
	12048.60,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	3011.53,
	0,
	1003.84,
	1465.61,
	421.70,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'杨良秋',
	'梁碧珍');
INSERT INTO invoice VALUES (
	'021219154326',
	2,
	'011239',
	'2-1-2002 0:0:0.000',
	'12-19-2002 15:41:0.000',
	1,
	2,
	4015.37,
	0,
	0,
	76,
	50192.10,
	14,
	12048.60,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	3011.53,
	0,
	1003.84,
	1465.61,
	421.70,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'杨良秋',
	'梁碧珍');
INSERT INTO invoice VALUES (
	'021219154326',
	3,
	'011239',
	'3-1-2002 0:0:0.000',
	'12-19-2002 15:41:0.000',
	1,
	2,
	4015.37,
	240,
	0,
	76,
	50192.10,
	14,
	12048.60,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	3011.53,
	0,
	1003.84,
	1465.61,
	421.70,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'杨良秋',
	'梁碧珍');
INSERT INTO invoice VALUES (
	'021219154828',
	1,
	'011239',
	'4-1-2002 0:0:0.000',
	'12-19-2002 15:48:0.000',
	1,
	2,
	4015.37,
	0,
	0,
	76,
	50192.10,
	14,
	12048.60,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	3011.53,
	0,
	1003.84,
	1465.61,
	421.70,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'杨良秋',
	'梁碧珍');
INSERT INTO invoice VALUES (
	'021219154828',
	2,
	'011239',
	'5-1-2002 0:0:0.000',
	'12-19-2002 15:48:0.000',
	1,
	2,
	4015.37,
	0,
	0,
	76,
	50192.10,
	14,
	12048.60,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	3011.53,
	0,
	1003.84,
	1465.61,
	421.70,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'杨良秋',
	'梁碧珍');
INSERT INTO invoice VALUES (
	'021219154828',
	3,
	'011239',
	'6-1-2002 0:0:0.000',
	'12-19-2002 15:48:0.000',
	1,
	2,
	4015.37,
	150,
	0,
	76,
	50192.10,
	14,
	12048.60,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	3011.53,
	0,
	1003.84,
	1465.61,
	421.70,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'杨良秋',
	'梁碧珍');
INSERT INTO invoice VALUES (
	'021219160308',
	1,
	'011239',
	'7-1-2002 0:0:0.000',
	'12-19-2002 16:3:0.000',
	1,
	2,
	4004.85,
	0,
	0,
	76,
	50060.70,
	15,
	12716.30,
	0,
	0,
	6.00,
	2.00,
	2.90,
	3.50,
	3003.64,
	0,
	1001.21,
	1451.76,
	445.07,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'杨良秋',
	'梁碧珍');
INSERT INTO invoice VALUES (
	'021219160308',
	2,
	'011239',
	'8-1-2002 0:0:0.000',
	'12-19-2002 16:3:0.000',
	1,
	2,
	4004.85,
	0,
	0,
	76,
	50060.70,
	15,
	12716.30,
	0,
	0,
	6.00,
	2.00,
	2.90,
	3.50,
	3003.64,
	0,