Project

General

Profile

Download (608 Bytes)

RULE AUTOMATION.txt

Luc Tran Van, 01/27/2021 04:05 PM

 
1 
??UPDATE TR_REQ_PAY_PERIOD SET PROCESS ='2' WHERE REQ_PAY_ID
2 
IN (SELECT REQ_PAY_ID FROM TR_REQ_ADVANCE_PAYMENT WHERE ISNULL (REQ_AMT,0) = ISNULL(PAY_AMT,0)) AND PROCESS <> '2'
3 
UPDATE TR_REQ_PAY_INVOICE SET INVOICE_NO = INVOICE_NO +'REMOVE' WHERE REQ_PAY_ID NOT IN (SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT)