J_1BNFNAD

Nota Fiscal partners | #transactional | #language | Component: Logistics Brazil
Column Name Description
MANDT FK Client
DOCNUM FK Document Number
PARVW FK Nota Fiscal Partner Function
Column Name Description
Column Name Description
Column Name Description
Column Name Description
PARTYP Nota Fiscal Partner Type Show values
XCPDK Indicator: Is the account a one-time account? Show values
INDUST Customer's CFOP category Show values
STKZN Natural Person Show values
IND_IEDEST NF-e State Tax Number Indicator Show values
CTE_PARTNER CT-e Partner in Fiscal Document Show values
PARTNER_ROLE NF Partner Place Type Show values
Column Name Description Domain name
PARID Partner ID (Customer, Vendor, Business Place) J_1BPARID
ANRED Title TEXT15
NAME1 Name 1 NAME
NAME2 Name 2 NAME
NAME3 Name 3 NAME
NAME4 Name 4 NAME
STRAS Street and House Number TEXT35
ORT01 City TEXT35
ORT02 District TEXT35
PSTLZ Postal Code PSTLZ
PFACH PO Box PFACH
PSTL2 P.O. Box Postal Code PSTLZ
SORTL Sort field CHAR10
TELF1 Addresses: telephone no. TEXT30
TELFX Fax Number TEXT31
TELTX Teletex number TEXT30
TELX1 Telex number TEXT30
CGC CNPJ Number J_1BCGC
CPF CPF number J_1BCPF
STAINS State Tax Number J_1BSTAINS
MUNINS Municipal Tax Number J_1BMUNINS
HAUSN House number CHAR6
STOCK Floor STOCK
STREET Street TEXT60
HOUSE_NUM1 House Number TEXT10
HOUSE_NUM2 House number supplement TEXT10
FOREIGNID NF-e Partner Foreign ID J_1BNFE_FOREIGNID
SMTP_ADDR E-Mail Address AD_SMTPADR
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Client
  • J_1BNFNAD.LAND1 == T005.LAND1
  • J_1BNFNAD.MANDT == T005.MANDT
Client J_1BNFNAD.MANDT == T000.MANDT
Nota Fiscal Partner Function
  • J_1BNFNAD.MANDT == J_1BAD.MANDT
  • J_1BNFNAD.PARVW == J_1BAD.PARVW
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • J_1BNFNAD.MANDT == T005S.MANDT
  • J_1BNFNAD.LAND1 == T005S.LAND1
  • J_1BNFNAD.REGIO == T005S.BLAND
Language Key J_1BNFNAD.SPRAS == T002.SPRAS
Tax Jurisdiction
  • ?
  • Tax Jurisdiction
  • J_1BNFNAD.MANDT == TTXJ.MANDT
  • J_1BNFNAD.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • J_1BNFNAD.TXJCD == TTXJ.TXJCD