I_BR_NFItemTaxByItem_C

Brazil Nota Fiscal Tax by Item | view: IBRNFITMTXITMC | Extraction: Not supported | Component: Logistics Brazil
Column Name Description
BR_NotaFiscal FK Document Number
BR_NotaFiscalItem Document Item Number
BR_TaxType FK Tax Type
TaxGroup Tax Group Show values
Column Name Description
Column Name Description
📏 Pauta Unit (BR_NFItemFixedMarketTariffUnit):
BR_NFItemFixedMktTariffBaseAmt Pauta Base with 3 Decimal Places
Column Name Description
Column Name Description
TaxGroup Tax Group Show values
BR_NFItemIsStatisticalTax Statistical Tax Item Show values
BR_NFItemHasFixedMktTariff Pauta Indicator Show values
BR_NFItemHasWithholdingTax Withholding Tax Show values
BR_ICMSPartilhaSubdivisionCode Tax Subdivision Show values
Column Name Description Domain name
TaxTypeName Description Tax Type TXT30
BR_NFItemBaseAmount Base Amount DECV15_2
BR_NFItemTaxRate Tax Rate J_1BTXRATE
BR_NFItemTaxAmount Tax Amount DECV15_2
BR_NFItemExcludedBaseAmount Excluded Base Amount DECV15_2
BR_NFItemOtherBaseAmount Other Base Amount DECV15_2
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
Master Data Relations Join Conditions
Pauta Unit
  • Client
  • Pauta Unit
  • I_BR_NFITEMTAXBYITEM_C.MANDT == T006.MANDT
  • I_BR_NFITEMTAXBYITEM_C.BR_NFITEMFIXEDMARKETTARIFFUNIT == T006.MSEHI
Tax Type
  • Client
  • Tax Type
  • I_BR_NFITEMTAXBYITEM_C.MANDT == J_1BAJ.MANDT
  • I_BR_NFITEMTAXBYITEM_C.BR_TAXTYPE == J_1BAJ.TAXTYP