| Template | Description | Notes | XML Output |
|---|---|---|---|
|
BACKLOG_DAILY_DETAIL |
Backlog Daily Detail |
Backlog Export contains information about the year-to-date production for a property. Data will contain the current year and the two previous years. Room nights and nett revenue are output by status, but the last status is only reported on. These figures are then split by market segment and stay month. |
|
|
BOOK_STATUS_SNAPSHOT |
Booking Status Snapshot Export |
||
|
CHECKOUT_GST_DETAILS |
Checked out Guest Information Export |
||
|
CHECKOUT_TRX_DETAILS |
Financial Transactions Export |
||
|
COMPANY_AGENT_OWNERS |
Company and Agent Owners Export |
||
|
COMPLEXPT |
Comp Rooms In house Export |
||
|
COVEXPORT |
Covers Export |
||
|
CRISIS_EXPORT |
Crisis Management Export |
||
|
CRISIS_EXPORT_DAY |
Crisis Management Export By Date |
||
|
DAILYSTAT |
Daily Statistics Export |
||
|
DB_STAY_DAY |
DB Stay Export - Manual |
The DB STAY export provides a breakout of the revenue buckets for all reservations checked out for a specified date. The export first provides a summary record for each reservation and then one row for each day of the stay/Billing screen window combination showing: |
|
|
Totals of each revenue bucket (Room, F&B, Banquet, Other) as configured for your property. |
|||
|
Totals of membership-points-eligible revenue and membership- points-eligible nights for the stay as defined by the rules set up for the default membership type. Default Membership Type OPERA Control) |
|||
|
DB_STAY_NIGHT |
DB Stay Export - End of Day |
||
|
DCO_EXPORT |
Detailed Checkout Export |
||
|
DCO_EXPORT_SCC |
Detailed Checkout Export (IHG) |
||
|
DCO_EXPORT_SCC_DAY |
Detailed Checkout Export (IHG) By Date |
||
|
DRS_EXPORT |
DRS Extract - End of Day |
||
|
DRS_EXPORT_DAY |
DRS Extract By Date - Manual |
||
|
EDW EXPORT |
EDW Export - End of Day |
JD Edwards ? |
YES |
|
EDW_EXPORT_DAY |
EDW Export By Date - Manual |
YES |
|
|
EXP_ALLOTMENT |
Allotments View |
||
|
EXP_CHKOUT_FOLIO |
Checkout Details Export - End of Day |
||
|
EXP_CHKOUT_FOLIO_DAY |
Checkout Details Export By Date - Manual |
||
|
EXP_EFOLIO_DETAILS |
Efolio Detail Export |
||
|
EXP_MC_EFOLIO |
MasterCard Efolio Export |
||
|
EXP_OPERA_ECERT |
Opera E-Certificate Export |
||
|
EXP_ROOMSTATS |
Room type Daily Statistics |
||
|
EXP_TRANSACTIONS |
All Financial Transactions View |
||
|
FOLIOTAX_EXPORT |
Folio-tax Export |
||
|
GEN_REVENUE |
General Revenue Export |
||
|
GEN_REVENUE_DAY |
General Revenue Export By Date |
||
|
GEN_XMLBO_BILLS |
Generic XML Back Office-Bills |
YES |
|
|
GEN_XMLBO_BILLS_DAY |
Generic XML Back Office-Bills By Date |
YES |
|
|
GEN_XMLBO_CITYLD_DAY |
Generic XML Back Office-City Ledger By Date |
YES |
|
|
GEN_XMLBO_CITYLEDGER |
Generic XML Back Office-City Ledger |
YES |
|
|
GEN_XMLBO_CUSTOMER |
Generic XML Back Office-Customer |
YES |
|
|
GEN_XMLBO_CUST_DAY |
Generic XML Back Office-Customer By Date |
YES |
|
|
GEN_XMLBO_REVENUE |
Generic XML Back Office-Revenue |
YES |
|
|
GEN_XMLBO_REVENUE_DY |
Generic XML Back Office-Revenue By Date |
YES |
|
|
GEN_XMLBO_REV_DAY |
Generic XML Back Office-Revenue By Date |
YES |
|
|
GEN_XMLBO_STATISTICS |
Generic XML Back Office-Statistics |
YES |
|
|
GEN_XMLBO_STAT_DAY |
Generic XML Back Office-Statistics By Date |
YES |
|
|
GENERIC_ARRIVALS |
General Arrivals Export |
||
|
GENERIC_DEPARTURES |
General Departures Export |
||
|
GENERIC_INHOUSE_RESV |
General In house Reservation Export |
||
|
GENERIC_PROFILES |
General Profiles Export |
||
|
GL_EXPORT |
Global 2000 Export |
||
|
GL_EXPORT_SCC |
Global 2000 Export (IHG) |
||
|
GROUPEXPORT |
Groups In house Export |
||
|
GS_EXPORT |
Guest Stay Export |
||
|
GS_EXPORT_DAY |
Guest Stay Export By Date |
||
|
GST_HIST_EXPORT |
Guest History Export |
||
|
GST_HIST_EXPORT_DAY |
Guest History Export By Date |
||
|
HSK_STATUS_EXP |
Housekeeping Room Status Export |
||
|
HSK_STATUS_EXP_NA |
Housekeeping Room Status Export - - End of Day |
||
|
HUSEEXPORT |
House Use Rooms Export |
||
|
MARKETEXPORT |
Market Statistics Export |
||
|
NETSUITE_REVENUE |
NetSuite Revenue Export - End of Day |
TB/Revenue export for Oracle Netsuite ERP |
|
|
NETSUITE_REVENUE_DAY |
NetSuite Revenue Export By Date - Manual |
||
|
ORS_RESV_EXP |
ORS Reservations Export 2 |
||
|
ORS_RESV_EXP_RESORTS |
ORS Reservations Export 1 |
||
|
POST_STAY_EXPORT |
Departures Export |
||
|
POTENTIAL_FORECAST |
Potential Forecast Export |
||
|
PRE_ARRIVAL_EXPORT |
Arrivals Export |
||
|
PROFEXPORT |
Profiles Export |
||
|
PROFILE_REQUESTS |
Profile Requests Export |
||
|
RELATIONSHIPS |
Relationships Export |
||
|
RESPONSYS_PROF |
Profile Data for Responsys - End of Day |
Profile export for Oracle Responsys (Marketing Cloud) |
|
|
RESPONSYS_PROF_AUTO |
Profile Data for Responsys - Scheduler |
||
|
RESPONSYS_PROF_DAY |
Profile Data for Responsys - Manual |
RESPONSYS_PROF_DAY export can be generated for date/date range and filtered by profile type(s) and profile privacy option. The Profile export file generated contains profile, revenue (production) data, stay details, and membership details for applicable profile types(s) |
|
|
RESPONSYS_RESV |
Reservation Data for Responsys - End of Day |
Reservation export for Oracle Responsys (Marketing Cloud) |
|
|
RESPONSYS_RESV_DAY export can be generated for an arrival date range and for specific reservation status(es). Additional filter conditions can be defined in export Filter Condition. |
|||
|
End Of Day and Scheduler exports are generated for the next 30 days arrivals (from the current business date). |
|||
|
RESPONSYS_RESV_AUTO |
Reservation Data for Responsys - Scheduler |
||
|
RESPONSYS_RESV_DAY |
Reservation Data for Responsys - Manual |
Note: Pseudo room type reservations are not included in the reservation export. |
|
|
RESPONSYS_TRX |
Transaction data for Responsys - End of Day |
Sales charge (revenue) transaction export for Oracle Responsys |
|
|
Transations codes configured as revenue_yn=Y are included. |
|||
|
RESPONSYS_TRX_AUTO |
Transaction data for Responsys - Scheduler |
||
|
RESPONSYS_TRX_DAY |
Transaction data for Responsys - Manual |
Note: Pseudo room type reservation transactions are not included in this export. |
|
|
RESVEXPORT |
Checked out Reservations Export |
||
|
SALES_OCC_EXPORT |
Sales and Occupancy Feed - End of Day |
YES |
|
|
SALES_OCC_EXPORT_DAY |
Sales and Occupancy Feed By Date - Manual |
YES |
|
|
TB_EXPORT |
Trial Balance Export- End of Day |
||
|
TB_EXPORT_DAY |
Trial Balance Export by Date - Manual |
||
|
TB_STAT_EXPORT |
Trial Balance Statistics Export |
||
|
TREXPORT |
Financial Transactions Export - End of Day |
||
|
TREXPORT_DAY |
Financial Transactions Export by Date - Manual |
||
|
TRX_CODES |
Transaction Codes - End of Day |
||
|
TRX_CODES_DAY |
Transaction Codes by Date - Manual |
||
|
TRXCODEEXPT |
Transaction Codes |
||
|
TSA01 |
TSA01 Export |
Exports specific tohttps://www.tsa-solutions.com/ |
|
|
TSA02 |
TSA02 Export |
||
|
TSA03 |
TSA03 Export |
||
|
TSA04 |
TSA04 Export |
||
|
TSA06 |
TSA06 Export |
||
|
TSA07 |
TSA07 Export |
||
|
VISA_EXTRACT |
Visa Folio Export - End of Day |
YES |
|
|
VISA_EXTRACT_DAY |
Visa Folio Export by Date -Manual |
YES |
Parent topic: Exports