Difference between revisions of "Purchasing.PurchaseOrderHeader (table)"

Revision as of 07:24, 30 November 2009

Table

Purchasing.PurchaseOrderHeader

Column	Data Type	Nullable	Default	PK	Index
PurchaseOrderID	int	not null		PK_PurchaseOrderHeader_PurchaseOrderID
RevisionNumber	tinyint	not null	((0))
Status	tinyint	not null	((1))
EmployeeID	int	not null			IX_PurchaseOrderHeader_EmployeeID
VendorID	int	not null			IX_PurchaseOrderHeader_VendorID
ShipMethodID	int	not null
OrderDate	datetime	not null	(getdate())
ShipDate	datetime	null
SubTotal	money	not null	((0.00))
TaxAmt	money	not null	((0.00))
Freight	money	not null	((0.00))
TotalDue
ModifiedDate	datetime	not null	(getdate())

Detail Table	Column	Referencing Column
Purchasing.PurchaseOrderDetail	PurchaseOrderID	PurchaseOrderID

Triggers	Type
uPurchaseOrderHeader	ON UPDATE

Table	Purchasing.PurchaseOrderHeader
Description	General purchase order information. See PurchaseOrderDetail.

Column	Data Type	Nullable	Default	Description / PK / Index
PurchaseOrderID	int	not null		Primary key. PK_PurchaseOrderHeader_PurchaseOrderID
RevisionNumber	tinyint	not null	(0)	Incremental number to track changes to the purchase order over time.
Status	tinyint	not null	(1)	Order current status. 1 = Pending; 2 = Approved; 3 = Rejected; 4 = Complete
EmployeeID	int	not null		Employee who created the purchase order. Foreign key to Employee.EmployeeID. IX_PurchaseOrderHeader_EmployeeID
VendorID	int	not null		Vendor with whom the purchase order is placed. Foreign key to Vendor.VendorID. IX_PurchaseOrderHeader_VendorID
ShipMethodID	int	not null		Shipping method. Foreign key to ShipMethod.ShipMethodID.
OrderDate	datetime	not null	(GETDATE())	Purchase order creation date.
ShipDate	datetime	null		Estimated shipment date from the vendor.
SubTotal	money	not null	(0.00)	Purchase order subtotal. Computed as SUM(PurchaseOrderDetail.LineTotal)for the appropriate PurchaseOrderID.
TaxAmt	money	not null	(0.00)	Tax amount.
Freight	money	not null	(0.00)	Shipping cost.
TotalDue				Total due to vendor. Computed as Subtotal + TaxAmt + Freight.
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

Detail Table	Column	Referencing Column
Purchasing.PurchaseOrderDetail	PurchaseOrderID	PurchaseOrderID

Triggers	Type
uPurchaseOrderHeader	ON UPDATE

Referenced Object	Object Type	Dependency Type
.Purchasing	Schema	Schema
Purchasing.PurchaseOrderHeader	Table	Update	Trigger	uPurchaseOrderHeader
dbo.uspLogError	Procedure	Execute	Trigger	uPurchaseOrderHeader
dbo.uspPrintError	Procedure	Execute	Trigger	uPurchaseOrderHeader

Referencing Object	Object Type	Reference Type
Purchasing.PurchaseOrderDetail	Table	Select	Trigger	iPurchaseOrderDetail
Purchasing.PurchaseOrderDetail	Table	Update	Trigger	iPurchaseOrderDetail
Purchasing.PurchaseOrderDetail	Table	Update	Trigger	uPurchaseOrderDetail
Purchasing.PurchaseOrderHeader	Table	Update	Trigger	uPurchaseOrderHeader

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