J_1BNFLIN

Nota Fiscal line items | #itemdata | Component: Logistics Brazil
Column Name Description
MANDT FK Client
DOCNUM FK Document Number
ITMNUM Document Item Number
Column Name Description
💲 SD Document Currency (J_1BNFDOC.WAERK):
NETWR Net Value
NETFRE Net freight value in document currency
NETINS Net insurance value in document currency
NETOTH Net expenses in document currency
NETDIS Net discount value in document currency
NFNET Net Value including taxes
NFDIS Discount value including taxes
NFFRE Freight value including taxes
NFINS Insurance value including taxes
NFOTH Expenses including taxes
NETWRT Net value/Freight/Insurance/Expenses/Discount
NFNETT Net value/Freight/Insurance/Expenses/Discount
ICMSAVR Average ICMS on Stock Transfers
SUBTAVR Average Substituição Tributária on Stock Transfers
LPPNET Last Purchase Price (Net)
LPPBRT Last Purchase Price (Gross)
ICMSVALP ICMS on Last Purchase Price
SUBTVALP Substituição Tributária on Last Purchase Price
VICMSSTRET Wth. ICMS ST Value already charged
VBCSTRET WTH. ICMS ST Base already charged
VBCFCPSTRET FCP Calculation Basis withheld for Tributary Substitution
VBCEFET Effective Calculation Basis Amount
VICMSEFET Effective ICMS Amount
COFINSST COFINS ST Value
PISST PIS ST Value
NFCOFINSST COFINS ST Value Including Taxes
NFPISST PIS ST Value Including Taxes
VTOTTRIB Approximate Total Tax Amount
💲 Currency Key (TCURC.WAERS):
VBCSTDEST ICMS ST Calculation Basis from UF Destination
VICMSSTDEST ICMS ST Value from UF Destination
Column Name Description
📏 Base unit of measure (MEINS):
MENGE Quantity
Column Name Description
Column Name Description
MATORG Origin of the material Show values
TAXSIT Tax situation ICMS Show values
OWNPRO Produced in-house Show values
MATUSE Usage of the material Show values
TMISS Service tax - no ICMS/IPI calculation Show values
INDUS3 Material CFOP category Show values
SPCSTO Nota Fiscal Special Case for CFOP Determination Show values
INCLTX Value and price including ICMS/ISS Show values
STATIT Indicator: Statistical item Show values
DIRECT Direction of the movement Show values
DSTCAT Destination category Show values
INDUS2 Business Place CFOP Category Show values
MODBC ICMS Tax Base Determination Modality Show values
MODBCST ICMS Sub Trib Tax Base Determination Modality Show values
MOTDESICMS ICMS Exemption Reason Show values
IND_MOV Physical Movement of Materials Show values
INDINCENTIVO Tax Incentive Show values
INDESCALA Relevant Scale Indicator Show values
CPRB CPRB Relevance Show values
IND_NAT_FRT Freight Nature Indicator Show values
MOTDESICMSST ICMS ST Exemption Reason Show values
INDSOMACOFINSST Indicator of COFINS ST in the Nota Fiscal Total Show values
INDSOMAPISST Indicator of PIS ST in the Nota Fiscal Total Show values
NAT_BC_CRED Credit Basis Show values
Column Name Description Domain name
MAKTX Material Description TEXT40
ITMREF Reference to item number (Return) J_1BITMNUM
REFKEY Reference to source document J_1BREFKEY
REFITM Reference item to source document J_1BREFITM
NETPR Net price J_1BNFPRI
NFPRI Net Price Including Tax J_1BNFPRI
MWSKZ Tax on sales/purchases code MWSKZ
KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM
TAXSI3 Tax Situation ISS J_1BTAXSI3
TAXSI4 Tax Situation COFINS J_1BTAXSI4
TAXSI5 Tax Situation PIS J_1BTAXSI5
REFTYP_PREV Previously linked NF-e - type of source document J_1BREFTYP
REFKEY_PREV Previously linked NF-e - key of source document J_1BREFKEY
REFITM_PREV Previously linked NF-e - item of source document J_1BREFITM
NBS Brazilian Nomenclature Services code J_1BNBS
CEAN International Article Number (EAN/UPC) EAN11
XPED Purchase Order Number CHAR15
NITEMPED Purchase Order Item CHAR6
CLENQ IPI Classification for Tobacco Products and Beverages CHAR5
CSELO IPI Control Seal Code CHAR10
QSELO IPI Quantity of Control Seal DEC12
NUM_ITEM External Item Number NUMC3
COD_CTA G/L Account Number for Revenue/Expenses SAKNR
NRECOPI RECOPI Number
VICMSDESON Exemption value of ICMS
NFICMSDESON Exemption Value of ICMS Including Taxes
VICMSDIF Value of deferment ICMS J_1BNFE_RFC_VICMSDIF
MENGE_TRIB Tributary Quantity of Material
VDESPADU Customs Expense Value
VIOF IOF Value
CEAN_TRIB Tributary International Article Number (EAN/UPC) EAN11
UTRIB Tributary Unit of Measure
PST Final Consumer Rate J_1BNFE_PST
PFCPSTRET Percentage of Tributary Substitution withheld from FCP J_1BNFE_PFCPSTRET
VFCPSTRET Tributary Substitution amount withheld from FCP J_1BNFE_VFCPSTRET
CNPJFAB Producer CNPJ J_1BCGC
PREDBCEFET Reduction Percentage of Effective Calculation Basis J_1BNFE_PREDBCEFET
PICMSEFET Effective ICMS Rate J_1BNFE_PICMSEFET
VOUTRO Statistical Amount J_1BNFE_VOUTRO
XPROD Product or Service Description J_1BNFE_XPROD
TAX_INFO_SOURCE Source of Tax Burden J_1BNFSE_TAX_INFO_SOURCE
TAX_RATE Percentage of Tax Burden J_1BNFSE_TAX_RATE
VICMSSUBSTITUTO Substitute ICMS Value Charged in Previous Transaction J_1BNFE_VICMSSUBSTITUTO
MUNICIPAL_ISS_TAXSIT CST for ISS Defined by Municipality LOGBR_MUNICIPAL_ISS_TAXSIT
COD_CTA_PIS G/L Account Number for Revenue/Expenses for PIS SAKNR
COD_CTA_COFINS G/L Account Number for Revenue/Expenses for COFINS SAKNR
STSTCL_VICMSDESON Statistical Exemption Value of ICMS
P_MVAST Margin percentage of value Added from ICMS ST J_1BNFE_PMVAST
PICMSDEF Tax Rate for ICMS Deferral J_1BNFE_PICMSDEF
CBARRA Internal Barcode J_1BNFE_CBARRA
CBARRA_TRIB Internal Tributary Barcode J_1BNFE_CBARRA_TRIB
VICMSSTDESON Exemption Value of ICMS ST J_1BNFE_VICMSSTDESON
PDIF ICMS Deferral Percentage J_1BNFE_PDIF
VFCPDIF Deferred FCP Value J_1BNFE_VFCPDIF
PFCPDEF Tax Rate for FCP Deferral J_1BNFE_PFCPDEF
PFCPDIF FCP Deferral Percentage J_1BNFE_PFCPDIF
EXCLUDED_ICMS_FROM_PISCOFINS ICMS Amount Excluded from the PIS/COFINS Calculation Base J_1BNFE_EXC_ICMS_PISCOF
NFCI FCI Number
KOSTL Cost Center KOSTL
AUFNR Order Number AUFNR
PRCTR Profit Centers PRCTR
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_POSNR
KSTRG Cost Objects KSTRG
NPLNR Network Number for Account Assignment AUFNR
SEGMENT Segment for Segmental Reporting FB_SEGMENT
PIPIDEVOL Quantity Returned (%)
NPROCESSO Judicial or Administrative Process Number which Suspends ISS CHAR30
Master Data Relations Join Conditions
Valuation area
  • Valuation area
  • Client
  • J_1BNFLIN.BWKEY == T001K.BWKEY
  • J_1BNFLIN.MANDT == T001K.MANDT
