C_BR_VerifyNotaFiscal

Brazil Verify Nota Fiscal | view: CBRVERIFYNF | Extraction: Not supported | Component: Logistics Brazil
Tables used: J_1BNFDOC, J_1BNFE_ACTIVE, J_1BNFEPHARMA, LOGBR_NF_DUE, J_1BNFE_EXPORT, J_1BNFFUEL, J_1BNFLIN, J_1BNFNAD, J_1BNFSTX, J_1BNFVEHICLE, EKBE, VBFA, J_1BNFE_TEC_RESP, AFKO, AFVC, AFVU, AFVV, JEST, PRTE, ADCP, ADRC, ADR6, J_1BBRANCH, J_1BTCENQT, J_1BTCESTT, J_1BAGNT, TKA02, CSKT, CKPHT, J_1BITEMTYPEST, T604N, J_1BAAT, AUFK, J_1BADT, T001W, J_1BABT, J_1BATL4T, J_1BATL1T, J_1BATL2T, J_1BATL3T, J_1BATL5T, J_1BTAXSITCOFT, J_1BAST, J_1BTAXSITISST, J_1BTAXSITPIST, J_1BAJ, J_1BAJT, T001, TKA02, KNA1, AUFK, AUFK, T430, T001W, CEPC, CEPCT, PROJ, PROJ, CNLDST_SHORTTX, T024, T024E, T005U, FAGL_SEGMT, LFA1, PRPS, PRPS, CRHD
Column Name Description
BR_NotaFiscal Document Number
Column Name Description
💲 SD Document Currency (SalesDocumentCurrency):
BR_NFWithholdingAmount Withholding Amount
Column Name Description
📏 Weight Unit (HeaderWeightUnit):
HeaderNetWeight Net Weight
HeaderGrossWeight Gross Weight
Column Name Description
BR_NFIssueDate Document Date
BR_NFPostingDate Posting Date
BR_NFAuthenticationDate Processing Date
BR_NFAuthenticationTime Processing Time
CreationDate Document Creation Date
CreationTime Document Creation Time
LastChangeDate Date when document was changed
LastChangeTime Time when the document was last changed
BR_NFArrivalOrDepartureDate Goods Departure or Arrival Date
BR_NFArrivalOrDepartureTime Departure/Arrival Time
BR_DUEIssuedDate Export Declaration Issued Date
BR_BillOfLadingDate Bill of Lading Date
BR_DUEExportConfirmationDate Export Confirmation Date
Column Name Description
BR_NFIssuerType Issuer Type Show values
BR_NFIssuerTaxRegimenCode Issuer Código de Regime Tributário Show values
BR_NFReceiverType Receiver Type Show values
FreightPayer Freight Mode Show values
BR_NFDirection Movement Direction Show values
BR_NFHasFollowOnDocument Follow-On Document Show values
BR_NFeDocumentStatus Document Status Show values
BR_NFModel Nota Fiscal Model Show values
BR_IsNFe Electronic Fiscal Document Show values
BR_NFHasServiceItem Service NF/NF-e Show values
BR_NFeModel Nota Fiscal Model Show values
IssuingType Issuing Type Show values
BR_NFIsContingency Contingency Indicator for Nota Fiscal Show values
BR_NFIsFinalConsumer Final Consumer Show values
BR_NFeCustomerPresence Customer Presence Show values
BR_NFeDestination Destination Show values
BR_NFeIntermediatorTransaction Intermediator Indicator Show values
BR_NFIsPrinted Nota Fiscal Was Printed Show values
BR_NFIsCreatedManually Manually Created Show values
BR_NFIsChargingInvoice NF is a fatura Show values
BR_NFIsCanceled Nota Fiscal Cancelled Show values
BR_NFIssuedBy Nota Fiscal Issued By Show values
BR_NFIsCalculatedByTaxService Tax Calculated by Tax Service Show values
BR_NFFiscalCouponDocModel Fiscal Coupon Document Model Show values
BR_PaymentForm Payment Form Indicator Show values
BR_DUEType Export Declaration Type Show values
BR_BillOfLadingType Bill of Lading Type Show values
Column Name Description Domain name
BR_NFIssuerNameFrmtdDesc Issuer Name LOGBR_CHAR60
BR_NFIssuerCNPJOrCPF Nota Fiscal Issuer CNPJ/CPF CHAR18
BR_NFIssuerStateTaxNumber State Tax Number
BR_NFIssuerMunicipalTaxNumber Municipal Tax Number J_1BMUNINS
BR_NFIssuerStateTaxNumberST State Tax Number (Substituição Tributária)
BR_NFIssuerCNAE NF Issuer Classificação Nacional de Atividades Econômicas CHAR7
BR_NFIssuerStreetName Street and House Number TEXT80
BR_NFIssuerDistrict District TEXT40
BR_NFIssuerPostalCode Postal Code CHAR10
BR_NFIssuerCityRegionFrmtdDesc Nota Fiscal City / Region LOGBR_CHAR80
BR_NFIssuerPhoneNumber Telephone Number TEXT30
BR_NFReceiverNameFrmtdDesc Receiver Name LOGBR_CHAR60
BR_NFReceiverCNPJ Receiver CNPJ CHAR60
BR_NFReceiverStateTaxNumber State Tax Number
BR_NFReceiverMunicipalTaxNmbr Municipal Tax Number J_1BMUNINS
BR_NFReceiverStateSTTaxNumber State Tax Number (Substituição Tributária)
BR_NFReceiverCNAE Receiver Classificação Nacional de Atividades Econômicas CHAR7
BR_NFReceiverTaxRegimenCode Receiver Código de Regime Tributário CHAR7
BR_NFReceiverForeignIdn Receiver Foreign Identification J_1BNFE_FOREIGNID
BR_NFReceiverStreetName Street and House Number TEXT80
BR_NFReceiverDistrict District TEXT40
BR_NFReceiverPostalCode Postal Code CHAR10
BR_NFReceiverCityRgnFrmtdDesc Nota Fiscal City / Region LOGBR_CHAR80
BR_NFReceiverPhoneNumber Telephone Number TEXT30
SupplierInvoiceWthnFiscalYear Invoice Number CHAR20
BR_NFOverviewNetAmount Invoice Net Amount DECV15_2
BR_NFOverviewOriginalAmount Invoice Original Amount DECV15_2
NFOverviewDiscountAmount Invoice Discount Amount DECV15_2
BR_ICMSBaseTotalAmount ICMS Base DECV15_2
BR_ICMSTaxTotalAmount ICMS Amount DECV15_2
BR_ICMSSTBaseTotalAmount ICMS ST Base Amount DECV15_2
BR_ICMSSTTaxTotalAmount ICMS ST Amount DECV15_2
BR_ICMSOriginTaxAmount ICMS Origin DECV15_2
BR_ICMSDestinationTaxAmount ICMS Destination DECV15_2
BR_FCPOnICMSTaxBaseAmount ICMS FCP Base DECV15_2
BR_FCPOnICMSTaxAmount ICMS FCP Amount DECV15_2
BR_FCPOnICMSSTTaxBaseAmount ICMS ST FCP Base DECV15_2
BR_FCPOnICMSSTTaxAmount ICMS ST FCP Amount DECV15_2
BR_IPITaxTotalAmount IPI Amount DECV15_2
BR_NFFreightNetTotalAmount Freight Amount DECV15_2
BR_NFNetInsuranceTotalAmount Insurance Amount DECV15_2
BR_NFNetOthExpensesTotalAmount Other Expenses Amount DECV15_2
BR_NFNetPriceTotalAmount Total Product Amount DECV15_2
BR_NFNetDiscountTotalAmount Net Discount Amount DECV15_2
BR_NFTotalAmount Nota Fiscal Total Amount DECV15_2
BR_ExemptedICMSTotalAmount Exempt ICMS Amount DECV15_2
BR_NFPartnerNameFrmtdDesc Name LOGBR_CHAR60
BR_NFPartnerStreetName Street and House Number TEXT35
BR_NFPartnerCityName City TEXT35
BR_NFPartnerRegistrationFrmtd Transporter CPF / CNPJ CHAR60
BR_NFPartnerStateTaxNumber State Tax Number J_1BSTAINS
LicensePlate Vehicle License Plate CHAR7
BR_NFTransptRgnCodeFrmtdDesc Region CHAR64
BR_ANTTCarrierRegistration Cargo Carrier ID CHAR20
BR_NFeAccessKey Access Key
BR_NFOperationTypeDesc Operation Type TEXT60
BR_NFReferenceDocument Reference Document CHAR73
BR_NFHeaderTotalAmount Nota Fiscal Total Amount DECV15_2
BR_NFNumber Number for Non-Electronic Documents
BR_NFHeaderAuthznProtocolNmbr Protocol Number J_1BNFEAUTHCODE
BR_NFTitle null
Region Region of Document Issuer J_1BREGIO
BR_NFeIssueYear Year J_1BYEAR
BR_NFeIssueMonth Month of Document Date J_1BMONTH
BR_NFeAccessKeyCNPJOrCPF Access Key CNPJ/CPF
BR_NFeSeries Nota Fiscal Series J_1BSERIES
BR_NFeNumber NF-e Number
BR_NFeRandomNumber Random Number J_1BDOCNUM8
BR_NFeCheckDigit Check Digit J_1BCHECKDIGIT
BR_NFAuthznProtocolNumber Protocol Number J_1BNFEAUTHCODE
BR_NFeXMLVersion XML Version J_1BNFEXMLVERSION
BR_NFeIntermediatorRegistry Intermediator Identification Registry CHAR60
BR_NFeIntermediatorCNPJ CNPJ of the Intermediator LOGBR_CNPJ
CreatedByUser User who created the document USNAM
LogicalSystem Logical System LOGSYS
BR_NFTypeFormattedDesc Nota Fiscal Type Description CHAR65
BR_NFSeries Nota Fiscal Series J_1BSERIES
BR_NFSubSeries Sub series J_1BSUBSER
LastChangedByUser User who last changed the document USNAM
MeansOfTransport Transport ID TRAID
Incoterms Incoterms CHAR60
BR_NFShippingUnitBrand Shipping Unit Mark TEXT20
BR_NFNumberOfPackages Number of Packages ANZPK
BR_NFShippingUnitNumber Shipping Unit Number TEXT20
WagonID Wagon ID CHAR20
FerryBoatID Ferryboat ID CHAR20
BR_WhldgICMSForTranspCFOP CFOP of ICMS Withholding for Transportation LOGBR_CFOPCODE
BR_WhldgICMSForTranspCity City Code
BR_NFExportShipmentPlace Shipment Place (Export) CHAR60
BR_NFExportDispatchLocation Dispatch Location J_1BNFE_DISPATCH
BR_NFCommitmentNote Commitment Note CHAR22
OriginReferenceDocument Sales Order / Purchase Order CHAR15
PredecessorReferenceDocument Outbound Delivery / Goods Receipt CHAR10
ReferenceDocument Billing / Invoice Receipt CHAR35
BR_NFOperationOrderNumber Operation Order Counter Number J_1BNFE_NCOO
AccountingDocument Accounting Document BELNR
BR_NFFiscalYear Fiscal Year GJAHR
PaymentTerms Terms of Payment Key ZTERM
ChangeAmount Change Amount DECV15_2
SupplierInvoice Invoice Number CHAR20
BR_NFNetAmount Invoice Net Amount DECV15_2
BR_NFOriginalAmount Invoice Original Amount DECV15_2
BR_NFDiscountAmount Invoice Discount Amount DECV15_2
SugarcaneHarvest Harvest ID CHAR9
SugarcaneRefMonthYear Reference Month/Year CHAR7
SugarcaneCurrentMonthQty Current Month Amount DECV15_3
SugarcaneLastMnthQuantity Last Month Amount DECV15_3
SugarcaneSumBothMonthsQty Sum of Both Months DECV15_3
SugarcaneSuppliesAmount Supplies Amount DECV15_2
SugarcaneTotalDeductionAmount Total Deduction DECV15_2
SugarcaneSuppliesNetAmt Supplies Net Amount DECV15_2
BR_TechnicalResponsibleCNPJ Technical Responsible CNPJ CHAR18
BR_TechnicalRespContactName Contact Name J_1BNFE_CONTACT
BR_TechnicalResponsibleEmail E-mail J_1BNFE_EMAIL
BR_TechResponsiblePhoneNumber Phone J_1BNFE_PHONE
BR_SecureCodeTechRespID Secure Code Identifier J_1BNFE_IDCSRT
BR_SecureCodeTechnicalRespHash Secure Code J_1BNFE_CSRT
BR_DUE Export Declaration Number CHAR14
BR_BillOfLading Bill of Lading Number LOGBR_BILL_LADING_NUMBER
CompanyCodeName Name of Company Code or Company TEXT25
IsBusinessPurposeCompleted null
BR_CFOPItemOperationCode null
Master Data Relations Join Conditions
Document Type
  • Document Type
  • Client
