Difference between revisions of "Purchasing.PurchaseOrderDetail (table)"
| Line 156: | Line 156: | ||
| not null | | not null | ||
| | | | ||
| − | | Primary key. Foreign key to PurchaseOrderHeader.PurchaseOrderID.PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID | + | | Primary key. Foreign key to PurchaseOrderHeader.PurchaseOrderID.<br />PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID |
|- valign="top" | |- valign="top" | ||
| PurchaseOrderDetailID | | PurchaseOrderDetailID | ||
| Line 162: | Line 162: | ||
| not null | | not null | ||
| | | | ||
| − | | Primary key. One line number per purchased product.PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID | + | | Primary key. One line number per purchased product.<br />PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID |
|- valign="top" | |- valign="top" | ||
| DueDate | | DueDate | ||
| Line 168: | Line 168: | ||
| not null | | not null | ||
| | | | ||
| − | | Date the product is expected to be received. | + | | Date the product is expected to be received.<br /> |
|- valign="top" | |- valign="top" | ||
| OrderQty | | OrderQty | ||
| Line 174: | Line 174: | ||
| not null | | not null | ||
| | | | ||
| − | | Quantity ordered. | + | | Quantity ordered.<br /> |
|- valign="top" | |- valign="top" | ||
| ProductID | | ProductID | ||
| Line 180: | Line 180: | ||
| not null | | not null | ||
| | | | ||
| − | | Product identification number. Foreign key to Product.ProductID.IX_PurchaseOrderDetail_ProductID | + | | Product identification number. Foreign key to Product.ProductID.<br />IX_PurchaseOrderDetail_ProductID |
|- valign="top" | |- valign="top" | ||
| UnitPrice | | UnitPrice | ||
| Line 186: | Line 186: | ||
| not null | | not null | ||
| | | | ||
| − | | Vendor's selling price of a single product. | + | | Vendor's selling price of a single product.<br /> |
|- valign="top" | |- valign="top" | ||
| LineTotal | | LineTotal | ||
| Line 192: | Line 192: | ||
| | | | ||
| | | | ||
| − | | Per product subtotal. Computed as OrderQty * UnitPrice. | + | | Per product subtotal. Computed as OrderQty * UnitPrice.<br /> |
|- valign="top" | |- valign="top" | ||
| ReceivedQty | | ReceivedQty | ||
| Line 198: | Line 198: | ||
| not null | | not null | ||
| | | | ||
| − | | Quantity actually received from the vendor. | + | | Quantity actually received from the vendor.<br /> |
|- valign="top" | |- valign="top" | ||
| RejectedQty | | RejectedQty | ||
| Line 204: | Line 204: | ||
| not null | | not null | ||
| | | | ||
| − | | Quantity rejected during inspection. | + | | Quantity rejected during inspection.<br /> |
|- valign="top" | |- valign="top" | ||
| StockedQty | | StockedQty | ||
| Line 210: | Line 210: | ||
| | | | ||
| | | | ||
| − | | Quantity accepted into inventory. Computed as ReceivedQty - RejectedQty. | + | | Quantity accepted into inventory. Computed as ReceivedQty - RejectedQty.<br /> |
|- valign="top" | |- valign="top" | ||
| ModifiedDate | | ModifiedDate | ||
| Line 216: | Line 216: | ||
| not null | | not null | ||
| (GETDATE()) | | (GETDATE()) | ||
| − | | Date and time the record was last updated. | + | | Date and time the record was last updated.<br /> |
|} | |} | ||
Revision as of 01:10, 27 November 2009
wikibot
| Table | Purchasing.PurchaseOrderDetail |
| Column | Data Type | Nullable | Default | PK | Index |
| PurchaseOrderID | int | not null | PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID | ||
| PurchaseOrderDetailID | int | not null | PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID | ||
| DueDate | datetime | not null | |||
| OrderQty | smallint | not null | |||
| ProductID | int | not null | IX_PurchaseOrderDetail_ProductID | ||
| UnitPrice | money | not null | |||
| LineTotal | |||||
| ReceivedQty | decimal(8, 2) | not null | |||
| RejectedQty | decimal(8, 2) | not null | |||
| StockedQty | |||||
| ModifiedDate | datetime | not null | (getdate()) |
| Relation | Column | Referenced Column |
| Production.Product | ProductID | ProductID |
| Purchasing.PurchaseOrderHeader | PurchaseOrderID | PurchaseOrderID |
| Triggers | Type |
| iPurchaseOrderDetail | ON INSERT |
| uPurchaseOrderDetail | ON UPDATE |
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 |
| Referenced Object | Object Type | Dependency Type |
| Production.TransactionHistory | Table | Insert |
| Production.TransactionHistory | Table | Insert |
| Purchasing.PurchaseOrderDetail | Table | Select |
| Purchasing.PurchaseOrderDetail | Table | Select |
| Purchasing.PurchaseOrderDetail | Table | Update |
| Purchasing.PurchaseOrderHeader | Table | Select |
| Purchasing.PurchaseOrderHeader | Table | Update |
| Purchasing.PurchaseOrderHeader | Table | Update |
| dbo.uspLogError | Procedure | Execute |
| dbo.uspLogError | Procedure | Execute |
| dbo.uspPrintError | Procedure | Execute |
| dbo.uspPrintError | Procedure | Execute |
| Referencing Object | Object Type | Reference Type |
| Purchasing.PurchaseOrderDetail | Table | Select |
| Purchasing.PurchaseOrderDetail | Table | Select |
| Purchasing.PurchaseOrderDetail | Table | Update |
