TYPE=VIEW
query=select `p`.`IDEmpresa` AS `IDEmpresa`,`p`.`IDProveedor` AS `IDProveedor`,`p`.`Tipo_de_Proveedor` AS `Tipo_de_Proveedor`,`p`.`Apellido_y_Nombre` AS `Apellido_y_Nombre`,`p`.`Calle` AS `Calle`,`p`.`Numero` AS `Numero`,`p`.`Piso` AS `Piso`,`p`.`Oficina` AS `Oficina`,`p`.`Localidad` AS `Localidad`,`p`.`Codigo_Postal` AS `Codigo_Postal`,`p`.`Provincia` AS `Provincia`,`p`.`Pais` AS `Pais`,`p`.`Telefono` AS `Telefono`,`p`.`Fax` AS `Fax`,`p`.`eMail` AS `eMail`,`p`.`Tipo_de_Documento` AS `Tipo_de_Documento`,`p`.`Nro_de_Documento` AS `Nro_de_Documento`,`p`.`Cuit` AS `Cuit`,`p`.`IVA` AS `IVA`,`p`.`Ing_Brutos_Exento` AS `Ing_Brutos_Exento`,`p`.`IngresosBrutos` AS `IngresosBrutos`,`p`.`Ganancias_Exento` AS `Ganancias_Exento`,`p`.`Saldo_Inicial` AS `Saldo_Inicial`,`p`.`Saldo` AS `Saldo`,`p`.`SaldosDto` AS `SaldosDto`,`p`.`Fecha_de_Ingreso` AS `Fecha_de_Ingreso`,`p`.`Fecha_Ultima_Operacion` AS `Fecha_Ultima_Operacion`,`p`.`Anulado` AS `Anulado`,`p`.`CtaCte` AS `CtaCte`,`p`.`Concepto` AS `Concepto`,`p`.`Provisorio` AS `Provisorio`,`p`.`Categoria` AS `Categoria`,`p`.`CodReg` AS `CodReg`,(select `tp`.`Descripcion` AS `descripcion` from `curia`.`tipoprov` `tp` where ((`p`.`IDEmpresa` = `tp`.`IDEmpresa`) and (`p`.`Tipo_de_Proveedor` = `tp`.`IDTipoProveedor`))) AS `desctipo`,(select `i`.`Tipo_IVA` AS `tipo_iva` from `curia`.`iva` `i` where (`p`.`IVA` = `i`.`IVA`)) AS `descIVA` from `curia`.`proveedo` `p`
md5=a0378063dce4d58c30904cd6ea9ada2f
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=2
timestamp=2007-11-01 08:16:36
create-version=1
source=select `p`.`IDEmpresa` AS `IDEmpresa`,`p`.`IDProveedor` AS `IDProveedor`,`p`.`Tipo_de_Proveedor` AS `Tipo_de_Proveedor`,`p`.`Apellido_y_Nombre` AS `Apellido_y_Nombre`,`p`.`Calle` AS `Calle`,`p`.`Numero` AS `Numero`,`p`.`Piso` AS `Piso`,`p`.`Oficina` AS `Oficina`,`p`.`Localidad` AS `Localidad`,`p`.`Codigo_Postal` AS `Codigo_Postal`,`p`.`Provincia` AS `Provincia`,`p`.`Pais` AS `Pais`,`p`.`Telefono` AS `Telefono`,`p`.`Fax` AS `Fax`,`p`.`eMail` AS `eMail`,`p`.`Tipo_de_Documento` AS `Tipo_de_Documento`,`p`.`Nro_de_Documento` AS `Nro_de_Documento`,`p`.`Cuit` AS `Cuit`,`p`.`IVA` AS `IVA`,`p`.`Ing_Brutos_Exento` AS `Ing_Brutos_Exento`,`p`.`IngresosBrutos` AS `IngresosBrutos`,`p`.`Ganancias_Exento` AS `Ganancias_Exento`,`p`.`Saldo_Inicial` AS `Saldo_Inicial`,`p`.`Saldo` AS `Saldo`,`p`.`SaldosDto` AS `SaldosDto`,`p`.`Fecha_de_Ingreso` AS `Fecha_de_Ingreso`,`p`.`Fecha_Ultima_Operacion` AS `Fecha_Ultima_Operacion`,`p`.`Anulado` AS `Anulado`,`p`.`CtaCte` AS `CtaCte`,`p`.`Concepto` AS `Concepto`,`p`.`Provisorio` AS `Provisorio`,`p`.`Categoria` AS `Categoria`,`p`.`CodReg` AS `CodReg`,(select `tp`.`Descripcion` AS `descripcion` from `tipoprov` `tp` where ((`p`.`IDEmpresa` = `tp`.`IDEmpresa`) and (`p`.`Tipo_de_Proveedor` = `tp`.`IDTipoProveedor`))) AS `desctipo`,(select `i`.`Tipo_IVA` AS `tipo_iva` from `iva` `i` where (`p`.`IVA` = `i`.`IVA`)) AS `descIVA` from `proveedo` `p`
