drop table inv_mensualtmp;
create table inv_mensualtmp (
   cod_cia              CHAR(3)                         not null,
   cod_bodega           CHAR(3)                         not null,
   clasifica            VARCHAR2(5)                     not null,
   mon_inicial          NUMBER(14)                    not null,
   mon_compra           NUMBER(14)                    not null,
   mon_venta            NUMBER(14)                    not null,
   mon_devcli           NUMBER(14)                    not null,
   mon_devprov          NUMBER(14)                    not null,
   mon_otrent           NUMBER(14)                    not null,
   mon_entrans          NUMBER(14)                    not null,
   mon_satrans          NUMBER(14)                    not null,
   mon_otrsal           NUMBER(14)                    not null,
   ventas               NUMBER(14)			  not null,
   devolucion           NUMBER(14)		        not null,
   constraint INV_MENSUALTMP_PK primary key (cod_cia, cod_bodega, clasifica)
)
/

drop table articulosvtmp;
create table articulosvtmp (
   cod_cia              CHAR(3)                         not null,
   cod_bodega           CHAR(3)                         not null,
   cod_articulo         VARCHAR2(25)			not null,
   des_articulo         VARCHAR2(50)			not null,
   can_existe		NUMBER(14,4)			not null,
   costo		NUMBER(14,4)			not null,
   fec_ult_compra	DATE,	
   can_ult_compra	NUMBER(14,4),
   fec_pen_compra	DATE,
   can_pen_compra	NUMBER(14,4),
   can_venta		NUMBER(14,4),
   cod_proveedor 	VARCHAR(25),
   constraint ARTICULOSVTMP_PK primary key (cod_cia, cod_bodega, cod_articulo)
)
/


create table inv_artabc_tmp (
   cod_cia              CHAR(3)                         not null,
   cod_bodega           CHAR(3)                         not null,
   cod_articulo         VARCHAR2(25)                    not null,
   monto                NUMBER(14,4)                    not null,
   abc                  CHAR(1)				  not null,
   constraint INV_ARTABC_TMP_PK primary key (cod_cia, cod_bodega, cod_articulo)
)
/

