fact_agoda_transactions
Agoda · 28 dòng · đọc gần nhất 24/09/2026
1Bảng này là gì
🔴 README chưa có mục riêng cho bảng này.
2Từ điển cột (tự đo)
| Cột | Kiểu | Có giá trị | Giá trị khác nhau | Ví dụ |
|---|---|---|---|---|
snapshot_date | ngày | 28 | 1 | 2026-09-24 |
channel | chữ | 28 | 1 | agoda |
slug | chữ | 28 | 4 | 15nuocman5, 181tohienthanh, alacarte305 |
external_id | số | 28 | 4 | 63382515, 84463562, 84463574 |
transaction_id | số | 28 | 28 | 10330703988, 10496353526, 10530884449 |
reference_number | chữ | 28 | 25 | 1558664156, 1609038648, 1647763853 |
transaction_type | chữ | 28 | 2 | Adjustment, Reservation |
is_adjustment | số | 28 | 2 | 0, 1 |
created_date | ngày | 28 | 23 | 2025-03-06, 2025-05-08, 2025-09-07 |
checkin | ngày | 28 | 22 | 2025-03-18, 2025-05-26, 2025-10-31 |
checkout | ngày | 28 | 23 | 2025-03-20, 2025-05-28, 2025-11-20 |
booking_value | số | 28 | 17 | -4438157.9, -532000.0, 0.0 |
collection_amount | số | 28 | 17 | -4438157.9, -532000.0, 0.0 |
currency | chữ | 28 | 1 | VND |
payment_method | chữ | 28 | 1 | Telex Transfer |
3Xem trước (28 dòng cuối)
| 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 |