Northwind › Views
Invoices view
2155 rows. A view stores a SELECT statement, not rows: each time you open it, SQLite runs the query again.
| ShipName | ShipAddress | ShipCity | ShipRegion | ShipPostalCode | ShipCountry | CustomerID | CustomerName | Address | City | Region | PostalCode | Country | Salesperson | OrderID | OrderDate | RequiredDate | ShippedDate | ShipperName | ProductID | ProductName | UnitPrice | Quantity | Discount | ExtendedPrice | Freight |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Antonio Moreno Taquería | Mataderos 2312 | México D.F. | NULL | 05023 | Mexico | ANTON | Antonio Moreno Taquería | Mataderos 2312 | México D.F. | NULL | 05023 | Mexico | Margaret Peacock | 10535 | 1997-05-13 | 1997-06-10 | 1997-05-21 | Speedy Express | 11 | Queso Cabrales | 21.0 | 50 | 0.1 | 945.0 | 15.64 |
| Antonio Moreno Taquería | Mataderos 2312 | México D.F. | NULL | 05023 | Mexico | ANTON | Antonio Moreno Taquería | Mataderos 2312 | México D.F. | NULL | 05023 | Mexico | Margaret Peacock | 10535 | 1997-05-13 | 1997-06-10 | 1997-05-21 | Speedy Express | 40 | Boston Crab Meat | 18.4 | 10 | 0.1 | 165.6 | 15.64 |
| Antonio Moreno Taquería | Mataderos 2312 | México D.F. | NULL | 05023 | Mexico | ANTON | Antonio Moreno Taquería | Mataderos 2312 | México D.F. | NULL | 05023 | Mexico | Margaret Peacock | 10535 | 1997-05-13 | 1997-06-10 | 1997-05-21 | Speedy Express | 57 | Ravioli Angelo | 19.5 | 5 | 0.1 | 87.75 | 15.64 |
| Antonio Moreno Taquería | Mataderos 2312 | México D.F. | NULL | 05023 | Mexico | ANTON | Antonio Moreno Taquería | Mataderos 2312 | México D.F. | NULL | 05023 | Mexico | Margaret Peacock | 10535 | 1997-05-13 | 1997-06-10 | 1997-05-21 | Speedy Express | 59 | Raclette Courdavault | 55.0 | 15 | 0.1 | 742.5 | 15.64 |
| Antonio Moreno Taquería | Mataderos 2312 | México D.F. | NULL | 05023 | Mexico | ANTON | Antonio Moreno Taquería | Mataderos 2312 | México D.F. | NULL | 05023 | Mexico | Robert King | 10573 | 1997-06-19 | 1997-07-17 | 1997-06-20 | Federal Shipping | 17 | Alice Mutton | 39.0 | 18 | 0.0 | 702.0 | 84.84 |
| Antonio Moreno Taquería | Mataderos 2312 | México D.F. | NULL | 05023 | Mexico | ANTON | Antonio Moreno Taquería | Mataderos 2312 | México D.F. | NULL | 05023 | Mexico | Robert King | 10573 | 1997-06-19 | 1997-07-17 | 1997-06-20 | Federal Shipping | 34 | Sasquatch Ale | 14.0 | 40 | 0.0 | 560.0 | 84.84 |
| Antonio Moreno Taquería | Mataderos 2312 | México D.F. | NULL | 05023 | Mexico | ANTON | Antonio Moreno Taquería | Mataderos 2312 | México D.F. | NULL | 05023 | Mexico | Robert King | 10573 | 1997-06-19 | 1997-07-17 | 1997-06-20 | Federal Shipping | 53 | Perth Pasties | 32.8 | 25 | 0.0 | 820.0 | 84.84 |
| Antonio Moreno Taquería | Mataderos 2312 | México D.F. | NULL | 05023 | Mexico | ANTON | Antonio Moreno Taquería | Mataderos 2312 | México D.F. | NULL | 05023 | Mexico | Nancy Davolio | 10677 | 1997-09-22 | 1997-10-20 | 1997-09-26 | Federal Shipping | 26 | Gumbär Gummibärchen | 31.23 | 30 | 0.15 | 796.37 | 4.03 |
| Antonio Moreno Taquería | Mataderos 2312 | México D.F. | NULL | 05023 | Mexico | ANTON | Antonio Moreno Taquería | Mataderos 2312 | México D.F. | NULL | 05023 | Mexico | Nancy Davolio | 10677 | 1997-09-22 | 1997-10-20 | 1997-09-26 | Federal Shipping | 33 | Geitost | 2.5 | 8 | 0.15 | 17.0 | 4.03 |
| Antonio Moreno Taquería | Mataderos 2312 | México D.F. | NULL | 05023 | Mexico | ANTON | Antonio Moreno Taquería | Mataderos 2312 | México D.F. | NULL | 05023 | Mexico | Janet Leverling | 10682 | 1997-09-25 | 1997-10-23 | 1997-10-01 | United Package | 33 | Geitost | 2.5 | 30 | 0.0 | 75.0 | 36.13 |
| Antonio Moreno Taquería | Mataderos 2312 | México D.F. | NULL | 05023 | Mexico | ANTON | Antonio Moreno Taquería | Mataderos 2312 | México D.F. | NULL | 05023 | Mexico | Janet Leverling | 10682 | 1997-09-25 | 1997-10-23 | 1997-10-01 | United Package | 66 | Louisiana Hot Spiced Okra | 17.0 | 4 | 0.0 | 68.0 | 36.13 |
| Antonio Moreno Taquería | Mataderos 2312 | México D.F. | NULL | 05023 | Mexico | ANTON | Antonio Moreno Taquería | Mataderos 2312 | México D.F. | NULL | 05023 | Mexico | Janet Leverling | 10682 | 1997-09-25 | 1997-10-23 | 1997-10-01 | United Package | 75 | Rhönbräu Klosterbier | 7.75 | 30 | 0.0 | 232.5 | 36.13 |
| Antonio Moreno Taquería | Mataderos 2312 | México D.F. | NULL | 05023 | Mexico | ANTON | Antonio Moreno Taquería | Mataderos 2312 | México D.F. | NULL | 05023 | Mexico | Janet Leverling | 10856 | 1998-01-28 | 1998-02-25 | 1998-02-10 | United Package | 2 | Chang | 19.0 | 20 | 0.0 | 380.0 | 58.43 |
| Antonio Moreno Taquería | Mataderos 2312 | México D.F. | NULL | 05023 | Mexico | ANTON | Antonio Moreno Taquería | Mataderos 2312 | México D.F. | NULL | 05023 | Mexico | Janet Leverling | 10856 | 1998-01-28 | 1998-02-25 | 1998-02-10 | United Package | 42 | Singaporean Hokkien Fried Mee | 14.0 | 20 | 0.0 | 280.0 | 58.43 |
| Around the Horn | Brook Farm Stratford St. Mary | Colchester | Essex | CO7 6JX | UK | AROUT | Around the Horn | 120 Hanover Sq. | London | NULL | WA1 1DP | UK | Michael Suyama | 10355 | 1996-11-15 | 1996-12-13 | 1996-11-20 | Speedy Express | 24 | Guaraná Fantástica | 3.6 | 25 | 0.0 | 90.0 | 41.95 |
| Around the Horn | Brook Farm Stratford St. Mary | Colchester | Essex | CO7 6JX | UK | AROUT | Around the Horn | 120 Hanover Sq. | London | NULL | WA1 1DP | UK | Michael Suyama | 10355 | 1996-11-15 | 1996-12-13 | 1996-11-20 | Speedy Express | 57 | Ravioli Angelo | 15.6 | 25 | 0.0 | 390.0 | 41.95 |
| Around the Horn | Brook Farm Stratford St. Mary | Colchester | Essex | CO7 6JX | UK | AROUT | Around the Horn | 120 Hanover Sq. | London | NULL | WA1 1DP | UK | Laura Callahan | 10383 | 1996-12-16 | 1997-01-13 | 1996-12-18 | Federal Shipping | 13 | Konbu | 4.8 | 20 | 0.0 | 96.0 | 34.24 |
| Around the Horn | Brook Farm Stratford St. Mary | Colchester | Essex | CO7 6JX | UK | AROUT | Around the Horn | 120 Hanover Sq. | London | NULL | WA1 1DP | UK | Laura Callahan | 10383 | 1996-12-16 | 1997-01-13 | 1996-12-18 | Federal Shipping | 50 | Valkoinen suklaa | 13.0 | 15 | 0.0 | 195.0 | 34.24 |
| Around the Horn | Brook Farm Stratford St. Mary | Colchester | Essex | CO7 6JX | UK | AROUT | Around the Horn | 120 Hanover Sq. | London | NULL | WA1 1DP | UK | Laura Callahan | 10383 | 1996-12-16 | 1997-01-13 | 1996-12-18 | Federal Shipping | 56 | Gnocchi di nonna Alice | 30.4 | 20 | 0.0 | 608.0 | 34.24 |
| Around the Horn | Brook Farm Stratford St. Mary | Colchester | Essex | CO7 6JX | UK | AROUT | Around the Horn | 120 Hanover Sq. | London | NULL | WA1 1DP | UK | Nancy Davolio | 10453 | 1997-02-21 | 1997-03-21 | 1997-02-26 | United Package | 48 | Chocolade | 10.2 | 15 | 0.1 | 137.7 | 25.36 |
| Around the Horn | Brook Farm Stratford St. Mary | Colchester | Essex | CO7 6JX | UK | AROUT | Around the Horn | 120 Hanover Sq. | London | NULL | WA1 1DP | UK | Nancy Davolio | 10453 | 1997-02-21 | 1997-03-21 | 1997-02-26 | United Package | 70 | Outback Lager | 12.0 | 25 | 0.1 | 270.0 | 25.36 |
| Around the Horn | Brook Farm Stratford St. Mary | Colchester | Essex | CO7 6JX | UK | AROUT | Around the Horn | 120 Hanover Sq. | London | NULL | WA1 1DP | UK | Nancy Davolio | 10558 | 1997-06-04 | 1997-07-02 | 1997-06-10 | United Package | 47 | Zaanse koeken | 9.5 | 25 | 0.0 | 237.5 | 72.97 |
| Around the Horn | Brook Farm Stratford St. Mary | Colchester | Essex | CO7 6JX | UK | AROUT | Around the Horn | 120 Hanover Sq. | London | NULL | WA1 1DP | UK | Nancy Davolio | 10558 | 1997-06-04 | 1997-07-02 | 1997-06-10 | United Package | 51 | Manjimup Dried Apples | 53.0 | 20 | 0.0 | 1060.0 | 72.97 |
| Around the Horn | Brook Farm Stratford St. Mary | Colchester | Essex | CO7 6JX | UK | AROUT | Around the Horn | 120 Hanover Sq. | London | NULL | WA1 1DP | UK | Nancy Davolio | 10558 | 1997-06-04 | 1997-07-02 | 1997-06-10 | United Package | 52 | Filo Mix | 7.0 | 30 | 0.0 | 210.0 | 72.97 |
| Around the Horn | Brook Farm Stratford St. Mary | Colchester | Essex | CO7 6JX | UK | AROUT | Around the Horn | 120 Hanover Sq. | London | NULL | WA1 1DP | UK | Nancy Davolio | 10558 | 1997-06-04 | 1997-07-02 | 1997-06-10 | United Package | 53 | Perth Pasties | 32.8 | 18 | 0.0 | 590.4 | 72.97 |