I_BR_NFDocument

Brazil Nota Fiscal Document Data | view: IBRNFDOCUMENT | Extraction: Not supported | Component: Logistics Brazil
Tables used: J_1BNFDOCJ_1BNFNADT001TKA02KNA1LFA1
Column Name Description
BR_NotaFiscal Document Number
Column Name Description
💲 SD Document Currency (SalesDocumentCurrency):
BR_NFTotalAmount Total value including all taxes
BR_NFWithholdingAmount Withholding Amount
BR_CTeTotalGoodsAmount Total Amount of Goods
Column Name Description
📏 Weight Unit (HeaderWeightUnit):
HeaderNetWeight Net Weight
HeaderGrossWeight Gross Weight
Column Name Description
ReportingIncgOrOutgDate TMF Reporting Date
BR_NFArrivalOrDepartureDate Goods Departure or Arrival Date
BR_NFArrivalOrDepartureTime Departure/Arrival Time
CreationDate Document Creation Date
CreationTime Document Creation Time
LastChangeDate Date when document was changed
LastChangeTime Time when the document was last changed
BR_NFAuthenticationDate Processing Date
BR_NFAuthenticationTime Processing Time
BR_NFPostingDate Posting Date
BR_NFIssueDate Document Date
BR_NFCancellationDate Cancellation Date
BR_CTeEstimatedDeliveryDate Estimated Delivery Date
Column Name Description
PartnerIsOneTimeAccount Indicator: Is the account a one-time account? Show values
BR_NFPartnerType Type Show values
BR_NFPartnerIsNaturalPerson Natural Person Show values
BR_NFPartnerTaxRegimenCode Tax Regimen Code (CRT) of Partner Show values
BR_PartnerCFOPCategory Customer's CFOP category Show values
BR_SPEDTaxCategory Tax Category Show values
BR_NFIsPrinted Nota Fiscal Was Printed Show values
BR_NFIsCreatedManually Manually Created Show values
BR_NFIsIncomingIssdByCust Nota Fiscal Entrada Show values
BR_NFIsCanceled Nota Fiscal Cancelled Show values
BR_NFIsChargingInvoice NF is a fatura Show values
BR_NFDirection Movement Direction Show values
BR_NFModel Nota Fiscal Model Show values
BR_NFSituationCode Status Code of Fiscal Document Show values
BR_NFIssuedBy Nota Fiscal Issued By Show values
BR_NFIsContingency Contingency Indicator for Nota Fiscal Show values
BR_NFeDocumentStatus Document Status Show values
BR_NFIsFinalConsumer NF-e Final Consumer Identification Show values
BR_NFeCustomerPresence Customer Presence Show values
BR_NFeDestination Destination Show values
BusinessPlaceTaxRegimenCode Business Place CRT Show values
BR_PaymentForm Payment Form Indicator Show values
FreightPayer Freight Mode Show values
BR_NFIsMunicipal Municipal Fiscal Document Show values
BR_IsNFe Electronic Fiscal Document Show values
BR_NFHasFollowOnDocument Follow-On Document Show values
BR_NFPartnerPlaceType Nota Fiscal Partner Place Type Show values
BR_NFFiscalCouponDocModel Fiscal Coupon Document Model Show values
BR_NFIsCalculatedByTaxService Tax Calculated by Tax Service Show values
BR_NFeIntermediatorTransaction Intermediator Indicator Show values
BR_CTeDocumentType CT-e Type Show values
BR_CTePartnerServiceTaker CT-e Partner as Service Taker Show values
BR_CTeFiscalDocumentPartner CT-e Partner in Fiscal Document Show values
BR_CTeServiceType Service Type Indicator Show values
BR_CTeTransportationMode Transportation Mode Show values
BR_CTeIsTruckFullyLoaded Full Truck Load Indicator Show values
BR_NFHasServiceItem Service NF/NF-e Show values
Column Name Description Domain name
BR_NFPartner Partner ID (Customer, Vendor, Business Place) J_1BPARID
BR_NFPartnerName1 Name 1 NAME
BR_NFPartnerName2 Name 2 NAME
BR_NFPartnerName3 Name 3 NAME
BR_NFPartnerName4 Name 4 NAME
BR_NFPartnerStreetName Street and House Number TEXT35
BusinessPartnerHouseNumber House Number TEXT10
BPHsNmbrSuplmntTxt House number supplement TEXT10
BR_NFPartnerCityName City TEXT35
BR_NFPartnerDistrictName District TEXT35
BR_NFPartnerPostalCode Postal Code PSTLZ
BR_NFPartnerCNPJ CNPJ Number LOGBR_CNPJ
BR_NFPartnerCPF CPF number LOGBR_CPF
PhoneNumber Addresses: telephone no. TEXT30
BR_NFPartnerStateTaxNumber State Tax Number J_1BSTAINS
BR_NFPartnerMunicipalTaxNumber Municipal Tax Number J_1BMUNINS
BR_NFPartnerStateTaxNumberST State Tax Number of Partner (SubTrib) J_1BSTAINS
BR_SUFRAMACode SUFRAMA Subscription of Partner J_1BSUFRAMA
BR_NFObservationText Legal Books Mod. 1 + 2: Header text for observations column J_1BLBOBS
MeansOfTransport Transport ID TRAID
IncotermsTransferLocation Incoterms (Part 2) INCO2
BR_NFShippingUnitBrand Shipping Unit Mark TEXT20
BR_NFShippingUnitNumber Shipping Unit Number TEXT20
BR_NFNumberOfPackages Number of Packages ANZPK
BR_WhldgICMSForTranspCFOP CFOP of ICMS Withholding for Transportation LOGBR_CFOPCODE
BR_WhldgICMSForTranspCity City Code
CreatedByUser User who created the document USNAM
LogicalSystem Logical System LOGSYS
LastChangedByUser User who last changed the document USNAM
PaymentTerms Terms of Payment Key ZTERM
BR_NFNumber Nota Fiscal Number J_1BNFNUMB
BR_NFSeries Nota Fiscal Series J_1BSERIES
BR_NFSubSeries Sub series J_1BSUBSER
BR_NFAuthznProtocolNumber Protocol Number J_1BNFEAUTHCODE
BR_NFeXMLVersion XML Version J_1BNFEXMLVERSION
SupplierInvoice Invoice Number CHAR20
BR_NFOriginalAmount Invoice Original Amount DECV15_2
BR_NFDiscountAmount Invoice Discount Amount DECV15_2
BR_NFNetAmount Invoice Net Amount DECV15_2
BR_NFCommitmentNote Commitment Note CHAR22
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_BusinessPlaceCNPJ Business Place CNPJ LOGBR_CNPJ
BusinessPlaceStateTaxNumber State Tax Number J_1BSTAINS
BR_BusPlaceStateTaxNumberST State Tax Number (ST) J_1BSTAINS
BusPlaceMunicipalTaxNumber Municipal Tax Number J_1BMUNINS
AccountingDocument Accounting Document BELNR
BR_NFFiscalYear Fiscal Year GJAHR
BR_ANTTCarrierRegistration Cargo Carrier ID CHAR20
BR_NFeNumber Nine-Digit Number
WagonID Wagon ID CHAR20
FerryBoatID Ferryboat ID CHAR20
BR_NFExportShipmentPlace Shipment Place (Export) CHAR60
BR_NFExportDispatchLocation Dispatch Location J_1BNFE_DISPATCH
BR_NFOperationTypeDesc Operation Type TEXT60
BR_NFReferenceDocument null
LicensePlate Vehicle License Plate CHAR7
BR_UtilsNFNumber Number for Non-Electronic Documents
ChangeAmount Change Amount DECV15_2
BR_NFOperationOrderNumber Operation Order Counter Number J_1BNFE_NCOO
BR_NFPartnerForeignIdn Foreign Identification J_1BNFE_FOREIGNID
BR_NFeIntermediatorRegistry Intermediator Identification Registry CHAR60
BR_NFeIntermediatorCNPJ CNPJ of the Intermediator LOGBR_CNPJ
BR_CTeMainProductTransported Main Product LOGBR_CHAR60
BR_NFSVerificationCode Verification Code J_1BCHECOD
BR_NFSNumber Service NF-e Number J_1BPREFNO
IsBusinessPurposeCompleted null
BR_NFPartnerAuthorizationGroup Authorization Group BRGRU
CompanyCodeName Name of Company Code or Company TEXT25
Master Data Relations Join Conditions
Jurisdiction Code of the Final Destination
  • ?
  • Client
  • Jurisdiction Code of the Final Destination
  • I_BR_NFDOCUMENT.[column in domain "LAND1"] == J_1BTXJUR.COUNTRY
  • I_BR_NFDOCUMENT.MANDT == J_1BTXJUR.CLIENT
  • I_BR_NFDOCUMENT.BR_CTEJURISDICTIONCODEDEST == J_1BTXJUR.TAXJURCODE
