Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Purchasing PurchaseOrderHeader (table)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/01/09 18:03


wikibot

TablePurchasing.PurchaseOrderHeader
DescriptionGeneral purchase order information. See PurchaseOrderDetail.

ColumnData TypeNullableDefaultDescription / PK / Index
PurchaseOrderIDintnot null Primary key.
PK_PurchaseOrderHeader_PurchaseOrderID
RevisionNumbertinyintnot null((0))Incremental number to track changes to the purchase order over time.
Statustinyintnot null((1))Order current status. 1 = Pending; 2 = Approved; 3 = Rejected; 4 = Complete
EmployeeIDintnot null Employee who created the purchase order. Foreign key to Employee.EmployeeID.
IX_PurchaseOrderHeader_EmployeeID
VendorIDintnot null Vendor with whom the purchase order is placed. Foreign key to Vendor.VendorID.
IX_PurchaseOrderHeader_VendorID
ShipMethodIDintnot null Shipping method. Foreign key to ShipMethod.ShipMethodID.
OrderDatedatetimenot null(getdate())Purchase order creation date.
ShipDatedatetimenull Estimated shipment date from the vendor.
SubTotalmoneynot null((0.00))Purchase order subtotal. Computed as SUM(PurchaseOrderDetail.LineTotal)for the appropriate PurchaseOrderID.
TaxAmtmoneynot null((0.00))Tax amount.
Freightmoneynot null((0.00))Shipping cost.
TotalDue   Total due to vendor. Computed as Subtotal + TaxAmt + Freight.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.



RelationColumnReferenced Column
HumanResources.EmployeeEmployeeIDEmployeeID
Purchasing.ShipMethodShipMethodIDShipMethodID
Purchasing.VendorVendorIDVendorID

Detail TableColumnReferencing Column
Purchasing.PurchaseOrderDetailPurchaseOrderIDPurchaseOrderID

TriggersType
uPurchaseOrderHeaderON UPDATE

Dependency TypeObject TypeReferenced ObjectChild TypeChild Object
UpdateTablePurchasing.PurchaseOrderHeaderTriggeruPurchaseOrderHeader
ExecuteProceduredbo.uspLogErrorTriggeruPurchaseOrderHeader
ExecuteProceduredbo.uspPrintErrorTriggeruPurchaseOrderHeader

Reference TypeObject TypeReferencing ObjectChild TypeChild Object
SelectTablePurchasing.PurchaseOrderDetailTriggeriPurchaseOrderDetail
UpdateTablePurchasing.PurchaseOrderDetailTriggeriPurchaseOrderDetail
UpdateTablePurchasing.PurchaseOrderDetailTriggeruPurchaseOrderDetail
UpdateTablePurchasing.PurchaseOrderHeaderTriggeruPurchaseOrderHeader

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.