34 lines
1.0 KiB
MySQL
34 lines
1.0 KiB
MySQL
|
CREATE OR REPLACE DEFINER=`root`@`localhost`
|
||
|
|
SQL SECURITY DEFINER
|
||
|
|
VIEW `vn2008`.`Compres`
|
||
|
|
AS SELECT `c`.`id` AS `Id_Compra`,
|
||
|
|
`c`.`entryFk` AS `Id_Entrada`,
|
||
|
|
`c`.`itemFk` AS `Id_Article`,
|
||
|
|
`c`.`buyingValue` AS `Costefijo`,
|
||
|
|
`c`.`quantity` AS `Cantidad`,
|
||
|
|
`c`.`packagingFk` AS `Id_Cubo`,
|
||
|
|
`c`.`stickers` AS `Etiquetas`,
|
||
|
|
`c`.`freightValue` AS `Portefijo`,
|
||
|
|
`c`.`packageValue` AS `Embalajefijo`,
|
||
|
|
`c`.`comissionValue` AS `Comisionfija`,
|
||
|
|
`c`.`packing` AS `Packing`,
|
||
|
|
`c`.`grouping` AS `grouping`,
|
||
|
|
`c`.`groupingMode` AS `caja`,
|
||
|
|
`c`.`location` AS `Nicho`,
|
||
|
|
`c`.`price1` AS `Tarifa1`,
|
||
|
|
`c`.`price2` AS `Tarifa2`,
|
||
|
|
`c`.`price3` AS `Tarifa3`,
|
||
|
|
`c`.`minPrice` AS `PVP`,
|
||
|
|
`c`.`printedStickers` AS `Vida`,
|
||
|
|
`c`.`isChecked` AS `punteo`,
|
||
|
|
`c`.`ektFk` AS `buy_edi_id`,
|
||
|
|
`c`.`created` AS `odbc_date`,
|
||
|
|
`c`.`isIgnored` AS `Novincular`,
|
||
|
|
`c`.`isPickedOff` AS `isPickedOff`,
|
||
|
|
`c`.`workerFk` AS `Id_Trabajador`,
|
||
|
|
`c`.`weight` AS `weight`,
|
||
|
|
`c`.`dispatched` AS `dispatched`,
|
||
|
|
`c`.`containerFk` AS `container_id`,
|
||
|
|
`c`.`itemOriginalFk` AS `itemOriginalFk`
|
||
|
|
FROM `vn`.`buy` `c`
|