14 lines
444 B
MySQL
14 lines
444 B
MySQL
|
CREATE OR REPLACE DEFINER=`root`@`localhost`
|
||
|
|
SQL SECURITY DEFINER
|
||
|
|
VIEW `vn2008`.`recibida_iva`
|
||
|
|
AS SELECT `i`.`id` AS `id`,
|
||
|
|
`i`.`invoiceInFk` AS `recibida_id`,
|
||
|
|
`i`.`taxCodeFk` AS `iva_id`,
|
||
|
|
`i`.`taxableBase` AS `bi`,
|
||
|
|
`i`.`expenseFk` AS `gastos_id`,
|
||
|
|
`i`.`foreignValue` AS `divisa`,
|
||
|
|
`i`.`taxTypeSageFk` AS `taxTypeSageFk`,
|
||
|
|
`i`.`transactionTypeSageFk` AS `transactionTypeSageFk`,
|
||
|
|
`i`.`created` AS `MYSQL_TIME`
|
||
|
|
FROM `vn`.`invoiceInTax` `i`
|