|
1
|
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'PLRD00000200946',N'GDK_TT',N'C',N'GDK',N'',N'',NULL,N'TC',N'N',N'',N'DM0000000000018',N'Chờ giám đốc khối xác nhận',0,NULL)
|
|
2
|
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'PLRD00000200946',N'GDK_TT',N'C',N'GDK',N'',N'',NULL,N'TC',N'N',N'',N'DM0000000000015',N'Chờ giám đốc khối xác nhận',0,NULL)
|
|
3
|
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'PLRD00000200946',N'PTGDK_TT',N'U',N'PTGD',N'',N'',NULL,N'GDK_TT',N'N',N'',N'DM0000000000015',N'Chờ phó tổng giám đốc khối xác nhận',0,NULL)
|
|
4
|
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'PLRD00000200946',N'PTGDK_TT',N'U',N'PTGD',N'',N'',NULL,N'GDK_TT',N'N',N'',N'DM0000000000017',N'Chờ phó tổng giám đốc khối xác nhận',0,NULL)
|
|
5
|
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'PLRD00000200946',N'TGD',N'U',N'TGD',N'',N'',NULL,N'PTGDK_TT',N'N',N'',N'',N'Chờ tổng giám đốc khối xác nhận',0,NULL)
|
|
6
|
|
|
7
|
UPDATE PL_TRADEDETAIL SET AMT_ETM=AMT_ETM-3973620200,AMT_RECEIVE_TF=AMT_RECEIVE_TF-723620200 WHERE TRADE_ID='PLT000000071211'
|
|
8
|
UPDATE PL_TRADEDETAIL SET AMT_ETM=AMT_ETM-690800000 WHERE TRADE_ID='PLT000000071351'
|
|
9
|
UPDATE PL_TRADEDETAIL SET AMT_ETM=AMT_ETM-529500000 WHERE TRADE_ID='PLT000001012732'
|
|
10
|
UPDATE PL_TRADEDETAIL SET AMT_ETM=AMT_ETM-1679900000,AMT_TF=AMT_TF-723620200 WHERE TRADE_ID='PLT000001071902'
|
|
11
|
UPDATE PL_TRADEDETAIL SET AMT_ETM=AMT_ETM-153000000 WHERE TRADE_ID='PLT000001071878'
|
|
12
|
UPDATE PL_TRADEDETAIL SET AMT_ETM=AMT_ETM-78000000 WHERE TRADE_ID='PLT000001012687'
|
|
13
|
UPDATE dbo.PL_REQUEST_DOC SET PROCESS_ID='GDK_TT' WHERE REQ_ID='PLRD00000200946'
|
|
14
|
UPDATE dbo.PL_REQUEST_PROCESS SET STATUS='U',PARENT_PROCESS_ID='TGD' WHERE REQ_ID='PLRD00000200946' AND PROCESS_ID='APPROVE'
|