29 lines
899 B
MySQL
29 lines
899 B
MySQL
|
CREATE OR REPLACE DEFINER=`root`@`localhost`
|
||
|
|
SQL SECURITY DEFINER
|
||
|
|
VIEW `vn2008`.`Entradas`
|
||
|
|
AS SELECT `e`.`id` AS `Id_Entrada`,
|
||
|
|
`e`.`supplierFk` AS `Id_Proveedor`,
|
||
|
|
`e`.`invoiceNumber` AS `Referencia`,
|
||
|
|
`e`.`reference` AS `reference`,
|
||
|
|
`e`.`isExcludedFromAvailable` AS `Inventario`,
|
||
|
|
`e`.`isConfirmed` AS `Confirmada`,
|
||
|
|
`e`.`isOrdered` AS `Pedida`,
|
||
|
|
`e`.`commission` AS `comision`,
|
||
|
|
`e`.`created` AS `odbc_date`,
|
||
|
|
`e`.`evaNotes` AS `Notas_Eva`,
|
||
|
|
`e`.`travelFk` AS `travel_id`,
|
||
|
|
`e`.`currencyFk` AS `Id_Moneda`,
|
||
|
|
`e`.`companyFk` AS `empresa_id`,
|
||
|
|
`e`.`gestDocFk` AS `gestdoc_id`,
|
||
|
|
`e`.`invoiceInFk` AS `recibida_id`,
|
||
|
|
`e`.`dated` AS `Fecha`,
|
||
|
|
`e`.`isBooked` AS `Anotadoencaja`,
|
||
|
|
`e`.`loadPriority` AS `loadPriority`,
|
||
|
|
`e`.`sub` AS `sub`,
|
||
|
|
`e`.`kop` AS `kop`,
|
||
|
|
`e`.`pro` AS `pro`,
|
||
|
|
`e`.`invoiceAmount` AS `invoiceAmount`,
|
||
|
|
`e`.`buyerFk` AS `buyerFk`,
|
||
|
|
`e`.`typeFk` AS `typeFk`
|
||
|
|
FROM `vn`.`entry` `e`
|