Reservation List CSV Fields
Purpose:
This section explains the definitions of the CSV file fields in the reservation list.
This section explains the definitions of the CSV file fields in the reservation list.
▼Sample
| id | Definition |
| created_at | Reservation Date |
| facility_name | Property Name |
| reservation_no | Reservation Number |
| status | Reservation Status |
| booking_name | Guest Name |
| Guest Email Address | |
| organization_name | Organization Name |
| membership_program | Membership program name *blank if not logged in. |
| tripla_internal_membership_id | tripla internal ID *Automatically assigned membership ID. |
| rank_name | Membership rank |
| checkin_date | Check-in date |
checkout_date | Check-out date |
| number_of_days | Total number of nights |
| number_of_persons | Total number of guests |
| room_nights | Total room nights *For a 1-room day-use reservation, this value is counted as 1, not 0. |
| total_price | Total amount *Tax included. |
discount_price | Total discount amount |
| cancellation_fee | Cancellation fee |
| currency | Payment Currency Code (e.g., JPY, CNH, KRW) |
| payment_type | Payment Type ・on_site: Pay at property ・pre_paid: Advance payment ・tour_company_settlement: Tour company settlement. *Dynamic package |
| room_type_code | Room code |
| room_type_name | Room name |
| hotel_plan_code | Plan code |
| hotel_plan_name | Plan name |
| administrative_tags | Internal management tag |
| best_rate | Lowest OTA Price *Reference price used for Best Rate Guarantee. |
| best_rate_discount_amount | Discount amount for Best Rate |
| coupon_code | Coupon code *Shown only when used. |
| promotion_1 | Name of the first discount |
| promotion_1_discount_amount | Amount of the first discount |
| promotion_2 | Name of the second discount |
| promotion_2_discount_amount | Amount of the second discount |
| promotion_3 | Name of the third discount |
| promotion_3_discount_amount | Amount of the third discount |
| point_used | Points used for this reservation |
| point_accrued | Points earned from this reservation |
| options | Option details *Item name: quantity, amount |
| additional_questions_and_answers | Option and additional question details (Q1: Question A1: Answer). *Multiple entries are separated by a vertical bar. |
The discount amounts for "best_rate" and "promotion" are tax-inclusive.
Related Articles
Reservation List
Purpose: This section explains how to manage customer reservations, make changes, cancel bookings, and resend confirmation emails from the reservation list page. ⏱Estimated time: ~15 minutes 1. Where to Set Setting page: Brand Management Screen & ...Chat List
Purpose This section is to explain how to view chatbot inquiry history. Inquiries received via the chatbot can be viewed in a list and downloaded as a CSV file. Inquiry history can be checked for up to one year, excluding the most recent four weeks. ...Cancel a Reservation (Guest Screen)
Purpose This section explains the steps for canceling a reservation. ⏱ Estimated time: ~5 mins 1. Cancel from Email Confirmation Step 1 ・Click on the URL provided in the reservation confirmation email. ・After clicking the URL, Reservation ...Reservation Security Settings
Purpose: This section is explaining how to configure the Reservation Security settings. ⏱ Estimated time: ~5mins 1. Where to set Setting Page: Brand Management Screen Action: 'Settings' → 'Booking Engine' → [Reservation Security] 2. Reservation ...Reservation Update Policy
Purpose: This section explain how to set up options that allow or restrict users from modifying their reservation details or changing their payment method on the reservation confirmation page. ⏱ Estimated time: ~10 mins 1. Where to set Setting page: ...