Functional_Documentation_DaVinci_AddressImport

Column name	Required field	Information	Example	DB field type/length
Status	X	Supported values:PrivateFirm TravelAgency InterestedParty Interessent Traveller TourOperatorAdvertising InvoiceAddress DeliveryAddress SalesOffice ServiceSupplier TourLeaderHotel CarRentalStation	Private	100
Clientnumber		ONLY if former numbers should be taken over !If empty --> number is automatically created by DaVinci	100000	int
Debtor		ONLY if former numbers should be taken over !If empty --> number is automatically created by DaVinci	100000	int
Creditor		ONLY if former numbers should be taken over !If empty --> number is automatically created by DaVinci	100000	int
Name1	X		Mustermann	50
Name2			Max	50
Title1		values need to match values stored in DaVinci	Herr	32
Title2		values need to match values stored in DaVinci	Dr.	32
Salutation		values need to match values stored in DaVinci	Sehr geehrter Herr	80
Street			Musterstr.1	60
Addition			App. 2a	32
CountryCode		values need to match values stored in DaVinci	DE	10
PST			51503	10
City			Rösrath	50
Birthdate			01.01.1970	datetime
Phone1_Name		values need to match values stored in DaVinci	Telefon	32
Phone1_Value			0049-2205-89640	100
Phone2_Name		values need to match values stored in DaVinci	Telefon	32
Phone2_Value			0111-333	100
Mobile1_Name		values need to match values stored in DaVinci	Handy	32
Mobile1_Value			0111-444	100
Fax1_Name		values need to match values stored in DaVinci	Fax	32
Fax1_Value			0049-2205-8964111	100
Email1_Name		values need to match values stored in DaVinci	Email	32
Email1_Value			test@test.de	100
Webaddress			www.bewotec.de	100
Free5			11Aa	150
Free6			22Bb	150
TaxReg			ABC123456	100
Created			29.10.2014	datetime
EmployeeCode	X	value need to match with a DaVinci user	BEWO	10
NoSelection		Yes = flag set	YES	bit
Code1		values need to match values stored in DaVinci	Direct client	20
Mailingtype		Supported Values:0 = Letter1 = Fax2 = Email3 = Unknown	0	int
BankInstitute			Sparkasse Ort	32
IBAN				34
AccountNo				40
BankCode				20
SWIFTCode				20
AccountOwner				50
BankCountryCode			DE	10
Referencenumber			AbC123456	20
LinkedTo		client number of adress in DaVinci	123456	int
MatchCode			Mustermann	nvarchar(40)
Code2		values need to match values stored in DaVinci		nvarchar(20)
EmergencyName			Hr. F. Muster	nvarchar(50)
EmergencyCountry		values need to match values stored in DaVinci	CH	nvarchar(10)
EmergencyEmail			fmuster@web.com	nvarchar(50)
History1				nvarchar(32)
History2				nvarchar(32)
History3				nvarchar(32)
History4				nvarchar(32)
Language		values need to match values stored in DaVinci	EN	nvarchar(10)
BranchOffice				int
PaymentType		0 = Barzahlung1 = Bankeinzug2 = Rechnung3 = Kreditkarte4 = Lastschrift5 = Nachnahme6 = Scheck7 = unbekannt8 = Überweisung	1	int
PaymentTerm		values need to match values stored in DaVinci		nvarchar(50)
DebtorGroup		values need to match values stored in DaVinci		int
Origin		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 only4 = 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)