← All tables and views

Chinook table

Invoice

Billing invoices issued to customers for music purchases.

412rows

9 columns

Schema from the provider contract
ColumnTypeNullableKeyReferences
InvoiceIdINTEGERnoPK—
CustomerIdINTEGERno—Customer.CustomerId
InvoiceDateDATETIMEno——
BillingAddressNVARCHAR(70)yes——
BillingCityNVARCHAR(40)yes——
BillingStateNVARCHAR(40)yes——
BillingCountryNVARCHAR(40)yes——
BillingPostalCodeNVARCHAR(10)yes——
TotalNUMERIC(10,2)no——

Data preview

Sample records

412 rows available
InvoiceIdCustomerIdInvoiceDateBillingAddressBillingCityBillingStateBillingCountry
122021-01-01 00:00:00Theodor-Heuss-Straße 34StuttgartNULLGermany
242021-01-02 00:00:00Ullevålsveien 14OsloNULLNorway
382021-01-03 00:00:00Grétrystraat 63BrusselsNULLBelgium
4142021-01-06 00:00:008210 111 ST NWEdmontonABCanada
5232021-01-11 00:00:0069 Salem StreetBostonMAUSA
6372021-01-19 00:00:00Berger Straße 10FrankfurtNULLGermany
7382021-02-01 00:00:00Barbarossastraße 19BerlinNULLGermany
8402021-02-01 00:00:008, Rue HanovreParisNULLFrance

Interactive explorer

Explore Invoice

Powered by DataTug