Project

General

Profile

Feature #1404

VẬN HÀNH SAU GOLIVE NGÀY 22-11-2022

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

Status:
New
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
11/22/2022
Due date:
% Done:

0%

Estimated time:
Data_Bao.xlsx (12.4 KB) Data_Bao.xlsx Luc Tran Van, 11/22/2022 09:29 AM
nguyennhk.txt (634 Bytes) nguyennhk.txt Luc Tran Van, 11/22/2022 10:26 AM
DATA_PHONG_#4.txt (2.27 KB) DATA_PHONG_#4.txt Luc Tran Van, 11/22/2022 10:30 AM
DATA_BAO_#5.xlsx (9.73 KB) DATA_BAO_#5.xlsx Luc Tran Van, 11/22/2022 10:34 AM
PL_REQUEST_DOC_ByTransfer.txt (5.07 KB) PL_REQUEST_DOC_ByTransfer.txt Luc Tran Van, 11/22/2022 11:03 AM
PUR_2022_002759_SỬA DATA.txt (1.2 KB) PUR_2022_002759_SỬA DATA.txt Luc Tran Van, 11/22/2022 11:10 AM
Debug.txt (279 Bytes) Debug.txt Luc Tran Van, 11/22/2022 11:14 AM
PAY_KT_UPD.txt (38 KB) PAY_KT_UPD.txt Luc Tran Van, 11/22/2022 01:48 PM
DATA_BAO_#18.xlsx (10.9 KB) DATA_BAO_#18.xlsx Luc Tran Van, 11/22/2022 02:07 PM
TR_REQUEST_DOC_MOVE_DVCM.txt (3.47 KB) TR_REQUEST_DOC_MOVE_DVCM.txt Luc Tran Van, 11/22/2022 02:22 PM
PAY_KT_UPD.txt (38.3 KB) PAY_KT_UPD.txt Luc Tran Van, 11/22/2022 02:56 PM
PL_REQUEST_DOC_DT_ById.txt (18.3 KB) PL_REQUEST_DOC_DT_ById.txt Luc Tran Van, 11/22/2022 03:47 PM
231122.zip (25.1 KB) 231122.zip Luc Tran Van, 11/23/2022 11:50 AM

History

#1 Updated by Luc Tran Van over 2 years ago

  • Assignee set to Luc Tran Van

#2 Updated by Luc Tran Van over 2 years ago

SELECT * FROM TR_REQUEST_DOC WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002759')
SELECT * FROM TR_REQUEST_DOC_PL_DT WHERE REQ_DOC_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002759')
SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002759')
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002759')
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002759')

#5 Updated by Luc Tran Van over 2 years ago

SELECT * FROM PL_PROCESS WHERE REQ_ID = 'TRRD00000257401'

#8 Updated by Luc Tran Van over 2 years ago

PUR/2022/002759

#11 Updated by Luc Tran Van over 2 years ago

#12 Updated by Luc Tran Van over 2 years ago

SELECT ISNULL,0)
FROM dbo.PL_REQUEST_DOC_DT DDT
LEFT JOIN dbo.PL_REQUEST_DOC DOC ON DDT.REQ_ID = DOC.REQ_ID
WHERE DOC.PROCESS_ID IN ('APPROVE','SETTLMENT')
AND DDT.TRADE_ID = 'PLT000000283388'

SELECT pt.AMT_ETM FROM PL_TRADEDETAIL pt WHERE pt.TRADE_ID = 'PLT000000283388'

#13 Updated by Luc Tran Van over 2 years ago

SELECT ISNULL,0)
FROM dbo.PL_REQUEST_DOC_DT DDT
LEFT JOIN dbo.PL_REQUEST_DOC DOC ON DDT.REQ_ID = DOC.REQ_ID
WHERE DOC.PROCESS_ID IN ('APPROVE','SETTLMENT')
AND DDT.TRADE_ID = 'PLT000000283388'

SELECT pt.AMT_ETM FROM PL_TRADEDETAIL pt WHERE pt.TRADE_ID = 'PLT000000283388'

#14 Updated by Luc Tran Van over 2 years ago

UPDATE PL_TRADEDETAIL SET AMT_ETM = AMT_ETM -3300000 WHERE TRADE_ID ='PLT000000283388'

#15 Updated by Luc Tran Van over 2 years ago

PUR/2022/002814

#17 Updated by Luc Tran Van over 2 years ago

UPDATE TL_USER SET RoleName = 'NVMS' WHERE TLNANME = 'nguyennhk'

#18 Updated by Luc Tran Van over 2 years ago

SELECT * FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002602'
SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002602')
SELECT * FROM CM_SUPPLIER WHERE SUP_CODE = 'CMS000000252081'

#20 Updated by Luc Tran Van over 2 years ago

UPDATE TR_REQUEST_DOC_DT SET SUP_ID = 'CMS000000252081' WHERE REQ_DOC_ID = 'TRRD00000257244'

#24 Updated by Luc Tran Van over 2 years ago

UPDATE TR_REQUEST_DOC SET AUTH_STATUS='E', PROCESS_ID='' WHERE REQ_ID='TRRD00000257456'
DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID ='TRRD00000257456'

#25 Updated by Luc Tran Van over 2 years ago

Also available in: Atom PDF