-- RayosMall SQL Data Backup
-- Generated: 2026-07-05 00:46:00
-- ملاحظة: هذا ملف نسخ احتياطي للبيانات الأساسية وليس بديلًا عن SQL Server .bak
SET NOCOUNT ON;
GO

PRINT N'Backup table: dbo.account_charts';
GO
SET IDENTITY_INSERT dbo.[account_charts] ON;
GO
INSERT INTO dbo.[account_charts] ([id], [account_code], [account_name], [parent_id], [account_type], [is_postable], [is_active], [created_at]) VALUES (1, N'1', N'الأصول', NULL, N'Asset', 0, 1, '2026-07-04 17:11:55.131');
INSERT INTO dbo.[account_charts] ([id], [account_code], [account_name], [parent_id], [account_type], [is_postable], [is_active], [created_at]) VALUES (2, N'2', N'الالتزامات', NULL, N'Liability', 0, 1, '2026-07-04 17:11:55.131');
INSERT INTO dbo.[account_charts] ([id], [account_code], [account_name], [parent_id], [account_type], [is_postable], [is_active], [created_at]) VALUES (3, N'3', N'حقوق الملكية', NULL, N'Equity', 0, 1, '2026-07-04 17:11:55.131');
INSERT INTO dbo.[account_charts] ([id], [account_code], [account_name], [parent_id], [account_type], [is_postable], [is_active], [created_at]) VALUES (4, N'4', N'الإيرادات', NULL, N'Revenue', 0, 1, '2026-07-04 17:11:55.131');
INSERT INTO dbo.[account_charts] ([id], [account_code], [account_name], [parent_id], [account_type], [is_postable], [is_active], [created_at]) VALUES (5, N'5', N'المصروفات', NULL, N'Expense', 0, 1, '2026-07-04 17:11:55.131');
INSERT INTO dbo.[account_charts] ([id], [account_code], [account_name], [parent_id], [account_type], [is_postable], [is_active], [created_at]) VALUES (6, N'1100', N'النقدية والبنوك', 17, N'Asset', 0, 1, '2026-07-04 17:11:55.166');
INSERT INTO dbo.[account_charts] ([id], [account_code], [account_name], [parent_id], [account_type], [is_postable], [is_active], [created_at]) VALUES (7, N'1110', N'الخزينة الرئيسية', 6, N'Asset', 1, 1, '2026-07-04 17:11:55.166');
INSERT INTO dbo.[account_charts] ([id], [account_code], [account_name], [parent_id], [account_type], [is_postable], [is_active], [created_at]) VALUES (8, N'1120', N'البنك الرئيسي', 6, N'Asset', 1, 1, '2026-07-04 17:11:55.166');
INSERT INTO dbo.[account_charts] ([id], [account_code], [account_name], [parent_id], [account_type], [is_postable], [is_active], [created_at]) VALUES (9, N'1200', N'مشروعات تحت التنفيذ - غير مستخدم', 1, N'Asset', 0, 0, '2026-07-04 17:11:55.166');
INSERT INTO dbo.[account_charts] ([id], [account_code], [account_name], [parent_id], [account_type], [is_postable], [is_active], [created_at]) VALUES (10, N'1210', N'مول رايوس تحت الإنشاء', 18, N'Asset', 0, 1, '2026-07-04 17:11:55.166');
INSERT INTO dbo.[account_charts] ([id], [account_code], [account_name], [parent_id], [account_type], [is_postable], [is_active], [created_at]) VALUES (11, N'1300', N'دفعات مقدمة للمقاولين والموردين', 17, N'Asset', 1, 1, '2026-07-04 17:11:55.166');
INSERT INTO dbo.[account_charts] ([id], [account_code], [account_name], [parent_id], [account_type], [is_postable], [is_active], [created_at]) VALUES (12, N'1400', N'ضريبة قيمة مضافة مدينة', 17, N'Asset', 1, 1, '2026-07-04 17:11:55.166');
INSERT INTO dbo.[account_charts] ([id], [account_code], [account_name], [parent_id], [account_type], [is_postable], [is_active], [created_at]) VALUES (13, N'2100', N'مقاولون وموردون دائنون', 23, N'Liability', 0, 1, '2026-07-04 17:11:55.166');
INSERT INTO dbo.[account_charts] ([id], [account_code], [account_name], [parent_id], [account_type], [is_postable], [is_active], [created_at]) VALUES (14, N'2200', N'احتجازات مقاولين', 23, N'Liability', 1, 1, '2026-07-04 17:11:55.166');
INSERT INTO dbo.[account_charts] ([id], [account_code], [account_name], [parent_id], [account_type], [is_postable], [is_active], [created_at]) VALUES (15, N'2300', N'ضرائب مستحقة', 23, N'Liability', 1, 1, '2026-07-04 17:11:55.166');
INSERT INTO dbo.[account_charts] ([id], [account_code], [account_name], [parent_id], [account_type], [is_postable], [is_active], [created_at]) VALUES (16, N'5100', N'مصروفات إدارية للمشروع', 5, N'Expense', 1, 1, '2026-07-04 17:11:55.166');
INSERT INTO dbo.[account_charts] ([id], [account_code], [account_name], [parent_id], [account_type], [is_postable], [is_active], [created_at]) VALUES (17, N'11', N'الأصول المتداولة', 1, N'Asset', 0, 1, '2026-07-04 22:14:14.886');
INSERT INTO dbo.[account_charts] ([id], [account_code], [account_name], [parent_id], [account_type], [is_postable], [is_active], [created_at]) VALUES (18, N'12', N'مشروعات تحت التنفيذ', 1, N'Asset', 0, 1, '2026-07-04 22:14:14.886');
INSERT INTO dbo.[account_charts] ([id], [account_code], [account_name], [parent_id], [account_type], [is_postable], [is_active], [created_at]) VALUES (19, N'1211', N'مول رايوس تحت الإنشاء - أعمال مدنية', 10, N'Asset', 1, 1, '2026-07-04 22:14:14.886');
INSERT INTO dbo.[account_charts] ([id], [account_code], [account_name], [parent_id], [account_type], [is_postable], [is_active], [created_at]) VALUES (20, N'1212', N'مول رايوس تحت الإنشاء - كهروميكانيكال', 10, N'Asset', 1, 1, '2026-07-04 22:14:14.886');
INSERT INTO dbo.[account_charts] ([id], [account_code], [account_name], [parent_id], [account_type], [is_postable], [is_active], [created_at]) VALUES (21, N'1213', N'مول رايوس تحت الإنشاء - تشطيبات وواجهات', 10, N'Asset', 1, 1, '2026-07-04 22:14:14.886');
INSERT INTO dbo.[account_charts] ([id], [account_code], [account_name], [parent_id], [account_type], [is_postable], [is_active], [created_at]) VALUES (22, N'1214', N'مول رايوس تحت الإنشاء - استشارات وإشراف', 10, N'Asset', 1, 1, '2026-07-04 22:14:14.886');
INSERT INTO dbo.[account_charts] ([id], [account_code], [account_name], [parent_id], [account_type], [is_postable], [is_active], [created_at]) VALUES (23, N'21', N'التزامات متداولة', 2, N'Liability', 0, 1, '2026-07-04 22:14:14.886');
INSERT INTO dbo.[account_charts] ([id], [account_code], [account_name], [parent_id], [account_type], [is_postable], [is_active], [created_at]) VALUES (29, N'3100', N'رأس المال / تمويل المالك', 3, N'Equity', 1, 1, '2026-07-04 22:14:14.886');
INSERT INTO dbo.[account_charts] ([id], [account_code], [account_name], [parent_id], [account_type], [is_postable], [is_active], [created_at]) VALUES (30, N'211001', N'شركة النيل للمقاولات العامة', 13, N'Liability', 1, 1, '2026-07-04 22:17:25.241');
INSERT INTO dbo.[account_charts] ([id], [account_code], [account_name], [parent_id], [account_type], [is_postable], [is_active], [created_at]) VALUES (31, N'211002', N'شركة باور تك للكهروميكانيكال', 13, N'Liability', 1, 1, '2026-07-04 22:17:25.241');
INSERT INTO dbo.[account_charts] ([id], [account_code], [account_name], [parent_id], [account_type], [is_postable], [is_active], [created_at]) VALUES (32, N'211003', N'شركة فيوتشر إليفيتورز للمصاعد', 13, N'Liability', 1, 1, '2026-07-04 22:17:25.241');
INSERT INTO dbo.[account_charts] ([id], [account_code], [account_name], [parent_id], [account_type], [is_postable], [is_active], [created_at]) VALUES (33, N'211004', N'المكتب الاستشاري الهندسي', 13, N'Liability', 1, 1, '2026-07-04 22:17:25.241');
INSERT INTO dbo.[account_charts] ([id], [account_code], [account_name], [parent_id], [account_type], [is_postable], [is_active], [created_at]) VALUES (34, N'211005', N'مورد خامات البناء التجريبي', 13, N'Liability', 1, 1, '2026-07-04 22:17:25.241');
GO
SET IDENTITY_INSERT dbo.[account_charts] OFF;
GO

