Computer Info systems
inwoodchck
a04HotelRevenue.accdb| ChargeDetailsID | Purchase | RoomChargeID |
|---|---|---|
| 1 | 13 | |
| 2 | 10 | |
| 3 | 12 | |
| 4 | 11 | |
| 5 | 6 | |
| 6 | 1 | |
| 7 | 3 | |
| 8 | 4 | |
| 9 | 5 | |
| 10 | 8 | |
| 11 | 9 | |
| 12 | 7 | |
| 13 | 2 | |
| 14 | 14 | |
| 15 | 17 | |
| 16 | 15 | |
| 17 | 16 | |
| 18 | 20 | |
| 19 | 22 | |
| 20 | 23 | |
| 21 | 21 | |
| 22 | 18 | |
| 23 | 19 |
| EmployeeID | EmpFirstName | EmpLastName | EmpAddress | EmpCity | EmpState | EmpPhone |
|---|---|---|---|---|---|---|
| 1 | Bradley | Cummings | 567 N 53rd Street | Santa Ana | NM | (505) 555-8217 |
| 2 | Justine | Wise | 321 Bolivar Lane | Albuquerque | NM | (505) 555-4149 |
| 3 | Jasper | Shepherd | 783 W Point Drive | Pueblo | NM | (505) 555-3800 |
| 4 | Carla | Conley | 9982 N Red Oak Road | Santa Fe | NM | (505) 555-2525 |
| 5 | Christopher | Noble | 492 NW Lake Park Avenue | Las Vegas | NM | (505) 555-4836 |
| 6 | Halla | Reid | 901 Mesa Boulevard | Rio Rancho | NM | (505) 555-4103 |
| 7 | Burton | Roberson | 8441 Lomas Avenue | Las Vegas | NM | (505) 555-7943 |
| 8 | Branden | Black | 672 Los Ranchos Drive | Carlsbad | NM | (505) 555-0247 |
| 9 | Isabella | Sparks | 2245 Cedar Grove Lane | Santa Fe | NM | (505) 555-3242 |
| 10 | Camden | Nash | 306 Ranchos de Taos Road | Agua Fria | NM | (505) 555-6201 |
| 11 | Keegan | Hammond | 1837 El Dorado Avenue | Agua Fria | NM | (505) 555-6243 |
| 12 | Gregory | Peterson | 245 E Bend Avenue | Santa Fe | NM | (505) 555-9244 |
| 13 | Katelyn | Noble | 268 NW 42nd Street | Rio Rancho | NM | (505) 555-3227 |
| 14 | Bradley | Blair | 7056 17th Street | Carlsbad | NM | (505) 555-4101 |
| GuestID | GuestLastName | GuestFirstName | GuestMI | Gender | Address | City | State | ZipCode | Phone |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Wenner | Susan | E | Female | 982 Red Rose Avenue | Las Vegas | NV | 89044 | (702) 555-6627 |
| 2 | Ellis | Iona | T | Male | 5059 Eleifend Road | Lebanon | OK | 83587 | (391) 555-7647 |
| 3 | Mcconnell | Kiona | C | Female | 5884 Sed Avenue | Fontana | CA | 65735 | (560) 555-2542 |
| 4 | Foley | Elaine | U | Female | 2958 Euismod Street | Louisville | WA | 95007 | (764) 555-7221 |
| 5 | Mccall | Kyra | N | Female | 7191 Odio Avenue | Portland | MI | 97794 | (745) 555-3525 |
| 6 | Kirk | Aidan | P | Male | 8975 E Street | Jeannette | DC | 78621 | (698) 555-9020 |
| 7 | English | Lois | L | Female | 8937 Tempor Street | Valdosta | PA | 26645 | (531) 555-6230 |
| 8 | Rojas | Colorado | A | Male | 8778 Seed Street | Wahoo | RI | 56929 | (295) 555-9673 |
| 9 | Kidd | Graiden | L | Male | 5547 Mattis Road | Lake Charles | IN | 11891 | (450) 555-5080 |
| 10 | Brock | Sheila | Q | Female | 8712 Mauris Street | Bethany | NY | 01731 | (959) 555-3798 |
| 11 | Adams | Kirk | V | Male | 4262 Accumsan Road | Stockton | WI | 08761 | (889) 555-8964 |
| 12 | Finch | Adrian | C | Male | 8201 Taciti Avenue | Cary | MN | 88785 | (873) 555-3753 |
| 13 | Mcmahon | Farrah | E | Female | 577 Amet Avenue | Stillwater | CT | 69418 | (305) 555-9987 |
| 14 | Cochran | Cassandra | K | Female | 8563 Vivamus Road | Hutchinson | SD | 68371 | (175) 555-1017 |
| 15 | Hays | Aileen | P | Female | 3819 Nonummy Avenue | Mark's Point | NE | 55793 | (352) 555-5197 |
| 16 | Myers | Tate | S | Male | 300 Scelerisque Street | East St. Louis | KY | 17166 | (723) 555-2815 |
| 17 | Cote | Paula | N | Female | 3218 Phasellus Road | Brockton | CA | 21169 | (330) 555-1346 |
| 18 | Wong | Marshall | J | Male | 9574 Sodales Street | The Dalles | LA | 96405 | (717) 555-6195 |
| 19 | Woodward | Adrian | V | Male | 665 Cras Avenue | Concord | CA | 80273 | (670) 555-7930 |
| 20 | Bridges | Hall | L | Male | 2971 Ornare Street | Citrus Heights | OH | 07110 | (113) 555-6694 |
| 21 | Elliott | Martin | H | Male | 3169 Natoque Avenue | Shreveport | IA | 15785 | (857) 555-1967 |
| 22 | Sharp | Emi | G | Male | 1783 Semper Avenue | Fernley | AK | 33569 | (616) 555-0546 |
| 23 | Gould | Malcolm | K | Male | 7817 Elementum Road | Commerce | AK | 62769 | (104) 555-8666 |
| 24 | Bennett | Maryam | R | Male | 9058 Dolor Street | Marquette | MT | 83597 | (214) 555-8618 |
| 25 | Francis | Gallagher | M | Male | 2662 Paige Circle | Pittsburgh | PA | 15237 | (412) 555-1669 |
| RoomChargeID | GuestID | ReservationID | ChargeCategory | ChargeAmount |
|---|---|---|---|---|
| 24 | 17 | 16 | Room Service | ¤ 81.36 |
| 25 | 21 | 7 | Painted Treasures | ¤ 51.30 |
| 26 | 19 | 46 | Indigo5 | ¤ 287.26 |
| 27 | 12 | 44 | Terra Cotta Brew | ¤ 40.29 |
| 28 | 3 | 40 | Turquoise Oasis Spa | ¤ 309.59 |
| PmtID | GuestID | ReservationID | PmtAmount | PmtDate | PmtMethod | AuthNumber |
|---|---|---|---|---|---|---|
| 1 | 24 | 5 | ¤ 1,129.00 | 1/2/22 | 22597 | |
| 2 | 17 | 6 | ¤ 186.50 | 1/1/22 | ||
| 3 | 18 | 7 | ¤ 393.23 | 1/3/22 | 877456 | |
| 4 | 20 | 8 | ¤ 342.62 | 1/1/22 | ||
| 5 | 12 | 10 | ¤ 42.19 | 2/15/22 | ||
| 6 | 22 | 11 | ¤ 388.80 | 2/14/22 | 01123 | |
| 7 | 19 | 12 | ¤ 362.31 | 2/28/22 | 08556 | |
| 8 | 13 | 14 | ¤ 173.62 | 4/2/22 | 22113 | |
| 9 | 1 | 16 | ¤ 833.49 | 4/10/22 | 88945 | |
| 10 | 25 | 17 | ¤ 1,862.71 | 7/6/22 | 612876 |
| ReservationID | GuestID | CheckInDate | NightsStay | NumberOfGuests | Crib | Handicapped | RoomType | RoomRate | DiscountType | EmployeeID |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 14 | 6/22/17 | 3 | 2 | false | false | Double (1 king bed) | ¤ 308.00 | AAA | 1 |
| 2 | 21 | 11/10/17 | 2 | 3 | true | false | Triple (1 king bed, foldout couch) | ¤ 395.00 | None | 13 |
| 3 | 6 | 12/2/17 | 3 | 4 | false | false | Quad (2 king beds) | ¤ 511.00 | Military | 14 |
| 4 | 23 | 12/21/17 | 6 | 2 | false | false | Double (1 king bed) | ¤ 308.00 | None | 7 |
| 5 | 24 | 12/30/17 | 3 | 2 | false | false | Double (1 king bed) | ¤ 308.00 | None | 5 |
| 6 | 17 | 12/31/17 | 1 | 2 | false | false | Double (2 queen beds) | ¤ 288.00 | None | 6 |
| 7 | 18 | 12/29/17 | 5 | 2 | false | false | Double (2 queen beds) | ¤ 288.00 | AAA | 3 |
| 8 | 20 | 12/30/17 | 2 | 2 | false | false | Double (1 king bed) | ¤ 308.00 | None | 2 |
| 9 | 24 | 1/14/18 | 3 | 3 | true | false | Triple (2 queen beds) | ¤ 368.00 | None | 3 |
| 10 | 12 | 2/12/18 | 3 | 2 | false | false | Double (1 king bed) | ¤ 308.00 | None | 9 |
| 11 | 22 | 2/13/18 | 1 | 2 | false | false | Double (1 king bed) | ¤ 308.00 | None | 11 |
| 12 | 19 | 2/25/18 | 3 | 2 | false | false | Double (1 king bed) | ¤ 308.00 | AARP | 11 |
| 13 | 5 | 3/18/18 | 2 | 4 | false | false | Grand Villa Suite | ¤ 1,194.00 | None | 10 |
| 14 | 13 | 4/1/18 | 1 | 2 | false | false | Double (1 king bed) | ¤ 308.00 | None | 13 |
| 15 | 22 | 4/2/18 | 2 | 3 | false | false | Triple (2 queen beds) | ¤ 368.00 | None | 5 |
| 16 | 1 | 4/8/18 | 2 | 2 | false | true | Double (1 king bed) | ¤ 308.00 | AARP | 12 |
| 17 | 25 | 5/13/18 | 3 | 2 | false | false | Grand Villa Suite | ¤ 1,194.00 | None | 3 |
| 18 | 19 | 5/25/18 | 3 | 2 | false | false | Double (1 king bed) | ¤ 308.00 | AAA | 1 |
| 19 | 20 | 6/2/18 | 3 | 2 | false | false | Double (1 king bed) | ¤ 308.00 | AAA | 1 |
| 20 | 7 | 6/7/18 | 2 | 3 | true | false | Triple (1 king bed, foldout couch) | ¤ 395.00 | None | 13 |
| 21 | 4 | 6/25/18 | 3 | 4 | false | false | Quad (2 king beds) | ¤ 511.00 | Military | 14 |
| 22 | 9 | 7/3/18 | 6 | 2 | false | false | Double (1 king bed) | ¤ 308.00 | None | 7 |
| 23 | 6 | 7/3/18 | 3 | 2 | false | false | Double (1 king bed) | ¤ 308.00 | None | 5 |
| 24 | 17 | 7/10/18 | 1 | 2 | false | false | Double (2 queen beds) | ¤ 288.00 | None | 6 |
| 25 | 3 | 7/12/18 | 5 | 2 | false | false | Double (2 queen beds) | ¤ 288.00 | AAA | 3 |
| 26 | 11 | 8/4/18 | 2 | 2 | false | false | Double (1 king bed) | ¤ 308.00 | None | 2 |
| 27 | 15 | 8/15/18 | 3 | 3 | true | false | Triple (2 queen beds) | ¤ 368.00 | None | 3 |
| 28 | 12 | 6/22/18 | 3 | 2 | false | false | Double (1 king bed) | ¤ 308.00 | None | 9 |
| 29 | 23 | 11/10/18 | 1 | 2 | false | false | Double (1 king bed) | ¤ 308.00 | None | 11 |
| 30 | 18 | 12/2/18 | 3 | 2 | false | false | Double (1 king bed) | ¤ 308.00 | AARP | 11 |
| 31 | 1 | 12/21/18 | 2 | 4 | false | false | Grand Villa Suite | ¤ 1,194.00 | None | 10 |
| 32 | 25 | 12/30/18 | 1 | 2 | false | false | Double (1 king bed) | ¤ 308.00 | None | 13 |
| 33 | 14 | 12/31/18 | 2 | 3 | false | false | Triple (2 queen beds) | ¤ 368.00 | None | 5 |
| 34 | 11 | 12/29/18 | 2 | 2 | false | true | Double (1 king bed) | ¤ 308.00 | AARP | 12 |
| 35 | 22 | 12/30/18 | 5 | 5 | false | false | Grand Villa Suite | ¤ 1,194.00 | None | 3 |
| 36 | 14 | 1/14/18 | 3 | 2 | false | false | Double (1 king bed) | ¤ 308.00 | AAA | 1 |
| 37 | 21 | 2/12/18 | 2 | 3 | true | false | Triple (1 king bed, foldout couch) | ¤ 395.00 | None | 1 |
| 38 | 6 | 2/13/18 | 3 | 4 | false | false | Quad (2 king beds) | ¤ 511.00 | Military | 13 |
| 39 | 23 | 2/25/18 | 6 | 2 | false | false | Double (1 king bed) | ¤ 308.00 | None | 14 |
| 40 | 24 | 3/18/18 | 3 | 2 | false | false | Double (1 king bed) | ¤ 308.00 | None | 7 |
| 41 | 17 | 4/1/18 | 1 | 2 | false | false | Double (2 queen beds) | ¤ 288.00 | None | 5 |
| 42 | 18 | 4/2/18 | 5 | 2 | false | false | Double (2 queen beds) | ¤ 288.00 | AAA | 6 |
| 43 | 20 | 4/8/18 | 2 | 2 | false | false | Double (1 king bed) | ¤ 308.00 | None | 3 |
| 44 | 24 | 5/13/18 | 3 | 3 | true | false | Triple (2 queen beds) | ¤ 368.00 | None | 2 |
| 45 | 12 | 5/25/18 | 3 | 2 | false | false | Double (1 king bed) | ¤ 308.00 | None | 3 |
| 46 | 22 | 6/2/18 | 1 | 2 | false | false | Double (1 king bed) | ¤ 308.00 | None | 9 |
| 47 | 19 | 6/7/18 | 3 | 2 | false | false | Double (1 king bed) | ¤ 308.00 | AARP | 11 |
| 48 | 5 | 6/25/18 | 2 | 4 | false | false | Grand Villa Suite | ¤ 1,194.00 | None | 11 |
| 49 | 13 | 7/3/18 | 1 | 2 | false | false | Double (1 king bed) | ¤ 308.00 | None | 10 |
| 50 | 22 | 7/3/18 | 2 | 3 | false | false | Triple (2 queen beds) | ¤ 368.00 | None | 13 |
| 51 | 5 | 7/10/18 | 1 | 2 | false | false | Double (1 king bed) | ¤ 246.00 | None | 5 |
| 52 | 21 | 7/12/18 | 2 | 3 | true | false | Triple (1 king bed, foldout couch) | ¤ 395.00 | None | 13 |
| 53 | 6 | 8/4/18 | 3 | 4 | false | false | Quad (2 king beds) | ¤ 511.00 | Military | 14 |
| 54 | 23 | 8/15/18 | 6 | 2 | false | false | Double (1 king bed) | ¤ 308.00 | None | 7 |
| RoomChargeID | GuestID | ReservationID | ChargeCategory | ChargeAmount |
|---|---|---|---|---|
| 1 | 13 | 14 | Terra Cotta Brew | ¤ 168.88 |
| 2 | 22 | 11 | Red Bluff Golf Club | ¤ 206.26 |
| 3 | 17 | 6 | Indigo5 | ¤ 199.56 |
| 4 | 18 | 7 | Room Service | ¤ 89.49 |
| 5 | 18 | 7 | Turquoise Oasis Spa | ¤ 456.26 |
| 6 | 12 | 10 | Room Service | ¤ 62.45 |
| 7 | 22 | 11 | Painted Treasures | ¤ 157.76 |
| 8 | 19 | 12 | Painted Treasures | ¤ 113.46 |
| 9 | 19 | 12 | Silver Moon Lounge | ¤ 340.37 |
| 10 | 1 | 16 | Red Bluff Golf Club | ¤ 281.26 |
| 11 | 1 | 16 | Turquoise Oasis Spa | ¤ 356.26 |
| 12 | 1 | 16 | Room Service | ¤ 77.01 |
| 13 | 1 | 16 | Painted Treasures | ¤ 218.00 |
| 14 | 22 | 11 | Silver Moon Lounge | ¤ 125.56 |
| 15 | 24 | 5 | Red Bluff Golf Club | ¤ 231.26 |
| 16 | 24 | 5 | Turquoise Oasis Spa | ¤ 1,060.26 |
| 17 | 20 | 8 | Turquoise Oasis Spa | ¤ 377.76 |
| 18 | 25 | 17 | Silver Moon Lounge | ¤ 121.16 |
| 19 | 25 | 17 | Turquoise Oasis Spa | ¤ 259.76 |
| 20 | 25 | 17 | Indigo5 | ¤ 329.04 |
| 21 | 25 | 17 | Room Service | ¤ 102.46 |
| 22 | 25 | 17 | Painted Treasures | ¤ 354.49 |
| 23 | 25 | 17 | Red Bluff Golf Club | ¤ 703.36 |
