P_BR_ReportingNFTaxCalculation

EFD - NF Calculated Tax Value Cube | view: PBRNFTAXCALC | Extraction: Not supported | Component: Financials Brazil
Column Name Description
BR_NotaFiscal FK Document Number
BR_NotaFiscalItem Document Item Number
Column Name Description
💲 SD Document Currency (SalesDocumentCurrency):
NFHeaderTotalAmount Total value including all taxes
BR_NFTotalAmount Net value/Freight/Insurance/Expenses/Discount
BR_NFTotalAmountWithTaxes Net value/Freight/Insurance/Expenses/Discount
BR_NFValueAmountWithTaxes Net Value including taxes
NetValueAmount Net Amount
BR_NFDiscountAmountWithTaxes Discount value including taxes
BR_NFFreightAmountWithTaxes Freight value including taxes
BR_NFInsuranceAmountWithTaxes Insurance value including taxes
BR_NFNetOtherExpensesAmount Net expenses in document currency
BR_NFItemOriginalBaseAmount Base amount
BR_OriglNFItemOtherBaseAmount Other base amount
BR_NFItemOriginalTaxAmount Tax value
NFItemOtherBaseAmount Other base amount
NFItemBaseAmount Base amount
BR_IPIReductionTaxAmount null
BR_ICMSReductionTaxAmount null
NFItemTaxAmount null
BR_ISSQNTaxBaseAmount Base amount
BR_ISSQNTaxAmount null
BR_ISSQNTaxOtherBaseAmount Other base amount
BR_ICMSTaxBaseAmount Base amount
BR_ICMSTaxAmount null
BR_ICMSTaxOtherBaseAmount Other base amount
BR_ICMSSTTaxBaseAmount Base amount
BR_ICMSSTTaxAmount null
BR_ICMSSTTaxOtherBaseAmount Other base amount
BR_IPITaxBaseAmount Base amount
BR_IPITaxAmount null
BR_IPITaxOtherBaseAmount Other base amount
BR_PISTaxBaseAmount Base amount
BR_PISTaxAmount null
BR_PISTaxOtherBaseAmount Other base amount
BR_PISSTTaxBaseAmount Base amount
BR_PISSTTaxAmount null
BR_PISSTTaxOtherBaseAmount Other base amount
BR_COFINSTaxBaseAmount Base amount
BR_COFINSTaxAmount null
BR_COFINSTaxOtherBaseAmount Other base amount
BR_COFINSSTTaxBaseAmount Base amount
BR_COFINSSTTaxAmount null
BR_COFINSSTTaxOtherBaseAmount Other base amount
BR_IRRFTaxBaseAmount Base amount
BR_IRRFTaxAmount null
BR_DIFALTaxBaseAmount Base amount
BR_DIFALTaxAmount null
BR_DIFALTaxOtherBaseAmount Other base amount
BR_OriginalICMSSTTaxAmount Tax value
BR_OriginalIPITaxAmount Tax value
BR_OriginalICMSTaxAmount Tax value
BR_OriginalPISTaxAmount Tax value
BR_OriginalCOFINSTaxAmount Tax value
BR_OriginalFCPOnICMSTaxAmount Tax value
BR_OriglFCPOnICMSSTTaxAmount Tax value
BR_ICMSOriginTaxBaseAmount Base amount
BR_ICMSOriginTaxAmount null
BR_ICMSDestinationTxBaseAmount Base amount
BR_ICMSDestinationTaxAmount null
BR_FCPOnICMSTaxBaseAmount Base amount
BR_FCPOnICMSTaxAmount null
BR_FCPOnICMSSTTaxBaseAmount Base amount
BR_FCPOnICMSSTTaxAmount null
ImportTaxAmount null
BR_ICMSSTStatisticalTaxAmount null
BR_IPIStatisticalTaxAmount null
BR_ICZGTaxAmount null
Column Name Description
📏 Weight Unit (HeaderWeightUnit):
QuantityInBaseUnit Quantity
BR_NFItemFixedMktTariffBaseQty Pauta Base Four Decimals
Column Name Description
BR_NFIssueDate Document Date
BR_NFCancellationDate Cancellation Date
BR_NFPostingDate Posting Date
CreationDate Document Creation Date
BR_NFArrivalOrDepartureDate Goods Departure or Arrival Date
Column Name Description
OriginalTaxGroup Tax Group Show values
BR_PaymentForm Payment Form Indicator Show values
BR_NFPartnerType Type Show values
BR_NFIssuedBy Nota Fiscal Issued By Show values
BR_NFSituationCode Status Code of Fiscal Document Show values
BR_NFModel Nota Fiscal Model Show values
BR_NFDirection Movement Direction Show values
BR_IsNFe Electronic Fiscal Document Show values
BR_NFIsCanceled Nota Fiscal Cancelled Show values
FreightPayer Freight Mode Show values
BR_NFIsMunicipal Municipal Fiscal Document Show values
BR_NFHasServiceItem Service NF/NF-e Show values
BR_NFIsCreatedManually Manually Created Show values
BR_NFIsContingency Contingency Indicator for Nota Fiscal Show values
BR_CTeDocumentType CT-e Type Show values
BR_CTeServiceType Service Type Indicator Show values
BR_NFIsPhysicalMvtOfMaterial Material Movement Show values
BR_ICMSTaxSituation ICMS Tax Situation Show values
BR_MaterialUsage Material Usage Show values
BR_NFIsServiceItem Service tax - no ICMS/IPI calculation Show values
BR_MaterialOrigin Material Origin Show values
BR_ICMSBaseDetn ICMS Base Determination Show values
BR_NFItemIsStatistical Statistical Item Show values
BR_NFItemIsStatisticalTax Statistical Tax Item Show values
BR_NFItemHasFixedMktTariff Nota Fiscal tax record type Show values
BR_NFItemHasWithholdingTax Withholding Tax Show values
BR_ICMSIsIncludedInAmount Value and price including ICMS/ISS Show values
BR_ICMSPartilhaSubdivisionCode Tax Subdivision Show values
BR_PISTaxIsFiscalTariff Nota Fiscal tax record type Show values
BR_PISSTTaxIsFiscalTariff Nota Fiscal tax record type Show values
BR_COFINSTaxIsFiscalTariff Nota Fiscal tax record type Show values
BR_COFINSSTTaxIsFiscalTariff Nota Fiscal tax record type Show values
BR_DIFALTaxIsFiscalTariff Nota Fiscal tax record type Show values
Column Name Description Domain name
BR_NFSeries Nota Fiscal Series J_1BSERIES
PartnerFieldLength null
BR_NFPartner Partner ID (Customer, Vendor, Business Place) J_1BPARID
LicensePlate Vehicle License Plate CHAR7
BR_NFeNumber Nine-Digit Number
BR_CTeJurisdictionCodeOrigin null
BR_CTeJurisdictionCodeDest null
BR_NFShippingUnitBrand Shipping Unit Mark TEXT20
BR_NFSVerificationCode Verification Code J_1BCHECOD
BR_NFSubSeries Sub series J_1BSUBSER
SupplierInvoice Invoice Number CHAR20
BR_NFSNumber Service NF-e Number J_1BPREFNO
BR_NFPartnerStateTaxNumber State Tax Number J_1BSTAINS
BR_NFPartnerMunicipalTaxNumber Municipal Tax Number J_1BMUNINS
BR_NFReferenceDocument null
CreatedByUser User who created the document USNAM
AccountingDocument Accounting Document BELNR
PaymentTerms Terms of Payment Key ZTERM
BR_NFPartnerName1 Name 1 NAME
BR_NFPartnerDistrictName District TEXT35
BR_NFPartnerCityName City TEXT35
BR_NFPartnerPostalCode Postal Code PSTLZ
BR_NFPartnerStreetName Street and House Number TEXT35
BusinessPartnerHouseNumber House Number TEXT10
BPHsNmbrSuplmntTxt House number supplement TEXT10
PhoneNumber Addresses: telephone no. TEXT30
Material Material Number MATNR
MaterialName Material Description TEXT40
BR_PISTaxSituation PIS Tax Situation J_1BTAXSI5
BR_COFINSTaxSituation COFINS Tax Situation J_1BTAXSI4
GLAccount G/L Account Number SAKNR
BR_NFExternalItemNumber External Item Number NUMC3
BR_IPIControlSealCode IPI Control Seal Code CHAR10
BR_IPIControlSealQuantityValue IPI Control Seal Quantity DEC12
PurchaseOrder Purchase Order Number CHAR15
PurchaseOrderItem Purchase Order Item CHAR6
NetPriceAmount Net Price Including Tax J_1BNFPRI
BR_ExemptedICMSAmount ICMS Exemption Amount
BR_NFSourceDocumentNumber Source Document Key J_1BREFKEY
BR_NFSourceDocumentItem Reference item to source document J_1BREFITM
BR_ISSTaxSituation ISS Tax Situation CHAR80
BR_ReferenceNFItem NF Reference Item J_1BITMNUM
BR_NFPriceAmountWithTaxes Net Price Including Tax J_1BNFPRI
CostCenter Cost Center KOSTL
BR_NBSCode NBS Code J_1BNBS
TaxGroup null
BR_OriglNFItemExclBaseAmount Excluded Base Amount DECV15_2
BR_OriginalNFItemTaxRate Tax Rate J_1BTXRATE
BR_NFItemTaxBasePct1 Tax Base J_1BTXBASE
BR_NFItemTaxBasePct2 Tax base (%) J_1BTXBASE
BR_NFItemWhldgCollectionCode Official Withholding Tax Collection Code WITHCD2
BR_NFItemFixedMktTariffTaxRate Tax Rate with 4 Decimal Places J_1BTXRATE4DEC
BR_NFItemFixedMktTariffQty Number of Units for Pauta with 4 DP (for Reporting Only) DEC4_2
BR_UFTaxJurisdiction null
BR_NFIsTaxInNetAmount null
NFItemExcludedBaseAmount Excluded Base Amount DECV15_2
BR_TaxIsISSQN null
NFItemTaxRate Tax Rate with 4 Decimal Places J_1BTXRATE4DEC
BR_ISSQNTaxRate Tax Rate with 4 Decimal Places J_1BTXRATE4DEC
BR_ISSQNTaxExcludedBaseAmount Excluded Base Amount DECV15_2
BR_ICMSTaxRate Tax Rate with 4 Decimal Places J_1BTXRATE4DEC
BR_ICMSTaxExcludedBaseAmount Excluded Base Amount DECV15_2
BR_ICMSSTTaxRate Tax Rate with 4 Decimal Places J_1BTXRATE4DEC
BR_ICMSSTTaxExcludedBaseAmount Excluded Base Amount DECV15_2
BR_IPITaxRate Tax Rate with 4 Decimal Places J_1BTXRATE4DEC
BR_IPITaxExcludedBaseAmount Excluded Base Amount DECV15_2
BR_AppliedPISTaxAmount Tax Rate with 4 Decimal Places J_1BTXRATE4DEC
BR_PISTaxExcludedBaseAmount Excluded Base Amount DECV15_2
BR_PISTxFiscalTariffBaseAmount Tax Rate with 4 Decimal Places J_1BTXRATE4DEC
BR_PISSTTaxRate Tax Rate with 4 Decimal Places J_1BTXRATE4DEC
BR_PISSTTaxExcludedBaseAmount Excluded Base Amount DECV15_2
BR_PISSTTxFsclTariffBaseAmount Tax Rate with 4 Decimal Places J_1BTXRATE4DEC
BR_AppliedCOFINSTaxAmount Tax Rate with 4 Decimal Places J_1BTXRATE4DEC
BR_COFINSTaxExcludedBaseAmount Excluded Base Amount DECV15_2
BR_COFINSTxFsclTrifBaseAmount Tax Rate with 4 Decimal Places J_1BTXRATE4DEC
BR_COFINSSTTaxRate Tax Rate with 4 Decimal Places J_1BTXRATE4DEC
BR_COFINSSTTaxExcldBaseAmount Excluded Base Amount DECV15_2
BR_COFINSSTTxFsclTrifBaseAmt Tax Rate with 4 Decimal Places J_1BTXRATE4DEC
BR_DIFALTaxRate Tax Rate with 4 Decimal Places J_1BTXRATE4DEC
BR_DIFALTaxExcludedBaseAmount Excluded Base Amount DECV15_2
BR_DIFALTxFsclTariffBaseAmount Tax Rate with 4 Decimal Places J_1BTXRATE4DEC
BR_ICMSOriginTaxRate Tax Rate with 4 Decimal Places J_1BTXRATE4DEC
BR_ICMSDestinationTaxRate Tax Rate with 4 Decimal Places J_1BTXRATE4DEC
BR_FCPOnICMSTaxRate Tax Rate with 4 Decimal Places J_1BTXRATE4DEC
BR_FCPOnICMSSTTaxRate Tax Rate with 4 Decimal Places J_1BTXRATE4DEC
BR_PISIsIncludedInAmount null
BR_COFINSIsIncludedInAmount null
Master Data Relations Join Conditions
Base unit of measure
  • Client
  • Base unit of measure
  • P_BR_REPORTINGNFTAXCALCULATION.MANDT == T006.MANDT
  • P_BR_REPORTINGNFTAXCALCULATION.BASEUNIT == T006.MSEHI
