TYPE=VIEW
query=select `wmsdb`.`t_instockdemandbillitem`.`instockDemandBillId` AS `instockDemandBillId`,`wmsdb`.`t_instockdemandbillitem`.`goodsId` AS `goodsId`,`wmsdb`.`t_instockdemandbillitem`.`productBatch` AS `productBatch`,`wmsdb`.`t_instockdemandbillitem`.`areaId` AS `areaId`,`wmsdb`.`t_goods`.`goodsCode` AS `goodsCode`,`wmsdb`.`t_goods`.`goodsName` AS `goodsName`,`wmsdb`.`t_goods`.`price` AS `price`,`wmsdb`.`t_goods`.`specs` AS `specs`,`wmsdb`.`t_instockdemandbillitem`.`planArrivalQuantity` AS `planArrivalQuantity`,`wmsdb`.`t_warehousearea`.`areaName` AS `areaName`,`wmsdb`.`t_instockdemandbillitem`.`instockDemandBillItemId` AS `instockDemandBillItemId` from ((`wmsdb`.`t_goods` left join `wmsdb`.`t_instockdemandbillitem` on((`wmsdb`.`t_instockdemandbillitem`.`goodsId` = `wmsdb`.`t_goods`.`goodsId`))) left join `wmsdb`.`t_warehousearea` on((`wmsdb`.`t_instockdemandbillitem`.`areaId` = `wmsdb`.`t_warehousearea`.`areaId`)))
md5=81fc3ccb701b792d439cd06162114a97
updatable=0
algorithm=0
definer_user=root
definer_host=%
suid=1
with_check_option=0
timestamp=2016-01-12 06:01:00
create-version=1
source=select `t_instockdemandbillitem`.`instockDemandBillId` AS `instockDemandBillId`,`t_instockdemandbillitem`.`goodsId` AS `goodsId`,`t_instockdemandbillitem`.`productBatch` AS `productBatch`,`t_instockdemandbillitem`.`areaId` AS `areaId`,`t_goods`.`goodsCode` AS `goodsCode`,`t_goods`.`goodsName` AS `goodsName`,`t_goods`.`price` AS `price`,`t_goods`.`specs` AS `specs`,`t_instockdemandbillitem`.`planArrivalQuantity` AS `planArrivalQuantity`,`t_warehousearea`.`areaName` AS `areaName`,`t_instockdemandbillitem`.`instockDemandBillItemId` AS `instockDemandBillItemId` from ((`t_goods` left join `t_instockdemandbillitem` on((`t_instockdemandbillitem`.`goodsId` = `t_goods`.`goodsId`))) left join `t_warehousearea` on((`t_instockdemandbillitem`.`areaId` = `t_warehousearea`.`areaId`)))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `wmsdb`.`t_instockdemandbillitem`.`instockDemandBillId` AS `instockDemandBillId`,`wmsdb`.`t_instockdemandbillitem`.`goodsId` AS `goodsId`,`wmsdb`.`t_instockdemandbillitem`.`productBatch` AS `productBatch`,`wmsdb`.`t_instockdemandbillitem`.`areaId` AS `areaId`,`wmsdb`.`t_goods`.`goodsCode` AS `goodsCode`,`wmsdb`.`t_goods`.`goodsName` AS `goodsName`,`wmsdb`.`t_goods`.`price` AS `price`,`wmsdb`.`t_goods`.`specs` AS `specs`,`wmsdb`.`t_instockdemandbillitem`.`planArrivalQuantity` AS `planArrivalQuantity`,`wmsdb`.`t_warehousearea`.`areaName` AS `areaName`,`wmsdb`.`t_instockdemandbillitem`.`instockDemandBillItemId` AS `instockDemandBillItemId` from ((`wmsdb`.`t_goods` left join `wmsdb`.`t_instockdemandbillitem` on((`wmsdb`.`t_instockdemandbillitem`.`goodsId` = `wmsdb`.`t_goods`.`goodsId`))) left join `wmsdb`.`t_warehousearea` on((`wmsdb`.`t_instockdemandbillitem`.`areaId` = `wmsdb`.`t_warehousearea`.`areaId`)))
