Purchasing.PurchaseOrderHeader (table) - Revision history

Bot at 08:56, 27 August 2011

2011-08-27T08:56:01Z

Bot at 22:17, 23 June 2010

2010-06-23T22:17:14Z

Bot at 22:05, 2 February 2010

2010-02-02T22:05:42Z

Show changes

Bot at 21:55, 28 December 2009

2009-12-28T21:55:11Z

Show changes

Bot at 05:59, 30 November 2009

2009-11-30T05:59:54Z

Bot at 05:35, 30 November 2009

2009-11-30T05:35:17Z

Bot at 05:24, 30 November 2009

2009-11-30T05:24:32Z

Bot at 23:13, 26 November 2009

2009-11-26T23:13:22Z

Bot at 23:10, 26 November 2009

2009-11-26T23:10:45Z

Bot at 22:57, 26 November 2009

2009-11-26T22:57:59Z

@@ Line 116: / Line 116: @@
 | '''Columns
 |- valign="top"
 | IX_PurchaseOrderHeader_VendorID
+|
 | VendorID
 |}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Purchasing.PurchaseOrderHeader
@@ Line 8: / Line 8: @@
 | '''Description
 | General purchase order information. See PurchaseOrderDetail.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | PurchaseOrderID
@@ Line 106: / Line 104: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_PurchaseOrderHeader_PurchaseOrderID
 | PurchaseOrderID
@@ Line 117: / Line 115: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | IX_PurchaseOrderHeader_VendorID
+|
 | VendorID
-|-
+|- valign="top"
 | IX_PurchaseOrderHeader_EmployeeID
+|
@@ Line 134: / Line 132: @@
 | '''Expression
 | '''Description
-−
-|-
+|- valign="top"
 | CK_PurchaseOrderHeader_Freight
 | ([Freight]>=(0.00))
 | Check constraint [Freight] >= (0.00)
-|-
+|- valign="top"
 | CK_PurchaseOrderHeader_ShipDate
 | ([ShipDate]>=[OrderDate] OR [ShipDate] IS NULL)
 | Check constraint [ShipDate] >= [OrderDate] OR [ShipDate] IS NULL
-|-
+|- valign="top"
 | CK_PurchaseOrderHeader_Status
 | ([Status]>=(1) AND [Status]<=(4))
 | Check constraint [Status] BETWEEN (1) AND (4)
-|-
+|- valign="top"
 | CK_PurchaseOrderHeader_SubTotal
 | ([SubTotal]>=(0.00))
 | Check constraint [SubTotal] >= (0.00)
-|-
+|- valign="top"
 | CK_PurchaseOrderHeader_TaxAmt
 | ([TaxAmt]>=(0.00))
@@ Line 163: / Line 161: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[HumanResources.Employee_(table)|HumanResources.Employee]]
 | EmployeeID
 | EmployeeID
-|-
+|- valign="top"
 | [[Purchasing.ShipMethod_(table)|Purchasing.ShipMethod]]
 | ShipMethodID
 | ShipMethodID
-|-
+|- valign="top"
 | [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
 | VendorID
@@ Line 184: / Line 182: @@
 | '''Column
 | '''Referencing Column
-−
-|-
+|- valign="top"
 | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
 | PurchaseOrderID
@@ Line 194: / Line 192: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
-| '''Triggers
+| '''Trigger
 | '''Type
-−
-|-
+|- valign="top"
 | uPurchaseOrderHeader
 | ON UPDATE
 |}
-	Trigger uPurchaseOrderHeader
+==== Trigger uPurchaseOrderHeader ====
 <pre>
 CREATE TRIGGER [Purchasing].[uPurchaseOrderHeader] ON [Purchasing].[PurchaseOrderHeader]
@@ Line 240: / Line 238: @@
 END;
 </pre>
-−
 === References ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
@@ Line 251: / Line 249: @@
 | '''Child Object
-|-
+|- valign="top"
 | Schema
 | Schema
@@ Line 258: / Line 256: @@
+|
+|
-|-
+|- valign="top"
 | Update
 | Table
@@ Line 265: / Line 263: @@
 | Trigger
 | uPurchaseOrderHeader
-|-
+|- valign="top"
 | Execute
 | Procedure
@@ Line 272: / Line 270: @@
 | Trigger
 | uPurchaseOrderHeader
-|-
+|- valign="top"
 | Execute
 | Procedure
@@ Line 291: / Line 289: @@
 | '''Child Object
-|-
+|- valign="top"
 | Select
 | Table
@@ Line 298: / Line 296: @@
 | Trigger
 | iPurchaseOrderDetail
-|-
+|- valign="top"
 | Update
 | Table
@@ Line 305: / Line 303: @@
 | Trigger
 | iPurchaseOrderDetail
-|-
+|- valign="top"
 | Update
 | Table
@@ Line 312: / Line 310: @@
 | Trigger
 | uPurchaseOrderDetail
-|-
+|- valign="top"
 | Update
 | Table

@@ Line 163: / Line 163: @@
 | Purchasing.PurchaseOrderHeader
 |- valign="top"
 | '''Description
 | General purchase order information. See PurchaseOrderDetail.
 |-
 |}

