Internal Inventory Process

[CNIN] Inventory

Specification

Field

Length

Type

Null

Description

Internal Name

Initial date

8

Date

N

Travel start date

fec_desde

Final date

8

Date

N

Travel end date

fec_hasta

Room type

3

Text

N

The combination of the Room Type, Room Characteristic is the room code in the XML. However certain offers and supplement can be applied to specific Room Type and/or Room Characteristic.File will contain multiple room types. No limit on the number of room types

cod_hab

Characteristic

15

Text

N

 

cod_car

Rate

8

Number

Y

Rate code

 

Release

4

Number

N

Release days. 0 is day of departure (i.e. no release date)

nro_release

Allotment

2

Number

N

Remaining allotment from 0 to 10. 10 will indicate the number of rooms available is equal or greater than 10

nro_disponible

Example

A contract with CCON.Fix rate value true. The Rate field is always informed and shows the specific release/allotment per day from 20110501 to 20110508.
More than one record is possible for every combination of room type and characteristic. One record per rate.

{CNIN}
20110501:20110508:DBT:ST:1:(0,8)(0,10)(0,10)(0,10)(0,10)(0,10)(0,9)(0,10)
20110501:20110508:DBT:ST:2:(0,6)(0,10)(0,10)(0,10)(0,10)(0,10)(0,10)(0,9)
{/CNIN} 


A contract with CCON.Fix rate value false. The Rate field is always null and you can see the release/allotment for DBT-ST and DBT-HD rooms per day from 20110501 to 20110508.
Only one record is possible for every combination of room type and characteristic.

{CNIN}
20110501:20110508:DBT:ST::(0,10)(0,8)(0,10)(0,10)(0,10)(0,10)(0,10)(0,10)
20110501:20110508:DBT:HD::(0,10)(0,10)(0,10)(0,8)(0,10)(0,10)(0,10)(0,10)
{/CNIN}

[CNCT] Prices

Specification

Field

Length

Type

Null

Description

Internal Name

Initial date

8

Date

N

Travel start date

fec_desde

Final date

8

Date

N

Travel end date

fec_hasta

Room type

3

Text

N

The combination of the Room Type, Room Characteristic is the room code in the XML. However certain prices filters can be applied by Room Type and or Room Characteristic.File will contain multiple room types. No limit on the number of room types

cod_hab

Characteristic

15

Text

N

 

cod_car

Generic Rate

8

Number

Y

Rate code

 

Market price

2

Text

Y

Price per origin market (only available for clients that works on several countries). If you only work with one country, you will receive this field empty

 

Is price per pax

1

Boolean

N

Applies per pax or per service: 
Y: Price per passenger 
N: Price per room

ind_paxser

Net price

 

Number

N

Contains net sale price for the product

 

Price

 

Number

N

Contains the final price for this product when sold to public 
When [CCON.Selling price] value is true indicates this price is mandatory

 

Specific Rate

8

Number

Y

Rate code

 

Base board

2

Text

Y

Default base board code

 

Amount

 

Number

N

Contains the amount for the product

 

Example

A contract with CCON.Fix rate value true. The generic rate field is always informed and shows the price information per day from 20110501 to 20110508. Note that the specific rate is null.
More than one record is possible for every combination of room type and characteristic. One record per rate. 

{CNCT}
20110501:20110508:DBT:ST:1:DE:(Y,45,50,,RO,45)(Y,45,50,,RO,45)(Y,45,50,,RO,45)(Y,55,75,,RO,55)(Y,55,75,,RO,55)(Y,140,150,,RO,140)(Y,45,50,,RO,45)(Y,45,50,,RO,45)
20110501:20110508:DBT:ST:2::(Y,45,50,,RO,45)(Y,45,50,,RO,45)(Y,45,50,,RO,45)(Y,55,75,,RO,55)(Y,55,75,,RO,55)(Y,140,150,,RO,140)(Y,45,50,,RO,45) (Y,45,50,,RO,45)
{/CNCT} 

A contract with CCON.Fix rate value false. The generic rate field is always null and you can see the price information for DBT-ST per day from 20110501 to 20110508. Note that the rate information is informed in the specific rate field in each day.
Only one record is possible for every combination of room type and characteristic. 

{CNCT}
20110501:20110508:DBT:ST:::(Y,45,50,1,RO,45)(Y,35,45,2,RO,35)(Y,45,50,1,RO,45)(Y,65,75,1,RO,65)(Y,65,75,2,RO,65)(Y,140,150,2,RO,140)(Y,45,50,1,RO,45)(Y,45,50,1,RO,45)
{/CNCT} 

