I_BR_NFItemBrief_C

Brazil Nota Fiscal Item Brief | view: IBRNFITEMBRIEFC | 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):
NetValueAmount Net Amount
BR_NFNetFreightAmount Net freight value in document currency
BR_NFNetInsuranceAmount Net insurance value in document currency
BR_NFNetOtherExpensesAmount Net expenses in document currency
BR_NFTotalAmount Net value/Freight/Insurance/Expenses/Discount
BR_NFValueAmountWithTaxes Net Value including taxes
BR_NFDiscountAmountWithTaxes Discount value including taxes
BR_NFFreightAmountWithTaxes Freight value including taxes
BR_NFInsuranceAmountWithTaxes Insurance value including taxes
BR_NFExpensesAmountWithTaxes Expenses including taxes
BR_NFTotalAmountWithTaxes Net value/Freight/Insurance/Expenses/Discount
Column Name Description
📏 Base unit of measure (BaseUnit):
QuantityInBaseUnit Quantity
Column Name Description
Column Name Description
BR_NFItemIsStatistical Statistical Item Show values
BR_NFIsServiceItem Service tax - no ICMS/IPI calculation Show values
BR_NFIsPhysicalMvtOfMaterial Material Movement Show values
BR_ICMSTaxSituation ICMS Tax Situation Show values
BR_MaterialOrigin Material Origin Show values
BR_MaterialUsage Material Usage Show values
IsProducedInhouse Produced in-House Show values
BR_NFItemHasTaxIncentive Tax Incentive Show values
ProductionIsInRelevantScale Scale Production Indicator Show values
BR_NFFreightNature Freight Nature Indicator Show values
Column Name Description Domain name
BR_NFItemTypeDesc Description of Rule TEXT60
MaterialName Material Description TEXT40
PlantName Plant Name TEXT30
BR_NFSourceDocumentNumber Source Document Key J_1BREFKEY
BR_NFSourceDocumentItem Reference item to source document J_1BREFITM
BR_NFPercentReturned Quantity Returned
BR_ReferenceNFItem NF Reference Item J_1BITMNUM
BR_NFSourceDocumentTypeDesc Reference type text TEXT30
NetPriceAmount Net Price Including Tax J_1BNFPRI
BR_NFNetDiscountAmount Net Discount Amount DECV15_2
BR_ExemptedICMSAmount ICMS Exemption Amount
BR_ICMSStatisticalExemptionAmt Statistical Exemption Value of ICMS
BR_ICMSSTMarginAddedPercent Margin percentage of value Added from ICMS ST J_1BNFE_PMVAST
BR_NFExemptedICMSWithTaxes Exemption Value of ICMS Including Taxes
BR_NFPriceAmountWithTaxes Net Price Including Tax J_1BNFPRI
BR_ISSTaxSituation ISS Tax Situation CHAR80
BR_CFOPFrmtdCode null
BR_CFOPDesc CFOP description TEXT50
NCMDesc1 Description of Rule TEXT60
NCMDesc2 Description of Rule TEXT60
NCMDesc3 Description of Rule TEXT60
NCMDesc4 Description of Rule TEXT60
NCMDesc5 Description of Rule TEXT60
BR_NFApproximateTotalTaxAmount Approximate Tax DECV15_2
BR_FCINumber FCI Number
BR_ICMSTaxLawDesc Tax Law - Description TEXT60
BR_IPITaxLawDesc Tax Law - Description TEXT60
BR_ISSTaxLawDesc Tax Law - Description TEXT60
BR_COFINSTaxLawDesc Tax Law - Description TEXT60
BR_PISTaxLawDesc Tax Law - Description TEXT60
GLAccount G/L Account Number SAKNR
PurchaseOrder Purchase Order Number CHAR15
PurchaseOrderItem Purchase Order Item CHAR6
InternationalArticleNumber European Article Number EAN11
BR_NFExternalItemNumber External Item Number NUMC3
BR_RECOPINumber Registro e Controle das Operações com o Papel Imune
BR_ISSSuspensionProcess Process Number CHAR30
BR_NFTributaryQuantity Tributary Quantity
ProjectNetwork Network Number for Account Assignment AUFNR
BR_ManufacturerCNPJ Manufacturer CNPJ LOGBR_CNPJ
CustomsChargesAmount Customs Expense Amount
BR_NFeStatisticalAmount Statistical Amount J_1BNFE_VOUTRO
BR_CSTISSCode CST for ISS Defined by Municipality LOGBR_MUNICIPAL_ISS_TAXSIT
BR_NBSCode NBS Code J_1BNBS
Master Data Relations Join Conditions
Base unit of measure
  • Client
  • Base unit of measure
  • I_BR_NFITEMBRIEF_C.MANDT == T006.MANDT
  • I_BR_NFITEMBRIEF_C.BASEUNIT == T006.MSEHI
Batch Number
  • Material Number
  • Batch Number
  • Client
  • I_BR_NFITEMBRIEF_C.MATERIAL == MCH1.MATNR
  • I_BR_NFITEMBRIEF_C.BATCH == MCH1.CHARG
  • I_BR_NFITEMBRIEF_C.MANDT == MCH1.MANDT
CNAE Business Place Code
  • CNAE Business Place Code
  • Client
  • I_BR_NFITEMBRIEF_C.BR_BUSINESSPLACECNAE == J_1BTCNAE.J_1BCNAE
  • I_BR_NFITEMBRIEF_C.MANDT == J_1BTCNAE.MANDT
COFINS Tax Law
  • COFINS Tax Law
  • Client
  • I_BR_NFITEMBRIEF_C.BR_COFINSTAXLAW == J_1BATL4A.TAXLAW
  • I_BR_NFITEMBRIEF_C.MANDT == J_1BATL4A.MANDT
EFD-REINF Service Type Code
  • EFD-REINF Service Type Code
  • Client
  • I_BR_NFITEMBRIEF_C.BR_EFDREINFSERVICECODE == LOGBR_REINF.REINF
  • I_BR_NFITEMBRIEF_C.MANDT == LOGBR_REINF.CLIENT
Tax Law ICMS
  • Client
  • Tax Law ICMS
  • I_BR_NFITEMBRIEF_C.MANDT == J_1BATL1.MANDT
  • I_BR_NFITEMBRIEF_C.BR_ICMSTAXLAW == J_1BATL1.TAXLAW
Tax Law IPI
  • Tax Law IPI
  • Client
  • I_BR_NFITEMBRIEF_C.BR_IPITAXLAW == J_1BATL2.TAXLAW
  • I_BR_NFITEMBRIEF_C.MANDT == J_1BATL2.MANDT
Benefit Code for ISS Tax
  • Benefit Code for ISS Tax
  • Client
  • ?
ISS Tax Law
  • Client
  • ISS Tax Law
  • I_BR_NFITEMBRIEF_C.MANDT == J_1BATL3.MANDT
  • I_BR_NFITEMBRIEF_C.BR_ISSTAXLAW == J_1BATL3.TAXLAW
LC 116 Service Type Code
  • LC 116 Service Type Code
  • Client
NF Item Type
  • NF Item Type
  • Client
CNAE Code for Partner
  • CNAE Code for Partner
  • Client
  • I_BR_NFITEMBRIEF_C.BR_NFPARTNERCNAE == J_1BTCNAE.J_1BCNAE
  • I_BR_NFITEMBRIEF_C.MANDT == J_1BTCNAE.MANDT
Reference type I_BR_NFITEMBRIEF_C.BR_NFSOURCEDOCUMENTTYPE == J_1BAB.REFTYP
Tax Law PIS
  • Client
  • Tax Law PIS
  • I_BR_NFITEMBRIEF_C.MANDT == J_1BATL5.MANDT
  • I_BR_NFITEMBRIEF_C.BR_PISTAXLAW == J_1BATL5.TAXLAW
Material Number
  • Material Number
  • Client
  • I_BR_NFITEMBRIEF_C.MATERIAL == MARA.MATNR
  • I_BR_NFITEMBRIEF_C.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • I_BR_NFITEMBRIEF_C.MATERIALGROUP == T023.MATKL
  • I_BR_NFITEMBRIEF_C.MANDT == T023.MANDT
Control Code
  • Control Code
  • Client
  • ?
  • I_BR_NFITEMBRIEF_C.NCMCODE == T604F.STEUC
  • I_BR_NFITEMBRIEF_C.MANDT == T604F.MANDT
  • I_BR_NFITEMBRIEF_C.[column in domain "LAND1"] == T604F.LAND1
Plants
  • Plant
  • Client
  • I_BR_NFITEMBRIEF_C.PLANT == T001W.WERKS
  • I_BR_NFITEMBRIEF_C.MANDT == T001W.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • I_BR_NFITEMBRIEF_C.MANDT == TCURC.MANDT
  • I_BR_NFITEMBRIEF_C.SALESDOCUMENTCURRENCY == TCURC.WAERS
State Tax Incentive Code
  • Client
  • ?
  • State Tax Incentive Code
Valuation Type
  • Plant
  • Material Number
  • Client
  • Valuation Type
  • I_BR_NFITEMBRIEF_C.PLANT == MBEW.BWKEY
  • I_BR_NFITEMBRIEF_C.MATERIAL == MBEW.MATNR
  • I_BR_NFITEMBRIEF_C.MANDT == MBEW.MANDT
  • I_BR_NFITEMBRIEF_C.VALUATIONTYPE == MBEW.BWTAR