19 lines
564 B
MySQL
19 lines
564 B
MySQL
|
CREATE OR REPLACE DEFINER=`root`@`localhost`
|
||
|
|
SQL SECURITY DEFINER
|
||
|
|
VIEW `vn2008`.`Movimientos`
|
||
|
|
AS SELECT `m`.`id` AS `Id_Movimiento`,
|
||
|
|
`m`.`itemFk` AS `Id_Article`,
|
||
|
|
`m`.`ticketFk` AS `Id_Ticket`,
|
||
|
|
`m`.`concept` AS `Concepte`,
|
||
|
|
`m`.`quantity` AS `Cantidad`,
|
||
|
|
`m`.`price` AS `Preu`,
|
||
|
|
`m`.`discount` AS `Descuento`,
|
||
|
|
`m`.`reserved` AS `Reservado`,
|
||
|
|
`m`.`isPicked` AS `OK`,
|
||
|
|
`m`.`created` AS `odbc_date`,
|
||
|
|
`m`.`priceFixed` AS `CostFixat`,
|
||
|
|
`m`.`isPriceFixed` AS `PrecioFijado`,
|
||
|
|
`m`.`originalQuantity` AS `quantity`,
|
||
|
|
`m`.`isAdded` AS `isAdded`
|
||
|
|
FROM `vn`.`sale` `m`
|