Harthliving OTA · bản chữ cho AI · dựng từ vault (nguồn sửa lần cuối 29/09/2026 09:28) · mục lục: https://harthliving-ota.pages.dev/ai/index.txt # Bảng dữ liệu: Agoda transactions (`fact_agoda_transactions`) Agoda money transactions per booking (booking value, collection amount, adjustments). booking_value = 0 means cancelled. - Nền tảng: agoda · Nhóm: payments · Mỗi dòng: one transaction - Số dòng: 28 · Cập nhật: 2026-09-24 - Tải: CSV https://harthliving-ota.pages.dev/data/fact-agoda-transactions.csv · JSON https://harthliving-ota.pages.dev/data/fact-agoda-transactions.json · HTML https://harthliving-ota.pages.dev/library/data/fact-agoda-transactions/ ## Cột | Cột | Kiểu | Nghĩa | |---|---|---| | `snapshot_date` | date | Date the data was crawled from the platform (NOT the date the numbers refer to) | | `channel` | string | Sales channel / platform key: booking / agoda / airbnb / pricelabs | | `slug` | string | Internal property key (e.g. 25anthuong11, alacarte305). Join key across all datasets | | `external_id` | string | Property/listing ID on the platform (Booking hotel_id, Agoda property ID, Airbnb listing ID) | | `transaction_id` | string | Agoda transaction ID | | `reference_number` | string | Booking ID the transaction belongs to (= fact_agoda_reservations.booking_id) | | `transaction_type` | string | Reservation or Adjustment | | `is_adjustment` | boolean | 1 if the transaction is an adjustment | | `created_date` | date | Date the transaction was created | | `checkin` | date | Check-in date | | `checkout` | date | Check-out date | | `booking_value` | number | Booking value in VND. 0 means the booking was cancelled | | `collection_amount` | number | Amount collected/paid out in VND (negative = deduction) | | `currency` | string | Currency code of money columns (VND) | | `payment_method` | string | Payout method (Telex Transfer) | ## Dữ liệu **Phần 1/1** — dòng 1–28 / 28 · (hết bảng) ```csv snapshot_date,channel,slug,external_id,transaction_id,reference_number,transaction_type,is_adjustment,created_date,checkin,checkout,booking_value,collection_amount,currency,payment_method 2026-09-24,agoda,15nuocman5,84463562,10496353526,1739184041,Reservation,0,2026-06-19,2026-06-26,2026-06-28,7504000.0,7504000.0,VND,Telex Transfer 2026-09-24,agoda,15nuocman5,84463562,10716866751,1750220315,Reservation,0,2026-07-21,2026-08-02,2026-08-06,12895760.0,12895760.0,VND,Telex Transfer 2026-09-24,agoda,15nuocman5,84463562,10719425744,2017336129-11079,Adjustment,1,2026-07-21,2026-07-21,2026-07-21,-4438157.9,-4438157.9,VND,Telex Transfer 2026-09-24,agoda,15nuocman5,84463562,10993681288,1743114920,Reservation,0,2026-07-01,2026-07-16,2026-07-21,16119703.8,16119703.8,VND,Telex Transfer 2026-09-24,agoda,181tohienthanh,84463574,10330703988,1731187602,Reservation,0,2026-05-26,2026-06-15,2026-06-20,18000000.0,18000000.0,VND,Telex Transfer 2026-09-24,agoda,181tohienthanh,84463574,10530884449,2017336129,Reservation,0,2026-05-30,2026-07-10,2026-07-13,0.0,0.0,VND,Telex Transfer 2026-09-24,agoda,181tohienthanh,84463574,10538254719,1740896512,Reservation,0,2026-06-24,2026-07-10,2026-07-12,0.0,0.0,VND,Telex Transfer 2026-09-24,agoda,181tohienthanh,84463574,10543750985,2021076598,Reservation,0,2026-06-10,2026-07-16,2026-07-20,0.0,0.0,VND,Telex Transfer 2026-09-24,agoda,181tohienthanh,84463574,10577667623,2028258226,Reservation,0,2026-07-01,2026-07-15,2026-07-20,0.0,0.0,VND,Telex Transfer 2026-09-24,agoda,181tohienthanh,84463574,10676898443,2017336129-11079,Adjustment,1,2026-07-15,2026-07-15,2026-07-15,-4438157.9,-4438157.9,VND,Telex Transfer 2026-09-24,agoda,181tohienthanh,84463574,10719423231,2017336129-11079,Adjustment,1,2026-07-21,2026-07-21,2026-07-21,4438157.9,4438157.9,VND,Telex Transfer 2026-09-24,agoda,181tohienthanh,84463574,10770689755,1754586651,Reservation,0,2026-07-28,2026-09-04,2026-09-07,8248890.0,8248890.0,VND,Telex Transfer 2026-09-24,agoda,181tohienthanh,84463574,10849371105,1759236001,Reservation,0,2026-08-08,2026-12-26,2026-12-30,10998520.0,10998520.0,VND,Telex Transfer 2026-09-24,agoda,181tohienthanh,84463574,10883945606,1761214569,Reservation,0,2026-08-13,2026-08-30,2026-09-02,8936298.0,8936298.0,VND,Telex Transfer 2026-09-24,agoda,181tohienthanh,84463574,10953911633,988554310,Reservation,0,2026-04-06,2026-08-17,2026-08-24,-532000.0,-532000.0,VND,Telex Transfer 2026-09-24,agoda,181tohienthanh,84463574,10978198338,1766609131,Reservation,0,2026-08-26,2026-09-18,2026-09-19,2749630.0,2749630.0,VND,Telex Transfer 2026-09-24,agoda,181tohienthanh,84463574,11071059358,1771814012,Reservation,0,2026-09-08,2026-10-20,2026-10-23,8248890.0,8248890.0,VND,Telex Transfer 2026-09-24,agoda,181tohienthanh,84463574,9677584332,1700138196,Reservation,0,2026-02-19,2026-02-19,2026-02-20,3200000.0,3200000.0,VND,Telex Transfer 2026-09-24,agoda,181tohienthanh,84463574,9677873853,1700156672,Reservation,0,2026-02-19,2026-04-15,2026-04-18,9600000.0,9600000.0,VND,Telex Transfer 2026-09-24,agoda,181tohienthanh,84463574,9731473738,632865171,Reservation,0,2026-02-27,2026-03-06,2026-03-13,21280000.0,21280000.0,VND,Telex Transfer 2026-09-24,agoda,181tohienthanh,84463574,9993122865,988554310,Reservation,0,2026-04-06,2026-08-17,2026-08-24,21280000.0,21280000.0,VND,Telex Transfer 2026-09-24,agoda,alacarte305,63382515,7506448239,1558664156,Reservation,0,2025-03-06,2025-03-18,2025-03-20,2980000.0,2980000.0,VND,Telex Transfer 2026-09-24,agoda,alacarte305,63382515,7880119913,1609038648,Reservation,0,2025-05-08,2025-05-26,2025-05-28,0.0,0.0,VND,Telex Transfer 2026-09-24,agoda,alacarte305,63382515,8617612639,1647763853,Reservation,0,2025-09-07,2025-10-31,2025-11-20,0.0,0.0,VND,Telex Transfer 2026-09-24,agoda,alacarte305,63382515,9055132385,1953782804,Reservation,0,2025-11-17,2026-01-20,2026-01-23,0.0,0.0,VND,Telex Transfer 2026-09-24,agoda,alacarte305,63382515,9200181058,1676580203,Reservation,0,2025-12-08,2026-03-26,2026-03-28,0.0,0.0,VND,Telex Transfer 2026-09-24,agoda,alacarte305,63382515,9243325056,944491738,Reservation,0,2025-12-15,2026-02-07,2026-02-13,0.0,0.0,VND,Telex Transfer 2026-09-24,agoda,alacarte502,84463577,10954292212,2025001589,Reservation,0,2026-06-22,2026-07-16,2026-07-20,6240000.0,6240000.0,VND,Telex Transfer ``` **Phần 1/1** — dòng 1–28 / 28 · (hết bảng)