|
1
|
UPDATE dbo.CM_DVDM SET IS_DVDM=1 WHERE DVDM_CODE='0692101'
|
|
2
|
UPDATE dbo.CM_DVDM SET IS_DVDM=1 WHERE DVDM_CODE='0692201'
|
|
3
|
UPDATE dbo.CM_DVDM SET IS_DVDM=1 WHERE DVDM_CODE='0690803'
|
|
4
|
UPDATE dbo.CM_DVDM SET IS_DVDM=1 WHERE DVDM_CODE='0690404'
|
|
5
|
|
|
6
|
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)
|
|
7
|
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)
|
|
8
|
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)
|
|
9
|
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)
|
|
10
|
|
|
11
|
|
|
12
|
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)
|
|
13
|
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)
|
|
14
|
|
|
15
|
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')
|
|
16
|
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')
|