OF Import template v4 - public template.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM
1		Contact – who will pay?																	Agreement – how much, how often and for what?														Subscription – during which period will they pay?						Payment Method – how will they pay?																	Data Set - hvilke oplysninger skal også gemmes?
2	merchant_country_code	contact_type	contact_name	first_name	last_name	birth_date	national_id	company_name	business_code	address	address2	post_code	city	country_code	msisdn	email	contact_external_id	contact_external_link	agreement_name	description	amount	currency_code	tax_deductable	schedule_type	schedule_base_tier	schedule_fixed_day	schedule_every_other	schedule_calendar_unit	schedule_selected_set	purpose_accounting_code	communication_collection_guid	agreement_external_id	origin_ts	start_date	next_due_date	expires_after_date	subscription_external_id	subscription_external_link	payment_method_type	payment_gateway_subscription_reference_id	bs_send_as_payment_slip	bs_mandate	bs_customer_number	bs_sort_code	bs_account_number	bs_guid	card_type	card_expires_ts	card_number	card_acquirer	mp_external_id	sp_vcn	dd_bank_code	dd_account_type	dd_account_number	dataset_1_key	dataset_1_value	dataset_2_key	dataset_2_value	dataset_3_key	dataset_3_value	dataset_4_key	dataset_4_value	dataset_5_key	dataset_5_value

3	Nationality of organisation	Custom field for the type of contact	Full personal name	First name	Last name	Birth date in YYYY-MM-DD	DK (CPR), IS (Kennitala)	Company name	DK (CVR), IS (Kennitala)	Street	Municipality or similar	Postal code	City	Country code (2 characters)	Phone number with prefixed country code	Email-address	Optional ID for membership number, ID in CRM or similar	Optional URL for profile in CRM or similar	Name of agreement	Description of agreement				Schedule	Month of year	Day of month	Frequency (Yearly = 12. Monthly = 1)	Calencar unit (Month, Week, Day)	Selected months (i.e. February, May, August)			Optional ID for membership number, ID in CRM or similar	Date of origin	Date of import	Date of next charge	Date of expiration	Optional ID for membership number, ID in CRM or similar	Optional URL for profile in CRM or similar		Leavy empty		BS-aftalenr.	BS-kundenr.	Reg.nr.	Kontonr.	Leave empty	Type of card	Expiration of card	Number on card	Acquirer	VippsMobilePay external ID	Teya Virtual Card Number	Arion bank code	Arion account type	Arion account number	Key1	Value1	Key2	Value2	Key3	Value3	Key4	Value4	Key5	Value5
4	DK	individual	Jens Jensen	Jens	Jensen	1980-01-01	1111111118	OnlineFundraising ApS	37273457	Finsensvej 6E, 2.		2000	Frederiksberg	DK	4511223344	email@email.dk			Medlemskab		100	DKK	true	Monthly	1	1	1	Month	[2,5,8]				2020-01-01	2026-03-23	2030-01-01	2020-01-01			Betalingsservice		false	Unikt nr. defineret af Betalingsservice	Unikt nr. defineret af organisationen	Efterlad tom med mindre anden aftale er indgået	Efterlad tom med mindre anden aftale er indgået		Dankort			NETS
5	SE	business												SE					Bidrag			EUR	false	Quarterly	2	2	2												DirectDebit		true						Visa			Teller
6	NO													NO								GBP		Halfyearly	3	3	3												MobilePaySubscriptions								MasterCard			Clearhaus
7	DE													DE								USD		Yearly	4	4	4												VippsMobilePayRecurring
8	IS													IS										Custom	5	5	5												SwishRecurring
9	GL													GL											6	6	6												Card
10	FO													FO											7	7	7												SMS
11																									8	8	8
12																									9	9	9
13																									10	10	10
14																									11	11	11
15																									12	12	12
16																										13	13
17																										14	14
18																										15	15
19																										16	16
20																										17	17
21																										18	18
22																										19
23																										20
24																										21
25																										22
26																										23
27																										24
28																										25
29																										26
30																										27
31																										28
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100