J_1BNFE_ACTIVE - Electronic Nota Fiscal: Actual Status

Electronic Nota Fiscal: Actual Status information is stored in SAP table J_1BNFE_ACTIVE.
It is part of development package J1BA in software component FI-LOC-LO-BR. This development package consists of objects that can be grouped under "Localization Brazil".

Fields for table J_1BNFE_ACTIVE

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
DOCNUM	Document Number	X	J_1BDOCNUM	NUMC	20
DOCSTA	Document Status		J_1BNFEDOCSTATUS	CHAR	2
SCSSTA	System Communication Status		J_1BNFESCSSTATUS	CHAR	2
CONTING	Document Posted under Contingency		J_1BCONTINGENCY	CHAR	2
CANCEL	Canceled		J_1BCANCEL	CHAR	2
CODE	Official Status Code		J_1BSTATUSCODE	CHAR	6
REGIO	Region of Document Issuer		J_1BREGIO	CHAR	4
NFYEAR	Year of Document Date		J_1BYEAR	CHAR	4
NFMONTH	Month of Document Date		J_1BMONTH	CHAR	4
STCD1	CNPJ/CPF Number of Document Issuer		J_1BSTCD1	CHAR	28
MODEL	Model of Nota Fiscal		J_1BMODEL	NUMC	4
SERIE	Series		J_1BSERIES	CHAR	6
NFNUM9	Electronic Nota Fiscal Number		J_1BNFNUM9	CHAR	18
DOCNUM9	Random Number in Access Key		J_1BDOCNUM9	CHAR	18
CDV	Check Digit in Access Key		J_1BCHECKDIGIT	CHAR	2
AUTHCOD	Protocol Number		J_1BNFEAUTHCODE	CHAR	30
CREDAT	Create date		J_1BCREDAT	DATS	16
ACTION_DATE	Date of Change to Document		J_1BNFE_ACTION_DATE	DATS	16
ACTION_TIME	Time of Change to Document		J_1BNFE_ACTION_TIME	TIMS	12
ACTION_USER	User Who Made Change to Document		J_1BNFE_ACTION_USER	CHAR	24
BUKRS	Company Code		BUKRS	CHAR	8
BRANCH	Business Place		J_1BBRANC_	CHAR	8
VSTEL	Shipping Point / Receiving Point		VSTEL	CHAR	8
PARID	Partner ID (Customer, Vendor, Business Place)		J_1BPARID	CHAR	20
PARTYP	Nota Fiscal Partner Type		J_1BPARTYP	CHAR	2
DIRECT	Direction of the movement		J_1BDIRECT	CHAR	2
REFNUM	Number of Reference Document		J_1BNFE_REFNUM	NUMC	20
FORM	Form of Electronic Fiscal Document		J_1BFORM	CHAR	8
ACTION_REQU	Required Process Step		J_1BNFE_ACTION_REQUIRED	CHAR	2
PRINTD	Printed		J_1BPRINTD	CHAR	2
CONTING_S	Switched to Contingency		J_1BCONTINGENCY_NFE_SWITCHED	CHAR	2
MSSTAT	Status from Messaging System		J_1BNFE_MS_STATUS	CHAR	2
REASON	Reason for Cancellation/Skipping		J_1BNFE_CANCEL_REASON	CHAR	4	J_1BNFE_CANCELR
REASON1	Text for Cancellation/Skipping Reason		J_1BNFE_CANCEL_TEXT	CHAR	128
REASON2	Text for Cancellation/Skipping Reason		J_1BNFE_CANCEL_TEXT	CHAR	128
REASON3	Text for Cancellation/Skipping Reason		J_1BNFE_CANCEL_TEXT	CHAR	128
REASON4	Text for Cancellation/Skipping Reason		J_1BNFE_CANCEL_TEXT	CHAR	128
CRENAM	Name of the user		J_1BCRENAM	CHAR	24
CALLRFC	Control Doc. No. and RFC Execution to Messaging System		J_1BNFERFCCALL	CHAR	2
TPAMB	Type of Environment (Test or Production)		J_1BNFETPAMB	CHAR	2
SEFAZ_ACTIVE	SEFAZ Server is Active		J_1BNFE_SEFAZ_ACTIVE	CHAR	2
SCAN_ACTIVE	SCAN Server is Active		J_1BNFE_SCAN_ACTIVE	CHAR	2
CHECKTMPL	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)		TIMESTAMPL	DEC	11
AUTHDATE	Processing Timestamp - Date		J_1BAUTHDATE	DATS	16
AUTHTIME	Processing Timestamp - Time		J_1BAUTHTIME	TIMS	12
TPEMIS	Issuing Type		J_1BNFE_TPEMIS	CHAR	2
REASON_CONTING	Reason for Contingency		J_1BNFE_CONTINGENCY_REASON	CHAR	4	J_1BNFE_CONTINR
REASON_CONTING1	Text for Contingency Reason		J_1BNFE_CONTINGENCY_TEXT	CHAR	128
REASON_CONTING2	Text for Contingency Reason		J_1BNFE_CONTINGENCY_TEXT	CHAR	128
REASON_CONTING3	Text for Contingency Reason		J_1BNFE_CONTINGENCY_TEXT	CHAR	128
REASON_CONTING4	Text for Contingency Reason		J_1BNFE_CONTINGENCY_TEXT	CHAR	128
CONTING_DATE	Contingency Date		J_1BNFE_CONTINGENCY_DATE	DATS	16
CONTING_TIME	Contingency Time		J_1BNFE_CONTINGENCY_TIME	TIMS	12
CONTIN_TIME_ZONE	Time Zone		TZNZONE	CHAR	12
CANCEL_ALLOWED	Cancellation Allowed by Authorities		J_1BNFE_CANCEL_ALLOWED	CHAR	2
SOURCE	Source of Entry		J_1BNFE_SOURCE	CHAR	2
CANCEL_PA	Cancel Prior to Authorization		J_1BNFE_CANCEL_PA	CHAR	2
EVENT_FLAG	Checkbox		XFELD	CHAR	2
ACTIVE_SERVICE	Active Service of Tax Authorities		J_1BNFE_ACTIVE_SERVICE	CHAR	4
SVC_SP_ACTIVE	SVC SP Contingency Active		J_1BNFE_SVCSP_ACTIVE	CHAR	2
SVC_RS_ACTIVE	SVC RS Contingency Active		J_1BNFE_SVCRS_ACTIVE	CHAR	2
SVC_ACTIVE	Contingency SVC Active		J_1BNFE_SVC_ACTIVE	CHAR	2
.INCLUDE				J_1BNFSE_IDENTIFICATION	0
RPS	Provisory Service Receipt (RPS)		J_1B_PROVISORY_SERVICE_RECEIPT	NUMC	12
NFSE_NUMBER	Service NF-e Number		J_1BPREFNO	CHAR	40
NFSE_CHECK_CODE	Verification Code of Service NF-e		J_1BCHECOD	CHAR	40
CODE_DESCRIPTION	Official Status Code Description		J_1BNFE_CODE_DESCRIPTION	CHAR	510
CMSG	SEFAZ Message Code		J_1BNFE_CMSG	CHAR	8
XMSG	SEFAZ Message Description		J_1BNFE_XMSG	CHAR	400
CLOUD_GUID	Document Universal Unique Identifier (UUID)		NFE_DOCUMENT_UUID	CHAR	72
CLOUD_EXTENS_FLAG	Extension values		NFE_EXTENS_FLAG	CHAR	2
REPLACEMENT_STATUS	NFS-e: Replacement Status		NFE_REPLACEMENT_STATUS	CHAR	2
CLOUD_LOG_STATUS	Cloud Log Status		NFE_CLOUD_LOG_STATUS	CHAR	2