1
2
3
4
5
6
7
| man_mat表 mat_type int 物料类型{1:单品,2:高频,3:混放}
| cust_wait_pakin表 mat_type int 物料类型{1:单品,2:高频,3:混放}
| cust_wait_pakin_log表 mat_type int 物料类型{1:单品,2:高频,3:混放}
|
| update asr_loc_mast set loc_type2 = 1 where row1 not in (3,4,11,12,18,19) and bay1 < 21
| update asr_loc_mast set loc_type2 = 2 where row1 in (3,4,11,12,18,19) and bay1 < 21
| update asr_loc_mast set loc_type2 = 3 where row1 >= 1 and bay1 >= 21
|
|
