Difference between revisions of "Production.TransactionHistoryArchive (table)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Production.TransactionHistoryArchive |- |} {| border="1" cellpadding="5" cel...)
(No difference)

Revision as of 13:35, 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(0) not null
Quantity int not null
ActualCost money not null
ModifiedDate datetime not null (getdate())