[CNSR] Board supplements and discounts

Specification

Field

Length

Type

Null

Order

Description

Internal Name

Initial date

8

Date

N

 

Travel start date

fec_desde

Final date

8

Date

N

 

Travel end date

fec_hasta

Board code

2

Text

N

 

Board code

cod_regimen

Is per pax

1

Boolean

N

 

Applies per pax or per service: 
Y: Per person 
N: Per room

ind_paxser

Amount

 

Number

Y

 

Amount. It could be positive (supplement) and negative (discount)

imp_suplem

Percentage

 

Number

Y

 

Percentage. It could be positive (supplement) and negative (discount)

pct_suplem

Rate

8

Number

Y

1

 

cod_tarifa

Room type

3

Text

Y

2

 

cod_hab

Characteristic

15

Text

Y

3

 

cod_car

Minimum age

2

Number

Y

 

Minimum age that limits the rule

nro_edaini

Maximum age

2

Number

Y

 

Maximum age that limits the rule

nro_edafin

On Monday

1

Boolean

N

 

True if supplement on Monday. False if not.

ind_lun

On Tuesday

1

Boolean

N

 

True if supplement on Tuesday. False if not.

ind_mar

On Wednesday

1

Boolean

N

 

True if supplement on Wednesday. False if not.

ind_mie

On Thursday

1

Boolean

N

 

True if supplement on Thursday. False if not.

ind_jue

On Friday

1

Boolean

N

 

True if supplement on Friday. False if not.

ind_vie

On Saturday

1

Boolean

N

 

True if supplement on Saturday. False if not.

ind_sab

On Sunday

1

Boolean

N

 

True if supplement on Sunday. False if not.

ind_dom

Internal field

1

Number

N

 

This field should not be used

 

Net price

 

Number

Y

 

Contains net sale price for this board 
It could be positive (supplement) and negative (discount)

 

Price

 

Number

Y

 

Contains the final price for this board when sold to public 
When [CCON.Selling price] value is true indicates this price is mandatory 
It could be positive (supplement) and negative (discount)

 

Market price

2

Text

Y

 

Price per origin market (only available for clients that works on several countries). If you only work with one country, you will receive this field empty

 

 

Example

{CNSR}
20110101:20111231:BB:Y:24.500:::::::Y:Y:Y:Y:Y:Y:Y:0:20.000:24.500:DE
20110101:20111231:BB:Y:24.500:::::::Y:Y:Y:Y:Y:Y:Y:0:20.000:24.500:
{/CNSR}

 

[CNSU] Supplements and discounts

Specification

 

Field

Length

Type

Null

Order

Description

Internal Name

Initial date

8

Date

N

 

 

fec_desde

Final date

8

Date

N

 

 

fec_hasta

Application initial date

8

Date

N

 

Earliest booking creation date

fec_aplini

Application final date

8

Date

Y

 

Last booking creation date

fec_aplfin

Supplement or discount code

3

Text

N

 

Supplement or discount code

cod_suplem

Type

1

Enumeration

N

 

N: Child discount 
F: Infant C: Additional/Extra Bed I: Double for individual use 
L: Long stay B: Early booking E: Fixed stay M: Minimum stay O: Operation days G: General K: Turbo early booking V: Apply supplement based on arrival date times number of nights if arrival date is in the Travel Start / End date period U: Last minute Q: Only available for Airline discounts

tipo_suplemento

Is per pax

1

Boolean

N

 

Applies per pax or per service: 
Y: Per person 
N: Per room

ind_paxser

Opaque

1

Boolean

N

 

If true, only applies for packaging

ind_opaque

Order

8

Number

Y

 

Order in which supplements must be applied. From lowest to highest.

orden

Application type

1

Enumeration

N

 

B: On base board 
R: On board supplement 
N: Per night, base board plus supplement 
A: Absolute amount 
T: Only once. Check in date must be within the travel start and end date. Apply once to check in date. 
U: Only once type if any date of the booking overlaps with the period. The day to apply the offer is the first one that overlaps. 
M: Absolute amount + board supplement

ind_tipapl

Amount

 

Number

Y

 

Amount. It could be positive (supplement) and negative (discount)

imp_suplem

Percentage

 

Number

Y

 

Percentage. It could be positive (supplement) and negative (discount)

pct_suplem

Is cumulative

1

Boolean

N

 

True if cumulative and applies to rest of supplements applied before

ind_acumula

Rate

8

Number

Y

1

 

cod_tarifa

Room type

3

Text

Y

2

 

cod_hab

Characteristic

15

