2024-03-13 11:50:27 +00:00
|
|
|
CREATE OR REPLACE DEFINER=`root`@`localhost`
|
|
|
|
|
SQL SECURITY DEFINER
|
|
|
|
|
VIEW `vn2008`.`payroll_conceptos`
|
|
|
|
|
AS SELECT `pc`.`id` AS `conceptoid`,
|
2024-03-13 13:17:10 +00:00
|
|
|
`pc`.`name` AS `concepto`,
|
2024-03-13 11:50:27 +00:00
|
|
|
`pc`.`isSalaryAgreed` AS `isSalaryAgreed`,
|
|
|
|
|
`pc`.`isVariable` AS `isVariable`,
|
|
|
|
|
`pc`.`isException` AS `isException`
|
|
|
|
|
FROM `vn`.`payrollComponent` `pc`
|
