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. Y or N	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.