What do I have to consider for the import of addresses for business partners in Scope?

The import works via an xls file. Certain rules apply to this file, which are explained in this article.

Partner code (column A and optionally)

The first column (A) in the xls file defines the partner code in Scope, you can assign this freely. Often, 3-digit for the customer + 3-digit for the location is chosen here,
e.g. RSIDUS for Riege Software International in Düsseldorf. The code must be unique. Therefore, make sure that no duplicate codes are used in the file for the import.
Note that for debtors, this code will normally need to be repeated in column naw_acc.

Mandatory

* Columns A, B, C, E and F are mandatory fields for the import of each Partner and must be filled in.

A	B	C	D	E	F
naw_code	naw_name	naw_address	naw_pc	naw_city	naw_country
RSIDUS	Riege Software International Düsseldorf	Otto-Hahn-Str. 4	40670	Meerbusch	DE

** For the debtor role column N (naw_acc) is required. It will normally contain the same code as column A. The number of the debtor in the accounting system can be added to column O (cm_accno).

*** For the creditor role column Q (vm_accno) is required. This should also be the number of the creditor in the accounting system.

**** For the Customs roles columns T (cus_eori, for Dutch Customs), AL (cus_de_eori, for ATLAS) or AI/AJ (zaz account customs or zaz account vat for EZV) are required.

***** For the Secure Shipper role column AG (sec_kc_id) is required.

Download

Download sample file (xlsx)

Explanation of the designations/input restrictions

Legend

Max. length/restrictions: Maximum number of characters and/or any other restrictions
truncate: For free text values that probably still convey useful information even if some exceeding characters are removed, this strategy is used.
reject: For references or codes or other values that will not be understandable or even wrong if truncated, the value is rejected. The interface as whole, however, is still processed.

	Column name	Value in Scope	Max. length/restrictions	If too long /restictions don't fit
A	naw_code*	Code	12, must be unique	reject
B	naw_name*	Name	35	truncate
C	naw_address*	Default Address	last part must consist of street (max. 70), streetnumber (max. 5) and streetnumber suffix (max. 12)	reject
D	naw_pc	Postal Code of default address	9	reject
E	naw_city*	City of default address	35	truncate
F	naw_country*	Country of default address	2, ISO-3166	reject
G	naw_state	State of default address, may not be empty for a country with states	2 or 3, ISO-3166	reject
H	naw_lang	Language	2 or 4, ISO-3166 ("EN-GB" for English with European date and time formatting)	reject
I	naw_tel	Telephone	32	reject
J	naw_fax	Fax	32	reject
K	naw_email	E-Mail	64	reject
L	naw_vatno	VAT	none
M	naw_curr	Debtor Currency	3, ISO-4217	reject
N	naw_acc**	Scope Partner Code of the Master Debtor, if there is no master debtor, please enter the normal scope partner code (as in column naw_code).	12	reject
O	cm_accmo	Debtor Account Number	none
P	cm_payterm	Debtor Payment Term	12	reject
Q	vm_accno***	Creditor Account Number	none
R	vm_curr	Creditor Currency	3	reject
S	vm_payterm	Creditor Payment Term	12	reject
T	cus_eori****	Netherlands Customs Partner EORI	17	reject
U	cus_imp_repr_status	Netherlands Customs Partner Import Representation Status	must be from list "A81"	reject
V	cus_imp_repr_naw	Netherlands Customs Partner Import Fin. Representative	12	truncate
W	cus_imp_repr_from	Netherlands Customs Partner Import Valid From	dd.MM.yyyy	reject
X	cus_imp_repr_to	Netherlands Customs Partner Import Valid To	dd.MM.yyyy	reject
Y	cus_imp_repr_pay	Netherlands Customs Partner Import Payment By	Partner Code	reject
Z	cus_imp_repr_pay_meth	Netherlands Customs Partner Import Guarantee	1, must be from list "S09"	reject
AA	cus_exp_repr_status	Netherlands Customs Partner Export Representation Status	must be from list "A81"	reject
AB	cus_exp_repr_naw	Netherlands Customs Partner Export Fin. Representative	12	truncate
AC	cus_exp_repr_from	Netherlands Customs Partner Export Valid From	dd.MM.yyyy	reject
AD	cus_exp_repr_to	Netherlands Customs Partner Export Valid To	dd.MM.yyyy	reject
AE	cus_transit_cust_off	Netherlands Customs Transit Customs Office	8	truncate
AF	sec_aeo_cert	Secure Shipper AEO Certificate	must have format "AA/KC/nnnnn-nn/nnnn"	reject
AG	sec_kc_id*****	Secure Shipper ID Known shipper	63	reject
AH	sec_kc_exp_date	Secure Shipper Expiration date	dd.MM.yyyy	reject
AI	zaz account customs****	EZV Teilnehmer ZAZ-Konto Zoll	8	reject
AJ	zaz account vat****	EZV Teilnehmer ZAZ-Konto MwSt.	8	reject
AK	naw_label	Labels	1024	truncate
AL	cus_de_eori****	ATLAS EORI	must have format "DEn..7" or " an..17"	truncate
AM	cus_de_niederlassung	ATLAS Niederlassungsnummer	n4	truncate
AN	cm_invoice2printer	Debtor Print invoices	n1, either '0' for no printing or '1' for printing	default is printing enabled
AO	cus_ch_uid	UID for the Swiss Customs participant	an..17	reject
AP	info_note	User defined text will appear as a Note on the partner with priority 'medium' and visibility 'company'	4000	truncate