Editing Purchasing.PurchaseOrderDetail (table)
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone.
Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 457: | Line 457: | ||
| not null | | not null | ||
| | | | ||
− | | Primary key. Foreign key to PurchaseOrderHeader.PurchaseOrderID. | + | | Primary key. Foreign key to PurchaseOrderHeader.PurchaseOrderID.PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID |
|- valign="top" | |- valign="top" | ||
| PurchaseOrderDetailID | | PurchaseOrderDetailID | ||
Line 463: | Line 463: | ||
| not null | | not null | ||
| | | | ||
− | | Primary key. One line number per purchased product. | + | | Primary key. One line number per purchased product.PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID |
|- valign="top" | |- valign="top" | ||
| DueDate | | DueDate | ||
Line 469: | Line 469: | ||
| not null | | not null | ||
| | | | ||
− | | Date the product is expected to be received. | + | | Date the product is expected to be received. |
|- valign="top" | |- valign="top" | ||
| OrderQty | | OrderQty | ||
Line 475: | Line 475: | ||
| not null | | not null | ||
| | | | ||
− | | Quantity ordered. | + | | Quantity ordered. |
|- valign="top" | |- valign="top" | ||
| ProductID | | ProductID | ||
Line 481: | Line 481: | ||
| not null | | not null | ||
| | | | ||
− | | Product identification number. Foreign key to Product.ProductID. | + | | Product identification number. Foreign key to Product.ProductID.IX_PurchaseOrderDetail_ProductID |
|- valign="top" | |- valign="top" | ||
| UnitPrice | | UnitPrice | ||
Line 487: | Line 487: | ||
| not null | | not null | ||
| | | | ||
− | | Vendor's selling price of a single product. | + | | Vendor's selling price of a single product. |
|- valign="top" | |- valign="top" | ||
| LineTotal | | LineTotal | ||
Line 493: | Line 493: | ||
| | | | ||
| | | | ||
− | | Per product subtotal. Computed as OrderQty * UnitPrice. | + | | Per product subtotal. Computed as OrderQty * UnitPrice. |
|- valign="top" | |- valign="top" | ||
| ReceivedQty | | ReceivedQty | ||
Line 499: | Line 499: | ||
| not null | | not null | ||
| | | | ||
− | | Quantity actually received from the vendor. | + | | Quantity actually received from the vendor. |
|- valign="top" | |- valign="top" | ||
| RejectedQty | | RejectedQty | ||
Line 505: | Line 505: | ||
| not null | | not null | ||
| | | | ||
− | | Quantity rejected during inspection. | + | | Quantity rejected during inspection. |
|- valign="top" | |- valign="top" | ||
| StockedQty | | StockedQty | ||
Line 511: | Line 511: | ||
| | | | ||
| | | | ||
− | | Quantity accepted into inventory. Computed as ReceivedQty - RejectedQty. | + | | Quantity accepted into inventory. Computed as ReceivedQty - RejectedQty. |
|- valign="top" | |- valign="top" | ||
| ModifiedDate | | ModifiedDate | ||
Line 517: | Line 517: | ||
| not null | | not null | ||
| (GETDATE()) | | (GETDATE()) | ||
− | | Date and time the record was last updated. | + | | Date and time the record was last updated. |
|} | |} | ||