CREATE OR REPLACE DEFINER=`root`@`localhost`
	SQL SECURITY DEFINER
	VIEW `vn2008`.`Tickets`
AS SELECT `t`.`id` AS `Id_Ticket`,
	`t`.`clientFk` AS `Id_Cliente`,
	`t`.`warehouseFk` AS `warehouse_id`,
	`t`.`shipped` AS `Fecha`,
	`t`.`landed` AS `landing`,
	`t`.`nickname` AS `Alias`,
	`t`.`refFk` AS `Factura`,
	`t`.`addressFk` AS `Id_Consigna`,
	`t`.`location` AS `Localizacion`,
	`t`.`solution` AS `Solucion`,
	`t`.`routeFk` AS `Id_Ruta`,
	`t`.`companyFk` AS `empresa_id`,
	`t`.`agencyModeFk` AS `Id_Agencia`,
	`t`.`priority` AS `Prioridad`,
	`t`.`packages` AS `Bultos`,
	`t`.`isDeleted` AS `isDeleted`,
	`t`.`created` AS `odbc_date`,
	`t`.`workerFk` AS `Id_Trabajador`,
	`t`.`observations` AS `Observaciones`,
	`t`.`isSigned` AS `Firmado`,
	`t`.`isLabeled` AS `Etiquetasemitidas`,
	`t`.`isPrinted` AS `PedidoImpreso`,
	`t`.`hour` AS `Hora`,
	`t`.`isBlocked` AS `blocked`,
	`t`.`hasPriority` AS `priority`,
	`t`.`isBoxed` AS `boxed`,
	`t`.`zoneFk` AS `zoneFk`,
	`t`.`totalWithVat` AS `totalWithVat`,
	`t`.`totalWithoutVat` AS `totalWithoutVat`
FROM `vn`.`ticket` `t`