Project

General

Profile

Actions

VOC support #2850

closed

[ELLIS] Hotel List Availability Export - 20260106

Added by Tracy Tran 2 months ago. Updated about 2 months ago.

Status:
완료성공(Resolve)
Priority:
보통(Normal)
Assignee:
Target version:
Start date:
01/08/2026
Due date:
01/08/2026
% Done:

100%

Estimated time:
2.00 h
Spent time:
Part:
Build env.:
Prod

Description

Dear Team,

Please kindly support us to export a Hotel List Availability (All countries) with criteria as below:

- Period: 30, 60, 90 days
- Include information: (same as Availability all countries file)
Hotel Code, Legacy Hotel Code, Hotel Name, Country Code, Country Name, Region Code, Region Name, Address, Phone Number, Room Code, Legacy Room Code, Room Name

- Additional Criteria:
Hotel - Register Status: Approved
Trader - Trade Status: Active
Vendor Contract - Contract Status: Active
Room Type - Open Sales: Yes
Rate & Allotment: Has rate & allotment within an active contract

Looking forward to hearing from you soon.

Best regards,


Files

Script.sql (4.05 KB) Script.sql Mon Nguyen, 01/08/2026 09:02 AM
PagingScript.sql (4.16 KB) PagingScript.sql Mon Nguyen, 01/09/2026 09:48 AM
Result-bookable-file.xlsx (518 KB) Result-bookable-file.xlsx Mon Nguyen, 01/09/2026 09:48 AM
Actions #1

Updated by Mon Nguyen 2 months ago

  • Due date set to 01/08/2026
  • Status changed from 신규(New) to 진행(Doing)
  • Start date set to 01/08/2026
Actions #2

Updated by Mon Nguyen 2 months ago

  • Estimated time set to 2.00 h
Actions #3

Updated by Mon Nguyen 2 months ago

Actions #4

Updated by Mon Nguyen about 2 months ago

Done script, waiting get response

Actions #5

Updated by ziniy Kang about 2 months ago

  • % Done changed from 0 to 100
Actions #6

Updated by Mon Nguyen about 2 months ago

Dear Mrs. Tracy Tran
Please help me double check file attachment on the next week
Thank you

Actions #7

Updated by Tracy Tran about 2 months ago

  • Status changed from QA test to 완료성공(Resolve)
  • Assignee changed from Tracy Tran to Mon Nguyen

sent to Content

Actions

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 50 MB)