ID_PROVEEDOR insert into Proveedor values(proveedor_sec.nextval,domicilio_sec.nextval,comunic acion_sec.

nextval,5,'Garbarino', '45-46737475-8', to_date('2011/09/29' , 'yyyy/m m/dd'), to_date('2011/09/29' , 'yyyy/mm/dd')); insert into Proveedor values(proveedor_sec.nextval,domicilio_sec.nextval,comunic acion_sec.nextval,5,'la casa del audio', '45-46457898-8', to_date('2011/09/29' , 'yyyy/mm/dd'), to_date('2011/09/29' , 'yyyy/mm/dd')); insert into Proveedor values(proveedor_sec.nextval,domicilio_sec.nextval,comunic acion_sec.nextval,5,'compumundo', '45-47857832-8 ', to_date('2011/09/29' , 'yyyy/mm/dd'), to_date('2011/09/29' , 'yyyy/mm/dd')); insert into Proveedor values(proveedor_sec.nextval,domicilio_sec.nextval,comunic acion_sec.nextval,5,'Fravega', '45-46254789-8', to_date('2011/09/29' , 'yyyy/mm/ dd'), to_date('2011/09/29' , 'yyyy/mm/dd')); insert into Proveedor values(proveedor_sec.nextval,domicilio_sec.nextval,comunic acion_sec.nextval,5,'Motorola', '45-46254789-8', to_date('2011/09/29' , 'yyyy/mm /dd'), to_date('2011/09/29' , 'yyyy/mm/dd')); ID_PAIS insert insert insert insert insert into into into into into pais pais pais pais pais values(1,'Uruguay'); values(2,'Brasil'); values(3,'Paraguay'); values(4,'Venezuela'); values(5,'Chile'); values(1,1'Buenos Aires'); values(2,2'Buenos Aires'); values(3,3'Santa Cruz'); values(4,4'Rio Negro'); values(5,5'Neuquen'); values(6,6'Mendoza');

ID_PROVINCIA insert into provincia insert into provincia insert into provincia insert into provincia insert into provincia insert into provincia ID_LOCALIDAD insert into localidad os'); insert into localidad ngam'); insert into localidad o'); insert into localidad s Lugares'); insert into localidad del Parque'); insert into localidad Pea'); ID_DESCRIPCION insert insert insert insert insert into into into into into

