← All tables and views
AdventureWorks OLTP table
Purchasing.PurchaseOrderDetail
Individual products associated with a specific purchase order. See PurchaseOrderHeader.
8,845rows
11 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
PurchaseOrderID | INTEGER | no | PK 1/2 | Purchasing.PurchaseOrderHeader.PurchaseOrderID |
PurchaseOrderDetailID | INTEGER | no | PK 2/2 | — |
DueDate | TEXT | no | — | — |
OrderQty | INTEGER | no | — | — |
ProductID | INTEGER | no | — | Production.Product.ProductID |
UnitPrice | NUMERIC | no | — | — |
LineTotal | NUMERIC | yes | — | — |
ReceivedQty | NUMERIC | no | — | — |
RejectedQty | NUMERIC | no | — | — |
StockedQty | NUMERIC | yes | — | — |
ModifiedDate | TEXT | no | — | — |
Keys and unique indexes
Physical SQLite metadataPrimary key is declared above.
No additional full-column unique key was found.
1 unique index inspected
sqlite_autoindex_Purchasing.PurchaseOrderDetail_1PurchaseOrderID + PurchaseOrderDetailIDData preview
Sample records
| PurchaseOrderID | PurchaseOrderDetailID | DueDate | OrderQty | ProductID | UnitPrice | LineTotal |
|---|---|---|---|---|---|---|
| 1 | 1 | 2022-04-29 00:00:00.000 | 4 | 1 | 50.26 | 201.04 |
| 2 | 2 | 2022-04-29 00:00:00.000 | 3 | 359 | 45.12 | 135.36 |
| 2 | 3 | 2022-04-29 00:00:00.000 | 3 | 360 | 45.5805 | 136.7415 |
| 3 | 4 | 2022-04-29 00:00:00.000 | 550 | 530 | 16.086 | 8847.3 |
| 4 | 5 | 2022-04-29 00:00:00.000 | 3 | 4 | 57.0255 | 171.0765 |
| 5 | 6 | 2022-05-13 00:00:00.000 | 550 | 512 | 37.086 | 20397.3 |
| 6 | 7 | 2022-05-13 00:00:00.000 | 550 | 513 | 26.5965 | 14628.075 |
| 7 | 8 | 2022-05-13 00:00:00.000 | 550 | 317 | 27.0585 | 14882.175 |
Interactive explorer