28/04/2021 16:19:52 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->Generar Comprobate MÉTODO->uf_guardar_detallecmp ERROR->Invalid query: ERROR: insert or update on table "scb_dt_cmp_ret" violates foreign key constraint "fk_scb_dt_cmp_ret__scb_cmp_ret" DETAIL: Key (codemp, codret, numcom, tipsolpag)=(0001, 0000000001, 20210400000001 , LIQA) is not present in table "scb_cmp_ret". Whole query: INSERT INTO scb_dt_cmp_ret (codemp,codret,numcom,numope,fecfac,numfac,numcon,numnd,numnc,tiptrans, totcmp_sin_iva,totcmp_con_iva,basimp,porimp,totimp,iva_ret,desope, numsop,codban,ctaban,numdoc,codope,tipsolpag, cmp_porcret, cmp_monobjret, cmp_monret, cmp_sc_cuenta,cmp_codret, cmpretmanual,nrocompcont) VALUES ('0001','0000000001','20210400000001','0000000002', '2021-04-28','7777','00-7777','','', '01-reg','1000000','1160000','1000000', '16','160000','120000.00','','CXPTB-000000004', '','','7777','01','LIQA', '75','1000000','120000.00','201040300', '00001', '0', '')