No.

Field name

Position

Length

Description

Field exported by our system

1

Version No.

1

2

Field value is fixed: 02

Y

2

Time Stamp

3

14

Current time in format : yyyyMMddhhmmss (year, month, day, hour, minutes, seconds)

Y

3

Local Time Difference Prefix (Sign)

17

1

Local time difference prefix (sign): Field value is configurable per client: e.g. +

Y

4

Local Time Difference

18

2

Local time difference in hours. Field value is configurable per client: e.g. 00

Y

5

Start Agency No.

20

6

Field value is configurable per client: e.g. 019309

Y

6

Start Business Unit No.

26

3

Field value is configurable per client: e.g. 012

Y

7

Start Terminal Number

29

3

Field value is configurable per client: e.g. 001

Y

8

Production Indicator

32

1

Field value is fixed: P

Y

9

Country Indicator

33

3

Field value is configurable per client: e.g. D (Deutschland)

Y

10

Src Agency No.

36

6

Field value is configurable per client: e.g. 019309

Y

11

Src Business Unit No.

42

3

Field value is configurable per client: e.g. 012

Y

12

Src-Codeplan

45

3

Field value is fixed: C

Y

13

Src Sign

48

3

14

Mrc Sign

51

3

15

Version No. Of Data Structure

54

2

Field value is fixed: 04

Y

16

Data Structure

56

3

Field value is fixed: 4

Y

17

Document Counter Indicator

59

1

Field value is fixed: R (invoice)

Y

18

Sales Document (Invoice) Number

60

8

Contains invoice number related with this export

Y

19

Following Number

68

4

Line position in document file. i.e: 1 for first line, 2 for second etc.

Y

20

Information-Bit (Has Sales Document Been Printed?)

72

1

Field value is fixed: J

Y

21

Form Of Payment

73

2

22

Pcs Office Delivery

75

1

Field value is fixed: N

Y

23

Counterentry-Info

76

1

24

Filler

77

6

25

Document Request

83

1

Requested document type. Field value is fixed: R for line that contains new service(e.g. new booking) and G for line that contains modifications of existing service (e.g. cancellation). Please notice that cancellation of non or partially refundable bookings is concerned like modifying existing booking (G) and creation of new service with specified amount (R)

Y

26

Document Date

84

8

Contains the date of issue of the printed document in format: ddMMyyy

Y

27

Issuing Agent Id

92

4

Contains personal ID of the travel agent, who made the booking. Field value is configurable per client e.g: 9998

Y

28

Barcode

96

2

29

Customer Profile

98

1

30

Customer Id (Kd-Nr)

99

6

Contains number of agency which made the booking

Y

31

Customer.P. Number (Kdp-Nr)

105

5

32

Customer Name 1 (Kd Name 1)

110

30

Contains name of agency which made the booking

Y

33

Customer Name 2 (Kd Name 2)

140

30

34

Type Of Address (Adressart)

170

1

35

Customer Street (Kd Strasse)

171

30

Contains part of address (street) of agency which made the booking

Y

36

Customer Zip Code (Kd-Plz)

201

9

Contains part of address (ZIP code) of agency which made the booking

Y

37

Customer City (Kd-Ort)

210

26

Contains part of address (city) of agency which made the booking

Y

38

Ordered By-Number (Besteller-Nr)

236

5

39

Ordered By-Name (Besteller Name)

241

30

Person who paid for booking (responsible person)

Y

40

Traveller-Number (Reisender-Nr)

271

5

For hotel field value is fixed: 1

Y

41

Traveller Name (Reisender Name)

276

30

First guest (agency booking) or responsible person name in format LASTNAME/FIRSTNAME

Y

42

Customer Cost Center - Ccp (Kundenkostenstelle)

306

15

43

Ccp Printed (Kks Gedruckt)

321

1

Field value is fixed: N

Y

44

Projectnumber (Projektnummer)

322

15

Information field. Field value is configurable per client: e.g may contain shopping card id

Y

45