Shipment Region
  • Shipment Region
  • Client
  • ?
  • C_BR_VERIFYNOTAFISCAL.BR_NFEXPORTSHIPMENTREGION == T005S.BLAND
  • C_BR_VERIFYNOTAFISCAL.MANDT == T005S.MANDT
  • C_BR_VERIFYNOTAFISCAL.[column in domain "LAND1"] == T005S.LAND1
Region (State, Province, County)
  • ?
  • Client
  • Region (State, Province, County)
  • Region of Document Issuer
  • C_BR_VERIFYNOTAFISCAL.[column in domain "LAND1"] == T005S.LAND1
  • C_BR_VERIFYNOTAFISCAL.MANDT == T005S.MANDT
  • C_BR_VERIFYNOTAFISCAL.BR_NFPARTNERREGIONCODE == T005S.BLAND
  • C_BR_VERIFYNOTAFISCAL.REGION == T005S.BLAND
Shipping Unit
  • Shipping Unit
  • Client
  • C_BR_VERIFYNOTAFISCAL.BR_NFSHIPPINGUNITCONVERTED == T006.MSEHI
  • C_BR_VERIFYNOTAFISCAL.MANDT == T006.MANDT
Nota Fiscal Type
  • Client
  • Nota Fiscal Type
  • C_BR_VERIFYNOTAFISCAL.MANDT == J_1BAA.MANDT
  • C_BR_VERIFYNOTAFISCAL.BR_NFTYPE == J_1BAA.NFTYPE
