J_1BNFCPD

Nota Fiscal one-time accounts | #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
STKZU Liable for VAT Show values
STKZA Indicator: Business Partner Subject to Equalization Tax? Show values
DTAMS Report key for data medium exchange Show values
XCPDK Indicator: Is the account a one-time account? Show values
STKZN Natural Person Show values
CHCKSTATUS City file test status Show values
PO_BOX_NUM Flag: PO Box Without Number Show values
IPICONTRIBUTOR IPI Contributor - OTC Show values
ICMSCONTRIBUTOR ICMS Contributor - OTC Show values
PISCONTRIBUTOR PIS Contributor - OTC Show values
COFINSCONTRIBUTOR COFINS Contributor - OTC Show values
ISSCONTRIBUTOR ISS Contributor - OTC Show values
ICMSSTCONTRIBUTOR ICMS ST Contributor - OTC Show values
CRTN CRT Number Show values
Column Name Description Domain name
NAME1 Name 1 NAME
NAME2 Name 2 NAME
NAME3 Name 3 NAME
NAME4 Name 4 NAME
PSTLZ Postal Code PSTLZ
ORT01 City TEXT35
STRAS Street and House Number TEXT35
PFACH PO Box PFACH
PSTL2 P.O. Box Postal Code PSTLZ
PSKTO PO Bank Current Acct No. or Building Society Ref. No. PSKTO
BANKN Bank account number BANKN
BANKL Bank Keys BANKK
STCD1 Tax Number 1 STCD1
STCD2 Tax Number 2 STCD2
BKONT Bank Control Key BKONT
EMPFG Payment Recipient Code EMPFG
J_1BSTAINS State Tax Number J_1BSTAINS
J_1BMUNINS Municipal Tax Number J_1BMUNINS
NAME_CO c/o name TEXT40
CITY1 City TEXT40
CITY2 District TEXT40
HOME_CITY City (different from postal city) TEXT40
POST_CODE1 City postal code CHAR10
POST_CODE2 PO Box Postal Code CHAR10
POST_CODE3 Company Postal Code (for Large Customers) CHAR10
PCODE1_EXT (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code CHAR10
PCODE2_EXT (Not Supported) PO Box Postal Code Extension CHAR10
PCODE3_EXT (Not Supported) Major Customer Postal Code Extension CHAR10
PO_BOX PO Box CHAR10
PO_BOX_LOC PO Box city TEXT40
POSTALAREA (Not Supported) Post Delivery District TEXT15
STREET Street TEXT60
HOUSE_NUM1 House Number TEXT10
HOUSE_NUM2 House number supplement TEXT10
HOUSE_NUM3 (Not supported) House Number Range TEXT10
STR_SUPPL1 Street 2 TEXT40
STR_SUPPL2 Street 3 TEXT40
STR_SUPPL3 Street 4 TEXT40
LOCATION Street 5 TEXT40
BUILDING Building (Number or Code) TEXT20
FLOOR Floor in building TEXT10
ROOMNUMBER Room or Apartment Number TEXT10
SORT1 Search Term 1 TEXT20
SORT2 Search Term 2 TEXT20
SORT_PHN (Not Supported) Phonetic Search Sort Field CHAR20
EXTENSION1 Extension (only for data conversion) (e.g. data line) TEXT40
EXTENSION2 Extension (only for data conversion) (e.g. telebox) TEXT40
TAXJURCODE Tax Jurisdiction AD_TXJCD
ADDRESS_ID (Not supported) Physical address ID AD_ADDR_ID
REMARK Address notes TEXT50
PO_BOX_LOBBY PO Box Lobby TEXT40
DELI_SERV_NUMBER Number of Delivery Service CHAR10
COUNTY County TEXT40
TOWNSHIP Township TEXT40
TEL_NUMBER First telephone no.: dialling code+number CHAR30
TEL_EXTENS First Telephone No.: Extension CHAR10
FAX_NUMBER First Fax No.: Area Code + Number CHAR30
FAX_EXTENS First fax no.: extension CHAR10
SUFRAMA Suframa Code J_1BSUFRAMA
Master Data Relations Join Conditions
Address source
  • J_1BNFCPD.MANDT == TSAD6.CLIENT
  • J_1BNFCPD.ADDRORIGIN == TSAD6.ORIGIN
Country/Region Key of Bank
  • Country/Region Key of Bank
  • Client
  • J_1BNFCPD.BANKS == T005.LAND1
  • J_1BNFCPD.MANDT == T005.MANDT
Different city for city/street file
  • Country/Region Key
  • Client
  • Different city for city/street file
  • J_1BNFCPD.COUNTRY == ADRCITY.COUNTRY
  • J_1BNFCPD.MANDT == ADRCITY.CLIENT
  • J_1BNFCPD.CITYH_CODE == ADRCITY.CITY_CODE
City code for city/street file
  • Country/Region Key
  • Client
  • City code for city/street file
  • J_1BNFCPD.COUNTRY == ADRCITY.COUNTRY
  • J_1BNFCPD.MANDT == ADRCITY.CLIENT
  • J_1BNFCPD.CITY_CODE == ADRCITY.CITY_CODE
City PO box code (City file)
  • Country/Region Key
  • Client
  • City PO box code (City file)
  • J_1BNFCPD.COUNTRY == ADRCITY.COUNTRY
  • J_1BNFCPD.MANDT == ADRCITY.CLIENT
  • J_1BNFCPD.CITY_CODE2 == ADRCITY.CITY_CODE
CNAE
  • CNAE
  • Client
Country Indic.
  • Country/Region Key
  • Client
  • J_1BNFCPD.COUNTRY == T005.LAND1
  • J_1BNFCPD.MANDT == T005.MANDT
County code for county
  • PO Box of Country/Region
  • Region for PO Box (Country/Region, State, Province, ...)
  • Client
  • County code for county
Type of Delivery Service
  • Type of Delivery Service
  • Client
Non-Delivery Reason
  • J_1BNFCPD.MANDT == TSAD12.CLIENT
  • J_1BNFCPD.DONT_USE_P == TSAD12.UNDELIVER
Non-Delivery Reason
  • J_1BNFCPD.MANDT == TSAD12.CLIENT
  • J_1BNFCPD.DONT_USE_S == TSAD12.UNDELIVER
Instruction Key for Data Medium Exchange
  • Country/Region Key of Bank
  • Instruction Key for Data Medium Exchange
  • Client
  • ?
  • J_1BNFCPD.BANKS == T015W.BANKS
  • J_1BNFCPD.DTAWS == T015W.DTAWS
  • J_1BNFCPD.MANDT == T015W.MANDT
  • J_1BNFCPD.[column in domain "DZLSCH"] == T015W.ZLSCH
ICMS Taxpayer
Country/Region Key
  • Country/Region Key
  • Client
  • J_1BNFCPD.LAND1 == T005.LAND1
  • J_1BNFCPD.MANDT == T005.MANDT
Language key J_1BNFCPD.LANGU == T002.SPRAS
Address record creation original language J_1BNFCPD.LANGU_CREA == T002.SPRAS
Legal Nature
Client J_1BNFCPD.MANDT == T000.MANDT
Nota Fiscal Partner Function
  • J_1BNFCPD.MANDT == J_1BAD.MANDT
  • J_1BNFCPD.PARVW == J_1BAD.PARVW
PO Box of Country/Region
  • PO Box of Country/Region
  • Client
  • J_1BNFCPD.PO_BOX_CTY == T005.LAND1
  • J_1BNFCPD.MANDT == T005.MANDT
Region for PO Box (Country/Region, State, Province, ...)
  • PO Box of Country/Region
  • Region for PO Box (Country/Region, State, Province, ...)
  • J_1BNFCPD.MANDT == T005S.MANDT
  • J_1BNFCPD.PO_BOX_CTY == T005S.LAND1
  • J_1BNFCPD.PO_BOX_REG == T005S.BLAND
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • J_1BNFCPD.MANDT == T005S.MANDT
  • J_1BNFCPD.LAND1 == T005S.LAND1
  • J_1BNFCPD.REGIO == T005S.BLAND
Regional structure grouping
Region key
  • Country/Region Key
  • Region (State, Province, County)
  • J_1BNFCPD.MANDT == T005S.MANDT
  • J_1BNFCPD.COUNTRY == T005S.LAND1
  • J_1BNFCPD.REGION == T005S.BLAND
Language Key J_1BNFCPD.SPRAS == T002.SPRAS
(Not Supported) Abbreviation of Street Name
  • Country/Region Key
  • (Not Supported) Abbreviation of Street Name
Street Number for City/Street File
  • Country/Region Key
  • Street Number for City/Street File
Tax Declaration Type
Address time zone
  • J_1BNFCPD.MANDT == TTZZ.CLIENT
  • J_1BNFCPD.TIME_ZONE == TTZZ.TZONE
Township code for Township
  • Region for PO Box (Country/Region, State, Province, ...)
  • County code for county
  • PO Box of Country/Region
  • Township code for Township
Transportation zone
  • Country/Region Key
  • Client
  • Transportation zone to or from which the goods are delivered
  • J_1BNFCPD.COUNTRY == TZONE.LAND1
  • J_1BNFCPD.MANDT == TZONE.MANDT
  • J_1BNFCPD.TRANSPZONE == TZONE.ZONE1
Other Relations | to Master Data Relations ↑ Join Conditions
District code for City and Street file
  • Country/Region Key
  • City code for city/street file
  • District code for City and Street file