CREATE TABLE `bd_car_cntr` (
  `SaleId` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `CarId` varchar(8) NOT NULL,
  `CntrNo` varchar(20) NOT NULL,
  `CntrDat` varchar(10) NOT NULL,
  `CntrNam` varchar(100) NOT NULL,
  `IdNo` varchar(10) NOT NULL,
  `LicNo` varchar(10) NOT NULL,
  `CntrCity` varchar(20) NOT NULL,
  `CntrAdr` varchar(100) NOT NULL,
  `CntrTel` varchar(20) NOT NULL,
  `UseNam` varchar(100) NOT NULL,
  `UseTel` varchar(20) NOT NULL,
  `UseCell` varchar(20) NOT NULL,
  `UseAdr` varchar(100) NOT NULL,
  `CntrMile` varchar(10) NOT NULL,
  `Payment` varchar(10) DEFAULT NULL,
  `LeaseCo` varchar(100) NOT NULL,
  `LoanCo` varchar(100) NOT NULL,
  `SaleDep` varchar(20) NOT NULL,
  `SaleMan` varchar(10) NOT NULL,
  `EstDelDat` varchar(10) NOT NULL,
  `CntrMemo` varchar(50) NOT NULL,
  `CntrAmt` bigint(10) unsigned NOT NULL,
  `CommAmt` bigint(10) DEFAULT NULL,
  `FinalDat` varchar(10) NOT NULL,
  `FinalUser` varchar(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`SaleId`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;


INSERT INTO `bd_car_cntr` VALUES (1, '9', '1', '102.07.23', '詹照', 'A210599553', '', '新北市汐止區', '長青路210巷63號', '', '', '', '0963018986', '', '', '現金', '', '', '', '吳大維', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (2, '23', '2', '102.07.19', '李宗勳', 'E122850232', '', '高雄市新興區', '仁愛路一街67號', '', '', '', '0989050111', '', '', '現金', '', '', '', '黃聖舜', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (3, '15', '3', '102.07.18', '高婉潔', ' A22692429', '', '台北市中正區', '羅斯福路6段70號', '', '', '', '0955599155', '', '', '現金', '', '', '', '吳大維', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (4, '41', '4', '102.07.24', '高坤維', 'Y100598710', '', '台北市北投區', '中央路四段316巷40號', '', '', '', '', '', '', '現金', '', '', '', '林韋呈', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (5, '11', '5', '102.07.24', '周永勝', 'A110199999', '', '台北市內湖區', '大湖山莊路63巷19號', '', '', '', '', '', '', '現金', '', '', '', '林韋呈', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (6, '32', '6', '102.07.25', '上裕交通股份有限公司', '', '84217257', '台中市東勢區', '豐勢路125號', '', '', '', '', '', '', '現金', '', '', '', '吳大維', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (7, '29', '8', '102.07.14', '張秀美', 'Q220891950', '', '苗栗縣頭份鎮', '蟠桃里上庄路58號3F', '54337826', '', '', '', '', '', '現金', '', '', '', '吳大維', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (8, '21', '9', '102.07.26', '王美娟', 'K122153555', '', '台中市西屯區', '文心路三段508號', '', '', '', '', '', '', '現金', '', '', '', '吳大維', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (9, '33', '10', '102.07.26', '上裕交通股份有限公司', '', '84217257', '台中市東勢區', '豐勢路125號', '', '', '', '', '', '', '現金', '', '', '', '林韋呈', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (10, '24', '11', '102.08.01', '方榮熙', '', '', '台北市中正區', '', '', '', '', '0930090472', '', '', '現金', '', '', '', '林韋呈', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (11, '38', '12', '102.08.01', '李智賢', 'A122352620', '', '新北市林口區', '東湖路76巷7號', '', '', '', '', '', '', '現金', '', '', '', '林韋呈', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (12, '5', '13', '102.08.05', '房芯佑', 'F225466048', '', '台北市中正區', '', '', '', '', '0931096290', '', '', '現金', '', '', '', '黃聖舜', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (13, '17', '14', '102.08.05', '林濬緯', '', '', '台北市中正區', '重慶南路二段51號13F', '', '', '', '0938938735', '', '', '現金', '', '', '', '林韋呈', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (14, '13', '15', '102.08.06', '楊育琌', 'R221932282', '', '台北市中正區', '', '', '', '', '0929113300', '', '', '現金', '', '', '', '林韋呈', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (15, '6', '16', '102.08.01', '涂淑媛', 'E223840625', '', '新北市汐止區', '樟樹一路151巷10號7樓', '', '', '', '0933032089', '', '', '現金', '', '', '', '林韋呈', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (16, '7', '17', '102.08.08', '吳元豪', 'R122803751', '', '新北市林口區', '文化三路一段555巷8號5樓', '', '', '', '0925328739', '', '', '現金', '', '', '', '駱健基', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (17, '16', '18', '102.07.31', '日盛全通小客車租賃', '', '70579068', '台北市中山區', '新生北路二段120號一樓', '', '', '', '', '', '', '現金', '', '', '', '黃聖舜', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (18, '30', '20', '102.08.22', '上和建材養護材料有限公司', '', '97311661', '新北市汐止區', '大安街52巷12號3樓', '', '', '', '', '', '', '現金', '', '', '', '吳大維', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (19, '44', '21', '102.08.20', '聯邦國際租賃(股)公司', 'A128995576', '', '新北市八里區', '仁一街8號', '(02)26102075', '', '', '', '', '', '現金', '', '', '', '駱健基', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (20, '28', '22', '102.08.27', '焦文娟', '', '', '台北市萬華區', '洛陽街55號3樓之一', '', '', '', '', '', '', '現金', '', '', '', '林韋呈', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (21, '36', '23', '102.08.14', '遠銀國際租賃股份有限公司', '', '', '台北市松山區', '南京東路5段108號5樓', '(02)2745-5038', '', '', '', '', '', '現金', '', '', '', '黃聖舜', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (22, '8', '24', '102.08.14', '林怡亨', 'F220098282', '', '台北市中山區', '北安路767巷19號2樓', '', '', '', '0958-833899', '', '', '現金', '', '', '', '黃聖舜', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (23, '34', '25', '102.08.29', '台壽保資融(股)有限公司', '', '', '台中市北屯區', '東山路一段140巷6號', '0932-575090', '', '', '', '', '', '現金', '', '', '', '黃聖舜', '', '', 0, 8, '', '0');
INSERT INTO `bd_car_cntr` VALUES (24, '40', '28', '102.09.01', '陳浩瑋', 'A129667366', '', '台北市南港區', '園區街48號5樓之三', '', '', '', '0953-895973', '', '', '現金', '', '', '', '林韋呈', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (25, '39', '29', '102.09.03', '楊銘洲', 'F124553979', '', '台北市中正區', '', '', '', '', '', '', '', '現金', '', '', '', '吳大維', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (26, '22', '31', '102.09.07', '江曉茜', '', '', '台北市信義區', '敦化南路二段63巷57號', '', '', '', '0958354286', '', '', '現金', '', '', '', '林韋呈', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (27, '18', '32', '102.09.09', '廖唯倫', 'C120388320', '', '新竹市東區科', '園里26鄰湖濱二路27號2樓', '', '', '', '', '', '', '現金', '', '', '', '林韋呈', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (28, '19', '33', '102.09.13', '簡鴻翔', 'A122187687', '', '新北市蘆洲區', '光榮路97巷19號3F', '', '', '', '', '', '', '現金', '', '', '', '吳大維', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (29, '27', '34', '102.09.13', '張漢平', 'K101305308', '', '苗栗縣公館鄉', '大坑村大坑109號', '', '', '', '', '', '', '現金', '', '', '', '吳大維', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (30, '31', '35', '102.09.16', '聯邦國際租賃(股)有限公司', '', '97169587', '台北市中正區', '', '', '', '', '', '', '', '現金', '聯邦國際租賃(股)有限公司', '', '', '林韋呈', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (31, '20', '36', '102.10.01', '永鑫能源(股)公司', '', '53911029', '台北市士林區', '德行西路25號5F', '', '', '', '0932-216224', '', '', '現金', '', '', '', '吳大維', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (32, '37', '40', '102.10.07', '官麗雪', 'H221462671', '', '桃園縣平鎮市', '龍南路47號', '', '', '', '0972-208171', '', '', '現金', '', '', '', '林韋呈', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (33, '10', '41', '102.10.03', '聯邦國際租賃(股)公司', '', '', '新北市汐止區', '茄苳路208-1號1F', '', '', '', '0936-709959', '', '', '現金', '', '', '', '駱健基', '', '', 0, 0, '', '0');
INSERT INTO `bd_car_cntr` VALUES (34, '26', '43', '102.10.08', '洪華山', 'N122462882', '', '彰化縣芳苑鄉', '仁愛村9鄰芳頂路山號', '', '', '', '0939-083888', '', '', '現金', '', '', '', '吳大維', '', '', 0, 0, '', '0');

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


CREATE TABLE `bd_car_deco` (
  `CarId` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
  `SerNo` tinyint(3) unsigned NOT NULL,
  `Dat` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `DecoNo` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `Des` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `Amt` decimal(10,2) DEFAULT '0.00',
  `Memo` varchar(100) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



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


CREATE TABLE `bd_car_finan` (
  `FinaCat` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `SrcId` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
  `SerNo` tinyint(3) unsigned NOT NULL,
  `Dat` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `Subject` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `Des` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `Amt` bigint(12) DEFAULT '0',
  `AmtTax` bigint(12) DEFAULT '0',
  `InvNo` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `Memo` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `PrtFlag` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



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


CREATE TABLE `bd_car_insur` (
  `InsId` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `CntrNo` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `CntrName` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `CntrId` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `CntrBDat` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `CntrCity` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `CntrAdd` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `CntrTel` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `CntrCell` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `CarModel` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `CarCat` varchar(8) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `CarPdMon` varchar(8) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `CarFrNo` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `CarOpt` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `CarPltDat` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `CarPltNo` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `SaleDep` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `SaleMan` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `SalePay` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `CarLeaCo` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `KeyInMan` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `InsCat` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `InsCo` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `InsCdDat` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `InsCdNo` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `InsNo` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `InsBegDat` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `InsEndDat` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `InsAmt1` bigint(12) DEFAULT NULL,
  `InsAmt2` bigint(12) DEFAULT NULL,
  `InsAmt3` bigint(12) DEFAULT NULL,
  `InsAmt4` bigint(12) DEFAULT NULL,
  `InsAmt5` bigint(12) DEFAULT NULL,
  `InsAmt6` bigint(12) DEFAULT NULL,
  `InsAmt7` bigint(12) DEFAULT NULL,
  `InsAmt8` bigint(12) DEFAULT NULL,
  `InsAmt9` bigint(12) DEFAULT NULL,
  `InsAmt10` bigint(12) DEFAULT NULL,
  `InsDes1` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `InsDes2` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `InsDes3` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `InsDes4` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `InsDes5` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `InsDes6` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `InsDes7` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `InsDes8` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `InsDes9` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `InsDes10` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `InsTotal` bigint(12) NOT NULL,
  `InsMemo` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `PayDat` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `PayMemo` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `AvlFlag` varchar(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
  PRIMARY KEY (`InsId`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;



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


CREATE TABLE `bd_car_pur` (
  `CarId` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `SaleId` varchar(8) NOT NULL,
  `CarAvl` varchar(1) NOT NULL DEFAULT '1',
  `TranCat` varchar(2) NOT NULL,
  `PurNo` varchar(20) NOT NULL,
  `PurDat` varchar(10) NOT NULL,
  `FrNo10` varchar(10) NOT NULL,
  `FrNo7` varchar(7) NOT NULL,
  `CarBrand` varchar(30) NOT NULL,
  `CarModel` varchar(30) NOT NULL,
  `CarColor` varchar(10) NOT NULL,
  `CarOpt` varchar(100) NOT NULL,
  `CarMile` varchar(10) DEFAULT NULL,
  `PrdcMon` varchar(8) NOT NULL,
  `EngNo` varchar(20) NOT NULL,
  `LstPltNo` varchar(20) NOT NULL,
  `InitPltDat` varchar(10) NOT NULL,
  `DocInDat` varchar(10) NOT NULL,
  `PurAmt` bigint(10) unsigned DEFAULT NULL,
  `Supplier` varchar(10) NOT NULL,
  `LstOwnNam` varchar(100) NOT NULL,
  `LstOwnCity` varchar(20) NOT NULL,
  `LstOwnAdr` varchar(100) NOT NULL,
  `LstOwnTel` varchar(50) NOT NULL,
  `CarInDat` varchar(10) NOT NULL,
  `ListAmt` bigint(10) unsigned NOT NULL,
  `Locat` varchar(10) NOT NULL,
  `CarMovMemo` varchar(50) NOT NULL,
  `CarMovDat` varchar(10) NOT NULL,
  `CarInMemo` varchar(50) DEFAULT NULL,
  `PlateDat` varchar(10) NOT NULL,
  `PlateNo` varchar(20) NOT NULL,
  `DeliDat` varchar(10) NOT NULL,
  `DocDeliDat` varchar(10) NOT NULL,
  `PurDelMemo` varchar(50) DEFAULT NULL,
  `PurDelDat` varchar(10) NOT NULL,
  `RsvFlag` varchar(1) NOT NULL DEFAULT '0',
  `RsvMemo` varchar(50) NOT NULL,
  PRIMARY KEY (`CarId`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=latin1 AUTO_INCREMENT=48 ;


INSERT INTO `bd_car_pur` VALUES (1, '', '1', '1', 'T01', '102.11.01', '', 'J675370', 'BMW', '118I F20', '黑色', '', '', '1301', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '', '', '', '', '', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (2, '', '1', '1', 'T02', '102.11.01', '', 'DJ60469', 'BMW', '316I F30', '黑色', '', '', '1302', 'B332J441', '', '', '', 0, '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (3, '', '1', '1', 'T03', '102.11.01', '', 'NR22098', 'BMW', '328I F30', '灰色', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '財盟租賃代步車', '', '', '', '', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (4, '', '1', '1', 'T04', '102.11.01', '', 'NR22099', 'BMW', '328I F30', '黑色', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', 0, '竹圍', '', '', '財盟租賃代步車', '', '', '', '', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (5, '12', '1', '1', 'T05', '102.11.01', '', 'NR22089', 'BMW', '328I F30', '黑色', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '財盟租賃代步車', '102.08.05', 'RAA-1625', '102.08.05', '102.08.05', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (6, '15', '1', '1', 'T06', '102.11.01', '', 'F378074', 'BMW', '320I F30', '紅色', '', '', '1203', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '依德領牌日101.12.10,6408KM', '102.08.08', '9850-T3', '102.08.08', '102.08.08', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (7, '16', '1', '1', 'T07', '102.11.01', '', 'NR09244', 'BMW', '320I F30', '銀色', '', '', '1209', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '鎔德', '102.08.13', 'AAA-9052', '102.08.13', '102.08.13', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (8, '22', '1', '1', 'T08', '102.11.01', '', 'F377944', 'BMW', '320I F30', '銀色', '', '', '2012', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '', '102.08.23', '4419-S2', '102.08.23', '102.08.23', NULL, '', '', '黃聖舜保留');
INSERT INTO `bd_car_pur` VALUES (9, '1', '1', '1', 'T09', '102.11.01', '', 'NN94333', 'BMW', '318D F30', '灰色', '', '', '1209', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '鎔德', '102.07.23', '94333', '102.07.23', '102.07.23', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (10, '33', '1', '1', 'I102100402', '102.11.01', '', 'DZ97032', 'BMW', '520D GT LCI F07', 'A52/灰', '', '', '1303', '', '', '', '', 0, '', '', '', '', '', '', 0, '', '', '', '', '', '已售', '', '', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (11, '5', '1', '1', 'T10', '102.11.01', '', 'DY53269', 'BMW', '520D F10', '灰色', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '財盟租賃代步車', '102.07.24', 'RAA-1653', '102.07.24', '102.07.24', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (12, '', '1', '1', 'T11', '102.11.01', '', 'DY60899', 'BMW', '520D F10', '白色', '', '', '1301', '87518397', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '', '', '', '', '', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (13, '14', '1', '1', 'T12', '102.11.01', '', 'DY53213', 'BMW', '520D F10', '黑色', '403,5DL,710', '', '1209', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '財盟租賃代步車', '102.08.14', 'RAA-1663', '102.08.14', '102.08.14', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (14, '', '1', '1', 'T13', '102.11.01', '', 'VS35103', 'BMW', 'X1 X25D', '深藍色', '', '', '1208', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '', '', '', '', '', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (15, '3', '1', '1', 'T14', '102.11.01', '', 'VR38062', 'BMW', 'X1 S20D', '灰色', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '財盟租賃代步車', '102.07.24', 'RAA-1629', '102.07.24', '102.07.24', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (16, '17', '1', '1', 'T15', '102.11.01', '', 'VR38063', 'BMW', 'X1 S20D', '白色', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '財盟租賃代步車', '102.08.02', 'RAA-1627', '102.08.02', '102.08.02', NULL, '', '', '8/8黃聖舜訂單未取回');
INSERT INTO `bd_car_pur` VALUES (17, '13', '1', '1', 'T16', '102.11.01', '', 'DY83501', 'BMW', '520I F10', '灰色', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', 0, '柏德', '', '', '財盟租賃代步車', '102.08.05', 'RAA-1672', '102.08.05', '102.08.05', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (18, '27', '1', '1', 'T17', '102.11.01', '', 'D172497', 'BMW', '520I F10', '灰色', '', '', '1302', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '', '', 'AAF-8373', '', '', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (19, '28', '1', '1', 'T18', '102.11.01', '', 'DY83812', 'BMW', '520I F10', '灰色', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '財盟租賃代步車', '', 'RAA-1675', '', '', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (20, '31', '1', '1', 'T19', '102.11.01', '', 'DY83788', 'BMW', '520I F10', '黑色', '', '', '', '', '', '', '', 0, '', '', '', '', '', '102.07.24', 0, '鉑德', '', '', '財盟租賃代步車', '', 'RAA-1665', '', '', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (21, '8', '1', '1', 'T20', '102.11.01', '', 'DY84452', 'BMW', '520I F10', '黑色', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '財盟租賃代步車', '102.07.31', 'RAA-1875', '102.07.31', '102.07.31', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (22, '26', '1', '1', 'T21', '102.11.01', '', 'D172989', 'BMW', '520I F10', '黑色', '', '', '1303', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '', '', 'AAA-9381', '', '', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (23, '2', '1', '1', 'T22', '102.11.01', '', 'DY83766', 'BMW', '520I F10', '黑色', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', 0, '竹圍', '', '', '財盟租賃代步車', '102.07.24', 'RAA-1671', '102.07.24', '102.07.24', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (24, '10', '1', '1', 'T23', '102.11.01', '', 'DY83786', 'BMW', '520I F10', '黑色', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', 0, '明龍', '', '', '財盟租賃代步車', '', '', '', '', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (25, '', '1', '1', 'T24', '102.11.01', '', 'C567194', 'BMW', '528I F10', '475/黑色', '', '', '2010', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '', '', '', '', '', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (26, '34', '1', '1', 'T25', '102.11.01', '', 'DW42008', 'BMW', '528I F10', '灰色', '316,710', '', '1209', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '財盟租賃代步車', '', 'RAA-1650', '', '', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (27, '29', '1', '1', 'T26', '102.11.01', '', 'DW42037', 'BMW', '528I F10', '白色', '', '', '1209', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '財盟租賃-鎔德', '', 'RAA-3732', '', '', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (28, '20', '1', '1', 'T27', '102.11.01', '', 'DW42011', 'BMW', '528I F10', '黑色', '316,710', '', '1209', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '財盟租賃代步車', '102.08.27', 'RAA-1652', '102.08.27', '102.08.27', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (29, '7', '1', '1', 'T28', '102.11.01', '', 'DW42053', 'BMW', '528I F10', '黑色', '', '', '1209', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '財盟租賃-依德,領牌日101.12.18,4148KM', '102.07.26', 'RAA-0078', '102.07.26', '102.07.26', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (30, '18', '1', '1', 'T29', '102.11.01', '', 'D124417', 'BMW', '730D F01', '灰色', '', '', '1209', '', '', '', '', 0, '', '', '', '', '', '', 0, '', '', '', '汎德財盟租賃', '102.08.22', 'RAA-1690', '102.08.22', '102.08.22', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (31, '30', '1', '1', 'T30', '102.11.01', '', 'D124413', 'BMW', '730D F01', '黑色', '', '', '1209', '', '', '', '', 0, '', '', '', '', '', '', 0, '竹圍', '', '', '財盟租賃代步車', '', '已售', '', '', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (32, '6', '1', '1', 'T31', '102.11.01', '', 'C998927', 'BMW', '730D F01', '黑色', '', '', '1207', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '依德領牌日101.10.31,4933KM', '102.07.25', '4262-T3', '102.07.25', '102.07.25', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (33, '9', '1', '1', 'T32', '102.11.01', '', 'D124415', 'BMW', '730D F01', '黑色', '', '', '1209', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '財盟租賃代步車', '102.08.01', 'RAA-1691', '102.08.01', '102.08.01', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (34, '23', '1', '1', 'T33', '102.11.01', '', 'D999181', 'BMW', '730D F01', '黑色', '', '', '1209', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '財盟租賃代步車', '', 'RAA-1715', '', '', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (35, '', '1', '1', 'T34', '102.11.01', '', 'DD85071', 'BMW', '7 HYBR F02', '黑色', '', '', '1208', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '財盟租賃-依德,領牌日101.01.02,2761KM', '', '', '', '', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (36, '21', '1', '1', 'T35', '102.11.01', '', 'DZ52263', 'BMW', '740LI F02', '黑色', '', '', '1209', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '財盟租賃-鎔德', '102.08.15', 'RAA-3731', '102.08.15', '102.08.15', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (37, '32', '1', '1', 'T36', '102.11.01', '', 'L449737', 'BMW', 'X5 X35I E70', '灰色', '', '', '2010', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '', '', '', '', '', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (38, '11', '1', '1', 'T37', '102.11.01', '', 'L928972', 'BMW', 'X5 X35I E70', '黑色', '', '', '1208', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '財盟租賃-依德,領牌日101.12.18,5480KM', '102.08.05', 'RAA-0079', '102.08.05', '102.08.05', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (39, '25', '1', '1', 'T38', '102.11.01', '', 'NN94298', 'BMW', '318D F30', '白色', '', '', '1209', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '依德', '', 'AAA-8107', '', '', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (40, '24', '1', '1', 'T39', '102.11.01', '', 'NN68008', 'BMW', '320D F30', '黑色', '', '', '1209', '', '', '', '', 0, '', '', '', '', '', '', 0, '益德', '', '', '財盟租賃-代步車', '', 'RAA-1620', '', '', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (41, '4', '1', '1', 'T40', '102.11.01', '', 'DY52052', 'BMW', '520D F10', '黑色', '', '', '1209', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '鎔德', '', '', '', '', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (42, '', '1', '1', 'T41', '102.11.01', '', 'VR23834', 'BMW', '118D E82', '黑色', '', '', '1203', '', '', '', '', 0, '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (43, '', '1', '1', 'T42', '102.11.01', '', 'VT77118', 'BMW', 'X1 S20I', 'A76', '', '', '2013', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '', '', '', '', '', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (44, '19', '1', '1', 'T43', '102.11.01', '', 'D265325', 'BMW', '520D F10', '黑色', '', '', '2013', '', '', '', '', 0, '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (45, '', '1', '1', 'T44', '102.11.01', '', '', 'BMW', '520D GT F07', '475/黑色', '', '', '1301', '', '', '', '', 0, '', '', '', '', '', '', 0, '鉑德', '', '', '', '', '', '', '', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (46, '', '1', '1', 'T45', '102.11.01', '', 'D171731', 'BMW', '520I F10', '475/黑色', '', '', '1303', '', '', '', '', 0, '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', NULL, '', '', '');
INSERT INTO `bd_car_pur` VALUES (47, '', '1', '1', 'T46', '102.11.01', '', '0C51721', 'BMW', 'X3 X20D', '白色', '', '', '1305', '79508482', '', '', '', 0, '', '', '', '', '', '', 0, '', '', '', '', '', '已售', '', '', NULL, '', '', '');

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

CREATE TABLE `bd_des_cntr` (
  `CntrNo` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `Dat` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `Dep` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `SaleMan` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `SignFlag` varchar(1) COLLATE utf8_unicode_ci DEFAULT '0',
  `VoidFlag` varchar(1) COLLATE utf8_unicode_ci DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `bd_des_cntr` VALUES ('1', '', '', '', '0', '0');
INSERT INTO `bd_des_cntr` VALUES ('2', '', '', '', '0', '0');
INSERT INTO `bd_des_cntr` VALUES ('3', '', '', '', '0', '0');
INSERT INTO `bd_des_cntr` VALUES ('4', '', '', '', '0', '0');
INSERT INTO `bd_des_cntr` VALUES ('5', '', '', '', '0', '0');
INSERT INTO `bd_des_cntr` VALUES ('6', '', '', '', '0', '0');
INSERT INTO `bd_des_cntr` VALUES ('7', '', '', '', '0', '0');
INSERT INTO `bd_des_cntr` VALUES ('8', '', '', '', '0', '0');
INSERT INTO `bd_des_cntr` VALUES ('9', '', '', '', '0', '0');
INSERT INTO `bd_des_cntr` VALUES ('10', '', '', '', '0', '0');
INSERT INTO `bd_des_cntr` VALUES ('11', '', '', '', '0', '0');
INSERT INTO `bd_des_cntr` VALUES ('12', '', '', '', '0', '0');
INSERT INTO `bd_des_cntr` VALUES ('13', '', '', '', '0', '0');
INSERT INTO `bd_des_cntr` VALUES ('14', '', '', '', '0', '0');
INSERT INTO `bd_des_cntr` VALUES ('15', '', '', '', '0', '0');
INSERT INTO `bd_des_cntr` VALUES ('16', '', '', '', '0', '0');
INSERT INTO `bd_des_cntr` VALUES ('17', '', '', '', '0', '0');
INSERT INTO `bd_des_cntr` VALUES ('18', '', '', '', '0', '0');
INSERT INTO `bd_des_cntr` VALUES ('19', '', '', '', '0', '0');
INSERT INTO `bd_des_cntr` VALUES ('20', '', '', '', '0', '0');
INSERT INTO `bd_des_cntr` VALUES ('21', '', '', '', '0', '0');
INSERT INTO `bd_des_cntr` VALUES ('22', '', '', '', '0', '0');
INSERT INTO `bd_des_cntr` VALUES ('23', '', '', '', '0', '0');
INSERT INTO `bd_des_cntr` VALUES ('24', '', '', '', '0', '0');
INSERT INTO `bd_des_cntr` VALUES ('25', '', '', '', '0', '0');
INSERT INTO `bd_des_cntr` VALUES ('26', '', '', '', '0', '0');
INSERT INTO `bd_des_cntr` VALUES ('27', '', '', '', '0', '0');
INSERT INTO `bd_des_cntr` VALUES ('28', '', '', '', '0', '0');
INSERT INTO `bd_des_cntr` VALUES ('29', '', '', '', '0', '0');
INSERT INTO `bd_des_cntr` VALUES ('30', '', '', '', '0', '0');
INSERT INTO `bd_des_cntr` VALUES ('38', '102.11.11', '', 'Peter', '0', '0');

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


CREATE TABLE `bd_des_scan` (
  `ScanId` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `CntrNo` varchar(20) NOT NULL,
  `Dat` varchar(10) NOT NULL,
  `Tmk` varchar(14) NOT NULL,
  `VoidFlag` varchar(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ScanId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



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


CREATE TABLE `des_city` (
  `City` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `Town` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `Zip` varchar(3) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `des_city` VALUES ('台北市', '中正區', '100');
INSERT INTO `des_city` VALUES ('台北市', '大同區', '103');
INSERT INTO `des_city` VALUES ('台北市', '中山區', '104');
INSERT INTO `des_city` VALUES ('台北市', '松山區', '105');
INSERT INTO `des_city` VALUES ('台北市', '大安區', '106');
INSERT INTO `des_city` VALUES ('台北市', '萬華區', '108');
INSERT INTO `des_city` VALUES ('台北市', '信義區', '110');
INSERT INTO `des_city` VALUES ('台北市', '士林區', '111');
INSERT INTO `des_city` VALUES ('台北市', '北投區', '112');
INSERT INTO `des_city` VALUES ('台北市', '內湖區', '114');
INSERT INTO `des_city` VALUES ('台北市', '南港區', '115');
INSERT INTO `des_city` VALUES ('台北市', '文山區', '116');
INSERT INTO `des_city` VALUES ('基隆市', '仁愛區', '200');
INSERT INTO `des_city` VALUES ('基隆市', '信義區', '201');
INSERT INTO `des_city` VALUES ('基隆市', '中正區', '202');
INSERT INTO `des_city` VALUES ('基隆市', '中山區', '203');
INSERT INTO `des_city` VALUES ('基隆市', '安樂區', '204');
INSERT INTO `des_city` VALUES ('基隆市', '暖暖區', '205');
INSERT INTO `des_city` VALUES ('基隆市', '七堵區', '206');
INSERT INTO `des_city` VALUES ('新北市', '萬里區', '207');
INSERT INTO `des_city` VALUES ('新北市', '金山區', '208');
INSERT INTO `des_city` VALUES ('連江縣', '南竿鄉', '209');
INSERT INTO `des_city` VALUES ('連江縣', '北竿鄉', '210');
INSERT INTO `des_city` VALUES ('連江縣', '莒光鄉', '211');
INSERT INTO `des_city` VALUES ('連江縣', '東引鄉', '212');
INSERT INTO `des_city` VALUES ('新北市', '板橋區', '220');
INSERT INTO `des_city` VALUES ('新北市', '汐止區', '221');
INSERT INTO `des_city` VALUES ('新北市', '深坑區', '222');
INSERT INTO `des_city` VALUES ('新北市', '石碇區', '223');
INSERT INTO `des_city` VALUES ('新北市', '瑞芳區', '224');
INSERT INTO `des_city` VALUES ('新北市', '平溪區', '226');
INSERT INTO `des_city` VALUES ('新北市', '雙溪區', '227');
INSERT INTO `des_city` VALUES ('新北市', '貢寮區', '228');
INSERT INTO `des_city` VALUES ('新北市', '新店區', '231');
INSERT INTO `des_city` VALUES ('新北市', '坪林區', '232');
INSERT INTO `des_city` VALUES ('新北市', '烏來區', '233');
INSERT INTO `des_city` VALUES ('新北市', '永和區', '234');
INSERT INTO `des_city` VALUES ('新北市', '中和區', '235');
INSERT INTO `des_city` VALUES ('新北市', '土城區', '236');
INSERT INTO `des_city` VALUES ('新北市', '三峽區', '237');
INSERT INTO `des_city` VALUES ('新北市', '樹林區', '238');
INSERT INTO `des_city` VALUES ('新北市', '鶯歌區', '239');
INSERT INTO `des_city` VALUES ('新北市', '三重區', '241');
INSERT INTO `des_city` VALUES ('新北市', '新莊區', '242');
INSERT INTO `des_city` VALUES ('新北市', '泰山區', '243');
INSERT INTO `des_city` VALUES ('新北市', '林口區', '244');
INSERT INTO `des_city` VALUES ('新北市', '蘆洲區', '247');
INSERT INTO `des_city` VALUES ('新北市', '五股區', '248');
INSERT INTO `des_city` VALUES ('新北市', '八里區', '249');
INSERT INTO `des_city` VALUES ('新北市', '淡水區', '251');
INSERT INTO `des_city` VALUES ('新北市', '三芝區', '252');
INSERT INTO `des_city` VALUES ('新北市', '石門區', '253');
INSERT INTO `des_city` VALUES ('宜蘭縣', '宜蘭市', '260');
INSERT INTO `des_city` VALUES ('宜蘭縣', '頭城鎮', '261');
INSERT INTO `des_city` VALUES ('宜蘭縣', '礁溪鄉', '262');
INSERT INTO `des_city` VALUES ('宜蘭縣', '壯圍鄉', '263');
INSERT INTO `des_city` VALUES ('宜蘭縣', '員山鄉', '264');
INSERT INTO `des_city` VALUES ('宜蘭縣', '羅東鎮', '265');
INSERT INTO `des_city` VALUES ('宜蘭縣', '三星鄉', '266');
INSERT INTO `des_city` VALUES ('宜蘭縣', '大同鄉', '267');
INSERT INTO `des_city` VALUES ('宜蘭縣', '五結鄉', '268');
INSERT INTO `des_city` VALUES ('宜蘭縣', '冬山鄉', '269');
INSERT INTO `des_city` VALUES ('宜蘭縣', '蘇澳鎮', '270');
INSERT INTO `des_city` VALUES ('宜蘭縣', '南澳鄉', '272');
INSERT INTO `des_city` VALUES ('新竹市', '北區', '300');
INSERT INTO `des_city` VALUES ('新竹市', '東區', '300');
INSERT INTO `des_city` VALUES ('新竹市', '香山區', '300');
INSERT INTO `des_city` VALUES ('新竹縣', '竹北市', '302');
INSERT INTO `des_city` VALUES ('新竹縣', '湖口鄉', '303');
INSERT INTO `des_city` VALUES ('新竹縣', '新豐鄉', '304');
INSERT INTO `des_city` VALUES ('新竹縣', '新埔鎮', '305');
INSERT INTO `des_city` VALUES ('新竹縣', '關西鎮', '306');
INSERT INTO `des_city` VALUES ('新竹縣', '芎林鄉', '307');
INSERT INTO `des_city` VALUES ('新竹縣', '寶山鄉', '308');
INSERT INTO `des_city` VALUES ('新竹縣', '竹東鎮', '310');
INSERT INTO `des_city` VALUES ('新竹縣', '五峰鄉', '311');
INSERT INTO `des_city` VALUES ('新竹縣', '橫山鄉', '312');
INSERT INTO `des_city` VALUES ('新竹縣', '尖石鄉', '313');
INSERT INTO `des_city` VALUES ('新竹縣', '北埔鄉', '314');
INSERT INTO `des_city` VALUES ('新竹縣', '峨眉鄉', '315');
INSERT INTO `des_city` VALUES ('桃園縣', '中壢市', '320');
INSERT INTO `des_city` VALUES ('桃園縣', '平鎮市', '324');
INSERT INTO `des_city` VALUES ('桃園縣', '龍潭鄉', '325');
INSERT INTO `des_city` VALUES ('桃園縣', '楊梅鎮', '326');
INSERT INTO `des_city` VALUES ('桃園縣', '新屋鄉', '327');
INSERT INTO `des_city` VALUES ('桃園縣', '觀音鄉', '328');
INSERT INTO `des_city` VALUES ('桃園縣', '桃園市', '330');
INSERT INTO `des_city` VALUES ('桃園縣', '龜山鄉', '333');
INSERT INTO `des_city` VALUES ('桃園縣', '八德市', '334');
INSERT INTO `des_city` VALUES ('桃園縣', '大溪鎮', '335');
INSERT INTO `des_city` VALUES ('桃園縣', '復興鄉', '336');
INSERT INTO `des_city` VALUES ('桃園縣', '大園鄉', '337');
INSERT INTO `des_city` VALUES ('桃園縣', '蘆竹鄉', '338');
INSERT INTO `des_city` VALUES ('苗栗縣', '竹南鎮', '350');
INSERT INTO `des_city` VALUES ('苗栗縣', '頭份鎮', '351');
INSERT INTO `des_city` VALUES ('苗栗縣', '三灣鄉', '352');
INSERT INTO `des_city` VALUES ('苗栗縣', '南庄鄉', '353');
INSERT INTO `des_city` VALUES ('苗栗縣', '獅潭鄉', '354');
INSERT INTO `des_city` VALUES ('苗栗縣', '後龍鎮', '356');
INSERT INTO `des_city` VALUES ('苗栗縣', '通霄鎮', '357');
INSERT INTO `des_city` VALUES ('苗栗縣', '苑裡鎮', '358');
INSERT INTO `des_city` VALUES ('苗栗縣', '苗栗市', '360');
INSERT INTO `des_city` VALUES ('苗栗縣', '造橋鄉', '361');
INSERT INTO `des_city` VALUES ('苗栗縣', '頭屋鄉', '362');
INSERT INTO `des_city` VALUES ('苗栗縣', '公館鄉', '363');
INSERT INTO `des_city` VALUES ('苗栗縣', '大湖鄉', '364');
INSERT INTO `des_city` VALUES ('苗栗縣', '泰安鄉', '365');
INSERT INTO `des_city` VALUES ('苗栗縣', '銅鑼鄉', '366');
INSERT INTO `des_city` VALUES ('苗栗縣', '三義鄉', '367');
INSERT INTO `des_city` VALUES ('苗栗縣', '西湖鄉', '368');
INSERT INTO `des_city` VALUES ('苗栗縣', '卓蘭鎮', '369');
INSERT INTO `des_city` VALUES ('台中市', '中區', '400');
INSERT INTO `des_city` VALUES ('台中市', '東區', '401');
INSERT INTO `des_city` VALUES ('台中市', '南區', '402');
INSERT INTO `des_city` VALUES ('台中市', '西區', '403');
INSERT INTO `des_city` VALUES ('台中市', '北區', '404');
INSERT INTO `des_city` VALUES ('台中市', '北屯區', '406');
INSERT INTO `des_city` VALUES ('台中市', '西屯區', '407');
INSERT INTO `des_city` VALUES ('台中市', '南屯區', '408');
INSERT INTO `des_city` VALUES ('台中市', '太平區', '411');
INSERT INTO `des_city` VALUES ('台中市', '大里區', '412');
INSERT INTO `des_city` VALUES ('台中市', '霧峰區', '413');
INSERT INTO `des_city` VALUES ('台中市', '烏日區', '414');
INSERT INTO `des_city` VALUES ('台中市', '豐原區', '420');
INSERT INTO `des_city` VALUES ('台中市', '后里區', '421');
INSERT INTO `des_city` VALUES ('台中市', '石岡區', '422');
INSERT INTO `des_city` VALUES ('台中市', '東勢區', '423');
INSERT INTO `des_city` VALUES ('台中市', '和平區', '424');
INSERT INTO `des_city` VALUES ('台中市', '新社區', '426');
INSERT INTO `des_city` VALUES ('台中市', '潭子區', '427');
INSERT INTO `des_city` VALUES ('台中市', '大雅區', '428');
INSERT INTO `des_city` VALUES ('台中市', '神岡區', '429');
INSERT INTO `des_city` VALUES ('台中市', '大肚區', '432');
INSERT INTO `des_city` VALUES ('台中市', '沙鹿區', '433');
INSERT INTO `des_city` VALUES ('台中市', '龍井區', '434');
INSERT INTO `des_city` VALUES ('台中市', '梧棲區', '435');
INSERT INTO `des_city` VALUES ('台中市', '清水區', '436');
INSERT INTO `des_city` VALUES ('台中市', '大甲區', '437');
INSERT INTO `des_city` VALUES ('台中市', '外埔區', '438');
INSERT INTO `des_city` VALUES ('台中市', '大安區', '439');
INSERT INTO `des_city` VALUES ('彰化縣', '彰化市', '500');
INSERT INTO `des_city` VALUES ('彰化縣', '芬園鄉', '502');
INSERT INTO `des_city` VALUES ('彰化縣', '花壇鄉', '503');
INSERT INTO `des_city` VALUES ('彰化縣', '秀水鄉', '504');
INSERT INTO `des_city` VALUES ('彰化縣', '鹿港鎮', '505');
INSERT INTO `des_city` VALUES ('彰化縣', '福興鄉', '506');
INSERT INTO `des_city` VALUES ('彰化縣', '線西鄉', '507');
INSERT INTO `des_city` VALUES ('彰化縣', '和美鎮', '508');
INSERT INTO `des_city` VALUES ('彰化縣', '伸港鄉', '509');
INSERT INTO `des_city` VALUES ('彰化縣', '員林鎮', '510');
INSERT INTO `des_city` VALUES ('彰化縣', '社頭鄉', '511');
INSERT INTO `des_city` VALUES ('彰化縣', '永靖鄉', '512');
INSERT INTO `des_city` VALUES ('彰化縣', '埔心鄉', '513');
INSERT INTO `des_city` VALUES ('彰化縣', '溪湖鎮', '514');
INSERT INTO `des_city` VALUES ('彰化縣', '大村鄉', '515');
INSERT INTO `des_city` VALUES ('彰化縣', '埔鹽鄉', '516');
INSERT INTO `des_city` VALUES ('彰化縣', '田中鎮', '520');
INSERT INTO `des_city` VALUES ('彰化縣', '北斗鎮', '521');
INSERT INTO `des_city` VALUES ('彰化縣', '田尾鄉', '522');
INSERT INTO `des_city` VALUES ('彰化縣', '埤頭鄉', '523');
INSERT INTO `des_city` VALUES ('彰化縣', '溪州鄉', '524');
INSERT INTO `des_city` VALUES ('彰化縣', '竹塘鄉', '525');
INSERT INTO `des_city` VALUES ('彰化縣', '二林鎮', '526');
INSERT INTO `des_city` VALUES ('彰化縣', '大城鄉', '527');
INSERT INTO `des_city` VALUES ('彰化縣', '芳苑鄉', '528');
INSERT INTO `des_city` VALUES ('彰化縣', '二水鄉', '530');
INSERT INTO `des_city` VALUES ('南投縣', '南投市', '540');
INSERT INTO `des_city` VALUES ('南投縣', '中寮鄉', '541');
INSERT INTO `des_city` VALUES ('南投縣', '草屯鎮', '542');
INSERT INTO `des_city` VALUES ('南投縣', '國姓鄉', '544');
INSERT INTO `des_city` VALUES ('南投縣', '埔里鎮', '545');
INSERT INTO `des_city` VALUES ('南投縣', '仁愛鄉', '546');
INSERT INTO `des_city` VALUES ('南投縣', '名間鄉', '551');
INSERT INTO `des_city` VALUES ('南投縣', '集集鎮', '552');
INSERT INTO `des_city` VALUES ('南投縣', '水里鄉', '553');
INSERT INTO `des_city` VALUES ('南投縣', '魚池鄉', '555');
INSERT INTO `des_city` VALUES ('南投縣', '信義鄉', '556');
INSERT INTO `des_city` VALUES ('南投縣', '竹山鎮', '557');
INSERT INTO `des_city` VALUES ('南投縣', '鹿谷鄉', '558');
INSERT INTO `des_city` VALUES ('嘉義市', '西區', '600');
INSERT INTO `des_city` VALUES ('嘉義市', '東區', '600');
INSERT INTO `des_city` VALUES ('嘉義縣', '番路鄉', '602');
INSERT INTO `des_city` VALUES ('嘉義縣', '梅山鄉', '603');
INSERT INTO `des_city` VALUES ('嘉義縣', '竹崎鄉', '604');
INSERT INTO `des_city` VALUES ('嘉義縣', '阿里山', '605');
INSERT INTO `des_city` VALUES ('嘉義縣', '中埔鄉', '606');
INSERT INTO `des_city` VALUES ('嘉義縣', '大埔鄉', '607');
INSERT INTO `des_city` VALUES ('嘉義縣', '水上鄉', '608');
INSERT INTO `des_city` VALUES ('嘉義縣', '鹿草鄉', '611');
INSERT INTO `des_city` VALUES ('嘉義縣', '太保市', '612');
INSERT INTO `des_city` VALUES ('嘉義縣', '朴子市', '613');
INSERT INTO `des_city` VALUES ('嘉義縣', '東石鄉', '614');
INSERT INTO `des_city` VALUES ('嘉義縣', '六腳鄉', '615');
INSERT INTO `des_city` VALUES ('嘉義縣', '新港鄉', '616');
INSERT INTO `des_city` VALUES ('嘉義縣', '民雄鄉', '621');
INSERT INTO `des_city` VALUES ('嘉義縣', '大林鎮', '622');
INSERT INTO `des_city` VALUES ('嘉義縣', '溪口鄉', '623');
INSERT INTO `des_city` VALUES ('嘉義縣', '義竹鄉', '624');
INSERT INTO `des_city` VALUES ('嘉義縣', '布袋鎮', '625');
INSERT INTO `des_city` VALUES ('雲林縣', '斗南鎮', '630');
INSERT INTO `des_city` VALUES ('雲林縣', '大埤鄉', '631');
INSERT INTO `des_city` VALUES ('雲林縣', '虎尾鎮', '632');
INSERT INTO `des_city` VALUES ('雲林縣', '土庫鎮', '633');
INSERT INTO `des_city` VALUES ('雲林縣', '褒忠鄉', '634');
INSERT INTO `des_city` VALUES ('雲林縣', '東勢鄉', '635');
INSERT INTO `des_city` VALUES ('雲林縣', '台西鄉', '636');
INSERT INTO `des_city` VALUES ('雲林縣', '崙背鄉', '637');
INSERT INTO `des_city` VALUES ('雲林縣', '麥寮鄉', '638');
INSERT INTO `des_city` VALUES ('雲林縣', '斗六市', '640');
INSERT INTO `des_city` VALUES ('雲林縣', '林內鄉', '643');
INSERT INTO `des_city` VALUES ('雲林縣', '古坑鄉', '646');
INSERT INTO `des_city` VALUES ('雲林縣', '莿桐鄉', '647');
INSERT INTO `des_city` VALUES ('雲林縣', '西螺鎮', '648');
INSERT INTO `des_city` VALUES ('雲林縣', '二崙鄉', '649');
INSERT INTO `des_city` VALUES ('雲林縣', '北港鎮', '651');
INSERT INTO `des_city` VALUES ('雲林縣', '水林鄉', '652');
INSERT INTO `des_city` VALUES ('雲林縣', '口湖鄉', '653');
INSERT INTO `des_city` VALUES ('雲林縣', '四湖鄉', '654');
INSERT INTO `des_city` VALUES ('雲林縣', '元長鄉', '655');
INSERT INTO `des_city` VALUES ('台南市', '中西區', '700');
INSERT INTO `des_city` VALUES ('台南市', '東區', '701');
INSERT INTO `des_city` VALUES ('台南市', '南區', '702');
INSERT INTO `des_city` VALUES ('台南市', '北區', '704');
INSERT INTO `des_city` VALUES ('台南市', '安平區', '708');
INSERT INTO `des_city` VALUES ('台南市', '安南區', '709');
INSERT INTO `des_city` VALUES ('台南市', '永康區', '710');
INSERT INTO `des_city` VALUES ('台南市', '歸仁區', '711');
INSERT INTO `des_city` VALUES ('台南市', '新化區', '712');
INSERT INTO `des_city` VALUES ('台南市', '左鎮區', '713');
INSERT INTO `des_city` VALUES ('台南市', '玉井區', '714');
INSERT INTO `des_city` VALUES ('台南市', '楠西區', '715');
INSERT INTO `des_city` VALUES ('台南市', '南化區', '716');
INSERT INTO `des_city` VALUES ('台南市', '仁德區', '717');
INSERT INTO `des_city` VALUES ('台南市', '關廟區', '718');
INSERT INTO `des_city` VALUES ('台南市', '龍崎區', '719');
INSERT INTO `des_city` VALUES ('台南市', '官田區', '720');
INSERT INTO `des_city` VALUES ('台南市', '麻豆區', '721');
INSERT INTO `des_city` VALUES ('台南市', '佳里區', '722');
INSERT INTO `des_city` VALUES ('台南市', '西港區', '723');
INSERT INTO `des_city` VALUES ('台南市', '七股區', '724');
INSERT INTO `des_city` VALUES ('台南市', '將軍區', '725');
INSERT INTO `des_city` VALUES ('台南市', '學甲區', '726');
INSERT INTO `des_city` VALUES ('台南市', '北門區', '727');
INSERT INTO `des_city` VALUES ('台南市', '新營區', '730');
INSERT INTO `des_city` VALUES ('台南市', '後壁區', '731');
INSERT INTO `des_city` VALUES ('台南市', '白河區', '732');
INSERT INTO `des_city` VALUES ('台南市', '東山區', '733');
INSERT INTO `des_city` VALUES ('台南市', '六甲區', '734');
INSERT INTO `des_city` VALUES ('台南市', '下營區', '735');
INSERT INTO `des_city` VALUES ('台南市', '柳營區', '736');
INSERT INTO `des_city` VALUES ('台南市', '鹽水區', '737');
INSERT INTO `des_city` VALUES ('台南市', '善化區', '741');
INSERT INTO `des_city` VALUES ('台南市', '大內區', '742');
INSERT INTO `des_city` VALUES ('台南市', '山上區', '743');
INSERT INTO `des_city` VALUES ('台南市', '新市區', '744');
INSERT INTO `des_city` VALUES ('台南市', '安定區', '745');
INSERT INTO `des_city` VALUES ('高雄市', '新興區', '800');
INSERT INTO `des_city` VALUES ('高雄市', '前金區', '801');
INSERT INTO `des_city` VALUES ('高雄市', '苓雅區', '802');
INSERT INTO `des_city` VALUES ('高雄市', '鹽埕區', '803');
INSERT INTO `des_city` VALUES ('高雄市', '鼓山區', '804');
INSERT INTO `des_city` VALUES ('高雄市', '旗津區', '805');
INSERT INTO `des_city` VALUES ('高雄市', '前鎮區', '806');
INSERT INTO `des_city` VALUES ('高雄市', '三民區', '807');
INSERT INTO `des_city` VALUES ('高雄市', '楠梓區', '811');
INSERT INTO `des_city` VALUES ('高雄市', '小港區', '812');
INSERT INTO `des_city` VALUES ('高雄市', '左營區', '813');
INSERT INTO `des_city` VALUES ('高雄市', '仁武區', '814');
INSERT INTO `des_city` VALUES ('高雄市', '大社區', '815');
INSERT INTO `des_city` VALUES ('高雄市', '岡山區', '820');
INSERT INTO `des_city` VALUES ('高雄市', '路竹區', '821');
INSERT INTO `des_city` VALUES ('高雄市', '阿蓮區', '822');
INSERT INTO `des_city` VALUES ('高雄市', '田寮區', '823');
INSERT INTO `des_city` VALUES ('高雄市', '燕巢區', '824');
INSERT INTO `des_city` VALUES ('高雄市', '橋頭區', '825');
INSERT INTO `des_city` VALUES ('高雄市', '梓官區', '826');
INSERT INTO `des_city` VALUES ('高雄市', '彌陀區', '827');
INSERT INTO `des_city` VALUES ('高雄市', '永安區', '828');
INSERT INTO `des_city` VALUES ('高雄市', '湖內區', '829');
INSERT INTO `des_city` VALUES ('高雄市', '鳳山區', '830');
INSERT INTO `des_city` VALUES ('高雄市', '大寮區', '831');
INSERT INTO `des_city` VALUES ('高雄市', '林園區', '832');
INSERT INTO `des_city` VALUES ('高雄市', '鳥松區', '833');
INSERT INTO `des_city` VALUES ('高雄市', '大樹區', '840');
INSERT INTO `des_city` VALUES ('高雄市', '旗山區', '842');
INSERT INTO `des_city` VALUES ('高雄市', '美濃區', '843');
INSERT INTO `des_city` VALUES ('高雄市', '六龜區', '844');
INSERT INTO `des_city` VALUES ('高雄市', '內門區', '845');
INSERT INTO `des_city` VALUES ('高雄市', '杉林區', '846');
INSERT INTO `des_city` VALUES ('高雄市', '甲仙區', '847');
INSERT INTO `des_city` VALUES ('高雄市', '桃源區', '848');
INSERT INTO `des_city` VALUES ('高雄市', '那瑪夏', '849');
INSERT INTO `des_city` VALUES ('高雄市', '茂林區', '851');
INSERT INTO `des_city` VALUES ('高雄市', '茄萣區', '852');
INSERT INTO `des_city` VALUES ('澎湖縣', '馬公市', '880');
INSERT INTO `des_city` VALUES ('澎湖縣', '西嶼鄉', '881');
INSERT INTO `des_city` VALUES ('澎湖縣', '望安鄉', '882');
INSERT INTO `des_city` VALUES ('澎湖縣', '七美鄉', '883');
INSERT INTO `des_city` VALUES ('澎湖縣', '白沙鄉', '884');
INSERT INTO `des_city` VALUES ('澎湖縣', '湖西鄉', '885');
INSERT INTO `des_city` VALUES ('金門縣', '金沙鎮', '890');
INSERT INTO `des_city` VALUES ('金門縣', '金湖鎮', '891');
INSERT INTO `des_city` VALUES ('金門縣', '金寧鄉', '892');
INSERT INTO `des_city` VALUES ('金門縣', '金城鎮', '893');
INSERT INTO `des_city` VALUES ('金門縣', '烈嶼鄉', '894');
INSERT INTO `des_city` VALUES ('金門縣', '烏坵鄉', '896');
INSERT INTO `des_city` VALUES ('屏東縣', '屏東市', '900');
INSERT INTO `des_city` VALUES ('屏東縣', '三地門', '901');
INSERT INTO `des_city` VALUES ('屏東縣', '霧台鄉', '902');
INSERT INTO `des_city` VALUES ('屏東縣', '瑪家鄉', '903');
INSERT INTO `des_city` VALUES ('屏東縣', '九如鄉', '904');
INSERT INTO `des_city` VALUES ('屏東縣', '里港鄉', '905');
INSERT INTO `des_city` VALUES ('屏東縣', '高樹鄉', '906');
INSERT INTO `des_city` VALUES ('屏東縣', '鹽埔鄉', '907');
INSERT INTO `des_city` VALUES ('屏東縣', '長治鄉', '908');
INSERT INTO `des_city` VALUES ('屏東縣', '麟洛鄉', '909');
INSERT INTO `des_city` VALUES ('屏東縣', '竹田鄉', '911');
INSERT INTO `des_city` VALUES ('屏東縣', '內埔鄉', '912');
INSERT INTO `des_city` VALUES ('屏東縣', '萬丹鄉', '913');
INSERT INTO `des_city` VALUES ('屏東縣', '潮州鎮', '920');
INSERT INTO `des_city` VALUES ('屏東縣', '泰武鄉', '921');
INSERT INTO `des_city` VALUES ('屏東縣', '來義鄉', '922');
INSERT INTO `des_city` VALUES ('屏東縣', '萬巒鄉', '923');
INSERT INTO `des_city` VALUES ('屏東縣', '崁頂鄉', '924');
INSERT INTO `des_city` VALUES ('屏東縣', '新埤鄉', '925');
INSERT INTO `des_city` VALUES ('屏東縣', '南州鄉', '926');
INSERT INTO `des_city` VALUES ('屏東縣', '林邊鄉', '927');
INSERT INTO `des_city` VALUES ('屏東縣', '東港鎮', '928');
INSERT INTO `des_city` VALUES ('屏東縣', '琉球鄉', '929');
INSERT INTO `des_city` VALUES ('屏東縣', '佳冬鄉', '931');
INSERT INTO `des_city` VALUES ('屏東縣', '新園鄉', '932');
INSERT INTO `des_city` VALUES ('屏東縣', '枋寮鄉', '940');
INSERT INTO `des_city` VALUES ('屏東縣', '枋山鄉', '941');
INSERT INTO `des_city` VALUES ('屏東縣', '春日鄉', '942');
INSERT INTO `des_city` VALUES ('屏東縣', '獅子鄉', '943');
INSERT INTO `des_city` VALUES ('屏東縣', '車城鄉', '944');
INSERT INTO `des_city` VALUES ('屏東縣', '牡丹鄉', '945');
INSERT INTO `des_city` VALUES ('屏東縣', '恆春鎮', '946');
INSERT INTO `des_city` VALUES ('屏東縣', '滿州鄉', '947');
INSERT INTO `des_city` VALUES ('台東縣', '台東市', '950');
INSERT INTO `des_city` VALUES ('台東縣', '綠島鄉', '951');
INSERT INTO `des_city` VALUES ('台東縣', '蘭嶼鄉', '952');
INSERT INTO `des_city` VALUES ('台東縣', '延平鄉', '953');
INSERT INTO `des_city` VALUES ('台東縣', '卑南鄉', '954');
INSERT INTO `des_city` VALUES ('台東縣', '鹿野鄉', '955');
INSERT INTO `des_city` VALUES ('台東縣', '關山鎮', '956');
INSERT INTO `des_city` VALUES ('台東縣', '海端鄉', '957');
INSERT INTO `des_city` VALUES ('台東縣', '池上鄉', '958');
INSERT INTO `des_city` VALUES ('台東縣', '東河鄉', '959');
INSERT INTO `des_city` VALUES ('台東縣', '成功鎮', '961');
INSERT INTO `des_city` VALUES ('台東縣', '長濱鄉', '962');
INSERT INTO `des_city` VALUES ('台東縣', '太麻里', '963');
INSERT INTO `des_city` VALUES ('台東縣', '金峰鄉', '964');
INSERT INTO `des_city` VALUES ('台東縣', '大武鄉', '965');
INSERT INTO `des_city` VALUES ('台東縣', '達仁鄉', '966');
INSERT INTO `des_city` VALUES ('花蓮縣', '花蓮市', '970');
INSERT INTO `des_city` VALUES ('花蓮縣', '新城鄉', '971');
INSERT INTO `des_city` VALUES ('花蓮縣', '秀林鄉', '972');
INSERT INTO `des_city` VALUES ('花蓮縣', '吉安鄉', '973');
INSERT INTO `des_city` VALUES ('花蓮縣', '壽豐鄉', '974');
INSERT INTO `des_city` VALUES ('花蓮縣', '鳳林鎮', '975');
INSERT INTO `des_city` VALUES ('花蓮縣', '光復鄉', '976');
INSERT INTO `des_city` VALUES ('花蓮縣', '豐濱鄉', '977');
INSERT INTO `des_city` VALUES ('花蓮縣', '瑞穗鄉', '978');
INSERT INTO `des_city` VALUES ('花蓮縣', '萬榮鄉', '979');
INSERT INTO `des_city` VALUES ('花蓮縣', '玉里鎮', '981');
INSERT INTO `des_city` VALUES ('花蓮縣', '卓溪鄉', '982');
INSERT INTO `des_city` VALUES ('花蓮縣', '富里鄉', '983');

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

-- 
-- ±���½ṹ `des_function`
-- 

CREATE TABLE `des_function` (
  `MainIndex` int(5) unsigned DEFAULT NULL,
  `SubIndex` int(5) unsigned DEFAULT NULL,
  `Pos` tinyint(3) unsigned DEFAULT NULL,
  `Title` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Des` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Level` tinyint(1) unsigned DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- µ¼³�еŊ�es_function`
-- 

INSERT INTO `des_function` VALUES (1, 1, 1, '空白合約書製作', '輸入須建立的合約起始及終止編號，系統會檢查是否有重號並依設立的合約編號自動產生新合約編號建檔。', 4);
INSERT INTO `des_function` VALUES (1, 2, 2, '空白合約書領取/作廢', '部門及業務領用空白合約登記及作廢己領用空白合約處理。', 4);
INSERT INTO `des_function` VALUES (1, 3, 3, '新合約輸入', '客戶購車合約建立〔依可用合約編號及車身碼〕，輸入客戶基本資料及客戶購車資料建檔。', 3);
INSERT INTO `des_function` VALUES (1, 4, 4, '合約資料修改', '客戶購車合約資料修改〔依已建立合約編號〕，輸入修改的客戶基本資料及客戶購車資料。', 3);
INSERT INTO `des_function` VALUES (1, 5, 5, '合約換車輸入', '客戶換購其他庫存車，依合約編號輸入欲換購的車身碼，系統會依新輸入的車身碼車輛資料取代原購車。', 3);
INSERT INTO `des_function` VALUES (1, 6, 6, '合約退購輸入', '客戶取消購車但保留合約及相關財務記錄，依合約編號執行退購確認。 ', 3);
INSERT INTO `des_function` VALUES (1, 7, 7, '合約換號輸入', '更換已成交的客戶合約編號，輸入新合約編號取代原合約編號。', 3);
INSERT INTO `des_function` VALUES (1, 8, 8, '交車核對表下載列印', '依合約、憑單、科目….等條件產生交車核對表單 EXCEL表，提供二次運用及列印使用。', 3);
INSERT INTO `des_function` VALUES (1, 9, 9, '空白合約書明細表', '依合約起啟、結束編號產生空白合約書狀態EXCEL表，提供二次運用及列印使用。', 3);
INSERT INTO `des_function` VALUES (1, 10, 10, '連續合約查詢', '依合約起啟、結束編號查詢所有合約的狀態。', 3);
INSERT INTO `des_function` VALUES (1, 11, 11, '綜合合約查詢', '查詢成交客戶合約建檔資料、訂購車資料及所有與客戶合約相關的車輛資料。 ', 3);
INSERT INTO `des_function` VALUES (2, 1, 1, '可售車源查詢/保留', '依廠牌或其它條件查詢… 可銷售〔己保留、未保留〕的「現車庫存」、「寄售車」等可銷售車資料，並可設定「保留」。', 3);
INSERT INTO `des_function` VALUES (2, 2, 2, '入庫單輸入', '建立車輛採購〔買斷、寄售〕入庫單及採購車輛相關資料輸入作業處理。', 3);
INSERT INTO `des_function` VALUES (2, 3, 3, '車輛基本資料修改', '採購車輛資料修改〔採購條件、車輛基本資料、來源、庫存地、相關異動日期….等〕。', 3);
INSERT INTO `des_function` VALUES (2, 4, 4, '選配加裝作業', '客戶增加選配資料輸入及修改，選配可分收費或不收費〔贈品〕。', 3);
INSERT INTO `des_function` VALUES (2, 5, 5, '入庫單刪除', '入庫單及採購車會被取消，但資料仍被保留，不可使用但可查詢〔如果入庫車己建立客戶購車合約，則須先執行退購處理，取消客戶購車〕。', 4);
INSERT INTO `des_function` VALUES (2, 6, 6, '入庫單刪除還原', '解除已被列入「刪除」的入庫單及採購車並還原相關資料。', 4);
INSERT INTO `des_function` VALUES (2, 7, 7, '入庫單永久刪除', '將已列入刪除的入庫單及採購車相關資料永久刪除。', 5);
INSERT INTO `des_function` VALUES (2, 8, 8, '綜合車輛查詢', '依車身號、入庫單號、合約號、牌照號、來源、庫存地...等條件，查詢車輛資料記錄。', 3);
INSERT INTO `des_function` VALUES (3, 1, 1, '新增保單輸入', '依客戶投保資料建立保單輸入作業。', 3);
INSERT INTO `des_function` VALUES (3, 2, 2, '保單修改', '依保單號碼修改客戶投保資料作業。', 3);
INSERT INTO `des_function` VALUES (3, 3, 3, '保單刪除', '依保單號碼刪除客戶投保資料作業。', 5);
INSERT INTO `des_function` VALUES (3, 4, 4, '保險明細資料下載', '依查詢條件產生險明細帳 EXCEL表，並下載至指定位置，提供二次運用。', 4);
INSERT INTO `des_function` VALUES (3, 5, 5, '保單查詢', '依合約編號、姓名、車身號、牌照號、保單號、保卡號….等條件，查詢調出保單基本資料及相關記錄。', 3);
INSERT INTO `des_function` VALUES (4, 1, 1, '應收/已收憑單作業', '應收/己收憑單資料輸入處理。〔售車款-應收/己收、保險費-應收/己收、牌照及其他應收/己收〕', 3);
INSERT INTO `des_function` VALUES (4, 2, 2, '應付/已付憑單作業', '應付/己付憑單資料輸入處理。〔購車款-應付/己付、保險費-應付/己付、牌照及其他應付/己付〕', 3);
INSERT INTO `des_function` VALUES (4, 3, 3, '款清確認輸入', '客戶車輛款清確認作業。', 5);
INSERT INTO `des_function` VALUES (4, 4, 4, '財務明細帳下載', '依起啟日期、結束日期、科目名稱產生財務明細帳 EXCEL表，並下載至指定位置，提供二次運用。', 3);
INSERT INTO `des_function` VALUES (4, 5, 5, '應收/已收憑單查詢', '依憑單、科目、合約、車身號….等條件查詢相關應收/已收憑單記錄。', 3);
INSERT INTO `des_function` VALUES (4, 6, 6, '應付/已付憑單查詢', '依憑單、科目、合約、車身號….等條件查詢相關應付/已付憑單記錄。', 3);
INSERT INTO `des_function` VALUES (4, 7, 7, '合約應/已收帳下載', '依統計分析產生目前合約應收已收未收明細 EXCEL表，並下載至指定位置，提供二次運用。', 3);
INSERT INTO `des_function` VALUES (4, 8, 8, '車輛應/已付帳下載', '依統計分析產生目前車輛應付已付未付明細 EXCEL表，並下載至指定位置，提供二次運用。', 3);
INSERT INTO `des_function` VALUES (4, 9, 9, '轉售佣金明細帳下載', '依合約轉售佣金及統計期間…等條件產生收款單 EXCEL表，提供二次運用及列印使用。 ', 3);
INSERT INTO `des_function` VALUES (4, 10, 10, '收款單下載列印', '依合約、憑單、科目….等條件產生收款單 EXCEL表，提供二次運用及列印使用。', 3);
INSERT INTO `des_function` VALUES (5, 1, 1, '照片/文件掃瞄上傳', '將己掃描存檔的文件資料或車輛照片〔編號及圖檔名〕上傳至系統。 ', 5);
INSERT INTO `des_function` VALUES (5, 2, 2, '照片/文件掃瞄查看', '將己掃描存檔至系統的文件資料或車輛照片調出查看。 ', 5);
INSERT INTO `des_function` VALUES (6, 1, 1, '可售車源表', '依查詢條件產生可售車源 EXCEL 明細表，提供二次運用。', 5);
INSERT INTO `des_function` VALUES (6, 2, 2, '成交客戶表', '依查詢條件產生成交客戶 EXCEL 明細表，提供二次運用。', 5);
INSERT INTO `des_function` VALUES (6, 3, 3, '空白合約書領用表', '依查詢條件產生空白合約書領用明細 EXCEL 明細表，提供二次運用。', 5);
INSERT INTO `des_function` VALUES (6, 4, 4, '業代銷售表', '依查詢條件產生業代銷售表 EXCEL 明細表，提供二次運用。', 5);
INSERT INTO `des_function` VALUES (6, 5, 5, '進/銷/存月報表', '依查詢條件產生進/銷/存月報 EXCEL 明細表，提供二次運用。', 5);
INSERT INTO `des_function` VALUES (6, 6, 6, '存貨天數與台數表', '依查詢條件產生存貨天數與台數 EXCEL 明細表，提供二次運用。', 5);
INSERT INTO `des_function` VALUES (7, 1, 1, '新增使用人員', '新增使用本系統人員、名稱、密碼。', 5);
INSERT INTO `des_function` VALUES (7, 2, 2, '修改刪除使用人員', '修改使用本系統人員、名稱、密碼、使用權限，及刪除使用本系統人員。', 5);
INSERT INTO `des_function` VALUES (7, 3, 3, '修改功能名稱權限', '修改子能功顯名示名稱、要求使用人員進入最低權限。', 5);
INSERT INTO `des_function` VALUES (7, 4, 4, '修改管理員帳號密碼', '修改管理員登入本系統的帳號、密碼。', 5);
INSERT INTO `des_function` VALUES (7, 5, 5, '使用人員查詢', '查詢現有全部使用人員名稱、帳號、密碼。', 5);