Company Code
  • Company Code
  • Client
  • C_BR_VERIFYNOTAFISCAL.COMPANYCODE == T001.BUKRS
  • C_BR_VERIFYNOTAFISCAL.MANDT == T001.MANDT
Weight Unit
  • Weight Unit
  • Client
  • C_BR_VERIFYNOTAFISCAL.HEADERWEIGHTUNIT == T006.MSEHI
  • C_BR_VERIFYNOTAFISCAL.MANDT == T006.MANDT
Means of Transport
  • Means of Transport
  • Client
  • C_BR_VERIFYNOTAFISCAL.MEANSOFTRANSPORTTYPE == TVTY.TRATY
  • C_BR_VERIFYNOTAFISCAL.MANDT == TVTY.MANDT
SD Document Currency
  • SD Document Currency
  • Client
  • C_BR_VERIFYNOTAFISCAL.SALESDOCUMENTCURRENCY == TCURC.WAERS
  • C_BR_VERIFYNOTAFISCAL.MANDT == TCURC.MANDT
Foreign Key for Shipping Point
  • Shipping Point / Receiving Point
  • Client
  • C_BR_VERIFYNOTAFISCAL.SHIPPINGPOINT == TVST.VSTEL
  • C_BR_VERIFYNOTAFISCAL.MANDT == TVST.MANDT