P_BR_ReportigNFDocumentItemTax

EFD - NF Document Item Tax Cube | view: PBRNFDOCITEMTAX | Extraction: Not supported | Component: Financials Brazil
Tables used: J_1BNFDOC, J_1BNFE_ACTIVE, J_1BNFLIN, J_1BNFNAD, J_1BNFSTX, J_1BAJ, T001, TKA02, KNA1, LFA1, T006A
Column Name Description
CompanyCode FK Company Code
BusinessPlace FK Business Place
BR_NotaFiscal FK Document Number
BR_NotaFiscalItem Document Item Number
BR_TaxType FK Tax Type
TaxGroup null
Column Name Description
💲 SD Document Currency (SalesDocumentCurrency):
BR_PISSTTaxBaseAmount Base amount
BR_PISSTTaxAmount null
BR_IPITaxBaseAmount Base amount
BR_IPITaxAmount null
BR_IPITaxOtherBaseAmount Other base amount
BR_ISSQNTaxBaseAmount Base amount
BR_ISSQNTaxAmount null
BR_ISSQNTaxOtherBaseAmount Other base amount
BR_PISTaxBaseAmount Base amount
BR_PISTaxAmount null
BR_PISTaxOtherBaseAmount 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_COFINSTaxBaseAmount Base amount
BR_COFINSTaxAmount null
BR_COFINSTaxOtherBaseAmount Other base amount
BR_COFINSSTTaxBaseAmount Base amount
BR_COFINSSTTaxAmount null
BR_COFINSSTTaxOtherBaseAmount Other base amount
NFHeaderTotalAmount Total value including all taxes
BR_ICMSReductionTaxAmount null
BR_IPIReductionTaxAmount null
BR_DIFALTaxBaseAmount Base amount
BR_DIFALTaxAmount null
BR_DIFALTaxOtherBaseAmount Other base amount
BR_OutgoingNFOperationAmount Net value/Freight/Insurance/Expenses/Discount
BR_IncomingNFOperationAmount Net value/Freight/Insurance/Expenses/Discount
NFTotalAmount Net Value including taxes
BR_NFTotalAmount Net Value including taxes
BR_OriginalICMSSTTaxAmount Tax value
BR_OriginalIPITaxAmount Tax value
BR_OriginalICMSTaxAmount Tax value
BR_OriginalFCPOnICMSTaxAmount Tax value
BR_OriglFCPOnICMSSTTaxAmount Tax value
BR_ICMSOriginTaxAmount null
BR_ICMSOriginTaxBaseAmount Base amount
BR_ICMSDestinationTaxAmount null
BR_FCPOnICMSTaxAmount null
BR_FCPOnICMSTaxBaseAmount Base amount
BR_FCPOnICMSSTTaxAmount null
BR_FCPOnICMSSTTaxBaseAmount Base amount
BR_NFDiscountAmountWithTaxes null
BR_NFValueAmountWithTaxes Net Value including taxes
NetValueAmount Net Amount
BR_NFFreightAmountWithTaxes Freight value including taxes
BR_NFInsuranceAmountWithTaxes Insurance value including taxes
BR_NFNetOtherExpensesAmount Net expenses in document currency
NFItemTaxAmount null
NFItemBaseAmount Base amount
BR_NFOperationAmount null
BR_NFTotalOperationAmount null
Column Name Description
📏 Weight Unit (HeaderWeightUnit):
QuantityInBaseUnit Quantity
Column Name Description
BR_NFIssueDate Document Date
BR_NFPostingDate Posting Date
BR_NFCancellationDate Cancellation Date
BR_NFArrivalOrDepartureDate Goods Departure or Arrival Date
Column Name Description
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_NFOriginalDirection Movement Direction Show values
BR_NFIsCanceled Nota Fiscal Cancelled Show values
BR_CTeOriginalDocumentType CT-e Type Show values
FreightPayer Freight Mode Show values
BR_NFIsPhysicalMvtOfMaterial Material Movement Show values
BR_ICMSIsOriginalTaxSituation 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_ICMSIsIncludedInAmount Value and price including ICMS/ISS Show values
BR_PISTaxIsFiscalTariff Nota Fiscal tax record type Show values
BR_COFINSTaxIsFiscalTariff Nota Fiscal tax record type Show values
BR_NFIsMunicipal Municipal Fiscal Document Show values
BR_NFHasServiceItem Service NF/NF-e Show values
BR_NFItemIsStatistical Statistical Item Show values
BR_NFIsContingency Contingency Indicator for Nota Fiscal Show values
BR_CTeServiceType Service Type Indicator Show values
BR_NFIsCreatedManually Manually Created Show values
BR_ICMSPartilhaSubdivisionCode Tax Subdivision Show values
Column Name Description Domain name
BR_NFSeries Nota Fiscal Series J_1BSERIES
BR_NFPartner null
LicensePlate Vehicle License Plate CHAR7
BR_NFeNumber Nine-Digit Number
BR_NFeAccessKeyCNPJOrCPF CNPJ/CPF Number of Document Issuer J_1BSTCD1
BR_NFDirection null
SupplierInvoice Invoice Number CHAR20
BR_NFModel null
BR_NFeAccessKey null
BR_CTeAccessKey null
BR_CTeDocumentType null
BR_CTeJurisdictionCodeOrigin null
BR_CTeJurisdictionCodeDest null
Material Material Number MATNR
MaterialName Material Description TEXT40
BaseUnit External Unit of Measurement in Commercial Format (3-Char.) MSEH3
BR_ICMSTaxSituation null
BR_CFOPCode null
BR_PISTaxSituation PIS Tax Situation J_1BTAXSI5
BR_COFINSTaxSituation COFINS Tax Situation J_1BTAXSI4
GLAccount G/L Account Number SAKNR
ValuationArea null
BR_NFExternalItemNumber External Item Number NUMC3
BR_SUFRAMACode null
BR_NFShippingUnitBrand Shipping Unit Mark TEXT20
BR_NFSVerificationCode Verification Code J_1BCHECOD
BR_NFSubSeries Sub series J_1BSUBSER
BR_NFSNumber Service NF-e Number J_1BPREFNO
BR_NFPartnerStateTaxNumber State Tax Number J_1BSTAINS
BR_PISSTTaxRate Tax Rate with 4 Decimal Places J_1BTXRATE4DEC
BR_PISSTTaxExcludedBaseAmount Excluded Base Amount DECV15_2
BR_IPITaxRate Tax Rate with 4 Decimal Places J_1BTXRATE4DEC
BR_IPITaxExcludedBaseAmount Excluded Base Amount DECV15_2
BR_ISSQNTaxRate Tax Rate with 4 Decimal Places J_1BTXRATE4DEC
BR_ISSQNTaxExcludedBaseAmount 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_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_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_DIFALTaxRate Tax Rate with 4 Decimal Places J_1BTXRATE4DEC
BR_DIFALTaxExcludedBaseAmount Excluded Base Amount DECV15_2
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
MaterialType null
BR_NFPartnerMunicipalTaxNumber Municipal Tax Number J_1BMUNINS
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
BR_NFReferenceDocument null
AccountingDocument Accounting Document BELNR
PaymentTerms Terms of Payment Key ZTERM
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_NFPartnerName1 Name 1 NAME
BR_NFPartnerStreetName Street and House Number TEXT35
BusinessPartnerHouseNumber null
BPHsNmbrSuplmntTxt null
BR_NFPartnerDistrictName District TEXT35
BR_NFPartnerCityName City TEXT35
BR_NFPartnerPostalCode Postal Code PSTLZ
CostCenter Cost Center KOSTL
BR_NBSCode null
BR_NCMCode null
PhoneNumber Addresses: telephone no. TEXT30
BR_NFReductionBaseAmount Excluded Base Amount DECV15_2
Master Data Relations Join Conditions
Batch Number
  • Batch Number
  • Client
  • Material Number
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.BATCH == MCH1.CHARG
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.MANDT == MCH1.MANDT
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.MATERIALOLDID == MCH1.MATNR
COFINS Tax Law
  • Client
  • COFINS Tax Law
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.MANDT == J_1BATL4A.MANDT
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.BR_COFINSTAXLAW == J_1BATL4A.TAXLAW
Tax Law ICMS
  • Client
  • Tax Law ICMS
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.MANDT == J_1BATL1.MANDT
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.BR_ICMSTAXLAW == J_1BATL1.TAXLAW
Tax Law IPI
  • Client
  • Tax Law IPI
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.MANDT == J_1BATL2.MANDT
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.BR_IPITAXLAW == J_1BATL2.TAXLAW
IPI Tax Situation
  • IPI Tax Situation
  • Client
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.BR_IPITAXSITUATION == J_1BAS.TAXSIT
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.MANDT == J_1BAS.MANDT
ISS Tax Law
  • Client
  • ISS Tax Law
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.MANDT == J_1BATL3.MANDT
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.BR_ISSTAXLAW == J_1BATL3.TAXLAW
NF Item Type
  • Client
  • NF Item Type
