|
1
|
|
|
2
|
UPDATE dbo.SYS_GROUP_LIMIT SET IS_HO=0
|
|
3
|
UPDATE dbo.SYS_GROUP_LIMIT SET IS_HO=1 WHERE GROUP_CODE='I.1.1.A'
|
|
4
|
UPDATE dbo.SYS_GROUP_LIMIT SET IS_HO=1 WHERE GROUP_CODE='I.3.1'
|
|
5
|
INSERT [dbo].[SYS_GROUP_LIMIT_DT] ([GROUD_LM_DTID], [GROUP_LM_ID], [ROLE_ID], [VALUE_LIMIT], [BRANCH_ID], [DVDM_ID]) VALUES (N'SGLDT0000000523', N'SGL000000000099', N'PTGD', CAST(300000000 AS Decimal(18, 0)), N'', N'DM0000000000015')
|
|
6
|
INSERT [dbo].[SYS_GROUP_LIMIT_DT] ([GROUD_LM_DTID], [GROUP_LM_ID], [ROLE_ID], [VALUE_LIMIT], [BRANCH_ID], [DVDM_ID]) VALUES (N'SGLDT0000000524', N'SGL000000000099', N'GDK', CAST(100000000 AS Decimal(18, 0)), N'', N'DM0000000000015')
|
|
7
|
INSERT [dbo].[SYS_GROUP_LIMIT_DT] ([GROUD_LM_DTID], [GROUP_LM_ID], [ROLE_ID], [VALUE_LIMIT], [BRANCH_ID], [DVDM_ID]) VALUES (N'SGLDT0000000525', N'SGL000000000099', N'GDDV', CAST(-1 AS Decimal(18, 0)), N'DV0001', N'')
|
|
8
|
INSERT [dbo].[SYS_GROUP_LIMIT_DT] ([GROUD_LM_DTID], [GROUP_LM_ID], [ROLE_ID], [VALUE_LIMIT], [BRANCH_ID], [DVDM_ID]) VALUES (N'SGLDT0000000526', N'SGL000000000100', N'TGD', CAST(1000000000 AS Decimal(18, 0)), N'', N'')
|
|
9
|
INSERT [dbo].[SYS_GROUP_LIMIT_DT] ([GROUD_LM_DTID], [GROUP_LM_ID], [ROLE_ID], [VALUE_LIMIT], [BRANCH_ID], [DVDM_ID]) VALUES (N'SGLDT0000000527', N'SGL000000000100', N'PTGD', CAST(-1 AS Decimal(18, 0)), N'', N'DM0000000000015')
|
|
10
|
INSERT [dbo].[SYS_GROUP_LIMIT_DT] ([GROUD_LM_DTID], [GROUP_LM_ID], [ROLE_ID], [VALUE_LIMIT], [BRANCH_ID], [DVDM_ID]) VALUES (N'SGLDT0000000528', N'SGL000000000100', N'GDK', CAST(-1 AS Decimal(18, 0)), N'', N'DM0000000000015')
|
|
11
|
INSERT [dbo].[SYS_GROUP_LIMIT_DT] ([GROUD_LM_DTID], [GROUP_LM_ID], [ROLE_ID], [VALUE_LIMIT], [BRANCH_ID], [DVDM_ID]) VALUES (N'SGLDT0000000529', N'SGL000000000100', N'GDDV', CAST(-1 AS Decimal(18, 0)), N'DV0001', N'')
|
|
12
|
INSERT [dbo].[SYS_GROUP_LIMIT_DT] ([GROUD_LM_DTID], [GROUP_LM_ID], [ROLE_ID], [VALUE_LIMIT], [BRANCH_ID], [DVDM_ID]) VALUES (N'SGLDT0000000530', N'SGL000000000101', N'TGD', CAST(2000000000 AS Decimal(18, 0)), N'', N'')
|
|
13
|
INSERT [dbo].[SYS_GROUP_LIMIT_DT] ([GROUD_LM_DTID], [GROUP_LM_ID], [ROLE_ID], [VALUE_LIMIT], [BRANCH_ID], [DVDM_ID]) VALUES (N'SGLDT0000000531', N'SGL000000000101', N'PTGD', CAST(300000000 AS Decimal(18, 0)), N'', N'DM0000000000015')
|
|
14
|
INSERT [dbo].[SYS_GROUP_LIMIT_DT] ([GROUD_LM_DTID], [GROUP_LM_ID], [ROLE_ID], [VALUE_LIMIT], [BRANCH_ID], [DVDM_ID]) VALUES (N'SGLDT0000000532', N'SGL000000000101', N'GDK', CAST(100000000 AS Decimal(18, 0)), N'', N'DM0000000000015')
|
|
15
|
INSERT [dbo].[SYS_GROUP_LIMIT_DT] ([GROUD_LM_DTID], [GROUP_LM_ID], [ROLE_ID], [VALUE_LIMIT], [BRANCH_ID], [DVDM_ID]) VALUES (N'SGLDT0000000533', N'SGL000000000101', N'GDDV', CAST(-1 AS Decimal(18, 0)), N'DV0001', N'')
|