Projectnumber Printed (" Projektnr. Gedruckt )

337

1

Field value is fixed: N

Y

46

Employee Number (Personalnummer)

338

20

47

Employee -Number Printed ( P-Nummer Gedruckt )

358

1

Field value is fixed: N

Y

48

Remark 1 (Bemerkung 1)

359

20

49

Remark 1 Printed ( Bemerkung 1 Gedruckt )

379

1

Field value is fixed: N

Y

50

Remark 2 (Bemerkung 2)

380

20

51

Remark 2 Printed ( Bemerkung 2 Gedruckt )

400

1

Field value is fixed: N

Y

52

Other Agency (Fremd-Argentur)

401

6

53

Other Business Unit (Fremd-Betriebsstelle)

407

3

54

Balance (Auszifferung)

410

10

If export concerns cancellation of existing booking, this field contains number of invoice issued for booking transaction.

Y

55

Date Of Travel (Reisedatum)

420

8

Start date of travel in format ddMMyyyy

Y

56

Date Of Order (Auftragsdatum)

428

8

57

Contra Account (Gegen Konto)

436

10

58

Consolidation (Konsolidierung)

446

3

59

Total Amount (Gesamtbetrag)

449

18

Contains the accumulated value of the whole document (sum of all UNIT PRICE values with corresponding PREFIX of UNIT PRICE). This field is only filled in the last line of the document

Y

60

Bu Currency Indicator ( Bst-Währungskennzeichen )

467

3

Contains a valid currency ISO-Code. Field value is fixed: EUR

Y

61

Display Currency Indicator ( Darstellungs-Währungskennzeichen )

470

3

Contains a valid currency ISO-Code. Field value is fixed: EUR

Y

62

Denominal Currency Indicator ( Denominal-Währungskennzeichen )

473

3

Contains a valid currency ISO-Code. Field value is fixed: EUR

Y

63

Denominal Total Amount ( Denominal-Gesamtbetrag )

476

18

64

Filler

494

2

65

Stored Accounting Segment /Acc (Gespeicherte Bhp)

496

1

Field value is fixed: 1

Y

66

Servicecode (Leistungscode)

497

4

Service code of the accounting segment. Field value is configurable per hotel provider: e.g. 1771 for GTA

Y

67

Service Designation (Leistungsbezeichnung)

501

18

Human readable description of service code. Field value is fixed for net value: Einkauf

Y

68

Document Number (Dokumenten)

519

20

Contains reservation number in provider system

Y

69

Number (Anzahl)

539

2

Field value is fixed: 01

Y

70

Unit Price (Einzelpreis)

541

18

Contains unit price in EUR without period and comma e.g.: 123.45 EUR will be visible as 000000000000012345

Y

71

Line Price (Zeilenpreis)

559

18

Contains calculated value in EUR of the total amount of the serviceline. (UNIT PRICE * NUMBER)

Y

72

Original Unit Price ( Original-Einzelpreis )

577

18

Contains unit price in EUR without period and comma e.g.: 123.45 EUR will be visible as 000000000000012345

Y

73

Original Line Price ( Original-Zeilenpreis )

595

18

Contains calculated value in EUR of the total amount of the serviceline. (ORIGINAL UNIT PRICE * NUMBER)

Y

74

Prefix (Vorzeichen)

613

1

PREFIX (sign) of UNIT PRICE: + or -

Y

75

Vat 1 (Steuersatz 1)

614

4

Contains percentage of the VAT without period or comma e.g.: 16.00% is 1900

Y

76

Taxed Partial Amount 1 (Versteuerter Teilbetrag 1)

618

18

Contains partial tax amount in EUR without period or comma e.g.: 123.45 EUR will be visible as 000000000000012345

Y

77

Taxed Line Amount 1 (Versteuerter Zeilenteilbetrag 1)

636

18

Contains calculated value in EUR of the total tax amount of the tax line. (TAXED PARTIAL AMOUNT 1 * NUMBER)

Y

78

Taxed Original Partial Amount 1) Versteuerter Original-Teilbetrag 1

654

18

Contains partial tax amount in EUR without period or comma e.g.: 123.45 EUR will be visible as 000000000000012345

Y

79

Taxed Original-Line Amount 1 ( Versteuerter Original-Zeilenteilbetrag 1 )

672

18

Contains calculated value in EUR of the total tax amount of the tax line. (TAXED ORIGINAL PARTIAL AMOUNT 1 * NUMBER)

Y

80

Vat 1 / Steuersatz 2

690

4

81

Taxed Partial Amount 2 (Versteuerter Teilbetrag 2)

694

18

82

Taxed Partial Amount 2 (Versteuerter Teilbetrag 2)

712

18

83

Taxed Original Partial Amount 2 ( Versteuerter Original-Teilbetrag 2 )

730

18

84

Taxed Original-Line Amount 2 ( Versteuerter Original-Zeilenteilbetrag 2 )

748

18

85

Vat 3 / Steuersatz 3

766

4

86

Taxed Partial Amount 3 (Versteuerter Teilbetrag 3)

770

18

87

Taxed Partial Amount 3 (Versteuerter Teilbetrag 3)

788

18

88

Taxed Original Partial Amount 3 ( Versteuerter Original-Teilbetrag 3 )

806

18

89

Taxed Original-Line Amount 3 ( Versteuerter Original-Zeilenteilbetrag 3 )

824

18

90

Vat 4 / Steuersatz 4

842

4

91

Taxed Partial Amount 4 (Versteuerter Teilbetrag 4)

846

18

92

Taxed Partial Amount 4 (Versteuerter Teilbetrag 4)

864

18

93

Taxed Original Partial Amount 4 ( Versteuerter Original-Teilbetrag 34)

882

18

94

Taxed Original-Line Amount 4 Versteuerter Original-Zeilenteilbetrag 4)

900

18

95

Vat 5 / Steuersatz 5

918

4

96

Taxed Partial Amount 5 (Versteuerter Teilbetrag 5)

922

18

97

Taxed Partial Amount 5 (Versteuerter Teilbetrag 5)

940

18

98

Taxed Original Partial Amount 5 ( Versteuerter Original-Teilbetrag 5)

958

18

99