Batch Number
  • Client
  • Material Number
  • Batch Number
  • P_BR_REPORTINGNFTAXCALCULATION.MANDT == MCH1.MANDT
  • P_BR_REPORTINGNFTAXCALCULATION.MATERIALOLDID == MCH1.MATNR
  • P_BR_REPORTINGNFTAXCALCULATION.BATCH == MCH1.CHARG
CFOP Code and Extension
  • CFOP Code and Extension
  • Client
  • ?
  • P_BR_REPORTINGNFTAXCALCULATION.BR_CFOPCODE == J_1BAGN.CFOP
  • P_BR_REPORTINGNFTAXCALCULATION.MANDT == J_1BAGN.MANDT
  • P_BR_REPORTINGNFTAXCALCULATION.[column in domain "J_1BCFOP_VER"] == J_1BAGN.VERSION
COFINS Tax Law
  • Client
  • COFINS Tax Law
  • P_BR_REPORTINGNFTAXCALCULATION.MANDT == J_1BATL4A.MANDT
  • P_BR_REPORTINGNFTAXCALCULATION.BR_COFINSTAXLAW == J_1BATL4A.TAXLAW
Tax Law ICMS
  • Client
  • Tax Law ICMS
  • P_BR_REPORTINGNFTAXCALCULATION.MANDT == J_1BATL1.MANDT
  • P_BR_REPORTINGNFTAXCALCULATION.BR_ICMSTAXLAW == J_1BATL1.TAXLAW
