Purchasing.PurchaseOrderDetail (table) - Revision history

Bot at 08:55, 27 August 2011

2011-08-27T08:55:59Z

Bot at 22:17, 23 June 2010

2010-06-23T22:17:12Z

Show changes

Bot at 22:05, 2 February 2010

2010-02-02T22:05:47Z

Show changes

Bot at 21:55, 28 December 2009

2009-12-28T21:55:09Z

Show changes

Bot at 05:59, 30 November 2009

2009-11-30T05:59:53Z

Bot at 05:35, 30 November 2009

2009-11-30T05:35:15Z

Bot at 05:24, 30 November 2009

2009-11-30T05:24:30Z

Bot at 23:13, 26 November 2009

2009-11-26T23:13:20Z

Bot at 23:10, 26 November 2009

2009-11-26T23:10:44Z

Bot at 22:57, 26 November 2009

2009-11-26T22:57:57Z

@@ Line 331: / Line 331: @@
 | Trigger
-| uPurchaseOrderDetail
+| iPurchaseOrderDetail
 |- valign="top"
 | Select
@@ Line 338: / Line 338: @@
 | Trigger
-| iPurchaseOrderDetail
+| uPurchaseOrderDetail
 |- valign="top"
 | Update
@@ Line 387: / Line 387: @@
 | Trigger
-| uPurchaseOrderDetail
+| iPurchaseOrderDetail
 |- valign="top"
 | Execute
@@ Line 394: / Line 394: @@
 | Trigger
-| iPurchaseOrderDetail
+| uPurchaseOrderDetail
 |}

@@ Line 135: / Line 135: @@
 | Purchasing.PurchaseOrderDetail
 |- valign="top"
 | '''Description
 | Individual products associated with a specific purchase order. See PurchaseOrderHeader.
 |-
 |}

@@ Line 254: / Line 254: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referenced Object
-| '''Object Type
-| '''Dependency Type
+| '''Child Type
 |-
 | Schema
 | Schema
 |-
 | [[Production.TransactionHistory_(table)|Production.TransactionHistory]]
-| Table
 | Trigger
 | iPurchaseOrderDetail
 |-
 | [[Production.TransactionHistory_(table)|Production.TransactionHistory]]
-| Table
 | Trigger
 | uPurchaseOrderDetail
 |-
 | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
-| Table
 | Trigger
 | uPurchaseOrderDetail
 |-
 | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
-| Table
 | Trigger
 | iPurchaseOrderDetail
 |-
 | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
-| Table
 | Trigger
 | uPurchaseOrderDetail
 |-
 | [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]]
-| Table
 | Trigger
 | iPurchaseOrderDetail
 |-
 | [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]]
-| Table
 | Trigger
 | iPurchaseOrderDetail
 |-
 | [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]]
-| Table
 | Trigger
 | uPurchaseOrderDetail
 |-
 | [[dbo.uspLogError_(procedure)|dbo.uspLogError]]
-| Procedure
 | Trigger
 | iPurchaseOrderDetail
 |-
 | [[dbo.uspLogError_(procedure)|dbo.uspLogError]]
-| Procedure
 | Trigger
 | uPurchaseOrderDetail
 |-
 | [[dbo.uspPrintError_(procedure)|dbo.uspPrintError]]
-| Procedure
 | Trigger
 | uPurchaseOrderDetail
 |-
 | [[dbo.uspPrintError_(procedure)|dbo.uspPrintError]]
-| Procedure
 | Trigger
 | iPurchaseOrderDetail
@@ Line 339: / Line 357: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referencing Object
-| '''Object Type
-| '''Reference Type
+| '''Child Type
 |-
 | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
-| Table
 | Trigger
 | iPurchaseOrderDetail
 |-
 | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
-| Table
 | Trigger
 | uPurchaseOrderDetail
 |-
 | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
-| Table
 | Trigger
 | uPurchaseOrderDetail
 |}

@@ Line 257: / Line 257: @@
 | '''Object Type
 | '''Dependency Type
-−
 |-
 | [[Production.TransactionHistory_(table)|Production.TransactionHistory]]
 | Table
 | Insert
 |-
 | [[Production.TransactionHistory_(table)|Production.TransactionHistory]]
 | Table
 | Insert
 |-
 | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
 | Table
 | Select
 |-
 | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
 | Table
 | Select
 |-
 | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
 | Table
 | Update
 |-
 | [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]]
 | Table
 | Select
 |-
 | [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]]
 | Table
 | Update
 |-
 | [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]]
 | Table
 | Update
 |-
 | [[dbo.uspLogError_(procedure)|dbo.uspLogError]]
 | Procedure
 | Execute
 |-
 | [[dbo.uspLogError_(procedure)|dbo.uspLogError]]
 | Procedure
 | Execute
 |-
 | [[dbo.uspPrintError_(procedure)|dbo.uspPrintError]]
 | Procedure
 | Execute
 |-
 | [[dbo.uspPrintError_(procedure)|dbo.uspPrintError]]
 | Procedure
 | Execute
 |}
@@ Line 314: / Line 342: @@
 | '''Object Type
 | '''Reference Type
-−
 |-
 | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
 | Table
 | Select
 |-
 | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
 | Table
 | Select
 |-
 | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
 | Table
 | Update
 |}

@@ Line 134: / Line 134: @@
 | '''Table
 | Purchasing.PurchaseOrderDetail
-|-
+|- valign="top"
 | '''Description

@@ Line 156: / Line 156: @@
 | 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"
 | PurchaseOrderDetailID
@@ Line 162: / Line 162: @@
 | 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"
 | DueDate
@@ Line 168: / Line 168: @@
 | not null
+|
-| Date the product is expected to be received.
+| Date the product is expected to be received.<br />
 |- valign="top"
 | OrderQty
@@ Line 174: / Line 174: @@
 | not null
+|
-| Quantity ordered.
+| Quantity ordered.<br />
 |- valign="top"
 | ProductID
@@ Line 180: / Line 180: @@
 | 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"
 | UnitPrice
@@ Line 186: / Line 186: @@
 | not null
+|
-| Vendor's selling price of a single product.
+| Vendor's selling price of a single product.<br />
 |- valign="top"
 | LineTotal
@@ Line 192: / Line 192: @@
+|
+|
-| Per product subtotal. Computed as OrderQty * UnitPrice.
+| Per product subtotal. Computed as OrderQty * UnitPrice.<br />
 |- valign="top"
 | ReceivedQty
@@ Line 198: / Line 198: @@
 | not null
+|
-| Quantity actually received from the vendor.
+| Quantity actually received from the vendor.<br />
 |- valign="top"
 | RejectedQty
@@ Line 204: / Line 204: @@
 | not null
+|
-| Quantity rejected during inspection.
+| Quantity rejected during inspection.<br />
 |- valign="top"
 | StockedQty
@@ Line 210: / Line 210: @@
+|
+|
-| Quantity accepted into inventory. Computed as ReceivedQty - RejectedQty.
+| Quantity accepted into inventory. Computed as ReceivedQty - RejectedQty.<br />
 |- valign="top"
 | ModifiedDate
@@ Line 216: / Line 216: @@
 | not null
 | (GETDATE())
-| Date and time the record was last updated.
+| Date and time the record was last updated.<br />
 |}