Project

General

Profile

Support #869

Cập nhật lại hợp đồng cho phiếu đề nghị thanh toán

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/28/2021
Due date:
% Done:

0%

Estimated time:

Description

--SELECT * FROM TR_CONTRACT WHERE CONTRACT_ID ='TRC000001126807'

--SELECT * FROM TR_CONTRACT WHERE CONTRACT_ID ='TRC000001125772'
--SELECT * FROM TR_REQ_ADVANCE_DT WHERE REF_ID ='TRC000001126807'
SELECT * FROM TR_REQ_ADVANCE_DT WHERE REF_ID ='TRC000001125772'

SELECT * FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID ='TTTY00001120683'
UPDATE TR_REQ_ADVANCE_DT SET REF_ID ='TRC000001125772' WHERE REQ_PAYDTID='TUTU00001103447'
SELECT * FROM TR_REQ_PAY_PERIOD WHERE REQ_PAY_ID ='TTTY00001120683'
UPDATE TR_REQ_PAY_PERIOD SET CONTRACT_ID ='TRC000001125772' WHERE REQ_PAY_ID ='TTTY00001120683'

History

#1 Updated by Luc Tran Van over 4 years ago

UPDATE TR_REQ_ADVANCE_PAYMENT SET REQ_PAY_CODE ='062020/000001' WHERE REQ_PAY_ID ='TTTY00001120683'

#2 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF