I_BR_NFBrief_C

Brazil Nota Fiscal Brief | view: IBRNFBRIEFC | Extraction: Not supported | Component: Logistics Brazil
Column Name Description
BR_NotaFiscal Document Number
Column Name Description
Column Name Description
HeaderGrossWeight Gross Weight
HeaderNetWeight Net Weight
Column Name Description
BR_NFPostingDate Posting Date
BR_NFArrivalOrDepartureDate Goods Departure or Arrival Date
BR_NFArrivalOrDepartureTime Departure/Arrival Time
BR_NFIssueDate Document Date
Column Name Description
BR_NFFiscalCouponDocModel Fiscal Coupon Document Model Show values
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_IsNFe Electronic Fiscal Document Show values
BR_NFHasServiceItem Service NF/NF-e Show values
BR_NFHasFollowOnDocument Follow-On Document Show values
BR_NFModel Nota Fiscal Model Show values
BR_NFeIntermediatorTransaction Intermediator Indicator Show values
Column Name Description Domain name
BR_NFNumber Nota Fiscal Number J_1BNFNUMB
BR_UtilsNFNumber Number for Non-Electronic Documents
BR_NFSeries Nota Fiscal Series J_1BSERIES
BR_NFSubSeries Sub series J_1BSUBSER
BR_NFOperationOrderNumber Operation Order Counter Number J_1BNFE_NCOO
BR_NFIssuerName Issuer Name LOGBR_CHAR60
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_NFIssuerPhoneNumber Telephone Number TEXT30
BR_NFIssuerStreetName Street and House Number TEXT80
BR_NFIssuerDistrict District TEXT40
BR_NFIssuerCityRegionFrmtdDesc Nota Fiscal City / Region LOGBR_CHAR80
BR_NFIssuerPostalCode Postal Code CHAR10
BR_NFReceiverName Name 1 NAME
BR_NFReceiverNameFrmtdDesc Receiver Name LOGBR_CHAR60
BR_NFReceiverStreetName Street and House Number TEXT80
BR_NFReceiverCityRgnFrmtdDesc Nota Fiscal City / Region LOGBR_CHAR80
BR_NFReceiverDistrict District TEXT40
BR_NFReceiverCNPJ Receiver CNPJ CHAR60
BR_NFReceiverForeignIdn Receiver Foreign Identification J_1BNFE_FOREIGNID
BR_NFReceiverPostalCode Postal Code CHAR10
BR_NFReceiverPhoneNumber Telephone Number TEXT30
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
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_ICMSBaseTotalAmount ICMS Base DECV15_2
BR_ICMSSTBaseTotalAmount ICMS ST Base Amount DECV15_2
BR_ICMSTaxTotalAmount ICMS Amount DECV15_2
BR_ICMSSTTaxTotalAmount ICMS ST Amount DECV15_2
BR_NFFreightNetTotalAmount Freight Amount DECV15_2
BR_NFNetInsuranceTotalAmount Insurance Amount DECV15_2
BR_NFNetOthExpensesTotalAmount Other Expenses Amount DECV15_2
BR_IPITaxTotalAmount IPI Amount DECV15_2
BR_NFNetPriceTotalAmount Total Product Amount DECV15_2
BR_NFTotalAmount Nota Fiscal Total Amount DECV15_2
BR_NFNetDiscountTotalAmount Net Discount Amount DECV15_2
BR_ExemptedICMSTotalAmount Exempt ICMS Amount DECV15_2
BR_ICMSOriginTaxAmount ICMS Origin DECV15_2
BR_ICMSDestinationTaxAmount ICMS Destination DECV15_2
BR_FCPOnICMSTaxAmount ICMS FCP Amount DECV15_2
BR_FCPOnICMSTaxBaseAmount ICMS FCP Base DECV15_2
BR_FCPOnICMSSTTaxBaseAmount ICMS ST FCP Base DECV15_2
BR_FCPOnICMSSTTaxAmount ICMS ST FCP Amount DECV15_2
ChangeAmount Change Amount DECV15_2
BR_NFPartnerNameFrmtdDesc Name LOGBR_CHAR60
BR_NFPartnerStreetName Street and House Number TEXT35
BR_NFPartnerCityName City TEXT35
RegionName Description TEXT20
BR_NFPartnerRegistrationFrmtd Transporter CPF / CNPJ CHAR60
LicensePlate Vehicle License Plate CHAR7
BR_ANTTCarrierRegistration Cargo Carrier ID CHAR20
BR_NFPartnerStateTaxNumber State Tax Number J_1BSTAINS
BR_NFeNumber Nine-Digit Number
BR_NFOperationTypeDesc Operation Type TEXT60
BR_NFReferenceDocument null
BR_NFHasReferenceDocument null
IsBusinessPurposeCompleted null
BR_NFeIntermediatorRegistry Intermediator Identification Registry CHAR60
BR_NFeIntermediatorCNPJ CNPJ of the Intermediator LOGBR_CNPJ
Master Data Relations Join Conditions
Document Type
  • Document Type
  • Client
Country/Region Key
  • Client
  • Country/Region Key
  • I_BR_NFBRIEF_C.MANDT == T005.MANDT
  • I_BR_NFBRIEF_C.BR_NFPARTNERCOUNTRYCODE == T005.LAND1
Region (State, Province, County)
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • I_BR_NFBRIEF_C.MANDT == T005S.MANDT
  • I_BR_NFBRIEF_C.BR_NFPARTNERCOUNTRYCODE == T005S.LAND1
  • I_BR_NFBRIEF_C.BR_NFPARTNERREGIONCODE == T005S.BLAND
Company Code
  • Company Code
  • Client
  • I_BR_NFBRIEF_C.COMPANYCODE == T001.BUKRS
  • I_BR_NFBRIEF_C.MANDT == T001.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • I_BR_NFBRIEF_C.MANDT == TCURC.MANDT
  • I_BR_NFBRIEF_C.SALESDOCUMENTCURRENCY == TCURC.WAERS
Region (State, Province, County)
  • Region (State, Province, County)
  • Client
  • ?
  • I_BR_NFBRIEF_C.VEHICLEREGION == T005S.BLAND
  • I_BR_NFBRIEF_C.MANDT == T005S.MANDT
  • I_BR_NFBRIEF_C.[column in domain "LAND1"] == T005S.LAND1