Text

Y

3

 

cod_car

Board

3

Text

Y

4

 

cod_regim

Adults

3

Number

Y

 

Minimum adults to apply the rule

nro_adultos

Pax order

3

Number

Y

 

Indicates adult to which the rule applies: N and C

nro_orden

Minimum age

2

Number

Y

 

Minimum age that limits the rule

nro_edaini

Maximum age

2

Number

Y

 

Maximum age that limits the rule

nro_edafin

Number of days

3

Number

Y

 

Refer to valuation process

nro_dias

Length of stay

3

Number

Y

 

Number of days for the stay

nro_dias_estancia

Limit date

8

Date

Y

 

Refer to valuation process

fec_limite

On Monday

1

Boolean

N

 

True if supplement on Monday. False if not.

ind_lun

On Tuesday

1

Boolean

N

 

True if supplement on Tuesday. False if not.

ind_mar

On Wednesday

1

Boolean

N

 

True if supplement on Wednesday. False if not.

ind_mie

On Thursday

1

Boolean

N

 

True if supplement on Thursday. False if not.

ind_jue

On Friday

1

Boolean

N

 

True if supplement on Friday. False if not.

ind_vie

On Saturday

1

Boolean

N

 

True if supplement on Saturday. False if not.

ind_sab

On Sunday

1

Boolean

N

 

True if supplement on Sunday. False if not.

ind_dom

Net price

 

Number

Y

 

Contains net sale price for this supplement 
It could be positive (supplement) and negative (discount)

 

Price

 

Number

Y

 

Contains the final price for this supplement when sold to public 
When [CCON.Selling price] value is true indicates this price is mandatory 
It could be positive (supplement) and negative (discount)

 

Market price

2

Text

Y

 

Price per origin market (only available for clients that works on several countries).If you only work with one country, you will receive this field empty

 

Example

{CNSU}
20110101:20111231:20100915::DN:N:Y:N:-30:N::-100:N::JSU:ST::2:1:0:12::::Y:Y:Y:Y:Y:Y:Y:::
20110101:20111231:20100915::DN:N:Y:N:-30:N::-100:N::SUI:ST::2:1:0:12::::Y:Y:Y:Y:Y:Y:Y:::DE
20110101:20111231:20100915::DN:N:Y:N:-30:N::-100:N::SUI:LX-SU::2:1:0:12::::Y:Y:Y:Y:Y:Y:Y:::DE
20110101:20111231:20100915::DN:N:Y:N:-30:N::-100:N::SUI:ST::2:2:0:12::::Y:Y:Y:Y:Y:Y:Y:::ES
20110101:20111231:20100915::DN:N:Y:N:-30:N::-100:N::SUI:LX-SU::2:2:0:12::::Y:Y:Y:Y:Y:Y:Y:::ES
20110101:20111231:20100915::CA:C:Y:N:-20:A:134.500:N:::::BB::3:13:99::::Y:Y:Y:Y:Y:Y:Y:130.000:134.500
20110101:20111231:20100915::CA:C:Y:N:-20:A:110.000::N::::RO::3:13:99::::Y:Y:Y:Y:Y:Y:Y:100.000:110.000
20110101:20111231:20100915::CA:C:Y:N:-20:A:110.000::N::::RO::4:13:99::::Y:Y:Y:Y:Y:Y:Y:100.000:110.000
20110101:20111231:20100915::CA:C:Y:N:-20:A:134.500::N::::BB::4:13:99::::Y:Y:Y:Y:Y:Y:Y:130.000:134.500
20110101:20111231:20100915::CA:C:Y:N:-20:A:110.000::N::::RO::5:13:99::::Y:Y:Y:Y:Y:Y:Y:100.000:110.000
20110101:20111231:20100915::CA:C:Y:N:-20:A:134.500::N::::BB::5:13:99::::Y:Y:Y:Y:Y:Y:Y130.000:134.500
20110101:20111231:20100915::EB:B:S:N:0:N::-10:N:::::::::30:::Y:Y:Y:Y:Y:Y:Y::
{/CNSU}

[CNPV] Stop sales

Specification

Field

Length

Type

Null

Order

Description

Internal Name

Initial date

8

Date

N

 

Initial date for the stop sales

fec_desde

Final date

8

Date

N

 

End date for the stop sales

fec_hasta

Rate

8

Number

Y

1

 

cod_tarifa

Room type

3

Text

Y

2

 

cod_hab

Characteristic

15

Text

Y

3

 

cod_car

Board

3

Text

Y

4

 

cod_regim

 

Example

