--
-- Table structure for table `master_kanri`
--

DROP TABLE IF EXISTS `master_kanri`;
CREATE TABLE IF NOT EXISTS `master_kanri` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `date_entered` datetime NOT NULL,
  `date_modified` datetime NOT NULL,
  `modified_user_id` char(36) NOT NULL,
  `created_by` char(36) NOT NULL,
  `inactive` tinyint(1) DEFAULT '0',
  `display_order` int(11) DEFAULT NULL,
  `master_name` varchar(40) DEFAULT NULL,
  `master_group` varchar(40) DEFAULT NULL,
  `school_id` char(36) DEFAULT NULL,
  `master_category1` varchar(40) DEFAULT NULL,
  `master_category2` varchar(40) DEFAULT NULL,
  `field1` varchar(40) DEFAULT NULL,
  `field2` varchar(40) DEFAULT NULL,
  `field3` varchar(40) DEFAULT NULL,
  `field4` varchar(40) DEFAULT NULL,
  `field5` varchar(40) DEFAULT NULL,
  `field6` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2163 ;

--
-- Dumping data for table `master_kanri`
--

INSERT INTO `master_kanri` (`id`, `deleted`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `inactive`, `display_order`, `master_name`, `master_group`, `school_id`, `master_category1`, `master_category2`, `field1`, `field2`, `field3`, `field4`, `field5`, `field6`) VALUES
(2, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, 'ハマふれんど', 'hojoken', NULL, '141', NULL, '2000', NULL, NULL, NULL, NULL, NULL),
(3, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '神厚振（レクリェーション券）', 'hojoken', NULL, '141', NULL, '1000', NULL, NULL, NULL, NULL, NULL),
(4, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '使用不可・横かがやき', 'hojoken', NULL, '142', NULL, '1000', NULL, NULL, NULL, NULL, NULL),
(5, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '川崎市職員　100円', 'hojoken', NULL, '141', NULL, '100', NULL, NULL, NULL, NULL, NULL),
(6, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '川崎市職員　500円', 'hojoken', NULL, '141', NULL, '500', NULL, NULL, NULL, NULL, NULL),
(7, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '使用不可・横浜税関', 'hojoken', NULL, '142', NULL, '2500', NULL, NULL, NULL, NULL, NULL),
(8, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, 'セラｻｰﾋﾞｽ3,000円', 'hojoken', NULL, '141', NULL, '3000', NULL, NULL, NULL, NULL, NULL),
(9, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, 'セラｻｰﾋﾞｽ5,000円', 'hojoken', NULL, '141', NULL, '5000', NULL, NULL, NULL, NULL, NULL),
(10, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '墨田区勤労者', 'hojoken', NULL, '141', NULL, '3000', NULL, NULL, NULL, NULL, NULL),
(11, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '使用不可10/04/02ﾍﾞﾈﾌｨｯﾄ補助券', 'hojoken', NULL, '142', NULL, '0', NULL, NULL, NULL, NULL, NULL),
(12, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, 'ねりまファミリーパック', 'hojoken', NULL, '141', NULL, '5000', NULL, NULL, NULL, NULL, NULL),
(13, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, 'ﾍﾞﾈﾌｨｯﾄ・ﾎﾟｲﾝﾄ', 'hojoken', NULL, '141', NULL, '1', NULL, NULL, NULL, NULL, NULL),
(14, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '福利厚生倶楽部', 'hojoken', NULL, '141', NULL, '500', NULL, NULL, NULL, NULL, NULL),
(16, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, 'ﾊﾞﾘｭｰﾈｯﾄﾜｰｸｽ', 'hojoken', NULL, '141', NULL, '1', NULL, NULL, NULL, NULL, NULL),
(17, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '札幌市中小企業共済', 'hojoken', NULL, '141', NULL, '2000', NULL, NULL, NULL, NULL, NULL),
(18, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '使用不可・公共済神奈川', 'hojoken', NULL, '142', NULL, '1000', NULL, NULL, NULL, NULL, NULL),
(23, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '福岡県教職員補助券1,000円', 'hojoken', NULL, '141', NULL, '1000', NULL, NULL, NULL, NULL, NULL),
(24, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '福岡ギフト券500円', 'hojoken', NULL, '141', NULL, '500', NULL, NULL, NULL, NULL, NULL),
(25, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '福岡ギフト券1,000円', 'hojoken', NULL, '141', NULL, '1000', NULL, NULL, NULL, NULL, NULL),
(26, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '京都市職員厚生会共通利用券500円', 'hojoken', NULL, '141', NULL, '500', NULL, NULL, NULL, NULL, NULL),
(27, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '名古屋割引1,000円', 'hojoken', NULL, '141', NULL, '1000', NULL, NULL, NULL, NULL, NULL),
(28, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '名古屋割引2,000円', 'hojoken', NULL, '141', NULL, '2000', NULL, NULL, NULL, NULL, NULL),
(29, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '名古屋割引3,000円', 'hojoken', NULL, '141', NULL, '3000', NULL, NULL, NULL, NULL, NULL),
(30, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '名古屋割引4,000円', 'hojoken', NULL, '141', NULL, '4000', NULL, NULL, NULL, NULL, NULL),
(31, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '名古屋割引5,000円', 'hojoken', NULL, '141', NULL, '5000', NULL, NULL, NULL, NULL, NULL),
(32, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, 'ｾﾗｻｰﾋﾞｽ1,500円', 'hojoken', NULL, '141', NULL, '1500', NULL, NULL, NULL, NULL, NULL),
(33, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, 'ｾﾗｻｰﾋﾞｽ6,500円', 'hojoken', NULL, '141', NULL, '6500', NULL, NULL, NULL, NULL, NULL),
(34, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, 'ｾﾗｻｰﾋﾞｽ8,000円', 'hojoken', NULL, '141', NULL, '8000', NULL, NULL, NULL, NULL, NULL),
(35, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '湘南教室補助券', 'hojoken', NULL, '141', NULL, '500', NULL, NULL, NULL, NULL, NULL),
(50, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 1, '会社員', 'anqeto', NULL, 'anketo_shokugyo', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(51, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 2, '公務員', 'anqeto', NULL, 'anketo_shokugyo', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(52, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 3, '立新聞', 'anqeto', NULL, 'anketo_baitai', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(53, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 4, 'HP', 'anqeto', NULL, 'anketo_baitai', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(54, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 5, '教養', 'anqeto', NULL, 'anketo_janru', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(55, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 6, '外国語', 'anqeto', NULL, 'anketo_janru', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(60, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 1, '新聞', 'ninchi_baitai_course', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(61, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 2, '看板', 'ninchi_baitai_course', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(62, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 3, 'ＨＰ', 'ninchi_baitai_course', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 4, '検索エンジン', 'ninchi_baitai_course', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(70, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 1, '新聞記事', 'ninchi_baitai_group', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(71, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 2, '新聞広告', 'ninchi_baitai_group', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(72, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 3, 'チラシ・パンフレット', 'ninchi_baitai_group', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(73, 0, '2012-12-05 10:00:00', '2012-12-11 20:42:08', 'a437cc11-564c-e5c4-3ff0-4c88c6961e3b', '1', 0, 4, 'オリコミ', 'ninchi_baitai_group', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(141, 0, '2012-12-05 00:00:00', '2012-12-05 00:00:00', '', '', 0, NULL, '使用中', 'hojoken_group', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(142, 0, '2012-12-05 00:00:00', '2012-12-05 00:00:00', '', '', 0, NULL, '使用停止', 'hojoken_group', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(201, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '使用中', 'tatekaekin_group', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(202, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '使用停止', 'tatekaekin_group', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(205, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '神教振・現役', 'tatekaekin', NULL, '201', NULL, '10000', '1250', NULL, NULL, NULL, NULL),
(217, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '神教振・現役', 'tatekaekin', NULL, '201', NULL, '10000', '3000', NULL, NULL, NULL, NULL),
(218, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '神教振・ＯＢ', 'tatekaekin', NULL, '201', NULL, '10000', '1000', NULL, NULL, NULL, NULL),
(219, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '神教振・ＯＢシルバー', 'tatekaekin', NULL, '201', NULL, '10000', '1000', NULL, NULL, NULL, NULL),
(220, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '★神教振・現役（他社入会）', 'tatekaekin', NULL, '201', NULL, '10000', '3000', NULL, NULL, NULL, NULL),
(221, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '★神教振・ＯＢ（他社入会）', 'tatekaekin', NULL, '201', NULL, '10000', '1250', NULL, NULL, NULL, NULL),
(278, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '神教振現役・継続', 'tatekaekin', NULL, '201', NULL, '10000', '3000', NULL, NULL, NULL, NULL),
(279, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '神教振・ＯＢ継続', 'tatekaekin', NULL, '201', NULL, '10000', '1000', NULL, NULL, NULL, NULL),
(282, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '神教振・臨時現役', 'tatekaekin', NULL, '201', NULL, '10000', '1250', NULL, NULL, NULL, NULL),
(308, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '×神教振　継続★', 'tatekaekin', NULL, '201', NULL, '10000', '3000', NULL, NULL, NULL, NULL),
(380, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '◎神教振・現役（札幌）', 'tatekaekin', NULL, '201', NULL, '10000', '3000', NULL, NULL, NULL, NULL),
(381, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '◎神教振現役・継続（札幌）', 'tatekaekin', NULL, '201', NULL, '10000', '3000', NULL, NULL, NULL, NULL),
(382, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '◎神教振OB（札幌）', 'tatekaekin', NULL, '201', NULL, '10000', '1000', NULL, NULL, NULL, NULL),
(383, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '◎神教振OB・継続（札幌）', 'tatekaekin', NULL, '201', NULL, '10000', '1000', NULL, NULL, NULL, NULL),
(384, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '◎神教振シニア', 'tatekaekin', NULL, '201', NULL, '10000', '1000', NULL, NULL, NULL, NULL),
(385, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '☆神教振現役（名古屋）', 'tatekaekin', NULL, '201', NULL, '10000', '3000', NULL, NULL, NULL, NULL),
(386, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '☆神教振現役・継続（名古屋）', 'tatekaekin', NULL, '201', NULL, '10000', '3000', NULL, NULL, NULL, NULL),
(387, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '☆神教振OB（名古屋）', 'tatekaekin', NULL, '201', NULL, '1000', '1000', NULL, NULL, NULL, NULL),
(388, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '☆神教振OB・継続（名古屋）', 'tatekaekin', NULL, '201', NULL, '10000', '1000', NULL, NULL, NULL, NULL),
(389, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, NULL, '☆神教振シニア', 'tatekaekin', NULL, '201', NULL, '10000', '1000', NULL, NULL, NULL, NULL),
(401, 0, '2012-12-05 10:00:00', '2012-12-25 23:31:35', 'a437cc11-564c-e5c4-3ff0-4c88c6961e3b', '1', 0, 1, '新宿', 'nenkihenko', 'sssssss-1111', NULL, NULL, '2013-02-17', '2013-05-19', '2012-08-19', '2012-11-17', NULL, NULL),
(403, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 2, '横浜', 'nenkihenko', '49caa19d-9872-3095-6bd4-5001d0aa692d', NULL, NULL, '2013-02-17', '2013-05-19', '2012-08-19', '2012-11-17', NULL, NULL),
(405, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 3, '立川', 'nenkihenko', 'a32c39d6-45da-a750-6e4d-5001d0bd7a8d', NULL, NULL, '2013-02-17', '2013-05-19', '2012-08-19', '2012-11-17', NULL, NULL),
(406, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 4, '湘南', 'nenkihenko', 'b0845182-f1bc-145f-0560-5001d0cbee2a', NULL, NULL, '2013-02-17', '2013-05-19', '2012-08-19', '2012-11-17', NULL, NULL),
(417, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 5, '札幌', 'nenkihenko', '28e74451-24cc-c806-9642-5001d0f926d9', NULL, NULL, '2013-02-17', '2013-05-19', '2012-08-19', '2012-11-17', NULL, NULL),
(420, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 6, '中之島', 'nenkihenko', 'c083c4e8-6f1d-24ea-fd47-5001d0b9910f', NULL, NULL, '2013-02-17', '2013-05-19', '2012-08-19', '2012-11-17', NULL, NULL),
(422, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 7, '川西', 'nenkihenko', '5ea7a466-203e-45f4-582c-5001d12b64db', NULL, NULL, '2013-02-17', '2013-05-19', '2012-08-19', '2012-11-17', NULL, NULL),
(424, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 8, '芦屋', 'nenkihenko', '5bc40075-3911-d52a-a0f8-5001d15a06e5', NULL, NULL, '2013-02-17', '2013-05-19', '2012-08-19', '2012-11-17', NULL, NULL),
(428, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 9, '京都', 'nenkihenko', 'c387f0ac-5700-6490-3264-5001d1127ee7', NULL, NULL, '2013-02-17', '2013-05-19', '2012-08-19', '2012-11-17', NULL, NULL),
(429, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 10, '梅田', 'nenkihenko', 'bb0d4d73-13a4-b000-36a6-5001d0094cb6', NULL, NULL, '2013-02-17', '2013-05-19', '2012-08-19', '2012-11-17', NULL, NULL),
(436, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 11, '北九州', 'nenkihenko', '1ca1eb40-372a-27a2-bf44-5001d1ad9d91', NULL, NULL, '2013-02-17', '2013-05-19', '2012-08-19', '2012-11-17', NULL, NULL),
(437, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 12, '福岡', 'nenkihenko', 'a312c57a-0e45-6f65-0402-5001d1e84f1d', NULL, NULL, '2013-02-17', '2013-05-19', '2012-08-19', '2012-11-17', NULL, NULL),
(445, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 13, '名古屋', 'nenkihenko', 'e86510a2-302b-7c34-250d-5001d1fc1b41', NULL, NULL, '2013-02-17', '2013-05-19', '2012-08-19', '2012-11-17', NULL, NULL),
(499, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 14, 'test campus', 'nenkihenko', '687ec71c-1c7d-6c97-fc2a-4c889fc5d652', NULL, NULL, '2013-02-17', '2013-05-19', '2012-08-19', '2012-11-17', NULL, NULL),
(501, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 0, '個人', 'yutai_kubun', NULL, '1000', NULL, '0', '1', NULL, '切捨て', NULL, NULL),
(502, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 0, 'シニア', 'yutai_kubun', NULL, '1000', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(503, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 0, '高校生・大学生', 'yutai_kubun', NULL, '1000', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(504, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 60, '★東京都福利厚生事業団', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(506, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 0, '法人', 'yutai_kubun', NULL, '1000', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(507, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 3, '★タカシマヤ', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(508, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 3, '★ルミネカード', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(509, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×アスパラ（使用不可）', 'yutai_kubun', NULL, '1999', NULL, NULL, '10', '2630', '切上げ', NULL, NULL),
(510, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 56, '★わかば（神奈川県民共済）', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(511, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 13, '◆朝日メイト（大阪）', 'yutai_kubun', NULL, '1002', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(512, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×朝日メイト（無料）終了', 'yutai_kubun', NULL, '1999', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(513, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 58, '★東芝ＢＬ', 'yutai_kubun', NULL, '1001', NULL, NULL, '1', '2625', '切捨て', NULL, NULL),
(514, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 59, '★文京アカデミア講座', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(515, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×東京都福利厚生事業団（無料）終了', 'yutai_kubun', NULL, '1999', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(516, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 61, '★特別区職員互助組合', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(522, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 69, '★神厚振・共済組合神奈川支部', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', 'true', NULL),
(523, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 70, '★横浜市職員厚生会', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(524, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 72, '×川崎市職員厚生会・本人', 'yutai_kubun', NULL, '1999', NULL, NULL, '1', '2625', '切捨て', NULL, NULL),
(525, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 74, '×川崎市職員厚生会・家族', 'yutai_kubun', NULL, '1999', NULL, NULL, '1', '2625', '切捨て', NULL, NULL),
(526, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×横浜税関（200803月終了）', 'yutai_kubun', NULL, '1999', NULL, '0.5', '10', NULL, '切上げ', NULL, NULL),
(527, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 75, '★神奈川県弘済会', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(528, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 77, '★藤沢市職員厚生会', 'yutai_kubun', NULL, '1001', NULL, NULL, '1', '2625', '切捨て', NULL, NULL),
(529, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 43, '朝日新聞関係（本人・家族）', 'yutai_kubun', NULL, '1000', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(530, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 45, 'ＡＣＣ・ＪＴＢ社員／家族', 'yutai_kubun', NULL, '1000', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(531, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 47, 'ＡＣＣ・ＪＴＢ講師／家族', 'yutai_kubun', NULL, '1000', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(532, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 46, 'ＡＣＣ・ＪＴＢ社員の友達紹介', 'yutai_kubun', NULL, '1000', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(533, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 55, 'ACC千葉からの登録入会', 'yutai_kubun', NULL, '1000', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(534, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 54, 'ACC千葉からの（新規）更新入会', 'yutai_kubun', NULL, '1000', NULL, '0.8', '1', NULL, '切捨て', NULL, NULL),
(535, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 82, '★住友ビルテナント社員', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(536, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 81, '★新宿住友ﾋﾞﾙ管理職員', 'yutai_kubun', NULL, '1001', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(537, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 83, '★ルミネ職員', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(538, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 84, '★協同プランナー', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(539, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 86, '★神奈川県経営者福祉財団ｸﾞﾘｰﾝｶｰﾄ', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(540, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 85, '★美工講座体験受講後の入会', 'yutai_kubun', NULL, '1001', NULL, '0.4', '1', NULL, '切捨て', NULL, NULL),
(541, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×特例会員更新（更新期間超過）終了', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(542, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×入会新規無料ｷｬﾝﾍﾟｰﾝ（終了）', 'yutai_kubun', NULL, '1999', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(543, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×入会新規無料（特例）終了', 'yutai_kubun', NULL, '1999', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(544, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 95, '返金全額　', 'yutai_kubun', NULL, '1000', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(545, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 97, '★返金新規3分の2　3,500円', 'yutai_kubun', NULL, '1001', NULL, NULL, '1', '3500', '切捨て', NULL, NULL),
(546, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 98, '★返金新規3分の１　1,750円', 'yutai_kubun', NULL, '1001', NULL, NULL, '1', '1750', '切捨て', NULL, NULL),
(547, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×返金全額・使用不可', 'yutai_kubun', NULL, '1001', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(548, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 100, '★返金継続3分の２　1,750円', 'yutai_kubun', NULL, '1001', NULL, NULL, '1', '1750', '切捨て', NULL, NULL),
(549, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 101, '★返金継続3分の１　875円', 'yutai_kubun', NULL, '1001', NULL, NULL, '1', '875', '切捨て', NULL, NULL),
(550, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×返金団体使用不可全額　', 'yutai_kubun', NULL, '1999', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(551, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '★返金団体3分の2　1,750円', 'yutai_kubun', NULL, '1001', NULL, NULL, '1', '4375', '切捨て', NULL, NULL),
(552, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '★返金団体3分の1　875円', 'yutai_kubun', NULL, '1001', NULL, NULL, '1', '3500', '切捨て', NULL, NULL),
(553, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×ACC本支社会員登録', 'yutai_kubun', NULL, '1999', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(554, 1, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 93, '法人', 'yutai_kubun', NULL, '1000', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(555, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×他社からの継続更新', 'yutai_kubun', NULL, '1999', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(556, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 94, '★西多摩霊園（法人契約が満員の時使用）', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(557, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 88, '★工学院大学生', 'yutai_kubun', NULL, '1001', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(558, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 89, '★工学院大学職員', 'yutai_kubun', NULL, '1001', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(559, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 90, '★工学院大学職員の家族', 'yutai_kubun', NULL, '1001', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(560, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 92, '★エステックビル職員', 'yutai_kubun', NULL, '1001', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(561, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 91, '★エステックビルﾃﾅﾝﾄ', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(562, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 53, 'その他入会金　　　　（半額）', 'yutai_kubun', NULL, '1000', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(563, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×ぺアーレ新宿', 'yutai_kubun', NULL, '1999', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(564, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×全日通文化（終了）', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(565, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 87, '★社会保険職員共済組合・東京支部', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(566, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×都民カレッジ', 'yutai_kubun', NULL, '1999', NULL, '1', '10', NULL, '切上げ', NULL, NULL),
(567, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×ＫＡＺ（横浜）', 'yutai_kubun', NULL, '1999', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(568, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×ＫＡＺ会員', 'yutai_kubun', NULL, '1999', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(569, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×毎日カルチャーシティ', 'yutai_kubun', NULL, '1999', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(570, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×横浜市水道局職員厚生会（終了）', 'yutai_kubun', NULL, '1999', NULL, '0.5', '10', NULL, '切上げ', NULL, NULL),
(571, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×東京都消防庁（契約切れ）', 'yutai_kubun', NULL, '1999', NULL, '0.5', '10', NULL, '切上げ', NULL, NULL),
(572, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×東京都消防庁ｷｬﾝﾍﾟｰﾝ終了', 'yutai_kubun', NULL, '1999', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(573, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 57, '★ハマふれんど', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(574, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×ぺアーレ藤沢無料ｷｬﾝﾍﾟｰﾝ', 'yutai_kubun', NULL, '1999', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(575, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×LES移行用仮更新０円', 'yutai_kubun', NULL, '1999', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(576, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×LES移行用2,620円', 'yutai_kubun', NULL, '1999', NULL, NULL, '10', '2630', '切捨て', NULL, NULL),
(577, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '中学生以下', 'yutai_kubun', NULL, '1000', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(580, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 73, '×川崎市職員本人・継続', 'yutai_kubun', NULL, '1999', NULL, '5', '10', NULL, '切捨て', NULL, NULL),
(581, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×東芝ＢＬ・継続（終了）', 'yutai_kubun', NULL, '1999', NULL, '5', '10', NULL, '切捨て', NULL, NULL),
(583, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×優待50・継続（0803終了）', 'yutai_kubun', NULL, '1999', NULL, '5', '1', NULL, '切捨て', NULL, NULL),
(584, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 0, 'さ', 'yutai_kubun', NULL, '1000', NULL, '0', '1', NULL, '切捨て', NULL, NULL),
(585, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 99, '★返金全額・継続　2,625円', 'yutai_kubun', NULL, '1001', NULL, NULL, '1', '2625', '切捨て', NULL, NULL),
(586, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×新宿語学ｷｬﾝﾍﾟｰﾝ入会無料', 'yutai_kubun', NULL, '1999', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(587, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 76, '★川崎勤労者福祉共済', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(588, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 80, '★横浜事業課紹介', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(589, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 46, '返金額新規全額　2,625円', 'yutai_kubun', NULL, '1000', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(590, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 79, '★横・美術講座特集', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(591, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×横浜産経学園・無料（終了）', 'yutai_kubun', NULL, '1999', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(592, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×タカシマヤ・継続', 'yutai_kubun', NULL, '1999', NULL, '0', '1', NULL, '切捨て', NULL, NULL),
(593, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×ルミネ・継続', 'yutai_kubun', NULL, '1999', NULL, '0', '1', NULL, '切捨て', NULL, NULL),
(594, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 48, '講師紹介　　　　　　（無料）', 'yutai_kubun', NULL, '1000', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(595, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×ドゥスポーツ会員無料　8/31まで', 'yutai_kubun', NULL, '1999', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(596, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×ｻﾝｼｬｲﾝ文化ｾﾝﾀｰ無料　', 'yutai_kubun', NULL, '1999', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(597, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×60歳無料ｷｬﾝﾍﾟｰﾝ（終了）', 'yutai_kubun', NULL, '1999', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(598, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×家族新規無料ｷｬﾝﾍﾟｰﾝ終了', 'yutai_kubun', NULL, '1999', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(599, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 3, '◎一般（札幌）', 'yutai_kubun', NULL, '1005', NULL, '0.4', '1', NULL, '切捨て', NULL, NULL),
(600, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×継続更新（札幌）', 'yutai_kubun', NULL, '1999', NULL, NULL, '1', '525', '切捨て', NULL, NULL),
(601, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 3, '◎悠々会員（札幌）', 'yutai_kubun', NULL, '1005', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(602, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 4, '◎ＡＦＣ会員（札幌）', 'yutai_kubun', NULL, '1005', NULL, '0.7', '1', NULL, '切捨て', NULL, NULL),
(603, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 4, '◎ＡＦＣ会員継続更新（札幌）', 'yutai_kubun', NULL, '1005', NULL, NULL, '1', '525', '切捨て', NULL, NULL),
(604, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 76, '★神奈川県看護協会', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(605, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 71, '★横浜市交通局厚生会', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(606, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×わかば（神奈川県民共済）・継続', 'yutai_kubun', NULL, '1999', NULL, '0', '1', NULL, '切捨て', NULL, NULL),
(607, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×朝日メイト・継続0903終了', 'yutai_kubun', NULL, '1999', NULL, '0', '1', NULL, '切捨て', NULL, NULL),
(609, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 49, '講師紹介　　　　　　（半額）', 'yutai_kubun', NULL, '1000', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(610, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 1, 'JTBカルチャーサロン', 'yutai_kubun', NULL, '1999', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(611, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×三越ｶﾙﾁｬｰｻﾛﾝ（使用せず）', 'yutai_kubun', NULL, '1999', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(612, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 100, 'テスト', 'yutai_kubun', NULL, '1000', NULL, NULL, '1', '-1625', '切捨て', NULL, NULL),
(613, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 52, 'その他入会金　　　　（無料）', 'yutai_kubun', NULL, '1000', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(614, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 11, '☆一般（名古屋）', 'yutai_kubun', NULL, '1003', NULL, '0.2', '1', NULL, '切捨て', NULL, NULL),
(615, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 11, '☆大学生（名古屋）', 'yutai_kubun', NULL, '1003', NULL, '0.6', '1', NULL, '切捨て', NULL, NULL),
(616, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 0, '18歳以下', 'yutai_kubun', NULL, '1000', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(617, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 11, '☆ないすらいふの会（名古屋）', 'yutai_kubun', NULL, '1003', NULL, '0.6', '1', NULL, '切捨て', NULL, NULL),
(618, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 24, '■ないすらいふの会（西部）法人に変更', 'yutai_kubun', NULL, '1999', NULL, '0.6', '1', NULL, '切捨て', NULL, NULL),
(619, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 12, '☆名古屋ＡＢＣ（名古屋）', 'yutai_kubun', NULL, '1003', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(620, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 44, 'ＪＴＢ関連会社', 'yutai_kubun', NULL, '1000', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(621, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 50, '他社からの紹介　　　（無料）', 'yutai_kubun', NULL, '1000', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(622, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 51, '他社からの紹介　　　　（半額）', 'yutai_kubun', NULL, '1000', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(623, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 13, '◆大阪大丸松坂屋友の会（大阪）', 'yutai_kubun', NULL, '1002', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(624, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 14, '◆三宮センター街（大阪）', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(625, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 15, '◆センタープラザ（大阪）', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(626, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 16, '◆阪神みどりの会（大阪）', 'yutai_kubun', NULL, '1002', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(627, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 17, '◆朝日倶楽部（大阪）', 'yutai_kubun', NULL, '1002', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(628, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 18, '◆千里朝日倶楽部（大阪）', 'yutai_kubun', NULL, '1002', NULL, '0.2', '1', NULL, '切捨て', NULL, NULL),
(629, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 19, '◆奈良朝日倶楽部（大阪）', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(630, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 20, '◆京都朝日会館ﾃﾅﾝﾄ懇話会（大阪）', 'yutai_kubun', NULL, '1999', NULL, '0.1', '1', NULL, '切捨て', NULL, NULL),
(631, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 21, '◆大阪府教職員互助組合退職者（大阪）', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(632, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 1, 'Ｊ－Ｂasket　　　　　　', 'yutai_kubun', NULL, '1000', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(633, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 23, 'みずほﾌﾟﾚﾐｱﾑｸﾗﾌﾞ家族友人番号無', 'yutai_kubun', NULL, '1000', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(634, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 25, '■井筒屋（西部）', 'yutai_kubun', NULL, '1004', NULL, '0.6', '1', NULL, '切捨て', NULL, NULL),
(635, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 31, '×■博多大丸カード（西部）10.10変更', 'yutai_kubun', NULL, '1999', NULL, '0.6', '1', NULL, '切捨て', NULL, NULL),
(636, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 27, '■エムアイ友の会（西部）10年10月変更', 'yutai_kubun', NULL, '1004', NULL, '0.6', '1', NULL, '切捨て', NULL, NULL),
(637, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 28, '×■ＪＣＢｺﾞｰﾙﾄﾞｶｰﾄﾞ（西部）', 'yutai_kubun', NULL, '1999', NULL, '0.6', '1', NULL, '切捨て', NULL, NULL),
(638, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 29, '■大和リゾート（西部）', 'yutai_kubun', NULL, '1004', NULL, '0.6', '1', NULL, '切捨て', NULL, NULL),
(639, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 30, '×■九州日本信販（西部）', 'yutai_kubun', NULL, '1999', NULL, '0.2', '1', NULL, '切捨て', NULL, NULL),
(640, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 31, '西部日本信販（西部）', 'yutai_kubun', NULL, '1000', NULL, '0.2', '1', NULL, '切捨て', NULL, NULL),
(641, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 32, '×■小町倶楽部（西部）', 'yutai_kubun', NULL, '1999', NULL, '0.2', '1', NULL, '切捨て', NULL, NULL),
(642, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 33, '■ＪＲ九州一般（西部）', 'yutai_kubun', NULL, '1004', NULL, '0.6', '1', NULL, '切捨て', NULL, NULL),
(643, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 35, '■福岡県教職員互助会（西部）', 'yutai_kubun', NULL, '1004', NULL, '0.6', '1', NULL, '切捨て', NULL, NULL),
(644, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 36, '■全教互九州ブロック協議会（西部）', 'yutai_kubun', NULL, '1004', NULL, '0.6', '1', NULL, '切捨て', NULL, NULL),
(645, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 37, '×■福岡市職員厚生会会員（西部', 'yutai_kubun', NULL, '1999', NULL, '0.6', '1', NULL, '切捨て', NULL, NULL),
(646, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 38, '■福岡県看護協会会員（西部）', 'yutai_kubun', NULL, '1004', NULL, '0.6', '1', NULL, '切捨て', NULL, NULL),
(647, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 39, '■朝日新聞購読（西部）', 'yutai_kubun', NULL, '1004', NULL, '0.6', '1', NULL, '切捨て', NULL, NULL),
(648, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 40, '■福岡朝日ビルテナント（西部）', 'yutai_kubun', NULL, '1004', NULL, '0.6', '1', NULL, '切捨て', NULL, NULL),
(649, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 20, '◆会員紹介（大阪）', 'yutai_kubun', NULL, '1002', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(650, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 22, '◆えらべる倶楽部（梅田のみ）', 'yutai_kubun', NULL, '1002', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(651, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 80, '★JTB旅行会社窓口の紹介', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(652, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 20, '◆再入会（大阪）', 'yutai_kubun', NULL, '1999', NULL, '0.4', '1', NULL, '切捨て', NULL, NULL),
(653, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 4, '◎JTB旅行会社窓口紹介（札幌）', 'yutai_kubun', NULL, '1005', NULL, '0.7', '1', NULL, '切捨て', NULL, NULL),
(654, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 3, '◎大学生（札幌）', 'yutai_kubun', NULL, '1005', NULL, '0.7', '1', NULL, '切捨て', NULL, NULL),
(655, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '★09年9月切れ更新（東京）終了', 'yutai_kubun', NULL, '1999', NULL, NULL, '1', '1575', '切捨て', NULL, NULL),
(656, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 24, '■永久会員■（西部）', 'yutai_kubun', NULL, '1004', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(657, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '×立川日曜講座入会キャンペーン（終了）', 'yutai_kubun', NULL, '1999', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(658, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 4, '◎JTB旅行会社窓口紹介継続更新（札幌）', 'yutai_kubun', NULL, '1005', NULL, NULL, '1', '525', '切捨て', NULL, NULL),
(659, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 24, '■新入会ｷｬﾝﾍﾟｰﾝ2,625円', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(660, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 11, '☆朝日メイト', 'yutai_kubun', NULL, '1003', NULL, '0.6', '1', NULL, '切捨て', NULL, NULL),
(661, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 21, '◆みずほﾌﾟﾚﾐｱﾑｸﾗ（本人）梅田のみ', 'yutai_kubun', NULL, '1999', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(662, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 81, '★かながわ社保ｾﾝﾀｰ', 'yutai_kubun', NULL, '1999', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(663, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 1, '★紹介ｷｬﾝﾍﾟｰﾝ4/30迄', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(664, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 3, '★紹介ｷｬﾝﾍﾟｰﾝ　　 10/31迄', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(665, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 3, '★日経新聞ｵﾘｺﾐ  3/31迄（新宿）', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(666, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 10, '★ASA販売店紹介 　11/9/30迄', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(667, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 13, '◆紹介ｷｬﾝﾍﾟｰﾝ’ 11年3/31迄', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(668, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 11, '☆新入会キャンペーン', 'yutai_kubun', NULL, '1003', NULL, '0.6', '1', NULL, '切捨て', NULL, NULL),
(669, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 13, '◆ASA販売店紹介’11年3/31迄', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(670, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 13, '◆JTB旅物語より 10年5/25迄', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(671, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 4, '◎紹介ｷｬﾝﾍﾟｰﾝ　　4/30迄', 'yutai_kubun', NULL, '1005', NULL, '0.7', '1', NULL, '切捨て', NULL, NULL),
(672, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 4, '◎ASA販売店紹介　6/30迄', 'yutai_kubun', NULL, '1005', NULL, '0.7', '1', NULL, '切捨て', NULL, NULL),
(673, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 5, '★立川オリコミ', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(674, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 11, '☆ASA販売店', 'yutai_kubun', NULL, '1003', NULL, '0.6', '1', NULL, '切捨て', NULL, NULL),
(675, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 24, '■新入会ﾝｷｬﾝﾍﾟｰﾝ1,050円 ', 'yutai_kubun', NULL, '1999', NULL, '0.8', '1', NULL, '切捨て', NULL, NULL),
(676, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 13, '◆近鉄文化ｻﾛﾝ 　10年6/30迄', 'yutai_kubun', NULL, '1999', NULL, '0.8', '1', NULL, '切捨て', NULL, NULL),
(677, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 10, '★湘南リビング　　11/9/30迄', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(678, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 3, 'ｾｿﾞﾝｶｰﾄﾞ会員3/20～4/30迄', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(679, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 11, '☆jtb栄店', 'yutai_kubun', NULL, '1003', NULL, '0.6', '1', NULL, '切捨て', NULL, NULL),
(690, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 23, '■一般（西部）', 'yutai_kubun', NULL, '1004', NULL, '0.2', '1', NULL, '切捨て', NULL, NULL),
(691, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 23, '■大学生（西部）', 'yutai_kubun', NULL, '1004', NULL, '0.6', '1', NULL, '切捨て', NULL, NULL),
(692, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 13, '◆グンゼ会員より10年6/30迄', 'yutai_kubun', NULL, '1999', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(693, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 3, '★メトロガイド　 　8/31迄', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(694, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 5, '★オリオンチラシ（立川）', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(695, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 5, '★立川ポスティング', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(696, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 3, '★朝日旅行紹介　 　9/30迄', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(697, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 0, '◆芦屋ﾗﾎﾟﾙﾃ従業員（大阪）', 'yutai_kubun', NULL, '1002', NULL, '0.2', '1', NULL, '切捨て', NULL, NULL),
(698, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 21, '◆芦屋ﾗﾎﾟﾙﾃ従業員（大阪）', 'yutai_kubun', NULL, '1002', NULL, '0.2', '1', NULL, '切捨て', NULL, NULL),
(699, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 3, '★ｵﾔﾉｺﾄ.ｴｷｽﾎﾟ　10/7/31', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(700, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 21, '◆駅ナビ優待 11年1月末迄', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(701, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 1, '★新入会ｷｬﾝﾍﾟｰﾝ　10/31迄', 'yutai_kubun', NULL, '1999', NULL, '0', '1', NULL, '切捨て', NULL, NULL),
(702, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 3, '★お友だち紹介ｷｬﾝﾍﾟｰﾝ', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(703, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 1, '★ﾄﾗｲｱﾙ・体験受講', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(704, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 3, '★公開講座受講者ｷｬﾝﾍﾟｰﾝ', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(705, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 3, '★セラ・サービス　', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(706, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 3, '★講師紹介ｷｬﾝﾍﾟｰﾝ 10/31迄', 'yutai_kubun', NULL, '1999', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(707, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '★定年時代広告ｷｬﾝﾍﾟｰﾝ10/30', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(708, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 200, '★横浜市区報ｷｬﾝﾍﾟｰﾝ10/30', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL);
INSERT INTO `master_kanri` (`id`, `deleted`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `inactive`, `display_order`, `master_name`, `master_group`, `school_id`, `master_category1`, `master_category2`, `field1`, `field2`, `field3`, `field4`, `field5`, `field6`) VALUES
(709, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 4, '★ハマエコカード　', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(710, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 3, '★朝日新聞ｵﾘｺﾐ　　10/10迄', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(711, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 5, '★住友不動産Ｍ　', 'yutai_kubun', NULL, '1001', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(712, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 22, '◆体験より入会(大阪)', 'yutai_kubun', NULL, '1002', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(713, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 22, '◆非会員受講より入会(大阪)', 'yutai_kubun', NULL, '1002', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(714, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 3, '★湘南ASA販売店紹介10/30迄', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(715, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 3, '★湘南めざましﾀｲﾑ　10/30迄', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(716, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 3, '★湘南ふれあい朝日　10/30迄', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(717, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 22, '◆朝日ﾋﾞﾙﾃﾅﾝﾄ従業員(中之島)  ', 'yutai_kubun', NULL, '1002', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(718, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 22, '◆新ｻﾝｹｲﾋﾞﾙﾃﾅﾝﾄ従業員(梅田)', 'yutai_kubun', NULL, '1002', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(719, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 22, '◆くじゃくサロン', 'yutai_kubun', NULL, '1002', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(720, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 4, '★相鉄カード', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(721, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 3, '★ﾄﾘﾌﾟﾙｷｬﾝﾍﾟｰﾝ', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(722, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 1, '★3回講座受講ｷｬﾝﾍﾟｰﾝ1/31迄', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(723, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 1, '★会員紹介　　　1/31迄', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(724, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 3, '★工学院・朝日ｶﾚｯｼﾞ6/30迄', 'yutai_kubun', NULL, '1999', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(725, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 4, '★ｶﾙﾁｬｰ遊日受講者入会ｷｬﾝﾍﾟｰﾝ', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(726, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 0, '◆読売文化センター梅田’23年6月迄', 'yutai_kubun', NULL, '1002', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(727, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 22, '◆読売文化センター梅田’23年6月迄', 'yutai_kubun', NULL, '1002', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(728, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 26, '■博多阪急カード（西部）', 'yutai_kubun', NULL, '1004', NULL, '0.6', '1', NULL, '切捨て', NULL, NULL),
(729, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 3, '★複数講座ｷｬﾝﾍﾟｰﾝ（横浜・湘南）', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(730, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 4, '★京急カード　横浜・湘南', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(731, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 1, 'ｱｽﾊﾟﾗﾌﾟﾚﾐｱﾑ　9/30迄', 'yutai_kubun', NULL, '1999', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(732, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 1, 'ｱｽﾊﾟﾗﾌﾟﾚﾐｱﾑ', 'yutai_kubun', NULL, '1000', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(733, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 10, '★GOGO TOWN（横浜）', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(734, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 10, '★東急不動産シニア（横浜）', 'yutai_kubun', NULL, '1001', NULL, '0', '1', NULL, '切捨て', NULL, NULL),
(735, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 45, 'ＡＣＣ・ＪＴＢ社員の親族', 'yutai_kubun', NULL, '1000', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(736, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 9, '★横浜物語（横浜）11/9/30迄', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(737, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 45, 'ＡＣＣ・ＪＴＢパート', 'yutai_kubun', NULL, '1000', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(738, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 0, '★入会半額ｷｬﾝﾍﾟｰﾝ12/22迄', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(739, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 0, '★会員のご紹介', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(740, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 1, '★湘南リビング　9/30迄', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(741, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 8, '★ASA横浜折込 10/31迄', 'yutai_kubun', NULL, '1999', NULL, '0.8', '1', NULL, '切捨て', NULL, NULL),
(742, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 11, '☆新入会キャンペーン（無料）', 'yutai_kubun', NULL, '1003', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(743, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 12, '☆Honda Cars愛知モバイル会員', 'yutai_kubun', NULL, '1003', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(744, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 0, '◆講師紹介(期間限定）12/1末迄', 'yutai_kubun', NULL, '1002', NULL, '0.8', '1', NULL, '切捨て', NULL, NULL),
(745, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 13, '◆講師紹介（期間限定）12年1/31まで', 'yutai_kubun', NULL, '1999', NULL, '0.8', '1', NULL, '切捨て', NULL, NULL),
(746, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 8, '★ASA横浜折込　7/31迄', 'yutai_kubun', NULL, '1999', NULL, '0.8', '1', NULL, '切捨て', NULL, NULL),
(747, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 22, '◆楽々キャンパス(12年3/8迄）', 'yutai_kubun', NULL, '1002', NULL, NULL, '1', '4250', '切捨て', NULL, NULL),
(748, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 9, '★横浜美術館6／30迄', 'yutai_kubun', NULL, '1999', NULL, '0.8', '1', NULL, '切捨て', NULL, NULL),
(749, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 5, '★住友不動産Ｔ', 'yutai_kubun', NULL, '1001', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(750, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 24, '■65歳以上ｷｬﾝﾍﾟｰﾝ（西部）', 'yutai_kubun', NULL, '1999', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(751, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 5, '★ASA湘南折込　3/5から', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(752, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 5, '★てんとう虫　5/31迄', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(753, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 8, '★ASA横浜折込　4/28迄', 'yutai_kubun', NULL, '1999', NULL, '0.8', '1', NULL, '切捨て', NULL, NULL),
(754, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 5, '★社員紹介', 'yutai_kubun', NULL, '1001', NULL, NULL, '1', '4200', '切捨て', NULL, NULL),
(755, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 4, '★ユザワヤ　5/31まで', 'yutai_kubun', NULL, '1999', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(756, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 4, '★ｼｮｰﾄｼｱﾀｰ（横浜）9/30迄', 'yutai_kubun', NULL, '1001', NULL, '0.8', '1', NULL, '切捨て', NULL, NULL),
(757, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 5, '★藤沢タウンガイド（HAPPY)', 'yutai_kubun', NULL, '1001', NULL, '0.5', '1', NULL, '切捨て', NULL, NULL),
(758, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 8, '★有隣堂封入　10/31迄', 'yutai_kubun', NULL, '1999', NULL, '0.8', '1', NULL, '切捨て', NULL, NULL),
(759, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 1, 'ぷろむなぁど　2013/3/31迄', 'yutai_kubun', NULL, '1000', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(760, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 2, '★JTBクルーズ　2013/3/31迄', 'yutai_kubun', NULL, '1001', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(761, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 8, '★ASA横浜折込　1/31迄', 'yutai_kubun', NULL, '1001', NULL, '0.8', '1', NULL, '切捨て', NULL, NULL),
(762, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 22, '◆中之島移転ｷｬﾝﾍﾟｰﾝ（おひろめ会）', 'yutai_kubun', NULL, '1002', NULL, '1', '1', NULL, '切捨て', NULL, NULL),
(801, 0, '2012-12-05 10:00:00', '2012-12-15 03:46:14', 'a437cc11-564c-e5c4-3ff0-4c88c6961e3b', '1', 0, 1, '新宿', 'nyukaikin', 'sssssss-1111', NULL, NULL, '5250', '1050', '5250', NULL, NULL, NULL),
(803, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 2, '横浜', 'nyukaikin', '49caa19d-9872-3095-6bd4-5001d0aa692d', NULL, NULL, '5250', '1050', '5250', NULL, NULL, NULL),
(805, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 3, '立川', 'nyukaikin', 'a32c39d6-45da-a750-6e4d-5001d0bd7a8d', NULL, NULL, '5250', '1050', '5250', NULL, NULL, NULL),
(806, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 4, '湘南', 'nyukaikin', 'b0845182-f1bc-145f-0560-5001d0cbee2a', NULL, NULL, '5250', '1050', '5250', NULL, NULL, NULL),
(817, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 5, '札幌', 'nyukaikin', '28e74451-24cc-c806-9642-5001d0f926d9', NULL, NULL, '5250', '1050', '5250', NULL, NULL, NULL),
(820, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 6, '中之島', 'nyukaikin', 'c083c4e8-6f1d-24ea-fd47-5001d0b9910f', NULL, NULL, '5250', '1050', '5250', NULL, NULL, NULL),
(822, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 7, '川西', 'nyukaikin', '5ea7a466-203e-45f4-582c-5001d12b64db', NULL, NULL, '5250', '1050', '5250', NULL, NULL, NULL),
(824, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 8, '芦屋', 'nyukaikin', '5bc40075-3911-d52a-a0f8-5001d15a06e5', NULL, NULL, '5250', '1050', '5250', NULL, NULL, NULL),
(828, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 9, '京都', 'nyukaikin', 'c387f0ac-5700-6490-3264-5001d1127ee7', NULL, NULL, '5250', '1050', '5250', NULL, NULL, NULL),
(829, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 10, '梅田', 'nyukaikin', 'bb0d4d73-13a4-b000-36a6-5001d0094cb6', NULL, NULL, '5250', '1050', '5250', NULL, NULL, NULL),
(836, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 11, '北九州', 'nyukaikin', '1ca1eb40-372a-27a2-bf44-5001d1ad9d91', NULL, NULL, '5250', '1050', '5250', NULL, NULL, NULL),
(837, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 12, '福岡', 'nyukaikin', 'a312c57a-0e45-6f65-0402-5001d1e84f1d', NULL, NULL, '5250', '1050', '5250', NULL, NULL, NULL),
(845, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 13, '名古屋', 'nyukaikin', 'e86510a2-302b-7c34-250d-5001d1fc1b41', NULL, NULL, '5250', '1050', '5250', NULL, NULL, NULL),
(899, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 14, 'test campus', 'nyukaikin', '687ec71c-1c7d-6c97-fc2a-4c889fc5d652', NULL, NULL, '5250', '1050', '5250', NULL, NULL, NULL),
(1000, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 0, '共通', 'yutai_kubun_group', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1001, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 0, '東京', 'yutai_kubun_group', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1002, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 0, '大阪', 'yutai_kubun_group', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1003, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 0, '名古屋', 'yutai_kubun_group', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1004, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 0, '西部', 'yutai_kubun_group', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1005, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 0, '札幌', 'yutai_kubun_group', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1999, 0, '2012-12-05 10:00:00', '2012-12-05 10:00:00', '1', '1', 0, 0, '非表示', 'yutai_kubun_group', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2000, 0, '2012-12-09 13:06:41', '2012-12-11 20:41:41', 'a437cc11-564c-e5c4-3ff0-4c88c6961e3b', 'a437cc11-564c-e5c4-3ff0-4c88c6961e3b', 0, 1, 'テスト媒体', 'ninchi_baitai', NULL, '70', NULL, '19', NULL, NULL, NULL, NULL, NULL),
(2009, 0, '2012-12-13 18:34:12', '2012-12-13 18:34:12', 'a437cc11-564c-e5c4-3ff0-4c88c6961e3b', 'a437cc11-564c-e5c4-3ff0-4c88c6961e3b', 0, NULL, '新聞報告　テスト１', 'ninchi_baitai', NULL, '71', NULL, '3', NULL, NULL, NULL, NULL, NULL),
(2010, 0, '2012-12-13 18:34:29', '2012-12-13 18:34:29', 'a437cc11-564c-e5c4-3ff0-4c88c6961e3b', 'a437cc11-564c-e5c4-3ff0-4c88c6961e3b', 0, NULL, 'チラシ　テスト１', 'ninchi_baitai', NULL, '72', NULL, '11', NULL, NULL, NULL, NULL, NULL),
(2011, 0, '2012-12-13 18:34:42', '2012-12-13 18:34:42', 'a437cc11-564c-e5c4-3ff0-4c88c6961e3b', 'a437cc11-564c-e5c4-3ff0-4c88c6961e3b', 0, NULL, '折込　テスト１', 'ninchi_baitai', NULL, '73', NULL, '1', NULL, NULL, NULL, NULL, NULL),
(2012, 0, '2012-12-13 19:36:41', '2012-12-13 19:36:41', 'a437cc11-564c-e5c4-3ff0-4c88c6961e3b', 'a437cc11-564c-e5c4-3ff0-4c88c6961e3b', 0, NULL, '新聞　テスト２', 'ninchi_baitai', NULL, '70', NULL, '3', NULL, NULL, NULL, NULL, NULL),
(2013, 0, '2012-12-13 19:36:57', '2012-12-13 19:36:57', 'a437cc11-564c-e5c4-3ff0-4c88c6961e3b', 'a437cc11-564c-e5c4-3ff0-4c88c6961e3b', 0, NULL, 'オリコミ　テスト２', 'ninchi_baitai', NULL, '73', NULL, '3', NULL, NULL, NULL, NULL, NULL),
(2014, 0, '2013-01-04 23:15:50', '2013-01-05 01:11:17', 'a437cc11-564c-e5c4-3ff0-4c88c6961e3b', 'a437cc11-564c-e5c4-3ff0-4c88c6961e3b', 0, NULL, '法人', 'koushi_zeikubun', NULL, NULL, NULL, '法人', '１円未満', '切捨て', '0', '１円未満', '切捨て'),
(2015, 0, '2013-01-05 01:12:25', '2013-01-05 01:12:25', 'a437cc11-564c-e5c4-3ff0-4c88c6961e3b', 'a437cc11-564c-e5c4-3ff0-4c88c6961e3b', 0, NULL, '法人（士）', 'koushi_zeikubun', NULL, NULL, NULL, '法人（士）', '１円未満', '切捨て', '0', '１円未満', '切捨て'),
(2016, 0, '2013-01-05 01:12:56', '2013-01-05 01:12:56', 'a437cc11-564c-e5c4-3ff0-4c88c6961e3b', 'a437cc11-564c-e5c4-3ff0-4c88c6961e3b', 0, NULL, '個人', 'koushi_zeikubun', NULL, NULL, NULL, '課税講師', '１円未満', '切捨て', '0.1', '１円未満', '切捨て'),
(2017, 0, '2013-01-05 01:13:19', '2013-01-05 01:13:19', 'a437cc11-564c-e5c4-3ff0-4c88c6961e3b', 'a437cc11-564c-e5c4-3ff0-4c88c6961e3b', 0, NULL, '個人（士）', 'koushi_zeikubun', NULL, NULL, NULL, '弁護士・弁理', '１円未満', '切捨て', '0.1', '１円未満', '切捨て'),
(2018, 0, '2013-01-05 01:13:44', '2013-01-05 01:13:44', 'a437cc11-564c-e5c4-3ff0-4c88c6961e3b', 'a437cc11-564c-e5c4-3ff0-4c88c6961e3b', 0, NULL, '個人（非）', 'koushi_zeikubun', NULL, NULL, NULL, '個人（非）', '１円未満', '切捨て', '0.2', '１円未満', '切捨て'),
(2019, 0, '2013-01-05 01:13:51', '2013-01-05 01:13:51', 'a437cc11-564c-e5c4-3ff0-4c88c6961e3b', 'a437cc11-564c-e5c4-3ff0-4c88c6961e3b', 0, NULL, '個人（丙）', 'koushi_zeikubun', NULL, NULL, NULL, '個人（丙）', '１円未満', '切捨て', '0', '１円未満', '切捨て'),
(2020, 0, '2013-01-09 16:42:35', '2013-01-09 16:58:17', '1', '1', 0, NULL, 'ﾃｸﾉﾋﾟｱﾝ', 'yutai_kubun', NULL, '1005', NULL, '0.5', '1', NULL, '切捨て', '0', NULL),
(2121, 0, '2013-01-19 02:09:11', '2013-01-19 02:09:11', '1', '1', 0, 1, '手数料', 'reigai_shori_group', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2122, 0, '2013-01-19 02:11:28', '2013-01-19 02:11:28', '1', '1', 0, 2, '過剰金', 'reigai_shori_group', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2123, 0, '2013-01-19 02:11:43', '2013-01-19 02:11:43', '1', '1', 0, 3, '謝礼', 'reigai_shori_group', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2124, 0, '2013-01-19 02:12:05', '2013-01-19 02:12:05', '1', '1', 0, 4, '前払い', 'reigai_shori_group', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2125, 0, '2013-01-19 02:13:48', '2013-01-19 02:13:48', '1', '1', 0, 1, '手数料100', 'reigai_shori', NULL, '2121', NULL, '100', NULL, NULL, NULL, NULL, NULL),
(2126, 0, '2013-01-19 02:14:08', '2013-01-19 02:14:08', '1', '1', 0, 2, '手数料500', 'reigai_shori', NULL, '2121', NULL, '500', NULL, NULL, NULL, NULL, NULL),
(2127, 0, '2013-01-19 02:14:26', '2013-01-19 02:14:26', '1', '1', 0, 3, '手数料1500', 'reigai_shori', NULL, '2121', NULL, '1500', NULL, NULL, NULL, NULL, NULL),
(2128, 0, '2013-01-19 02:23:32', '2013-01-21 04:40:13', '1', '1', 0, 10, '前払い500', 'reigai_shori', NULL, '2124', NULL, '500', NULL, NULL, NULL, NULL, NULL),
(2129, 0, '2013-01-19 02:24:02', '2013-01-21 04:40:32', '1', '1', 0, 11, '前払い1000', 'reigai_shori', NULL, '2124', NULL, '1000', NULL, NULL, NULL, NULL, NULL),
(2130, 0, '2013-01-21 04:38:35', '2013-01-21 04:39:52', '1', '1', 0, 20, '過剰金', 'reigai_shori', NULL, '2122', NULL, '100', NULL, NULL, NULL, NULL, NULL),
(2131, 0, '2013-01-21 04:39:28', '2013-01-21 04:39:28', '1', '1', 0, 30, '謝礼', 'reigai_shori', NULL, '2123', NULL, '1000', NULL, NULL, NULL, NULL, NULL),
(2132, 0, '2013-02-11 23:08:27', '2013-02-11 23:08:27', '1', '1', 0, 4, '手数料-100', 'reigai_shori', NULL, '2121', NULL, '-100', NULL, NULL, NULL, NULL, NULL),
(2135, 0, '2013-01-25 10:13:16', '2013-02-11 23:36:57', '1', '1', 0, 12, '大分類1', 'reigai_shori_group', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2138, 0, '2013-01-25 10:14:33', '2013-02-11 23:25:56', '1', '1', 0, 12, '手数料戻し', 'reigai_shori', NULL, '2135', NULL, '-500', NULL, NULL, NULL, NULL, NULL),
(2139, 0, '2013-02-17 01:49:42', '2013-02-17 01:49:42', '1', '1', 0, NULL, NULL, 'moderuzei', NULL, NULL, NULL, '0', '9299', '0', NULL, NULL, NULL),
(2140, 0, '2013-02-17 01:50:27', '2013-02-17 01:50:27', '1', '1', 0, NULL, NULL, 'moderuzei', NULL, NULL, NULL, '9300', '9399', '3', NULL, NULL, NULL),
(2141, 0, '2013-02-17 01:50:27', '2013-02-17 01:50:27', '1', '1', 0, NULL, NULL, 'moderuzei', NULL, NULL, NULL, '9400', '9499', '6', NULL, NULL, NULL),
(2142, 0, '2013-02-17 01:50:27', '2013-02-17 01:50:27', '1', '1', 0, NULL, NULL, 'moderuzei', NULL, NULL, NULL, '9500', '9599', '10', NULL, NULL, NULL),
(2143, 0, '2013-02-17 01:50:27', '2013-02-17 01:50:27', '1', '1', 0, NULL, NULL, 'moderuzei', NULL, NULL, NULL, '9600', '9699', '13', NULL, NULL, NULL),
(2144, 0, '2013-02-17 01:50:27', '2013-02-17 01:50:27', '1', '1', 0, NULL, NULL, 'moderuzei', NULL, NULL, NULL, '9700', '9799', '17', NULL, NULL, NULL),
(2145, 0, '2013-02-17 01:50:27', '2013-02-17 01:50:27', '1', '1', 0, NULL, NULL, 'moderuzei', NULL, NULL, NULL, '9800', '9899', '20', NULL, NULL, NULL),
(2146, 0, '2013-02-17 01:50:27', '2013-02-17 01:50:27', '1', '1', 0, NULL, NULL, 'moderuzei', NULL, NULL, NULL, '9900', '9999', '24', NULL, NULL, NULL),
(2147, 0, '2013-02-17 01:50:27', '2013-02-17 01:50:27', '1', '1', 0, NULL, NULL, 'moderuzei', NULL, NULL, NULL, '10000', '10099', '27', NULL, NULL, NULL),
(2148, 0, '2013-02-17 01:50:27', '2013-02-17 01:50:27', '1', '1', 0, NULL, NULL, 'moderuzei', NULL, NULL, NULL, '10100', '10199', '31', NULL, NULL, NULL),
(2149, 0, '2013-02-17 01:50:27', '2013-02-17 01:50:27', '1', '1', 0, NULL, NULL, 'moderuzei', NULL, NULL, NULL, '10200', '10299', '34', NULL, NULL, NULL),
(2150, 0, '2013-02-17 01:50:27', '2013-02-17 01:50:27', '1', '1', 0, NULL, NULL, 'moderuzei', NULL, NULL, NULL, '10300', '10399', '38', NULL, NULL, NULL),
(2151, 0, '2013-02-17 01:50:27', '2013-02-17 01:50:27', '1', '1', 0, NULL, NULL, 'moderuzei', NULL, NULL, NULL, '10400', '10499', '41', NULL, NULL, NULL),
(2152, 0, '2013-02-17 01:50:27', '2013-02-17 01:50:27', '1', '1', 0, NULL, NULL, 'moderuzei', NULL, NULL, NULL, '10500', '10599', '45', NULL, NULL, NULL),
(2153, 0, '2013-02-17 02:36:18', '2013-02-17 02:36:18', '1', '1', 0, 1, '教養', 'pamp_janru_dai', 'sssssss-1111', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2154, 0, '2013-02-17 02:37:11', '2013-02-17 02:37:11', '1', '1', 0, 2, '社会参加', 'pamp_janru_dai', 'sssssss-1111', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2155, 0, '2013-02-17 02:37:29', '2013-02-17 02:37:29', '1', '1', 0, 3, '外国語', 'pamp_janru_dai', 'sssssss-1111', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2156, 0, '2013-02-17 02:37:39', '2013-02-17 02:37:39', '1', '1', 0, 4, '日本語', 'pamp_janru_dai', 'sssssss-1111', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2157, 0, '2013-02-17 02:38:04', '2013-02-17 02:38:04', '1', '1', 0, 1, '社会', 'pamp_janru_chu', NULL, '2153', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2158, 0, '2013-02-17 02:38:51', '2013-02-17 02:38:51', '1', '1', 0, 2, '思想', 'pamp_janru_chu', NULL, '2153', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2159, 0, '2013-02-17 02:39:05', '2013-02-17 02:39:05', '1', '1', 0, 3, '宗教', 'pamp_janru_chu', NULL, '2153', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2160, 0, '2013-02-17 02:54:04', '2013-02-17 02:54:04', '1', '1', 0, 1, '現代社会', 'pamp_janru', NULL, '2157', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2161, 0, '2013-02-17 02:54:46', '2013-02-17 02:54:46', '1', '1', 0, 2, '文化の深層', 'pamp_janru', NULL, '2157', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2162, 0, '2013-02-17 02:55:03', '2013-02-17 02:55:03', '1', '1', 0, 3, 'ライフスタイル・ビジネス', 'pamp_janru', NULL, '2157', NULL, NULL, NULL, NULL, NULL, NULL, NULL);