DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT

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'