DELETE FROM  TCONCEPTOSCODIGOCONTABLE WHERE CCONCEPTO IN ('1630','1631','1632','1633');
DELETE FROM  TCONCEPTOS WHERE CCONCEPTO IN ('1630','1631','1632','1633');
DELETE FROM  TCONCEPTOSID WHERE CCONCEPTO IN ('1630','1631','1632','1633');

INSERT INTO TCONCEPTOSID (CCONCEPTO, CSUBSISTEMA, CGRUPOTRANSACCION, CODIGOORDENPAGO) VALUES ('1630', '05', null, null);
INSERT INTO TCONCEPTOSID (CCONCEPTO, CSUBSISTEMA, CGRUPOTRANSACCION, CODIGOORDENPAGO) VALUES ('1631', '05', null, null);
INSERT INTO TCONCEPTOSID (CCONCEPTO, CSUBSISTEMA, CGRUPOTRANSACCION, CODIGOORDENPAGO) VALUES ('1632', '05', null, null);
INSERT INTO TCONCEPTOSID (CCONCEPTO, CSUBSISTEMA, CGRUPOTRANSACCION, CODIGOORDENPAGO) VALUES ('1633', '05', null, null);

INSERT INTO TCONCEPTOS (CIDIOMA, CCONCEPTO, FHASTA, FDESDE, DESCRIPCION, VERSIONCONTROL) VALUES ('ES', '1630', TIMESTAMP '2999-12-31 00:00:00', TIMESTAMP '2007-01-01 00:00:00', 'POR GARANTIA DE CREDITO-CONSUMO', 0);
INSERT INTO TCONCEPTOS (CIDIOMA, CCONCEPTO, FHASTA, FDESDE, DESCRIPCION, VERSIONCONTROL) VALUES ('ES', '1631', TIMESTAMP '2999-12-31 00:00:00', TIMESTAMP '2007-01-01 00:00:00', 'POR GARANTIA DE CREDITO-VIVIENDA', 0);
INSERT INTO TCONCEPTOS (CIDIOMA, CCONCEPTO, FHASTA, FDESDE, DESCRIPCION, VERSIONCONTROL) VALUES ('ES', '1632', TIMESTAMP '2999-12-31 00:00:00', TIMESTAMP '2007-01-01 00:00:00', 'POR GARANTIA DE CREDITO-MICRO', 0);
INSERT INTO TCONCEPTOS (CIDIOMA, CCONCEPTO, FHASTA, FDESDE, DESCRIPCION, VERSIONCONTROL) VALUES ('ES', '1633', TIMESTAMP '2999-12-31 00:00:00', TIMESTAMP '2007-01-01 00:00:00', 'POR GARANTIA DE CREDITO-COMERCIAL', 0);

INSERT INTO TCONCEPTOSCODIGOCONTABLE (CCONCEPTO, VERSIONCONTROL, CODIGOCONTABLE) VALUES ('1630', 1, '01');
INSERT INTO TCONCEPTOSCODIGOCONTABLE (CCONCEPTO, VERSIONCONTROL, CODIGOCONTABLE) VALUES ('1631', 1, '02');
INSERT INTO TCONCEPTOSCODIGOCONTABLE (CCONCEPTO, VERSIONCONTROL, CODIGOCONTABLE) VALUES ('1632', 1, '03');
INSERT INTO TCONCEPTOSCODIGOCONTABLE (CCONCEPTO, VERSIONCONTROL, CODIGOCONTABLE) VALUES ('1633', 1, '04');

UPDATE TCATEGORIASDETALLE SET CODIGOCONTABLE = '730110TO' WHERE CATEGORIA = 'GRTZDO' and CGRUPOBALANCE = '73' and CPERSONA_COMPANIA = 2;
UPDATE TCATEGORIASDETALLE SET CODIGOCONTABLE = '740110TO' WHERE CATEGORIA = 'GRTZDO' and CGRUPOBALANCE = '74' and CPERSONA_COMPANIA = 2;