Chinook table

Invoice

Orders raised for a customer.

412rows

9 columns

Column	Type	Nullable	Key	References
`InvoiceId`	`INTEGER`	no	PK	—
`CustomerId`	`INTEGER`	no	—	`Customer.CustomerId`
`InvoiceDate`	`DATETIME`	no	—	—
`BillingAddress`	`NVARCHAR(70)`	yes	—	—
`BillingCity`	`NVARCHAR(40)`	yes	—	—
`BillingState`	`NVARCHAR(40)`	yes	—	—
`BillingCountry`	`NVARCHAR(40)`	yes	—	—
`BillingPostalCode`	`NVARCHAR(10)`	yes	—	—
`Total`	`NUMERIC(10,2)`	no	—	—

First 8 rows

Data preview

of 412

`InvoiceId`	`CustomerId`	`InvoiceDate`	`BillingAddress`	`BillingCity`	`BillingState`	`BillingCountry`	`BillingPostalCode`	`Total`
1	2	2021-01-01 00:00:00	Theodor-Heuss-Straße 34	Stuttgart	null	Germany	70174	1.98
2	4	2021-01-02 00:00:00	Ullevålsveien 14	Oslo	null	Norway	0171	3.96
3	8	2021-01-03 00:00:00	Grétrystraat 63	Brussels	null	Belgium	1000	5.94
4	14	2021-01-06 00:00:00	8210 111 ST NW	Edmonton	AB	Canada	T6G 2C7	8.91
5	23	2021-01-11 00:00:00	69 Salem Street	Boston	MA	USA	2113	13.86
6	37	2021-01-19 00:00:00	Berger Straße 10	Frankfurt	null	Germany	60316	0.99
7	38	2021-02-01 00:00:00	Barbarossastraße 19	Berlin	null	Germany	10779	1.98
8	40	2021-02-01 00:00:00	8, Rue Hanovre	Paris	null	France	75002	1.98