09/09/2021 16:37:00  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <br><b>ERROR-></b><br><b>CLASE:</b> covensol_cxc_cuentasxcobrar <br><b>METODO:</b> insertar_documentoInvalid query: ERROR:  duplicate key value violates unique constraint "cxc_documento_codemp_key"
DETAIL:  Key (codemp, codtipdoc, numdoc)=(0001, NC, 2083) already exists.
Whole query:   LOCK TABLE cxc_documento IN ACCESS EXCLUSIVE MODE;
					                SELECT reset_sequencia('cxc_documento','id_doc');
					                INSERT INTO cxc_documento(
											    codemp, codsuc, codcaj, codtipdoc, numdoc, coddoc, numcont_doc, id_fact, 
												estdoccxc,codmon_doc, tascam_doc, tipopecont, fecdoc, porcdesc_doc, montodesc_doc, 
												saldo_doc, subtot_doc, iva_doc, otros_doc, baseimp_doc, total_doc, 
												descripdoc, nummov_doc, numorddes_doc, procedoc, coduniadm, codestpro1, 
												codestpro2, codestpro3, codestpro4, codestpro5, estcla,formpagdoc, 
												id_fact_tercero, id_cliente_tercero,noafecdoc,noapllibven_doc,	
												
												fecreg, 
												usureg, horareg
										) 
										VALUES ('0001','0002','0002','NC','00002083','00002083','','492','P','USD','4123464.32','DEV','2021-09-09','0.00','0','0','1682736307.42','269237809.19','0','1682736307.42','1951974116.61','','','','CXCDOC','----------','-------------------------','-------------------------','-------------------------','-------------------------','-------------------------','-','APLDO','0','0','0','0','2021-09-09','ADMINISTRADOR','16:37'); ; SELECT lastval() AS valor_id; 

09/09/2021 16:37:42  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <br><b>ERROR-></b><br><b>CLASE:</b> covensol_cxc_cuentasxcobrar <br><b>METODO:</b> insertar_documentoInvalid query: ERROR:  duplicate key value violates unique constraint "cxc_documento_codemp_key"
DETAIL:  Key (codemp, codtipdoc, numdoc)=(0001, NC, 2083) already exists.
Whole query:   LOCK TABLE cxc_documento IN ACCESS EXCLUSIVE MODE;
					                SELECT reset_sequencia('cxc_documento','id_doc');
					                INSERT INTO cxc_documento(
											    codemp, codsuc, codcaj, codtipdoc, numdoc, coddoc, numcont_doc, id_fact, 
												estdoccxc,codmon_doc, tascam_doc, tipopecont, fecdoc, porcdesc_doc, montodesc_doc, 
												saldo_doc, subtot_doc, iva_doc, otros_doc, baseimp_doc, total_doc, 
												descripdoc, nummov_doc, numorddes_doc, procedoc, coduniadm, codestpro1, 
												codestpro2, codestpro3, codestpro4, codestpro5, estcla,formpagdoc, 
												id_fact_tercero, id_cliente_tercero,noafecdoc,noapllibven_doc,	
												
												fecreg, 
												usureg, horareg
										) 
										VALUES ('0001','0002','0002','NC','00002083','00002083','','492','P','USD','4123464.32','DEV','2021-09-09','0.00','0','0','1682736307.42','269237809.19','0','1682736307.42','1951974116.61','','','','CXCDOC','----------','-------------------------','-------------------------','-------------------------','-------------------------','-------------------------','-','APLDO','0','0','0','0','2021-09-09','ADMINISTRADOR','16:37'); ; SELECT lastval() AS valor_id; 

09/09/2021 16:40:22  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <br><b>ERROR-></b><br><b>CLASE:</b> covensol_cxc_cuentasxcobrar <br><b>METODO:</b> insertar_documentoInvalid query: ERROR:  duplicate key value violates unique constraint "cxc_documento_codemp_key"
DETAIL:  Key (codemp, codtipdoc, numdoc)=(0001, NC, 2083) already exists.
Whole query:   LOCK TABLE cxc_documento IN ACCESS EXCLUSIVE MODE;
					                SELECT reset_sequencia('cxc_documento','id_doc');
					                INSERT INTO cxc_documento(
											    codemp, codsuc, codcaj, codtipdoc, numdoc, coddoc, numcont_doc, id_fact, 
												estdoccxc,codmon_doc, tascam_doc, tipopecont, fecdoc, porcdesc_doc, montodesc_doc, 
												saldo_doc, subtot_doc, iva_doc, otros_doc, baseimp_doc, total_doc, 
												descripdoc, nummov_doc, numorddes_doc, procedoc, coduniadm, codestpro1, 
												codestpro2, codestpro3, codestpro4, codestpro5, estcla,formpagdoc, 
												id_fact_tercero, id_cliente_tercero,noafecdoc,noapllibven_doc,	
												
												fecreg, 
												usureg, horareg
										) 
										VALUES ('0001','0002','0002','NC','00002083','00002083','','492','P','USD','4123464.32','DEV','2021-09-09','0.00','0','0','1682736307.42','269237809.19','0','1682736307.42','1951974116.61','','','','CXCDOC','----------','-------------------------','-------------------------','-------------------------','-------------------------','-------------------------','-','APLDO','0','0','0','0','2021-09-09','ADMINISTRADOR','16:40'); ; SELECT lastval() AS valor_id;