insert into grupoconcepto values
   ('001', '001', 'INGRESOS');
insert into grupoconcepto values
   ('001', '002', 'EGRESOS');
-------
insert into concepto values
   ('001','MARCADOBRUTO','MARCADO BRUTO','001','11-00-00','D',NULL,NULL, 'S',NULL,'S','CL',NULL);
insert into concepto values
   ('001','MARCAMENOS','MARCADAS DE MENOS','001','11-00-01','D',NULL,NULL,'S',NULL,'S','CL',NULL);
insert into concepto values
   ('001','MARCAMAS','MARCADAS DE MAS','002','11-00-02','C',NULL,NULL,'N',NULL,'S','CL', NULL);
insert into concepto values
   ('001','VENTACONTADO','VENTAS DE CONTADO','001','11-00-03','D',NULL,NULL,'S',NULL,'S','CL',NULL);
insert into concepto values
   ('001','VENTACREDITO','VENTAS DE CREDITO','001','11-00-04','D',NULL,NULL,'S',NULL,'S','CL',NULL);
-----------
insert into conceptoventa values
   ('001', 'VENTACONTADO', 'XX', 'S');
insert into conceptoventa values
   ('001', 'VENTACREDITO', 'ZZ', 'N');
-----------
insert into departamento values
   ('001', '001', 'ROPA', '88', '1ER  PISO');
insert into departamento values
   ('001', '002', 'JUGUETES', '99', '3ER  PISO');
-----------
insert into caja values
   ('001', '001', 'CAJA 1', 'PASILLO1');
insert into caja values
   ('001', '002', 'CAJA 2', 'PASILLO2');
insert into caja values
   ('001', '003', 'CAJA 3', 'PASILLO3');
-------------
insert into tipocajero values
   ('001', '01', 'CAJERO TITULAR', 10000, 25000);
insert into tipocajero values
   ('001', '02', 'CAJERO SUPLENTE', 5000, 15000);
insert into tipocajero values
   ('001', '03', 'CAJERO ESPECIAL', 30000, 100000);
-----------
insert into cajero values
   ('001', '1', '01', '001', 'RTORRES', 'ROSENDA TORRES');
insert into cajero values
   ('001', '2', '02', '002', 'SMENDEZ', 'SANDRA MENDEZ');
insert into cajero values
   ('001', '3', '03', '003', 'JARRIETA', 'JUAN C. ARRIETA');

-------------
insert into operacioncaja values
   ('001', '001', '1',  '15-SEP-99', 1999, 9, '01', 200000, 5000,0, 'C');
insert into operacioncaja values
   ('001', '001', '1',  '16-SEP-99', 1999, 9, '01', 5000, 7000,0, 'C');
insert into operacioncaja values
   ('001', '001', '1',  '18-SEP-99', 1999, 9, '01', 200000, 3000,0, 'C');
insert into operacioncaja values
   ('001', '001', '1',  '19-SEP-99', 1999, 9, '01', 200000, 1000,0, 'C');
insert into operacioncaja values
   ('001', '001', '1',  '20-SEP-99', 1999, 9, '01', 200000, 800,0, 'C');
insert into operacioncaja values
   ('001', '001', '1',  '21-SEP-99', 1999, 9, '01', 200000, 3000,0, 'C');
insert into operacioncaja values
   ('001', '002', '2',  '16-SEP-99', 1999, 9, '01', 200000, 8000, 0,'C');
insert into operacioncaja values
   ('001', '002', '2',  '15-SEP-99', 1999, 9, '01', 200000, 1000,0, 'C');
insert into operacioncaja values
   ('001', '003', '3',  '17-SEP-99', 1999, 9, '03', 50000, 1000,0, 'C');
--------------
insert into operacioncaja values
   ('001', '001', '1',  '15-SEP-98', 1998, 9, '01', 150000, 5000,0, 'C');
insert into operacioncaja values
   ('001', '002', '2',  '16-SEP-98', 1998, 9, '01', 150000, 5000, 0,'C');
insert into operacioncaja values
   ('001', '003', '3',  '17-SEP-98', 1998, 9, '03', 40000, 1000,0, 'C');

--------------
insert into movimientocaja values
   ('001','MARCADOBRUTO','001','1','15-SEP-99',1999,9, NULL,'OBSERVACION XXXX',50000);
insert into movimientocaja values
   ('001','MARCAMAS','001','1','15-SEP-99',1999,9,NULL,NULL,2000);
   insert into movimientocajaDet values
      ('001', '001', '55', '1', '15-SEP-99', 293, 'MARCAMAS', '18-AUG-99', null, 500);
   insert into movimientocajaDet values
      ('001', '001', '56', '1', '15-SEP-99', 293, 'MARCAMAS', '18-JUL-99', null, 1500);

