-
Notifications
You must be signed in to change notification settings - Fork 7
Expand file tree
/
Copy pathsqlscripts.sql
More file actions
228 lines (202 loc) · 119 KB
/
Copy pathsqlscripts.sql
File metadata and controls
228 lines (202 loc) · 119 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
-- MySQL dump 10.13 Distrib 8.0.19, for Win64 (x86_64)
--
-- Host: 192.168.11.102 Database: cmfpid2.0
-- ------------------------------------------------------
-- Server version 5.7.13-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `biz_outfield_group_detail`
--
DROP TABLE IF EXISTS `biz_outfield_group_detail`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `biz_outfield_group_detail` (
`id` char(32) NOT NULL,
`outfield_id` varchar(100) DEFAULT NULL COMMENT '输出字段的ID',
`unit` varchar(50) DEFAULT NULL COMMENT '输出字段的计量单位',
`outfield_sn` double DEFAULT '0' COMMENT '输出字段的顺序',
`group_info_id` char(32) DEFAULT NULL COMMENT '分组信息的ID',
`chinesename` varchar(100) DEFAULT NULL COMMENT '中文名称',
`formula` varchar(200) DEFAULT NULL,
`data_type` varchar(1) DEFAULT NULL COMMENT '数据的类型（1:日期时间(yyyy-MM-dd HH:mm:ss),2:数字枚举,3:数据,4:其他,5:文本枚举,6:文本多枚举,7:多字段组合多枚举值,NULL 直接返回原始值）',
`field_name` varchar(50) DEFAULT NULL COMMENT '此字段仅起显示作用',
`decimals` varchar(10) DEFAULT NULL COMMENT '保留几位小数，默认值可为空',
`data_map` varchar(1255) DEFAULT NULL COMMENT '需要根据 data_type 类型，采用不同的数据转换方式',
`is_analysable` int(11) DEFAULT '0' COMMENT '是否可用来进行数据分析，以对车辆进行问题排查。一般情况下，是具有一定意义的数据或状态值，多指标对比来分析问题。\\n0、不可分析；1、可分析；2、默认分析项',
`is_delete` int(11) DEFAULT '0' COMMENT '是否删除 0、未删除；1、已删除',
`isAlarm` varchar(1) DEFAULT '0' COMMENT '是否为软件报警项：1-报警项 0-非报警项',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `biz_outfield_group_detail`
--
LOCK TABLES `biz_outfield_group_detail` WRITE;
/*!40000 ALTER TABLE `biz_outfield_group_detail` DISABLE KEYS */;
INSERT INTO `biz_outfield_group_detail` VALUES ('003adfedd79d11e9b2f2000c29140042','4250','%',4,'31','摩擦扭矩',NULL,'3',NULL,NULL,NULL,1,0,'0'),('003adfedd79d11e9b2f2000c2914004c','4250','%',4,'25','摩擦扭矩',NULL,'3',NULL,NULL,NULL,1,0,'0'),('00739ad16edc11e9a45b000c2914004c','4177','℃',11,'24','发动机冷却水温度',NULL,NULL,'发动机冷却水温度',NULL,NULL,0,0,'0'),('0260a12b8c4bebb38205331d49412e5e','3014',NULL,7,'49',NULL,NULL,'1','GPS时间',NULL,NULL,1,0,'0'),('045a0b78b448167505e8d853e82ce3e3','4182','',15,'50','主离合状态','','2','mainClutchState','','0-脱开,1-结合,2-错误,3-无效',1,0,'0'),('04a4cb19d79d11e9b2f2000c29140043','4101','rpm',5,'31','发动机转速',NULL,'3',NULL,NULL,NULL,1,0,'0'),('04a4cb19d79d11e9b2f2000c2914004c','4101','rpm',5,'25','发动机转速',NULL,'3',NULL,NULL,NULL,1,0,'0'),('0692dab5d10b11e8a45b000c29140015','4288','%',21,'30','发动机负荷系数',NULL,'3','发动机负荷系数',NULL,NULL,1,0,'0'),('0692dab5d10b11e8a45b000c2914004c','4288','%',21,'20','发动机负荷系数',NULL,'3','发动机负荷系数',NULL,NULL,1,0,'0'),('07cac9c4950045de96c98733e045dc12','4100','℃',3,'338698becb2b4b38ac6d5cecc29dbe99','冷却水温','','3','coolantTemp','0','',1,0,'1'),('08c3e6dbd79d11e9b2f2000c29140044','6039','L/h',6,'31','发动机燃料流量',NULL,'3',NULL,NULL,NULL,1,0,'0'),('08c3e6dbd79d11e9b2f2000c2914004c','6039','L/h',6,'25','发动机燃料流量',NULL,'3',NULL,NULL,NULL,1,0,'0'),('08e3189232fe7b829635f5b5c1308465','4002',NULL,2,'52','开关量状态-MOTO',NULL,'2',NULL,NULL,'0-有启动信号,1-无启动信号',1,0,'0'),('0a72a3318b1a416f85cd6ac1b28b6617','4113','%',14,'338698becb2b4b38ac6d5cecc29dbe99','燃油位','','3','fuelLevel','0','',1,0,'1'),('0ac97cced79e11e9b2f2000c2914004c','6000',NULL,1,'26','诊断协议',NULL,'2',NULL,NULL,'0-ISO 15765,1-ISO 27145,2-SAE J1939,3-ISO 15031,254-无效',1,0,'0'),('0ac97cced79e11e9b2f2000c29140059','6000',NULL,1,'32','诊断协议',NULL,'2',NULL,NULL,'0-ISO 15765,1-ISO 27145,2-SAE J1939,3-ISO 15031,254-无效',1,0,'0'),('0c01280d91fb4113af3960b175c53dd6','4118','H',10,'338698becb2b4b38ac6d5cecc29dbe99','工作时间','x/10','3','workTime','1','',1,0,'1'),('0cf4087fd79d11e9b2f2000c29140045','6040','ppm',7,'31','SCR上游NOx传感器输出值',NULL,'3',NULL,NULL,NULL,1,0,'0'),('0cf4087fd79d11e9b2f2000c2914004c','6040','ppm',7,'25','SCR上游NOx传感器输出值',NULL,'3',NULL,NULL,NULL,1,0,'0'),('0df58102d893253d204cb442b4b4e4bc','-1',NULL,4,'49','当前位置',NULL,NULL,'当前位置(xml文件中不存在)',NULL,NULL,0,0,'0'),('0e8e0984b39e942d1a215e046ca82526','3019',NULL,5,'49',NULL,NULL,NULL,'GPS模块状态',NULL,NULL,1,0,'0'),('0fc4f481d79e11e9b2f2000c2914004c','4347',NULL,2,'26','MIL报警灯状态',NULL,'2',NULL,NULL,'0-未点亮,1-点亮',1,0,'0'),('0fc4f481d79e11e9b2f2000c29140060','4347',NULL,2,'32','MIL报警灯状态',NULL,'2',NULL,NULL,'0-未点亮,1-点亮',1,0,'0'),('1','2602',NULL,1,'1',NULL,NULL,NULL,'经度',NULL,NULL,0,0,'0'),('10','3012',NULL,10,'1',NULL,NULL,NULL,'方向',NULL,NULL,0,0,'0'),('10b79b86c97e11e9bab7d0946600e1f1','2601',NULL,5,'17','定位状态',NULL,'2','定位状态',NULL,'0-已定位,1-未定位',1,0,'0'),('11','4163','H',30,'2',NULL,'x/3600',NULL,'发动机工作时间',NULL,NULL,0,0,'0'),('110','2602',NULL,1,'8',NULL,NULL,NULL,'经度',NULL,NULL,0,0,'0'),('110b3229d79d11e9b2f2000c29140046','6041','ppm',8,'31','SCR下游NOx传感器输出值',NULL,'3',NULL,NULL,NULL,1,0,'0'),('110b3229d79d11e9b2f2000c2914004c','6041','ppm',8,'25','SCR下游NOx传感器输出值',NULL,'3',NULL,NULL,NULL,1,0,'0'),('111','2603',NULL,2,'8',NULL,NULL,NULL,'纬度',NULL,NULL,0,0,'0'),('11110ef06edb11e9a45b000c2914004c','4284','KPa',3,'24','发动机进气压力',NULL,NULL,'发动机进气压力',NULL,NULL,0,0,'0'),('112','-1',NULL,3,'8','当前位置',NULL,NULL,'当前位置(xml文件中不存在)',NULL,NULL,0,0,'0'),('113','3019',NULL,4,'8',NULL,NULL,NULL,'GPS模块状态',NULL,NULL,0,0,'0'),('114','2204',NULL,5,'8','GPS速度',NULL,NULL,'GPS速度',NULL,NULL,0,0,'0'),('115','3014',NULL,6,'8',NULL,NULL,'1','GPS时间',NULL,NULL,0,0,'0'),('116','TIME',NULL,7,'8','回传时间',NULL,'1','接收时间',NULL,NULL,0,0,'0'),('117','4014',NULL,8,'8',NULL,NULL,NULL,'水平精度因子',NULL,NULL,0,0,'0'),('118','3012',NULL,9,'8',NULL,NULL,NULL,'方向',NULL,NULL,0,0,'0'),('119','4030',NULL,10,'8','作业车辆状态',NULL,NULL,'车辆状态',NULL,NULL,0,0,'0'),('12','4101',NULL,31,'2',NULL,NULL,NULL,'发动机转速',NULL,NULL,0,0,'0'),('120','4031',NULL,11,'8',NULL,NULL,NULL,'作业标识',NULL,NULL,0,0,'0'),('121','4032',NULL,12,'8',NULL,NULL,NULL,'实时亩数',NULL,NULL,0,0,'0'),('122','4033',NULL,13,'8',NULL,NULL,NULL,'作业时长',NULL,NULL,0,0,'0'),('123','4193',NULL,14,'8',NULL,NULL,NULL,'实时深度',NULL,NULL,0,0,'0'),('124','4194',NULL,15,'8',NULL,NULL,NULL,'实时合格率',NULL,NULL,0,0,'0'),('125','4195',NULL,16,'8',NULL,NULL,NULL,'深松传感器通讯故障',NULL,NULL,0,0,'0'),('125978f009a911eab2f2000c2914004c','2601',NULL,5,'39','GPS定位状态',NULL,'2','定位状态',NULL,'0-有效定位,1-无效定位',1,0,'0'),('125a632a09a911eab2f2000c2914004c','4350',NULL,0,'39','数据加密',NULL,'2','数据加密',NULL,'1-数据不加密,2-数据经过RSA算法加密,3-数据经过国密SM2算法加密,254-异常,255-无效',0,0,'0'),('125a649609a911eab2f2000c2914004c','2602',NULL,1,'39',NULL,NULL,'3','经度',NULL,NULL,1,0,'0'),('125a656a09a911eab2f2000c2914004c','3012',NULL,8,'39',NULL,NULL,'3','方向',NULL,NULL,1,0,'0'),('125a661b09a911eab2f2000c2914004c','2603',NULL,2,'39',NULL,NULL,'3','纬度',NULL,NULL,1,0,'0'),('125a66d109a911eab2f2000c2914004c','-1',NULL,14,'39','当前位置',NULL,NULL,'当前位置(xml文件中不存在)',NULL,NULL,0,0,'0'),('125a677f09a911eab2f2000c2914004c','3019',NULL,6,'39','GPS模块状态',NULL,'2','GPS模块状态',NULL,'0- 模块正常,1-模块异常',1,0,'0'),('125a682809a911eab2f2000c2914004c','2204',NULL,7,'39','GPS速度',NULL,'3','GPS速度',NULL,NULL,1,0,'0'),('125a68cb09a911eab2f2000c2914004c','3014',NULL,3,'39',NULL,NULL,'1','GPS时间',NULL,NULL,1,0,'0'),('125a696e09a911eab2f2000c2914004c','TIME',NULL,4,'39','回传时间',NULL,'1','接收时间',NULL,NULL,1,0,'0'),('125a6a1409a911eab2f2000c2914004c','4014',NULL,9,'39',NULL,NULL,'3','水平精度因子',NULL,NULL,1,0,'0'),('125a6b1009a911eab2f2000c2914004c','3013','m',11,'39','海拔高度',NULL,'3','海拔高度',NULL,NULL,1,0,'0'),('125a6c4b09a911eab2f2000c2914004c','3015',NULL,12,'39','使用卫星数',NULL,'3','使用卫星数',NULL,NULL,1,0,'0'),('125a6e0909a911eab2f2000c2914004c','3016',NULL,13,'39','可视卫星数',NULL,'3','可视卫星数',NULL,NULL,1,0,'0'),('126','4196',NULL,17,'8',NULL,NULL,NULL,'深松传感器角度值错误',NULL,NULL,0,0,'0'),('13','4100',NULL,32,'2',NULL,NULL,NULL,'冷却水温',NULL,NULL,0,0,'0'),('139b40e411bd11eab2f2000c2914004c','2601',NULL,5,'44','GPS定位状态',NULL,'2','定位状态',NULL,'0-有效定位,1-无效定位',1,0,'0'),('139c39cb11bd11eab2f2000c2914004c','4350',NULL,0,'44','数据加密',NULL,'2','数据加密',NULL,'1-数据不加密,2-数据经过RSA算法加密,3-数据经过国密SM2算法加密,254-异常,255-无效',0,0,'0'),('139c3b1411bd11eab2f2000c2914004c','2602',NULL,1,'44',NULL,NULL,'3','经度',NULL,NULL,1,0,'0'),('139c3bd211bd11eab2f2000c2914004c','3012',NULL,8,'44',NULL,NULL,'3','方向',NULL,NULL,1,0,'0'),('139c3c8811bd11eab2f2000c2914004c','2603',NULL,2,'44',NULL,NULL,'3','纬度',NULL,NULL,1,0,'0'),('139c3d2a11bd11eab2f2000c2914004c','-1',NULL,14,'44','当前位置',NULL,NULL,'当前位置(xml文件中不存在)',NULL,NULL,0,0,'0'),('139c3dd911bd11eab2f2000c2914004c','3019',NULL,6,'44','GPS模块状态',NULL,'2','GPS模块状态',NULL,'0- 模块正常,1-模块异常',1,0,'0'),('139c3ec311bd11eab2f2000c2914004c','2204',NULL,7,'44','GPS速度',NULL,'3','GPS速度',NULL,NULL,1,0,'0'),('139c3fa411bd11eab2f2000c2914004c','3014',NULL,3,'44',NULL,NULL,'1','GPS时间',NULL,NULL,1,0,'0'),('139c404a11bd11eab2f2000c2914004c','TIME',NULL,4,'44','回传时间',NULL,'1','接收时间',NULL,NULL,1,0,'0'),('139c40eb11bd11eab2f2000c2914004c','4014',NULL,9,'44',NULL,NULL,'3','水平精度因子',NULL,NULL,1,0,'0'),('139c42bd11bd11eab2f2000c2914004c','3013','m',11,'44','海拔高度',NULL,'3','海拔高度',NULL,NULL,1,0,'0'),('139c43a111bd11eab2f2000c2914004c','3015',NULL,12,'44','使用卫星数',NULL,'3','使用卫星数',NULL,NULL,1,0,'0'),('139c444611bd11eab2f2000c2914004c','3016',NULL,13,'44','可视卫星数',NULL,'3','可视卫星数',NULL,NULL,1,0,'0'),('13e5b17cd79e11e9b2f2000c2914004c','6037',NULL,3,'26','故障码总数',NULL,'3',NULL,NULL,NULL,1,0,'0'),('13e5b17cd79e11e9b2f2000c29140061','6037',NULL,3,'32','故障码总数',NULL,'3',NULL,NULL,NULL,1,0,'0'),('14','4173','℃',33,'2',NULL,NULL,NULL,'变速箱油温',NULL,NULL,0,0,'0'),('14a5375a488f4e45815e4658a116eaba','4261',NULL,19,'18','冷启动加热状态',NULL,'2','冷启动加热状态',NULL,'0-正常,1-不正常',1,0,'0'),('15','4176',NULL,34,'2',NULL,NULL,NULL,'环境温度',NULL,NULL,0,0,'0'),('15593f94d27911e8a45b000c29140016','4291',NULL,25,'30','车身故障DM1',NULL,NULL,'车身故障DM1',NULL,NULL,0,0,'0'),('15593f94d27911e8a45b000c2914004c','4291',NULL,25,'20','车身故障DM1',NULL,NULL,'车身故障DM1',NULL,NULL,0,0,'0'),('155b8093d79d11e9b2f2000c29140047','6042','%',9,'31','反应剂余量',NULL,'3',NULL,NULL,NULL,1,0,'0'),('155b8093d79d11e9b2f2000c2914004c','6042','%',9,'25','反应剂余量',NULL,'3',NULL,NULL,NULL,1,0,'0'),('16','4108','MPa',35,'2',NULL,'x/1000',NULL,'机油压力',NULL,NULL,0,0,'0'),('17','4109',NULL,36,'2',NULL,NULL,NULL,'大气压力',NULL,NULL,0,0,'0'),('17cc1636164644e5956c6005cc6c8171','3040','KM/H',16,'18','行驶速度',NULL,'3','CAN速度',NULL,NULL,1,0,'0'),('18','3040',NULL,37,'2',NULL,NULL,NULL,'CAN速度',NULL,NULL,0,0,'0'),('18095e17d79e11e9b2f2000c2914004c','6038',NULL,4,'26','故障码信息列表',NULL,'6',NULL,NULL,'separator-|,EG03100003117010001-冷却液高温报警,EG03100003117010101-发动机高温报警,EG03100003117010201-制动系统报警,EG03100003117010301-发动机超速报警,EG03100003117010401-发动机堵转报警,EG03100003117010501-加速踏板信号故障报警,EG03100003117010601-进气压力感知器线路报警,EG03100003117010701-进气温度感知器线路报警,EG03100003117010801-引擎增压系统故障报警,EG03100003117010901-引擎多缸失火报警',0,0,'0'),('18095e17d79e11e9b2f2000c29140062','6038',NULL,4,'32','故障码信息列表',NULL,'6',NULL,NULL,'separator-|,EG03100003117010001-冷却液高温报警,EG03100003117010101-发动机高温报警,EG03100003117010201-制动系统报警,EG03100003117010301-发动机超速报警,EG03100003117010401-发动机堵转报警,EG03100003117010501-加速踏板信号故障报警,EG03100003117010601-进气压力感知器线路报警,EG03100003117010701-进气温度感知器线路报警,EG03100003117010801-引擎增压系统故障报警,EG03100003117010901-引擎多缸失火报警',0,0,'0'),('19','4174',NULL,38,'2',NULL,NULL,NULL,'燃油消耗总量',NULL,NULL,0,0,'0'),('19231b41d79d11e9b2f2000c29140048','6043','kg/h',10,'31','进气量',NULL,'3',NULL,NULL,NULL,1,0,'0'),('19231b41d79d11e9b2f2000c2914004c','6043','kg/h',10,'25','进气量',NULL,'3',NULL,NULL,NULL,1,0,'0'),('1b7ff154753efa236506a784d609a89a','4010','V',12,'52','输入电压 2','x/1000','3',NULL,NULL,NULL,1,0,'0'),('1bfc422c13065f92f5f3a04a61a6beb2','4184','kN',27,'50','提升器右提升力','','3','rightLiftingFource','','',1,0,'0'),('1cd7beaad10b11e8a45b000c29140017','4289','%',22,'30','实际最大可用发动机-扭矩百分比',NULL,'3','实际最大可用发动机-扭矩百分比',NULL,NULL,1,0,'0'),('1cd7beaad10b11e8a45b000c2914004c','4289','%',22,'20','实际最大可用发动机-扭矩百分比',NULL,'3','实际最大可用发动机-扭矩百分比',NULL,NULL,1,0,'0'),('1cf0d67ad79d11e9b2f2000c29140049','6044','℃',11,'31','SCR入口温度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('1cf0d67ad79d11e9b2f2000c2914004c','6044','℃',11,'25','SCR入口温度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('1d91a33011bd11eab2f2000c2914004c','4288','%',21,'45','发动机负荷系数',NULL,'3','发动机负荷系数',NULL,NULL,1,0,'0'),('1d91a8cb11bd11eab2f2000c2914004c','4291',NULL,25,'45','车身故障DM1',NULL,NULL,'车身故障DM1',NULL,NULL,0,0,'0'),('1d91aa9611bd11eab2f2000c2914004c','4289','%',22,'45','实际最大可用发动机-扭矩百分比',NULL,'3','实际最大可用发动机-扭矩百分比',NULL,NULL,1,0,'0'),('1d91ac3711bd11eab2f2000c2914004c','4175','L/h',7,'45','燃油消耗率',NULL,'3','小时油耗',NULL,NULL,1,0,'0'),('1d91add411bd11eab2f2000c2914004c','4292',NULL,26,'45','车身故障DM2',NULL,NULL,'车身故障DM2',NULL,NULL,0,0,'0'),('1d91af4c11bd11eab2f2000c2914004c','4279','rpm',1,'45','理想发动机转速',NULL,'3','理想发动机转速',NULL,NULL,1,0,'0'),('1d91b0bc11bd11eab2f2000c2914004c','4110','kPa',15,'45','发动机增压压力',NULL,'3','增压压力',NULL,NULL,1,0,'0'),('1d945ec611bd11eab2f2000c2914004c','4280',NULL,3,'45','发动机等待启动灯',NULL,'2','发动机等待启动灯',NULL,'0-关闭,1-打开',1,0,'0'),('1d947aa711bd11eab2f2000c2914004c','4281',NULL,5,'45','发动机保护系统已关闭发动机',NULL,'2','发动机保护系统已关闭发动机',NULL,'0-关闭未激活,1-关闭已激活',1,0,'0'),('1d94861e11bd11eab2f2000c2914004c','4250','%',23,'45','标准摩擦-扭矩百分比',NULL,'3','摩擦扭矩百分比',NULL,NULL,1,0,'0'),('1d94878811bd11eab2f2000c2914004c','4282','KM/L',8,'45','即时燃油经济性',NULL,'3','即时燃油经济性',NULL,NULL,1,0,'0'),('1d9488a911bd11eab2f2000c2914004c','4290','%',24,'45','估计的发动机寄生损失-扭矩百分比',NULL,'3','估计的发动机寄生损失-扭矩百分比',NULL,NULL,1,0,'0'),('1d95a98011bd11eab2f2000c2914004c','4283','°C',13,'45','发动机进气管温度',NULL,'3','发动机进气管温度',NULL,NULL,1,0,'0'),('1d95ac1e11bd11eab2f2000c2914004c','4284','kPa',16,'45','发动机进气压力',NULL,'3','发动机进气压力',NULL,NULL,1,0,'0'),('1d95ad9f11bd11eab2f2000c2914004c','4243','℃',10,'45','发动机机油温度',NULL,'3','机油温度',NULL,NULL,1,0,'0'),('1d95af0c11bd11eab2f2000c2914004c','4023','L',6,'45','发动机总燃油量',NULL,'3','累计油耗',NULL,NULL,1,0,'0'),('1d95b07911bd11eab2f2000c2914004c','4101','rpm',0,'45','发动机转速',NULL,'3','发动机转速',NULL,NULL,2,0,'0'),('1d95b1c011bd11eab2f2000c2914004c','4108','mPa',4,'45','发动机机油压力','x/1000','3','机油压力',NULL,NULL,1,0,'0'),('1d95b32b11bd11eab2f2000c2914004c','4163','h',2,'45','发动机总工作小时数','x/3600','3','发动机工作时间',NULL,NULL,2,0,'0'),('1d95b52f11bd11eab2f2000c2914004c','4103','%',19,'45','实际发动机-扭矩百分比',NULL,'3','发动机实际扭矩',NULL,NULL,1,0,'0'),('1d95b6a811bd11eab2f2000c2914004c','4109','kPa',14,'45','大气压力',NULL,'3','大气压力',NULL,NULL,1,0,'0'),('1d95b8fc11bd11eab2f2000c2914004c','4112','°C',12,'45','空气进气温度',NULL,'3','进气温度',NULL,NULL,1,0,'0'),('1d95ba8711bd11eab2f2000c2914004c','4245','℃',11,'45','外界温度',NULL,'3','大气温度',NULL,NULL,1,0,'0'),('1d95bba711bd11eab2f2000c2914004c','4177','°C',9,'45','发动机冷却液温度',NULL,'3','冷却水温度',NULL,NULL,1,0,'0'),('1d95bca811bd11eab2f2000c2914004c','4285',NULL,17,'45','发动机扭矩模式',NULL,'3','发动机扭矩模式',NULL,NULL,1,0,'0'),('1d95be7d11bd11eab2f2000c2914004c','DATE_TYPE',NULL,-1,'45',NULL,NULL,NULL,NULL,NULL,NULL,0,0,'0'),('1d95bf9011bd11eab2f2000c2914004c','4286','%',18,'45','驾驶员要求的发动机-扭矩百分比',NULL,'3','驾驶员要求的发动机-扭矩百分比',NULL,NULL,1,0,'0'),('1d95c07b11bd11eab2f2000c2914004c','4287','%',20,'45','发动机需求-扭矩百分比',NULL,'3','发动机需求-扭矩百分比',NULL,NULL,1,0,'0'),('2','2603',NULL,2,'1',NULL,NULL,NULL,'纬度',NULL,NULL,0,0,'0'),('20','4162',NULL,39,'2','燃油量',NULL,NULL,'燃油量（液位）',NULL,NULL,0,0,'0'),('200','2602',NULL,1,'9',NULL,NULL,NULL,'经度',NULL,NULL,0,0,'0'),('201','2603',NULL,1,'9',NULL,NULL,NULL,'纬度',NULL,NULL,0,0,'0'),('202','-1',NULL,4,'9','当前位置',NULL,NULL,'当前位置(xml文件中不存在)',NULL,NULL,0,0,'0'),('203','3019',NULL,5,'9',NULL,NULL,NULL,'GPS模块状态',NULL,NULL,0,0,'0'),('204','2204',NULL,6,'9','GPS速度',NULL,NULL,'GPS速度',NULL,NULL,0,0,'0'),('205','3014',NULL,7,'9',NULL,NULL,'1','GPS时间',NULL,NULL,0,0,'0'),('20565d2dd11011e8a45b000c29140018','4175','L/h',7,'30','燃油消耗率',NULL,'3','小时油耗',NULL,NULL,1,0,'0'),('20565d2dd11011e8a45b000c2914004c','4175','L/h',7,'20','燃油消耗率',NULL,'3','小时油耗',NULL,NULL,1,0,'0'),('206','TIME',NULL,8,'9','回传时间',NULL,'1','接收时间',NULL,NULL,0,0,'0'),('207','4014',NULL,9,'9',NULL,NULL,NULL,'水平精度因子',NULL,NULL,0,0,'0'),('208','3012',NULL,10,'9',NULL,NULL,NULL,'方向',NULL,NULL,0,0,'0'),('209','4030',NULL,76,'9','作业车辆状态',NULL,NULL,'车辆状态',NULL,NULL,0,0,'0'),('21','4022',NULL,40,'2',NULL,NULL,NULL,'单次油耗',NULL,NULL,0,0,'0'),('210','4031',NULL,77,'9',NULL,NULL,NULL,'作业标识',NULL,NULL,0,0,'0'),('211','4032',NULL,78,'9',NULL,NULL,NULL,'实时亩数',NULL,NULL,0,0,'0'),('212','4033',NULL,79,'9',NULL,NULL,NULL,'作业时长',NULL,NULL,0,0,'0'),('213','4101',NULL,31,'10',NULL,NULL,NULL,'发动机转速',NULL,NULL,0,0,'0'),('214','4100',NULL,32,'10',NULL,NULL,NULL,'冷却水温',NULL,NULL,0,0,'0'),('215','4108','MPa',35,'10',NULL,'x/1000',NULL,'机油压力',NULL,NULL,0,0,'0'),('216','4162',NULL,39,'10','燃油量',NULL,NULL,'燃油量（液位）',NULL,NULL,0,0,'0'),('218','4164',NULL,42,'10',NULL,NULL,NULL,'系统电压',NULL,NULL,0,0,'0'),('219','3040',NULL,80,'10','行驶速度',NULL,NULL,'CAN速度',NULL,NULL,0,0,'0'),('22','4175','L/h',41,'2','每小时油耗',NULL,NULL,'瞬时油耗',NULL,NULL,0,0,'0'),('220','2205',NULL,53,'10',NULL,NULL,NULL,'总里程',NULL,NULL,0,0,'0'),('221','4182',NULL,68,'10',NULL,NULL,NULL,'主离合状态',NULL,NULL,0,0,'0'),('222','4183',NULL,81,'10',NULL,NULL,NULL,'提升器左提升力',NULL,NULL,0,0,'0'),('22260a822cbfe8350cedef9aa9887d0f','4354',NULL,17,'52','开壳告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('223','4184',NULL,82,'10',NULL,NULL,NULL,'提升器右提升力',NULL,NULL,0,0,'0'),('224','4185',NULL,83,'10',NULL,NULL,NULL,'机具离地高度',NULL,NULL,0,0,'0'),('225','4186',NULL,84,'10',NULL,NULL,NULL,'POT转速',NULL,NULL,0,0,'0'),('226','4187',NULL,85,'10',NULL,NULL,NULL,'液压系统压力',NULL,NULL,0,0,'0'),('22cf42fc21e259f203812e4612fd4028','4108','kPa',6,'50','机油压力','','3','engineOilPressure','','',1,0,'0'),('23','4164',NULL,42,'2',NULL,NULL,NULL,'系统电压',NULL,NULL,0,0,'0'),('24','4178','KN',43,'2','传感器1拉力值','(x-2.5)*25',NULL,'传感器1电压',NULL,NULL,0,0,'0'),('25','4179','KN',44,'2','传感器2拉力值','(x-2.5)*25',NULL,'传感器2电压',NULL,NULL,0,0,'0'),('27','3014',NULL,46,'2',NULL,NULL,'1','GPS时间',NULL,NULL,0,0,'0'),('277e7a3e11bd11eab2f2000c2914004c','4250','%',4,'46','摩擦扭矩',NULL,'3',NULL,NULL,NULL,1,0,'0'),('277e7dec11bd11eab2f2000c2914004c','4101','rpm',5,'46','发动机转速',NULL,'3',NULL,NULL,NULL,1,0,'0'),('278015fe11bd11eab2f2000c2914004c','6039','L/h',6,'46','发动机燃料流量',NULL,'3',NULL,NULL,NULL,1,0,'0'),('2780194711bd11eab2f2000c2914004c','6040','ppm',7,'46','SCR上游NOx传感器输出值',NULL,'3',NULL,NULL,NULL,1,0,'0'),('27801a1611bd11eab2f2000c2914004c','6041','ppm',8,'46','SCR下游NOx传感器输出值',NULL,'3',NULL,NULL,NULL,1,0,'0'),('27801aad11bd11eab2f2000c2914004c','6042','%',9,'46','反应剂余量',NULL,'3',NULL,NULL,NULL,1,0,'0'),('27801b4511bd11eab2f2000c2914004c','6043','kg/h',10,'46','进气量',NULL,'3',NULL,NULL,NULL,1,0,'0'),('27801be611bd11eab2f2000c2914004c','6044','℃',11,'46','SCR入口温度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('27801c7d11bd11eab2f2000c2914004c','6045','℃',12,'46','SCR出口温度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('27801d0b11bd11eab2f2000c2914004c','6046','kPa',13,'46','DPF压差',NULL,'3',NULL,NULL,NULL,1,0,'0'),('27801d9611bd11eab2f2000c2914004c','4177','℃',14,'46','发动机冷却液温度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('27801e2c11bd11eab2f2000c2914004c','4162','%',15,'46','油箱液位',NULL,'3',NULL,NULL,NULL,1,0,'0'),('27801ebb11bd11eab2f2000c2914004c','4348','%',16,'46','实际EGR阀开度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('27801f6211bd11eab2f2000c2914004c','4349','%',17,'46','设定的EGR阀开度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('27801ff211bd11eab2f2000c2914004c','3040','km/h',1,'46','车速',NULL,'3',NULL,NULL,NULL,1,0,'0'),('2780208311bd11eab2f2000c2914004c','4109','kPa',2,'46','大气压力',NULL,'3',NULL,NULL,NULL,1,0,'0'),('2780210b11bd11eab2f2000c2914004c','4103','%',3,'46','发动机净输出扭矩',NULL,'3',NULL,NULL,NULL,1,0,'0'),('27f9c48e469c89377e296896a3fb5ffa','3014','',8,'4b0bcd3b652b4f078f46cc5ef7768a8b','','','1','GPS时间','0','',1,0,'1'),('28','TIME',NULL,47,'2','回传时间',NULL,'1','接收时间',NULL,NULL,0,0,'0'),('29','4021',NULL,48,'2','FMI',NULL,NULL,'故障码MFI列表',NULL,NULL,0,0,'0'),('2aa73fb4d79d11e9b2f2000c2914004c','6045','℃',12,'25','SCR出口温度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('2aa73fb4d79d11e9b2f2000c29140050','6045','℃',12,'31','SCR出口温度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('2c133a156edb11e9a45b000c2914004c','4247','%',4,'24','发动机负荷',NULL,NULL,'发动机负荷',NULL,NULL,0,0,'0'),('2c707a4cdeff134704b2090405a979fe','4253','%',5,'50','机油液位','','3','oilLevel','','',1,0,'0'),('2ecaa220d79d11e9b2f2000c2914004c','6046','kPa',13,'25','DPF压差',NULL,'3',NULL,NULL,NULL,1,0,'0'),('2ecaa220d79d11e9b2f2000c29140051','6046','kPa',13,'31','DPF压差',NULL,'3',NULL,NULL,NULL,1,0,'0'),('2f5fa399455a82b6789ca2bad718d962','4186','RPM',16,'50','PTO转速','','3','POTRevs','','',1,0,'0'),('30','4020',NULL,49,'2','SPN',NULL,NULL,'故障码SPN列表',NULL,NULL,0,0,'0'),('3020f8e4d27911e8a45b000c29140019','4292',NULL,26,'30','车身故障DM2',NULL,NULL,'车身故障DM2',NULL,NULL,0,0,'0'),('3020f8e4d27911e8a45b000c2914004c','4292',NULL,26,'20','车身故障DM2',NULL,NULL,'车身故障DM2',NULL,NULL,0,0,'0'),('30b88bf111bd11eab2f2000c2914004c','6000',NULL,1,'47','诊断协议',NULL,'2',NULL,NULL,'0-ISO 15765,1-ISO 27145,2-SAE J1939,3-ISO 15031,254-无效',1,0,'0'),('30b890c411bd11eab2f2000c2914004c','4347',NULL,2,'47','MIL报警灯状态',NULL,'2',NULL,NULL,'0-未点亮,1-点亮',1,0,'0'),('30b891b811bd11eab2f2000c2914004c','6037',NULL,3,'47','故障码总数',NULL,'3',NULL,NULL,NULL,1,0,'0'),('30b8926811bd11eab2f2000c2914004c','6038',NULL,4,'47','故障码信息列表',NULL,'6',NULL,NULL,'separator-|,EG03100003117010001-冷却液高温报警,EG03100003117010101-发动机高温报警,EG03100003117010201-制动系统报警,EG03100003117010301-发动机超速报警,EG03100003117010401-发动机堵转报警,EG03100003117010501-加速踏板信号故障报警,EG03100003117010601-进气压力感知器线路报警,EG03100003117010701-进气温度感知器线路报警,EG03100003117010801-引擎增压系统故障报警,EG03100003117010901-引擎多缸失火报警',0,0,'0'),('31','4180',NULL,73,'2','行驶里程',NULL,NULL,'行驶里程',NULL,NULL,0,0,'0'),('31fecf73eb41beda59c4404be76c6fe4','4176','℃',21,'50','环境温度','','3','ambientTemp','','',1,0,'0'),('331bae64d79d11e9b2f2000c2914004c','4177','℃',14,'25','发动机冷却液温度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('331bae64d79d11e9b2f2000c29140052','4177','℃',14,'31','发动机冷却液温度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3570caa0d10a11e8a45b000c29140020','4279','rpm',1,'30','理想发动机转速',NULL,'3','理想发动机转速',NULL,NULL,1,0,'0'),('3570caa0d10a11e8a45b000c2914004c','4279','rpm',1,'20','理想发动机转速',NULL,'3','理想发动机转速',NULL,NULL,1,0,'0'),('36bfafcad79d11e9b2f2000c2914004c','4162','%',15,'25','油箱液位',NULL,'3',NULL,NULL,NULL,1,0,'0'),('36bfafcad79d11e9b2f2000c29140053','4162','%',15,'31','油箱液位',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3755280fafd94ecd4ee424081e5ed834','3013','M',11,'49','海拔高度',NULL,'3','海拔高度',NULL,NULL,0,0,'0'),('37fdd43111bd11eab2f2000c2914004c','4001',NULL,1,'48','开关量状态-ACC',NULL,'2',NULL,NULL,'0-电钥匙关闭,1- 电钥匙打开',1,0,'0'),('37fdd7f811bd11eab2f2000c2914004c','4002',NULL,2,'48','开关量状态-MOTO',NULL,'2',NULL,NULL,'0-有启动信号,1-无启动信号',1,0,'0'),('37fdd91211bd11eab2f2000c2914004c','4003',NULL,3,'48','开关量状态-电平 1',NULL,'2',NULL,NULL,'0-低电平,1-高电平',1,0,'0'),('37fdda2e11bd11eab2f2000c2914004c','4004',NULL,4,'48','开关量状态-电平 2',NULL,'2',NULL,NULL,'0-低电平,1- 高电平',1,0,'0'),('37fddb2a11bd11eab2f2000c2914004c','3020',NULL,5,'48','ACC状态',NULL,'5',NULL,NULL,'电钥匙打开-打开-1,电钥匙关闭-关闭-0',1,0,'0'),('37fddcd311bd11eab2f2000c2914004c','3021',NULL,6,'48','终端 MOTO 状态',NULL,NULL,NULL,NULL,NULL,1,0,'0'),('37fddd9e11bd11eab2f2000c2914004c','4005','Hz',7,'48','FRQ1 输入',NULL,'3',NULL,NULL,NULL,1,0,'0'),('37fdde4411bd11eab2f2000c2914004c','4006','Hz',8,'48','FRQ2 输入',NULL,'3',NULL,NULL,NULL,1,0,'0'),('37fddee411bd11eab2f2000c2914004c','4007','Hz',9,'48','PWM1 输出频率',NULL,'3',NULL,NULL,NULL,1,0,'0'),('37fddf8611bd11eab2f2000c2914004c','4008','Hz',10,'48','PWM2 输出频率',NULL,'3',NULL,NULL,NULL,1,0,'0'),('37fde02211bd11eab2f2000c2914004c','4009','mv',11,'48','输入电压 1',NULL,'3',NULL,NULL,NULL,1,0,'0'),('37fde17b11bd11eab2f2000c2914004c','4010','mv',12,'48','输入电压 2',NULL,'3',NULL,NULL,NULL,1,0,'0'),('37fde2ce11bd11eab2f2000c2914004c','4011','mv',13,'48','输入电源电压',NULL,'3',NULL,NULL,NULL,1,0,'0'),('37fde40411bd11eab2f2000c2914004c','4012','mv',14,'48','输入电池电压',NULL,'3',NULL,NULL,NULL,1,0,'0'),('37fde53f11bd11eab2f2000c2914004c','3006',NULL,20,'48','固件版本号',NULL,NULL,NULL,NULL,NULL,1,0,'0'),('37fde6a311bd11eab2f2000c2914004c','3007',NULL,21,'48','硬件版本号',NULL,NULL,NULL,NULL,NULL,1,0,'0'),('37fde80b11bd11eab2f2000c2914004c','4352',NULL,15,'48','外壳状态',NULL,'2',NULL,NULL,'0-外壳关闭,1-外壳打开',1,0,'0'),('37fde94b11bd11eab2f2000c2914004c','4353',NULL,16,'48','拆除告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('37fdeaad11bd11eab2f2000c2914004c','4354',NULL,17,'48','开壳告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('37fdebe811bd11eab2f2000c2914004c','4355',NULL,18,'48','GPS 天线告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('37fe756f11bd11eab2f2000c2914004c','4356',NULL,19,'48','CAN 异常告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('3860a15fb7fda08f83c972f9b67fa960','4012','V',3,'0ad4727a2920487cb436822b9da78c1a','备用电池电压','x/1000','3','输入电池电压',NULL,NULL,1,0,'0'),('3ab4d2cad79d11e9b2f2000c2914004c','4348','%',16,'25','实际EGR阀开度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3ab4d2cad79d11e9b2f2000c29140054','4348','%',16,'31','实际EGR阀开度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c2682c409a911eab2f2000c2914004c','4288','%',21,'40','发动机负荷系数',NULL,'3','发动机负荷系数',NULL,NULL,1,0,'0'),('3c26897c09a911eab2f2000c2914004c','4291',NULL,25,'40','车身故障DM1',NULL,NULL,'车身故障DM1',NULL,NULL,0,0,'0'),('3c268af209a911eab2f2000c2914004c','4289','%',22,'40','实际最大可用发动机-扭矩百分比',NULL,'3','实际最大可用发动机-扭矩百分比',NULL,NULL,1,0,'0'),('3c268bbb09a911eab2f2000c2914004c','4175','L/h',7,'40','燃油消耗率',NULL,'3','小时油耗',NULL,NULL,1,0,'0'),('3c268c8009a911eab2f2000c2914004c','4292',NULL,26,'40','车身故障DM2',NULL,NULL,'车身故障DM2',NULL,NULL,0,0,'0'),('3c268d9f09a911eab2f2000c2914004c','4279','rpm',1,'40','理想发动机转速',NULL,'3','理想发动机转速',NULL,NULL,1,0,'0'),('3c268e9b09a911eab2f2000c2914004c','4110','kPa',15,'40','发动机增压压力',NULL,'3','增压压力',NULL,NULL,1,0,'0'),('3c268fd509a911eab2f2000c2914004c','4280',NULL,3,'40','发动机等待启动灯',NULL,'2','发动机等待启动灯',NULL,'0-关闭,1-打开',1,0,'0'),('3c26909d09a911eab2f2000c2914004c','4281',NULL,5,'40','发动机保护系统已关闭发动机',NULL,'2','发动机保护系统已关闭发动机',NULL,'0-关闭未激活,1-关闭已激活',1,0,'0'),('3c2691b309a911eab2f2000c2914004c','4250','%',23,'40','标准摩擦-扭矩百分比',NULL,'3','摩擦扭矩百分比',NULL,NULL,1,0,'0'),('3c26931609a911eab2f2000c2914004c','4282','KM/L',8,'40','即时燃油经济性',NULL,'3','即时燃油经济性',NULL,NULL,1,0,'0'),('3c26941909a911eab2f2000c2914004c','4290','%',24,'40','估计的发动机寄生损失-扭矩百分比',NULL,'3','估计的发动机寄生损失-扭矩百分比',NULL,NULL,1,0,'0'),('3c2694c809a911eab2f2000c2914004c','4283','°C',13,'40','发动机进气管温度',NULL,'3','发动机进气管温度',NULL,NULL,1,0,'0'),('3c26956909a911eab2f2000c2914004c','4284','kPa',16,'40','发动机进气压力',NULL,'3','发动机进气压力',NULL,NULL,1,0,'0'),('3c26961609a911eab2f2000c2914004c','4243','℃',10,'40','发动机机油温度',NULL,'3','机油温度',NULL,NULL,1,0,'0'),('3c2696b709a911eab2f2000c2914004c','4023','L',6,'40','发动机总燃油量',NULL,'3','累计油耗',NULL,NULL,1,0,'0'),('3c26975a09a911eab2f2000c2914004c','4101','rpm',0,'40','发动机转速',NULL,'3','发动机转速',NULL,NULL,2,0,'0'),('3c2697fa09a911eab2f2000c2914004c','4108','mPa',4,'40','发动机机油压力','x/1000','3','机油压力',NULL,NULL,1,0,'0'),('3c2698a109a911eab2f2000c2914004c','4163','h',2,'40','发动机总工作小时数','x/3600','3','发动机工作时间',NULL,NULL,2,0,'0'),('3c26995309a911eab2f2000c2914004c','4103','%',19,'40','实际发动机-扭矩百分比',NULL,'3','发动机实际扭矩',NULL,NULL,1,0,'0'),('3c269a7609a911eab2f2000c2914004c','4109','kPa',14,'40','大气压力',NULL,'3','大气压力',NULL,NULL,1,0,'0'),('3c269bca09a911eab2f2000c2914004c','4112','°C',12,'40','空气进气温度',NULL,'3','进气温度',NULL,NULL,1,0,'0'),('3c269d2a09a911eab2f2000c2914004c','4245','℃',11,'40','外界温度',NULL,'3','大气温度',NULL,NULL,1,0,'0'),('3c269e2409a911eab2f2000c2914004c','4177','°C',9,'40','发动机冷却液温度',NULL,'3','冷却水温度',NULL,NULL,1,0,'0'),('3c269ecd09a911eab2f2000c2914004c','4285',NULL,17,'40','发动机扭矩模式',NULL,'3','发动机扭矩模式',NULL,NULL,1,0,'0'),('3c269f6909a911eab2f2000c2914004c','DATE_TYPE',NULL,-1,'40',NULL,NULL,NULL,NULL,NULL,NULL,0,0,'0'),('3c26a00a09a911eab2f2000c2914004c','4286','%',18,'40','驾驶员要求的发动机-扭矩百分比',NULL,'3','驾驶员要求的发动机-扭矩百分比',NULL,NULL,1,0,'0'),('3c26a0ab09a911eab2f2000c2914004c','4287','%',20,'40','发动机需求-扭矩百分比',NULL,'3','发动机需求-扭矩百分比',NULL,NULL,1,0,'0'),('3c80be21da0111e9b2f2000c2914004c','4001',NULL,1,'27','开关量状态-ACC',NULL,'2',NULL,NULL,'0-电钥匙关闭,1- 电钥匙打开',1,0,'0'),('3c80be21da0111e9b2f2000c29140063','4001',NULL,1,'33','开关量状态-ACC',NULL,'2',NULL,NULL,'0-电钥匙关闭,1- 电钥匙打开',1,0,'0'),('3c80be4cda0111e9b2f2000c2914004c','4002',NULL,2,'27','开关量状态-MOTO',NULL,'2',NULL,NULL,'0-有启动信号,1-无启动信号',1,0,'0'),('3c80be4cda0111e9b2f2000c29140064','4002',NULL,2,'33','开关量状态-MOTO',NULL,'2',NULL,NULL,'0-有启动信号,1-无启动信号',1,0,'0'),('3c80be56da0111e9b2f2000c2914004c','4003',NULL,3,'27','开关量状态-电平 1',NULL,'2',NULL,NULL,'0-低电平,1-高电平',1,0,'0'),('3c80be56da0111e9b2f2000c29140065','4003',NULL,3,'33','开关量状态-电平 1',NULL,'2',NULL,NULL,'0-低电平,1-高电平',1,0,'0'),('3c80be61da0111e9b2f2000c2914004c','4004',NULL,4,'27','开关量状态-电平 2',NULL,'2',NULL,NULL,'0-低电平,1- 高电平',1,0,'0'),('3c80be61da0111e9b2f2000c29140066','4004',NULL,4,'33','开关量状态-电平 2',NULL,'2',NULL,NULL,'0-低电平,1- 高电平',1,0,'0'),('3c80be68da0111e9b2f2000c2914004c','3020',NULL,5,'27','ACC状态',NULL,'5',NULL,NULL,'电钥匙打开-打开-1,电钥匙关闭-关闭-0',2,0,'0'),('3c80be68da0111e9b2f2000c29140067','3020',NULL,5,'33','ACC状态',NULL,'5',NULL,NULL,'电钥匙打开-打开-1,电钥匙关闭-关闭-0',1,0,'0'),('3c80be6eda0111e9b2f2000c2914004c','3021',NULL,6,'27','终端 MOTO 状态',NULL,NULL,NULL,NULL,NULL,1,0,'0'),('3c80be6eda0111e9b2f2000c29140068','3021',NULL,6,'33','终端 MOTO 状态',NULL,NULL,NULL,NULL,NULL,1,0,'0'),('3c80be75da0111e9b2f2000c2914004c','4005','Hz',7,'27','FRQ1 输入',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c80be75da0111e9b2f2000c29140069','4005','Hz',7,'33','FRQ1 输入',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c80be7bda0111e9b2f2000c2914004c','4006','Hz',8,'27','FRQ2 输入',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c80be7bda0111e9b2f2000c29140070','4006','Hz',8,'33','FRQ2 输入',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c80be81da0111e9b2f2000c2914004c','4007','Hz',9,'27','PWM1 输出频率',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c80be81da0111e9b2f2000c29140071','4007','Hz',9,'33','PWM1 输出频率',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c80be87da0111e9b2f2000c2914004c','4008','Hz',10,'27','PWM2 输出频率',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c80be87da0111e9b2f2000c29140072','4008','Hz',10,'33','PWM2 输出频率',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c80be8eda0111e9b2f2000c2914004c','4009','mv',11,'27','输入电压 1',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c80be8eda0111e9b2f2000c29140073','4009','mv',11,'33','输入电压 1',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c80be94da0111e9b2f2000c2914004c','4010','mv',12,'27','输入电压 2',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c80be94da0111e9b2f2000c29140074','4010','mv',12,'33','输入电压 2',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c80be9ada0111e9b2f2000c2914004c','4011','mv',13,'27','输入电源电压',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c80be9ada0111e9b2f2000c29140075','4011','mv',13,'33','输入电源电压',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c80bea0da0111e9b2f2000c2914004c','4012','mv',14,'27','输入电池电压',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3c80bea0da0111e9b2f2000c29140076','4012','mv',14,'33','输入电池电压',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3d815fb1d8f811e9b2f2000c29140001','2601',NULL,5,'29','GPS定位状态',NULL,'2','定位状态',NULL,'0-有效定位,1-无效定位',1,0,'0'),('3d815fb1d8f811e9b2f2000c2914004c','2601',NULL,5,'19','GPS定位状态',NULL,'2','定位状态',NULL,'0-有效定位,1-无效定位',1,0,'0'),('3ea97f04d79d11e9b2f2000c2914004c','4349','%',17,'25','设定的EGR阀开度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('3ea97f04d79d11e9b2f2000c29140055','4349','%',17,'31','设定的EGR阀开度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('4','-1',NULL,4,'1','当前位置',NULL,NULL,'当前位置(xml文件中不存在)',NULL,NULL,0,0,'0'),('405f457c09a911eab2f2000c2914004c','4250','%',4,'41','摩擦扭矩',NULL,'3',NULL,NULL,NULL,1,0,'0'),('405f496809a911eab2f2000c2914004c','4101','rpm',5,'41','发动机转速',NULL,'3',NULL,NULL,NULL,1,0,'0'),('4062836609a911eab2f2000c2914004c','6039','L/h',6,'41','发动机燃料流量',NULL,'3',NULL,NULL,NULL,1,0,'0'),('4062850409a911eab2f2000c2914004c','6040','ppm',7,'41','SCR上游NOx传感器输出值',NULL,'3',NULL,NULL,NULL,1,0,'0'),('4065759e09a911eab2f2000c2914004c','6041','ppm',8,'41','SCR下游NOx传感器输出值',NULL,'3',NULL,NULL,NULL,1,0,'0'),('4065772809a911eab2f2000c2914004c','6042','%',9,'41','反应剂余量',NULL,'3',NULL,NULL,NULL,1,0,'0'),('4065782309a911eab2f2000c2914004c','6043','kg/h',10,'41','进气量',NULL,'3',NULL,NULL,NULL,1,0,'0'),('40657d7309a911eab2f2000c2914004c','6044','℃',11,'41','SCR入口温度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('40657ea009a911eab2f2000c2914004c','6045','℃',12,'41','SCR出口温度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('40657fff09a911eab2f2000c2914004c','6046','kPa',13,'41','DPF压差',NULL,'3',NULL,NULL,NULL,1,0,'0'),('406580f109a911eab2f2000c2914004c','4177','℃',14,'41','发动机冷却液温度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('406581c609a911eab2f2000c2914004c','4162','%',15,'41','油箱液位',NULL,'3',NULL,NULL,NULL,1,0,'0'),('4065828d09a911eab2f2000c2914004c','4348','%',16,'41','实际EGR阀开度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('4065837c09a911eab2f2000c2914004c','4349','%',17,'41','设定的EGR阀开度',NULL,'3',NULL,NULL,NULL,1,0,'0'),('4065844f09a911eab2f2000c2914004c','3040','km/h',1,'41','车速',NULL,'3',NULL,NULL,NULL,1,0,'0'),('4065851109a911eab2f2000c2914004c','4109','kPa',2,'41','大气压力',NULL,'3',NULL,NULL,NULL,1,0,'0'),('406585dc09a911eab2f2000c2914004c','4103','%',3,'41','发动机净输出扭矩',NULL,'3',NULL,NULL,NULL,1,0,'0'),('408715c30cc811cbed4f9135675f3ab0','2603',NULL,2,'49',NULL,NULL,NULL,'纬度',NULL,NULL,0,0,'0'),('40b77f80869acc95579732abf6fbcb75','4022','L',20,'50','单次油耗','','3','tripFuelConsumption','','',1,0,'0'),('41','2602',NULL,1,'3',NULL,NULL,NULL,'经度',NULL,NULL,0,0,'0'),('42','2603',NULL,1,'3',NULL,NULL,NULL,'纬度',NULL,NULL,0,0,'0'),('42c7b37fb84b851a345a6bd093d3f46a','4014',NULL,9,'49',NULL,NULL,'3','水平精度因子',NULL,NULL,1,0,'0'),('43','-1',NULL,4,'3','当前位置',NULL,NULL,'当前位置(xml文件中不存在)',NULL,NULL,0,0,'0'),('432df538773f6b67a33caa69fde3237e','3040','km/h',13,'50','行驶速度','','3','CANSpeed','','',1,0,'0'),('4399ce8f6edb11e9a45b000c2914004c','4101','rpm',5,'24','发动机转速',NULL,NULL,'发动机转速',NULL,NULL,0,0,'0'),('43edf40309a911eab2f2000c2914004c','6000',NULL,1,'42','诊断协议',NULL,'2',NULL,NULL,'0-ISO 15765,1-ISO 27145,2-SAE J1939,3-ISO 15031,254-无效',1,0,'0'),('43edf79709a911eab2f2000c2914004c','4347',NULL,2,'42','MIL报警灯状态',NULL,'2',NULL,NULL,'0-未点亮,1-点亮',1,0,'0'),('43edf89309a911eab2f2000c2914004c','6037',NULL,3,'42','故障码总数',NULL,'3',NULL,NULL,NULL,1,0,'0'),('43ee8ba109a911eab2f2000c2914004c','6038',NULL,4,'42','故障码信息列表',NULL,'6',NULL,NULL,'separator-|,EG03100003117010001-冷却液高温报警,EG03100003117010101-发动机高温报警,EG03100003117010201-制动系统报警,EG03100003117010301-发动机超速报警,EG03100003117010401-发动机堵转报警,EG03100003117010501-加速踏板信号故障报警,EG03100003117010601-进气压力感知器线路报警,EG03100003117010701-进气温度感知器线路报警,EG03100003117010801-引擎增压系统故障报警,EG03100003117010901-引擎多缸失火报警',0,0,'0'),('44','3019',NULL,5,'3',NULL,NULL,NULL,'GPS模块状态',NULL,NULL,0,0,'0'),('444c8de1848a3fdae242d907b973b10f','4101','RPM',2,'50','发动机转速','','3','engineSpeed','','',1,0,'0'),('45','2204',NULL,6,'3','GPS速度',NULL,NULL,'GPS速度',NULL,NULL,0,0,'0'),('453b337f7e7e5879c849d15e170e96f3','3020',NULL,5,'52','ACC状态',NULL,'5',NULL,NULL,'0-电钥匙关闭,1-电钥匙打开',2,0,'0'),('46','3014',NULL,7,'3',NULL,NULL,'1','GPS时间',NULL,NULL,0,0,'0'),('47','TIME',NULL,8,'3','回传时间',NULL,'1','接收时间',NULL,NULL,0,0,'0'),('478b4b6d09a911eab2f2000c2914004c','4001',NULL,1,'43','开关量状态-ACC',NULL,'2',NULL,NULL,'0-电钥匙关闭,1- 电钥匙打开',1,0,'0'),('478b4efd09a911eab2f2000c2914004c','4002',NULL,2,'43','开关量状态-MOTO',NULL,'2',NULL,NULL,'0-有启动信号,1-无启动信号',1,0,'0'),('478b4ff809a911eab2f2000c2914004c','4003',NULL,3,'43','开关量状态-电平 1',NULL,'2',NULL,NULL,'0-低电平,1-高电平',1,0,'0'),('478b50b109a911eab2f2000c2914004c','4004',NULL,4,'43','开关量状态-电平 2',NULL,'2',NULL,NULL,'0-低电平,1- 高电平',1,0,'0'),('478b515d09a911eab2f2000c2914004c','3020',NULL,5,'43','ACC状态',NULL,'5',NULL,NULL,'电钥匙打开-打开-1,电钥匙关闭-关闭-0',1,0,'0'),('478b521109a911eab2f2000c2914004c','3021',NULL,6,'43','终端 MOTO 状态',NULL,NULL,NULL,NULL,NULL,1,0,'0'),('478b52b809a911eab2f2000c2914004c','4005','Hz',7,'43','FRQ1 输入',NULL,'3',NULL,NULL,NULL,1,0,'0'),('478bd6b809a911eab2f2000c2914004c','4006','Hz',8,'43','FRQ2 输入',NULL,'3',NULL,NULL,NULL,1,0,'0'),('478bd7de09a911eab2f2000c2914004c','4007','Hz',9,'43','PWM1 输出频率',NULL,'3',NULL,NULL,NULL,1,0,'0'),('478bd8a409a911eab2f2000c2914004c','4008','Hz',10,'43','PWM2 输出频率',NULL,'3',NULL,NULL,NULL,1,0,'0'),('478bd95009a911eab2f2000c2914004c','4009','mv',11,'43','输入电压 1',NULL,'3',NULL,NULL,NULL,1,0,'0'),('478bda0a09a911eab2f2000c2914004c','4010','mv',12,'43','输入电压 2',NULL,'3',NULL,NULL,NULL,1,0,'0'),('478bdaaf09a911eab2f2000c2914004c','4011','mv',13,'43','输入电源电压',NULL,'3',NULL,NULL,NULL,1,0,'0'),('478bdb5209a911eab2f2000c2914004c','4012','mv',14,'43','输入电池电压',NULL,'3',NULL,NULL,NULL,1,0,'0'),('478bdbf209a911eab2f2000c2914004c','3006',NULL,20,'43','固件版本号',NULL,NULL,NULL,NULL,NULL,1,0,'0'),('478bdd7d09a911eab2f2000c2914004c','3007',NULL,21,'43','硬件版本号',NULL,NULL,NULL,NULL,NULL,1,0,'0'),('478bde2709a911eab2f2000c2914004c','4352',NULL,15,'43','外壳状态',NULL,'2',NULL,NULL,'0-外壳关闭,1-外壳打开',1,0,'0'),('478bdec709a911eab2f2000c2914004c','4353',NULL,16,'43','拆除告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('478bdf5e09a911eab2f2000c2914004c','4354',NULL,17,'43','开壳告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('478be00909a911eab2f2000c2914004c','4355',NULL,18,'43','GPS 天线告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('478be13109a911eab2f2000c2914004c','4356',NULL,19,'43','CAN 异常告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('48','4014',NULL,9,'3',NULL,NULL,NULL,'水平精度因子',NULL,NULL,0,0,'0'),('49','3012',NULL,10,'3',NULL,NULL,NULL,'方向',NULL,NULL,0,0,'0'),('5','3019',NULL,5,'1',NULL,NULL,NULL,'GPS模块状态',NULL,NULL,0,0,'0'),('50','4030',NULL,76,'3','作业车辆状态',NULL,NULL,'车辆状态',NULL,NULL,0,0,'0'),('503a34db510542a8a65c38d9ad7354d8','4101','rpm',0,'338698becb2b4b38ac6d5cecc29dbe99','发动机转速','','3','engineSpeed','0','',2,0,'1'),('51','4031',NULL,77,'3',NULL,NULL,NULL,'作业标识',NULL,NULL,0,0,'0'),('511bdd08d11011e8a45b000c29140021','4110','kPa',15,'30','发动机增压压力',NULL,'3','增压压力',NULL,NULL,1,0,'0'),('511bdd08d11011e8a45b000c2914004c','4110','kPa',15,'20','发动机增压压力',NULL,'3','增压压力',NULL,NULL,1,0,'0'),('52','4032',NULL,78,'3',NULL,NULL,NULL,'实时亩数',NULL,NULL,0,0,'0'),('53d3c3ffd82411e9b2f2000c29140002','4350',NULL,0,'29','数据加密',NULL,'2','数据加密',NULL,'1-数据不加密,2-数据经过RSA算法加密,3-数据经过国密SM2算法加密,254-异常,255-无效',0,0,'0'),('53d3c3ffd82411e9b2f2000c2914004c','4350',NULL,0,'19','数据加密',NULL,'2','数据加密',NULL,'1-数据不加密,2-数据经过RSA算法加密,3-数据经过国密SM2算法加密,254-异常,255-无效',0,0,'0'),('54','4033',NULL,79,'3',NULL,NULL,NULL,'作业时长',NULL,NULL,0,0,'0'),('55','4101',NULL,31,'4',NULL,NULL,NULL,'发动机转速',NULL,NULL,0,0,'0'),('56','4100',NULL,32,'4',NULL,NULL,NULL,'冷却水温',NULL,NULL,0,0,'0'),('57','4108','MPa',35,'4',NULL,'x/1000',NULL,'机油压力',NULL,NULL,0,0,'0'),('58','4162',NULL,39,'4','燃油量',NULL,NULL,'燃油量（液位）',NULL,NULL,0,0,'0'),('59','4163','H',30,'4',NULL,'x/3600',NULL,'发动机工作时间',NULL,NULL,0,0,'0'),('59718122d10a11e8a45b000c29140022','4280',NULL,3,'30','发动机等待启动灯',NULL,'2','发动机等待启动灯',NULL,'0-关闭,1-打开',1,0,'0'),('59718122d10a11e8a45b000c2914004c','4280',NULL,3,'20','发动机等待启动灯',NULL,'2','发动机等待启动灯',NULL,'0-关闭,1-打开',1,0,'0'),('6','2204',NULL,6,'1','GPS速度',NULL,NULL,'GPS速度',NULL,NULL,0,0,'0'),('60','4164',NULL,42,'4',NULL,NULL,NULL,'系统电压',NULL,NULL,0,0,'0'),('609ee82c6edb11e9a45b000c2914004c','4301','V',6,'24','电瓶电压',NULL,NULL,'电瓶电压',NULL,NULL,0,0,'0'),('61','3040',NULL,80,'4','行驶速度',NULL,NULL,'CAN速度',NULL,NULL,0,0,'0'),('62','2205',NULL,53,'4',NULL,NULL,NULL,'总里程',NULL,NULL,0,0,'0'),('63','4182',NULL,68,'4',NULL,NULL,NULL,'主离合状态',NULL,NULL,0,0,'0'),('64','4183',NULL,81,'4',NULL,NULL,NULL,'提升器左提升力',NULL,NULL,0,0,'0'),('65','4184',NULL,82,'4',NULL,NULL,NULL,'提升器右提升力',NULL,NULL,0,0,'0'),('66','4185',NULL,83,'4',NULL,NULL,NULL,'机具离地高度',NULL,NULL,0,0,'0'),('67','4186',NULL,84,'4',NULL,NULL,NULL,'POT转速',NULL,NULL,0,0,'0'),('68','4187',NULL,85,'4',NULL,NULL,NULL,'液压系统压力',NULL,NULL,0,0,'0'),('6bba5172d10a11e8a45b000c29140023','4281',NULL,5,'30','发动机保护系统已关闭发动机',NULL,'2','发动机保护系统已关闭发动机',NULL,'0-关闭未激活,1-关闭已激活',1,0,'0'),('6bba5172d10a11e8a45b000c2914004c','4281',NULL,5,'20','发动机保护系统已关闭发动机',NULL,'2','发动机保护系统已关闭发动机',NULL,'0-关闭未激活,1-关闭已激活',1,0,'0'),('6bfc64ba4bc9fe35d1083e8f3584fda5','4005','Hz',7,'52','FRQ1 输入',NULL,'3',NULL,NULL,NULL,1,0,'0'),('6fba8c0afa0b11e9b2f2000c2914004c','4020,4021',NULL,24,'18','SPN_FMI 故障码',NULL,'7','SPN_FMI 故障码',NULL,NULL,0,0,'0'),('7','3014',NULL,7,'1',NULL,NULL,'1','GPS时间',NULL,NULL,0,0,'0'),('70601b58d11011e8a45b000c29140024','4250','%',23,'30','标准摩擦-扭矩百分比',NULL,'3','摩擦扭矩百分比',NULL,NULL,1,0,'0'),('70601b58d11011e8a45b000c2914004c','4250','%',23,'20','标准摩擦-扭矩百分比',NULL,'3','摩擦扭矩百分比',NULL,NULL,1,0,'0'),('72442cef6eda11e9a45b000c2914004c','2602',NULL,1,'23',NULL,NULL,NULL,'经度',NULL,NULL,0,0,'0'),('724432436eda11e9a45b000c2914004c','3012',NULL,5,'23',NULL,NULL,NULL,'方向',NULL,NULL,0,0,'0'),('724434986eda11e9a45b000c2914004c','2603',NULL,2,'23',NULL,NULL,NULL,'纬度',NULL,NULL,0,0,'0'),('724435506eda11e9a45b000c2914004c','-1',NULL,3,'23','当前位置',NULL,NULL,'当前位置(xml文件中不存在)',NULL,NULL,0,0,'0'),('724439b86eda11e9a45b000c2914004c','3019',NULL,7,'23',NULL,NULL,NULL,'GPS模块状态',NULL,NULL,0,0,'0'),('72443a896eda11e9a45b000c2914004c','2204',NULL,4,'23','GPS速度',NULL,NULL,'GPS速度',NULL,NULL,0,0,'0'),('72443b726eda11e9a45b000c2914004c','3014',NULL,8,'23',NULL,NULL,'1','GPS时间',NULL,NULL,0,0,'0'),('72443c4c6eda11e9a45b000c2914004c','TIME',NULL,9,'23','回传时间',NULL,'1','接收时间',NULL,NULL,0,0,'0'),('72443d006eda11e9a45b000c2914004c','4014',NULL,6,'23',NULL,NULL,NULL,'水平精度因子',NULL,NULL,0,0,'0'),('733e16b8b7754150a4ee472a0912a5d6','4272',NULL,21,'18',NULL,NULL,NULL,'车辆报警状态 2',NULL,NULL,1,0,'0'),('7b95c4dea46018cc9a83709168e0b7b1','4008','Hz',10,'52','PWM2 输出频率',NULL,'3',NULL,NULL,NULL,1,0,'0'),('7d19fa9e19c6146dcaaf0ca0e2173867','4009','V',11,'52','输入电压 1','x/1000','3',NULL,NULL,NULL,1,0,'0'),('7dce79edd10a11e8a45b000c29140025','4282','KM/L',8,'30','即时燃油经济性',NULL,'3','即时燃油经济性',NULL,NULL,1,0,'0'),('7dce79edd10a11e8a45b000c2914004c','4282','KM/L',8,'20','即时燃油经济性',NULL,'3','即时燃油经济性',NULL,NULL,1,0,'0'),('7f08f1217ea511e8a594000c292ded3c','4101',NULL,31,'15',NULL,NULL,NULL,'发动机转速',NULL,NULL,0,0,'0'),('7f08f5457ea511e8a594000c292ded3c','4100',NULL,32,'15',NULL,NULL,NULL,'冷却水温',NULL,NULL,0,0,'0'),('7f08f6627ea511e8a594000c292ded3c','4108','MPa',35,'15',NULL,'x/1000',NULL,'机油压力',NULL,NULL,0,0,'0'),('7f08f7427ea511e8a594000c292ded3c','4162',NULL,39,'15','燃油量',NULL,NULL,'燃油量（液位）',NULL,NULL,0,0,'0'),('7f08f8147ea511e8a594000c292ded3c','4163','H',30,'15',NULL,'x/3600',NULL,'发动机工作时间',NULL,NULL,0,0,'0'),('7f08f8e97ea511e8a594000c292ded3c','4164',NULL,42,'15',NULL,NULL,NULL,'系统电压',NULL,NULL,0,0,'0'),('7f08f9a47ea511e8a594000c292ded3c','3040',NULL,80,'15','行驶速度',NULL,NULL,'CAN速度',NULL,NULL,0,0,'0'),('7f08fa5d7ea511e8a594000c292ded3c','2205',NULL,53,'15',NULL,NULL,NULL,'总里程',NULL,NULL,0,0,'0'),('7f08fb137ea511e8a594000c292ded3c','4182',NULL,68,'15',NULL,NULL,NULL,'主离合状态',NULL,NULL,0,0,'0'),('7f08fbca7ea511e8a594000c292ded3c','4183',NULL,81,'15',NULL,NULL,NULL,'提升器左提升力',NULL,NULL,0,0,'0'),('7f08fc817ea511e8a594000c292ded3c','4184',NULL,82,'15',NULL,NULL,NULL,'提升器右提升力',NULL,NULL,0,0,'0'),('7f08fd397ea511e8a594000c292ded3c','4185',NULL,83,'15',NULL,NULL,NULL,'机具离地高度',NULL,NULL,0,0,'0'),('7f08fded7ea511e8a594000c292ded3c','4186',NULL,84,'15',NULL,NULL,NULL,'POT转速',NULL,NULL,0,0,'0'),('7f08fea97ea511e8a594000c292ded3c','4187',NULL,85,'15',NULL,NULL,NULL,'液压系统压力',NULL,NULL,0,0,'0'),('7f5dc3b66edb11e9a45b000c2914004c','4302',NULL,7,'24','SPN',NULL,NULL,'SPN',NULL,NULL,0,0,'0'),('7fc8d47e964411e89b79000c292ded3c','4103',NULL,12,'18',NULL,NULL,'3','发动机实际扭矩',NULL,NULL,1,0,'0'),('7fd6c04128727d73359b1f13074fef36','4012','V',14,'52','输入电池电压','x/1000','3',NULL,NULL,NULL,1,0,'0'),('8','TIME',NULL,8,'1','回传时间',NULL,'1','接收时间',NULL,NULL,0,0,'0'),('80','2602',NULL,1,'5',NULL,NULL,NULL,'经度',NULL,NULL,0,0,'0'),('800461b26cec89b0158546b12f416be0','4006','Hz',8,'52','FRQ2 输入',NULL,'3',NULL,NULL,NULL,1,0,'0'),('81','2603',NULL,1,'5',NULL,NULL,NULL,'纬度',NULL,NULL,0,0,'0'),('814efdfc6f2e8cac8fcbeb58f886b6da','3020',NULL,1,'0ad4727a2920487cb436822b9da78c1a','电锁状态',NULL,'5',NULL,NULL,'电钥匙打开-打开-1,电钥匙关闭-关闭-0',2,0,'0'),('82','-1',NULL,4,'5','当前位置',NULL,NULL,'当前位置(xml文件中不存在)',NULL,NULL,0,0,'0'),('82079ebde2826f079cd7d9e111caceca','3016',NULL,13,'49','可视卫星数',NULL,'3','可视卫星数',NULL,NULL,0,0,'0'),('83','3019',NULL,5,'5',NULL,NULL,NULL,'GPS模块状态',NULL,NULL,0,0,'0'),('84','2204',NULL,6,'5','GPS速度',NULL,NULL,'GPS速度',NULL,NULL,0,0,'0'),('85','3014',NULL,7,'5',NULL,NULL,'1','GPS时间',NULL,NULL,0,0,'0'),('86','TIME',NULL,8,'5','回传时间',NULL,'1','接收时间',NULL,NULL,0,0,'0'),('8695726524174d20a762358df2830613','4258',NULL,6,'18','GPS 监控功能',NULL,'2','GPS监控功能',NULL,'0-关闭,1-打开',1,0,'0'),('87','4014',NULL,9,'5',NULL,NULL,NULL,'水平精度因子',NULL,NULL,0,0,'0'),('873d59983cfd54632529895893a8ce8d','TIME','',9,'4b0bcd3b652b4f078f46cc5ef7768a8b','回传时间','','1','接收时间','0','',1,0,'1'),('88','3012',NULL,10,'5',NULL,NULL,NULL,'方向',NULL,NULL,0,0,'0'),('886fa9c9964411e89b79000c292ded3c','4106',NULL,9,'18',NULL,NULL,'3','燃油温度',NULL,NULL,1,0,'0'),('89','4030',NULL,76,'5','作业车辆状态',NULL,NULL,'车辆状态',NULL,NULL,0,0,'0'),('8b5627273cecb05b39cbd2e4908e5076','4141','℃',28,'50','液压油温','','3','hydraulicOilTemperature','','',1,0,'0'),('8bd5c291d10711e8a45b000c29140003','2602',NULL,1,'29',NULL,NULL,'3','经度',NULL,NULL,1,0,'0'),('8bd5c291d10711e8a45b000c2914004c','2602',NULL,1,'19',NULL,NULL,'3','经度',NULL,NULL,1,0,'0'),('8bd5c964d10711e8a45b000c29140004','3012',NULL,8,'29',NULL,NULL,'3','方向',NULL,NULL,1,0,'0'),('8bd5c964d10711e8a45b000c2914004c','3012',NULL,8,'19',NULL,NULL,'3','方向',NULL,NULL,1,0,'0'),('8bd5ca9fd10711e8a45b000c29140005','2603',NULL,2,'29',NULL,NULL,'3','纬度',NULL,NULL,1,0,'0'),('8bd5ca9fd10711e8a45b000c2914004c','2603',NULL,2,'19',NULL,NULL,'3','纬度',NULL,NULL,1,0,'0'),('8bd5cb7dd10711e8a45b000c29140006','-1',NULL,14,'29','当前位置',NULL,NULL,'当前位置(xml文件中不存在)',NULL,NULL,0,0,'0'),('8bd5cb7dd10711e8a45b000c2914004c','-1',NULL,14,'19','当前位置',NULL,NULL,'当前位置(xml文件中不存在)',NULL,NULL,0,0,'0'),('8bd5cc57d10711e8a45b000c29140007','3019',NULL,6,'29','GPS模块状态',NULL,'2','GPS模块状态',NULL,'0- 模块正常,1-模块异常',1,0,'0'),('8bd5cc57d10711e8a45b000c2914004c','3019',NULL,6,'19','GPS模块状态',NULL,'2','GPS模块状态',NULL,'0- 模块正常,1-模块异常',1,0,'0'),('8bd5cd26d10711e8a45b000c29140008','2204',NULL,7,'29','GPS速度',NULL,'3','GPS速度',NULL,NULL,1,0,'0'),('8bd5cd26d10711e8a45b000c2914004c','2204',NULL,7,'19','GPS速度',NULL,'3','GPS速度',NULL,NULL,1,0,'0'),('8bd5cdebd10711e8a45b000c29140009','3014',NULL,3,'29',NULL,NULL,'1','GPS时间',NULL,NULL,1,0,'0'),('8bd5cdebd10711e8a45b000c2914004c','3014',NULL,3,'19',NULL,NULL,'1','GPS时间',NULL,NULL,1,0,'0'),('8bd5ceb3d10711e8a45b000c29140010','TIME',NULL,4,'29','回传时间',NULL,'1','接收时间',NULL,NULL,1,0,'0'),('8bd5ceb3d10711e8a45b000c2914004c','TIME',NULL,4,'19','回传时间',NULL,'1','接收时间',NULL,NULL,1,0,'0'),('8bd5cf7dd10711e8a45b000c29140011','4014',NULL,9,'29',NULL,NULL,'3','水平精度因子',NULL,NULL,1,0,'0'),('8bd5cf7dd10711e8a45b000c2914004c','4014',NULL,9,'19',NULL,NULL,'3','水平精度因子',NULL,NULL,1,0,'0'),('8be24551799211ea82d10894ef147327','4401','',25,'50','变速箱压力状态','','2','4401','','0-无压力,1-有压力',1,0,'0'),('8bebe2f6799211ea82d10894ef147327','4183','kN',26,'50','提升器左提升力','','3','LeftLiftingFource','','',1,0,'0'),('8bfc5fc6799211ea82d10894ef147327','4179','V',30,'50','传感器2电压',NULL,'3','sensorVoltage2',NULL,NULL,1,0,'0'),('8c05d3b0799211ea82d10894ef147327','4178','V',29,'50','传感器1电压',NULL,'3','sensorVoltage1',NULL,NULL,1,0,'0'),('8cb9b1fc401ec94897d96f30ce47d034','4320','%',3,'50','油门踏板位置','','3','4320','','',1,0,'0'),('8e29533aaa4e4e14b4e0804e1117519c','4163','时',4,'18',NULL,'x/3600','3','发动机工作时间','2',NULL,2,0,'0'),('8e59cf8e964411e89b79000c292ded3c','4109','MPa',13,'18',NULL,'x/1000','3','大气压力',NULL,NULL,1,0,'0'),('8f5d4529a890836193d2008fcb475587','2601','',5,'4b0bcd3b652b4f078f46cc5ef7768a8b','定位状态','','2','定位状态','0','0-已定位,1-未定位',1,0,'1'),('9','4014',NULL,9,'1',NULL,NULL,NULL,'水平精度因子',NULL,NULL,0,0,'0'),('90','4031',NULL,77,'5',NULL,NULL,NULL,'作业标识',NULL,NULL,0,0,'0'),('90f28143e26a11e9b2f2000c2914004c','2601',NULL,5,'34','GPS定位状态',NULL,'2','定位状态',NULL,'0-有效定位,1-无效定位',0,0,'0'),('90f28631e26a11e9b2f2000c2914004c','4350',NULL,0,'34','数据加密',NULL,'2','数据加密',NULL,'1-数据不加密,2-数据经过RSA算法加密,3-数据经过国密SM2算法加密,254-异常,255-无效',0,0,'0'),('90f3b153e26a11e9b2f2000c2914004c','2602',NULL,1,'34',NULL,NULL,NULL,'经度',NULL,NULL,0,0,'0'),('90f3b25ce26a11e9b2f2000c2914004c','3012',NULL,8,'34',NULL,NULL,NULL,'方向',NULL,NULL,0,0,'0'),('90f3b2fce26a11e9b2f2000c2914004c','2603',NULL,2,'34',NULL,NULL,NULL,'纬度',NULL,NULL,0,0,'0'),('90f3b383e26a11e9b2f2000c2914004c','-1',NULL,14,'34','当前位置',NULL,NULL,'当前位置(xml文件中不存在)',NULL,NULL,0,0,'0'),('90f3b413e26a11e9b2f2000c2914004c','3019',NULL,6,'34','GPS模块状态',NULL,NULL,'GPS模块状态',NULL,'0- 模块正常,1-模块异常',0,0,'0'),('90f3b49ee26a11e9b2f2000c2914004c','2204',NULL,7,'34','GPS速度',NULL,NULL,'GPS速度',NULL,NULL,0,0,'0'),('90f4e6cae26a11e9b2f2000c2914004c','3014',NULL,3,'34',NULL,NULL,'1','GPS时间',NULL,NULL,0,0,'0'),('90f4e7c8e26a11e9b2f2000c2914004c','TIME',NULL,4,'34','回传时间',NULL,'1','接收时间',NULL,NULL,0,0,'0'),('90f4e860e26a11e9b2f2000c2914004c','4014',NULL,9,'34',NULL,NULL,NULL,'水平精度因子',NULL,NULL,0,0,'0'),('90f4e933e26a11e9b2f2000c2914004c','3013','m',11,'34','海拔高度',NULL,NULL,'海拔高度',NULL,NULL,0,0,'0'),('90f4e9dce26a11e9b2f2000c2914004c','3015',NULL,12,'34','使用卫星数',NULL,NULL,'使用卫星数',NULL,NULL,0,0,'0'),('90f4ea65e26a11e9b2f2000c2914004c','3016',NULL,13,'34','可视卫星数',NULL,NULL,'可视卫星数',NULL,NULL,0,0,'0'),('91','4032',NULL,78,'5',NULL,NULL,NULL,'实时亩数',NULL,NULL,0,0,'0'),('92','4033',NULL,79,'5',NULL,NULL,NULL,'作业时长',NULL,NULL,0,0,'0'),('92facac71156f2bb46f1c82c76531561','4103','%',0,'50','发动机实际扭矩','','3','actualEngineTorque','','',1,0,'0'),('939761fb7ea511e8a594000c292ded3c','2602',NULL,1,'16',NULL,NULL,NULL,'经度',NULL,NULL,0,0,'0'),('939765d97ea511e8a594000c292ded3c','3012',NULL,10,'16',NULL,NULL,NULL,'方向',NULL,NULL,0,0,'0'),('939766ec7ea511e8a594000c292ded3c','2603',NULL,2,'16',NULL,NULL,NULL,'纬度',NULL,NULL,0,0,'0'),('939767c37ea511e8a594000c292ded3c','-1',NULL,4,'16','当前位置',NULL,NULL,'当前位置(xml文件中不存在)',NULL,NULL,0,0,'0'),('9397688f7ea511e8a594000c292ded3c','3019',NULL,5,'16',NULL,NULL,NULL,'GPS模块状态',NULL,NULL,0,0,'0'),('939769617ea511e8a594000c292ded3c','2204',NULL,6,'16','GPS速度',NULL,NULL,'GPS速度',NULL,NULL,0,0,'0'),('93976b717ea511e8a594000c292ded3c','3014',NULL,7,'16',NULL,NULL,'1','GPS时间',NULL,NULL,0,0,'0'),('93976c687ea511e8a594000c292ded3c','TIME',NULL,8,'16','回传时间',NULL,'1','接收时间',NULL,NULL,0,0,'0'),('93976d307ea511e8a594000c292ded3c','4014',NULL,9,'16',NULL,NULL,NULL,'水平精度因子',NULL,NULL,0,0,'0'),('950255d5be80b0d9b38886eda037d8e5','3015',NULL,12,'49','使用卫星数',NULL,'3','使用卫星数',NULL,NULL,0,0,'0'),('962ca748d11011e8a45b000c29140026','4290','%',24,'30','估计的发动机寄生损失-扭矩百分比',NULL,'3','估计的发动机寄生损失-扭矩百分比',NULL,NULL,1,0,'0'),('962ca748d11011e8a45b000c2914004c','4290','%',24,'20','估计的发动机寄生损失-扭矩百分比',NULL,'3','估计的发动机寄生损失-扭矩百分比',NULL,NULL,1,0,'0'),('998981b8d79c11e9b2f2000c2914004c','3040','km/h',1,'25','车速',NULL,'3',NULL,NULL,NULL,1,0,'0'),('998981b8d79c11e9b2f2000c29140056','3040','km/h',1,'31','车速',NULL,'3',NULL,NULL,NULL,1,0,'0'),('9b31d77cd10a11e8a45b000c29140027','4283','°C',13,'30','发动机进气管温度',NULL,'3','发动机进气管温度',NULL,NULL,1,0,'0'),('9b31d77cd10a11e8a45b000c2914004c','4283','°C',13,'20','发动机进气管温度',NULL,'3','发动机进气管温度',NULL,NULL,1,0,'0'),('9b48341798ca1e033b06ae4f8f417cf3','3012',NULL,10,'49',NULL,NULL,'3','方向',NULL,NULL,0,0,'0'),('9b4f48f9e26a11e9b2f2000c2914004c','4288','%',21,'35','发动机负荷系数',NULL,'3','发动机负荷系数',NULL,NULL,0,0,'0'),('9b4f4c44e26a11e9b2f2000c2914004c','4291',NULL,25,'35','车身故障DM1',NULL,NULL,'车身故障DM1',NULL,NULL,0,0,'0'),('9b4f4d24e26a11e9b2f2000c2914004c','4289','%',22,'35','实际最大可用发动机-扭矩百分比',NULL,'3','实际最大可用发动机-扭矩百分比',NULL,NULL,0,0,'0'),('9b4f4dbee26a11e9b2f2000c2914004c','4175','L/h',7,'35','燃油消耗率',NULL,'3','小时油耗',NULL,NULL,0,0,'0'),('9b4f4f81e26a11e9b2f2000c2914004c','4292',NULL,26,'35','车身故障DM2',NULL,NULL,'车身故障DM2',NULL,NULL,0,0,'0'),('9b4f503be26a11e9b2f2000c2914004c','4279','rpm',1,'35','理想发动机转速',NULL,'3','理想发动机转速',NULL,NULL,0,0,'0'),('9b4f50c9e26a11e9b2f2000c2914004c','4110','kPa',15,'35','发动机增压压力',NULL,'3','增压压力',NULL,NULL,0,0,'0'),('9b4f514de26a11e9b2f2000c2914004c','4280',NULL,3,'35','发动机等待启动灯',NULL,'2','发动机等待启动灯',NULL,'0-关闭,1-打开',0,0,'0'),('9b4f524fe26a11e9b2f2000c2914004c','4281',NULL,5,'35','发动机保护系统已关闭发动机',NULL,'2','发动机保护系统已关闭发动机',NULL,'0-关闭未激活,1-关闭已激活',0,0,'0'),('9b4f52e8e26a11e9b2f2000c2914004c','4250','%',23,'35','标准摩擦-扭矩百分比',NULL,'3','摩擦扭矩百分比',NULL,NULL,0,0,'0'),('9b4f536ae26a11e9b2f2000c2914004c','4282','KM/L',8,'35','即时燃油经济性',NULL,'3','即时燃油经济性',NULL,NULL,0,0,'0'),('9b4f53e4e26a11e9b2f2000c2914004c','4290','%',24,'35','估计的发动机寄生损失-扭矩百分比',NULL,'3','估计的发动机寄生损失-扭矩百分比',NULL,NULL,0,0,'0'),('9b4f5466e26a11e9b2f2000c2914004c','4283','°C',13,'35','发动机进气管温度',NULL,'3','发动机进气管温度',NULL,NULL,0,0,'0'),('9b4f54e7e26a11e9b2f2000c2914004c','4284','kPa',16,'35','发动机进气压力',NULL,'3','发动机进气压力',NULL,NULL,0,0,'0'),('9b4f555ee26a11e9b2f2000c2914004c','4243','℃',10,'35','发动机机油温度',NULL,'3','机油温度',NULL,NULL,0,0,'0'),('9b4f55d6e26a11e9b2f2000c2914004c','4023','L',6,'35','发动机总燃油量',NULL,'3','累计油耗',NULL,NULL,0,0,'0'),('9b4f56d2e26a11e9b2f2000c2914004c','4101','rpm',0,'35','发动机转速',NULL,'3','发动机转速',NULL,NULL,0,0,'0'),('9b4f5775e26a11e9b2f2000c2914004c','4108','mPa',4,'35','发动机机油压力','x/1000','3','机油压力',NULL,NULL,0,0,'0'),('9b4f5802e26a11e9b2f2000c2914004c','4163','h',2,'35','发动机总工作小时数','x/3600','3','发动机工作时间',NULL,NULL,0,0,'0'),('9b4f5895e26a11e9b2f2000c2914004c','4103','%',19,'35','实际发动机-扭矩百分比',NULL,'3','发动机实际扭矩',NULL,NULL,0,0,'0'),('9b4f5920e26a11e9b2f2000c2914004c','4109','kPa',14,'35','大气压力',NULL,'3','大气压力',NULL,NULL,0,0,'0'),('9b4f59a0e26a11e9b2f2000c2914004c','4112','°C',12,'35','空气进气温度',NULL,'3','进气温度',NULL,NULL,0,0,'0'),('9b4f5a20e26a11e9b2f2000c2914004c','4245','℃',11,'35','外界温度',NULL,'3','大气温度',NULL,NULL,0,0,'0'),('9b4f5a9ce26a11e9b2f2000c2914004c','4177','°C',9,'35','发动机冷却液温度',NULL,'3','冷却水温度',NULL,NULL,0,0,'0'),('9b4f5b1de26a11e9b2f2000c2914004c','4285',NULL,17,'35','发动机扭矩模式',NULL,'3','发动机扭矩模式',NULL,NULL,0,0,'0'),('9b4f5b9ae26a11e9b2f2000c2914004c','4286','%',18,'35','驾驶员要求的发动机-扭矩百分比',NULL,'3','驾驶员要求的发动机-扭矩百分比',NULL,NULL,0,0,'0'),('9b4f5c1ce26a11e9b2f2000c2914004c','4287','%',20,'35','发动机需求-扭矩百分比',NULL,'3','发动机需求-扭矩百分比',NULL,NULL,0,0,'0'),('9f34eaf12b72c111d8ee59d9e63e8c98','2603','',2,'4b0bcd3b652b4f078f46cc5ef7768a8b','','','3','纬度','7','',1,0,'1'),('a0e3b28e4634414c925869d888713cb1','4247',NULL,15,'18',NULL,NULL,'3','发动机负荷',NULL,NULL,1,0,'0'),('a0e655e76ddaf5664680ea3d5ee6dfff','4164','V',22,'50','系统电压','','3','systemVoltage','','',1,0,'0'),('a1ee7059964411e89b79000c292ded3c','4112',NULL,14,'18',NULL,NULL,'3','进气温度',NULL,NULL,1,0,'0'),('a22ca1d5d645a11ab3b63b54833eea81','4353',NULL,16,'52','拆除告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('a3789933d79c11e9b2f2000c2914004c','4109','kPa',2,'25','大气压力',NULL,'3',NULL,NULL,NULL,1,0,'0'),('a3789933d79c11e9b2f2000c29140057','4109','kPa',2,'31','大气压力',NULL,'3',NULL,NULL,NULL,1,0,'0'),('a514399d6edb11e9a45b000c2914004c','4163','小时',8,'24','发动机累计工作时间','x/3600',NULL,'发动机累计工作时间',NULL,NULL,0,0,'0'),('a715ce22a98348c7dc4cdbc8ffaabb85','4173','℃',19,'50','变速箱油温','','3','gearBoxOilTemp','','',1,0,'0'),('a897d2fc896a44189245a8edd563762e','4253',NULL,10,'18',NULL,NULL,'3','机油液位',NULL,NULL,1,0,'0'),('a8a26e7411922ee69a4a32b9fca6f043','2602',NULL,1,'49',NULL,NULL,NULL,'经度',NULL,NULL,0,0,'0'),('a8de70fbeb3411e9b2f2000c2914004c','DATE_TYPE',NULL,-1,'20',NULL,NULL,NULL,NULL,NULL,NULL,0,0,'0'),('a9193819e26a11e9b2f2000c2914004c','4250','%',4,'36','摩擦扭矩',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a9193ca1e26a11e9b2f2000c2914004c','4101','rpm',5,'36','发动机转速',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a9193e33e26a11e9b2f2000c2914004c','6039','L/h',6,'36','发动机燃料流量',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a9193ed8e26a11e9b2f2000c2914004c','6040','ppm',7,'36','SCR上游NOx传感器输出值',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a9193f5fe26a11e9b2f2000c2914004c','6041','ppm',8,'36','SCR下游NOx传感器输出值',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a9193fe5e26a11e9b2f2000c2914004c','6042','%',9,'36','反应剂余量',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a919405de26a11e9b2f2000c2914004c','6043','kg/h',10,'36','进气量',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a919414ae26a11e9b2f2000c2914004c','6044','℃',11,'36','SCR入口温度',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a91941e2e26a11e9b2f2000c2914004c','6045','℃',12,'36','SCR出口温度',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a9194266e26a11e9b2f2000c2914004c','6046','kPa',13,'36','DPF压差',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a91942dbe26a11e9b2f2000c2914004c','4177','℃',14,'36','发动机冷却液温度',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a9194355e26a11e9b2f2000c2914004c','4162','%',15,'36','油箱液位',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a91943cae26a11e9b2f2000c2914004c','4348','%',16,'36','实际EGR阀开度',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a919444ce26a11e9b2f2000c2914004c','4349','%',17,'36','设定的EGR阀开度',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a91944c8e26a11e9b2f2000c2914004c','3040','km/h',1,'36','车速',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a919762fe26a11e9b2f2000c2914004c','4109','kPa',2,'36','大气压力',NULL,'3',NULL,NULL,NULL,0,0,'0'),('a9197730e26a11e9b2f2000c2914004c','4319','%',3,'36','发动机净输出扭矩',NULL,'3',NULL,NULL,NULL,0,0,'0'),('ac402727a6ffc186629430b96cc5988e','4004',NULL,4,'52','开关量状态-电平 2',NULL,'2',NULL,NULL,'0-低电平,1- 高电平',1,0,'0'),('ada1f0ba6eda11e9a45b000c2914004c','4175','L/H',1,'24','小时油耗',NULL,NULL,'小时油耗',NULL,NULL,0,0,'0'),('ae1f4238dff9417baccbdf142d537ebc','4271',NULL,20,'18',NULL,NULL,NULL,'车辆报警状态 1',NULL,NULL,1,0,'0'),('ae66dc74483b4fb1ab36ffe80b3fdd04','4249','MPa',11,'18',NULL,'x/1000','3','绝对机油压力',NULL,NULL,1,0,'0'),('ae82ddd094cc12d612e89bcb972a2126','4106','℃',8,'50','燃油温度','','3','fuelOilTemperature','','',1,0,'0'),('b0dd6b0f614b31e7f62d3274336fb6d9','4162','%',12,'50','燃油量（液位）','','3','quantityOfFuel','','',1,0,'0'),('b28ea1c6dcff7f53ef44129bbf007c40','4023','L',10,'50','累计油耗','','3','totalFuelConsumption','','',1,0,'0'),('b66f5678d10a11e8a45b000c29140028','4284','kPa',16,'30','发动机进气压力',NULL,'3','发动机进气压力',NULL,NULL,1,0,'0'),('b66f5678d10a11e8a45b000c2914004c','4284','kPa',16,'20','发动机进气压力',NULL,'3','发动机进气压力',NULL,NULL,1,0,'0'),('b7a2bfd4f95911e9bab7d0946600e1f1','3006',NULL,8,'28','固件版本号',NULL,NULL,NULL,NULL,NULL,1,0,'0'),('b7a2bfd4f95911e9bab7d0946615e1f1','3006',NULL,20,'33','固件版本号',NULL,NULL,NULL,NULL,NULL,1,0,'0'),('b7a2bfd4f95911e9bab7d0946619e1f1','3006',NULL,20,'27','固件版本号',NULL,NULL,NULL,NULL,NULL,1,0,'0'),('b7a2bfd4f95911e9bab7d0946625e1f1','3007',NULL,21,'33','硬件版本号',NULL,NULL,NULL,NULL,NULL,1,0,'0'),('b7a2bfd4f95911e9bab7d0946635e1f1','3007',NULL,21,'27','硬件版本号',NULL,NULL,NULL,NULL,NULL,1,0,'0'),('b8968db397d9bf14cb6ec6ef31ddd688','4011','V',2,'0ad4727a2920487cb436822b9da78c1a','供电电压','x/1000','3','输入电源电压',NULL,NULL,1,0,'0'),('b98e35db963e11e89b79000c292ded3c','2602',NULL,1,'17',NULL,NULL,'3','经度',NULL,NULL,1,0,'0'),('b98e39c0963e11e89b79000c292ded3c','3012',NULL,11,'17',NULL,NULL,'3','方向',NULL,NULL,1,0,'0'),('b98e3a93963e11e89b79000c292ded3c','2603',NULL,2,'17',NULL,NULL,'3','纬度',NULL,NULL,1,0,'0'),('b98e3b18963e11e89b79000c292ded3c','-1',NULL,4,'17','当前位置',NULL,NULL,'当前位置(xml文件中不存在)',NULL,NULL,0,0,'0'),('b98e3c2b963e11e89b79000c292ded3c','2204',NULL,7,'17','GPS速度',NULL,'3','GPS速度',NULL,NULL,1,0,'0'),('b98e3ca2963e11e89b79000c292ded3c','3014',NULL,8,'17',NULL,NULL,'1','GPS时间',NULL,NULL,1,0,'0'),('b98e3d1a963e11e89b79000c292ded3c','TIME',NULL,9,'17','回传时间',NULL,'1','接收时间',NULL,NULL,1,0,'0'),('b98e3d99963e11e89b79000c292ded3c','4014',NULL,10,'17',NULL,NULL,'3','水平精度因子',NULL,NULL,1,0,'0'),('ba0d1fe0e26a11e9b2f2000c2914004c','6000',NULL,1,'37','诊断协议',NULL,'2',NULL,NULL,'0-ISO 15765,1-ISO 27145,2-SAE J1939,3-ISO 15031,254-无效',0,0,'0'),('ba0d2561e26a11e9b2f2000c2914004c','4347',NULL,2,'37','MIL报警灯状态',NULL,'2',NULL,NULL,'0-未点亮,1-点亮',0,0,'0'),('ba0d26b0e26a11e9b2f2000c2914004c','6037',NULL,3,'37','故障码总数',NULL,NULL,NULL,NULL,NULL,0,0,'0'),('ba0d27abe26a11e9b2f2000c2914004c','6038',NULL,4,'37','故障码信息列表',NULL,NULL,NULL,NULL,NULL,0,0,'0'),('bbb9d476d10911e8a45b000c29140029','4243','℃',10,'30','发动机机油温度',NULL,'3','机油温度',NULL,NULL,1,0,'0'),('bbb9d476d10911e8a45b000c2914004c','4243','℃',10,'20','发动机机油温度',NULL,'3','机油温度',NULL,NULL,1,0,'0'),('bbb9d7bed10911e8a45b000c29140030','4023','L',6,'30','发动机总燃油量',NULL,'3','累计油耗',NULL,NULL,1,0,'0'),('bbb9d7bed10911e8a45b000c2914004c','4023','L',6,'20','发动机总燃油量',NULL,'3','累计油耗',NULL,NULL,1,0,'0'),('bbb9d890d10911e8a45b000c29140031','4101','rpm',0,'30','发动机转速',NULL,'3','发动机转速',NULL,NULL,2,0,'0'),('bbb9d890d10911e8a45b000c2914004c','4101','rpm',0,'20','发动机转速',NULL,'3','发动机转速',NULL,NULL,1,0,'0'),('bbb9d913d10911e8a45b000c29140032','4108','mPa',4,'30','发动机机油压力','x/1000','3','机油压力',NULL,NULL,1,0,'0'),('bbb9d913d10911e8a45b000c2914004c','4108','mPa',4,'20','发动机机油压力','x/1000','3','机油压力',NULL,NULL,1,0,'0'),('bbb9d997d10911e8a45b000c29140033','4163','h',2,'30','发动机总工作小时数','x/3600','3','发动机工作时间',NULL,NULL,2,0,'0'),('bbb9d997d10911e8a45b000c2914004c','4163','h',2,'20','发动机总工作小时数','x/3600','3','发动机工作时间',NULL,NULL,1,0,'0'),('bbb9da1ed10911e8a45b000c29140034','4103','%',19,'30','实际发动机-扭矩百分比',NULL,'3','发动机实际扭矩',NULL,NULL,1,0,'0'),('bbb9da1ed10911e8a45b000c2914004c','4103','%',19,'20','实际发动机-扭矩百分比',NULL,'3','发动机实际扭矩',NULL,NULL,1,0,'0'),('bbb9daa1d10911e8a45b000c29140035','4109','kPa',14,'30','大气压力',NULL,'3','大气压力',NULL,NULL,1,0,'0'),('bbb9daa1d10911e8a45b000c2914004c','4109','kPa',14,'20','大气压力',NULL,'3','大气压力',NULL,NULL,1,0,'0'),('bbb9db15d10911e8a45b000c29140036','4112','°C',12,'30','空气进气温度',NULL,'3','进气温度',NULL,NULL,1,0,'0'),('bbb9db15d10911e8a45b000c2914004c','4112','°C',12,'20','空气进气温度',NULL,'3','进气温度',NULL,NULL,1,0,'0'),('bbb9db86d10911e8a45b000c29140037','4245','℃',11,'30','外界温度',NULL,'3','大气温度',NULL,NULL,1,0,'0'),('bbb9db86d10911e8a45b000c2914004c','4245','℃',11,'20','外界温度',NULL,'3','大气温度',NULL,NULL,1,0,'0'),('bbb9dbfcd10911e8a45b000c29140038','4177','°C',9,'30','发动机冷却液温度',NULL,'3','冷却水温度',NULL,NULL,1,0,'0'),('bbb9dbfcd10911e8a45b000c2914004c','4177','°C',9,'20','发动机冷却液温度',NULL,'3','冷却水温度',NULL,NULL,1,0,'0'),('bf805636677111ea82d10894ef147327','2601',NULL,5.1,'49','GPS定位状态',NULL,'2','定位状态',NULL,'0-已定位,1-未定位',1,0,'0'),('c250ee80d79c11e9b2f2000c2914004c','4103','%',3,'25','发动机净输出扭矩',NULL,'3',NULL,NULL,NULL,1,0,'0'),('c250ee80d79c11e9b2f2000c29140058','4103','%',3,'31','发动机净输出扭矩',NULL,'3',NULL,NULL,NULL,1,0,'0'),('c3b09bb0e26a11e9b2f2000c2914004c','4001',NULL,1,'38','开关量状态-ACC',NULL,'2',NULL,NULL,'0-电钥匙关闭,1- 电钥匙打开',0,0,'0'),('c3b0a00ee26a11e9b2f2000c2914004c','4002',NULL,2,'38','开关量状态-MOTO',NULL,'2',NULL,NULL,'0-有启动信号,1-无启动信号',0,0,'0'),('c3b0a15ee26a11e9b2f2000c2914004c','4003',NULL,3,'38','开关量状态-电平 1',NULL,'2',NULL,NULL,'0-低电平,1-高电平',0,0,'0'),('c3b0a255e26a11e9b2f2000c2914004c','4004',NULL,4,'38','开关量状态-电平 2',NULL,'2',NULL,NULL,'0-低电平,1- 高电平',0,0,'0'),('c3b0a336e26a11e9b2f2000c2914004c','3020',NULL,5,'38','ACC状态',NULL,'',NULL,NULL,'',0,0,'0'),('c3b0a3fee26a11e9b2f2000c2914004c','3021',NULL,6,'38','终端 MOTO 状态',NULL,NULL,NULL,NULL,NULL,0,0,'0'),('c3b0a4cee26a11e9b2f2000c2914004c','4005','Hz',7,'38','FRQ1 输入',NULL,'3',NULL,NULL,NULL,0,0,'0'),('c3b0a598e26a11e9b2f2000c2914004c','4006','Hz',8,'38','FRQ2 输入',NULL,'3',NULL,NULL,NULL,0,0,'0'),('c3b0a671e26a11e9b2f2000c2914004c','4007','Hz',9,'38','PWM1 输出频率',NULL,'3',NULL,NULL,NULL,0,0,'0'),('c3b0a74ce26a11e9b2f2000c2914004c','4008','Hz',10,'38','PWM2 输出频率',NULL,'3',NULL,NULL,NULL,0,0,'0'),('c3b0a812e26a11e9b2f2000c2914004c','4009','mv',11,'38','输入电压 1',NULL,'3',NULL,NULL,NULL,0,0,'0'),('c3b0a8cde26a11e9b2f2000c2914004c','4010','mv',12,'38','输入电压 2',NULL,'3',NULL,NULL,NULL,0,0,'0'),('c3b0a9aae26a11e9b2f2000c2914004c','4011','mv',13,'38','输入电源电压',NULL,'3',NULL,NULL,NULL,0,0,'0'),('c3b0aa81e26a11e9b2f2000c2914004c','4012','mv',14,'38','输入电池电压',NULL,'3',NULL,NULL,NULL,0,0,'0'),('c3b0ab47e26a11e9b2f2000c2914004c','4352',NULL,15,'38','外壳状态',NULL,'2',NULL,NULL,'0-外壳关闭,1-外壳打开',0,0,'0'),('c3b0abf8e26a11e9b2f2000c2914004c','4353',NULL,16,'38','拆除告警',NULL,'2',NULL,NULL,'0-正常,1-告警',0,0,'0'),('c3b0aceee26a11e9b2f2000c2914004c','4354',NULL,17,'38','开壳告警',NULL,'2',NULL,NULL,'0-正常,1-告警',0,0,'0'),('c3b0adbfe26a11e9b2f2000c2914004c','4355',NULL,18,'38','GPS 天线告警',NULL,'2',NULL,NULL,'0-正常,1-告警',0,0,'0'),('c3b0ae87e26a11e9b2f2000c2914004c','4356',NULL,19,'38','CAN 异常告警',NULL,'2',NULL,NULL,'0-正常,1-告警',0,0,'0'),('c444ca00523cf2a50ecaf82f9a175a34','2204',NULL,6,'49','GPS速度',NULL,'3','GPS速度',NULL,NULL,1,0,'0'),('c45059cfdb7411e9b2f2000c2914004c','3020',NULL,1,'28','电锁状态',NULL,'5',NULL,NULL,'电钥匙打开-打开-1,电钥匙关闭-关闭-0',2,0,'0'),('c4505dd4db7411e9b2f2000c2914004c','4011','V',2,'28','供电电压','x/1000','3','输入电源电压',NULL,NULL,1,0,'0'),('c4505e50db7411e9b2f2000c2914004c','4012','V',3,'28','备用电池电压','x/1000','3','输入电池电压',NULL,NULL,1,0,'0'),('c4505ed2db7411e9b2f2000c2914004c','4352',NULL,15,'281','外壳状态',NULL,'2',NULL,NULL,'0-外壳关闭,1-外壳打开',0,0,'0'),('c45062cedb7411e9b2f2000c2914004c','4354',NULL,5,'28','开壳报警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('c4506380db7411e9b2f2000c2914004c','4355',NULL,18,'281','GPS 天线告警',NULL,'2',NULL,NULL,'0-正常,1-告警',0,0,'0'),('c45064b5db7411e9b2f2000c2914004c','4356',NULL,19,'281','CAN 异常告警',NULL,'2',NULL,NULL,'0-正常,1-告警',0,0,'0'),('c6dffe7c2398096b32eea1280b83056b','4356',NULL,19,'52','CAN 异常告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('c7f43f11fd43876e365ddf20ed9bcc0a','4007','Hz',9,'52','PWM1 输出频率',NULL,'3',NULL,NULL,NULL,1,0,'0'),('ca0b62826edb11e9a45b000c2914004c','4303','kPa',9,'24','燃油压力',NULL,NULL,'燃油压力',NULL,NULL,0,0,'0'),('cb41e53fd10a11e8a45b000c29140039','4285',NULL,17,'30','发动机扭矩模式',NULL,'3','发动机扭矩模式',NULL,NULL,1,0,'0'),('cb41e53fd10a11e8a45b000c2914004c','4285',NULL,17,'20','发动机扭矩模式',NULL,'3','发动机扭矩模式',NULL,NULL,1,0,'0'),('cb716d72f3190f1229bec7663d2c6046','2602','',1,'4b0bcd3b652b4f078f46cc5ef7768a8b','','','3','经度','7','',1,0,'1'),('cc875ed065b6b06cefd728f5d1048b70','4352',NULL,15,'52','外壳状态',NULL,'2',NULL,NULL,'0-外壳关闭,1-外壳打开',1,0,'0'),('ccd6f3ea885798de6a357bd8b595b32a','4355',NULL,18,'52','GPS 天线告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('ccfd84a43b614964bfecc225d3ca507c','4260',NULL,8,'18','GPS ID 匹配状态',NULL,'2','GPSID匹配状态',NULL,'0-不匹配,1-匹配',1,0,'0'),('cda517a90a7811e9bab7d0946600e1f1','4257','',5,'18','锁车状态','','2','锁车状态','','0-未锁车,1-一级锁车,2-二级锁车,9-待锁车',1,0,'0'),('cfe3c279607da123ccd44b090c024933','3012','',11,'4b0bcd3b652b4f078f46cc5ef7768a8b','','','3','方向','0','',1,0,'1'),('d330b620f32e45809c30243c7198c5c9','4108','kPa',5,'338698becb2b4b38ac6d5cecc29dbe99','机油压力','','3','engineOilPressure','0','',1,0,'1'),('d4103687f2d1d978b8975ecd58f88da4','4011','V',13,'52','输入电源电压','x/1000','3',NULL,NULL,NULL,1,0,'0'),('d562db0cf21c4cd4a13401bac08c0421','4254','MPa',18,'18',NULL,'x/1000','3','曲轴箱压力',NULL,NULL,1,0,'0'),('d80e535054fbf441892d1e6a52e655c2','4187','MPa',17,'50','液压系统压力','','3','hydraulicSystemPressure','','',1,0,'0'),('d87a76519673d4b14e390ad6b17de098','2205','km',14,'50','总里程','','3','totalMileage','','',1,0,'0'),('d882f7c70ff11f53928294de2dc391ed','4001',NULL,1,'52','开关量状态-ACC',NULL,'2',NULL,NULL,'0-电钥匙关闭,1- 电钥匙打开',1,0,'0'),('d8d6edf0a2d7e7f2633bdeb84430fcda','-1','',4,'4b0bcd3b652b4f078f46cc5ef7768a8b','当前位置','','4','当前位置(xml文件中不存在)','0','',0,0,'0'),('da3e9cb39cbb6c52c5496afc08b7070c','4003',NULL,3,'52','开关量状态-电平 1',NULL,'2',NULL,NULL,'0-低电平,1-高电平',1,0,'0'),('dbb9dd7f7d7b5c730bf46a1bf1b858dd','3006',NULL,8,'0ad4727a2920487cb436822b9da78c1a','固件版本号',NULL,NULL,NULL,NULL,NULL,1,0,'0'),('dc6a99d5eee011e8a45b000c2914004c','2602',NULL,1,'21',NULL,NULL,'3','经度',NULL,NULL,1,0,'0'),('dc6aa4e5eee011e8a45b000c2914004c','3012',NULL,5,'21',NULL,NULL,'3','方向',NULL,NULL,1,0,'0'),('dc6aa8caeee011e8a45b000c2914004c','2603',NULL,2,'21',NULL,NULL,'3','纬度',NULL,NULL,1,0,'0'),('dc6aaabeeee011e8a45b000c2914004c','-1',NULL,3,'21','当前位置',NULL,NULL,'当前位置(xml文件中不存在)',NULL,NULL,0,0,'0'),('dc6aad2deee011e8a45b000c2914004c','3019',NULL,7,'21',NULL,NULL,'2','GPS模块状态',NULL,'0- 模块正常,1-模块异常',1,0,'0'),('dc6aaed3eee011e8a45b000c2914004c','2204',NULL,4,'21','GPS速度',NULL,'3','GPS速度',NULL,NULL,1,0,'0'),('dc6ab044eee011e8a45b000c2914004c','3014',NULL,8,'21',NULL,NULL,'1','GPS时间',NULL,NULL,1,0,'0'),('dc6ab1a3eee011e8a45b000c2914004c','TIME',NULL,9,'21','回传时间',NULL,'1','接收时间',NULL,NULL,1,0,'0'),('dc6ab30deee011e8a45b000c2914004c','4014',NULL,6,'21',NULL,NULL,'3','水平精度因子',NULL,NULL,1,0,'0'),('ded7a5ad4c7545e8ba27e3b87cf49e0e','4259',NULL,7,'18','GPS Key 验证码',NULL,'2','Key验证码',NULL,'0-不正确,1-正确',1,0,'0'),('dfef5536eb3411e9b2f2000c2914004c','DATE_TYPE',NULL,-1,'30',NULL,NULL,NULL,NULL,NULL,NULL,0,0,'0'),('e08c033cd10a11e8a45b000c29140040','4286','%',18,'30','驾驶员要求的发动机-扭矩百分比',NULL,'3','驾驶员要求的发动机-扭矩百分比',NULL,NULL,1,0,'0'),('e08c033cd10a11e8a45b000c2914004c','4286','%',18,'20','驾驶员要求的发动机-扭矩百分比',NULL,'3','驾驶员要求的发动机-扭矩百分比',NULL,NULL,1,0,'0'),('e112bd84799311ea82d10894ef147327','3014',NULL,-0.1,'50','GPS时间',NULL,'1','GPS时间',NULL,NULL,1,0,'0'),('e31504ef6edb11e9a45b000c2914004c','4108','kPa',10,'24','机油压力',NULL,NULL,'机油压力',NULL,NULL,0,0,'0'),('e39efcc591b71381db6e46150c5fc2bb','3021',NULL,6,'52','终端 MOTO 状态',NULL,NULL,NULL,NULL,NULL,1,0,'0'),('e83fc3bbe76868fdb90ac5d05c70d8e7','4303','kPa',4,'50','燃油压力','','3','4303','','',1,0,'0'),('e8baa4adda0411e9b2f2000c29140012','3013','m',11,'29','海拔高度',NULL,'3','海拔高度',NULL,NULL,1,0,'0'),('e8baa4adda0411e9b2f2000c2914004c','3013','m',11,'19','海拔高度',NULL,'3','海拔高度',NULL,NULL,1,0,'0'),('e8baa4d7da0411e9b2f2000c29140013','3015',NULL,12,'29','使用卫星数',NULL,'3','使用卫星数',NULL,NULL,1,0,'0'),('e8baa4d7da0411e9b2f2000c2914004c','3015',NULL,12,'19','使用卫星数',NULL,'3','使用卫星数',NULL,NULL,1,0,'0'),('e8baa4dfda0411e9b2f2000c29140014','3016',NULL,13,'29','可视卫星数',NULL,'3','可视卫星数',NULL,NULL,1,0,'0'),('e8baa4dfda0411e9b2f2000c2914004c','3016',NULL,13,'19','可视卫星数',NULL,'3','可视卫星数',NULL,NULL,1,0,'0'),('e8c887ffeee011e8a45b000c2914004c','4288','%',21,'22','发动机负荷系数',NULL,'3','发动机负荷系数',NULL,NULL,1,0,'0'),('e8c88ff8eee011e8a45b000c2914004c','4291',NULL,25,'22','车身故障DM1',NULL,NULL,'车身故障DM1',NULL,NULL,0,0,'0'),('e8c89259eee011e8a45b000c2914004c','4289','%',22,'22','实际最大可用发动机-扭矩百分比',NULL,'3','实际最大可用发动机-扭矩百分比',NULL,NULL,1,0,'0'),('e8c893e9eee011e8a45b000c2914004c','4175','L/H',7,'22','燃油消耗率',NULL,'3','小时油耗',NULL,NULL,1,0,'0'),('e8c89564eee011e8a45b000c2914004c','4292',NULL,26,'22','车身故障DM2',NULL,NULL,'车身故障DM2',NULL,NULL,0,0,'0'),('e8c896bdeee011e8a45b000c2914004c','4279','RPM',1,'22','理想发动机转速',NULL,'3','理想发动机转速',NULL,NULL,2,0,'0'),('e8c89815eee011e8a45b000c2914004c','4110','Kpa',15,'22','发动机增压压力',NULL,'3','增压压力',NULL,NULL,1,0,'0'),('e8c89970eee011e8a45b000c2914004c','4280',NULL,3,'22','发动机等待启动灯',NULL,'3','发动机等待启动灯',NULL,NULL,1,0,'0'),('e8c89ac1eee011e8a45b000c2914004c','4281',NULL,5,'22','发动机保护系统已关闭发动机',NULL,'3','发动机保护系统已关闭发动机',NULL,NULL,1,0,'0'),('e8c89c12eee011e8a45b000c2914004c','4250','%',23,'22','标准摩擦-扭矩百分比',NULL,'3','摩擦扭矩百分比',NULL,NULL,1,0,'0'),('e8c89d55eee011e8a45b000c2914004c','4282','KM/L',8,'22','即时燃油经济性',NULL,'3','即时燃油经济性',NULL,NULL,1,0,'0'),('e8c89ec5eee011e8a45b000c2914004c','4290','%',24,'22','估计的发动机寄生损失-扭矩百分比',NULL,'3','估计的发动机寄生损失-扭矩百分比',NULL,NULL,1,0,'0'),('e8c8a029eee011e8a45b000c2914004c','4283','°C',13,'22','发动机进气管温度',NULL,'3','发动机进气管温度',NULL,NULL,1,0,'0'),('e8c8a179eee011e8a45b000c2914004c','4284','Kpa',16,'22','发动机进气压力',NULL,'3','发动机进气压力',NULL,NULL,1,0,'0'),('e8c8a2beeee011e8a45b000c2914004c','4243','℃',10,'22','发动机机油温度',NULL,'3','机油温度',NULL,NULL,1,0,'0'),('e8c8a40deee011e8a45b000c2914004c','4023','L',6,'22','发动机总燃油量',NULL,'3','累计油耗',NULL,NULL,1,0,'0'),('e8c8a6a7eee011e8a45b000c2914004c','4101','RPM',0,'22','发动机速度',NULL,'3','发动机转速',NULL,NULL,1,0,'0'),('e8c8a867eee011e8a45b000c2914004c','4108','MPa',4,'22','发动机机油压力','x/1000','3','机油压力',NULL,NULL,1,0,'0'),('e8c8a9bbeee011e8a45b000c2914004c','4163','H',2,'22','发动机总工作小时数','x/3600','3','发动机工作时间','2',NULL,2,0,'0'),('e8c8ab12eee011e8a45b000c2914004c','4103','%',19,'22','实际发动机-扭矩百分比',NULL,'3','发动机实际扭矩',NULL,NULL,1,0,'0'),('e8c8ac5beee011e8a45b000c2914004c','4109','Kpa',14,'22','大气压力',NULL,'3','大气压力',NULL,NULL,1,0,'0'),('e8c8adcbeee011e8a45b000c2914004c','4112','°C',12,'22','空气进气温度',NULL,'3','进气温度',NULL,NULL,1,0,'0'),('e8c8af2deee011e8a45b000c2914004c','4245','℃',11,'22','外界温度',NULL,'3','大气温度',NULL,NULL,1,0,'0'),('e8c8b089eee011e8a45b000c2914004c','4177','°C',9,'22','发动机冷却液温度',NULL,'3','冷却水温度',NULL,NULL,1,0,'0'),('e8c8b248eee011e8a45b000c2914004c','4285',NULL,17,'22','发动机扭矩模式',NULL,'3','发动机扭矩模式',NULL,NULL,1,0,'0'),('e8c8b4dbeee011e8a45b000c2914004c','4286','%',18,'22','驾驶员要求的发动机-扭矩百分比',NULL,'3','驾驶员要求的发动机-扭矩百分比',NULL,NULL,1,0,'0'),('e8c8b64ceee011e8a45b000c2914004c','4287','%',20,'22','发动机需求-扭矩百分比',NULL,'3','发动机需求-扭矩百分比',NULL,NULL,1,0,'0'),('e9fffc6785418627dcf3e7fc6398e31a','4175','L/h',9,'50','小时油耗','','3','instanFuel','','',1,0,'0'),('eb0f443f6eda11e9a45b000c2914004c','4023','L',2,'24','总耗油量',NULL,NULL,'总耗油量',NULL,NULL,0,0,'0'),('eb2d9f3f963e11e89b79000c292ded3c','4101','RPM',3,'18',NULL,NULL,'3','发动机转速',NULL,NULL,1,0,'0'),('eb2da81c963e11e89b79000c292ded3c','4100',NULL,2,'18',NULL,NULL,'3','冷却水温度',NULL,NULL,1,0,'0'),('eb2daabe963e11e89b79000c292ded3c','3026','V',1,'18',NULL,NULL,'3','电源电压',NULL,NULL,1,0,'0'),('eb3b41c93f114920b525b96bf6292357','4252','MPa',17,'18',NULL,'x/1000','3','绝对增压压力',NULL,NULL,1,0,'0'),('eb5711d2fc5a31259f5040dcb6b84c58','TIME',NULL,8,'49','回传时间',NULL,'1','接收时间',NULL,NULL,1,0,'0'),('ed772e1cabd7fa37a75a8e223b1ee777','4109','kPa',18,'50','大气压力','','3','atmosphericPressure','','',1,0,'0'),('f0b9eff33ff8c6ea2238661e8fbd639f','4014','',10,'4b0bcd3b652b4f078f46cc5ef7768a8b','','','3','水平精度因子','0','',1,0,'1'),('f26801f0afcad5dfcaab4eddf0903acc','4250','%',24,'50','摩擦扭矩百分比','','3','frictionTorqueTercentage','','',1,0,'0'),('f2c29afad10a11e8a45b000c29140041','4287','%',20,'30','发动机需求-扭矩百分比',NULL,'3','发动机需求-扭矩百分比',NULL,NULL,1,0,'0'),('f2c29afad10a11e8a45b000c2914004c','4287','%',20,'20','发动机需求-扭矩百分比',NULL,'3','发动机需求-扭矩百分比',NULL,NULL,1,0,'0'),('f30c677bdab911e9b2f2000c2914004c','4352',NULL,15,'27','外壳状态',NULL,'2',NULL,NULL,'0-外壳关闭,1-外壳打开',1,0,'0'),('f30c677bdab911e9b2f2000c29140077','4352',NULL,15,'33','外壳状态',NULL,'2',NULL,NULL,'0-外壳关闭,1-外壳打开',1,0,'0'),('f30c67a0dab911e9b2f2000c2914004c','4353',NULL,16,'27','拆除告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('f30c67a0dab911e9b2f2000c29140078','4353',NULL,16,'33','拆除告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('f30c67a6dab911e9b2f2000c2914004c','4354',NULL,17,'27','开壳告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('f30c67a6dab911e9b2f2000c29140079','4354',NULL,17,'33','开壳告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('f30c67abdab911e9b2f2000c2914004c','4355',NULL,18,'27','GPS 天线告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('f30c67abdab911e9b2f2000c29140080','4355',NULL,18,'33','GPS 天线告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('f30c67afdab911e9b2f2000c2914004c','4356',NULL,19,'27','CAN 异常告警',NULL,'2',NULL,NULL,'0-正常,1-告警',0,0,'0'),('f30c67afdab911e9b2f2000c29140081','4356',NULL,19,'33','CAN 异常告警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('f48805efb2d2376760c0262fb6e95a6c','4177','℃',7,'50','冷却水温度','','3','coolingWaterTemp','','',1,0,'0'),('f584ece9bddfbb86500421cb0b08ef9e','4163','H',11,'50','发动机工作时间','x/3600','3','engineWorkTime','','',1,0,'0'),('f8a9cdc52344cb128391d6e38d8683d2','4247','%',23,'50','发动机负荷','','3','engineLoad','','',1,0,'0'),('fbd94907db7411e9b2f2000c2914004c','4358',NULL,6,'28','定位天线断开报警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('fbd9490ddb7411e9b2f2000c2914004c','4359',NULL,7,'28','定位天线短路报警',NULL,'2',NULL,NULL,'0-正常,1-告警',1,0,'0'),('fbd94913db7411e9b2f2000c2914004c','3205',NULL,4,'28','电源断开报警',NULL,'',NULL,NULL,'',1,0,'0'),('fcaa7c395f4aa000be0050ff1fa7f8b8','2204','',7,'4b0bcd3b652b4f078f46cc5ef7768a8b','GPS速度','','3','GPS速度','0','',2,0,'1');
/*!40000 ALTER TABLE `biz_outfield_group_detail` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `biz_outfield_group_info`
--
DROP TABLE IF EXISTS `biz_outfield_group_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `biz_outfield_group_info` (
`id` char(32) NOT NULL,
`group_name` varchar(255) DEFAULT NULL COMMENT '组的名称（TAB页的名称）',
`group_sn` int(11) DEFAULT '0' COMMENT '组的序列号（TAB页的顺序）',
`remark` varchar(255) DEFAULT NULL COMMENT '备注信息 \\n0:常规信息；1：CAN信息;2：国四监控信息，3：诊断信息，4：设备信息',
`agreement_id` char(32) DEFAULT NULL COMMENT '协议ID',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `biz_outfield_group_info`
--
LOCK TABLES `biz_outfield_group_info` WRITE;
/*!40000 ALTER TABLE `biz_outfield_group_info` DISABLE KEYS */;
INSERT INTO `biz_outfield_group_info` VALUES ('0884e85a3b434d69946908651dbe8013','指令下发',2,'2','0bdf887d7d4d40b5975c04d31b655ce6'),('0ad4727a2920487cb436822b9da78c1a','设备信息',5,'5','0bdf887d7d4d40b5975c04d31b655ce6'),('1','常规信息',2,'0','7ef5fd7a538940b3a59e1c8c93016eef'),('10','CAN信息',1,'1','24fc65c5d94846333630a3dc3ca83142'),('11','常规信息',2,'0','3e14d204ae8c40f0801c0e0054dfc427'),('12','CAN信息',1,'1','3e14d204ae8c40f0801c0e0054dfc427'),('13','常规信息',2,'0','db92e9fdcacb433eba576d39d8a22424'),('14','CAN信息',1,'1','db92e9fdcacb433eba576d39d8a22424'),('15','CAN信息',1,'1','92be613241774effbac31e63119f00d8'),('16','常规信息',2,'0','92be613241774effbac31e63119f00d8'),('17','常规信息',2,'0','4810d5cf9d2c4e9da2e77215a2946d77'),('18','CAN信息',1,'1','4810d5cf9d2c4e9da2e77215a2946d77'),('19','常规信息',2,'0','9244dee5c44446f7829fecf1eb98a34f'),('2','CAN信息',1,'1','7ef5fd7a538940b3a59e1c8c93016eef'),('20','车身CAN信息',1,'1','9244dee5c44446f7829fecf1eb98a34f'),('21','常规信息',2,'0','e26779bb6ea44bf0bd7e8e504a5cafe8'),('22','CAN信息',1,'1','e26779bb6ea44bf0bd7e8e504a5cafe8'),('23','常规信息',2,'0','6143c92d4e9d478eb089a25dc98ea354'),('24','CAN信息',1,'1','6143c92d4e9d478eb089a25dc98ea354'),('25','国四监控信息',3,'2','9244dee5c44446f7829fecf1eb98a34f'),('26','诊断信息',4,'3','9244dee5c44446f7829fecf1eb98a34f'),('27','设备信息',5,'4','9244dee5c44446f7829fecf1eb98a34f'),('28','设备信息',5,'4','4810d5cf9d2c4e9da2e77215a2946d77'),('29','常规信息',2,'0','de9f0b6503ce43248a4a7e50cf97d115'),('3','常规信息',2,'0','24fc65c5d94846038670a3dc3ca83142'),('30','车身CAN信息',1,'1','de9f0b6503ce43248a4a7e50cf97d115'),('31','国四监控信息',3,'2','de9f0b6503ce43248a4a7e50cf97d115'),('32','诊断信息',4,'3','de9f0b6503ce43248a4a7e50cf97d115'),('33','设备信息',5,'4','de9f0b6503ce43248a4a7e50cf97d115'),('338698becb2b4b38ac6d5cecc29dbe99','CAN信息',1,'1','0bdf887d7d4d40b5975c04d31b655ce6'),('34','常规信息',2,'0','a91f789e70c545768dd2ff95c57fb88c'),('35','车身CAN信息',1,'1','a91f789e70c545768dd2ff95c57fb88c'),('36','国四监控信息',3,'2','a91f789e70c545768dd2ff95c57fb88c'),('37','诊断信息',4,'3','a91f789e70c545768dd2ff95c57fb88c'),('38','设备信息',5,'4','a91f789e70c545768dd2ff95c57fb88c'),('39','常规信息',2,'0','20e7d4fa4e104fde89d8c1408ba8942c'),('4','CAN信息',1,'1','24fc65c5d94846038670a3dc3ca83142'),('40','车身CAN信息',1,'1','20e7d4fa4e104fde89d8c1408ba8942c'),('41','国四监控信息',3,'2','20e7d4fa4e104fde89d8c1408ba8942c'),('42','诊断信息',4,'3','20e7d4fa4e104fde89d8c1408ba8942c'),('43','设备信息',5,'4','20e7d4fa4e104fde89d8c1408ba8942c'),('44','常规信息',2,'0','0abbabba314b45a797eec940edd2c8bf'),('45','车身CAN信息',1,'1','0abbabba314b45a797eec940edd2c8bf'),('46','国四监控信息',3,'2','0abbabba314b45a797eec940edd2c8bf'),('47','诊断信息',4,'3','0abbabba314b45a797eec940edd2c8bf'),('48','设备信息',5,'4','0abbabba314b45a797eec940edd2c8bf'),('49','常规信息',1,'0','03fb72169c5a4e10889e85d685c4008d'),('4b0bcd3b652b4f078f46cc5ef7768a8b','常规信息',0,'0','0bdf887d7d4d40b5975c04d31b655ce6'),('5','常规信息',1,'0','e08e3c73d76443f58ad5e9d2645dbd65'),('50','CAN信息',2,'1','03fb72169c5a4e10889e85d685c4008d'),('51','指令下发',3,'2','03fb72169c5a4e10889e85d685c4008d'),('52','设备信息',4,'5','03fb72169c5a4e10889e85d685c4008d'),('8','常规信息',1,'0','e08e3c73d764ddf58dd5e9d2645dbd65'),('9','常规信息',2,'0','24fc65c5d94846333630a3dc3ca83142');
/*!40000 ALTER TABLE `biz_outfield_group_info` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `biz_vehicle_type`
--
DROP TABLE IF EXISTS `biz_vehicle_type`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `biz_vehicle_type` (
`type_id` char(32) NOT NULL,
`type_name` varchar(50) NOT NULL COMMENT '代码',
`org_id` varchar(45) NOT NULL COMMENT '机构ID',
`mark` int(1) DEFAULT NULL COMMENT '模板标识 0:公共模板；1私有模板',
`brand` varchar(50) DEFAULT NULL COMMENT '品牌',
`model_name` varchar(45) DEFAULT NULL COMMENT '型号名称',
`powerrating` int(6) DEFAULT NULL COMMENT '额定功率',
`classify` varchar(50) DEFAULT NULL COMMENT '所属分类',
`size` varchar(45) DEFAULT NULL COMMENT '尺寸',
`in_use` int(1) DEFAULT NULL COMMENT '0:未使用；1：使用',
`v_org_id` varchar(45) DEFAULT NULL COMMENT '车型的机构ID',
`is_intelligent` int(11) DEFAULT NULL COMMENT '是否是智能终端，已弃用',
`is_filter_missing_column` bit(1) DEFAULT NULL COMMENT '是否过滤丢失字段\\\\\\\\n0、不过滤；1、过滤',
PRIMARY KEY (`type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `biz_vehicle_type`
--
LOCK TABLES `biz_vehicle_type` WRITE;
/*!40000 ALTER TABLE `biz_vehicle_type` DISABLE KEYS */;
INSERT INTO `biz_vehicle_type` VALUES ('03fb72169c5a4e10889e85d685c4008d','临工车辆类型','a2c1c88cdba246bca14671cfd62b7bb0',1,NULL,NULL,0,NULL,NULL,1,NULL,NULL,NULL),('052a63d8cb4a4f36a2cccd8429e7ba6e','收割机','61727e241f814593942a5bfbb720d649',1,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL),('0abbabba314b45a797eec940edd2c8bf','卡特彼勒内部测试车型','194ac518db9147b1a7fadf843b9546a4',1,NULL,NULL,0,NULL,NULL,1,NULL,NULL,NULL),('0bdf887d7d4d40b5975c04d31b655ce6','挖机','b49830825cd842d1b65e913b12d5f0e5',1,NULL,NULL,0,NULL,NULL,1,NULL,NULL,NULL),('20e7d4fa4e104fde89d8c1408ba8942c','长征测试机型','b72650b7a85545a0b1d5c9693e98e7f5',1,NULL,NULL,0,NULL,NULL,1,NULL,NULL,NULL),('24fc65c5d94846038670a3dc3ca83142','农机慧眼一体机CAN','000022dafc444b949af0684538b85e08',0,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL),('24fc65c5d94846333630a3dc3ca83142','农机慧眼一体机CAN-时风','e1ba1d0f36a9467a9369e92003fe998a',0,NULL,NULL,0,NULL,NULL,1,NULL,NULL,NULL),('4810d5cf9d2c4e9da2e77215a2946d77','装载机-英轩重工','a036e9986b6f4c4fa9a27c7b442c129a',1,NULL,NULL,0,NULL,NULL,1,NULL,NULL,NULL),('5da491a0cb9744bca07a6751606faf5b','深翻机','61727e241f814593942a5bfbb720d649',1,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL),('6143c92d4e9d478eb089a25dc98ea354','安百拓车型','819c20240c984a4e8de6bfd8c89a2358',1,NULL,NULL,0,NULL,NULL,1,NULL,NULL,NULL),('65978071b5084857b494c1169389c7d4','履带式拖拉机','34bac7f643844259898ca92875762c96',1,NULL,NULL,0,NULL,NULL,1,NULL,NULL,NULL),('7ef5fd7a538940b3a59e1c8c93016eef','拖拉机车辆类型','34bac7f643844259898ca92875762c96',1,NULL,NULL,0,NULL,NULL,1,NULL,NULL,NULL),('807cfd3dda2c47f390812e9f1790c808','lucky','be2ac410ceb04a83b8671d6e27ce3a23',1,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL),('9244dee5c44446f7829fecf1eb98a34f','卡特彼勒测试机型','b8721c2d62a7422d9cd18e1ae318649c',1,NULL,NULL,0,NULL,NULL,1,NULL,NULL,NULL),('92be613241774effbac31e63119f00d8','挖掘机-嘉和','70320d7d2c1c4a97a5371ec4da32b736',1,NULL,NULL,0,NULL,NULL,1,NULL,NULL,NULL),('a91f789e70c545768dd2ff95c57fb88c','玉柴发动机','af4fe7c7854246269bd338cf761c827d',1,NULL,NULL,0,NULL,NULL,1,NULL,NULL,NULL),('b149a489fcb94ee4874503f48ba53144','111','61727e241f814593942a5bfbb720d649',1,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL),('b41c896c036c45979d7cacb878841535','sky','be2ac410ceb04a83b8671d6e27ce3a23',1,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL),('de9f0b6503ce43248a4a7e50cf97d115','卡特彼勒测试专用机型','d70c987fd05e43a3a479f41ff84792a9',1,NULL,NULL,0,NULL,NULL,1,NULL,NULL,NULL),('e08e3c73d76443f58ad5e9d2645dbd65','农机慧眼一体机','34bac7f643844259898ca92875762c96',0,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL),('e08e3c73d764ddf58dd5e9d2645dbd65','农机慧眼深松一体机','34bac7f643844259898ca92875762c96',0,NULL,NULL,0,NULL,NULL,1,NULL,NULL,NULL),('e26779bb6ea44bf0bd7e8e504a5cafe8','卡特彼勒测试机型','a4afab015f8d49c58e4accb25b012059',1,NULL,NULL,0,NULL,NULL,1,NULL,NULL,NULL);
/*!40000 ALTER TABLE `biz_vehicle_type` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sys_organization`
--
DROP TABLE IF EXISTS `sys_organization`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_organization` (
`id` char(32) NOT NULL,
`org_name` varchar(50) DEFAULT NULL,
`org_ids` varchar(2000) DEFAULT NULL,
`parent_id` char(32) DEFAULT NULL,
`create_time` datetime DEFAULT NULL,
`update_time` datetime DEFAULT NULL,
`update_user_id` char(32) DEFAULT NULL,
`in_use` int(1) DEFAULT '0' COMMENT '0不\n\n可用1可用',
`is_manufacturer` int(1) DEFAULT NULL COMMENT '组织机构类型,0、企业；1、厂商；3、代理商；4、经销商；5、其他；-1、平台节点',
`manufacturer_id` char(32) DEFAULT NULL COMMENT '所属厂商',
`province` char(50) DEFAULT NULL,
`city` char(50) DEFAULT NULL,
`county` char(100) DEFAULT NULL,
`province_code` char(10) DEFAULT NULL,
`county_code` char(10) DEFAULT NULL,
`city_code` char(10) DEFAULT NULL,
`old_org_ids` varchar(2000) DEFAULT NULL,
`new_org_ids` varchar(2000) DEFAULT NULL,
`order_id` int(11) DEFAULT '0',
`domain_name` varchar(45) DEFAULT '',
`login_url` varchar(200) DEFAULT '',
`home_url` varchar(200) DEFAULT '',
`LogoFile` blob COMMENT 'logo文件',
`FileNameExtension` varchar(10) DEFAULT '' COMMENT '文件扩展名',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sys_organization`
--
LOCK TABLES `sys_organization` WRITE;
/*!40000 ALTER TABLE `sys_organization` DISABLE KEYS */;
INSERT INTO `sys_organization` VALUES (''00f96888f1f84d268d92b4de455b20a0'',''机构测试2'',''#19dee55f0cc54a7f9b39bfc9c4ded670#34bac7f643844259898ca92875762c96#9403c348216f4152bc626dea1f447755#9418e3d6246f49e6aeb11c3e3bb22b6c#00f96888f1f84d268d92b4de455b20a0#'',''9418e3d6246f49e6aeb11c3e3bb22b6c'',''2018-08-23 08:57:30'',NULL,NULL,0,4,''34bac7f643844259898ca92875762c96'',''天津市'',''市辖区'',''河东区'',''120000'',''120102'',''120100'',''00010001000200020004'',NULL,1,'''','''','''',NULL,''''),(''04f1bbcd4531455d839f0ecc5fc860fa'',''嘉和烟台代理'',''#19dee55f0cc54a7f9b39bfc9c4ded670#70320d7d2c1c4a97a5371ec4da32b736#04f1bbcd4531455d839f0ecc5fc860fa#'',''70320d7d2c1c4a97a5371ec4da32b736'',''2018-08-22 10:57:49'',NULL,NULL,1,3,''70320d7d2c1c4a97a5371ec4da32b736'',''山东省'',''烟台市'',''市辖区'',''370000'',''370601'',''370600'',''000100150004'',NULL,3,'''','''',''/summary/index'',NULL,''.png''),(''064a6a1609d54bed8546e23d28eecb3e'',''工程机械-经销商'',''#19dee55f0cc54a7f9b39bfc9c4ded670#a036e9986b6f4c4fa9a27c7b442c129a#86837a29ef3f4593a71aaf619a3a1212#064a6a1609d54bed8546e23d28eecb3e#'',''86837a29ef3f4593a71aaf619a3a1212'',''2019-09-19 17:32:08'',NULL,NULL,1,0,''a036e9986b6f4c4fa9a27c7b442c129a'',''山东省'',''潍坊市'',''昌乐县'',''370000'',''370725'',''370700'',''0001002300010004'',NULL,1,'''','''','''',NULL,''''),(''0bb68199267f42969e602498c061b13c'',''嘉和菏泽代理'',''#19dee55f0cc54a7f9b39bfc9c4ded670#70320d7d2c1c4a97a5371ec4da32b736#0bb68199267f42969e602498c061b13c#'',''70320d7d2c1c4a97a5371ec4da32b736'',''2018-08-22 10:53:53'',NULL,NULL,1,3,''70320d7d2c1c4a97a5371ec4da32b736'',''山东省'',''德州市'',''东城区'',''370000'',''110101'',''371400'',''000100150003'',NULL,2,'''','''',''/summary/index'',NULL,''.png''),(''194ac518db9147b1a7fadf843b9546a4'',''卡特彼勒博创内部测试'',''#19dee55f0cc54a7f9b39bfc9c4ded670#194ac518db9147b1a7fadf843b9546a4#'',''19dee55f0cc54a7f9b39bfc9c4ded670'',''2019-11-28 17:01:21'',NULL,NULL,1,1,''194ac518db9147b1a7fadf843b9546a4'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''00010038'',NULL,9,'''','''','''',NULL,''''),(''19dee55f0cc54a7f9b39bfc9c4ded670'',''工程机械生产管理平台'',''#19dee55f0cc54a7f9b39bfc9c4ded670#'',NULL,NULL,''2016-09-09 15:03:00'',''0c008d48110e420c9a1ff48e51860156'',1,-1,NULL,''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''0001'',''#19dee55f0cc54a7f9b39bfc9c4ded670#'',0,'''','''','''',NULL,''.png''),(''34bac7f643844259898ca92875762c96'',''山东五征集团'',''#19dee55f0cc54a7f9b39bfc9c4ded670#34bac7f643844259898ca92875762c96#'',''19dee55f0cc54a7f9b39bfc9c4ded670'',''2017-10-31 15:54:42'',NULL,NULL,1,1,''34bac7f643844259898ca92875762c96'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''00010001'',NULL,-1,'''','''','''',NULL,''.png''),(''62edc42e3d73485b9b7021f9492ba40f'',''英轩重工长时间测试'',''#19dee55f0cc54a7f9b39bfc9c4ded670#a036e9986b6f4c4fa9a27c7b442c129a#62edc42e3d73485b9b7021f9492ba40f#'',''a036e9986b6f4c4fa9a27c7b442c129a'',''2020-06-01 09:36:24'',NULL,NULL,1,0,''a036e9986b6f4c4fa9a27c7b442c129a'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''000100230004'',NULL,2,'''','''','''',NULL,''''),(''64545bcba3d34fb28edd8849a05d9d05'',''经销商演示机构'',''#19dee55f0cc54a7f9b39bfc9c4ded670#a4afab015f8d49c58e4accb25b012059#64545bcba3d34fb28edd8849a05d9d05#'',''a4afab015f8d49c58e4accb25b012059'',''2020-04-03 09:40:11'',NULL,NULL,1,4,''a4afab015f8d49c58e4accb25b012059'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''000100300001'',NULL,0,'''','''','''',NULL,''''),(''6983646475dc4242a79a17fea9893a34'',''英轩测试子企业的子企业'',''#19dee55f0cc54a7f9b39bfc9c4ded670#a036e9986b6f4c4fa9a27c7b442c129a#9e1ba94554af4656bc5a4954cddd7ece#6983646475dc4242a79a17fea9893a34#'',''9e1ba94554af4656bc5a4954cddd7ece'',''2018-11-29 15:55:01'',NULL,NULL,1,0,''a036e9986b6f4c4fa9a27c7b442c129a'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''0001002300030001'',NULL,0,'''','''','''','''',NULL),(''6ab1fa8091104f54951c292beb6d91d0'',''嘉和济宁代理'',''#19dee55f0cc54a7f9b39bfc9c4ded670#70320d7d2c1c4a97a5371ec4da32b736#6ab1fa8091104f54951c292beb6d91d0#'',''70320d7d2c1c4a97a5371ec4da32b736'',''2018-08-22 15:39:04'',NULL,NULL,1,3,''70320d7d2c1c4a97a5371ec4da32b736'',''山东省'',''济宁市'',''市辖区'',''370000'',''370801'',''370800'',''000100150005'',NULL,4,'''','''','''',NULL,''''),(''70320d7d2c1c4a97a5371ec4da32b736'',''泰安嘉和重工'',''#19dee55f0cc54a7f9b39bfc9c4ded670#70320d7d2c1c4a97a5371ec4da32b736#'',''19dee55f0cc54a7f9b39bfc9c4ded670'',''2018-07-03 11:31:14'',NULL,NULL,1,1,''70320d7d2c1c4a97a5371ec4da32b736'',''山东省'',''泰安市'',''泰山区'',''370000'',''370902'',''370900'',''00010015'',NULL,4,'''','''','''',NULL,''''),(''7dabc93eb2bf413283d24ef7c3a8cf73'',''企业0625'',''#19dee55f0cc54a7f9b39bfc9c4ded670#34bac7f643844259898ca92875762c96#7dabc93eb2bf413283d24ef7c3a8cf73#'',''34bac7f643844259898ca92875762c96'',''2019-06-25 10:50:57'',NULL,NULL,0,0,''34bac7f643844259898ca92875762c96'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''000100010006'',NULL,4,'''','''','''',NULL,''''),(''819c20240c984a4e8de6bfd8c89a2358'',''安百拓'',''#19dee55f0cc54a7f9b39bfc9c4ded670#819c20240c984a4e8de6bfd8c89a2358#'',''19dee55f0cc54a7f9b39bfc9c4ded670'',''2019-05-05 10:07:48'',NULL,NULL,1,1,''819c20240c984a4e8de6bfd8c89a2358'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''00010034'',NULL,10,'''','''','''',NULL,''''),(''84f7e24f4251457981583878b61c712b'',''泰安嘉和代理商'',''#19dee55f0cc54a7f9b39bfc9c4ded670#70320d7d2c1c4a97a5371ec4da32b736#84f7e24f4251457981583878b61c712b#'',''70320d7d2c1c4a97a5371ec4da32b736'',''2018-08-21 20:12:58'',NULL,NULL,1,3,''70320d7d2c1c4a97a5371ec4da32b736'',''山东省'',''泰安市'',''东城区'',''370000'',''110101'',''370900'',''000100150001'',NULL,0,'''','''','''',NULL,''''),(''86837a29ef3f4593a71aaf619a3a1212'',''工程机械事业部'',''#19dee55f0cc54a7f9b39bfc9c4ded670#a036e9986b6f4c4fa9a27c7b442c129a#86837a29ef3f4593a71aaf619a3a1212#'',''a036e9986b6f4c4fa9a27c7b442c129a'',''2018-08-21 11:14:54'',NULL,NULL,1,0,''a036e9986b6f4c4fa9a27c7b442c129a'',''山东省'',''潍坊市'',''昌乐县'',''370000'',''370725'',''370700'',''000100230001'',NULL,0,'''','''','''',NULL,''''),(''8d197c67f44440f6948d1508b1f817b5'',''代理商演示机构'',''#19dee55f0cc54a7f9b39bfc9c4ded670#a4afab015f8d49c58e4accb25b012059#64545bcba3d34fb28edd8849a05d9d05#8d197c67f44440f6948d1508b1f817b5#'',''64545bcba3d34fb28edd8849a05d9d05'',''2020-04-03 09:40:22'',NULL,NULL,1,3,''a4afab015f8d49c58e4accb25b012059'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''0001003000010001'',NULL,0,'''','''','''',NULL,''''),(''9403c348216f4152bc626dea1f447755'',''五征子机构测试'',''#19dee55f0cc54a7f9b39bfc9c4ded670#34bac7f643844259898ca92875762c96#9403c348216f4152bc626dea1f447755#'',''34bac7f643844259898ca92875762c96'',''2018-08-21 14:02:22'',NULL,NULL,1,0,''34bac7f643844259898ca92875762c96'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''000100010002'',NULL,1,'''','''',''/'',NULL,''''),(''9418e3d6246f49e6aeb11c3e3bb22b6c'',''子机构下新增子机构测试'',''#19dee55f0cc54a7f9b39bfc9c4ded670#34bac7f643844259898ca92875762c96#9403c348216f4152bc626dea1f447755#9418e3d6246f49e6aeb11c3e3bb22b6c#'',''9403c348216f4152bc626dea1f447755'',''2018-08-21 14:39:01'',NULL,NULL,0,4,''34bac7f643844259898ca92875762c96'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''0001000100020002'',NULL,0,'''','''',''/'',NULL,''''),(''9737a00ff14a43a4881d895d4db38aad'',''1111'',''#19dee55f0cc54a7f9b39bfc9c4ded670#34bac7f643844259898ca92875762c96#9403c348216f4152bc626dea1f447755#9737a00ff14a43a4881d895d4db38aad#'',''9403c348216f4152bc626dea1f447755'',''2019-10-14 16:37:28'',NULL,NULL,0,4,''34bac7f643844259898ca92875762c96'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''0001000100020003'',NULL,0,'''','''','''',NULL,''''),(''9bd00cc36c0a4815af1eb133f9f8637f'',''工程机械-厂内'',''#19dee55f0cc54a7f9b39bfc9c4ded670#a036e9986b6f4c4fa9a27c7b442c129a#86837a29ef3f4593a71aaf619a3a1212#9bd00cc36c0a4815af1eb133f9f8637f#'',''86837a29ef3f4593a71aaf619a3a1212'',''2019-09-19 17:32:27'',NULL,NULL,1,0,''a036e9986b6f4c4fa9a27c7b442c129a'',''山东省'',''潍坊市'',''昌乐县'',''370000'',''370725'',''370700'',''0001002300010005'',NULL,2,'''','''','''',NULL,''''),(''9e1ba94554af4656bc5a4954cddd7ece'',''车队'',''#19dee55f0cc54a7f9b39bfc9c4ded670#a036e9986b6f4c4fa9a27c7b442c129a#9e1ba94554af4656bc5a4954cddd7ece#'',''a036e9986b6f4c4fa9a27c7b442c129a'',''2018-11-29 15:54:14'',NULL,NULL,1,0,''a036e9986b6f4c4fa9a27c7b442c129a'',''山东省'',''潍坊市'',''昌乐县'',''370000'',''370725'',''370700'',''000100230003'',NULL,2,'''','''','''','''',NULL),(''a036e9986b6f4c4fa9a27c7b442c129a'',''英轩集团'',''#19dee55f0cc54a7f9b39bfc9c4ded670#a036e9986b6f4c4fa9a27c7b442c129a#'',''19dee55f0cc54a7f9b39bfc9c4ded670'',''2018-08-02 18:01:46'',NULL,NULL,1,1,''a036e9986b6f4c4fa9a27c7b442c129a'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''00010023'',NULL,7,'''','''','''',NULL,''yxpng''),(''a1275580fcbe48428bdd348975c1dacc'',''英轩重工'',''#19dee55f0cc54a7f9b39bfc9c4ded670#a036e9986b6f4c4fa9a27c7b442c129a#62edc42e3d73485b9b7021f9492ba40f#a1275580fcbe48428bdd348975c1dacc#'',''62edc42e3d73485b9b7021f9492ba40f'',''2020-10-28 16:19:18'',NULL,NULL,1,0,''a036e9986b6f4c4fa9a27c7b442c129a'',''山东省'',''潍坊市'',''市辖区'',''370000'',''370701'',''370700'',''0001002300040001'',NULL,0,'''','''','''',NULL,''''),(''a1d8e0bc767c46babad028be98266a9c'',''五征代理商'',''#19dee55f0cc54a7f9b39bfc9c4ded670#34bac7f643844259898ca92875762c96#a1d8e0bc767c46babad028be98266a9c#'',''34bac7f643844259898ca92875762c96'',''2018-08-21 11:38:26'',NULL,NULL,1,3,''34bac7f643844259898ca92875762c96'',''山东省'',''济南市'',''市辖区'',''370000'',''370101'',''370100'',''000100010001'',NULL,0,'''','''','''',NULL,''''),(''a2c1c88cdba246bca14671cfd62b7bb0'',''临工'',''#19dee55f0cc54a7f9b39bfc9c4ded670#a2c1c88cdba246bca14671cfd62b7bb0#'',''19dee55f0cc54a7f9b39bfc9c4ded670'',''2020-04-10 17:13:01'',NULL,NULL,1,1,''a2c1c88cdba246bca14671cfd62b7bb0'',''山东省'',''济南市'',''市辖区'',''370000'',''370101'',''370100'',''00010039'',NULL,10,'''','''','''',NULL,''''),(''a4afab015f8d49c58e4accb25b012059'',''演示专用机构'',''#19dee55f0cc54a7f9b39bfc9c4ded670#a4afab015f8d49c58e4accb25b012059#'',''19dee55f0cc54a7f9b39bfc9c4ded670'',''2018-11-23 11:44:46'',NULL,NULL,1,1,''a4afab015f8d49c58e4accb25b012059'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''00010030'',NULL,6,'''','''','''','''',NULL),(''af4fe7c7854246269bd338cf761c827d'','' 广西玉柴机器集团有限公司'',''#19dee55f0cc54a7f9b39bfc9c4ded670#af4fe7c7854246269bd338cf761c827d#'',''19dee55f0cc54a7f9b39bfc9c4ded670'',''2019-09-29 11:36:14'',NULL,NULL,1,1,''af4fe7c7854246269bd338cf761c827d'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''00010036'',NULL,7,'''','''','''',NULL,''''),(''b1068cde7d8044b2b5f4f8685a1a57ba'',''测试'',''#19dee55f0cc54a7f9b39bfc9c4ded670#34bac7f643844259898ca92875762c96#b1068cde7d8044b2b5f4f8685a1a57ba#'',''34bac7f643844259898ca92875762c96'',''2018-11-30 14:18:50'',NULL,NULL,0,0,''34bac7f643844259898ca92875762c96'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''000100010004'',NULL,2,'''','''','''',NULL,''''),(''b2d8bd21fd154876bc4a0f3b37e8fbbb'',''嘉和日照代理'',''#19dee55f0cc54a7f9b39bfc9c4ded670#70320d7d2c1c4a97a5371ec4da32b736#b2d8bd21fd154876bc4a0f3b37e8fbbb#'',''70320d7d2c1c4a97a5371ec4da32b736'',''2018-08-22 15:40:31'',NULL,NULL,1,3,''70320d7d2c1c4a97a5371ec4da32b736'',''山东省'',''日照市'',''市辖区'',''370000'',''371101'',''371100'',''000100150006'',NULL,5,'''','''','''',NULL,''''),(''b49623570d4e4f8f8f519c0a8861abfa'',''99999999999999999999999999999999999999999999999999'',''#19dee55f0cc54a7f9b39bfc9c4ded670#34bac7f643844259898ca92875762c96#9403c348216f4152bc626dea1f447755#9418e3d6246f49e6aeb11c3e3bb22b6c#b49623570d4e4f8f8f519c0a8861abfa#'',''9418e3d6246f49e6aeb11c3e3bb22b6c'',''2019-06-18 16:13:53'',NULL,NULL,0,3,''34bac7f643844259898ca92875762c96'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''00010001000200020005'',NULL,2,'''','''','''',NULL,''''),(''b49830825cd842d1b65e913b12d5f0e5'',''山东泽圳机电有限公司'',''#19dee55f0cc54a7f9b39bfc9c4ded670#b49830825cd842d1b65e913b12d5f0e5#'',''19dee55f0cc54a7f9b39bfc9c4ded670'',''2020-06-17 15:43:18'',NULL,NULL,1,1,''b49830825cd842d1b65e913b12d5f0e5'',''山东省'',''临沂市'',''临沭县'',''370000'',''371329'',''371300'',''00010040'',NULL,11,'''','''','''',NULL,''''),(''b72650b7a85545a0b1d5c9693e98e7f5'',''河北长征汽车制造有限公司'',''#19dee55f0cc54a7f9b39bfc9c4ded670#b72650b7a85545a0b1d5c9693e98e7f5#'',''19dee55f0cc54a7f9b39bfc9c4ded670'',''2019-11-18 09:50:25'',NULL,NULL,1,1,''b72650b7a85545a0b1d5c9693e98e7f5'',''河北省'',''邢台市'',''邢台县'',''130000'',''130521'',''130500'',''00010037'',NULL,8,'''','''','''',NULL,''''),(''b8721c2d62a7422d9cd18e1ae318649c'',''卡特彼勒'',''#19dee55f0cc54a7f9b39bfc9c4ded670#b8721c2d62a7422d9cd18e1ae318649c#'',''19dee55f0cc54a7f9b39bfc9c4ded670'',''2018-10-16 13:39:49'',NULL,NULL,1,1,''b8721c2d62a7422d9cd18e1ae318649c'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''00010024'',NULL,3,'''','''','''','''',NULL),(''c11905a497e4499b817f33b763e10235'',''兴旺经销商'',''#19dee55f0cc54a7f9b39bfc9c4ded670#a036e9986b6f4c4fa9a27c7b442c129a#86837a29ef3f4593a71aaf619a3a1212#064a6a1609d54bed8546e23d28eecb3e#c11905a497e4499b817f33b763e10235#'',''064a6a1609d54bed8546e23d28eecb3e'',''2020-04-07 14:09:27'',NULL,NULL,1,4,''a036e9986b6f4c4fa9a27c7b442c129a'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''00010023000100040002'',NULL,1,'''','''','''',NULL,''''),(''c6d3dfb7afc548438989aa6f6b472071'',''嘉和德州代理'',''#19dee55f0cc54a7f9b39bfc9c4ded670#70320d7d2c1c4a97a5371ec4da32b736#c6d3dfb7afc548438989aa6f6b472071#'',''70320d7d2c1c4a97a5371ec4da32b736'',''2018-08-22 09:44:44'',NULL,NULL,1,3,''70320d7d2c1c4a97a5371ec4da32b736'',''山东省'',''德州市'',''市辖区'',''370000'',''371401'',''371400'',''000100150002'',NULL,1,'''','''','''',NULL,''''),(''c9fce339f5a24283a573c6c12b44187a'',''测试0620'',''#19dee55f0cc54a7f9b39bfc9c4ded670#34bac7f643844259898ca92875762c96#c9fce339f5a24283a573c6c12b44187a#'',''34bac7f643844259898ca92875762c96'',''2019-06-20 17:22:10'',NULL,NULL,0,0,''34bac7f643844259898ca92875762c96'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''000100010005'',NULL,3,'''','''','''',NULL,''''),(''cb35ca1e984c4172b7824ea9dd4cf440'',''子机构测试'',''#19dee55f0cc54a7f9b39bfc9c4ded670#34bac7f643844259898ca92875762c96#9403c348216f4152bc626dea1f447755#9418e3d6246f49e6aeb11c3e3bb22b6c#cb35ca1e984c4172b7824ea9dd4cf440#'',''9418e3d6246f49e6aeb11c3e3bb22b6c'',''2018-08-23 08:55:51'',NULL,NULL,0,4,''34bac7f643844259898ca92875762c96'',''北京市'',''市辖区'',''西城区'',''110000'',''110102'',''110100'',''00010001000200020003'',NULL,0,'''','''','''',NULL,''''),(''d70c987fd05e43a3a479f41ff84792a9'',''卡特彼勒测试'',''#19dee55f0cc54a7f9b39bfc9c4ded670#d70c987fd05e43a3a479f41ff84792a9#'',''19dee55f0cc54a7f9b39bfc9c4ded670'',''2019-09-25 08:42:25'',NULL,NULL,1,1,''d70c987fd05e43a3a479f41ff84792a9'',''北京市'',''市辖区'',''西城区'',''110000'',''110102'',''110100'',''00010035'',NULL,6,'''','''','''',NULL,''''),(''dbe7ce06e2bd4311b329c161c84bfeb3'',''小经销商'',''#19dee55f0cc54a7f9b39bfc9c4ded670#b8721c2d62a7422d9cd18e1ae318649c#fa4d7df7634e4c83b19b8c42d583cdb9#dbe7ce06e2bd4311b329c161c84bfeb3#'',''fa4d7df7634e4c83b19b8c42d583cdb9'',''2018-11-26 10:44:38'',NULL,NULL,1,4,''b8721c2d62a7422d9cd18e1ae318649c'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''0001002400010001'',NULL,0,'''','''','''','''',NULL),(''dfcdb40807944bd1aec8dd49b49cc2bb'',''经销商0625-2'',''#19dee55f0cc54a7f9b39bfc9c4ded670#34bac7f643844259898ca92875762c96#dfcdb40807944bd1aec8dd49b49cc2bb#'',''34bac7f643844259898ca92875762c96'',''2019-06-25 11:02:17'',NULL,NULL,1,4,''34bac7f643844259898ca92875762c96'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''000100010007'',NULL,5,'''','''','''',NULL,''''),(''e2a76a9522c7483eba93e7bf9962116c'',''英轩经销商'',''#19dee55f0cc54a7f9b39bfc9c4ded670#a036e9986b6f4c4fa9a27c7b442c129a#86837a29ef3f4593a71aaf619a3a1212#064a6a1609d54bed8546e23d28eecb3e#e2a76a9522c7483eba93e7bf9962116c#'',''064a6a1609d54bed8546e23d28eecb3e'',''2019-09-19 17:32:57'',NULL,NULL,1,4,''a036e9986b6f4c4fa9a27c7b442c129a'',''山东省'',''潍坊市'',''昌乐县'',''370000'',''370725'',''370700'',''00010023000100040001'',NULL,0,'''','''','''',NULL,''''),(''fa4d7df7634e4c83b19b8c42d583cdb9'',''卡特下属代理'',''#19dee55f0cc54a7f9b39bfc9c4ded670#b8721c2d62a7422d9cd18e1ae318649c#fa4d7df7634e4c83b19b8c42d583cdb9#'',''b8721c2d62a7422d9cd18e1ae318649c'',''2018-11-20 14:36:47'',NULL,NULL,1,3,''b8721c2d62a7422d9cd18e1ae318649c'',''北京市'',''市辖区'',''东城区'',''110000'',''110101'',''110100'',''000100240001'',NULL,0,'''','''','''','''',NULL);
/*!40000 ALTER TABLE `sys_organization` ENABLE KEYS */;
--
-- Table structure for table `biz_command_config`
--
DROP TABLE IF EXISTS `biz_command_config`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `biz_command_config` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`commandName` varchar(45) DEFAULT NULL COMMENT '指令名称',
`url` varchar(45) DEFAULT '',
`description` varchar(255) DEFAULT NULL COMMENT '指令描述',
`renderTemplate` varchar(255) DEFAULT NULL,
`paramTemplate` varchar(255) DEFAULT NULL,
`defaultValue` varchar(255) DEFAULT NULL COMMENT '控件默认值',
`groupType` int(11) DEFAULT NULL COMMENT '分组类型，用于前端渲染处理',
`isDelete` int(11) DEFAULT '0' COMMENT '0、未删除；1、已删除',
`createTime` datetime(6) DEFAULT NULL,
`updateTime` datetime(6) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='指令配置表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `biz_command_config`
--
LOCK TABLES `biz_command_config` WRITE;
/*!40000 ALTER TABLE `biz_command_config` DISABLE KEYS */;
INSERT INTO `biz_command_config` VALUES (1,'设置宽幅','/command/api/farm/setParams','设置宽幅','输入宽幅|setWidth|input','setWidth={setWidth}','',0,0,NULL,'2020-06-28 05:50:54.859553'),(2,'设置终端休眠时间','/command/api/farm/setParams','设置终端休眠时间','输入休眠时间|terminalSleepTime|input','terminalSleepTime={terminalSleepTime}','',0,0,'2020-05-14 09:25:02.330064','2020-06-28 05:50:51.851002'),(3,'设置网关','/command/api/farm/setParams','设置网关','域名|platformDomainName|input,端口|platformPort|input','platformDomainName={platformDomainName}|platformPort={platformPort}','',0,0,'2020-06-03 05:28:17.823309','2020-06-28 05:50:48.460262'),(4,'清除亩数','/command/api/farm/setParams','清除亩数','输入亩数|clearArea|input','clearArea={clearArea}','',0,0,'2020-06-03 05:32:39.399659','2020-06-28 05:50:58.625486'),(5,'清除里程','/command/api/farm/setParams','清除里程','输入里程|clearMileage|input','clearMileage={clearMileage}','',0,0,'2020-06-03 05:33:24.175212','2020-06-28 05:51:01.768004'),(6,'FTP服务器-远程升级','/command/api/farm/remoteUpgrade','请填写服务器相关信息','用户名|userName|input,密码|psd|input,IP地址|upDataIp|input,端口|upDataPor|input,文件名称|file|input,升级模块|model|input','{upDataIp},{upDataPor},{userName},{psd},{file},0&model={model}','',0,0,'2020-06-15 02:41:38.674139','2020-06-28 05:45:42.636477');
/*!40000 ALTER TABLE `biz_command_config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `biz_terminaltype_cmdcfg_rel`
--
DROP TABLE IF EXISTS `biz_terminaltype_cmdcfg_rel`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `biz_terminaltype_cmdcfg_rel` (
`id` char(32) NOT NULL,
`commandConfigId` bigint(20) DEFAULT NULL COMMENT '指令配置ID',
`terminalTypeId` char(32) DEFAULT NULL COMMENT '终端类型ID',
`realtionTime` datetime DEFAULT NULL COMMENT '关联时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='终端类型与指令配置关联表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `biz_terminaltype_cmdcfg_rel`
--
LOCK TABLES `biz_terminaltype_cmdcfg_rel` WRITE;
/*!40000 ALTER TABLE `biz_terminaltype_cmdcfg_rel` DISABLE KEYS */;
INSERT INTO `biz_terminaltype_cmdcfg_rel` VALUES ('3a4e498b888146e2a08d3f874910310b',2,'19c89c708e42499fae7ee4cde54daf2b','2020-05-16 11:01:46'),('96885e7d303148cc8c075c1a882ff5c8',1,'19c89c708e42499fae7ee4cde54daf2b','2020-05-16 11:01:46'),('d0b7471da3c5464395a0d6ed77dbc549',2,'e17b1ff6e3d3445fb020e0f4d094ad04','2020-08-05 10:13:20');
/*!40000 ALTER TABLE `biz_terminaltype_cmdcfg_rel` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2020-12-04 18:49:06