PRINT N'Backup table: dbo.cost_centers';
GO
SET IDENTITY_INSERT dbo.[cost_centers] ON;
GO
INSERT INTO dbo.[cost_centers] ([cost_center_id], [cost_center_code], [cost_center_name], [parent_id], [center_type], [is_active], [created_at]) VALUES (1, N'01', N'خرسانه', NULL, N'Other', 1, '2026-07-04 18:25:35.927');
INSERT INTO dbo.[cost_centers] ([cost_center_id], [cost_center_code], [cost_center_name], [parent_id], [center_type], [is_active], [created_at]) VALUES (2, N'PRJ-001', N'مشروع المول', NULL, N'Project', 1, '2026-07-04 20:24:51.905');
INSERT INTO dbo.[cost_centers] ([cost_center_id], [cost_center_code], [cost_center_name], [parent_id], [center_type], [is_active], [created_at]) VALUES (3, N'PH-001', N'أعمال الحفر والأساسات', 2, N'Phase', 1, '2026-07-04 20:24:52.082');
INSERT INTO dbo.[cost_centers] ([cost_center_id], [cost_center_code], [cost_center_name], [parent_id], [center_type], [is_active], [created_at]) VALUES (4, N'PH-002', N'أعمال الخرسانات', 2, N'Phase', 1, '2026-07-04 20:24:52.082');
INSERT INTO dbo.[cost_centers] ([cost_center_id], [cost_center_code], [cost_center_name], [parent_id], [center_type], [is_active], [created_at]) VALUES (5, N'PH-003', N'أعمال الكهرباء والميكانيكا', 2, N'Phase', 1, '2026-07-04 20:24:52.082');
INSERT INTO dbo.[cost_centers] ([cost_center_id], [cost_center_code], [cost_center_name], [parent_id], [center_type], [is_active], [created_at]) VALUES (6, N'PH-004', N'أعمال التشطيبات', 2, N'Phase', 1, '2026-07-04 20:24:52.082');
INSERT INTO dbo.[cost_centers] ([cost_center_id], [cost_center_code], [cost_center_name], [parent_id], [center_type], [is_active], [created_at]) VALUES (13, N'DEMO-ADMIN', N'إدارة مشروع الإنشاء', 17, N'Department', 1, '2026-07-04 22:17:25.274');
INSERT INTO dbo.[cost_centers] ([cost_center_id], [cost_center_code], [cost_center_name], [parent_id], [center_type], [is_active], [created_at]) VALUES (14, N'DEMO-CIVIL', N'أعمال مدنية', 17, N'Phase', 1, '2026-07-04 22:17:25.274');
INSERT INTO dbo.[cost_centers] ([cost_center_id], [cost_center_code], [cost_center_name], [parent_id], [center_type], [is_active], [created_at]) VALUES (15, N'DEMO-CONSULT', N'استشارات وإشراف', 17, N'Department', 1, '2026-07-04 22:17:25.274');
INSERT INTO dbo.[cost_centers] ([cost_center_id], [cost_center_code], [cost_center_name], [parent_id], [center_type], [is_active], [created_at]) VALUES (16, N'DEMO-FINISH', N'تشطيبات وواجهات', 17, N'Phase', 1, '2026-07-04 22:17:25.274');
INSERT INTO dbo.[cost_centers] ([cost_center_id], [cost_center_code], [cost_center_name], [parent_id], [center_type], [is_active], [created_at]) VALUES (17, N'DEMO-MALL', N'مول رايوس التجريبي', NULL, N'Project', 1, '2026-07-04 22:17:25.274');
INSERT INTO dbo.[cost_centers] ([cost_center_id], [cost_center_code], [cost_center_name], [parent_id], [center_type], [is_active], [created_at]) VALUES (18, N'DEMO-MEP', N'أعمال كهروميكانيكال', 17, N'Phase', 1, '2026-07-04 22:17:25.274');
GO
SET IDENTITY_INSERT dbo.[cost_centers] OFF;
GO

