TYPE=VIEW
query=select `curia`.`cobros`.`IDEmpresa` AS `IDEmpresa`,`curia`.`cobros`.`Codigo` AS `Codigo`,`curia`.`cobros`.`SucRecibo` AS `SucRecibo`,`curia`.`cobros`.`Recibo` AS `Recibo`,`curia`.`cobros`.`Fecha` AS `Fecha`,`curia`.`cobros`.`IDCliente` AS `IDCliente`,`curia`.`cobros`.`TotalBruto` AS `TotalBruto`,`curia`.`cobros`.`Descuento` AS `Descuento`,`curia`.`cobros`.`TotalNeto` AS `TotalNeto`,`curia`.`cobros`.`TotalEfectivo` AS `TotalEfectivo`,`curia`.`cobros`.`Anulado` AS `Anulado`,`curia`.`cobros`.`Tipo` AS `Tipo`,`curia`.`cobros`.`Suc` AS `Suc`,`curia`.`cobros`.`Factura` AS `Factura`,`curia`.`cobros`.`FechaFactura` AS `FechaFactura`,`curia`.`cobros`.`DiasPromedioPago` AS `DiasPromedioPago`,`curia`.`cobros`.`IDUsuario` AS `IDUsuario`,`curia`.`cobros`.`Impreso` AS `Impreso`,`curia`.`cobros`.`PISuc` AS `PISuc`,`curia`.`cobros`.`PINro` AS `PINro`,`curia`.`cobros`.`CtaCte` AS `CtaCte`,`curia`.`cobros`.`Transmitido` AS `Transmitido`,(select `cli`.`Apellido_y_Nombre` AS `apellido_y_nombre` from `curia`.`clientes` `cli` where (`cli`.`IDCliente` = `curia`.`cobros`.`IDCliente`)) AS `RazonSocial`,if((`curia`.`cobros`.`DiasPromedioPago` <> 0),(`curia`.`cobros`.`TotalNeto` * `curia`.`cobros`.`DiasPromedioPago`),0) AS `Ponderado`,(select `usu`.`Nombre` AS `nombre` from `curia`.`usuarios` `usu` where (`usu`.`IDUsuario` = `curia`.`cobros`.`IDUsuario`)) AS `cobrador` from `curia`.`cobros`
md5=86ca37be9e141195240528940d507bd4
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=1
timestamp=2008-02-19 15:04:33
create-version=1
source=select `cobros`.`IDEmpresa` AS `IDEmpresa`,`cobros`.`Codigo` AS `Codigo`,`cobros`.`SucRecibo` AS `SucRecibo`,`cobros`.`Recibo` AS `Recibo`,`cobros`.`Fecha` AS `Fecha`,`cobros`.`IDCliente` AS `IDCliente`,`cobros`.`TotalBruto` AS `TotalBruto`,`cobros`.`Descuento` AS `Descuento`,`cobros`.`TotalNeto` AS `TotalNeto`,`cobros`.`TotalEfectivo` AS `TotalEfectivo`,`cobros`.`Anulado` AS `Anulado`,`cobros`.`Tipo` AS `Tipo`,`cobros`.`Suc` AS `Suc`,`cobros`.`Factura` AS `Factura`,`cobros`.`FechaFactura` AS `FechaFactura`,`cobros`.`DiasPromedioPago` AS `DiasPromedioPago`,`cobros`.`IDUsuario` AS `IDUsuario`,`cobros`.`Impreso` AS `Impreso`,`cobros`.`PISuc` AS `PISuc`,`cobros`.`PINro` AS `PINro`,`cobros`.`CtaCte` AS `CtaCte`,`cobros`.`Transmitido` AS `Transmitido`,(select `cli`.`Apellido_y_Nombre` AS `apellido_y_nombre`
\nfrom `clientes` `cli` where ((`cli`.`IDCliente` = `cobros`.`IDCliente`))) AS `RazonSocial`,if((`cobros`.`DiasPromedioPago` <> 0),(`cobros`.`TotalNeto` * `cobros`.`DiasPromedioPago`),0) AS `Ponderado`,(select `usu`.`Nombre` AS `nombre` from `usuarios` `usu` where ((`usu`.`IDUsuario` = `cobros`.`IDUsuario`))) AS `cobrador` from `cobros`
