TYPE=VIEW
query=select `wmsdb`.`t_outstockbill`.`outstockBillId` AS `outstockBillId`,`wmsdb`.`t_outstockbill`.`actualOutstockGroup` AS `actualOutstockGroup`,`wmsdb`.`t_outstockbill`.`appointmentDate` AS `appointmentDate`,`wmsdb`.`t_outstockbill`.`demandNo` AS `demandNo`,`wmsdb`.`t_outstockbill`.`demanderId` AS `demanderId`,`wmsdb`.`t_outstockbill`.`itemNo` AS `itemNo`,`wmsdb`.`t_outstockbill`.`orderNo` AS `orderNo`,`wmsdb`.`t_outstockbill`.`outstockDemandBillId` AS `outstockDemandBillId`,`wmsdb`.`t_outstockbill`.`outstockGroup` AS `outstockGroup`,`wmsdb`.`t_outstockbill`.`outstockNature` AS `outstockNature`,`wmsdb`.`t_outstockbill`.`pickupCompany` AS `pickupCompany`,`wmsdb`.`t_outstockbill`.`pickupPerson` AS `pickupPerson`,`wmsdb`.`t_outstockbill`.`planArrivalTime` AS `planArrivalTime`,`wmsdb`.`t_outstockbill`.`status` AS `status`,`wmsdb`.`t_outstockbill`.`vehicleNo` AS `vehicleNo`,`wmsdb`.`t_demander`.`demanderName` AS `demanderName`,`wmsdb`.`t_dict`.`dictName` AS `outstockNatureName`,`t_dictgroup`.`dictName` AS `outstockGroupName`,`wmsdb`.`t_demander`.`status` AS `demanderStatus` from (((`wmsdb`.`t_outstockbill` left join `wmsdb`.`t_demander` on((`wmsdb`.`t_outstockbill`.`demanderId` = `wmsdb`.`t_demander`.`demanderId`))) left join `wmsdb`.`t_dict` on((`wmsdb`.`t_outstockbill`.`outstockNature` = `wmsdb`.`t_dict`.`dictId`))) left join `wmsdb`.`t_dict` `t_dictgroup` on((`wmsdb`.`t_outstockbill`.`outstockGroup` = `t_dictgroup`.`dictId`))) where ((`wmsdb`.`t_dict`.`dictType` = 4) or (`t_dictgroup`.`dictType` = 10))
md5=c12ef88e1d607857b3ab8b5edc9eb520
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_outstockbill`.`outstockBillId` AS `outstockBillId`,`t_outstockbill`.`actualOutstockGroup` AS `actualOutstockGroup`,`t_outstockbill`.`appointmentDate` AS `appointmentDate`,`t_outstockbill`.`demandNo` AS `demandNo`,`t_outstockbill`.`demanderId` AS `demanderId`,`t_outstockbill`.`itemNo` AS `itemNo`,`t_outstockbill`.`orderNo` AS `orderNo`,`t_outstockbill`.`outstockDemandBillId` AS `outstockDemandBillId`,`t_outstockbill`.`outstockGroup` AS `outstockGroup`,`t_outstockbill`.`outstockNature` AS `outstockNature`,`t_outstockbill`.`pickupCompany` AS `pickupCompany`,`t_outstockbill`.`pickupPerson` AS `pickupPerson`,`t_outstockbill`.`planArrivalTime` AS `planArrivalTime`,`t_outstockbill`.`status` AS `status`,`t_outstockbill`.`vehicleNo` AS `vehicleNo`,`t_demander`.`demanderName` AS `demanderName`,`t_dict`.`dictName` AS `outstockNatureName`,`t_dictgroup`.`dictName` AS `outstockGroupName`,`t_demander`.`status` AS `demanderStatus` from (((`t_outstockbill` left join `t_demander` on((`t_outstockbill`.`demanderId` = `t_demander`.`demanderId`))) left join `t_dict` on((`t_outstockbill`.`outstockNature` = `t_dict`.`dictId`))) left join `t_dict` `t_dictgroup` on((`t_outstockbill`.`outstockGroup` = `t_dictgroup`.`dictId`))) where ((`t_dict`.`dictType` = 4) or (`t_dictgroup`.`dictType` = 10))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `wmsdb`.`t_outstockbill`.`outstockBillId` AS `outstockBillId`,`wmsdb`.`t_outstockbill`.`actualOutstockGroup` AS `actualOutstockGroup`,`wmsdb`.`t_outstockbill`.`appointmentDate` AS `appointmentDate`,`wmsdb`.`t_outstockbill`.`demandNo` AS `demandNo`,`wmsdb`.`t_outstockbill`.`demanderId` AS `demanderId`,`wmsdb`.`t_outstockbill`.`itemNo` AS `itemNo`,`wmsdb`.`t_outstockbill`.`orderNo` AS `orderNo`,`wmsdb`.`t_outstockbill`.`outstockDemandBillId` AS `outstockDemandBillId`,`wmsdb`.`t_outstockbill`.`outstockGroup` AS `outstockGroup`,`wmsdb`.`t_outstockbill`.`outstockNature` AS `outstockNature`,`wmsdb`.`t_outstockbill`.`pickupCompany` AS `pickupCompany`,`wmsdb`.`t_outstockbill`.`pickupPerson` AS `pickupPerson`,`wmsdb`.`t_outstockbill`.`planArrivalTime` AS `planArrivalTime`,`wmsdb`.`t_outstockbill`.`status` AS `status`,`wmsdb`.`t_outstockbill`.`vehicleNo` AS `vehicleNo`,`wmsdb`.`t_demander`.`demanderName` AS `demanderName`,`wmsdb`.`t_dict`.`dictName` AS `outstockNatureName`,`t_dictgroup`.`dictName` AS `outstockGroupName`,`wmsdb`.`t_demander`.`status` AS `demanderStatus` from (((`wmsdb`.`t_outstockbill` left join `wmsdb`.`t_demander` on((`wmsdb`.`t_outstockbill`.`demanderId` = `wmsdb`.`t_demander`.`demanderId`))) left join `wmsdb`.`t_dict` on((`wmsdb`.`t_outstockbill`.`outstockNature` = `wmsdb`.`t_dict`.`dictId`))) left join `wmsdb`.`t_dict` `t_dictgroup` on((`wmsdb`.`t_outstockbill`.`outstockGroup` = `t_dictgroup`.`dictId`))) where ((`wmsdb`.`t_dict`.`dictType` = 4) or (`t_dictgroup`.`dictType` = 10))
