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 last 2 images shown below, detail the SQL Function that will be called when accessing the invoice details.

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

The following is a comparison of the before and after the SQL Function was implemented for these 4 data points.
(Please note that the "MappedDataof7Tables" is a SQL View.)