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');