UPDATE dbo.CM_DVDM SET IS_DVDM=1 WHERE  DVDM_CODE='0692101'
UPDATE dbo.CM_DVDM SET IS_DVDM=1 WHERE  DVDM_CODE='0692201'
UPDATE dbo.CM_DVDM SET IS_DVDM=1 WHERE  DVDM_CODE='0690803'
UPDATE dbo.CM_DVDM SET IS_DVDM=1 WHERE  DVDM_CODE='0690404'

INSERT INTO [CM_PLAN_TYPE] ([PLAN_TYPE_ID],[PLAN_TYPE_CODE],[PLAN_TYPE_NAME],[NOTES],[RECORD_STATUS],[AUTH_STATUS],[MAKER_ID],[CREATE_DT],[EDITER_ID],[EDIT_DT],[CHECKER_ID],[APPROVE_DT])VALUES(N'PLTYPE000000048',N'L02-NV-01',N'Chi phí nhân viên',NULL,N'1',N'A',N'luctv',NULL,N'luctv',NULL,N'tscd_hoiso',NULL)
INSERT INTO [CM_PLAN_TYPE] ([PLAN_TYPE_ID],[PLAN_TYPE_CODE],[PLAN_TYPE_NAME],[NOTES],[RECORD_STATUS],[AUTH_STATUS],[MAKER_ID],[CREATE_DT],[EDITER_ID],[EDIT_DT],[CHECKER_ID],[APPROVE_DT])VALUES(N'PLTYPE000000049',N'L02-QL-01',N'Chi hoạt động quản lý và công cụ',NULL,N'1',N'A',N'luctv',NULL,N'luctv',NULL,N'tscd_hoiso',NULL)
INSERT INTO [CM_PLAN_TYPE] ([PLAN_TYPE_ID],[PLAN_TYPE_CODE],[PLAN_TYPE_NAME],[NOTES],[RECORD_STATUS],[AUTH_STATUS],[MAKER_ID],[CREATE_DT],[EDITER_ID],[EDIT_DT],[CHECKER_ID],[APPROVE_DT])VALUES(N'PLTYPE000000050',N'L02-TS-01',N'Chi về tài sản',NULL,N'1',N'A',N'luctv',NULL,N'luctv',NULL,N'tscd_hoiso',NULL)
INSERT INTO [CM_PLAN_TYPE] ([PLAN_TYPE_ID],[PLAN_TYPE_CODE],[PLAN_TYPE_NAME],[NOTES],[RECORD_STATUS],[AUTH_STATUS],[MAKER_ID],[CREATE_DT],[EDITER_ID],[EDIT_DT],[CHECKER_ID],[APPROVE_DT])VALUES(N'PLTYPE000000051',N'L02-TG-01',N'Chi về bảo hiểm tiền gửi  ',NULL,N'1',N'A',N'luctv',NULL,N'luctv',NULL,N'tscd_hoiso',NULL)


INSERT INTO [CM_BRANCH] ([BRANCH_ID],[FATHER_ID],[IS_POTENTIAL],[BRANCH_CODE],[BRANCH_NAME],[DAO_CODE],[DAO_NAME],[REGION_ID],[BRANCH_TYPE],[ADDR],[PROVICE],[TEL],[TAX_NO],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT])VALUES(N'BRN000000005852',N'DV0002',N'N',N'0800',N'NGAN HANG SO',NULL,NULL,N'REG000000000004',N'HS',N'',NULL,N'',N'',N'',N'1',N'tscd_hoiso',N'Aug  3 2020 10:14PM',N'A',NULL,NULL)
INSERT INTO [CM_BRANCH] ([BRANCH_ID],[FATHER_ID],[IS_POTENTIAL],[BRANCH_CODE],[BRANCH_NAME],[DAO_CODE],[DAO_NAME],[REGION_ID],[BRANCH_TYPE],[ADDR],[PROVICE],[TEL],[TAX_NO],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT])VALUES(N'BRN000000005853',N'DV0002',N'N',N'0801',N'DIGIBANK',NULL,NULL,N'REG000000000004',N'HS',N'',NULL,N'',N'',N'',N'1',N'tscd_hoiso',N'Aug  3 2020 10:14PM',N'A',NULL,NULL)

INSERT INTO [CM_DEPARTMENT] ([DEP_ID],[DEP_CODE],[DEP_NAME],[DAO_CODE],[DAO_NAME],[BRANCH_ID],[GROUP_ID],[TEL],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT])VALUES(N'DEP000000005836',N'08010001',N'DIGIBANK',NULL,N'DIGIBANK',N'BRN000000005853',N'',N'',N'',N'1',N'tscd_hoiso',N'Aug  3 2020 10:18PM',N'U',NULL,N'Jan  1 1900 12:00AM')
INSERT INTO [CM_DEPARTMENT] ([DEP_ID],[DEP_CODE],[DEP_NAME],[DAO_CODE],[DAO_NAME],[BRANCH_ID],[GROUP_ID],[TEL],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT])VALUES(N'DEP000000005837',N'08000001',N'NGAN HANG SO',NULL,N'NHS',N'BRN000000005852',N'',N'',N'',N'1',N'tscd_hoiso',N'Aug  3 2020 10:19PM',N'U',NULL,N'Jan  1 1900 12:00AM')