summaryrefslogtreecommitdiff
path: root/sql/Egypt-UTF8-chart.sql
blob: 135b2a017285bfd9d37e5410a8b4d818786b3595 (plain)
  1. begin;
  2. --
  3. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2210','Workers Comp Payable','A','L','','');
  4. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2220','Vacation Pay Payable','A','L','','');
  5. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2250','Pension Plan Payable','A','L','','');
  6. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2260','Employment Insurance Payable','A','L','','');
  7. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5420','Employment Insurance Expense','A','E','','');
  8. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5430','Pension Plan Expense','A','E','','');
  9. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5440','Workers Comp Expense','A','E','','');
  10. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5470','Employee Benefits','A','E','','');
  11. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5650','Capital Cost Allowance Expense','A','E','','');
  12. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1060','نقدية بالبنك','A','A','AR_paid:AP_paid','');
  13. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1065','نقديةبالصندوق','A','A','AR_paid:AP_paid','');
  14. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1520','مخزون - قطع غيار كمبيوتر','A','A','IC','');
  15. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1530','مخزون - برامج','A','A','IC','');
  16. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1540','مخزون - قطع اخرى','A','A','IC','');
  17. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1840','سيارات','A','A','','');
  18. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1000','الاصول المتداولة','H','A','','');
  19. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1500','المخزون كاصل','H','A','','');
  20. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1800','الاصول الثابتة','H','A','','');
  21. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2000','التزامات قصيرة الاجل','H','L','','');
  22. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2600','التزامات طويلة الاجل','H','L','','');
  23. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1845','مخصص اهلاك سيارات','A','A','','','1');
  24. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1820','اثاث مكتبى و معدات','A','A','','');
  25. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno,contra) VALUES ('1825','مخصص اهلاك اثاث مكتبى و معدات','A','A','','','1');
  26. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2310','ضريبة مبيعات (10%)','A','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice','');
  27. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2320','ضريبة مبيعات (14%)','A','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice','');
  28. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2330','ضريبة مبيعات (30%)','A','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice','');
  29. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1200','عملاء','A','A','AR','');
  30. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1205','مخصص ديون معدومة','A','A','','');
  31. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2100','موردين','A','L','AP','');
  32. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2160','ضريبة شركات مستحقة','A','L','','');
  33. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2190','ضريبة دخل مستحقة','A','L','','');
  34. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2620','قروض من البنوك','A','L','','');
  35. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2680','قروض من حملة الاسهم','A','L','AP_paid','');
  36. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3300','حقوق الملكية','H','Q','','');
  37. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4020','مبيعات - قطع غيار','A','I','AR_amount:IC_sale','');
  38. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4030','مبيعات برامج','A','I','AR_amount:IC_sale','');
  39. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4040','مبيعات اخرى','A','I','AR_amount:IC_sale','');
  40. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4000','ايراد المبيعات','H','I','','');
  41. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4300','ايراد استشارات','H','I','','');
  42. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4320','استشارات','A','I','AR_amount:IC_income','');
  43. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4330','برمجة','A','I','AR_amount:IC_income','');
  44. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4400','ايرادات اخرى','H','I','','');
  45. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4430','شحن و تعبئة','A','I','IC_income','');
  46. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4440','فائدة','A','I','','');
  47. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4450','ارباح تغيير عملة','A','I','','');
  48. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5000','تكلفة البضاعة المباعة','H','E','','');
  49. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5010','مشتريات','A','E','AP_amount:IC_cogs:IC_expense','');
  50. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5020','تكلفة البضاعة المباعة - قطع غيار','A','E','AP_amount:IC_cogs','');
  51. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5030','تكلفة البضاعة المباعة - برامج','A','E','AP_amount:IC_cogs','');
  52. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5040','تكلفة البضاعة المباعة - اخرى','A','E','AP_amount:IC_cogs','');
  53. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5100','شحن','A','E','AP_amount:IC_expense','');
  54. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5400','مصروفات الاجور','H','E','','');
  55. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5410','المرتبات','A','E','','');
  56. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3350','الاسهم','A','Q','','');
  57. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5600','مصروفات ادارية و عمومية','H','E','','');
  58. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5610','قانونية و محاسبية','A','E','AP_amount','');
  59. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5615','دعاية و اعلان','A','E','AP_amount','');
  60. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5765','اصلاح و صيانة','A','E','AP_amount','');
  61. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5680','ضريبة دخل','A','E','','');
  62. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5685','تامين','A','E','AP_amount','');
  63. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5620','ديون معدومة ','A','E','','');
  64. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5660','مصاريف اهلاك','A','E','','');
  65. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5690','قوائد و مصاريف بنكية','A','E','','');
  66. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5700','مهمات مكتبية','A','E','AP_amount','');
  67. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5780','تلفون','A','E','AP_amount','');
  68. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5760','ايجار','A','E','AP_amount','');
  69. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5785','مصاريف سفر','A','E','','');
  70. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5795','رسوم','A','E','AP_amount','');
  71. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5800','رخص','A','E','AP_amount','');
  72. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5810','خسارة تحويل عملة','A','E','','');
  73. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5790','مرافق','A','E','AP_amount','');
  74. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2280','ضرائب مرتبات مستحقة','A','L','','');
  75. INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE accno = '1520'));
  76. INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (SELECT id FROM chart WHERE accno = '4020'));
  77. INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE accno = '5010'));
  78. INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE accno = '4450'));
  79. INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE accno = '5810'));
  80. INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
  81. INSERT INTO defaults (setting_key, value) VALUES ('curr', 'USD:CAD:EUR';
  82. INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno = '2310'),'0.1',NULL);
  83. INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno = '2320'),'0.14',NULL);
  84. INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart WHERE accno = '2330'),'0.3',NULL);
  85. commit;