J_1BNFCPD - Nota Fiscal one-time accounts

Nota Fiscal one-time accounts information is stored in SAP table J_1BNFCPD.
It is part of development package J1BA in software component FI-LOC-LO-BR. This development package consists of objects that can be grouped under "Localization Brazil".

Fields for table J_1BNFCPD

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
DOCNUM	Document Number	X	J_1BDOCNUM	NUMC	20	J_1BNFDOC
PARVW	Nota Fiscal Partner Function	X	J_1BPARVW	CHAR	4	J_1BAD
NAME1	Name 1		NAME1_GP	CHAR	70
NAME2	Name 2		NAME2_GP	CHAR	70
NAME3	Name 3		NAME3_GP	CHAR	70
NAME4	Name 4		NAME4_GP	CHAR	70
PSTLZ	Postal Code		PSTLZ	CHAR	20
ORT01	City		ORT01_GP	CHAR	70
LAND1	Country/Region Key		LAND1_GP	CHAR	6	T005
STRAS	Street and House Number		STRAS_GP	CHAR	70
PFACH	PO Box		PFACH	CHAR	20
PSTL2	P.O. Box Postal Code		PSTL2	CHAR	20
PSKTO	PO Bank Current Acct No. or Building Society Ref. No.		PSKTO	CHAR	32
BANKN	Bank account number		BANKN	CHAR	36
BANKL	Bank Keys		BANKK	CHAR	30
BANKS	Country/Region Key of Bank		BANKS	CHAR	6	T005
STCD1	Tax Number 1		STCD1	CHAR	32
STCD2	Tax Number 2		STCD2	CHAR	22
STKZU	Liable for VAT		STKZU	CHAR	2
STKZA	Indicator: Business Partner Subject to Equalization Tax?		STKZA	CHAR	2
REGIO	Region (State, Province, County)		REGIO	CHAR	6	T005S
BKONT	Bank Control Key		BKONT	CHAR	4
DTAWS	Instruction Key for Data Medium Exchange		DTAWS	CHAR	4	T015W
DTAMS	Report key for data medium exchange		DTAMS	CHAR	2
XCPDK	Indicator: Is the account a one-time account?		XCPDK	CHAR	2
EMPFG	Payment Recipient Code		EMPFG	CHAR	32
SPRAS	Language Key		SPRAS	LANG	2	T002
.INCLUDE				J_1BBSEC	0
STKZN	Natural Person		STKZN	CHAR	2
J_1BSTAINS	State Tax Number		J_1BSTAINS	CHAR	36
J_1BMUNINS	Municipal Tax Number		J_1BMUNINS	CHAR	40
.INCLUDE				ADRC_STRUC	0
NAME_CO	c/o name		AD_NAME_CO	CHAR	80
CITY1	City		AD_CITY1	CHAR	80
CITY2	District		AD_CITY2	CHAR	80
CITY_CODE	City code for city/street file		AD_CITYNUM	CHAR	24	ADRCITY
CITYP_CODE	District code for City and Street file		AD_CITYPNM	CHAR	16	ADRCITYPRT
HOME_CITY	City (different from postal city)		AD_CITY3	CHAR	80
CITYH_CODE	Different city for city/street file		AD_CITYHNM	CHAR	24	ADRCITY
CHCKSTATUS	City file test status		AD_CHECKST	CHAR	2
REGIOGROUP	Regional structure grouping		REGIOGROUP	CHAR	16	ADRREGGRP
POST_CODE1	City postal code		AD_PSTCD1	CHAR	20
POST_CODE2	PO Box Postal Code		AD_PSTCD2	CHAR	20
POST_CODE3	Company Postal Code (for Large Customers)		AD_PSTCD3	CHAR	20
PCODE1_EXT	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code		AD_PST1XT	CHAR	20
PCODE2_EXT	(Not Supported) PO Box Postal Code Extension		AD_PST2XT	CHAR	20
PCODE3_EXT	(Not Supported) Major Customer Postal Code Extension		AD_PST3XT	CHAR	20
PO_BOX	PO Box		AD_POBX	CHAR	20
DONT_USE_P	PO Box Address Undeliverable Flag		AD_NO_USEP	CHAR	8	TSAD12
PO_BOX_NUM	Flag: PO Box Without Number		AD_POBXNUM	CHAR	2
PO_BOX_LOC	PO Box city		AD_POBXLOC	CHAR	80
CITY_CODE2	City PO box code (City file)		AD_CIT2NUM	CHAR	24	ADRCITY
PO_BOX_REG	Region for PO Box (Country/Region, State, Province, ...)		AD_POBXREG	CHAR	6	T005S
PO_BOX_CTY	PO Box of Country/Region		AD_POBXCTY	CHAR	6	T005
POSTALAREA	(Not Supported) Post Delivery District		AD_PSTLAR	CHAR	30
TRANSPZONE	Transportation zone to or from which the goods are delivered		LZONE	CHAR	20	TZONE
STREET	Street		AD_STREET	CHAR	120
DONT_USE_S	Street Address Undeliverable Flag		AD_NO_USES	CHAR	8	TSAD12
STREETCODE	Street Number for City/Street File		AD_STRNUM	CHAR	24	ADRSTREET
STREETABBR	(Not Supported) Abbreviation of Street Name		AD_STRABBR	CHAR	4	ADRSTRTYPE
HOUSE_NUM1	House Number		AD_HSNM1	CHAR	20
HOUSE_NUM2	House number supplement		AD_HSNM2	CHAR	20
HOUSE_NUM3	(Not supported) House Number Range		AD_HSNM3	CHAR	20
STR_SUPPL1	Street 2		AD_STRSPP1	CHAR	80
STR_SUPPL2	Street 3		AD_STRSPP2	CHAR	80
STR_SUPPL3	Street 4		AD_STRSPP3	CHAR	80
LOCATION	Street 5		AD_LCTN	CHAR	80
BUILDING	Building (Number or Code)		AD_BLDNG	CHAR	40
FLOOR	Floor in building		AD_FLOOR	CHAR	20
ROOMNUMBER	Room or Apartment Number		AD_ROOMNUM	CHAR	20
COUNTRY	Country/Region Key		LAND1	CHAR	6	T005
LANGU	Language Key		SPRAS	LANG	2	T002
REGION	Region (State, Province, County)		REGIO	CHAR	6	T005S
SORT1	Search Term 1		AD_SORT1UL	CHAR	40
SORT2	Search Term 2		AD_SORT2UL	CHAR	40
SORT_PHN	(Not Supported) Phonetic Search Sort Field		AD_SRTPHN	CHAR	40
ADDRORIGIN	(Not Supported) Address Data Source (Key)		AD_ORIGINA	CHAR	8	TSAD6
EXTENSION1	Extension (only for data conversion) (e.g. data line)		AD_EXTENS1	CHAR	80
EXTENSION2	Extension (only for data conversion) (e.g. telebox)		AD_EXTENS2	CHAR	80
TIME_ZONE	Address time zone		AD_TZONE	CHAR	12	TTZZ
TAXJURCODE	Tax Jurisdiction		AD_TXJCD	CHAR	30
ADDRESS_ID	(Not supported) Physical address ID		AD_ADDR_ID	CHAR	20
REMARK	Address notes		AD_REMARK1	CHAR	100
LANGU_CREA	Address record creation original language		AD_LANGUCR	LANG	2	T002
PO_BOX_LOBBY	PO Box Lobby		AD_PO_BOX_LBY	CHAR	80
DELI_SERV_TYPE	Type of Delivery Service		AD_DELIVERY_SERVICE_TYPE	CHAR	8	ADDRC_DELI_SERV
DELI_SERV_NUMBER	Number of Delivery Service		AD_DELIVERY_SERVICE_NUMBER	CHAR	20
COUNTY_CODE	County code for county		AD_CNTYNUM	CHAR	16	ADRCOUNTY
COUNTY	County		AD_COUNTY	CHAR	80
TOWNSHIP_CODE	Township code for Township		AD_TWSHPNUM	CHAR	16	ADRTOWNSHIP
TOWNSHIP	Township		AD_TOWNSHIP	CHAR	80
TEL_NUMBER	First telephone no.: dialling code+number		AD_TLNMBR1	CHAR	60
TEL_EXTENS	First Telephone No.: Extension		AD_TLXTNS1	CHAR	20
FAX_NUMBER	First Fax No.: Area Code + Number		AD_FXNMBR1	CHAR	60
FAX_EXTENS	First fax no.: extension		AD_FXXTNS1	CHAR	20
.INCLUDE				LOGBR_OTC	0
IPICONTRIBUTOR	IPI Contributor - OTC		LOGBR_IPICONTRIB_OTC	CHAR	2
ICMSCONTRIBUTOR	ICMS Contributor - OTC		LOGBR_ICMSCONTRIB_OTC	CHAR	2
PISCONTRIBUTOR	PIS Contributor - OTC		LOGBR_PISCONTRIB_OTC	CHAR	2
COFINSCONTRIBUTOR	COFINS Contributor - OTC		LOGBR_COFINSCONTRIB_OTC	CHAR	2
ISSCONTRIBUTOR	ISS Contributor - OTC		LOGBR_ISSCONTRIB_OTC	CHAR	2
ICMSSTCONTRIBUTOR	ICMS ST Contributor - OTC		LOGBR_ICMSSTCONTRIB_OTC	CHAR	2
SUFRAMA	Suframa Code		J_1BSUFRAMA	CHAR	18
CNAE	CNAE		J_1BCNAE	CHAR	14	J_1BTCNAE
LEGALNAT	Legal Nature		J_1BLEGALNAT	NUMC	8	J_1BTLEGALNAT
CRTN	CRT Number		J_1BCRTN	CHAR	2
ICMSTAXPAY	ICMS Taxpayer		J_1BICMSTAXPAY	CHAR	4	J_1BTICMSTAXPAY
TDT	Tax Declaration Type		J_1BTDT	CHAR	4	J_1BTTDT