/doc/tips/convert_mediawiki_to_ikiwiki/

link rel='alternate' title='Atom feed' href='https://source.jones.dk/ledger-smb/atom/sql/Colombia-PUC-gifi.sql?h=master' type='application/atom+xml'/>
summaryrefslogtreecommitdiff
path: root/sql/Colombia-PUC-gifi.sql
blob: 1ee02eb1b8f038f6afe979d299d76e1f1b3627a2 (plain) 
    

  1. --
    2. 

  2. --
    3. 

  3. -- Data for Plan Único de Cuentas (PUC) Gifi Table
    4. 

  4. --
    5. 

  5. 

  6. INSERT INTO gifi (accno,description) VALUES ('1', 'ACTIVO ');
    7. 

  7. INSERT INTO gifi (accno,description) VALUES ('11', 'DISPONIBLE ');
    8. 

  8. INSERT INTO gifi (accno,description) VALUES ('1105', 'CAJA ');
    9. 

  9. INSERT INTO gifi (accno,description) VALUES ('110505', 'CAJA GENERAL ');
    10. 

  10. INSERT INTO gifi (accno,description) VALUES ('110510', 'CAJAS MENORES ');
    11. 

  11. INSERT INTO gifi (accno,description) VALUES ('110515', 'MONEDA EXTRANJERA ');
    12. 

  12. INSERT INTO gifi (accno,description) VALUES ('1110', 'BANCOS ');
    13. 

  13. INSERT INTO gifi (accno,description) VALUES ('111005', 'MONEDA NACIONAL ');
    14. 

  14. INSERT INTO gifi (accno,description) VALUES ('111010', 'MONEDA EXTRANJERA ');
    15. 

  15. INSERT INTO gifi (accno,description) VALUES ('1115', 'REMESAS EN TRANSITO ');
    16. 

  16. INSERT INTO gifi (accno,description) VALUES ('111505', 'MONEDA NACIONAL ');
    17. 

  17. INSERT INTO gifi (accno,description) VALUES ('111510', 'MONEDA EXTRANJERA ');
    18. 

  18. INSERT INTO gifi (accno,description) VALUES ('1120', 'CUENTAS DE AHORRO ');
    19. 

  19. INSERT INTO gifi (accno,description) VALUES ('112005', 'BANCOS ');
    20. 

  20. INSERT INTO gifi (accno,description) VALUES ('112010', 'CORPORACIONES DE AHORRO Y VIVIENDA ');
    21. 

  21. INSERT INTO gifi (accno,description) VALUES ('112015', 'ORGANISMOS COOPERATIVOS FINANCIEROS ');
    22. 

  22. INSERT INTO gifi (accno,description) VALUES ('1125', 'FONDOS ');
    23. 

  23. INSERT INTO gifi (accno,description) VALUES ('112505', 'ROTATORIOS MONEDA NACIONAL ');
    24. 

  24. INSERT INTO gifi (accno,description) VALUES ('112510', 'ROTATORIOS MONEDA EXTRANJERA ');
    25. 

  25. INSERT INTO gifi (accno,description) VALUES ('112515', 'ESPECIALES MONEDA NACIONAL ');
    26. 

  26. INSERT INTO gifi (accno,description) VALUES ('112520', 'ESPECIALES MONEDA EXTRANJERA ');
    27. 

  27. INSERT INTO gifi (accno,description) VALUES ('112525', 'DE AMORTIZACION MONEDA NACIONAL ');
    28. 

  28. INSERT INTO gifi (accno,description) VALUES ('112530', 'DE AMORTIZACION MONEDA EXTRANJERA ');
    29. 

  29. INSERT INTO gifi (accno,description) VALUES ('12', 'INVERSIONES ');
    30. 

  30. INSERT INTO gifi (accno,description) VALUES ('1205', 'ACCIONES ');
    31. 

  31. INSERT INTO gifi (accno,description) VALUES ('120505', 'AGRICULTURA, GANADERIA, CAZA Y SILVICULTURA ');
    32. 

  32. INSERT INTO gifi (accno,description) VALUES ('120510', 'PESCA ');
    33. 

  33. INSERT INTO gifi (accno,description) VALUES ('120515', 'EXPLOTACION DE MINAS Y CANTERAS ');
    34. 

  34. INSERT INTO gifi (accno,description) VALUES ('120520', 'INDUSTRIA MANUFACTURERA ');
    35. 

  35. INSERT INTO gifi (accno,description) VALUES ('120525', 'SUMINISTRO DE ELECTRICIDAD, GAS Y AGUA ');
    36. 

  36. INSERT INTO gifi (accno,description) VALUES ('120530', 'CONSTRUCCION ');
    37. 

  37. INSERT INTO gifi (accno,description) VALUES ('120535', 'COMERCIO AL POR MAYOR Y AL POR MENOR ');
    38. 

  38. INSERT INTO gifi (accno,description) VALUES ('120540', 'HOTELES Y RESTAURANTES ');
    39. 

  39. INSERT INTO gifi (accno,description) VALUES ('120545', 'TRANSPORTE, ALMACENAMIENTO Y COMUNICACIONES ');
    40. 

  40. INSERT INTO gifi (accno,description) VALUES ('120550', 'ACTIVIDAD FINANCIERA ');
    41. 

  41. INSERT INTO gifi (accno,description) VALUES ('120555', 'ACTIVIDADES INMOBILIARIAS, EMPRESARIALES Y DE ALQUILER ');
    42. 

  42. INSERT INTO gifi (accno,description) VALUES ('120560', 'ENSEŃANZA ');
    43. 

  43. INSERT INTO gifi (accno,description) VALUES ('120565', 'SERVICIOS SOCIALES Y DE SALUD ');
    44. 

  44. INSERT INTO gifi (accno,description) VALUES ('120570', 'OTRAS ACTIVIDADES DE SERVICIOS COMUNITARIOS, SOCIALES Y PERSONALES ');
    45. 

  45. INSERT INTO gifi (accno,description) VALUES ('120599', 'AJUSTES POR INFLACION ');
    46. 

  46. INSERT INTO gifi (accno,description) VALUES ('1210', 'CUOTAS O PARTES DE INTERES SOCIAL ');
    47. 

  47. INSERT INTO gifi (accno,description) VALUES ('121005', 'AGRICULTURA, GANADERIA, CAZA Y SILVICULTURA ');
    48. 

  48. INSERT INTO gifi (accno,description) VALUES ('121010', 'PESCA ');
    49. 

  49. INSERT INTO gifi (accno,description) VALUES ('121015', 'EXPLOTACION DE MINAS Y CANTERAS ');
    50. 

  50. INSERT INTO gifi (accno,description) VALUES ('121020', 'INDUSTRIA MANUFACTURERA ');
    51. 

  51. INSERT INTO gifi (accno,description) VALUES ('121025', 'SUMINISTRO DE ELECTRICIDAD, GAS Y AGUA ');
    52. 

  52. INSERT INTO gifi (accno,description) VALUES ('121030', 'CONSTRUCCION ');
    53. 

  53. INSERT INTO gifi (accno,description) VALUES ('121035', 'COMERCIO AL POR MAYOR Y AL POR MENOR ');
    54. 

  54. INSERT INTO gifi (accno,description) VALUES ('121040', 'HOTELES Y RESTAURANTES ');
    55. 

  55. INSERT INTO gifi (accno,description) VALUES ('121045', 'TRANSPORTE, ALMACENAMIENTO Y COMUNICACIONES ');
    56. 

  56. INSERT INTO gifi (accno,description) VALUES ('121050', 'ACTIVIDAD FINANCIERA ');
    57. 

  57. INSERT INTO gifi (accno,description) VALUES ('121055', 'ACTIVIDADES INMOBILIARIAS, EMPRESARIALES Y DE ALQUILER ');
    58. 

  58. INSERT INTO gifi (accno,description) VALUES ('121060', 'ENSEŃANZA ');
    59. 

  59. INSERT INTO gifi (accno,description) VALUES ('121065', 'SERVICIOS SOCIALES Y DE SALUD ');
    60. 

  60. INSERT INTO gifi (accno,description) VALUES ('121070', 'OTRAS ACTIVIDADES DE SERVICIOS COMUNITARIOS, SOCIALES Y PERSONALES ');
    61. 

  61. INSERT INTO gifi (accno,description) VALUES ('121099', 'AJUSTES POR INFLACION ');
    62. 

  62. INSERT INTO gifi (accno,description) VALUES ('1215', 'BONOS ');
    63. 

  63. INSERT INTO gifi (accno,description) VALUES ('121505', 'BONOS PUBLICOS MONEDA NACIONAL ');
    64. 

  64. INSERT INTO gifi (accno,description) VALUES ('121510', 'BONOS PUBLICOS MONEDA EXTRANJERA ');
    65. 

  65. INSERT INTO gifi (accno,description) VALUES ('121515', 'BONOS ORDINARIOS ');
    66. 

  66. INSERT INTO gifi (accno,description) VALUES ('121520', 'BONOS CONVERTIBLES EN ACCIONES ');
    67. 

  67. INSERT INTO gifi (accno,description) VALUES ('121595', 'OTROS ');
    68. 

  68. INSERT INTO gifi (accno,description) VALUES ('1220', 'CEDULAS ');
    69. 

  69. INSERT INTO gifi (accno,description) VALUES ('122005', 'CEDULAS DE CAPITALIZACION ');
    70. 

  70. INSERT INTO gifi (accno,description) VALUES ('122010', 'CEDULAS HIPOTECARIAS ');
    71. 

  71. INSERT INTO gifi (accno,description) VALUES ('122015', 'CEDULAS DE INVERSION ');
    72. 

  72. INSERT INTO gifi (accno,description) VALUES ('122095', 'OTRAS ');
    73. 

  73. INSERT INTO gifi (accno,description) VALUES ('1225', 'CERTIFICADOS ');
    74. 

  74. INSERT INTO gifi (accno,description) VALUES ('122505', 'CERTIFICADOS DE DEPOSITO A TERMINO (C.D.T.) ');
    75. 

  75. INSERT INTO gifi (accno,description) VALUES ('122510', 'CERTIFICADOS DE DEPOSITO DE AHORRO ');
    76. 

  76. INSERT INTO gifi (accno,description) VALUES ('122515', 'CERTIFICADOS DE AHORRO DE VALOR CONSTANTE (C.A.V.C.) ');
    77. 

  77. INSERT INTO gifi (accno,description) VALUES ('122520', 'CERTIFICADOS DE CAMBIO ');
    78. 

  78. INSERT INTO gifi (accno,description) VALUES ('122525', 'CERTIFICADOS CAFETEROS VALORIZABLES ');
    79. 

  79. INSERT INTO gifi (accno,description) VALUES ('122530', 'CERTIFICADOS ELECTRICOS VALORIZABLES (C.E.V.) ');
    80. 

  80. INSERT INTO gifi (accno,description) VALUES ('122535', 'CERTIFICADOS DE REEMBOLSO TRIBUTARIO (C.E.R.T.) ');
    81. 

  81. INSERT INTO gifi (accno,description) VALUES ('122540', 'CERTIFICADOS DE DESARROLLO TURISTICO ');
    82. 

  82. INSERT INTO gifi (accno,description) VALUES ('122545', 'CERTIFICADOS DE INVERSION FORESTAL (C.I.F.) ');
    83. 

  83. INSERT INTO gifi (accno,description) VALUES ('122595', 'OTROS ');
    84. 

  84. INSERT INTO gifi (accno,description) VALUES ('1230', 'PAPELES COMERCIALES ');
    85. 

  85. INSERT INTO gifi (accno,description) VALUES ('123005', 'EMPRESAS COMERCIALES ');
    86. 

  86. INSERT INTO gifi (accno,description) VALUES ('123010', 'EMPRESAS INDUSTRIALES ');
    87. 

  87. INSERT INTO gifi (accno,description) VALUES ('123015', 'EMPRESAS DE SERVICIOS ');
    88. 

  88. INSERT INTO gifi (accno,description) VALUES ('1235', 'TITULOS ');
    89. 

  89. INSERT INTO gifi (accno,description) VALUES ('123505', 'TITULOS DE DESARROLLO AGROPECUARIO ');
    90. 

  90. INSERT INTO gifi (accno,description) VALUES ('123510', 'TITULOS CANJEABLES POR CERTIFICADOS DE CAMBIO ');
    91. 

  91. INSERT INTO gifi (accno,description) VALUES ('123515', 'TITULOS DE TESORERIA (T.E.S.) ');
    92. 

  92. INSERT INTO gifi (accno,description) VALUES ('123520', 'TITULOS DE PARTICIPACION ');
    93. 

  93. INSERT INTO gifi (accno,description) VALUES ('123525', 'TITULOS DE CREDITO DE FOMENTO ');
    94. 

  94. INSERT INTO gifi (accno,description) VALUES ('123530', 'TITULOS FINANCIEROS AGROINDUSTRIALES (T.F.A.) ');
    95. 

  95. INSERT INTO gifi (accno,description) VALUES ('123535', 'TITULOS DE AHORRO CAFETERO (T.A.C.) ');
    96. 

  96. INSERT INTO gifi (accno,description) VALUES ('123540', 'TITULOS DE AHORRO NACIONAL (T.A.N.) ');
    97. 

  97. INSERT INTO gifi (accno,description) VALUES ('123545', 'TITULOS ENERGETICOS DE RENTABILIDAD CRECIENTE (T.E.R.) ');
    98. 

  98. INSERT INTO gifi (accno,description) VALUES ('123550', 'TITULOS DE AHORRO EDUCATIVO (T.A.E.) ');
    99. 

  99. INSERT INTO gifi (accno,description) VALUES ('123555', 'TITULOS FINANCIEROS INDUSTRIALES Y COMERCIALES ');
    100. 

  100. INSERT INTO gifi (accno,description) VALUES ('123560', 'TESOROS ');
    101. 

  101. INSERT INTO gifi (accno,description) VALUES ('123565', 'TITULOS DE DEVOLUCION DE IMPUESTOS NACIONALES (TIDIS) ');
    102. 

  102. INSERT INTO gifi (accno,description) VALUES ('123570', 'TITULOS INMOBILIARIOS ');
    103. 

  103. INSERT INTO gifi (accno,description) VALUES ('123595', 'OTROS ');
    104. 

  104. INSERT INTO gifi (accno,description) VALUES ('1240', 'ACEPTACIONES BANCARIAS O FINANCIERAS ');
    105. 

  105. INSERT INTO gifi (accno,description) VALUES ('124005', 'BANCOS COMERCIALES ');
    106. 

  106. INSERT INTO gifi (accno,description) VALUES ('124010', 'COMPAŃIAS DE FINANCIAMIENTO COMERCIAL ');
    107. 

  107. INSERT INTO gifi (accno,description) VALUES ('124015', 'CORPORACIONES FINANCIERAS ');
    108. 

  108. INSERT INTO gifi (accno,description) VALUES ('124095', 'OTRAS ');
    109. 

  109. INSERT INTO gifi (accno,description) VALUES ('1245', 'DERECHOS FIDUCIARIOS ');
    110. 

  110. INSERT INTO gifi (accno,description) VALUES ('124505', 'FIDEICOMISOS DE INVERSION MONEDA NACIONAL ');
    111. 

  111. INSERT INTO gifi (accno,description) VALUES ('124510', 'FIDEICOMISOS DE INVERSION MONEDA EXTRANJERA ');
    112. 

  112. INSERT INTO gifi (accno,description) VALUES ('1250', 'DERECHOS DE RECOMPRA DE INVERSIONES NEGOCIADAS (REPOS) ');
    113. 

  113. INSERT INTO gifi (accno,description) VALUES ('125005', 'ACCIONES ');
    114. 

  114. INSERT INTO gifi (accno,description) VALUES ('125010', 'CUOTAS O PARTES DE INTERES SOCIAL ');
    115. 

  115. INSERT INTO gifi (accno,description) VALUES ('125015', 'BONOS ');
    116. 

  116. INSERT INTO gifi (accno,description) VALUES ('125020', 'CEDULAS ');
    117. 

  117. INSERT INTO gifi (accno,description) VALUES ('125025', 'CERTIFICADOS ');
    118. 

  118. INSERT INTO gifi (accno,description) VALUES ('125030', 'PAPELES COMERCIALES ');
    119. 

  119. INSERT INTO gifi (accno,description) VALUES ('125035', 'TITULOS ');
    120. 

  120. INSERT INTO gifi (accno,description) VALUES ('125040', 'ACEPTACIONES BANCARIAS O FINANCIERAS 125095 OTROS ');
    121. 

  121. INSERT INTO gifi (accno,description) VALUES ('125099', 'AJUSTES POR INFLACION ');
    122. 

  122. INSERT INTO gifi (accno,description) VALUES ('1255', 'OBLIGATORIAS ');
    123. 

  123. INSERT INTO gifi (accno,description) VALUES ('125505', 'BONOS DE FINANCIAMIENTO ESPECIAL ');
    124. 

  124. INSERT INTO gifi (accno,description) VALUES ('125510', 'BONOS DE FINANCIAMIENTO PRESUPUESTAL ');
    125. 

  125. INSERT INTO gifi (accno,description) VALUES ('125515', 'BONOS PARA DESARROLLO SOCIAL Y SEGURIDAD INTERNA (B.D.S.I.) ');
    126. 

  126. INSERT INTO gifi (accno,description) VALUES ('125595', 'OTRAS ');
    127. 

  127. INSERT INTO gifi (accno,description) VALUES ('1260', 'CUENTAS EN PARTICIPACION ');
    128. 

  128. INSERT INTO gifi (accno,description) VALUES ('126099', 'AJUSTES POR INFLACION ');
    129. 

  129. INSERT INTO gifi (accno,description) VALUES ('1295', 'OTRAS INVERSIONES ');
    130. 

  130. INSERT INTO gifi (accno,description) VALUES ('129505', 'APORTES EN COOPERATIVAS ');
    131. 

  131. INSERT INTO gifi (accno,description) VALUES ('129510', 'DERECHOS EN CLUBES SOCIALES ');
    132. 

  132. INSERT INTO gifi (accno,description) VALUES ('129515', 'ACCIONES O DERECHOS EN CLUBES DEPORTIVOS ');
    133. 

  133. INSERT INTO gifi (accno,description) VALUES ('129520', 'BONOS EN COLEGIOS ');
    134. 

  134. INSERT INTO gifi (accno,description) VALUES ('129595', 'DIVERSAS ');
    135. 

  135. INSERT INTO gifi (accno,description) VALUES ('129599', 'AJUSTES POR INFLACION ');
    136. 

  136. INSERT INTO gifi (accno,description) VALUES ('1299', 'PROVISIONES ');
    137. 

  137. INSERT INTO gifi (accno,description) VALUES ('129905', 'ACCIONES ');
    138. 

  138. INSERT INTO gifi (accno,description) VALUES ('129910', 'CUOTAS O PARTES DE INTERES SOCIAL ');
    139. 

  139. INSERT INTO gifi (accno,description) VALUES ('129915', 'BONOS ');
    140. 

  140. INSERT INTO gifi (accno,description) VALUES ('129920', 'CEDULAS ');
    141. 

  141. INSERT INTO gifi (accno,description) VALUES ('129925', 'CERTIFICADOS ');
    142. 

  142. INSERT INTO gifi (accno,description) VALUES ('129930', 'PAPELES COMERCIALES ');