-
Change
-
解决结果: 完成
-
High
-
无
-
L-Links-Y2020058
-
基础通用功能
员工孙晨11月工资里未累计到9月应税工资,执行以下sql后,如图所示,发现缺少9月扣缴义务人,希望可以补全code = 'D001' ,employee_tax_month ='2021-09'
SELECT
brd.text, brd.value, wa.code, brd.employee_tax_month
FROM
batch_result_data AS brd
LEFT JOIN withhold_agent AS wa
ON brd.employee_withholding_agent_id = wa.ID
WHERE
batch_id = ( SELECT ID FROM hr_payslip_run WHERE NAME = 'PG006-20210901' )
AND employee_id = ( SELECT ID FROM hr_employee WHERE employee_number = 'DK997' )
AND payitem_code = 'R0016';