Tax Law IPI
  • Client
  • Tax Law IPI
  • P_BR_REPORTINGNFTAXCALCULATION.MANDT == J_1BATL2.MANDT
  • P_BR_REPORTINGNFTAXCALCULATION.BR_IPITAXLAW == J_1BATL2.TAXLAW
IPI Tax Situation
  • Client
  • IPI Tax Situation
  • P_BR_REPORTINGNFTAXCALCULATION.MANDT == J_1BAS.MANDT
  • P_BR_REPORTINGNFTAXCALCULATION.BR_IPITAXSITUATION == J_1BAS.TAXSIT
ISS Tax Law
  • Client
  • ISS Tax Law
  • P_BR_REPORTINGNFTAXCALCULATION.MANDT == J_1BATL3.MANDT
  • P_BR_REPORTINGNFTAXCALCULATION.BR_ISSTAXLAW == J_1BATL3.TAXLAW
Document Type
  • Client
  • Document Type
  • P_BR_REPORTINGNFTAXCALCULATION.MANDT == J_1BDOCTYPES.MANDT
  • P_BR_REPORTINGNFTAXCALCULATION.BR_NFDOCUMENTTYPE == J_1BDOCTYPES.DOCTYP
Pauta Unit
  • Client
  • Pauta Unit
  • P_BR_REPORTINGNFTAXCALCULATION.MANDT == T006.MANDT
  • P_BR_REPORTINGNFTAXCALCULATION.BR_NFITEMFIXEDMARKETTARIFFUNIT == T006.MSEHI
