34 lines
1.0 KiB
MySQL
34 lines
1.0 KiB
MySQL
|
CREATE OR REPLACE DEFINER=`root`@`localhost`
|
||
|
|
SQL SECURITY DEFINER
|
||
|
|
VIEW `vn2008`.`awb`
|
||
|
|
AS SELECT `a`.`id` AS `id`,
|
||
|
|
`a`.`code` AS `codigo`,
|
||
|
|
`a`.`package` AS `bultos`,
|
||
|
|
`a`.`weight` AS `peso`,
|
||
|
|
`a`.`created` AS `MYSQL_TIME`,
|
||
|
|
`a`.`transitoryFk` AS `transitario_id`,
|
||
|
|
`a`.`taxFk` AS `iva_id`,
|
||
|
|
`a`.`duakk` AS `duakk`,
|
||
|
|
`a`.`docFk` AS `gestdoc_id`,
|
||
|
|
`a`.`amount` AS `importe`,
|
||
|
|
`a`.`freightFk` AS `carguera_id`,
|
||
|
|
`a`.`m3` AS `m3`,
|
||
|
|
`a`.`stems` AS `stems`,
|
||
|
|
`a`.`flightFk` AS `flight_id`,
|
||
|
|
`a`.`volumeWeight` AS `volume_weight`,
|
||
|
|
`a`.`hb` AS `hb`,
|
||
|
|
`a`.`rate` AS `rate`,
|
||
|
|
`a`.`booked` AS `booked`,
|
||
|
|
`a`.`issued` AS `issued`,
|
||
|
|
`a`.`operated` AS `operated`,
|
||
|
|
`a`.`bookEntried` AS `bookEntried`,
|
||
|
|
`a`.`invoiceInFk` AS `invoiceInFk`,
|
||
|
|
`a`.`isChecked` AS `isChecked`,
|
||
|
|
`a`.`isTransitoryChecked` AS `isTransitoryChecked`,
|
||
|
|
`a`.`year` AS `year`,
|
||
|
|
`a`.`invoiceInPaletizedFk` AS `invoiceInPaletizedFk`,
|
||
|
|
`a`.`observation` AS `observation`,
|
||
|
|
`a`.`hasFreightPrepaid` AS `hasFreightPrepaid`,
|
||
|
|
`a`.`propertyNumber` AS `propertyNumber`
|
||
|
|
FROM `vn`.`awb` `a`
|