A stop of sales from 05th May to 07th May for the DBT-ST room.
A stop of sales from 01st June to 15th June for all the bookings with rate code 1

{CNPV}
20110505:20110507::DBT:ST:
20110601:20110615:1:::
{/CNPV} 

[CNGR] Frees

Specification

Field

Length

Type

Null

Description

Internal Name

Initial date

8

Date

N

 

fec_desde

Final date

8

Date

N

 

fec_hasta

Application initial date

8

Date

N

Earliest booking creation date

fec_aplini

Application final date

8

Date

Y

Last booking creation date

fec_aplfin

Minimum days

1

Number

N

Minimum days for the booking

nro_ini

Maximum days

1

Number

N

Maximum days for the booking

nro_fin

Rate

8

Number

Y

 

cod_tarifa

Room type

3

Text

Y

 

cod_hab

Characteristic

15

Text

Y

 

cod_car

Board

3

Text

Y

 

cod_regim

Frees

3

Number

Y

Number of free nights

nro_gratis

Free code

3

Text

Y

Free code. It is used in conjunction with the data held in the CNOE

cod_grat

Discount

8

Number

Y

Percentage amount of discount

pct_descuento

Application base type

1

Enumeration

N

B: Applies to the base price [without supplement and discounts CNSU] 
D: Applies to the base price with base supplements and discounts [CNSU.Type = N, C or I] 
T: Applies to the total price

ind_base

Application board type

1

Enumeration

N

B: Applies to the base price [without board supplements and discounts CNSR] 
R: Applies to the price with board supplements and discounts

ind_regimen

Application discount type

1

Enumeration

N

Which night the free offer applies 
B: Cheapest night 
C: Most expensive night 
M: Average night 
P: First night 
U: Last night

ind_tipapl

Application stay type

1

Enumeration

N

E: Check in date must be in travel date period S: Check in date and check out date must be in the travel date period P: Only applies if no E or S has been applied. The check in and check out (minus 1) dates must overlap with the travel date period. The number of nights stay is taken from the overlap period and validated against the min/max duration. Multiple P offers can be applied. However max of 1 offer for each nightP only applies if no E or S offers have been applied

ind_entest

On Monday

1

Boolean

N

True if applies on Monday. False if not.

ind_lun

On Tuesday

1

Boolean

N

True if applies on Tuesday. False if not.

ind_mar

On Wednesday

1

Boolean

N

True if applies on Wednesday. False if not.

ind_mie

On Thursday

1

Boolean

N

True if applies on Thursday. False if not.

ind_jue

On Friday

1

Boolean

N

True if applies on Friday. False if not.

ind_vie

On Saturday

1

Boolean

N

True if applies on Saturday. False if not.

ind_sab

On Sunday

1

Boolean

N

True if applies on Sunday. False if not.

ind_dom

Week Day validation type

1

Enumeration

N

E: Check in date must be valid for the week day S: The travel stay overlaps with at least one valid week day

ind_DiasemEntest

Example

{CNGR}
20110101:20111231:::5:999:::::1:::D:R:B:S:N:N:N:N:N:N:N:E
{/CNGR} 

[CNOE] Combinable offers

Specification

Field

Length

Type

Null

Description

Internal Name

Code1

3

Text

N

Free or supplement/discount code

cod_splgra

Code2

3

Text

N

Free or supplement/discount code

cod_splgra_ex

Is excluded

1

Boolean

N

Y: If Code1 applies then Code2 is excluded 
N: If Code1 applies then Code2 is also mandatory required

ind_excluido

 

Example

The EB supplement/discount is excluded when the ARD free applies.

{CNOE}
ARD:EB:Y
{/CNOE}

 

[CNEM] Minimum and maximum stay

Specification

Field

Length

Type

Null

Order

Description

Internal Name

Application date

8

Date

Y

 

Earliest booking creation date where the minimum stay applies.
If null the rule always applies.

fec_aplicacion

Initial date

8

Date

N

 

Travel starts date

fec_desde

Final date

8

Date

N

 

Travel end date

fec_hasta

Type

1

Enumeration

N

 

Rule types: 
T: Check in date if between the travels date period. Check min/max stay on check in date 
E: Check in and check out dates minus 1 is between the travels date period. Check min/max stay on check in date

ind_tipo

Rate

8

Number

Y

1

 

cod_tarifa

Room type

3

Text

Y

2

 

cod_hab

Characteristic

15

Text

Y

3

 

cod_car

Board

3

Text

Y

4

 

 

Minimum days

3

Number

N

 

Minimum days for the stay duration. If this field is empty, Maximum days cannot be empty.

