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
|
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)
|
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:
|
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.
|
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:
|
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) |
Parent topic: System Setup - Importing Data