TYPE=VIEW
query=select `wmsdb`.`t_goods`.`goodsCode` AS `goodsCode`,`wmsdb`.`t_goods`.`goodsName` AS `goodsName`,`wmsdb`.`t_outstockdemandbillitem`.`productBatch` AS `productBatch`,`wmsdb`.`t_outstockdemandbillitem`.`planArrivalQuantity` AS `planArrivalQuantity`,`wmsdb`.`t_goods`.`price` AS `price`,`wmsdb`.`t_outstockdemandbillitem`.`supplierId` AS `supplierId`,`wmsdb`.`t_supplier`.`supplierName` AS `supplierName`,`wmsdb`.`t_outstockdemandbillitem`.`outstockDemandBillItemId` AS `outstockDemandBillItemId`,`wmsdb`.`t_outstockdemandbillitem`.`outstockDemandBillId` AS `outstockDemandBillId`,`wmsdb`.`t_outstockdemandbillitem`.`outstockTacticsWay` AS `outstockTacticsWay`,`wmsdb`.`t_outstockdemandbillitem`.`actualArrivalQuantity` AS `actualArrivalQuantity`,`wmsdb`.`t_outstockdemandbillitem`.`outstockTactics` AS `outstockTactics`,`wmsdb`.`t_outstockdemandbillitem`.`planOutstockLocation` AS `planOutstockLocation`,`wmsdb`.`t_warehouselocation`.`locationNo` AS `locationNo`,`wmsdb`.`t_outstockdemandbillitem`.`goodsId` AS `goodsId`,`wmsdb`.`t_outstockdemandbillitem`.`instockTime` AS `instockTime`,`wmsdb`.`t_outstockdemandbillitem`.`actualOutstockTotalQuantity` AS `actualOutstockTotalQuantity` from (((`wmsdb`.`t_outstockdemandbillitem` join `wmsdb`.`t_goods` on((`wmsdb`.`t_outstockdemandbillitem`.`goodsId` = `wmsdb`.`t_goods`.`goodsId`))) join `wmsdb`.`t_supplier` on((`wmsdb`.`t_outstockdemandbillitem`.`supplierId` = `wmsdb`.`t_supplier`.`supplierId`))) join `wmsdb`.`t_warehouselocation` on((`wmsdb`.`t_outstockdemandbillitem`.`planOutstockLocation` = `wmsdb`.`t_warehouselocation`.`locationId`)))
md5=d5c85e9280b99455cbd60d685bafb091
updatable=1
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_goods`.`goodsCode` AS `goodsCode`,`t_goods`.`goodsName` AS `goodsName`,`t_outstockdemandbillitem`.`productBatch` AS `productBatch`,`t_outstockdemandbillitem`.`planArrivalQuantity` AS `planArrivalQuantity`,`t_goods`.`price` AS `price`,`t_outstockdemandbillitem`.`supplierId` AS `supplierId`,`t_supplier`.`supplierName` AS `supplierName`,`t_outstockdemandbillitem`.`outstockDemandBillItemId` AS `outstockDemandBillItemId`,`t_outstockdemandbillitem`.`outstockDemandBillId` AS `outstockDemandBillId`,`t_outstockdemandbillitem`.`outstockTacticsWay` AS `outstockTacticsWay`,`t_outstockdemandbillitem`.`actualArrivalQuantity` AS `actualArrivalQuantity`,`t_outstockdemandbillitem`.`outstockTactics` AS `outstockTactics`,`t_outstockdemandbillitem`.`planOutstockLocation` AS `planOutstockLocation`,`t_warehouselocation`.`locationNo` AS `locationNo`,`t_outstockdemandbillitem`.`goodsId` AS `goodsId`,`t_outstockdemandbillitem`.`instockTime` AS `instockTime`,`t_outstockdemandbillitem`.`actualOutstockTotalQuantity` AS `actualOutstockTotalQuantity` from (((`t_outstockdemandbillitem` join `t_goods` on((`t_outstockdemandbillitem`.`goodsId` = `t_goods`.`goodsId`))) join `t_supplier` on((`t_outstockdemandbillitem`.`supplierId` = `t_supplier`.`supplierId`))) join `t_warehouselocation` on((`t_outstockdemandbillitem`.`planOutstockLocation` = `t_warehouselocation`.`locationId`)))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `wmsdb`.`t_goods`.`goodsCode` AS `goodsCode`,`wmsdb`.`t_goods`.`goodsName` AS `goodsName`,`wmsdb`.`t_outstockdemandbillitem`.`productBatch` AS `productBatch`,`wmsdb`.`t_outstockdemandbillitem`.`planArrivalQuantity` AS `planArrivalQuantity`,`wmsdb`.`t_goods`.`price` AS `price`,`wmsdb`.`t_outstockdemandbillitem`.`supplierId` AS `supplierId`,`wmsdb`.`t_supplier`.`supplierName` AS `supplierName`,`wmsdb`.`t_outstockdemandbillitem`.`outstockDemandBillItemId` AS `outstockDemandBillItemId`,`wmsdb`.`t_outstockdemandbillitem`.`outstockDemandBillId` AS `outstockDemandBillId`,`wmsdb`.`t_outstockdemandbillitem`.`outstockTacticsWay` AS `outstockTacticsWay`,`wmsdb`.`t_outstockdemandbillitem`.`actualArrivalQuantity` AS `actualArrivalQuantity`,`wmsdb`.`t_outstockdemandbillitem`.`outstockTactics` AS `outstockTactics`,`wmsdb`.`t_outstockdemandbillitem`.`planOutstockLocation` AS `planOutstockLocation`,`wmsdb`.`t_warehouselocation`.`locationNo` AS `locationNo`,`wmsdb`.`t_outstockdemandbillitem`.`goodsId` AS `goodsId`,`wmsdb`.`t_outstockdemandbillitem`.`instockTime` AS `instockTime`,`wmsdb`.`t_outstockdemandbillitem`.`actualOutstockTotalQuantity` AS `actualOutstockTotalQuantity` from (((`wmsdb`.`t_outstockdemandbillitem` join `wmsdb`.`t_goods` on((`wmsdb`.`t_outstockdemandbillitem`.`goodsId` = `wmsdb`.`t_goods`.`goodsId`))) join `wmsdb`.`t_supplier` on((`wmsdb`.`t_outstockdemandbillitem`.`supplierId` = `wmsdb`.`t_supplier`.`supplierId`))) join `wmsdb`.`t_warehouselocation` on((`wmsdb`.`t_outstockdemandbillitem`.`planOutstockLocation` = `wmsdb`.`t_warehouselocation`.`locationId`)))
