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

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

Debitor

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 ***

E

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

11Aa

nvarchar(150)

Free6

AB

22Bb

nvarchar(150)

TaxReg

AC

ABC123456

nvarchar(100)

Created

AD

29.10.2014

datetime

EmployeeCode ***

AE

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

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)

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…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)