﻿-------------------------------- AK 2025-01-28 --------------------
SET IDENTITY_INSERT [dbo].[LookupTables] ON 
GO
INSERT [dbo].[LookupTables] ([LookupTableId], [TableName], [ControllerName], [ActionName], [DataValueField], [DataTextFieldEn], [DataTextFieldAr]) VALUES (10, N'FinancialYears', N'GenerlLedger/FinancialYears', N'GetFinancialYearForList', N'FinancialYearCode', N'Name', N'Arabic_Name')
GO
INSERT [dbo].[LookupTables] ([LookupTableId], [TableName], [ControllerName], [ActionName], [DataValueField], [DataTextFieldEn], [DataTextFieldAr]) VALUES (11, N'JournalType', N'GenerlLedger/JournalType', N'GetJournalType', N'JournalTypeCode', N'Name', N'Arabic_Name')
GO
INSERT [dbo].[LookupTables] ([LookupTableId], [TableName], [ControllerName], [ActionName], [DataValueField], [DataTextFieldEn], [DataTextFieldAr]) VALUES (12, N'AccountsChart', N'GenerlLedger/AccountsChart', N'GetAccountsChart', N'AccountsChartCode', N'Name', N'Arabic_Name')
GO
INSERT [dbo].[LookupTables] ([LookupTableId], [TableName], [ControllerName], [ActionName], [DataValueField], [DataTextFieldEn], [DataTextFieldAr]) VALUES (13, N'CostCenterChart', N'GenerlLedger/CostCenterChart', N'GetCostCenterChartsNotMain', N'CostCenterChartCode', N'Name', N'Arabic_Name')
GO
INSERT [dbo].[LookupTables] ([LookupTableId], [TableName], [ControllerName], [ActionName], [DataValueField], [DataTextFieldEn], [DataTextFieldAr]) VALUES (14, N'Safes', N'GenerlLedger/safe', N'GetSafe', N'SafeCode', N'Name', N'Arabic_Name')
GO
INSERT [dbo].[LookupTables] ([LookupTableId], [TableName], [ControllerName], [ActionName], [DataValueField], [DataTextFieldEn], [DataTextFieldAr]) VALUES (15, N'BanksAccounts', N'GenerlLedger/Bank', N'GetBankForList', N'BanksAccountCode', N'Name', N'Arabic_Name')
GO
INSERT [dbo].[LookupTables] ([LookupTableId], [TableName], [ControllerName], [ActionName], [DataValueField], [DataTextFieldEn], [DataTextFieldAr]) VALUES (16, N'Supplier', N'GenerlLedger/Supplier', N'GetListSuppliers', N'SupplierCode', N'Name', N'Arabic_Name')
GO
INSERT [dbo].[LookupTables] ([LookupTableId], [TableName], [ControllerName], [ActionName], [DataValueField], [DataTextFieldEn], [DataTextFieldAr]) VALUES (17, N'Customers', N'GenerlLedger/Customer', N'GetListCustomers', N'SupplierCode', N'Name', N'Arabic_Name')
GO
INSERT [dbo].[LookupTables] ([LookupTableId], [TableName], [ControllerName], [ActionName], [DataValueField], [DataTextFieldEn], [DataTextFieldAr]) VALUES (18, N'Expenses', N'GenerlLedger/Expense', N'GetExpensesByCategoryCode', N'ExpenseCode', N'Name', N'Arabic_Name')
GO
INSERT [dbo].[LookupTables] ([LookupTableId], [TableName], [ControllerName], [ActionName], [DataValueField], [DataTextFieldEn], [DataTextFieldAr]) VALUES (19, N'JournalHeaders', N'GenerlLedger/JournalHeader', N'GetJournalStatus', N'LookupCode', N'LookupName', N'LookupName')
GO
INSERT [dbo].[LookupTables] ([LookupTableId], [TableName], [ControllerName], [ActionName], [DataValueField], [DataTextFieldEn], [DataTextFieldAr]) VALUES (20, N'JournalFooters', N'GenerlLedger/AccountsChart', N'GetAccountsChart', N'AccountsChartCode', N'Name', N'Arabic_Name')
GO
SET IDENTITY_INSERT [dbo].[LookupTables] OFF
GO

