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`	`DECIMAL_TEXT(19,4)`Exact decimal · precision 19, scale 4 · text storage	no	—	—
`LineTotal`	`DECIMAL_TEXT(38,4)`Exact decimal · precision 38, scale 4 · text storage	yes	—	—
`ReceivedQty`	`DECIMAL_TEXT(8,2)`Exact decimal · precision 8, scale 2 · text storage	no	—	—
`RejectedQty`	`DECIMAL_TEXT(8,2)`Exact decimal · precision 8, scale 2 · text storage	no	—	—
`StockedQty`	`DECIMAL_TEXT(38,2)`Exact decimal · precision 38, scale 2 · text storage	yes	—	—
`ModifiedDate`	`TEXT`	no	—	—

Physical SQLite metadata

Primary key is declared above.

No additional full-column unique key was found.

1 unique index inspected

sqlite_autoindex_Purchasing.PurchaseOrderDetail_1PurchaseOrderID + PurchaseOrderDetailID

Data preview

8,845 rows available

PurchaseOrderID	PurchaseOrderDetailID	DueDate	OrderQty	ProductID	UnitPrice	LineTotal
1	1	2022-04-29 00:00:00.000	4	1	50.2600	201.0400
2	2	2022-04-29 00:00:00.000	3	359	45.1200	135.3600
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.0860	8847.3000
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.0860	20397.3000
6	7	2022-05-13 00:00:00.000	550	513	26.5965	14628.0750
7	8	2022-05-13 00:00:00.000	550	317	27.0585	14882.1750

Interactive explorer