TYPE=VIEW
query=select `wmsdb`.`t_supplier`.`supplierName` AS `supplierName`,`wmsdb`.`t_dict`.`dictName` AS `instockGroupName`,`t_dictactual`.`dictName` AS `actualInstockGroupName`,`t_dictground`.`dictName` AS `groundingGroupName`,`wmsdb`.`t_instockbill`.`demandNo` AS `demandNo`,`wmsdb`.`t_instockbill`.`appointmentDate` AS `appointmentDate`,`wmsdb`.`t_instockbill`.`actualArrivalTime` AS `actualArrivalTime`,`wmsdb`.`t_instockbill`.`planArrivalTime` AS `planArrivalTime`,`wmsdb`.`t_instockbill`.`itemNo` AS `itemNo`,`wmsdb`.`t_instockbill`.`orderNo` AS `orderNo`,`wmsdb`.`t_instockbill`.`deliveryCompany` AS `deliveryCompany`,`wmsdb`.`t_instockbill`.`deliveryman` AS `deliveryman`,`wmsdb`.`t_instockbill`.`status` AS `status`,`wmsdb`.`t_instockbill`.`supplierId` AS `supplierId`,`wmsdb`.`t_instockbill`.`vehicleNo` AS `vehicleNo`,`wmsdb`.`t_instockbill`.`instockBillId` AS `instockBillId`,`wmsdb`.`t_instockbill`.`groundingGroup` AS `groundingGroup`,`wmsdb`.`t_supplier`.`status` AS `supplierStatus` from ((((`wmsdb`.`t_instockbill` join `wmsdb`.`t_supplier` on((`wmsdb`.`t_instockbill`.`supplierId` = `wmsdb`.`t_supplier`.`supplierId`))) join `wmsdb`.`t_dict` on((`wmsdb`.`t_instockbill`.`instockGroup` = `wmsdb`.`t_dict`.`dictId`))) join `wmsdb`.`t_dict` `t_dictactual` on((`wmsdb`.`t_instockbill`.`actualInstockGroup` = `t_dictactual`.`dictId`))) left join `wmsdb`.`t_dict` `t_dictground` on((`wmsdb`.`t_instockbill`.`groundingGroup` = `t_dictground`.`dictId`))) where (`wmsdb`.`t_dict`.`dictType` = 10)
md5=eab3bc976a59814cf299c75d120b3801
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_supplier`.`supplierName` AS `supplierName`,`t_dict`.`dictName` AS `instockGroupName`,`t_dictactual`.`dictName` AS `actualInstockGroupName`,`t_dictground`.`dictName` AS `groundingGroupName`,`t_instockbill`.`demandNo` AS `demandNo`,`t_instockbill`.`appointmentDate` AS `appointmentDate`,`t_instockbill`.`actualArrivalTime` AS `actualArrivalTime`,`t_instockbill`.`planArrivalTime` AS `planArrivalTime`,`t_instockbill`.`itemNo` AS `itemNo`,`t_instockbill`.`orderNo` AS `orderNo`,`t_instockbill`.`deliveryCompany` AS `deliveryCompany`,`t_instockbill`.`deliveryman` AS `deliveryman`,`t_instockbill`.`status` AS `status`,`t_instockbill`.`supplierId` AS `supplierId`,`t_instockbill`.`vehicleNo` AS `vehicleNo`,`t_instockbill`.`instockBillId` AS `instockBillId`,`t_instockbill`.`groundingGroup` AS `groundingGroup`,`t_supplier`.`status` AS `supplierStatus` from ((((`t_instockbill` join `t_supplier` on((`t_instockbill`.`supplierId` = `t_supplier`.`supplierId`))) join `t_dict` on((`t_instockbill`.`instockGroup` = `t_dict`.`dictId`))) join `t_dict` `t_dictactual` on((`t_instockbill`.`actualInstockGroup` = `t_dictactual`.`dictId`))) left join `t_dict` `t_dictground` on((`t_instockbill`.`groundingGroup` = `t_dictground`.`dictId`))) where (`t_dict`.`dictType` = 10)
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `wmsdb`.`t_supplier`.`supplierName` AS `supplierName`,`wmsdb`.`t_dict`.`dictName` AS `instockGroupName`,`t_dictactual`.`dictName` AS `actualInstockGroupName`,`t_dictground`.`dictName` AS `groundingGroupName`,`wmsdb`.`t_instockbill`.`demandNo` AS `demandNo`,`wmsdb`.`t_instockbill`.`appointmentDate` AS `appointmentDate`,`wmsdb`.`t_instockbill`.`actualArrivalTime` AS `actualArrivalTime`,`wmsdb`.`t_instockbill`.`planArrivalTime` AS `planArrivalTime`,`wmsdb`.`t_instockbill`.`itemNo` AS `itemNo`,`wmsdb`.`t_instockbill`.`orderNo` AS `orderNo`,`wmsdb`.`t_instockbill`.`deliveryCompany` AS `deliveryCompany`,`wmsdb`.`t_instockbill`.`deliveryman` AS `deliveryman`,`wmsdb`.`t_instockbill`.`status` AS `status`,`wmsdb`.`t_instockbill`.`supplierId` AS `supplierId`,`wmsdb`.`t_instockbill`.`vehicleNo` AS `vehicleNo`,`wmsdb`.`t_instockbill`.`instockBillId` AS `instockBillId`,`wmsdb`.`t_instockbill`.`groundingGroup` AS `groundingGroup`,`wmsdb`.`t_supplier`.`status` AS `supplierStatus` from ((((`wmsdb`.`t_instockbill` join `wmsdb`.`t_supplier` on((`wmsdb`.`t_instockbill`.`supplierId` = `wmsdb`.`t_supplier`.`supplierId`))) join `wmsdb`.`t_dict` on((`wmsdb`.`t_instockbill`.`instockGroup` = `wmsdb`.`t_dict`.`dictId`))) join `wmsdb`.`t_dict` `t_dictactual` on((`wmsdb`.`t_instockbill`.`actualInstockGroup` = `t_dictactual`.`dictId`))) left join `wmsdb`.`t_dict` `t_dictground` on((`wmsdb`.`t_instockbill`.`groundingGroup` = `t_dictground`.`dictId`))) where (`wmsdb`.`t_dict`.`dictType` = 10)