NF Item Type
  • NF Item Type
  • Client
Nota Fiscal Partner Function
  • Client
  • Nota Fiscal Partner Function
  • P_BR_REPORTINGNFTAXCALCULATION.MANDT == J_1BAD.MANDT
  • P_BR_REPORTINGNFTAXCALCULATION.BR_NFPARTNERFUNCTION == J_1BAD.PARVW
Region (State, Province, County)
  • Client
  • Region (State, Province, County)
  • ?
  • P_BR_REPORTINGNFTAXCALCULATION.MANDT == T005S.MANDT
  • P_BR_REPORTINGNFTAXCALCULATION.BR_NFPARTNERREGIONCODE == T005S.BLAND
  • P_BR_REPORTINGNFTAXCALCULATION.[column in domain "LAND1"] == T005S.LAND1
Tax Jurisdiction
  • Client
  • Tax Jurisdiction
  • ?
  • P_BR_REPORTINGNFTAXCALCULATION.MANDT == TTXJ.MANDT
  • P_BR_REPORTINGNFTAXCALCULATION.BR_NFPARTNERTAXJURISDICTION == TTXJ.TXJCD
  • P_BR_REPORTINGNFTAXCALCULATION.[column in domain "TAX_KALSM"] == TTXJ.KALSM
Reference type P_BR_REPORTINGNFTAXCALCULATION.BR_NFSOURCEDOCUMENTTYPE == J_1BAB.REFTYP
Service Type (Incoming)
  • Client
  • ?
  • Tax Jurisdiction Code For Brazilian Tax Calculation
  • Service Type (Incoming)
  • P_BR_REPORTINGNFTAXCALCULATION.MANDT == J_1BSERVTYPES1.CLIENT
  • P_BR_REPORTINGNFTAXCALCULATION.[column in domain "LAND1"] == J_1BSERVTYPES1.COUNTRY
  • P_BR_REPORTINGNFTAXCALCULATION.TAXJURISDICTION == J_1BSERVTYPES1.TAXJURCODE
  • P_BR_REPORTINGNFTAXCALCULATION.BR_NFSSERVICETYPEINCOMING == J_1BSERVTYPES1.SERVTYPE_IN
