End of Day and Reservation Statistics

Reservation statistics tables are created during the end of day process for the current business date.

Transactions within the Financial Transactions table are recorded and stored with the market code, source code and room class of the originating reservation. If a transaction is routed or transferred to another reservation (irrespective of the transactions posting date) with a different room class, market segment or source code, the entries in the financial transaction table are not be updated with the above data for the target reservation. Financial journals and reports print from the financial transaction table and are therefore referenced to the financial information and filtration based on the originating reservation.

Reservation statistic tables that are created during the end of day process (for the current business date and a have revenue association) summarize and calculate revenues by the room class, market segment and source code of the reservation they are linked/associated to for the specific transaction at the time the business date is rolled. It is not intended be a direct reflection of the components such as market/source etc. of the actual posting for reasons such as transfer, routing, room moves, and so on.

An exception to the revenue statistic calculation in the end of day process as described above are those transactions which are routed or transferred to a PM (pseudo) account. Those revenues for statistical reporting are recorded under the room class, market segment and source code of the reservation from which they were last routed/transfer on the business date of the posting.