SQL Tables: Customer Information Reservations Invoices Guest Rooms Guest Room Gallery Promotions User Management

SQL Objects: SP - Mapped Data SP - Invoices View - Mapped Data View - Payment Summary Trigger - Audit Function - Invoice

Viewing All Available Invoices

Please click on the Invoice ID to view report or to view invoice details.
The image shown is the SQL Procedure that will be called when accessing invoice details.

Invoice
ID		 First Name Last Name Street City State ZipCode Room Rate Total
Nights		 Total
Guests		 Total
Cost		 Invoice
Status		 Date
From		 Date
To