Importing Stay Records

• Data Type: Stay Records

• Mandatory columns are marked in bold.

• Configuration required prior to importing Stay Records:

  • Rate Codes.

  • Revenue Bucket Codes for the 'Profile' bucket type.

  • Revenue Types.

Stay Records import is associated with existing Profiles and Membership Details (Membership Type and Number) if any. 

Table 24-12 Stay Records

Column	Description	Max Data Length	Sample Data	Mandatory
Filename: Stay_records.csv
ST_Stay_Record_Map_Id	Unique Primary ID to map parent Stay Records with its child templates Stay_Records.csv Stay_Records_Daily_Rates.csv Stay_Records_Memberships.csv Stay_Records_Profiles.csv Stay_Records_Revenue_Details.csv	NUMBER	EX: (100)
ST_UDFC01	User defined character field	200	EX: (UDFC01)
ST_UDFC02	User defined character field	200	EX: (UDFC02)
ST_UDFC03	User defined character field	200	EX: (UDFC03)
ST_UDFC04	User defined character field	200	EX: (UDFC04)
ST_UDFC05	User defined character field	200	EX: (UDFC05)
ST_UDFC06	User defined character field	200	EX: (UDFC06)
ST_UDFC07	User defined character field	200	EX: (UDFC07)
ST_UDFC08	User defined character field	200	EX: (UDFC08)
ST_UDFC09	User defined character field	200	EX: (UDFC09)
ST_UDFC10	User defined character field	200	EX: (UDFC10)
ST_UDFD01	User defined number field	NUMBER	EX: (UDFD01)
ST_UDFD02	User defined number field	NUMBER	EX: (UDFD02)
ST_UDFD03	User defined number field	NUMBER	EX: (UDFD03)
ST_UDFD04	User defined number field	NUMBER	EX: (UDFD04)
ST_UDFD05	User defined number field	NUMBER	EX: (UDFD05)
ST_UDFN01	User defined date field	DATE	EX: (UDFN01)
ST_UDFN02	User defined date field	DATE	EX: (UDFN02)
ST_UDFN03	User defined date field	DATE	EX: (UDFN03)
ST_UDFN04	User defined date field	DATE	EX: (UDFN04)
ST_UDFN05	User defined date field	DATE	EX: (UDFN05)
ST_adults	Number of adults	NUMBER	EX: (2)
ST_arrivalDate	Arrival Date	DATE	EX: (20230101)
ST_baseRateAmount	Base Rate Amount	NUMBER	EX: (1000)
ST_baseRateCode	Base Rate Code	20	EX: (DAILY)
ST_baseRateCurrencyCode	Base Rate Currency Code	20	EX: (USD)
ST_blockCode	Block Code	20	EX: (BLOCK1)
ST_bookedRoomType	Booked Room Type	50	EX: (STDK)
ST_bookingDate	Booking Date	DATE	EX: (20230101)	Note: This is not mandatory for reservation status 'PASSERBY'.
ST_channel	Channel through which reservation received	20	EX: (GDS)
ST_children	Number of Children	NUMBER	EX: (1)
ST_companyId	Company ID	20	EX: (700001)
ST_confirmationLegNumber	Confirmation Leg Number	NUMBER	EX: (10000001)
ST_confirmationNumber	Confirmation Number	50	EX: (10000001)
ST_currencyCode	Currency Code	20	EX: (USD)
ST_departureDate	Date the guest departed.	DATE	EX: (20230131)
ST_exhangeRate	Exchange Rate	NUMBER	EX: (1)
ST_externalReservationId	External Reservation ID	50	EX: (1000001)
ST_groupId	Group ID	20	EX: (700002)
ST_miscellaneousId	Miscellaneous ID	20	EX: (700003)
ST_paymentMethod	Payment Method	240	EX: (CASH)
ST_posCode	Point Of Sale Code	20	EX: (POS1)
ST_promotionCode	Promotion Code	20	EX: (NEWYEAR)
ST_reservationStatus	Status of the reservation (Only before values are accepted) CANCELLED (Cancellation Date is required for this) NO SHOW CHECKED OUT PASSERBY	20	EX: (CHECKED OUT)
ST_reservationInsertSource	Source of reservation	20	EX: (CORPORATE)
ST_roomNumber	Room Number	20	EX: (1007)
ST_roomRevenue	Room Revenue	NUMBER	EX: (100000)
ST_roomType	Room Type for the stay	50	EX: (STDK)
ST_shareId	Sharer ID	20	EX: (100002)
ST_sourceCode	Source Code	20	EX: (TEL)
ST_sourceId	Source ID	20	EX: (700004)
ST_cancellationDate	Cancellation Date (Only required for CANCELLED Reservation Status)	DATE	EX: ()
ST_totalRevenue	Total Revenue	NUMBER	EX: (150000)
ST_travelAgentId	Travel Agent ID	240	EX: (700005)
ST_resort	Resort Name	20	EX: (LCSCRM1)
ST_pmsNameId	Name id from the external system.	20	EX: (200001)	Note: Either of the below is required: GuestNameID PMSNameID Membership Type and Membership Number
ST_guestNameId	Guest Name ID	20	EX: (100001)
ST_membershipType	Membership Type	20	EX: (CRMROYAL)
ST_membershipNumber	Membership Number	50	EX: (CRM10001)

