summaryrefslogtreecommitdiff
path: root/sql/Paraguay-chart.sql
blob: 899991aa86e1cd3de3f021d06ccffc3e7bedca19 (plain) 
    

  1. begin;
    2. 

  2. --
    3. 

  3. -- LedgerSMB Sample COA - Paraguay
    4. 

  4. -- Version: 2.4.6
    5. 

  5. -- Submitted by: Mario L. Epp
    6. 

  6. -- Date: 2005-01-03
    7. 

  7. --
    8. 

  8. --
    9. 

  9. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.000','ACTIVO','H','A','','');
    10. 

  10. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.100','ACTIVO CORRIENTE','H','A','','');
    11. 

  11. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.110','DISPONIBLE','H','A','','');
    12. 

  12. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.111','Caja','H','A','','');
    13. 

  13. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.111.01','Recaudaciones a depositar','A','A','','');
    14. 

  14. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.111.02','Fondo fijo','A','A','','');
    15. 

  15. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.111.03','Valores a depositar','A','A','','');
    16. 

  16. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.111.04','Monedas extranjeras','A','A','','');
    17. 

  17. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.112','Bancos','H','A','','');
    18. 

  18. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.112.01','Cuenta Corriente','A','A','','');
    19. 

  19. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.112.02','Caja de Ahorro','A','A','','');
    20. 

  20. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.120','VALORES NEGOCIABLES / INVERSIONES TRANSITORIAS','H','A','','');
    21. 

  21. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.120.01','Títulos y acciones','A','A','','');
    22. 

  22. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.120.02','Títulos públicos','A','A','','');
    23. 

  23. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.120.03','Depósito a plazo fijo','A','A','','');
    24. 

  24. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.120.04','Previsión fluctuaciones y desvalorizaciones (regularizadora)','A','A','','');
    25. 

  25. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.130','CRÉDITOS','H','A','','');
    26. 

  26. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.131','Créditos por ventas','A','A','','');
    27. 

  27. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.132','Otros créditos','A','A','','');
    28. 

  28. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.140','BIENES DE CAMBIO','H','A','','');
    29. 

  29. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.141','Mercaderías de reventa','A','A','','');
    30. 

  30. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.142','Mercaderías en proceso de producción','A','A','','');
    31. 

  31. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.150','OTROS ACTIVOS CORRIENTES','H','A','','');
    32. 

  32. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.151','Muestras y otros materiales de propaganda','A','A','','');
    33. 

  33. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.152','Combustibles','A','A','','');
    34. 

  34. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.153','Repuestos','A','A','','');
    35. 

  35. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.154','Embalajes y envases','A','A','','');
    36. 

  36. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.155','Materiales de oficina','A','A','','');
    37. 

  37. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.156','Materiales diversos','A','A','','');
    38. 

  38. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.200','REALIZABLE A LARGO PLAZO','H','A','','');
    39. 

  39. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.210','INVERSIONES PERMANENTES','H','A','','');
    40. 

  40. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.211','Títulos públicos','A','A','','');
    41. 

  41. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.212','Debenturas','A','A','','');
    42. 

  42. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.213','Inversiones en otras empresas','A','A','','');
    43. 

  43. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.214','Previsión fluctuaciones y desvalorzaciones','A','A','','');
    44. 

  44. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.220','CRÉDITOS','H','A','','');
    45. 

  45. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.221','Créditos por ventas','A','A','','');
    46. 

  46. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.222','Otros créditos','A','A','','');
    47. 

  47. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.300','ACTIVO FIJO','H','A','','');
    48. 

  48. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.310','MUEBLES, ÚTILES Y ENSERES','H','A','','');
    49. 

  49. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.311','MUEBLES Y EQUIPOS','H','A','','');
    50. 

  50. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.311.01','Muebles y equipos - Costo de origen','A','A','','');
    51. 

  51. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.311.02','Muebles y equipos - Mejoras','A','A','','');
    52. 

  52. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.311.03','Muebles y equipos - Revalúo','A','A','','');
    53. 

  53. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.311.04','Muebles y equipos - (Depreciaciones acumuladas)','A','A','','');
    54. 

  54. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.312','ÚTILES Y ENSERES','H','A','','');
    55. 

  55. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.312.01','Útiles y enseres - Costo de origen','A','A','','');
    56. 

  56. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.312.02','Útiles y enseres - Mejoras','A','A','','');
    57. 

  57. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.312.03','Útiles y enseres - Revalúo','A','A','','');
    58. 

  58. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.312.04','Útiles y enseres - (Depreciaciones acumuladas)','A','A','','');
    59. 

  59. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.320','MAQUINARIAS, HERRAMIENTAS Y EQUIPOS','H','A','','');
    60. 

  60. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.321','MAQUINARIAS','H','A','','');
    61. 

  61. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.321.01','Maquinarias - Costo de origen','A','A','','');
    62. 

  62. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.321.02','Maquinarias - Mejoras','A','A','','');
    63. 

  63. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.321.03','Maquinarias - Revalúo','A','A','','');
    64. 

  64. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.321.04','Maquinarias - (Depreciaciones acumuladas)','A','A','','');
    65. 

  65. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.322','HERRAMIENTAS Y EQUIPOS','H','A','','');
    66. 

  66. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.322.01','Herramientas y Equipos - Costo de origen','A','A','','');
    67. 

  67. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.322.02','Herramientas y Equipos - Mejoras','A','A','','');
    68. 

  68. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.322.03','Herramientas y Equipos - Revalúo','A','A','','');
    69. 

  69. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.322.04','Herramientas y Equipos - (Depreciaciones acumuladas)','A','A','','');
    70. 

  70. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.323','EQUIPOS INFORMÁTICOS','H','A','','');
    71. 

  71. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.323.01','Equipos informáticos - Costo de origen','A','A','','');
    72. 

  72. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.323.02','Equipos informáticos - Mejoras','A','A','','');
    73. 

  73. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.323.03','Equipos informáticos - Revalúo','A','A','','');
    74. 

  74. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.323.04','Equipos informáticos - (Depreciaciones acumuladas)','A','A','','');
    75. 

  75. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.330','TRANSPORTE TERRESTRE','H','A','','');
    76. 

  76. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.331','AUTOS, CAMIONETAS, CAMIONES O ACOPLADOS','H','A','','');
    77. 

  77. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.331.01','Autos, camionetas, camiones o acoplados - Costo de origen','A','A','','');
    78. 

  78. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.331.02','Autos, camionetas, camiones o acoplados - Mejoras','A','A','','');
    79. 

  79. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.331.03','Autos, camionetas, camiones o acoplados - Revalúo','A','A','','');
    80. 

  80. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.331.04','Autos, camionetas, camiones o acoplados - (Depreciaciones acumuladas)','A','A','','');
    81. 

  81. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.332','MOTOCICLETAS, TRICICLOS Y BICICLETAS','H','A','','');
    82. 

  82. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.332.01','Motocicletas, triciclos y bicicletas - Costo de origen','A','A','','');
    83. 

  83. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.332.02','Motocicletas, triciclos y bicicletas - Mejoras','A','A','','');
    84. 

  84. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.332.03','Motocicletas, triciclos y bicicletas - Revalúo','A','A','','');
    85. 

  85. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.332.04','Motocicletas, triciclos y bicicletas - (Depreciaciones acumuladas)','A','A','','');
    86. 

  86. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.333','BIENES PARA TRANSPORTE TERRESTRE','H','A','','');
    87. 

  87. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.333.01','Bienes para transporte terrestre - Costo de origen','A','A','','');
    88. 

  88. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.333.02','Bienes para transporte terrestre - Mejoras','A','A','','');
    89. 

  89. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.333.03','Bienes para transporte terrestre - Revalúo','A','A','','');
    90. 

  90. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.333.04','Bienes para transporte terrestre - (Depreciaciones acumuladas)','A','A','','');
    91. 

  91. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.340','TRANSPORTE AÉREO','H','A','','');
    92. 

  92. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.341','AVIONES Y MATERIAL DE VUELO','H','A','','');
    93. 

  93. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.341.01','Aviones y material de vuelo - Costo de origen','A','A','','');
    94. 

  94. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.341.02','Aviones y material de vuelo - Mejoras','A','A','','');
    95. 

  95. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.341.03','Aviones y material de vuelo - Revalúo','A','A','','');
    96. 

  96. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.341.04','Aviones y material de vuelo - (Depreciaciones acumuladas)','A','A','','');
    97. 

  97. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.342','INSTALACIONES DE TIERRA','H','A','','');
    98. 

  98. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.342.01','Instalaciones de tierra - Costo de origen','A','A','','');
    99. 

  99. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.342.02','Instalaciones de tierra - Mejoras','A','A','','');
    100. 

  100. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.342.03','Instalaciones de tierra - Revalúo','A','A','','');
    101. 

  101. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.342.04','Instalaciones de tierra - (Depreciaciones acumuladas)','A','A','','');
    102. 

  102. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.350','TRANSPORTE MARÍTIMO Y FLUVIAL','H','A','','');
    103. 

  103. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.351','EMBARCACIONES EN GENERAL','H','A','','');
    104. 

  104. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.351.01','Embarcaciones en general - Costo de origen','A','A','','');
    105. 

  105. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.351.02','Embarcaciones en general - Mejoras','A','A','','');
    106. 

  106. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.351.03','Embarcaciones en general - Revalúo','A','A','','');
    107. 

  107. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.351.04','Embarcaciones en general - (Depreciaciones acumuladas)','A','A','','');
    108. 

  108. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.352','CANOAS, BOTES Y DEMÁS BIENES','H','A','','');
    109. 

  109. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.352.01','Canoas, botes y demás bienes - Costo de origen','A','A','','');
    110. 

  110. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.352.02','Canoas, botes y demás bienes - Mejoras','A','A','','');
    111. 

  111. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.352.03','Canoas, botes y demás bienes - Revalúo','A','A','','');
    112. 

  112. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.352.04','Canoas, botes y demás bienes - (Depreciaciones acumuladas)','A','A','','');
    113. 

  113. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.360','TRANSPORTE FERROVIARIO','H','A','','');
    114. 

  114. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.361','MATERIALES RODANTES','H','A','','');
    115. 

  115. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.361.01','Materiales rodantes - Costo de origen','A','A','','');
    116. 

  116. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.361.02','Materiales rodantes - Mejoras','A','A','','');
    117. 

  117. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.361.03','Materiales rodantes - Revalúo','A','A','','');
    118. 

  118. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.361.04','Materiales rodantes - (Depreciaciones acumuladas)','A','A','','');
    119. 

  119. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.362','VÍAS Y DEMÁS BIENES','H','A','','');
    120. 

  120. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.362.01','Vías y demás bienes - Costo de origen','A','A','','');
    121. 

  121. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.362.02','Vías y demás bienes - Mejoras','A','A','','');
    122. 

  122. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.362.03','Vías y demás bienes - Revalúo','A','A','','');
    123. 

  123. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.362.04','Vías y demás bienes - (Depreciaciones acumuladas)','A','A','','');
    124. 

  124. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.370','INMUEBLES','H','A','','');
    125. 

  125. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.371','CONSTRUCCIONES EN INMUEBLES URBANOS','H','A','','');
    126. 

  126. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.371.01','Construcciones en inmuebles urbanos - Costo de origen','A','A','','');
    127. 

  127. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.371.02','Construcciones en inmuebles urbanos - Mejoras','A','A','','');
    128. 

  128. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.371.03','Construcciones en inmuebles urbanos - Revalúo','A','A','','');
    129. 

  129. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.371.04','Construcciones en inmuebles urbanos - (Depreciaciones acumuladas)','A','A','','');
    130. 

  130. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.372','CONSTRUCCIONES EN INMUEBLES RURALES','H','A','','');
    131. 

  131. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.372.01','Construcciones en inmuebles rurales - Costo de origen','A','A','','');
    132. 

  132. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.372.02','Construcciones en inmuebles rurales - Mejoras','A','A','','');
    133. 

  133. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.372.03','Construcciones en inmuebles rurales - Revalúo','A','A','','');
    134. 

  134. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.372.04','Construcciones en inmuebles rurales - (Depreciaciones acumuladas)','A','A','','');
    135. 

  135. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.373','CONSTRUCCIONES EN INMUEBLES AJENOS','H','A','','');
    136. 

  136. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.373.01','Construcciones en inmuebles ajenos - Costo de origen','A','A','','');
    137. 

  137. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.373.02','Construcciones en inmuebles ajenos - Mejoras','A','A','','');
    138. 

  138. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.373.03','Construcciones en inmuebles ajenos - Revalúo','A','A','','');
    139. 

  139. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.373.04','Construcciones en inmuebles ajenos - (Depreciaciones acumuladas)','A','A','','');
    140. 

  140. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.381','RESTANTES BIENES','H','A','','');
    141. 

  141. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.381.01','Restantes bienes - Costo de origen','A','A','','');
    142. 

  142. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.381.02','Restantes bienes - Mejoras','A','A','','');
    143. 

  143. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.381.03','Restantes bienes - Revalúo','A','A','','');
    144. 

  144. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.381.04','Restantes bienes - (Depreciaciones acumuladas)','A','A','','');
    145. 

  145. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.390','BIENES INTANGIBLES','H','A','','');
    146. 

  146. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.391','Llave de negocio','A','A','','');
    147. 

  147. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.392','Marcas registradas','A','A','','');
    148. 

  148. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.393','Concesiones','A','A','','');
    149. 

  149. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.394','Patente de invención','A','A','','');
    150. 

  150. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.395','Gastos de constitución y organización','A','A','','');
    151. 

  151. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.396','Gastos de reorganización','A','A','','');
    152. 

  152. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.397','Gastos de proyectos de inversión','A','A','','');
    153. 

  153. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.398','Gastos de desarrollo e investigación','A','A','','');
    154. 

  154. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1.399','(Amortizaciones acumuladas)','A','A','','');
    155. 

  155. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2.000','PASIVO','H','L','','');
    156. 

  156. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2.100','CIRCULANTE','H','L','','');
    157. 

  157. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2.110','DEUDAS','H','L','','');
    158. 

  158. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2.111','Acreedores por compras','A','L','','');
    159. 

  159. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2.112','Deudas bancarias y financieras','A','L','','');
    160. 

  160. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2.113','Otras deudas','A','L','','');
    161. 

  161. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2.150','PROVISIONES','H','L','','');
    162. 

  162. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2.151','IVA a pagar','A','L','','');
    163. 

  163. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2.200','EXIGIBLE A LARGO PLAZO','H','L','','');
    164. 

  164. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2.210','DEUDAS','H','L','','');
    165. 

  165. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2.211','Acreedores por compras','A','L','','');
    166. 

  166. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2.212','Deudas bancarias y financieras','A','L','','');
    167. 

  167. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2.213','Otras deudas','A','L','','');
    168. 

  168. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2.220','PREVISIONES','H','L','','');
    169. 

  169. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2.221','Previsición para indemnización por despidos','A','L','','');
    170. 

  170. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2.222','Previsición para indemnización por accidente','A','L','','');
    171. 

  171. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3.000','PATRIMONIO NETO','H','Q','','');
    172. 

  172. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3.100','CAPITAL','A','Q','','');
    173. 

  173. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3.200','RESERVAS','H','Q','','');
    174. 

  174. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3.210','Reserva legal','A','Q','','');
    175. 

  175. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3.220','Reserva de revalúo','A','Q','','');
    176. 

  176. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3.230','Prima de emisión','A','Q','','');
    177. 

  177. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3.240','Reserva estatutaria','A','Q','','');
    178. 

  178. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3.300','RESULTADOS','H','Q','','');
    179. 

  179. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3.310','Resultados acumulados','A','Q','','');
    180. 

  180. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3.320','Resultados del ejercicio','A','Q','','');
    181. 

  181. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4.000','INGRESOS','H','I','','');
    182. 

  182. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4.100','INGRESOS OPERATIVOS','H','I','','');
    183. 

  183. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4.110','Venta de mercadrías','A','I','','');
    184. 

  184. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4.120','Venta de servicios','A','I','','');
    185. 

  185. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4.130','Otros ingresos operativos','H','I','','');
    186. 

  186. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4.130.01','Intereses ganados','A','I','','');
    187. 

  187. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4.130.02','Descuentos obtenidos','A','I','','');
    188. 

  188. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4.130.03','Comisiones obtenidas','A','I','','');
    189. 

  189. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4.200','INGRESOS NO OPERATIVOS','H','I','','');
    190. 

  190. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4.210','Utilidad en venta de bienes de uso','A','I','','');
    191. 

  191. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4.220','Alquileres ganados','A','I','','');
    192. 

  192. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4.230','Incobrables recuperados','A','I','','');
    193. 

  193. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4.240','Utilidad en venta de bienes intangibles','A','I','','');
    194. 

  194. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4.250','Utilidades varias','A','I','','');
    195. 

  195. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4.300','INGRESOS EXTRAORDINARIOS','H','I','','');
    196. 

  196. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4.310','Utilidad en venta de bienes de uso','A','I','','');
    197. 

  197. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4.320','Donaciones y premios','A','I','','');
    198. 

  198. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4.330','Premios','A','I','','');
    199. 

  199. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4.340','Diferencias de cambios positivos','A','I','','');
    200. 

  200. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.000','EGRESOS','H','E','','');
    201. 

  201. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.100','EGRESOS OPERATIVOS','H','E','','');
    202. 

  202. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.110','COSTO DE MERCADERÍAS VENDIDAS','H','E','','');
    203. 

  203. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.110.01','Costo de ventas sección 1','A','E','','');
    204. 

  204. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.110.20','Costo de ventas producto 1','A','E','','');
    205. 

  205. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.110.40','Costo de ventas diversas','A','E','','');
    206. 

  206. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.110.60','Costo de ventas productos elaborados','A','E','','');
    207. 

  207. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.120','COSTO DE SERVICIOS VENDIDOS','H','E','','');
    208. 

  208. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.120.01','Costo de servicios','A','E','','');
    209. 

  209. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.130','GASTOS DE VENTAS','H','E','','');
    210. 

  210. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.130.01','Comisiones sobre ventas','A','E','','');
    211. 

  211. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.130.02','Publicidad y propaganda','A','E','','');
    212. 

  212. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.130.03','Gastos de viajes','A','E','','');
    213. 

  213. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.130.04','Gastos de exportación','A','E','','');
    214. 

  214. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.130.05','Otros gastos de ventas','A','E','','');
    215. 

  215. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.140','GASTOS DE ADMINISTRACIÓN','H','E','','');
    216. 

  216. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.140.01','Aguinaldos','A','E','','');
    217. 

  217. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.140.02','Alquileres pagados','A','E','','');
    218. 

  218. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.140.03','Depreciación bienes de uso','A','E','','');
    219. 

  219. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.140.04','Depreciación bienes intangibles','A','E','','');
    220. 

  220. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.140.05','Bonificación familiar','A','E','','');
    221. 

  221. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.140.06','Créditos incobrables','A','E','','');
    222. 

  222. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.140.07','Aporte patronal sobre salarios','A','E','','');
    223. 

  223. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.140.08','Fletes y acarreos','A','E','','');
    224. 

  224. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.140.09','Luz, teléfono y agua','A','E','','');
    225. 

  225. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.140.10','Impuestos, tasas y contribuciones','A','E','','');
    226. 

  226. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.140.11','Seguros','A','E','','');
    227. 

  227. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.140.12','Gastos de útiles e impresos','A','E','','');
    228. 

  228. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.140.13','Sueldos y jornales','A','E','','');
    229. 

  229. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.140.14','Remuneración personal superior','A','E','','');
    230. 

  230. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.140.15','Honorarios profesionales','A','E','','');
    231. 

  231. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.140.16','Gastos de representación','A','E','','');
    232. 

  232. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.140.17','Gastos de cobranza','A','E','','');
    233. 

  233. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.140.18','Gastos judiciales','A','E','','');
    234. 

  234. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.140.19','Otros gastos de administración','A','E','','');
    235. 

  235. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.150','GASTOS FINANCIEROS','H','E','','');
    236. 

  236. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.150.01','Intereses pagados','A','E','','');
    237. 

  237. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.150.02','Gastos bancarios','A','E','','');
    238. 

  238. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.150.03','Otros gastos financieros','A','E','','');
    239. 

  239. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.200','EGRESOS NO OPERATIVOS','H','E','','');
    240. 

  240. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.210','Bajas bienes de uso','A','E','','');
    241. 

  241. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.220','Gastos inmuebles alquileres','A','E','','');
    242. 

  242. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.230','Pérdidas en ventas bienes de uso','A','E','','');
    243. 

  243. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.240','Otros resultados negativos no operativos','A','E','','');
    244. 

  244. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.300','EGRESOS EXTRAORDINARIOS','H','E','','');
    245. 

  245. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.310','Pérdidas en ventas bienes de uso','A','E','','');
    246. 

  246. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.320','Donaciones y contribuciones negativas','A','E','','');
    247. 

  247. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.330','Indemnizaciones a terceros','A','E','','');
    248. 

  248. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.340','Diferencias de cambios negativos','A','E','','');
    249. 

  249. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5.350','Otros resultados negativos extraordinarios','A','E','','');
    250. 

  250. --
    251. 

  251. INSERT INTO tax (chart_id,rate) VALUES ((select id from chart where accno = '2.151'),'0.1');
    252. 

  252. --
    253. 

  253. INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', 
    254. 

  254. (select id from chart where accno = '1.141'));
    255. 

  255. 

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

  257. 

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

  259. 

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

  261. 

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

  263. 

  264.  INSERT INTO defaults (setting_key, value) VALUES ('curr', 'PYG:USD:EUR');
    265. 

  265. 

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

  267. --
    268. 

  268. commit;
    269.
generated by cgit v1.2.3 (git 2.39.1) at 2024-06-26 04:13:53 +0000