TYPE=VIEW
query=select `wmsdb`.`t_goods`.`goodsName` AS `goodsName`,`wmsdb`.`t_transferstockdemandbillitem`.`productBatch` AS `productBatch`,`wmsdb`.`t_transferstockdemandbillitem`.`planTransferQuantity` AS `planTransferQuantity`,`wmsdb`.`t_goods`.`price` AS `price`,`wmsdb`.`t_transferstockdemandbillitem`.`goodsId` AS `goodsId`,`wmsdb`.`t_transferstockdemandbillitem`.`supplierId` AS `supplierId`,`wmsdb`.`t_transferstockdemandbillitem`.`transferstockDemandBillId` AS `transferstockDemandBillId`,`wmsdb`.`t_goods`.`goodsCode` AS `goodsCode`,`wmsdb`.`t_supplier`.`supplierName` AS `supplierName`,`wmsdb`.`t_transferstockdemandbillitem`.`offshelvesTime` AS `offshelvesTime`,`wmsdb`.`t_transferstockdemandbillitem`.`status` AS `status`,`wmsdb`.`t_transferstockdemandbillitem`.`actualTransferQuantity` AS `actualTransferQuantity` from ((`wmsdb`.`t_transferstockdemandbillitem` join `wmsdb`.`t_goods` on((`wmsdb`.`t_transferstockdemandbillitem`.`goodsId` = `wmsdb`.`t_goods`.`goodsId`))) join `wmsdb`.`t_supplier` on((`wmsdb`.`t_transferstockdemandbillitem`.`supplierId` = `wmsdb`.`t_supplier`.`supplierId`)))
md5=257b1e1a2287d03dce28060fcd2d2fc3
updatable=1
algorithm=0
definer_user=root
definer_host=%
suid=1
with_check_option=0
timestamp=2016-01-12 06:01:01
create-version=1
source=select `t_goods`.`goodsName` AS `goodsName`,`t_transferstockdemandbillitem`.`productBatch` AS `productBatch`,`t_transferstockdemandbillitem`.`planTransferQuantity` AS `planTransferQuantity`,`t_goods`.`price` AS `price`,`t_transferstockdemandbillitem`.`goodsId` AS `goodsId`,`t_transferstockdemandbillitem`.`supplierId` AS `supplierId`,`t_transferstockdemandbillitem`.`transferstockDemandBillId` AS `transferstockDemandBillId`,`t_goods`.`goodsCode` AS `goodsCode`,`t_supplier`.`supplierName` AS `supplierName`,`t_transferstockdemandbillitem`.`offshelvesTime` AS `offshelvesTime`,`t_transferstockdemandbillitem`.`status` AS `status`,`t_transferstockdemandbillitem`.`actualTransferQuantity` AS `actualTransferQuantity` from ((`t_transferstockdemandbillitem` join `t_goods` on((`t_transferstockdemandbillitem`.`goodsId` = `t_goods`.`goodsId`))) join `t_supplier` on((`t_transferstockdemandbillitem`.`supplierId` = `t_supplier`.`supplierId`)))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `wmsdb`.`t_goods`.`goodsName` AS `goodsName`,`wmsdb`.`t_transferstockdemandbillitem`.`productBatch` AS `productBatch`,`wmsdb`.`t_transferstockdemandbillitem`.`planTransferQuantity` AS `planTransferQuantity`,`wmsdb`.`t_goods`.`price` AS `price`,`wmsdb`.`t_transferstockdemandbillitem`.`goodsId` AS `goodsId`,`wmsdb`.`t_transferstockdemandbillitem`.`supplierId` AS `supplierId`,`wmsdb`.`t_transferstockdemandbillitem`.`transferstockDemandBillId` AS `transferstockDemandBillId`,`wmsdb`.`t_goods`.`goodsCode` AS `goodsCode`,`wmsdb`.`t_supplier`.`supplierName` AS `supplierName`,`wmsdb`.`t_transferstockdemandbillitem`.`offshelvesTime` AS `offshelvesTime`,`wmsdb`.`t_transferstockdemandbillitem`.`status` AS `status`,`wmsdb`.`t_transferstockdemandbillitem`.`actualTransferQuantity` AS `actualTransferQuantity` from ((`wmsdb`.`t_transferstockdemandbillitem` join `wmsdb`.`t_goods` on((`wmsdb`.`t_transferstockdemandbillitem`.`goodsId` = `wmsdb`.`t_goods`.`goodsId`))) join `wmsdb`.`t_supplier` on((`wmsdb`.`t_transferstockdemandbillitem`.`supplierId` = `wmsdb`.`t_supplier`.`supplierId`)))
