Difference between revisions of "Production.TransactionHistory (table)"
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Production.TransactionHistory |- |} {| border="1" cellpadding="5" cellspacin...) |
|||
| Line 55: | Line 55: | ||
|- | |- | ||
| TransactionType | | TransactionType | ||
| − | | nchar( | + | | nchar(1) |
| not null | | not null | ||
| | | | ||
Revision as of 16:31, 3 January 2009
wikibot
| Table | Production.TransactionHistory |
| Column | Data Type | Nullable | Default | PK | Index |
| TransactionID | int | not null | PK_TransactionHistory_TransactionID | ||
| ProductID | int | not null | IX_TransactionHistory_ProductID | ||
| ReferenceOrderID | int | not null | IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID | ||
| ReferenceOrderLineID | int | not null | ((0)) | IX_TransactionHistory_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()) |
| Relation | Column | Referenced Column |
| Production.Product | ProductID | ProductID |
