EOFFICE - GD4

04/04/2025

04:44 PM Bug #1593: UAT 04042025

DECLARE @REQ_ID VARCHAR(15)
SELECT @REQ_ID = REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2024/002916'
INSERT d... Luc Tran Van

03:29 PM Bug #1593: UAT 04042025

WITH RankedTrades AS (
SELECT
B.YEAR,
B.DEPT_ID,
B.BRANCH_ID,
DP.DEP_COD... Luc Tran Van

03:15 PM Bug #1593: UAT 04042025

UPDATE dbo.PL_TRADEDETAIL
SET PLAN_ID = 'X' + LEFT(PLAN_ID, LEN(PLAN_ID) - 14)
WHERE LEN(PLAN_ID) > 14 AND PLAN_ID ... Luc Tran Van

02:29 PM Bug #1593: UAT 04042025

DECLARE @REQ_ID VARCHAR(50)
SELECT TOP 1 @REQ_ID = IMP_LOG_CODE FROM dbo.PL_IMPORT_LOG ORDER BY IMP_LOG_ID DESC
SEL... Luc Tran Van

08:55 AM Bug #1593: UAT 04042025

WITH RankedTrades AS (
SELECT
B.YEAR,
B.DEPT_ID,
B.BRANCH_ID,
DP.DEP_COD... Luc Tran Van

08:55 AM Bug #1593 (New): UAT 04042025

Luc Tran Van

08:50 AM Bug #1590: UAT.25.03.2025

SELECT B.YEAR, A.*
FROM dbo.PL_TRADEDETAIL A
INNER JOIN dbo.PL_MASTER B ON B.PLAN_ID = A.PLAN_ID
WHERE TRADE_ID I... Luc Tran Van