TYPE=VIEW
query=select `wmsdb`.`t_openingendinginventory`.`locationId` AS `locationId`,`wmsdb`.`t_openingendinginventory`.`supplierId` AS `supplierId`,`wmsdb`.`t_openingendinginventory`.`goodsId` AS `goodsId`,`wmsdb`.`t_openingendinginventory`.`beginQuantity` AS `beginQuantity`,`wmsdb`.`t_openingendinginventory`.`beginTotalPrice` AS `beginTotalPrice`,`wmsdb`.`t_openingendinginventory`.`beginVolume` AS `beginVolume`,`wmsdb`.`t_openingendinginventory`.`beginWeight` AS `beginWeight`,`wmsdb`.`t_openingendinginventory`.`inQuantity` AS `inQuantity`,`wmsdb`.`t_openingendinginventory`.`inTotalPrice` AS `inTotalPrice`,`wmsdb`.`t_openingendinginventory`.`inVolume` AS `inVolume`,`wmsdb`.`t_openingendinginventory`.`inWeight` AS `inWeight`,`wmsdb`.`t_openingendinginventory`.`outQuantity` AS `outQuantity`,`wmsdb`.`t_openingendinginventory`.`outTotalPrice` AS `outTotalPrice`,`wmsdb`.`t_openingendinginventory`.`outVolume` AS `outVolume`,`wmsdb`.`t_openingendinginventory`.`outWeight` AS `outWeight`,`wmsdb`.`t_openingendinginventory`.`endQuantity` AS `endQuantity`,`wmsdb`.`t_openingendinginventory`.`endTotalPrice` AS `endTotalPrice`,`wmsdb`.`t_openingendinginventory`.`endVolume` AS `endVolume`,`wmsdb`.`t_openingendinginventory`.`endWeight` AS `endWeight`,`wmsdb`.`t_goods`.`goodsCode` AS `goodsCode`,`wmsdb`.`t_goods`.`goodsName` AS `goodsName`,`wmsdb`.`t_goods`.`price` AS `price`,`wmsdb`.`t_goods`.`outerPackingVolume` AS `outerPackingVolume`,`wmsdb`.`t_goods`.`outerPackingWeight` AS `outerPackingWeight`,`v_warehouselocationinfo`.`locationNo` AS `locationNo`,`v_warehouselocationinfo`.`areaId` AS `areaId`,`v_warehouselocationinfo`.`areaName` AS `areaName`,`v_warehouselocationinfo`.`natureName` AS `natureName`,`v_warehouselocationinfo`.`natureId` AS `natureId`,`v_warehouselocationinfo`.`areaCode` AS `areaCode`,`wmsdb`.`t_supplier`.`supplierName` AS `supplierName`,`wmsdb`.`t_openingendinginventory`.`reportTime` AS `reportTime`,`wmsdb`.`t_supplier`.`supplierCode` AS `supplierCode` from (((`wmsdb`.`t_openingendinginventory` join `wmsdb`.`t_goods` on((`wmsdb`.`t_goods`.`goodsId` = `wmsdb`.`t_openingendinginventory`.`goodsId`))) join `wmsdb`.`v_warehouselocationinfo` on((`v_warehouselocationinfo`.`locationId` = `wmsdb`.`t_openingendinginventory`.`locationId`))) join `wmsdb`.`t_supplier` on((`wmsdb`.`t_supplier`.`supplierId` = `wmsdb`.`t_openingendinginventory`.`supplierId`)))
md5=84bfc4d0ca728170eced81c28182cc81
updatable=1
algorithm=0
definer_user=root
definer_host=%
suid=1
with_check_option=0
timestamp=2016-01-12 06:02:38
create-version=1
source=select `t_openingendinginventory`.`locationId` AS `locationId`,`t_openingendinginventory`.`supplierId` AS `supplierId`,`t_openingendinginventory`.`goodsId` AS `goodsId`,`t_openingendinginventory`.`beginQuantity` AS `beginQuantity`,`t_openingendinginventory`.`beginTotalPrice` AS `beginTotalPrice`,`t_openingendinginventory`.`beginVolume` AS `beginVolume`,`t_openingendinginventory`.`beginWeight` AS `beginWeight`,`t_openingendinginventory`.`inQuantity` AS `inQuantity`,`t_openingendinginventory`.`inTotalPrice` AS `inTotalPrice`,`t_openingendinginventory`.`inVolume` AS `inVolume`,`t_openingendinginventory`.`inWeight` AS `inWeight`,`t_openingendinginventory`.`outQuantity` AS `outQuantity`,`t_openingendinginventory`.`outTotalPrice` AS `outTotalPrice`,`t_openingendinginventory`.`outVolume` AS `outVolume`,`t_openingendinginventory`.`outWeight` AS `outWeight`,`t_openingendinginventory`.`endQuantity` AS `endQuantity`,`t_openingendinginventory`.`endTotalPrice` AS `endTotalPrice`,`t_openingendinginventory`.`endVolume` AS `endVolume`,`t_openingendinginventory`.`endWeight` AS `endWeight`,`t_goods`.`goodsCode` AS `goodsCode`,`t_goods`.`goodsName` AS `goodsName`,`t_goods`.`price` AS `price`,`t_goods`.`outerPackingVolume` AS `outerPackingVolume`,`t_goods`.`outerPackingWeight` AS `outerPackingWeight`,`v_warehouselocationinfo`.`locationNo` AS `locationNo`,`v_warehouselocationinfo`.`areaId` AS `areaId`,`v_warehouselocationinfo`.`areaName` AS `areaName`,`v_warehouselocationinfo`.`natureName` AS `natureName`,`v_warehouselocationinfo`.`natureId` AS `natureId`,`v_warehouselocationinfo`.`areaCode` AS `areaCode`,`t_supplier`.`supplierName` AS `supplierName`,`t_openingendinginventory`.`reportTime` AS `reportTime`,`t_supplier`.`supplierCode` AS `supplierCode` from (((`t_openingendinginventory` join `t_goods` on((`t_goods`.`goodsId` = `t_openingendinginventory`.`goodsId`))) join `v_warehouselocationinfo` on((`v_warehouselocationinfo`.`locationId` = `t_openingendinginventory`.`locationId`))) join `t_supplier` on((`t_supplier`.`supplierId` = `t_openingendinginventory`.`supplierId`)))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `wmsdb`.`t_openingendinginventory`.`locationId` AS `locationId`,`wmsdb`.`t_openingendinginventory`.`supplierId` AS `supplierId`,`wmsdb`.`t_openingendinginventory`.`goodsId` AS `goodsId`,`wmsdb`.`t_openingendinginventory`.`beginQuantity` AS `beginQuantity`,`wmsdb`.`t_openingendinginventory`.`beginTotalPrice` AS `beginTotalPrice`,`wmsdb`.`t_openingendinginventory`.`beginVolume` AS `beginVolume`,`wmsdb`.`t_openingendinginventory`.`beginWeight` AS `beginWeight`,`wmsdb`.`t_openingendinginventory`.`inQuantity` AS `inQuantity`,`wmsdb`.`t_openingendinginventory`.`inTotalPrice` AS `inTotalPrice`,`wmsdb`.`t_openingendinginventory`.`inVolume` AS `inVolume`,`wmsdb`.`t_openingendinginventory`.`inWeight` AS `inWeight`,`wmsdb`.`t_openingendinginventory`.`outQuantity` AS `outQuantity`,`wmsdb`.`t_openingendinginventory`.`outTotalPrice` AS `outTotalPrice`,`wmsdb`.`t_openingendinginventory`.`outVolume` AS `outVolume`,`wmsdb`.`t_openingendinginventory`.`outWeight` AS `outWeight`,`wmsdb`.`t_openingendinginventory`.`endQuantity` AS `endQuantity`,`wmsdb`.`t_openingendinginventory`.`endTotalPrice` AS `endTotalPrice`,`wmsdb`.`t_openingendinginventory`.`endVolume` AS `endVolume`,`wmsdb`.`t_openingendinginventory`.`endWeight` AS `endWeight`,`wmsdb`.`t_goods`.`goodsCode` AS `goodsCode`,`wmsdb`.`t_goods`.`goodsName` AS `goodsName`,`wmsdb`.`t_goods`.`price` AS `price`,`wmsdb`.`t_goods`.`outerPackingVolume` AS `outerPackingVolume`,`wmsdb`.`t_goods`.`outerPackingWeight` AS `outerPackingWeight`,`v_warehouselocationinfo`.`locationNo` AS `locationNo`,`v_warehouselocationinfo`.`areaId` AS `areaId`,`v_warehouselocationinfo`.`areaName` AS `areaName`,`v_warehouselocationinfo`.`natureName` AS `natureName`,`v_warehouselocationinfo`.`natureId` AS `natureId`,`v_warehouselocationinfo`.`areaCode` AS `areaCode`,`wmsdb`.`t_supplier`.`supplierName` AS `supplierName`,`wmsdb`.`t_openingendinginventory`.`reportTime` AS `reportTime`,`wmsdb`.`t_supplier`.`supplierCode` AS `supplierCode` from (((`wmsdb`.`t_openingendinginventory` join `wmsdb`.`t_goods` on((`wmsdb`.`t_goods`.`goodsId` = `wmsdb`.`t_openingendinginventory`.`goodsId`))) join `wmsdb`.`v_warehouselocationinfo` on((`v_warehouselocationinfo`.`locationId` = `wmsdb`.`t_openingendinginventory`.`locationId`))) join `wmsdb`.`t_supplier` on((`wmsdb`.`t_supplier`.`supplierId` = `wmsdb`.`t_openingendinginventory`.`supplierId`)))
