DELETE FROM PL_MASTER WHERE BRANCH_ID ='BRN000000001843'

INSERT INTO [PL_MASTER] ([PLAN_ID],[PLAN_CODE],[PLAN_NAME],[BRANCH_ID],[DEPT_ID],[EFFECT_DT],[PLAN_TYPE],[TOTAL_AMT],[APPROVE_VALUE],[VERSON],[YEAR],[STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PLAN_TYPE_ID],[COST_ID])VALUES(N'PLM000000347527',N'077000120',N'KẾ HOẠCH NGÂN SÁCH 2020',N'BRN000000001843',N'DEP000000251865',N'Oct 22 2020  1:52PM',N'',205365630.60,205365630.60,1,N'2020',N'1',N'',N'1',NULL,NULL,N'A',N'admin',N'Oct 22 2020  1:52PM',N'PLTYPE000000019',N'DM0000000000003')
INSERT INTO [PL_MASTER] ([PLAN_ID],[PLAN_CODE],[PLAN_NAME],[BRANCH_ID],[DEPT_ID],[EFFECT_DT],[PLAN_TYPE],[TOTAL_AMT],[APPROVE_VALUE],[VERSON],[YEAR],[STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PLAN_TYPE_ID],[COST_ID])VALUES(N'PLM000000347528',N'077000120',N'KẾ HOẠCH NGÂN SÁCH 2020',N'BRN000000001843',N'DEP000000251865',N'Oct 22 2020  1:52PM',N'',205365630.60,205365630.60,1,N'2020',N'1',N'',N'1',NULL,NULL,N'A',N'admin',N'Oct 22 2020  1:52PM',N'PLTYPE000000019',N'DM0000000000049')
INSERT INTO [PL_MASTER] ([PLAN_ID],[PLAN_CODE],[PLAN_NAME],[BRANCH_ID],[DEPT_ID],[EFFECT_DT],[PLAN_TYPE],[TOTAL_AMT],[APPROVE_VALUE],[VERSON],[YEAR],[STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PLAN_TYPE_ID],[COST_ID])VALUES(N'PLM000000347529',N'077000120',N'KẾ HOẠCH NGÂN SÁCH 2020',N'BRN000000001843',N'DEP000000251865',N'Oct 22 2020  1:52PM',N'',209475000.00,209475000.00,1,N'2020',N'1',N'',N'1',NULL,NULL,N'A',N'admin',N'Oct 22 2020  1:52PM',N'PLTYPE000000020',N'DM0000000000003')
INSERT INTO [PL_MASTER] ([PLAN_ID],[PLAN_CODE],[PLAN_NAME],[BRANCH_ID],[DEPT_ID],[EFFECT_DT],[PLAN_TYPE],[TOTAL_AMT],[APPROVE_VALUE],[VERSON],[YEAR],[STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PLAN_TYPE_ID],[COST_ID])VALUES(N'PLM000000347530',N'077000120',N'KẾ HOẠCH NGÂN SÁCH 2020',N'BRN000000001843',N'DEP000000251865',N'Oct 22 2020  1:52PM',N'',209475000.00,209475000.00,1,N'2020',N'1',N'',N'1',NULL,NULL,N'A',N'admin',N'Oct 22 2020  1:52PM',N'PLTYPE000000020',N'DM0000000000052')
INSERT INTO [PL_MASTER] ([PLAN_ID],[PLAN_CODE],[PLAN_NAME],[BRANCH_ID],[DEPT_ID],[EFFECT_DT],[PLAN_TYPE],[TOTAL_AMT],[APPROVE_VALUE],[VERSON],[YEAR],[STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PLAN_TYPE_ID],[COST_ID])VALUES(N'PLM000000347531',N'077000120',N'KẾ HOẠCH NGÂN SÁCH 2020',N'BRN000000001843',N'DEP000000251865',N'Oct 22 2020  1:52PM',N'',85000000.00,85000000.00,1,N'2020',N'1',N'',N'1',NULL,NULL,N'A',N'admin',N'Oct 22 2020  1:52PM',N'PLTYPE000000022',N'DM0000000000004')
INSERT INTO [PL_MASTER] ([PLAN_ID],[PLAN_CODE],[PLAN_NAME],[BRANCH_ID],[DEPT_ID],[EFFECT_DT],[PLAN_TYPE],[TOTAL_AMT],[APPROVE_VALUE],[VERSON],[YEAR],[STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PLAN_TYPE_ID],[COST_ID])VALUES(N'PLM000000347532',N'077000120',N'KẾ HOẠCH NGÂN SÁCH 2020',N'BRN000000001843',N'DEP000000251865',N'Oct 22 2020  1:52PM',N'',2500000000.00,2500000000.00,1,N'2020',N'1',N'',N'1',NULL,NULL,N'A',N'admin',N'Oct 22 2020  1:52PM',N'PLTYPE000000028',N'DM0000000000003')
INSERT INTO [PL_MASTER] ([PLAN_ID],[PLAN_CODE],[PLAN_NAME],[BRANCH_ID],[DEPT_ID],[EFFECT_DT],[PLAN_TYPE],[TOTAL_AMT],[APPROVE_VALUE],[VERSON],[YEAR],[STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PLAN_TYPE_ID],[COST_ID])VALUES(N'PLM000000347533',N'077000120',N'KẾ HOẠCH NGÂN SÁCH 2020',N'BRN000000001843',N'DEP000000251865',N'Oct 22 2020  1:52PM',N'',400000000.00,400000000.00,1,N'2020',N'1',N'',N'1',NULL,NULL,N'A',N'admin',N'Oct 22 2020  1:52PM',N'PLTYPE000000031',N'DM0000000000003')
INSERT INTO [PL_MASTER] ([PLAN_ID],[PLAN_CODE],[PLAN_NAME],[BRANCH_ID],[DEPT_ID],[EFFECT_DT],[PLAN_TYPE],[TOTAL_AMT],[APPROVE_VALUE],[VERSON],[YEAR],[STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PLAN_TYPE_ID],[COST_ID])VALUES(N'PLM000000347534',N'077000120',N'KẾ HOẠCH NGÂN SÁCH 2020',N'BRN000000001843',N'DEP000000251865',N'Oct 22 2020  1:52PM',N'',157000000.00,157000000.00,1,N'2020',N'1',N'',N'1',NULL,NULL,N'A',N'admin',N'Oct 22 2020  1:52PM',N'PLTYPE000000036',N'DM0000000000003')
INSERT INTO [PL_MASTER] ([PLAN_ID],[PLAN_CODE],[PLAN_NAME],[BRANCH_ID],[DEPT_ID],[EFFECT_DT],[PLAN_TYPE],[TOTAL_AMT],[APPROVE_VALUE],[VERSON],[YEAR],[STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PLAN_TYPE_ID],[COST_ID])VALUES(N'PLM000000347535',N'077000120',N'KẾ HOẠCH NGÂN SÁCH 2020',N'BRN000000001843',N'DEP000000251865',N'Oct 22 2020  1:52PM',N'',20600000.00,20600000.00,1,N'2020',N'1',N'',N'1',NULL,NULL,N'A',N'admin',N'Oct 22 2020  1:52PM',N'PLTYPE000000038',N'DM0000000000077')
INSERT INTO [PL_MASTER] ([PLAN_ID],[PLAN_CODE],[PLAN_NAME],[BRANCH_ID],[DEPT_ID],[EFFECT_DT],[PLAN_TYPE],[TOTAL_AMT],[APPROVE_VALUE],[VERSON],[YEAR],[STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PLAN_TYPE_ID],[COST_ID])VALUES(N'PLM000000347536',N'077000120',N'KẾ HOẠCH NGÂN SÁCH 2020',N'BRN000000001843',N'DEP000000251865',N'Oct 22 2020  1:52PM',N'',422958269.26,422958269.26,1,N'2020',N'1',N'',N'1',NULL,NULL,N'A',N'admin',N'Oct 22 2020  1:52PM',N'PLTYPE000000048',N'DM0000000000001')
INSERT INTO [PL_MASTER] ([PLAN_ID],[PLAN_CODE],[PLAN_NAME],[BRANCH_ID],[DEPT_ID],[EFFECT_DT],[PLAN_TYPE],[TOTAL_AMT],[APPROVE_VALUE],[VERSON],[YEAR],[STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PLAN_TYPE_ID],[COST_ID])VALUES(N'PLM000000347537',N'077000120',N'KẾ HOẠCH NGÂN SÁCH 2020',N'BRN000000001843',N'DEP000000251865',N'Oct 22 2020  1:53PM',N'',0.00,0.00,1,N'2020',N'1',N'',N'1',NULL,NULL,N'A',N'admin',N'Oct 22 2020  1:53PM',N'PLTYPE000000049',N'DM0000000000001')
INSERT INTO [PL_MASTER] ([PLAN_ID],[PLAN_CODE],[PLAN_NAME],[BRANCH_ID],[DEPT_ID],[EFFECT_DT],[PLAN_TYPE],[TOTAL_AMT],[APPROVE_VALUE],[VERSON],[YEAR],[STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PLAN_TYPE_ID],[COST_ID])VALUES(N'PLM000000347538',N'077000120',N'KẾ HOẠCH NGÂN SÁCH 2020',N'BRN000000001843',N'DEP000000251865',N'Oct 22 2020  1:53PM',N'',109773747.47,109773747.47,1,N'2020',N'1',N'',N'1',NULL,NULL,N'A',N'admin',N'Oct 22 2020  1:53PM',N'PLTYPE000000049',N'DM0000000000003')
INSERT INTO [PL_MASTER] ([PLAN_ID],[PLAN_CODE],[PLAN_NAME],[BRANCH_ID],[DEPT_ID],[EFFECT_DT],[PLAN_TYPE],[TOTAL_AMT],[APPROVE_VALUE],[VERSON],[YEAR],[STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PLAN_TYPE_ID],[COST_ID])VALUES(N'PLM000000347539',N'077000120',N'KẾ HOẠCH NGÂN SÁCH 2020',N'BRN000000001843',N'DEP000000251865',N'Oct 22 2020  1:53PM',N'',0.00,0.00,1,N'2020',N'1',N'',N'1',NULL,NULL,N'A',N'admin',N'Oct 22 2020  1:53PM',N'PLTYPE000000049',N'DM0000000000042')
INSERT INTO [PL_MASTER] ([PLAN_ID],[PLAN_CODE],[PLAN_NAME],[BRANCH_ID],[DEPT_ID],[EFFECT_DT],[PLAN_TYPE],[TOTAL_AMT],[APPROVE_VALUE],[VERSON],[YEAR],[STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PLAN_TYPE_ID],[COST_ID])VALUES(N'PLM000000347540',N'077000120',N'KẾ HOẠCH NGÂN SÁCH 2020',N'BRN000000001843',N'DEP000000251865',N'Oct 22 2020  1:53PM',N'',38159195.15,38159195.15,1,N'2020',N'1',N'',N'1',NULL,NULL,N'A',N'admin',N'Oct 22 2020  1:53PM',N'PLTYPE000000049',N'DM0000000000048')
INSERT INTO [PL_MASTER] ([PLAN_ID],[PLAN_CODE],[PLAN_NAME],[BRANCH_ID],[DEPT_ID],[EFFECT_DT],[PLAN_TYPE],[TOTAL_AMT],[APPROVE_VALUE],[VERSON],[YEAR],[STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PLAN_TYPE_ID],[COST_ID])VALUES(N'PLM000000347541',N'077000120',N'KẾ HOẠCH NGÂN SÁCH 2020',N'BRN000000001843',N'DEP000000251865',N'Oct 22 2020  1:53PM',N'',33290909.09,33290909.09,1,N'2020',N'1',N'',N'1',NULL,NULL,N'A',N'admin',N'Oct 22 2020  1:53PM',N'PLTYPE000000049',N'DM0000000000049')
INSERT INTO [PL_MASTER] ([PLAN_ID],[PLAN_CODE],[PLAN_NAME],[BRANCH_ID],[DEPT_ID],[EFFECT_DT],[PLAN_TYPE],[TOTAL_AMT],[APPROVE_VALUE],[VERSON],[YEAR],[STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PLAN_TYPE_ID],[COST_ID])VALUES(N'PLM000000347542',N'077000120',N'KẾ HOẠCH NGÂN SÁCH 2020',N'BRN000000001843',N'DEP000000251865',N'Oct 22 2020  1:53PM',N'',3583605.30,3583605.30,1,N'2020',N'1',N'',N'1',NULL,NULL,N'A',N'admin',N'Oct 22 2020  1:53PM',N'PLTYPE000000049',N'DM0000000000070')
INSERT INTO [PL_MASTER] ([PLAN_ID],[PLAN_CODE],[PLAN_NAME],[BRANCH_ID],[DEPT_ID],[EFFECT_DT],[PLAN_TYPE],[TOTAL_AMT],[APPROVE_VALUE],[VERSON],[YEAR],[STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PLAN_TYPE_ID],[COST_ID])VALUES(N'PLM000000347543',N'077000120',N'KẾ HOẠCH NGÂN SÁCH 2020',N'BRN000000001843',N'DEP000000251865',N'Oct 22 2020  1:53PM',N'',50349850.84,50349850.84,1,N'2020',N'1',N'',N'1',NULL,NULL,N'A',N'admin',N'Oct 22 2020  1:53PM',N'PLTYPE000000049',N'DVDM-CHUNG')
INSERT INTO [PL_MASTER] ([PLAN_ID],[PLAN_CODE],[PLAN_NAME],[BRANCH_ID],[DEPT_ID],[EFFECT_DT],[PLAN_TYPE],[TOTAL_AMT],[APPROVE_VALUE],[VERSON],[YEAR],[STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PLAN_TYPE_ID],[COST_ID])VALUES(N'PLM000000347544',N'077000120',N'KẾ HOẠCH NGÂN SÁCH 2020',N'BRN000000001843',N'DEP000000251865',N'Oct 22 2020  1:53PM',N'',134431621.62,134431621.62,1,N'2020',N'1',N'',N'1',NULL,NULL,N'A',N'admin',N'Oct 22 2020  1:53PM',N'PLTYPE000000050',NULL)
INSERT INTO [PL_MASTER] ([PLAN_ID],[PLAN_CODE],[PLAN_NAME],[BRANCH_ID],[DEPT_ID],[EFFECT_DT],[PLAN_TYPE],[TOTAL_AMT],[APPROVE_VALUE],[VERSON],[YEAR],[STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PLAN_TYPE_ID],[COST_ID])VALUES(N'PLM000000347545',N'077000120',N'KẾ HOẠCH NGÂN SÁCH 2020',N'BRN000000001843',N'DEP000000251865',N'Oct 22 2020  1:53PM',N'',148500000.00,148500000.00,1,N'2020',N'1',N'',N'1',NULL,NULL,N'A',N'admin',N'Oct 22 2020  1:53PM',N'PLTYPE000000050',N'DM0000000000003')
INSERT INTO [PL_MASTER] ([PLAN_ID],[PLAN_CODE],[PLAN_NAME],[BRANCH_ID],[DEPT_ID],[EFFECT_DT],[PLAN_TYPE],[TOTAL_AMT],[APPROVE_VALUE],[VERSON],[YEAR],[STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PLAN_TYPE_ID],[COST_ID])VALUES(N'PLM000000347546',N'077000120',N'KẾ HOẠCH NGÂN SÁCH 2020',N'BRN000000001843',N'DEP000000251865',N'Oct 22 2020  1:53PM',N'',0.00,0.00,1,N'2020',N'1',N'',N'1',NULL,NULL,N'A',N'admin',N'Oct 22 2020  1:53PM',N'PLTYPE000000051',N'DM0000000000048')

UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347531' WHERE TRADE_ID ='PLT000001071889'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347534' WHERE TRADE_ID ='PLT000001071913'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347537' WHERE TRADE_ID ='PLT000001010984'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347539' WHERE TRADE_ID ='PLT000001011359'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347532' WHERE TRADE_ID ='PLT000000071216'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347532' WHERE TRADE_ID ='PLT000000071238'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347533' WHERE TRADE_ID ='PLT000000071356'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347529' WHERE TRADE_ID ='PLT000001071872'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347535' WHERE TRADE_ID ='PLT000000072264'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347527' WHERE TRADE_ID ='PLT000001071838'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347527' WHERE TRADE_ID ='PLT000001071855'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347528' WHERE TRADE_ID ='PLT000001012720'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347530' WHERE TRADE_ID ='PLT000001012731'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347544' WHERE TRADE_ID ='PLT000001012200'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347541' WHERE TRADE_ID ='PLT000001011709'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347540' WHERE TRADE_ID ='PLT000001011366'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347540' WHERE TRADE_ID ='PLT000001011367'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347544' WHERE TRADE_ID ='PLT000001012201'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347544' WHERE TRADE_ID ='PLT000001012202'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347544' WHERE TRADE_ID ='PLT000001012203'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347528' WHERE TRADE_ID ='PLT000001012704'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347543' WHERE TRADE_ID ='PLT000001011835'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347542' WHERE TRADE_ID ='PLT000001011734'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347536' WHERE TRADE_ID ='PLT000001010916'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347536' WHERE TRADE_ID ='PLT000001010917'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347536' WHERE TRADE_ID ='PLT000001010918'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347536' WHERE TRADE_ID ='PLT000001010919'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347536' WHERE TRADE_ID ='PLT000001010920'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347536' WHERE TRADE_ID ='PLT000001010921'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347538' WHERE TRADE_ID ='PLT000001011243'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347538' WHERE TRADE_ID ='PLT000001011244'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347538' WHERE TRADE_ID ='PLT000001011245'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347538' WHERE TRADE_ID ='PLT000001011246'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347538' WHERE TRADE_ID ='PLT000001011247'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347538' WHERE TRADE_ID ='PLT000001011248'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347538' WHERE TRADE_ID ='PLT000001011249'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347538' WHERE TRADE_ID ='PLT000001011250'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347538' WHERE TRADE_ID ='PLT000001011251'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347538' WHERE TRADE_ID ='PLT000001011252'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347538' WHERE TRADE_ID ='PLT000001011253'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347538' WHERE TRADE_ID ='PLT000001011254'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347538' WHERE TRADE_ID ='PLT000001011255'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347538' WHERE TRADE_ID ='PLT000001011256'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347540' WHERE TRADE_ID ='PLT000001011599'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347540' WHERE TRADE_ID ='PLT000001011600'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347540' WHERE TRADE_ID ='PLT000001011601'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347540' WHERE TRADE_ID ='PLT000001011602'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347540' WHERE TRADE_ID ='PLT000001011603'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347540' WHERE TRADE_ID ='PLT000001011604'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347540' WHERE TRADE_ID ='PLT000001011605'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347540' WHERE TRADE_ID ='PLT000001011606'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347540' WHERE TRADE_ID ='PLT000001011607'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347540' WHERE TRADE_ID ='PLT000001011608'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347540' WHERE TRADE_ID ='PLT000001011609'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347545' WHERE TRADE_ID ='PLT000001012557'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347545' WHERE TRADE_ID ='PLT000001012558'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347545' WHERE TRADE_ID ='PLT000001012559'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347545' WHERE TRADE_ID ='PLT000001012560'
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID ='PLM000000347546' WHERE TRADE_ID ='PLT000001012657'