INSERT INTO CM_DVDM (DVDM_ID, DVDM_CODE,DVDM_NAME,NOTES,RECORD_STATUS,AUTH_STATUS,MAKER_ID,CREATE_DT,EDITER_ID,EDIT_DT,CHECKER_ID,APPROVE_DT, IS_DVDM, IS_KHOI, IS_DVCM) VALUES ('DM0000000000078','89900001','PHONG PHAT TRIEN KINH DOANH NGAN HANG SO','PHONG PHAT TRIEN KINH DOANH NGAN HANG SO', '1','A','admin',GETDATE(),'admin',GETDATE(),1,0,1,0,0) INSERT INTO PL_COSTCENTER (COST_ID,COST_CODE,COST_NAME,RECORD_STATUS,AUTH_STATUS,MAKER_ID,CREATE_DT,DVDM_ID) VALUES ('PLCC00000001003','89900001','PHONG PHAT TRIEN KINH DOANH NGAN HANG SO','1','A','admin',GETDATE(),'DM0000000000078') INSERT INTO PL_COSTCENTER_DT(COSTDT_ID,COST_ID,BRANCH_ID,DEP_ID,RECORD_STATUS,MAKER_ID,CREATE_DT) VALUES ('PCDT00000001014','PLCC00000001003','DV0001','DEP000000252203','1','admin',GETDATE()) UPDATE CM_DVDM SET DVDM_CODE ='8990000', DVDM_NAME ='TRUNG TAM NGAN HANG SO' WHERE DVDM_ID ='DM0000000000034'