TYPE=VIEW
query=select `wmsdb`.`t_transferstockdemandbill`.`appointmentDate` AS `appointmentDate`,`wmsdb`.`t_transferstockdemandbill`.`transferstockDemandBillId` AS `transferstockDemandBillId`,`wmsdb`.`t_transferstockdemandbill`.`demandNo` AS `demandNo`,`wmsdb`.`t_transferstockdemandbill`.`planTransferTime` AS `planTransferTime`,`wmsdb`.`t_transferstockdemandbill`.`pickupCompany` AS `pickupCompany`,`wmsdb`.`t_transferstockdemandbill`.`vehicleNo` AS `vehicleNo`,`wmsdb`.`t_transferstockdemandbill`.`pickupPerson` AS `pickupPerson`,`wmsdb`.`t_warehousearea`.`areaCode` AS `inAreaCode`,`wmsdb`.`t_warehousearea`.`areaNature` AS `inAreaNature`,`t_warehouseareaout`.`areaCode` AS `outAreaCode`,`t_warehouseareaout`.`areaNature` AS `outAreaNature`,`wmsdb`.`t_warehouselocation`.`locationNo` AS `inLocationNo`,`t_warehouselocationout`.`locationNo` AS `outLocationNo`,`t_locationnatureout`.`natureName` AS `outLocationNature`,`wmsdb`.`t_locationnature`.`natureName` AS `inLocationNature`,`wmsdb`.`t_dict`.`dictName` AS `transferCauseName`,`wmsdb`.`t_transferstockdemandbill`.`status` AS `status`,`wmsdb`.`t_transferstockdemandbill`.`inAreaId` AS `inAreaId`,`wmsdb`.`t_transferstockdemandbill`.`inLocationId` AS `inLocationId`,`wmsdb`.`t_transferstockdemandbill`.`outAreaId` AS `outAreaId`,`wmsdb`.`t_transferstockdemandbill`.`outLocationId` AS `outLocationId`,`wmsdb`.`t_transferstockdemandbill`.`transferCause` AS `transferCause`,`wmsdb`.`t_transferstockdemandbill`.`actualTransferstockGroup` AS `actualTransferstockGroup`,`wmsdb`.`t_transferstockdemandbill`.`actualTransferTime` AS `actualTransferTime`,`wmsdb`.`t_dict`.`status` AS `causeStatus`,`wmsdb`.`t_warehousearea`.`status` AS `inAreaStatus`,`t_warehouseareaout`.`status` AS `outAreaStatus`,`t_warehouseareaout`.`areaName` AS `warehouseareaoutName`,`wmsdb`.`t_warehousearea`.`areaName` AS `warehouseareaName`,`wmsdb`.`t_transferstockdemandbill`.`totalPrice` AS `totalPrice`,`wmsdb`.`t_transferstockdemandbill`.`totalQuantity` AS `totalQuantity` from (((((((`wmsdb`.`t_transferstockdemandbill` join `wmsdb`.`t_warehousearea` on((`wmsdb`.`t_transferstockdemandbill`.`inAreaId` = `wmsdb`.`t_warehousearea`.`areaId`))) join `wmsdb`.`t_warehousearea` `t_warehouseareaout` on((`wmsdb`.`t_transferstockdemandbill`.`outAreaId` = `t_warehouseareaout`.`areaId`))) join `wmsdb`.`t_warehouselocation` on((`wmsdb`.`t_transferstockdemandbill`.`inLocationId` = `wmsdb`.`t_warehouselocation`.`locationId`))) join `wmsdb`.`t_warehouselocation` `t_warehouselocationout` on((`wmsdb`.`t_transferstockdemandbill`.`outLocationId` = `t_warehouselocationout`.`locationId`))) join `wmsdb`.`t_locationnature` on((`wmsdb`.`t_warehouselocation`.`natureId` = `wmsdb`.`t_locationnature`.`natureId`))) join `wmsdb`.`t_locationnature` `t_locationnatureout` on((`t_warehouselocationout`.`natureId` = `t_locationnatureout`.`natureId`))) join `wmsdb`.`t_dict` on((`wmsdb`.`t_transferstockdemandbill`.`transferCause` = `wmsdb`.`t_dict`.`dictId`))) where (`wmsdb`.`t_dict`.`dictType` = 6)
md5=6540158a9910123b79e2329dcb9b1167
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_transferstockdemandbill`.`appointmentDate` AS `appointmentDate`,`t_transferstockdemandbill`.`transferstockDemandBillId` AS `transferstockDemandBillId`,`t_transferstockdemandbill`.`demandNo` AS `demandNo`,`t_transferstockdemandbill`.`planTransferTime` AS `planTransferTime`,`t_transferstockdemandbill`.`pickupCompany` AS `pickupCompany`,`t_transferstockdemandbill`.`vehicleNo` AS `vehicleNo`,`t_transferstockdemandbill`.`pickupPerson` AS `pickupPerson`,`t_warehousearea`.`areaCode` AS `inAreaCode`,`t_warehousearea`.`areaNature` AS `inAreaNature`,`t_warehouseareaout`.`areaCode` AS `outAreaCode`,`t_warehouseareaout`.`areaNature` AS `outAreaNature`,`t_warehouselocation`.`locationNo` AS `inLocationNo`,`t_warehouselocationout`.`locationNo` AS `outLocationNo`,`t_locationnatureout`.`natureName` AS `outLocationNature`,`t_locationnature`.`natureName` AS `inLocationNature`,`t_dict`.`dictName` AS `transferCauseName`,`t_transferstockdemandbill`.`status` AS `status`,`t_transferstockdemandbill`.`inAreaId` AS `inAreaId`,`t_transferstockdemandbill`.`inLocationId` AS `inLocationId`,`t_transferstockdemandbill`.`outAreaId` AS `outAreaId`,`t_transferstockdemandbill`.`outLocationId` AS `outLocationId`,`t_transferstockdemandbill`.`transferCause` AS `transferCause`,`t_transferstockdemandbill`.`actualTransferstockGroup` AS `actualTransferstockGroup`,`t_transferstockdemandbill`.`actualTransferTime` AS `actualTransferTime`,`t_dict`.`status` AS `causeStatus`,`t_warehousearea`.`status` AS `inAreaStatus`,`t_warehouseareaout`.`status` AS `outAreaStatus`,`t_warehouseareaout`.`areaName` AS `warehouseareaoutName`,`t_warehousearea`.`areaName` AS `warehouseareaName`,`t_transferstockdemandbill`.`totalPrice` AS `totalPrice`,`t_transferstockdemandbill`.`totalQuantity` AS `totalQuantity` from (((((((`t_transferstockdemandbill` join `t_warehousearea` on((`t_transferstockdemandbill`.`inAreaId` = `t_warehousearea`.`areaId`))) join `t_warehousearea` `t_warehouseareaout` on((`t_transferstockdemandbill`.`outAreaId` = `t_warehouseareaout`.`areaId`))) join `t_warehouselocation` on((`t_transferstockdemandbill`.`inLocationId` = `t_warehouselocation`.`locationId`))) join `t_warehouselocation` `t_warehouselocationout` on((`t_transferstockdemandbill`.`outLocationId` = `t_warehouselocationout`.`locationId`))) join `t_locationnature` on((`t_warehouselocation`.`natureId` = `t_locationnature`.`natureId`))) join `t_locationnature` `t_locationnatureout` on((`t_warehouselocationout`.`natureId` = `t_locationnatureout`.`natureId`))) join `t_dict` on((`t_transferstockdemandbill`.`transferCause` = `t_dict`.`dictId`))) where (`t_dict`.`dictType` = 6)
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `wmsdb`.`t_transferstockdemandbill`.`appointmentDate` AS `appointmentDate`,`wmsdb`.`t_transferstockdemandbill`.`transferstockDemandBillId` AS `transferstockDemandBillId`,`wmsdb`.`t_transferstockdemandbill`.`demandNo` AS `demandNo`,`wmsdb`.`t_transferstockdemandbill`.`planTransferTime` AS `planTransferTime`,`wmsdb`.`t_transferstockdemandbill`.`pickupCompany` AS `pickupCompany`,`wmsdb`.`t_transferstockdemandbill`.`vehicleNo` AS `vehicleNo`,`wmsdb`.`t_transferstockdemandbill`.`pickupPerson` AS `pickupPerson`,`wmsdb`.`t_warehousearea`.`areaCode` AS `inAreaCode`,`wmsdb`.`t_warehousearea`.`areaNature` AS `inAreaNature`,`t_warehouseareaout`.`areaCode` AS `outAreaCode`,`t_warehouseareaout`.`areaNature` AS `outAreaNature`,`wmsdb`.`t_warehouselocation`.`locationNo` AS `inLocationNo`,`t_warehouselocationout`.`locationNo` AS `outLocationNo`,`t_locationnatureout`.`natureName` AS `outLocationNature`,`wmsdb`.`t_locationnature`.`natureName` AS `inLocationNature`,`wmsdb`.`t_dict`.`dictName` AS `transferCauseName`,`wmsdb`.`t_transferstockdemandbill`.`status` AS `status`,`wmsdb`.`t_transferstockdemandbill`.`inAreaId` AS `inAreaId`,`wmsdb`.`t_transferstockdemandbill`.`inLocationId` AS `inLocationId`,`wmsdb`.`t_transferstockdemandbill`.`outAreaId` AS `outAreaId`,`wmsdb`.`t_transferstockdemandbill`.`outLocationId` AS `outLocationId`,`wmsdb`.`t_transferstockdemandbill`.`transferCause` AS `transferCause`,`wmsdb`.`t_transferstockdemandbill`.`actualTransferstockGroup` AS `actualTransferstockGroup`,`wmsdb`.`t_transferstockdemandbill`.`actualTransferTime` AS `actualTransferTime`,`wmsdb`.`t_dict`.`status` AS `causeStatus`,`wmsdb`.`t_warehousearea`.`status` AS `inAreaStatus`,`t_warehouseareaout`.`status` AS `outAreaStatus`,`t_warehouseareaout`.`areaName` AS `warehouseareaoutName`,`wmsdb`.`t_warehousearea`.`areaName` AS `warehouseareaName`,`wmsdb`.`t_transferstockdemandbill`.`totalPrice` AS `totalPrice`,`wmsdb`.`t_transferstockdemandbill`.`totalQuantity` AS `totalQuantity` from (((((((`wmsdb`.`t_transferstockdemandbill` join `wmsdb`.`t_warehousearea` on((`wmsdb`.`t_transferstockdemandbill`.`inAreaId` = `wmsdb`.`t_warehousearea`.`areaId`))) join `wmsdb`.`t_warehousearea` `t_warehouseareaout` on((`wmsdb`.`t_transferstockdemandbill`.`outAreaId` = `t_warehouseareaout`.`areaId`))) join `wmsdb`.`t_warehouselocation` on((`wmsdb`.`t_transferstockdemandbill`.`inLocationId` = `wmsdb`.`t_warehouselocation`.`locationId`))) join `wmsdb`.`t_warehouselocation` `t_warehouselocationout` on((`wmsdb`.`t_transferstockdemandbill`.`outLocationId` = `t_warehouselocationout`.`locationId`))) join `wmsdb`.`t_locationnature` on((`wmsdb`.`t_warehouselocation`.`natureId` = `wmsdb`.`t_locationnature`.`natureId`))) join `wmsdb`.`t_locationnature` `t_locationnatureout` on((`t_warehouselocationout`.`natureId` = `t_locationnatureout`.`natureId`))) join `wmsdb`.`t_dict` on((`wmsdb`.`t_transferstockdemandbill`.`transferCause` = `wmsdb`.`t_dict`.`dictId`))) where (`wmsdb`.`t_dict`.`dictType` = 6)
