I_BR_NFItemTax_C

Brazil Nota Fiscal Item Tax | view: IBRNFITEMTAXC | Extraction: Not supported | Component: Logistics Brazil
Column Name Description
BR_NotaFiscal FK Document Number
BR_NotaFiscalItem Document Item Number
Column Name Description
💲 SD Document Currency (SalesDocumentCurrency):
BR_WithholdingICMSSTBaseAmount Withholding ICMS ST Base
BR_WithholdingICMSSTAmount Withholding ICMS ST Amount
BR_EffctvCalcBasisAmount Effective Calculation Basis Amount
BR_EffectiveICMSAmount Effective ICMS Amount
BR_ICMSSTDestTaxBaseAmount ICMS ST Basis Destination State
BR_ICMSSTDestTaxAmount ICMS ST for Destination State
BR_FCPOnICMSSTWithheldBaseAmt Withheld FCP Calculation Basis
Column Name Description
Column Name Description
Column Name Description
BR_ICMSTaxSituation ICMS Tax Situation Show values
BR_ICMSBaseDetn ICMS Base Determination Show values
BR_ICMSSTBaseDetermination ICMS ST Base Determination Show values
BR_ICMSExemptionReason Exemption Reason Show values
Column Name Description Domain name
BR_IPITaxSituationDesc Description tax situation IPI TEXT60
BR_COFINSTaxSituationDesc COFINS Tax Situation: Description TEXT60
BR_PISTaxSituationDesc PIS Tax Situation: Description TEXT60
BR_ISSTaxSituationDesc ISS Tax Situation: Description TEXT60
BR_ICMSSTMarginAddedPercent Margin percentage of value Added from ICMS ST J_1BNFE_PMVAST
BR_ICMSSTLegalClassfctn null
BR_ICMSSTLegalClassfctnDesc ICMS ST Legal Classification Code Description J_1BCESTD
BR_SubstituteICMSAmount Substitute ICMS Amount Charged in Previous Transaction J_1BNFE_VICMSSUBSTITUTO
BR_ICMSDefermentAmount Deferment Amount J_1BNFE_RFC_VICMSDIF
BR_ICMSDeferralTaxRate Tax Rate for ICMS Deferral J_1BNFE_PICMSDEF
BR_ReducnPctEffctvCalcBasis Reduction Percentage of Effective Calculation Basis J_1BNFE_PREDBCEFET
BR_EffectiveICMSRate Effective ICMS Rate J_1BNFE_PICMSEFET
BR_IPILegalClassificationDesc IPI Legal Classification Code Description J_1BCENQD
BR_TobaccoBeverageIPIClassfctn IPI Tobacco/Beverage CHAR5
BR_IPIControlSealCode IPI Control Seal Code CHAR10
BR_IPIControlSealQuantityValue IPI Control Seal Quantity DEC12
BR_FCPonICMSSTWithheldRate Withheld FCP ST J_1BNFE_PFCPSTRET
BR_FCPOnICMSSTWithheldAmount Withheld FCP ST Amount J_1BNFE_VFCPSTRET
BR_IOFTaxAmount IOF Amount
CustomsChargesAmount Customs Expense Amount
BR_ICMSSTRateIncludingFCP Final Consumer Rate J_1BNFE_PST
Master Data Relations Join Conditions
Tax Situation COFINS
  • Client
  • Tax Situation PIS
  • Tax Situation COFINS
  • Tax situation IPI
  • Tax Situation ISS
IPI Legal Classification Code
  • Client
  • IPI Legal Classification Code
  • I_BR_NFITEMTAX_C.MANDT == J_1BTCENQ.MANDT
  • I_BR_NFITEMTAX_C.BR_IPILEGALCLASSIFICATION == J_1BTCENQ.CENQ
Tax situation IPI
  • Client
  • Tax Situation PIS
  • Tax Situation COFINS
  • Tax situation IPI
  • Tax Situation ISS
  • I_BR_NFITEMTAX_C.MANDT == J_1BAS.MANDT
  • I_BR_NFITEMTAX_C.BR_PISTAXSITUATION == J_1BAS.TAXSIT
  • I_BR_NFITEMTAX_C.BR_COFINSTAXSITUATION == J_1BAS.TAXSIT
  • I_BR_NFITEMTAX_C.BR_IPITAXSITUATION == J_1BAS.TAXSIT
  • I_BR_NFITEMTAX_C.BR_ISSTAXSITUATION == J_1BAS.TAXSIT
Tax Situation ISS
  • Client
  • Tax Situation PIS
  • Tax Situation COFINS
  • Tax situation IPI
  • Tax Situation ISS
Tax Situation PIS
  • Client
  • Tax Situation PIS
  • Tax Situation COFINS
  • Tax situation IPI
  • Tax Situation ISS
SD Document Currency
  • Client
  • SD Document Currency
  • I_BR_NFITEMTAX_C.MANDT == TCURC.MANDT
  • I_BR_NFITEMTAX_C.SALESDOCUMENTCURRENCY == TCURC.WAERS