INSERT INTO [SystemMenu](SystemMenuCode,Name,Arabic_Name,ParentID,ControllerName,ActionName,ImageURL,HTTPMethod,Sequence,IsVisible,ShowInPrivilegePage) VALUES (1146,N'Reports',N'التقارير',583,N'/',N'NULL',N'fa fa-thumb-tack',N'NULL',4,1,1)
GO
INSERT INTO [SystemMenu](SystemMenuCode,Name,Arabic_Name,ParentID,ControllerName,ActionName,ImageURL,HTTPMethod,Sequence,IsVisible,ShowInPrivilegePage) VALUES (1147,N'Reports Consolidated ',N'التقارير المجمعة',1146,N'/GenerlLedger/ReportsConsolidated',N'Index',N'fa fa-thumb-tack',N'get',1,1,1)
GO
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1146,18)
GO
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1147,18)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (23207,N'التقارير',N'Reports',1146,1)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (23208,N'التقارير المجمعة',N'Reports Consolidated ',1147,1)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (23209,N'ميزان المراجعة',N'Trial Balance',1147,2)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (23210,N'ميزان المراجعة تفصيلي',N'Trial Balance details',1147,2)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (23211,N'الأستاذ العام',N'General Ledger',1147,2)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (23212,N'الأستاذ العام تفصيلي',N'Subsidiary Ledger',1147,2)
GO
BEGIN TRANSACTION
GO
ALTER TABLE dbo.Reports ADD
	SystemMenuCode int NULL,
	SecurityPrivilegeCode int NULL
GO
ALTER TABLE dbo.Reports SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
UPDATE SystemMenu SET Sequence=0 WHERE SystemMenuCode=584
GO
UPDATE SystemMenu SET Sequence=5 WHERE SystemMenuCode=596
GO
UPDATE SystemMenu SET Sequence=10 WHERE SystemMenuCode=1144
GO
UPDATE SystemMenu SET Sequence=15 WHERE SystemMenuCode=609
GO
UPDATE SystemMenu SET Sequence=20 WHERE SystemMenuCode=607
GO
UPDATE SystemMenu SET Sequence=25 WHERE SystemMenuCode=1124
GO
UPDATE SystemMenu SET Sequence=30 WHERE SystemMenuCode=1146
GO
----------------------------------------- AK 2025-01-28 --------------------- 
----------------------------------------- Hammad 2025-01-29 -----------------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription])
VALUES (N'WFDelegationByDivision', N'Add Delegation Depend On Delgator Division', N'   الاعتماد على القطاع فى إضافة التفويض     ', N'false', 2, 22, 1, 1, NULL, NULL, 0, N' الاعتماد على القطاع فى إضافة التفويض    ')
GO
ALTER TABLE dbo.TermsAndConditions ADD
	Attachment nvarchar(250) NULL