Jurisdiction Code of the Point of Origin
  • ?
  • Client
  • Jurisdiction Code of the Point of Origin
  • I_BR_NFDOCUMENT.[column in domain "LAND1"] == J_1BTXJUR.COUNTRY
  • I_BR_NFDOCUMENT.MANDT == J_1BTXJUR.CLIENT
  • I_BR_NFDOCUMENT.BR_CTEJURISDICTIONCODEORIGIN == J_1BTXJUR.TAXJURCODE
Document Type
  • Document Type
  • Client
Shipment Region
  • ?
  • Client
  • Shipment Region
  • I_BR_NFDOCUMENT.[column in domain "LAND1"] == T005S.LAND1
  • I_BR_NFDOCUMENT.MANDT == T005S.MANDT
  • I_BR_NFDOCUMENT.BR_NFEXPORTSHIPMENTREGION == T005S.BLAND
Country/Region Key
  • Country/Region Key
  • Client
  • I_BR_NFDOCUMENT.BR_NFPARTNERCOUNTRYCODE == T005.LAND1
  • I_BR_NFDOCUMENT.MANDT == T005.MANDT
Nota Fiscal Partner Function
  • Client
  • Nota Fiscal Partner Function
  • I_BR_NFDOCUMENT.MANDT == J_1BAD.MANDT
  • I_BR_NFDOCUMENT.BR_NFPARTNERFUNCTION == J_1BAD.PARVW
Region (State, Province, County)
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • I_BR_NFDOCUMENT.BR_NFPARTNERCOUNTRYCODE == T005S.LAND1
  • I_BR_NFDOCUMENT.MANDT == T005S.MANDT
  • I_BR_NFDOCUMENT.BR_NFPARTNERREGIONCODE == T005S.BLAND
Tax Jurisdiction
  • ?
  • Tax Jurisdiction
  • Client
  • I_BR_NFDOCUMENT.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • I_BR_NFDOCUMENT.BR_NFPARTNERTAXJURISDICTION == TTXJ.TXJCD
  • I_BR_NFDOCUMENT.MANDT == TTXJ.MANDT
Shipping Unit
  • Shipping Unit
  • Client
  • I_BR_NFDOCUMENT.BR_NFSHIPPINGUNIT == T006.MSEHI
  • I_BR_NFDOCUMENT.MANDT == T006.MANDT
Nota Fiscal Type
  • Client
  • Nota Fiscal Type
  • I_BR_NFDOCUMENT.MANDT == J_1BAA.MANDT
  • I_BR_NFDOCUMENT.BR_NFTYPE == J_1BAA.NFTYPE
Company Code
  • Company Code
  • Client
  • I_BR_NFDOCUMENT.COMPANYCODE == T001.BUKRS
  • I_BR_NFDOCUMENT.MANDT == T001.MANDT
Weight Unit
  • Weight Unit
  • Client
  • I_BR_NFDOCUMENT.HEADERWEIGHTUNIT == T006.MSEHI
  • I_BR_NFDOCUMENT.MANDT == T006.MANDT
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • I_BR_NFDOCUMENT.MANDT == TINC.MANDT
  • I_BR_NFDOCUMENT.INCOTERMSCLASSIFICATION == TINC.INCO1
Means of Transport
  • Client
  • Means of Transport
  • I_BR_NFDOCUMENT.MANDT == TVTY.MANDT
  • I_BR_NFDOCUMENT.MEANSOFTRANSPORTTYPE == TVTY.TRATY
SD Document Currency
  • SD Document Currency
  • Client
  • I_BR_NFDOCUMENT.SALESDOCUMENTCURRENCY == TCURC.WAERS
  • I_BR_NFDOCUMENT.MANDT == TCURC.MANDT
Foreign Key for Shipping Point
  • Client
  • Shipping Point / Receiving Point
  • I_BR_NFDOCUMENT.MANDT == TVST.MANDT
  • I_BR_NFDOCUMENT.SHIPPINGPOINT == TVST.VSTEL
Region of Vehicle
  • ?
  • Client
  • Region of Vehicle
  • I_BR_NFDOCUMENT.[column in domain "LAND1"] == T005S.LAND1
  • I_BR_NFDOCUMENT.MANDT == T005S.MANDT
  • I_BR_NFDOCUMENT.VEHICLEREGION == T005S.BLAND