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-12 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) |
Parent topic: About Data Import