PRINT N'Backup table: dbo.vendors';
GO
SET IDENTITY_INSERT dbo.[vendors] ON;
GO
INSERT INTO dbo.[vendors] ([vendor_id], [vendor_code], [vendor_name], [vendor_type], [phone], [email], [tax_number], [commercial_register], [address], [account_id], [opening_balance], [is_active], [created_at]) VALUES (6, N'DEMO-V-001', N'شركة النيل للمقاولات العامة', N'مقاول', N'01000000001', N'civil.demo@example.com', N'TAX-DEMO-001', N'CR-DEMO-001', N'القاهرة', 30, 0.00, 1, '2026-07-04 22:17:25.399');
INSERT INTO dbo.[vendors] ([vendor_id], [vendor_code], [vendor_name], [vendor_type], [phone], [email], [tax_number], [commercial_register], [address], [account_id], [opening_balance], [is_active], [created_at]) VALUES (7, N'DEMO-V-002', N'شركة باور تك للكهروميكانيكال', N'مقاول', N'01000000002', N'mep.demo@example.com', N'TAX-DEMO-002', N'CR-DEMO-002', N'القاهرة', 31, 0.00, 1, '2026-07-04 22:17:25.399');
INSERT INTO dbo.[vendors] ([vendor_id], [vendor_code], [vendor_name], [vendor_type], [phone], [email], [tax_number], [commercial_register], [address], [account_id], [opening_balance], [is_active], [created_at]) VALUES (8, N'DEMO-V-003', N'شركة فيوتشر إليفيتورز للمصاعد', N'مورد', N'01000000003', N'elevator.demo@example.com', N'TAX-DEMO-003', N'CR-DEMO-003', N'الجيزة', 32, 0.00, 1, '2026-07-04 22:17:25.399');
INSERT INTO dbo.[vendors] ([vendor_id], [vendor_code], [vendor_name], [vendor_type], [phone], [email], [tax_number], [commercial_register], [address], [account_id], [opening_balance], [is_active], [created_at]) VALUES (9, N'DEMO-V-004', N'المكتب الاستشاري الهندسي', N'استشاري', N'01000000004', N'consult.demo@example.com', N'TAX-DEMO-004', N'CR-DEMO-004', N'القاهرة', 33, 0.00, 1, '2026-07-04 22:17:25.399');
INSERT INTO dbo.[vendors] ([vendor_id], [vendor_code], [vendor_name], [vendor_type], [phone], [email], [tax_number], [commercial_register], [address], [account_id], [opening_balance], [is_active], [created_at]) VALUES (10, N'DEMO-V-005', N'مورد خامات البناء التجريبي', N'مورد', N'01000000005', N'materials.demo@example.com', N'TAX-DEMO-005', N'CR-DEMO-005', N'القاهرة', 34, 0.00, 1, '2026-07-04 22:17:25.399');
GO
SET IDENTITY_INSERT dbo.[vendors] OFF;
GO

PRINT N'Backup table: dbo.safes_and_banks';
GO
SET IDENTITY_INSERT dbo.[safes_and_banks] ON;
GO
INSERT INTO dbo.[safes_and_banks] ([safe_id], [safe_code], [safe_name], [safe_type], [account_id], [opening_balance], [current_balance], [is_active], [created_at]) VALUES (1, N'01', N'خزينة الصفا', N'خزينة', 7, 0.00, 0.00, 1, '2026-07-04 18:24:00.200');
INSERT INTO dbo.[safes_and_banks] ([safe_id], [safe_code], [safe_name], [safe_type], [account_id], [opening_balance], [current_balance], [is_active], [created_at]) VALUES (4, N'DEMO-CASH-001', N'خزينة موقع المول التجريبية', N'خزينة', 7, 250000.00, 250000.00, 1, '2026-07-04 22:17:25.369');
INSERT INTO dbo.[safes_and_banks] ([safe_id], [safe_code], [safe_name], [safe_type], [account_id], [opening_balance], [current_balance], [is_active], [created_at]) VALUES (5, N'DEMO-BANK-001', N'البنك الرئيسي - حساب مشروع المول', N'بنك', 8, 10000000.00, 8215000.00, 1, '2026-07-04 22:17:25.369');
GO
SET IDENTITY_INSERT dbo.[safes_and_banks] OFF;
GO

PRINT N'Backup table: dbo.construction_projects';
GO
SET IDENTITY_INSERT dbo.[construction_projects] ON;
GO
INSERT INTO dbo.[construction_projects] ([project_id], [project_code], [project_name], [location], [owner_name], [start_date], [expected_end_date], [actual_end_date], [estimated_budget], [status], [cost_center_id], [is_active], [created_at]) VALUES (1, N'02', N'مول ريوس', N'السادات', N'الحاج فوزي الحصري', '2026-07-04 00:00:00.000', '2028-12-31 00:00:00.000', NULL, 0.00, N'قيد الإنشاء', 1, 0, '2026-07-04 18:26:09.473');
INSERT INTO dbo.[construction_projects] ([project_id], [project_code], [project_name], [location], [owner_name], [start_date], [expected_end_date], [actual_end_date], [estimated_budget], [status], [cost_center_id], [is_active], [created_at]) VALUES (3, N'DEMO-MALL-001', N'مول رايوس التجريبي - قيد الإنشاء', N'القاهرة الجديدة', N'شركة رايوس للتطوير العقاري', '2026-07-01 00:00:00.000', '2027-12-31 00:00:00.000', NULL, 30000000.00, N'قيد الإنشاء', 17, 1, '2026-07-04 22:17:25.290');
GO
SET IDENTITY_INSERT dbo.[construction_projects] OFF;
GO

PRINT N'Backup table: dbo.construction_phases';
GO
SET IDENTITY_INSERT dbo.[construction_phases] ON;
GO
INSERT INTO dbo.[construction_phases] ([phase_id], [project_id], [phase_code], [phase_name], [parent_phase_id], [start_date], [expected_end_date], [estimated_budget], [status], [cost_center_id], [is_active], [created_at]) VALUES (12, 3, N'DEMO-PH-001', N'أعمال الحفر والإحلال', NULL, '2026-07-01 00:00:00.000', '2026-08-15 00:00:00.000', 1500000.00, N'قيد التنفيذ', 14, 1, '2026-07-04 22:17:25.319');
INSERT INTO dbo.[construction_phases] ([phase_id], [project_id], [phase_code], [phase_name], [parent_phase_id], [start_date], [expected_end_date], [estimated_budget], [status], [cost_center_id], [is_active], [created_at]) VALUES (13, 3, N'DEMO-PH-002', N'أعمال الأساسات', NULL, '2026-08-16 00:00:00.000', '2026-10-15 00:00:00.000', 3500000.00, N'لم يبدأ', 14, 1, '2026-07-04 22:17:25.319');
INSERT INTO dbo.[construction_phases] ([phase_id], [project_id], [phase_code], [phase_name], [parent_phase_id], [start_date], [expected_end_date], [estimated_budget], [status], [cost_center_id], [is_active], [created_at]) VALUES (14, 3, N'DEMO-PH-003', N'أعمال الخرسانة المسلحة', NULL, '2026-10-16 00:00:00.000', '2027-02-28 00:00:00.000', 7000000.00, N'لم يبدأ', 14, 1, '2026-07-04 22:17:25.319');
INSERT INTO dbo.[construction_phases] ([phase_id], [project_id], [phase_code], [phase_name], [parent_phase_id], [start_date], [expected_end_date], [estimated_budget], [status], [cost_center_id], [is_active], [created_at]) VALUES (15, 3, N'DEMO-PH-004', N'أعمال المباني', NULL, '2027-01-01 00:00:00.000', '2027-04-30 00:00:00.000', 2500000.00, N'لم يبدأ', 14, 1, '2026-07-04 22:17:25.319');
INSERT INTO dbo.[construction_phases] ([phase_id], [project_id], [phase_code], [phase_name], [parent_phase_id], [start_date], [expected_end_date], [estimated_budget], [status], [cost_center_id], [is_active], [created_at]) VALUES (16, 3, N'DEMO-PH-005', N'أعمال الكهرباء', NULL, '2027-03-01 00:00:00.000', '2027-09-30 00:00:00.000', 3200000.00, N'لم يبدأ', 18, 1, '2026-07-04 22:17:25.319');
INSERT INTO dbo.[construction_phases] ([phase_id], [project_id], [phase_code], [phase_name], [parent_phase_id], [start_date], [expected_end_date], [estimated_budget], [status], [cost_center_id], [is_active], [created_at]) VALUES (17, 3, N'DEMO-PH-006', N'أعمال السباكة والحريق', NULL, '2027-03-01 00:00:00.000', '2027-09-30 00:00:00.000', 2300000.00, N'لم يبدأ', 18, 1, '2026-07-04 22:17:25.319');
INSERT INTO dbo.[construction_phases] ([phase_id], [project_id], [phase_code], [phase_name], [parent_phase_id], [start_date], [expected_end_date], [estimated_budget], [status], [cost_center_id], [is_active], [created_at]) VALUES (18, 3, N'DEMO-PH-007', N'أعمال التكييف', NULL, '2027-04-01 00:00:00.000', '2027-10-31 00:00:00.000', 4200000.00, N'لم يبدأ', 18, 1, '2026-07-04 22:17:25.319');
INSERT INTO dbo.[construction_phases] ([phase_id], [project_id], [phase_code], [phase_name], [parent_phase_id], [start_date], [expected_end_date], [estimated_budget], [status], [cost_center_id], [is_active], [created_at]) VALUES (19, 3, N'DEMO-PH-008', N'التشطيبات الداخلية', NULL, '2027-06-01 00:00:00.000', '2027-12-15 00:00:00.000', 2800000.00, N'لم يبدأ', 16, 1, '2026-07-04 22:17:25.319');
INSERT INTO dbo.[construction_phases] ([phase_id], [project_id], [phase_code], [phase_name], [parent_phase_id], [start_date], [expected_end_date], [estimated_budget], [status], [cost_center_id], [is_active], [created_at]) VALUES (20, 3, N'DEMO-PH-009', N'الواجهات الخارجية', NULL, '2027-06-01 00:00:00.000', '2027-11-30 00:00:00.000', 2000000.00, N'لم يبدأ', 16, 1, '2026-07-04 22:17:25.319');
INSERT INTO dbo.[construction_phases] ([phase_id], [project_id], [phase_code], [phase_name], [parent_phase_id], [start_date], [expected_end_date], [estimated_budget], [status], [cost_center_id], [is_active], [created_at]) VALUES (21, 3, N'DEMO-PH-010', N'المصاعد والسلالم الكهربائية', NULL, '2027-05-01 00:00:00.000', '2027-10-31 00:00:00.000', 1300000.00, N'لم يبدأ', 18, 1, '2026-07-04 22:17:25.319');
INSERT INTO dbo.[construction_phases] ([phase_id], [project_id], [phase_code], [phase_name], [parent_phase_id], [start_date], [expected_end_date], [estimated_budget], [status], [cost_center_id], [is_active], [created_at]) VALUES (22, 3, N'DEMO-PH-011', N'استشارات وإشراف هندسي', NULL, '2026-07-01 00:00:00.000', '2027-12-31 00:00:00.000', 700000.00, N'قيد التنفيذ', 15, 1, '2026-07-04 22:17:25.319');
GO
SET IDENTITY_INSERT dbo.[construction_phases] OFF;
GO

PRINT N'Backup table: dbo.cost_items';
GO
SET IDENTITY_INSERT dbo.[cost_items] ON;
GO
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (1, N'C001', N'أعمال الحفر', N'أعمال مدنية', N'م3', 1, '2026-07-04 17:12:02.593');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (2, N'C002', N'أعمال الأساسات', N'أعمال مدنية', N'م3', 1, '2026-07-04 17:12:02.593');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (3, N'C003', N'أعمال الخرسانة المسلحة', N'أعمال مدنية', N'م3', 1, '2026-07-04 17:12:02.593');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (4, N'C004', N'أعمال المباني', N'أعمال مدنية', N'م2', 1, '2026-07-04 17:12:02.593');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (5, N'C005', N'أعمال الكهرباء', N'كهروميكانيكال', N'بند', 1, '2026-07-04 17:12:02.593');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (6, N'C006', N'أعمال السباكة', N'كهروميكانيكال', N'بند', 1, '2026-07-04 17:12:02.593');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (7, N'C007', N'أعمال التكييف', N'كهروميكانيكال', N'بند', 1, '2026-07-04 17:12:02.593');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (8, N'C008', N'أعمال التشطيبات', N'تشطيبات', N'م2', 1, '2026-07-04 17:12:02.593');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (9, N'C009', N'أعمال الواجهات', N'واجهات', N'م2', 1, '2026-07-04 17:12:02.593');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (10, N'C010', N'أعمال المصاعد', N'مصاعد', N'بند', 1, '2026-07-04 17:12:02.593');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (11, N'002', N'التصاريح', N'مصروفات رسمية', NULL, 1, '2026-07-04 18:29:52.587');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (12, N'005', N'عداد مياه', N'مصروفات رسمية', NULL, 1, '2026-07-04 18:30:28.308');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (33, N'DEMO-CI-001', N'حفر وردم وإحلال', N'أعمال مدنية', N'م3', 1, '2026-07-04 22:17:25.356');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (34, N'DEMO-CI-002', N'خرسانة عادية ومسلحة', N'أعمال مدنية', N'م3', 1, '2026-07-04 22:17:25.356');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (35, N'DEMO-CI-003', N'حديد تسليح', N'أعمال مدنية', N'طن', 1, '2026-07-04 22:17:25.356');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (36, N'DEMO-CI-004', N'مباني وطوب', N'أعمال مدنية', N'م2', 1, '2026-07-04 22:17:25.356');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (37, N'DEMO-CI-005', N'محارة وبياض', N'تشطيبات', N'م2', 1, '2026-07-04 22:17:25.356');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (38, N'DEMO-CI-006', N'أرضيات وسيراميك', N'تشطيبات', N'م2', 1, '2026-07-04 22:17:25.356');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (39, N'DEMO-CI-007', N'دهانات', N'تشطيبات', N'م2', 1, '2026-07-04 22:17:25.356');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (40, N'DEMO-CI-008', N'واجهات زجاج وألومنيوم', N'واجهات', N'م2', 1, '2026-07-04 22:17:25.356');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (41, N'DEMO-CI-009', N'لوحات وكابلات كهرباء', N'كهرباء', N'بند', 1, '2026-07-04 22:17:25.356');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (42, N'DEMO-CI-010', N'إنارة داخلية وخارجية', N'كهرباء', N'بند', 1, '2026-07-04 22:17:25.356');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (43, N'DEMO-CI-011', N'سباكة وصرف', N'سباكة', N'بند', 1, '2026-07-04 22:17:25.356');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (44, N'DEMO-CI-012', N'شبكة حريق', N'حريق', N'بند', 1, '2026-07-04 22:17:25.356');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (45, N'DEMO-CI-013', N'تكييف وتهوية', N'تكييف', N'بند', 1, '2026-07-04 22:17:25.356');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (46, N'DEMO-CI-014', N'مصاعد', N'مصاعد', N'وحدة', 1, '2026-07-04 22:17:25.356');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (47, N'DEMO-CI-015', N'سلالم كهربائية', N'مصاعد', N'وحدة', 1, '2026-07-04 22:17:25.356');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (48, N'DEMO-CI-016', N'استشارات وإشراف', N'استشارات', N'شهر', 1, '2026-07-04 22:17:25.356');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (49, N'DEMO-CI-017', N'اختبارات جودة', N'استشارات', N'بند', 1, '2026-07-04 22:17:25.356');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (50, N'DEMO-CI-018', N'معدات وموقع عام', N'مصروفات موقع', N'بند', 1, '2026-07-04 22:17:25.356');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (51, N'DEMO-CI-019', N'أمن وسلامة', N'مصروفات موقع', N'بند', 1, '2026-07-04 22:17:25.356');
INSERT INTO dbo.[cost_items] ([cost_item_id], [cost_item_code], [cost_item_name], [cost_category], [unit], [is_active], [created_at]) VALUES (52, N'DEMO-CI-020', N'مصاريف إدارية للمشروع', N'مصروفات إدارية', N'بند', 1, '2026-07-04 22:17:25.356');
GO
SET IDENTITY_INSERT dbo.[cost_items] OFF;
GO

PRINT N'Backup table: dbo.contracts';
GO
SET IDENTITY_INSERT dbo.[contracts] ON;
GO
INSERT INTO dbo.[contracts] ([contract_id], [project_id], [vendor_id], [contract_no], [contract_date], [contract_type], [description], [contract_amount], [retention_percent], [advance_percent], [tax_percent], [start_date], [end_date], [status], [is_active], [created_at]) VALUES (6, 3, 6, N'DEMO-CON-001', '2026-07-05 00:00:00.000', N'مقاولة', N'عقد الأعمال المدنية للمول التجريبي', 12000000.00, 5.00, 10.00, 14.00, '2026-07-10 00:00:00.000', '2027-04-30 00:00:00.000', N'ساري', 1, '2026-07-04 22:17:25.452');
INSERT INTO dbo.[contracts] ([contract_id], [project_id], [vendor_id], [contract_no], [contract_date], [contract_type], [description], [contract_amount], [retention_percent], [advance_percent], [tax_percent], [start_date], [end_date], [status], [is_active], [created_at]) VALUES (7, 3, 7, N'DEMO-CON-002', '2026-07-10 00:00:00.000', N'مقاولة', N'عقد أعمال الكهرباء والسباكة والتكييف', 6500000.00, 5.00, 10.00, 14.00, '2027-03-01 00:00:00.000', '2027-10-31 00:00:00.000', N'ساري', 1, '2026-07-04 22:17:25.452');
INSERT INTO dbo.[contracts] ([contract_id], [project_id], [vendor_id], [contract_no], [contract_date], [contract_type], [description], [contract_amount], [retention_percent], [advance_percent], [tax_percent], [start_date], [end_date], [status], [is_active], [created_at]) VALUES (8, 3, 8, N'DEMO-CON-003', '2026-07-12 00:00:00.000', N'توريد وتركيب', N'عقد توريد وتركيب المصاعد والسلالم الكهربائية', 2800000.00, 5.00, 20.00, 14.00, '2027-05-01 00:00:00.000', '2027-10-31 00:00:00.000', N'ساري', 1, '2026-07-04 22:17:25.452');
INSERT INTO dbo.[contracts] ([contract_id], [project_id], [vendor_id], [contract_no], [contract_date], [contract_type], [description], [contract_amount], [retention_percent], [advance_percent], [tax_percent], [start_date], [end_date], [status], [is_active], [created_at]) VALUES (9, 3, 9, N'DEMO-CON-004', '2026-07-01 00:00:00.000', N'استشارة', N'عقد الإشراف والاستشارات الهندسية', 750000.00, 0.00, 0.00, 14.00, '2026-07-01 00:00:00.000', '2027-12-31 00:00:00.000', N'ساري', 1, '2026-07-04 22:17:25.452');
INSERT INTO dbo.[contracts] ([contract_id], [project_id], [vendor_id], [contract_no], [contract_date], [contract_type], [description], [contract_amount], [retention_percent], [advance_percent], [tax_percent], [start_date], [end_date], [status], [is_active], [created_at]) VALUES (10, 3, 10, N'DEMO-CON-005', '2026-07-15 00:00:00.000', N'توريد', N'توريد خامات بناء متنوعة للاختبار', 1200000.00, 0.00, 0.00, 14.00, '2026-07-15 00:00:00.000', '2026-12-31 00:00:00.000', N'ساري', 1, '2026-07-04 22:17:25.452');
GO
SET IDENTITY_INSERT dbo.[contracts] OFF;
GO

PRINT N'Backup table: dbo.payment_certificates';
GO
SET IDENTITY_INSERT dbo.[payment_certificates] ON;
GO
INSERT INTO dbo.[payment_certificates] ([certificate_id], [contract_id], [certificate_no], [certificate_date], [period_from], [period_to], [gross_amount], [tax_amount], [retention_amount], [advance_deduction], [other_deductions], [net_amount], [status], [notes], [created_at]) VALUES (2, 6, N'DEMO-CERT-001', '2026-08-31 00:00:00.000', '2026-07-10 00:00:00.000', '2026-08-31 00:00:00.000', 1200000.00, 168000.00, 60000.00, 120000.00, 0.00, 1188000.00, N'معتمد', N'مستخلص تجريبي رقم 1 للأعمال المدنية', '2026-07-04 22:17:25.518');
GO
SET IDENTITY_INSERT dbo.[payment_certificates] OFF;
GO

PRINT N'Backup table: dbo.vendor_invoices';
GO
SET IDENTITY_INSERT dbo.[vendor_invoices] ON;
GO
INSERT INTO dbo.[vendor_invoices] ([invoice_id], [vendor_id], [project_id], [phase_id], [cost_item_id], [contract_id], [certificate_id], [invoice_no], [invoice_date], [due_date], [gross_amount], [tax_amount], [retention_amount], [discount_amount], [net_amount], [status], [notes], [created_at]) VALUES (2, 10, 3, 16, 41, 10, NULL, N'DEMO-INV-001', '2026-09-05 00:00:00.000', '2026-09-20 00:00:00.000', 250000.00, 35000.00, 0.00, 0.00, 285000.00, N'مرحلة', N'فاتورة توريد كابلات ولوحات لاختبار الفواتير', '2026-07-04 22:17:25.534');
GO
SET IDENTITY_INSERT dbo.[vendor_invoices] OFF;
GO

PRINT N'Backup table: dbo.payments';
GO
SET IDENTITY_INSERT dbo.[payments] ON;
GO
INSERT INTO dbo.[payments] ([payment_id], [vendor_id], [project_id], [contract_id], [certificate_id], [invoice_id], [safe_id], [payment_no], [payment_date], [payment_method], [amount], [reference_no], [notes], [is_posted], [created_at]) VALUES (3, 6, 3, 6, 2, NULL, 5, N'DEMO-PAY-001', '2026-09-10 00:00:00.000', N'تحويل بنكي', 600000.00, N'TRF-DEMO-001', N'سداد جزئي من مستخلص الأعمال المدنية', 1, '2026-07-04 22:17:25.543');
INSERT INTO dbo.[payments] ([payment_id], [vendor_id], [project_id], [contract_id], [certificate_id], [invoice_id], [safe_id], [payment_no], [payment_date], [payment_method], [amount], [reference_no], [notes], [is_posted], [created_at]) VALUES (4, 10, 3, 10, NULL, 2, 5, N'DEMO-PAY-002', '2026-09-18 00:00:00.000', N'تحويل بنكي', 285000.00, N'TRF-DEMO-002', N'سداد فاتورة مورد خامات البناء التجريبية', 1, '2026-07-04 22:17:25.543');
GO
SET IDENTITY_INSERT dbo.[payments] OFF;
GO

PRINT N'Backup table: dbo.journal_entries';
GO
SET IDENTITY_INSERT dbo.[journal_entries] ON;
GO
INSERT INTO dbo.[journal_entries] ([entry_id], [entry_date], [reference_no], [description], [source_type], [source_id], [is_posted], [is_active], [created_at]) VALUES (7, '2026-07-01 00:00:00.000', N'DEMO-JV-001', N'إثبات تمويل افتتاحي لحساب مشروع المول التجريبي', N'رصيد افتتاحي', NULL, 1, 1, '2026-07-04 22:17:25.543');
INSERT INTO dbo.[journal_entries] ([entry_id], [entry_date], [reference_no], [description], [source_type], [source_id], [is_posted], [is_active], [created_at]) VALUES (8, '2026-07-15 00:00:00.000', N'DEMO-JV-002', N'صرف دفعة مقدمة للمقاول الرئيسي', N'دفعة مقدمة', 2, 1, 1, '2026-07-04 22:17:25.543');
INSERT INTO dbo.[journal_entries] ([entry_id], [entry_date], [reference_no], [description], [source_type], [source_id], [is_posted], [is_active], [created_at]) VALUES (9, '2026-08-31 00:00:00.000', N'DEMO-JV-003', N'إثبات مستخلص الأعمال المدنية رقم DEMO-CERT-001', N'مستخلص', 2, 1, 1, '2026-07-04 22:17:25.543');
INSERT INTO dbo.[journal_entries] ([entry_id], [entry_date], [reference_no], [description], [source_type], [source_id], [is_posted], [is_active], [created_at]) VALUES (10, '2026-09-10 00:00:00.000', N'DEMO-JV-004', N'سداد جزئي من مستخلص الأعمال المدنية', N'دفعة', 3, 1, 1, '2026-07-04 22:17:25.543');
INSERT INTO dbo.[journal_entries] ([entry_id], [entry_date], [reference_no], [description], [source_type], [source_id], [is_posted], [is_active], [created_at]) VALUES (11, '2026-09-05 00:00:00.000', N'DEMO-JV-005', N'إثبات فاتورة مورد خامات البناء التجريبية', N'فاتورة مورد', 2, 1, 1, '2026-07-04 22:17:25.543');
INSERT INTO dbo.[journal_entries] ([entry_id], [entry_date], [reference_no], [description], [source_type], [source_id], [is_posted], [is_active], [created_at]) VALUES (12, '2026-09-18 00:00:00.000', N'DEMO-JV-006', N'سداد فاتورة مورد خامات البناء التجريبية', N'دفعة', 4, 1, 1, '2026-07-04 22:17:25.543');
GO
SET IDENTITY_INSERT dbo.[journal_entries] OFF;
GO

PRINT N'Backup table: dbo.journal_details';
GO
SET IDENTITY_INSERT dbo.[journal_details] ON;
GO
INSERT INTO dbo.[journal_details] ([detail_id], [entry_id], [account_id], [project_id], [phase_id], [cost_center_id], [cost_item_id], [debit], [credit], [description]) VALUES (17, 7, 8, 3, NULL, 17, NULL, 10000000.00, 0.00, N'إيداع تمويل افتتاحي بالبنك');
INSERT INTO dbo.[journal_details] ([detail_id], [entry_id], [account_id], [project_id], [phase_id], [cost_center_id], [cost_item_id], [debit], [credit], [description]) VALUES (18, 7, 29, 3, NULL, 17, NULL, 0.00, 10000000.00, N'تمويل مالك للمشروع');
INSERT INTO dbo.[journal_details] ([detail_id], [entry_id], [account_id], [project_id], [phase_id], [cost_center_id], [cost_item_id], [debit], [credit], [description]) VALUES (19, 8, 11, 3, NULL, 17, NULL, 900000.00, 0.00, N'دفعة مقدمة للمقاول الرئيسي');
INSERT INTO dbo.[journal_details] ([detail_id], [entry_id], [account_id], [project_id], [phase_id], [cost_center_id], [cost_item_id], [debit], [credit], [description]) VALUES (20, 8, 8, 3, NULL, 17, NULL, 0.00, 900000.00, N'صرف من البنك');
INSERT INTO dbo.[journal_details] ([detail_id], [entry_id], [account_id], [project_id], [phase_id], [cost_center_id], [cost_item_id], [debit], [credit], [description]) VALUES (21, 9, 19, 3, 12, 14, 33, 1200000.00, 0.00, N'تحميل مستخلص أعمال مدنية على مشروع تحت التنفيذ');
INSERT INTO dbo.[journal_details] ([detail_id], [entry_id], [account_id], [project_id], [phase_id], [cost_center_id], [cost_item_id], [debit], [credit], [description]) VALUES (22, 9, 12, 3, NULL, 17, NULL, 168000.00, 0.00, N'ضريبة قيمة مضافة على المستخلص');
INSERT INTO dbo.[journal_details] ([detail_id], [entry_id], [account_id], [project_id], [phase_id], [cost_center_id], [cost_item_id], [debit], [credit], [description]) VALUES (23, 9, 30, 3, NULL, 17, NULL, 0.00, 1188000.00, N'صافي مستحق للمقاول الرئيسي');
INSERT INTO dbo.[journal_details] ([detail_id], [entry_id], [account_id], [project_id], [phase_id], [cost_center_id], [cost_item_id], [debit], [credit], [description]) VALUES (24, 9, 14, 3, NULL, 17, NULL, 0.00, 60000.00, N'احتجاز مقاولين من المستخلص');
INSERT INTO dbo.[journal_details] ([detail_id], [entry_id], [account_id], [project_id], [phase_id], [cost_center_id], [cost_item_id], [debit], [credit], [description]) VALUES (25, 9, 11, 3, NULL, 17, NULL, 0.00, 120000.00, N'خصم جزء من الدفعة المقدمة');
INSERT INTO dbo.[journal_details] ([detail_id], [entry_id], [account_id], [project_id], [phase_id], [cost_center_id], [cost_item_id], [debit], [credit], [description]) VALUES (26, 10, 30, 3, NULL, 17, NULL, 600000.00, 0.00, N'تخفيض مستحقات المقاول الرئيسي');
INSERT INTO dbo.[journal_details] ([detail_id], [entry_id], [account_id], [project_id], [phase_id], [cost_center_id], [cost_item_id], [debit], [credit], [description]) VALUES (27, 10, 8, 3, NULL, 17, NULL, 0.00, 600000.00, N'صرف من البنك');
INSERT INTO dbo.[journal_details] ([detail_id], [entry_id], [account_id], [project_id], [phase_id], [cost_center_id], [cost_item_id], [debit], [credit], [description]) VALUES (28, 11, 20, 3, 16, 18, 41, 250000.00, 0.00, N'تحميل خامات كهرباء على مشروع تحت التنفيذ');
INSERT INTO dbo.[journal_details] ([detail_id], [entry_id], [account_id], [project_id], [phase_id], [cost_center_id], [cost_item_id], [debit], [credit], [description]) VALUES (29, 11, 12, 3, NULL, 17, NULL, 35000.00, 0.00, N'ضريبة قيمة مضافة على الفاتورة');
INSERT INTO dbo.[journal_details] ([detail_id], [entry_id], [account_id], [project_id], [phase_id], [cost_center_id], [cost_item_id], [debit], [credit], [description]) VALUES (30, 11, 34, 3, NULL, 17, NULL, 0.00, 285000.00, N'مستحقات مورد خامات البناء');
INSERT INTO dbo.[journal_details] ([detail_id], [entry_id], [account_id], [project_id], [phase_id], [cost_center_id], [cost_item_id], [debit], [credit], [description]) VALUES (31, 12, 34, 3, NULL, 17, NULL, 285000.00, 0.00, N'تخفيض مستحقات مورد خامات البناء');
INSERT INTO dbo.[journal_details] ([detail_id], [entry_id], [account_id], [project_id], [phase_id], [cost_center_id], [cost_item_id], [debit], [credit], [description]) VALUES (32, 12, 8, 3, NULL, 17, NULL, 0.00, 285000.00, N'صرف من البنك');
GO
SET IDENTITY_INSERT dbo.[journal_details] OFF;
GO

