24 lines
723 B
MySQL
24 lines
723 B
MySQL
|
CREATE OR REPLACE DEFINER=`root`@`localhost`
|
||
|
|
SQL SECURITY DEFINER
|
||
|
|
VIEW `vn2008`.`empresa`
|
||
|
|
AS SELECT `c`.`id` AS `id`,
|
||
|
|
`c`.`code` AS `abbreviation`,
|
||
|
|
`c`.`supplierAccountFk` AS `Id_Proveedores_account`,
|
||
|
|
`c`.`workerManagerFk` AS `gerente_id`,
|
||
|
|
`c`.`phytosanitary` AS `phytosanitary`,
|
||
|
|
`c`.`companyCode` AS `CodigoEmpresa`,
|
||
|
|
`c`.`companyGroupFk` AS `empresa_grupo`,
|
||
|
|
`c`.`isDefaulter` AS `morosidad`,
|
||
|
|
`c`.`expired` AS `baja`,
|
||
|
|
`c`.`register` AS `registro`,
|
||
|
|
`c`.`registered` AS `alta`,
|
||
|
|
`c`.`logo` AS `logo`,
|
||
|
|
`c`.`isOfficial` AS `oficial`,
|
||
|
|
`c`.`hasCyc` AS `cyc`,
|
||
|
|
`c`.`rgb` AS `rgb`,
|
||
|
|
`c`.`email` AS `mail`,
|
||
|
|
`c`.`stamp` AS `cuno`,
|
||
|
|
`c`.`created` AS `ODBC_DATE`,
|
||
|
|
`c`.`clientFk` AS `Id_Cliente`
|
||
|
|
FROM `vn`.`company` `c`
|