DELETE FROM TL_SYSROLE_LIMIT  WHERE LIMIT_TYPE='DCNS'
INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LM000012',N'GDK',150000000,N'GDK_DC',N'admin',N'U',NULL,NULL,NULL,N'1',N'DCNS',2,NULL)
INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LM000013',N'PTGD',150000000,N'PTGD_DC',N'admin',N'U',NULL,NULL,NULL,N'2',N'DCNS',2,NULL)
INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LM000014',N'TGD',NULL,N'TGD_DC',N'admin',N'U',NULL,NULL,NULL,N'3',N'DCNS',NULL,NULL)
INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LMI00014',N'GDDV',20000000,N'',N'',N'',N'',N'Nov 30 2020 10:33AM',N'',N'',N'DCNS',30,N'')
     

INSERT dbo.SYS_PREFIX
(
    ID,
    Prefix,
    Description
)
VALUES
(   'LIMIT_ACCUMULATE', -- ID - varchar(100)
    'LMAC', -- Prefix - varchar(10)
    N'' -- Description - nvarchar(1000)
    )