Nota Fiscal Partner Function
  • Nota Fiscal Partner Function
  • Client
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.BR_NFPARTNERFUNCTION == J_1BAD.PARVW
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.MANDT == J_1BAD.MANDT
Region (State, Province, County)
  • Client
  • ?
  • Region (State, Province, County)
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.MANDT == T005S.MANDT
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.[column in domain "LAND1"] == T005S.LAND1
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.BR_NFPARTNERREGIONCODE == T005S.BLAND
Tax Jurisdiction
  • ?
  • Client
  • Tax Jurisdiction
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.MANDT == TTXJ.MANDT
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.BR_NFPARTNERTAXJURISDICTION == TTXJ.TXJCD
Reference type P_BR_REPORTIGNFDOCUMENTITEMTAX.BR_NFSOURCEDOCUMENTTYPE == J_1BAB.REFTYP
Nota Fiscal Type
  • Client
  • Nota Fiscal Type
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.MANDT == J_1BAA.MANDT
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.BR_NFTYPE == J_1BAA.NFTYPE
Tax Law PIS
  • Client
  • Tax Law PIS
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.MANDT == J_1BATL5.MANDT
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.BR_PISTAXLAW == J_1BATL5.TAXLAW
Tax Type
  • Tax Type
  • Client
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.BR_TAXTYPE == J_1BAJ.TAXTYP
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.MANDT == J_1BAJ.MANDT
Company Code
  • Client
  • Company Code
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.MANDT == T001.MANDT
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.COMPANYCODE == T001.BUKRS
Weight Unit
  • Client
  • Weight Unit
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.MANDT == T006.MANDT
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.HEADERWEIGHTUNIT == T006.MSEHI
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.MANDT == TINC.MANDT
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.INCOTERMSCLASSIFICATION == TINC.INCO1
Material Number
  • Client
  • Material Number
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.MANDT == MARA.MANDT
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.MATERIALOLDID == MARA.MATNR
Control Code
  • Client
  • Control Code
  • ?
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.MANDT == T604F.MANDT
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.NCMCODE == T604F.STEUC
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.[column in domain "LAND1"] == T604F.LAND1
CFOP Code and Extension
  • Client
  • ?
  • CFOP Code and Extension
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.MANDT == J_1BAGN.MANDT
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.[column in domain "J_1BCFOP_VER"] == J_1BAGN.VERSION
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.NFOPERATIONNATURE == J_1BAGN.CFOP
Plants
  • Client
  • Plant
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.MANDT == T001W.MANDT
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.PLANT == T001W.WERKS
SD Document Currency
  • Client
  • SD Document Currency
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.MANDT == TCURC.MANDT
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.SALESDOCUMENTCURRENCY == TCURC.WAERS
Valuation Type
  • Client
  • Valuation Type
  • Material Number
  • Plant
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.MANDT == MBEW.MANDT
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.VALUATIONTYPE == MBEW.BWTAR
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.MATERIALOLDID == MBEW.MATNR
  • P_BR_REPORTIGNFDOCUMENTITEMTAX.PLANT == MBEW.BWKEY