Hi, :
Reservations
| Reservation No. | Room | Cost | Terms | Status |
|---|
Pending Invoices
| Invoice No. | Invoice Detail | Cost | Fee | Total | Created On | SELECT room_invoices.InvoiceID, room_invoiceDetail.ReservationID, room_invoices.Amount, room_invoices.Fee, room_invoices.Total, room_invoiceDetail.Description, room_invoices.CreateDate, room_reservations.RoomNo, room_reservations.RoomType FROM `room_invoiceDetail`, `room_invoices`, `room_reservations` WHERE room_invoices.UserID = '' && room_invoices.PaidDate IS NULL && room_reservations.ReservationID = room_invoiceDetail.ReservationID && room_invoiceDetail.InvoiceID = room_invoices.InvoiceID |
|---|
Recent Transactions
| Transaction Number | Card No. (Last 4 digits) | Amount | Fee | Total | Status | Invoice Number | Detail | Transaction Date |
|---|---|---|---|---|---|---|---|---|
| 1351352 | 6191 | 1.00 | 3.00 | 4.00 | Approved | 63 | Payment for Conference Room - 2025-03-04 | 2025-05-08 |
| 540461 | 6191 | 1.00 | 3.00 | 4.00 | Approved | 54 | Payment for Conference Room - 2025-03-04 | 2025-05-08 |
| 450367 | 6191 | 1.00 | 3.00 | 4.00 | Approved | 53 | Payment for Conference Room - 2025-03-04 | 2025-05-08 |
| 360274 | 6191 | 1.00 | 3.00 | 4.00 | Approved | 52 | Payment for Conference Room - 2025-03-04 | 2025-05-08 |
| 270182 | 6191 | 1.00 | 3.00 | 4.00 | Denied | 50 | Payment for Conference Room - 2025-03-04 | 2025-05-08 |
