From 208f6c2cd469cf46a51b11c0ea58723f4a18f9ab Mon Sep 17 00:00:00 2001 From: Daniel Kahn Gillmor Date: Thu, 19 Jun 2008 01:53:05 -0400 Subject: clarify why monkeysphere-server publish_key is currently non-functional. --- src/common | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'src') diff --git a/src/common b/src/common index 9b06b1d..c39506d 100644 --- a/src/common +++ b/src/common @@ -561,6 +561,8 @@ publish_server_key() { # FIXME: need to figure out better way to identify host key # dummy command so as not to publish fakes keys during testing # eventually: - #gpg --send-keys --keyserver "$KEYSERVER" $(hostname -f) - echo "NOT PUBLISHED: gpg --send-keys --keyserver $KEYSERVER $(hostname -f)" + #gpg --keyserver "$KEYSERVER" --send-keys $(hostname -f) + echo "NOT PUBLISHED (to avoid permanent publication errors during monkeysphere development). +To publish manually, do: gpg --keyserver $KEYSERVER --send-keys $(hostname -f)" + return 1 } -- cgit v1.2.3 03b56279444b93b303d57f785a74d44d75a07df'/> Unnamed repository; edit this file to name it for gitweb.Jonas Smedegaard
summaryrefslogtreecommitdiff
path: root/sql/Colombia-utf8-PUC-gifi.sql
blob: 3b8d7b2e77e888f8b0bb6716b51eee12e1147b20 (plain)
  1. --
  2. --
  3. -- Data for Plan Único de Cuentas (PUC) Gifi Table
  4. --
  5. INSERT INTO gifi (accno,description) VALUES ('1', 'ACTIVO ');
  6. INSERT INTO gifi (accno,description) VALUES ('11', 'DISPONIBLE ');
  7. INSERT INTO gifi (accno,description) VALUES ('1105', 'CAJA ');
  8. INSERT INTO gifi (accno,description) VALUES ('110505', 'CAJA GENERAL ');
  9. INSERT INTO gifi (accno,description) VALUES ('110510', 'CAJAS MENORES ');
  10. INSERT INTO gifi (accno,description) VALUES ('110515', 'MONEDA EXTRANJERA ');
  11. INSERT INTO gifi (accno,description) VALUES ('1110', 'BANCOS ');
  12. INSERT INTO gifi (accno,description) VALUES ('111005', 'MONEDA NACIONAL ');
  13. INSERT INTO gifi (accno,description) VALUES ('111010', 'MONEDA EXTRANJERA ');
  14. INSERT INTO gifi (accno,description) VALUES ('1115', 'REMESAS EN TRANSITO ');
  15. INSERT INTO gifi (accno,description) VALUES ('111505', 'MONEDA NACIONAL ');
  16. INSERT INTO gifi (accno,description) VALUES ('111510', 'MONEDA EXTRANJERA ');
  17. INSERT INTO gifi (accno,description) VALUES ('1120', 'CUENTAS DE AHORRO ');
  18. INSERT INTO gifi (accno,description) VALUES ('112005', 'BANCOS ');
  19. INSERT INTO gifi (accno,description) VALUES ('112010', 'CORPORACIONES DE AHORRO Y VIVIENDA ');
  20. INSERT INTO gifi (accno,description) VALUES ('112015', 'ORGANISMOS COOPERATIVOS FINANCIEROS ');
  21. INSERT INTO gifi (accno,description) VALUES ('1125', 'FONDOS ');
  22. INSERT INTO gifi (accno,description) VALUES ('112505', 'ROTATORIOS MONEDA NACIONAL ');
  23. INSERT INTO gifi (accno,description) VALUES ('112510', 'ROTATORIOS MONEDA EXTRANJERA ');
  24. INSERT INTO gifi (accno,description) VALUES ('112515', 'ESPECIALES MONEDA NACIONAL ');
  25. INSERT INTO gifi (accno,description) VALUES ('112520', 'ESPECIALES MONEDA EXTRANJERA ');
  26. INSERT INTO gifi (accno,description) VALUES ('112525', 'DE AMORTIZACION MONEDA NACIONAL ');
  27. INSERT INTO gifi (accno,description) VALUES ('112530', 'DE AMORTIZACION MONEDA EXTRANJERA ');
  28. INSERT INTO gifi (accno,description) VALUES ('12', 'INVERSIONES ');
  29. INSERT INTO gifi (accno,description) VALUES ('1205', 'ACCIONES ');
  30. INSERT INTO gifi (accno,description) VALUES ('120505', 'AGRICULTURA, GANADERIA, CAZA Y SILVICULTURA ');
  31. INSERT INTO gifi (accno,description) VALUES ('120510', 'PESCA ');
  32. INSERT INTO gifi (accno,description) VALUES ('120515', 'EXPLOTACION DE MINAS Y CANTERAS ');
  33. INSERT INTO gifi (accno,description) VALUES ('120520', 'INDUSTRIA MANUFACTURERA ');
  34. INSERT INTO gifi (accno,description) VALUES ('120525', 'SUMINISTRO DE ELECTRICIDAD, GAS Y AGUA ');
  35. INSERT INTO gifi (accno,description) VALUES ('120530', 'CONSTRUCCION ');
  36. INSERT INTO gifi (accno,description) VALUES ('120535', 'COMERCIO AL POR MAYOR Y AL POR MENOR ');
  37. INSERT INTO gifi (accno,description) VALUES ('120540', 'HOTELES Y RESTAURANTES ');
  38. INSERT INTO gifi (accno,description) VALUES ('120545', 'TRANSPORTE, ALMACENAMIENTO Y COMUNICACIONES ');
  39. INSERT INTO gifi (accno,description) VALUES ('120550', 'ACTIVIDAD FINANCIERA ');
  40. INSERT INTO gifi (accno,description) VALUES ('120555', 'ACTIVIDADES INMOBILIARIAS, EMPRESARIALES Y DE ALQUILER ');
  41. INSERT INTO gifi (accno,description) VALUES ('120560', 'ENSEуANZA ');
  42. INSERT INTO gifi (accno,description) VALUES ('120565', 'SERVICIOS SOCIALES Y DE SALUD ');
  43. INSERT INTO gifi (accno,description) VALUES ('120570', 'OTRAS ACTIVIDADES DE SERVICIOS COMUNITARIOS, SOCIALES Y PERSONALES ');
  44. INSERT INTO gifi (accno,description) VALUES ('120599', 'AJUSTES POR INFLACION ');
  45. INSERT INTO gifi (accno,description) VALUES ('1210', 'CUOTAS O PARTES DE INTERES SOCIAL ');
  46. INSERT INTO gifi (accno,description) VALUES ('121005', 'AGRICULTURA, GANADERIA, CAZA Y SILVICULTURA ');
  47. INSERT INTO gifi (accno,description) VALUES ('121010', 'PESCA ');
  48. INSERT INTO gifi (accno,description) VALUES ('121015', 'EXPLOTACION DE MINAS Y CANTERAS ');
  49. INSERT INTO gifi (accno,description) VALUES ('121020', 'INDUSTRIA MANUFACTURERA ');
  50. INSERT INTO gifi (accno,description) VALUES ('121025', 'SUMINISTRO DE ELECTRICIDAD, GAS Y AGUA ');
  51. INSERT INTO gifi (accno,description) VALUES ('121030', 'CONSTRUCCION ');
  52. INSERT INTO gifi (accno,description) VALUES ('121035', 'COMERCIO AL POR MAYOR Y AL POR MENOR ');
  53. INSERT INTO gifi (accno,description) VALUES ('121040', 'HOTELES Y RESTAURANTES ');
  54. INSERT INTO gifi (accno,description) VALUES ('121045', 'TRANSPORTE, ALMACENAMIENTO Y COMUNICACIONES ');
  55. INSERT INTO gifi (accno,description) VALUES ('121050', 'ACTIVIDAD FINANCIERA ');
  56. INSERT INTO gifi (accno,description) VALUES ('121055', 'ACTIVIDADES INMOBILIARIAS, EMPRESARIALES Y DE ALQUILER ');
  57. INSERT INTO gifi (accno,description) VALUES ('121060', 'ENSEŃANZA ');
  58. INSERT INTO gifi (accno,description) VALUES ('121065', 'SERVICIOS SOCIALES Y DE SALUD ');
  59. INSERT INTO gifi (accno,description) VALUES ('121070', 'OTRAS ACTIVIDADES DE SERVICIOS COMUNITARIOS, SOCIALES Y PERSONALES ');
  60. INSERT INTO gifi (accno,description) VALUES ('121099', 'AJUSTES POR INFLACION ');
  61. INSERT INTO gifi (accno,description) VALUES ('1215', 'BONOS ');
  62. INSERT INTO gifi (accno,description) VALUES ('121505', 'BONOS PUBLICOS MONEDA NACIONAL ');
  63. INSERT INTO gifi (accno,description) VALUES ('121510', 'BONOS PUBLICOS MONEDA EXTRANJERA ');
  64. INSERT INTO gifi (accno,description) VALUES ('121515', 'BONOS ORDINARIOS ');
  65. INSERT INTO gifi (accno,description) VALUES ('121520', 'BONOS CONVERTIBLES EN ACCIONES ');
  66. INSERT INTO gifi (accno,description) VALUES ('121595', 'OTROS ');
  67. INSERT INTO gifi (accno,description) VALUES ('1220', 'CEDULAS ');
  68. INSERT INTO gifi (accno,description) VALUES ('122005', 'CEDULAS DE CAPITALIZACION ');
  69. INSERT INTO gifi (accno,description) VALUES ('122010', 'CEDULAS HIPOTECARIAS ');
  70. INSERT INTO gifi (accno,description) VALUES ('122015', 'CEDULAS DE INVERSION ');
  71. INSERT INTO gifi (accno,description) VALUES ('122095', 'OTRAS ');
  72. INSERT INTO gifi (accno,description) VALUES ('1225', 'CERTIFICADOS ');
  73. INSERT INTO gifi (accno,description) VALUES ('122505', 'CERTIFICADOS DE DEPOSITO A TERMINO (C.D.T.) ');
  74. INSERT INTO gifi (accno,description) VALUES ('122510', 'CERTIFICADOS DE DEPOSITO DE AHORRO ');
  75. INSERT INTO gifi (accno,description) VALUES ('122515', 'CERTIFICADOS DE AHORRO DE VALOR CONSTANTE (C.A.V.C.) ');
  76. INSERT INTO gifi (accno,description) VALUES ('122520', 'CERTIFICADOS DE CAMBIO ');
  77. INSERT INTO gifi (accno,description) VALUES ('122525', 'CERTIFICADOS CAFETEROS VALORIZABLES ');
  78. INSERT INTO gifi (accno,description) VALUES ('122530', 'CERTIFICADOS ELECTRICOS VALORIZABLES (C.E.V.) ');
  79. INSERT INTO gifi (accno,description) VALUES ('122535', 'CERTIFICADOS DE REEMBOLSO TRIBUTARIO (C.E.R.T.) ');
  80. INSERT INTO gifi (accno,description) VALUES ('122540', 'CERTIFICADOS DE DESARROLLO TURISTICO ');
  81. INSERT INTO gifi (accno,description) VALUES ('122545', 'CERTIFICADOS DE INVERSION FORESTAL (C.I.F.) ');
  82. INSERT INTO gifi (accno,description) VALUES ('122595', 'OTROS ');
  83. INSERT INTO gifi (accno,description) VALUES ('1230', 'PAPELES COMERCIALES ');
  84. INSERT INTO gifi (accno,description) VALUES ('123005', 'EMPRESAS COMERCIALES ');
  85. INSERT INTO gifi (accno,description) VALUES ('123010', 'EMPRESAS INDUSTRIALES ');
  86. INSERT INTO gifi (accno,description) VALUES ('123015', 'EMPRESAS DE SERVICIOS ');
  87. INSERT INTO gifi (accno,description) VALUES ('1235', 'TITULOS ');
  88. INSERT INTO gifi (accno,description) VALUES ('123505', 'TITULOS DE DESARROLLO AGROPECUARIO ');
  89. INSERT INTO gifi (accno,description) VALUES ('123510', 'TITULOS CANJEABLES POR CERTIFICADOS DE CAMBIO ');
  90. INSERT INTO gifi (accno,description) VALUES ('123515', 'TITULOS DE TESORERIA (T.E.S.) ');
  91. INSERT INTO gifi (accno,description) VALUES ('123520', 'TITULOS DE PARTICIPACION ');
  92. INSERT INTO gifi (accno,description) VALUES ('123525', 'TITULOS DE CREDITO DE FOMENTO ');
  93. INSERT INTO gifi (accno,description) VALUES ('123530', 'TITULOS FINANCIEROS AGROINDUSTRIALES (T.F.A.) ');
  94. INSERT INTO gifi (accno,description) VALUES ('123535', 'TITULOS DE AHORRO CAFETERO (T.A.C.) ');
  95. INSERT INTO gifi (accno,description) VALUES ('123540', 'TITULOS DE AHORRO NACIONAL (T.A.N.) ');
  96. INSERT INTO gifi (accno,description) VALUES ('123545', 'TITULOS ENERGETICOS DE RENTABILIDAD CRECIENTE (T.E.R.) ');
  97. INSERT INTO gifi (accno,description) VALUES ('123550', 'TITULOS DE AHORRO EDUCATIVO (T.A.E.) ');
  98. INSERT INTO gifi (accno,description) VALUES ('123555', 'TITULOS FINANCIEROS INDUSTRIALES Y COMERCIALES ');
  99. INSERT INTO gifi (accno,description) VALUES ('123560', 'TESOROS ');
  100. INSERT INTO gifi (accno,description) VALUES ('123565', 'TITULOS DE DEVOLUCION DE IMPUESTOS NACIONALES (TIDIS) ');
  101. INSERT INTO gifi (accno,description) VALUES ('123570', 'TITULOS INMOBILIARIOS ');
  102. INSERT INTO gifi (accno,description) VALUES ('123595', 'OTROS ');
  103. INSERT INTO gifi (accno,description) VALUES ('1240', 'ACEPTACIONES BANCARIAS O FINANCIERAS ');
  104. INSERT INTO gifi (accno,description) VALUES ('124005', 'BANCOS COMERCIALES ');
  105. INSERT INTO gifi (accno,description) VALUES ('124010', 'COMPANÍAS DE FIAANNCIAMIENTO COMERCIAL ');
  106. INSERT INTO gifi (accno,description) VALUES ('124015', 'CORPORACIONES FINANCIERAS ');
  107. INSERT INTO gifi (accno,description) VALUES ('124095', 'OTRAS ');
  108. INSERT INTO gifi (accno,description) VALUES ('1245', 'DERECHOS FIDUCIARIOS ');
  109. INSERT INTO gifi (accno,description) VALUES ('124505', 'FIDEICOMISOS DE INVERSION MONEDA NACIONAL ');
  110. INSERT INTO gifi (accno,description) VALUES ('124510', 'FIDEICOMISOS DE INVERSION MONEDA EXTRANJERA ');
  111. INSERT INTO gifi (accno,description) VALUES ('1250', 'DERECHOS DE RECOMPRA DE INVERSIONES NEGOCIADAS (REPOS) ');
  112. INSERT INTO gifi (accno,description) VALUES ('125005', 'ACCIONES ');
  113. INSERT INTO gifi (accno,description) VALUES ('125010', 'CUOTAS O PARTES DE INTERES SOCIAL ');
  114. INSERT INTO gifi (accno,description) VALUES ('125015', 'BONOS ');
  115. INSERT INTO gifi (accno,description) VALUES ('125020', 'CEDULAS ');
  116. INSERT INTO gifi (accno,description) VALUES ('125025', 'CERTIFICADOS ');
  117. INSERT INTO gifi (accno,description) VALUES ('125030', 'PAPELES COMERCIALES ');
  118. INSERT INTO gifi (accno,description) VALUES ('125035', 'TITULOS ');
  119. INSERT INTO gifi (accno,description) VALUES ('125040', 'ACEPTACIONES BANCARIAS O FINANCIERAS 125095 OTROS ');
  120. INSERT INTO gifi (accno,description) VALUES ('125099', 'AJUSTES POR INFLACION ');
  121. INSERT INTO gifi (accno,description) VALUES ('1255', 'OBLIGATORIAS ');
  122. INSERT INTO gifi (accno,description) VALUES ('125505', 'BONOS DE FINANCIAMIENTO ESPECIAL ');
  123. INSERT INTO gifi (accno,description) VALUES ('125510', 'BONOS DE FINANCIAMIENTO PRESUPUESTAL ');
  124. INSERT INTO gifi (accno,description) VALUES ('125515', 'BONOS PARA DESARROLLO SOCIAL Y SEGURIDAD INTERNA (B.D.S.I.) ');
  125. INSERT INTO gifi (accno,description) VALUES ('125595', 'OTRAS ');
  126. INSERT INTO gifi (accno,description) VALUES ('1260', 'CUENTAS EN PARTICIPACION ');
  127. INSERT INTO gifi (accno,description) VALUES ('126099', 'AJUSTES POR INFLACION ');
  128. INSERT INTO gifi (accno,description) VALUES ('1295', 'OTRAS INVERSIONES ');
  129. INSERT INTO gifi (accno,description) VALUES ('129505', 'APORTES EN COOPERATIVAS ');
  130. INSERT INTO gifi (accno,description) VALUES ('129510', 'DERECHOS EN CLUBES SOCIALES ');
  131. INSERT INTO gifi (accno,description) VALUES ('129515', 'ACCIONES O DERECHOS EN CLUBES DEPORTIVOS ');
  132. INSERT INTO gifi (accno,description) VALUES ('129520', 'BONOS EN COLEGIOS ');
  133. INSERT INTO gifi (accno,description) VALUES ('129595', 'DIVERSAS ');
  134. INSERT INTO gifi (accno,description) VALUES ('129599', 'AJUSTES POR INFLACION ');
  135. INSERT INTO gifi (accno,description) VALUES ('1299', 'PROVISIONES ');
  136. INSERT INTO gifi (accno,description) VALUES ('129905', 'ACCIONES ');
  137. INSERT INTO gifi (accno,description) VALUES ('129910', 'CUOTAS O PARTES DE INTERES SOCIAL ');
  138. INSERT INTO gifi (accno,description) VALUES ('129915', 'BONOS ');
  139. INSERT INTO gifi (accno,description) VALUES ('129920', 'CEDULAS ');
  140. INSERT INTO gifi (accno,description) VALUES ('129925', 'CERTIFICADOS ');
  141. INSERT INTO gifi (accno,description) VALUES ('129930', 'PAPELES COMERCIALES ');
  142. INSERT INTO gifi (accno,description) VALUES ('129935', 'TITULOS ');
  143. INSERT INTO gifi (accno,description) VALUES ('129940', 'ACEPTACIONES BANCARIAS O FINANCIERAS ');
  144. INSERT INTO gifi (accno,description) VALUES ('129945', 'DERECHOS FIDUCIARIOS ');
  145. INSERT INTO gifi (accno,description) VALUES ('129950', 'DERECHOS DE RECOMPRA DE INVERSIONES NEGOCIADAS ');
  146. INSERT INTO gifi (accno,description) VALUES ('129955', 'OBLIGATORIAS ');
  147. INSERT INTO gifi (accno,description) VALUES ('129960', 'CUENTAS EN PARTICIPACION ');
  148. INSERT INTO gifi (accno,description) VALUES ('129995', 'OTRAS INVERSIONES ');
  149. INSERT INTO gifi (accno,description) VALUES ('13', 'DEUDORES ');
  150. INSERT INTO gifi (accno,description) VALUES ('1305', 'CLIENTES ');
  151. INSERT INTO gifi (accno,description) VALUES ('130505', 'NACIONALES ');
  152. INSERT INTO gifi (accno,description) VALUES ('130510', 'DEL EXTERIOR ');
  153. INSERT INTO gifi (accno,description) VALUES ('130515', 'DEUDORES DEL SISTEMA ');
  154. INSERT INTO gifi (accno,description) VALUES ('1310', 'CUENTAS CORRIENTES COMERCIALES ');
  155. INSERT INTO gifi (accno,description) VALUES ('131005', 'CASA MATRIZ ');
  156. INSERT INTO gifi (accno,description) VALUES ('131010', 'COMPAŃIAS VINCULADAS ');
  157. INSERT INTO gifi (accno,description) VALUES ('131015', 'ACCIONISTAS O SOCIOS ');
  158. INSERT INTO gifi (accno,description) VALUES ('131020', 'PARTICULARES ');
  159. INSERT INTO gifi (accno,description) VALUES ('131095', 'OTRAS ');
  160. INSERT INTO gifi (accno,description) VALUES ('1315', 'CUENTAS POR COBRAR A CASA MATRIZ ');
  161. INSERT INTO gifi (accno,description) VALUES ('131505', 'VENTAS ');
  162. INSERT INTO gifi (accno,description) VALUES ('131510', 'PAGOS A NOMBRE DE CASA MATRIZ ');
  163. INSERT INTO gifi (accno,description) VALUES ('131515', 'VALORES RECIBIDOS POR CASA MATRIZ ');
  164. INSERT INTO gifi (accno,description) VALUES ('131520', 'PRESTAMOS ');
  165. INSERT INTO gifi (accno,description) VALUES ('1320', 'CUENTAS POR COBRAR A VINCULADOS ECONOMICOS ');
  166. INSERT INTO gifi (accno,description) VALUES ('132005', 'FILIALES ');
  167. INSERT INTO gifi (accno,description) VALUES ('132010', 'SUBSIDIARIAS ');
  168. INSERT INTO gifi (accno,description) VALUES ('132015', 'SUCURSALES ');
  169. INSERT INTO gifi (accno,description) VALUES ('1325', 'CUENTA S POR COBRAR A SOCIOS Y ACCIONISTAS ');
  170. INSERT INTO gifi (accno,description) VALUES ('132505', 'A SOCIOS ');
  171. INSERT INTO gifi (accno,description) VALUES ('132510', 'A ACCIONISTAS ');
  172. INSERT INTO gifi (accno,description) VALUES ('1328', 'APORTES POR COBRAR ');
  173. INSERT INTO gifi (accno,description) VALUES ('1330', 'ANTICIPOS Y AVANCES ');
  174. INSERT INTO gifi (accno,description) VALUES ('133005', 'A PROVEEDORES ');
  175. INSERT INTO gifi (accno,description) VALUES ('133010', 'A CONTRATISTAS ');
  176. INSERT INTO gifi (accno,description) VALUES ('133015', 'A TRABAJADORES ');
  177. INSERT INTO gifi (accno,description) VALUES ('133020', 'A AGENTES ');
  178. INSERT INTO gifi (accno,description) VALUES ('133025', 'A CONCESIONARIOS ');
  179. INSERT INTO gifi (accno,description) VALUES ('133030', 'DE ADJUDICACIONES ');
  180. INSERT INTO gifi (accno,description) VALUES ('133095', 'OTROS ');
  181. INSERT INTO gifi (accno,description) VALUES ('1332', 'CUENTAS DE OPERACION CONJUNTA ');
  182. INSERT INTO gifi (accno,description) VALUES ('1335', 'DEPOSITOS ');
  183. INSERT INTO gifi (accno,description) VALUES ('133505', 'PARA IMPORTACIONES ');
  184. INSERT INTO gifi (accno,description) VALUES ('133510', 'PARA SERVICIOS ');
  185. INSERT INTO gifi (accno,description) VALUES ('133515', 'PARA CONTRATOS ');
  186. INSERT INTO gifi (accno,description) VALUES ('133520', 'PARA RESPONSABILIDADES ');