From dbscript Online Help
wikibot
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())
|
|
|
Triggers
|
Type
|
uPurchaseOrderHeader
|
ON UPDATE
|