Production.TransactionHistory Table

Information

NameTransactionHistory
SchemaProduction
Row Count113443
Data Size6304 KB
Index Size3192 KB
Reserved Size9920 KB
Unused Size424 KB
Created14.10.2005 1:58:37
Modified14.10.2005 1:59:57

Extended Properties

NameTypeProperty NameValue
TransactionHistoryTABLEMS_DescriptionRecord of each purchase order, sales order, or work order transaction year to date.

Columns

PKKeyIdentityNameData TypeAllow NullsCollationReferencesDefaultComputedCompute Expression
   TransactionIDint   
 
 
 
   ProductIDint  Production.Product.ProductID
 
 
 
   ReferenceOrderIDint   
 
 
 
   ReferenceOrderLineIDint   
((0))
 
 
   TransactionDatedatetime   
(getdate())
 
 
   TransactionTypenchar(2) SQL_Latin1_General_CP1_CI_AS 
 
 
 
   Quantityint   
 
 
 
   ActualCostmoney   
 
 
 
   ModifiedDatedatetime   
(getdate())
 
 

Indexes

NameTypePrimaryUniqueColumns
PK_TransactionHistory_TransactionIDClustered  TransactionID
IX_TransactionHistory_ProductIDNonClustered  ProductID
IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineIDNonClustered  ReferenceOrderID, ReferenceOrderLineID

Check Constraints

NameColumnEnabledTrustedExpression
CK_TransactionHistory_TransactionTypeTransactionType  (upper([TransactionType])='P' OR upper([TransactionType])='S' OR upper([TransactionType])='W')

Foreign Key Constraints

NameTypeReferenced Table
FK_TransactionHistory_Product_ProductIDForeign keyProduction.Product

Triggers

NameActivates onInstead OfFor ReplicationEnabledCreatedModified
Production.uTransactionHistoryUPDATE   14.10.2005 1:59:5714.10.2005 1:59:57