Concept · entity · registered
Invoice
A billing invoice for tracks purchased by a customer. Chinook has 412 invoices dated from 2021-01-01 to 2025-12-22. It is an invoice record, not the request to supply represented by an order.
Definition
What Invoice means
Used in data
In OVDB databases
Databases, recordsets and fields whose meaning is this concept, a kind of it, or whose values are instances of it. Rows open the OVDB Directory.
Recordsets are ModelSpec entities and fields are ModelSpec properties: model/chinook.modelspec.hcl at commit 3e7bb31.
ModelSpec
Bindings
Where this concept's data is, named as ModelSpec entities and properties in model/chinook.modelspec.hcl at commit 3e7bb31.
| Role | ModelSpec entity / property | Match | Note |
|---|---|---|---|
| entity | chinook.InvoiceModelSpec entityModelSpec registry | ||
| foreign-key | chinook.InvoiceLine.InvoiceIdModelSpec propertyModelSpec registry | The invoice a line is on. |
In the graph
Related concepts
Attributes, measures and parts of it
The country an invoice is billed to, as Chinook spells it ("USA", "Czech Republic"). Use this one when a question asks which countries buy or spend: it is recorded on the sale…
The date of a purchase. The time part is always midnight.
One track bought on an invoice.
The amount charged on an invoice. It equals the sum of UnitPrice x Quantity over the invoice's lines (true for all 412 invoices).