insert into movimientocaja values
   ('001','MARCADOBRUTO','002','2','16-SEP-99',1999,9,NULL,'OBSERVACION YYYY', 80000);
insert into movimientocaja values
   ('001','MARCAMAS','002','2','16-SEP-99',1999,9,NULL,NULL,3000);
   insert into movimientocajaDet values
      ('001', '002', '80', '2', '16-SEP-99', 294, 'MARCAMAS', '01-MAY-99', null, 2800);
   insert into movimientocajaDet values
      ('001', '002', '81', '2', '16-SEP-99', 294, 'MARCAMAS', '01-JUN-99', null, 200);

insert into movimientocaja values
   ('001','MARCAMENOS','002','2','16-SEP-99',1999,9,NULL,NULL,8000);
   insert into movimientocajaDet values
      ('001', '002', '401', '2', '16-SEP-99', 293, 'MARCAMENOS', '01-JAN-99', null, 4200);
   insert into movimientocajaDet values
      ('001', '002', '402', '2', '16-SEP-99', 293, 'MARCAMENOS', '01-FEB-99', null, 3000);
   insert into movimientocajaDet values
      ('001', '002', '403', '2', '16-SEP-99', 293, 'MARCAMENOS', '01-MAR-99', null, 800);

insert into movimientocaja values
   ('001', 'MARCAMENOS','003','3','17-SEP-99',1999,9,NULL,NULL,4000);
   insert into movimientocajaDet values
      ('001', '003', '08403', '3', '17-SEP-99', 295, 'MARCAMENOS', '05-DEC-98', null, 2000);
   insert into movimientocajaDet values
      ('001', '003', '08404', '3', '17-SEP-99', 295, 'MARCAMENOS', '05-JAN-99', null, 2000);

insert into movimientocaja values
   ('001','MARCADOBRUTO', '003','3','17-SEP-99',1999,9,NULL,'OBSERVACION ZZZ',100000);
insert into movimientocaja values
   ('001','APART','002','2','16-SEP-99',1999,9,NULL,NULL,13000);
insert into movimientocaja values
   ('001','DEPOSITOS','002','2','16-SEP-99',1999,9,NULL,NULL,150000);
insert into movimientocaja values
   ('001','DEPOSITOCHK','002','2','16-SEP-99',1999,9,NULL,NULL,22980);

----------
insert into movimientoventa values
   ('001', '001', '1', '15-SEP-99', '001', 'VENTACONTADO', 1999, 9, 20000, 1000);
insert into movimientoventa values
   ('001', '001', '1', '15-SEP-99', '001', 'VENTACREDITO', 1999, 9,  5000, 0);
insert into movimientoventa values
   ('001', '002', '2', '16-SEP-99', '002', 'VENTACREDITO', 1999, 9,  40000, 980);
insert into movimientoventa values
   ('001', '002', '2', '16-SEP-99', '001', 'VENTACREDITO', 1999, 9,  6700, 300);
insert into movimientoventa values
   ('001', '003', '3', '17-SEP-99', '002', 'VENTACONTADO', 1999, 9,  2800, 0);
---------
insert into movimientoventa values
   ('001', '001', '1', '15-SEP-98', '001', 'VENTACONTADO', 1998, 9, 22000, 1200);
insert into movimientoventa values
   ('001', '001', '1', '15-SEP-98', '001', 'VENTACREDITO', 1998, 9,  35000, 0);
insert into movimientoventa values
   ('001', '002', '2', '16-SEP-98', '002', 'VENTACREDITO', 1998, 9,  25000, 1500);
insert into movimientoventa values
   ('001', '002', '2', '16-SEP-98', '001', 'VENTACREDITO', 1998, 9,  7500, 0);
insert into movimientoventa values
   ('001', '003', '3', '17-SEP-98', '002', 'VENTACONTADO', 1998, 9,  9800, 630);
------------
insert into balancecaja values
   ('001', '1',  1999, 9, 10000, 2000, 5000, 3000, 30, 200000,NULL, 'C');
insert into balancecaja values
   ('001', '2',  1999, 9, 0, 2000, 7000, 1000,  29, 100000, NULL,'C');
insert into balancecaja values
   ('001', '3',  1999, 9, 4000,  500, 2500, 6000, 30, 50000, NULL,'C');
insert into balancecaja values
   ('001', '1',  1999, 10, 1000, 0, 1000, 1000, 31, 200000, NULL,'C');
insert into balancecaja values
   ('001', '2',  1999, 10, 0, 1000, 3000, 0,  31, 100000, NULL,'C');
insert into balancecaja values
   ('001', '3',  1999, 10, 8000, 1500, 500, 0, 30, 50000, NULL,'C');