DaVinci address import

Revision History

Date	Version	Version	Name
25/11/2016	1.0	Initial creation	U.Levas
01/12/2016	1.1	Add fields Birthdate, BankCountryCode, BranchOffice	U.Levas
20/12/2016	1.2	Update/add fields on documentation	W.Falk

Content of the Excel Cheat

For the address import it is necessary to fill the Excel template with the corresponding data. The position of the columns must not be changed. The required fields must be filled.
*

Anker

	_GoBack
	_GoBack

Required field

A Status

Image Added

Format: Text

Supported values: Private, Firm, TravelAgency, InterestedParty, Interessent, Traveller, TourOperator, Advertising, InvoiceAddress, DeliveryAddress, SalesOffice, ServiceSupplier, TourLeader, Hotel, CarRentalStation

Example: Private

DB field:

Column name		Fields in DaVinci	Information	Example	DB field type/length
Clientnumber	B	Image Added	ONLY if former numbers should be taken over !If empty --> number is automatically created by DaVinci	100000	int
Debitor	C	Image Added	ONLY if former numbers should be taken over !If empty --> number is automatically created by DaVinci	100000	int
Creditor	D		ONLY if former numbers should be taken over !If empty --> number is automatically created by DaVinci	100000	int
Name1 ***	E	Image Added		Mustermann	nvarchar(50)
Name2	F			Max	nvarchar(50)
Title1	G		values need to match values stored in DaVinci	Herr	nvarchar(32)
Title2	H		values need to match values stored in DaVinci	Dr.	nvarchar(32)
Salutation	I		values need to match values stored in DaVinci	Sehr geehrter Herr	nvarchar(80)
Street	J			Musterstr.1	nvarchar(60)
Addition	K			App. 2a	nvarchar(32)
CountryCode	L		values need to match values stored in DaVinci	DE	nvarchar(10)
PST	M			51503	nvarchar(10)
City	N			Rösrath	nvarchar(50)
Birthdate	O			01.01.1970	datetime
Phone1_Name	P		values need to match values stored in DaVinci	Telefon	nvarchar(32)
Phone1_Value	Q			0049-2205-89640	nvarchar(100)
Phone2_Name	R		values need to match values stored in DaVinci	Telefon	nvarchar(32)
Phone2_Value	S			0111-333	nvarchar(100)
Mobile1_Name	T		values need to match values stored in DaVinci	Handy	nvarchar(32)
Mobile1_Value	U			0111-444	nvarchar(100)
Fax1_Name	V		values need to match values stored in DaVinci	Fax	nvarchar(32)
Fax1_Value	W			0049-2205-8964111	nvarchar(100)
Email1_Name	X		values need to match values stored in DaVinci	Email	nvarchar(32)
Email1_Value	Y			test@test.de	nvarchar(100)
Webaddress	Z			www.bewotec.de	nvarchar(100)
Free5	AA	Image Added		11Aa	nvarchar(150)
Free6	AB			22Bb	nvarchar(150)
TaxReg	AC	Image Added		ABC123456	nvarchar(100)
Created	AD			29.10.2014	datetime
EmployeeCode ***	AE	Image Added	value need to match with a DaVinci user	BEWO	nvarchar(10)
NoSelection	AF	Image Added	Yes = flag set	YES	bit
Code1	AG	Image Added	values need to match values stored in DaVinci	Direct client	nvarchar(20)
Mailingtype	AH	Image Added	Supported Values:0 = Letter1 = Fax2 = Email3 = Unknown	0	int
BankInstitute	AI	Image Added		Sparkasse Ort	nvarchar(32)
IBAN	AJ				nvarchar(34)
AccountNo	AK				nvarchar(40)
BankCode	AL				20
BankName	AM
SWIFTCode	AN				20
AccountOwner	AO				50
BankCountryCode	AP	Image Added		DE	10
Referencenumber	AQ			AbC123456	20
LinkedTo	AR	Image Added	client number of adress in DaVinci	123456	int
MatchCode	AS	Image Added		Mustermann	nvarchar(40)
Code2	AT		values need to match values stored in DaVinci		nvarchar(20)
EmergencyName	AU	Image Added		Hr. F. Muster	nvarchar(50)
EmergencyCountry	AV		values need to match values stored in DaVinci	CH	nvarchar(10)
EmergencyEmail	AW			fmuster@web.com	nvarchar(50)
History1	AX				nvarchar(32)
History2	AY				nvarchar(32)
History3	AZ				nvarchar(32)
History4	BA				nvarchar(32)
Language	BB	Image Added	values need to match values stored in DaVinci	EN	nvarchar(10)
BranchOffice	BC				int
PaymentType	BD		0 = Barzahlung1 = Bankeinzug2 = Rechnung3 = Kreditkarte4 = Lastschrift5 = Nachnahme6 = Scheck7 = unbekannt8 = Überweisung	1	int
PaymentTerm	BE		values need to match values stored in DaVinci		nvarchar(50)
DebtorGroup	BF		values need to match values stored in DaVinci		int
Origin	BG		0=interne Agentur1=Externe fremde Agentur 2=Externe eigene Agentur3=START Agentur	1	int
State			0=frei1=gesperrt	0	int
OptionPeriod			0 = Departure1 = Booking2 = Invoice (Invoice date) 3 = Invoice (Print date) 4 = Fix booking	1	int
OptionDays				3	int
OptionType			0 = Expires1 = Fix	0	int
OptionWorkDays			0 = deactivated1 = activated	1	bit
AgencyCollection			0=TravelAgency1=Touroperator	1	int
AgencyType			0=Touroperator1=Retailer	0	int
NoVATCommission			0 = deactivated1 = activated	1	bit
NoVATSales			0 = deactivated1 = activated	0	bit
ReceivesCommision			0 = deactivated1 = activated	1	bit
ReverseCharge			0 = deactivated1 = activated	0	bit
AutoCommission			0 = deactivated1 = activated		bit
ChainType			0 = free agency1 = Chain header2 = Chain agency	2	int
NoSales			0 = deactivated1 = activated		bit
ParentAgency1			DaVinci client number of the parent agency	110000	int
Assignment			0 = Commission1 = Statistic2 = Authorisation	1	int
AssignmentFrom			datefield DD.MM.YYYY	01.01.2009	datetime
AssignmentTo			datefield DD.MM.YYYY	31.12.2046	datetime
BookingDisplay			0 = all bookings1 = own bookings2 = chain bookings	2	nvarchar(100)
BookingChanges			0 = all bookings1 = own bookings2 = chain bookings	1	nvarchar(100)
AgencyChanges			0 = all agencies1 = no change2 = only chain agencies	1	nvarchar(100)
Attribut1			value need to match values stored in DaVinci		nvarchar(100)
CRSAgency1				540091	nvarchar(20)
CRS1			0 = CETS1=TourOnline2=Start/Amadeus3=Sabre/Merlin…12=MyJack…	0	int
CRSState1			0 = Free1 = Locked2 = Locked for new bookings3 = CMIR only 4 = Free in booking period	0	int
CRSTouroperator1			values need to match values stored in DaVinci		nvarchar(4)
CRSAgency2			see CRSAgency 1		nvarchar(20)
CRS2			see CRS1	0	int
CRSState2			see CRSSTate1	0	int
CRSTouroperator2			values need to match values stored in DaVinci		nvarchar(4)
CurrencySalesPrice1			values need to match values stored in DaVinci	CHF	nvarchar(3)
CurrencySalesPrice2			values need to match values stored in DaVinci	EUR	nvarchar(3)
CurrencySalesPrice3			values need to match values stored in DaVinci	USD	nvarchar(3)