nro_dias_min

Maximum days

3

Number

Y

 

Maximum days for the stay duration.

nro_dias_max

On Monday

1

Boolean

N

 

True if check in required on Monday. False if not.

ind_lun

On Tuesday

1

Boolean

N

 

True if check in required on Tuesday. False if not.

ind_mar

On Wednesday

1

Boolean

N

 

True if check in required on Wednesday. False if not.

ind_mie

On Thursday

1

Boolean

N

 

True if check in required on Thursday. False if not.

ind_jue

On Friday

1

Boolean

N

 

True if check in required on Friday. False if not.

ind_vie

On Saturday

1

Boolean

N

 

True if check in required on Saturday. False if not.

ind_sab

On Sunday

1

Boolean

N

 

True if check in required on Sunday. False if not.

ind_dom

 

Example

From 1st July to 30th September minimum of 7 length of stay days required. 3 days the rest of the periods.

{CNEM}
:20110425:20110630:T:::::3:999:Y:Y:Y:Y:Y:Y:Y
:20110701:20110930:T:::::7:999:Y:Y:Y:Y:Y:Y:Y
:20111001:20111031:T:::::3:999:Y:Y:Y:Y:Y:Y:Y
{/CNEM}

[CNTA] Rate codes

Specification

Field

Length

Type

Null

Description

Internal Name

Rate

8

Number

N

Rate code

cod_tarifa

Description

5

Text

N

Rate name

cor_tarifa

Order

3

Number

Y

Rate order for cancellation policy

nro_orden

Example

Different rate codes and descriptions.

{CNTA}
3:FIT:
0:NRATE:
{/CNTA} 

[CNES] Check in and check out

Specification

Field

Length

Type

Null

Description

Internal Name

Application date

8

Date

Y

Application start date

fec_aplicacion

Initial date

8

Date

N

Travel starts date

fec_desde

Final date

8

Date

N

Travel end date

fec_hasta

Type

1

Enumeration

N

Restriction type 
I: Check in 
O: Check out

ind_tipo

Room type

3

Text

Y

 

cod_hab

Characteristic

15

Text

Y

 

cod_car

Rate

8

Number

Y

Rate code

cod_tarifa

On Monday

1

Boolean

N

True if the rule applies. False if not

ind_lun

On Tuesday

1

Boolean

N

True if the rule applies. False if not

ind_mar

On Wednesday

1

Boolean

N

True if the rule applies. False if not

ind_mie

On Thursday

1

Boolean

N

True if the rule applies. False if not

ind_jue

On Friday

1

Boolean

N

True if the rule applies. False if not

ind_vie

On Saturday

1

Boolean

N

True if the rule applies. False if not

ind_sab

On Sunday

1

Boolean

N

True if the rule applies. False if not

ind_dom

Board

3

Text

Y

 

 

 

Example

From 1st July to 30th September only Saturday and Sunday check in allowed.

{CNES}
:20110425:20110630:I::::Y:Y:Y:Y:Y:Y:Y
:20110701:20110930:I::::N:N:N:N:N:Y:Y
:20111001:20111031:I::::Y:Y:Y:Y:Y:Y:Y
{/CNES} 

[CNCF] Cancellation fees

Specification

Field

Length

Type

Null

Description

Internal Name

Application date

8

Date

Y

Earliest booking creation date

fec_aplicacion

Initial date

8

Date

N

Travel starts date

fec_desde

Final date

8

Date

N

Travel end date

fec_hasta

Rate

8

Number

Y

Rate code

cod_tarifa

Days

 

Number

Y

Days before the booking client check in where the cancellation fee applies

nro_dias

Hours

 

Number

Y

Hours before the client check in where the cancellation fee applies. Hour is considered local time at hotel.

nro_hora

Amount first night

 

Number

N

Total amount of the cancellation fee for the first night

imp_gasto_1

Percentage first night

 

Number

N

Percentage of the cancellation fee for the first night

pct_gasto_1

Amount per night

 

Number

N

Total amount of the cancellation fee per night of the stay

imp_gasto_noc

Percentage per night

 

Number

N

Percentage of the cancellation fee per night of the stay

pct_gasto_noc

Application end date

8

Date

Y

Last booking creation date

 

Type

 

Enumeration

N

Cancellation type: 
EN: Per check in 
ES: Per stay

ind_tipgas

 

Example

A 100% of first night cancellation fees from 1st May to 05th May, 3 days before travel start.

{CNCF}
:20110501:20110505::3:0:0.0:0.0:0.0:100.0::EN
{/CNCF} 

Docs Navigation