Service Type (Outgoing)
  • Client
  • ?
  • Service Type (Outgoing)
  • Tax Jurisdiction Code For Brazilian Tax Calculation
  • P_BR_REPORTINGNFTAXCALCULATION.MANDT == J_1BSERVTYPES2.CLIENT
  • P_BR_REPORTINGNFTAXCALCULATION.[column in domain "LAND1"] == J_1BSERVTYPES2.COUNTRY
  • P_BR_REPORTINGNFTAXCALCULATION.BR_NFSSERVICETYPEOUTGOING == J_1BSERVTYPES2.SERVTYPE_OUT
  • P_BR_REPORTINGNFTAXCALCULATION.TAXJURISDICTION == J_1BSERVTYPES2.TAXJURCODE
Nota Fiscal Type
  • Client
  • Nota Fiscal Type
  • P_BR_REPORTINGNFTAXCALCULATION.MANDT == J_1BAA.MANDT
  • P_BR_REPORTINGNFTAXCALCULATION.BR_NFTYPE == J_1BAA.NFTYPE
Tax Law PIS
  • Client
  • Tax Law PIS
  • P_BR_REPORTINGNFTAXCALCULATION.MANDT == J_1BATL5.MANDT
  • P_BR_REPORTINGNFTAXCALCULATION.BR_PISTAXLAW == J_1BATL5.TAXLAW
