Changes between Version 17 and Version 18 of carga_movimientos

Timestamp:

07/27/12 23:46:48 (12 years ago)

Author:

David

Comment:

--

carga_movimientos

@@ -57 +57 @@
 
 {{{
+#!text/x-sql
  DELETE FROM <NOMBRE DE LA TABLA>
 }}}
@@ -250 +251 @@
 Tabla CN_TABLE_VIG_SEQ
 
-{{{
-
+Vigencia 2010
+
+{{{
+#!text/x-sql
 UPDATE CN_TABLE_VIG_SEQ
 set seq = nvl( (select max(id_documento) from cn_documento where id_vigencia = 2010 and id_cia=1  ),0 )
@@ -263 +266 @@
 set seq = nvl( (select max(id_mov_cont) from cn_movimiento_contable where id_vigencia = 2010 and id_cia=1  ),0 )
 WHERE NOM_ENTIDAD='CN_MOVIMIENTO_CONTABLE' AND ID_CIA=1 and ID_VIGENCIA = 2010;
-
+}}}
+
+Vigencia 2011
+
+{{{
+#!text/x-sql
 UPDATE CN_TABLE_VIG_SEQ
 set seq = nvl( (select max(id_documento) from cn_documento where id_vigencia = 2011 and id_cia=1  ),0 )
@@ -275 +283 @@
 set seq = nvl( (select max(id_mov_cont) from cn_movimiento_contable where id_vigencia = 2011 and id_cia=1  ),0 )
 WHERE NOM_ENTIDAD='CN_MOVIMIENTO_CONTABLE' AND ID_CIA=1 and ID_VIGENCIA = 2011;
-
+}}}
+
+Vigencia 2012
+
+{{{
+#!text/x-sql
 UPDATE CN_TABLE_VIG_SEQ
 set seq = nvl( (select max(id_documento) from cn_documento where id_vigencia = 2012 and id_cia=1  ),0 )
@@ -287 +300 @@
 set seq = nvl( (select max(id_mov_cont) from cn_movimiento_contable where id_vigencia = 2012 and id_cia=1  ),0 )
 WHERE NOM_ENTIDAD='CN_MOVIMIENTO_CONTABLE' AND ID_CIA=1 and ID_VIGENCIA = 2012;
-
 }}}
 
@@ -314 +326 @@
  }}} 
 
-