UPDATE dbo.PL_TRADEDETAIL SET AMT_ETM=AMT_ETM-2283134700.00 WHERE TRADE_ID='PLT000000071220'
UPDATE dbo.PL_TRADEDETAIL SET AMT_ETM=AMT_ETM-1016000000.00	WHERE TRADE_ID='PLT000000071360'
UPDATE dbo.PL_TRADEDETAIL SET AMT_ETM=AMT_ETM-230325000.00	WHERE TRADE_ID='PLT000001071860'
UPDATE dbo.PL_TRADEDETAIL SET AMT_ETM=AMT_ETM-157000000.00	WHERE TRADE_ID='PLT000001071901'
UPDATE dbo.PL_TRADEDETAIL SET AMT_ETM=AMT_ETM-85000000.00	WHERE TRADE_ID='PLT000001071877'
UPDATE dbo.PL_TRADEDETAIL SET AMT_ETM=AMT_ETM-25200000.00	WHERE TRADE_ID='PLT000001071818'

UPDATE PL_TRADEDETAIL SET AMT_TF=AMT_TF-89220700.00 WHERE TRADE_ID='PLT000000071216'
UPDATE PL_TRADEDETAIL SET AMT_TF=AMT_TF-549914000.00 WHERE TRADE_ID='PLT000000071222'

UPDATE PL_TRADEDETAIL SET AMT_RECEIVE_TF=AMT_RECEIVE_TF-23134700.00 	  WHERE TRADE_ID='PLT000000071220'
UPDATE PL_TRADEDETAIL SET AMT_RECEIVE_TF=AMT_RECEIVE_TF-616000000.00	  WHERE TRADE_ID='PLT000000071360'
UPDATE dbo.PL_REQUEST_DOC SET PROCESS_ID='GDK_DC' WHERE REQ_ID='PLRD00000200360'
UPDATE dbo.PL_REQUEST_PROCESS SET PARENT_PROCESS_ID='TGD_DC',STATUS='U' WHERE REQ_ID='PLRD00000200360' AND PROCESS_ID='APPROVE'
INSERT INTO [Pl_REQUEST_PROCESS] ([REQ_ID],[PROCESS_ID],[STATUS],[ROLE_USER],[BRANCH_ID],[CHECKER_ID],[APPROVE_DT],[PARENT_PROCESS_ID],[IS_LEAF],[COST_ID],[DVDM_ID],[NOTES],[IS_HAS_CHILD],[DEP_ID])VALUES(N'PLRD00000200360',N'GDK_DC',N'C',N'GDK',N'',N'',N'Nov  4 2020  2:54PM',N'TC',N'N',N'',N'DM0000000000015',N'Chờ giám đốc khối xác nhận',NULL,NULL)
INSERT INTO [Pl_REQUEST_PROCESS] ([REQ_ID],[PROCESS_ID],[STATUS],[ROLE_USER],[BRANCH_ID],[CHECKER_ID],[APPROVE_DT],[PARENT_PROCESS_ID],[IS_LEAF],[COST_ID],[DVDM_ID],[NOTES],[IS_HAS_CHILD],[DEP_ID])VALUES(N'PLRD00000200360',N'PTGD_DC',N'U',N'PTGD',N'',N'',N'Nov  4 2020  2:54PM',N'GDK_DC',N'N',N'',N'DM0000000000015',N'Chờ giám đốc khối xác nhận',NULL,NULL)
INSERT INTO [Pl_REQUEST_PROCESS] ([REQ_ID],[PROCESS_ID],[STATUS],[ROLE_USER],[BRANCH_ID],[CHECKER_ID],[APPROVE_DT],[PARENT_PROCESS_ID],[IS_LEAF],[COST_ID],[DVDM_ID],[NOTES],[IS_HAS_CHILD],[DEP_ID])VALUES(N'PLRD00000200360',N'TGD_DC',N'U',N'TGD',N'',N'',NULL,N'PTGD_DC',N'',N'',N'',N'Chờ tổng giám đốc phê duyệt',NULL,NULL)
INSERT INTO [Pl_REQUEST_PROCESS] ([REQ_ID],[PROCESS_ID],[STATUS],[ROLE_USER],[BRANCH_ID],[CHECKER_ID],[APPROVE_DT],[PARENT_PROCESS_ID],[IS_LEAF],[COST_ID],[DVDM_ID],[NOTES],[IS_HAS_CHILD],[DEP_ID])VALUES(N'PLRD00000200360',N'PTGD_DC',N'U',N'PTGD',N'',N'',N'Nov  4 2020  2:54PM',N'GDK_DC',N'N',N'',N'DM0000000000017',N'Chờ giám đốc khối xác nhận',NULL,NULL)