data.sql
106 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
-- 堆垛机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);