【Payroll】取消已完成的支付处理
2016-08-03 本文已影响0人
记忆飘向青春海
取消已完成的支付处理
DELETE FROM PS_GP_PAYMENT
WHERE CAL_RUN_ID='日历组ID';
UPDATE PS_GP_CAL_RUN
SET PMT_SENT_IND='N'
WHERE CAL_RUN_ID = '日历组ID';
DELETE FROM PS_GP_PAYMENT
WHERE CAL_RUN_ID='日历组ID';
UPDATE PS_GP_CAL_RUN
SET PMT_SENT_IND='N'
WHERE CAL_RUN_ID = '日历组ID';