TYPE=VIEW
query=select `wmsdb`.`t_cancelstockdemandbill`.`cancelstockDemandBillId` AS `cancelstockDemandBillId`,`wmsdb`.`t_cancelstockdemandbill`.`planCancelTime` AS `planCancelTime`,`wmsdb`.`t_cancelstockdemandbill`.`status` AS `status`,`wmsdb`.`t_cancelstockdemandbill`.`actualCancelTime` AS `actualCancelTime`,`wmsdb`.`t_cancelstockdemandbill`.`actualCancelstockGroup` AS `actualCancelstockGroup`,`wmsdb`.`t_cancelstockdemandbill`.`appointmentDate` AS `appointmentDate`,`wmsdb`.`t_cancelstockdemandbill`.`areaId` AS `areaId`,`wmsdb`.`t_cancelstockdemandbill`.`cancelCause` AS `cancelCause`,`wmsdb`.`t_cancelstockdemandbill`.`demandNo` AS `demandNo`,`wmsdb`.`t_cancelstockdemandbill`.`itemNo` AS `itemNo`,`wmsdb`.`t_cancelstockdemandbill`.`orderNo` AS `orderNo`,`wmsdb`.`t_cancelstockdemandbill`.`pickupCompany` AS `pickupCompany`,`wmsdb`.`t_cancelstockdemandbill`.`pickupPerson` AS `pickupPerson`,`wmsdb`.`t_cancelstockdemandbill`.`supplierId` AS `supplierId`,`wmsdb`.`t_cancelstockdemandbill`.`vehicleNo` AS `vehicleNo`,`wmsdb`.`t_warehousearea`.`areaName` AS `areaName`,`wmsdb`.`t_dict`.`dictName` AS `cancelCauseName`,`wmsdb`.`t_supplier`.`supplierName` AS `supplierName`,`wmsdb`.`t_dict`.`status` AS `causeStatus`,`wmsdb`.`t_supplier`.`status` AS `supplierStatus`,`wmsdb`.`t_cancelstockdemandbill`.`totalPrice` AS `totalPrice`,`wmsdb`.`t_cancelstockdemandbill`.`totalQuantity` AS `totalQuantity` from (((`wmsdb`.`t_cancelstockdemandbill` left join `wmsdb`.`t_warehousearea` on((`wmsdb`.`t_cancelstockdemandbill`.`areaId` = `wmsdb`.`t_warehousearea`.`areaId`))) left join `wmsdb`.`t_supplier` on((`wmsdb`.`t_cancelstockdemandbill`.`supplierId` = `wmsdb`.`t_supplier`.`supplierId`))) left join `wmsdb`.`t_dict` on((`wmsdb`.`t_cancelstockdemandbill`.`cancelCause` = `wmsdb`.`t_dict`.`dictId`))) where (`wmsdb`.`t_dict`.`dictType` = 5)
md5=24a506f75a2f83efe591618e3c31143d
updatable=0
algorithm=0
definer_user=root
definer_host=%
suid=1
with_check_option=0
timestamp=2016-01-12 06:00:59
create-version=1
source=select `t_cancelstockdemandbill`.`cancelstockDemandBillId` AS `cancelstockDemandBillId`,`t_cancelstockdemandbill`.`planCancelTime` AS `planCancelTime`,`t_cancelstockdemandbill`.`status` AS `status`,`t_cancelstockdemandbill`.`actualCancelTime` AS `actualCancelTime`,`t_cancelstockdemandbill`.`actualCancelstockGroup` AS `actualCancelstockGroup`,`t_cancelstockdemandbill`.`appointmentDate` AS `appointmentDate`,`t_cancelstockdemandbill`.`areaId` AS `areaId`,`t_cancelstockdemandbill`.`cancelCause` AS `cancelCause`,`t_cancelstockdemandbill`.`demandNo` AS `demandNo`,`t_cancelstockdemandbill`.`itemNo` AS `itemNo`,`t_cancelstockdemandbill`.`orderNo` AS `orderNo`,`t_cancelstockdemandbill`.`pickupCompany` AS `pickupCompany`,`t_cancelstockdemandbill`.`pickupPerson` AS `pickupPerson`,`t_cancelstockdemandbill`.`supplierId` AS `supplierId`,`t_cancelstockdemandbill`.`vehicleNo` AS `vehicleNo`,`t_warehousearea`.`areaName` AS `areaName`,`t_dict`.`dictName` AS `cancelCauseName`,`t_supplier`.`supplierName` AS `supplierName`,`t_dict`.`status` AS `causeStatus`,`t_supplier`.`status` AS `supplierStatus`,`t_cancelstockdemandbill`.`totalPrice` AS `totalPrice`,`t_cancelstockdemandbill`.`totalQuantity` AS `totalQuantity` from (((`t_cancelstockdemandbill` left join `t_warehousearea` on((`t_cancelstockdemandbill`.`areaId` = `t_warehousearea`.`areaId`))) left join `t_supplier` on((`t_cancelstockdemandbill`.`supplierId` = `t_supplier`.`supplierId`))) left join `t_dict` on((`t_cancelstockdemandbill`.`cancelCause` = `t_dict`.`dictId`))) where (`t_dict`.`dictType` = 5)
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `wmsdb`.`t_cancelstockdemandbill`.`cancelstockDemandBillId` AS `cancelstockDemandBillId`,`wmsdb`.`t_cancelstockdemandbill`.`planCancelTime` AS `planCancelTime`,`wmsdb`.`t_cancelstockdemandbill`.`status` AS `status`,`wmsdb`.`t_cancelstockdemandbill`.`actualCancelTime` AS `actualCancelTime`,`wmsdb`.`t_cancelstockdemandbill`.`actualCancelstockGroup` AS `actualCancelstockGroup`,`wmsdb`.`t_cancelstockdemandbill`.`appointmentDate` AS `appointmentDate`,`wmsdb`.`t_cancelstockdemandbill`.`areaId` AS `areaId`,`wmsdb`.`t_cancelstockdemandbill`.`cancelCause` AS `cancelCause`,`wmsdb`.`t_cancelstockdemandbill`.`demandNo` AS `demandNo`,`wmsdb`.`t_cancelstockdemandbill`.`itemNo` AS `itemNo`,`wmsdb`.`t_cancelstockdemandbill`.`orderNo` AS `orderNo`,`wmsdb`.`t_cancelstockdemandbill`.`pickupCompany` AS `pickupCompany`,`wmsdb`.`t_cancelstockdemandbill`.`pickupPerson` AS `pickupPerson`,`wmsdb`.`t_cancelstockdemandbill`.`supplierId` AS `supplierId`,`wmsdb`.`t_cancelstockdemandbill`.`vehicleNo` AS `vehicleNo`,`wmsdb`.`t_warehousearea`.`areaName` AS `areaName`,`wmsdb`.`t_dict`.`dictName` AS `cancelCauseName`,`wmsdb`.`t_supplier`.`supplierName` AS `supplierName`,`wmsdb`.`t_dict`.`status` AS `causeStatus`,`wmsdb`.`t_supplier`.`status` AS `supplierStatus`,`wmsdb`.`t_cancelstockdemandbill`.`totalPrice` AS `totalPrice`,`wmsdb`.`t_cancelstockdemandbill`.`totalQuantity` AS `totalQuantity` from (((`wmsdb`.`t_cancelstockdemandbill` left join `wmsdb`.`t_warehousearea` on((`wmsdb`.`t_cancelstockdemandbill`.`areaId` = `wmsdb`.`t_warehousearea`.`areaId`))) left join `wmsdb`.`t_supplier` on((`wmsdb`.`t_cancelstockdemandbill`.`supplierId` = `wmsdb`.`t_supplier`.`supplierId`))) left join `wmsdb`.`t_dict` on((`wmsdb`.`t_cancelstockdemandbill`.`cancelCause` = `wmsdb`.`t_dict`.`dictId`))) where (`wmsdb`.`t_dict`.`dictType` = 5)
