summaryrefslogtreecommitdiff
path: root/sql/coa/lv/chart/General.sql
blob: 0fef5ecbeac089cab742b624f6f466b89fe41457 (plain) 
    

  1. begin;
    2. 

  2. -- Latvian COA
    3. 

  3. -- prepared by Kaspars Melkis <info@isolis.lv>
    4. 

  4. -- Sept. 14, 2003
    5. 

  5. -- checked and edited Sept. 20, 2003, D. Simader
    6. 

  6. --
    7. 

  7. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1','Ilgtermiòa ieguldîjumi','H','A','','');
    8. 

  8. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2','Apgrozâmie lîdzekïi','H','A','','');
    9. 

  9. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('11','Nemateriâlie ieguldîjumi','H','A','','');
    10. 

  10. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('12','Pamatlîdzekïi','H','A','','');
    11. 

  11. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1210','Zemes gabali, çkas, bûves, ilggadîgie stâdîjumi un citi nekustamâ îpaðuma objekti','A','A','IC','');
    12. 

  12. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1290','Pamatlîdzekïu nolietojums (pasîvâ)','A','A','IC','');
    13. 

  13. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('13','Ilgtermiòa finansu ieguldîjumi','H','A','','');
    14. 

  14. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('21','Krâjumi','H','A','','');
    15. 

  15. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2130','Gatavâs preces pârdoðanai','A','A','IC','');
    16. 

  16. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2310','Norçíini ar pircçjiem un pasûtîtâjiem','A','L','AP','');
    17. 

  17. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('23','Norçíini par prasîbâm (ar debitoriem)','H','I','','');
    18. 

  18. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2350','Norçíini ar citiem debitoriem','A','A','AR_amount','');
    19. 

  19. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('26','Naudas lîdzekïi','H','A','','');
    20. 

  20. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2610','Kase','A','A','AR_paid:AP_paid','');
    21. 

  21. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1380','Aizdevumi uzòçmuma dalîbniekiem un valdei','A','A','','');
    22. 

  22. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1310','Lîdzdalîba meitas uzòçmumu kapitâlâ','A','A','','');
    23. 

  23. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1340','Aizdevumi saistîtajiem uzòçmumiem','A','A','','');
    24. 

  24. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1350','Pârçjie vçrtspapîri','A','A','','');
    25. 

  25. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5','Kreditori','H','L','','');
    26. 

  26. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1370','Paðu akcijas un daïas','A','A','','');
    27. 

  27. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2210','Pieauguðie produktîvie lopi','A','A','','');
    28. 

  28. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3350','Statûtos paredzçtâs rezerves','A','Q','','');
    29. 

  29. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2220','Jaunlopi un sîkie dzîvnieki','A','A','','');
    30. 

  30. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2320','Par piegâdçm un pasûtîjumiem saòemtie vekseïi','A','A','IC','');
    31. 

  31. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2140','Nepabeigtie pasûtîjumi','A','A','','');
    32. 

  32. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2370','Îstermiòa aizdevumi sabiedrîbâm dalîbniekiem un vadîbai','A','A','AP_paid','');
    33. 

  33. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1360','Pârçjie aizdevumi','A','A','','');
    34. 

  34. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2120','Nepabeigtie raþojumi','A','A','','');
    35. 

  35. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2330','Meitas uzòçmumu parâdi','A','A','','');
    36. 

  36. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2340','Saistîto uzòçmumu parâdi','A','A','','');
    37. 

  37. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2380','Norçíini par prasîbâm pret personâlu un îstermiòa aizdevumi personâlam','A','A','','');
    38. 

  38. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2410','Nâkamo periodu izdevumi','A','A','','');
    39. 

  39. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2420','Akciju emisijas  nocenojums (disagio)','A','A','','');
    40. 

  40. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('25','Vçrtspapîri apgrozâmo lîdzekïu sastâvâ un îstermiòa lîdzdalîba kapitâlos','H','A','','');
    41. 

  41. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2510','Meitas  uzòçmuma akcijas un daïas ','A','A','','');
    42. 

  42. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2520','Saistîto uzòçmuma akcijas un daïas ','A','A','','');
    43. 

  43. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2530','Paðu  uzòçmuma akcijas un daïas ','A','A','','');
    44. 

  44. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2540','Pârçjie vçrtspapîri un lîdzdalîba kapitâlos','A','A','','');
    45. 

  45. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2640','Akreditîvi, èeki un îpaðu norçíina  formu konti','A','A','AR_paid:AP_paid','');
    46. 

  46. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2650','Citi konti bankâs','A','A','AR_paid:AP_paid','');
    47. 

  47. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2670','Pârçjie naudas lîdzekïi','A','A','','');
    48. 

  48. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3','Paðu kapitâls','H','Q','','');
    49. 

  49. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3130','Ilgtermiòa ieguldîjuma pârvçrtçðanas rezerve','A','Q','','');
    50. 

  50. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3120','Akciju emisijas uzcenojums (agio)','A','Q','','');
    51. 

  51. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('32','Privâtkonti','H','Q','','');
    52. 

  52. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3210','Privâtiem nolûkiem izòemtie lîdzekïi','A','Q','','');
    53. 

  53. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('33','Rezerves ','H','Q','','');
    54. 

  54. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3310','Rezerves kapitâls','A','Q','','');
    55. 

  55. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3330','Citas likumâ paredzçtâs  rezerves','A','Q','','');
    56. 

  56. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3340','Rezerves paðu akcijâm un daïâm','A','Q','','');
    57. 

  57. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3360','Pârçjâs rezerves','A','Q','','');
    58. 

  58. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('34','Nesadalîtâ peïòa vai nesegtie zaudçjumi','H','Q','','');
    59. 

  59. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3410','Pârskata gada nesadalîtâ peïòa','A','Q','','');
    60. 

  60. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3420','Iepriekðçjo gadu nesadalîtâ peïòa','A','Q','','');
    61. 

  61. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4','Uzkrâjumi','H','L','','');
    62. 

  62. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4110','Uzkrâjumi pensijâm pielîdzinâtâm saistîbâm','A','L','','');
    63. 

  63. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4310','Citi uzkrâjumi','A','L','','');
    64. 

  64. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('41','Uzkrâjumi pensijâm pielîdzinâmâtâm saistîbâm','H','L','','');
    65. 

  65. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('43','Citi uzkrâjumi','H','L','','');
    66. 

  66. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('42','Uzkrâjumi paredzamiem nodokïiem','H','L','','');
    67. 

  67. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('51','Norçíini par aizòçmumiem','H','L','','');
    68. 

  68. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5110','Aizòçmumi pret obligâcijâm','A','L','','');
    69. 

  69. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5120','Akcijâs pârvçðamie aizòçmumi','A','L','','');
    70. 

  70. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5130','Aizòçmumi ar lîdzdalîbu peïòâ','A','L','','');
    71. 

  71. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5140','Citi aizòçmumi','A','L','','');
    72. 

  72. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5150','Îstermiòa aizòçmumi  no kredîtiestâdçm','A','L','','');
    73. 

  73. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5160','Ilgtermiòa aizòçmumi no kredîtiestâdçm','A','L','','');
    74. 

  74. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5170','Aizòçmumi no kredîtiestâdçm bez norâdîtâ termiòa','A','L','','');
    75. 

  75. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('52','Norçíini par saòemtajiem avansiem','H','L','','');
    76. 

  76. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5210','Norçíini par saòemtiem avansiem','A','L','','');
    77. 

  77. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('54','Maksâjamie vekseïi','H','L','','');
    78. 

  78. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('53','Norçíini par piegâdâtâjiem un darbuzòçmçjiem','H','L','','');
    79. 

  79. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5310','Norçíini par piegâdâtâjiem un darbuzòçmçjiem','A','L','','');
    80. 

  80. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5410','Norçíini par paðu izdotajiem vekseïiem','A','L','AP_paid','');
    81. 

  81. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5510','Norçíini par parâdiem meitas uzòçmumiem','A','L','AP_paid','');
    82. 

  82. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5540','Norçíini par parâdiem citiem uzòçmumiem un dalîbniekiem','A','L','AP_paid','');
    83. 

  83. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5550','Norçíini par parâdiem personâlam','A','L','AP_paid','');
    84. 

  84. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5520','Norçíini par parâdiem saistîtiem uzòçmumiem','A','L','AP_paid','');
    85. 

  85. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5530','Norçíini par parâdiem uzòçmumiem, ar kuriem ir lîgums par lîdzdalîbu','A','L','AP_paid','');
    86. 

  86. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('57','Norçíini par nodokïiem','H','L','AP_amount','');
    87. 

  87. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('58','Norçíini par  dividendçm','H','L','','');
    88. 

  88. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('61','Ieòçmumi no pârdoðanas, kas apliekami ar nodokïiem vispârçjâ kârtîbâ','H','I','','');
    89. 

  89. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('62','Ieòçmumi no pârdoðanas, kas citâdi  apliekami ar nodokïiem','H','I','','');
    90. 

  90. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6220','Ar îpaðiem nodokïiem apliekamie pârdoðanas ieòçmumi','A','I','AR_amount:IC_income','');
    91. 

  91. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('63','Komisijas, starpniecîbas un citi ieòçmumi','H','I','','');
    92. 

  92. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6310','Komisijas un starpniecîbas ieòçmumi','A','I','IC_income','');
    93. 

  93. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6320','Ieòçmumi no atkritumu pârstrâdes un realizâcijas','A','I','AR_amount:IC_income','');
    94. 

  94. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6330','Ieòçmumi no taras realizâcijas','A','I','AR_amount:IC_income','');
    95. 

  95. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6340','Ar nodokïiem neapliekamie apgrozîjumi','A','I','AR_amount:IC_income','');
    96. 

  96. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('64','Ieòçmumus samazinoðas atlaides','H','I','','');
    97. 

  97. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6410','Pieðíirtâs skonto atlaides','A','I','IC_income','');
    98. 

  98. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6420','Pieðíirtie bonusi','A','I','','');
    99. 

  99. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('59','Nâkamo periodu ieòçmumi','H','L','','');
    100. 

  100. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('65','Pârçjie uzòçmuma ieòçmumi','H','I','','');
    101. 

  101. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6510','Ieòçmumi no vçrtspapîru kursa paaugstinâðanâs','A','I','AR_amount','');
    102. 

  102. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6530','Ieòçmumi no zemes gabalu iznomâðanas','A','I','AR_amount','');
    103. 

  103. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6540','Ieòçmumi no apgrozâmo lîdzekïu pârdoðanas','A','I','','');
    104. 

  104. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6550','Ieòçmumi no pamatlîdzekïu iznomâðanas','A','I','','');
    105. 

  105. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6560','Ieòçmumos pârskaitîtais rezervju un uzkrâjumu samazinâjums','A','I','','');
    106. 

  106. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6570','Iepriekðçjo gadu nodokïu samazinâjums','A','I','','');
    107. 

  107. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6580','Papildus  ieguldîjumi un citi ieòçmumi','A','I','AR_amount','');
    108. 

  108. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6590','Paðu uzòçmuma kapitâlieguldîjumiem izpildîtie darbi','A','I','AR_amount','');
    109. 

  109. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('67','Citu periodu ieòçmumi, kas attiecas uz pârskata periodu','H','I','','');
    110. 

  110. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6710','Citu periodu ieòçmumi, kas attiecas uz pârskata periodu','A','I','AR_amount','');
    111. 

  111. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('69','Sociâlâs infrastruktûras iestâþu un pasâkumu ieòçmumi','H','I','','');
    112. 

  112. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6930','Sadzîves paklpojumu ieòçmumi','A','I','IC_income','');
    113. 

  113. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6920','Komunâlâs  saimniecîbas ieòçmumi','A','I','IC_income','');
    114. 

  114. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('66','Gatavâs produkcijas  un nepabeigto  raþojumu krâjumu un vçrtîbas  izmaiòas','H','I','','');
    115. 

  115. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6610','Gatavâs produkcijas krâjumu un vçrtîbas izmaiòas','A','I','','');
    116. 

  116. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6620','Nepabeigto raþojumu krâjumu un vçrtîbas  izmaiòas','A','I','','');
    117. 

  117. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6630','Nepabeigto pasûtîjumu atlikumu un vçtîbas izmaiòas','A','I','','');
    118. 

  118. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6640','Produktîvo  un darba dzîvnieku ganâmpulka vçrtîbas izmaiòas','A','I','','');
    119. 

  119. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6940','Sabiedriskâs çdinâðanas ieòçmumi','A','I','IC_income','');
    120. 

  120. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6950','Izglîtîbas iestâþu ieòçmumi','A','I','IC_income','');
    121. 

  121. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6960','Medicînas iestâþu ieòçmumi','A','I','IC_income','');
    122. 

  122. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6970','Kultûras un sporta ietâþu un pasâkumu ieòçmumi','A','I','','');
    123. 

  123. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6980','Pârçjie sociâlâs infrastruktûras iestâþu un pasâkumu ieòçmumi','A','I','','');
    124. 

  124. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7','Saimnieciskâs darbîbas izdevumi','H','E','','');
    125. 

  125. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('71','Izdevumi izejvielu, materiâlu un preèu iepirkðanai','H','E','','');
    126. 

  126. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7110','Izejvielu un materiâlu iepirkðanas un piegâdes izdevumi','A','E','','');
    127. 

  127. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7120','Preèu iepirkðanas un piegâdes izdevumi','A','E','','');
    128. 

  128. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7130','Saòemtâs atlaides','A','E','','');
    129. 

  129. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7140','Taras izdevumi','A','E','','');
    130. 

  130. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7150','Muitas un ievednodevas','A','E','AP_paid','');
    131. 

  131. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7160','Pârçjie ârçjie izdevumi','A','E','AP_paid','');
    132. 

  132. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7170','Samaksa par darbiem un pakalpojumiem no ârienes','A','E','','');
    133. 

  133. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7190','Pirkto materiâlu un preèu krâjumu un vçrtîbas izmaiòas','A','E','','');
    134. 

  134. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('72','Personâla izmaksas','H','E','','');
    135. 

  135. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7210','Strâdnieku algas','A','E','AP_paid','');
    136. 

  136. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7230','Sociâlâs  infrastruktûras  iestâþu un pasâkumu darbinieku algas','A','E','','');
    137. 

  137. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('73','Sociâlâs nodevas un izmaksas','H','I','','');
    138. 

  138. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7320','Pârçjâs sociâlâs izmaksas','A','E','AP_tax','');
    139. 

  139. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('74','Pamatlîdzekïu nolietojums un citu ieguldîjumu vçrtîbas norakstîjumi','H','E','','');
    140. 

  140. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7410','Nemateriâlo ieguldîjumu vçrtîbas norakstîðana','A','E','','');
    141. 

  141. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('75','Pârçjie saimnieciskâs darbîbas  izdevumi','H','E','','');
    142. 

  142. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7510','Dabas aizsardzîbas izdevumi','A','E','AP_paid','');
    143. 

  143. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7530','Nodevas par raþoðanâ izmantotiem zemes gabaliem','A','E','AP_paid','');
    144. 

  144. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7440','Apgrozâmo lîdzekïu vçrtîbas norakstîðana','A','E','','');
    145. 

  145. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7540','Apdroðinnâðanas maksâjumi (izòemot darbinieku apdroðinâðanu)','A','E','AP_paid','');
    146. 

  146. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7550','Pârçjie saimnieciskâs darbîbas izdevumi','A','E','AP_paid','');
    147. 

  147. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7560','Strâdnieku vervçðanas un apmâcîbas izdevumi','A','E','AP_paid','');
    148. 

  148. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('76','Preèu pârdoðanas izdevumi','H','E','','');
    149. 

  149. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7610','Iesaiòojamais materiâls, tara','A','E','AP_paid','');
    150. 

  150. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7620','Preèu transporta izdevumi','A','E','AP_paid','');
    151. 

  151. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7630','Preèu transporta apdroðinâðana','A','E','AP_paid','');
    152. 

  152. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7640','Samaksâtâs komisijas naudas','A','E','AP_paid','');
    153. 

  153. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7650','Citi pârdoðanas izdevumi','A','E','AP_paid','');
    154. 

  154. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('77','Administrâcijas izdevumi','H','E','','');
    155. 

  155. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7710','Sakaru izdevumi','A','E','AP_paid','');
    156. 

  156. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7720','Kantora (biroja) izdevumi','A','E','AP_paid','');
    157. 

  157. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7730','Juristu pakalpojumu apmaksa','A','E','AP_paid','');
    158. 

  158. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7740','Gada pârskata un revîzijas izdevumi','A','E','IC_expense','');
    159. 

  159. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7750','Naudas apgrozîjuma blakus izdevumi','A','E','IC_expense','');
    160. 

  160. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7760','Transporta izdevumi administrâcijas vajadzîbâm','A','E','IC_expense','');
    161. 

  161. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7770','Citi vadîðanas un administrâcijas izdevumi','A','E','IC_expense','');
    162. 

  162. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('78','Pârskata periodâ iekïaujamie iepriekðçjo periodu izdevumi','H','I','','');
    163. 

  163. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7810','Pârskata periodâ iekïaujamie iepriekðçjo periodu izdevumi','A','E','IC_expense','');
    164. 

  164. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('79','Sociâlâs  infrastruktûras uzturçðanas izdevumi','H','E','','');
    165. 

  165. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7920','Komuâlâs saimniecîbas izdevumi','A','E','IC_expense','');
    166. 

  166. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7940','Sabiedriskâs çdinâðanas izdevumi','A','E','IC_expense','');
    167. 

  167. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7950','Izglîtîbas iestâþu izdevumi','A','E','IC_expense','');
    168. 

  168. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8','Daþâdi ieòçmumi un izdevumi, peïòa un zaudçjumi','H','Q','','');
    169. 

  169. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('81','Daþâdi ieòçmumi','H','I','','');
    170. 

  170. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8110','Ieòçmumi no lîdzdalîbas, vçrtspapîriem un aizdevumiem','A','I','IC_income','');
    171. 

  171. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8120','Pârçjie ieòçmumi no procentiem un tiem pielîdzinâmi ieòçmumi','A','I','IC_income','');
    172. 

  172. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7910','Dzîvokïu saimniecîbas izdevumi','A','E','AP_paid','');
    173. 

  173. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8130','Vekseïu diskonta ieòçmumi','A','I','IC_income','');
    174. 

  174. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8150','Ienâkumi no valûtas kursa paaugstinâðanâs','A','I','IC_income','');
    175. 

  175. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8160','Saòemtâs soda naudas un lîgumsodi','A','I','IC_income','');
    176. 

  176. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8170','Peïòa no ârzemju valûtas pârdoðanas vai pirkðanas','A','I','IC_income','');
    177. 

  177. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8190','Citi ieòçmumi','A','I','IC_income','');
    178. 

  178. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('82','Daþâdi izdevumi','H','E','','');
    179. 

  179. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8210','Îstermiòa finansu ieguldîjumu vçrtîbas norakstîðana','A','E','IC_expense','');
    180. 

  180. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8220','Samaksâtie procenti un tiem pielîdzinâmie izdevumi','A','E','IC_expense','');
    181. 

  181. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8230','Vekseïu diskonta izmaksas','A','E','IC_expense','');
    182. 

  182. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8240','Ilgtermiòa aizdevumu procentu samaksa','A','E','IC_expense','');
    183. 

  183. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8260','Samaksâtâs soda naudas un lîgumsodi','A','E','IC_expense','');
    184. 

  184. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8270','Zaudçjumi no ârzemju valûtas pirkðanas un pârdoðanas','A','E','IC_expense','');
    185. 

  185. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8290','Citi izdevumi','A','E','IC_expense','');
    186. 

  186. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('83','Ârkârtas ieòçmumi','H','I','IC_income','');
    187. 

  187. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8310','Ârkârtas ieòçmumi','A','I','IC_income','');
    188. 

  188. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('84','Ârkârtas izdevumi','H','E','','');
    189. 

  189. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8410','Ârkârtas izdevumi','A','E','IC_expense','');
    190. 

  190. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('86','Peïòa vai zaudçjumi','H','I','IC_income:IC_expense','');
    191. 

  191. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8610','Peïòa vai zaudçjumi','A','I','IC_income:IC_expense','');
    192. 

  192. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3220','Privâtie ieguldîjumi','A','Q','','');
    193. 

  193. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6110','Ieòçmumi no pamatdarbîbas  produkcijas un pakalpojumu pârdoðanas','A','I','AR_paid','');
    194. 

  194. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1220','Tehnoloìiskâs  iekârtas un maðînas','A','A','IC','');
    195. 

  195. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1240','Pamatlîdzekïu izveidoðana un nepabeigto celtniecîbas objektu izmaksas','A','A','IC','');
    196. 

  196. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1320','Aizdevumi meitas uzòçmumam','A','A','','');
    197. 

  197. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2110','Izejvielas un materiâli','A','A','AP','');
    198. 

  198. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2190','Avansa maksâjumi par precçm','A','A','AR','');
    199. 

  199. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1130','Uzòçmuma nemateriâlâ vçrtîba','A','A','IC','');
    200. 

  200. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1180','Avansa maksâjumi par nemateriâliem aktîviem','A','A','IC','');
    201. 

  201. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1190','Nemateriâlo ieguldîjumu vçrtîbas norakstîtâ daïa (pasîvâ)','A','A','IC','');
    202. 

  202. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('22','Produktîvie un darba dzîvnieki','H','A','','');
    203. 

  203. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2230','Darba lopi','A','A','','');
    204. 

  204. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2290','Darba lopu norakstîtâ vçrtîba (pasîvâ)','A','A','','');
    205. 

  205. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2360','Norçíini par parakstîtâ sabiedrîbas kapitâlâ neiemaksâtâm summâm','A','A','AR_paid','');
    206. 

  206. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('24','Nâkamo periodu izdevumi','H','A','','');
    207. 

  207. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2620','Norçíinu konti bankâ','A','A','AR_paid:AP_paid','');
    208. 

  208. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('3110','Pamatkapitâls vai lîdzdalîbas kapitâls','A','Q','','');
    209. 

  209. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('55','Norçíini ar uzòçmumiem, dalîbniekiem un personâlu','H','L','','');
    210. 

  210. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('56','Norçíini  par darba samaksu  un ieturçjumiem (izòemot nodokïus)','H','L','','');
    211. 

  211. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5610','Norçíini par darba algu','A','E','AP_amount','');
    212. 

  212. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5620','Norçíini par ieturçjumiem no darba algas (izòemot nodokïus)','A','E','','');
    213. 

  213. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5820','Norçíini par iepriekðçjo gadu neizmaksâtajâm dividendçm','A','L','AP_paid','');
    214. 

  214. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5810','Norçíini par pârskata gada dividendçm','A','L','AP_paid','');
    215. 

  215. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5910','Nâkamo periodu ieòçmumi','A','I','','');
    216. 

  216. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6','Ieòçmumi no uzòçmuma saimnieciskâs darbîbas','H','I','','');
    217. 

  217. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6210','Ar nodokïiem neapliekamie pârdoðanas ieòçmumi','A','I','AR_amount:IC_income','');
    218. 

  218. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6430','Pieðíirtie rabati un citas tirdzniecîbas  atlaides','A','I','','');
    219. 

  219. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('6910','Dzîvokïu saimniecîbas ieòçmumi','A','I','AR_paid','');
    220. 

  220. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7180','Pârçjie materiâlie izdevumi (nodoklis par dabas resursu izmantoðanu, celmu nauda u.c.)','A','E','','');
    221. 

  221. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7240','Pârçjâs personâla izmaksas','A','E','AP_paid','');
    222. 

  222. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7220','Pârvaldes personâla un administratîvâ personâla algas','A','E','AP_paid','');
    223. 

  223. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7420','Pamatlîdzekïu nolietojums','A','E','','');
    224. 

  224. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7570','Komandçjuma izdevumi','A','E','AP_paid','');
    225. 

  225. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7930','Sadzîves pakalpojumu izdevumi','A','E','IC_expense','');
    226. 

  226. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7960','Medicîniskâs apkalpoðanas izdevumi','A','E','IC_expense','');
    227. 

  227. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7970','Kultûras un sporta iestâþu un pasâkumu izdevumi','A','E','IC_expense','');
    228. 

  228. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8140','Ziedojumi un citi tiem pielîdzinâmi ieòçmumi','A','I','IC_income','');
    229. 

  229. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8250','Zaudçjumi no valûtu  kursa pazeminâðanâs','A','E','IC_expense','');
    230. 

  230. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7980','Pârçjie sociâlâs infrastruktûras uzturçðanas izdevumi','A','E','','');
    231. 

  231. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('87','Peïòas izlietojums (bez nodokïiem)','H','E','','');
    232. 

  232. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('88','Nodoïi no peïòas un citi saimnieciskâs darbîbas izdevumos neiekïaujamie nodokïi','H','E','','');
    233. 

  233. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1110','Pçtniecîbas un uzòçmuma attîstîbas izmaksas','A','A','','');
    234. 

  234. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1120','Koncesijas, patenti, licences, tirdzniecîbas zîmes un lîdzîgas tiesîbas; datoru programmas','A','A','IC','');
    235. 

  235. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1230','Pârçjie pamatlîdzekïi un inventârs','A','A','IC','');
    236. 

  236. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5710','Norçíini par peïòas nodokli','A','L','','');
    237. 

  237. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2390','Pârmaksâtie nodokïi, iepriekð samaksâtie nodokïi','A','A','','');
    238. 

  238. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('4210','Uzkrâjumi paredzamiem nodokïiem','A','L','','');
    239. 

  239. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('5720','Norçíini par citiem nodokïiem, nodevâm un maksâjumiem budþetam','A','L','','');
    240. 

  240. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('7310','Sociâlais nodoklis','A','E','','');
    241. 

  241. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8710','Peïòas izlietojums','A','E','','');
    242. 

  242. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8830','Nodoklis par zemi','A','E','','');
    243. 

  243. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8840','Citi saimnieciskâs darbîbas izmaksâs neiekïaujamie nodokïi','A','E','','');
    244. 

  244. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8820','Nodoklis par dabas resursu izmantoðanu no peïòas  maksâjamâ daïâ','A','E','','');
    245. 

  245. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('8810','Nodoklis no peïòas','A','E','','');
    246. 

  246. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('1330','Lîdzdalîbas saistîto uzòçmumu kapitâlâ','A','A','','');
    247. 

  247. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2354','PVN samaksâts 18%','A','E','AP_tax:IC_taxpart:IC_taxservice','');
    248. 

  248. INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('2352','PVN ieòemtais 18%','A','L','AR_tax:IC_taxpart:IC_taxservice','');
    249. 

  249. --
    250. 

  250. INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart where accno = '2352'),'0.18','');
    251. 

  251. INSERT INTO tax (chart_id,rate,taxnumber) VALUES ((SELECT id FROM chart where accno = '2354'),'0.18','');
    252. 

  252. --
    253. 

  253. INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1230'));
    254. 

  254. 

  255.  INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '6010'));
    256. 

  256. 

  257.  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '7110'));
    258. 

  258. 

  259.  INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '8170'));
    260. 

  260. 

  261.  INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '8270'));
    262. 

  262. 

  263.  INSERT INTO defaults (setting_key, value) VALUES ('curr', 'LVL');
    264. 

  264. 

  265.  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
    266. 

  266. 

  267. commit;
    268.
generated by cgit v1.2.3 (git 2.46.0) at 2024-11-06 17:46:37 +0000