CREATE OR REPLACE DEFINER=`root`@`localhost`
	SQL SECURITY DEFINER
	VIEW `vn2008`.`Recibos`
AS SELECT `r`.`Id` AS `Id`,
	`r`.`invoiceFk` AS `Id_Factura`,
	`r`.`amountPaid` AS `Entregado`,
	`r`.`payed` AS `Fechacobro`,
	`r`.`workerFk` AS `Id_Trabajador`,
	`r`.`bankFk` AS `Id_Banco`,
	`r`.`clientFk` AS `Id_Cliente`,
	`r`.`created` AS `odbc_date`,
	`r`.`companyFk` AS `empresa_id`,
	`r`.`isConciliate` AS `conciliado`
FROM `vn`.`receipt` `r`