salix/db/routines/vn/views/payrollCenter.sql

8 lines
210 B
MySQL
Raw Permalink Normal View History

2024-08-20 08:06:10 +00:00
CREATE OR REPLACE DEFINER=`vn`@`localhost`
SQL SECURITY DEFINER
VIEW `vn`.`payrollCenter`
2024-04-18 07:13:15 +00:00
AS SELECT `b`.`workCenterFkA3` AS `codCenter`,
`b`.`companyFkA3` AS `companyCode`
FROM `vn`.`payrollWorkCenter` `b`