GO
----------------------------------------- End 2025-01-29 -----------------
----------------------------------------- AK 2025-01-30 --------------------
INSERT [dbo].[Parameters] ([ParameterCode], [DescriptionAr], [DescriptionEn], [ParameterName], [LookupTableId], [DataType], [IsString]) VALUES (12, N'السنة المالية', N'Financial year', N'FinancialYearCode', 10, 6, 0)
GO
INSERT [dbo].[Parameters] ([ParameterCode], [DescriptionAr], [DescriptionEn], [ParameterName], [LookupTableId], [DataType], [IsString]) VALUES (13, N'نوع اليومية', N'Journal type', N'JournalTypeCode', 11, 6, 0)
GO
INSERT [dbo].[Parameters] ([ParameterCode], [DescriptionAr], [DescriptionEn], [ParameterName], [LookupTableId], [DataType], [IsString]) VALUES (14, N'دليل الحسابات', N'Accounts chart', N'AccountsChartCode', 12, 6, 0)
GO
INSERT [dbo].[Parameters] ([ParameterCode], [DescriptionAr], [DescriptionEn], [ParameterName], [LookupTableId], [DataType], [IsString]) VALUES (15, N'حالة القيد', N'Journal Status', N'JournalStatus', 19, 6, 0)
GO
INSERT [dbo].[Parameters] ([ParameterCode], [DescriptionAr], [DescriptionEn], [ParameterName], [LookupTableId], [DataType], [IsString]) VALUES (16, N'الخزينة', N'Treasury', N'SafeCode', 14, 6, 0)
GO
INSERT [dbo].[Parameters] ([ParameterCode], [DescriptionAr], [DescriptionEn], [ParameterName], [LookupTableId], [DataType], [IsString]) VALUES (17, N'الحساب البنكي', N'Bank accounts', N'BankAccountCode', 15, 6, 0)
GO
INSERT [dbo].[Parameters] ([ParameterCode], [DescriptionAr], [DescriptionEn], [ParameterName], [LookupTableId], [DataType], [IsString]) VALUES (18, N'المورد', N'Vendor', N'SupplierCode', 16, 6, 0)
GO
INSERT [dbo].[Parameters] ([ParameterCode], [DescriptionAr], [DescriptionEn], [ParameterName], [LookupTableId], [DataType], [IsString]) VALUES (19, N'العميل', N'Customer', N'SupplierCode', 17, 6, 0)
GO
INSERT [dbo].[Parameters] ([ParameterCode], [DescriptionAr], [DescriptionEn], [ParameterName], [LookupTableId], [DataType], [IsString]) VALUES (20, N'المصروف', N'Expense', N'ExpenseCode', 18, 6, 0)
GO
INSERT [dbo].[Parameters] ([ParameterCode], [DescriptionAr], [DescriptionEn], [ParameterName], [LookupTableId], [DataType], [IsString]) VALUES (21, N'تاريخ', N'Date', N'JournalDate', 19, 5, 0)
GO
INSERT [dbo].[Parameters] ([ParameterCode], [DescriptionAr], [DescriptionEn], [ParameterName], [LookupTableId], [DataType], [IsString]) VALUES (22, N'مركز التكلفة 1', N'Cost Center Chart Code 1', N'CostCenterChartCode1', 13, 6, 0)
GO
INSERT [dbo].[Parameters] ([ParameterCode], [DescriptionAr], [DescriptionEn], [ParameterName], [LookupTableId], [DataType], [IsString]) VALUES (23, N'مركز التكلفة 2', N'Cost Center Chart Code 2', N'CostCenterChartCode2', 13, 6, 0)
GO
INSERT [dbo].[Parameters] ([ParameterCode], [DescriptionAr], [DescriptionEn], [ParameterName], [LookupTableId], [DataType], [IsString]) VALUES (24, N'مركز التكلفة 3', N'Cost Center Chart Code 3', N'CostCenterChartCode3', 13, 6, 0)
GO
SET IDENTITY_INSERT [dbo].[Reports] ON 
GO
INSERT [dbo].[Reports] ([ReportCode], [Name], [Arabic_Name], [ReportName], [AllClient], [NeedPublish], [AvailableToCustomer], [FixedFormula], [Description], [PassFixedFormulaToSupReport], [ShowGroup], [ShowSeparatedPage], [DefaultTableGroupPrefix], [DefaultGroupCode], [Sortable], [ShowMonthAndYear], [CanReadPayRoll], [ReportNameEn], [DescriptionEn], [ReportNo], [FileName], [ShowMonthAndYear2], [DependOnFinancialPrivilege], [ShowCalcNo], [SystemMenuCode], [SecurityPrivilegeCode]) VALUES (21, N'Trial Balance Report', N'تقرير ميزان المراجعة', N'TrialBalance.rpt', 1, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 0, N'TrialBalance-EN.rpt', NULL, NULL, N'TrialBalance.rpt', 0, 0, 0, 1147, 23209)
GO
INSERT [dbo].[Reports] ([ReportCode], [Name], [Arabic_Name], [ReportName], [AllClient], [NeedPublish], [AvailableToCustomer], [FixedFormula], [Description], [PassFixedFormulaToSupReport], [ShowGroup], [ShowSeparatedPage], [DefaultTableGroupPrefix], [DefaultGroupCode], [Sortable], [ShowMonthAndYear], [CanReadPayRoll], [ReportNameEn], [DescriptionEn], [ReportNo], [FileName], [ShowMonthAndYear2], [DependOnFinancialPrivilege], [ShowCalcNo], [SystemMenuCode], [SecurityPrivilegeCode]) VALUES (22, N'Detailed Trial Balance Report', N'تقرير ميزان المراجعة التفصيلي', N'TrialBalanceByDetail.rpt', 1, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 0, N'TrialBalanceByDetail-EN.rpt', NULL, NULL, N'TrialBalanceByDetail.rpt', 0, 0, 0, 1147, 23210)
GO
INSERT [dbo].[Reports] ([ReportCode], [Name], [Arabic_Name], [ReportName], [AllClient], [NeedPublish], [AvailableToCustomer], [FixedFormula], [Description], [PassFixedFormulaToSupReport], [ShowGroup], [ShowSeparatedPage], [DefaultTableGroupPrefix], [DefaultGroupCode], [Sortable], [ShowMonthAndYear], [CanReadPayRoll], [ReportNameEn], [DescriptionEn], [ReportNo], [FileName], [ShowMonthAndYear2], [DependOnFinancialPrivilege], [ShowCalcNo], [SystemMenuCode], [SecurityPrivilegeCode]) VALUES (23, N'Detailed General Ledger Report', N'تقرير الاستاذ العام التفصيلي', N'GLByDetail.rpt', 1, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 0, N'GLByDetail-EN.rpt', NULL, NULL, N'GLByDetail.rpt', 0, 0, 0, 1147, 23212)
GO
INSERT [dbo].[Reports] ([ReportCode], [Name], [Arabic_Name], [ReportName], [AllClient], [NeedPublish], [AvailableToCustomer], [FixedFormula], [Description], [PassFixedFormulaToSupReport], [ShowGroup], [ShowSeparatedPage], [DefaultTableGroupPrefix], [DefaultGroupCode], [Sortable], [ShowMonthAndYear], [CanReadPayRoll], [ReportNameEn], [DescriptionEn], [ReportNo], [FileName], [ShowMonthAndYear2], [DependOnFinancialPrivilege], [ShowCalcNo], [SystemMenuCode], [SecurityPrivilegeCode]) VALUES (24, N'General Ledger Report', N'تقرير الأستاذ العام', N'GL.rpt', 1, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, 0, 0, 0, N'GL-EN.rpt', NULL, NULL, N'GL.rpt', 0, 0, 0, 1147, 23211)
GO
SET IDENTITY_INSERT [dbo].[Reports] OFF
GO
SET IDENTITY_INSERT [dbo].[ParameterReports] ON 
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (92, 12, 21, 0, NULL, NULL, 19, 0)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (93, 13, 21, 0, NULL, NULL, 19, 0)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (94, 14, 21, 0, NULL, NULL, 12, 0)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (95, 15, 21, 0, NULL, NULL, 19, 1)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (96, 21, 21, 0, NULL, NULL, 19, 0)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (97, 22, 21, 0, NULL, NULL, 20, 0)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (98, 23, 21, 0, NULL, NULL, 20, 0)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (99, 24, 21, 0, NULL, NULL, 20, 0)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (100, 12, 22, 0, NULL, NULL, 19, 0)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (101, 13, 22, 0, NULL, NULL, 19, 0)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (102, 14, 22, 0, NULL, NULL, 12, 0)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (103, 15, 22, 0, NULL, NULL, 19, 1)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (104, 21, 22, 0, NULL, NULL, 19, 0)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (105, 22, 22, 0, NULL, NULL, 20, 0)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (106, 23, 22, 0, NULL, NULL, 20, 0)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (107, 24, 22, 0, NULL, NULL, 20, 0)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (129, 12, 24, 0, NULL, NULL, 19, 0)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (130, 13, 24, 0, NULL, NULL, 19, 0)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (131, 14, 24, 0, NULL, NULL, 12, 0)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (132, 15, 24, 0, NULL, NULL, 19, 1)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (133, 21, 24, 0, NULL, NULL, 19, 0)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (134, 12, 23, 0, NULL, NULL, 19, 0)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (135, 13, 23, 0, NULL, NULL, 19, 0)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (136, 14, 23, 0, NULL, NULL, 12, 0)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (137, 15, 23, 0, NULL, NULL, 19, 1)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (138, 16, 23, 0, NULL, NULL, 20, 0)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (139, 17, 23, 0, NULL, NULL, 20, 0)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (140, 18, 23, 0, NULL, NULL, 20, 0)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (141, 19, 23, 0, NULL, NULL, 20, 0)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (142, 20, 23, 0, NULL, NULL, 20, 0)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (143, 21, 23, 0, NULL, NULL, 19, 0)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (144, 22, 23, 0, NULL, NULL, 20, 0)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (145, 23, 23, 0, NULL, NULL, 20, 0)
GO
INSERT [dbo].[ParameterReports] ([ParameterReportCode], [ParameterCode], [ReportCode], [IsRequired], [DefaultValueFrom], [DefaultValueTo], [SelectionTable], [DisplayMultiSelect]) VALUES (146, 24, 23, 0, NULL, NULL, 20, 0)
GO
SET IDENTITY_INSERT [dbo].[ParameterReports] OFF
GO
SET IDENTITY_INSERT [dbo].[ReportsAppModules] ON 
GO
INSERT [dbo].[ReportsAppModules] ([ReportsAppModuleCode], [ReportCode], [AppModuleCode]) VALUES (42, 21, 18)
GO
INSERT [dbo].[ReportsAppModules] ([ReportsAppModuleCode], [ReportCode], [AppModuleCode]) VALUES (43, 22, 18)
GO
INSERT [dbo].[ReportsAppModules] ([ReportsAppModuleCode], [ReportCode], [AppModuleCode]) VALUES (47, 24, 18)
GO
INSERT [dbo].[ReportsAppModules] ([ReportsAppModuleCode], [ReportCode], [AppModuleCode]) VALUES (48, 23, 18)
GO
SET IDENTITY_INSERT [dbo].[ReportsAppModules] OFF
GO
----------------------------------------- AK 2025-01-30 --------------------- 