19 lines
560 B
MySQL
19 lines
560 B
MySQL
|
CREATE OR REPLACE DEFINER=`root`@`localhost`
|
||
|
|
SQL SECURITY DEFINER
|
||
|
|
VIEW `vn2008`.`pago`
|
||
|
|
AS SELECT `p`.`id` AS `id`,
|
||
|
|
`p`.`received` AS `fecha`,
|
||
|
|
`p`.`dueDated` AS `dueDated`,
|
||
|
|
`p`.`supplierFk` AS `id_proveedor`,
|
||
|
|
`p`.`amount` AS `importe`,
|
||
|
|
`p`.`currencyFk` AS `id_moneda`,
|
||
|
|
`p`.`divisa` AS `divisa`,
|
||
|
|
`p`.`bankFk` AS `id_banco`,
|
||
|
|
`p`.`payMethodFk` AS `pay_met_id`,
|
||
|
|
`p`.`companyFk` AS `empresa_id`,
|
||
|
|
`p`.`isConciliated` AS `conciliado`,
|
||
|
|
`p`.`bankingFees` AS `g_bancarios`,
|
||
|
|
`p`.`concept` AS `concepte`,
|
||
|
|
`p`.`created` AS `odbc_date`
|
||
|
|
FROM `vn`.`payment` `p`
|