Purchasing.PurchaseOrderDetail (table)
wikibot
Table | Purchasing.PurchaseOrderDetail |
Description | Individual products associated with a specific purchase order. See PurchaseOrderHeader. |
Column | Data Type | Nullable | Default | Description / PK / Index |
PurchaseOrderID | int | not null | Primary key. Foreign key to PurchaseOrderHeader.PurchaseOrderID. PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID | |
PurchaseOrderDetailID | int | not null | Primary key. One line number per purchased product. PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID | |
DueDate | datetime | not null | Date the product is expected to be received. | |
OrderQty | smallint | not null | Quantity ordered. | |
ProductID | int | not null | Product identification number. Foreign key to Product.ProductID. IX_PurchaseOrderDetail_ProductID | |
UnitPrice | money | not null | Vendor's selling price of a single product. | |
LineTotal | Per product subtotal. Computed as OrderQty * UnitPrice. | |||
ReceivedQty | decimal(8, 2) | not null | Quantity actually received from the vendor. | |
RejectedQty | decimal(8, 2) | not null | Quantity rejected during inspection. | |
StockedQty | Quantity accepted into inventory. Computed as ReceivedQty - RejectedQty. | |||
ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated. |
Relation | Column | Referenced Column |
Production.Product | ProductID | ProductID |
Purchasing.PurchaseOrderHeader | PurchaseOrderID | PurchaseOrderID |
Triggers | Type |
iPurchaseOrderDetail | ON INSERT |
uPurchaseOrderDetail | ON UPDATE |
Dependency Type | Object Type | Referenced Object | Child Type | Child Object |
Insert | Table | Production.TransactionHistory | Trigger | iPurchaseOrderDetail |
Insert | Table | Production.TransactionHistory | Trigger | uPurchaseOrderDetail |
Select | Table | Purchasing.PurchaseOrderDetail | Trigger | uPurchaseOrderDetail |
Select | Table | Purchasing.PurchaseOrderDetail | Trigger | iPurchaseOrderDetail |
Update | Table | Purchasing.PurchaseOrderDetail | Trigger | uPurchaseOrderDetail |
Select | Table | Purchasing.PurchaseOrderHeader | Trigger | iPurchaseOrderDetail |
Update | Table | Purchasing.PurchaseOrderHeader | Trigger | iPurchaseOrderDetail |
Update | Table | Purchasing.PurchaseOrderHeader | Trigger | uPurchaseOrderDetail |
Execute | Procedure | dbo.uspLogError | Trigger | iPurchaseOrderDetail |
Execute | Procedure | dbo.uspLogError | Trigger | uPurchaseOrderDetail |
Execute | Procedure | dbo.uspPrintError | Trigger | uPurchaseOrderDetail |
Execute | Procedure | dbo.uspPrintError | Trigger | iPurchaseOrderDetail |
Reference Type | Object Type | Referencing Object | Child Type | Child Object |
Select | Table | Purchasing.PurchaseOrderDetail | Trigger | iPurchaseOrderDetail |
Select | Table | Purchasing.PurchaseOrderDetail | Trigger | uPurchaseOrderDetail |
Update | Table | Purchasing.PurchaseOrderDetail | Trigger | uPurchaseOrderDetail |
automatically generated
Table | Purchasing.PurchaseOrderDetail |
Description | Individual products associated with a specific purchase order. See PurchaseOrderHeader. |
Column | Data Type | Nullable | Default | Description / PK / Index |
PurchaseOrderID | int | not null | Primary key. Foreign key to PurchaseOrderHeader.PurchaseOrderID. PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID | |
PurchaseOrderDetailID | int | not null | Primary key. One line number per purchased product. PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID | |
DueDate | datetime | not null | Date the product is expected to be received. | |
OrderQty | smallint | not null | Quantity ordered. | |
ProductID | int | not null | Product identification number. Foreign key to Product.ProductID. IX_PurchaseOrderDetail_ProductID | |
UnitPrice | money | not null | Vendor's selling price of a single product. | |
LineTotal | Per product subtotal. Computed as OrderQty * UnitPrice. | |||
ReceivedQty | decimal(8, 2) | not null | Quantity actually received from the vendor. | |
RejectedQty | decimal(8, 2) | not null | Quantity rejected during inspection. | |
StockedQty | Quantity accepted into inventory. Computed as ReceivedQty - RejectedQty. | |||
ModifiedDate | datetime | not null | (GETDATE()) | Date and time the record was last updated. |
Relation | Column | Referenced Column |
Production.Product | ProductID | ProductID |
Purchasing.PurchaseOrderHeader | PurchaseOrderID | PurchaseOrderID |
Triggers | Type |
iPurchaseOrderDetail | ON INSERT |
uPurchaseOrderDetail | ON UPDATE |
Dependency Type | Object Type | Referenced Object | Child Type | Child Object |
Schema | Schema | Purchasing | ||
Insert | Table | Production.TransactionHistory | Trigger | iPurchaseOrderDetail |
Insert | Table | Production.TransactionHistory | Trigger | uPurchaseOrderDetail |
Select | Table | Purchasing.PurchaseOrderDetail | Trigger | uPurchaseOrderDetail |
Select | Table | Purchasing.PurchaseOrderDetail | Trigger | iPurchaseOrderDetail |
Update | Table | Purchasing.PurchaseOrderDetail | Trigger | uPurchaseOrderDetail |
Select | Table | Purchasing.PurchaseOrderHeader | Trigger | iPurchaseOrderDetail |
Update | Table | Purchasing.PurchaseOrderHeader | Trigger | iPurchaseOrderDetail |
Update | Table | Purchasing.PurchaseOrderHeader | Trigger | uPurchaseOrderDetail |
Execute | Procedure | dbo.uspLogError | Trigger | iPurchaseOrderDetail |
Execute | Procedure | dbo.uspLogError | Trigger | uPurchaseOrderDetail |
Execute | Procedure | dbo.uspPrintError | Trigger | uPurchaseOrderDetail |
Execute | Procedure | dbo.uspPrintError | Trigger | iPurchaseOrderDetail |
Reference Type | Object Type | Referencing Object | Child Type | Child Object |
Select | Table | Purchasing.PurchaseOrderDetail | Trigger | iPurchaseOrderDetail |
Select | Table | Purchasing.PurchaseOrderDetail | Trigger | uPurchaseOrderDetail |
Update | Table | Purchasing.PurchaseOrderDetail | Trigger | uPurchaseOrderDetail |