values(localidad_sec.nextval,provincia_sec.nextval, 'Caser values(localidad_sec.nextval,provincia_sec.nextval, 'Hurli values(localidad_sec.nextval,provincia_sec.nextval, 'Devot values(localidad_sec.nextval,provincia_sec.nextval, 'Santo values(localidad_sec.nextval,provincia_sec.nextval, 'Villa values(localidad_sec.nextval,provincia_sec.nextval, 'Saenz

descripcion descripcion descripcion descripcion descripcion

values(descripcion_sec.nextval,marca_sec.nextval); values(descripcion_sec.nextval,marca_sec.nextval); values(descripcion_sec.nextval,marca_sec.nextval); values(descripcion_sec.nextval,marca_sec.nextval); values(descripcion_sec.nextval,marca_sec.nextval);

ID_VENDEDOR

insert insert insert insert insert

into into into into into

vendedor vendedor vendedor vendedor vendedor

values(vendedor_sec.nextval,'20','20%', values(vendedor_sec.nextval,'12','10%', values(vendedor_sec.nextval,'10','15%', values(vendedor_sec.nextval,'10','15%', values(vendedor_sec.nextval,'20','10%',

'procesador','5'); 'memorias','5'); 'gabinete','5'); 'mother','5'); 'Fuente','5');

ID_marca insert into marca values(marca_sec.nextval,'2011',to_date('2011/09/28', /dd'),'No caduca','Fuente', dimension_sec.nextval); insert into marca values(marca_sec.nextval,'2011',to_date('2011/09/28', /dd'),'No caduca','Mother', dimension_sec.nextval); insert into marca values(marca_sec.nextval,'2011',to_date('2011/09/28', /dd'),'No caduca','Memorias Kingston', dimension_sec.nextval); insert into marca values(marca_sec.nextval,'2011',to_date('2011/09/28', /dd'),'No caduca','Teclado Microsoft', dimension_sec.nextval); insert into marca values(marca_sec.nextval,'2011',to_date('2011/09/28', /dd'),'No caduca','Mouse Microsoft', dimension_sec.nextval); ID_TIPO DE MONEDA insert insert insert insert insert into into into into into "TIPO "TIPO "TIPO "TIPO "TIPO DE DE DE DE DE MONEDA" MONEDA" MONEDA" MONEDA" MONEDA" values(tipo_moneda_sec.nextval, values(tipo_moneda_sec.nextval, values(tipo_moneda_sec.nextval, values(tipo_moneda_sec.nextval, values(tipo_moneda_sec.nextval, 'dolar'); 'Euro'); 'Real'); 'Pesos'); 'Patacones'); 'yyyy/mm 'yyyy/mm 'yyyy/mm 'yyyy/mm 'yyyy/mm

ID_DIMENSION insert into m'); insert into 2cm'); insert into 3cm'); insert into 26cm'); insert into cm'); dimension values(dimension_sec.nextval, '50cm','120cm', '65cm', '78c dimension values(dimension_sec.nextval, '125cm','470cm', '780cm', '8 dimension values(dimension_sec.nextval, '155cm','196cm', '56cm', '12 dimension values(dimension_sec.nextval, '483cm','129cm', '458cm', '1 dimension values(dimension_sec.nextval, '123cm','269cm', '53cm', '56

ID_"CONDICION IVA" insert insert insert insert insert into into into into into "condicion "condicion "condicion "condicion "condicion iva" iva" iva" iva" iva" values(cond_iva_sec.nextval,tipo_iva_sec.nextval); values(cond_iva_sec.nextval,tipo_iva_sec.nextval); values(cond_iva_sec.nextval,tipo_iva_sec.nextval); values(cond_iva_sec.nextval,tipo_iva_sec.nextval); values(cond_iva_sec.nextval,tipo_iva_sec.nextval);

ID_UBICACION insert insert insert insert insert into into into into into ubicacion ubicacion ubicacion ubicacion ubicacion values values values values values (ubicacion_sec.nextval, (ubicacion_sec.nextval, (ubicacion_sec.nextval, (ubicacion_sec.nextval, (ubicacion_sec.nextval, 'santos Lugares'); 'Floresta'); 'Ballester'); 'Saenz Pea'); 'Palermo');

ID_TIPO DE IVA insert insert insert insert insert into into into into into "TIPO "TIPO "TIPO "TIPO "TIPO DE DE DE DE DE IVA" IVA" IVA" IVA" IVA" values(tipo_iva_sec.nextval, values(tipo_iva_sec.nextval, values(tipo_iva_sec.nextval, values(tipo_iva_sec.nextval, values(tipo_iva_sec.nextval, 'RI','21%'); 'RNI','10,5%'); 'MTRIBU','10,5%'); 'MTRIBU','21%'); 'MTRIBU','21%');

ID_DEPOSITO insert into deposito values(deposito_sec.nextval,domicilio_sec.nextval,'Materia Prima', comunicacion_sec.nextval, ubicacion_sec.nextval); insert into deposito values(deposito_sec.nextval,domicilio_sec.nextval,'almacen' , comunicacion_sec.nextval, ubicacion_sec.nextval); insert into deposito values(deposito_sec.nextval,domicilio_sec.nextval,'Producto Terminado', comunicacion_sec.nextval, ubicacion_sec.nextval); insert into deposito values(deposito_sec.nextval,domicilio_sec.nextval,'Prod. s. terminar', comunicacion_sec.nextval, ubicacion_sec.nextval); insert into deposito values(deposito_sec.nextval,domicilio_sec.nextval,'[Link] Fallas', comunicacion_sec.nextval, ubicacion_sec.nextval); insert into domicilio values (504, 504, 504, 504, 'A5632ADS', 'cEJAS', '0', '0') ; ID_Domicilio insert into ); insert into ', '6'); insert into '5') insert into ); ID_EMPRESA insert into empresa values(empresa_sec.nextval,t_cta_cte_sec.nextval,cta_cte_sec .nextval,comunicacion_sec.nextval,cond_iva_sec.nextval,domicilio_sec.nextval,'30 -4543541-4','CALitos','fernandez',to_date('2011/09/29' , 'yyyy/mm/dd'),'Suple',5 ,to_date('2011/09/29' , 'yyyy/mm/dd')); insert into empresa values(empresa_sec.nextval,t_cta_cte_sec.nextval,cta_cte_sec .nextval,comunicacion_sec.nextval,cond_iva_sec.nextval,domicilio_sec.nextval,'30 -4543541-4','Matias','Messi',to_date('2011/09/29' , 'yyyy/mm/dd'),'AFA',5,to_dat e('2011/09/29' , 'yyyy/mm/dd')); insert into empresa values(empresa_sec.nextval,t_cta_cte_sec.nextval,cta_cte_sec .nextval,comunicacion_sec.nextval,cond_iva_sec.nextval,domicilio_sec.nextval,'30 -4534531-4','Nicole','Neuman',to_date('2011/09/29' , 'yyyy/mm/dd'),'TELEFE',5,to _date('2011/09/29' , 'yyyy/mm/dd')); insert into empresa values(empresa_sec.nextval,t_cta_cte_sec.nextval,cta_cte_sec .nextval,comunicacion_sec.nextval,cond_iva_sec.nextval,domicilio_sec.nextval,'30 -4123231-4','Critian','Sarrus',to_date('2011/09/29' , 'yyyy/mm/dd'),'Doggi',5,to _date('2011/09/29' , 'yyyy/mm/dd')); insert into empresa values(empresa_sec.nextval,t_cta_cte_sec.nextval,cta_cte_sec .nextval,comunicacion_sec.nextval,cond_iva_sec.nextval,domicilio_sec.nextval,'30 -4567231-4','Eliana','Rodriguez',to_date('2011/09/29' , 'yyyy/mm/dd'),'AMD',5,to _date('2011/09/29' , 'yyyy/mm/dd')); ID_PRODUCTO domicilio values (500, 500, 500, 500, 'A3456EfE', 'Moreno', '0', '0' domicilio values (501, 501, 501, 501, 'A3456cfE', 'Leonismo Ar.', '3 domicilio values (502, 502, 502, 502, 'A3490FRE', 'Irivarren.', '2', domicilio values (503, 503, 503, 503, 'A5423bcs', 'Murias', '0', '0'

insert into producto values(500,'23456', '123154',500 , '245', to_date('2011/09/ 29','yyyy/mm/dd'),6 ,600 , '150', 6, 6, '420'); insert into producto values(501,'23456', '32424',501 , '324', to_date('2011/09/2 9','yyyy/mm/dd'),5 ,5 , '210', 5, 5, '1235'); insert into producto values(502,'23456', '53212',502 , '245', to_date('2011/09/2 9','yyyy/mm/dd'),5 ,502 , '534', 5, 5, '654'); insert into producto values(503,'23456', '53212',503 , '245', to_date('2011/09/2 9','yyyy/mm/dd'),5 ,503 , '534', 5, 5, '654'); insert into producto values(504,'23456', '53212',504 , '245', to_date('2011/09/2 9','yyyy/mm/dd'),5 ,504 , '534', 5, 5, '654'); ID_COMUNICACION insert into comunicacion values(comunicacion_sec.nextval, empresa_sec.nextval, ' 59021024', 'quick@[Link]', '1547854321', '[Link]', '43567802', 'Enriqu e Acoroni'); insert into comunicacion values(comunicacion_sec.nextval, empresa_sec.nextval, ' 47851234', 'produc@[Link]', '1547854321', '[Link]', '47569823', 'Fabi an Roblendo'); insert into comunicacion values(comunicacion_sec.nextval, empresa_sec.nextval, ' 46578844', 'hdfc@[Link]', '1547854321', '[Link]', '47589345', 'Nestor Lopez'); insert into comunicacion values(comunicacion_sec.nextval, empresa_sec.nextval, ' 46349232', 'ituom@[Link]', '1547857463', '[Link]', '47859080', 'Mauric io Macri'); insert into comunicacion values(comunicacion_sec.nextval, empresa_sec.nextval, ' 43748232', 'pepsi@[Link]', '1534567890', '[Link]', '47893245', 'Alej andro Muccio'); ID_DOCUMENTO insert insert insert insert insert into into into into into documento documento documento documento documento values(500,500 values(501,501 values(502,502 values(503,503 values(504,504 , , , , , '36825567'); '35673009'); '29009456'); '10234589'); '9234567');

ID_CTA_CTE insert into "CUENTA CORRIENTE" values (500, 500, 500, '$30000',500, 1/09/29','yyyy/mm/dd'), to_date('2011/09/29','yyyy/mm/dd'), 5); insert into "CUENTA CORRIENTE" values (501, 501, 501, '$43000',501, 1/09/29','yyyy/mm/dd'), to_date('2011/09/29','yyyy/mm/dd'), 5); insert into "CUENTA CORRIENTE" values (502, 502, 502, '$20000',502, 1/09/29','yyyy/mm/dd'), to_date('2011/09/29','yyyy/mm/dd'), 5); insert into "CUENTA CORRIENTE" values (503, 503, 503, '$25000',503, 1/09/29','yyyy/mm/dd'), to_date('2011/09/29','yyyy/mm/dd'), 5); insert into "CUENTA CORRIENTE" values (504, 504, 504, '$25500',504, 1/09/29','yyyy/mm/dd'), to_date('2011/09/29','yyyy/mm/dd'), 5); ID_PLANILLA DE STOCK insert into "Planilla de stock" values (planilla_stock_sec.nextval, producto_sec .nextval, 'memorias', ubicacion_sec.nextval, '1500', '3000', to_date('2011/09/28 ', 'yyyy/mm/dd'),to_date('2011/09/28', 'yyyy/mm/dd'), usuario_sec.nextval, '1250 ', '5000'); insert into "Planilla de stock" values (planilla_stock_sec.nextval, producto_sec to_date('201 to_date('201 to_date('201 to_date('201 to_date('201

.nextval, 'gabinetes', ubicacion_sec.nextval, '1000', '1500', to_date('2011/09/2 8', 'yyyy/mm/dd'),to_date('2011/09/28', 'yyyy/mm/dd'), usuario_sec.nextval, '650 ', '2500'); insert into "Planilla de stock" values (planilla_stock_sec.nextval, producto_sec .nextval, 'gabinetes', ubicacion_sec.nextval, '1400', '4000', to_date('2011/09/2 8', 'yyyy/mm/dd'),to_date('2011/09/28', 'yyyy/mm/dd'), usuario_sec.nextval, '708 ', '4300'); insert into "Planilla de stock" values (planilla_stock_sec.nextval, producto_sec .nextval, 'mother', ubicacion_sec.nextval, '1400', '4000', to_date('2011/09/28', 'yyyy/mm/dd'),to_date('2011/09/28', 'yyyy/mm/dd'), usuario_sec.nextval, '708', '4300'); insert into "Planilla de stock" values (planilla_stock_sec.nextval, producto_sec .nextval, 'teclados', ubicacion_sec.nextval, '589', '985', to_date('2011/09/28', 'yyyy/mm/dd'),to_date('2011/09/28', 'yyyy/mm/dd'), usuario_sec.nextval, '658', '6700');

ID_FACTURA insert into factura values(factura_sec.nextval,'4534',empresa_sec.nextval,produc to_sec.nextval,'543',vendedor_sec.nextval,'4532',tipo_iva_sec.nextval,'$4321','$ 8453'); insert into factura values(factura_sec.nextval,'25233',empresa_sec.nextval,produ cto_sec.nextval,'245',vendedor_sec.nextval,'4435',tipo_iva_sec.nextval,'$445341' ,'$845353'); insert into factura values(factura_sec.nextval,'73445',empresa_sec.nextval,produ cto_sec.nextval,'6545',vendedor_sec.nextval,'2345',tipo_iva_sec.nextval,'$56554' ,'$12354'); insert into factura values(factura_sec.nextval,'23456',empresa_sec.nextval,produ cto_sec.nextval,'34567',vendedor_sec.nextval,'2345',tipo_iva_sec.nextval,'$74533 ','$23445'); insert into factura values(factura_sec.nextval,'23456',empresa_sec.nextval,produ cto_sec.nextval,'23457',vendedor_sec.nextval,'2345',tipo_iva_sec.nextval,'$2194' ,'$53256'); ID_T_CTE_CTA insert insert insert insert insert into into into into into "TIPO "TIPO "TIPO "TIPO "TIPO DE DE DE DE DE CTA CTA CTA CTA CTA CTE" CTE" CTE" CTE" CTE" values(t_cta_cte_sec.nextval,'20 coutas'); values(t_cta_cte_sec.nextval,'45 coutas'); values(t_cta_cte_sec.nextval,'10 coutas'); values(t_cta_cte_sec.nextval,'50 coutas'); values(t_cta_cte_sec.nextval,'5 coutas');

ID_t_DOCUMENTO insert insert insert insert insert into into into into into "TIPO "TIPO "TIPO "TIPO "TIPO DE DE DE DE DE DOCUMENTO" DOCUMENTO" DOCUMENTO" DOCUMENTO" DOCUMENTO" values(500,'DNI'); values(501,'cedula'); values(502,'No posee'); values(503,'DNI'); values(504,'cedula');

ID_RUBRO insert insert insert insert insert into into into into into rubro rubro rubro rubro rubro values(rubro_sec.nextval,subrubro_sec.nextval); values(rubro_sec.nextval,subrubro_sec.nextval); values(rubro_sec.nextval,subrubro_sec.nextval); values(rubro_sec.nextval,subrubro_sec.nextval); values(rubro_sec.nextval,subrubro_sec.nextval);

ID_SUBRUBRO insert insert insert insert insert into into into into into subrubro subrubro subrubro subrubro subrubro values(subrubro_sec.nextval,'escritorio'); values(subrubro_sec.nextval,'programas'); values(subrubro_sec.nextval,'electricidad'); values(subrubro_sec.nextval,'pilas'); values(subrubro_sec.nextval,'Luz');