Taxed Original-Line Amount 5 Versteuerter Original-Zeilenteilbetrag 5)

976

18

100

Shared Commission

994

4

101

Own Commission

998

4

102

Ud-Code

1002

2

103

Inclusive Tours

1004

1

104

Tax (Taxe)

1005

8

105

Original Tax ( Original-Taxe )

1013

8

106

Destination Code (Zielcode)

1021

3

107

Tourcode

1024

14

108

Farecalculation Mode Indicator (Vertrauensgewicht)

1038

1

109

Cost Center (Costing Point Kostenstelle)

1039

3

Cost center of agency which made the booking. Cost centers are used to account revenues and expenses

Y

110

Ordernumber (Auftragsnummer)

1042

4

111

Selling Personal Id (Verkaufender Exp)

1046

4

Contains personal ID of the travel agent, who made the booking. Field value is configurable per client: e.g. 9998

Y

112

Travel Agent (Pac) Who Is Changing The Document (Ändernder Exp)

1050

4

Contains personal ID of the travel agent, who did the last change in the booking. Field value is configurable per client: e.g. 9998

Y

113

Number Of Traveller (Nummer Des Reisenden)

1054

5

114

Name Of Traveller (Name Des Reisenden)

1059

20

115

Field Of Amount Price 2 (Betragsfeld Preis 2)

1079

18

116

Customer Cost Center (Ccp /Kundenkostenstelle)

1097

15

117

Ccp Printed ( Kks Gedruckt )

1112

1

118

Projectnumber (Projektnummer)

1113

15

119

Projectnumber Printed ( Projektnr. Gedruckt )

1128

1

120

Staff Number / Employee Number (Personalnummer)

1129

20

121

Staff Number Printed ( P-Nummer Gedruckt )

1149

1

122

Remark 1 (Bemerkung 1)

1150

20

123

Remark ! Printed ( Bemerkung 1 Gedruckt )

1170

1

124

Remark 2 (Bemerkung 2)

1171

20

125

Remark Printed ( Bemerkung 2 Gedruckt )

1191

1

126

Currency Indicator (Waehrungskennzeichen)

1192

3

Field value is fixed: EUR

Y

127

Rate Of Exchange ( Umrechnungskurs )

1195

10

Field value is fixed: 0001000000

Y

128

Unit ( Einheit )

1205

4

Field value is fixed: 1

Y

129

Prefix Original -Exponent ( Vorz. Original-Exponent )

1209

1

Field value is fixed: -

Y

130

Original Exponent ( Original-Exponent )

1210

1

Field value is fixed: 2

Y

131

Sign Bu-Exponent ( Vorz. Bst-Exponent )

1211

1

Field value is fixed: -

Y

132

Bu-Exponent ( Bst-Exponent )

1212

1

Field value is fixed: 2

Y

133

Modified On (Geaendert Am)

1213

8

Date of the last modification in format ddMMyyyy

Y

134

Type Of Connection ( Anschlußart )

1221

3

135

Denominal Rate Of Exchange ( Denominal-Umrechnungskurs )

1224

10

136

Denominal Unit ( Denominal-Einheit )

1234

4

137

Sign Denominal Exponent ( Vorz. Denominal-Exponent )

1238

1

138

Denominal Exponent ( Denominal-Exponent )

1239

1

139

Denominal Unit Price ( Denominal-Einzelpreis )

1240

18

140

Denominal Line Price ( Denominal-Zeilenpreis )

1258

18

141

Taxed Denominal Partial Amount ( Versteuerter Denominal-Teilbetrag 1 )

1276

18

142

Taxed Denominal Line Partial Amount ( Versteuerter Denominal-Zeilenteilbetrag 1 )

1294

18

143

Taxed Denominal Partial Amount 2 ( Versteuerter Denominal-Teilbetrag 2 )

1312

18

144

Taxed Denominal Line Partial Amount 2 ( Versteuerter Denominal-Zeilenteilbetrag 2 )

1330

18

145

Taxed Denominal Partial Amount 3 ( Versteuerter Denominal-Teilbetrag 3 )

1348

18

146

Taxed Denominal Line Partial Amount 3 ( Versteuerter Denominal-Zeilenteilbetrag 3 )

1366

18

147

Taxed Denominal Partial Amount 4 ( Versteuerter Denominal-Teilbetrag 4 )

1384

18

148

Taxed Denominal Line Partial Amount 4 ( Versteuerter Denominal-Zeilenteilbetrag 4)

1402

18

149

Taxed Denominal Partial Amount 5 ( Versteuerter Denominal-Teilbetrag 5 )

1420

18

150

Taxed Denominal Line Partial Amount 5 ( Versteuerter Denominal-Zeilenteilbetrag 5 )

1438

18

151

Denominal Tax ( Denominal-Taxe )

1456

8

152

Use ( Nutzung )

1464

6

153

Use Version Number ( Nutzungsversion )

1470

3

154

Custom Data ( Custom Daten )

1473

528

Anx/Service/Castor3/DataExports/RBSSAP/Verk (last edited 2010-09-03 13:49:20 by KarolinaPolak)

UA-140066296-2