-- Deleting TCONSTRAINTSRESULTADO... delete from tConstraintsResultado where constraintname='CKESVENCIMIENTOFUTUROCLA'; delete from tConstraintsResultado where constraintname='FKTRASPCLASTAT'; delete from tConstraintsResultado where constraintname='FKTRASPCLASTATFUT'; delete from tConstraintsResultado where constraintname='FKTRASPCLASTATVEN'; delete from tConstraintsResultado where constraintname='IPKTRASPCLASTAT'; delete from tConstraintsResultado where constraintname='FKTRASPSTATACT'; delete from tConstraintsResultado where constraintname='FKTRASPSTATPAS'; delete from tConstraintsResultado where constraintname='CKESVENCIMIENTOFUTURO'; delete from tConstraintsResultado where constraintname='IPKTRASPSTAT'; -- Deleting TCONSTRAINTSRESULTADOID... delete from tConstraintsResultadoId where constraintname='CKESVENCIMIENTOFUTUROCLA'; delete from tConstraintsResultadoId where constraintname='FKTRASPCLASTAT'; delete from tConstraintsResultadoId where constraintname='FKTRASPCLASTATFUT'; delete from tConstraintsResultadoId where constraintname='FKTRASPCLASTATVEN'; delete from tConstraintsResultadoId where constraintname='IPKTRASPCLASTAT'; delete from tConstraintsResultadoId where constraintname='FKTRASPSTATACT'; delete from tConstraintsResultadoId where constraintname='FKTRASPSTATPAS'; delete from tConstraintsResultadoId where constraintname='CKESVENCIMIENTOFUTURO'; delete from tConstraintsResultadoId where constraintname='IPKTRASPSTAT'; -- Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultadoId values('CKESVENCIMIENTOFUTUROCLA','2290','505332'); insert into tConstraintsResultadoId values('FKTRASPCLASTAT','2291','505328'); insert into tConstraintsResultadoId values('FKTRASPCLASTATFUT','2291','505329'); insert into tConstraintsResultadoId values('FKTRASPCLASTATVEN','2291','505330'); insert into tConstraintsResultadoId values('IPKTRASPCLASTAT','1','505331'); -- Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultado values('ES','CKESVENCIMIENTOFUTUROCLA',to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'FUERA DE LOS VALORES PERMITIDOS PARA TTRASPASOSCLASIFICACIONESTATUS.'); insert into tConstraintsResultado values('ES','FKTRASPCLASTAT',to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'NO EXISTE REFERENCIA DE TTRASPASOSCLASIFICACIONESTATUS EN TCLASIFICACIONCONTABLEID'); insert into tConstraintsResultado values('ES','FKTRASPCLASTATFUT',to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'NO EXISTE REFERENCIA DE TTRASPASOSCLASIFICACIONESTATUS EN TESTATUSCUENTAID'); insert into tConstraintsResultado values('ES','FKTRASPCLASTATVEN',to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'NO EXISTE REFERENCIA DE TTRASPASOSCLASIFICACIONESTATUS EN TESTATUSCUENTAID'); insert into tConstraintsResultado values('ES','IPKTRASPCLASTAT',to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'REGISTRO DUPLICADO CLAVE PRINCIPAL DE TTRASPASOSCLASIFICACIONESTATUS'); commit; -- Done.