Project

General

Profile

Feature #655

Kiểm tra TTCT 0002/2020/TTr-069040302 NS bị sai số tiền

Added by Truong Nguyen Vu over 4 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Truong Nguyen Vu
Start date:
11/20/2020
Due date:
% Done:

0%

Estimated time:
DATA TT 0002 069040302.xlsx (114 KB) DATA TT 0002 069040302.xlsx Luc Tran Van, 11/20/2020 09:06 AM
UPDATE TTCT 0002.txt (249 Bytes) UPDATE TTCT 0002.txt Truong Nguyen Vu, 11/20/2020 09:45 AM
IN TTCT 0002 069040302.pdf (268 KB) IN TTCT 0002 069040302.pdf Luc Tran Van, 11/20/2020 09:51 AM

History

#1 Updated by Luc Tran Van over 4 years ago

SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE ='0002/2020/TTr-069040302'
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='PLRD00000200273'
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID ='PLRD00000200273'
SELECT * FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID ='PLRD00000200273'
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT TRADE_ID FROM PL_REQUEST_DOC_DT WHERE REQ_ID ='PLRD00000200273')
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT FR_TRADE_ID FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID ='PLRD00000200273')
SELECT * FROM PL_TRADEDETAIL_HIST

#4 Updated by Truong Nguyen Vu over 4 years ago

UPDATE dbo.PL_REQUEST_DOC_DT SET TRADE_ID='PLT000001064143',PLAN_ID='PLM000001056986',TRADE_ID='GOO000001061967' WHERE REQ_ID='PLRD00000200273'

#5 Updated by Truong Nguyen Vu over 4 years ago

UPDATE dbo.PL_REQUEST_DOC_DT SET TRADE_ID='PLT000001064143',PLAN_ID='PLM000001056986',GOODS_ID='GOO000001061967' WHERE REQ_ID='PLRD00000200273'

#6 Updated by Truong Nguyen Vu over 4 years ago

UPDATE dbo.PL_REQUEST_TRANSFER SET TO_TRADE_ID='PLT000001064143',TO_PLAN_ID='PLM000001056986',TO_GOOD_ID='GOO000001061967' WHERE REQ_DOC_ID='PLRD00000200273'

#7 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF