-- شجرة حسابات شركة فحم الطربوش المتوافقة مع معايير المحاسبة العامة ونظام القيد المزدوج
-- تم التوليد آلياً بتاريخ: 2026-11-12 21:16:34

BEGIN TRANSACTION;

INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('1', 'الموجودات', NULL, 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('11', 'الموجودات المتداولة', (SELECT id FROM accounts WHERE account_code = '1'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('111', 'الصندوق النقدي', (SELECT id FROM accounts WHERE account_code = '11'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('11101', 'الصندوق الرئيسي (الخزينة المركزية)', (SELECT id FROM accounts WHERE account_code = '111'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'cash_box', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('11102', 'صندوق عهدة مشاريع الميدان', (SELECT id FROM accounts WHERE account_code = '111'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'cash_box', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('1111', 'صندوق النقدية الرئيسي (شيكل)', (SELECT id FROM accounts WHERE account_code = '111'), 'asset', 'debit', 'balance_sheet', 4, 'ILS', 'cash_box', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('1112', 'صندوق النقدية الرئيسي (دولار)', (SELECT id FROM accounts WHERE account_code = '111'), 'asset', 'debit', 'balance_sheet', 4, 'USD', 'cash_box', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('1113', 'صندوق النقدية الرئيسي (دينار)', (SELECT id FROM accounts WHERE account_code = '111'), 'asset', 'debit', 'balance_sheet', 4, 'JOD', 'cash_box', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('1114', 'صندوق المصاريف النثرية (العهدة)', (SELECT id FROM accounts WHERE account_code = '111'), 'asset', 'debit', 'balance_sheet', 4, 'ILS', 'cash_box', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('112', 'صندوق الشيكات', (SELECT id FROM accounts WHERE account_code = '11'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('11201', 'صندوق الشيكات الواردة بالخزينة', (SELECT id FROM accounts WHERE account_code = '112'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'cash_box', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('1121', 'شيكات واردة برسم الحفظ', (SELECT id FROM accounts WHERE account_code = '112'), 'asset', 'debit', 'balance_sheet', 4, 'ILS', 'checks_in_hand', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('1122', 'شيكات مرتجعة قيد التحصيل', (SELECT id FROM accounts WHERE account_code = '112'), 'asset', 'debit', 'balance_sheet', 4, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('113', 'نقدي في البنك', (SELECT id FROM accounts WHERE account_code = '11'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('11301', 'بنك فلسطين - احمد دنديس\الجاري (شيكل)', (SELECT id FROM accounts WHERE account_code = '113'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'bank_current', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('11302', 'بنك القدس - حساب جاري العمليات والمشاريع', (SELECT id FROM accounts WHERE account_code = '113'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'bank_current', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('11303', 'البنك العربي - حساب المقاولات والإنشاءات', (SELECT id FROM accounts WHERE account_code = '113'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'bank_current', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('1132', 'بنك فلسطين - جاري دولار', (SELECT id FROM accounts WHERE account_code = '113'), 'asset', 'debit', 'balance_sheet', 4, 'USD', 'bank_current', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('1133', 'بنك فلسطين - جاري دينار', (SELECT id FROM accounts WHERE account_code = '113'), 'asset', 'debit', 'balance_sheet', 4, 'JOD', 'bank_current', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('114', 'موجودات المخزون', (SELECT id FROM accounts WHERE account_code = '11'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('11401', 'بضاعة ومواد أول المدة', (SELECT id FROM accounts WHERE account_code = '114'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('11402', 'بضاعة ومواد آخر المدة', (SELECT id FROM accounts WHERE account_code = '114'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('115', 'السلفيات', (SELECT id FROM accounts WHERE account_code = '11'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('11501', 'سلف العمال والموظفين المؤقتة', (SELECT id FROM accounts WHERE account_code = '115'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'workers_advance', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('1151', 'سلف الموظفين', (SELECT id FROM accounts WHERE account_code = '115'), 'asset', 'debit', 'balance_sheet', 4, 'ILS', 'workers_advance', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('1152', 'عهد المشتريات والمندوبين', (SELECT id FROM accounts WHERE account_code = '115'), 'asset', 'debit', 'balance_sheet', 4, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('116', 'المسحوبات الشخصية', (SELECT id FROM accounts WHERE account_code = '11'), 'asset', 'debit', 'balance_sheet', 3, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('11601', 'المسحوبات الشخصية للشركاء', (SELECT id FROM accounts WHERE account_code = '11'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('1161', 'مسحوبات الشركاء الشخصية', (SELECT id FROM accounts WHERE account_code = '116'), 'asset', 'debit', 'balance_sheet', 4, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('117', 'ض.ق.م (ضريبة القيمة المضافة)', (SELECT id FROM accounts WHERE account_code = '11'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('11701', 'ض.ق.م مدخلات ومشتريات', (SELECT id FROM accounts WHERE account_code = '117'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('11702', 'ض.ق.م مستردة', (SELECT id FROM accounts WHERE account_code = '117'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('1173', 'تسويات ضريبة القيمة المضافة (المقاصة)', (SELECT id FROM accounts WHERE account_code = '117'), 'asset', 'debit', 'balance_sheet', 4, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('118', 'حساب الشيكات برسم التحصيل', (SELECT id FROM accounts WHERE account_code = '11'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('11801', 'بنك فلسطين احمد دنديس\برسم التحصيل', (SELECT id FROM accounts WHERE account_code = '118'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'checks_under_collection', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('119', 'حسابات التوفير', (SELECT id FROM accounts WHERE account_code = '11'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('11901', 'بنك فلسطين\التوفير والودائع', (SELECT id FROM accounts WHERE account_code = '119'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'bank_savings', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('12', 'الموجودات الثابتة', (SELECT id FROM accounts WHERE account_code = '1'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('121', 'القيمة الاولية (الأصول الثابتة)', (SELECT id FROM accounts WHERE account_code = '12'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('12101', 'سيارات وشاحنات نقل ومعدات', (SELECT id FROM accounts WHERE account_code = '121'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('12102', 'آليات ومعدات حفر وبناء ثقيلة', (SELECT id FROM accounts WHERE account_code = '121'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('12103', 'عدد وأدوات بناء وتجهيزات موقع', (SELECT id FROM accounts WHERE account_code = '121'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('12104', 'أجهزة حاسوب ومعدات تقنية ومكاتب', (SELECT id FROM accounts WHERE account_code = '121'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('1211', 'الأراضي', (SELECT id FROM accounts WHERE account_code = '121'), 'asset', 'debit', 'balance_sheet', 4, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('1212', 'المباني والإنشاءات', (SELECT id FROM accounts WHERE account_code = '121'), 'asset', 'debit', 'balance_sheet', 4, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('1213', 'الآلات والمعدات', (SELECT id FROM accounts WHERE account_code = '121'), 'asset', 'debit', 'balance_sheet', 4, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('1214', 'السيارات ووسائل النقل', (SELECT id FROM accounts WHERE account_code = '121'), 'asset', 'debit', 'balance_sheet', 4, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('1215', 'الأثاث والمفروشات', (SELECT id FROM accounts WHERE account_code = '121'), 'asset', 'debit', 'balance_sheet', 4, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('1216', 'أجهزة الحاسوب والبرمجيات', (SELECT id FROM accounts WHERE account_code = '121'), 'asset', 'debit', 'balance_sheet', 4, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('122', 'مجمع استهلاك الأصول الثابتة', (SELECT id FROM accounts WHERE account_code = '12'), 'asset', 'credit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('12201', 'مجمع استهلاك السيارات والآليات الثقيلة', (SELECT id FROM accounts WHERE account_code = '122'), 'asset', 'credit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('1221', 'مجمع استهلاك المباني والإنشاءات', (SELECT id FROM accounts WHERE account_code = '122'), 'asset', 'credit', 'balance_sheet', 4, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('1222', 'مجمع استهلاك الآلات والمعدات', (SELECT id FROM accounts WHERE account_code = '122'), 'asset', 'credit', 'balance_sheet', 4, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('1223', 'مجمع استهلاك السيارات ووسائل النقل', (SELECT id FROM accounts WHERE account_code = '122'), 'asset', 'credit', 'balance_sheet', 4, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('1224', 'مجمع استهلاك الأثاث والمفروشات', (SELECT id FROM accounts WHERE account_code = '122'), 'asset', 'credit', 'balance_sheet', 4, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('1225', 'مجمع استهلاك أجهزة الحاسوب', (SELECT id FROM accounts WHERE account_code = '122'), 'asset', 'credit', 'balance_sheet', 4, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('13', 'الموجودات الأخرى', (SELECT id FROM accounts WHERE account_code = '1'), 'asset', 'debit', 'balance_sheet', 2, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('1301', 'الاعتمادات والشحنات ومصاريف التأسيس', (SELECT id FROM accounts WHERE account_code = '1'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('1302', 'مصاريف مدفوعة مقدماً', (SELECT id FROM accounts WHERE account_code = '13'), 'asset', 'debit', 'balance_sheet', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('1303', 'تأمينات مستردة لدى الغير', (SELECT id FROM accounts WHERE account_code = '13'), 'asset', 'debit', 'balance_sheet', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('1304', 'ضريبة دخل مخصومة من المصدر (لنا)', (SELECT id FROM accounts WHERE account_code = '13'), 'asset', 'debit', 'balance_sheet', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('2', 'المطلوبات', NULL, 'liability', 'credit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('21', 'المطلوبات قصيرة الاجل', (SELECT id FROM accounts WHERE account_code = '2'), 'liability', 'credit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('211', 'الشيكات الاجلة (الصادرة برسم الدفع)', (SELECT id FROM accounts WHERE account_code = '21'), 'liability', 'credit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('21101', 'بنك فلسطين احمد دنديس\برسم الدفع', (SELECT id FROM accounts WHERE account_code = '211'), 'liability', 'credit', 'balance_sheet', 1, 'ILS', 'issued_checks', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('21201', 'ضريبة القيمة المضافة على المخرجات والمبيعات', (SELECT id FROM accounts WHERE account_code = '21'), 'liability', 'credit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('213', 'المستحقات والأمانات', (SELECT id FROM accounts WHERE account_code = '21'), 'liability', 'credit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('21301', 'أمانات اقتطاعات الضرائب والتأمين الصحي', (SELECT id FROM accounts WHERE account_code = '213'), 'liability', 'credit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('2131', 'رواتب وأجور مستحقة', (SELECT id FROM accounts WHERE account_code = '213'), 'liability', 'credit', 'balance_sheet', 4, 'ILS', 'workers_payable', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('2132', 'ضريبة دخل مقتطعة من الرواتب (أمانات)', (SELECT id FROM accounts WHERE account_code = '213'), 'liability', 'credit', 'balance_sheet', 4, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('2133', 'ضريبة خصم من المصدر للموردين (أمانات)', (SELECT id FROM accounts WHERE account_code = '213'), 'liability', 'credit', 'balance_sheet', 4, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('2134', 'مصاريف مستحقة الدفع', (SELECT id FROM accounts WHERE account_code = '213'), 'liability', 'credit', 'balance_sheet', 4, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('2135', 'مخصص مكافأة نهاية الخدمة', (SELECT id FROM accounts WHERE account_code = '213'), 'liability', 'credit', 'balance_sheet', 4, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('22', 'المطلوبات طويلة الاجل', (SELECT id FROM accounts WHERE account_code = '2'), 'liability', 'credit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('221', 'قروض وتسهيلات بنكية طويلة الأجل', (SELECT id FROM accounts WHERE account_code = '22'), 'liability', 'credit', 'balance_sheet', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('22101', 'قروض وتسهيلات بنكية طويلة الاجل', (SELECT id FROM accounts WHERE account_code = '22'), 'liability', 'credit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('3', 'راس المال', NULL, 'equity', 'credit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('31', 'راس مال التأسيس', (SELECT id FROM accounts WHERE account_code = '3'), 'equity', 'credit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('311', 'رأس المال المدفوع', (SELECT id FROM accounts WHERE account_code = '31'), 'equity', 'credit', 'balance_sheet', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('31101', 'رأس مال الشركاء والمساهمين', (SELECT id FROM accounts WHERE account_code = '31'), 'equity', 'credit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('312', 'احتياطي قانوني', (SELECT id FROM accounts WHERE account_code = '31'), 'equity', 'credit', 'balance_sheet', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('313', 'جاري الشركاء', (SELECT id FROM accounts WHERE account_code = '31'), 'equity', 'credit', 'balance_sheet', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('32', 'الارباح والخسائر', (SELECT id FROM accounts WHERE account_code = '3'), 'equity', 'credit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('32101', 'حساب ملخص الأرباح والخسائر', (SELECT id FROM accounts WHERE account_code = '32'), 'equity', 'credit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('32201', 'أرباح غير موزعة ومدورة', (SELECT id FROM accounts WHERE account_code = '32'), 'equity', 'credit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('4', 'المشتريات والمصاريف', NULL, 'expense', 'debit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('41', 'المشتريات', (SELECT id FROM accounts WHERE account_code = '4'), 'expense', 'debit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('41101', 'مشتريات مواد البناء والمستهلكات', (SELECT id FROM accounts WHERE account_code = '41'), 'expense', 'debit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('41201', 'مردودات المشتريات', (SELECT id FROM accounts WHERE account_code = '41'), 'expense', 'credit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('41301', 'خصم مكتسب على المشتريات', (SELECT id FROM accounts WHERE account_code = '41'), 'expense', 'credit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('414', 'مشتريات معفاة / صفرية الضريبة', (SELECT id FROM accounts WHERE account_code = '41'), 'expense', 'debit', 'income_statement', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('42', 'المصاريف العمومية والادارة وتكاليف المشاريع', (SELECT id FROM accounts WHERE account_code = '4'), 'expense', 'debit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('4201', 'مصاريف السيارات سولار ومحروقات وصيانة', (SELECT id FROM accounts WHERE account_code = '42'), 'expense', 'debit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('4202', 'صيانة وترخيص وتأمين السيارات', (SELECT id FROM accounts WHERE account_code = '42'), 'expense', 'debit', 'income_statement', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('4203', 'الرواتب والأجور', (SELECT id FROM accounts WHERE account_code = '42'), 'expense', 'debit', 'income_statement', 3, 'ILS', 'direct_labor_expense', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('4204', 'مكافآت وبدلات ومواصلات', (SELECT id FROM accounts WHERE account_code = '42'), 'expense', 'debit', 'income_statement', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('4205', 'إيجار المقر والمخازن', (SELECT id FROM accounts WHERE account_code = '42'), 'expense', 'debit', 'income_statement', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('4206', 'كهرباء ومياه وخدمات بلدية', (SELECT id FROM accounts WHERE account_code = '42'), 'expense', 'debit', 'income_statement', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('4207', 'اتصالات وإنترنت', (SELECT id FROM accounts WHERE account_code = '42'), 'expense', 'debit', 'income_statement', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('4208', 'قرطاسية ومطبوعات', (SELECT id FROM accounts WHERE account_code = '42'), 'expense', 'debit', 'income_statement', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('4209', 'ضيافة ونظافة', (SELECT id FROM accounts WHERE account_code = '42'), 'expense', 'debit', 'income_statement', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('4210', 'أتعاب مهنية واستشارية', (SELECT id FROM accounts WHERE account_code = '42'), 'expense', 'debit', 'income_statement', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('4211', 'رسوم واشتراكات وتراخيص حكومية', (SELECT id FROM accounts WHERE account_code = '42'), 'expense', 'debit', 'income_statement', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('4212', 'مصاريف وعمولات بنكية', (SELECT id FROM accounts WHERE account_code = '42'), 'expense', 'debit', 'income_statement', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('4213', 'مصاريف إهلاك الموجودات الثابتة', (SELECT id FROM accounts WHERE account_code = '42'), 'expense', 'debit', 'income_statement', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('4214', 'دعاية وإعلان وتسويق', (SELECT id FROM accounts WHERE account_code = '42'), 'expense', 'debit', 'income_statement', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('4215', 'مصاريف عمومية ونثرية أخرى', (SELECT id FROM accounts WHERE account_code = '42'), 'expense', 'debit', 'income_statement', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('43', 'مصاريف المشتريات', (SELECT id FROM accounts WHERE account_code = '4'), 'expense', 'debit', 'income_statement', 2, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('4301', 'مصاريف شحن ونقل للداخل', (SELECT id FROM accounts WHERE account_code = '43'), 'expense', 'debit', 'income_statement', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('4302', 'رسوم جمركية وتخليص', (SELECT id FROM accounts WHERE account_code = '43'), 'expense', 'debit', 'income_statement', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('4303', 'تأمين على البضائع المشتراة', (SELECT id FROM accounts WHERE account_code = '43'), 'expense', 'debit', 'income_statement', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('4304', 'تحميل وتنزيل وتغليف', (SELECT id FROM accounts WHERE account_code = '43'), 'expense', 'debit', 'income_statement', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('5', 'الايرادات', NULL, 'revenue', 'credit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('51', 'ايرادات المبيعات والتشغيل', (SELECT id FROM accounts WHERE account_code = '5'), 'revenue', 'credit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('51101', 'إيرادات مستخلصات وعقود المشاريع الإنشائية', (SELECT id FROM accounts WHERE account_code = '51'), 'revenue', 'credit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('51201', 'مردودات إيرادات ومستخلصات تنفيذية', (SELECT id FROM accounts WHERE account_code = '51'), 'revenue', 'debit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('51301', 'خصم مسموح به للعملاء والمشاريع', (SELECT id FROM accounts WHERE account_code = '51'), 'expense', 'debit', 'balance_sheet', 1, 'ILS', 'allowed_discount', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('514', 'مبيعات معفاة / تصدير (صفرية)', (SELECT id FROM accounts WHERE account_code = '51'), 'revenue', 'credit', 'income_statement', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('52', 'إيرادات مختلفة', (SELECT id FROM accounts WHERE account_code = '5'), 'revenue', 'credit', 'income_statement', 2, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('5201', 'أرباح فروقات عملة', (SELECT id FROM accounts WHERE account_code = '52'), 'revenue', 'credit', 'income_statement', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('5202', 'إيرادات فوائد بنكية', (SELECT id FROM accounts WHERE account_code = '52'), 'revenue', 'credit', 'income_statement', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('5203', 'أرباح بيع أصول ثابتة', (SELECT id FROM accounts WHERE account_code = '52'), 'revenue', 'credit', 'income_statement', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('5204', 'إيرادات متنوعة أخرى', (SELECT id FROM accounts WHERE account_code = '52'), 'revenue', 'credit', 'income_statement', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('52101', 'إيرادات تمويلية وفوائد دائنة وأرباح بيع أصول', (SELECT id FROM accounts WHERE account_code = '5'), 'revenue', 'credit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('6', 'الذمم', NULL, 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('61', 'حساب المدينون', (SELECT id FROM accounts WHERE account_code = '6'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('611', 'حساب الزبائن', (SELECT id FROM accounts WHERE account_code = '61'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('6110001', 'ذمم المشاريع والعملاء العامة', (SELECT id FROM accounts WHERE account_code = '611'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'clients_receivable', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('6110940', 'شركة كوكا كولا التجارية للمواد الغذائية', (SELECT id FROM accounts WHERE account_code = '611'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('6110998', 'ابو انور يافا', (SELECT id FROM accounts WHERE account_code = '611'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('6110999', 'بهاء ابو زهرة', (SELECT id FROM accounts WHERE account_code = '611'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('6111000', 'ابراهيم علي', (SELECT id FROM accounts WHERE account_code = '611'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('6111001', 'احمد الشمالي', (SELECT id FROM accounts WHERE account_code = '611'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('6111002', 'نافز العمور عراد', (SELECT id FROM accounts WHERE account_code = '611'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('6111003', 'محمد العقبة حورة', (SELECT id FROM accounts WHERE account_code = '611'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('6111004', 'علاء ابو ربيعة كسيفة', (SELECT id FROM accounts WHERE account_code = '611'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('6111005', 'ادريس الجعبري', (SELECT id FROM accounts WHERE account_code = '611'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('6111023', 'مراد مجد الكروم', (SELECT id FROM accounts WHERE account_code = '611'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('6111024', 'مشاوي غيث راس الجورة', (SELECT id FROM accounts WHERE account_code = '611'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('612', 'ذمم مدينة أخرى', (SELECT id FROM accounts WHERE account_code = '61'), 'asset', 'debit', 'balance_sheet', 3, 'ILS', 'receivables_account', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('61201', 'سلف وذمم العمال والموظفين (مدينة)', (SELECT id FROM accounts WHERE account_code = '61'), 'asset', 'debit', 'balance_sheet', 1, 'ILS', 'workers_advance', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('613', 'مخصص ديون مشكوك في تحصيلها', (SELECT id FROM accounts WHERE account_code = '61'), 'asset', 'credit', 'balance_sheet', 3, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('62', 'حسابات الدائنون', (SELECT id FROM accounts WHERE account_code = '6'), 'liability', 'credit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('621', 'حساب الموردين', (SELECT id FROM accounts WHERE account_code = '62'), 'liability', 'credit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('621001', 'شركة باطون القدس الحديثة', (SELECT id FROM accounts WHERE account_code = '621'), 'liability', 'credit', 'balance_sheet', 1, 'ILS', 'suppliers_payable', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('621002', 'شركة حديد فلسطين المحدودة', (SELECT id FROM accounts WHERE account_code = '621'), 'liability', 'credit', 'balance_sheet', 1, 'ILS', 'suppliers_payable', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('621003', 'مقاول باطن أعمال حفر وتسوية', (SELECT id FROM accounts WHERE account_code = '621'), 'liability', 'credit', 'balance_sheet', 1, 'ILS', 'suppliers_payable', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('622', 'حساب الموظفين وأجور العمال المستحقة', (SELECT id FROM accounts WHERE account_code = '62'), 'liability', 'credit', 'balance_sheet', 1, 'ILS', 'general', 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('622001', 'مستحقات وأمانات أجور العمال (ذمم دائنة)', (SELECT id FROM accounts WHERE account_code = '622'), 'liability', 'credit', 'balance_sheet', 1, 'ILS', 'workers_payable', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('62301', 'حساب المندوبين والوكلاء التجاريين', (SELECT id FROM accounts WHERE account_code = '62'), 'liability', 'credit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('62401', 'حساب جاري الشركاء والمساهمين', (SELECT id FROM accounts WHERE account_code = '62'), 'liability', 'credit', 'balance_sheet', 1, 'ILS', 'general', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO accounts (account_code, name, parent_id, account_type, account_nature, financial_statement, level, currency, system_tag, is_postable, is_active, created_at, updated_at) VALUES ('625', 'موردو خدمات ومصاريف', (SELECT id FROM accounts WHERE account_code = '62'), 'liability', 'credit', 'balance_sheet', 3, 'ILS', 'payables_account', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

COMMIT;
