Importing Membership Transactions
-
Data Type: Membership Transactions
-
Notes: Available with OPERA Loyalty Cloud Services
-
Template Filename: Membership_Transactions.csv
Import is associated with existing Profile Membership details, based on Membership Type and Membership Card Number.
Table 24-6 Membership Transactions
| Column | Description | Max Data Length | Sample Data | Mandatory |
|---|---|---|---|---|
|
MT_Arrival_Date |
The Arrival Date of the stay. The format must be YYYYMMDD |
Ex: (20230124) |
|
|
|
MT_CRS_Booking_No |
CRS booking number (alphanumeric) |
50 |
Ex: (AB123456C) |
|
|
MT_Departure_Date |
The Departure Date of the stay. The format must be YYYYMMDD |
Ex: (20230126) |
|
|
|
MT_PMS_Reservation_No |
Confirmation number (alphanumeric) |
50 |
Ex: (A12345B) |
|
|
MT_Membership_Type (FK) |
Membership Type associated with the member profile. Pre-configured in OPERA Cloud |
20 |
Ex: (ABROYAL) |
|
|
MT_Membership_Card_No (FK) |
Membership Number |
50 |
Ex: (1000001) |
|
|
MT_Record_Type |
The type of membership transaction, and valid values are:
|
Ex: (ST) |
|
|
|
MT_Property |
OPERA property code. Preconfigured in OPERA Cloud |
20 |
Ex: (ROSIE) |
|
|
MT_Currency |
Currency code which points were calculated. Preconfigured in OPERA Cloud |
20 |
Ex: (USD) |
|
|
MT_Membership_Level |
Membership level associated with the member. Preconfigured in OPERA Cloud |
20 |
Ex: (GOLD) |
|
|
MT_Profile_Promotion_1 |
Promotion Code applied to points. Preconfigured in OPERA Cloud |
20 |
Ex: (SEASON) |
|
|
MT_Profile_Promotion_2 |
Promotion Code applied to points. Preconfigured in OPERA Cloud |
20 |
||
|
MT_Rate_Promotion |
Promotion Code associated with the reservation. Pre-onfigured in OPERA Cloud |
20 |
Ex: (NEWYEAR) |
|
|
MT_Base_Nights |
Base Night points |
Ex: (1000) |
(At least one of the following fields must be populated) |
|
|
MT_Base_Points |
Total Base Points (Nights+Revenue+stays) |
Ex: (3000) |
||
|
MT_Base_Revenue |
Base Revenue Points |
Ex: (1000) |
||
|
MT_Base_Stay |
Base Stay Points |
Ex: (1000) |
||
|
MT_Bonus_Nights |
Bonus Night Points |
Ex: (100) |
||
|
MT_Bonus_Points |
Total Bonus Points (Nights + Stay+Revenue) |
Ex: (300) |
||
|
MT_Bonus_Revenue |
Bonus Revenue Points |
Ex: (100) |
||
|
MT_Bonus_Stay |
Bonus Stay Points |
Ex: (100) |
||
|
MT_Miscellaneous_Points |
Miscellaneous Points |
Ex: (100) |
||
|
MT_Expiration_Date |
Points Expiration Date |
Ex: (20231231) |
||
|
MT_Notes |
Comments related to Points transaction |
4000 |
Ex: (Service Recovery) |
|
|
MT_Points_Cost |
Cost of Points |
Ex: (1000) |
||
|
MT_Points_Credit_Date |
Date Points were awarded. The format must be YYYYMMDD |
Ex: (20230126) |
||
|
MT_Transaction_Date |
Date of Points Transaction. The format must be YYYYMMDD |
Ex: (20230126) |
Parent topic: System Setup - Importing Data