/*!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 tis620 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
DROP TABLE IF EXISTS `income`;
CREATE TABLE `income` (
  `income` char(2) NOT NULL DEFAULT '',
  `name` varchar(200) DEFAULT NULL,
  `bill_order` tinyint(4) DEFAULT NULL,
  `income_group` char(2) DEFAULT NULL,
  `group1` tinyint(4) DEFAULT NULL,
  `group2` tinyint(4) DEFAULT NULL,
  `group3` tinyint(4) DEFAULT NULL,
  `group4` tinyint(4) DEFAULT NULL,
  `def_paidst` char(2) DEFAULT NULL,
  `dummy_icode` varchar(7) DEFAULT NULL,
  `outline` varchar(15) DEFAULT NULL,
  `header1` varchar(150) DEFAULT NULL,
  `header2` varchar(150) DEFAULT NULL,
  `income_guid` varchar(38) DEFAULT NULL,
  `note` text,
  `drg_group` char(2) DEFAULT NULL,
  `std_group` char(2) DEFAULT NULL,
  `nk2_group` int(11) DEFAULT NULL,
  `ename` varchar(150) DEFAULT NULL,
  `display_order` int(11) DEFAULT NULL,
  `drg_chrgitem_id` int(11) DEFAULT NULL,
  `no_send_sks` char(1) DEFAULT NULL,
  `hos_guid` varchar(38) DEFAULT NULL,
  `rvsp_group` varchar(10) DEFAULT NULL,
  `income_sss_group_code` varchar(15) DEFAULT NULL,
  `allow_split_finance` char(1) DEFAULT NULL,
  `finance_tran_order` int(11) DEFAULT NULL,
  `no_sp_discount` char(1) DEFAULT NULL,
  `finance_split_icode` varchar(7) DEFAULT NULL,
  `sr1_acc_chart_code` varchar(20) DEFAULT NULL,
  `income_csmbs_code` varchar(2) DEFAULT NULL,
  `dc1_acc_chart_code` varchar(20) DEFAULT NULL,
  `sr2_acc_chart_code` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`income`),
  KEY `group1` (`group1`),
  KEY `group2` (`group2`),
  KEY `group3` (`group3`),
  KEY `group4` (`group4`),
  KEY `income_group` (`income_group`),
  KEY `name` (`name`),
  KEY `ix_outline` (`outline`),
  KEY `ix_income_guid` (`income_guid`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;

LOCK TABLES `income` WRITE;
/*!40000 ALTER TABLE `income` DISABLE KEYS */;
INSERT INTO `income` VALUES
  ('01', '01-ค่าห้องและค่าอาหาร', 0, '01', NULL, 1, NULL, NULL, NULL, '3001163', '2.1', NULL, NULL, '{A98D8484-B233-11DF-9F6C-FEF8DF76AE08}', NULL, '07', '01', 16, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  ('02', '02-ค่าอวัยวะเทียมและอุปกรณ์ในการบำบัดรักษาโรค', 0, '02', NULL, 2, NULL, NULL, NULL, '3001164', '1.1.7', NULL, NULL, '{A98D890F-B233-11DF-9F6C-FEF8DF76AE08}', NULL, '09', '02', 9, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  ('03', '03-ค่ายาและสารอาหารทางเส้นเลือด (ยาในบัญชียาหลักแห่งชาติ)', 0, '03', NULL, 3, NULL, NULL, NULL, '3001165', '1.1.1', NULL, NULL, '{A98D8C4A-B233-11DF-9F6C-FEF8DF76AE08}', NULL, '05', '03', 12, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  ('04', '04-ค่ายากลับบ้าน', 0, '04', NULL, 4, NULL, NULL, NULL, '3001166', '1.1.1(2)', NULL, NULL, '{A98D8F62-B233-11DF-9F6C-FEF8DF76AE08}', NULL, '05', '04', 12, NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  ('05', '05-ค่าเวชภัณฑ์ที่มิใช่ยา', 0, '05', NULL, 5, NULL, NULL, NULL, '3001167', '1.1.2', NULL, NULL, '{A98D927F-B233-11DF-9F6C-FEF8DF76AE08}', NULL, '05', '05', 12, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  ('06', '06-ค่าบริการโลหิตและส่วนประกอบของโลหิต', 0, '06', NULL, 6, NULL, NULL, NULL, '3001168', '1.1.3', NULL, NULL, '{A98D95A1-B233-11DF-9F6C-FEF8DF76AE08}', NULL, '09', '06', 2, NULL, NULL, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  ('07', '07-ค่าตรวจวินิจฉัยทางเทคนิคการแพทย์และพยาธิวิทยา', 0, '07', NULL, 7, NULL, NULL, NULL, '3001169', '1.1.4', NULL, NULL, '{A98D98D8-B233-11DF-9F6C-FEF8DF76AE08}', NULL, '02', '07', 1, NULL, NULL, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  ('08', '08-ค่าตรวจวินิจฉัยและรักษาทางรังสีวิทยา', 0, '08', NULL, 8, NULL, NULL, NULL, '3001170', '1.1.5', NULL, NULL, '{A98D9BFC-B233-11DF-9F6C-FEF8DF76AE08}', NULL, '01', '08', 4, NULL, NULL, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  ('09', '09-ค่าตรวจวินิจฉัยโดยวิธีพิเศษอื่นๆ', 0, '09', NULL, 9, NULL, NULL, NULL, '3001171', '1.1.6', NULL, NULL, '{A98D9F04-B233-11DF-9F6C-FEF8DF76AE08}', NULL, '04', '09', 5, NULL, NULL, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  ('10', '10-ค่าอุปกรณ์ของใช้และเครื่องมือทางการแพทย์', 0, '10', NULL, 10, NULL, NULL, NULL, '3001172', '1.1.7', NULL, NULL, '{A98DA218-B233-11DF-9F6C-FEF8DF76AE08}', NULL, '09', '10', 9, NULL, NULL, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  ('11', '11-ค่าทำหัตถการ และวิสัญญี', 0, '11', NULL, 11, NULL, NULL, NULL, '3001173', '1.2.2', NULL, NULL, '{A98DA533-B233-11DF-9F6C-FEF8DF76AE08}', NULL, '03', '11', 6, NULL, NULL, 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  ('12', '12-ค่าบริการทางการพยาบาล', 0, '12', NULL, 12, NULL, NULL, NULL, '3001174', '1.1', NULL, NULL, '{A98DA84F-B233-11DF-9F6C-FEF8DF76AE08}', NULL, '09', '12', 14, NULL, NULL, 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  ('13', '13-ค่าบริการทางทันตกรรม', 0, '13', NULL, 13, NULL, NULL, NULL, '3001175', '1.1.9', NULL, NULL, '{A98DAB55-B233-11DF-9F6C-FEF8DF76AE08}', NULL, '09', '13', 14, NULL, NULL, 13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  ('14', '14-ค่าบริการทางกายภาพบำบัดและทางเวชกรรมฟื้นฟู', 0, '14', NULL, 14, NULL, NULL, NULL, '3001176', '1.1.10', NULL, NULL, '{A98DAE6E-B233-11DF-9F6C-FEF8DF76AE08}', NULL, '04', '14', 13, NULL, NULL, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  ('15', '15-ค่าบริการฝังเข็ม และค่าบริการการให้การบำบัดของผู้ประกอบโรคศิลปะอื่น', 0, '15', NULL, 15, NULL, NULL, NULL, '3001177', '1.1.11', NULL, NULL, '{A98DB182-B233-11DF-9F6C-FEF8DF76AE08}', NULL, '09', '15', 14, NULL, NULL, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  ('16', '16-ค่าบริการอื่น ๆ ที่ไม่เกี่ยวกับการรักษาพยาบาลโดยตรง', 0, '16', NULL, 16, NULL, NULL, NULL, '3001178', '2.6', NULL, NULL, '{A98DB4A3-B233-11DF-9F6C-FEF8DF76AE08}', NULL, '09', '16', 14, NULL, NULL, 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  ('17', '17-ค่ายานอกบัญชียาหลักแห่งชาติ', 0, '17', NULL, 17, NULL, NULL, NULL, '3001179', '1.1.1', NULL, NULL, '{A98DB7CA-B233-11DF-9F6C-FEF8DF76AE08}', NULL, '05', '03', 12, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  ('18', '18-คำธรรมเนียมทางการแพทย์', 0, '18', NULL, 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
/*!40000 ALTER TABLE `income` ENABLE KEYS */;
UNLOCK TABLES;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!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 */;
