TYPE=VIEW
query=select `wmsdb`.`t_instockbillitem`.`actualProductBatch` AS `actualProductBatch`,`wmsdb`.`t_instockbillitem`.`planArrivalQuantity` AS `planArrivalQuantity`,`wmsdb`.`t_instockbillitem`.`productBatch` AS `productBatch`,`wmsdb`.`t_instockbillitem`.`unloadWay` AS `unloadWay`,`wmsdb`.`t_instockbillitem`.`instockBillId` AS `instockBillId`,`wmsdb`.`t_instockbillitem`.`groundingStatus` AS `groundingStatus`,`wmsdb`.`t_instockbillitem`.`instockBillItemId` AS `instockBillItemId`,`wmsdb`.`t_instockbillitem`.`areaId` AS `areaId`,`wmsdb`.`t_instockbillitem`.`goodsId` AS `goodsId`,`wmsdb`.`t_instockbillitem`.`instockDemandBillItemId` AS `instockDemandBillItemId`,`wmsdb`.`t_instockbillitem`.`actualLocation` AS `actualLocation`,`wmsdb`.`t_instockbillitem`.`groundingTime` AS `groundingTime`,`wmsdb`.`t_goods`.`goodsCode` AS `goodsCode`,`wmsdb`.`t_goods`.`goodsName` AS `goodsName`,`wmsdb`.`t_goods`.`price` AS `price`,`wmsdb`.`t_dict`.`dictName` AS `unloadWayName`,`wmsdb`.`t_warehousearea`.`areaName` AS `areaName`,`wmsdb`.`t_goods`.`specs` AS `specs` from (((`wmsdb`.`t_instockbillitem` join `wmsdb`.`t_goods` on((`wmsdb`.`t_instockbillitem`.`goodsId` = `wmsdb`.`t_goods`.`goodsId`))) left join `wmsdb`.`t_dict` on((`wmsdb`.`t_instockbillitem`.`unloadWay` = `wmsdb`.`t_dict`.`dictId`))) left join `wmsdb`.`t_warehousearea` on((`wmsdb`.`t_instockbillitem`.`areaId` = `wmsdb`.`t_warehousearea`.`areaId`))) where (`wmsdb`.`t_dict`.`dictType` = 7)
md5=99abab2cc21c88b6162a544b74dbd778
updatable=0
algorithm=0
definer_user=root
definer_host=%
suid=1
with_check_option=0
timestamp=2016-01-12 06:00:59
create-version=1
source=select `t_instockbillitem`.`actualProductBatch` AS `actualProductBatch`,`t_instockbillitem`.`planArrivalQuantity` AS `planArrivalQuantity`,`t_instockbillitem`.`productBatch` AS `productBatch`,`t_instockbillitem`.`unloadWay` AS `unloadWay`,`t_instockbillitem`.`instockBillId` AS `instockBillId`,`t_instockbillitem`.`groundingStatus` AS `groundingStatus`,`t_instockbillitem`.`instockBillItemId` AS `instockBillItemId`,`t_instockbillitem`.`areaId` AS `areaId`,`t_instockbillitem`.`goodsId` AS `goodsId`,`t_instockbillitem`.`instockDemandBillItemId` AS `instockDemandBillItemId`,`t_instockbillitem`.`actualLocation` AS `actualLocation`,`t_instockbillitem`.`groundingTime` AS `groundingTime`,`t_goods`.`goodsCode` AS `goodsCode`,`t_goods`.`goodsName` AS `goodsName`,`t_goods`.`price` AS `price`,`t_dict`.`dictName` AS `unloadWayName`,`t_warehousearea`.`areaName` AS `areaName`,`t_goods`.`specs` AS `specs` from (((`t_instockbillitem` join `t_goods` on((`t_instockbillitem`.`goodsId` = `t_goods`.`goodsId`))) left join `t_dict` on((`t_instockbillitem`.`unloadWay` = `t_dict`.`dictId`))) left join `t_warehousearea` on((`t_instockbillitem`.`areaId` = `t_warehousearea`.`areaId`))) where (`t_dict`.`dictType` = 7)
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `wmsdb`.`t_instockbillitem`.`actualProductBatch` AS `actualProductBatch`,`wmsdb`.`t_instockbillitem`.`planArrivalQuantity` AS `planArrivalQuantity`,`wmsdb`.`t_instockbillitem`.`productBatch` AS `productBatch`,`wmsdb`.`t_instockbillitem`.`unloadWay` AS `unloadWay`,`wmsdb`.`t_instockbillitem`.`instockBillId` AS `instockBillId`,`wmsdb`.`t_instockbillitem`.`groundingStatus` AS `groundingStatus`,`wmsdb`.`t_instockbillitem`.`instockBillItemId` AS `instockBillItemId`,`wmsdb`.`t_instockbillitem`.`areaId` AS `areaId`,`wmsdb`.`t_instockbillitem`.`goodsId` AS `goodsId`,`wmsdb`.`t_instockbillitem`.`instockDemandBillItemId` AS `instockDemandBillItemId`,`wmsdb`.`t_instockbillitem`.`actualLocation` AS `actualLocation`,`wmsdb`.`t_instockbillitem`.`groundingTime` AS `groundingTime`,`wmsdb`.`t_goods`.`goodsCode` AS `goodsCode`,`wmsdb`.`t_goods`.`goodsName` AS `goodsName`,`wmsdb`.`t_goods`.`price` AS `price`,`wmsdb`.`t_dict`.`dictName` AS `unloadWayName`,`wmsdb`.`t_warehousearea`.`areaName` AS `areaName`,`wmsdb`.`t_goods`.`specs` AS `specs` from (((`wmsdb`.`t_instockbillitem` join `wmsdb`.`t_goods` on((`wmsdb`.`t_instockbillitem`.`goodsId` = `wmsdb`.`t_goods`.`goodsId`))) left join `wmsdb`.`t_dict` on((`wmsdb`.`t_instockbillitem`.`unloadWay` = `wmsdb`.`t_dict`.`dictId`))) left join `wmsdb`.`t_warehousearea` on((`wmsdb`.`t_instockbillitem`.`areaId` = `wmsdb`.`t_warehousearea`.`areaId`))) where (`wmsdb`.`t_dict`.`dictType` = 7)
