mht_brerp10
.adempiere
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
cof_evaluatenfstatus(character varying, character varying, character varying)
Parameters
Name
Type
Mode
nfestatus
character varying
IN
returntrue
character varying
IN
returnfalse
character varying
IN
Definition
DECLARE STATUS_RET CHARACTER VARYING; BEGIN BEGIN -- 101: Canceladas - 102: Inutilizadas - 135: Evento Vinculado - 202: Rejeição: Falha Arquivo XML IF(nfeStatus IS NULL OR nfeStatus = '') THEN STATUS_RET = returnFalse; END IF; IF (nfeStatus IN ('101', '102', '135', '155','302')) THEN STATUS_RET = returnFalse; ELSE STATUS_RET = returnTrue; END IF; EXCEPTION WHEN NO_DATA_FOUND THEN STATUS_RET := returnFalse; END; RETURN STATUS_RET; END;