Valuation Type
  • Material Number
  • Plant
  • Valuation Type
  • J_1BNFLIN.MANDT == MBEW.MANDT
  • J_1BNFLIN.MATNR == MBEW.MATNR
  • J_1BNFLIN.WERKS == MBEW.BWKEY
  • J_1BNFLIN.BWTAR == MBEW.BWTAR
State Fiscal Benefit Code
  • State Fiscal Benefit Code
  • Client
  • ?
Benefit Code for ISS Tax
  • ?
  • Client
  • Benefit Code for ISS Tax
IPI Legal Classification Code
  • IPI Legal Classification Code
  • Client
ICMS ST Legal Classification Code
CFOP Code and Extension
  • ?
  • CFOP Code and Extension
  • Client
  • J_1BNFLIN.[column in domain "J_1BCFOP_VER"] == J_1BAGN.VERSION
  • J_1BNFLIN.CFOP == J_1BAGN.CFOP
  • J_1BNFLIN.MANDT == J_1BAGN.MANDT
Batch Number
  • Material Number
  • Client
  • Batch Number
  • J_1BNFLIN.MATNR == MCH1.MATNR
  • J_1BNFLIN.MANDT == MCH1.MANDT
  • J_1BNFLIN.CHARG == MCH1.CHARG
CNAE Business Place Code
  • CNAE Business Place Code
  • Client
CNAE Code for Partner
  • CNAE Code for Partner
  • Client
Nota Fiscal Item Type
  • Nota Fiscal Item Type
  • Client
LC 116 Service Type Code
Client J_1BNFLIN.MANDT == T000.MANDT
Material Group
  • J_1BNFLIN.MANDT == T023.MANDT
  • J_1BNFLIN.MATKL == T023.MATKL
Material Number
  • Material Number
  • Client
  • J_1BNFLIN.MATNR == MARA.MATNR
  • J_1BNFLIN.MANDT == MARA.MANDT
Base unit of measure
  • J_1BNFLIN.MANDT == T006.MANDT
  • J_1BNFLIN.MEINS == T006.MSEHI
Control code for consumption taxes in foreign trade
  • Control code for consumption taxes in foreign trade
  • Client
  • ?
  • J_1BNFLIN.NBM == T604F.STEUC
  • J_1BNFLIN.MANDT == T604F.MANDT
  • J_1BNFLIN.[column in domain "LAND1"] == T604F.LAND1
Reference type J_1BNFLIN.REFTYP == J_1BAB.REFTYP
EFD-REINF Service Type Code
  • EFD-REINF Service Type Code
  • Client
Activity Number
  • J_1BNFLIN.MANDT == ASMD.MANDT
  • J_1BNFLIN.SRVNR == ASMD.ASNUM
Tax law: ICMS
Tax law: IPI
ISS Tax Law
  • ISS Tax Law
  • Client
COFINS Tax Law
PIS Tax Law
Tax situation IPI
  • J_1BNFLIN.MANDT == J_1BAS.MANDT
  • J_1BNFLIN.TAXSI2 == J_1BAS.TAXSIT
Plants
  • J_1BNFLIN.MANDT == T001W.MANDT
  • J_1BNFLIN.WERKS == T001W.WERKS