summaryrefslogtreecommitdiff
path: root/sql/Sweden_Church_Society-chart.sql
blob: 4cee4378d85c64dd828c5e9419149fba0a25c5f1 (plain) 
    

  1. -- Johan Hambraeus
    2. 

  2. -- May 7, 2006
    3. 

  3. --
    4. 

  4. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1','Tillg�ngar','H','','','');
    5. 

  5. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('10','Immateriella anl�ggningstillg�ngar','H','','','');
    6. 

  6. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1010','Balanserade utgifter','A','','A','');
    7. 

  7. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1019','Ack avskriningar balanserade utg','A','','C','');
    8. 

  8. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1060','Hyresr�tt','A','','A','');
    9. 

  9. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1069','Ack avskrivn hyresr�tt','A','','C','');
    10. 

  10. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('11','Byggnader och mark','H','','A','');
    11. 

  11. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1110','Byggnader','A','','A','IC');
    12. 

  12. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1119','Ack avskrivn byggnader','A','','C','');
    13. 

  13. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1130','Mark','A','','A','IC');
    14. 

  14. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1140','Tomter, markomr obebyggda','A','','A','IC');
    15. 

  15. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1150','Markanl�ggningar','A','','A','IC');
    16. 

  16. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1159','Ack avskrivn markanl�ggn','A','','C','');
    17. 

  17. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1190','�vriga byggnader och mark','A','','A','IC');
    18. 

  18. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('12','Maskiner och inventarier','H','','A','');
    19. 

  19. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1230','Installationer','A','','A','IC');
    20. 

  20. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1238','Ack nedskrivn installationer','A','','C','');
    21. 

  21. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1239','Ack avskrivn installationer','A','','C','');
    22. 

  22. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1250','Datorer','A','','A','IC');
    23. 

  23. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1259','Ack avskrivn datorer','A','','C','');
    24. 

  24. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('13','Finansiella anl�ggningstillg�ngar','H','','A','');
    25. 

  25. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1370','Uppskjuten skattefordran','A','','A','');
    26. 

  26. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1380','L�ngfristiga fordringar','A','','A','');
    27. 

  27. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1400','Fordran hos EFS Gafsele','A','','A','');
    28. 

  28. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1405','Fordran hos EFS H�lla','A','','A','');
    29. 

  29. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('15','Kundfordringar','H','','A','');
    30. 

  30. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1500','Kundfordringar','A','','A','AR');
    31. 

  31. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('16','�vriga kortfristiga fordringar','H','','A','');
    32. 

  32. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1600','�vr kortfristiga fordr','A','','A','');
    33. 

  33. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1710','F�rutbetalda hyror','A','','A','');
    34. 

  34. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1730','F�rutbet f�rs�kringspremier','A','','A','');
    35. 

  35. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1740','F�rutbet r�nteutgifter','A','','A','');
    36. 

  36. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1750','Upplupna hyresinkomster','A','','A','');
    37. 

  37. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1760','Upplupna inkomstr�ntor','A','','A','');
    38. 

  38. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1790','�vr interimsfordringar','A','','A','');
    39. 

  39. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('19','Kassa och Bank','H','','A','');
    40. 

  40. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1910','Kassa','A','','A','AR_paid:AP_paid');
    41. 

  41. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1920','Postgiro','A','','A','AR_paid:AP_paid');
    42. 

  42. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1930','Checkr�kningskonto','A','','A','AR_paid:AP_paid');
    43. 

  43. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1940','�vriga bankkonto','A','','A','AR_paid:AP_paid');
    44. 

  44. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1941','Nordea v�rdepappersfond','A','','A','');
    45. 

  45. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1942','Nordea girokapitalkonto','A','','A','AR_paid:AP_paid');
    46. 

  46. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2','Eget kapital och skulder','H','','A','');
    47. 

  47. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('20','Eget kapital','H','','A','');
    48. 

  48. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2000','Eget kapital EFS �sele','A','','Q','');
    49. 

  49. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2005','Eget kapital EFS Gafsele','A','','Q','');
    50. 

  50. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2010','Eget kapital EFS H�lla','A','','Q','');
    51. 

  51. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2070','�ndam�lsbest�mda medel','A','','Q','');
    52. 

  52. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2091','Balanserad vinst/f�rlust','A','','Q','');
    53. 

  53. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2098','Vinst/f�rlust f�reg �r','A','','Q','');
    54. 

  54. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2099','Redovisat resultat','A','','Q','');
    55. 

  55. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('22','Avs�ttningar','H','','L','');
    56. 

  56. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2250','Avs�ttning f�r skatter','A','','L','');
    57. 

  57. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2290','�vriga avs�ttningar','A','','L','');
    58. 

  58. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('23','Skulder','H','','L','');
    59. 

  59. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2300','Skuld till EFS Gafsele','A','','L','');
    60. 

  60. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2310','Skuld till EFS H�lla','A','','L','');
    61. 

  61. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2320','Skuld till fam Norlin','A','','L','');
    62. 

  62. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2330','Checkr�kningskredit','A','','L','');
    63. 

  63. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2399','�vr l�ngfristiga skulder','A','','L','');
    64. 

  64. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2440','Leverant�rsskulder','A','','L','AP');
    65. 

  65. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2499','�vr kortfristiga skulder','A','','L','');
    66. 

  66. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2960','Upplupna utgiftsr�ntor','A','','L','');
    67. 

  67. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2971','F�rutbetalda hyresint�kter','A','','L','');
    68. 

  68. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2972','F�rutbetalda medlemsavgifter','A','','L','');
    69. 

  69. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2979','�vriga f�rutbetalda int�kter','A','','L','');
    70. 

  70. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2990','�vr interimsskulder','A','','L','');
    71. 

  71. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2999','�vr uppl kostn/f�rutbet int�kter','A','','L','');
    72. 

  72. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3','Int�kter','H','','I','');
    73. 

  73. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('30','Allm�nna g�vor','H','','I','');
    74. 

  74. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3000','G�vor via konto','A','','I','AR_amount');
    75. 

  75. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3005','Minnesg�vor','A','','I','AR_amount');
    76. 

  76. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3010','Gudstj�nstkollekter','A','','I','AR_amount');
    77. 

  77. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3015','Fika/kaffe/fester - g�vor','A','','I','AR_amount');
    78. 

  78. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('31','�ronm�rkta g�vor','H','','I','');
    79. 

  79. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3100','�ronm�rkta g�vor','A','','I','AR_amount');
    80. 

  80. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3101','G�vor barnarbete','A','','I','AR_amount');
    81. 

  81. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3102','G�vor k�rs�ng','A','','I','AR_amount');
    82. 

  82. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3103','G�vor b�negrupper','A','','I','AR_amount');
    83. 

  83. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3104','G�vor Alfa-grupper','A','','I','AR_amount');
    84. 

  84. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3105','�vrigt lokalt arbete','A','','I','AR_amount');
    85. 

  85. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3106','G�vor till fastighet mm','A','','I','AR_amount');
    86. 

  86. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3109','G�vor �sele allkristna gemenskap','A','','I','AR_amount');
    87. 

  87. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3110','G�vor EFS V�sterbotten','A','','I','AR_amount');
    88. 

  88. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3111','G�vor distriktskonferens','A','','I','AR_amount');
    89. 

  89. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3112','G�vor Scoutverksamhet','A','','I','AR_amount');
    90. 

  90. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3120','G�vor EFS riks','A','','I','AR_amount');
    91. 

  91. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3121','G�vor EFS riks konferens','A','','I','AR_amount');
    92. 

  92. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3122','G�vor EFS Inre mission','A','','I','AR_amount');
    93. 

  93. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3123','G�vor EFS Yttre mission','A','','I','AR_amount');
    94. 

  94. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3130','G�vor Barn i alla l�nder','A','','I','AR_amount');
    95. 

  95. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3131','G�vor Johannelundsinsamling','A','','I','AR_amount');
    96. 

  96. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3132','G�vor P�skinsamling','A','','I','AR_amount');
    97. 

  97. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3133','G�vor Flodv�gens offer','A','','I','AR_amount');
    98. 

  98. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('33','F�rs�ljningsint�kter','H','','I','');
    99. 

  99. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3300','F�rs�ljning bokbordet','A','','I','IC_sale');
    100. 

  100. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3350','F�rs�ljning fika mm','A','','I','IC_sale');
    101. 

  101. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34','Medlemsavgifter','H','','I','');
    102. 

  102. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3400','Medlemsavgifter','A','','I','IC_income');
    103. 

  103. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3405','Medlemsavgifter Solglimten','A','','I','IC_income');
    104. 

  104. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('345','Hyresint�kter','H','','I','');
    105. 

  105. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3450','Hyresint�kter, hyreskontrakt','A','','I','IC_income');
    106. 

  106. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3460','Hyresint�kter, enstaka tillf�lle','A','','I','IC_income');
    107. 

  107. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3470','Hyresint Ers�ttning telefonkostnad','A','','I','IC_income');
    108. 

  108. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('35','Bidrag','H','','I','');
    109. 

  109. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3510','Erh�llna statliga bidrag','A','','I','AR_amount');
    110. 

  110. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3520','Erh�llna kommunala bidrag','A','','I','AR_amount');
    111. 

  111. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3530','Bidrag Svenska kyrkan','A','','I','AR_amount');
    112. 

  112. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3590','�vriga erh�llna bidrag','A','','I','AR_amount');
    113. 

  113. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('36','�vriga int�kter','H','','I','');
    114. 

  114. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3690','�vriga sidoint�ker','A','','I','');
    115. 

  115. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3731','Kassarabatter','A','','I','');
    116. 

  116. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3740','�resutj�mning','A','','I','');
    117. 

  117. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3960','Valuta kursvinst','A','','I','');
    118. 

  118. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3972','Vinst avyttr fastigheter','A','','I','');
    119. 

  119. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3973','Vinst avyttr maskiner/inv','A','','I','');
    120. 

  120. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3990','�vr ers�ttn och int�ker','A','','I','');
    121. 

  121. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3994','F�rs�kringsers�ttningar','A','','I','');
    122. 

  122. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4','Utgifter','H','','E','');
    123. 

  123. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4000','Kostnad f�r predikant','A','','E','AP_amount');
    124. 

  124. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4050','Reskostnader f�r predikant','A','','E','AP_amount');
    125. 

  125. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('41','Utgifter �ronm�rkta g�vor','H','','E','');
    126. 

  126. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4100','Kostnad �ronm�rkta g�vor','A','','E','AP_amount');
    127. 

  127. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4101','Kostnad barnarbete','A','','E','AP_amount');
    128. 

  128. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4102','Kostnad k�rer','A','','E','AP_amount');
    129. 

  129. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4103','Kostnad b�negrupper','A','','E','AP_amount');
    130. 

  130. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4104','Kostnad Alfa','A','','E','AP_amount');
    131. 

  131. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4105','Kostnad �vrigt lokalt arbete','A','','E','AP_amount');
    132. 

  132. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4106','Kostnad Fastighet (s�rskilt)','A','','E','AP_amount');
    133. 

  133. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4107','Kostnad scouting barnarbete','A','','E','AP_amount');
    134. 

  134. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4109','�sele allkristna gemenskap','A','','E','AP_amount');
    135. 

  135. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4110','EFS V�sterbotten','A','','E','AP_amount');
    136. 

  136. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4111','distriktskonferens','A','','E','AP_amount');
    137. 

  137. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4120','EFS riks','A','','E','AP_amount');
    138. 

  138. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4121','EFS riks konferensinsamling','A','','E','AP_amount');
    139. 

  139. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4122','EFS inre mission','A','','E','AP_amount');
    140. 

  140. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4123','EFS yttre mission','A','','E','AP_amount');
    141. 

  141. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4130','Barn i alla l�nder','A','','E','AP_amount');
    142. 

  142. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4131','Johannelundinsamling','A','','E','AP_amount');
    143. 

  143. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4132','P�skinsamling','A','','E','AP_amount');
    144. 

  144. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4133','Till Flodv�gens offer','A','','E','AP_amount');
    145. 

  145. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('43','Ink�pskostnader mm','H','','E','');
    146. 

  146. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4300','Ink�p bokbord','A','','E','IC_cogs');
    147. 

  147. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4350','Ink�p matr fika mm','A','','E','IC_cogs');
    148. 

  148. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4400','Pren V�rt budskap (distr tidning)','A','','E','IC_expense');
    149. 

  149. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4600','Inhyrda predikanter/f�rel�sare','A','','E','AP_amount');
    150. 

  150. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4700','Tidningar, facklitteratur','A','','E','IC_expense');
    151. 

  151. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4900','F�reningsavgifter','A','','E','IC_expense');
    152. 

  152. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('50','Lokalkostnader hyrd lokal','H','','E','');
    153. 

  153. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5010','Lokalhyra','A','','E','');
    154. 

  154. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5020','El','A','','E','');
    155. 

  155. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5030','V�rme hyrd lokal','A','','E','');
    156. 

  156. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5050','Lokaltillbeh�r hyrd lokal','A','','E','');
    157. 

  157. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5060','St�dning, renh�llning hyrd lokal','A','','E','');
    158. 

  158. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5070','Reparationer hyrd lokal','A','','E','');
    159. 

  159. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5090','�vr kostnader hyrd lokal','A','','E','');
    160. 

  160. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('51','Lokalkostnader egen lokal','H','','E','');
    161. 

  161. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5120','Belysning','A','','E','');
    162. 

  162. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5130','V�rme','A','','E','');
    163. 

  163. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5132','Sotning','A','','E','');
    164. 

  164. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5140','Vatten och avlopp','A','','E','');
    165. 

  165. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5160','Renh�lln och st�dning','A','','E','');
    166. 

  166. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5170','Rep och underh�ll fastighet','A','','E','');
    167. 

  167. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5191','Fastighetsskatt','A','','E','');
    168. 

  168. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5192','F�rs�kringsprem fastighet','A','','E','');
    169. 

  169. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5193','Fastighetssk�tsel och f�rvaltning','A','','E','');
    170. 

  170. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5199','�vr fastighetskostnader','A','','E','');
    171. 

  171. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('52','�vriga kostnader','H','','E','');
    172. 

  172. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5210','Hyra arbetsmaskiner','A','','E','');
    173. 

  173. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5220','Hyra inventarier','A','','E','');
    174. 

  174. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5290','�vr hyreskostn anl tillg','A','','E','');
    175. 

  175. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5390','�vriga br�nslen','A','','E','');
    176. 

  176. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5410','F�rbrukningsinventarier','A','','E','');
    177. 

  177. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5460','F�rbrukningsmaterial','A','','E','');
    178. 

  178. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5480','Arbetskl�der o skyddsmtrl','A','','E','');
    179. 

  179. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5500','Reparation och underh�ll','A','','E','');
    180. 

  180. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5710','Frakt och transport','A','','E','');
    181. 

  181. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5800','Resekostnader','A','','E','');
    182. 

  182. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5910','Annonsering','A','','E','');
    183. 

  183. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5930','Reklamtrycksaker','A','','E','');
    184. 

  184. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5990','�vrig reklam','A','','E','');
    185. 

  185. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6110','Kontorsmaterial','A','','E','');
    186. 

  186. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6150','Trycksaker','A','','E','');
    187. 

  187. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6210','Telefon','A','','E','');
    188. 

  188. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6250','Porto','A','','E','');
    189. 

  189. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6310','F�rs�kringar','A','','E','');
    190. 

  190. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6320','Sj�lvrisker','A','','E','');
    191. 

  191. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6340','L�mnade skadest�nd','A','','E','');
    192. 

  192. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('64','F�rvaltningskostnader','H','','E','');
    193. 

  193. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6490','�vr f�rvaltningskostnader','A','','E','');
    194. 

  194. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6530','Redovisningstj�nster','A','','E','');
    195. 

  195. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6540','IT-tj�nster','A','','E','');
    196. 

  196. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6550','Konsultarvoden','A','','E','');
    197. 

  197. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('65','Bankkostnader','H','','E','');
    198. 

  198. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6570','Bankkostnader, Nordea','A','','E','');
    199. 

  199. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6571','Bankkostnader, Postgirot','A','','E','');
    200. 

  200. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6572','Bankkostnader, Bankgiro','A','','E','');
    201. 

  201. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6573','Bankkostnader, F�reningssparbank','A','','E','');
    202. 

  202. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('658','Fr�mmande tj�nster','H','','E','');
    203. 

  203. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6580','Advokatkostnader','A','','E','');
    204. 

  204. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6590','�vr fr�mmande tj�nster','A','','E','');
    205. 

  205. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7','Avskrivningar och eng�ngskostn','H','','E','');
    206. 

  206. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7780','Avskrivningar enligt plan','A','','E','');
    207. 

  207. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7811','Avskrivningar balanserade utgifter','A','','E','');
    208. 

  208. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7820','Avskrivningar byggnader/mark','A','','E','');
    209. 

  209. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7821','Avskrivn byggnader','A','','E','');
    210. 

  210. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7822','Avskrivn byggnadsinv','A','','E','');
    211. 

  211. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7824','Avskrivn markanl�ggn','A','','E','');
    212. 

  212. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7829','Avskrivningar �vr byggnader','A','','E','');
    213. 

  213. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7832','Avskrivn inventarier','A','','E','');
    214. 

  214. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7833','Avskrivningar installationer','A','','E','');
    215. 

  215. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7835','Avskrivningar datorer','A','','E','');
    216. 

  216. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7921','Kostn av eng�ngskarakt�r ','A','','E','');
    217. 

  217. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7960','Valutakursf�rlust','A','','E','');
    218. 

  218. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8','Financiella int�kter o kostnader','H','','E','');
    219. 

  219. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('83','R�nteint�kter','H','','I','');
    220. 

  220. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8300','R�nteint�kter ','A','','I','');
    221. 

  221. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8390','�vr finansiella int�kter','A','','I','');
    222. 

  222. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('84','R�ntekostnader','H','','E','');
    223. 

  223. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8400','R�ntekostnader','A','','E','');
    224. 

  224. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8490','�vr finansiella kostnader','A','','E','');
    225. 

  225. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('891','Skatter','H','','E','');
    226. 

  226. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8910','�rets skattekostnad','A','','E','');
    227. 

  227. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('899','Redovisat resultat','H','','E','');
    228. 

  228. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8999','Redovisat resultat','A','','E','');
    229. 

  229. --
    230. 

  230. update defaults set inventory_accno_id = (select id from chart where accno ='1130'), income_accno_id = (select id from chart where accno = '3400'), expense_accno_id = (select id from chart where accno = '4400'), fxgain_accno_id = (select id from chart where accno = '3960'), fxloss_accno_id = (select id from chart where accno = '7960'), curr = 'SEK:EUR:USD', weightunit = 'kg';
    231. 

  231.
generated by cgit v1.2.3 (git 2.46.0) at 2025-03-03 06:20:28 +0000