Importing Reservations
-
Records reference the IC_Unique_ID_Ind_Contact from the Guest/Contact data file.
-
Reservation Status is auto-populated with values: Reserved (if arrival date is greater than business date), Arrival (if arrival date is equal to business date).
-
Payment Instructions. Payment method is set to "Cash". No credit card details are imported.
-
All reservations are imported irrespective of the room type or house availability or rate restrictions.
Table 24-10 Reservations
| Column Name | Description | Max Data Length | Sample Data | Mandatory |
|---|---|---|---|---|
|
RES_Unique_ID_Reservation (PK) |
Unique ID value for reservation in the uploaded csv files for Data type Reservations within an Import cycle. |
200 |
Ex: (30001, INC20001) |
|
|
IC_Unique_ID_Ind_Contact (FK) |
Foreign Key: Unique ID for Linked Guest Profile. Reference PK value from Guest / Contact Profiles data file for an Import cycle. |
Ex: (30001, INC20001) |
|
|
|
RES_Confirmation_Number |
This is the confirmation number from OPERA5 or third-party PMS. If provided, res_confirmation_number will be migrated as an external reference number of type 'IMPORTCNF' A new/unique OPERA Cloud confirmation number is generated for each reservation. |
50 |
Ex: ( 3451267345) |
|
|
RES_CRS_Number |
This is the CRS confirmation number from OPERA5 or third-party PMS. res_crs_number will be migrated as an external reference number of type res_external_ref_type_crs (if provided) else 'IMPORTCRS' as default. |
50 |
Ex: (56712345245) |
|
|
RES_External_Ref_Type_CRS |
The External Reference Type code. |
50 |
Ex: (CRS) |
|
|
RES_External_Leg_No_CRS |
Leg Number for External Reference |
5 |
Ex: (12345) |
|
|
RES_Reservation_Type |
The Reservation Type code; pre-configured in OPERA Cloud. |
20 |
Ex: (6PM) |
|
|
RES_Arrival_Date |
The Arrival Date of the reservation. The format must be YYYYMMDD. |
Ex: (20201121) |
|
|
|
RES_Departure_Date |
The Departure Date of the reservation. The format must be YYYYMMDD. |
Ex: (20201125) |
|
|
|
RES_Room_Type |
The Room type code; pre-configured in OPERA Cloud. |
50 |
Ex: (KNGN) |
|
|
RES_Room_Type_Charge |
The room type to charge code; pre-configured in OPERA Cloud. |
50 |
Ex: (KNGN) |
|
|
RES_Number_Rooms |
The number of rooms for this reservation. |
The value must be between 1 to 150 |
Ex: (1) |
|
|
RES_Number_Adults |
The Number of Adults: Defaulted to 1 in case of Null value. |
The value must be between 1 to 99 |
Ex: (2) |
|
|
RES_Number_Children |
The number of Children. |
The Value must be between 0- 99 |
Ex: (1) |
|
|
RES_Rate_Code |
The Rate Code for the reservation; pre-configured in OPERA Cloud. |
20 |
Ex: (RACK) |
|
|
RES_Rate_Amount |
The Rate Amount for the reservation. |
Ex: (100.00) |
|
|
|
RES_Currency_Code |
The Currency code for the reservation; pre-configured in OPERA Cloud. |
20 |
Ex: (USD) |
|
|
RES_Fixed_RateYN |
The Fixed Rate Flag.
|
1 |
Ex: ( Y, N) |
|
|
Room_Number |
The Room Number allocated (pre-assigned) to the reservation. |
200 |
Ex: (101) |
|
|
RES_Market_Code |
The Market code; pre-configured in OPERA Cloud. |
20 |
Ex: (CORPC) |
|
|
RES_Source_Code |
The Source code; pre-configured in OPERA Cloud. |
20 |
Ex: (REF) |
|
|
RES_Origin_Code |
The Origin code; pre-configured in OPERA Cloud. |
40 |
Ex: (PMS) |
|
|
RES_Source_Profile_ID (FK) |
Unique ID value of the Source profile in the uploaded csv files for Data type Accounts within an Import cycle. Foreign Key: Unique ID for Linked Accounts Profile. Reference PK value from Accounts Profiles data file for an Import cycle. |
200 |
Ex: (40002, AC40002) |
|
|
RES_Company_Profile_ID (FK) |
Unique ID value for Company profile in the uploaded csv files for Data type Accounts within an Import cycle. Foreign Key: Unique ID for Linked Accounts Profile. Reference PK value from Accounts Profiles data file for an Import cycle. |
200 |
Ex: (400013, AC40003) |
|
|
RES_Travel_Agent_Profile_ID (FK) |
Unique ID value for Travel agent profile in the uploaded csv files for Data type Accounts within an Import cycle. Foreign Key: Unique ID for Linked Accounts Profile. Reference PK value from Accounts Profiles data file for an Import cycle. |
200 |
Ex: (40004, AC40004) |
|
|
RES_Contact_Profile (FK) |
Unique ID value of the Guest/contact profile of uploaded csv files for Data type Reservations within an Import cycle. Foreign Key: Unique ID for Linked Guest Profile. Reference PK value from Guest / Contact Profiles data file for an Import cycle. |
200 |
Ex: (30003, INC20003) |
Note:
Any reservation exceeding the inventory checks in place in OPERA Cloud will not be imported, these records will be generated in the error file after the import process is completed. Ensure that the files uploaded for data type "Reservations", the cumulative number of rooms for a room type in all the files do not exceed the inventory checks in place.Parent topic: System Setup - Importing Data