From dbscript Online Help
wikibot
| Table
|
Production.TransactionHistoryArchive
|
| Column
|
Data Type
|
Nullable
|
Default
|
PK
|
Index
|
| TransactionID
|
int
|
not null
|
|
PK_TransactionHistoryArchive_TransactionID
|
|
| ProductID
|
int
|
not null
|
|
|
IX_TransactionHistoryArchive_ProductID
|
| ReferenceOrderID
|
int
|
not null
|
|
|
IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID
|
| ReferenceOrderLineID
|
int
|
not null
|
((0))
|
|
IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID
|
| TransactionDate
|
datetime
|
not null
|
(getdate())
|
|
|
| TransactionType
|
nchar(1)
|
not null
|
|
|
|
| Quantity
|
int
|
not null
|
|
|
|
| ActualCost
|
money
|
not null
|
|
|
|
| ModifiedDate
|
datetime
|
not null
|
(getdate())
|
|
|