Tax Type
  • Client
  • Tax Type
  • P_BR_REPORTINGNFTAXCALCULATION.MANDT == J_1BAJ.MANDT
  • P_BR_REPORTINGNFTAXCALCULATION.BR_TAXTYPE == J_1BAJ.TAXTYP
Company Code
  • Client
  • Company Code
  • P_BR_REPORTINGNFTAXCALCULATION.MANDT == T001.MANDT
  • P_BR_REPORTINGNFTAXCALCULATION.COMPANYCODE == T001.BUKRS
Weight Unit
  • Client
  • Weight Unit
  • P_BR_REPORTINGNFTAXCALCULATION.MANDT == T006.MANDT
  • P_BR_REPORTINGNFTAXCALCULATION.HEADERWEIGHTUNIT == T006.MSEHI
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • P_BR_REPORTINGNFTAXCALCULATION.INCOTERMSCLASSIFICATION == TINC.INCO1
  • P_BR_REPORTINGNFTAXCALCULATION.MANDT == TINC.MANDT
Material Number
  • Client
  • Material Number
  • P_BR_REPORTINGNFTAXCALCULATION.MANDT == MARA.MANDT
  • P_BR_REPORTINGNFTAXCALCULATION.MATERIALOLDID == MARA.MATNR
Control Code
  • Client
  • ?
  • Control Code
  • P_BR_REPORTINGNFTAXCALCULATION.MANDT == T604F.MANDT
  • P_BR_REPORTINGNFTAXCALCULATION.[column in domain "LAND1"] == T604F.LAND1
  • P_BR_REPORTINGNFTAXCALCULATION.NCMCODE == T604F.STEUC
Plants
  • Client
  • Plant
  • P_BR_REPORTINGNFTAXCALCULATION.MANDT == T001W.MANDT
  • P_BR_REPORTINGNFTAXCALCULATION.PLANT == T001W.WERKS
SD Document Currency
  • Client
  • SD Document Currency
  • P_BR_REPORTINGNFTAXCALCULATION.MANDT == TCURC.MANDT
  • P_BR_REPORTINGNFTAXCALCULATION.SALESDOCUMENTCURRENCY == TCURC.WAERS
Tax Jurisdiction Code For Brazilian Tax Calculation
  • Client
  • ?
  • Tax Jurisdiction Code For Brazilian Tax Calculation
  • P_BR_REPORTINGNFTAXCALCULATION.MANDT == J_1BTXJUR.CLIENT
  • P_BR_REPORTINGNFTAXCALCULATION.[column in domain "LAND1"] == J_1BTXJUR.COUNTRY
  • P_BR_REPORTINGNFTAXCALCULATION.TAXJURISDICTION == J_1BTXJUR.TAXJURCODE
Valuation Type
  • Client
  • Material Number
  • Valuation Type
  • Plant
  • P_BR_REPORTINGNFTAXCALCULATION.MANDT == MBEW.MANDT
  • P_BR_REPORTINGNFTAXCALCULATION.MATERIALOLDID == MBEW.MATNR
  • P_BR_REPORTINGNFTAXCALCULATION.VALUATIONTYPE == MBEW.BWTAR
  • P_BR_REPORTINGNFTAXCALCULATION.PLANT == MBEW.BWKEY