TYPE=VIEW
query=select `wmsdb`.`t_cancelstockdemandbillitem`.`goodsId` AS `goodsId`,`wmsdb`.`t_cancelstockdemandbillitem`.`productBatch` AS `productBatch`,`wmsdb`.`t_cancelstockdemandbillitem`.`planCancelQuantity` AS `planCancelQuantity`,`wmsdb`.`t_cancelstockdemandbillitem`.`status` AS `status`,`wmsdb`.`t_cancelstockdemandbillitem`.`actualCancelQuantity` AS `actualCancelQuantity`,`wmsdb`.`t_cancelstockdemandbillitem`.`locationId` AS `locationId`,`wmsdb`.`t_cancelstockdemandbillitem`.`offshelvesTime` AS `offshelvesTime`,`wmsdb`.`t_cancelstockdemandbillitem`.`cancelstockDemandBillId` AS `cancelstockDemandBillId`,`wmsdb`.`t_warehouselocation`.`locationNo` AS `locationNo`,`wmsdb`.`t_goods`.`goodsCode` AS `goodsCode`,`wmsdb`.`t_goods`.`goodsName` AS `goodsName`,`wmsdb`.`t_goods`.`price` AS `price`,`wmsdb`.`t_cancelstockdemandbillitem`.`cancelstockDemandBillItemId` AS `cancelstockDemandBillItemId` from ((`wmsdb`.`t_cancelstockdemandbillitem` left join `wmsdb`.`t_warehouselocation` on((`wmsdb`.`t_cancelstockdemandbillitem`.`locationId` = `wmsdb`.`t_warehouselocation`.`locationId`))) left join `wmsdb`.`t_goods` on((`wmsdb`.`t_cancelstockdemandbillitem`.`goodsId` = `wmsdb`.`t_goods`.`goodsId`)))
md5=039e60ce9ab772c524e0c4e9ccaf8c75
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_cancelstockdemandbillitem`.`goodsId` AS `goodsId`,`t_cancelstockdemandbillitem`.`productBatch` AS `productBatch`,`t_cancelstockdemandbillitem`.`planCancelQuantity` AS `planCancelQuantity`,`t_cancelstockdemandbillitem`.`status` AS `status`,`t_cancelstockdemandbillitem`.`actualCancelQuantity` AS `actualCancelQuantity`,`t_cancelstockdemandbillitem`.`locationId` AS `locationId`,`t_cancelstockdemandbillitem`.`offshelvesTime` AS `offshelvesTime`,`t_cancelstockdemandbillitem`.`cancelstockDemandBillId` AS `cancelstockDemandBillId`,`t_warehouselocation`.`locationNo` AS `locationNo`,`t_goods`.`goodsCode` AS `goodsCode`,`t_goods`.`goodsName` AS `goodsName`,`t_goods`.`price` AS `price`,`t_cancelstockdemandbillitem`.`cancelstockDemandBillItemId` AS `cancelstockDemandBillItemId` from ((`t_cancelstockdemandbillitem` left join `t_warehouselocation` on((`t_cancelstockdemandbillitem`.`locationId` = `t_warehouselocation`.`locationId`))) left join `t_goods` on((`t_cancelstockdemandbillitem`.`goodsId` = `t_goods`.`goodsId`)))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `wmsdb`.`t_cancelstockdemandbillitem`.`goodsId` AS `goodsId`,`wmsdb`.`t_cancelstockdemandbillitem`.`productBatch` AS `productBatch`,`wmsdb`.`t_cancelstockdemandbillitem`.`planCancelQuantity` AS `planCancelQuantity`,`wmsdb`.`t_cancelstockdemandbillitem`.`status` AS `status`,`wmsdb`.`t_cancelstockdemandbillitem`.`actualCancelQuantity` AS `actualCancelQuantity`,`wmsdb`.`t_cancelstockdemandbillitem`.`locationId` AS `locationId`,`wmsdb`.`t_cancelstockdemandbillitem`.`offshelvesTime` AS `offshelvesTime`,`wmsdb`.`t_cancelstockdemandbillitem`.`cancelstockDemandBillId` AS `cancelstockDemandBillId`,`wmsdb`.`t_warehouselocation`.`locationNo` AS `locationNo`,`wmsdb`.`t_goods`.`goodsCode` AS `goodsCode`,`wmsdb`.`t_goods`.`goodsName` AS `goodsName`,`wmsdb`.`t_goods`.`price` AS `price`,`wmsdb`.`t_cancelstockdemandbillitem`.`cancelstockDemandBillItemId` AS `cancelstockDemandBillItemId` from ((`wmsdb`.`t_cancelstockdemandbillitem` left join `wmsdb`.`t_warehouselocation` on((`wmsdb`.`t_cancelstockdemandbillitem`.`locationId` = `wmsdb`.`t_warehouselocation`.`locationId`))) left join `wmsdb`.`t_goods` on((`wmsdb`.`t_cancelstockdemandbillitem`.`goodsId` = `wmsdb`.`t_goods`.`goodsId`)))
