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

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 50 MB)