Seitenvergleich

Column name

Required field

Information

Example

DB field type/length

Status

X

Image Added

Supported values:PrivateFirm TravelAgency InterestedParty Interessent Traveller TourOperatorAdvertising InvoiceAddress DeliveryAddress SalesOffice ServiceSupplier TourLeaderHotel CarRentalStation

Private

100

Clientnumber

Image Added

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

Image Added

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

Image Added

www.bewotec.de

100

Free5

Image Added

11Aa

150

Free6

22Bb

150

TaxReg

Image Added

ABC123456

100

Created

29.10.2014

datetime

EmployeeCode

X

Image Added

value need to match with a DaVinci user

BEWO

10

NoSelection

Image Added

Yes = flag set

YES

bit

Code1

Image Added

values need to match values stored in DaVinci

Direct client

20

Mailingtype

Supported Values:0 = Letter1 = Fax2 = Email3 = Unknown

0

int

BankInstitute

Image Added

Sparkasse Ort

32

IBAN

34

AccountNo

40

BankCode

20

SWIFTCode

20

AccountOwner

50

BankCountryCode

DE

10

Referencenumber

Image Added

AbC123456

20

LinkedTo

client number of adress in DaVinci

123456

int

MatchCode

Image Added

Mustermann

nvarchar(40)

Code2

values need to match values stored in DaVinci

nvarchar(20)

EmergencyName

Image Added

Hr. F. Muster

nvarchar(50)

EmergencyCountry

values need to match values stored in DaVinci

CH

nvarchar(10)

EmergencyEmail

fmuster@web.com

nvarchar(50)

nvarchar(32)

History2

nvarchar(32)

History3

nvarchar(32)

History4

nvarchar(32)

Language

Image Added

values need to match values stored in DaVinci

EN

nvarchar(10)

BranchOffice

Image Added

int

PaymentType

Image Added

0 = Barzahlung1 = Bankeinzug2 = Rechnung3 = Kreditkarte4 = Lastschrift5 = Nachnahme6 = Scheck7 = unbekannt8 = Überweisung

1

int

PaymentTerm

values need to match values stored in DaVinci

nvarchar(50)

DebtorGroup

Image Added

values need to match values stored in DaVinci

int

Origin

Image Added

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

Image Added

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

Image Added

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

Image Added

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

Image Added

value need to match values stored in DaVinci

nvarchar(100)

CRSAgency1

Image Added

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

Image Added

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)