@@ Line 308: / Line 308: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referenced Object
-| '''Object Type
-| '''Dependency Type
+| '''Child Type
 |-
 | Schema
 | Schema
 |-
 | [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]]
-| Table
 | Trigger
 | uPurchaseOrderHeader
 |-
 | [[dbo.uspLogError_(procedure)|dbo.uspLogError]]
-| Procedure
 | Trigger
 | uPurchaseOrderHeader
 |-
 | [[dbo.uspPrintError_(procedure)|dbo.uspPrintError]]
-| Procedure
 | Trigger
 | uPurchaseOrderHeader
@@ Line 339: / Line 348: @@
 {| 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
 | iPurchaseOrderDetail
 |-
 | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
-| Table
 | Trigger
 | uPurchaseOrderDetail
 |-
 | [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]]
-| Table
 | Trigger
 | uPurchaseOrderHeader
 |}

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

@@ Line 184: / Line 184: @@
 | not null
+|
-| Primary key.PK_PurchaseOrderHeader_PurchaseOrderID
+| Primary key.<br />PK_PurchaseOrderHeader_PurchaseOrderID
 |- valign="top"
 | RevisionNumber
@@ Line 190: / Line 190: @@
 | not null
 | (0)
-| Incremental number to track changes to the purchase order over time.
+| Incremental number to track changes to the purchase order over time.<br />
 |- valign="top"
 | Status
@@ Line 196: / Line 196: @@
 | not null
 | (1)
-| Order current status. 1 = Pending; 2 = Approved; 3 = Rejected; 4 = Complete
+| Order current status. 1 = Pending; 2 = Approved; 3 = Rejected; 4 = Complete<br />
 |- valign="top"
 | EmployeeID
@@ Line 202: / Line 202: @@
 | not null
+|
-| Employee who created the purchase order. Foreign key to Employee.EmployeeID.IX_PurchaseOrderHeader_EmployeeID
+| Employee who created the purchase order. Foreign key to Employee.EmployeeID.<br />IX_PurchaseOrderHeader_EmployeeID
 |- valign="top"
 | VendorID
@@ Line 208: / Line 208: @@
 | not null
+|
-| Vendor with whom the purchase order is placed. Foreign key to Vendor.VendorID.IX_PurchaseOrderHeader_VendorID
+| Vendor with whom the purchase order is placed. Foreign key to Vendor.VendorID.<br />IX_PurchaseOrderHeader_VendorID
 |- valign="top"
 | ShipMethodID
@@ Line 214: / Line 214: @@
 | not null
+|
-| Shipping method. Foreign key to ShipMethod.ShipMethodID.
+| Shipping method. Foreign key to ShipMethod.ShipMethodID.<br />
 |- valign="top"
 | OrderDate
@@ Line 220: / Line 220: @@
 | not null
 | (GETDATE())
-| Purchase order creation date.
+| Purchase order creation date.<br />
 |- valign="top"
 | ShipDate
@@ Line 226: / Line 226: @@
 | null
+|
-| Estimated shipment date from the vendor.
+| Estimated shipment date from the vendor.<br />
 |- valign="top"
 | SubTotal
@@ Line 232: / Line 232: @@
 | not null
 | (0.00)
-| Purchase order subtotal. Computed as SUM(PurchaseOrderDetail.LineTotal)for the appropriate PurchaseOrderID.
+| Purchase order subtotal. Computed as SUM(PurchaseOrderDetail.LineTotal)for the appropriate PurchaseOrderID.<br />
 |- valign="top"
 | TaxAmt
@@ Line 238: / Line 238: @@
 | not null
 | (0.00)
-| Tax amount.
+| Tax amount.<br />
 |- valign="top"
 | Freight
@@ Line 244: / Line 244: @@
 | not null
 | (0.00)
-| Shipping cost.
+| Shipping cost.<br />
 |- valign="top"
 | TotalDue
@@ Line 250: / Line 250: @@
+|
+|
-| Total due to vendor. Computed as Subtotal + TaxAmt + Freight.
+| Total due to vendor. Computed as Subtotal + TaxAmt + Freight.<br />
 |- valign="top"
 | ModifiedDate
@@ Line 256: / Line 256: @@
 | not null
 | (GETDATE())
-| Date and time the record was last updated.
+| Date and time the record was last updated.<br />
 |}