TYPE=VIEW
query=select `wmsdb`.`t_instockdemandbill`.`instockDemandBillId` AS `instockDemandBillId`,`wmsdb`.`t_instockdemandbill`.`appointmentDate` AS `appointmentDate`,`wmsdb`.`t_instockdemandbill`.`deliveryCompany` AS `deliveryCompany`,`wmsdb`.`t_instockdemandbill`.`deliveryman` AS `deliveryman`,`wmsdb`.`t_instockdemandbill`.`demandNo` AS `demandNo`,`wmsdb`.`t_instockdemandbill`.`instockGroup` AS `instockGroup`,`wmsdb`.`t_instockdemandbill`.`orderNo` AS `orderNo`,`wmsdb`.`t_instockdemandbill`.`planArrivalTime` AS `planArrivalTime`,`wmsdb`.`t_instockdemandbill`.`status` AS `status`,`wmsdb`.`t_instockdemandbill`.`supplierId` AS `supplierId`,`wmsdb`.`t_instockdemandbill`.`vehicleNo` AS `vehicleNo`,`wmsdb`.`t_supplier`.`supplierName` AS `supplierName`,`wmsdb`.`t_instockdemandbill`.`instockNature` AS `instockNature`,`wmsdb`.`t_dict`.`dictName` AS `instockGroupName`,`wmsdb`.`t_instockdemandbill`.`itemNo` AS `itemNo`,`t_dictactual`.`dictName` AS `actualInstockGroupName`,`wmsdb`.`t_instockdemandbill`.`actualInstockGroup` AS `actualInstockGroup`,`wmsdb`.`t_instockdemandbill`.`actualArrivalTime` AS `actualArrivalTime`,`t_dictnature`.`dictName` AS `instockNatureName`,`wmsdb`.`t_supplier`.`status` AS `supplierStatus`,`wmsdb`.`t_instockdemandbill`.`totalQuantity` AS `totalQuantity`,`wmsdb`.`t_instockdemandbill`.`totalPrice` AS `totalPrice` from ((((`wmsdb`.`t_instockdemandbill` left join `wmsdb`.`t_supplier` on((`wmsdb`.`t_instockdemandbill`.`supplierId` = `wmsdb`.`t_supplier`.`supplierId`))) left join `wmsdb`.`t_dict` on((`wmsdb`.`t_instockdemandbill`.`instockGroup` = `wmsdb`.`t_dict`.`dictId`))) left join `wmsdb`.`t_dict` `t_dictactual` on((`wmsdb`.`t_instockdemandbill`.`actualInstockGroup` = `t_dictactual`.`dictId`))) left join `wmsdb`.`t_dict` `t_dictnature` on((`wmsdb`.`t_instockdemandbill`.`instockNature` = `t_dictnature`.`dictId`))) where ((`wmsdb`.`t_dict`.`dictType` = 10) or (`t_dictnature`.`dictType` = 3))
md5=fe1e31538c57c686fb083d425dea982b
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_instockdemandbill`.`instockDemandBillId` AS `instockDemandBillId`,`t_instockdemandbill`.`appointmentDate` AS `appointmentDate`,`t_instockdemandbill`.`deliveryCompany` AS `deliveryCompany`,`t_instockdemandbill`.`deliveryman` AS `deliveryman`,`t_instockdemandbill`.`demandNo` AS `demandNo`,`t_instockdemandbill`.`instockGroup` AS `instockGroup`,`t_instockdemandbill`.`orderNo` AS `orderNo`,`t_instockdemandbill`.`planArrivalTime` AS `planArrivalTime`,`t_instockdemandbill`.`status` AS `status`,`t_instockdemandbill`.`supplierId` AS `supplierId`,`t_instockdemandbill`.`vehicleNo` AS `vehicleNo`,`t_supplier`.`supplierName` AS `supplierName`,`t_instockdemandbill`.`instockNature` AS `instockNature`,`t_dict`.`dictName` AS `instockGroupName`,`t_instockdemandbill`.`itemNo` AS `itemNo`,`t_dictactual`.`dictName` AS `actualInstockGroupName`,`t_instockdemandbill`.`actualInstockGroup` AS `actualInstockGroup`,`t_instockdemandbill`.`actualArrivalTime` AS `actualArrivalTime`,`t_dictnature`.`dictName` AS `instockNatureName`,`t_supplier`.`status` AS `supplierStatus`,`t_instockdemandbill`.`totalQuantity` AS `totalQuantity`,`t_instockdemandbill`.`totalPrice` AS `totalPrice` from ((((`t_instockdemandbill` left join `t_supplier` on((`t_instockdemandbill`.`supplierId` = `t_supplier`.`supplierId`))) left join `t_dict` on((`t_instockdemandbill`.`instockGroup` = `t_dict`.`dictId`))) left join `t_dict` `t_dictactual` on((`t_instockdemandbill`.`actualInstockGroup` = `t_dictactual`.`dictId`))) left join `t_dict` `t_dictnature` on((`t_instockdemandbill`.`instockNature` = `t_dictnature`.`dictId`))) where ((`t_dict`.`dictType` = 10) or (`t_dictnature`.`dictType` = 3))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `wmsdb`.`t_instockdemandbill`.`instockDemandBillId` AS `instockDemandBillId`,`wmsdb`.`t_instockdemandbill`.`appointmentDate` AS `appointmentDate`,`wmsdb`.`t_instockdemandbill`.`deliveryCompany` AS `deliveryCompany`,`wmsdb`.`t_instockdemandbill`.`deliveryman` AS `deliveryman`,`wmsdb`.`t_instockdemandbill`.`demandNo` AS `demandNo`,`wmsdb`.`t_instockdemandbill`.`instockGroup` AS `instockGroup`,`wmsdb`.`t_instockdemandbill`.`orderNo` AS `orderNo`,`wmsdb`.`t_instockdemandbill`.`planArrivalTime` AS `planArrivalTime`,`wmsdb`.`t_instockdemandbill`.`status` AS `status`,`wmsdb`.`t_instockdemandbill`.`supplierId` AS `supplierId`,`wmsdb`.`t_instockdemandbill`.`vehicleNo` AS `vehicleNo`,`wmsdb`.`t_supplier`.`supplierName` AS `supplierName`,`wmsdb`.`t_instockdemandbill`.`instockNature` AS `instockNature`,`wmsdb`.`t_dict`.`dictName` AS `instockGroupName`,`wmsdb`.`t_instockdemandbill`.`itemNo` AS `itemNo`,`t_dictactual`.`dictName` AS `actualInstockGroupName`,`wmsdb`.`t_instockdemandbill`.`actualInstockGroup` AS `actualInstockGroup`,`wmsdb`.`t_instockdemandbill`.`actualArrivalTime` AS `actualArrivalTime`,`t_dictnature`.`dictName` AS `instockNatureName`,`wmsdb`.`t_supplier`.`status` AS `supplierStatus`,`wmsdb`.`t_instockdemandbill`.`totalQuantity` AS `totalQuantity`,`wmsdb`.`t_instockdemandbill`.`totalPrice` AS `totalPrice` from ((((`wmsdb`.`t_instockdemandbill` left join `wmsdb`.`t_supplier` on((`wmsdb`.`t_instockdemandbill`.`supplierId` = `wmsdb`.`t_supplier`.`supplierId`))) left join `wmsdb`.`t_dict` on((`wmsdb`.`t_instockdemandbill`.`instockGroup` = `wmsdb`.`t_dict`.`dictId`))) left join `wmsdb`.`t_dict` `t_dictactual` on((`wmsdb`.`t_instockdemandbill`.`actualInstockGroup` = `t_dictactual`.`dictId`))) left join `wmsdb`.`t_dict` `t_dictnature` on((`wmsdb`.`t_instockdemandbill`.`instockNature` = `t_dictnature`.`dictId`))) where ((`wmsdb`.`t_dict`.`dictType` = 10) or (`t_dictnature`.`dictType` = 3))
