41 lines
946 B
MySQL
41 lines
946 B
MySQL
|
CREATE OR REPLACE DEFINER=`root`@`localhost`
|
||
|
|
SQL SECURITY DEFINER
|
||
|
|
VIEW `vn2008`.`buy_edi`
|
||
|
|
AS SELECT `t`.`id` AS `id`,
|
||
|
|
`t`.`entryYear` AS `entry_year`,
|
||
|
|
`t`.`deliveryNumber` AS `delivery_number`,
|
||
|
|
`t`.`fec` AS `fec`,
|
||
|
|
`t`.`hor` AS `hor`,
|
||
|
|
`t`.`now` AS `now`,
|
||
|
|
`t`.`ptj` AS `ptj`,
|
||
|
|
`t`.`ref` AS `ref`,
|
||
|
|
`t`.`item` AS `item`,
|
||
|
|
`t`.`pac` AS `pac`,
|
||
|
|
`t`.`qty` AS `qty`,
|
||
|
|
`t`.`ori` AS `ori`,
|
||
|
|
`t`.`cat` AS `cat`,
|
||
|
|
`t`.`agj` AS `agj`,
|
||
|
|
`t`.`kop` AS `kop`,
|
||
|
|
`t`.`ptd` AS `ptd`,
|
||
|
|
`t`.`sub` AS `sub`,
|
||
|
|
`t`.`pro` AS `pro`,
|
||
|
|
`t`.`pri` AS `pri`,
|
||
|
|
`t`.`package` AS `package`,
|
||
|
|
`t`.`auction` AS `auction`,
|
||
|
|
`t`.`klo` AS `klo`,
|
||
|
|
`t`.`k1` AS `k01`,
|
||
|
|
`t`.`k2` AS `k02`,
|
||
|
|
`t`.`k3` AS `k03`,
|
||
|
|
`t`.`k4` AS `k04`,
|
||
|
|
`t`.`s1` AS `s1`,
|
||
|
|
`t`.`s2` AS `s2`,
|
||
|
|
`t`.`s3` AS `s3`,
|
||
|
|
`t`.`s4` AS `s4`,
|
||
|
|
`t`.`s5` AS `s5`,
|
||
|
|
`t`.`s6` AS `s6`,
|
||
|
|
`t`.`ok` AS `ok`,
|
||
|
|
`t`.`trolleyFk` AS `trolley_id`,
|
||
|
|
`t`.`putOrderFk` AS `putOrderFk`,
|
||
|
|
`t`.`scanned` AS `scanned`
|
||
|
|
FROM `edi`.`ekt` `t`
|