USE [payroll]
GO
/****** Object:  Table [dbo].[Menu]    Script Date: 2/20/2024 4:37:06 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Menu](
	[MenuId] [int] IDENTITY(1,1) NOT NULL,
	[Menu] [varchar](50) NULL,
	[status] [numeric](18, 0) NULL,
 CONSTRAINT [PK_Menu] PRIMARY KEY CLUSTERED 
(
	[MenuId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Permissions]    Script Date: 2/20/2024 4:37:06 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Permissions](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[RoleId] [numeric](18, 0) NOT NULL,
	[MenuId] [numeric](18, 0) NOT NULL,
	[SubmenuId] [numeric](18, 0) NOT NULL,
	[MenuStatus] [int] NULL,
	[SubmenuStatus] [int] NULL,
	[can_view] [int] NULL,
	[can_add] [int] NULL,
	[can_edit] [int] NULL,
	[can_delete] [int] NULL,
	[can_assign] [int] NULL,
 CONSTRAINT [PK_Permissions] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Roles]    Script Date: 2/20/2024 4:37:06 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Roles](
	[RoleId] [int] IDENTITY(1,1) NOT NULL,
	[RoleName] [varchar](50) NULL,
	[status] [numeric](18, 0) NULL,
	[CompanyId] [numeric](18, 0) NULL,
 CONSTRAINT [PK_Roles] PRIMARY KEY CLUSTERED 
(
	[RoleId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Submenu]    Script Date: 2/20/2024 4:37:06 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Submenu](
	[SubmenuId] [int] IDENTITY(1,1) NOT NULL,
	[ParentId] [numeric](18, 0) NOT NULL,
	[SubmenuName] [varchar](50) NULL,
	[status] [numeric](18, 0) NULL,
	[enable_view] [int] NULL,
	[enable_add] [int] NULL,
	[enable_edit] [int] NULL,
	[enable_delete] [int] NULL,
 CONSTRAINT [PK_Submenu] PRIMARY KEY CLUSTERED 
(
	[SubmenuId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Menu] ON 

INSERT [dbo].[Menu] ([MenuId], [Menu], [status]) VALUES (1, N'Admin', CAST(1 AS Numeric(18, 0)))
INSERT [dbo].[Menu] ([MenuId], [Menu], [status]) VALUES (2, N'Employees', CAST(1 AS Numeric(18, 0)))
INSERT [dbo].[Menu] ([MenuId], [Menu], [status]) VALUES (3, N'Transactions', CAST(1 AS Numeric(18, 0)))
INSERT [dbo].[Menu] ([MenuId], [Menu], [status]) VALUES (4, N'Payroll Process', CAST(1 AS Numeric(18, 0)))
INSERT [dbo].[Menu] ([MenuId], [Menu], [status]) VALUES (5, N'Reports', CAST(1 AS Numeric(18, 0)))
INSERT [dbo].[Menu] ([MenuId], [Menu], [status]) VALUES (6, N'Utilities', CAST(1 AS Numeric(18, 0)))
SET IDENTITY_INSERT [dbo].[Menu] OFF
GO
SET IDENTITY_INSERT [dbo].[Permissions] ON 

INSERT [dbo].[Permissions] ([Id], [RoleId], [MenuId], [SubmenuId], [MenuStatus], [SubmenuStatus], [can_view], [can_add], [can_edit], [can_delete], [can_assign]) VALUES (1, CAST(1 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1, 1, 1, NULL)
INSERT [dbo].[Permissions] ([Id], [RoleId], [MenuId], [SubmenuId], [MenuStatus], [SubmenuStatus], [can_view], [can_add], [can_edit], [can_delete], [can_assign]) VALUES (2, CAST(1 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(2 AS Numeric(18, 0)), 1, 1, 1, 1, 1, 1, NULL)
INSERT [dbo].[Permissions] ([Id], [RoleId], [MenuId], [SubmenuId], [MenuStatus], [SubmenuStatus], [can_view], [can_add], [can_edit], [can_delete], [can_assign]) VALUES (3, CAST(1 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(3 AS Numeric(18, 0)), 1, 1, 1, 1, 1, 1, NULL)
INSERT [dbo].[Permissions] ([Id], [RoleId], [MenuId], [SubmenuId], [MenuStatus], [SubmenuStatus], [can_view], [can_add], [can_edit], [can_delete], [can_assign]) VALUES (4, CAST(1 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(4 AS Numeric(18, 0)), 1, 1, 1, 1, 1, 1, NULL)
INSERT [dbo].[Permissions] ([Id], [RoleId], [MenuId], [SubmenuId], [MenuStatus], [SubmenuStatus], [can_view], [can_add], [can_edit], [can_delete], [can_assign]) VALUES (5, CAST(1 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(5 AS Numeric(18, 0)), 1, 1, 1, 1, 1, 1, NULL)
INSERT [dbo].[Permissions] ([Id], [RoleId], [MenuId], [SubmenuId], [MenuStatus], [SubmenuStatus], [can_view], [can_add], [can_edit], [can_delete], [can_assign]) VALUES (6, CAST(1 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(6 AS Numeric(18, 0)), 1, 1, 1, 1, 1, 1, NULL)
INSERT [dbo].[Permissions] ([Id], [RoleId], [MenuId], [SubmenuId], [MenuStatus], [SubmenuStatus], [can_view], [can_add], [can_edit], [can_delete], [can_assign]) VALUES (7, CAST(1 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(7 AS Numeric(18, 0)), 1, 1, 1, 1, 1, 1, NULL)
INSERT [dbo].[Permissions] ([Id], [RoleId], [MenuId], [SubmenuId], [MenuStatus], [SubmenuStatus], [can_view], [can_add], [can_edit], [can_delete], [can_assign]) VALUES (8, CAST(1 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(8 AS Numeric(18, 0)), 1, 1, 1, 1, 1, 1, NULL)
INSERT [dbo].[Permissions] ([Id], [RoleId], [MenuId], [SubmenuId], [MenuStatus], [SubmenuStatus], [can_view], [can_add], [can_edit], [can_delete], [can_assign]) VALUES (9, CAST(1 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(9 AS Numeric(18, 0)), 1, 1, 1, 1, 1, 1, NULL)
INSERT [dbo].[Permissions] ([Id], [RoleId], [MenuId], [SubmenuId], [MenuStatus], [SubmenuStatus], [can_view], [can_add], [can_edit], [can_delete], [can_assign]) VALUES (10, CAST(1 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(10 AS Numeric(18, 0)), 1, 1, 1, 1, 1, 1, NULL)
INSERT [dbo].[Permissions] ([Id], [RoleId], [MenuId], [SubmenuId], [MenuStatus], [SubmenuStatus], [can_view], [can_add], [can_edit], [can_delete], [can_assign]) VALUES (11, CAST(1 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(11 AS Numeric(18, 0)), 1, 1, 1, 1, 1, 1, NULL)
INSERT [dbo].[Permissions] ([Id], [RoleId], [MenuId], [SubmenuId], [MenuStatus], [SubmenuStatus], [can_view], [can_add], [can_edit], [can_delete], [can_assign]) VALUES (12, CAST(1 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(12 AS Numeric(18, 0)), 1, 1, 1, 1, 1, 1, NULL)
INSERT [dbo].[Permissions] ([Id], [RoleId], [MenuId], [SubmenuId], [MenuStatus], [SubmenuStatus], [can_view], [can_add], [can_edit], [can_delete], [can_assign]) VALUES (13, CAST(1 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(13 AS Numeric(18, 0)), 1, 1, 1, 1, 1, 1, NULL)
INSERT [dbo].[Permissions] ([Id], [RoleId], [MenuId], [SubmenuId], [MenuStatus], [SubmenuStatus], [can_view], [can_add], [can_edit], [can_delete], [can_assign]) VALUES (14, CAST(1 AS Numeric(18, 0)), CAST(5 AS Numeric(18, 0)), CAST(51 AS Numeric(18, 0)), 1, 1, 1, 1, 1, 1, NULL)
SET IDENTITY_INSERT [dbo].[Permissions] OFF
GO
SET IDENTITY_INSERT [dbo].[Roles] ON 

INSERT [dbo].[Roles] ([RoleId], [RoleName], [status], [CompanyId]) VALUES (1, N'Accountant', CAST(1 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)))
INSERT [dbo].[Roles] ([RoleId], [RoleName], [status], [CompanyId]) VALUES (2, N'Admin', CAST(1 AS Numeric(18, 0)), CAST(2 AS Numeric(18, 0)))
INSERT [dbo].[Roles] ([RoleId], [RoleName], [status], [CompanyId]) VALUES (3, N'Superadmin', CAST(1 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)))
SET IDENTITY_INSERT [dbo].[Roles] OFF
GO
SET IDENTITY_INSERT [dbo].[Submenu] ON 

INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (1, CAST(1 AS Numeric(18, 0)), N'Nationality', CAST(1 AS Numeric(18, 0)), 1, 1, 0, 0)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (2, CAST(1 AS Numeric(18, 0)), N'Religion', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (3, CAST(1 AS Numeric(18, 0)), N'Pension', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (4, CAST(1 AS Numeric(18, 0)), N'Bank', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (5, CAST(1 AS Numeric(18, 0)), N'Branch', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (6, CAST(1 AS Numeric(18, 0)), N'Department', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (7, CAST(1 AS Numeric(18, 0)), N'Designation', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (8, CAST(1 AS Numeric(18, 0)), N'Main Division', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (9, CAST(1 AS Numeric(18, 0)), N'Sub Division', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (10, CAST(1 AS Numeric(18, 0)), N'Loan Type', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (11, CAST(1 AS Numeric(18, 0)), N'Leave Type', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (12, CAST(1 AS Numeric(18, 0)), N'Deductions', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (13, CAST(1 AS Numeric(18, 0)), N'Payments', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (14, CAST(1 AS Numeric(18, 0)), N'Company Payment Details', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (15, CAST(1 AS Numeric(18, 0)), N'Tax Rate Type', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (16, CAST(1 AS Numeric(18, 0)), N'Type of Terminations', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (17, CAST(1 AS Numeric(18, 0)), N'Tax Table', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (18, CAST(1 AS Numeric(18, 0)), N'Overtime Rate', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (19, CAST(1 AS Numeric(18, 0)), N'SDL', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (20, CAST(1 AS Numeric(18, 0)), N'WH Tax Rate', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (21, CAST(1 AS Numeric(18, 0)), N'WCF Rate', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (22, CAST(1 AS Numeric(18, 0)), N'Housing Rate', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (23, CAST(1 AS Numeric(18, 0)), N'NHIF', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (24, CAST(1 AS Numeric(18, 0)), N'Company Setup', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (25, CAST(1 AS Numeric(18, 0)), N'Contract Clause', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (26, CAST(1 AS Numeric(18, 0)), N'Holiday', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (27, CAST(1 AS Numeric(18, 0)), N'Formula', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (28, CAST(1 AS Numeric(18, 0)), N'Shift Timings', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (29, CAST(1 AS Numeric(18, 0)), N'Menu', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (30, CAST(1 AS Numeric(18, 0)), N'Submenu', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (31, CAST(1 AS Numeric(18, 0)), N'Roles', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (32, CAST(2 AS Numeric(18, 0)), N'Employees', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (33, CAST(3 AS Numeric(18, 0)), N'Loan', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (34, CAST(3 AS Numeric(18, 0)), N'Leaves', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (35, CAST(3 AS Numeric(18, 0)), N'Advance Salary', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (36, CAST(3 AS Numeric(18, 0)), N'Overtime', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (37, CAST(3 AS Numeric(18, 0)), N'Absent & Late', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (38, CAST(3 AS Numeric(18, 0)), N'Dynamic Payments', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (39, CAST(3 AS Numeric(18, 0)), N'Dynamic Deductions', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (40, CAST(3 AS Numeric(18, 0)), N'Casual Transactions', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (41, CAST(4 AS Numeric(18, 0)), N'Payroll Process', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (42, CAST(5 AS Numeric(18, 0)), N'Payslips', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (43, CAST(5 AS Numeric(18, 0)), N'Salary Summary', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (44, CAST(5 AS Numeric(18, 0)), N'Payment Reports', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (45, CAST(5 AS Numeric(18, 0)), N'Deduction Reports', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (46, CAST(5 AS Numeric(18, 0)), N'Employees Reports', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (47, CAST(5 AS Numeric(18, 0)), N'Monthly Reports', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (48, CAST(5 AS Numeric(18, 0)), N'Yearly Reports', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (49, CAST(5 AS Numeric(18, 0)), N'Export to Excel', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (50, CAST(5 AS Numeric(18, 0)), N'Cash Salary Reports', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
INSERT [dbo].[Submenu] ([SubmenuId], [ParentId], [SubmenuName], [status], [enable_view], [enable_add], [enable_edit], [enable_delete]) VALUES (51, CAST(5 AS Numeric(18, 0)), N'Bank Salary Reports', CAST(1 AS Numeric(18, 0)), 1, 1, 1, 1)
SET IDENTITY_INSERT [dbo].[Submenu] OFF
GO
