TYPE=VIEW
query=select `wmsdb`.`t_outstockbillitem`.`outstockBillItemId` AS `outstockBillItemId`,`wmsdb`.`t_outstockbillitem`.`actualArrivalQuantity` AS `actualArrivalQuantity`,`wmsdb`.`t_outstockbillitem`.`actualOutstockLocation` AS `actualOutstockLocation`,`wmsdb`.`t_outstockbillitem`.`goodsId` AS `goodsId`,`wmsdb`.`t_outstockbillitem`.`outstockBillId` AS `outstockBillId`,`wmsdb`.`t_outstockbillitem`.`outstockTactics` AS `outstockTactics`,`wmsdb`.`t_outstockbillitem`.`outstockTacticsWay` AS `outstockTacticsWay`,`wmsdb`.`t_outstockbillitem`.`planOutstockLocation` AS `planOutstockLocation`,`wmsdb`.`t_outstockbillitem`.`productBatch` AS `productBatch`,`wmsdb`.`t_outstockbillitem`.`supplierId` AS `supplierId`,`wmsdb`.`t_outstockbillitem`.`trayNumber` AS `trayNumber`,`wmsdb`.`t_goods`.`goodsCode` AS `goodsCode`,`wmsdb`.`t_goods`.`goodsName` AS `goodsName`,`wmsdb`.`t_goods`.`price` AS `price`,`wmsdb`.`t_supplier`.`supplierName` AS `supplierName`,`wmsdb`.`t_outstockbillitem`.`status` AS `status`,`wmsdb`.`t_outstockbillitem`.`offshelvesTime` AS `offshelvesTime`,`wmsdb`.`t_warehouselocation`.`locationNo` AS `planLocationNo`,`t_warehouselocationactual`.`locationNo` AS `locationNo`,`wmsdb`.`t_outstockbillitem`.`actualArrivalQuantity` AS `planOutstockQuantity`,`wmsdb`.`t_outstockbillitem`.`instockTime` AS `instockTime`,`wmsdb`.`t_outstockbillitem`.`stockQuantity` AS `stockQuantity`,`wmsdb`.`t_outstockbillitem`.`actualOutstockQuantity` AS `actualOutstockQuantity` from ((((`wmsdb`.`t_outstockbillitem` left join `wmsdb`.`t_goods` on((`wmsdb`.`t_outstockbillitem`.`goodsId` = `wmsdb`.`t_goods`.`goodsId`))) left join `wmsdb`.`t_supplier` on((`wmsdb`.`t_outstockbillitem`.`supplierId` = `wmsdb`.`t_supplier`.`supplierId`))) left join `wmsdb`.`t_warehouselocation` on((`wmsdb`.`t_outstockbillitem`.`planOutstockLocation` = `wmsdb`.`t_warehouselocation`.`locationId`))) left join `wmsdb`.`t_warehouselocation` `t_warehouselocationactual` on((`wmsdb`.`t_outstockbillitem`.`actualOutstockLocation` = `t_warehouselocationactual`.`locationId`)))
md5=865702dc406f8174f38bbda4ec0afa34
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_outstockbillitem`.`outstockBillItemId` AS `outstockBillItemId`,`t_outstockbillitem`.`actualArrivalQuantity` AS `actualArrivalQuantity`,`t_outstockbillitem`.`actualOutstockLocation` AS `actualOutstockLocation`,`t_outstockbillitem`.`goodsId` AS `goodsId`,`t_outstockbillitem`.`outstockBillId` AS `outstockBillId`,`t_outstockbillitem`.`outstockTactics` AS `outstockTactics`,`t_outstockbillitem`.`outstockTacticsWay` AS `outstockTacticsWay`,`t_outstockbillitem`.`planOutstockLocation` AS `planOutstockLocation`,`t_outstockbillitem`.`productBatch` AS `productBatch`,`t_outstockbillitem`.`supplierId` AS `supplierId`,`t_outstockbillitem`.`trayNumber` AS `trayNumber`,`t_goods`.`goodsCode` AS `goodsCode`,`t_goods`.`goodsName` AS `goodsName`,`t_goods`.`price` AS `price`,`t_supplier`.`supplierName` AS `supplierName`,`t_outstockbillitem`.`status` AS `status`,`t_outstockbillitem`.`offshelvesTime` AS `offshelvesTime`,`t_warehouselocation`.`locationNo` AS `planLocationNo`,`t_warehouselocationactual`.`locationNo` AS `locationNo`,`t_outstockbillitem`.`actualArrivalQuantity` AS `planOutstockQuantity`,`t_outstockbillitem`.`instockTime` AS `instockTime`,`t_outstockbillitem`.`stockQuantity` AS `stockQuantity`,`t_outstockbillitem`.`actualOutstockQuantity` AS `actualOutstockQuantity` from ((((`t_outstockbillitem` left join `t_goods` on((`t_outstockbillitem`.`goodsId` = `t_goods`.`goodsId`))) left join `t_supplier` on((`t_outstockbillitem`.`supplierId` = `t_supplier`.`supplierId`))) left join `t_warehouselocation` on((`t_outstockbillitem`.`planOutstockLocation` = `t_warehouselocation`.`locationId`))) left join `t_warehouselocation` `t_warehouselocationactual` on((`t_outstockbillitem`.`actualOutstockLocation` = `t_warehouselocationactual`.`locationId`)))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `wmsdb`.`t_outstockbillitem`.`outstockBillItemId` AS `outstockBillItemId`,`wmsdb`.`t_outstockbillitem`.`actualArrivalQuantity` AS `actualArrivalQuantity`,`wmsdb`.`t_outstockbillitem`.`actualOutstockLocation` AS `actualOutstockLocation`,`wmsdb`.`t_outstockbillitem`.`goodsId` AS `goodsId`,`wmsdb`.`t_outstockbillitem`.`outstockBillId` AS `outstockBillId`,`wmsdb`.`t_outstockbillitem`.`outstockTactics` AS `outstockTactics`,`wmsdb`.`t_outstockbillitem`.`outstockTacticsWay` AS `outstockTacticsWay`,`wmsdb`.`t_outstockbillitem`.`planOutstockLocation` AS `planOutstockLocation`,`wmsdb`.`t_outstockbillitem`.`productBatch` AS `productBatch`,`wmsdb`.`t_outstockbillitem`.`supplierId` AS `supplierId`,`wmsdb`.`t_outstockbillitem`.`trayNumber` AS `trayNumber`,`wmsdb`.`t_goods`.`goodsCode` AS `goodsCode`,`wmsdb`.`t_goods`.`goodsName` AS `goodsName`,`wmsdb`.`t_goods`.`price` AS `price`,`wmsdb`.`t_supplier`.`supplierName` AS `supplierName`,`wmsdb`.`t_outstockbillitem`.`status` AS `status`,`wmsdb`.`t_outstockbillitem`.`offshelvesTime` AS `offshelvesTime`,`wmsdb`.`t_warehouselocation`.`locationNo` AS `planLocationNo`,`t_warehouselocationactual`.`locationNo` AS `locationNo`,`wmsdb`.`t_outstockbillitem`.`actualArrivalQuantity` AS `planOutstockQuantity`,`wmsdb`.`t_outstockbillitem`.`instockTime` AS `instockTime`,`wmsdb`.`t_outstockbillitem`.`stockQuantity` AS `stockQuantity`,`wmsdb`.`t_outstockbillitem`.`actualOutstockQuantity` AS `actualOutstockQuantity` from ((((`wmsdb`.`t_outstockbillitem` left join `wmsdb`.`t_goods` on((`wmsdb`.`t_outstockbillitem`.`goodsId` = `wmsdb`.`t_goods`.`goodsId`))) left join `wmsdb`.`t_supplier` on((`wmsdb`.`t_outstockbillitem`.`supplierId` = `wmsdb`.`t_supplier`.`supplierId`))) left join `wmsdb`.`t_warehouselocation` on((`wmsdb`.`t_outstockbillitem`.`planOutstockLocation` = `wmsdb`.`t_warehouselocation`.`locationId`))) left join `wmsdb`.`t_warehouselocation` `t_warehouselocationactual` on((`wmsdb`.`t_outstockbillitem`.`actualOutstockLocation` = `t_warehouselocationactual`.`locationId`)))
