...
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
...
...
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.
*
Required field Anker _GoBack _GoBack
A Status
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 |
| ONLY if former numbers should be taken over !If empty --> number is automatically created by DaVinci | 100000 | int | ||
DebtorDebitor | C |
| 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 *** | XE |
|
| 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 | nvarchar(32) | |||
Email1_Value | Y |
|
| test@test.de | nvarchar(100) | ||
Webaddress | Z | |
| www.bewotec.de | nvarchar(100) | ||
Free5 | AA |
|
| 11Aa | nvarchar(150) | ||
Free6 | AB |
|
| 22Bb | nvarchar(150) | ||
TaxReg | AC |
|
| ABC123456 | nvarchar(100) | ||
Created | AD |
|
| 29.10.2014 | datetime | ||
EmployeeCode *** | XAE |
| value need to match with a DaVinci user | BEWO | nvarchar(10) | ||
NoSelection | AF |
| Yes = flag set | YES | bit | ||
Code1 | AG |
| values need to match values stored in DaVinci | Direct client | nvarchar(20) | ||
Mailingtype | AH |
| Supported Values:0 = Letter1 = Fax2 = Email3 = Unknown | 0 | int | ||
BankInstitute | AI |
|
| Sparkasse Ort | nvarchar(32) | ||
IBAN | AJ |
|
|
| nvarchar(34) | ||
AccountNo | AK |
|
|
| nvarchar(40) | ||
BankCode | AL |
|
|
| 20 | ||
BankName | AM |
|
|
| 20 | ||
SWIFTCode | AN |
|
|
| 20 | ||
AccountOwner | AO |
|
|
| 50 | ||
BankCountryCode | AP |
|
| DE | 10 | ||
Referencenumber | AQ |
|
|
| AbC123456 | 20 | |
LinkedTo | AR |
| client number of adress in DaVinci | 123456 | int | ||
MatchCode | AS |
|
| Mustermann | nvarchar(40) | ||
Code2 | AT |
| values need to match values stored in DaVinci |
| nvarchar(20) | ||
EmergencyName | AU |
|
| 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) | _GoBack | _GoBack|
History1 | AX |
|
|
| nvarchar(32) | ||
History2 | AY |
|
|
| nvarchar(32) | ||
History3 | AZ |
|
|
| nvarchar(32) | ||
History4 | BA |
|
|
| nvarchar(32) | ||
Language | BB |
| 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… 12Merlin…12=MyJack… | 0 | int | ||
CRSState1 |
|
| 0 = Free1 = Locked2 = Locked for new bookings3 = CMIR only4 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) |
