Difference between revisions of "Production.TransactionHistoryArchive (table)"
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Production.TransactionHistoryArchive |- |} {| border="1" cellpadding="5" cel...) |
|||
| Line 55: | Line 55: | ||
|- | |- | ||
| TransactionType | | TransactionType | ||
| − | | nchar( | + | | nchar(1) |
| not null | | not null | ||
| | | | ||
Revision as of 16:31, 3 January 2009
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()) |
