data.txt
139 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
-- 堆垛机1 PLC--> WCS PROPS
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'TaskValidate','任务校验','BYTE', '1—任务校验正确；2--任务校验出错',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'WorkModel','工作模式','BYTE', '工作模式：1-脱机；2-联机',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'OperationModel','操作模式','BYTE', '操作模式：1-维修；2-手动；3-机载操作；4-单机自 动；5-联机',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'WorkStatus','工作状态','BYTE', '工作状态：0-待机，1-入库，2-出库，3-拣选，4-转 库，5-双重入库，6-回库台位（入库准备），7-召回， 8-急停',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'HorizontalDistance','水平测距','DWORD', '水平测距数据 单位 1m',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'VerticalDistance','起升测距','DWORD', '起升测距数据 单位 1m',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'CurrentColumn','当前列','BYTE', '当前列',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'CurrentLayer','当前层','BYTE', '当前层',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'HasPallet','叉原位时是否有货','BYTE', '1-叉原位时叉上无货，2-叉原位时叉上有货，',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'LeftForkOutWhenInOrigin','叉原位时是否左超差','BOOL', '0-无超差；1-货物左超差（叉原位时）',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'RightForkOutWhenInOrigin','叉原位时是否右超差','BOOL', '0-无超差；1-货物右超差（叉原位时）',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'LeftShape','是否左侧外形超限','BOOL', '0-无超限；1-左侧外形超限',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'RightShape','是否右侧外形超限','BOOL', '0-无超限；1-右侧外形超限',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'Overload','过载','BOOL', '0-无过载；1-过载',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'Rope','松绳','BOOL', '0-无松绳；1-松绳',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'RunningUuivertorAlarm','运行变频器报警','BOOL', '0-无报警；1-运行变频器报警',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'RaisingUuivertorAlarm','起升变频器报警','BOOL', '0-无报警；1-起升变频器报警',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'RunningTimeout','运行超时','BOOL', '0-无超时；1-运行超时',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'RaisingTimeout','起升超时','BOOL', '0-无超时；1-起升超时',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'PalletForkTimeout','货叉超时','BOOL', '0-无超时；1-货叉超时',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'OverHeight1','超高1','BOOL', '0-无超高；1-超高 1（货物高度与送货地址不匹配）',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'OverHeight2','超高2','BOOL', '0-无超高；1-超高 2（货物高度与送货地址不匹配）',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'OverHeight3','超高3','BOOL', '0-无超高；1-超高 3（货物高度与送货地址不匹配）',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'OverHeight','货物超高','BOOL', '0-无超高；1-货物超高',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'HorizontalLaserDataError','水平激光数据错误','BOOL', '0-无错误；1-水平激光数据错误',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'RaisingBarcodeDataError','起升条码数据错误','BOOL', '0-无错误；1-起升条码数据错误',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'DoubleIn','双重入库','BOOL', '0-无故障；1-双重入库 满入',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'EmptyOut','空货位出库','BOOL', '0-无故障；1-空货位出库 空出',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'AdressError','0-无故障；1-地址错','BOOL', '0-无故障；1-地址错',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'MainCocontactorInterrupt','主接触器断开','BOOL', '0-无故障；1-主接触器断开 （急停、冲 顶、超速保 护，行走超 限动作）',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'HorizontalBreakerOrBrakeInterrupt','水平断路器/制动器跳闸','BOOL', '0-无故障；1-水平断路器/制动器跳闸',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'RaisingBreakerOrBrakeInterrupt','起升断路器/制动器跳闸','BOOL', '0-无故障；1-起升断路器/制动器跳闸',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'PalletForkBreakerOrBrakeInterrupt','货叉断路器/制动器跳闸','BOOL', '0-无故障；1-货叉断路器/制动器跳闸',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'HorizontalLeadingendOut','水平前端超限（前进终点）','BOOL', '0-无超限，1-水平前端超限（前进终点）',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'HorizontalTrailingendOut','水平后端超限（后退终点）','BOOL', '0-无超限；1-水平后端超限（后退终点）',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'VerticalHorizontalLeadingendOut','垂直上端超限（上升终点）','BOOL', '0-无超限；1-垂直上端超限（上升终点）',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'VerticalHorizontalTrailingendOut','垂直下端超限（下降终点）','BOOL', '0-无超限；1-垂直下端超限（下降终点）',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'Free1','Free1','BOOL', 'free',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'Free2','Free2','BOOL', 'free',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'Free3','Free3','BOOL', 'free',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'Free4','Free4','BOOL', 'free',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'TaskExcuteStatus','任务执行','BYTE', '1-待机；2-任务执行中;3-任务完成；4-任务中断（出 错） 1*',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'TaskNo1','任务号1','DWORD', '托盘条码数据 1（任务号）',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'TaskNo2','任务号2','WORD', '托盘条码数据 2（任务号）(双托盘时使用)',1);
insert into deviceprop(deviceTypeId,code,name,type,description,enable) values (1,'Free5','Free5','WORD', 'free',1) ;
-- 堆垛机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,devicePropCode,serverHandle,address,value,enable) values(1, 'TaskValidate', -1, 'DB101B0' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'WorkModel', -1, 'DB101B1' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'OperationModel', -1, 'DB101B2' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'WorkStatus', -1, 'DB101B3' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'HorizontalDistance', -1, 'DB101D4' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'VerticalDistance', -1, 'DB101D8' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'CurrentColumn', -1, 'DB101B12' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'CurrentLayer', -1, 'DB101B13' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'HasPallet', -1, 'DB101B14' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'LeftForkOutWhenInOrigin', -1, 'DB101X15.0' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'RightForkOutWhenInOrigin', -1, 'DB101X15.1' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'LeftShape', -1, 'DB101X15.2' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'RightShape', -1, 'DB101X15.3' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'Overload', -1, 'DB101X15.4' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'Rope', -1, 'DB101X15.5' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'RunningUuivertorAlarm', -1, 'DB101X15.6' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'RaisingUuivertorAlarm', -1, 'DB101X15.7' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'RunningTimeout', -1, 'DB101X16.0' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'RaisingTimeout', -1, 'DB101X16.1' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'PalletForkTimeout', -1, 'DB101X16.2' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'OverHeight1', -1, 'DB101X16.3' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'OverHeight2', -1, 'DB101X16.4' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'OverHeight3', -1, 'DB101X16.5' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'OverHeight', -1, 'DB101X16.6' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'HorizontalLaserDataError', -1, 'DB101X16.7' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'RaisingBarcodeDataError', -1, 'DB101X17.0' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'DoubleIn', -1, 'DB101X17.1' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'EmptyOut', -1, 'DB101X17.2' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'AdressError', -1, 'DB101X17.3' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'MainCocontactorInterrupt', -1, 'DB101X17.4' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'HorizontalBreakerOrBrakeInterrupt', -1, 'DB101X17.5' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'RaisingBreakerOrBrakeInterrupt', -1, 'DB101X17.6' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'PalletForkBreakerOrBrakeInterrupt', -1, 'DB101X17.7' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'HorizontalLeadingendOut', -1, 'DB101X18.0' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'HorizontalTrailingendOut', -1, 'DB101X18.1' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'VerticalHorizontalLeadingendOut', -1, 'DB101X18.2' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'VerticalHorizontalTrailingendOut', -1, 'DB101X18.3' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'Free1', -1, 'DB101X18.4' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'Free2', -1, 'DB101X18.5' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'Free3', -1, 'DB101X18.6' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'Free4', -1, 'DB101X18.7' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'TaskExcuteStatus', -1, 'DB101B19' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'TaskNo1', -1, 'DB101D20' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'TaskNo2', -1, 'DB101D24' ,'-1',1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values(1, 'Free5', -1, 'DB101W28' ,'-1',1);
-- 堆垛机1 WCS-->PLC Address
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values (1, 'WCSTaskFlag', -1, 'DB100B0', '-1', 1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values (1, 'WCSStop', -1, 'DB100B1', '-1', 1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values (1, 'WCSFromRow', -1, 'DB100B2', '-1', 1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values (1, 'WCSFromLayer', -1, 'DB100B3', '-1', 1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values (1, 'WCSFromColumn', -1, 'DB100B4', '-1', 1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values (1, 'WCSToRow', -1, 'DB100B5', '-1', 1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values (1, 'WCSToLayer', -1, 'DB100B6', '-1', 1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values (1, 'WCSToColumn', -1, 'DB100B7', '-1', 1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values (1, 'WCSTaskNo', -1, 'DB100D8', '-1', 1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values (1, 'WCSValidateCode', -1, 'DB100B12','-1', 1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values (1, 'WCSFree1', -1, 'DB100B13','-1', 1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values (1, 'WCSFree2', -1, 'DB100B14','-1', 1);
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value,enable) values (1, 'WCSFree3', -1, 'DB100B15','-1', 1);
-- 货位
--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 ('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_2DB1500W10', '-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_2DB1500W62', '-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_2DB1500W114', '-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]DB1510BW4', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (5, 'PalletBarcode', -1, 'S7:[S7 connection_2]DB1510W6', '-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]DB1510BW30', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (6, 'PalletBarcode', -1, 'S7:[S7 connection_2]DB1510W32', '-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]DB1510BW56', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (7, 'PalletBarcode', -1, 'S7:[S7 connection_2]DB1510W58', '-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]DB1510BW82', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (8, 'PalletBarcode', -1, 'S7:[S7 connection_2]DB1510W84', '-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]DB1510BW108', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (9, 'PalletBarcode', -1, 'S7:[S7 connection_2]DB1510W110', '-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]DB1510BW134', '-1');
insert into deviceaddress(deviceId,devicePropCode,serverHandle,address,value) values (10, 'PalletBarcode', -1, 'S7:[S7 connection_2]DB1510W136', '-1');