le to name it for gitweb.
summaryrefslogtreecommitdiff
path: root/sql/Sweden_Agriculture-chart.sql
blob: 96dbc8662adbf80e44cbcd39b93782678e154064 (plain) 
    

  1. -- COA for Agriculture
    2. 

  2. -- Johan Hambraeus
    3. 

  3. -- May 7, 2006
    4. 

  4. --
    5. 

  5. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('075','Observationskonton','H','','','');
    6. 

  6. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0750','Uttagna förmåner ','A','','L','AP_amount:IC_cogs:IC_expense');
    7. 

  7. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0751','Bostadsförmåner ','A','','A','AP_amount:IC_cogs:IC_expense');
    8. 

  8. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0752','Kostförmåner ','A','','A','AP_amount:IC_cogs:IC_expense');
    9. 

  9. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0753','Fria resor tor arbete','A','','A','AP_amount:IC_cogs:IC_expense');
    10. 

  10. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0754','Fria arbetsresor ','A','','A','AP_amount:IC_cogs:IC_expense');
    11. 

  11. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0755','Bilförmån ','A','','A','AP_amount:IC_cogs:IC_expense');
    12. 

  12. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0756','Rtaförmån ','A','','A','AP_amount:IC_cogs:IC_expense');
    13. 

  13. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0759','Övr.förmåner ','A','','A','AP_amount:IC_cogs:IC_expense');
    14. 

  14. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1','Tillgångar ','H','','','');
    15. 

  15. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('10','Immater. anl.tillg','H','','','');
    16. 

  16. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1010','Balanserade utg','A','234','A','IC');
    17. 

  17. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1011','Bal.utg forskn/utv','A','234','A','IC');
    18. 

  18. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1012','Bal.utg dataprogram','A','234','A','IC');
    19. 

  19. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1019','Ack avskr bal.utg','A','234','C','IC');
    20. 

  20. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1020','Koncessioner m m ','A','234','A','IC');
    21. 

  21. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1029','Ack avskr koncess.','A','234','C','IC');
    22. 

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

  23. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1039','Ack avskr på patent','A','234','C','IC');
    24. 

  24. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1040','Licenser ','A','234','A','IC');
    25. 

  25. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1049','Ack avskr licenser','A','234','C','IC');
    26. 

  26. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1050','Varumärken ','A','234','A','IC');
    27. 

  27. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1059','Ack avskr varumärken','A','234','C','IC');
    28. 

  28. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1060','Hyresrätter ','A','234','A','IC');
    29. 

  29. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1069','Ack avskr hyresr.','A','234','C','IC');
    30. 

  30. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1070','Goodwill ','A','234','A','IC');
    31. 

  31. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1079','Ack avskr på goodw.','A','234','C','IC');
    32. 

  32. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1080','Påg proj o försk','A','234','A','IC');
    33. 

  33. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1081','Påg f imm anl.tillg','A','234','A','IC');
    34. 

  34. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1088','Försk imm anl.tillg','A','234','A','IC');
    35. 

  35. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1090','Övr imm anl.tillg','A','234','A','IC');
    36. 

  36. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1099','Ack avskr ö im.an.t','A','234','C','IC');
    37. 

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

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

  39. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1111','Byggnader egen mark','A','237','A','IC');
    40. 

  40. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1112','Byggnader ofri grund','A','237','A','IC');
    41. 

  41. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1119','Ack avskr byggnader','A','237','C','IC');
    42. 

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

  43. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1140','Tomter/obeb.mark','A','237','A','IC');
    44. 

  44. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1150','Markanläggning','A','237','A','IC');
    45. 

  45. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1159','Ack avskr markanl','A','237','C','IC');
    46. 

  46. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1180','Påg nyanl/förs byg/m','A','237','A','IC');
    47. 

  47. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1181','Pågående nybyggnad','A','237','A','IC');
    48. 

  48. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1182','Pågående tillbyggn','A','237','A','IC');
    49. 

  49. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1183','Pågående ombyggnad','A','237','A','IC');
    50. 

  50. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1188','Försk byggn/mark','A','237','A','IC');
    51. 

  51. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1190','Övr byggn/mark','A','237','A','IC');
    52. 

  52. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1199','Ack avskr övr.byggn','A','237','C','IC');
    53. 

  53. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('12','Maskiner och inv ','H','','A','');
    54. 

  54. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1200','Maskiner och inv','A','236','A','IC');
    55. 

  55. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1209','Ack av. mask o inv','A','236','C','IC');
    56. 

  56. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1210','Mask.tekn.anläggnin','A','236','A','IC');
    57. 

  57. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1211','Maskiner','A','236','A','IC');
    58. 

  58. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1212','Byggnadsinventarier','A','236','A','IC');
    59. 

  59. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1213','Andra tekn anl','A','236','A','IC');
    60. 

  60. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1219','Ack avs mask/t.anl','A','236','C','IC');
    61. 

  61. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1220','Inv och verktyg','A','236','A','IC');
    62. 

  62. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1229','Ack avskr inv verkt','A','236','C','IC');
    63. 

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

  64. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1231','Install.eg fastigh','A','236','A','IC');
    65. 

  65. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1232','Inst. annans fast','A','236','A','IC');
    66. 

  66. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1233','Förb.utg. an.fast','A','236','A','IC');
    67. 

  67. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1239','Ack avs install','A','236','C','IC');
    68. 

  68. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1240','Bilar o a trsp','A','236','A','IC');
    69. 

  69. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1249','Ack av bilar/trsp','A','236','C','IC');
    70. 

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

  71. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1251','Datorer - företaget','A','236','A','IC');
    72. 

  72. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1257','Datorer - personal','A','236','A','IC');
    73. 

  73. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1259','Ack avskr datorer','A','236','C','IC');
    74. 

  74. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1260','Leasingavtal','A','236','A','IC');
    75. 

  75. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1269','Ack avs leasingavt','A','236','C','IC');
    76. 

  76. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1270','Anläggningsdjur','A','236','A','IC');
    77. 

  77. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1279','Ack avskr anl.djur','A','236','C','IC');
    78. 

  78. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1280','Påg nyanl o försk','A','236','A','IC');
    79. 

  79. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1281','Påg nyanläggningar','A','236','A','IC');
    80. 

  80. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1288','Förskott mask.o inv','A','236','A','IC');
    81. 

  81. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1290','Övr mask. o inv','A','236','A','IC');
    82. 

  82. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1291','Konst och likn','A','236','A','IC');
    83. 

  83. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1292','Inv.i annans fastig','A','236','A','IC');
    84. 

  84. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1299','Ack avs övr ma./inv','A','236','C','IC');
    85. 

  85. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('13','Finansiella anl.tillg','H','','A','');
    86. 

  86. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1310','Akt/andel koncernf.','A','230','A','');
    87. 

  87. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1311','Akt/and sv.do.för.','A','230','A','');
    88. 

  88. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1312','Akt/and utl.do.för','A','231','A','');
    89. 

  89. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1313','Akt öv.sv.konc.för','A','230','A','');
    90. 

  90. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1314','Akt öv.utl.kon.för','A','231','A','');
    91. 

  91. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1319','Värderegl akt/and','A','230','A','');
    92. 

  92. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1320','Långfr fordr ko.f.','A','241/233','A','');
    93. 

  93. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1321','Fordr moderföretag','A','241/234','A','');
    94. 

  94. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1322','Fordr dotterföretag','A','241/235','A','');
    95. 

  95. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1323','Fordr andra kon.för','A','241/236','A','');
    96. 

  96. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1329','Värderegl långf.ford','A','241/233','A','');
    97. 

  97. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1330','Akt/and intresseför','A','230','A','');
    98. 

  98. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1339','Värderegl akt/an i.f','A','230','A','');
    99. 

  99. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1340','Långfr ford intr.för','A','241/233','A','');
    100. 

  100. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1349','Värderegl l.fr.fordr','A','241/233','A','');
    101. 

  101. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1350','Akt/and/värdep öv.f','A','233/230','A','');
    102. 

  102. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1351','Aktier börsn. bolag','A','233/230','A','');
    103. 

  103. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1352','Övr aktier och andel','A','233/230','A','');
    104. 

  104. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1353','Andel bostadsrättsf','A','233','A','');
    105. 

  105. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1354','Obligationer','A','233','A','');
    106. 

  106. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1359','Värderegl öv.akt mm','A','233/230','A','');
    107. 

  107. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1380','Andra långfr fordr','A','233','A','');
    108. 

  108. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1381','Reversfordringar','A','233','A','');
    109. 

  109. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1382','Fordr hos anställda','A','233','A','');
    110. 

  110. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1383','Lämnade depositioner','A','233','A','');
    111. 

  111. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1384','Lån t närståen.pers','A','233','A','');
    112. 

  112. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1385','Värde av kap.försäk','A','233','A','');
    113. 

  113. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1386','Förutbet leasingavg','A','233','A','');
    114. 

  114. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1387','Långfr kontraktsfor','A','233','A','');
    115. 

  115. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1388','Olika långfr fordr','A','233','A','');
    116. 

  116. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1389','Värderegl långfr.f','A','233','A','');
    117. 

  117. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1390','Värder.värdep/l.fr.f','A','233','A','');
    118. 

  118. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('14','Lager och påg arb','H','','A','');
    119. 

  119. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1400','Lager','A','219','A','IC');
    120. 

  120. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1401','Inneliggande lager','A','219','A','');
    121. 

  121. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1402','Varor på väg ','A','219','A','');
    122. 

  122. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1403','Konsignationslager','A','219','A','');
    123. 

  123. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1404','Lager av värdepapper','A','219','A','');
    124. 

  124. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1409','För. av lager','A','219','A','');
    125. 

  125. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1410','Lag råvaror (förråd)','A','219','A','');
    126. 

  126. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1419','För. lag råvaror','A','219','A','');
    127. 

  127. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1420','Lager tills/förnöd','A','219','A','');
    128. 

  128. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1429','För lager t/förnöd','A','219','A','');
    129. 

  129. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1430','Lager halvfabrikat','A','219','A','');
    130. 

  130. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1431','Lager köpt halvfab','A','219','A','');