Table 24-13 Stay Record Daily Rates

Column	Description	Max Data Length	Sample Data	Mandatory
Filename: Stay_Records_Daily_Rates.csv
STD_Stay_Record_Map_Id	Primary ID to map the record to its parent record (ST_Stay_Record_Map_Id)	NUMBER	EX: (100)
STD_transactionDate	Transaction Date	DATE	EX: (20230201)
STD_bookedRoomType	Booked Room Type	50	EX: (STDK)
STD_currencyCode	Currency Code for this Rate Code	20	EX: (USD)
STD_marketCode	Market Code	20	EX: (CORP)
STD_rateCode	Rate Code	20	EX: (DAILY)
STD_rateAmount	Rate Amount	NUMBER	EX: (1000)
STD_roomNumber	Room number for the stay date	20	EX: (1007)
STD_roomType	Room Type for the stay	50	EX: (STDK)

Table 24-14 Stay Record Membership

Column	Description	Max Data Length	Sample Data	Mandatory
Filename: Stay_Records_Memberships.csv
STM_Stay_Record_Map_Id	Primary ID to the record map to its parent record (ST_Stay_Record_Map_Id)	NUMBER	EX: (100)
STM_membershipType	Membership Type	20	EX: (CRMROYAL)
STM_membershipNumber	Membership Number	50	EX: (CRM10001)

Table 24-15 Stay Record Profiles

Column	Description	Max Data Length	Sample Data	Mandatory
Filename: Stay_Records_Profiles.csv
STP_Stay_Record_Map_Id	Primary ID to map the record to its parent record (ST_Stay_Record_Map_Id)	NUMBER	EX: (100)
STP_nameId	Name ID	NUMBER	EX: (100001)	Note: Either of the below is required. NameID: If nameId is provided, the system will use the same PMSNameID: If pmsNameId is provided, the system will fetch nameId from the name_subscription table
STP_pmsNameId	Name ID from the external system.	20	EX: (100002)
STP_profileRole	Represents how the profile is related to the reservation. Only below 4 values can be used: CONTACT_ACCOUNT CONTACT_AGENT CONTACT_RESV CONTACT_RESV_BILL	20	EX: (CONTACT_RESV)

Table 24-16 Stay Record Revenue

Column	Description	Max Data Length	Sample Data	Mandatory
Filename: Stay_Records_Revenue_Details.csv
STR_Stay_Record_Map_Id	Primary ID to map the record to its parent record (ST_Stay_Record_Map_Id)	NUMBER	EX: (100)
STR_folioView	Billing Window	40	EX: (1)
STR_revenueAmount	Revenue Amount	NUMBER	EX: (10000)
STR_revenueBucketCode	Revenue Type	20	EX: (ROOM REV)
STR_transactionDate	Transaction Date	DATE	EX: (20230101)