data.txt
169 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
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
-- 堆垛机1 PLC--> WCS PROPS
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'TaskValidate', '任务校验', 'BYTE', '1—任务校验正确；2--任务校验出错', NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'WorkModel', '工作模式', 'BYTE', '工作模式：1-脱机；2-联机', NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'OperationModel', '操作模式', 'BYTE', '操作模式：1-维修；2-手动；3-机载操作；4-单机自 动；5-联机', NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'WorkStatus', '工作状态', 'BYTE', '工作状态：0-待机，1-入库，2-出库，3-拣选，4-转 库，5-双重入库，6-回库台位（入库准备），7-召回， 8-急停', NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'HorizontalDistance', '水平测距', 'DWORD', '水平测距数据 单位 1m', NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'VerticalDistance', '起升测距', 'DWORD', '起升测距数据 单位 1m', NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'CurrentColumn', '当前列', 'BYTE', '当前列', NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'CurrentLayer', '当前层', 'BYTE', '当前层', NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'HasPallet', '叉原位时是否有货', 'BYTE', '1-叉原位时叉上无货，2-叉原位时叉上有货，', NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'LeftForkOutWhenInOrigin', '叉原位时是否左超差', 'BOOL', '0-无超差；1-货物左超差（叉原位时）', 1, 'False', '无超差', '货物左超差（叉原位时）', b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'RightForkOutWhenInOrigin', '叉原位时是否右超差', 'BOOL', '0-无超差；1-货物右超差（叉原位时）', 1, 'False', '无超差', '货物右超差（叉原位时）', b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'LeftShape', '是否左侧外形超限', 'BOOL', '0-无超限；1-左侧外形超限', 1, 'False', '无超限', '左侧外形超限', b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'RightShape', '是否右侧外形超限', 'BOOL', '0-无超限；1-右侧外形超限', 1, 'False', '无超限', '右侧外形超限', b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'Overload', '过载', 'BOOL', '0-无过载；1-过载', 1, 'False', '无过载', '过载', b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'Rope', '松绳', 'BOOL', '0-无松绳；1-松绳', 1, 'False', '无松绳', '松绳', b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'RunningUuivertorAlarm', '运行变频器报警', 'BOOL', '0-无报警；1-运行变频器报警', 1, 'False', '无报警', '运行变频器报警', b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'RaisingUuivertorAlarm', '起升变频器报警', 'BOOL', '0-无报警；1-起升变频器报警', 1, 'False', '无报警', '起升变频器报警', b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'RunningTimeout', '运行超时', 'BOOL', '0-无超时；1-运行超时', 1, 'False', '无超时', '运行超时', b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'RaisingTimeout', '起升超时', 'BOOL', '0-无超时；1-起升超时', 1, 'False', '无超时', '起升超时', b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'PalletForkTimeout', '货叉超时', 'BOOL', '0-无超时；1-货叉超时', 1, 'False', '无超时', '货叉超时', b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'OverHeight1', '超高1', 'BOOL', '0-无超高；1-超高 1（货物高度与送货地址不匹配）', 1, 'False', '无超高', '超高 1（货物高度与送货地址不匹配）', b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'OverHeight2', '超高2', 'BOOL', '0-无超高；1-超高 2（货物高度与送货地址不匹配）', 1, 'False', '无超高', '超高 2（货物高度与送货地址不匹配）', b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'OverHeight3', '超高3', 'BOOL', '0-无超高；1-超高 3（货物高度与送货地址不匹配）', 1, 'False', '无超高', '超高 3（货物高度与送货地址不匹配）', b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'OverHeight', '货物超高', 'BOOL', '0-无超高；1-货物超高', 1, 'False', '无超高', '货物超高', b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'HorizontalLaserDataError', '水平激光数据错误', 'BOOL', '0-无错误；1-水平激光数据错误', 1, 'False', '无错误', '水平激光数据错误', b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'RaisingBarcodeDataError', '起升条码数据错误', 'BOOL', '0-无错误；1-起升条码数据错误', 1, 'False', '无错误', '起升条码数据错误', b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'DoubleIn', '双重入库', 'BOOL', '0-无故障；1-双重入库 满入', 1, 'False', '无故障', '双重入库 满入', b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'EmptyOut', '空货位出库', 'BOOL', '0-无故障；1-空货位出库 空出', 1, 'False', '无故障', '空货位出库', b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'AdressError', '0-无故障；1-地址错', 'BOOL', '0-无故障；1-地址错', 1, 'False', '无故障', '地址错', b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'MainCocontactorInterrupt', '主接触器断开', 'BOOL', '0-无故障；1-主接触器断开 （急停、冲 顶、超速保 护，行走超 限动作）', 1, 'False', '无故障', '主接触器断开 （急停、冲 顶、超速保 护，行走超 限动作）', b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'HorizontalBreakerOrBrakeInterrupt', '水平断路器/制动器跳闸', 'BOOL', '0-无故障；1-水平断路器/制动器跳闸', 1, 'False', '无故障', '水平断路器/制动器跳闸', b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'RaisingBreakerOrBrakeInterrupt', '起升断路器/制动器跳闸', 'BOOL', '0-无故障；1-起升断路器/制动器跳闸', 1, 'False', '无故障', '起升断路器/制动器跳闸', b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'PalletForkBreakerOrBrakeInterrupt', '货叉断路器/制动器跳闸', 'BOOL', '0-无故障；1-货叉断路器/制动器跳闸', 1, 'False', '无故障', '货叉断路器/制动器跳闸', b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'HorizontalLeadingendOut', '水平前端超限（前进终点）', 'BOOL', '0-无超限，1-水平前端超限（前进终点）', 1, 'False', '无超限', '水平前端超限（前进终点）', b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'HorizontalTrailingendOut', '水平后端超限（后退终点）', 'BOOL', '0-无超限；1-水平后端超限（后退终点）', 1, 'False', '无超限', '水平后端超限（后退终点）', b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'VerticalHorizontalLeadingendOut', '垂直上端超限（上升终点）', 'BOOL', '0-无超限；1-垂直上端超限（上升终点）', 1, 'False', '无超限', '垂直上端超限（上升终点）', b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'VerticalHorizontalTrailingendOut', '垂直下端超限（下降终点）', 'BOOL', '0-无超限；1-垂直下端超限（下降终点）', 1, 'False', '无超限', '垂直下端超限（下降终点）', b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'Free1', 'Free1', 'BOOL', 'free', NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'Free2', 'Free2', 'BOOL', 'free', NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'Free3', 'Free3', 'BOOL', 'free', NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'Free4', 'Free4', 'BOOL', 'free', NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'TaskExcuteStatus', '任务执行', 'BYTE', '1-待机；2-任务执行中;3-任务完成；4-任务中断（出 错） 1*', NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'TaskNo1', '任务号1', 'DWORD', '托盘条码数据 1（任务号）', NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'TaskNo2', '任务号2', 'DWORD', '托盘条码数据 2（任务号）(双托盘时使用)', NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `deviceprop`(`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`, `enable`, `createTime`, `lastUpdateTime`) VALUES (1, 'Free5', 'Free5', 'WORD', 'free', NULL, NULL, NULL, NULL, b'1', NULL, NULL);
-- 堆垛机1 WCS --> PLC PROPS
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1, 'WCSTaskFlag', '任务标志', 'BYTE', '任务标志：0-无任务，1-人库，2-出库，3-拣选，4- 转库，5-双重入库，6-回库台位（入库准备，召回）， 7-送货高度不匹配；9-清任务（须带托盘号） 任务完成时清除', 1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1, 'WCSStop', '急停', 'BYTE', '0-无任务，1-急停 ', 1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1, 'WCSFromRow', '取货地址排', 'BYTE', '取货地址: 排 （1—N） 源地址(回库 台位时发)', 1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1, 'WCSFromLayer', '取货地址层', 'BYTE', '取货地址: 列（0-最远列） ', 1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1, 'WCSFromColumn', '取货地址列', 'BYTE', '取货地址: 层（1-最高层） ', 1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1, 'WCSToRow', '放货地址排', 'BYTE', '放货地址: 排（1—N） 目的地址(双 重入库及高 度不符时为放货地址)', 1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1, 'WCSToLayer', '放货地址层', 'BYTE', '放货地址: 列（0-最远列）） ', 1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1, 'WCSToColumn', '放货地址列', 'BYTE', '放货地址: 层（1-最高层） ', 1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1, 'WCSTaskNo', '任务号', 'DWORD', '托盘条码数据（即任务号） ', 1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1, 'WCSValidateCode', '校验码', 'BYTE', 'DB100.DBB0-- DB100.DBB11 字节异或值 校验码', 1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1, 'WCSFree1', 'WCSFree1', 'BYTE', 'free ', 1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1, 'WCSFree2', 'WCSFree2', 'BYTE', 'free ', 1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1, 'WCSFree3', 'WCSFree3', 'BYTE', 'free ', 1);
-- 堆垛机1 PLC-->WCS Address
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'TaskValidate', -1, 'S7:[S7 connection_3]DB101B0', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'WorkModel', -1, 'S7:[S7 connection_3]DB101B1', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'OperationModel', -1, 'S7:[S7 connection_3]DB101B2', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'WorkStatus', -1, 'S7:[S7 connection_3]DB101B3', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'HorizontalDistance', -1, 'S7:[S7 connection_3]DB101D4', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'VerticalDistance', -1, 'S7:[S7 connection_3]DB101D8', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'CurrentColumn', -1, 'S7:[S7 connection_3]DB101B12', '3', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'CurrentLayer', -1, 'S7:[S7 connection_3]DB101B13', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'HasPallet', -1, 'S7:[S7 connection_3]DB101B14', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'LeftForkOutWhenInOrigin', -1, 'S7:[S7 connection_3]DB101X15.0', 'False', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'RightForkOutWhenInOrigin', -1, 'S7:[S7 connection_3]DB101X15.1', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'LeftShape', -1, 'S7:[S7 connection_3]DB101X15.2', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'RightShape', -1, 'S7:[S7 connection_3]DB101X15.3', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'Overload', -1, 'S7:[S7 connection_3]DB101X15.4', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'Rope', -1, 'S7:[S7 connection_3]DB101X15.5', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'RunningUuivertorAlarm', -1, 'S7:[S7 connection_3]DB101X15.6', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'RaisingUuivertorAlarm', -1, 'S7:[S7 connection_3]DB101X15.7', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'RunningTimeout', -1, 'S7:[S7 connection_3]DB101X16.0', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'RaisingTimeout', -1, 'S7:[S7 connection_3]DB101X16.1', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'PalletForkTimeout', -1, 'S7:[S7 connection_3]DB101X16.2', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'OverHeight1', -1, 'S7:[S7 connection_3]DB101X16.3', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'OverHeight2', -1, 'S7:[S7 connection_3]DB101X16.4', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'OverHeight3', -1, 'S7:[S7 connection_3]DB101X16.5', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'OverHeight', -1, 'S7:[S7 connection_3]DB101X16.6', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'HorizontalLaserDataError', -1, 'S7:[S7 connection_3]DB101X16.7', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'RaisingBarcodeDataError', -1, 'S7:[S7 connection_3]DB101X17.0', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'DoubleIn', -1, 'S7:[S7 connection_3]DB101X17.1', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'EmptyOut', -1, 'S7:[S7 connection_3]DB101X17.2', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'AdressError', -1, 'S7:[S7 connection_3]DB101X17.3', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'MainCocontactorInterrupt', -1, 'S7:[S7 connection_3]DB101X17.4', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'HorizontalBreakerOrBrakeInterrupt', -1, 'S7:[S7 connection_3]DB101X17.5', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'RaisingBreakerOrBrakeInterrupt', -1, 'S7:[S7 connection_3]DB101X17.6', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'PalletForkBreakerOrBrakeInterrupt', -1, 'S7:[S7 connection_3]DB101X17.7', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'HorizontalLeadingendOut', -1, 'S7:[S7 connection_3]DB101X18.0', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'HorizontalTrailingendOut', -1, 'S7:[S7 connection_3]DB101X18.1', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'VerticalHorizontalLeadingendOut', -1, 'S7:[S7 connection_3]DB101X18.2', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'VerticalHorizontalTrailingendOut', -1, 'S7:[S7 connection_3]DB101X18.3', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'Free1', -1, 'S7:[S7 connection_3]DB101X18.4', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'Free2', -1, 'S7:[S7 connection_3]DB101X18.5', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'Free3', -1, 'S7:[S7 connection_3]DB101X18.6', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'Free4', -1, 'S7:[S7 connection_3]DB101X18.7', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'TaskExcuteStatus', -1, 'S7:[S7 connection_3]DB101B19', '2', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'TaskNo1', -1, 'S7:[S7 connection_3]DB101D20', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'TaskNo2', -1, 'S7:[S7 connection_3]DB101D24', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'Free5', -1, 'S7:[S7 connection_3]DB101W28', '-1', b'1', NULL, NULL, NULL, NULL);
-- 堆垛机1 WCS-->PLC Address
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'WCSTaskFlag', -1, 'S7:[S7 connection_3]DB100B0', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'WCSStop', -1, 'S7:[S7 connection_3]DB100B1', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'WCSFromRow', -1, 'S7:[S7 connection_3]DB100B2', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'WCSFromLayer', -1, 'S7:[S7 connection_3]DB100B3', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'WCSFromColumn', -1, 'S7:[S7 connection_3]DB100B4', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'WCSToRow', -1, 'S7:[S7 connection_3]DB100B5', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'WCSToLayer', -1, 'S7:[S7 connection_3]DB100B6', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'WCSToColumn', -1, 'S7:[S7 connection_3]DB100B7', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'WCSTaskNo', -1, 'S7:[S7 connection_3]DB100D8', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'WCSValidateCode', -1, 'S7:[S7 connection_3]DB100B12', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'WCSFree1', -1, 'S7:[S7 connection_3]DB100B13', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'WCSFree2', -1, 'S7:[S7 connection_3]DB100B14', '-1', b'1', NULL, NULL, NULL, NULL);
INSERT INTO `deviceaddress`(`deviceId`, `devicePropId`, `devicePropCode`, `serverHandle`, `address`, `value`, `enable`, `createBy`, `createTime`, `lastUpdateBy`, `lastUpdateTime`) VALUES (1, NULL, 'WCSFree3', -1, 'S7:[S7 connection_3]DB100B15', '-1', b'1', NULL, NULL, NULL, NULL);
-- 货位
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010101', '1', 'CS0001', '1', '1', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010102', '1', 'CS0001', '1', '1', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010103', '1', 'CS0001', '1', '1', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010104', '1', 'CS0001', '1', '1', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010105', '1', 'CS0001', '1', '1', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010201', '1', 'CS0001', '1', '2', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010202', '1', 'CS0001', '1', '2', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010203', '1', 'CS0001', '1', '2', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010204', '1', 'CS0001', '1', '2', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010205', '1', 'CS0001', '1', '2', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010301', '1', 'CS0001', '1', '3', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010302', '1', 'CS0001', '1', '3', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010303', '1', 'CS0001', '1', '3', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010304', '1', 'CS0001', '1', '3', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010305', '1', 'CS0001', '1', '3', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010401', '1', 'CS0001', '1', '4', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010402', '1', 'CS0001', '1', '4', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010403', '1', 'CS0001', '1', '4', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010404', '1', 'CS0001', '1', '4', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010405', '1', 'CS0001', '1', '4', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010501', '1', 'CS0001', '1', '5', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010502', '1', 'CS0001', '1', '5', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010503', '1', 'CS0001', '1', '5', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010504', '1', 'CS0001', '1', '5', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010505', '1', 'CS0001', '1', '5', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010601', '1', 'CS0001', '1', '6', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010602', '1', 'CS0001', '1', '6', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010603', '1', 'CS0001', '1', '6', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010604', '1', 'CS0001', '1', '6', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010605', '1', 'CS0001', '1', '6', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010701', '1', 'CS0001', '1', '7', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010702', '1', 'CS0001', '1', '7', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010703', '1', 'CS0001', '1', '7', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010704', '1', 'CS0001', '1', '7', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010705', '1', 'CS0001', '1', '7', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010801', '1', 'CS0001', '1', '8', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010802', '1', 'CS0001', '1', '8', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010803', '1', 'CS0001', '1', '8', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010804', '1', 'CS0001', '1', '8', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010805', '1', 'CS0001', '1', '8', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010901', '1', 'CS0001', '1', '9', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010902', '1', 'CS0001', '1', '9', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010903', '1', 'CS0001', '1', '9', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010904', '1', 'CS0001', '1', '9', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A010905', '1', 'CS0001', '1', '9', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011001', '1', 'CS0001', '1', '10', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011002', '1', 'CS0001', '1', '10', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011003', '1', 'CS0001', '1', '10', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011004', '1', 'CS0001', '1', '10', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011005', '1', 'CS0001', '1', '10', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011101', '1', 'CS0001', '1', '11', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011102', '1', 'CS0001', '1', '11', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011103', '1', 'CS0001', '1', '11', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011104', '1', 'CS0001', '1', '11', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011105', '1', 'CS0001', '1', '11', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011201', '1', 'CS0001', '1', '12', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011202', '1', 'CS0001', '1', '12', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011203', '1', 'CS0001', '1', '12', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011204', '1', 'CS0001', '1', '12', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011205', '1', 'CS0001', '1', '12', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011301', '1', 'CS0001', '1', '13', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011302', '1', 'CS0001', '1', '13', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011303', '1', 'CS0001', '1', '13', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011304', '1', 'CS0001', '1', '13', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011305', '1', 'CS0001', '1', '13', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011401', '1', 'CS0001', '1', '14', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011402', '1', 'CS0001', '1', '14', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011403', '1', 'CS0001', '1', '14', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011404', '1', 'CS0001', '1', '14', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011405', '1', 'CS0001', '1', '14', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011501', '1', 'CS0001', '1', '15', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011502', '1', 'CS0001', '1', '15', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011503', '1', 'CS0001', '1', '15', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011504', '1', 'CS0001', '1', '15', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011505', '1', 'CS0001', '1', '15', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011601', '1', 'CS0001', '1', '16', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011602', '1', 'CS0001', '1', '16', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011603', '1', 'CS0001', '1', '16', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011604', '1', 'CS0001', '1', '16', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A011605', '1', 'CS0001', '1', '16', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020101', '1', 'CS0001', '2', '1', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020102', '1', 'CS0001', '2', '1', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020103', '1', 'CS0001', '2', '1', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020104', '1', 'CS0001', '2', '1', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020105', '1', 'CS0001', '2', '1', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020201', '1', 'CS0001', '2', '2', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020202', '1', 'CS0001', '2', '2', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020203', '1', 'CS0001', '2', '2', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020204', '1', 'CS0001', '2', '2', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020205', '1', 'CS0001', '2', '2', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020301', '1', 'CS0001', '2', '3', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020302', '1', 'CS0001', '2', '3', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020303', '1', 'CS0001', '2', '3', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020304', '1', 'CS0001', '2', '3', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020305', '1', 'CS0001', '2', '3', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020401', '1', 'CS0001', '2', '4', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020402', '1', 'CS0001', '2', '4', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020403', '1', 'CS0001', '2', '4', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020404', '1', 'CS0001', '2', '4', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020405', '1', 'CS0001', '2', '4', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020501', '1', 'CS0001', '2', '5', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020502', '1', 'CS0001', '2', '5', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020503', '1', 'CS0001', '2', '5', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020504', '1', 'CS0001', '2', '5', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020505', '1', 'CS0001', '2', '5', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020601', '1', 'CS0001', '2', '6', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020602', '1', 'CS0001', '2', '6', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020603', '1', 'CS0001', '2', '6', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020604', '1', 'CS0001', '2', '6', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020605', '1', 'CS0001', '2', '6', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020701', '1', 'CS0001', '2', '7', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020702', '1', 'CS0001', '2', '7', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020703', '1', 'CS0001', '2', '7', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020704', '1', 'CS0001', '2', '7', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020705', '1', 'CS0001', '2', '7', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020801', '1', 'CS0001', '2', '8', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020802', '1', 'CS0001', '2', '8', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020803', '1', 'CS0001', '2', '8', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020804', '1', 'CS0001', '2', '8', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020805', '1', 'CS0001', '2', '8', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020901', '1', 'CS0001', '2', '9', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020902', '1', 'CS0001', '2', '9', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020903', '1', 'CS0001', '2', '9', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020904', '1', 'CS0001', '2', '9', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A020905', '1', 'CS0001', '2', '9', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021001', '1', 'CS0001', '2', '10', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021002', '1', 'CS0001', '2', '10', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021003', '1', 'CS0001', '2', '10', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021004', '1', 'CS0001', '2', '10', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021005', '1', 'CS0001', '2', '10', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021101', '1', 'CS0001', '2', '11', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021102', '1', 'CS0001', '2', '11', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021103', '1', 'CS0001', '2', '11', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021104', '1', 'CS0001', '2', '11', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021105', '1', 'CS0001', '2', '11', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021201', '1', 'CS0001', '2', '12', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021202', '1', 'CS0001', '2', '12', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021203', '1', 'CS0001', '2', '12', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021204', '1', 'CS0001', '2', '12', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021205', '1', 'CS0001', '2', '12', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021301', '1', 'CS0001', '2', '13', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021302', '1', 'CS0001', '2', '13', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021303', '1', 'CS0001', '2', '13', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021304', '1', 'CS0001', '2', '13', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021305', '1', 'CS0001', '2', '13', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021401', '1', 'CS0001', '2', '14', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021402', '1', 'CS0001', '2', '14', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021403', '1', 'CS0001', '2', '14', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021404', '1', 'CS0001', '2', '14', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021405', '1', 'CS0001', '2', '14', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021501', '1', 'CS0001', '2', '15', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021502', '1', 'CS0001', '2', '15', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021503', '1', 'CS0001', '2', '15', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021504', '1', 'CS0001', '2', '15', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021505', '1', 'CS0001', '2', '15', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021601', '1', 'CS0001', '2', '16', '1', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021602', '1', 'CS0001', '2', '16', '2', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021603', '1', 'CS0001', '2', '16', '3', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021604', '1', 'CS0001', '2', '16', '4', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
--INSERT INTO `hhwcs`.`location` (`code`, `warehouseId`, `warehouseCode`, `row`, `column`, `layer`, `grid`, `roadway`, `locationTypeId`, `containerId`, `containerCode`, `zoneId`, `zoneCode`, `status`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `enable`, `deleted`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`) VALUES ('A021605', '1', 'CS0001', '2', '16', '5', '0', '1', '1', NULL, NULL, NULL, NULL, 'empty', NULL, '2018-08-24 11:31:27', NULL, '2018-08-24 14:31:46', NULL, b'01', b'00', NULL, NULL, NULL, NULL, NULL);
-- 链条机实体
--INSERT INTO `hhwcs`.`devicelist` ( `code`, `name`, `type`, `ip`, `S7_Connect`, `groupName`, `roadway`, `selfAddress`, `deviceTypeId`) VALUES ('conveyor1', '链条机1', '7', '1', '1', '1', '0', NULL, '7');
--INSERT INTO `hhwcs`.`devicelist` ( `code`, `name`, `type`, `ip`, `S7_Connect`, `groupName`, `roadway`, `selfAddress`, `deviceTypeId`) VALUES ('conveyor2', '链条机2', '7', '1', '1', '1', '0', NULL, '7');
--INSERT INTO `hhwcs`.`devicelist` ( `code`, `name`, `type`, `ip`, `S7_Connect`, `groupName`, `roadway`, `selfAddress`, `deviceTypeId`) VALUES ('conveyor3', '链条机3', '7', '1', '1', '1', '0', NULL, '7');
--INSERT INTO `hhwcs`.`devicelist` ( `code`, `name`, `type`, `ip`, `S7_Connect`, `groupName`, `roadway`, `selfAddress`, `deviceTypeId`) VALUES ('conveyor4', '链条机4', '7', '1', '1', '1', '0', NULL, '7');
--INSERT INTO `hhwcs`.`devicelist` ( `code`, `name`, `type`, `ip`, `S7_Connect`, `groupName`, `roadway`, `selfAddress`, `deviceTypeId`) VALUES ('conveyor5', '链条机5', '7', '1', '1', '1', '0', NULL, '7');
--INSERT INTO `hhwcs`.`devicelist` ( `code`, `name`, `type`, `ip`, `S7_Connect`, `groupName`, `roadway`, `selfAddress`, `deviceTypeId`) VALUES ('conveyor6', '链条机6', '7', '1', '1', '1', '0', NULL, '7');
-- 堆垛机接入站台属性
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('2', 'Flag', '标志位', 'BYTE', '有新消息时，标志位置1', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('2', 'Type', '报文类型', 'WORD', '01(地址请求)02（位置到达）03（控制指令）', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('2', 'PLCNo', 'PLC编号', 'WORD', 'PLC编号', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('2', 'LoadStatus', '装载状态', 'WORD', '装载状态，填充0', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('2', 'StationNo', '输送线编号', 'WORD', '站台编号', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('2', 'TaskNo', '货物ID', 'WORD', 'PLC内部跟踪', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('2', 'Barcode', '条码', 'CHAR', 'PLC上报的条码信息(托盘条码)', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('2', 'Weight', '货位重量', 'WORD', '货位重量', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('2', 'Length', '货物长度', 'WORD', '货物长度', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('2', 'Width', '货物宽度', 'WORD', '货物宽度', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('2', 'Height', '货物高度', 'WORD', '货物高度', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('2', 'RetCode', '消息类型', 'WORD', '消息类型', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('2', 'BackUp', '备用', 'WORD', '备用', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('2', 'WCSFlag', '新消息标记位', 'BYTE', '有新消息时，标志位置1', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('2', 'WCSType', '报文类型', 'WORD', '06(地址请求)08（位置到达）)07（控制指令）', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('2', 'WCSPLCNo', 'PLC编号', 'WORD', 'PLC编号', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('2', 'WCSLoadStatus', '装载状态', 'WORD', '填充0', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('2', 'WCSStationNo', '输送线编号', 'WORD', '输送线编号', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('2', 'WCSTaskNo', '货物ID', 'WORD', '货物ID', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('2', 'WCSBarcode', '条码', 'CHAR', 'PLC上报的条码信息', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('2', 'WCSToAddress', '目的地', 'WORD', '托盘目的地', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('2', 'WCSBackUp', '备用', 'WORD', '备用', '0', '', '', '');
-- 堆垛机接出站台属性
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('3', 'Flag', '标志位', 'BYTE', '有新消息时，标志位置1', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('3', 'Type', '报文类型', 'WORD', '01(地址请求)02（位置到达）03（控制指令）', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('3', 'PLCNo', 'PLC编号', 'WORD', 'PLC编号', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('3', 'LoadStatus', '装载状态', 'WORD', '装载状态，填充0', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('3', 'StationNo', '输送线编号', 'WORD', '站台编号', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('3', 'TaskNo', '货物ID', 'WORD', 'PLC内部跟踪', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('3', 'Barcode', '条码', 'CHAR', 'PLC上报的条码信息(托盘条码)', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('3', 'Weight', '货位重量', 'WORD', '货位重量', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('3', 'Length', '货物长度', 'WORD', '货物长度', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('3', 'Width', '货物宽度', 'WORD', '货物宽度', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('3', 'Height', '货物高度', 'WORD', '货物高度', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('3', 'RetCode', '消息类型', 'WORD', '消息类型', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('3', 'BackUp', '备用', 'WORD', '备用', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('3', 'WCSFlag', '新消息标记位', 'BYTE', '有新消息时，标志位置1', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('3', 'WCSType', '报文类型', 'WORD', '06(地址请求)08（位置到达）)07（控制指令）', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('3', 'WCSPLCNo', 'PLC编号', 'WORD', 'PLC编号', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('3', 'WCSLoadStatus', '装载状态', 'WORD', '填充0', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('3', 'WCSStationNo', '输送线编号', 'WORD', '输送线编号', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('3', 'WCSTaskNo', '货物ID', 'WORD', '货物ID', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('3', 'WCSBarcode', '条码', 'CHAR', 'PLC上报的条码信息', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('3', 'WCSToAddress', '目的地', 'WORD', '托盘目的地', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('3', 'WCSBackUp', '备用', 'WORD', '备用', '0', '', '', '');
-- 只入站台属性
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('4', 'Flag', '标志位', 'BYTE', '有新消息时，标志位置1', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('4', 'Type', '报文类型', 'WORD', '01(地址请求)02（位置到达）03（控制指令）', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('4', 'PLCNo', 'PLC编号', 'WORD', 'PLC编号', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('4', 'LoadStatus', '装载状态', 'WORD', '装载状态，填充0', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('4', 'StationNo', '输送线编号', 'WORD', '站台编号', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('4', 'TaskNo', '货物ID', 'WORD', 'PLC内部跟踪', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('4', 'Barcode', '条码', 'CHAR', 'PLC上报的条码信息(托盘条码)', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('4', 'Weight', '货位重量', 'WORD', '货位重量', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('4', 'Length', '货物长度', 'WORD', '货物长度', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('4', 'Width', '货物宽度', 'WORD', '货物宽度', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('4', 'Height', '货物高度', 'WORD', '货物高度', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('4', 'RetCode', '消息类型', 'WORD', '消息类型', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('4', 'BackUp', '备用', 'WORD', '备用', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('4', 'WCSFlag', '新消息标记位', 'BYTE', '有新消息时，标志位置1', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('4', 'WCSType', '报文类型', 'WORD', '06(地址请求)08（位置到达）)07（控制指令）', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('4', 'WCSPLCNo', 'PLC编号', 'WORD', 'PLC编号', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('4', 'WCSLoadStatus', '装载状态', 'WORD', '填充0', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('4', 'WCSStationNo', '输送线编号', 'WORD', '输送线编号', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('4', 'WCSTaskNo', '货物ID', 'WORD', '货物ID', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('4', 'WCSBarcode', '条码', 'CHAR', 'PLC上报的条码信息', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('4', 'WCSToAddress', '目的地', 'WORD', '托盘目的地', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('4', 'WCSBackUp', '备用', 'WORD', '备用', '0', '', '', '');
-- 只出站台属性
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('5', 'Flag', '标志位', 'BYTE', '有新消息时，标志位置1', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('5', 'Type', '报文类型', 'WORD', '01(地址请求)02（位置到达）03（控制指令）', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('5', 'PLCNo', 'PLC编号', 'WORD', 'PLC编号', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('5', 'LoadStatus', '装载状态', 'WORD', '装载状态，填充0', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('5', 'StationNo', '输送线编号', 'WORD', '站台编号', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('5', 'TaskNo', '货物ID', 'WORD', 'PLC内部跟踪', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('5', 'Barcode', '条码', 'CHAR', 'PLC上报的条码信息(托盘条码)', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('5', 'Weight', '货位重量', 'WORD', '货位重量', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('5', 'Length', '货物长度', 'WORD', '货物长度', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('5', 'Width', '货物宽度', 'WORD', '货物宽度', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('5', 'Height', '货物高度', 'WORD', '货物高度', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('5', 'RetCode', '消息类型', 'WORD', '消息类型', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('5', 'BackUp', '备用', 'WORD', '备用', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('5', 'WCSFlag', '新消息标记位', 'BYTE', '有新消息时，标志位置1', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('5', 'WCSType', '报文类型', 'WORD', '06(地址请求)08（位置到达）)07（控制指令）', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('5', 'WCSPLCNo', 'PLC编号', 'WORD', 'PLC编号', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('5', 'WCSLoadStatus', '装载状态', 'WORD', '填充0', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('5', 'WCSStationNo', '输送线编号', 'WORD', '输送线编号', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('5', 'WCSTaskNo', '货物ID', 'WORD', '货物ID', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('5', 'WCSBarcode', '条码', 'CHAR', 'PLC上报的条码信息', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('5', 'WCSToAddress', '目的地', 'WORD', '托盘目的地', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('5', 'WCSBackUp', '备用', 'WORD', '备用', '0', '', '', '');
-- 出入站台属性
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('6', 'Flag', '标志位', 'BYTE', '有新消息时，标志位置1', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('6', 'Type', '报文类型', 'WORD', '01(地址请求)02（位置到达）03（控制指令）', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('6', 'PLCNo', 'PLC编号', 'WORD', 'PLC编号', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('6', 'LoadStatus', '装载状态', 'WORD', '装载状态，填充0', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('6', 'StationNo', '输送线编号', 'WORD', '站台编号', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('6', 'TaskNo', '货物ID', 'WORD', 'PLC内部跟踪', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('6', 'Barcode', '条码', 'CHAR', 'PLC上报的条码信息(托盘条码)', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('6', 'Weight', '货位重量', 'WORD', '货位重量', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('6', 'Length', '货物长度', 'WORD', '货物长度', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('6', 'Width', '货物宽度', 'WORD', '货物宽度', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('6', 'Height', '货物高度', 'WORD', '货物高度', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('6', 'RetCode', '消息类型', 'WORD', '消息类型', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('6', 'BackUp', '备用', 'WORD', '备用', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('6', 'WCSFlag', '新消息标记位', 'BYTE', '有新消息时，标志位置1', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('6', 'WCSType', '报文类型', 'WORD', '06(地址请求)08（位置到达）)07（控制指令）', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('6', 'WCSPLCNo', 'PLC编号', 'WORD', 'PLC编号', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('6', 'WCSLoadStatus', '装载状态', 'WORD', '填充0', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('6', 'WCSStationNo', '输送线编号', 'WORD', '输送线编号', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('6', 'WCSTaskNo', '货物ID', 'WORD', '货物ID', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('6', 'WCSBarcode', '条码', 'CHAR', 'PLC上报的条码信息', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('6', 'WCSToAddress', '目的地', 'WORD', '托盘目的地', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('6', 'WCSBackUp', '备用', 'WORD', '备用', '0', '', '', '');
-- 链条机属性
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('7', 'RunningStatus', '输送线状态', 'BOOL', '1=自动运行 0=故障或手动', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('7', 'PalletExist', '是否有货', 'BOOL', '1=有货 0=无货物', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('7', 'PalletDestinationAddress', '托盘目的地', 'WORD', '托盘目的地', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('7', 'ConveyorNo', '输送线编号', 'WORD', '当前输送线编号', '0', '', '', '');
INSERT INTO `hhwcs`.`deviceprop` (`deviceTypeId`, `code`, `name`, `type`, `description`, `isMonitor`, `monitorCompareValue`, `monitorNormal`, `monitorFailure`) VALUES ('7', 'PalletBarcode', '托盘条码', 'CHAR', '托盘条码（按实际长度）', '0', '', '', '');
-- 链条机实体
INSERT INTO `hhwcs`.`devicelist` ( `code`, `name`, `type`, `ip`, `S7_Connect`, `groupName`, `roadway`, `selfAddress`, `deviceTypeId`) VALUES ('conveyor1', '链条机1', '7', '1', '1', '1', '0', NULL, '7');
INSERT INTO `hhwcs`.`devicelist` ( `code`, `name`, `type`, `ip`, `S7_Connect`, `groupName`, `roadway`, `selfAddress`, `deviceTypeId`) VALUES ('conveyor2', '链条机2', '7', '1', '1', '1', '0', NULL, '7');
INSERT INTO `hhwcs`.`devicelist` ( `code`, `name`, `type`, `ip`, `S7_Connect`, `groupName`, `roadway`, `selfAddress`, `deviceTypeId`) VALUES ('conveyor3', '链条机3', '7', '1', '1', '1', '0', NULL, '7');
INSERT INTO `hhwcs`.`devicelist` ( `code`, `name`, `type`, `ip`, `S7_Connect`, `groupName`, `roadway`, `selfAddress`, `deviceTypeId`) VALUES ('conveyor4', '链条机4', '7', '1', '1', '1', '0', NULL, '7');
INSERT INTO `hhwcs`.`devicelist` ( `code`, `name`, `type`, `ip`, `S7_Connect`, `groupName`, `roadway`, `selfAddress`, `deviceTypeId`) VALUES ('conveyor5', '链条机5', '7', '1', '1', '1', '0', NULL, '7');
INSERT INTO `hhwcs`.`devicelist` ( `code`, `name`, `type`, `ip`, `S7_Connect`, `groupName`, `roadway`, `selfAddress`, `deviceTypeId`) VALUES ('conveyor6', '链条机6', '7', '1', '1', '1', '0', NULL, '7');
-- 出入站台 address
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (4, 'Flag', -1, 'S7:[S7 connection_2]DB1500B0', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (4, 'Type', -1, 'S7:[S7 connection_2]DB1500W2', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (4, 'PLCNo', -1, 'S7:[S7 connection_2]DB1500W4', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (4, 'LoadStatus', -1, 'S7:[S7 connection_2]DB1500W6', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (4, 'StationNo', -1, 'S7:[S7 connection_2]DB1500W8', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (4, 'TaskNo', -1, 'S7:[S7 connection_2]DB1500W10', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (4, 'Barcode', -1, 'S7:[S7 connection_2]DB1500CHAR12,20', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (4, 'Weight', -1, 'S7:[S7 connection_2]DB1500W32', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (4, 'Length', -1, 'S7:[S7 connection_2]DB1500W34', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (4, 'Width', -1, 'S7:[S7 connection_2]DB1500W36', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (4, 'Height', -1, 'S7:[S7 connection_2]DB1500W38', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (4, 'RetCode', -1, 'S7:[S7 connection_2]DB1500W40', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (4, 'BackUp', -1, 'S7:[S7 connection_2]DB1500W42', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (4, 'WCSFlag', -1, 'S7:[S7 connection_2]DB1501B0', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (4, 'WCSType', -1, 'S7:[S7 connection_2]DB1501W2', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (4, 'WCSPLCNo', -1, 'S7:[S7 connection_2]DB1501W4', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (4, 'WCSLoadStatus', -1, 'S7:[S7 connection_2]DB1501W6', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (4, 'WCSStationNo', -1, 'S7:[S7 connection_2]DB1501W8', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (4, 'WCSTaskNo', -1, 'S7:[S7 connection_2]DB1501W10', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (4, 'WCSBarcode', -1, 'S7:[S7 connection_2]DB1501CHAR12,20', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (4, 'WCSToAddress', -1, 'S7:[S7 connection_2]DB1501W32', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (4, 'WCSBackUp', -1, 'S7:[S7 connection_2]DB1501W34', '-1');
-- 堆垛机接入站台 address
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (2, 'Flag', -1, 'S7:[S7 connection_2]DB1500B52', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (2, 'Type', -1, 'S7:[S7 connection_2]DB1500W54', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (2, 'PLCNo', -1, 'S7:[S7 connection_2]DB1500W56', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (2, 'LoadStatus', -1, 'S7:[S7 connection_2]DB1500W58', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (2, 'StationNo', -1, 'S7:[S7 connection_2]DB1500W60', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (2, 'TaskNo', -1, 'S7:[S7 connection_2]DB1500W62', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (2, 'Barcode', -1, 'S7:[S7 connection_2]DB1500CHAR64,20', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (2, 'Weight', -1, 'S7:[S7 connection_2]DB1500W84', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (2, 'Length', -1, 'S7:[S7 connection_2]DB1500W86', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (2, 'Width', -1, 'S7:[S7 connection_2]DB1500W88', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (2, 'Height', -1, 'S7:[S7 connection_2]DB1500W90', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (2, 'RetCode', -1, 'S7:[S7 connection_2]DB1500W92', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (2, 'BackUp', -1, 'S7:[S7 connection_2]DB1500W94', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (2, 'WCSFlag', -1, 'S7:[S7 connection_2]DB1501B42', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (2, 'WCSType', -1, 'S7:[S7 connection_2]DB1501W44', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (2, 'WCSPLCNo', -1, 'S7:[S7 connection_2]DB1501W46', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (2, 'WCSLoadStatus', -1, 'S7:[S7 connection_2]DB1501W48', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (2, 'WCSStationNo', -1, 'S7:[S7 connection_2]DB1501W50', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (2, 'WCSTaskNo', -1, 'S7:[S7 connection_2]DB1501W52', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (2, 'WCSBarcode', -1, 'S7:[S7 connection_2]DB1501CHAR54,20', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (2, 'WCSToAddress', -1, 'S7:[S7 connection_2]DB1501W74', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (2, 'WCSBackUp', -1, 'S7:[S7 connection_2]DB1501W76', '-1');
-- 堆垛机接出站台 address
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (3, 'Flag', -1, 'S7:[S7 connection_2]DB1500B104', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (3, 'Type', -1, 'S7:[S7 connection_2]DB1500W106', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (3, 'PLCNo', -1, 'S7:[S7 connection_2]DB1500W108', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (3, 'LoadStatus', -1, 'S7:[S7 connection_2]DB1500W110', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (3, 'StationNo', -1, 'S7:[S7 connection_2]DB1500W112', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (3, 'TaskNo', -1, 'S7:[S7 connection_2]DB1500W114', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (3, 'Barcode', -1, 'S7:[S7 connection_2]DB1500CHAR116,20', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (3, 'Weight', -1, 'S7:[S7 connection_2]DB1500W136', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (3, 'Length', -1, 'S7:[S7 connection_2]DB1500W138', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (3, 'Width', -1, 'S7:[S7 connection_2]DB1500W140', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (3, 'Height', -1, 'S7:[S7 connection_2]DB1500W142', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (3, 'RetCode', -1, 'S7:[S7 connection_2]DB1500W144', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (3, 'BackUp', -1, 'S7:[S7 connection_2]DB1500W146', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (3, 'WCSFlag', -1, 'S7:[S7 connection_2]DB1501B84', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (3, 'WCSType', -1, 'S7:[S7 connection_2]DB1501W86', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (3, 'WCSPLCNo', -1, 'S7:[S7 connection_2]DB1501W88', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (3, 'WCSLoadStatus', -1, 'S7:[S7 connection_2]DB1501W90', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (3, 'WCSStationNo', -1, 'S7:[S7 connection_2]DB1501W92', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (3, 'WCSTaskNo', -1, 'S7:[S7 connection_2]DB1501W94', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (3, 'WCSBarcode', -1, 'S7:[S7 connection_2]DB1501CHAR96,20', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (3, 'WCSToAddress', -1, 'S7:[S7 connection_2]DB1501W116', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (3, 'WCSBackUp', -1, 'S7:[S7 connection_2]DB1501W118', '-1');
-- 输送线1 address
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (5, 'RunningStatus', -1, 'S7:[S7 connection_2]DB1510X0.0', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (5, 'PalletExist', -1, 'S7:[S7 connection_2]DB1510X0.1', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (5, 'PalletDestinationAddress', -1, 'S7:[S7 connection_2]DB1510W2', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (5, 'ConveyorNo', -1, 'S7:[S7 connection_2]DB1510W4', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (5, 'PalletBarcode', -1, 'S7:[S7 connection_2]DB1510CHAR6,20', '-1');
-- 输送线2 address
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (6, 'RunningStatus', -1, 'S7:[S7 connection_2]DB1510X26.0', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (6, 'PalletExist', -1, 'S7:[S7 connection_2]DB1510X26.1', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (6, 'PalletDestinationAddress', -1, 'S7:[S7 connection_2]DB1510W28', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (6, 'ConveyorNo', -1, 'S7:[S7 connection_2]DB1510W30', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (6, 'PalletBarcode', -1, 'S7:[S7 connection_2]DB1510CHAR32,20', '-1');
-- 输送线3 address
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (7, 'RunningStatus', -1, 'S7:[S7 connection_2]DB1510X52.0', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (7, 'PalletExist', -1, 'S7:[S7 connection_2]DB1510X52.1', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (7, 'PalletDestinationAddress', -1, 'S7:[S7 connection_2]DB1510W54', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (7, 'ConveyorNo', -1, 'S7:[S7 connection_2]DB1510W56', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (7, 'PalletBarcode', -1, 'S7:[S7 connection_2]DB1510CHAR58,20', '-1');
-- 输送线4 address
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (8, 'RunningStatus', -1, 'S7:[S7 connection_2]DB1510X78.0', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (8, 'PalletExist', -1, 'S7:[S7 connection_2]DB1510X78.1', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (8, 'PalletDestinationAddress', -1, 'S7:[S7 connection_2]DB1510W80', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (8, 'ConveyorNo', -1, 'S7:[S7 connection_2]DB1510W82', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (8, 'PalletBarcode', -1, 'S7:[S7 connection_2]DB1510CHAR84,20', '-1');
-- 输送线5 address
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (9, 'RunningStatus', -1, 'S7:[S7 connection_2]DB1510X104.0', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (9, 'PalletExist', -1, 'S7:[S7 connection_2]DB1510X104.1', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (9, 'PalletDestinationAddress', -1, 'S7:[S7 connection_2]DB1510W106', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (9, 'ConveyorNo', -1, 'S7:[S7 connection_2]DB1510W108', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (9, 'PalletBarcode', -1, 'S7:[S7 connection_2]DB1510CHAR110,20', '-1');
-- 输送线6 address
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (10, 'RunningStatus', -1, 'S7:[S7 connection_2]DB1510X130.0', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (10, 'PalletExist', -1, 'S7:[S7 connection_2]DB1510X130.1', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (10, 'PalletDestinationAddress', -1, 'S7:[S7 connection_2]DB1510W132', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (10, 'ConveyorNo', -1, 'S7:[S7 connection_2]DB1510W134', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (10, 'PalletBarcode', -1, 'S7:[S7 connection_2]DB1510CHAR136,20', '-1');
-- 拣选口 address
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (11, 'Flag', -1, 'S7:[S7 connection_2]DB1500B156', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (11, 'Type', -1, 'S7:[S7 connection_2]DB1500W158', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (11, 'PLCNo', -1, 'S7:[S7 connection_2]DB1500W160', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (11, 'LoadStatus', -1, 'S7:[S7 connection_2]DB1500W162', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (11, 'StationNo', -1, 'S7:[S7 connection_2]DB1500W164', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (11, 'TaskNo', -1, 'S7:[S7 connection_2]DB1500W166', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (11, 'Barcode', -1, 'S7:[S7 connection_2]DB1500CHAR168,20', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (11, 'Weight', -1, 'S7:[S7 connection_2]DB1500W188', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (11, 'Length', -1, 'S7:[S7 connection_2]DB1500W190', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (11, 'Width', -1, 'S7:[S7 connection_2]DB1500W192', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (11, 'Height', -1, 'S7:[S7 connection_2]DB1500W194', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (11, 'RetCode', -1, 'S7:[S7 connection_2]DB1500W196', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (11, 'BackUp', -1, 'S7:[S7 connection_2]DB1500W198', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (11, 'WCSFlag', -1, 'S7:[S7 connection_2]DB1501B126', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (11, 'WCSType', -1, 'S7:[S7 connection_2]DB1501W128', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (11, 'WCSPLCNo', -1, 'S7:[S7 connection_2]DB1501W130', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (11, 'WCSLoadStatus', -1, 'S7:[S7 connection_2]DB1501W132', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (11, 'WCSStationNo', -1, 'S7:[S7 connection_2]DB1501W134', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (11, 'WCSTaskNo', -1, 'S7:[S7 connection_2]DB1501W136', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (11, 'WCSBarcode', -1, 'S7:[S7 connection_2]DB1501CHAR138,20', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (11, 'ToAddress', -1, 'S7:[S7 connection_2]DB1501W158', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (11, 'WCSBackUp', -1, 'S7:[S7 connection_2]DB1501W160', '-1');