Project

General

Profile

Support #851

Kiểm tra lệch số liệu hoàn tạm ứng hợp đồng định kì

Added by Luc Tran Van over 4 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
01/22/2021
Due date:
% Done:

0%

Estimated time:

Description

SELECT * FROM TR_REQ_PAY_PERIOD WHERE AD_PAY_ID IN (SELECT REQ_PAY_ID FROM TR_REQ_ADVANCE_PAYMENT WHERE ISNULL =REQ_AMT) AND PROCESS = '0' AND PAY_TYPE ='ADV_PAY'

UPDATE TR_REQ_PAY_PERIOD SET PROCESS ='0' WHERE PERIOD_ID ='PYOD00000205788'

UPDATE TR_REQ_PAY_PERIOD SET PROCESS ='0' WHERE PERIOD_ID ='PYOD00000206772'

UPDATE TR_REQ_PAY_PERIOD SET PROCESS ='0' WHERE PERIOD_ID ='PYOD00000209342'

History

#1 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF