DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

INSERT INTO [TL_USER] ([ID],[TLID],[TLNANME],[Password],[TLFullName],[TLSUBBRID],[BRANCH_NAME],[BRANCH_TYPE],[RoleName],[EMAIL],[ADDRESS],[PHONE],[AUTH_STATUS],[MARKER_ID],[AUTH_ID],[APPROVE_DT],[ISAPPROVE],[Birthday],[ISFIRSTTIME],[SECUR_CODE],[AccessFailedCount],[AuthenticationSource],[ConcurrencyStamp],[CreatorUserId],[DeleterUserId],[EmailAddress],[EmailConfirmationCode],[IsActive],[IsDeleted],[IsEmailConfirmed],[IsLockoutEnabled],[IsPhoneNumberConfirmed],[IsTwoFactorEnabled],[LastModifierUserId],[LockoutEndDateUtc],[Name],[NormalizedEmailAddress],[NormalizedUserName],[PasswordResetCode],[PhoneNumber],[ProfilePictureId],[SecurityStamp],[ShouldChangePasswordOnNextLogin],[Surname],[TenantId],[SignInToken],[SignInTokenExpireTimeUtc],[GoogleAuthenticatorKey],[SendActivationEmail],[DEP_ID],[CreationTime],[UamFullName],[UamEmployeeId],[UamCompanyCode],[UamWfDataId],[UamCompanyName],[UamJobTitle])VALUES(4022,NULL,N'nguyennhk',N'AQAAAAEAACcQAAAAEC2mw6zPd1C92vLHEulsmN0olmIstjP7RrBb4WSUQG4BLFnPI7re3R7Uhmsa9+kI/A==',N'Nguyen Nguyen Hoang Khanh',N'DV0001',N'Hội sở',N'HS',NULL,N'nguyennhk@vietcapitalbank.com.vn',NULL,NULL,N'A',N'baotq',NULL,NULL,NULL,NULL,NULL,N'DEP000000000014',1,NULL,N'4c72f4f3-14f4-4a42-8944-7a9c42e4d8d1',367,NULL,N'nguyennhk@vietcapitalbank.com.vn',NULL,1,0,0,1,0,1,NULL,NULL,NULL,N'NGUYENNHK@VIETCAPITALBANK.COM.VN',N'NGUYENNHK',NULL,N'0933748575',NULL,N'Z5XNPSIVK7MTIFWZZLXWBPCULLCFQCH3',1,NULL,1,NULL,NULL,NULL,0,N'DEP000000000014',N'Oct 24 2022 8:52AM',NULL,NULL,NULL,NULL,NULL,NULL)

column1

INSERT INTO [AbpUserRoles] ([Id],[CreationTime],[CreatorUserId],[RoleId],[TenantId],[UserId])VALUES(14130,N'2022-10-24 08:52:48.0002597',367,59,1,4022)

column1

INSERT INTO [CM_EMPLOYEE] ([EMP_ID],[EMP_CODE],[EMP_NAME],[BRANCH_ID],[DEP_ID],[NOTES],[RECORD_STATUS],[AUTH_STATUS],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT])VALUES(N'EMP000000257171',N'06508',N'Nguyễn Hoàng Khánh Nguyên',N'DV0001',N'DEP000000000014',NULL,N'1',N'U',N'baotq',N'Oct 24 2022 8:57AM',NULL,NULL)

column1

INSERT INTO [CM_EMPLOYEE_LOG] ([ID],[EMP_CODE],[EMP_NAME],[BRANCH_CODE],[DEP_CODE],[USER_DOMAIN],[POS_CODE],[POS_NAME],[CREATE_DT])VALUES(19343,N'06508',N'Nguyễn Hoàng Khánh Nguyên',N'069',N'HC-01',N'nguyennhk',N'H13021718',N'Chuyên viên Mua sắm và cung ứng',N'Oct 24 2022 8:51AM')