会计科目和会计科目分类的两张mysql表，sql语句文件

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50713 Source Host : localhost:3306 Source Database : plastic_erp Target Server Type : MYSQL Target Server Version : 50713 File Encoding : 65001 Date: 2019-06-20 15:50:51 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `subject` -- ---------------------------- DROP TABLE IF EXISTS `subject`; CREATE TABLE `subject` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '会计科目ID', `code` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `subject_type_id` int(11) DEFAULT NULL COMMENT '会计科目分类Id', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=157 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of subject -- ---------------------------- INSERT INTO `subject` VALUES ('1', '1001', '库存现金', '1'); INSERT INTO `subject` VALUES ('2', '1002', '银行存款', '1'); INSERT INTO `subject` VALUES ('3', '1003', '存放中央银行款项', '1'); INSERT INTO `subject` VALUES ('4', '1011', '存放同业', '1'); INSERT INTO `subject` VALUES ('5', '1012', '其他货币资金', '1'); INSERT INTO `subject` VALUES ('6', '1021', '结算备付金', '1'); INSERT INTO `subject` VALUES ('7', '1031', '存出保证金', '1'); INSERT INTO `subject` VALUES ('8', '1101', '交易性金融资产', '1'); INSERT INTO `subject` VALUES ('9', '1111', '买入返售金融资产', '1'); INSERT INTO `subject` VALUES ('10', '1121', '应收票据', '1'); INSERT INTO `subject` VALUES ('11', '1122', '应收账款', '1'); INSERT INTO `subject` VALUES ('12', '1123', '预付账款', '1'); INSERT INTO `subject` VALUES ('13', '1131', '应收股利', '1'); INSERT INTO `subject` VALUES ('14', '1132', '应收利息', '1'); INSERT INTO `subject` VALUES ('15', '1201', '应收代位追偿款', '1'); INSERT INTO `subject` VALUES ('16', '1211', '应收分保账款', '1'); INSERT INTO `subject` VALUES ('17', '1212', '应收分保合同准备金', '1'); INSERT INTO `subject` VALUES ('18', '1221', '其他应收款', '1'); INSERT INTO `subject` VALUES ('19', '1231', '坏账准备', '1'); INSERT INTO `subject` VALUES ('20', '1301', '贴现资产', '1'); INSERT INTO `subject` VALUES ('21', '1302', '拆出资金', '1'); INSERT INTO `subject` VALUES ('22', '1303', '贷款', '1'); INSERT INTO `subject` VALUES ('23', '1304', '贷款损失准备', '1'); INSERT INTO `subject` VALUES ('24', '1311', '代理兑付证券', '1'); INSERT INTO `subject` VALUES ('25', '1321', '代理业务资产', '1'); INSERT INTO `subject` VALUES ('26', '1401', '材料采购', '1'); INSERT INTO `subject` VALUES ('27', '1402', '在途物资', '1'); INSERT INTO `subject` VALUES ('28', '1403', '原材料', '1'); INSERT INTO `subject` VALUES ('29', '1404', '材料成本差异', '1'); INSERT INTO `subject` VALUES ('30', '1405', '库存商品', '1'); INSERT INTO `subject` VALUES ('31', '1406', '发出商品', '1'); INSERT INTO `subject` VALUES ('32', '1407', '商品进销差价', '1'); INSERT INTO `subject` VALUES ('33', '1408', '委托加工物资', '1'); INSERT INTO `subject` VALUES ('34', '1411', '周转材料', '1'); INSERT INTO `subject` VALUES ('35', '1421', '消耗性生物资产', '1'); INSERT INTO `subject` VALUES ('36', '1431', '贵金属', '1'); INSERT INTO `subject` VALUES ('37', '1441', '抵债资产', '1'); INSERT INTO `subject` VALUES ('38', '1451', '损余物资', '1'); INSERT INTO `subject` VALUES ('39', '1461', '融资租赁资产', '1'); INSERT INTO `subject` VALUES ('40', '1471', '存货跌价准备', '1'); INSERT INTO `subject` VALUES ('41', '1501', '持有至到期投资', '1'); INSERT INTO `subject` VALUES ('42', '1502', '持有至到期投资减值准备', '1'); INSERT INTO `subject` VALUES ('43', '1503', '可供出售金融资产', '1'); INSERT INTO `subject` VALUES ('44', '1511', '长期股权投资', '1'); INSERT INTO `subject` VALUES ('45', '1512', '长期股权投资减值准备', '1'); INSERT INTO `subject` VALUES ('46', '1521', '投资性房地产', '1'); INSERT INTO `subject` VALUES ('47', '1531', '长期应收款', '1'); INSERT INTO `subject` VALUES ('48', '1532', '未实现融资收益', '1'); INSERT INTO `subject` VALUES ('49', '1541', '存出资本保证金', '1'); INSERT INTO `subject` VALUES ('50', '1601', '固定资产', '1'); INSERT INTO `subject` VALUES ('51', '1602', '累计折旧', '1'); INSERT INTO `subject` VALUES ('52', '1603', '固定资产减值准备', '1'); INSERT INTO `subject` VALUES ('53', '1604', '在建工程', '1'); INSERT INTO `subject` VALUES ('54', '1605', '工程物资', '1'); INSERT INTO `subject` VALUES ('55', '1606', '固定资产清理', '1'); INSERT INTO `subject` VALUES ('56', '1611', '未担保余值', '1'); INSERT INTO `subject` VALUES ('57', '1621', '生产性生物资产', '1'); INSERT INTO `subject` VALUES ('58', '1622', '生产性生物资产累计折旧', '1'); INSERT INTO `subject` VALUES ('59', '1623', '公益性生物资产', '1'); INSERT INTO `subject` VALUES ('60', '1631', '油气资产', '1'); INSERT INTO `subject` VALUES ('61', '1632', '累计折耗', '1'); INSERT INTO `subject` VALUES ('62', '1701', '无形资产', '1'); INSERT INTO `subject` VALUES ('63', '1702', '累计摊销', '1'); INSERT INTO `subject` VALUES ('64', '1703', '无形资产减值准备', '1'); INSERT INTO `subject` VALUES ('65', '1711', '商誉', '1'); INSERT INTO `subject` VALUES ('66', '1801', '长期待摊费用', '1'); INSERT INTO `subject` VALUES ('67', '1811', '递延所得税资产', '1'); INSERT INTO `subject` VALUES ('68', '1821', '独立账户资产', '1'); INSERT INTO `subject` VALUES ('69', '1901', '待处理财产损溢', '1'); INSERT INTO `subject` VALUES ('70', '2001', '短期借款', '2'); INSERT INTO `subject` VALUES ('71', '2002', '存入保证金', '2'); INSERT INTO `subject` VALUES ('72', '2003', '拆入资金', '2'); INSERT INTO `subject` VALUES ('73', '2004', '向中央银行借款', '2'); INSERT INTO `subject` VALUES ('74', '2011', '吸收存款', '2'); INSERT INTO `subject` VALUES ('75', '2012', '同业存放', '2'); INSERT INTO `subject` VALUES ('76', '2021', '贴现负债', '2'); INSERT INTO `subject` VALUES ('77', '2101', '交易性金融负债', '2'); INSERT INTO `subject` VALUES ('78', '2111', '卖出回购金融资产款', '2'); INSERT INTO `subject` VALUES ('79', '2201', '应付票据', '2'); INSERT INTO `subject` VALUES ('80', '2202', '应付账款', '2'); INSERT INTO `subject` VALUES ('81', '2203', '预收账款', '2'); INSERT INTO `subject` VALUES ('82', '2211', '应付职工薪酬', '2'); INSERT INTO `subject` VALUES ('83', '2221', '应交税费', '2'); INSERT INTO `subject` VALUES ('84', '2231', '应付利息', '2'); INSERT INTO `subject` VALUES ('85', '2232', '应付股利', '2'); INSERT INTO `subject` VALUES ('86', '2241', '其他应付款', '2'); INSERT INTO `subject` VALUES ('87', '2251', '应付保单红利', '2'); INSERT INTO `subject` VALUES ('88', '2261', '应付分保账款', '2'); INSERT INTO `subject` VALUES ('89', '2311', '代理买卖证券款', '2'); INSERT INTO `subject` VALUES ('90', '2312', '代理承销证券款', '2'); INSERT INTO `subject` VALUES ('91', '2313', '代理兑付证券款', '2'); INSERT INTO `subject` VALUES ('92', '2314', '代理业务负债', '2'); INSERT INTO `subject` VALUES ('93', '2401', '递延收益', '2'); INSERT INTO `subject` VALUES ('94', '2501', '长期借款', '2'); INSERT INTO `subject` VALUES ('95', '2502', '应付债券', '2'); INSERT INTO `subject` VALUES ('96', '2601', '未到期责任准备金', '2'); INSERT INTO `subject` VALUES ('97', '2602', '保险责任准备金', '2'); INSERT INTO `subject` VALUES ('98', '2611', '保户储金', '2'); INSERT INTO `subject` VALUES ('99', '2621', '独立账户负债', '2'); INSERT INTO `subject` VALUES ('100', '2701', '长期应付款', '2'